SUMMARY

• Highly competent Business Intelligence Analyst/Data Warehouse (DW) expert on OBIEE/Siebel Analytics, Oracle BI Apps (Out of the Box Prebuilt Applications), Oracle BI tools, ERP's, OLTP & OLAP Applications.
• A dynamic professional with 10 years of rich experience in Business Analysis, adept at QA methodologies, business process analysis & change management communication on complex projects.
• Involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics, Oracle Project Analytics.
• Involved in implementing prebuilt solutions in converting data from ERP systems like Oracle EBS, PeopleSoft, and Siebel CRM into Enterprise Business Analytics Warehouse (BAW).
• Strong experience in Project methodologies, SDLC, DW and BI infrastructure and architecture using middleware OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, and dimensional modelling using Star schema in Data warehouse life cycle.
• Experience serving industrial segments like Finance, Insurance, HR, Sales and Marketing, Manufacturing and Service in business related to implementation of BI Solutions.
• Solid analytical & functional skills, ability to effectively communicate with technical & business audiences and expert negotiating skills while working with complex delivery variables and defining client requirements and ability to provide client executives with a comprehensive solution and coherent high level technical analysis.
• Experience in communicate with software vendor's first and second level support for OBIEE, OBIA, EPM administration, implementation and service requests and liaise with remote users and executives for application and production support.
• Hands on experience on metadata modeling Architecting BIDW projects, configuring Data Warehouse Administration Console (DAC), Informatica ETL Process and A technocrat with expertise in systems design, implementationand testing.
• Experience in BI Publisher (XML Publisher) and Oracle Business Intelligence Discoverer.
• Experience in developing applications using APEX 3.X/4.0(Application Express).
• Hands on experience in implementing JQUERY, AJAX in APEX.
• Extensive experience in writing SQL queries/reports, PL/SQL Stored Procedures, Functions, Packages, triggers for Oracle 11g/10g/9i/8i and tuning of SQL queries/scripts.

Skill Set

Development: OBIEE 11g/OBIEE 10.1.3.4/3/2, Oracle WebLogic Server, RCU (Repository creation utility), Oracle BI Apps 7.9.6.x/7.9.5.x, Siebel Analytics 7.8/7.7, Hyperion, EPM, Reporting & Analysis 9.x, ETL- Informatica 8.6.1/8.1.1/7.1.4/6.1.1, DAC 10.1.3.4/1(Data Warehouse Administration Console), ODI 11g/10g (Oracle Data Integrator), Oracle APEX 3.x/4.0, Oracle EBS R12/11i, PeopleSoft 9.0/8.9, Siebel CRM (Analytics), Mercury Quality center, Microsoft Visio, Quest Central for DB2, SQL*Loader, TOAD, SQL Developer, JDeveloper, BI (XML) Publisher, BI Discoverer 4i/10g, SQL, PL/SQL, C, C++, Java, HTML, XML, Web services, Oracle Financial Analytics, Procurement and Spend, Human Resources, Supply Chain and Order Management, Project Analytics.
RDBMS: Oracle 11g/10g/9i/8i/7, SQL Server 2003/2000.
Data Modeling: Erwin, Dimensional modeling, Star, Snowflake
Operating Systems: Linux, SUN Solaris, Windows

Education:

• Bachelor of Engineering (B.E) in Computer Science and Engineering.
• Masters in Advanced Computer Networks.
• Oracle Certified Professional (OCP).

Client: Confidential, SC July 2011 - Till Date
Role: Oracle BI/DW Lead Consultant

Responsibilities:

• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Customization and validation of all the OOB Dashboards: General Ledger, Payables, Procurement and Spend, Supply Chain (Inventory Control) and Project Analytics dashboards against Oracle EBS Source System.
• Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.
• Documented the technical architecture, physical components, requirements and delivery of the components
• Configured Oracle BI Applications (Informatica/ETL, DAC and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.
• Responsible for all activities related to the development, implementation, administration and support of ETL Informatica-DAC processes including customization of Prebuilt (OOB) Applications.

Environment: OBIEE 11g, Oracle BI Apps 7.9.6.3, OBAW, Informatica 9.0.1, DAC 10g, Oracle EBS R12, Web Logic Server, UNIX, SQL, PL/SQL, Oracle 11g, Windows 2003 Server.

Client: Confidential, MD July 2008 - Jun 2011
Role: Sr. Oracle BI/DW Consultant

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept and application design with Business Analysts from OLTP and OLAP to configure and customization of Oracle BI Analytics in all phases of implementing Out of the Box prebuilt mappings and Oracle Business Analytics warehouse (OBAW).
• Lead the team to co-ordinate the requirements and delivery of the components and train the team.
• Customization and validation of all the OOB Dashboards: General Ledger, Payables, and Procurement and Spend dashboards against Oracle EBS Source System.
• Documented the technical architecture, physical components, requirements and delivery of the components.
• Configured Oracle BI Applications (Informatica, DAC and OBIEE), implemented Oracle out of the box Prebuilt Apps.
• Worked on Oracle Data Integrator (ODI) as a custom Data warehouse development for student's information system data.
• Developed custom applications for school system using Oracle APEX (Application Express).
• Conversion of custom oracle discoverer reports in BI environment and working with BI-XML Publisher reports for Purchase Orders and configured Data Bursting to email & print.
• Responsible for all activities related to the development, implementation, administration and support of ETL Informatica-DAC processes including customization of Prebuilt (OOB) Applications.
• Documented the technical architecture, physical components, requirements and delivery of the components.

Environment:Oracle BI Apps 7.9.5, OBIEE 10g, Informatica 8.x, DAC, OBAW, SQL Server, Oracle10g, SQL Developer, Oracle E-Business Suite 11i, Toad, APEX 3.x/4.0.2, XML/BI Publisher, Discoverer 10g, UNIX, SQL, PL/SQL, SQL Loader.

Client: Confidential, FL. Apr 2005 - Jun 2008
Role: DW / Report Developer

Responsibilities:

• Highly experienced working with Oracle BI Server, Presentation Server, all three layers in the repository RPD - Physical, Business Model and Mapping and Presentation Layer.
• Develop Logical and Physical data models for warehouse to store data and tested data security, Dashboard security
• Migrate the testing of the code from Dev to QA and QA to Production of Repository RPD, Dashboard Reports and Informatica mappings and workflows
• Used Informatica Mappings and Transformations and created stored procedures and functions in Informatica.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various sources like XML, Flat files, COBOL Files, SQL Server, DB2 and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) and used Session parameters, Mapping variable/parameters and created Parameter files.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session, Implemented complex mapping such as Slowly Changing Dimensions.
• Designed and developed pre, post-session routines for sessions to drop and recreate indexes, UNIX shell scripts as part of the ETL process, automate the process of loading, pulling and pushing data from and to different servers.

Environment: Siebel Analytics 7.8/7.7, Informatica Power Center 7.1.4/6.1.1,Siebel CRM, Oracle 9i/8i, SQL Server 2003/2000, DB2, PL/SQL, Flat files, SQL*Loader, SRMW, TOAD, UNIX, Windows 2000.

Client: Confidential, Dallas, TX Feb 2004-Mar 2005
Role: ETL Developer

Responsibilities:

• Understand the Functional business processes and requirements given by the Business Users and involved in Designing High level Technical Documentation based on specification
• Designed and creation of fact and dimension tables and logical/physical data models based on specifications.
• Developed Mappings to populate data marts using Informatica Power mart designer and used debugger to evaluate ETL timings and optimized SQL in mappings and mappings by using Aggregator, filter, Joiner, Expression, Lookups
• Involved in Unit Testing, Integration Testing and System Testing and created UNIX shell scripts to automate batch jobs and debugging the Mappings, which were raised by QA at testing environment.
• Worked on to check out the Source to Target Mappings related to the Issues and modified, by analyzing data flow, evaluating various Transformationsand created mapplets which provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning. Designed workflows, sessions with assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Environment: Informatica Power Center 7.1.1/6.2, PL/SQL, Oracle 9i, SQL Server 2000, Windows 2000.

Client: Confidential, India Jan 2002 - Jan 2004
Role: Oracle Developer

Responsibilities:

• Coordinated with the business users to collect requirements.
• Prepared requirement specification document that gives the comprehensive details about the requirements
• Worked on logical and physical data modelling.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data-mart.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Created Materialized Views.
• Prepared unit test cases and executed the same.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Developed Reports to extract the monthly sales information.
• Customized and developed Reports using Reports 6i.

Environment: Oracle 9i, SQL, PL/SQL, Reports 6i, TOAD, SQL*Loader, UNIX.