Data Analyst Sales

Chaitali Choudhari

*************@*****.*** +1-973-***-**** 104,7th street,Harrison,NJ,USA https://www.linkedin.com/in/chaitali-choudhari-2a3a16132/ PROFESSIONAL EXPERIENCE

Data Analyst, New Jersey Institute of Technology NJ, USA January 2019 – May 2019

• Rectified the logistics management problems by devising an optimum revenue management system. This operated by introducing different modules that in return enhances the revenue optimization by cutting on delivery time and cost which possibly improve the efficiency by 40%.

• Reviewed and formatted the data and inserted the formatted data into staging tables, performed data cleansing and then loaded into destination table to generate new module reports and modify existing ones to increase the data retrieval efficiency.

• Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations, user defined functions (UDFs) for data analysis.

• Exporting data to MS Access and Excel and making pareto charts and graphs depending upon the various data available from UPS, USPS and FedEx. Built reports documenting the status of the project. Data Analyst Intern, M/S Agrasen Agro Industries, India June 2017 – May 2018

• Built visual analytics to measure sales performance using business intelligence tool (Tableau) for sales analysis,

• Used VLOOK-UP to access important information from KPI's and created visuals using Pivot tables other excel functions for Project Portfolio Management (PPM) and delivered critical technology solutions for pricing analysis to understand the consumer behavior.

• Worked with management authorities to prioritize business and information needs also provided ongoing reports.

• Evaluated existing business and operational flows and developed recommendations for process improvements that reduced the manual load by 75%.

EDUCATION

Master of Science – Engineering Management GPA: 3.88/4 May 2020 New Jersey Institute of Technology, Newark, New Jersey Bachelor of Engineering –Electronics and Telecommunication Mumbai University, Maharashtra, India

GPA: 6.54/10 May 2017

OTHER PROJECTS

Analysis of Inter College Basketball Teams Using Python and Neo4J September 2019-December 2019

• Developed analysis using Python and Neo4J to determine which teams consistently scored the highest as the top teams differed each year

• Concluded that there is no correlation between FG% and PPG but also a pattern of human behavior that is not yet identifiable.

• We have concluded that there are multiple variables we are lacking in this data set. Data Mining and Analysis using SAS JMP January2019-May 2019

• Collected, cleansed and analyzed inter college Basketball teams Data using SAS JMP.

• Successfully interpreted data and drew conclusions that there are missing important variables or there is simply very little pattern to be recognized using Neural Network.

• The team has concluded that there are not only multiple variables we are lacking in this data set, but also a pattern of human behavior that is not yet identifiable.

Uber Ride Analysis using Tableau February 2019-May 2019

• Performed Data Visualization using Tableau to see how Uber has rapidly grown in New York City.

• Analyzed Ride hailing app mainly for Uber and Lyft along with Yellow and Green taxis operated in the NYC area.

• Analyzed the distribution of Uber rides by bases and by month of the year to see the growth in Uber rides. TECHNICAL SKILLS

Programming Languages: R, Python, SQL,Java

Database: MySQL, MongoDB,NoSQL

Other: Data Analysis, Data Modeling, Tableau, SAS JMP, RStudio, Web applications, Google Analytics, MS Excel (Pivot- Tables) MS Office, MS PowerPoint, Amazon Web Services (AWS), Power BI, Requirement Analysis, Data Mapping, Salesforce, Data Visualization, Statistical Programming, DOMO Workbench, SAS Programming,Agile,EDI Data transactions,Supply Chain Management,User Acceptance Testing Data Server Skills: Microsoft SQL Server, Azure, Database Shell Script Statistics: Regression Techniques, Decision Trees, Random Forest, SVM, Native Bayes, Hierarchical Clustering, K- Means, Confidence Intervals, Chi-Square test, ANOVA, F-Test, Z-Test, Binomial and Poisson Distribution

Contact this candidate