Data Analyst Manager

Simran Wig

*********@*****.*** 217-***-**** San Jose, CA https://www.linkedin.com/in/simran-wig/ EDUCATION

University of Illinois at Urbana-Champaign, USA Aug 2018 - May 2020 MS in Information Management (GPA: 4/4)

Vivekanand Education Society’s Institute of Technology, University of Mumbai, India Jun 2014 - May 2018 BE in Computer Engineering (GPA: 8.36/10)

SKILLS

• Certification: Certified Associate in Project Management (CAPM), Certified Information Systems Auditor (CISA) Pass

• Analytics and Visualization: Tableau, Power BI, SPSS, Data Studio, Qlik Sense, Talend, MS Excel, OpenRefine

• Technical Languages: Python, R; Databases: MySQL, SQLite, MS Access

• Cloud Platforms: GCP – BigQuery, Data Studio; MS Azure – Text Analytics, HDInsight, Logic Apps PROFESSIONAL EXPERIENCE

Technology Intern Adaptable Security Corp, San Jose, CA May 2020 - Present

• Liaise with process owners to understand the risk infrastructure of the client and identify high risk applications

• Perform scans on these applications to detect vulnerabilities present in the existing internal controls

• Prioritize vulnerabilities based on OWASP Top 10 and recommend cost-effective solutions to enhance controls Data Analyst Graybar Services Inc, Champaign, IL May 2019 - Apr 2020

• Employed Azure Logic Apps and Text Analytics to automate the intake, classification, and tracking of customer requests received in emails

• Identified factors and attributes to assess profitability and productivity of branches to enable business executives for strategic planning and decision making

• Increased order efficiency by 7% compared to the previous quarter of an electrical manufacturer and distributor by identifying key metrics to enhance KPIs

• Provided insights into accidents of company drivers by building an analytics dashboard using Qlik Sense and predicted trends concerning weather, location, and traffic to create awareness

• Identified best data monetization practices and built a Tableau and Google Data Studio report to prototype the data services that can be provided to the clients

Project Manager Business Intelligence Group, University of Illinois Aug 2019 - Dec 2019

• Spearheaded a team of consultants and successfully developed a market entry strategy for an insurance firm

• Performed risk analysis to gauge the risk associated with market entry and launch of the new service

• Conducted feasibility analysis of the strategy and conceived a 5-year timeline of potential next steps for the client Project Lead Graybar Services Inc, Champaign, IL May 2019 - Aug 2019

• Led a team of 4 interns to pitch a business case for introducing industrial same-day delivery service in the B2B sector

• Analyzed data to generate insights and identify gaps in the client’s existing delivery and fleet management systems

• Devised a business model ensuring revenue growth of 20% and recommended strategies to inculcate this model into the client’s existing workflow

Technology Consultant Business Intelligence Group, University of Illinois Jan 2019 - May 2019

• Recommended an efficient market growth strategy for a niche product in the automobile industry

• Revamped marketing and pricing strategies to increase revenue by interviewing industry experts and SWOT analysis Consultant Business Intelligence Group, University of Illinois Aug 2018 - Dec 2018

• Conducted market research and competitor analysis to strategize operations for an educational startup

• Streamlined the peer evaluation process in the organization that reduced 1/3rd of the time taken for evaluation Data Visualization Specialist Illinois Leadership Center, Champaign, IL Jan 2019 - May 2019

• Analyzed LeaderShape Program data and built a Tableau dashboard to understand the demographics of the students

• Conducted ANOVA and Tukey Post-Hoc test in SPSS to understand the statistically significant differences between racial groups and age groups over the past years

ACADEMIC PROJECTS

Accidental Drug Related Deaths pandas, matplotlib, bqplot Sep 2019 - Dec 2019

• Performed exploratory data analysis to identify trends in deaths caused over years by the overuse of drugs

• Created an interactive dashboard which can be used to recognize the drugs which are causing the most deaths Missing Migrants Project Tableau, Power BI Sep 2019 - Dec 2019

• Analyzed the dataset of missing migrants along various migration routes to identify the common causes of death

• Built dashboards to understand the change in death trends overtime across different migration routes Twitter analysis NumPy, pandas, Tensorflow, Keras, Cuda Aug 2017 - May 2018

• Built a 4 layered CNN model with an accuracy of 91% to analyze underlying sentiments in tweets of users

• Generated a scaled Depression Quotient using techniques of Auto-regression, and a time-series regression to predict the future trend in behaviour

Contact this candidate