SUMMARY

• 7+ years of strong Data Warehousing ETL experience of using Informatica PowerCenter - 9.5.1, 9.0.x, 8.6.x. Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
• Strong Data Warehousing experience in using Oracle Warehouse Builder, Business Objects, SQL server, DB2 UDB, MS Access, OLTP, OLAP, Oracle SQL Loader.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Implemented performance tuning techniques for ETL processes.
• Experience in various production support activities like analyzing production migration issues, performance tuning issues related to Informatica mappings.
• Used Informatica Data Quality (IDQ) for data discovery and profiling.
• Used Informatica Data Quality (IDQ) tool to proactively monitor and cleanse data across the enterprise to achieve better business outcomes.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Have adept knowledge in leading offshore resources by providing technical and functional support.
• Coordinated with the off-shore team and provided guidance on the Construction/Development of Informatica routines.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 8/7/XP. UNIX (Sun-solaris, AIX, HP/UX), Linux.

ETL Tools: Informatica PowerCenter 9.5.1, 9.0.x, 8.6.x.

Databases: Oracle 11g/10g/9i, DB2 UDB, MS-SQL Server 2000/2005/2008 , Sybase 10,My SQL and MS-Access.

Languages: C, C++, C#.Net, PHP, UNIX Shell Scripting, PL/SQL, T-SQL.

Reporting Tools: Cognos 8, Siebel Analytics (OBIEE), Business Objects, SSRS.

Tools: TOAD, MS VISUAL STUDIO, MS VISIO, MS PROJECT, SQL *PLUS, SQL Loader, AUTOSYS.

Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, ERwin, Power Designer, Oracle Designer.

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Waltham, MA

Responsibilities:

• Gathered requirements from existing ETL Team, Tech Spec writers and Business Managers.
• Provided estimation document for each of the phase (Tech Spec Document, Design Document, Unit Testing, Migration and UAT).
• Developed end to end DWH project for Dialysis Chairside application.
• Created Technical Specification document which includes Source- Confidential mappings, Data Modelling, Job scheduling, Job run Summary and Risks.
• Developed mappings for three phases of project: KARMA, SPECTRA and CLAIMS using Source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Sorter, Union, Lookup, Normalizer, Update Strategy.
• Loaded data into Netezza warehouse using Netezza Bulk Writer by changing session properties and including some custom properties for bulk writer using external tables.
• Gathered requirements, analyzed, data profiling and developed end to end project for CHAIRSIDE Treatment Event which is one of the key subject areas in Fresenius Dialysis Treatment.
• Accomplished complicated business problem for reconciliation (Data Validation) task with usage of ABORT function in Informatica which avoided 3 environments (Netezza, Oracle and Python Script).
• Developed mappings for CDC (Change Data Capture), SCD2, SCD4/SCD7 using HASH CD (MD5).
• Used Informatica IDQ for Data standardization, enrichment, de-duplication, and consolidation purposes.
• Improved performance by applying Push Down Optimization (PDO) for long running sessions and for huge data sets.
• Created Autosys jobs (scheduling tool to run workflows) (.jil) file for Informatica job scheduling and created dependency on success of previous jobs.
• Performed unit test and validated Informatica workflows/sessions after the migration from Dev-QA and QA-Prod.
• Resolved data issues of Business users by debugging reporting analysis and ETL mappings
• Created Unit Test documents and also UAT documents (MINUS Queries).
• Interacted with multiple business subject matter experts for database issues and system failure issues.

Environment: Informatica PowerCenter 9.5.1, IDQ, CDC, Oracle 11g, unix, plsql, sql server 2008, SHELL scripting.

Informatica Developer

Confidential, Dublin, OH

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Extracted data from Sybase as one of the source databases.
• Involved in JAD sessions for the requirements gathering and understanding.
• Involved in the ETL design and its documentation.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ERWIN.
• Followed Star Schema to design dimension and fact tables.
• Implemented CDC processes for the LARGE TABLES.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area.
• Processed customer address elements by Cleansing, standardizing and converting using Trillium.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse from SQL server and Sybase.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Lookup, Aggregate, Update Strategy and Joiner.
• Extracted DTS (Data Transformation Services) packages from the SQL server.
• Identified the transformations used in each DTS packages.
• Converted the DTS packages into Informatica mappings and loaded the Confidential into the Oracle database.
• Worked with IBM Mainframes server to extract centralized data of the organization.
• Experienced in handling slowly changing dimensions.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Scheduling the sessions to extract, transform and load data in to warehouse database on business requirements.
• Scheduled the tasks using Autosys.
• Loaded the flat files data using Informatica to the staging area.
• Created SHELL SCRIPTS for generic use.
• Developed Test cases for Unit Testing of the mappings, and also was involved in the Integration Testing.
• Generated reports using Siebel Analytics 7.3 (OBIEE).

Environment: Windows XP/NT, Informatica Powercenter 9.5.1, UNIX, SQL Server,Sybase, Oracle 11g, SQL, PL/SQL,SQL Developer, Trillium, Metadata Manager, Oracle Designer, MS VISIO, Erwin 7.2, Siebel Analytics(OBIEE),IBM Mainframes, TOAD, Autosys, Korn Shell.

Informatica Developer

Confidential, Minneapolis, MN

Responsibilities:

• Analyzed the CSG source data for the new enhancements and created mappings to facilitate the changes made.
• Analyzed the Source data and business requirements to create the Informatica mappings from staging to ODS according to business specifications various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregator and expression transformation.
• Analyzed the mappings to determine the bottlenecks in the mappings and worked on performance tuning of these mappings.
• Converted the Lookups to dynamic lookups to improve the performance based on the loads of mappings.
• Improved the SQL query response time by tuning the SQL queries and providing alternative solutions to the time consuming queries.
• Constructed mapping (sources from CSG Systems) that mirrors the source data into a staging area using various transformations like update strategy, lookup, Router, Filter, aggregator and expression transformation and unit tested the mappings.
• Developed Shell Scripts that generate the parameter files, Checks the source systems to see if the data is loaded and then automatically start the workflows.
• Developed a Global shared folder that consists of sources and targets that are used by various mappings in different folders.
• Constructed mappings for data validation based on the row count.
• Worked on the production support team for monitoring the sessions, analyzing the failed sessions and generating status reports using Informatica Workflow manager.
• Provided Tuning assessment by rightly identifying performance bottlenecks and explored tuning opportunities in the current ETL environment and tuned Informatica mappings, sessions and SQL queries based on the Informatica velocity methodology.
• Modified the PL/SQL Stored Procedures to meet the changing standards.

Environment: Informatica-Power Center 9.0.x, DB2 UDB, SQL Server, SQL, PL/SQL, Shell Scripting, Tidal Scheduler, TOAD, Erwin 7.2, Sun Solaris, and AIX, Sunopsis.

Informatica Developer

Confidential

Responsibilities:

• Involved in designing and developing the database for the business division of Creative Eye at Focus for effectively managing manufacturing processes.
• Designed and developed database views and stored procedures.
• Maintained user roles and privileges at the database level. It involved enrolling users, maintaining the system security, controlling and monitoring user access.
• Used SQL to extract the data from the database.
• Worked with Development Life Cycle teams.
• Wrote Stored procedures, Stored functions, Packages and used in many Forms and Reports
• Wrote database triggers for automatic updating the tables and views.
• Designed and developed forms and reports.
• Involved in the creation of jobs using Informatica workflow manager to validate, schedule, run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.

Environment: Informatica PowerCenter 8.6.x, Oracle 10g, Oracle Forms, Reports, SQL, PL/SQL, Windows, SQL Navigator, Erwin 4.0 and LINUX.

Oracle Developer

Confidential

Responsibilities:

• Analyzed the system requirements and prepared the documentation.
• Designed and developed various user entry forms using Developer2000 with Forms 4.5.
• Used various levels of triggers and procedures to validate the data at each level.
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Created database tables with complex constraints applicable to the business rules.
• Involved in the Testing, Implementation and Production of the System.

Environment: Oracle 9i, PL/SQL, SQL* Loader, PERL, Forms and Shell scripts.