SUMMARY

• Around 6 years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using Informatica Power Center 9.x/8.x as ETL tool.
• Extensive experience with ETL Informatica Power Center Client tools in designing and developing Mappings, Mapplets, Sessions and Workflows.
• Extensive experience in creating and managing Tables, Views, Indexes, Stored Procedures, Triggers and UDFs using T - SQL as well as analyzing and debugging existing complex stored procedures
• Hands on experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, Teradata, DB2 UDB and SQL Server databases.
• Hands on experience with Informatica Administration and various upgrades.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center Client.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables.
• Good understanding of development life cycle of projects with Informatica, Oracle and Teradata.
• Experience writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.
• Proven experience with writing and technical requirements analysis.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Knowledge of Software Testing and Quality Assurance.
• Excellent communication and writing skills and capable of working successfully both in teams and independently.
• Ability to self-manage time and task priorities to meet project timelines, and identify potential project risks.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Experience in Data Modeling using ERWIN.
• Used 3rd generation programming languages like C++, COBOL & Java.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 8.6/8.1/7.x/6.x

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin

DATABASES: Oracle 10g/9i, Microsoft's SQL Server 7 0/2000/2005/2008/2012. , MS Access, Sybase, DB2,MySQL,Teradata V2R6

PROGRAMMING: C, C++, SQL, PL/SQL, HTML,UNIX Scripting

REPORTING TOOLS: Business Objects, OBIEE

OPERATING SYSTEMS: Windows XP,7, MAC, Sun Solaris, UNIX

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6

MANAGEMENT TOOLS: MS-Office 2007, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Worcester, MA

Consultant Sr. ETL Developer

Responsibilities:

• Provided 24X7 on call support which included monitoring morning and nightly jobs and emergency production fixes.
• Worked with installing, designing and managing MS SQL Server 2008 R2.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Responsible for creating datasets using T-SQL and stored procedures
• Coordinated the Change Management process which involved driving the QA and production deployments.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Working on new projects to fulfill the business needs.
• Documented the scope of new development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Involved in providing the solutions for production support job failures at Tier-2 level.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.

Environment: Informatica Power Center 8.6,Oracle 10g, DB2 UDB, UNIX (Sun-Solaris), UNIX (AIX 6.2), Harvest, SQL Loader, Autosys, Visio, Synsort, TOAD for Oracle, SQL Developer, Windows XP.

Confidential . Chicago, IL

Consultant Data Analyst

Responsibilities:

• Used SQL developer to run the queries to verify the data with the existing GUI functionality.
• Involved in creation of test plan and test cases for testing the enhanced functionality of MBOX.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.
• Developed ETL code by the business logic defined in the Functional Design Document.
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Conducted business requirements and source system analysis to arrive at optimal ETL designs.
• Develops new ETL applications from simple to moderately complex scope, works with basic applications systems design specifications; and utilizes Company standards, procedures, and techniques.
• Partnering with project managers and development resources to assist with design changes and design decisions.
• Worked with creation of reports for decision support.
• Involved in analysis of the data in the development and test environment.
• Work with analog team to test the existing application.
• Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.

Environment: MBOX (digital and analog), Oracle 10g, SQL developer, UNIX, Windows XP, JIRA

Confidential Chicago, IL

ProgramAnalyst/ETLDeveloper

Responsibilities:

• Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, Mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the Informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in *on-call* support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Power Center 8.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script.

Confidential

Database Developer/ETL Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Involved in Creation and designed required tables, indexes and constraints for all production activities.
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center.
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
• Used SQL, PL/SQL for database related functionality.

Environment: Informatica Power Center 6.1, Oracle 8.0, SQL Server (7.0), SQL, Sybase, PL/SQL, Erwin, UNIX, Windows XP, C.