SUMMARY

• An articulate Informatica Data Quality Consultant with vast 9 years of extensive experience on Informatica Data Quality IDQ and Informatica PowerCenter with strong business understanding and knowledge ofExtracting, Transforming and Loading of data from heterogeneous source systems like Oracle, SQL Server, Flat files, Excel, XML, UDB, Sybase.
• Total 14years of experience with proficiency in software analysis, consultancy, design, development, delivery & project transition.
• Understing in logical and physical data modeling of staging and warehouse environments using Datamodeling tools like ERWin, Rational Rose and Oracle Designer.
• Extensively involved in ETL Data warehousing using InformaticaPowerCenter 7.x/8.x/9.x Developer tool, Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi - table joins
• Experience in scheduling the batch jobs using workflow monitor, ESP, Tivoli, Autosys and FTP methods.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scriptsto automate the process of loading, pushing and pulling data from different servers.
• Good experience in performingUnit testing andsupporting System Integration testing (SIT), UAT and production support for issues raised by application users.

TECHNICAL SKILLS

ETL Tools: Informatica Data Quality IDQ 9.x / 8.x, Informatica PowerCenter 9 / 8.x / 7.x

RDBMS: Oracle11g/10g/9i, SQL Server 2005/2008/2010, Teradata V2R5

BI Tools: Business Objects XI R2/R1/6.x, IBM Cognos

Operating System: HP UNIX, IBM AIX 4.3/4.2, Windows NT/2000/XP/7

Job Scheduling Tools: Cisco TIDAL 6.x, Tivoli 7x, Autosys 4.5

Defect Management Tools: HP Quality Center 9.1, Test Director 7x, Remedy 7x

Languages: SQL, PL/SQL, Unix Shell Scripting, XML, C, C++, C#, JavaScript.

Modeling Tools: ER Studio, Erwin 4.1, UML

Database frontend Tools: Quest Toad for Oracle, Oracle PLSQL Developer, Aqua Data Studio 8.0.7, DB Artisan.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Data Quality (IDQ) Consultant

Responsibilities:

• This is a Auto Trader Group (ATG)’s data quality project to find the Unresolved duplicate records, and find the Discrepancy between primary and secondary dealer records.
• Involved in analyzing the ATG Oracle based databases as well as Flat file sources to figure out data quality issues.
• Responsible for working with Business personnel to gather the business needs to be implemented.
• Working with Project Manager, attending daily standup calls and providing project progress.
• Informatica Developer 9.6.1 tool is being used to create various mapping to validate and / or clease the data.
• Informatica Analyst 9.6.1 tool used to profile the all source files and to review the Human Task.
• Responsible for migrating and recreating 9.1 version based mapping in to the 9.6 version mapping.
• Used ExceptionStep and ReviewStep for generating bad records. Also, using Human Task, Mapping Task created a workflow for manual review for Business personnel using Analyst tool. Moreover, used ClusterSteps to generate duplicate record cluster for manual review.
• Project in the domain of Auto Industry.

Environment: IDQ Informatica Developer Tool 9.6.1 HF3, IDQ Informatica Analyst Tool 9.6.1 HF3, InforamtiaPowerCenter 9.6, Oracle 11g, Oracle SQL Developer 4.

Confidential, MA

Informatica Data Quality (IDQ) Consultant

Responsibilities:

• This is a RMV’s ALARS project which is a mordenizaiton project for auto license registration.
• Involved in analyzing the RMV’s Oracle based databasessources to figure out data quality issues.
• Responsible for working with ETL Lead, MDM lead to understand business requirements and clarifications of doubts.
• Using Informatica Developer Tool, createdsource PDOs from the Oracle tables, created Sources to Targets mappings for Data cleansing, validating,integrating and matching.
• Responsible for developing Mappings, Mappetsand Rulesusing different types of transformations like Parser,Address Validator, Key Gen, Match etctransformations, created PDOs and LDOs.
• Parsed the RMV’s data Person and Organization datain to the two columns.
• Migrated various rules developed at IDQ Developer tool to the PowerCenter.
• In order to cleanseRMV’s legacy addresses, created Address Validation rules for RMV’s various Mail, Residence and NOWN (organization) addresses, created match rules.
• Involved in DailyScrum team meeting.
• Project in the domain of Massechuset’s Department of Transportation (massDOT) and Registration.

Environment: IDQ Informatica Developer Tool 9.6.1, IDQ Informatica Analyst Tool 9.6.1, InforamtiaPowerCenter 9.6, Oracle 11g, Oracle SQL Developer 4.

Confidential, OKC, OK

Informatica Data Quality(IDQ) Developer

Responsibilities:

• Involved in complete understanding of business cases (requirement), analyzing the various WellView Application sources, transformingthese sources of dataand loading them into the OracleData Warehouse.
• Designed Oracle based WellViewSources to Targets mappingsusing Informatica Developer Tool for Data cleansing,valiadating,integrating and matching using Informatica Data Quality IDQ.
• Responsible for working with Business Analyist to have clear understanding on requirements and clarifications of doubts.
• Responsible for developing Mappings, Mappetsand Rulesusing different types of transformations like Union, Connected and Unconnected LOOKUP, Filter, Expressiontransformations, PDOs and LDOs.
• Involved in verifying the results in Fact Load with the Source data.
• Troubleshooted issues on IDQ Staging Environment post Stage installation.
• Helped the QA team and Testing team during testing phase for clarification of Requirements or their testing results.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing the developed rules, fixing the bugs identified, providing data to the Reporting team for their daily, weekly, monthly reports.
• Involved in DailyScrum team meeting.
• Project in Oil & Natural Gas Domain.

Environment: IDQ Informatica Developer Tool 9.5, Oracle 11g, MS SQL Server 2012/2008, QuestToad 12, HP QC 9.1

Confidential, Farmington,CT

Informatica Developer

Responsibilities:

• Involved in complete understanding of business descriptions, analyzing the sources, transforming sources of data and loading this transformed datainto the Teradata warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files, Xml Files to Teradata using Informatica Power CenterData cleansing, integating, and matching using Informatica Data QualityIDQ .
• Responsible for working with DBA and Data Modelers for project coordination.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily.
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.
• Project in Health Care Domain.

Environment: Informatica PowerCenter 9.1/8.6, IDQ 9 / 8.x, Unix scripting, MS SQL server 2005, Teradata V2R5, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages), IBM Cognos

Confidential

Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, and Sybase.
• Analyzed, designed and developed an environment that would facilitate the use of Informaticato transform data coming from OLTP intodatamartsandusedIDQfor cleansing and matching.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created Sessions, Worklets, Workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Worked on modification of UNIX shell scripts.
• Involved in weeklyteam status meetings from the offshore-onsite team members.
• Project in Financial Domain.

Environment: Informatica PowerCenter 9.1/8.6, IDQ 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Center9.0, Toad, PL/SQL (Stored Procedures, Triggers, Packages), Erwin, MS Visio, Windows XP

Confidential

Informatica Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the data of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSRS reports using Report Parameters,Drop-DownParameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.
• Project in Retail domain.

Environment: Informatica PowerCenter8.5, MS SQL Server 2008, Toad, SQL, PL/SQL (Stored Procedure, Trigger, Packages), Erwin, MS Visio, Windows 2000, UNIX.

Confidential

Sr. Project Engineer - Informatica

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSRS reports using Report Parameters,Drop-DownParameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.
• Project in Retail Domain.

Environment: Informatica PowerCenter8.5, MS SQL Server 2008, Toad, SQL, PL/SQL (Stored Procedure, Trigger, Packages), Erwin, MS Visio, Windows 2000, UNIX.

Confidential

Devement Manager

Responsibilities:

• Handled deliveries spanning across multiple phases like Customer Interaction, Requirement capturing, planning, Solution Designing, Development, Testing - SIT (System Integration Testing, NBT (Next Box Testing), E2E Testing etc.).
• Performed reviews of Project Plan, Estimation, Design, Requirement documents to ensure the deliveries are made within planned timelines and scope of work.
• Planned the deliveries by interworking with various teams and E2E designers, Component Delivery Managers, Product line Team to scope-in the change requests and agree on the delivery schedule.
• Tracked and monitored the progress of project for timely completion of milestones across all phases spanning from requirements to post deployment support to ensure successful delivery.
• Project in Telecom Domain.

Environment: CSG (INTEC) MediationInter-mediatE v5.0.11h, Sun Solaris Unix v5.8

Confidential

Software Developer

Responsibilities:

• Low Level Impact Analysis for the change requests and queries received from product team.
• Performed Low Level Design, Coding, debugging, testing of software components, it involves the coding in INTEC Inter-mediatE Mediation system’s programming language i.e. CGDC (Compiled Generalized Data Conversion) for the affected components.
• Planning, preparing and executing component/integration tests
• Prepare release notes for the ImE Operation team at the time of deliveries
• Resolve queries received from Operation and other interface teams.
• Project in Telecom Domain.

Environment: CSG (INTEC) Mediation Inter-mediatE v5.0.11h, Sun Solaris Unix v5.8

Confidential

Development Engineer

Responsibilities:

• Feasibility study of the problems reported by client.
• Reviewing the requirements, design and test specification documents.
• Coding as per the requirement
• Preparing Delivery notes and configuration management register for a package.
• Conducting physical configuration audit.
• Delivery of package for the given change request.
• Project in Telecom Domain.

Environment: Windows NT, CSG (INTEC) Mediation Inter-mediatE v5.0.11h