PROFESSIONAL SUMMARY

• Informatica developer with 11 Years of solid experience in Data warehousing Extraction, Transformation Load ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.x/8.x/7.x/6.x/5.x Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server , Informatica Power Exchange, Autosys
• Experience include Banking, Pharmaceutical and Insurance Domains
• Nine Plus 9 years of experience with Database objects, writing stored procedures, functions, triggers, DDL, DML SQL query performance tuning using Oracle 11gR2/10g/9i/8i, PL/SQL, SQL Plus, SQL Loader
• Extensive experience in tuning Informatica Mappings and Sessions for optimum performance.
• Excellent working knowledge of ODS, Datawarehouse models using Star and Snow-Flake scheme. Efficient utilization of Bottom-up and Top-Down methodologies.
• Experience in command line programs such as pmcmd, infacmd, infasetup and pmrep.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Good understanding of Software Development Life Cycle SDLC and Project Life Cycle.
• Good Understanding knowledge of Ralph Kimball Bill Inman Methodologies.
• Experienced with dimensional and relational database design.
• Good experience of working with process models like CMMi Level5
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings
• Proficient in using Informatica Repository Manager to create schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience in PL/SQL development and SQL Query Tuning for better performance.
• Good working knowledge on SQL Loader for Bulk Loading.
• Good knowledge in Scheduling ETL Jobs tool like Autosys.
• Experience in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
• Production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Effective in cross-functional and global environments to manage multiple tasks assignments concurrently.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILL SET:

• Technologies: Informatica Power Center 9.x, 8.x, Informatica Power Exchange.
• Work Model: Waterfall model, Agile
• Configuration Management Tools: Subversion, Perforce, Visual source safe.
• RDBMS: Oracle 11g, Teradata, SQL Server
• Operating Systems: Windows 7/2003/2013/Unix
• Others: Autosys

EXPERIENCE:

Confidenital

Senior Informatica Lead Developer

• Identity and Access Management: IAM deals with various entitlements across all the application used in the Bank. There are multiple tools being used by the bank for the review of these entitlements. Review Access SailPoint and Database Privileged Access MyCroft are the primary tools used extensively in the bank. Data is pulled from the source system on a weekly basis and Deltas are generated after cleansing and massaging. Provision for full load is provided as well. Data is then used by the application team for processing the certifications and sending out to managers for review
• Oracle Identity Management: Access Management OIM tool used by Bank to provision entitlements to bank users. ETL is performed on the source data, for example - user information, group information, to provide delta or full feed to the application. In addition various approval and provisioning reports are generated and shared with the business every 3 hrs for appropriate team to act upon it.
• Enterprise Credit Risk Information Warehouse: CPMV Common portfolio manager view processes Bank of America's Credit Risk portfolio data. Data is collected from different heterogeneous sources and consolidated into the ECRIS Enterprise Credit Risk Information System Warehouse. After the required business logic is applied by some value added processes this data is populated into data marts. These data marts are used by business users to generate the required reports.

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design
• Participated in data modelling logical and physical for operational database for the review tool.
• Worked as ETL Lead for all the tracks in IAM ETL projects.
• Developed High and Low level design documents
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files Fixed Width , XML and Excel files to staging database and from staging to the target Oracle database
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Imported XML target definitions from an XML, DTD, and XML schema files
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica PowerCenter.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys
• Monitored the status of Workflows/Work lets/Sessions in Gantt chart and Task view mode using Workflow Monitor
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse
• Involved in Unix Shell Scripts for automation of ETL process
• Error Handling: Handled in Informatica Mappings sessions and also through Validation Scripts
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements, etc.

Technologies/Environment: Informatica Power Center 8.x, Power Center 9.1, Informatica Oracle 10g, Oracle, Teradata, Unix, Autosys

Confidenital

Senior Informatica Lead Developer

• Eyeris: CPR is in process of developing/implementing a costing system using EyeProfit by Eyeris. The EyeProfit application is provided through a flexible, subscription based ASP Application Service Provider Model. The application requires historical operational and financial information from multiple systems on a monthly basis.
• Storage Enhancement: There exists a federate Data Mart which acts as the source of data for all operational reports, ad-hoc queries and data provisioning layer for all downstream systems. The derived layer contains derived data, aggregated and maintained at a higher granularity for a higher time period. As a part of this project new logic was added to identify CP Storage Cars.
• Corporate Operational Reporting: This project enhances the existing data mart at Canadian Pacific CP adding more Subject Areas to the system. This Data mart acts as the source of data for all operational reports, ad-hoc queries and data provisioning layer for all downstream systems.

Responsibilities:

• Analyzing the source data and working with business users to develop the Model.
• Used Informatica Power Exchange for Change Data Capture in Source Tables.
• Extracted data from Oracle Sources and loaded them into Stage tables in SQL Server.
• Applied business logic with transformation rules in Power Center to load in to SQL Server Warehouse.
• Developed Design documents and Mapping documents.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 7.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Technologies/Environment: Informatica Power Center 8.1.1, Informatica Power Exchange, Oracle 10g, SQL Server 2005, UNIX

Confidenital

ETL Informatica Lead Developer

• P2L BO Project: This project involves creating and populating a Datamart for Power2Learn application, from which BO reports are developed to be used by Business Users. Database for both, Staging and Datamart is Oracle 9i. Loading the Data Mart included complex transformation like look ups and grouping of data.
• P2L Data migration: The scope of this project includes L3 Support activities. The project involves populating data for Power2Learn courses from older version of the application to a newer version by means of an ETL tool, Informatica.

Responsibilities

• Worked with business partners to understand the requirements.
• Developed design documents and mapping documents based on BRD.
• Developed mappings/Transformation/ by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 7.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Scheduled the workflows using the Informatica scheduling functionality.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Responsible for end to end implementation of code in Production.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.1, Oracle 9i, Unix

Confidenital

ETL Developer

• Data Warehouse Corporate Analysis Reporting Acceleration: This project involved analyzing the performance and redesigning the production runs to load data warehouse in order to improve the batch window for the run using various utilities provided by Teradata and Informatica
• Data Mart Quality Insight: Anthem East Data Warehouse AEDW consolidates the data in North East region for reporting and analysis. AEDW receives data from various online transactional systems in the Connecticut, New Hampshire and Maine regions that are consolidated under Anthem Consolidated East Systems ACES . This project involved creating a data mart to provide quality insights of providers to business users.
• Anthem East Data Warehouse Maintenance and Production Support: Anthem East Data Warehouse AEDW consolidates the data in North East region for reporting and analysis. AEDW receives data from various online transactional systems in the Connecticut, New Hampshire and Maine regions that are consolidated under Anthem Consolidated East Systems ACES . This project involves production support, maintenance and enhancements to the AEDW system. Informatica Power Center 7.1 is the ETL tool being used for data migration to AEDW, which resides in Teradata RDBMS.

Environment: Informatica Power Center 5.x/6.x/7.1, Teradata 5.2, Oracle 8i, Unix

Responsibilities

• Analyzing the source data and working with business users to develop the Model.
• Extracted data from flat files and Teradata Database and applied business logic and loaded in to Teradata Warehouse.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked on different data sources such as DB2, Oracle, Teradata, SQL Server, Flat files etc.
• Used Teradata utilities Fastload, Multiload, TPump to load data
• Wrote BTEQ scripts to transform data
• Wrote Multiload and Fastexport scripts to export data
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center 5.x/6.x/7.1, Teradata 5.2, Oracle 8i, Unix