Data Analyst Sales

Self-motivated Data Analyst professional with proven ability to solve complex real world problems and communicate the insights effectively. Proficient in Python, R, Tableau, SQL, Excel, Business Analysis and Modelling techniques. EDUCATION

Masters in Information Technology and Analytics Rutgers Business School, Rutgers University, NJ GPA: 4.0/4.0 Courses: Multivariate Analysis, Business Analytics Programming, Data management, Data Analysis and Decision Making, Analytics for Business Intelligence (Data Mining), Information Technology strategy, Business Forecasting, Project Management SKILLS

Methodologies: SDLC, Agile, Waterfall

Languages: SQL, PL/SQL, Python (NumPy, Pandas, SciPy, Scikit learn ggplots, matplotlib), R Database: MySQL, SQL Server

Reporting Tools: Tableau, MS Excel(Pivot/ Vlookup) Other tools: Jupyter Notebook, Beautiful Soup,Spyder, Splunk, Service Now, Putty, Filezilla Server, Citrix, JIRA, MS Office Certificate: Certified Scrum Master by Scrum Alliance, available at http://bcert.me/sgsdopzrb WORK EXPERIENCE

Research Assistant Rutgers University Feb 2021 – Current

- Performing literature search and analysis for the research project called “Generation and Enumeration Algorithms” using visualization tools to generate reports and draw insights.

-Processed data from the web and compiled them in a database for statistical analysis Teaching Assistant Multivariate Analysis Course Rutgers University Jan 2020 – May 2020

- Delivered tutorials and designed assessment activities for the graduate level subject

- Supervised practical work and assisted students in data skill development and in resolving technical challenges

- Contributed to the development of appropriate teaching materials ensuring materials are in line with learning objectives

- Evaluated assignments and provided effective timely and appropriate feedback to the students to help support their learning Technology Data Analyst Deutsche Bank External Infosys Limited Aug 2017 – Feb 2019

- Worked as an analyst for Trade Finance Deutsche Bank project with agile methodology

- Worked with cross functional teams and projects to manage project priorities, JIRA workflows, and backlogs

- Cleaned and processed structured and unstructured transaction data using Python scripts to convert it into meaningful data

- Constructed workflow charts, diagrams, and user stories studying system capabilities and writing specifications

- Used R and data visualization tools like tableau for generating reports and dashboards providing insights, trends and recommendations.

- Involved in reporting of KPIs and deducing parameters for business intelligence

- Actively scheduled team planning sessions for sprint planning, refining and estimations.

- Collaborated with internal teams and clients, identifying areas for business process improvements, campaign optimization opportunities and help define innovative solutions

Data Analyst Adidas External Infosys Limited July 2014 – July 2017

- Worked for Adidas Point of Sales Application workflow management, sales and procurement data management.

- Analyzed and redefined business data models to gain accurate insights into business and ultimately drive better workflows for the customers

- Processed data using Python and SQL to identify data inconsistencies and business insights

- Collaborated with database developers to communicate system requirements and help design the data models for applications

- Engaged in problem management and all aspects of incident management life cycle

- Led the automation project for risk reduction across Adidas Point of Sales applications.

- Analyzed application data using SQL and created dashboards to analyze EMEA region operational and sales consumer data including orders, products sold together, renewal performance, competitive win rates, and average deal size ACADEMIC PROJECTS

Multivariate analysis of Airbnb Properties of NYC area Rutgers Business School Aug 2019 – Dec 2019 The motivation of the project was to identify factors which effect the pricing of properties. Used EDA for data exploration. Visualized dataset and identified relations between prices and other attributes using R and gg plots. Used statistical techniques such as PCA/Factor Analysis/Clustering for better data interpretation and identified key features and their relations. Also developed a regression model for price estimation based upon the above-identified factors. Business intelligence insights on factors effecting popularity of TED Talks Rutgers Business School Aug 2019 – Dec 2019 Analyzed Ted data for identifying why some videos are more popular. This can be helpful for businesses to decide on ted talk content and know about factors which can enhance the video experience. Used Python/NumPy/SciPy/Pandas. Identified popular ted talks over the years based on views, comments, and ratings. Identified factors affecting their popularity like speakers’ occupation, duration of the talk, speaker count, etc. IT strategy proposal for Best Buy business development Rutgers Business School Aug 2019 – Dec 2019 Analyzed case studies and reports for best buy’s current business models, strategy, and focus areas. Identified business and workflow bottlenecks. Prepared and proposed an IT strategy to enhance the consumer experience, profits, global expansion, and reduce operational costs, with Best Buy’s IT mission and vision at the epicenter. Project Planning using WBS/Gantt, for organizing a marathon Rutgers Business School Jan 2020 – May 2020 Developed a project plan, with a team of 5, encompassing all process groups using important tools and techniques. Prepared a detailed scope statement, project charter, requirements matrix, WBS, Gantt chart. Identified Critical path, budget estimate and communication plan for stakeholders. Identified risks, their actions and contingency plans. Presented the plan to a panel of angel investors for final assessment. PRIYAM SAXENA

Phone: 551-***-**** Email: ******.******@*******.*** Location: Greater New York City Area

Contact this candidate