Data Warehousing Machine Learning

SATISH CHAVAN

PROFESSIONAL SUMMARY

Experienced with over 28+ years of experience in delivering business critical application solutions to global enterprises. Hands-on experience in architecting, designing & developing and managing numerous data warehousing as well as BI Reporting and analytics solutions involving Microsoft Azure Synapse, Teradata, Tableau and PowerBI. Project Delivery management experience with global teams in onshore, offshore, and nearshore models using Waterfall & Agile methods. Experienced in Data warehousing, Data Modeling, RDBMS and Advanced SQL concepts as well as worked on multiple Integration software's such as webMethods, Vitria and Cast Iron.

Highly-motivated with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Completed PG Program in AIML Texas McCombs – UT Austin

(https://la.utexas.edu/texasexeced/digitalVerification.html?key=mwjxotcy) PROFESSIONAL EXPERIENCE

Coca-Cola - Delivery Architect, 01/2015 – 04/2020 : 03/2021 - Current Capgemini Americas Inc.

• Involved in Teradata to Azure Synapse migration project to support client's business modernization program initiative and reducing cost. Also was involved in migrating integrations between Teradata and legacy Mainframe to Azure Synapse and SAP S/4 Hana.

• Contributed to cost savings and accomplished transition from legacy platform

• Managed multiple projects utilizing an onshore-offshore delivery model in an Agile environment.

• Led business requirement workshop for operational and analytical reporting and data feed needs across various business teams.

• Architected, designed and developed multiple application in partnership with the reporting team utilizing Teradata, Tableau/PowerBI.

T-Mobile - Teradata Technical Lead, 04/2020 - 03/2021 Capgemini Americas Inc.

• Built a comprehensive data ingestion strategy based on business stakeholder's requirements to source data from diverse HR data sources.

• Worked closely with the modeling team to meet HR Analytical application enhancement requirements through data integration.

• Collaborated with other team members to troubleshoot complex issues and develop solutions.

CONTACT

Email: ****************@*****.***

Visa Status: Permanent Resident

Phone: 404-***-****

LinkedIn Profile:

www.linkedin.com/in/satish-m-chavan

TECHNOLOGY SKILLS

• SQL

• Azure Synapse

• Databricks

• Teradata BTEQ/TPT

• Python

• PySpark

• SparkSQL

• Machine Learning

• NLP

• Gen AI

• Shell Scripting

• Java

• C

• Windows

• Linux / Unix

• Teradata

• Snowflake

• MongoDb

• SQL Server

• Oracle

• Jira

• Erwin

• IBM Tivoli

• Autosys

• Data Modeling

• Data Analysis

• Assisted in the design and development of application architecture components.

Coca-Cola Refreshments - Lead Developer, 04/2011 - 01/2015 Quinnox Inc.

• Managed development team in delivering comprehensive technical solutions, driving sales growth and enhancing revenue generation

• Conducted requirement workshops with business and design teams to gather project specifications

• Collaborated with reporting team to develop and enhance reports and dashboards

• Designed and developed around 8+ applications.

• Managed multiple projects simultaneously while meeting deadlines set by stakeholders.

• Documented application design specifications including user stories, functional requirements, so that others can understand how the applications were built.

• Provided support to end users on various issues related to the use of Teradata systems.

Coca-Cola Enterprises - Teradata Support Lead, 04/2007 - 02/2011 Quinnox Inc.

• Lead the Teradata application support team (Data Stewards) onsite/offshore to support and manage around 80+ applications deployed in production ensure SLA adherence

• Monitoring 8000+ jobs and with around 25 TB data

• Ensured smooth execution of production deployments by acting as a gatekeeper.

• Ensured compliance with established policies and procedures related to customer service operations.

• Performed follow-up calls with customers after issue resolution was completed.

• Monitored the progress of escalated cases to resolution. Project Manager, 10/2005 - 03/2007

Quinnox India

• Managed a team of 15+ members developing and supporting multiple applications for HSBC as well as its Saudi branch (SABB) by providing end-to-end solution delivery

• This helped my client to execute multiple IPO's successfully thereby helping the bank grow.

Project Lead/Tech Lead, 07/2005 - 06/2001

Quinnox India

Project X (Re-engineering MFG/PRO), 10/1999 - 03/2001 Atos-Origin - Carpinteria, CA

(MFG/PRO) Support Maintenance (SPEC-PL), 04/1998 - 10/1999 Atos-Origin - Mumbai, INDIA

EDUCATION

SOFT SKILLS

• Project Management

• Change Management

• Time management

• Risk Analysis

• Business Intelligence

• Organizational Skills

• Teamwork and Collaboration

• Interpersonal Skills

• Decision-Making

• Problem Solving

Post Graduate Program In AIML: Business Applications Texas McCombs, University of Texas at Austin

GPA: 4.05

Masters Diploma in Computer Software Applications

Datapro Information Technology, Mumbai, India

Bachelors of Science (Physics)

Mumbai University, India

CERTIFICATIONS

• Snowflake Snowpro Core

• MongoDb SI Associate

• Connected Manager (Capgemini University & Harvard Manage Mentor)

• Sun Certification for Java

• WebMethods 6 Certified Developer

AWARDS

• BRAVO Award from MOTOROLA for eBiz Global Support Mgmt Project

• ASIA-PACIFIC EXCELLENCE AWARD from ATOS-ORIGIN for MFG/PRO Support Maintenance Project

• TEAM RECOGNITION award from Capgemini for Delivery Efficiency

• SERVICE EXCELLENCE award from Capgemini Coca-Cola Account Team ACADEMIC EXPERIENCE

AIML Project Summaries

Support Ticket Categorization

• Developed an NLP-based system to streamline customer support by classifying support tickets, assigning tags, and prioritizing issues. Applied advanced techniques like transformer architectures and prompt engineering. Improved ticket handling efficiency by 92% and reduced resolution time by 36%, enhancing customer satisfaction. Gained expertise in NLP and data analysis.

Plant Seedlings Classification

• Created a computer vision system using CNNs to classify plant seedlings and weeds, enhancing agricultural efficiency. Utilized Keras, Tensorflow, and transfer learning to achieve 87% classification accuracy. The model reduced manual labor and increased crop yields. Learned about computer vision applications in agriculture and deep learning model deployment.

Bank Customer Churn Prediction

• Developed a neural network model to predict bank customer churn, aiding retention strategies. Conducted EDA, data preprocessing, and model optimization using Tensorflow and Keras. Provided a predictive tool that reduced customer attrition rates. Gained hands-on experience in neural networks and data manipulation.

Credit Card Users Churn Prediction

• Created a model to predict credit card customer churn, helping refine bank services. Utilized ensemble methods like Random Forest and techniques such as SMOTE for handling imbalanced datasets. The model improved customer retention rates by addressing key churn factors. Enhanced skills in advanced machine learning and customer behavior analytics.

Personal Loan Campaign Modelling

• Developed a decision tree classifier to identify potential loan customers, optimizing marketing efforts. Conducted data analysis and preprocessing, validated the model with cross-validation, and provided strategic recommendations. Achieved high model accuracy, improving campaign conversion rates. Learned about machine learning in financial services and business analysis.

FoodHub Data Analysis

• Performed exploratory data analysis for a food aggregator to understand customer preferences and demand dynamics. Conducted data cleaning, created visualizations, and provided strategic recommendations to improve offerings. The insights led to optimized menus and increased sales. Gained proficiency in Python for data analysis and data-driven business strategy development.

Contact this candidate