SUMMARY: • 7+ years of total IT experience. • 5 years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps). • Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules. • Expertise in Building Executive Dashboards using Dashboard Manager for Siebel Analytics Web / Oracle Presentation Services for Siebel Analytics / OBIEE. • Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence. • Informatica Certified Developer. • Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems. • Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers. • Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load). • Experience in creating entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema. • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository. • Strong aptitude for learning and understanding business process and needs.
EDUCATION: Bachelors in Engineering - Electrical and Electronics Communications,
CERTIFICATION: Informatica Certified Developer.
TECHNICAL SKILLS: BI : OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/11g,BI Publisher, DAC 7.x, Siebel Analytics 7.7 / 7.8 ETL : Informatica Power Mart, Informatica Power Center 9.x/8.x/7.x/6.x Languages : SQL, PL/SQL, HTML, C, C++, C#, XML Databases : Oracle 11g, Microsoft SQL SERVER 2000, 2005 Tools : Clear case, Visual Source Safe OS : Windows 95/98/2000/XP, UNIX, Linux
WORK EXPERIENCE: Biogen Idec, Massachusetts Nov11- Till Date OBIEE 11g Developer/ BI Apps Developer Biogen Idec is a bio-pharmaceutical company manufacturing drugs at a global level. The company had to implement Financials, Supply Chain, Procurement and Spend, HR modules of BI apps to help better organize and quick decision making. The goal of the project was to upgrade the existing functionality with the new OBIEE 11g capabilities and also developing new functionality in addition to the existing one. Responsibilities: • Effectively interacted with the end users for requirement gathering and defined requirement specifications document • Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules. • Worked extensively with Physical Layer, Business Layer and Presentation Layer. • Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data. • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables. • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements. • Built Business model and established relationships & Foreign Keys Physical & Logical between tables. • Created business reports using BI Answers as per requirements. • Generated various Analytics Reports using global and local filters. • Identified the aggregate levels for each source and created dimension sources for each level of aggregates. • Added users and configured security in web logic console of OBIEE 11g. • Managed security privileges for each subject area and dashboards according to user requirements • Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository. • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse. • Created workflows for full load and incremental loads to be used by DAC. • Assembled subject areas and created execution plan and accommodated the new Informatica mappings. • Monitoring Incremental & Full load through DAC. • Trained End Users and Pilot Users about OBIEE Tools. • Responsible for installing, configuring, developing, support and maintenance of the BI APPS. Environment: OBIEE 11g, BI Apps 126.96.36.199, Web Logic Server, Informatica 9.0.1, Oracle 188.8.131.52, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
Unilever Best Foods, New Jersey Feb11- Nov11 Siebel Analytics/Siebel Analytics Applications Unilever is a biggest consumer goods company with world famous brands. The company was planning to go global and wanted all its data to be globally adequate for the entire decision making. Oracle Consumer goods were being implemented which needed some configurations to the custom RPD and Catalog. Responsibilities: • Full project life cycle implementation for Siebel Business Analytics Warehouse. • Involved in business requirements gathering and translated the requirements into technical requirements. • Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment. • Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects. • Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services. • Setup Multi User Development Environment (MUDE) in OBIEE. • Created new requests and opened Answers for adhoc reporting to the End users • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse. • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings. • Created workflows for full load and incremental loads to be used by DAC. • Assembled subject areas and created execution plan and accommodated the new Informatica mappings. • Documented all the configurations and new reports creation and published it to the end users. • Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications. • Created proper documentation to describe program development, logic, coding, testing, changes and corrections. Environment: Siebel Analytics 7.8.4, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
Pfizer Inc, Connecticut Feb10 -- Jan11 OBIEE/BI Apps Developer Consumer Experience Management (CEM HUB) is a project which involves gathering information from various marketing strategies developed by Epsilon team and the Task Force Team. Using this information certain groups are targeted, in turn increasing the hit ratio and reducing the expenditure spent on campaigns. Responsibilities: • Full project life cycle implementation for Oracle Business Analytics Warehouse (OBAW) • Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan. • Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area. • Expertise with Siebel Base tables and EIM workflows. • Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model. • Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool. • Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables • Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement. • Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data. • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards. • Developed BI Consumer reports using OBIEE 11g. • Expertise in segmentations and scheduled programs on daily basis. • Expertise in SQL check and List pulls. • Proficient in using Xcelsius tools. • Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements. • Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables. • Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table. • Proficient in working with HP Service center and Quality center. • Worked in production support and seen through the phase of the developments in the production and done various bug fixes. • Worked with Siebel EIM tables and tweaked the batch file (.ifb) to process more no. of rows at a time. Environment: OBIEE 10.1.3.3./11g, BI Apps 7.9.6, Xcelsius, Informatica 8.0, Oracle 10g, SQL, PL/SQL, DAC, TOAD, SQL* Plus, Windows XP.
QSSI, Washington DC May 2009 --Feb 2010 OBIEE Developer The project involved creating business intelligence solutions for the various work streams, by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level. Responsibilities: • Work with end users to understand business process of Credit Union and gather requirements for the necessary reports. • Analysis of business requirement to define KPIs (Key Performance Indicator). • Designed the RPD and defined the Subject Areas. • Customized Oracle BI Repository defining Physical Data Layer and developed Business Model and Presentation Layer using Administration Tool. • Prepare technical design documentation of all the necessary aggregates, KPIs which needs to be configured in fact dimension. • Implemented data level and object level securities. • Designed the implementation of ETL and OBIEE for various Modules like incentives, loans and cross sales. • Worked with different groups in organization to understand their business requirement and give valuable suggestions for reports and dashboards. • Create groups for different users to provide suitable securities for different dashboards and reports. • Designed the layout for different dashboards and reports. • Managed day-to-day .rpd, Scheduler & iBots. • Implemented BI Publisher and created business reports using BI Publisher. • Configured Database to authenticate users against Microsoft Active Directory. • Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users. • Extensively used Informatica to load data from wide range of sources such as flat files (CSV, fixed length), Oracle to Oracle. • Extensively worked with performance tuning of the mappings, sessions and Stored Procedures. • Developed re-usable transformations, mappings and Mapplets conforming to the business rules. • Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes. Environment: OBIEE 10.1.3.4, Informatica Power Center 8.1, Oracle 10g, TOAD, SQL, PL/SQL, Unix Shell scripts.
Watson Pharmaceuticals, Corona, CA Oct 2008 -- Apr 2009 Siebel Analytics Developer The ANALYZE project involved developing a BI solution for strategic analysis by sales, marketing, and pricing to provide marketing and campaign management capability, an ability to measure effectiveness across all products and provide single data set for analysis and tracking of results to the management. Responsibilities: • Worked closely with the business community to assess business needs, define requirements and Implement solutions. • Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs. • Design Siebel Web Components including OBIEE Answers and Intelligence Dashboards. • Implement Marketing Analytics module from Oracle BI Apps. • Implement new data modeling and new hierarchies on the existing marketing module as per client requirements. • Customized Siebel Repository defined Physical Data Layer and developed Business Model and Presentation Layer using Siebel Analytics Administration Tool and using OBIEE. • Configure DAC and create containers, subject areas and tasks. • Customized the repository and created new requests using Answers. • Managed day-to-day .rpd, Scheduler & iBots • Worked on creation and configuration of Siebel dashboards, customized reports and charts (like Sales, Service and marketing), in Siebel Answers. • Redefine hierarchies in Marketing Accounts and contacts as per client requirement. • Map the tasks to execute mappings in Informatica. • Extensively used Transformations like Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy. • Modified mappings as per the changed business requirements. • Developed UNIX and PL/SQL scripts to automate chronological loads. • Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution. Environment: OBIEE, DAC 7.9.4, Oracle 10g, SQL, PL/SQL, UNIX, Windows XP.
Marriott International, Bethesda, MD Nov 2007 -- Sep 2008 Siebel Analytics Developer The project aimed to analyze and predict customer and market trends and to help provide tailored solutions for customers and also analyze the performance reports for the bank. It enabled organization to develop and influence more intelligent business decisions, improve overall profitability, introduce new performance based KPI's for Budgeting, marketing, and forecasting. The Data Warehouse incorporated financial information from various data sources into one central repository providing the organization a cross-enterprise consolidated view of the information. Siebel Analytics was used to analyze information on revenue, cost, profitability, volumes, productivity and revenue generated by region, market segment. Responsibilities: • Responsible for delivery of quick fixes and enhancements to Siebel customers in the form of Fix packs. • Developed End-to-End Reporting Solutions. • Installation and Configuration of DAC (Data warehouse Application Console) for multi OLTP regional instance environment. • Used DAC client to load the custom mapping to the warehouse. • Direct Interact with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs. • Created/Modified Workflow Process. • Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, Joiner etc. • Extensively involved in designing the workflows, worklets and also involved in designing sequential and concurrent sessions using workflow manager. • Created Reusable Transformations and Mapplets in the Designer using Transformation Developer and Mapplet Designer Tools. Created and Monitored Workflows and Sessions using Informatica Workflow Manager. • Customized the application using Siebel Tools configuration in Data, Business and User interface layers. • Involved in unit testing and integration testing of all the mappings, workflows, schedules. • Configured Siebel Web Components including Siebel Answers and Intelligence Dashboards. • Created Logical Columns based on other Logical and Physical columns in the BMM layer. • Customized users, groups and assign privileges for the users to access the data from the warehouse. • Customized the repository and created new requests using Answers. • Created and configured the Siebel dashboards, customized reports and charts (like Sales, Service and marketing), in Siebel Answers. • Created Workflow Process, Workflow group and policy conditions to handle bounce backs. • Developed UNIX shell and PL/SQL scripts for pre & post session processes to automate daily loads. • Provided production support for applications. Environment: Siebel Analytics 7.8.5, Informatica Power Center 7.x, DAC, Oracle 9i, PL/SQL, SQL, Toad, UNIX.
ACL Technologies, Inc. Jun 2005 -- Oct 2007 Oracle Developer The project called SMS (Staff Maintenance System). The project contains that accepts the employees details and maintain the staff information in one database as well as we have maintained personal record of the employees and generating the employees' reports monthly, quarterly, half year and yearly. The process of accepting the details about employees forms and gives the employees reports. Responsibilities: • Involved in user requirement and requirement specification from users. • Documenting business requirements, functional specifications and test requirements. • Identified the key facts and dimensions necessary to support the business requirements. • Prepared prototype models to support the development efforts. • Developed various complex SQL queries, stored procedures, functions, packages and Database triggers. • Involved in the design, development and testing of the PL/SQL stored procedures, packages • Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts. • Provided input into updates and modifications of the product documentation and support the testing team to deliver the highest product quality to the customers. • Involved in analysis, estimating, design, development, testing, and 24 x 7 production support. Environment: Oracle 9i, SQL, PL/SQL, Windows XP, UNIX, SQL*Plus.