SUMMARY

• Over 7+ years of Total IT experience in Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Development, Testing of software systems in the ETL/DW environment.
• Strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool INFORMATICA POWER CENTER 8.x/ 9.0.1/9.1.0/9.5.1 , Power Exchange 8.x/9.5.1 and UNIX Shell Scripting
• Proficient in Dimensional Data modeling and Relational Star Join Schema/ Snowflake models, FACT & Dimensions tables, Physical & logical data modeling and Ralph Kimball Methodologies.
• Strong database experience using Oracle, SQL Server, Teradata, SQL, PL/SQL, SQL*Loader, Stored Procedures, TOAD, MS Access and UNIX Shell scripting.
• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Extensive experience and noledge of the project lifecycle, including requirements gathering, development and execution.
• Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Team player with good communication skills, written skills, technical documentation skills and also a self - motivated individual with exemplary analytical and problem solving.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.x/8.x/7.x/6.x, Power Exchange, ETL, ETI, Data mart, OLAP, OLTP, Mapplets, Transformations, Control M, IDQ, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Dimensional Data Modeling and Relational Data Modeling using, Star Join Schema/Snowflake modeling, FACT & Dimension tables

Business Analysis/Data Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office, Visio.

Database: SQL Server 2008/2005, Oracle, SQL*Loader, Teradata

Programming: SQL, PL/SQL, T- SQL, C, Unix Shell Scripting.

Environment: Windows NT/XP/2003, Unix, Sun Solaris, MS-Dos.

Reporting Tools: Business Objects

PROFESSIONAL EXPERIENCE

Confidential, CT

Informatica Developer

Responsibilities:

• Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
• Provided expert advice, counsel and technical expertise to the project team to halp assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
• Produce detail design document, low level design document and involved in code/document review. Participated in the maintenance and enhancement of the application and perform bug fixing
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.5.1
• Worked with PowerCenter Designer tools in developing mappings and mapplets to extract and load the data from various sources.
• Developed various Informatica mappings using various transformations like Sorter transformation, expression, sqlqualifier, lookups, Aggregator transformation, Normalizer Transformation and Joiner transformation.
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files, Oracle and Teradata to Teradata
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Modified Workflows and Mappings to accommodate the new features of log files in Informatica
• Modified Shell Scripts to facilitate the implementation of Informatica Upgrade Project.

Environment: Informatica-Power Center 9.5.1,Oracle 10g, Flat Files, SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, LINUX v 2.4.36,SecureCRT 4.1.0,Control-M 7.0 and Windows NT

Confidential, Virginia Beach, VA

Informatica Developer /Production Support Consultant

Responsibilities:

• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
• Worked closely with Business Analysts and SME’s to understand Business requirements and change requests of clients and implement with my team.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to Oracle.
• Developed mappings to bring in data from various sources across Staging, ODS to Reporting.
• Created mapping variables and parameters for incremental loading.
• Used all Transformations such as Expressions, Filters, Joiners, Aggregators, Lookups, Update strategy, Sequence Generator, Routers to load consistent data into database.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions and eliminating bottlenecks.
• Created and Monitored sessions and workflows for daily extract jobs using Informatica Power Center, Workflow Manager and Workflow Monitor.
• Deployed objects across various environments from various developer folders in development, Test and Production productions.

Confidential, Newyork, NY

Informatica Developer

Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze and document business requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Involved in customizing out of the box reports to support the business requirements.
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation.
• Provided expert advice, counsel and technical expertise to the project team to halp assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices.
• Implemented ETL standards and Best Practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Involved in Informaticacode migrations and monitoring according to Informatica standards
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 8.6.1
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Involved in automating the Informatica process by using Unix Shell Script.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g,Toad 9.6.1,Metadata Manager 8.6.1, SQL,PL/SQL, Unix Shell Scripts, SQL Navigator 4.5, F-Secure SSH 5.3 and Sun Solaris 9.0

Confidential

Informatica Developer

Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Implemented ETL standards and Best Practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Involved in Informaticacode migrations and monitoring according to Informatica standards
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 8.6.1
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files, Oracle and Oracle
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Migrated mappings and sessions and work flows from dev/test to production environment.
• Involved in automating the Informatica process by using Unix Shell Script.
• Written documentation to describe program development, logic, coding, testing, changes and corrections. Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes

Environment: Informatica Power Center, Oracle 10g, Teradata, UNIX Shell Scripting, SQL, PL/SQL, Toad, SQL*Loader, SQL Server.

Confidential, Nashua, NH

Informatica Developer

Responsibilities:

• Requirement analysis in support of Data Warehousing efforts.
• Designing and customizing data models for Data Warehouse supporting data for multiple sources on real time.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Maplets Designer and Transformations Developer.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Created various data marts from data warehouse and generated reports using Business Objects.

Environment: Informatica PowerCenter 8.6.1, Toad 9.7,Data Validation Option, Metadata Manager 8.6.1,Data Profiling, SQL, Unix Shell Scripts, F-Secure SSH 5.3 and Sun Solaris 9.0