PROFESSIONAL SUMMARY:

• 9 years of Data Warehousing experience in Data Integration using ETL Informatica PowerCenter tools. Hands on end to end experience in software development life cycle (SDLC), starting from Requirement gathering, Analysis, Design, Development, Testing, Deployment and Production support of Data Integration projects to populate Data Mart and Data Warehouse.
• Strong knowledge in industry standard Business Intelligence Reporting tools like Business Objects and Cognos.
• Extensive hands on experience in various Relation Database management systems (RDBMS) like Oracle, SQL Server and DB2.
• Experience in both UNIX and Windows environments. UNIX Shell scripts and windows batch scripts to schedule the jobs.
• Very good knowledge and understanding of Dimensional modeling using Start and snow flake schemas.
• Profiling of Source data in various database environments and external flat files.
• Hands on experience in Data Cleansing, Exceptionand Error Handling Procedures; Implemented Slowly Changing Dimensions (SCD Type 1/2/3 Methods), extensively used Analytical, Aggregate, String, Numeric, Date and Conversion Functions.
• Extensively used transformations - Source Qualifier, Normalizer, XML, Expression, Aggregator, Rank, Sequence, Lookup, Update, Router, Filter, Joiner, Union, Sorter, Transaction Control, and Stored ProcedureTransformations in mapping development process; Worked with Repository Migration Process from Product Life Cycle Environments from Development to Production
• Job scheduling experience using Control-M.
• Conceptual and Logical data modeling experience for OLAP.
• Knowledge on Ralph Kimball’s Dimensional Data Warehousing (DDW) using star and snowflake methodologies.
• Acquired knowledge in the areas ofData Integration, Data Element Analysis, DB Schema Management, Data Modeling,andData Testing for Executive and Decision Supporting Systems.
• Hands on experience in creating Schema Management Objects which includes IOT Tables, External Tables, Partitioning (Range, List, Hash) Tables, Indexes (B*Tree, Bit Map, Functional, Global and Local Indexes), Stored Procedures, Functions, Triggers, Packages.
• Involved in Application, ETL and Data Integration validation and testing. Developed Use Cases and Unit test documents. Supported User Acceptance Testing (UAT) to validated business rules for the Applications, Data Extraction Process and Target Data Quality Scripts. Tested Application Navigation and functionality for data integrity; Supported QA team in fixing the defects and closing the QA tickets. Prepared Data Validation SQL Scripts and Published Resultant Data into the Excel for business user’s evaluation.
• Provided data extract feed files to fulfill the Operational and Analytical teams request to run the business.
• Excellent Analytical, Critical thinking, and Creative Problem solving skills.Excellent communication skills and ability to work effectively and efficiently in teams and individuallyVery structured, organized, focused on quality and delivery of the product to the client with in the time lines to positively impact the business.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.5/9.1/8.6/8.1/7.1/6.2, SQL Server 2008 SSIS

BI: Business Objects XI R3, Cognos 10, SQL Server 2008 SSRS

Databases: Oracle 11g/10g/9i/8i, SQL Server and DB2.

Data Modeling Tools: ER Studio 9, ERWin

Scheduler: Control M

Version Control Issue Tracker: PVCS / Mercury Quality Centre

Operating Systems: Windows XP / 7 / 2008 Server, Red Hat Linux and Sun Solaris.

PROFESSIONAL EXPERIENCE:

Confidential, Beaverton, OR

Sr.ETL Developer

Responsibilities:

• Implement ETL Processes using Informatica tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer and Workflow Manager
• Extensive performance tuning was done by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance. Enhancements to Informatica Mappings.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Analyzed the exceptions rose during the ETL process and resolved them.
• Used Debugger to test the data flow between source and target and to fix invalid mappings.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings. Combined several Informatica sessions in desired execution sequence.
• Monitor Workflows in Production Environment and debug/resolve issues
• Participating in User meetings, gathering requirements, discussing the issues to be resolved. Translating user inputs into ETL design documents.
• Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.
• Used MS Visio for creating ETL Flows for the project implementation.
• Identify source systems, connectivity, tables, and fields, ensure data suitability for mapping.
• Researched sources and identified key attributes for Data Analysis.
• Converting the requirements to design specification and then translate into Informatica Transformation logic.
• Unit and Integration testing has been extensively done at development level and coordinated with Quality team while performing System testing.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Optimize SQL queries for better performance.
• Extensively worked on UNIX and shell scripts.
• Providing status updates to Client and senior management on time.
• Documented the test cases and results for future understanding and .
• Worked with Slowly Changing Dimensions like Type 1, Type 2.
• Worked with Informatica Version Controlling for Team Based Development to check in and check out mappings, objects, sources, targets, workflows, etc.,

Environment: Informatica PowerCenter 9.5, SQL Server2008 R2 Database / SSIS, Red Hat Enterprise LINUX Server release 6.4 and Windows Server 2008 R2 Standard.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Requirements gathering and business analysis by attending business meetings
• Assisted in Logical and physical modeling, followed Star schema to build Claims data mart
• Extensively used Erwin for Dimensional data modeling
• Prepared low level Design documents
• Prepared Mapping Specifications by capturing all the requirements and functionalities.
• Developed mappings inInformatica7.1.2.
• Used Stored Procedure Transformations in the Mappings to implement the requirements of OLTP system.
• Developed Mappings to populate data into Wits mart Data Mart which supports for the Reporting system.
• Developed Mappings to migrate data from FMS (existing) to ETM (new) system.
• Developed Mappings for data Synchronization between Order Management, Customer Management, Purchase Order and Billings Systems.
• Prepared Test cases for the Mappings. Involved in Integration of the code and testing.
• Coordinated the Offshore ETL Team.
• Created Mappings using transformations like Source Qualifies, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expression, Aggregator, Union to load Target tables.
• CreatedMappletsand used them across Mappings for maintaining the standards.
• Worked with SCD tables using Lookup and Update Strategy transformations
• Modified coded procedures to extract daily incremental data.
• Scheduling and Loading data process and monitoring the ETL Process
• Designed and developed UNIX Shell Scripts.
• Used debugger to test the mapping and fixed the bugs. Performed Unit and Integrated Testing.

Environment: Win NT, Win XP, Oracle 10g, SQL Server 2000 andInformatica7.1.2

Confidential

ETL Developer (Offshore)

Responsibilities:

• Analyzed SQR source code and converted into Informatica mappings.
• Developed complex mappings using all transformation of informatica extensively.
• Integrated Sessions and Workflows based on dependencies.
• Carried regressive Unit Testing of ETL Code.
• Used all tasks effectively in Workflow Manager.
• Participated in system testing and integration testing.
• Participated in UAT and fixed defects raised by QA team.
• Worked in Post Production historical and incremental loads.
• Made Impact Analysis on code during CRs.
• Worked as a Quality Coordinator for ETL Team. Prepared Work plans, Testing and Review Cycle for the Team. Attended Internal Quality Audits.

Environment: Oracle 8i, PL/SQL, SQL*Loader, SQL, Windows NT, 95, 98.

Confidential .

ETL Developer (Offshore)

Responsibilities:

• Building Data Mart (Conceptual, Logical and Physical) for reporting environment.
• Creating Data Dictionary for user defined databases (Collateral, Securities and Reporting) in Oracle, Server. Worked on Data Conversion for ACH Transactions.
• In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform.
• Define enterprise data architecture vision, strategy, principles and standards; get buy-in from stake-holders, management, business partners, and propagate throughout the company.
• Segregated data and organized the data for common subjects using ODS.
• Generated operational reports from ODS as opposed to the transactional/ legacy system.
• Performed Data Architecture in Designing and implementing a Metadata Repository and providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merger with Wachovia.
• Implemented Agile Methodology for building an internal application.
• Preparing Functional Specifications Document for the project.
• Reverse engineering old database and creating subject areas for each schema.
• Preparing High Level Data Flow for all the major Applications
• Well experienced in writing queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis.
• Fine-tuned existing PL/SQL code and worked on upgrade from 9i to 10g.

Environment: Oracle 9i/10g, SQL Server 2000/ 2005,ERwin7.5.2, Power Designer 7.1, BO 6.5/ XIR2, Windows XP, XML, Excel, Access.

Confidential .

Database Developer (Offshore)

Responsibilities:

• Business Analysis and Requirements Gathering.
• Database design and development.
• Designed and developed SQL Queries and PL/SQL Stored Procedures.
• Wrote packages, procedures, functions and DB triggers.
• Designed and developed various UNIX shell scripts
• Extensively worked on SQL*LOADER, import and export utilities.

Environment: Oracle 8i, PL/SQL, SQL*Loader, SQL, Forms 4.5, Sun Solaris, Windows NT, 95, 98.