SUMMARY

• 9+ Years of Techno Functional experience in BFSI including real time banking, Business Analysis, SQL, PL/SQL Programming, ETL Informatica Development/Testing and Project Management..
• Ability to analyze source data for potential data quality issues and addressing these issues in ETL procedures.Worked extensively with Debugging and tuning of ETL processes to improve the overall performance.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in SQL, T - SQL, PL/SQL Programming (Packages, Stored Procedures, Functions and Triggers).
• Experience in different areas of Data warehousing, RDBMS, Data modeling, Data extraction, Data acquisition, Analysis, Application design, Development and Implementation of data warehousing, business Intelligence system using Informatica Power Center, Data Conversion and various business applications in different platforms
• Experience in developing Unix Shell Scripts for scheduling Informatica jobs.
• Informatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1 Oracle 11g/10g/9i (SQL/PL/SQL). Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Finance and Insurance industries.
• Used various Informatica Transformations like Filter, Sorter, Router, Union,
• Aggregator, Normalizer, Lookup, Joiner, etc…
• Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source (Oracle, MS SQL Server, DB2, Teradata, XML and Flat files) and target.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in Implementing Slowly Changing Dimension Tables
• Strong understanding of OLAP and OLTP concepts
• Good understanding of data warehousing concepts, Star Schema and Snow-flake Schema
• Experienced in various testing levels
• Experienced in writing Complex SQL Queries like Unions, Joins
• Experienced in team management, resource Planning and Onsite/Offshore coordination
• Extensive knowledge with Teradata SQL Assistant.
• Good communication and interpersonal skills and Strong understanding of ETL best practices.
• Assigning work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.
• Knowledge of Advanced Programming for data transformation (JAVA) Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle, DB2 into a common target area such as Data Marts and Data Warehouse.
• Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process.

TECHNICAL SKILLS

Operating systems: Windows, UNIX, Linux,MS-DOS

RDBMS: Oracle 11g/10g/9i/8i, My SQL,PL SQL, DB2,MS SQL Server 2000/2005/2008

Modeling: Dimensional Data Modeling, Star and Snow-Flake schema Modeling

QA Tools: Win Runner, QuickTestPro, Test Director, Quality Center

ETL Tools: Informatica Power Center

Reporting Tools: Business Objects,OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Columbus,OH

ETL\ Informatica Developer

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server and DB2.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Developed and Implemented Error Handling Strategies.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes. Created test cases and completed unit, integration and system tests for Data warehouse
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator.
• Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension to keep the history changes.
• Responsible for tuning ETL procedures to optimize load and query Performance
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Trouble shoot connectivity problems, Looked up and read session, event and error logs for troubleshooting
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area XML files and relational tables.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Developed and maintained Reports using Business Objects.
• Involved in Designing BO reports & Universe & guiding designers and developers for each component.
• Generated, published and scheduled reports in Web Intelligence.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Worked closely with the testing team for the testing of maps.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.
• Worked on Pre-Production and Post-Production Issues

Environment: Informatica Power Center 9.1((Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, Oracle11g/10g,SQL, PL/SQL, UNIX,SQL Server 2008, MS Office, Putty, WinSCP, Toad, HP Service Center, HP Service Manager.

Confidential

System Analyst (ETL\Informatica)

Responsibilities:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in analysing the business requirements and functional specifications
• Extensively worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• 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
• Used Incremental method strategy for all Informatica mappings
• Designed the source to target mappings that contain the business rule for the extract, transform and load process using Informatica ETL Tool
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Written SQL Queries to cross validate data in both source and target databases
• Testing the Informatica Objects. Written Unit test scripts to test the developed interfaces.
• Created mapplet and used them in different mappings. Involved in fixing invalid mappings. Created High Level Design and mapping documents
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functionsand involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Provided support for the production department in handling the data warehouse.
• Written thorough design docs, unit test documentation, Installation and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views and queries.

Environment: Informatica Power Center 9.1, Oracle11g/10g,SQL, PL/SQL, Win XP

Confidential, Chicago, IL

Part of Tech Development & Project Mgmt Team

Responsibilities:

• Developed mappings in Informatica Designer to extract data from Heterogeneous sources like Relational Databases, Flat Files and Spread Sheets with various transformations like Filter, Sorter, Router, Expression, Normalizer, Lookup etc..
• Developed UNIX Shell scripts for getting data from various source systems to Data Warehouse
• Tracking the session output through log files using session manager
• Involved in creating Tables, Views, Constraints and Indexes
• Developed SQL Scripts for data verification at the backend
• Project plan preparation for all the minor enhancements and small projects and obtaining approval from client
• Team Management and Capacity planning for pipeline projects on resource requirement
• Testing the Informatica Objects before moving into production
• Onsite/Offshore coordination

Environment: Informatica Power Center 9.1, Oracle11g/10g,SQL, PL/SQL, Web Application, Win XP

Confidential

Analyst

Responsibilities:

• Understanding the FSD
• Providing KT on requirements to Offshore
• Creating and maintaining Requirement Traceability Matrix
• Involved in Mainframe and ETL Informatica/Database Testing
• Acted as an interface between client and offshore team

Environment: Informatica Power Center 8.x, Oracle11g/10g,SQL, PL/SQL, Vision Plus

Confidential

Deputy Manager - Business Analytics

Responsibilities:

• Preparation of various analysis on AR & P/L portfolios for Cards, Insurance and Retail Assets using Oracle SQL queries and Informatica Powercenter
• Preparation and presentation of Various Business trend Analysis reports
• Providing Portfolio Performance Reports to Business Intelligence Unit which will be used in framing strategies for new business enhancements and opportunities
• Development of SQL Scripts to prepare Strategy to identify the Delinquent Cards
• Involved in creating Tables, Views, Constraints and Indexes
• Proficient in creating Procedures, Functions, Packages and Triggers
• Designing of MIS Reports as per the requirements of Management
• Development of dashboards, reports and OBIEE repository
• Testing new enhancements on the existing application to provide user acceptance
• Involved in populating the staging tables from multiple source systems

Environment: Informatica Power Center 7.x/8.x, Oracle8i, OBIEE, Vision Plus, Main Frame