SUMMARY

• Around 5 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/ Confidential Power Center across various industries such as Finance, Banking, Confidential .
• Extensive experience in ETL/ Confidential Power Center and Data services, data integration experience in developing ETL mappings and scripts using Confidential PowerCenter 9.x/8.x/7.x, IDQ 9.6.1/9.0.1/8.6.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, and Deployment.
• Experience in working with business analysts to identify and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.
• Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Extensively created mapplets, common functions, reusable transformations, look - ups for better usability.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assitant
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Confidential, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Good understanding of Views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience in using Exception handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
• Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) and Mappings using Confidential Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Upgraded to Confidential PowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Confidential .
• Implemented B2B Project - DT/DX (Data Transformation Studio), Data Transformation Accelerator, Data Format Transformation Library, Data Transformation Engine and full integration with Powercenter
• Expert in Confidential 11g/10g, Confidential DB2 8.1, Sybase, SQL Server 2008/2005/2008 , SQL, PL/SQL Stored procedures, functions, and exception handling using Toad and PLSQL.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience working in Agile methodology and ability to manage change effectively.
• Responsible for Team Delivery and Participated in Design Reviews.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas

TECHNICAL SKILLS

ETL Tools: Confidential 10.1/9.6.1/9.1/8.6.1/8.1 , Confidential Data Quality(IDQ) 10.1/9.6.1/9.0.1/8.6 , MDM 10.1/9.7.1/9.5.1/9.1 , Confidential PowerExchange 9.6.1

Data Modeling: Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases: Teradata V2R12/V2R6, Confidential 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2012/ 2008/2005 , DB2 UDB, MS Access 2000, Sybase

Others: Toad, SQL Navigator, Crystal Reports, C#

Environment: MS Windows 2008/2005, LINUX, UNIX,PL/SQL

Job Scheduling: Autosys, Control-M, UC4

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Developer

Responsibilities:

• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Responsible for Data Warehouse Architecture, ETL and coding standards.
• Installed and configured PowerCenter 9.5 on UNIX platform.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Confidential PowerCenter Grid implementation.
• Created and maintained Users, Groups, Roles and Privileges.
• Provide PowerCenter performance tuning and production support.
• Perform Confidential Power Exchange System Administration including Team Based Development administration
• Installation and configuration of Confidential Power Center and other related products.
• Perform Confidential Power Center 8.x/9.x System Administration and Power Exchange System Administration including Team Based Development administration
• Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
• Designed web intelligence reports for dimensional hierarchical data
• Created web reports through report template in Web Application Designer.
• Extensively used IDQ which helped in debugging and also reducing development time.
• Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.
• Created several session and workflows in IDQ which we deployed in Power Center.
• Extracted data from SAP R/3 and loaded into Confidential Data Warehouse.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
• Done extensive bulk loading into the target using Confidential SQL Loader.
• Involved in developing detailed test plan, test cases and test scripts using PL/SQL. solutions and experienced working with data and analytics.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Environment: Confidential Power Centre 9.6.1/10.1, IDQ 9.6.1/10.1, Confidential 11g, Business objects, Confidential Power Exchange 9.6.1, Flat files, MS SQL server 2008, DB2 8.0, Data Services, Erwin, Winscp, UC4, MS. Visio, Shell Script, UNIX, PL/SQL.

Confidential, Manchester, NH

Developer

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Confidential Power Center.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Extensively used Autosys for Scheduling and monitoring.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Responsible for Data quality analysis to determine cleansing requirements.
• Worked with several facets of the Confidential PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Confidential mappings for better performance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Responsible for team members' work assignment and tracking.

Environment: Confidential Power Center 9.5, Confidential 11g/10g, DB2 7.1, SQL Server,PL/SQL, UNIX(Sun Solaris5.8/AIX), Toad 10.0,SQL Developer 3.0, WinScp, Putty, SFTP/FTP, XML Editor, Autosys, Ms-Access.

Confidential

ETL Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used Confidential power center for extraction, transformation and loading process.
• Created mappings for dimensions and facts.
• Extracted data from various sources like Confidential, flat files and DB2
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning mappings for better performance and efficiency.
• Migrated mappings from Dev to Test and Test to Production repositories.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Refreshed reports using Scheduler.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Responsible for testing and validating the Confidential mappings against the pre-defined ETL design standards.
• Created various tasks like sessions, decision, timer & control to design the workflows based on dependencies
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in production support.

Environment: Confidential Power Center 8.6.1, Confidential 10g, SQL, PL/SQL,Toad, UNIX, Windows,TOAD, Erwin 4.0