SUMMARY

• Around 8+ years of combined Industry Experience as a Data Warehousing Expert and ETL Developer in designing, developing and implementing ETL processes for business applications.
• Extensive experience in analysis, design, development & migration of data warehouse applications.
• Worked on Development, Maintenance, enhancement and support related projects.
• Diversified domain experience in banking domain.
• Working in banking domain for over 5 yrs.
• Demonstrated understanding of Dimensional modeling (Star & Snow flake schema) and other data warehousing concepts.
• Worked on Informatica versions of INFORMATICA 6.1.3, INFORMATICA 7.3.1, INFORMATICA 8.1.1 & INFORMATICA 9.0.1
• Extensive experience in implementing the ETL processes which include developing the data model, designing the change capture and disaster recovery strategies.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica PowerMart/PowerCenter with Teradata & Oracle.
• Experience in automating of the ETL processes for migration and patching Informatica objects.
• Worked with various Power Center/Power Mart components like Informatica Server and Client tools e.g.) Designer, Workflow Manager, and Repository Manager & Workflow Monitor.
• Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.
• Developed shell scripts for invoking Informatica workflows.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
• Extensive experience in formulating error handling mechanism.
• Used Command Line Utility like PMREP, PMCMD.
• Experience in integration of various data sources like Teradata and Oracle.
• Worked extensively on Teradata Utilities like MLOAD, TPUMP, FASTLOAD & FASTEXPORT and also Oracle Stored Procedures, Table Partitions SQL queries and loading data into Data Warehouse/Data Marts using Informatica.
• Involved in upgrading the product from PC 7.1.4 to PC 8.1.1, and also applied PC 8.1.1 SP1, SP2, SP3 and SP4on top of PC 8.1.1.
• Extensively used third party schedulers which include TOAD, AutoSys, Tivoli, Maximo, CA7 & Quality center etc.
• Extensively used various third party version control tools like Source safe & Sub Version tools.
• Excellent communication skills, Good organizational skills, outgoing personality, Self - motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6.x/7.x/8.x/9.x

Databases: Teradata V2R5 & V2R6, Oracle 8.i/9.i/10g.

Data Modeling Tools: Erwin 4.1.

Version Control Tools: Source safe & Sub Version

Languages: SQL, PL/SQL, C, C++, Java

Scripting Languages: Korn Shell, Bash shell scripting

Business Intelligence Tools: Had training on Cognos 7.x, Informatica Power Exchange

Scheduling tools: Autosys and Tivoli

Special Tools: TOAD, Autosys, Tivoli, Maximo, CA7, HP Quality center, Changeman, NDM & File-Aid

Operating Systems: Windows, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

ETL Senior Technical developer/Tech Lead

Responsibilities:

• The bank's 2008 acquisition of Merrill Lynch made Confidential the world's largest wealth manager and a major player in the investment banking industry.
• The company holds 12.2% of all U.S. deposits, as of August 2009, and is one of the Big Four Banks of the United States
• It has clients in over 48 states and 38 countries around the world.
• It has $ 2.25 trillion dollars in total assets by the end of 2009 and 33 million retail customers.
• It is the No. 1 debit card issuer in the United States, with nearly 16 million cards.
• It has the largest proprietary ATM network in USA.

Confidential

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications.
• Involved in designing the system and designing the logical database design using ER Studio.
• Involved in designing the physical database system.
• Involved in data quality and cleansing of data source.
• Involved in creation of database schema and capacity planning of schema for the warehouse.
• Coding as per the mapping/D953 documents.
• Unit testing of the mappings.
• Responsible for migration of applications from dev environment to Test and finally to Production.
• Developed UNIX scripting for data feed files for making ready to processing as per System.
• Scheduled jobs in Autosys scheduler.
• Developing the mapping documents including System of Record field names, Mapping Rules and BI Target field names.
• Discussion of the mapping document with Architects and mapping team to appropriately map Source elements to SCMBI target model and create a D953 design document.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Transmission of the System of Record files from UNIX to SCMBI environment.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases using Quality Center tool of Confidential .
• Defect tracking through Quality Center and SharePoint portal.

Environment: Informatica 9.0.1, Oracle, UNIX, Autosys Scheduler, Sub Version Control Tool.

Confidential

Responsibilities:

• Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
• Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
• Perform analysis of the existing W data to understand the mapping rules in the current environment
• Discussion of the W mapping document with Architects and mapping team to appropriately map ‘The W’ elements to the Banking Data Warehousing (BDW) Model.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Reviewing the BDW mapping document to produce the same data in new environment as in current W.
• Transmission of the System of Record files from mainframes / UNIX to new environment.
• Coding in new environment as per the mapping documents.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases using Quality Center tool of Confidential .
• Defect tracking through Quality Center and SharePoint portal.
• Had training on Datastage tool.

Environment: Informatica 8.6, Teradata V13, Datastage and quality stage Designer, UNIX, Autosys Scheduler.

Confidential

Responsibilities:

• Handling Project Meetings & Perform analysis of the existing W data to understand the mapping rules in the current environment.
• Finalize design, Model and High Level Design and Low Level Design Documents.
• Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
• Coordinating with offshore for Coding Testing and Deployment in prod.
• Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
• Transmission of the System of Record files from mainframes / UNIX to new environment.
• Coding in new environment as per the mapping documents.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases and Defect tracking using Quality Center tool.

Environment: Informatica 8.6, Teradata V2 R5, UNIX, F-SECURE, Teradata SQL Assistant, Autosys Scheduler.

Confidential

Responsibilities:

• Conducting quality reviews for design documents, test plans and operational manuals.
• Analysis of code to resolve data issues raised by clients and end users in the Warehouse.
• Analysis of client supplied documents
• Ensuring that the Bank’s customer and organizational data is been loaded into the Warehouse successfully.
• Meeting the day to day Service level agreements for loading the data into the Warehouse.
• Collection of various process and product metrics (Weekly and Monthly dashboards) for the project from IRIS tool for Bank.
• Monitoring and tracking the project status by using the tool IPMS
• Perform production support tasks such as scheduling, documenting the process, tracking run times, identifying the root causes for the delays for the applications in Production. .
• Identifying the applications consuming more CPU utilization and taking necessary steps to so that these applications don’t bring down the production servers.
• Planning and Managing the application runs during planned and unplanned outages for production servers such as Informatica Servers, UNIX servers, database servers and coordinating for the outages to completion and completing the applications within SLA.
• Monitoring the Production environment and sending notifications to the respective person/team in case of server performance going down.
• Analyze the applications to the code level and identify area of performance improvement and identify areas which can reduce UNIX space utilization.
• Coordinate for the new applications that are moving into Production with development team for initial run issues, knowledge transition to the support team and defining the process for the same..
• Resolve user queries and close Help desk tickets with the data issues.
• Lead the team on the W’s Teradata Upgrade activities for 5 times since . Once in 2007 Oct, twice in 2008 & twice in 2009. Among 5, the July 2009 upgrade was a very big upgrade exercise planned. It had focus of Bank senior management up to the level of Bank’s 3-dot hierarchy managers. Lead successfully the team in accomplishing the time for which entire team including myself got several appreciations from top level managers.
• Worked on the ECRIS Disaster recovery activates for Informatica applications in May and September 09.
• Analysis, coding, testing and Production migration to the enhancements with 40 person hrs effort.
• Document the new processes track the application runs in production resolve data user queries and coordinate with source team to complete the application run in production within SLA (Service Level Agreement) time.
• Conduct quality reviews of code / test plans.
• Lead teams successfully for establishing the IPG and EPE (Early proj engagement) process in the project. IPG (Inventory Processing group) Project is a internal Bank project which keeps track of all the application inventory details in a database and I was leading a team in making this process established for Informatica appl. EPE is a documentation process for all incoming new or changes to existing appl for effectively gathering the information so that the support for the appl is much more organized and stream lined.

Environment: Informatica V7.1.3, Informatica 8.1.1, UNIX Shell Scripting, Teradata V2R5, F-SECURE, SQL Assistant V7.1, Tivoli scheduler JSC 1.3, SunOS 5.10, Peregrine Service center V6.1.3.3.

Confidential

ETL Technical Developer

Responsibilities:

• To do impact analysis for new requirements and prepare the Low level design for new initiatives.
• Analysis of requirements for finding any ambiguity, incompleteness or incorrectness
• Involved in Enhancement and coding of the mappings
• Document the new processes and methodologies
• Conduct quality reviews of code / test plans.
• Have good hands on in performance tuning of Informatica mappings, identifying bottlenecks and eliminating bottlenecks in Informatica mappings.
• Have good hands on in developing UNIX shell scripts for handling files, formatting files for reading data from flat files through Informatica.

Environment: Informatica V6.2, UNIX Shell Scripting, Oracle 9i, F-SECURE, TOAD v7.5.2.0 scheduler tool.

Confidential

Team member

Responsibilities:

• Involved in the migration of Data using the MAXIMO data migration tool.
• Involved in reports generation using Actuate e-report generator.

Environment: MS SQL server 2000, Maximo data migration software, Actuate e-report developer tool.