SUMMARY

• I.T. Professional with 7+ years of experience in Data warehousing solutions using Informatica Power Center 9.0.1/8.1/7. x/6.x with Oracle databases
• Complete life cycle knowledge of building of Data warehouse. Good experience in dimension Modeling, Data Warehouse Requirement analysis and development/implementation.
• Experience in Insurance, Healthcare, Banking and Retail domains.
• Strong knowledge of Relational database modeling and Dimensional database modeling concepts and star/snowflake schemas implementation.
• Experience in Database Design and development of applications with Business Intelligence using SQL Server 2008/2005, Integration Services (Star Schema and Snow Flake schema).
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflows using shell scripting.
• Clear knowledge on OLTP and OLAP Systems, developing Database schema - Star and Snow flake schema (Dimensions and Facts), E-R Modeling- Logical and Physical Modeling Concepts.
• Expertise in integrating various source’s- Oracle, SQL Server, XML files and Flat files.
• Profound knowledge in implementing different types of Caches for Lookup’s- Dynamic, Persistent and Static.
• Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command.
• Extraction of data from Sources to Targets- Staging Area, Data Marts or Data Warehouses.
• Extensive use of Informatica Debugging in mappings and used Session Log File to trace the errors when loading into targets.
• Implemented Performance Tuning Techniques on Mappings, Session and Targets.
• Worked closely with Architects when designing the Data Marts and Data Warehouses, with Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled.
• Experienced in working with Tools- TOAD, SQL Developer and SQL Plus.
• Used various sources like Oracle10g, SQL Server2008, DB2, Flat files, and XML in creating reports.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Developed UNIX shell scripts to extract and convert data from different legacy systems in databases.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter 9.1/8.x/7.x/6.x, Power Exchange

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

Languages: SQL, T-SQL, PL/SQL, C, Perl, UNIX Shell Scripting

Operating Systems: UNIX, Windows 2000/2003/NT/XP/98/95, Linux, Sun Solaris

DB Tools: TOAD, SQL *Plus, PL/SQL Developer

Web Technologies: HTML, XML, DHTML, CSS

Data Modeling Tools: ERWIN 4.5/3.5, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Brookfield, WI

Sr. Informatica Developer

Responsibilities:

• Involved in designing the documents basing on the requirement specifications
• Done extensive testing and wrote sql queries to ensure loading of data.
• Performed unit testing at various levels of ETL.
• Developed and implemented the coding of Informatica mapping.
• Used various transformations like expression, union, source qualifier, aggregator, router, stored procedure, lookup transformations.
• Worked on sql tools like toad to run sql queries and validate the data.
• Fixed invalid mappings and troubleshoot the technical problems of database.
• Debug the sessions by utilizing logs of sessions.
• Monitored workflows and collected the performance data to maximize session performance.
• Made use of post-session success and post-session failure commands in the session task to execute scripts needed for cleanup and update purposes.

Environment: Informatica Power Center 9.0.1, SQL Server 2008, ActiveBatch

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• Designed and deployed overall ETL strategy including CDC, SCD’s, Partition Management, Materialized Views and other complex mapping logics.
• Worked with the business analysts in requirement analysis to implement the ETL process.
• Worked Extensively on Informatica tools - Repository Manager, Designer and Server Manager.
• Worked on all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
• Involved in both designing and developing the Data Mart.
• Writing stored procedures according to business scenarios.
• Data from source systems is extracted and transformed according to business requirements using Informatica PowerCenter and loaded into Oracle Data Mart.
• Involved in unit and system testing.
• Involved in Creating tasks, worklets, workflows to load the data.
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.
• Defined Target Load order Plan for loading data into Target Tables.
• Troubleshoot problems by checking Sessions and Error Logs.
• Involved in performance tuning issues at various levels such as target, sessions, mappings and sources.
• Worked with the Repository Manager and administrator functions of Informatica.
• Used pmcmd commands for stopping and starting workflows and tasks.
• Involved in Postproduction support and enhancements.

Environment: Power center 8.6, Oracle 9i, DB2, SQL Server, TOAD, SQL, PL/SQL, Erwin, Business Objects, UNIX and Windows XP

Confidential, Lansing, MI

Informatica Developer

Responsibilities:

• Developed Mapping design documents per business requirements.
• Extensively used all Informatica Tools to develop, Schedule, Execute and Monitor all ETL jobs.
• Developed Informatica ETL mappings per the Mapping Specifications.
• Developed mappings to extract data from COBOL files (Main frame), DB2 and oracle sources.
• Extensively used many transformations (Source Qualifier, Normalizer, Joiner, Router, Update Strategy, Look Up, Union Transformation, Filter transformations etc.)
• Designed and developed various Complex Mappings and Mapplets.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on all the SCD like Type 1, 2, 3 and type 2 variant.
• Worked on dimensional models like Star Schema and snow-flex Schema.
• Designing and creation of complex mappings using SCD type II involving.
• Created post-session and pre-session shell scripts and mail-notifications
• Developed SQL Scripts to validate all mappings business functionality for unit testing.
• Extensively used Mapping Variables & Parameters, Workflow Variables and Session Parameters.
• Involved in Migrating the code from development to production environments.
• Build and maintain code to support data movement from production databases to downstream databases/Files.
• Provided guidance and supervision to employees and contractors.
• Unit testing the code with a sub-set data base and making sure the test results match with the client requirement.
• Extensively used performance tuning techniques to tune ETL jobs.
• Attended Daily production support calls to troubleshoot production issues and provided solutions

Environment: Informatica 8.6.1, DB2, Oracle 10g, ERWIN 4.1, SQL & PL/SQL, Toad

Confidential, Northbrook, IL

Informatica Consultant

Responsibilities:

• Participated in all phases of development life-cycle by providing input during definition and design meetings, functional and technical walkthroughs.
• Developed Functional (Business terms) and Technical Design documents.
• Designed ETL strategy for both Initial and Incremental Load.
• Created the conceptual and logical designs for target system using Erwin 4.0.
• Constructed mappings using Mapping designer for each target table according to the business specifications.
• Used Informatica transformations like Lookup, Filter, Router, Expression, Aggregator, Joiner, Stored Procedure, Sequence Generator, Update Strategy and SQL extensively to transform the data according to the target tables design and constraints.
• Developed PL/SQL procedures, functions to accommodate functionalities otherwise not possible in Informatica.
• Developed UNIX Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables
• Tuned mappings to provide improved performance.
• Extensive use of Informatica repository queries in conjunction with metadata manager
• Automated many process using in built Informatica features. This reduced 15% of tickets per year and help support effort being utilized for other improvements
• Actively involved with users to resolve issues due to data/design discrepancies.
• Lead a team and helped them train in day to day development and support activities.

Environment: Informatica 8.6/ 9.1.0, Metadata Manager 9.1, DVO, Oracle 10g, SQL Server 2005, TOAD 7.5, Shell Script, Microstrategy Desktop Windows XP Professional, Sun Solaris

Confidential

ETL developer/Data Analyst

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• For Customer system, developed logical & physical data model by defining strategy for Star schema with Fact & Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Used Informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and performed loading.
• Performed data analysis on the source data coming from legacy systems.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookups and stored procedures.
• Created source, target, lookups, transformation, session, batches and defined schedules for those batches and sessions.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked with Informatica Power Center - Designer tool in developing Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Gathered business scope and technical requirements.
• Used transformations like Source Qualifier, Joiner, Update, Lookup, Stored procedure, Expression and Sequence Generator for loading the data into target Data Mart.
• Created events and tasks in the work flows using workflow manager
• Prepared the Schedules for the Historical Load run and regular Load runs.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export, Data Conversions and Data Cleansing
• Troubleshooting Informatica session failures and analyzing logs
• Fine tuning SQL procedures to resolve business queries
• Designed and developed shell scripts to enhance support activities.
• Creating, Scheduling and maintaining the reports in Business objects.
• Analyzing the business logics behind the BO reports to help resolve the report related issues.
• Fine tuning Informatica

Environment: Informatica PowerCenter 7.1/6.2, PowerConnect, Erwin 4.0, Business Objects 6.0, SQL Server 2000, SQL*Loader, Oracle 9i, DB2 8.0, Sun Solaris 5.8, Windows 2000

Confidential 

Level 3 Subject Matter Expert

Responsibilities:

• Performing L3 SQL DBA activities and working at client’s location.
• Work on High availability options: Replication (on its setup and failures).
• Maintenance work on different production databases (e.g.: freeing up space or adding data/log files etc.,)
• Look into the health of the Production Databases.
• Handling SQL Clustering Failover.
• Taking escalations from L1, L2 and Partner Account Managers situated in various Regional Operating Centers all over the world.
• Also worked as a Incident coordinator managing a team of 6 members
• Validating the Data Change Requests, raising a Request for Change to Change Management.
• Root cause analysis of the Incidents and Problems.
• Raising a bug to Development team and in depth discussion of the problem and steps to be taken to avoid the recurrence of the incident.
• Engaging with the Release management team and implementation of the release.
• Extraction of data for ad hoc request from partners and customers.
• Maintain the availability of Applications all the time.
• Categories the incident if it’s a Major Incident and follow the process to engage different teams to fix the problem with minimal business impact.
• Initiate Hot Fixes and drive the process to implement the changes for high impact code issues.
• Prepared documentation and KB articles of the issues which helped to reduce tickets and escalation to a great extent.
• Also received spot award of the month during this project.

Environment: Confidential Service Enterprise (MSE), ITSM, Password Updater, Sitescope, Appmon, RDCM, VSTF, Bugger, Product Studio, MS SQL Server 2005