Data Analyst Intern

Data Analyst with a Master's degree in Information Technology and Management and a specialization in Business Intelligence and Analytics. SAS certified in Business Intelligence and Data Mining. Expert in descriptive, diagnostic and predictive analyses with proficient knowledge in statistical analyses, data analytics, data warehousing, data science, big data analytics, relational databases management systems and data visualization. Experienced data analyst with more than 7 years of coding prowess.

• 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

- 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

SAS, SAS Enterprise Miner

• 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

Data Analyst

Find out detailed information about Priyankaa Jayaprakash, Data Analyst Intern in Union City, CA

Priyankaa Jayaprakash: Data Analyst Intern in Union City, CA

Priyankaa Jayaprakash

CEVA Logistics

Marketing Predictive Analytics

Processware Systems PVT LTD

The University of Texas at Dallas

Visveswaraya Technological University