SUMMARY

• Informatica: 8+ years of Data Warehousing experience using Informatica Power Center 9.0.1/8.6/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1 , Informatica IDQ, ETL OLAP, and OLTP.
• SDLC: 8 years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Hospitality, and Insurance domains.
• Databases: 8+ years experience in dealing with various Data sources like Oracle 10g/9i/8i, Oracle PL/SQL, DB2 SQL Server and Informix.
• Data Modeling: 4 years of Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0/3.5.5 /3.5.2 , Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Involved in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages and complex SQL queries for extracting the data to system.
• Transformations: Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Responsible for enhancements using Informatica 9.0.1
• Worked exclusively in implementing the types of slowly changing dimensions (SCDs) - Type I II and IIIindifferent mappings as per the requirements.
• Data Analysis: Expertise in data analysis by writing complex queries using various analytical functions.
• Data Cleansing: 5 years of Data Cleansing experience using UNIX Shell Scripting and SQL coding.
• Automation and scheduling of UNIX shell scripts and Informatica sessions using cron job and informatica scheduler.
• Designed and developed ETL workflows to work with various sources and targets like MS SQL Server, DB2, Oracle, My SQL and Flat files.
• Performance tuning: Expertise in session partitioning, session tuning by optimizing Source, target, mappings and transformations.
• Documentation: Expertise in preparing the ETL Design Documents like High Level and low level Design documents.
• Implemented the command line commands like pmcmd and infacmd to perform tasks from any machine in the Power Center environment.
• Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Involved in the Unit testing, integration testing, System testing and UAT using Quality Center.
• Have worked on Business Analytical Reporting using BI Tools like Business Objects and Cognos 7.0.
• Involved in scheduling the workflows through Job scheduler using UNIX scripts.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.1.0,Informatica Power Center 9.0.1/8.6.1/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1/5.1.1/4.7 , Informatica Designer, Workflow Manager, Workflow Monitor, Data mart, OLAP, OLTP, Mapplet, Transformations, Toad, SQL*Plus, SQL*Loader, SQL, PL/SQL.

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7, 4.5/4.0/3.5.5 , Microsoft Visio 2010

BI Tools: Business Objects 6.5/6.0/5.x, Oracle Reports 9i, Cognos Series 7.0/6.0, Oracle Business Intelligence(OBIEE) 10.1.3

Databases: IBM Data STudio, IBM DB2 Control center, Quest central for DB2 5.2.0, Toad 7.4.0.3, Aqua Data Studio 4.7.2, Oracle SQL Developer 3.0.04, Oracle 10g/9i/8i/8.0/7.0, MS SQL Server 2005/ 2000/7.0/6.0 , MS Access.

Programming GUI: Visual Basic 6.0/5.0, C, C++, HTML, Unix, Putty 0.6.1, WINSCP 4.3.3

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Win XP.

PROFESSIONAL EXPERIENCE

Confidential, Newark, New Jersey

Senior Informatica Developer

Responsibilities:

• Responsible for developing new models throughout the cycle of development, SIT support, UAT Support, production deployment and post production support.
• Involved in creating new mappings and workflows for the reporting purpose and also worked on the existing code to load the member details which contains around 70 transformations.
• Worked on transformations like SQL transformations, look-up, sorter, aggregator transformations mainly and also worked on the web service calls.
• Conduct meetings and co-ordinate with different teams like Portal team, MOM (Message Oriented Middleware) team in order to understand the code dependencies.
• Lead the user stories by co-coordinating with the off-shore team .
• Expertise in creating the design documents, migration documents and the production support documents.
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Handled production support along with the sprint cycle keeping all the deadlines intact.
• Involved in creating Control Balance process to help tracking the load, data reconciliation during the data load and helps in reporting usage.
• Expertise in writing the SQL queries and tried to use the SQL override and SQL transformations to decrease overhead on Informatica . Also used sorter and aggregator transformations for better performance.
• Created and used assignment task and generated parameters which were assigned in the following tasks. Also used decision task evidently to send the data to different pipelines wherever needed. created UNIX scripts to auto generate the parameter files.
• Tested scripts by running workflows and assisted in debugging the failed sessions during SIT.
• Support testing and the UAT team during the cycle and extensively worked on the adhoc requests by the business.

Environment: Informatica 9.1.0, IBM Data Studio 2.2.1.0, IBM DB2 9.5- control center Tivoli scheduler, putty 0.55, Core FTP LE 2.2, IBM Rational ClearQuest

Confidential, Parsippany, New Jersey

Senior Informatica Developer

Responsibilities:

• Involved working with database administrators and project teams to gather functional specifications for data requirements.
• Responsible for coding and prepare unit test cases the different modules according to the specifications and client requirements.
• Written many complex queries to analyze the data in order to meet the client requirements in an efficient manner.
• Involved in removing the embedded passwords in Informatica integration with DB2/Oracle/Informix though UNIX Shell scripts.
• Responsible for upgrading the logic by analyzing and understanding the existing processes and business logic using Informatica Power Center Designer.
• Created and modified multiple Unix and Perl scripts which included sftp, PGP encryption and decryption, check the size of the file, check the format of the file, append the dates in the filenames, remove the headers etc.
• Evaluate all functional requirements and map documents and perform troubleshoot in the development processes.
• Played a role of Data Modeler and was responsible in designing star schema using Erwin tool.
• Worked with multiple source systems like RDBMS, flat files, XML files etc.
• Developed mappings using various transformations like look up, expression, sorter, Router, update strategy etc.
• Designed ETL logic using SCD type 3, SCD - type 2 and also used mapplets for reusability.
• Closely associated with the QA team for system testing and integration testing. Also worked with the Production support team to analyze the defects and made appropriate code fixes.
• Exclusively worked on the PL/SQL stored procedures using the roll up and cube functions.
• Prepared the technical design documents like Detailed Design Documents, mapping documents, Release notes, Implementation plans, Operational manuals for Production support teams.
• Prepared the DDL and DML scripts for creating/modifying database tables with appropriate grants and permissions.
• Did SQL and PL/SQL programming for Oracle Data Integrator and oracle.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Automated the jobs thru scheduling using built in informatica scheduler, which runs every day by maintaining the data validations.

Environment: Informatica Power Center 9.0.1, Quest central for DB2 5.2.0, Oracle SQL Developer 3.0.04, Oracle 10g, Microsoft SQL Server 2005, Microsoft Visio 2010, Putty 0.6.1, Toad 7.4.0.3, Aqua Data Studio 4.7.2, WINSCP 4.3.3, Micro strategy.

Confidential, Greenwich, Connecticut

Senior ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
• Project involved 50 databases and each database was around 1TB.
• Responsible for the End-to-End development with respect to the Hedge Fund services.
• Created and scheduled workflows to generate Reference and Market data extracts like Securities, Price, Asset, Custodian, General Account Ledger, Funds, and Exchange Rate which are delivered to client on a daily basis.
• Involved in weekly Client meetings along with the Business Analyst to clarify the requirements and translate the requirements into technical specifications.
• Experience dealing with huge data ware house with about 50 databases.
• Responsible in integrating various systems using Informatica ETL tool, PL/SQL and Unix Shell Scripting.
• Exclusively worked on the PL/SQL stored procedures to implement complex business logic.
• Created the transmission job as a part of automation which polls for files, configures according to the job and drops the files to the staging directory.
• Also involved in tuning the mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
• Automated the jobs through scheduling using built in informatica scheduler, which runs every day by maintaining the data validations.
• Responsible for creating deployment scripts to set up the Unix directory structure, Informatica Scheduling and to create SQL server objects like tables, views, triggers and stored procedures.
• Worked on Ms Excel and created macros and used techniques as part of data analysis.
• Developed standard mappings, mapplets and worklets using various transformations like expression, aggregator, joiner, source qualifier, update strategy, connected/unconnected lookup and Router.
• Involved in defect fix and enhancement of existing UNIX scripts and ETL workflows.
• Monitored workflows and collected performance data to maximize the session performance
• Worked extensively on SQL queries and sub queries before and after ETL coding to ensure the loading of the data.
• Exclusively worked on Event wait, Session, Decision, Email tasks and also implemented Cygwin code in command tasks of the ETL workflows.
• Worked with the flat files in both direct and indirect methods.
• Used Tortoise SVN for configuration management of Informatica XMLs and UNIX scripts. While worked on Visual Source Safe for version control of the SQL objects.

Environment: Informatica Power Center 8.1/7.1.1, Microsoft SQL Server 2005, PL/SQL, Secure CRT 5.5, Cygwin, Geneva, Embarcadero ER/Studio, UltraEdit 15, Microsoft Visual Source Safe 6.0, Tortoise SVN 1.6 .

Confidential, WHITE PLAINS, NEW YORK

Informatica Developer

Responsibilities:

• Involved in End-to-End development from OLTP systems to creation of Data Marts.
• Handled 2 Terabytes of data warehouse database.
• Understood the business point of view to implement coding using Informatica power center components.
• Exclusively worked on the transformations like Aggregator - to get monthly, quarterly, Yearly claim aggregations, Connected & unconnected lookups - get the claim ids from other tables and also used SQL override to filter the data, Router-to route the fraud cases and claims settled and Sequence Generator.
• Involved in Performance tuning of different tables like FIRST RESERVATIONS table which has data around 1 TB by creating partitions and using stored procedures.
• Worked on flat files as sources, targets and lookups.
• Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
• Implementedvarious optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Developed mappings/sessions using Informatica Power Center 8.6 / 7.1 for data loading. Developed mapping to load the data in slowly changing dimension (SCD).
• Responsible for enhancements using the SQL-T and Lookup transformations in Informatica 9.0.
• Handled the post session commands to archive the files, remove the existing files using UNIX commands.
• As part of enhancement projects, modified the Perl scripts according to the requirement.
• Used Informatica parameter files to filter the daily data from the source system.
• Involved in Data Quality Analysis to determine the cleansing requirements.
• Used various debugging techniques and informatica debugger tool to debug the mappings.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Oracle Stored Procedure to implement complex business logic for better performance.
• Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
• Created Materialized view for summary data to improve the query performance
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
• Responsible for scheduling the workflow based on the nightly load.
• Supported Oracle 10g databases running mission critical 24*7 systems.

Environment: Informatica Power Center 9.0/8.6/7.1.1 , Oracle 9i & 10g, PL/SQL, GoldengateMicrostrategy 7i, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, TOAD, Windows 2000Autosys .

Confidential, COLUMBUS, OH

ETL Informatica Developer

Responsibilities:

• Extensively used ETL to load data from Oracle database, My SQL, DB2, Excel sheets, flat files to different target systems.
• Expertise with connected and unconnected transformations like look up, stored procedure, aggregator, Expression transformations.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Created the data models using the Erwin modeler.
• Used the techniques like Incremental aggregation, Incremental load and Constraint based loading for better performance.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Understand business process and draft technical design documents based on the functional documents.
• Involved in the development of Informatica mappings and also tuned the session for better performance by implementing the pre/post-load stored procedures for target optimization.
• Used various Oracle Index techniques and partitioning concepts on databases to improve the query performance.
• Extensively worked on client information stored in Oracle database using Toad.
• Worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Written Unix Scripts for event automation which included PMCMD to start the workflows.
• Generated reports using MS Access Reports.

Environment: Informatica Power Center 7.1, MS Access Reports, UNIX Shell Scripting, SQL*Plus, Erwin, SQL*Loader, MS SQL Server 2000, Sun Solaris 2.7, DB2.

Confidential

ETL Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Created Design Document and Informatica mappings based on business requirement.
• Created dimensions and fact tables for the project.
• Used update strategy and implemented SCD type-3 to effectively migrate data from source to target.
• Worked on lookup, aggregator and joiner caches for performance enhancements.
• Involved in designing of Testing plan (Unit Testing and system testing)
• Played a vital role in moving the project to Production and prepared the documentation at every level.
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Used persistent caches whenever data from workflows were to be retained.
• Involved in the Release Management team and verify the Production checklist documents necessary for the Production Activities
• Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Setup Developer Access for Development, QA and Production Environments in Informatica
• Set up Project Folders in all Environments.
• Perform Maintenance, including: Manage Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Set up Permissions for Groups and Users in all Environments (Dev,UAT and Prod)
• Migration of developed objects across different environments
• Also involved in conducting and leading the team meetings and providing status report to project manager

Environment: Informatica Power Center 8.1.1/7.1, Business Objects 6.5.1, Oracle 10g/9i, PL/SQL, Windows NT, ERWIN (4.5), PL/SQL Developer, OBIEE 10.1.3.3, DB2, and UNIX.