Professional Synopsis

• Informatica and oracle certified professional with over 9 Years of IT experience in the Analysis, Design, Development, Testing and Implementing the ETL/Data warehouse system for Banking, Telecom and Insurance Domains.
• Having in-depth work experience in Informatica Powercenter , Informatica Power Exchange,PL/SQL,IBM Cognos
• Expertise in creating Real time Change Data Capture CDC , MQ and Web Service workflows using Informatica Power Exchange
• Having experience in Informatica Data Quality for data validation rules
• Having experience of working with cloud based tool Salesforce
• Expertise in developing SQL, PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Expertise in working with relational databases such as Oracle Exadata , Mainframe DB2,Microsoft SQL Server, Teradata
• Exposure to Hadoop Ecosystem including HDFS, MapReduce, HBase, Hive and Pig,Oozie and Zookeeper
• Developed Models and Packages using Framework Manager and published to Cognos Server.
• Developed reports and performance tuning aggregation at the database, indices, Query Optimization and Framework Manager Model improvement were done to improve the report output.
• Experience in developing Unix Shell Scripts for automation of ETL process
• Knowledge in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational multidimensional database design using Data Modelling tool ERwin Physical and Logical data models .
• Experience in working with Teradata utilities like BTEQ, Fast load, Multiload, Fast export, Tpump.
• Experience in resolving on-going maintenance issues, bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Working with business stake holders about impact of implementing the changes in production environment
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Conducted training sessions for the users and also prepared user manuals for better understanding of the designed system for the users
• Having good experience as team lead and led the team with team size of 12-15.
• Excellent interpersonal and communication skills and having experience in working with senior level managers, business people and developers across multiple streams.

Technical Skills

• ETL Tools: Informatica Powercenter 9.x, 8.x , Power Exchange 9.x, 8.x , Informatica Data
• Quality, Pentaho, IBM WebSphere DataStage 8.1,Informatica MDM, Informatica Address Doctor
• BI Tools : Cognos 10 BI Series, Business Objects
• Databases: Oracle Exadata, Mainframe IBM DB2, Microsoft SQL Server, Sybase, Teradata
• Oracle Tools: SQL Developer, SQL Plus, TOAD
• Data Modeling Tool : Erwin
• Version Controlling Tools: Clear Case, Harvest, Tortoise SubVersion
• Scheduling Tools: ESP Scheduler, Control M, Autosys
• Operating Systems: Windows, AIX-UNIX, Mainframe Z/os
• Languages: SQL, PL/SQL, Java, JSP, C, UNIX Shell Scripting ,HTML

Projects Handled:

Confidential

ETL Consultant

Confidential

Technology : Informatica Power centre 9.5,

Autosys, Microsoft SQL Server 2008/2012, Oracle 11g,PL/SQL,Unix Shell Scripting, HP Quality Centre, Tortoise Sub Version Lincoln Financial Group is offering a diverse range of financial services and solutions. With a strong focus on four core business areas life insurance, annuities, retirement plan services, and group protection. This project is to create a LFGD Data Warehouse to optimize process to increase the productivity, improve flexibility and to achieve operational excellence. Customer Analytics and marketing team is responsible for managing data from different sources. The data is used to analyse customer behaviour to help make key business decisions. This information is used by businesses for direct marketing, site selection, and customer relationship management CRM , Sales Reporting, Compensation and Management reporting for LFD Sales.

Responsibilities:

• Developed reusable Informatica mapplets and worklets for audit balance framework.
• Responsible for creating, maintaining, and automation of ETL jobs using procedural objects like procedures, functions, packages and triggers, using utilities like SQL Loader, UTL FILE, external tables, Oracle data pump and delivering components by following the agile methodology.
• Responsible for providing solutions in performance tuning of database objects using parallel Execution, query optimization techniques function based indexes, minimizing joins , partitioning, bulk collections strategies, pipeline functions, oracle Hints. And expertise in using explain plan, SQL trace and extended SQL trace TKPROF for batch ODI scenarios.
• Performing POC to solve existing system/reporting problems using emerging technologies like Hadoop.
• Created ETL design and mapping flow for highly complex requirements.
• Done in depth data Analysis to see what kind of data present in source and how they should to be loaded into the target.
• Involved in the Design, Development, Testing phases of the Data warehouse.
• Prioritized Business requirements and translated those requirements into functional technical requirements
• Involved in Design and Data Model development
• Created Informatica mappings for initial load and daily updates.
• Modified mappings as per the changed business requirements.
• Designed reusable transformations and shortcuts to share different mappings.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Designed and developed Mapplets and worklets for reusability. Extensively used ETL to load data from heterogeneous sources like flat files, Oracle tables, XML and Teradata.
• Involved in fixing, testing of store procedures and functions, unit and integration testing of Stored Procedures and the target data.
• Designed Audit Strategy to audit the data between Source System, Target System and Other Parallel Reporting Systems.
• Involved in troubleshooting the load failure cases, including database problems.
• Analysed the query performance and designed the load process schedules.
• Involved in Production Deployment and Support.
• Creating UNIX scripts to run workflows and to check files availability and sending generated files to different systems for processing further.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Troubleshooting the problems by checking various logs.
• Involved in unit testing and Integration Testing.
• Created and performed testing strategy and test plans for any changes/upgrade to Informatica mappings

Confidential

Technology : Informatica power exchange, Informatica Power centre 9.0 9.5, ESP scheduler, Oracle Exadata, Teradata,DB2, Unix Scripting

Tools : Informatica Power Centre 9.0 9.5, Informatica power exchange 9.5, ESP Scheduler, Harvest

Confidential is a leading investment management and investment services company, uniquely focused to help clients manage and move their financial assets and succeed in the rapidly changing global marketplace. In CIW we process data for cash activity transactions related to assets, Foreign exchange ,Advisory fees, Asset management fees, Custody/administration fees, Stock transfers Research/analysis fees etc.The objective of this project is to create a new data warehouse CRS for The Bank of New York Mellon Customers. The new data warehouse CRS Customer Reporting System is developed by sourcing data from two systems. Legacy Bank of New York data warehouse COD Custody Operational Data warehouse Heritage Mellon custody and accounting systems CMS Custody Management System and IAS Institutional Accounting System CRS is built to store data necessary for generating drill-down reports which provide cash custody data. CRS is now renamed to CIW Client Information Warehouse . CIW will initially be populated by only legacy COD system and will eventually be integrated by Mellon's custody accounting source systems.

Responsibilities:

• Creating High Level Design documents and Low Level Design documents based on requirements
• Done in depth data Analysis to see what kind of data present in source and how they should to be loaded into the target.
• Involved in Data modelling.
• Created mapping with various type of sources and targets XML, Flat file, MQ, CDC, VSAM , DB , Web service .
• Creating CDC Registrations for Real time data.
• Creating PWX data maps to fetch data from the Mainframe Files.
• Monitor the Client Information Warehouse jobs to make sure SLAs are met. Ensure that environment related issues are reported immediately, and follow up to closure.
• Worked with Teradata 12 utilities like BTEQ, Fast Load, and Multi Load.
• Creating UNIX scripts to run workflows and to maintain Real time workflows Dependency.
• Developed mappings in Informatica to load the Real time data using PWX source along with normal sources. Also developed mappings which involve Mainframe file data extraction using PWX Data maps.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Models and Packages using Framework Manager and published to Cognos Server.
• Developed reports and performance tuning aggregation at the database, indices, Query Optimization and Framework Manager Model improvement were done to improve the report output.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Troubleshooting the problems by checking various logs.
• Involved in unit testing and Integration Testing.
• Created and performed testing strategy and test plans for any changes/upgrade to informatica mappings
• Involved in UAT Support.
• Involved in Peer reviews of LLDs, mappings, Sessions and PWX data maps.
• Monitoring currently running jobs.
• Worked on performance tuning of queries in project.
• Worked in MQ's and channels setup for project.
• Effective Co-ordination with the team to deliver the task with in schedule with Quality
• Co-Ordinating status meetings between offshore and onshore.

Confidential

ETL Technical Lead

Confidential

Technology : Informatica power exchange, Informatica Power centre 8.6 9.0, ESP scheduler, Oracle Exadata,Unix Scripting

Tools : Informatica Power Centre 8.6 9.0, Informatica power exchange 9.0, ESP Scheduler, Harvest

Responsibilities:

• Developing new mappings or making changes in existing mappings according to new business requirements.
• Real time processing of data using Informatica Power exchange which is essential for banking.
• Monitoring the daily warehouse load process and troubleshoot time sensitive job failure issues
• Tuning the Code after verifying the real-time data test results
• Incidents fixing
• Handling adhoc loads
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Working Closely with IGS Informatica Global Support after hot fixes are provided by informatica
• Carry out Impact Analysis for any new changes being pushed to Production.
• Testing and reviewing the deliverables.
• Co-ordinating meetings between offshore and onshore.
• Effective Co-ordination with the team to deliver the task with in schedule with Quality

Confidential

ETL Technical Leader

Confidential

Technology/Tools : Informatica power exchange, Informatica Power centre 9.0, ESP scheduler, Oracle Exadata, Unix Scripting, Harvest, BMC Remedy User, Sales Force

Responsibilities:

• Developing new mappings or making changes in existing mappings according to new business requirements.
• Real time processing of data using Informatica Power exchange which is essential for banking.
• Monitoring the daily warehouse load process and troubleshoot time sensitive job failure issues
• Designed OLAP Reports using most of the Report studio features Conditional Formatting/Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up .
• Tuning the Code after verifying the real-time data test results
• Incidents fixing
• Handling adhoc loads
• Working Closely with IGS Informatica Global Support after hot fixes are provided by informatica
• Carry out Impact Analysis for any new changes being pushed to Production.
• Testing and reviewing the deliverables.
• Co-ordinating meetings between offshore and onshore.
• Effective Co-ordination with the team to deliver the task with in schedule with Quality

Confidential

ETL Developer

Confidential

Technology: Informatica 8.5,Oracle 9i

Tools : Informatica Power Centre 8.5.1, TOAD, Peregrine service centre, Clear Case

Responsibilities:

• Doing production support activities
• Doing root cause analysis for Incidents raised
• Handling adhoc loads
• Developing new mappings or making changes in existing mappings according to new business requirements.
• Carry out Impact Analysis for any new changes being pushed to Production.
• Co-Ordinating UAT testing with stakeholders.
• Co-ordinating meetings between offshore and onshore.

Confidential

Developer

Confidential

Technology: Informatica 8.5, Oracle 9i

Tools : Informatica Power Centre 8.5.1, TOAD, Visual Source Safe

Responsibilities:

• Understanding existing business model and customer requirements.
• Developed mappings using informatica for data flows from Source to Target.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc... In mappings to perform the ETL process.
• Worked on mapping review, if design flaws found as a part of peer testing.
• Created Effective Test Data and Unit Test cases to ensure successful execution of data loading processes.
• Performed Informatica code migrations, testing, debugging and documentation.