SUMMARY

• Over six years of IT experience in the Software Development Life Cycle (SDLC)Business Requirements Analysis, Application Design, Development, Data Modeling, Implementations and Testing of Data warehousing and Database business systems for Insurance, Health Care and Financial Industries.
• Over Six years of experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.1/8.6/8.1/7.1, Informatica Power Exchange 9.1/8.1, Oracle 11g/10g, SQL Server 2x, SQL and PL/SQL.
• Extensive experience in Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
• Over threeyears of Experience in designing OLAP data and creating entity relational & dimensional relational data models with warehousing methodologies like Star & Snow flake schema architectures, Fact/dimension tables.
• Proficient in Implementation of Data warehouse from Requirement gathering, Data Analysis, data modeling, Application Design, development and data cleansing.
• Over sixyears of database experience using Oracle 11g/10g/9i/, MS SQL Server 2008/2000/7.0, DB2 8.0, SQL, PL/SQL andwriting Stored Procedures, Packages, Functions and Triggers.
• Over 1 years of experience in Teradata using queries and utilities like BTEQ, MLOAD, FLOAD and TPUMP.
• Experiencein generating various reports using Business Intelligence tool OBIEE 11g/10g.
• Experience in creating efficient and effective High and LowlevelETLdocument.
• Extensively worked on Informatica and SQL performance tuning.
• Worked on End User Training and production support.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Excellent communication & written skills, capable of working successfully both in teams and independently.
• Worked on Effort Estimation, coordination with various teams, Clients, Users, Onsite team and offshore team and Tracking work progress.
• Ability to self - manage time and task priorities to meet project timelines, and identify potential project risks.
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Worked on debugging and performance tuning of sources, targets, mappings, transformations and sessions.
• Extensively used Slowly Changing Dimension (SCD) technique in insurance application.
• Exposure in overall SDLC including requirement gathering, data modeling (Erwin 4.x/3.x), development, testing, debugging, deployment, documentation, production support.
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling and communicating with Server using pmcmd.
• Excellent analytical, problem solving and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Modeling: Informatica Power Center 9.1.8.x/7.x, Informatica Power Exchange 9.1,8.1, Erwin 7.1/4.x.

Databases: Oracle Exadata/11g/10g/9i, MS SQL Server 7.0/2000, MS Access. DB2 8.0/7.0 and Developer 2000, Teradata 14/13 DB2.

Programming: VB6, C, C++, SQL, PL/SQL, HTM,UNIX Scripting

Operating systems: Windows 98/NT/2000/XP,MAC, Sun Solaris, UNIX, MS-DOS

Reporting/Scheduling tools: OBIEE 11g/10g, ESP

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Informatica Developer

Responsibilities:

• Interacted with functional analysts to understand requirements and involved in preparing high-level design documents.
• Extensively used ETL to transfer data from source files and load the data into the target database.
• Extracted the data from the flat files into staging area and populated onto Data Warehouse.
• Prepared Low Level Design (LLD) documents as per the business requirements.
• Developed Mappings & Workflows as per Business logic, quality and coding standards prescribed for the module.
• Data Quality Analysis to determine cleansing requirements. Responsible for populating the business rules using mappings. Understand the business needs and implement the same into a functional database design.
• Developed number of complex mappings using connected - unconnected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, normalizer, sequence generator, Update Strategy, Transactional Control, SQLT Transformations, mapplets to implement the business logic and load the data incrementally
• Handled slowly changing dimensions of Type1, Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Documented Mappings, Transformations and Informatica sessions for further maintenance and support.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Created Power Exchange Registration for CDC on DB2 mainframe tables, created DataMap to extract data from file on mainframe.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Worked on OBIEE Answers to create the reports as per the client requirements and integrated them into the Dashboards.
• Prepared Unit Test Plan (UTP) documents for all the test cases for the developed mappings.

Environment: Informatica Power Center 9.1, Oracle 11g, Teradata 14, DB2, OBIEE 11g, Flat files, PL/SQL, SQL, Erwin 7.5, Toad 7.0, Remedy, ESP.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Involved in Data Analysis to extract useful data, finding patterns and regularities from the sources and develop conclusions.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Actively involved in Data Warehouse system design discussions.
• Extensively used various transformations like LookUp, Update Strategy, Joiner, Aggregator, Union and few other transformations.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing Delta loads.
• Involved in creating Fact and Dimension table mappings to load Fact and Dimension tables.
• Developed Slowly Changing Dimension (SCD) Type1, Type2, and Type3 mappings.
• Worked with Reusable Mappings (Mapplets), Reusable Workflows (Worklets) and Reusable Transformations.
• Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the workflows and session failures.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Worked with tools like TOAD to write queries and generate the result.
• As per the requirement, performed Initial loading,monthly loading and monthly cleanup update processing.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Used SQL Override in Source qualifier to customize SQL and filter data according to requirement.
• Wrote PRE and POST SQL commands in session properties to manage constraints that improved performance.
• Performed Pushdown Optimization to increase the read and write throughput
• Wrote SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Document all ETL related work per company's methodology.
• Used OBIEEDAC to Schedule the Informatica mappings in the correct order, dependencies between them based on the sources and targets.
• Involved in system end to end testing (Unit and System Integration Testing) as part of the SDLC process and performance tuning at the mapping level, session level, source level, and the target level.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.

Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Windows XP, Oracle 10g, DB2, PowerExchange 8.6, Teradata 13, TOAD, PL/SQL Developer, SQL Plus, OBIEE 10g, Sun Solaris.

Confidential, New York

Datawarehouse Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Performed Informatica Administrator functions like created repository, Groups Users, Folders, giving permissions on the folders to the users, etc.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL &database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator etc.
• Interacting with Users and participating in gathering the requirements.
• Worked extensively with designer tool to develop Mappings, Mapplets, and Reusable transformations to extract, transform and load the data.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Check and Tune the performance of application for optimum system performance.
• Developed and scheduled Workflows using Workflow Manager.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Mapping spreadsheets, issues, assumptions, configurations, and Informatica code details, shell scripts etc. and attended meetings with the clients for the Approval of the process.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PLSQL, flat files, XML, Putty, Sql Server 2003, Linux, Harvest.

Confidential, Atlanta, GA

Data Warehouse Developer

Responsibilities:

• Involved in designing and customizing logical and physical data models for Data warehouse supporting data from multiple sources on real time.Involved in analysis, solution and low-level design.
• Worked in the data mapping, designing phase and deploying the mappings
• Used Star Schema approach for designing of Data Warehouse using Erwin.
• Designed and developed Informatica mappings, enabling to Extract, Transform and Load the data into target tables.
• Extensively worked on Informatica Designer and Workflow Manager.
• Extensively used almost all of the transformations of Informatica including source qualifier, expression, filter, aggregator, rank, Lookups, Stored Procedures, sequence generator, joiner, Update Strategy and others.
• Worked with Memory cache for improving throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Developed Slowly Changing Dimension (SCD) mappings.
• Developed Sessions, Worklets using Informatica Workflow Manager.
• Extensively worked in the Performance tuning of the Programs, Procedures and Processes.
• Translated business requirements into data warehouse design.
• Worked in modules with relational E/R and Dimensional data modeling in large transaction.
• Worked on technical Documentation of existing and proposed models.
• Worked closely with DBA and developers during planning, analyzing and testing phase of the project.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, Views, Indexes, sequences and Users. SQL coding for problem resolution and performance optimization
• Participated in identifying scope of the project, planning and development with other team members.
• Analyzed, enhanced and maintained Data Warehouse systems using RDBMS database and Informatica tools.
• Worked with various IT and management teams with the schedule.
• Prepared test cases and performed Unit testing. Created test cases and test scenarios and documented actual results; involved in system testing of overall processes; compared actual results to expected results; and wrote Test Plans and created Test Cases effectively using Quality Center.
• Worked on data cleansing and query tuning. Involved in analyzing the source data coming from different data sources like Oracle, Flat Files, XML and SQLServer and identifying data anomalies in operational data.
• Trouble shot development related issues, which arose at the time of UAT.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Used mapping Parameters and Variables to pass the values between sessions.
• DevelopedInformaticaMappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Environment: Informatica PowerCenter 7.1, Windows 2000, Oracle 10g, SQL Server 2000, MS Suite, AIX.