Vivek Vazarkar

Teradata Consulting Engagements

• Transcend
  Sr. Lead Technical Consultant | 09/2024 – 03/2025
  Transcend is Teradata Internal project, managing Teradata Employee HR data around the globe. Providing Teradata development solutions to different subject areas like HCM, Gr8PeopleHr, Inventory, Legacy, CSM, and Reference Data.
  Technologies Deployed: Informatica Cloud, Kafka, Teradata 17, TTU, Linux, GitHub, Jenkins, Jams (scheduling tool).
• United Health Group
  Sr. Lead Technical Consultant | 04/2023 – 05/2024
  UnitedHealth Group Incorporated is an American multinational health insurance and services company based in Minnetonka, Minnesota. Offering insurance products under UnitedHealthcare, and health care services and care delivery aided by technology and data under Optum, it is the world's eleventh-largest company by revenue and the largest health care company by revenue. Worked as Sr. Consultant, provided technical solutions for DB2 to Teradata data migration. Migrated over 1800 Datastage Jobs, 345 Shell Script, 18 Pearl Scripts, 40 Python Scripts, 548 Airflow DAGs.
  Technologies Deployed: Datastage 11.3, DB2, Teradata 17, Linux, GitHub, Python.
• T-Mobile (Telecom)
  Sr. Teradata Consultant | 10/2022 – 04/2023
  T-Mobile US, Inc. is an American wireless network operator headquartered in Bellevue, Washington, U.S. Its largest Telecom company in USA. Teradata provide support to T-Mobile HRA Analytics Project. Worked as a Sr. Teradata Consultant. Project follows Agile methodology, and I was responsible for end-to-end development of the HRA requirements i.e., from information gather to deployment of the code. Developed BTEQ & Shell Scripts, Azure Data Bricks Jobs, Python Scripts and deploying it through Git-Hub & Jenkins.
  Technologies Deployed: Teradata 16, Google Big Query, Azure Data Bricks, Python, Git-Hub, Jenkins, Linux 3.10.0.
• SC-Johnson (Retail)
  Self Service Sr. Lead Data Engineer | 04/2020 – 09/2022
  SC Johnson (SCJ) is one of the world’s leading makers of household brands. The company has operations in more than 70 countries and sells products in virtually every country around the world. Teradata providing support to Self Service Data Engineer project. As an Offshore Sr. Lead Data Engineer, I was responsible to Develop data set processes, Align architecture with business requirements, Develop, construct, test and maintain architectures, Identify ways to improve data reliability, efficiency and quality, research for industry and business questions and provide solutions. Use large data sets to address business issues. Coordinating with 23+ Onshore Self Service Power Analyst, Solution Architect, Data Architect, GIM Managers, Self Service Sr. Director, Business Managers & Sr. Director on Data Lake & Data Lab development requirement, architectural changes, creation of new processes and provide development direction. Interacting with various teams like SAP M&M, SAP PLM, SAP BW, SAP SD, SAP APO for Data Lake Development for converting SAP requirement into Teradata Data Lake. Support Analyst to work on Tableau reports and resolve their technical issues. Perform auditing of Tableau report and review deployment plan for Tableau & Data Lake code and provide necessary inputs for successful deployment of code. Provide regular updates to Self Service Sr. Director, Solution Architect & Data Architect on current development and future development plan. Attend monthly development review meeting with Self Service Sr Director, Teradata Engagement Manager, Teradata Project Manager.
  Technologies Deployed: Teradata 16, Informatica 10.2, Informatica EDC, Tableau 2021, Visio, Cherwell.
• SC-Johnson (Retail)
  ETL Enhancement Lead| 03/2019 – 04/2020
  SC Johnson (SCJ) is one of the world’s leading makers of household brands. The company has operations in more than 70 countries and sells products in virtually every country around the world. Teradata providing 24X7 and 365-day production support to EDW Datawarehouse environment, BI, Teradata Analytic System (TAS), Hadoop System.
  As an Enhancement Lead, I was responsible for providing technical solutions to L2 & L3 activities. Proactively identify process improvements, automation possibilities, technical delivery risks and provide probable solutions. Ensuring deliveries, delivered within Target Date and incident ticket, service request, problem tickets are being managed correctly and timely. Attending Project Management meeting and coordinating with Client Leadership Team. Assigning tasks within team as per skill set and ensuring all team members are allocated with work. Perform weekly incident/bug fix, RCA review meetings with client. Manage and own Major & Minor application release process and attend CAB meetings. Track Incident Tickets, Problem Tickets, Service Request and perform on demand meetings with team supporting issues and prioritizing tickets based on criticality of issue.
  Technologies Deployed: Tableau, Teradata 14, Informatica 10.2, Unix, Autosys, Cherwell, Service Now, Erwin.
  American Airline Inc (Airline & Aviation)
  Sr Analyst & ETL Prod Support Team Lead| 06/2013 – 02/2019
  American Airlines, Inc. is a major American airline headquartered in Fort Worth, Texas, within the Dallas–Fort Worth metroplex. It is the world's largest airline when measured by fleet size, revenue, scheduled passengers carried, scheduled passenger-kilometers flown, and number of destinations served. Teradata providing 24X7 and 365 day production support to MOSAIC & Maintenance And Engineering EDW Datawarehouse environment.
  I worked as a Sr. Analyst for MOSAIC Prod Support Project and ETL Project Lead for Maintenance and Engineering Project. Point of contact for escalating major incidents and representing Data Warehouse team to key business stakeholders and partners. Managing onsite/offshore ETL resources. Project Estimation & Resource planning for projects involved with in American Airlines MAE Prod Support Project. Managing boarding processes for MAE Prod Support team members. Assign task within team as per skill set and ensuring all team members allocated with Task. Ensuring deliverables, delivered within Target Date. Attending Project Management meeting with American Airline Delivery Manager, Sr. Prod Support Manager, Development Manager & Development Leads. Creating Prod Support processes & best practice documents like shift roster, log register, code deployment process. Perform weekly incident/bug review meetings with client. Support release of deliverables into production and perform on demand meetings with team supporting issues encountered due to production changes. Follow change control and continue integration process for production changes using Cherwell Ticketing system, GitHub. Support daily, weekly, and monthly customer report processes and meet SLA. Conduct regular presentations to AA & Teradata Management.
  Technologies Deployed: Datastage 11.5, Informatica 10.6, Teradata 16, Oracle 10g, Unix, Tivoli, GitHub, Urban Code.
  
• Royal Bank of Canada (BFSI)
  Onshore Coordinator & Offshore Lead|10/20010 – 02/2013
  The Royal Bank of Canada is a Canadian multinational financial services company and the largest bank in Canada by market capitalization, headquarter located at Toronto. The bank serves over 16 million clients and has 80,000 employees worldwide. I worked as an Onshore Coordinator for Sales & Service Optimization Project as a Onshore coordinator from 10/2010 to 11/2011 and Offshore Lead for Sales & Service Optimization & Risk Enablement Project from 11/2011 to 02/2013. I was responsible for requirement gathering, impact analysis and converting requirement into technical solution. Provide estimation for new requirement, enhancement activity. Create Technical Design Document, Data Modelling Document, Source Target Mapping Document. Coordinating with Source Provider, Business Users, DBA, Data Architect Team, BI Team for requirement. Assign task within the team and ensure deliverables are delivered on target date. Reviewing Test Cases (Unit, IST, Regression), Implementation Plan, Change Request and providing feedback on it. Post verification of production deployment. Coordination with the Production Support Team and provide required solution for production incident and ensure SLA meet. Created Datastage Jobs, Mainframe JCL, SYSINs, Cobol Code, Unix Shell Scripts as per project requirement. Provided Technical Guidance to the team members to achieve technical goals.
  Technologies Deployed: Datastage 8.1, 8.5, Teradata 14, Unix Solaris 8.1, Mainframe ISPF 6.3, Z/OS 1.13, Microsoft Project Planner.
• Winn-Dixie (Food Retail)
  Sr. ETL Developer|02/2008 – 09/2010
  Winn-Dixie Stores, Inc., is an American supermarket chain headquartered in Jacksonville, Florida. Winn-Dixie has ranked #24 in the 2010 "Top 75 North American Food Retailers" based on FY2009 estimated sales of $7.3 billion by Supermarket News.
  Provided 12X7 production support to Winn-Dixie EDW Datawarehouse using Datastage & Teradata. Created DataStage jobs as a part of enhancement activity for existing applications. Query tuning to get optimum performance using query explain plans. Identify and Introduce join indexes to complete the query faster than earlier. Suggested indexes on a column to reduce the skew level and improve the SQL performance. Suggested new processes for job designing and documented the same, which led to job completion within SLAs.
  Technologies Deployed: Datastage 7.5, Teradata, Unix Solaris

• Understanding Business Requirement and Translating it into Technical Solutions.
• Provide estimation for new requirement, enhancement activity.
• Create Technical Design Document, Data Modelling Document, Source Target Mapping Document.
• Coordinating with Source Provider, Business Users, DBA, Data Architect Team, BI Team for requirement.
• Assigning Task with in team and ensuring deliverable delivered with in target date.
• Reviewing Test Cases (Unit, IST, Regression), Implementation Plan, Change Request and providing feedback on it.
• Post verification of production deployment.
• Coordination with Production Support Team and provide require solution for production incident and ensure SLA meet.
• Identify ETL processes for improvement, keep track of bug fix, enhancement.
• Creating Data stage Jobs, write Co-Sort & Unix Shell Script to support Data stage environment.
• Providing Technical Guidance to the team members to achieve technical goals.

• Understanding Business Requirement and Translating it into Technical Solutions.
• Creating SQLs to extract data from DSS database and generate MIS report in the excel format.
• Coordinating with ETL Developer, BI Developer to create end to end process for Business Reports.
• Coordinating with DBA & ETL Team to create Unix Shell scripts required for DSS.
• Coordinate with DBA for Database Performance Tuning..

• Creating ASP Web pages and data validation scripts through Java Scripts.