SUMMARY

• Having 8 years of IT experience focusing on Data Warehousing, Data Modeling, Data Integration, Data Migration and ETL Process working as ETL Designer.
• Exceptional background in full development cycle of a Data Warehouse, including analysis, requirements gathering, design, development, customization, testing, implementation and maintenance.
• Demonstrated Data Processing expertise, mainly transformation Process utilizing ETL tools - Informatica Power center, SSIS and Database like Teradata, Netezza, SQL Server, DB2 and Oracle.
• Have extensive domain knowledge on Retail Industry( Confidential ), Telecom Industry ( Confidential ), Insurance Industry ( Confidential Insurance) and Health Care Industry ( Confidential ).
• Demonstrated ability to deliver projects that required working with, facilitating and influencing multiple teams while taking initiative and applying creativity.
• Expertise in change management and preparing the ETL Design Documents like High Level and Low level Design documents, Source to Target Mapping's, Unit test plan, Unit test cases and Deployment documents along with proper version code.
• Strong leader with experience in training developers and advising technical groups on ETL best practices and standards.
• Highly experienced and skilled Developer with a long and proven record of complete client satisfaction.
• Correcting issues and bugs.
• Monitoring of production inquiries and issues to ensure efficient resolutions.
• Experience with Power center Designer, Work flow Manager and Repository Manager.
• Creation of Informatica database's source and target connections, folder management, and deployment of objects to and from development, quality assurance and production repositories.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Worked on Performance Tuning by session partitioning, persistent caches, session tuning by optimizing Source, target, mappings and transformations.
• Identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Scheduling of work flows and after hour support.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design and other Data Warehouse concepts.
• Data cleansing, data quality tracking and process balancing checkpoints.
• Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
• Strong knowledge of Entity-Relationship concept, Normalisation- Denormalisation, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling.
• Utilized in-house wiki to document data model, business rules, projects, and other information.
• Experienced in Performance Tuning and Optimization of Teradata Large/Complex queries and sound knowledge in using Teradata View Point.
• Proficient in GCFR Framework of the Teradata to maintain the data warehouse.
• Extensively worked with Teradata utilities like BTEQ, FAST LOAD, MULTILOAD, FAST EXPORT and TPUMP.
• Experience in writing, testing and implementation of the Complex SQL Queries and PL/SQL scripts.
• Excellent in UNIX shell scripting.
• In-Depth hands on experience in Quality Process and Release management activities using CVS, TFS, ClearQuest and Serena Dimensions.
• Used software applications to document technical specifications and all associate project deliverables.
• Experienced in handling the customers queries globally and have good interaction with business users.
• Have a high degree of positive attitude and extremely flexible to changing needs and environments.
• Team player with excellent communication and have a Strong analytical and problem solving skills.
• Technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Collaborated with team members, customers, developers, analysts, DBAs and IT in the creation of analytical solutions.

TECHNICAL SKILLS

Database: Teradata, SQL server, Netezza, Oracle and DB2.

Utilities: Teradata: BTEQ, FLoad, MLoad, Fast Export, TPT and GCFR MSBI: T-SQL

ETL: Informatica Powercenter 9.x/8.x, SSIS

Reporting: SSRS

Scheduling Tool: Maestro- Tivoli Workload Scheduler(IBM), Autosys

Operating system: Windows and Unix

Scripting language: Unix shell scripting, SQL and PL/SQL

Configuration Management: CVS, PVCS, TFS, ClearQuest and Serena Dimensions

Graphics: MS-Visio 2007

Documentation: MS-Office

PROFESSIONAL EXPERIENCE

Confidential

Senior Project Engineer

Responsibilities:

• Understanding the requirement.
• Participated in the data modelling discussions with customer, development team to ensure solutions are designed for successful deployment.
• Keeping in mind on the latest trends and technologies to be implemented in the development solutions.
• Contribute to customer-facing publications such as Solution model, Design Guides and presentations.
• Modifying the existing code to cope up with the new requirement.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Created Several Teradata Bteq to load the data from existing Oracle system into the Teradata EDM model.
• Understood and used the ABC (Audit Balance and Control) process to load the data.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Code testing and UTC execution and result capturing.
• Detail system defects are created to inform the project team about the status throughout the process.
• Effectively used Informatica parameter files to filter the daily data from the source system and for defining mapping variables, workflow variables, FTP connections and relational connections.
• Have supported from Code deployment, post warranty issues well under the timeline.
• Migration and support.
• Supported the project by solving critical issues under the SLA period.
• Showed passion for technology and its value in transforming employee collaboration and productivity.

Confidential

Senior ETL Developer

Responsibilities:

• Learnt the new GCFR framework developed by Teradata recently.
• Making the GCFR registrations and writing input view to load data to the table.
• Coordinated with the project team and business during project requirement phase and suggested many architecture ideas and best warehousing methods.
• Demonstrated data warehouse architecture knowledge by being a creative thinker with a sense of realism.
• Created Design documents, Source to target mapping documents after understanding requirements and Source system and initial data analysis.
• Modifying the existing code to cope up with the new requirement.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Code testing and UTC execution and result capturing.
• Detail system defects are created to inform the project team about the status throughout the process.
• Resolving the defects in QA and providing explanation for the issue/mismatch in PROD Migration, Implementation and support.
• Preparing the required documents for the QA/ PROD implementation.
• Implement best practices to maintain optimal performance.
• Showed passion for technology and its value in transforming employee collaboration and productivity.
• Have supported the project from Code deployment, post warranty issues well under the timeline.

Confidential

Senior ETL Developer

Responsibilities:

• Worked in Release management team, which has a working Software Development Life Cycle of 1 month period.
• Created Design documents, Source to target mapping documents after understanding requirements and Source system and initial data analysis.
• Modifying the existing code to cope up with the new requirement.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Effectively used Informatica parameter files to filter the daily data from the source system and for defining mapping variables, workflow variables, FTP connections and relational connections.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Code testing and Unit Test Case execution and result capturing.
• Detail system defects are created to inform the project team about the status throughout the process.
• Resolving the defects in QA and providing explanation for the issue/mismatch in PROD Migration, Implementation and support.
• Preparing the required documents for the QA/ PROD implementation.
• Implement best practices to maintain optimal performance.
• Have supported from Code deployment, post warranty issues well under the timeline.
• Supported the project by solving critical issues under the SLA period.

Confidential

Developer

Responsibilities:

• Created Design documents, Source to target mapping documents after understanding requirements, Initial data profiling and Source system analysis.
• Modifying the existing code to cope up with the new requirement.
• Created reports and automated the report generation to reduce the manual intervention and cost to the customer for gaining the customer confidence.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Created Several Teradata Bteq to load the data from existing Oracle system into the Teradata Enterprise data model.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Code testing and Unit Test Case execution and result capturing.
• Detail system defects are created to inform the project team about the status throughout the process.
• Preparing the required documents for the QA/ PROD implementation.
• Effectively used Informatica parameter files to filter the daily data from the source system and for defining mapping variables, workflow variables, FTP connections and relational connections.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions.
• Implement best practices to maintain optimal performance.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Analyzed reports and created LLD, rules required. Also have framed report queries for SSRS reports.
• Have supported from Code deployment, post warranty issues well under the timeline.
• Resolving the defects in QA and providing explanation for the issue/mismatch in PROD Migration, Implementation and support.
• Supported the project by solving critical issues under the SLA period.
• Trained my junior members with the process and groomed them with the development and analysis.
• Some of the critical/complex projects are mentioned below,
• Fort Re-Platform - The goal is to re-platform the FORT reports on the new PDW environment (Parallel Data Warehouse). Since this will be a re-platform in a new environment, all new ETL component will be required as part of the build. Both the DI (Data integration) and - BI (Business intelligence) are to be built.
• ETL Foundation - The Best Buy Reporting and Analytics Services Capability ( RASC) IT team has initiated this project as part of the Retail Next Generation (RNG) to replace the current Sales Flow to a new platform as the current Best Buy Enterprise Data Warehouse platform will run out of capacity by Holiday FY14.
• Product Return Center - Reducing the gaps in visibility of inventory transferring from stores to the Product Return Centers.
• Universal Basket - To enable “relationships” between “driver” SKUs and relationship SKUs that are derived by the Merchandising group.
• Service Analytics - To provide Repairs (technically referred as service orders) & Claims data in a consolidated repository that will allow reporting and analytics capabilities to be used by the Services organization.
• Market Place - Initiative to partner with external sellers to sell their products online by using Best Buy’s e-commerce portal.
• Digital SKU - To sell digital generic products (like music) through dot.com and in-store channels.