SAKSHI VIG
Data Analytics Business Intelligence AWS
Capitol Avenue,San Jose,United States **********@*****.*** 248-***-**** www.linkedin.com/in/vigsakshi PROFESSIONAL SUMMARY
Critical Learner and Data Enthusiast with 3+ years of experience in solving challenging problems in order to maximize productivity, profitability and competitiveness by transforming data into strategic insights that influence powerful business solutions SKILLS
Database : SQL Server, Redshift, Snow Flake,Oracle Data Visualization : Power BI, DOMO, Tableau, QlikView, Amazon Quicksight, Spot Fire
Programming Languages : R, Python, Java, SPSS MS Office Suite : MSVisio, MS Excel, MSPowerPoint, MS Access Web Development : React Js, HTML5 Designing Software : Adobe Photoshop and Illustrator Big Data and Machine Learning : Clustering, Neural Networks, Reporting Tools : MS SQL SSRS, Crystal Reports Hadoop, Hive, Scala
EXPERIENCE
Business Intelligence Developer Intern
Verisk Analytics September 2019 - December 2019, Lehi,Utah
• Generating ad-hoc reports for insurance claim data using oracle database.
• Used ETL processes to get desired data and SpotFire to build dashboards Data Analyst Intern
American Express June 2019 - August 2019, West Valley,Utah
• Devised an automation tool to convert unstructured pdf file to structured text file which reduced the man hours by 60%
• Performing the productivity analysis and de ning homogenous parameters to measure productivity in terms of time and volume.
• Understanding credit card system and personal savings account system to identify the discrepancies between di erent databases
• Segregating the customers based on their reasons for call and providing business insights to improve the Customer First Service using MS Excel, Teradata (SQL queries) and Word Cloud
Operational Analyst Fellow
Morgan Stanley (Utah Community Action ) October 2018 - May 2019, Salt Lake City,Utah
• Redesigned catering menus and brochures using Adobe photoshop and Illustrator for marketing campaigns that helped to increase the outreach to community
• Captured and visualized demographic data using MS Excel from various counties that helps in compiling Community Assessment Report to know low income families and children in that area.
• Analyzed the vocabulary test scores of children using Regression discontinuity analysis and Anova testing using R and visualized results using Power BI.
Business Analyst
Process Nine Technologies October 2016 - July 2017, India
• Analyzed Email Marketing campaign of clients using SPSS, Google Analytics and provided strategic insights to increase profits by 20%.
• Used natural language processing to built data dictionaries, used SQL server to populate data and di erent APIs to convert website content in 4 different Indian languages by providing translating and transliterating services to client.
• Used in house tools to generate revenue through affiliate marketing and Google Ad Words. Software Engineer
Virtusa Polaris July 2015- September 2016, India
• Specialized in installing Infor ION, ERPLN (10.3),data migration and implementation of Logistics module which increased the efficiency of inventory by 50%
• Created ION work flows and ability to handle ION alerts which help to resolve the critical alerts 30% faster. PROJECTS
Capstone Project,Utah Sports Athletics
Developing a web-based platform for capturing data of athletes using React Js, visualizing data using Power BI and performing predictive analytics to reduce the risk of injury and enhance performance using R. AWS based Soccer Data Warehouse Solution
Designed a data warehouse to understand high offensive production of soccer team by building dimensional model, OLAP cubes and understanding the analysis using visualizations.
Predict House Price
Predicted the house prices by selecting predictor variables and training a model on Ames Housing Dataset and then testing the predictive accuracy on test data set using Python.
EDUCATION
Masters in Information Systems
University of Utah • Salt Lake City,Utah • December 2019 • 3.7 GPA Bachelors of Technology in Computer Science
Jaypee Institute of Information technology • Noida,India • June 2015 CERTIFICATIONS
SUN Certified CORE JAVA Programmer
Udemy Certifications:
• Spark and Python for Big Data with PySpark
• The Complete QlikView Boot Camp
• The Ultimate hands on Hadoop
AWARDS
Runner Up, Domo Hackathon 2018:
Proposed solution to business problem by Layton Construction and Domo at University of Utah Winner,Super Bowl Analytics, Game Day Hackathon 2018 : Provided insights for Super Bowl commercials by building dashboard using Tableau and sentimental analysis using R