Purva Sawant

(*** Springville Ave, NY-*****) 716-***-****) (adhsip@r.postjobfree.com) (LinkedIn) (GitHub) (Tableau) SUMMARY

● Passionate Data Analyst with 4 years of proven experience in SQL Querying, ETL/ELT processing, Data Modelling, Python, Creative storytelling EDUCATION

Master of Science in MIS, University at Buffalo, The State University of New York [GPA 3.85] Aug 2017 -- Sept 2018 Courses: OLAP: Data Warehousing, Statistics, Distributed Computing and Big Data, Technology Innovation Management, Communications, System Analysis Design Bachelor of Electronics and Telecommunication, University of Mumbai [GPA 3.67] June 2011 – May 2015 Courses: Applied Mathematics, Image Processing, Simulation Software, Computer Programming, Random Signal Analysis SKILLS

● Analytics/BI/ ETL: Tableau, Pentaho, SSIS, Apache Airflow, Hive, Access, Excel, Matplotlib

● Database: MySQL, Oracle, Cassandra, Postgres, AWS Redshift, Spark

● Tools: PowerPoint, IBM Watson, JIRA, Excel, Github, Looker, SAS E Miner PROFESSIONAL EXPERIENCE

Business Analyst, Integral Information Systems (Python, Tableau) July 2020 – Oct 2020

● Clearly communicated status of dashboards and implement efficiencies and consistencies in all dashboards across medical billing solutions

● Created reports to see various change in trends, drop in engagement, aggregate values for post analysis using Tableau for competitor analysis

● Interacted with users and managers to gather report requirements and provided various mock-up reports to finalize the requirements

● Conducted A/B testing on product website to understand the impact of user behavior, thus improving content engagement Data Analyst/Data Wrangler, Equifax (SQL, Tableau, Hive) December 2019 – May 2020

● Created data quality analysis report for Equifax’s prominent employers by removing duplicates and finding root cause with non-distinct fields

● Automated fill rate reports created in excel for various types of fields like employer, employee, income in different environments by creating data quality Tableau dashboard

● Documented data integrity checks as per the SQL coding conventions to avoid reserved words and indentation errors Analyst, Lyft (Python, SQL) March 2019 – September 2019

● Created SQL reports by cleaning JSON columns and transforming them into finding number of repairs, types of repair, current status of repair per service order per region, make, model after ELT processing

● Wrangled in SQL and created SQL dashboard for parts planning by creating Pareto chart for 80/20 parts planning rule and found correlation

● Researched new technologies like Splunk for cyberattacks and recommended plan to implement it to increase security at service centers

● Created SQL reports for total Lyft’s service centers repairs for last 10, 15, 30 days, average repairs per day, performed data issue investigation to understand root cause for data ingestion

● Parsed 1000 pages PDF to extract tables from each page using Camelot python package based on metrics whitespace to perform data analysis Data Analyst, Tesla (Tableau, Python, SQL) June 2018 – March 2019

● Monitored and mined outlook emails to create Tableau dashboard for planning most effective shift timings for maximum labor utilization

● Created Facts and Dimensions for parts inventory management, and created reports for stock availability at warehouse

● Reduced manual effort by 10% by pulling data from JIRA to create Tableau dashboard for helping manage team’s workload

● Saved 90 minutes by cleaning data and creating Tableau dashboards that identified Model-3 shipped tools for onboarding using fuzzy-wuzzy

● Improved 10% customer satisfaction by building Regression Model with Python to understand drivers of CSAT to achieve overall customer loyalty

● Developed Excel VBA Macros for parts planning to find how many parts are present at inventory, used VLOOKUP, SMALL and PIVOT functions

● Increased efficiency of systems by 15% by partnering with account to identify key body shop performance metrics and gaps in various systems

● Tracked, made changes to Tableau dashboards to make sure incoming numbers are accurate, aligned to requirements provided by business Production Support Analyst, Tata Consultancy Services –Genworth Financials (SQL, SSIS) Oct 2015 – July 2017

● Resolved critical production issues related to access privileges, performance tuning, restarting, backup and restoration within given SLA

● Achieved 5% cost reduction by automating SQL subqueries, views, triggers, joins, SSIS packages, analyzing consumer behavior patterns, recommending beneficial changes

● Fixed data anomalies by troubleshooting letters mismatch, special character, payment engine to avoid processing fraudulent transactions

● Tested quality of data and provided inputs to EDW team for creating required data marts for accurate reporting

● Extracted data (128 million rows) from multiple sources, cleansed it for operational needs and loaded into target databases for analysis

● Practical understanding of Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflake Schema, Fact and Dimension tables

● Monitored daily batch jobs by creating, setting scripts to test quality of data, log CDC feed, detect, communicate and then delete unusual item out of IP queue, detect mismatch in check void, expired policies, ineligible benefits ACADEMIC PROJECTS

Survey Data Analysis, ABC Amega Company Feb 2018 – May 2018

● Designed Excel dashboards to find actionable insights thereby improving ABC Amega’s survey data collection methods

● Presented one-tailed Differences-In-Means Hypothesis test to the CEO of Marketing to test which company is more likely to place claims Predicting Pneumonia Mortality Rate Aug 2017 – May 2018

● Scraped vaccine reviews from drug websites and performed sentiment analysis with ‘Bag of Words’ algorithm and Python scripts

● Showcased the hidden underlying factors behind pneumonia deaths and the KPIs for its spread by developing visualization VOLUNTEER EXPERIENCE

Teaching Assistant, University at Buffalo Oct 2017-April 2018

● Taught 150 students in a 4-hour session to visualize and analyze data using Tableau

Contact this candidate