PROFESSIONAL SUMMARY:

• Around Eight plus years of IT experience in the Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions using Data Warehouse/ Data Mart Design, ETL, OLAP,OLTP.
• Strong ETL experience using Informatica Power Center with various versions 9.x/8.x/7.x Client tools - Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager and Power Mart
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11g/10g/9i, SQL Server 2008/2005, IBM DB2, Excel sheets, Flat Files.
• Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type I, II, III and Cleansing, Profiling, Conversion, Aggregation, and Performance Optimization and setting up Change Data Capture (CDC) mechanisms.
• Experience in working in an Onsite-Offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Strong Experience in creating Transformations such as Aggregation, Expression, Update Strategy, Lookup, Joiner, Rank, Router and Source Qualifier Transformations etc. in the Informatica Designer.
• Comprehensive knowledge of Dimensional Data Modeling like Star Schema, Snowflake Schemas, Facts and Dimension Tables, Physical and Logical Data Models and knowledge in designing tools like MS Visio, Erwin.
• Demonstrated proficiency in improving re-usability, automation of data loads, performance tuning in Informatica by identifying bottlenecks in Source, Targets or on Database level and de-bugging/rectification of data load errors.
• Expertise in querying and testingRDBMSsuch asOracle,MS SQL ServerusingSQL,PL/SQLfor data integrity.
• Comprehensive knowledge on Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.
• Expertise in using Automation Scheduling tools like Tivoli Workload Scheduler, Informatica Job Scheduler and Control-M.
• Scalable knowledge in Error Handling and Troubleshooting using various log files.
• Experience in database programming with PL/SQL (Stored Procedures, Functions and Triggers) and also involved in Query Optimization.
• Good understanding knowledge of Ralph Kimball & Bill Inman methodologies.
• Exposure to develop reports using Business Intelligence tools such as Business Objects.
• Maintain outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• A highly motivated self-starter and a good team-player with excellent communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1/9.1.0/8.6.1/8.1.1/7.1.1/7.0 Designer, Work Flow Manager, Work Flow Monitor, Repository Manager, Informatica Power Mart, Power Exchange, Data mart, OLAP, OLTP,IDQ.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Erwin 4.1, MS Visio.

Operating Systems: UNIX, LINUX, Windows7/ Vista/XP, 2000, MS DOS.

Databases: Oracle 11g/10g/9i, IBM DB2 8.0/7.0, MS SQL Server 2008/2005, SQL* Loader, SQL Developer, MS Access, Teradata v12/v11, Netezza.

Programming languages: SQL, PL/SQL, T-SQL, C, C++, HTML, Visual Basic, Perl, VB Script, XML.

Reporting Tools: Business Objects XI 4.0/3.1/3.0 (Web Intelligence, Universe Designer)

Scheduling tools: Tivoli Workload Scheduler, Control-M, Informatica Scheduler.

Other Tools: Manual Testing, Lotus Notes, WinSCP, QTP, HP Quality Center 10/9.2, TOAD, SVN, Ultra Edit, MS Office 2010/2007/2003.

WORK EXPERIENCE:

Confidential, MA

Data Conversion Analyst/Informatica Developer

Responsibilities:

• Developed the Functional and Technical Specifications Documents used for the conversion of the code.
• Identified gaps in the mapping document and finding out the data elements required for conversion and working with the Business Analysts, Data Modelers and Business Users to achieve project objectives.
• Involved in the Design Process of ETL mappings, workflows from Legacy systems to Staging.
• Extensive use of Informatica 9.5.1 /Oracle/ UNIX tools on a daily basis for development of the code.
• Developed Test cases for Unit Testing of the Mappings, and also was involved in the UNIT, SMOKE, SIT, UAT and volume testing of the code developed.
• Designed and developed the mappings using various transformations Expression, Filter, Router, Aggregator, Joiner, Normalizer, Union, Sequence Generator, Connected and Unconnected Lookup, Stored Procedure Transformations, Update Strategy, etc.
• Use of Materialized Views to join with the source systems to filter out the active records required for conversion and to increase performance of the code which made restartability easier.
• Implementation of Cross walk tables, Process logs for the data after conversion.
• Worked on Version Control Mechanism, Code Promotion Strategies and implemented Partitioning in the code.
• Tracked the defects using JIRA and generated defect summary reports.
• Developed the automated scripts for the Field to field comparison of the target data loaded with the source data used for reconciliation between to-be-converted-data against converted-data.
• Involved in the Preparation and Review of the code Release Plans to migrate objects from one environment to other.
• Loaded data to different databases using PLSQL scripts and maintained a repository for data loading scripts.
• Created Reusable Transformations, Worklets wherever possible to avoid redundancy.
• Performance of the source system data loading, validations, matching, updates/changes and actual conversion at the build-integration testing level.
• Prepared status summary reports with details of executed, passed and failed test cases
• Developed Cross Walk tables to store keys of legacy and new systems for audit purpose.
• Worked with XML files and Flat files as the source to load data into the tables.
• Performed data validation testing writingSQLqueries.
• Experienced in finding bottle necks and Performance Tuning of Slow running jobs by using EXPLAIN PLAN, ANALYSE TABLE and statistics to improve performance.
• Experience in the use of JIRA to log project level issues and ENSEMBLE to view the documentation.
• Error handling and debugging of the session.

Environment: Informatica Power Center 9.5.1 (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g,Power Exchange, PL/SQL, SQL Developer, Testing, UNIX, XML,Ultra edit, SVN Version Tool, Windows 7, MS Office 2010, WinSCP.

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Worked in the ‘Vision Replacement and Decommission Project/Golden Source Data Warehouse project’.
• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Prepared Functional Requirements Documents to redesign two legacy systems into a GOLDEN SOURCE DB environment.
• Design of HLD/LLD and Job-Linkage Diagrams of the documents for various interfaces using MS-Visio.
• Loading the data into the target tables and developed/designed the code for various interfaces like ACCOUNTS, POSITIONS/HOLDINGS, TAXLOTS and TRANSACTIONS, GOLDENSOURCE SECURITY MASTER for various source systems like INVESTONE, GIM, APL, WANGER, PACE-BOA, PAM
• Used Informatica Power Center to develop Mappings, Workflows, Reusable Shortcuts, Mapplets for populating the data into dimension, fact, and lookup tables from different source systems (Oracle, Flat files) and load into the target databases ( ORACLE, IBM DB2, Flat Files).
• Worked with the Data Analysts team and Data Governance team which involved Data Cleansing, Profiling and identifying for any duplicates in the data, data quality using tools like IDQ.
• Worked on Refresh Mappings in different environments E1 and E2 and loading of the data into the target databases.
• Use of Service now and Lotus Notes to create Work Requests and Change Management Requests.
• Involved in Unit testing of the code developed in Development stage and also UAT testing in E2 environment using Mocked up data/ files and testing in different possible ways in concern with Business People requests.
• Designed mappings using Expression, Filter, Router, Aggregator, Joiner, Sequence Generator, Connected and Unconnected Lookup, Unconnected Stored Procedure Transformations, Update Strategy, Union Transformations.
• Developed UNIX/Linux Shell scripts for the command tasks in the workflow and Stored Procedures for partitions of the tables.
• Scheduled the changes in E2 (Testing/Staging) and E3 (Production) environments using Tivoli Workload Scheduler and monitor the jobs.
• Use of CHMOD to change the permissions of the file, grep, pmcmd, pmrep, touch and other Unix/Linux commands and also the use of WinSCP.
• Worked on different tasks in Workflow Manager, Creating Instances for various Source Systems for all the Interfaces available in the workflow, using command tasks and on different Integration Services.
• Used Constraint Based loading & target load ordering to load data into the tables with maintaining the PK-FK relation in the same mapping.
• Used Debugger to create break points, run the mapping till the break points, find out the cause/error and modify the data and debug the mapping in the transformations.
• Expertise in Performance Tuning by identifying the Bottlenecks at sources, targets, databases, Power Center transformations and sessions using techniques like Explain plan, Oracle hints, partitioning, re-designing the mappings.
• Developed the UNIX Scripts and Parameter files migration Instructions, Informatica Code migration and Back-Out Instructions into Production and once migrated, involved in monitoring the jobs scheduled through TWS and find out the bugs/issues and fix them and test them in the development stage and move them to Production again.
• Used Repository Manager to copy the code/ workflows from one folder to other in various environments.
• Worked with RECONCILIATION files and prepared the final report of the daily files generated and comparison of Mismatches in the files generated in various versions V3 and V4 for Data warehouse and Vision Replacement files.

Environment: Informatica Power Center 9.x (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g, PL/SQL, SQL Developer, IBM DB2, UNIX, Linux, Lotus Notes, Windows 7, Tivoli Workload Scheduler, MS Visio, MS Office 2010, WinSCP, XML.

Confidential, Framingham, MA

InformaticaDeveloper

Responsibilities:

• Responsible for preparing the technical specifications from the business requirements.
• Analyzed the requirements and work out with the solution. Develop and maintain the detailed project documentation.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the Mappings between sources (external files and databases) to operational staging targets.
• Used Informatica Power Center to create Mappings, Sessions and Workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Utilized InformaticaIDQto complete initialdata profiling and matching/removing duplicate data.
• Designed and developed mappings using Expression, Filter, Router, Aggregator, Joiner, Normalizer, Rank, Sequence Generator, Update Strategy, Union, etc.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Identified and eliminated duplicates in datasets thorough IDQ components.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Used Debugger to create break points, run the mapping till the break points, intermittently modify the data and debug the mapping in the transformations.
• Expertise in Performance Tuning by identifying the Bottlenecks at sources, targets, databases, Power Center transformations and sessions using techniques like Explain plan, Oracle hints, partitioning, using indexes, re-designing the mappings.
• Extracted data from XML files and loaded into the oracle tables using Informatica.
• Managed production issues and delivered all assignments/projects within specified time lines.
• Developed UNIX shell scripts for regular maintenance and production support to load the history and incremental data into warehouse.
• Extensively used Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica using Tivoli Workload Scheduler.

Environment: Informatica Power Center 9.x/8.x, Oracle 11gR2, SQL Developer, UNIX, MS Visio, TOAD, Windows 7, TWS, WinScp, XML.

Confidential, Dallas,TX

Sr. Informatica Developer

Responsibilities:

• Worked closely with Business Analysts, Data Architects, and Database Administrators to gather requirements and build the infrastructure of the data flow.
• Involved in creating logical and physical data models using MS Visio based on business requirements.
• Created a global repository, groups, users and assigned privileges using Repository Manager.
• Extracted data from various sources systems such as Oracle, CSV files and Excel by importing and creating source definitions and loaded into targets such as Oracle, DB2.
• Created repositories, folders, and users for the development, staging, and QA environment.
• Improved performance by using Explain Plan, Creating appropriate Indexes, queries optimization, utilizing table spaces and Partitioning schemes.
• Set up ETL systems to generate reports on various securities like equity, mortgages, and Sand funds providing, pricing and ratings data from multiple vendors.
• Developed complex mappings using various transformations such as Aggregator, Expression, Filter, Joiner, Lookup, Sorter, Source Qualifier and Update Strategy for implementing complex business logic and efficiently transforming the data in mapping designer.
• Used Normalizer Transformation to normalize data from sources and used Aggregators to De-normalize records to change the granularity of data.
• Wrote FTP Shell scripts to perform automated file transfers, tasks scheduling, comparing and synchronization of folders, Zip/Unzip and upload/download the folders.
• Developed and implemented mappings for capturing Type II and Type III slowly changing dimensions for maintaining Full History of the data.
• Created and used tasks like Email, command, Control and monitored jobs in Informatica Workflow Monitor.
• Used Constraint Based loading & target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Developed Stored Procedures using PL/SQL and Driving scripts using UNIX Shell scripts and also for file management like Zip and Unzip the files.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, SQL Server 2008, UNIX Shell Scripting, MS Visio, PL/SQL, Windows 7, SQL Plus, SQL Developer, Business Objects XI 3.0, Teradata v12, MS Excel.

Confidential, Hartford, CT

Informatica / DW Developer/ETL Tester

Responsibilities:

• Analysis and involved in acquiring Requirements from Business Requirement Document (BRD), function/technical specification, development, deploying and testing by Business Analysts and Developers.
• Rehabilitated the business requirements into technical specifications for ETL process by populating the fact and dimension tables of data warehouse.
• Created and executed SQL queries in Oracle to test the data flow from OLTP systems to data warehouse.
• Created Informatica mappings for initial load and daily updates.
• Extensively used MS Visio for data modeling and Dimensional Data Modeling.
• Developed several mappings using (Source Qualifier, Lookup, Filter, Joiner, Aggregate, Sequence Generator, Expression, Lookup, Router, and Update Strategy) transformations to load data from multiple sources to target data warehouse.
• Actively participated with the team in Dimensional modeling of the Data warehouse and evaluated Informatica Power exchange for Change Data Capture.
• Wrote and modifiedSQL validation scripts, and writing scripts in SQL to validate the outputs.
• Coordinated Offshore and Onsite team with a total of six ETL developers.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved with the healthcare claims processing 837, 835. Accomplished data movement process from DB2 to Oracle.
• Developed Unit test cases and Unit test plans to check data is correctly loading.
• Written shell scripts using UNIX shell for file transfers, error log creations and log file cleanup process.
• Worked with HIPPA 5010 for reduced risks, flexibility and complete bi-directional transaction crosswalk transactions.
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Performed troubleshooting the load failure cases, including database problems.
• Involved in Design and Data Modeling using Star Schema.
• Configured Informatica connections source DB connection and target DB connection in DAC.

Environment: Informatica Power Center 8.5, Oracle 9i, PL/SQL, UNIX, IBM DB2, TOAD, SQL*Plus, SQL Developer, Windows 7/XP, SQL Loader, MS Visio.

Confidential, Farmington Hills, MI

Informatica Developer/Tester

Responsibilities:

• Designed and implemented ETL mappings to extract and transform data from various sources and also actively involved in analyzing business requirements.
• Designed and developed Functional and Technical Specification Documents.
• Creation of transformations like Lookup, Joiner, Rank, Expression, XML and Source Qualifier transformations in the Informatica Designer.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Created complex mappings using Unconnected Lookup, Sorter and Aggregator, Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplets and used them in different mappings.
• Developed Oracle PL/SQL scripts for Data Import/Export.
• Used Oracle and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Generated & developed reports, Drilldown reports using Business Objects.
• Involved in Tuning Informatica Mappings and Sessions for Optimum Performance.
• Deliberated and developed UNIX shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Widely used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Used FTP connection browser available in Informatica Workflow Manager to FTP the flat files into different environment.
• Involved in TestingChange Requests(CR) that is testing base enhancements to the existing code before implementing in the Production.
• Involved in all phases of (Unit, Integrated and UAT) testing Informatica mappings.
• Used Windows Scripting and PMCMD command to interact with Informatica Server from command mode.
• Involved in scheduling the workflows through Informatica Job Scheduler.
• Monitored the jobs daily and involved in production support.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g/9i, UNIX, SQL*Plus, Business Objects XI 3.0, Windows 7/XP, TOAD, SQL Server2005, XML, Erwin 4.0.

Confidential

ETL Consultant

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow.
• Designed and developed Informatica Mappings, Workflows to load the data into Oracle DB, SQL server.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Performingmanualtesting by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Created and maintained UNIX Shell Scripts for pre/post session operations and various day-to-day operations.
• Developed Unit and System testing test cases, using System Procedures to check data consistency with adherence to the data model defined.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL server 2005, UNIX, SQL Plus, Testing, MS Access, Windows XP.