PROFESSIONAL SUMMARY

• 9+ years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, analysis, designing, development, implementation, Maintenance, testing and Data Warehousing implementations across various domains.
• Experience in Project Analysis, Design, Development, Testing, Implementation and Maintenance of business application systems for Financial, Insurance and Health care Sectors.
• Sound experience in Data Warehousing ETL and Reporting experience of using Informatica Power Center 9x/8.x/7.x (Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Task Manager), Informatica Power Mart, Cognos8x, MS SQL Server 2000 /2005/2008.
• Extensive experience in creating theMappings, Mapplets, Reusable transformations Workflows, Worklets,and scheduling theWorkflows and sessionsusingInformatica Power Center.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Implemented error handling through Informatica. Worked with Teradata Utilities, external loaders in Informatica to optimize the ETL Load
• Designed and developed complex mappings using different transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more
• Excellent Knowledge of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, Relational, DB2, Teradata and SQL Server using Informatica
• Involved in the design of Multi - Dimensional Data Modeling (Star, Snow Flake schema) using Erwin, MS-Visio
• Experience in coding using SQL, PL/SQL. Implemented Stored procedures, functions, packages and exception handling using PL/SQL
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect).
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder
• Sound knowledge in Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Having Good Knowledge in Reporting tool Cognos8,Business objects in developing Standard reports, List, Crosstab reports, Prompts, Charts, Master Detail Reports, drill through reports, Report Template and Adhoc Reports in query studio
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts as per specific business requirements.
• Having knowledge of writing test plans and working with HP Quality center forexecuting the test plans, fixing the bugs and defects raised during testing
• Have Good communication skills, excellent analytical, problem solving skills with astrong technical background and good interpersonal skills with strong ability to

TECHNICAL SKILLS

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

OLAP Tools: Cognos 8/8.4, Business Objects (BOXI R2),OBIEE

Database: Oracle 8i/9i/10g, SQL server, PL/SQL, TeradataFlat files, XML, Cobol files, DB2, AS/400 and Ms Access

Programming Languages: C, RDBMS, XML, SQL, PL/SQL, Shell Scripting

Operating Systems: Windows XP/2000/NT/9x, Windows 98, UNIX (Solaris)LINUX

Document Tools: MS Office 2003/2007, MS Project 2003/2007, Erwin, Visio

Web Technologies: HTML, Java Script

Tools: & Utilities TOAD, EDITPLUS, AUTOSYS,TIDAL

PROFESSIONAL EXPERIENCE

Confidential, VA

ETL Informatica Consultant

Roles and Responsibilities:

• Involved in design, development, integration, deployment/production support & other technical aspects of the development of, modification to the applications
• Working with Project Managers, Architects, Designers, Analysts, Programmers, System Analysts, and Testers to ensure development requirement are properly documented as per SDLC standards. Involved in peer to peer reviews
• Involved in model management process to make the DDL changes for the Edward through the development of the logical and physical data integration models in teradata database.
• Created Informatica source-to-target mapping using different transformations to implement business rules to fulfill the data integration requirements
• Prepared BTEQ scripts to load data from Staging to Edward area.
• Lead team of developers, allotted work, resolved issues, was an active bridge between data modeler business users and developers in offshore and onsite. Trained new members to bring up speed.
• Provided project estimates, coordinated the development efforts and discussions with the business partners, updated status reports and handled logistics to enable smooth functioning of the project and meet all the deadlines.
• Updated numerous Bteq/Sql scripts, making appropriate DDL changes and completed unit and system test.
• Uploaded data from operational source system (Oracle 8i) to Teradata. Working with different files (Flat files, mainframe, Cobol files) to load data to teradata target system using informatica and BTEQ scripts.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts
• As part of RIM,s team, fixing the production issues for different source systems in membership subject area.
• Converting data integration models and other design specifications to Informatica source code
• Developing and maintaining the Informatica and Teradata objects. Involved in peer to peer reviews
• Worked extensively on performance improvement & query tuning tasks Teradata (BAO) BTEQ
• Involved in providing user support for executing System Integration Testing & Acceptance Testing
• Performing unit testing and responsible for System Integration testing, Regression testing until it moves to production
• Performing data profiling in different subject area applications. Developing BTEQ application from the Atomic and Semantic Layers

Environment: Informatica 9.1,Teradata R12 /R13, Flat files, COBOL files, Teradata SQL Assistant, BTEQ, MLOAD,FLOAD, Fast Export, Shell Scripts, AIX, Rational Clear Case, Windows XP WLM and Erwin.

Confidential, VA

ETL Informatica Consultant

Roles and Responsibilities:

• Involved in design, development, integration, deployment/production support & other technical aspects of the development of, modification to the applications
• Working with Project Managers, Architects, Designers, Analysts, Programmers, System Analysts, and Testers to ensure development requirement are properly documented as per SDLC standards. Involved in peer to peer reviews
• Involved in model management process to make the DDL changes for the Edward through the development of the logical and physical data integration models in teradata database.
• Created Informatica source-to-target mapping using different transformations to implement business rules to fulfill the data integration requirements
• Prepared BTEQ scripts to load data from Staging to Edward area.
• Lead team of developers, allotted work, resolved issues, was an active bridge between data modeler business users and developers in offshore and onsite. Trained new members to bring up speed.
• Provided project estimates, coordinated the development efforts and discussions with the business partners, updated status reports and handled logistics to enable smooth functioning of the project and meet all the deadlines.
• Updated numerous Bteq/Sql scripts, making appropriate DDL changes and completed unit and system test.
• Uploaded data from operational source system (Oracle 8i) to Teradata
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Involved in peer to peer reviews
• Converting data integration models and other design specifications to Informatica source code
• Developing and maintaining the Informatica and Teradata objects
• Worked extensively on performance improvement & query tuning tasks Teradata (BAO) BTEQ
• Involved in providing user support for executing System Integration Testing & Acceptance Testing
• Performing unit testing and responsible for System Integration testing, Regression testing until it moves to production
• Performing data profiling in different subject area applications. Developing BTEQ application from the Atomic and Semantic Layers

Environment: Informatica 9.1,Teradata R12 /R13, Flat files, COBOL files, Teradata SQL Assistant, BTEQ, MLOAD,FLOAD,FAST EXPORT, Shell Scripts, AIX, Rational Clear Case, OBIEE,Windows XP and WLM

Confidential, NY

ETL Programmer Analyst

Responsibilities:

• Extracts data from Flat Files and Oracle databases and applies business logic to load them in the central Oracle database.
• Develops map, reusable objects, transformation, and Mapplets using Mapping Designer, transformation developer and Mapplets Designer in Informatica PowerCenter 7.1.1/8.6.1.
• Upgrades from Informatica version 7.1.1 to 8.6.1.
• Creates reusable transformations and Mapplets and uses them in mappings.
• Uses Informatica PowerCenter 8.6.1./7.1.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Works with data modelers to prepare logical and physical data models and adds and deletes necessary fields using Erwin.
• Implements Informatica recommendations, methodologies and best practices.
• Worked with various transformations like aggregators, filters, connected and unconnected lookups, joiners, normalizers, source qualifiers, application source qualifier, update strategy etc.
• Implementations are populated slowly to change dimension to maintain current information and history information in dimension tables.
• Uses Informatica PowerCenter Workflow manager to create sessions and batches to run with logic embedded in the mappings.
• Creates folders, users, repositories, and deployment group using Repository Manager.
• Works with different data sources such as Oracle, SQL Server, and Flat Files.
• Creates complex mappings in PowerCenter Designer using aggregate, expression, filter, and sequence generator, update strategy, union, lookup, joiner, XML source qualifier and stored procedure transformations.
• Uses transformations such as router, aggregator, normalizer, joiner, expression, lookup, update strategy and sequence generator, and procedure.
• Uses SQL and Java transformations.

Environment: InformaticaPowerCenter 9.0.1/8.6.1/7. xAutosys,Oracle11g/10g,TeradataV2R6,Siebel,EI,starteam,TOAD,SQL*Plus, Windows, UNIX, Shell Script, AS 400

Confidential

ETL Developer

Responsibilities:

• Involved in analysis, requirement gathering, developing, testing and maintenance. Interacted with business analysts, data architects to understand the data model.
• Involved in creating comprehensive Technical and Mapping Design documents for the project and redeign the exiting mapping to implement the enhancement
• Developed an enterprise-wide policy Claims warehouse to view Claims, Inbound and Outbound Transactions details of all employees for the client in Annuities section.
• Responsible for coding of mappings and unit testing and integration testing. Prepared mapping specification documents for the same.
• Worked with different data sources such as Oracle, XML, SQL Server, DB2, Flat files.
• Worked with XML parser and split the mapping into flat files for performance tuning and got appreciation for the work done.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Performed activities including design of Exception handling strategy and performance tuning of custom stored procedures in PL/SQL.
• Worked with Pushdown Optimization technique to increase the performance and increase productivity.
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Extensively worked on Informatica Power Center - Mapping Designer & Mapplets, and Transformations, Reusable Transformations, Workflow manager, Repository manager, Workflow Monitor, Sessions, workflows.
• Worked with various transformations like aggregators, filters, connected and unconnected lookups, joiners, normalizers, source qualifiers, application source qualifier, update strategy etc.
• Created many reusable transformations using lookups, expressions etc.
• Developed both usable and reusable tasks like Session, Email, Decision, Assignment, Command, Event Wait and Event Raise.
• Designed and developed UNIX scripts for scheduling the jobs and generating parameter file automatically and good knowledge of Autosys job scheduling system.
• Used pmcmd command to schedule workflows.
• Developed Standard reports, Ad hoc and drill through reports in Business objects
• Received numerous letters of recommendation, appreciation from customers and Business Management for the performance and almost all my developments went live as FTR (First Time Right) in the project.

Environment: Informatica 9.1, Business objects, Flat files, XML, Oracle 10g, SQL Server, UNIX, Visio, TOAD, PL/SQL, Autosys, IDQ and SQL*Loader

Confidential

ETL Informatica Developer

Responsibilities:

• Performed business analysis and requirements per high-end users and managers and performed requirement gathering.
• Worked as Senior Associate for a year and proactively helped in fixing tickets with priority to team as part of production support.
• Developed an enterprise-wide policy Vouchering data warehouse to analyse the voucher hours of all employees for the client.
• Responsible for coding of mappings and unit testing and integration testing.
• Used SQL*Loader to first write the target rows to a flat file and then upload the data to the tables in the Oracle database.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Worked on various kinds of the transformations which were used to implement simple and complex business logic.
• As report author, Designed Standard reports, Ad hoc and drill through reports based on client requirements.
• Creating List, Crosstab reports using the published package
• Adding Filter to reports, Created prompts and passing parameters.
• Created Adhoc reports in query studio and also shared knowledge with users on Adhoc reporting to generate reports as per the business need.
• Tested all the developed reports once it is done.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target tables in warehouse using InformaticaWorkflow Manager..
• Tuning InformaticaMappings and Sessions for optimum performance.
• Designed and developed UNIX scripts for scheduling the jobs and generating parameter file automatically.
• Translated business requirements into Informatica mappings/workflows.
• Worked with various transformations like aggregators, filters, connected and unconnected lookups, joiners, normalizers, source qualifiers, application source qualifier, update strategy etc.
• Created many reusable transformations using lookups, expressions etc.
• Designing technical specification document for all the developed mappings.
• Co-ordinated among various teams like DBA, UNIX, Ops and testing team to get the database and UNIX environment setup for the release.
• Created and maintained all the release documents and migration forms for tracking reasons.Worked in Production Support environment for the previous ongoing projects.

Environment: Informatica8.1,Cognos8, Flat files, Oracle 9i, SQL Server, UNIX, TOAD, PL/SQL and SQL*Loader

Confidential

ETL Application Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development and testing. Interacted with business analysts, data architects, application developers to understand the data model.
• Developed Data warehouse to view financial datal on year to date snapshot.
• Extensively worked on Informatica 7.1 and its tools; Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.
• Designed the strategies to load the data into the target Data warehouse. Responsible for design, developing and implementing the batch ETL system using UNIX scripting and Informatica.
• Fixing tickets as part of production support and Ensuring On time Delivery.
• As report author, generated new simple list reports, Crosstab reports based on client requirements.
• In Report net created new reports as per the user requirements and got appreciation from customers and management for the enhancements made.
• Added Filter to reports, Created prompts and passing parameters.
• Scheduled reporting as per the business needs and also modified prompts to schedule few reports.
• Fixing in complex data type issues, Performance tuning tasks and formatting issues always before the deadline.
• Implementation/Deployment of minor Enhancements/Changes Requested in Reporting and ETL.
• Implemented Slowly Changing Dimensions (SCDs, Type 1, Type 2 and Type 3).
• Worked with Oracle, Teradata, Relational, SQL Server and flat file sources.
• Developed both usable and reusable tasks like Session, Email, Decision, Assignment, Command, Event Wait and Event Raise.
• Performed Exception Handling and executed Stored Procedures and Functions using PL/ SQL.
• Used SQL*Loader for bulk loading the data into the target tables.
• Implemented Performance Tuning for transformations to increase the session performance time.
• Used TOAD 8.0 to analyse the execution of SQL queries for performance tuning purposes.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Used session and workflow error logs to debug the session and find problems in the mapping.
• Attending status meetings and swat calls.
• Good understanding with all the team members for performing support work effectively
• Always tried to meet the client expectation by completing the work before the Deadline.

Environment: Informatica 8.1, Cognos 8, Oracle 8i/9i, Unix, Windows XP, TOAD 8.0, SQL Server 2000, SQL*Loader, PL/SQL

Confidential

Software Engineer

Responsibilities:

• Understanding existing business model and customer requirements.
• Worked on Informatica Power Center 7.1 tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• Developed InformaticaMappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Utilized aggregate, expression, lookup, update strategy and router transformation. Utilized joiner transformation to extract data from multiple sources.
• Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Used Utilized InformaticaServer Manager to create, schedule and monitor sessions and send pre and post session emails to communicate success or failure of session execution. Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Provide technical support to Quality Assurance team and Production group. Used Repository Manager to add Repository, to create folders, User groups, Users and managed users by setting up their privileges and profiles. Troubleshoot problems by checking session’s logs.
• Generated new simple list and crosstab reports based on clients requirements.
• Developed Prompts for filtering the data
• Worked on drill through reports and scheduled reports.
• Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Designing technical specification document for all the developed mappings.
• Worked on Change Requests (CR) while integration testing and UAT are in progress
• Has Successfully met 100% SLA in all the tasks assigned to me

Environment: Informatica 8.1, Cognos 8, Windows XP, Oracle 9i,, TOAD 8.0, SQL Server 2000, SQL*Loader, PL/SQL

Confidential

Associate

Responsibilities:

• Involved in designing the specifications, design documents, data modeling and design of data warehouse.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Participated in Migration Applications in Cognos8.
• Actively shared the multiple projects functional specification knowledge with clients in data warehousing.
• Have worked on Proof of concepts in Data Warehousing, Reporting and ETL with different case study’s.
• Received numerous letters of management for the POC’s made and received accolades from Business Management for the performance in the project
• Created InformaticaMappings to load data using transformations.
• Implemented Slowly Changing Dimensions (SCDs, Both Types 1, 2).
• Cleansed the source, extracted and transformed data with business rules, implemented Boolean logic to address complex business requirements, and built reusable transformation logic, known as ‘Mapplets’ using InformaticaDesigner.
• Involved in the development of Informaticamappings and also performed tuning for better performance.
• Extensively worked on tuning and thereby improving the load time.
• Extensively used PL/SQL for creating packages, procedures and functions.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Tested the target data against source system tables by writing some QA Procedures.
• Created documentation for the Informatica processes, naming conventions and best practices.
• Shared Knowledge through sessions to ELTP’s. Conducted Competency tests to business unit’s associates based on their domain for testing knowledge.

Environment: Informatica 7.1, Cognos 8, BOXIR2,Oracle and Windows XP.