PROFESSIONAL SUMMARY

• 7+ 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.
• Knowledge in creating Base objects, Landing tables, Staging tables, foreign key relationships, mappings, Lookups and cleansing functions in Informatica MDM.
• Extensive knowledge on Creating and defining Entity objects, Hierarchies, entity type and relationship objects and relationship types using Hierarchy tool
• Exposure to Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• 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 toperform part of a team.

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, Teradat

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

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

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

Web Technologies: HTML, Java Script

Tools & Utilities: Informatica MDM 9.x, TOAD, EDITPLUS, AUTOSYS,TIDAL

PROFESSIONAL EXPERIENCE

Confidential, VA

Informatica Consultant

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 in agile methodology. 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.
• Involved in the design of Multi-Dimensional Data Modeling (Snow Flake schema) using Erwin tool.
• 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
• Knowledge in creating Base objects, Landing tables, Staging tables, foreign key relationships, mappings, Lookups and cleansing functions in Informatica MDM.
• Extensive knowledge on Creating and defining Entity objects, Hierarchies, entity type and relationship objects and relationship types using Hierarchy tool
• Exposure to Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• 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

Informatica Consultant

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 agile methodology. 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.
• Involved in the design of Multi-Dimensional Data Modeling (Snow Flake schema) using Erwin
• 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.
• Knowledge in creating Base objects, Landing tables, Staging tables, foreign key relationships, mappings, Lookups and cleansing functions in Informatica MDM.
• Extensive knowledge on Creating and defining Entity objects, Hierarchies, entity type and relationship objects and relationship types using Hierarchy tool
• Exposure to Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• 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, Erwin 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 PowerCenter7.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.
• Involved in Scrum meetings on daily basis as part of SDLC Methodology.
• Involved in the design of Multi-Dimensional Data Modeling (Star & Snow Flake schema) using Erwin
• 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: InformaticaPowerCenter9.0.1/8.6.1/7.xAutosys,Oracle11g/10g,TeradataV2R6,Siebel,EI,starteam,TOAD,SQL*Plus, Windows, UNIX, Shell Script, AS 400

Confidential, TX

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 warehouse to view risks, 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.

Confidential

Software Engineer

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

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.
• 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.