SUMMARY

• About 8 years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica PowerCenter 9.5.1/9.1/8.6.1/8.1 - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience with Relational and Dimensional Modeling using Star and snow flake models for Data warehousing application.
• Experience in Automation & scheduling of processes, and Informatica sessions using Informatica Scheduler.
• Proficient in all phases of teh Software development lifecycle, including requirements definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Experience with development and maintenance of Informatica mappings, workflows and other tasks, experience in creating reusable objects.
• Implemented Slowly Changing Dimension methodology for accessing teh full history of accounts and transaction information.
• Experience in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type me, Type II, Type III slowly changing dimensions.
• Experience in implementing update strategies, incremental loads and Change Data Capture.
• Has worked with various databases like Oracle 11g/10g, SQL Server 2005/2008/2012 and DB2/UDB.
• Experience in using SQL, PL/SQL, TOAD and SQL Developer.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in different databases.
• Automation and scheduling of Informatica jobs using CRONTAB and AutoSys.
• Created UNIX scripts for parsing & modifying data, data validation, job scheduling, FTP and notification emails.
• Experience in database development skills using Oracle PL/SQL to write stored procedures and functions.
• Multiple Oracle ERP Applications life cycle experience with strong business skills.
• Other experiences include: methodology development, process re-engineering, facilitated sessions, proposal development, functional testing and software metrics & other quality assurance techniques.
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6/8.1

Reporting Tools: Business Objects, Oracle Business Intelligence, Crystal Reports

Data Modeling: Erwin 7.2/4.0/3.5

Databases: Oracle 11g/10g, MS SQL Server 2012/2008

Languages: SQL, PL/SQL, C, C++

Tools: SQL plus, TOAD, Autosys

Quality Assurance: Mercury Test Director 7.2, HP Quality Centre, JIRA

Operating Systems: UNIX, AIX, Windows (XP, NT/95/98/2000,Win 7)

PROFESSIONAL EXPERIENCE

Confidential, Union, NJ

Informatica Lead Developer

Responsibilities:

• Design and Develop Sales Audit process to capture transactional data from Amazon and load it to teh database for other Business Settlement processes.
• Experience in Automation & scheduling of processes, and Informatica sessions using Informatica Scheduler.
• Worked with Business Analyst to gather business requirements and involved in weekly team meetings.
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Data Quality Analysis to determine cleansing requirements and also responsible for teh data cleansing activities on source data.
• Integrated data from diverse source systems including MS SQL Server, Oracle and flat files into Oracle using Informatica PowerCenter.
• Responsible for solving complex data design and data retrieval/integration issues.
• Analyzing teh data model and Identification of heterogeneous data sources.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.
• Implemented Slowly Changing Dimensions Type II for teh Change Data Capture Process.
• Created Reusable Transformations and Mapplets in teh designer using transformation developer and mapplet designer according to teh business requirements.
• Improved Performance by tuning SQL Queries at mapping levels. Tuned performance by changing index and data cache sizes, DTM buffer size and target based commit intervals.
• Created and scheduled workflows using Workflow Manager to load teh data into teh Target Database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Autosys Scheduler to run teh Informatica session on a daily basis.
• Designed and created test cases for Unit testing for job validations. Also was in support team for teh UAT and soft launch phases.

Environment: Informatica PowerCenter 9.5, Oracle 11g, SQL Server 2012, TOAD, Autosys, AIX UNIX 5.3, MS Office.

Confidential, Reno, Nevada

ETL Developer

Responsibilities:

• Involved in Dimensional modeling of teh Data warehouse and used Erwin to design teh business process, grain, dimensions and measured facts.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement teh business logic and to load teh data incrementally.
• Worked on performance tuning of SQL and mappings by usage of SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• Involved in developing mappings as per teh requirement of teh business users to manage change data capture and implemented Slowly Changing Dimensions type me and type II.
• Involved in reviewing of code and Technical Support to teh Team.
• Responsible for conducting teh System and Unit Testing using Control-M.
• Worked with Persistent Caches for Conformed Dimensions for teh better performance and faster data load to teh data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed teh bugs.
• Used Workflow Manager for session management, database connection management and scheduling of jobs to be run.
• Troubleshoot workflows and sessions for daily and monthly extracts from various data sources across all platforms to teh target database.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Wrote various shell scripts for pre-processing of data and scheduling of jobs.
• Worked on HP Quality Center for Unit and Integration testing.

Environment: Informatica PowerCenter 9.0/9.1, ERwin 7.2, Oracle 11g, SQL Server 2008, SQL, TOAD, AIX UNIX, Control-M, HP Quality Center, MS Office.

Confidential, Wilmington, DE

Informatica Developer

Responsibilities:

• Involved in various meetings with business analysts and DBA(s) for better understanding of business requirements.
• Designed and developed Informatica mappings for data loads using various transformations like Aggregator, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union.
• Performance tuning of teh Informatica mappings using various components like Parameter files, Variables, Session Partitioning and lookup Cache size.
• Performed change data capture process using Type me and Type II implementations.
• Developed Mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Development of logical and physical test cases.
• Studied Session Log files to find errors in mappings and sessions.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data
• Worked on Balance and Control mechanism as a part of error handling and data validation processes.
• Developed PL/SQL procedures to implement business logic, Involved in query performance tuning and Informatica ETL tuning.
• Extensively involved in ETL testing, Created Unit test plan to test teh mappings, created test data.
• Performed code reviews and handled change request.

Environment: Informatica PowerCenter 9.0, Oracle 11g, SQL Server 2008, UNIX, Business Objects Enterprise XI3.

Confidential, Maple Grove, MN

Informatica Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and requirements gathering.
• Worked with users and developers on requirement issues and gap analysis.
• Developed and Implemented ETL processes using Informatica client tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Designed and developed complex aggregate, join, look up transformation rules to generate consolidated (fact/summary) data.
• Involved in Change data capture process using Slowly Changing Dimensions.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase teh efficiency of session.
• Involved in teh process of scheduling Workflows using AutoSys.
• Involved in developing SQL Scripts for extraction and loading of data to data warehouse.
• Developed Test Cases for Unit Testing, and also involved in Integration, system, and performance testing levels.
• Create and maintain shell scripts for pre/post session operations.

Environment: Informatica PowerCenter 8.6/9.0, Oracle 10gR2, SQL Server 2008, TOAD, AIX, Autosys.

Confidential, Ashford, TN

Informatica Developer

Responsibilities:

• Involved in requirement gathering from teh business users and converted them into mapping documentation.
• Created mapping documents with teh required Transformation logic, Sources and Targets for Facts and Dimensions.
• Involved in analysis and design of physical and logical data models for Enterprise data warehouse with a pool of various data marts.
• Analyzed dependencies and developed transformation logic for various enhancements and integrating various sub marts.
• Developed various slowly changing Type1, Type2 and slowly growing dimensional mappings according to teh data mart schemas for teh Change data capture.
• Created Connected and Unconnected Stored Procedure Transformations for pre & post load sessions.
• Developed Workflows for initial loading, historical data loading, Near Real Time data loading and Recovery data loading using sessions, worklets, commands, decisions, events and timers.
• Worked with Memory management for teh better throughput of sessions containing Rank, Router, Expression, Transaction control, Joiner, Sorter, Lookup and Aggregator transformations and involved in pipeline partitioning.
• Migrated workflows from Repository Manager to include all sources, targets, mapplets, mappings, sessions, worklets, workflows and scheduled jobs for those workflows to QA and Prod.
• Developed UNIX shell scripts to get data from external systems flat files to EDW stage area, and to schedule various workflows to load teh data into target system.
• Developed and Scheduled workflows using workflow manager created and modified parameter files according to teh business requirements.
• Provided production support for Business Users and documenting problems and solutions using Test Director.
• Tested teh reports manually and made them look easier and correct.
• Performed teh Database testing on teh databases to check whether teh data is generated to reports successfully.
• Involved in design meeting with Data Architect, Preparation of Test Scenarios, Test Plans, Test Cases.

Environment: Informatica PowerCenter 8.1/8.6, Oracle 10gR2, SQL Server, UNIX, Test Director.

Confidential 

PL/SQL Oracle Developer

Responsibilities:

• Communicated with clients regarding system requirements, ensuring teh development and implementation of customized products to customer satisfaction.
• Prepared functional specifications for user requirements.
• Developed and modified applications, authored database procedures and triggers for data processing. Developed PL/SQL Packages, Procedures, Database Triggers and Functions to implement business logic.
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Involved in creation of schema objects, roles and privileges, users.
• Prepared User manual, Technical documents for teh end user.
• Prepared executables for system deployment and led teh release of applications following
• Implemented teh system at various client sites.
• Maintenance and support for teh system. Involved in end user training.

Environment: Windows NT/95, Oracle 10g, SQL Server 2005, UNIX, SQL*Loader, PL/SQL