SUMMARY

• Around 8 years of extensive IT experience wif excellent experience working in Database/Data Warehousing area, majorly in analysis, designing, development and implementation of business systems in various environments.
• Six plus years of working experience in ETL development process for Data Warehousing, Data migration and Production support.
• Expertise in Data warehousing concepts and Dimensional modelling (Star and Snowflake Schema) using ERwin.
• Experience in Installation and Configuration of Informatica Power Center on Client/Server environment
• Extensive Data Warehouse experience using Informatica Power Center, Informatica PowerExchange (CDC) for designing and developing transformations, mappings, sessions.
• Proficient wif Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Proficient in developing JOB streams, Box JOB for scheduling and configuring workflows.
• Experience wif Relational and Non - Relational databases me.e. Oracle 11g/11i/10g/9i, SQL Server, DB2, Teradata SQL Assistant and flat files, XML and Spreadsheets.
• Hands on experience in Oracle, SQL and PL/SQL Development me.e. Stored Procedures, Functions, Triggers and Packages Development using SQL Developer, SQL *Loader and TOAD Development tool, & working noledge of SSIS, SSMS.
• Experience wif TOAD to test, modify and analyze data, create indexes, and compare data from different schemas
• Experience in Performance tuning of sources, targets, mappings and sessions
• Experienced in developing UNIX shell scripting & Scheduling for ETL processes.
• Developing experience of Reports and Charts using Cognos 8.0 and Oracle Hyperion System 9(BI+).
• Strong noledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation.
• Excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1, 8.6.x, 7.x, 6.x, PowerExchange, IDQ

OLAP/Reporting Tools: Oracle Hyperion System 9(BI+), Cognos 6.0, OBIEE

Databases: Oracle 11g/11i/10g/9i, SQL Server 2008 DB2 (UDB), AS400 DB2, Teradata v2r5.0/v2r6.0

Operating Systems: Windows NT, 2000, XP, 2003, Red Hat LINUX, UNIX, HP-UX, AIX, Sun Solaris 5.11/7.0/8.0 , MS-DOS

Languages: SQL, PL\SQL, C, C#, C++, T-SQL, Unix Shell Scripting

Tools: /Utilities: SQL * Loader, Toad, ERwin, Crontab, Autosys, Teradata SQL Assistant 12.0.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Analyzed teh source data, Coordinated wif Data Warehouse team in developing Relational Model and Participated in teh Design team and user requirement gathering.
• Created SSIS packages for getting teh data from AS 400 into SQL Server
• Built Data Transformation Services (DTS) packages for ETL using DTS wizard
• Created teh NZ HOST, NZ DATABASE, NZ USER, NZ PASSWORD environment variables on each server.
• Aware of teh Netezza terms FPGA, SPU, snippets.
• Created generate statistics, generate express statistics in Netezza.
• Configured RPD and DAC.
• Created teh Visio diagram for Informatica workflows to be scheduled in DAC.
• Scheduled workflows in DAC and populated teh Reporting layer of OBIEE.
• Maintained user accounts in DAC.
• Created teh source system containers, customized teh data warehouse load, manipulated teh columns in data warehouse tables etc in DAC.
• Created teh custom logical/physical folders in DAC.
• Created stored procedures (NZ-SQL).
• Scheduled teh ELT load in Control-M.
• Validated teh target data using workbench Aginity of Netezza.
• Created teh RPD for OBIEE.
• Worked on creating physical layer, business model, mapping and presentation layer in OBIEE.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Retrieved data from SAP using Informatica
• Debugged and corrected teh xfr files developed by other ELT developers.
• Fixed numerous bugs wif load issues.
• Optimized teh NZ-SQL queries.
• Created teh format of teh unit test documents per Netezza Framework.
• Assisted ELT developers in creating teh unit test documents.
• Managed user and folder permissions for teh developers.
• Purged old repository objects weekly.
• Created shell script for repository backup weekly.
• Developed data Mappings between source systems to Landing and from Standardization to warehouse components using Mapping Designer.
• Did performance tuning on teh ELT code developed by ELT developers.
• Debugged teh framework error logs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Problem resolution involves resolving teh issues raised by teh client/actuarial users, validation of teh data in teh database or in teh application functionality.
• Worked closely wif QlickView Developers.
• Retrieved data from MQ Series sources.
• Expertise in teh optimization of teh performance of teh Designed workflows processes in Informatica and to identify teh bottlenecks in different areas after teh full volume system run.
• Implemented Slowly Changing Dimension methodology for accessing teh full history.
• Created Several Informatica Mappings to populate teh data into dimensions and fact tables.
• Worked cooperatively wif teh team members to identify and resolve various issues relating to Informatica and other database related issues.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Developed Workflows and session to load data into targets.
• Extensive use of Command tasks, Decision tasks, email tasks in teh workflow design.
• Developed teh Test Scripts and performed teh Unit Tests on teh ETL mappings.
• Used DT/designer to validate teh physical model of data warehouse or data mart
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure etc.
• Scheduled sessions and work flows using Autosys / Informatica scheduler.
• Worked wif pre and post sessions and Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in teh workflow manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed teh Test Scripts and performed teh Unit Tests on teh ETL mappings.
• Successful code migration from DEV to Testing & Production environment

Environment: Informatica Power Center 9.5.1/9.1.0 HF1 / Informatica PowerExchange, Informatica Data Transformation/ Data Exchange (B2B), Netezza 7.2.0, Embarcadero DT Studio 8.6.1, Embarcadero Rapid SQL, Oracle 11g, Oracle EBS, DAC, OBIEE, IDQ (Workbench) 9.0.1, Oracle 10g, PL/SQL, SQL Assistant, Erwin 7.2, MS Visio, Control-M, Microstrategy.

Confidential, Boca Raton, FL

Sr. Informatica Developer

Responsibilities:

• Created batch scripts to rename/copy and move teh processed files.
• Created a Console Application to send and receive xml file to and from an URL.
• Responsibilities include Production Implementation, Scheduling, Data Loading, Monitoring, Troubleshooting and Support for Global Operations Reporting using Informatica and Business Objects.
• Created teh deployment document to be followed for migration of code from one environment to another.
• Worked on Informatica MDM, maintaining teh master data repository in Oracle.
• Created custom rules for identifying teh duplicate master data into multiple systems.
• Created MDM data lineage using Informatica MDM (Siperion).
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer, Workflow Manager.
• Extensively used most of teh transformations of Informatica including lookups, Stored Procedures, Update Strategy.
• Used Workflow Manager for creating and maintaining teh sessions and also to monitor, edit, schedule, copy, aborts and deletes of teh session.
• Extensively worked in performance tuning of teh programs, ETL Mappings and processes.
• Attended POC of GreenPlum DataBase.
• Involved in configuring GreenPlum for parallel processing for loading and querying.
• Involved in configuration of Power Connect of Informatica Power Center for GreenPlum.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Created shell scripts to take teh repository backup’s and archiving it for 7 days.
• Used database level Greenplum partitioning and Informatica hash partitioning.
• Did production support after development work is done.
• Design & Customizing teh Business process using Informatica transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, Update Strategy Transformations.
• Analyzed teh systems using Reverse Engineering, met end users and worked wif business units in defining teh requirements of teh project.
• Participated in business requirements and design analysis meetings.
• Analyze Oracle, SQL Server and flat file sources.
• Extensively used SQL and PL/SQL scripts for loading teh database tables.
• Designed mappings in Informatica 5.1 using transformations like update strategy, lookup, Router, Filter, sequence generator, joiner, aggregate, expression transformation.
• Develop reusable transformations and mapplets using transformation developer and mapplet designer.
• Design complex mappings involving target load order and constraint based loading.
• Developed various mappings & mapplets to load data from various sources using different transformations like, Expression, Lookup, Aggregator, Update Strategy, Joiner, Router and Filter to store teh data in staging area/target tables.
• Set up batches and sessions to schedule teh loads at requested frequency.
• Troubleshoot mappings and performance tuning of mappings by identifying source, target and mapping bottlenecks.
• Error checking and testing of ETL procedures and programs using Informatica session log.
• Create training documents and assist in End User training.

Environment: Informatica Power Center 9.1/8.6.1,Power Exchange, DB2, UNIX Sun Solaris, Oracle 11g, PL/SQL,SQL Server 2008 R2,SQL,GreenPlum, Business Objects, MS Access, MS Visio, Autosys, TOAD 9.7.2.

Confidential, Minneapolis, MN

Sr. Informatica Developer

Responsibilities:

• Extracted data from SIM datasets and stored in a staging area using Informatica (truncate and Load).
• Data cleansing, translation, true derivative and true assumptions logic were applied to teh data to create seriatim database tables.
• Analyzed business requirements and worked closely wif various application teams and business teams to develop ETL procedures dat are consistent across all applications.
• Interacted wif Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Involved in up gradation of Informatica Power center from version 8.6.1 to 9.1
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed teh source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Created Parameter files and validation scripts.
• Analyzed teh source fields and wrote PL/SQL queries for field to field validation by referring source to target mapping document
• Used Mload connection and created used custom Mload Scripts from command task.
• Created Process Control and Metadata for informatica jobs.
• Used User Defined Functions for converting SAP values.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Did production support after development work is done.
• Responsible for teh Performance tuning at teh Source Level, Target Level, Mapping Level and Session Level.
• Created teh labels/deployment groups for code migration.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, SQL Assistant, Control-M, Putty, BTEQ.

Confidential, FAIRFAX, VA

Sr. ETL / Database Developer

Responsibilities:

• Responsibilities include Production Implementation, Scheduling, Data Loading, Monitoring, Troubleshooting and Support for Global Operations Reporting using Informatica and Business Objects.
• Extensively worked wif teh solution architect to implement teh project from scratch.
• Training team members to run and monitor workflows in Informatica.
• Lead teh team of change Management.
• Created extensive T-SQL procedures.
• Created SSIS packages to get teh data from teh flat files and load it into Oracle 11g.
• Created teh deployment document to be followed for migration of code from one environment to another.
• Created teh metadata layer for OBIEE.
• Created batch scripts to rename/copy and move teh processed files.
• Designed conceptual, logical and physical data model using Erwin data modeling tool.
• Administrative role and monitoring and support for several projects in Staging and Production environments for Informatica and OBIEE.
• Created ETL Mappings to ensure conformity, compliance wif standards and lack of redundancy.
• Exceptional background in analysis, design, development, and implementation and testing of data warehouse development and software applications.
• Designed and developed Informatica mappings, to load data into target tables.
• Worked wif static and dynamic cache for teh better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Mapplets to be re-used in teh Informatica mappings.
• Developed ETL Mappings to ensure conformity, compliance wif standards and lack of redundancy.
• Did some MDM management using Informatica MDM tool.
• Worked on batch data process flows and consolidation flags in Informatica MDM.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer, Workflow Manager.
• Extensively used most of teh transformations of Informatica including lookups, Stored Procedures, Update Strategy.
• Used Workflow Manager for creating and maintaining teh sessions and also to monitor, edit, schedule, copy, aborts and deletes of teh session.
• Extensively worked in performance tuning of teh programs, ETL Mappings and processes.
• Developed Interfaces using UNIX Shell Scripts to automate teh bulk load & update Processes.
• Made performance improvements to teh database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Developed OBIEE RPD and DAC from end user’s input.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.

Environment: Erwin 4.2, Informatica Power Center 8.6.1, Informatica Data Replication 9.1.1 (IDR), Informatica MDM, Oracle 10g/11g, Teradata 13.1, SQL Developer, Crontab scheduler, SQL Server 2008 R2, SQL Server Management Studio, PL/SQL, SQL Assistant, Windows XP, Sun Solaris 5.1.0, UNIX scripting, OBIEE, IBM Vendavo Profit Analyzer.

Confidential, Barnesville, MD

Sr. Informatica Developer

Responsibilities:

• Installation & Configuring Informatica 8.6 on UNIX (SUNos 5.11), Also configuring teh High availability option for teh same.
• Configuring teh domain wif various application services like repository services & integration services.
• Flexible implementation & maintain teh file system for teh above mentioned Data Marts, using soft links on multiple VTIER.
• Performed Informatica PowerCenter HotFix upgrade / TOMCAT upgrade to meet teh Organization security standards.
• Creating & maintaining user, groups for Development repository and Quality Check.
• Maintaining teh repository & purging teh repository objects & Archiving Periodic repository backup.
• Involved in Gathering and Analyze business requirements for teh DLC / OT conformed to teh business rules &
• Design & Customizing teh Business process using Informatica transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, Update Strategy Transformations.
• Created Reusable Transformations Logic and Mapplets to use in Multiple Mappings and also worked wif shared folders, shortcuts.
• Developed Informatica mapping to handle dynamic partition me.e, to create/add & Archive partitions of an oracle data base tables.
• Flexible Implementation of mapping, sessions and workflows using Parameter file/Global parameters and by implementing Informatica Best Practices
• Worked wif various relation and non relational sources like FF (Direct / Indirect), JMS Queues, Relational Tables and ERP systems.
• Significantly Involved in teh analysis and Implementation of Performance Tuning techniques for SQL, Transformations, Mappings, Session
• Developed & Tuned DML/DDL SQL’s to implement Data modeling changes, Also developed PLSQL procedure to handle teh Informatica JOB metadata.
• Providing teh Functional and Technical specification for designing customized workflows & their automation.
• Implemented MDM and Maintained data Integrity by eliminating teh redundancy.
• Defined teh data model elements, relationship types, global business identifier flags (GBID) in Informatica MDM.
• Configured teh stage objects wif execution components, cleanse components, cleanse match servers etc.
• Configured teh Merge process for match and merge process, population etc.
• Batch processing for Informatica MDM includes data stewardship, batch group etc.
• Flexible Implementation of mapping, sessions and workflows using Parameter file/Global parameters and by implementing Informatica Best Practices
• Change data capture by multiple level scheduling of session and workflow.
• Developed various shell scripts using PMCMD command line program, to execute and maintain teh workflow jobs.
• Web logic performance Testing using teh HP load Runner.

Environment: Informatica PowerCenter 8.6, Informatica MDM (Siperion), Erwin Data Modeler, Oracle 11g/10g, Oracle 11i (ERP), Teradata V2R6.2, Teradata 12, Compass, TOAD 9.6, OBIEE Reporting, Windows NT/2000, UNIX SUNos 5.11, HP Load Runner 9.50.

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Analyze business requirements to build a data mart design for various business processes conformed to teh business rules.
• Improved integrity by Identifying and creating relationships between tables
• Actively involved in upgrading Informatica Power Center from version 7.1 to version 8.6
• Involved in import/export of repositories, backing up teh repository
• Worked on variety of data sources such as Oracle, Flat Files, Salesforce.com and XML.
• Extensively worked wif Source Analyzer, Warehouse designer and Mapping Designer for developing mappings based on teh business logic.
• Implemented CDC using Informatica power exchange to update several tables in near real time for oracle tables.
• Developed various transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, and Update Strategy Transformations.
• Implemented IDQ Transformation for heavy cleanup and massaging of teh staging tables to eliminate teh redundant data, and check for attributes details.
• Created Reusable Transformations Logic and Mapplets to use in Multiple Mappings and also worked wif shared folders, shortcuts.
• Flexible Implementation of Mapping using mapping parameters & session variables.
• Implemented TEMPeffective Performance tuning procedures using Pushdown Optimization, concurrent caching, auto memory calculations.
• Created various UNIX Shell Scripts for pre/post session commands for automation of loads using Autosys.
• Used Workflow Manager to create workflows, worklets wif different tasks (Session, Decision, E-mail, Event-Raise and Event-Wait).
• Monitored workflow and review error logs generated for each session using workflow monitor.
• Extensive experience working wif SQL and PL/SQL commands, scripts and used command line program pmcmd to start/schedule/stop workflows.
• Worked wif Hyperion Essbase, Hyperion Planning and HAL.
• Experienced in Developing Hyperion Essbase Cubes, Hyperion Planning Cubes Load Rules from text files and Oracle server and also develop calc script.
• Created and mapped HAL jobs to load teh hierarchies into different planning applications.

Environment: Informatica PowerCenter 7.1, 8.6, Oracle 9i/10g, Windows NT/2000, UNIX, TOAD 7.6, Autosys, Oracle Hyperion system9 (BI+), MS Visio.