Priyanka Pandey
Data Analyst with industry experience in Quality assurance, data visualization and Automation.
San Jose, CA 95126
******@*****.***
EXPERIENCE
Apple Inc. (Contractor) – Data Analyst
MAR 2019 - PRESENT Sunnyvale, CA
Applied SQL and Excel to resolve variety of ad hoc reporting issues. Reviewed design documentation to ensure accurate development of automated consolidated report generation through internal tools.
Automated the process of detection and analysis to accelerate the report collection problem by ~2.5 hours.
Maintain quality control systems, operational reports and spreadsheets to analyze the quality of data collected for weather and business of interest on road network.
Developed and implemented procedures to identify development model needs and categorize data according to the requirement gathered to achieve an overall better map experience supporting new street view feature (3 cities) and more land cover.
Aricent, Senior Software Engineer – Quality Assurance
NOV 2013 - AUG 2017 Gurgaon, Haryana, India
Performed regression and automation suite run, analysis and reporting for network protocols. Performed optimization of automation scripts in TCL, shell scripting and Python.
Developed test cases and test plans used for both testing and process audits; managed internal CRM for smooth feature delivery.
Improved simulator data collection process and developed comprehensive management strategy; improved efficiency of GoPro camera (Firmware and mobile app) testing by 10%.
Managed feature delivery by ensuring accuracy of hardware memory utilization record; reduced daily data collection time by ~eight hours.
ACADEMIC PROJECTS
Analysis of Sales Training on Jewelry Retail Store: Implemented Ordinary Least Squares Model to determine target customer group for specific products which can lead to 49% rise in Sales; incorporated future customer group using time series forecasting.
USA Gun violence analysis through data visualization: Produced meaningful visualization to find out interesting insights about USA Gun violence issue to understand deceptive data products using Tableau.
Annual Marketing Plan for Pets Supplies Plus: Planned the marketing strategy using Python and tableau to increase revenue (3.4% approx.) for PSP in its business for client Shaw + Scott. Successfully identified value propositions and key messages for company’s marketing campaign.
EDUCATION
Santa Clara University, Santa Clara — MS in Business Analytics
SEP 2017 - DEC 2018
Master of Science in Business Analytics (GPA 3.2/4.00)
KIIT University, Bhubaneswar — BTech, Computer Science
AUG 2009 - MAY 2013
Bachelor of Technology, Computer Science and Engineering (GPA 3.7/4.00)
SKILLS
Analytical and Business: Business Analysis, Product Pricing and Management, Quality Assurance, Digital Ads testing, Marketing and strategy, Supply-chain, merchandising, time series and forecasting.
Tools: Python, SQL, MongoDB, R, NumPy, seaborn, Scikit-learn, Keras, C/C++, Power BI Tableau, Microsoft Office, GIT, JIRA, R Shiny, MS Access, MS Excel, Excel VBA, Outlook, MS SQL Server, SQL Workbench
Statistics/Machine Learning: Cluster Analysis, Regression, Logistic regression, Binary and count regression, Data visualization, text analytics.
Networking: PPTP, Cucumber, IKEv2, IPsec Tunneling, TCP/IP, L2-L3 routing protocols (PPTP, RIP) and edge systems (VPN), DIAMETER and RADIUS Protocol.
AWARDS & RECOGNITION
Project Published
“How might data science students consider ethics?” SCU Machine Learning project published and recognized
Mentor/Guide
Managed teaching underprivileged children as part of Udaan initiative by JOSH, NGO in India.
Star Performance Award
Earned two consecutive Best Team Performance Awards in 2015 and 2016 and recognized with Star Performance Award within project team at Aricent.