SUMMARY

• Seven years of experience as a Business Intelligence Analyst in designing, building and maintaining Data Integration applications using various ETL tools and technologies such as Informatica Power Centre, IBM DataStage, Ab - Initio, and PL/SQL across multiple industries such as Logistics, Retail, Insurance and Banking & Finance.
• A thorough understanding of principles of Business Intelligence, and extensive experience in building BI systems.
• Extensive experience in performing analysis of existing systems/ business processes to identify enhancement to existing systems or a need for new system.
• Excellent understanding of concepts related to Data Warehouse Architecture, Star Schema, Snowflake Schema, and Dimensional Modeling.
• Excellent understanding of Data Marts, SCD (Slowly Changing Dimension) process, dimension, and fact tables.
• Extensive experience in designing, and building BI applications, such as reports, cubes, and dashboards using Microstrategy.
• Extensive experience in designing and building Extraction Transform & Load (ETL) processes.
• Expertise in building applications using SQL, and PL/SQL in DB2, SQL Server, Oracle, and Sybase.
• Experience with Shell scripting.
• Experience with all the phases of System Development Life Cycle (SDLC).
• Experience with executing projects using Agile Methodology.
• Evaluated Oracle Golden Gate as a change data capture tool.
• Experience with scheduling tools, Control-M, and Tidal.
• Proven ability to manage and motivate a team and excellent communication and leadership skills with

TECHNICAL SKILLS

Reporting Tool: Microstrategy, OBIEE

ETL Tools: Informatica 7.x/8.x/9.x, Ab Initio, IBM DataStage 8.1

CDC Tool: Oracle Golden Gate

Big data: Cloudera-Hadoop

Data Quality Tools: Informatica Data Quality Unix shell scripting, PL/SQL

OS: UNIX AIX5.1/5.3

SQL Tools: Toad, Putty, Oracle SQL Developer, DB2 Quest

RDBMS: Oracle, Sybase, DB2, MS-SQL Server 2000

Scheduling Tool: Control M

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Environment: Informatica 9.x, UNIX, DB2

Responsibilities:

• Build, and manage a five-member team with onsite-offshore model.
• Define the processes for Production Support.
• Define roles and responsibilities for team members.
• Support ETL processes in production environment for MBODS.
• Providing solutions to business readiness team/ application team to eliminate repetitive problems.
• Code review for offshore development team.
• Impact analysis for Reporting and ETL code changes as per changing business requirements.
• Create, and publish Run-Book for ETL process.
• Define different scenarios and escalation matrix for each scenario.
• Enable knowledge transfer to offshore team by gathering knowledge, and necessary documentation from development team.
• Coordinate with the Development team during the post “Go-Live" operations to address any bugs in the design.
• Work with the SA team to perform wellness checks on the production data.
• Working with the DBAs to performance tune DB2.

Confidential, Salt Lake City

BI System Analyst

Environment: Informatica 8.6/ 9.x, Microstrategy 9.x, Oracle Golden Gate, UNIX, DB2, PL/SQL

Responsibilities:

• Collaboration with various business units to determine and analyze the information needs and functional requirements, and document these requirements.
• Responsible for communicating both functional and technical specifications to the technology team.
• Conducts user acceptance testing (UAT) to validate technology solutions.
• Generate reports, charts, tables, graphs, and similar visual aids to effectively communicate results.
• Coordinate with an offshore team of 8 people.
• Prepare Source-Target data mapping.
• Develop Microstrategy Reports.
• Develop Informatica Mappings, and Workflows.
• Do performance tuning at Informatica and SQL level.
• Address Ad-Hoc business queries, and data issues reported by business users.
• Weekly Status reporting, offshore work assignment and status calls.
• Coordinating the timely delivery of code with the client and getting the required approvals from stakeholders.
• Provide first level ETL production support for post "go live" operations.

Confidential, Salt Lake City

BI Analyst

Environment: Informatica 8.6/ 9.x, Microstrategy 9.x, UNIX, DB2

Responsibilities:

• Support BI Applications (Reports, and ETL Processes) for GNA DW.
• Providing solutions to eliminate repetitive problems.
• Code review for offshore development team.
• Impact analysis for Reporting and ETL code changes as per changing business requirements.
• Create detailed Run-Book for all ETL process.
• Gather the necessary documents from the development team for the new ETL processes and transfer knowledge to offshore team.
• Coordinate with the Development team during the post “Go-Live" operations.
• Working with the DBAs to performance tune queries at DB2 level.

Confidential, North Carolina

BI Analyst

Environment: Informatica 8.6, UNIX, DB2

Responsibilities:

• Level One Support for SDN Datawarehouse.
• Resolving technical & functional issues in the ETL operations.
• Coordinating with the Control M team to schedule the ETL jobs.
• Impact analysis for ETL code changes as per changing business requirements.
• Code review, Unit Testing, and Integration testing for Change Requests.
• Maintaining necessary documentation for the changes made to the existing processes.
• Interviewed candidates for this project.

Confidential

BI Analyst

Environment: Informatica Power Center, Oracle, Sybase

Responsibilities:

• Participate in the design phase of the technical requirements.
• Create mappings, workflows, sessions based on the design documents.
• As an Offshore ETL Lead, I was responsible for allocating the daily tasks and coordinating the deliverables with my Onsite manager.
• Train new resources.
• Prepare support documents and get them approved by Onsite manager.
• Document the technical specifications, UTCs, etc.
• Unit Testing - It involved identifying the unit test cases to validate the functionality of the mappings.
• Integration testing to test various workflows.
• Handled the code deployment to QA, and Production environment.

Confidential

BI Analyst

Responsibilities:

• Create mappings, workflows, sessions based on the design documents.
• Provide technical solutions as per the client requirements.
• Document Technical Specifications, UTCs, etc.
• Unit Testing - It involved identifying the unit test cases to validate the functionality of the mapping.
• Integration Testing