PJ

Priyankaa Jayaprakash

Analytics Developer at Apple · CEVA Logistics

Union City, CA

In My Own Words

What I have done best:
• Automated processes to eliminate errors in reporting caused by manual data entry.
• Created a consolidated platform that acts as a one-stop destination for all the required information.
• Extracted, transformed and loaded data as required by teams and conducted analyses to create and present daily, monthly and quarterly reports on progression of certain metrics using custom SQL scripts, spreadsheets and interactive dashboards.
• Executed ad-hoc SQL queries as required by team members to provide information for analyses.

Technical skills:
1) Programming languages: SQL, base SAS, Python
2) Analytics/Reporting tools: Alteryx, Tableau, Business Objects, SAS Enterprise Miner, SAP Netweaver BW
3) Databases: MySQL, DB2, Microsoft SQL Server, Oracle Database
4) Operating Systems: Windows, Unix (Linux)

Work Experience

Data Analyst Intern

CEVA Logistics

2018 – Present

• Scripted and executed SQL scripts to handle real time exceptions of replenishment orders; identified and highlighted exceptions that needed to be handled immediately and ensured continuous material flow to the client • Created an automated tool using SQL and Tableau for operation managers across the organization to analyze the management of replenishment orders; eliminated errors due to manual data input and increased the efficiency of operation in all the work shifts by 7% • Collaborated with the Quality and Engineering teams to create interactive dashboards and reports on Tableau and Excel to provide ad-hoc reporting and analytics to executives by displaying KPI's for everyday work shifts

SAS, SAS Enterprise Miner

Marketing Predictive Analytics

2017 – 2017

- base SAS Aug 2017 - Dec 2017 • Analyzed a TGIF transaction data set to perform clustering using K-means classification algorithm; performed regression analysis, market-basket analysis and calculated the elasticity (pricing analysis) for each of these customer segments • Highlighted the key metrics of the best and worst performing segments and built strategies for each customer segment and forecasted an increase revenue by 8.25% Analyzing sales data of Amazon and Barnes & Noble - base SAS, SAS Enterprise Miner, Tableau March 2017 - April 2017 • Performed descriptive analysis on the customer characteristics of a sales dataset of Amazon and Barnes & Noble • Developed statistical models like NBD and Poisson Regression Models using base SAS to observe and find out the primary variables affecting the customer's choice between both brands • Applied model enhancement methods to create new variables from the raw data to widen the scope of the analysis; increased prediction accuracy by 6.89% • Successfully answered critical business questions and presented data driven insights using the output of predictive analysis

Data Analyst

Processware Systems PVT LTD

2014 – 2015

• Spearheaded my team through a data migration process by correcting data integrity issues and ensuring uniformity across all data fields; reduced the search time by 9 seconds • Developed and implemented stored procedures in SQL to optimize query performance • Conducted a comprehensive analysis and presented ad-hoc reports of the KPI's to internal stakeholders to help optimize the prediction of the candidature their customers; forecasted an improvement in revenues by 10% • Built and maintained business reports and executive dashboards in Tableau

Education

MS in Information Technology

The University of Texas at Dallas

2017

MS in Information Technology

BE

Visveswaraya Technological University

2014

BE