SUMMARY:

• 11+ Years of experience in Data Warehousing Technology Requirement Analysis, Data Analysis, Application Design, Application Development which includes, Requirement gathering, Customization, Maintenance and Testing of various Business Applications in Data Warehouse and Training Specialist.
• Performing various roles like BI Architect, Project Lead/ETL Technical lead, ETL/Teradata developer/Informatica Developer.
• Extensively worked on BIGDATA POC to move Teradata applications into big data platform.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT
• Good working knowledge in Data Modelling using Dimensional Data modelling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modelling, ERWIN.
• Heavily interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts. Dealt with Type1/Type2/Type3 loads.
• Experienced with the execution of project using AGILE or SDLC methodologies.
• Actively involved in designing business reporting strategy and architecture.
• Involved in the data analysis for source and target systems and good understanding of Data. Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Extensively worked on Informatica Power centre 9.X/8.x/7.x
• Extensively worked on Big data technologies HIVE, sqoop and PIG.
• Extensively worked on Confidential R3 Universe as well as Webinteligence Reports.
• Extensive knowledge on Teradata, Oracle, SQL Server.
• Extensive knowledge on OBIEE, Cognos Framework Manger, Report Studio.
• Usage of Teradata Utilities (Fload, Mload, Bteq)
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed
• Developed Transformation specs & Test Plans
• Analysis and development of mappings using needed transformations using Informatica.
• Involved in Preparation of Test cases and Resolving issues of SIT and UAT
• Extensively worked on performance tuning and error handling of BTEQ, MULTILOAD and FASTLOAD utilities in Teradata.
• Certified in Six Sigma Green Belt.
• Have good hands on Tortoise Confidential, SVN, Quality Center and Folio as a Configuration management tools, for maintaining the project related documents and their versioning system.
• Highly motivated with the ability to work effectively Leading the Team, In teams and as well as independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power centre 9.X/8.X/7.X

OLAP & Reporting: Business Object ( Confidential - R3), Cognos FM, Reportnet 8 series and OBIEE

RDBMS: Teradata V2R5/V2R6/V12/V13, Oracle 10g, DB2 & SQL Server

Languages: UNIX Shell Scripting, C, HIVE

Operating system: Windows 98/2000/2010/ NT/ME/CE/XP, UNIX, Linux.

Methodologies: SDLC, AGILE Methodology

Tools & Utilities: Teradata Utilities (BTEQ, Fast Load, Multi Load, Fast Export, TPUMP), Teradata SQL Assistant, Teradata Administrator, Event Engine.

PROFESSIONAL EXPERIENCE:

Confidential

Application Architect

Responsibilities:

• Built database design, complete ETL Architecture to migrate Current SAS ( Confidential ) system to Teradata IDN Data ware house.
• Provide data management solutions and drive technical design and execution.
• Involved in gathering of business scope and technical requirements and created technical specifications
• Developed MDF solution to integrate the data from 20 markets across the globe to bring into IDN data warehouse and built a Confidential i.e. single source of truth for acquisition analytical user across the globe.
• Leading Team with 10 members with offshore and Onsite.
• Project Lead who was responsible for the assignment of tasks for the team members, creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc. Used share point to maintain documents and tracking.
• Extensively worked on Big data POC to migrate current Confidential from Teradata to Big data platform as part of globalization.

Technologies Used: Teradata, Event Engine, MDF, Sybase, SVN, GIT and Tableau

Confidential

Offshore Development Lead

Responsibilities:

• Understanding Confidential Process Sybase proc and converting them into Teradata.
• Converting all the GMS Real Time Calc Procs into Teradata Procedures
• Replicating Event engine entire GMS Exp Batch Process job chain nodes into E3 Teradata.
• Performance tuning for the TD existing procedures which are consuming more CPU in Teradata.
• Cut down Sybase load process and loading the data from Teradata to Sybase for the all the GMS Exp tables.
• Established a process to load the from Teradata Amex5 environment to IQA and IQP Sybase databases.
• Developing the MDF for data feeds.
• Understanding Sybase procedures, functions used and converting the same to Teradata.
• Use to attend the client calls to understand the problem.
• Migrating Sybase database objects like tables, views to Teradata.
• Creating load jobs in the customized framework to load the tables that are migrated.
• Understanding and executing UNIX scripts to load the metadata information into the framework.
• Testing the stored procedures that are converted like functionality and black box and migrating the same to production environment.
• Analyzing the reason for job failure or data gap for a table and fixing the same.
• Analyzing the reason for data mismatch and fixing all the downstream tables as well as target table

Technologies Used: Teradata, Event Engine, MDF, Sybase and Confidential .

Confidential

Onsite Project Lead

Responsibilities:

• Leading 20+ members of team for the completion migrating the objects from Sybase to Teradata.
• Understanding Sybase procedures, functions used and converting the same to Teradata.
• Use to attend the client calls to understand the problem.
• Communicate/Guide the team to complete the work
• Migrating Sybase database objects like tables, views to Teradata.
• Creating load jobs in the customized framework to load the tables that are migrated.
• Understanding and executing UNIX scripts to load the metadata information into the framework.
• Testing the stored procedures that are converted like functionality and black box and migrating the same to production environment.
• Analyzing the reason for job failure or data gap for a table and fixing the same.
• Analyzing the reason for data mismatch and fixing all the downstream tables as well as target table

Technologies Used: Teradata, Event Engine, MDF, Sybase and Confidential .

Confidential

BI Architect and Project Lead

Responsibilities:

• Involved in the initial analysis and design deciding phases
• Involved in gathering of business scope and technical requirements and created technical specifications
• Involved in finalizing in scope and out of scope items of the deliverables list by analyzing the complexity involved in developing particular item.
• Involved in Designing Tables and Snowflake Schema.
• Leading Team with 12 members with offshore and Onsite.
• Project Lead who was responsible for the assignment of tasks for the team members, creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc. Used share point to maintain documents and tracking.
• Translated the Functional requirements into Technical requirements and in the process created standard Functional & Technical Requirement Gathering Templates.
• Responsible for testing, data validation and debugging of enhanced and new applications to ensure they are in conformance with user requirements.
• Good experience in Communicating with internal and external customers, and interact with business users and systems operations team as a part of support work for error resolution and design enhancements.
• Created Summary View for all Orders, Revenue, OP, IB, NPS and Backlog information of facilities in terms of Zone, Region, Territory and Account Level
• Developed Complex Confidential R3 Reports for Portfolio, My Account and Customer Summary Reports
• Building Orders, Revenue, Backlog, PS, Opp and IB Summary
• Designed Customer Cross Reference Relationship
• Good experience in manage Team and task priorities to meet the project timelines, and potential project risks.
• Good experience of executing project in Agile Methodology
• Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance.

Technologies Used: Power Center Tool (Informatica 7.1.5), Teradata V2R5, Confidential R3, Redwood Cronacle, Tortoise Repository, UNIX.

Confidential

ETL Tech Lead

Responsibilities:

• Involved in GAP Analysis between Teradata and Confidential .
• Involved in the requirement gathering, analysis to define business and functional specifications.
• Prepared Design documents and Data Validation process documents.
• Effectively lead the team in offshore from Onsite to Identify GAP, Data Validation and Closing GAPS.
• Translated the Functional requirements into Technical requirements and in the process created standard Functional & Technical Requirement Gathering Templates.
• Created Complex Informatica Mappings to hook up data from Teradata to Oracle.
• Created Complex Logics using Bteqs
• Prepared Unit Test Cases, Regression Test Cases and systems test cases
• Developed Complex Informatica Mappings, Tasks, Workflows and Worklets using Workflow Manager to load Data Marts.
• Extensively worked in Agile Methodology as project executed in Agile Process

Technologies Used: Power Center Tool (Informatica 7.1.5), Teradata V2R5, Cognos 7.4, Redwood Cronacle, Tortoise Repository, UNIX.

Confidential

ETL Technical Lead

Responsibilities:

• Involved in the requirement gathering, analysis to define business and functional specifications.
• Translated the Functional requirements into Technical requirements and in the process created standard Functional & Technical Requirement Gathering Templates.
• Worked on Erwin in the Logical Data-mart design of the Data-mart using Dimensional Data Modeling.
• Created a Star Schema structure by defining Fact Tables, Dimension Tables, Joins and their Cardinalities.
• Wrote technical interface specifications to create new mappings and modify existing mappings based on functional specifications to meet business requirements.
• Involved in High-level design documents.
• Performed Impact Analysis and Risk Analysis in Integration of new source system into existing system.
• Used shell scripts for even automation to load data from different sources.
• Effectively lead the team for the quality deliverable on time.
• Developed Complex web Confidential Intelligence Reports.
• Designed Data Base Tables and Data flow.
• Participated in designing data load strategy for full and incremental data load process.

Technologies Used: SQL Server, Informaitca, Confidential, Windows 2003

Confidential

ETL Module Lead

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in High level design documents.
• Involved in User requirements gathering.
• Performed Impact Analysis and Risk Analysis in Integration of new source system into existing system.
• Responsible for building dimension tables and fact tables for the target eSupplies Data-Warehouse.
• Extensively worked on Informatica Power Center-Source analyzer, Data warehousing designer, Mapping Designer, Mapplet and Transformations to import source and target definitions into the repository and to build mappings.
• Performed Unit Testing at various stages by checking the data manually.

Technologies Used: Power Center Tool (Informatica 7.1.5), Teradata V2R5, Cognos 7.4, Redwood Cronacle, Tortoise Repository, UNIX.

Confidential

ETL Module Lead

Responsibilities:

• Successfully lead the team as Technical Lead with the Team of 7 members for the modules Complaints, CAPA and Investigation.
• Mainly involved in ETL developing.
• Preparation of Transformation Specification & Unit Test Plans.
• Development & Unit testing of Informatica Mapping.
• Data Validation.
• Resolved design issues in transformations and mappings.
• Scheduled workflows, Bteq Scripts, Unix shell scripts using Redwood Cronacle
• Preparation of Performance Documents
• Preparing Job chains for Scheduling purposes of different loads using corn Job scheduler.
• Preparing the Documentation for the mappings according to the design logic used in the mapping.

Technologies Used: Power Center Tool (Informatica 7.1.5), Teradata V2R5, Cognos 7.4, Redwood Cronacle, Tortoise Repository, UNIX.

Confidential

ETL developer

Responsibilities:

• Mainly involved in ETL developing.
• Preparation of Transformation Specification & Unit Test Plans.
• Development & Unit testing of Informatica Mapping.
• Data Validation.
• Preparation of Performance Documents
• Preparing Job chains for Scheduling purposes of different loads using corn Job scheduler.
• Involved in the preparation of Migration documents.

Technologies Used: Power Center Tool (Informatica 7.1.5), Teradata V2R5, Cognos 7.4, Redwood Cronacle, Tortoise Repository, Unix.