Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Software
Certification
Timeline
AccountManager
Swagat Pattanaik

Swagat Pattanaik

Manager - Analytics
Bengaluru,KA

Summary

Knowledgeable Statistician with 7 years of progressive experience analyzing data across multiple industry settings. Adept in conducting sampling and validation using Good Clinical Practices. Offering broad understanding of statistical concepts and models with expertise in Data Science, Cloud Data Services & Machine Learning.

For Contact: swagat.pattanaik015@gmail.com & (+91) 9938227404

Overview

2
2
Certifications
6
6
years of post-secondary education
7
7
years of professional experience

Work History

Manager - Analytics

Anheuser-Busch InBev
Bangalore, India, India
12.2020 - Current
  • Leading Market Recommendation project for Category Management process, to find out potential markets for product launches & other enhancements with use of Decision Tree Modelling, Cluster Analysis & Regression Analysis.
  • Developed a complete set up for Market Share forecasting & Impact analysis using SARIMA Time Series & Regression analysis with an average accuracy of 87% across SKUs.
  • Leading Data lake project in Azure Cloud Platform.
  • Mentoring & creating a team of analytical minds to bring more value into process.
  • Interpreting business needs, doing fit-gap analysis & as-is to-be analysis and presenting same to client.

Principal Analyst

Anheuser-Busch InBev
Bangalore, India, India
08.2019 - 11.2020
  • Developed Country level sales forecasting models using ARIMA & ARIMAX models for Sales Volume of multiple brands.
  • Delivered process improvements & automations product worth of 3 FTEs.
  • Created analytics solutions using SAS and Microsoft Flows including data gateways like Azure Blob, SharePoint, FTP, Microsoft SSMS etc.
  • Expertise in Regression & Clustering Methodologies with E2E solution developments to track performance of various sales driver in Category Management process.

Senior Consultant

Harman International
Bangalore, India, India
11.2018 - 06.2019
  • Developing Sales reports using SQL queries.
  • Extensive knowledge in US Healthcare & Claims data.
  • Handling Dx,Rx,Px and Sx data for US claims and FDA.

Data Analyst

IQVIA
Bangalore, India, India
07.2017 - 11.2018
  • Established new vendor account setup from scratch and achieved NPS of 9 out of 10 through out tenure.
  • Preparing Linear Regressions and Logistic Regressions with Python libraries as well as in SAS procedures.
  • Led team of 4 staffs for Novartis account.
  • Expertise in use of PROC SQL, PROC MEAN, PROC FREQ, PROC REPORT and other reporting procedural in SAS.
  • Performing single and Multi-Indexing methods along with various SQL joins and Merges in Python.
  • Working on various Supervised and Unsupervised data models for Advisory team.
  • Designing SAS QC checks for Data Validation and SAS Reporting Programs.
  • Reporting and summarizing using SAS SQL.

Systems Engineer

Tata Consultancy Services
Bangalore, India, India
03.2014 - 06.2017
  • To document business process by identifying requirements
  • Expertise in various data analysis approaches using MS Excel and SAS EG.
  • Working in Pandas, NumPy and other data Visualization tools in Python.
  • Managed over 35 advisory data models for 2 different clients.
  • Creating various data visualization plots and graphs using Seaborn plots (Matrix Plots and Categorial Plots).
  • Preparing various Linear and Logistic Regression analysis with SAS.

Education

Bachelor of Technology - Electrical Engineering

Biju Patnaik University Of Technology
Bhubaneswar, Odisha
09.2009 - 07.2013

Associate of Science -

Utkal University
Bhubaneswar, Odisha
09.2007 - 07.2009

Skills

    Data Science

undefined

Affiliations

International Institute of Business Analysis

Accomplishments

  • Collaborated with team of 15 in the development of multiple sales analytics solution for the Category Management process.
  • Supervised team of 6 staff members.

Software

SAS 94

Python 37

Microsoft SQL Server Management Studio 18

Azure Data Lake

Agile Methodologies

MS Power Platform

Scikit Learn

Teradata & Snowflake

Certification

Diploma in Business Analysis

Timeline

Manager - Analytics

Anheuser-Busch InBev
12.2020 - Current

Principal Analyst

Anheuser-Busch InBev
08.2019 - 11.2020

Senior Consultant

Harman International
11.2018 - 06.2019

Data Analyst

IQVIA
07.2017 - 11.2018

Diploma in Business Analysis

03-2017

Diploma in Program Management

10-2016

Systems Engineer

Tata Consultancy Services
03.2014 - 06.2017

Bachelor of Technology - Electrical Engineering

Biju Patnaik University Of Technology
09.2009 - 07.2013

Associate of Science -

Utkal University
09.2007 - 07.2009
Swagat PattanaikManager - Analytics