SUMMARY

• Eight years of experience with data warehouse and business intelligence technologies, ETL development and designing, data modelling, reporting and business/data analysis.
• Substantial work experience with Informatica. Expertise in reusability, parameterization, workflow design, designing and developing ETL mappings and scripts.
• Six years of experience in Data Migration, Data Integration, and Data Conversion.
• Six years of experience in Global Data Conversion with various databases.
• Excellent experience with Oracle 8i/9i/10g/11g, SQL server 2005/2008, Greenplum.
• Expertise in UNIX shells scripting.
• Expertise in setting up load strategy, dynamically passing the parameters to mappings and workflows in Informatica.
• Well experienced in functional and technical systems analysis and design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis and design documentation and presentation.
• Experience with dimensional modeling with both star and snow flake schema using Ralf Kimball methodology with experience in manufacturing and logistics projects. Well versed with extract and loads of large data volumes.
• Experience in extracting data through Relational databases, flat files, excels XML files.
• Substantial experience implementing slowly changing dimensions - Type I, II and III
• Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.
• Expertise in Informatica 8.6.1/9.5.1 administration including managing domain, nodes, services, folders, managing Informatica services at regular interval.
• Expertise in successfully upgraded the Informatica from lower versions to higher versions, 8.x to 9.x (8.5.1 to 9.0.1 and 8.6.1 HF11 to 9.5.1 HF2)
• Involved in code migration across the environments and in deployment efforts.
• Implemented LDAP authentication for Informatica users.
• Scheduling and monitoring the ETL jobs using available scheduling tools, such as opswise, Control-M and Tidal.
• Experience an working with reporting tools Cognos and Qlickview
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation,, implementation and post-implementation review.
• Proven experience in project and team leading with zero defect delivery. Equally comfortable working independently as well as in a team environment

TECHNICAL SKILLS

Programming Languages: SQL,T-SQL, PL/SQL

DBMS: Oracle 8i/9i/10g/11g,Greenplum, SQL-Server 2005/2008,MS Access

Reporting Tools: Cognos, Qlikview, OBIEE

ETL Tools: Informatica 7.1, 8.1 and 8.6, 9.5.0, 9.5.1(HF2/HF4)

Design/CASE Tools: MS Project, Visio

Operating Systems: Win 2008/2003/XP/2000/NT, MS DOS, UNIX, RHEL

Miscellaneous: ERWIN, TOAD 7.x

Scheduling Tools: Opswise, Control-M, Tidal, DAC

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Atlanta, GA

Responsibilities:

• UsedInformatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Worked with InformaticaPowercenter8.6and9.5.1to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration ofInformatica8.6workflowsintoInformatica9.5.1version.
• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables.
• Created ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter,Normalizer,SQL Transformation,Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Built workflows, worklets, sessions, command tasks etc.
• FacilitatedETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Coordinated all migration efforts: migrating data mappings/session/workflows to Staging (QA)/Production from Development environments and monitoring, troubleshooting and restarting the batch process using Informatica.
• Maintained security by creating user accounts for Informatica Power Center (IPC)for all environments and providing the access for same.
• Troubleshot issues related to Server and ETL and made modifications to fix the problems when as required.
• Created a new code standards document with code standards and naming standards for all objects.
• Worked to ensure regular measurement of availability and when necessary,made improvements, providing 98% system availability.
• Involved in production support at all levels.
• Responsible for data validation across the systems in ETL and notifying the variances.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Involved in defining the overall strategy for design and standards by creating many checklists for smooth deployments.

Environment: Informatica 8.6 / 9.5.1, SQL Developer, Red Hat LINUX 6.5, Siebel CRM, Oracle BRM, Oracle EBS R12 and Oracle CCA, DAC 11g and OBIEE 11g

Informatica Admin/Developer

Confidential, Alpharetta, GA

Responsibilities:

• Responsible for requirement gathering analysis and end user meetings
• Architecture and development with high volume transaction systems.
• Responsible for migrating the code from 8.6 to 9.X and made changes to the code according to new 9.x standards at HP.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, XML Transformation and Aggregator Transformation.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Used both Connected and Un connected Lookup transformations
• Worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Data validation across the systems in ETL and notifying the variances.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Involved in defining the overall strategy for design and standards by creating many checklists for smooth deployments.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Facilitated Data Integration, Data conversion and Migrating the data from Source to Target
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Worked with Informatica data validation option on 9.5
• Performance tuning of Informatica mappings.
• Wrote Shell scripts in UNIX to make the email notification reusable and consistent.Admin Roles:
• Successfully upgraded the Informatica from 8.6.1 to 9.5.1 in all environments (Dev, QA, UAT and PROD).
• Maintaining user security in all environments
• Created a new code standards document with code standards and naming standards for all objects.
• Working to ensure the regular measurement of availability and when necessary the under taking of measures for its improvement providing 98% system availability
• Creating folder, managing various objects and encouraging developers to use shortcuts and re-usable objects.
• Involved in code deployment across the environments.
• Manage and maintain existing Informatica interfaces: Tidal, Powercenter, OBDC connections etc
• Participate in defining Informatica standards and best practices
• User support - answering questions, investigating user issues, enforcing standards
• Support production scheduler failures (either level 1 or 2)

Environment: Informatica 8.6.1, 9.5.1(HF4) on UNIX, Oracle, Qlikview, Tidal.

Informatica Admin/Developer

Confidential, Chicago, IL

Responsibilities:

• Responsible for requirement gathering analysis and End user meetings
• Architecture and development with high volume transaction systems.
• Responsible for Performance Tuning at the source level, Target level, Mapping Level and Session Level
• Solid expertise in using both connected and un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Responsible for best practices like naming conventions, performance tuning, and error handling.
• Involved in defining the overall strategy for design and standards by creating many checklists for smooth deployments.
• Developed slowly changing dimension mappings for Type 1 SCD and Type 2 SCD
• Data Integration, Data conversion and migrating the data from Source to Target
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Performance tuning of Informatica mappings.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Involved in estimation, design and architectural discussion with architecture team for data warehouse.Admin Roles:
• Setup and maintain Informatica folders and folder accesses.
• Worked on code review for maintaining the code standards across all environments
• Involved in design review/approval before on-boarding projects to shared platform along with day to day activities.
• Involved in establishing the platform architecture and implemented user security measures by creating appropriate roles and groups
• Worked on upgrade, Enhancement and migration of environments in Informatica
• Making sure that services are up and running in all environments
• Create and maintain connections (Relational, Application Etc.) and System usernames/passwords
• Working with Informatica product team to identify bugs and raising feature requests. Worked with product support on new version and hotfixes.

Environment: Informatica 9.1, 9.5.0 on UNIX, Greenplum,Hadoop,Oracle, Cognos 10.1, Qlikview, Opswise.

Lead Informatica Developer

Confidential, Detroit, MI

Responsibilities:

• Designed and developed Informatica Power Center mappings to Extract, Transform and Load (ETL) data from source to target.
• Tuned Performance of complex Informatica jobs involving huge Data files by adjusting Block Size, Data Cache Size and Target based commit interval. Fine-tuned existing ETL mappings for performance increase measures.
• Resolved bugs/issues that occurred due to incorrect understanding/analysis of business rules.
• Involved in identifying the source tables and defining the extraction criteria. Complex SQL queries were written as per specifications and extensively wrote Fast Export scripts for data extraction from Teradata.
• Extracted order transaction data using power connect from salesforce.com systems to load to Oracle target tables.
• Loaded and joined Salesforce.com data to the database using Update strategy to appropriate tables per business rules.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Developed Informatica mappings to load data from various sources into different targets. Used various ETL Transformations such as Look-Up, Joiner, Aggregate, Filter and Update Strategy.
• Used the Debugger to validate the transformations by creating Break Points and analyzing the Debug Monitor.
• Involved in writing SQL Stored Procedures to access data from Oracle Database.
• Fine-Tuned Existing Mappings for better performance. Documented Mappings and Transformations.
• Simplified the data flow by using a router transformation to check multiple conditions at the same time.
• Created customizable mapping by passing parameters at session level.
• Responsible for development and testing of conversion programs for importing data into Oracle data warehouse utilizing PL/SQL and Unix Shell Scripts.
• Also responsible for development of interface programs utilizing Unix Scripts

Environment: Informatica 8.6, 9.1 on UNIX, Oracle 10g, Teradata, PL/SQL, TOAD

Sr.Informatica Developer

Confidential, New York, NY

Responsibilities:

• Informatica, extraction from Oracle DB, transform and load to Oracle DB.
• Coordinated with off shore team for delivering the best solution to the client.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Facilitated scheduling and performance tuning of Informatica mappings.
• Prepared mapping documents and technical specifications
• Wrote PL/SQL stored procedures, functions, nested tables. Extensive hands on experience in PL/SQL.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Used ETL to load data from different sources like Oracle, Flat files, XML etc., into the Staging table and load the data into the Target database.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Collaborated with data modellers, ETL developers in the creating the Data Functional Design documents.
• Used free hand SQL for reports with calculation context and drill down features.
• Universe with aggregate navigation and derived tables.
• Conducted requirements analysis, design, and code reviews.
• Designed and implemented star and snowflake schemas to handle 1: N and M: N relationships.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Wrote PL/SQL functions and procedures, use of cursors, complex queries and ability to guide the team. Excellent communication skills
• Scheduled various ETL and reporting jobs using Control-M

Environment: Informatica 8.6 on UNIX, Business Objects, Oracle 10g, PL/SQL, MS SQL 2005,Control-M and TOAD.

Informatica Developer

Confidential, Portland, OR

Responsibilities:

• Used Informatica’s features to implement Type I, II, and III changes in slowly changing dimension tables.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Used PMCMD commands in non-windows environments.
• Data Integration, Data conversion and Migrating the data from Source to Target
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer Task, Command Task, Assignment Task and decision tasks.
• Created complex mappings to load data from various sources into Oracle, XML files.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Created the meta data layer using Cognos Framework Manager to simplify the end user presentation of the data
• Created of “Drill Pathways” with the Cognos Meta Data layer
• Authored documents involvingdetailed design document (DDD), unit test case scenarios, and knowledge transfer.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Monitored and configured the production ETL processes that run daily, weekly and monthly.

Environment: Informatica 8.6.1, Cognos 7x/8x, Oracle 9i, PL/SQL, TOAD, Autosys, Windows NT

Software Engineer

Confidential

Responsibilities:

• Understanding and Preparation of requirement for CIM application.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, views, Indexes, sequences and users.
• Wrote the commonly used Oracle stores procedures and functions.
• Built the Informatica mappings using Lookup, aggregator, update strategy, filter, and normalizer, sorter, and router transformations.
• Prepared the test cases and performing the unit testing CIM application.
• Implemented database and codes at the client location
• Scheduled daily and weekly database backups.
• Database monitoring, table space extension, user locks checking on daily basis.
• Creation of users, database schemas, tables, indexes, views and sequences.
• Prepared requirement and design documents.

Environment: Informatica PowerCenter 7.1, Oracle 8, TOAD, Linux, PL / SQL