PROFESSIONAL SUMMARY:

• 7 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 Power Center 9.1.0/8.0/7.1.1/6.1 - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience with Relational and Dimensional Modeling. Created Star and snow flake models for Data warehousing application.
• Proficient in all phases of the 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.
• Interacted with the business users during work at onsite location.
• Experience with development and maintenance of Informatica mappings, workflows and other tasks, experience in creating reusable objects.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Excellent capabilities in integration mappings including static cache lookup, dynamic, and persistence mappings for fact table mappings.
• Experience in implementing historical loads, incremental loads and change Data capture.
• Have worked with various databases like Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000 and DB2/UDB.
• Experience in using SQL, PL/SQL, TOAD, and PL/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.
• 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.
• Used various GUI Tools like Toad to check the output data while doing the Unit testing and in Production Environment.
• Experience in using Business Intelligence reporting tool,Business Objects, Cognos.
• Proficient inUNIX shell scripting, automation of ETL processes using Autosys.
• 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.1.0/8.6/8.1/7.1

Reporting Tools: Business Objects, Crystal Reports, Cognos

Data Modelling Tools: Erwin 7.2/4.0/3.5, Star Schema Modeling, Snowflake Schema Modeling, TOAD, SQL plus

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Teradata

Languages: C, C++,SQL,PL/SQLJob Scheduling: Informatica Scheduler, Autosys, UC4

Web Application Tools: HTML, Java

Operating Systems: UNIX, Windows 2003/2000/XP

PROFESSIONAL EXPERIENCE:

Confidential, Saint Paul, MN

ETL Informatica Developer

Responsibilities:

• Work with project teams in the design, development and deployment of solutions using domain technologies. Guidance includes, but is not limited to:
• Partnering with project managers, solution architects and development resources to assist with design decisions and estimates for project tasks related to domain technologies.
• Creation of deliverables and documentation per project delivery methodology
• Gather business requirements for data integration
• Design, code and test ETL processes
• Participate in daily standup meetings
• ETL developer for data integration of mainframe based data to SalesForce.com cloud services.
• Developer will gather business requirements; determine estimates and tasks to complete the work, complete the technical design, code and test.
• Worked on stored procedures to migrate the data from source database to target
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, filter, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migrating the code from dev to production and compared both codes.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Importing, scheduling and creating jobs using UC4 Job Scheduler

Environment: Informatica Power Center 9.1.0, Oracle 11g/9i, SQL Server 2012/2008, PL/SQL, SQL*Plus, Windows, UNIX, UC4 Job Scheduler v8

Confidential, Saint Paul, MN

Senior ETL Informatica Developer

Responsibilities:

• Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.
• Analyze the requirements for the data loading through the ETL process and provide solutions for the development of mappings
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, filter, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Designed and developed snow flaked /star schemas for better understanding of models using ERWIN.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migrating the code from dev to production and compared both codes.
• Scheduled Work flows on the Informatica Server using Informatica workflow Manager.
• Implemented Slowly Changing dimensions Type 1 &Type 2 methodology for accessing the Transaction history of accounts and transaction information.
• Designed and Developed the Informatica workflows/sessions to extract from different Data Bases, transform and load the data into oracle.
• Configured ODBC connectivity to various source/target databases.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the SQL queries inside the source qualifier.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Database connections and worked with sourcing files from multiple ftp sites.
• Wrote Unix Shell scripts to work with flat files and xml files.
• Developed various SQL queries and stored procedures.
• Wrote SQL queries for data and report validation in TOAD.
• Worked with Reporting team to create email alerts per site, by daily.
• Production Support & Maintenance.

Environment: Informatica Power Center 9.1.0, Cognos, Oracle 11g/9i, SQL Server 2008, PL/SQL, TOAD, SQL*Plus, Windows, UNIX.

Confidential, Seattle, WA

ETL Consultant

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Extracted the data from the 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 the business logic and to load the 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.
• As per the requirement of the business users to manage change data capture, implemented slowly Changing Dimensions type I and type II.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improved the performance of the mapping Involved in performance tuning on Informatica in all levels.
• Troubleshoot workflows and sessions for daily and monthly extracts from various data sources across all platforms to the target database.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Prepared prototype models using Erwin to support the development efforts.
• Wrote various shell scripts for pre-processing of data and scheduling of jobs.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, SQL, Cognos, Unix Shell scripts, Erwin, TOAD, AIX UNIX 5.1, MS Office.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Mainly involved in the ONSITE and OFFSHORE Communication for requirementsgathering from the Business users.
• Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system SNG.
• Responsible in developing the ETL logics and the data maps for loading the tables
• Responsible for Migrating from Development to Staging and to Production(deployments)
• Responsible of business requirement and analysis from business users.
• Designed for populating Tables for one time load and incremental loads.
• Design and development of Offline synching the applications of SIEBEL AND GARS both are OLTP applications.
• Generating and modifying the scripts for new mappings.
• Tuning of SQL queries under the tuning of session performance
• Creating the Mappings, Sessions, Workflows and Parameter files.
• Tuning the mappings for better performance and Performing Unit testing.
• Resolving the Bugs issues in Mappings, Sessions & Parameter file
• Preparing release note documents for different releases.
• Mentoring fresher’s in the team on Informatica.

Environment: Informatica Power Center 7.1.2, PL/SQL, DB2, Oracle 10g, TOAD, SQL*Loader, Oracle Reports Builder, Erwin 4.5, IBM AIX4.0, Shell Scripts, Autosys, PVCS, Windows 2000 and UNIX (server).

Confidential

ETL Developer

Responsibilities:

• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle.
• Used debugger to evaluate ETL timings and optimized SQL in mappings to run faster
• Workflow manager to create Workflow sessions to define mapping sequence
• Optimized mappings by using Aggregator, filter, Joiner, Expression, Lookups
• Created various active and passive transformations like Source Qualifier, Lookup, Router,Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica.
• Created parameter based mappings, Router and lookup transformations.
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups.
• Used Workflow Manager to design sessions, event wait/raise, and assignment, e-mail, and command to execute mappings.

Environment: Informatica Power Center 8.1, Oracle 8i, Windows 2000.

Confidential

ETL/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, Warehouse 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.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Scheduled Workflows using AutoSys.
• Involved in developing SQL Scripts for extraction and loading of data to data warehouse.
• Developed Test Cases for Unit Testing, also involved in Integration, system, and performance testing levels.
• Create and maintain shell scripts for pre/post session operations.

Environment: Informatica 7.1, Oracle 10g, PL/SQL, SQL Server 2000, TOAD, AIX UNIX 5.1

Confidential

PL/ SQL Developer

Responsibilities:

• SQL Loader was used to convert the data from the Excel to oracle tables.
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Sub-queries and joins were extensively used in stored procedures.
• Created database triggers to automate the transactions that take place online.

Environment: Oracle 8i, PL/SQL, SQL*Plus, SQL Loader, MS Excel, Windows 98.