PROFESSIONAL SUMMARY:

• 14+ years of experience in analysis, design, development of various Data Warehousing and Business Intelligence technologies. Hands on experience include developing Data Warehouses/Data Marts/ODS within BFSI industries.
• Primary technical Skills: Teradata (TD14/TD13/TD12),Informatica Power center (9.6/9.0.1/8.6/8.1 ), SQL Server, Sybase and Oracle (7.x to 11g).
• Involved in full lifecycle implementation of multiple projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Hands on experience in Teradata (Teradata Administrator, Teradata SQL Assistant, BTEQ, Fast Load, MultiLoad, TPump, Fast export) in a Data Warehousing Environment.
• Strong experience in Teradata Database design, Implementation and Maintenance mainly in large - scale Data Warehouse environments.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Strong SQL experience in Teradata from developing the ETL with Complex tuned queries including analytical functions and BTEQ scripts.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like PMON, Teradata Workload Analyzer, and Viewpoint.
• Extensively worked on Query tools like SQL Assistant, SQL Developer.
• Proficient inInformaticaPower Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor etc.
• Skilled in Business Intelligence domain on ETL technologies and worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation to Enterprise Reporting.
• Estimable technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• His focus areas have been analyzing the requirement specifications, Design, development of ETL codes, Testing, Peer Reviews, performance tuning, UAT support and implementation.
• Worked on projects in waterfall and agile methodology.
• Excellent problem solving skills, good communication and interpersonal skills.
• Experience in working with multiple vendors and geographically distributed teams.

KEY DOMAIN AND TECHNICAL KNOWLEDGE:

Domain: Banking & Financial services, Risk Management, Basel & Regulatory Reporting

Technical: ETL Informatica Power Center V9.6

Scripting Languages: UNIX-Shell Scripting

Database: Teradata, Oracle 10g, Sybase, Sql Server

Version Control: Perforce, VSS, SVN

Scheduler: Autosys, ESP workstation

Tools: Teradata SQL Assistant, BTEQ, Fastload, MultiLoad, Fast Export, TPump, Teradata Manager, Teradata Query Manager, Teradata Administrator, Teradata SQL Assistance, PMON, SQL Loader, TOAD 8.0., SQL Developer, TOAD, DB Visualizer, MS Visio

RECENT PROJECTS WORKED ON:

Confidential, Tampa, FL

Responsibilities:

• As a Part of VZ Data Services Team, taking responsibility for developing enablement strategies for effective data analysis and reporting.
• Selects, configures and implements analytical solutions, develops and implements data analytics, data collection systems, and other strategies that optimize statistical efficiency and quality.
• Identifies, analyzes, and interprets trends or patterns in complex data sets.
• Monitors performance and quality control plan to identify performance.
• Works on problems of moderate and varied complexity where analysis of data may require adaptation of standardized practices.
• Works with management to prioritize business and information needs.
• Development of scripts for loading the data into the base tables in EDW using Fastload, MultiLoad and BTEQ utilities of Teradata.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly, and Yearly Loading of Data.
• Extensively used of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
• Responsible for ETL design, development, testing and review of code along with supporting documents like unit test cases and hand over documents like technical specifications documents.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Confidential, Tampa, FL

Responsibilities:

• Lead and guide development of an Informatica based ETL architecture.
• Development of scripts for loading the data into the base tables in EDW using Fastload, MultiLoad and BTEQ utilities of Teradata.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly, and Yearly Loading of Data.
• Extensively used of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
• Designing and implementing Data Warehouses/ Data Marts, Operational Data Stores (ODS), Business Intelligence and Analytic solutions to meet functional and performance related requirements and specifications
• Technical leadership for large complex projects that includes several developers and consists of technical and business resources from other teams. Mentor and help develop technical competency
• Responsible for ETL design, development, testing and review of code along with supporting documents like unit test cases and hand over documents like technical specifications documents.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Confidential, Irvine, CA

Responsibilities:

• Lead and guide development of an Informatica based ETL architecture
• Designing and implementing Data Warehouses/ Data Marts, Operational Data Stores (ODS), Business Intelligence and Analytic solutions to meet functional and performance related requirements and specifications
• Technical leadership for large complex projects that includes several developers and consists of technical and business resources from other teams. Mentor and help develop technical competency
• Responsible for ETL design, development, testing and review of code along with supporting documents like unit test cases and hand over documents like technical specifications documents.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Confidential, Phoenix

Responsibilities:

• Creating design and mapping documents based on the requirements analysis, clarifying queries regarding requirements.
• Developing ETL code, Unit testing, Peer Reviews, Integrating Testing and UAT support.
• Gap Analysis for discrepancies between multiple systems, and identification of root cause
• Implementation of Data loading through Informatica from the source systems.

Confidential, Phoenix

Responsibilities:

• Creating design and mapping documents based on the requirements analysis, clarifying queries regarding requirements.
• Developing ETL code, Unit testing, Peer Reviews, Integrating Testing and UAT support.
• Gap Analysis for discrepancies between multiple systems, and identification of root cause
• Implementation of Data loading through Informatica from the source systems.

Confidential

Responsibilities:

• Have created mappings, workflows in Informatica as part of the ETL built to load data from ORA-APPS to ODS & ODS to Datamart.
• Have created mappings, workflows in Informatica as part of the ETL built to load data from datamart to downstream applications.
• Have lead the team and mentored the juniors and new joiners in the team on Data Modelling concepts.

Confidential

Responsibilities:

• Creating design and mapping documents based on the requirements analysis, clarifying queries regarding requirements.
• Developing ETL code, Unit testing, Peer Reviews, Integrating Testing and UAT support.
• Gap Analysis for discrepancies between multiple systems, and identification of root cause
• Implementation of Data loading through Informatica from the source systems.