Ameet Suryavanshi

Professional Summary

A Technical Project Manager having working experience of 12+ years in Banking & Telecom Domains. Possess expertise in Data Architecture, Solution Design, Data Modelling & Analysis, ETL Architecture, Development, Testing and Performance Tuning of the Enterprise Data Warehouse and Data Marts in different environments like Teradata, Oracle with multiple Terabytes of size and various levels of complexity.

Professional Highlights

A keen planner & implementer with demonstrated success ensuring effective management of various resources to meet project specifications.

Proficient in client engagements for Solution Designing, Project Planning and Task Prioritisations.

Project Management methodologies to manage multiple simultaneous projects and tasks.

E2E Data Warehousing including strategy, planning, delivery, operations and scaling.

Technology Architecture Analysis, Functional requirements Scope, Project Definition and Data Structures.

Excellent technical proficiency in Data Warehousing, Data Modelling & Analysis, Business Requirements, Development & Testing.

Proven problem solving, organizational and decision making abilities

Proven track-record of success in leadership, mentoring and managing stakeholders in a multicultural and geographically distributed team.

Quick thinker and Adaptive to rapidly changing demands and priorities.

Ability to influence without authority and gain consensus across all levels.

Key Strengths

Project Management

Teradata Architect

Solution Design

ETL design and development

Data Analysis

Business Requirement Gathering

FSLDM

Technical Leadership

Teradata Performance Tuning

GCFR

Teradata SQL

Teradata Client Tools

Software Skills

Operating System

Windows, Unix

Data Warehousing/ETL Tools

Teradata utilities, Teradata SQL Assistant

Special Software/Tools

WINSCP, PUTTY

RDBMS

Teradata, Oracle, PL/ SQL

Version Control

SVN

Programming Languages

PLSQL / SQL, Basic UNIX

Analytical Tools

SAS Macros, OBIEE

Project Management

MS Projects, JIRA

Work History Summary

Employer

From

To

Wipro Infotech

April 2017

Till Date

Teradata India Pvt Ltd

Aug 2010

Mar 2017

IBM India Pvt Ltd

Jan 2008

Jul 2010

Vodafone Essar Ltd

May 2006

Dec 2007

Alpha Data India Pvt Ltd

Dec 2005

May 2006

Work History Detail

Company Name: Wipro Ltd. (Apr-2017 till date)

Client Name: Union Bank of India (Apr-2017 till date)

Role: Technical Project Manager

Projet Desc: Union Bank of India is an Indian Public Sector Bank. It has a need to integrate data from more than 30 source systems to present a 360-degree view of each customer. For this an Enterprise Data Warehouse along with BI Reports need to be developed.

Responsibilities

Analyse requirements and design the solution

Preparing & monitoring detailed project plan & schedules

Delivering Presentations in Steering Committee meetings chaired by the General Manager of the bank

Responsible for development and presentation of analyses to management including feasibility/cost/benefit studies and implementation plans. Assists management in areas of budgeting, resourcing, standards and policies.

Development of delivery schedule, resource planning and capacity planning.

High degree of client engagement for requirements, overall planning, milestone definition and progress updates.

Architecture of the technical design, along with development and implementation

Solely responsible for framing the test strategy, creating guidelines for setting up test environment

Implement best practices to ensure data security, encryption and data sharing.

Task assignment and monitoring work quality, review outputs and ensuring the team is appropriately trained. Makes hiring recommendations. Responsible for the development of resource and manpower plans for the project.

Conducting Teradata workshops with vendors and client for highlighting project risks and their mitigation strategy

Leading team of experienced ETL developers and mentoring junior DW/ETL consultants.

Administering the conduct of parallel run in the DEV and PROD Environments

Optimisation of processes, and Performance tuning of queries

Holding weekly review meetings with the client to monitor progress of the project

Company Name: Teradata India Pvt Ltd. (Aug-2010 to Mar-2017)

Client Name: JPMorgan Chase (Feb-2016 to Mar-2017)

Role: Off-Shore Tech Lead

Project Desc: Data Warehouse Remediation. The client had an operational data-warehouse, which was consuming high system resources. New applications running on the EDW were not able to meet the SLAs. To achieve the SLAs the ETL jobs had to be tuned.

Responsibilities

Business focussed role to gather requirements and design a solution.

Project management for resources and delivery prioritization in accordance with client requirements.

Tech lead for a team of five to guide them in optimising the data warehouse of the bank.

Responsible for framing the test strategy, creating guidelines for setting up test environment.

Identifying and fix process gaps and tune high resource consuming queries

Educating client teams in adopting best practices of coding with SQL and data extraction.

Company Name: Teradata India Pvt Ltd.

Client Name: Commonwealth Bank of Australia (Nov-2012 to Dec-2015)

Role: Senior DW Consultant

Project Desc: Handled various short and long-term projects as Solution Architect, Data Analyst and DWH Consultant. One of the major projects handled was to create a BICD (Best In Class Data Warehouse) which would be used to generate reports across all business units.

Responsibilities

Conduct requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.

Interviewing Subject Matter Experts, Data Modellers etc, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical teams

Responsible for quality and timely delivery of the projects in Agile Mode.

Monitoring onshore & offshore delivery; management for technical deliverables

Design and development of Semantic layer and various Data Marts for different LOBs

Follow best practices of data security and data sharing

Design and development of SMBB (Solution Modelling Building Blocks)

SAS to Teradata data migration using Teradata utilities wrapped in SAS scripts

Company Name: Teradata India Pvt Ltd.

Client Name: National Australia Bank (Mar-2011 to Oct-2012)

Role: DW Consultant

Project Desc: National Australia Bank is one of the Big Four Banks of Australia. As the Bank was growing rapidly, customer data analysis was key help the business in understanding the customer behaviour and creating products, which are specific to the needs of the customer. For this, a complete single view of the customer was required. The development of an Integrated Data Warehouse was the need of the hour.

Responsibilities

Understanding the requirements by interacting with BA and Subject Matter Experts from various Business Units

Making presentations to the client and taking sign-off on requirements and ETL Design

Design and documentation of ETL Architecture

Development of High-Level Data Mapping Document

Design and development of BMAP (Metadata Management)

Data profiling and analysis to identify gaps in source systems

Design of ETL Scripts using GCFR

Performance Tuning of ETL Scripts

Design of Test Strategy and Peer Review

Leading a team of 9 Teradata Developers and Testers

Mentoring junior Teradata Developers

Company Name: Teradata India Pvt Ltd.

Client Name: Optus, Australia (Dec-2010 to Jan-2011)

Role: DW Consultant

Project Desc: Remediation of EDW-Access Layer. The client had a fully developed EDW and the business users were running their reports against it. There were new requirements to create views in the access layer, which could cater to the growing needs and demands of the business. This involved interacting with the business users to understand the requirement and to either create new views / jobs to get the data.

Responsibilities

Understanding the requirements by interacting with BA and the business teams

Understanding the Source Systems and documenting the data flow

Preparing Source to Target Mapping Documents for ETL

Development of ETL Scripts

Performance tuning of ETL scripts

Company Name: Teradata India Pvt Ltd.

Client Name: CitiBank, Singapore (Aug-2010 to Nov-2010)

Role: DW Consultant

Project Desc: The client wanted to create a new DWH and wanted to migrate data from the existing DWH in Oracle to the new DWH in Teradata.

Responsibilities

Development of Oracle to Teradata migration scripts

Migration of Oracle DDLs/data types to equivalent Teradata DDLs/Data Types

Convert Oracle PL/SQL procedures to Teradata SQL

Development and testing of BTEQs, TPTs, Stored Procedures

Company Name: IBM India Pvt. Ltd.

Client Name: Vodafone Essar India (Jan-2008 to Aug-2010)

Role: System Operations Lead Specialist

Project Desc: Vodafone Essar is one of the biggest Telecoms in India. As the operations were expanding into new circles, building an integrated EDW was the next step for storing and analysis of data for business growth.

Responsibilities

Managing end-to-end delivery of enterprise data warehouse and business intelligence reports for each circle.

Coordination between different geographical sites, vendor management, brainstorming workshop organization, coordination for environment set up, issues resolution.

Requirements gathering from each circle/geography

Data modelling and creating high level data mapping document

Database management including updating, quality assurance, metrics, writing user documentation, table level specification documents, table process flow documents and training.

Development of ETL scripts for Oracle to Teradata data migration

Performance tuning of Teradata ETL Scripts and processes

Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance

Perform System Reconciliation of numbers reported on various systems.

Form productive networks with client, team, technical community, vendors and consultants

Company Name: Vodafone Essar India (May-2006 to Dec-2007)

Role: System Analyst

Project Desc: Vodafone Essar is one of the biggest Telecoms in India. As the operations were expanding into new circles, building an integrated EDW was the next step for storing and analysis of data for business growth.

Responsibilities

Managing end-to-end delivery of enterprise data warehouse and business intelligence reports for each circle.

Coordination between different geographical sites, vendor management, brainstorming workshop organization, coordination for environment set up, issues resolution.

Data modelling and creating high level data mapping document

Database management including updating, quality assurance, metrics, writing user documentation, table level specification documents, table process flow documents and training.

Development of ETL scripts for Oracle to Teradata data migration

Performance tuning of Teradata ETL Scripts and processes

Perform System Reconciliation of numbers reported on various systems.

Form productive networks with client, team, technical community, vendors and consultants

Company Name: Alpha Data India Pvt Ltd.

Client Name: ICICI Bank (Dec-2005 to May-2006)

Role: Software Engineer

Responsibilities

Development of user reports as part of MIS using Teradata SQL,

Multiload, Fastload and FastExport

Certifications

Teradata 14 Certified Professional

Education

Bachelor of Engineering (Computer Science), Mumbai University.

Contact this candidate