Summary:

• Over 8 years of progressive experience in the IT industry with prime focus on analysis, modeling, design, development, implementation, testing, documentation, and maintenance of various Business Analytics in an effective way to deliver leading edge software solutions.
• Involved in all phases of design, development and implementation business Intelligence applications and my areas of expertise include business analysis, dimensional modeling, implementing Business Intelligence analytics solutions using Oracle BIEE 11g/10.1.3.x, Siebel Analytics 8.x/7.x, Extraction Transformation and Load ETL using tools like Informatica Power Center 9.x/8.x/7.x, Expertise in Data Warehouse Administration Console DAC to configure, monitor and schedule ETL and system integration/user acceptance testing.
• Experience in implementing and providing solution for HR, Financial, Sales, Manufacturing, Insurance business intelligence module.

• Proficient in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model and Mapping Layer Presentation Layer , Time Series Objects, configuring metadata, Answers, Delivers/ Interactive Dashboards/ Reports with drill-down drill-across capabilities using global local Filters, Security Setup Groups and Access Privileges , Web Catalog Objects and scheduling iBots.

• Experience in implementing Oracle Business Intelligence row level, Data Level and Object Level Security using LDAP.

• Expertise in implementing the LDAP, external table and database authentication in OBIEE 11g.
• Expertise in developing ad-hoc reports and dashboards as per business requirements using the OBIEE UI presentation services.
• Expert in configuring the delivers and scheduling the reports using the OBIEE Delivers.
• Experience in installing and configuring the Oracle BI Apps 7.9.6.3/7.9.6.4.
• Experience in multiple user development MUD environment.
• Solid understanding of Ralph Kimball approach and experience in Dimensional Data Modeling, Star Schema modeling, Snow-Flake modeling, identification of Fact and Dimension Tables, Normalization, Physical and Logical Data Modeling using Erwin.
• Strong Knowledge in using the Oracle Data Integrator 11g to perform the ETL.
• Extensively worked with Informatica PowerCenter Designer to create various mappings and maplets used for ETL operations.
• Extensively worked on Informatica PowerCenter Workflow Manager and Workflow Monitor to successfully perform the ETL.
• Experience in designing the data warehouse using the dimensional modeling techniques.
• Experienced in Installation, configuration, upgrade, migration and administration of OBIEE, Data Warehouse Administration Console DAC , and Informatica Power Center.
• Experience in designing DAC subject area, scheduling the execution plan using DAC client tool and debugging the ETL load using Informatica and DAC client tools. Configure, monitor and Schedule ETL routines of DAC.

• Highly experienced on Database such as Oracle 11g/10g/9i, SQL Server 2005/2008.
• Experienced in writing Toad and SQL Developer tool.

• Extensively used SQL, PL/SQL to write stored procedures, functions, package and triggers.
• Experience in managing and coordinating onsite/offshore team.
• Overall strength lies in precise translation of business requirements into technical documents. Ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Technical skills:

Professional Experience:

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Work with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation.
• Perform business analyst functions to develop and maintain online reporting to support the data and information needs of internal customers.
• Provide technical knowledge to the design and implementation of the enterprise wide business intelligence solutions.
• Create technical design specifications, developing analytical reports, troubleshoot and resolve technical issues, debug, tune and optimize report performance.
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications
• Develop test conditions and test cases for assigned tasks.
• Perform initial problem investigation to determine scope and depth of problem and recommend additional steps and solutions by following established guidelines.
• Support clients during implementation and use of the online reporting application.
• Migrate reports from current and various platforms into the OBIEE structure.
• OBIEE administration, setup, installation, and integration.
• Repository creation, maintenance and migration.
• OBIEE Security, Performance Tuning, Report Enhancements and Views.

Environment: Oracle 11g, OBIEE 11.1.1.7, Oracle EBS R12, SQL Developer, OBI Analytics Admin, Answers, Delivers , BI Publisher, Test Cases, UNIX, Windows 7.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Working with the Business users for identifying potential reporting needs that will help them save cost and effort. OBIEE Technical lead and Scrum master.
• Documenting customer requirements use cases translating them into functional and technical requirement specifications.
• Providing project estimates, with gap analysis and proof of concept if required for providing high level swag.
• Conduct OBIEE scrum sessions from requirement gathering phase to Customer acceptance testing.
• Preparing mock up designs for OBIEE dashboards and report requirements.
• Offshore development coordination, code reviews and ensuring project delivery.
• Developed complex out of box functionalities like JS scripting, Static HTMLs, navigations using Go URL methodologies etc.
• Involved in Unit Testing, performance Testing Regression Testing.
• Work with development team to resolve day to day issues and coordination.
• Responsibility for support and enhancements of the application.
• Proactively identifying new reporting requirements that are beneficial to the user community.
• User trainings.

Environment: Oracle 10g/11g, OBIEE 10.1.3.4.2/11g, Informatica Power Center 8.6.1/9.x, UNIX, Windows XP, Unit Testing, JS Script, Static HTMLs.

Confidential

Sr. OBIEE Developer

Responsibilities:

• Involved in creating templates in Word and Excel for status sheets, for capturing requirements and for various other purposes.
• Worked as a liaison between developer and end-users to resolve defects.
• Extensively worked with Siebel Analytics Answers to create Reports, Prompts, Folders, Union reports and different types of views.
• Tuning the reports for better performance.
• Worked with Siebel Analytics Delivers to create and schedule iBots.
• Creation of users and groups.
• Worked with the Variables and initialization blocks of the repository.
• Extensively worked on BI Publisher, Webcat Manager, Scorecards, OBI Presentation services Answers and Dashboards to create reports and dashboards.
• Designed and developed Detailed Credit Analysis Report using BI Publisher which extracts the Markdown reasons and multiple credit requests.
• Worked with Security Manager to implement Object level and data level Security.
• Involved in Review and Quality checking of other team members Code.
• Involved in developing Mappings and Transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy between source and target using designer.
• Created Test Cases for Siebel Analytics Admin Functionalities and iBots.
• Configured iBots to deliver analytics content based on schedule to obtain daily reports and sent notification Alerts.
• Configured DAC Data warehouse Access control for running of ETL jobs
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Worked on webcat, Siebel Analytics webcat replication and Siebel Analytics Web Administration.
• Troubleshooting and Analysis of Defects and providing recommendations to the customer and actively participated in resolving the issues.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.

Environment: Oracle Business Intelligence 10.1.3.3.4/11g, Oracle 10g/11g, Siebel CRM, Analytics Admin, Answers, Delivers, webcat , BI Publisher, Test Cases, DAC, Informatica 7.1.2/8.x PowerCenter/ PowerMart .

Confidential

OBIEE/ETL developer

Responsibilities:

• Involved in setting up the OBIEE environments.
• Strong experience in developing Crystal reports.
• Involved in development of data mapping process, functional design, technical design and requirement document.
• Designed ETL using Informatica to load data from Seibel CRM, Flat files, Oracle Database into the target OLAP centralized warehouse.
• Designed the OLAP warehouse using dimensional modelling approach.
• Developed the OBIEE repository definition physical layer, bmm layer and presentation layer file using OBIEE Admin tool.
• Designed dashboard pages like Overview, Payments Due, Payment Performance, and Supplier and Customer report in using OBIEE UI.
• Configured OBIEE iBots to deliver analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Involved in implementing the authentication and authorization security model in OBIEE 10g.
• Created Level based measures and dimension hierarchies in the BMM layer of OBIEE .rpd file.
• Designed Informatica Mappings from scratch to load the data from source systems to staging system and then to target data warehouse.
• Extensively used Informatica PowerCenter Workflow Manager and Monitor to successfully perform the ETL loads.
• Conducted training sessions on Informatica 8.6 for the IT team.
• Involved in testing the OBIEE reports/ dashboards and security set up on these analysis.

Environment: Seibel CRM, Oracle EBS, OBIEE 10.1.3.2, Informatica 8.6.1/7.x, ODI 10g, Oracle 10g, SQL PLUS, Netezza, Crystal reports, UNIX, Windows XP.

Confidential

Informatica ETL Developer

Responsibilities:

• Gathered business requirements and created mapping documents based on the data model and source system analysis.
• Integrated data from heterogeneous source systems extract and transform data with business rules and built re-usable mapplets using Informatica Designer.
• Created complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, lookups to develop datamarts.
• Worked on creating star schema datamarts using the dimensional modelling approach.
• Fine-tuned transformations and mappings for better performance.
• Used Informatica Power Center workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Efficient documentation was done for all phases like analysis, design, development, testing and maintenance.

Environment: Informatica Power Center 7.1.2, ODI 9i, Oracle 9i, UNIX and Windows Server 2000, Netezza.

Confidential

Responsibilities:

• Interacted with end users to gather business requirements and transformed them into technical work plan
• De-normalized the physical model to meet requirements and improve performance
• Designed functional layout from business specifications and by interaction with BA team
• Created and maintained database objects required for the process in development and QA environments
• Worked with other team members to develop ETL process to implement business rules and load transformed data to target tables
• Used SQL Loader to upload nightly/weekly data from flat files.
• Provided production support to operations team
• Participated in status meetings with manager

Environment: Oracle 9i/8i, PL/SQL, Oracle 8i Forms and Reports , Toad, SQL Loader, Informatica 7.1.