SUMMARY:

• 10 years of experience in complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, Proof of Concept, GAP Analysis, Design / data Modeling (Star and Snow flake) et al
• Experience in interacting with Business users to analyze the business requirements and business processes
• Worked as a liaison between IT and business to ensure better communication in understanding and assessing requirements, planning/resolving outstanding issues and rolling out innovative and Strategic Reporting Roadmaps utilizing Key Performance Indicators (KPI’s) and business performance Metrics.
• Experience in managing both small and large teams
• 8+ years of business intelligence experience using OBIEE platform including RPD and report development, BI administration and code migrations et al
• 8+ years of Data Integration(Informatica) and data modeling experience. Extensive experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager and Workflow Monitor).
• Experience in Dimensional Modeling and creating Logical Data Model(LDM) and Physical Data Model(PDM) for various domains.
• Knowledge of Siebel CRM, Oracle EBS, Tableau
• Excellent communication skills, coupled with very positive user interaction and team spirit.

TECHNICAL SKILLS:

Informatica: Powermart 6.2, Power Center 9.6, 9.5, 9.1, 8.6,7.1, Power Center Client, Mapping designer, Workflow manager, DAC 

Oracle Business Intelligence (OBI): EE 11.1.1.7.1 and 11.x, 10.x (Administration tool, Answers, dashboards, administration, Publisher), OBI Apps, Tableau 10.x

Siebel Analytics: 7.x (Admin, Web, Answers, Dashboards), iBots Oracle 8i/9i/10g/11g, Teradata, MySQL, Microsoft SQL Server2000 SQL, C, JavaScript, HTML Toad SQL Developer, Putty, FileZilla ftp client, SPUFI MS Office Suite

Operating systems: Windows XP/2003/2000/NT, IBM AIX, HP Unix, Sun Solaris, Linux

Industry/Domain: Financial, HealthCare, Automotive, Retail, Energy and Utilities

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

•  Involved in designing the overall datawarehousing solution for existing and new reports using Informatica and OBIEE
• Involved in preparing/reviewing the technical and functional design documents for ETL and OBIEE.
• Conducting meetings with business users to validate the requirements.
• Involved in analysis and design of the OLAP and repository.
• Analyze data sources, develop source to target relationship (Informatica - ETL).
• Data quality and profiling, advises on data quality issues, provides analysis on data collection, mapping, aggregation and balancing functions using ETL tool Informatica to load data from OLTP into Data Warehouse tables.
• Creating and configured Informatica repository.
• Designed Informatica mappings using various transformations (Source Qualifier, Expression, Joiner, Lookup, Aggregator, Filter, Router, Update Strategy)
• Designed and Developed workflow from workflow manager (Session, command task, event wait,decision task)
• Design of the Physical, Business, and Presentation Layer of the Analytics metadata repository.
• Working in Answers to build Analytics reports and thus dashboards.
• Creating/Developing reports in Siebel Answers/Dashboards and trained the Business Users/Power Users.           

ENVIRONMENT: OBIEE 11.1.1.7.1 , Informatica 9.6.1

Technical Lead

Confidential

Responsibilities:

• Interact with business users to understand their OBIEE reporting requirements 
• Create the high level and detail level design document for ETL and BI reports and dashboards
• Work with the team to complete development activities as per schedule
• Doing requirement analysis for stack of ETL and reporting applications and conducting feasibility study.
• Creating Functional Requirement Documents.
• Scheduling meetings with SME.
• Designing the logical and physical data models and defining the ETL data flow involving different systems.
• Source data analysis, identifying Data quality and issues.
• Created BI training content for the end user
• Conducted BI training for end user
• Assist business users to complete user acceptance testing          

ENVIRONMENT:  OBIEE 11.1.1.7.1 , Informatica 9.6.1

Technical Architect (Onsite)

Responsibilities:

• Designing the overall Datawarehousing solution to have basic ETL data flows from EBS and 2 other different sources using Informatica and ODI and reporting from BI applications and OBIU enabling and integrating multiple components.
• Conducting workshops with business users, SME and stakeholders.
• Doing requirement analysis for stack of ETL and reporting applications and conducting feasibility study.
• Creating Functional Requirement Documents.
• Scheduling meetings with SME.
• Designing the logical and physical data models and defining the ETL data flow involving different systems.
• Source data analysis, identifying Data quality and issues.
• Creating dimensional data (LDM and PDM) model for the reporting requirements. Star schema or Snow flake depending on the requirements.
• Designing of informatica mapping, workflows using transformations (Source qualifier, Expression, Joiner, Lookup, Aggregator, Filter, Router, Update Strategy)
• Creating physical, BMM and presentation layers in BI RPD and creating the report design and layout.
• Reviewing the data modeling and ETL detailed design documents and make necessary updation.
• Outlining and Defining the integration strategy between out of box BI apps reports and OBIU reports along with custom reports.
• Documenting and reviews for Validation testing of the application.
• Leading the team in implementation of the solution into Production.
• Conducting Train the trainer training program for business users and support team. The program includes the detailed BI training from functional and technical perspective.
• Setting the client expectations and meeting the requirements for reporting from various source systems including 3 utilities applications and ERP solution.
• Managing the team and work allocation.
• Preparation of project status report.
• Conducting the UAT sessions.
• Managing the project document repository and resources.
• Coordination with offshore team and managing the same.
• Conducted knowledge sharing sessions with the team on various data warehousing and business intelligence areas.

ENVIRONMENT: Informatica Powercenter 9, OWB, OBIEE 11.1.1.7.1 , Oracle 11g, Oracle utilities BI, OBI apps

ETL Lead

Confidential

Responsibilities:

• Requirement analysis and feasibility study.
• Creating dimensional data (LDM and PDM) model for the reporting requirements
• Developing of ETL process from source to Warehouse using Informatica.
• Designed and Developed Informatica using various transformations (Source qualifier, Expression, Joiner, Lookup, Aggregator, Filter, Router, Update Strategy)
• Designed and Developed workflow from workflow manager.
• Creating dimensional data model for the reporting requirements.
• Responsible for the Data Analysis on the Source systems
• Created and Validated mappings and workflows for various sources like Oracle, flat files to load and integrate data to target database.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Extracted data from source systems, transformed as per the business rules specified in the ETL design document and loaded into the staging tables with additional metadata columns.
• Implemented lookups and different transformations in the mappings.
• Developed mapping parameters.
• Responsible for coordination with client and for system testing deliverables team
• Tracking issues, statuses and timelines of each migration.

ENVIRONMENT: Informatica Power Center 9, Oracle BI 10.1.3, Teradata, Oracle 11g,

ETL Offshore Lead

Confidential

Responsibilities:

• Requirement analysis and creation of functional docs.
• Feasibility study and creating design doc, and implementation and testing of the Bugs or enhancements.
• Interaction with the client and Business analysts and coordinating the work.
• Analyzing the long-complicated PL/SQL code and converting the same into the Informatica code.
• Create supporting documentation, such as metadata and diagrams of logical entity relationships, business processes and process flows and detailed solution design document with ETL and reporting components.
• Configured Informatica repository as per the business requirements. Developed SDE and SIL mappings using various transformations as per the requirements.
• Configured slowly changing dimensions in Informatica.
• Extracted data from source systems, transformed as per the business rules specified in the ETL design document and loaded into the staging tables with additional metadata columns
• Implemented lookups and different transformations in the mappings.
• Developed mapping parameters.
• Provided production support by monitoring the processes running daily.
• Review ETL and BI code.
• Preparation of data mapping document, Technical Design Document and Unit Test Case document
• Used Debugger, setting the breakpoints to test the data flow and running the sessions. Coordination with onshore team.
• Come up with a mitigation plan or strategy for deviation.
• Manage different OBIEE development initiatives.
• Conducted knowledge sharing sessions with the team on various data warehousing and business intelligence areas.

ENVIRONMENT: Informatica Power Center 9, Oracle BI 11.1.1.5, Oracle 11g

Technical Lead

Confidential

Responsibilities:

• Done complete Analysis existing reporting system and classification of reports to be best suited to Analytics or publisher.
• Involved in template creation for various modules.
• Involved in OBI repository configuration and all report/dashboard creation for the sales module.
• Involves in ETL designing with identification of custom mappings and workflows.
• Providing technical expertise in developing informatica code and writing SQL in oracle
• Extracted data from source systems, transformed as per the business rules specified in the ETL design document and loaded into the staging tables with additional metadata columns
• Implemented lookups and different transformations in the mappings
• Developed mapping parameters
• Provided production support by monitoring the processes running daily
• Preparation of data mapping document, Technical Design Document and Unit Test Case document
• Providing solution on architecture in ETL front
• Involved in Scope and time estimates of the various modules for reporting.
• Involved in DAC designing.
• Set up usage tracking and configured iBots for the report schedules.
• Led the end user training initiative to ensure smooth user adaptability for the solution

ENVIRONMENT: Informatica Power Center 7.1.2, OBI 10.1.3.2, Teradata

Technical Lead

Responsibilities:

• Participated in requirements gathering of the various work streams by interacting with the business user and base lining the details.
• Involved in various phases of the project development including analysis, design, and implementation and testing.
• Direct interaction with the client and Business analysts and coordinating with the team.
• Coordinating with the market from requirement clarifications.
• Done the requirement analysis and design.
• Preparing the design specifications and data mapping documents.
• Preparing the effort and time estimations for the implementations.
• Managing and allocating the work among the team members.
• Clarify technical questions raised by market.
• Using ETL tool Informatica to load data from OLTP into Data Warehouse tables.
• Designed and Developed Informatica mappings using various transformations(Source Qualifier,Expression, Joiner, Lookup, Aggregator, Filter,Router, Update Strategy
• Designed and Developed workflow from workflow manager(Session,command task,event wait,decision task)
• Configuring the analytics metadata using administration tool for multi lingual implementation. The application was configured to implement different languages for different markets and thus dashboards and reports were designed.
• Configuring the DAC repository and then created execution plans and subject areas to execute the mappings.
• Working in Answers to build Analytics reports and thus dashboards.
• Analyze the production issues/bugs and provide the cause and design to fix the same.
• Creating/Developing reports in Siebel Answers/Dashboards and trained the Business Users/Power Users.
• Creation of the installation plan in different environments and migration documents.
• Conducting code drops from one environment to another.

ENVIRONMENT:  Informatica Power Center 7.1.2/8, Oracle BI 10.1.3.2 (Administration tool, DAC and Siebel answers)/OBIEE 11g, Oracle 10g/Teradata

Siebel analytics and ETL Lead

Responsibilities:

• Involved in various phases of the project development including analysis, design, and implementation and testing.
• Involved in preparing the technical and functional design documents.
• Creating work plan and schedule sheet for the team.
• Mentoring the team of 4 members and managing their day to day task.
• Managing the work among the team members and coordinating with the Client.
• Involved in document reviews and test case reviews.
• Briefing the development status and issues/risks during the daily conference call with the onsite client manager.
• Involved in analysis and design of the OLAP and repository.
• Analyze data sources, develop source to target relationship (Informatica -ETL)
• Data quality and profiling, advises on data quality issues, provides analysis on data collection, mapping, aggregation and balancing functions
• Using ETL tool Informatica to load data from OLTP into Data Warehouse tables.
• Creating and configured Informatica repository.
• Designed and Developed Informatica mappings using various transformations (Source qualifier, Expression, Joiner, Lookup, Aggregator, Filter, Router, Update Strategy)
• Designed and Developed workflow from workflow manager (Session, command task,event wait, decision task)
• Using Debugger, setting the breakpoints to test the data flow and running the sessions.
• Developing Sessions & Workflows using Workflow Manager and monitor the workflow execution using workflow monitor to load the data into Warehouse.
• Configuring the DAC repository and then created execution plans and subject areas to execute the mappings.
• Design of the Physical, Business, and Presentation Layer of the Analytics metadata repository.
• Implementing the data security in the RPD.
• Configured multi user environment for development.
• Working in Answers to build Analytics reports and thus dashboards.
• Have built Analytics dashboards and integrating them with CRM applications.
• Creating/Developing reports in Siebel Answers/Dashboards and trained the Business Users/Power Users.

ENVIRONMENT:  Informatica Power Mart 7.1.2, Siebel Analytics 7.8.2(Administration tool and Siebel answers), Oracle 9i