SUMMARY:

• 8+ years of experience in all the phases of the Data warehouse life cycle involving analysing, developing, designing, testing, maintaining Software applications and implementing Data Mart, Data Warehouse applications and Data integration using ETL.
• Expertise in Finance, Insurance, Health Care and Pharmaceutical Domains.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools - Informatica Power Center 9.x/8.6/7.x/6.x, Power Exchange, Power Mart 7.x/6.x/5.x(Administration Console, Designer, Workflow Manager, Workflow Monitor and Server Manager), OLTP and OLAP.
• Excellent knowledge in data warehouse development life cycle including Software Development Life Cycle (SDLC).
• Experience in Relational and dimensional modeling, repository management and Administration, implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Extensively worked in the Performance tuning of the SQL and ETL processes.
• Strong experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
• Have extensive experience with authoring Business Requirement Document BRD, Functional Specification Documents FSD and Software Requirement Specifications.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Experience in implementing Slowly Changing Dimensions (Type1, Type2 and Type3) mappings.
• Expertise in running of Informatica sessions and batches using UNIX Shell Scripts.
• Provide support to Onshore and Offshore team members.
• Experience in using Pipeline Partitioning feature in the sessions to reduce the load time.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files and XML files.
• Extensively executed SQL queries on Oracle using Toad and SQL Server tables in order to view successful transaction of data and to validate data.
• Experience in Bug Reporting and Defect Tracking, conducting Bug review meetings.
• Extensively used IDE to profile and analyze the source data and Prepared and executed quality plans for necessary dimensional attributes using IDQ
• Excellent reporting skills using OBIEE, Business Objects.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Able to understand and work flexibly in high paced environments and adapt quickly to different business organization needs.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/ 8.6.1/8.6/8.5/8.1/8.0

Data Modeling: Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i,DB2, MS SQL Server 2008/2005, DB2

Languages: SQL, PL/SQL, Unix Shell Script, XML, HTML, Visual Basic

Tools: OBIEE, Microsoft Office - Word, Excel, Access, Visio, PowerPoint, SQL* Loader, Autosys, SQL Develper, TOAD, ISQL

Operating Systems: Windows 2003/2000/NT/XP, AIX, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, GA

Sr. Informatica Developer

Responsibilities:

• Used Informatica 9.5 PowerCenter Designer and used transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data.
• Used Talend 5.3.1 extensively for migrating the data to Informatica Power center.
• Developed complex mappings in Informatica to load the data from various sources like FF, XML, Relational, WSDl, API.
• Worked on API’s like DFPP, Sensor Tower, Google Search, Recurly, Zoura, Moat, AolOn, AppAnnie, Omniture, Yieldex etc. to ingest data into cloud and Staging area.
• Used Informatica Cloud Services to create mappings and also used to connect to few API’S like Zoura /ADSense and AdExchange.
• Gained Knowledge on Jason, REST, SOAP for XML While working on this Project.
• Created complex Mappings and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created complex Mappings to implement data cleansing on the source data.
• Created Mappings to implement one time as well as Incremental loads.s
• Extensively used Informatica debugger to eliminate the bottlenecks for optimum performance. Also involved in troubleshooting existing ETL bugs.
• Used Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Created Technical Documentation for all the developed mappings for presentation with Business.

Environment: Informatica Power Center 9.5/9.2,Power Exchange, DB2, UNIX Shell Scripting, Oracle 9i/10g/11g, PL/SQL,SQL Server 2008,MS Access, MS Visio, Workload Scheduler, SQL Developer

Confidential, GA

Sr. Informatica Consultant

Responsibilities:

• Reviewed the stored procedures developed by team members in Microsoft SQL Server & DB2 to create the ETL functionality.
• Developed common stored procedures in DB2 & Microsoft SQL Server that are used as templates to perform the Transform & Load functionality.
• Extracted data form Flat Files and XML, applied business logic to load them in the central Microsoft SQL Server database.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure and Sequence generator, Joiner, Union and Normalize.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Performed Optimization at both the Mapping Level and Session Level.
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Actively participated in resolving Email tasks working on priority and non-priority issues of employee’s profiles and figuring out those issues through mappings.
• Created Informatica Workflows, Worklets, and Tasks like Command, Session, Decision, Event Wait, Control, and Timer Etc.
• Raised change requests, analyzed and coordinated resolution of program flaws in Prod and QA environment, migrated the fixed code in Dev and to QA, preproduction and production environments according to change request approval.
• Work with administrators, users and analysts to maintain exchange of reporting requirements
• Use the best practices of business intelligence to meet project and company objectives.
• Automated related tasks by developing UNIX shell scripts used to maintain the core EDW.

Environment: Informatica Power Center 9.5/9.2,Power Exchange, DB2, Erwin 4.0, UNIX Shell Scripting, Oracle 9i/10g/11g, PL/SQL,SQL Server 2008,MS Access, MS Visio, Workload Scheduler, SQL Developer

Confidential

Sr. Informatica Developer

Responsibilities:

• Conducted meetings and worked closely with business users in gathering reports requirements.
• Involved in preparation of Business requirement documentation (BRD), and functional specification documentation(FSD)
• Prepared technical specifications to develop Informatica ETL mappings to load data into various staging, Data warehousing and Data marts.
• Development and Support of OBIEE components and solutions.
• Installed the Informatica, DAC, OBIEE on distributed environments.
• Configured DAC - Data warehouse Access control for running of ETL jobs.
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Migration experience from OBIEE 10.x to OBIEE 11g.
• Develop and deploy dashboards, analytics and reports properly.
• Design and place data in layers varying to physical, business and presentation.
• Work with administrators, users and analysts to maintain exchange of reporting requirements
• Use the best practices of business intelligence to meet project and company objectives.
• Identify production faults and critical issues followed and troubleshoot them.
• Provide remedial measures to the production issues or process failure.
• Prepare monthly reports and present it to the management.
• Designed and Developed ETL process using Informatica Power center 9.2.
• Created Informatica Workflows, Worklets, and Tasks like Command, Session, Decision, Event Wait, Control, and Timer Etc.
• Tuned Mappings, Sessions, and SQL for better performance by eliminating various performance bottlenecks.
• Raised change requests, analyzed and coordinated resolution of program flaws in Prod and QA environment, migrated the fixed code in Dev and to QA, preproduction and production environments according to change request approval.
• Developed Unix shell/Perl scripts to automate the process of renaming the Flat files with a timestamp extension, Executing Informatica workflows using pmcmd, Compressing, Archiving, the Workflows, File Manipulations and automatic email notifications to the data owners (Success / Failure) and FTP to the desired locations as required by the user.
• Worked Extensively on Partitioning in Oracle and applied partitioning on several fact tables.
• Interacted with the third-party vendors regarding data issues with incoming and outgoing daily data extract.
• Automated related tasks by developing UNIX shell scripts used to maintain the core EDW.

Environment: Informatica Power Center 9.2/8.6.0,Power Exchange, DB2, UNIX Shell Scripting, Oracle 9i/10g/11g, PL/SQL,OBIEE,SQL Server 2008,MS Access, MS Visio, Workload Scheduler 8.4, SQL Developer

Confidential, MI

Sr. Informatica Developer

Responsibilities:

• Requirements gathering and business analysis and responsible for populating the business rules using mappings into the Repository for Meta Data management.
• Worked closely with Business Users to under the requirements, and prepared BRD for respective projects.
• Worked with a very large team - Offshore Onsite model.
• Designed the ETL Specifications Document (Source to Target mapping document) based on the requirements from Business Users.
• Worked on analyzing the data coming from different source systems like Mainframes, Informix, SQL Server, Oracle and Flat files (Fixed width and Delimited).
• Designed the Data Model and created several Fact & Dimensions based on the reporting needs for the projects.
• Designed and developed mappings with optimal performance using Aggregator, Joiner, Normalizer, Aggregator, B2B Transformation, Rank, Sequence Generator, Un-Cached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union etc.
• Used Pushdown Optimization to push the transformation logic on to the Database both on the Source and the Target sides where ever possible to improve performance of the mapping.
• Power Exchange Change Data Capture has been done for data updates.
• Used Power Exchange to extract DB2 Source from mainframe server.
• Used unstructured data transformation in informatica to use DT Studio Services.
• Extensively worked with Repeating Groups, Markers and Content tags in DT Studio.
• Used pre-session and post-session variable assignment to transport variable values across sessions and worklets.
• Used Constraint Based loading & target load order to efficiently load tables with PK-FK relation in the same mapping.
• Worked closely with the DBA’s and end users in the development of Informatica mappings and tuned existing mappings for better performance.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters and Source-Target Application Connection parameters.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Attended Team meetings as an ETL/Informatica technical advisory to offer opinion and guidance to managers to select the best plan of approach at project startup meetings.
• Provided post-production support to resolve the issues.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios
• Involved in UAT along with users to understand the data and to make any modifications if suggested by the user.

Environment: Informatica Power Center 9.0/8.6.0, Power Exchange, DB2, Erwin 4.0, UNIX Shell Scripting, Oracle 9i/10g/11g, PL/SQL, SQL Server 2008, SQL,Tivoli,MS Access, MS Visio, Workload Scheduler 8.4, TOAD 9.7.2 .

Confidential

Sr. Infromatica Developer

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
• Involved in upgrading Informatica power center 8.6 to power center 9.0.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Experience in Using Data Masking Transformation to obfuscate the sensitive Data or Toxic fields.
• Worked on different data sources such as Oracle, Delimited and fixed-width flat files.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, B2B Transformation, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Unconnected lookup transformations.
• Used the Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables using Power Exchange..
• Using the RDBMS concepts on the data for different user specified functions.
• Review the Session logs, fix the data and run again with recover option or run through again the same job in Production Support.

Environment: Informatica Power Center 8.6.1, Power Exchange, Teradata, Oracle 11g, DB2, SQL, PL/SQL, XML, Toad, MS Access, Windows XP, Linux, MS SQL Server

Confidential, CT

Informatica Developer

Responsibilities:

• Involved in the Informatica server installation and set up the environment.
• Worked on developing Unix scripts for data cleansing and data archiving
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Worked with Data Masking Transformation and ILM Workbench to automate data masking process.
• Expertise in configuration, performance tuning, installation of Informatica & in integration of various data sources like Oracle, SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Involved in writing the SQL procedures used SQL Server DTS to improve the warehouse loading.
• Used Transformation Language functions in the mappings to produce the desired results.
• Used TOAD and SQL Developer to run SQL queries and validate the data in warehouse and mart.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Developed test cases for Unit, Integration and system testing.
• Involved in maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments.
• Partitioned the Sessions for better performance.
• Wrote SQL Scripts and PL/SQL Scripts to extract data from Databases
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.0/8.6.1, Oracle 11g, DB2, Teradata, SQL, PL/SQLXML, Toad, MS Access, Windows XP, UNIX

Confidential, San Antonio, TX

GRADUATE RESEARCH ASSISTANT

• Worked as a Research assistant in the Biomedical Department (College of Engineering) of The University of Texas at San Antonio.
• Managing Student files using SQL SERVER
• Involved in Teaching Graduate Students all about Database (SQL SERVER)

Confidential, San Antonio, TX

GRADUATE RESEARCH ASSISTANT

• Assisted the Director of Development in the process of developing the financial condition of college of engineering.
• Organizing Advisory Council Meetings which involved around 40 members.
• Worked with Database (SQL SERVER) for managing and retrieving the data.