SUMMARY

• Over 7+ years of IT experience with extensive experience inInformatica Power Center,Datawarehousing,Data Analysis,Reporting,Development, Maintenance,Testing and Documentation.
• Involved in OLAP data modeling, for both Star Schemas and Snowflake Schemas.
• Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories and handledMigrations to higher environmentsand executing the jobs on demand.
• Hands on experience inidentifying and resolving performance bottlenecks in various levels likesources, targets, mappings, and sessions.
• Experience using Parameters and pre - defined session variables with in worklets and workflows.
• Experience with InformaticaServerManagerto create Sessions and Workflows to run with the logic embedded in the mappings.
• Highly proficient in various Transformations - Lookup’s, Update strategy, Aggregator, Expression, Normalizer, SQL transformation, Transaction control, Joiner, Sequence generator etc.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience with writing daily batch jobs using UNIX shell scripts, and developing complexUNIX Shell Scripts for automation of ETL.
• Good understanding on Master Data Management (Golden record, match and merge concepts).
• Extensive experience in design documents, business scenario test cases, debugging and fixing the ETL’s and redeploying with emergency RFC’s into higher environments.
• Creating and modifying Packages, procedures, functions, cursor, materialized view etc. according to the business requirements.
• Proposed ETL strategies based on requirements.
• Designed and developed various complex SCD Type1/Type2 mappings, CDC, Incremental loads, bulk updates.
• Used Business Objects Data Servicesand customerOracle PL/SQLfor creating ETL solutions in an EDW environment.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided a team with maximum of five to seven developers in Informatica Power Center, peer reviewed their development works and provided the technical solutions.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meetoperational deadlines.

TECHNICAL SKILLS

ETL/Data Modeling Tools: Informatica Power Center 9.5/9.1/8.6. x, DM express, SSIS

RDBMS: Oracle 11g/10g/9i/8i, SQL Server, SQL, PL/SQL, Teradata

Tools: SQL *Plus, TOAD, SQL *Loader

Engagement Experience: Metadata Development/Customization, Applications Development, Application/ Integration Testing, Snow-Flakes Schema, Star-Schema Tables, Dimension Tables, Report Development, ETL Development, ETL Development, Query Performance Tuning, Application Debugging.

Operating Systems: Windows 95/98/NT/2000/XP, MSDOS, UNIX, Linux

Environment: HTML, XML, SQL, PL/SQL, MYSQL

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, MD

ETL Developer

Responsibilities:

• Conceptualizing, designing, developing and implementing the business requirements through Informatica mappings.
• Business analysis and requirements Gathering, designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Developed and designed Data marts extensively using Star Schema.
• Expertise and experience in ETL design, ETL performance tuning, BI reporting design and Data Modeling.
• Used Informatica Power Center to extract, transform and load data from heterogeneous systems (Mainframe systems, flat files, Oracle) to Staging and Data warehouse (DWH).
• Extensive SQL, PL/SQL, Stored Procedure, Packages and UNIX scripting skills.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter, source qualifier and Aggregator transformations.
• Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Responsible for creating indexes, partitions to increase performance and writing complex SQL and PL/SQL procedures and functions, queries for joining multiple tables.
• Implemented a partitioning strategy similar to Informatica's partitioning to increase parallelism.
• Performed tuning functions on Informatica sessions, batches and other related scripts.
• Extensively used almost all of the transformations of Informatica including lookups, stored procedures, Update Strategy and others.
• Solely responsible for the daily loads, handling the reject data and extensively worked in the performance tuning.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Used SQL tools TOAD to run SQL queries and validate the data in warehouse.
• Fixed invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica sessions, batches and the target data.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Maintained facts and Dimensions using Star Schema and Snowflake Schema.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Automation and scheduling of UNIX Shell scripts, Informatica workflows, SQL procedures.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Rigorous unit testing and functional testing to reduce the defects before QA.

Environment: Informatica Power Center 9.1, Scheduler, Work Flows, ETL, Visio, Flat Files, OBIEE 10.x, Oracle 11g, XML, PL/SQL, Citrix TIDAL, TOAD 9.6.1, Rational Clear Case, Rational Clear Quest, Lotus, Unix Shell Scripts, BASH, SQL Navigator, Windows XP.

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Involved in creating Informatica mappings in uploading the Data files into the Staging tables and then finally into Data Warehouse system.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target and Transformation objects.
• Extracted data from Flat files, AS400 sources and loaded in to Oracle staging and target tables applying business rules as per the requirement
• Developed Complex mappings to feed Data warehouse & Data marts by extensively using Informatica Mappings, Mapplets, and Transformations like Lookup, Filter, Router, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy.
• Created Informatica mappings with PL/SQL Procedures / Functions/ Triggers to build business rules to load data.
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables.
• Created different reusable tasks like email tasks to send email and command tasks to create, rename and delete files
• Scheduled and ran Workflows for Extraction, Loading processes and monitored the Workflows using Workflow Monitor.
• Implemented Performance tuning technique and Optimization of mappings for better performance and efficiency.
• Provide remedial measures to the production issues or process failure.
• Troubleshoot problems by checking Sessions and Error Logs.
• Also used Debugger for complex problem troubleshooting.
• Modified / Created parameter files in development, test and production environments using UNIX.
• Developed unit test scripts and test cases for unit testing and system testing.
• Involved in production deployments of the projects.

Environment: Informatica Power Center 9.1, TOAD, Oracle 11g, UNIX, PL/SQL, SQL Server, Quality Center.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Architecture the dataflow in the data-mart, extensively customized Bank’s traditional methodology, designed data flow diagrams, designed the best solution for data flow.
• Involved in discussions with business analysts for requirement gathering, understanding the requirements and explanation of technical probabilities and possibilities with business users.
• Created Time Estimate Proposal document with estimation of hours required for completion of each ETL task.
• Conversion of business requirements into technical documents - Business Requirement Document, explained business requirements in terms of technology to the developers.
• Worked with data modeler and business users for designing of tables.
• Analyzed the source data with business users, developed critical mappings using Informatica Power Center to load the data from DB2 to Oracle.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Worked extensively on Erwin tool on Logical and physical level Design.
• Assisted data modelers in database design and successfully brought database to 2nd Normal form.
• Worked with DBA's and boiled down where to Partition the Tables, adding Indexes to the columns.
• Unit testing the data and report generation for review of business users for special accounts.
• Developed UNIX shell scripts and used PMCMD to execute the workflows.
• Prepared documents for QA and PRODUCTION migration.
• Worked with business users and QA team during testing phases.
• Created Test cases for Integration testing and UAT. Reviewed UAT with business users.

Environment: Informatica Power center Designer 8.6, Oracle 10g/9i,Sql Server2000,BO XI R2, UNIX, COBOL,ERWIN 3.5, Shell script, Rapid-SQL, Toad, SQL *Loader, SQL, PL/SQL, PVCS, Visio, Auto Sys.

Confidential, Durango, CO

Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model.
• Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Used Ralph Kimball Methodology for building the data warehouse
• Developed Informatica mappings and also tuned for better performance.
• Worked with MLOAD, FASTLOAD, TPUMP and BTEQ utilities of Teradata for faster loading and to improve the performance..
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Application views are built through Harvest Change Manager Tool in desired schema in Teradata Warehouse and used as one of the sources for Informatica.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Analyzed existing system and developed business documentation on changes required.
• Used UNIX to create Parameter files and for real time applications.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.

Environment: Informatica Power Center 8.6.1, Teradata, Oracle 9i, Teradata SQL Assistant and Administrator, IMS Data, XML, LINUX, UNIX Shell Scripting, Harvest Change Manager, Rational Clear Quest.

Confidential, Bloomington, IL

ETL Developer/Admin

Responsibilities:

• Responsible for Business Analysis, DBA for requirement allocation, designing of data warehousing.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them

Environment: Informatica Power Center 8.x,Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL,TOAD, SQL * Loader, Sun Solaris 2.6, UNIX Shell Scripting.

Confidential

Informatica Developer & PI SQL Developer

Responsibilities:

• Involved in Analyzing the System requirements gathering, implementation of star schema & in designing and development of data warehouse environment.
• Developed mapplets, mappings using transformations like Filter, Joiner, Expression, Aggregate, Router, Lookup and Update Strategy transformations.
• Developed reusable transformations to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings, Created and Monitored Batches and Sessions.
• Involved in tuning the sessions, mappings and fine Tuned the SQL queries using hints for better performance.
• Written and executed UNIX shell scripts to automate few reports.
• Created complex SQL queries, Stored Procedures, functions and database triggers and Views for the purpose of data analysis.
• Developed Complex Reports (Used multiple data providers, Union, Intersection and Master/Detail, cross tab, Charts).
• Used Broadcast Agent Publisher for Report Bursting, so that each individual receives particular information in Excel format and Created Web I reports and deployed them through Info View.
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Planned coordinated and executed Business Objects deployment for End-users and documented the project.

Environment: Informatica Power Center 7.1.4, Oracle 9i, SQL, PL/SQL, Cobol, XML, SQL Loader, UNIX Shell Scripts, TOAD, Windows XP, VB, UNIX, Informatica Scheduler, BOs.