Kartheek Guntupalli https://www.linkedin.com/in/kartheek-guntupalli/

**** ***** *** **, #***, Bellevue, WA - 98004 602-***-**** ad1v3o@r.postjobfree.com f

Education

Arizona State University, MS in Business Analytics (MSBA), Arizona 3.68 GPA August 2018 – May 2019 Visvesvaraya Technological University, BE in Electronics and Communication, India 3.4 GPA August 2011 – June 2015 Professional Qualifications

• Analytics and Databases: MySQL, SQL Server Studio, Tableau, Power BI, Toad, Access, Oracle, Google Analytics, Python, R, Palisade Stat Tools, Azure ML, SPSS, SSRS, SAS, Minitab, C, Data Mining, Big Data, DBeaver, Quicksight, Visual Studio Code

• Tools: PowerPoint, Word, Excel, Pivot Tables, VLOOKUP, @Risk, Solver, REDCap, Miro, MS Visio, JIRA, Putty, ModRSim

• Skills: Enterprise Analytics, Time Series Forecasting, Data Management, Data Visualization, Agile, Data Modelling, Decision Analysis, Statistical Modelling, A/B Testing, Marketing Analytics, Trend Analysis, Predictive Analysis, Lean Six Sigma, AWS T-SQL, PL/SQL, Teradata, Talend, Einstein Analytics, UNIX, Data Loader, C++, Waterfall Model, Kanban Model, Google Sheets, Sentiment Analysis, Text Mining, Macros, VLOOKUP, @RISK, Pandas, NumPy, Matplotlib, Seaborn, Holt Winters, ARIMA, Regression, ANOVA, Gantt Chart, Heat Map, KPI, Churn, Data Loading, Perceptual Mapping, Principal Component Analysis, Statistical Significance Testing, ROI, DMAIC, Statistical Process Control, SMOTE, Qlik Sense, Data cleaning, Data Warehousing, SSMS, Factorial Design, Hypothesis Testing, SAS, Java, Salesforce, SCRUM, Root Cause Analysis, Master Data Management, Data Integrity, ad hoc reports, Bar Graphs, Line Charts, Star Schema, SQL OLAP, Feature Engineering, CRM Module, Information Technology, BI Dashboard, Cognos, Math Computer Science, Computer Software, Data Analytics, Presentations, Collaborate, Vision, Quantitative, Impact, Hardworking, Intelligence Engineer, Business Intelligence Engineer, Status, Data Driven, Strategic Direction, Data Warehouse, Business Development, Data Quality, SQL Queries, Technical Skills, Focus, Marketing, Strong Organizational Skills, Databases, Passion, Innovative, Reliable, Problem Solving, Attention to Detail, Data Reporting, Flexible, Collaboration, High Quality, Provide Guidance, Team Oriented, Quantitative Analysis, Scripting Languages, KPIs, Committed, Self Motivated, Creative, Flexibility, Detail Oriented, Leadership, Statistics, Enthusiastic, Inspiring, Passionate, Proactively, Programming, Influence, Writing, Specifications, Operations, Business Requirement, Health, Sales, Architecture, Analyze Data, Administration, MS Project, Time Management, Project Delivery, UAT, Visio, Technical Requirement, Program Management, Data Extracts, Data Mapping, Quality Assurance, Local Laws, Project Documentation, Business Insights, Life Cycle, Change Management Skills, Creative Solutions, Workforce Management, Scheduling, Operational Performance, Retail, Call Routing, Vendors, Analytical Support, Customer Experience, Customer Service, Digital Products, Food Service, Operational Effectiveness, Strong Analytical Skills, Accountable, Judgment, Friendly, Innovation, Invent, Sensitive, Critical Thinking, Decision Making, Entrepreneurial Spirit, Continuous Improvement, Supply Chain, Web Analytics, Power Pivot, Power View, Web Trends Analytics, SharePoint, DAX, JavaScript, C#, SSI S, SSAS, Machine Learning, Deep Learning, Data Exploration, Database Management Systems, Object Oriented Programming, Software Project Management, NoSQL, MapReduce, Apache Spark, PySpark, Amazon Athena, Linear Regression, Naïve Bayes, Random Forest, Gradient Boosting, XGBoosting, kNN, Classification, Feature Engineering, Clustering, Natural Language Processing (NLP), Topic modeling, CNN, RNN, scikit-learn, Keras, TensorFlow, AWS EC2, S3, RDS, Lambda, VM, docker, Kubernetes, Google Cloud Platform, GitHub, Bitbucket, Selenium, Cloud Computing, Data Science, Angular JS, HTML 5, CSS 3, Scrum Master, Informatica Power Center, Palisade Stat Tools, AWS, Hadoop, Relational Database, Power Query, Micro Strategy, Workday, S3, Redshift, QuickSight, DynamoDB, Dropbox, Tag Manager, Hypothesis Testing, Modbus Slave Professional Experience

Business Intelligence Engineer, Amazon, Bellevue, WA February 2022 – October 2023

• Worked with Amazon Logistics (AMZL) FinTech Team to automate, standardize and expand the scope of Actuals, Plan and Estimates data of Under The Roof (UTR) and On The Road (OTR) costs stored in Redshift Database using SQL, Excel, Quicksight and Python used for Weekly Business Review (WBR) and Month End Close (MEC) across NA and EU regions

• Validated 35 Operational and Cost metrics for WBR and MEC for NA and EU with Finance POCs which reduced the variance from 57% to less than 1% and created the data source to consume this data which reduced their turn time from 1 hour to 5 minutes

• Onboarded all the critical pipelines to BDT Maestro to implement Code Review for the team which reduced code failures by 90%

• Created Architecture design for MEC pipeline for AMZL and its expansion design for other business like AMXL, RSR and SSD

• Automated the Fixed Cost Pipeline for US and MEC Payments Pipeline for CA and brought variance to less than 1%

• Created and onboarded custom metrics, documented team projects and designed internal Team Page(wiki) to display team’s work Data and Reporting Analyst, Amazon, Tempe, AZ March 2021 – February 2022

• Worked with Amazon Extra Large (AMXL) Supply Chain Analytics Team to analyze data stored in Redshift Database using SQL, Excel, Tableau and Python to get insights for making long term strategic decisions for Heavy and Bulky products

• Owned 25% of dashboards of the team and helped in their maintenance and modification by directly interacting with stakeholders

• Created a Weekly Metrics Dashboard with all major Metrics comparing the AMXL Network with Sort and Non-Sort Networks which is a one stop shop for validation of metrics and source for queries for other reports which increased team efficiency by 53%

• Performed Data Engineering tasks such as onboarding tables, fixing transform and load issues in tables and created Chime Bots Management Analyst, Arizona Department of Health Services, Phoenix, AZ November 2019 – March 2021

• Worked with the Arizona Immunization Office to analyze more than 3 billion rows of data stored in multiple tables in the ASIIS Oracle database and get vaccination trends and insights using Toad, which increased the vaccine coverage area by 5% in Arizona

• Automated the process of gathering orders and transfers data of vaccine providers from Oracle database using MS Access, which reduced the overall turn time from 1 hour to less than 1 minute and created reports using Power BI to compare trends in data Cost Scheduling Analyst, W. P. Carey School of Business, ASU, Tempe, AZ July 2019 – November 2019

• Worked on a data-driven approach to analyze student intake and segregate them into classes to make it more diverse for them based on past work experience and background using SQL Server and Tableau, which improved the student productivity by 15%

• Analyzed survey results of 200 students stored in SQL Server and created a better design of Data Science courses using the reports and dashboards in Tableau for the Business Analytics program which improved the success rate by 19% Intern - Capstone Project, W. P. Carey School of Business, ASU, Tempe, AZ January 2019 – May 2019

• Worked on the project Terminal Throughput Analysis, where the factors impacting terminal throughput of the trucks carrying cargo in and out of the terminal were analyzed and potential areas were identified where operational efficiency could be increased

• Communicated recommendations using more than 15 Tableau reports and dashboards having interactive charts, toggles and tables on factors to improve their throughput from 49% to 63% and reduce waiting time by 20% by considering actionable insights Data Quality Analyst, Schneider Electric, Bengaluru, India June 2015 – July 2018

• Created visualizations in Tableau and Google Analytics for 4 departments in the organization to convey the analysis of customer purchasing trends to the business leaders for a $250M+ business and helped in increasing the sales by 12%

• Performed data cleansing of source data stored in SQL server and analyzed alarm and warning data of data center products, and aggregated results and insights using Tableau which helped answer critical business questions and increased efficiency by 20% Intern, Schneider Electric, Bengaluru, India February 2015 – June 2015

• Worked on a project titled System and Method for Automatically Selecting Baud Rate in a Controller Area Network, where the CAN data had to be collected and analyzed using Excel and SQL to know which Baud Rate is suitable for different devices

• Created a working model of the patent and showcased it as a business proposal as it would reduce operating expenses by $500k Professional Development

• Member of Schneider Electric India Foundation (SEIF) and volunteered in various CSR activities February 2017 – July 2018

• Volunteer in Schneider Electric Teachers Program and taught MS Office and public speaking February 2017 – July 2018