PROFESSIONAL SUMMARY:

• Over 10 y ears of diversified experience in the field of Information Technology with an emphasis on complete software life cycle implementation of Data warehousing and Decision Support Systems (DSS).
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Have good Hands on Experience in Informatica 9.1 version.
• Have good experience in CRM application. Handled two different projects with CRM applications.
• Have knowledge in OBIEE.
• Have knowledge in implementing mappings using Informatica .
• Also implemented complex business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center.
• Strong in Data warehousing concepts, Star Schema and Snowflake Schema methodologies.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions.
• Experience in Slowly Changing Dimension Techniques
• Have good experience with Informatica IDQ.
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Interactive, command line utility) to create, schedule, control workflows, tasks and sessions.
• Used Debugger to test the mappings and get troubleshooting information about data and error conditions.
• Efficient team player with excellent analytical, communication and interpersonal skills.
• Ability to work in - groups as well as independently, well motivated to rapidly acquire new skills on the job and successfully implemented several projects.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/ 8.x/7.x/6.x, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager,IDQ

Business Intelligence: Business Objects

Databases: Oracle 10g/9i/8i, DB2 UDB, MS-SQL Server 2000/7.0, Microsoft Access.

Languages: C, C++, SQL

Web Technologies: HTML, JavaScript, VBScript, ASP 3.0, XML

Environment: UNIX, Windows NT 4.0, Win 95/98/2000/XP, MS DOS, IBM AS/400, IBM AIX.

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

• Developed technical specifications of the ETL process flow
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked in Onsite-offshore model.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Handled offshore team of 12 members having seniors and Juniors in the ratio 5:1
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica 9.5, Oracle 10g, Unix Shell scripts

Confidential

Senior ETL Developer

Responsibilities:

• Requirement Gathering
• Formulation of design strategy.
• Used IDQ and have done Data cleansing.
• Have majorly involved in preparing the Application Design for Landing to Staging.
• Daily Co Ordination with the customer to ensure any update in the requirement is clearly conveyed to team members.
• Review the Mappings, Workflows, Sessions.
• Support for Defect fixes in CIT environment.

Environment: Informatica 9.5, Teradata, Unix Shell scripts

Confidential

ETL Developer

Responsibilities:

• Requirements capture
• Formulation of design strategy.
• Preparation of HLD and LLD.
• Designed the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. ETL design and implementation include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
• Assist infrastructure personnel to define and document the technical architecture that includes ODI, DRM.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.

Environment: Oracle 11g, OBIEE 11g, ODI 11.1.1.5, RTC, Linux

Confidential, Los Angeles, CA

Sr. ETL Consultant

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Created salesforce External loader application and used this application to connect to salesforce.com.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.

Environment: Informatica PowerCenter/PowerMart 8, UNIX, Oracle.

Confidential, Los Angeles,CA

ETL Analyst

Responsibilities:

• Informatica Designer tasks include creating mappings, mapplets and transformations and import of source and target metadata
• Used complex data transformations in mapping.
• Involved in performance tuning and resolving performance bottlenecks.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous sources and determined the hierarchies in dimensions
• Used task developer in the Workflow manager to define sessions
• Created reusable Worklets and mapplets and transformations
• Responsible for monitoring all the sessions that are scheduled and involved in debugging the Mappings that failed
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Scheduling and coordination of the Informatica tasks is done using UNIX cron and Perl scripts. Email and paging facilities are also utilized at key points in the process
• Developed different types of Reports such as; Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects 6.5.1

Environment: Informatica PowerCenter/PowerMart 7,Business Objects 6.5.1 and Windows NT

Confidential

ETL Developer

Responsibilities:

• Involved in Business Analysis and Requirements Gathering.
• Designing and customizing data models for Data warehouse supporting data from different sources.
• Developed and designed Datamarts Extensively using Star Schema.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation.
• Designed, developed Informatica mappings, enabling the extract, data cleansing, transport and loading of the data into target tables.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Designed workflow, sessions and tasks using Workflow Manager and scheduled workflows .
• Extensively worked on Informatica client tool Repository Manager to create Folders, Users and Groups.
• Prepared Design documents to develop the Informatica mappings, Test cases to ensure the correctness and consistency of the data moved to the DDR.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit test and Integration testing of Informatica Sessions, Batches and the Target Data.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performance related issues.

Environment: Informatica PowerCenter 6.1, Oracle 9i, Windows XP.

Confidential

Responsibilities:

• Worked closely with Project Managers, Business Analysts and Business Clients.
• Involved in different Projects as a Business Objects Universe and Reports Developer for designing Universes to different Business Teams within the organization.
• Built around 6 Universes for various applications required by different departments.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Designed, developed Informatica mappings, enabling the extract, data cleansing, transport and loading of the data into target tables.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Designed workflow, sessions and tasks using Workflow Manager and scheduled workflows .
• Extensively worked on Informatica client tool Repository Manager to create Folders, Users and Groups.
• Involved in Designing the universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes. Created hierarchy and conditions at the designer level.
• Utilized the feature of Derived Tables in Universe
• Created Multi Dimensional analysis using Slice/Dice and Drill through methods to organize the data along a combination of “Dimensions” and “Drill-Down Hierarchies” giving the ability to the end-users to observe data from Heterogeneous viewpoints.
• Migrated the Universes and the Reports between Development, Testing and Production Repositories
• Created complex reports both in Business Objects 3 - Tier and Web Intelligence Java Report Panel like master/detail, drill down and cross tab using data from SQL server, Personal data files and Oracle.