Data Analyst Sales

Nityanand Wachche

Jersey City, NJ ***** ********@****.*** 201-***-**** www.linkedin.com/in/wnityanand Tableau GitHub/wnityanand

EXPERIENCE

Data Operation Analyst, Argus information and advisory services, New York Oct 2018 - Present

Developed ad-hoc detailed quarterly merchant net sales reports using SQL and Xlerator to allow global clients to make business decision

Interacted with users from different business units to gather and analyze complex requirements to develop reports in Tableau

Created SQL script for process automation, data governance process and generating data validation report

Designed CDM,PDM and ER diagrams using Erwin software to document processes for all business users

Extracted data from large databases and merge data set by writing SQL queries as well as stored procedures

Created and updated data mapping and data dictionary document from raw database to data mart for internal team

Data Analyst, Literacy Partners, New York May 2018 - Sep 2018

Identified correlation between distance between a student's home and LP class location using Google Maps Geocoding API

Discovered areas of NYC with greatest need for ESOL class to increase efficiency of LP’s outreach

Developed Annual report to calculate KPI using Microsoft Excel and performed data visualization of report using Tableau

Business Data Analyst, Entrepreneurship Lab, Pace University, New York May 2018 - Dec 2018

Maintained eLab database and website by updating content using MySQL, Drupal,HTML/CSS

Increased new visitor rate by 20% by implementing and analyzing report generated using Google Analytics

Salesforce Data Analyst, Capgemini Technology Services, Mumbai, India Nov 2014 – May 2017

Achieved 25% reduction in time consumption in data load operation by singlehandedly implemented lean six sigma principles

Identified appropriate implementation strategy for new enhancements related to data migration and activity using data loader

Translated solutions into deliverable work, coordinating with client for priority and final expectations in an Agile environment

Performed customization in salesforce app,debugging and deployment of salesforce.com components through change set

EDUCATION

Pace University - Master of Science (M.S.) in Information System GPA: 3.8 New York, NY May 2019

Honors: Recipient of Graduate Merit Scholarship One of the top 25 participants in Google UX world championship

University of Mumbai - Bachelor of Engineering (B.E.) in Computer Engineering GPA: 3.8 Mumbai, India June 2014

Honors: Outstanding Student of the year(2013-2014) Silver Medalist for consecutive 3 years

Projects:

Human Resources Analytics IBM HR Analytics Employee attrition and performance July 2018 - Aug 2018

Determined the factors affecting employee turnover on a simulated company using various exploratory data analysis (Kaggle)

Implemented logistic regression, random forest, decision tree, and machine models for predictions

Deduced from extensive data mining that employee satisfaction rate, Job Involvement, and Job level were leading factors in turnover

Framingham Heart Study (Python: Seaborn, NumPy, pandas, Matplotlib) Sep 2017- Dec 2017

Analyzed Framingham Data to determine the dependency of cardiovascular disease on risk factors such as blood pressure, lung function and smoking history

Walmart superstore Analysis ( Tableau : donut chart, map styles, side-by-side bar-graphs ) Jan 2018 - March 2018

Designed dashboard to showcase region wise, state wise and category wise total profit using tableau

Analyzing Energy Indicators of nations in context of their GDP Coursera Assignment June 2018-July 2018

Collected data from different sources and combine all dataset to create one dataset performed data scrubbing, data analysis

Performed visualization for the relationship between Energy Supply per Capita vs. Citable docs per Capita, % Renewable vs. Rank

The effect of recession on housing prices in university towns Zillow Data set July 2018-Aug 2018

Conclusion of Analysis : the real-estate investment in university towns might be a safer option as compared to non-university towns if there’s a chance of impending recession in near future

TECHNICAL SUMMARY

Programming Language: Python( NumPy, Pandas, Scikit-learn, Matplotlib), Apex, Visualforce, JAVA,PHP, R, SAS, HTML/CSS

Data Analytics : Adobe Analytics suite, Tableau, Google Analytics, MS Visio, Informatica, Power BI

Tools: Erwin, Microsoft Excel(VLOOKUP, pivot table, Index Match), SSMS, JIRA, Axure RP, Azure DevOps, BIRD

Certifications: Salesforce Developer, Salesforce Administrator, Professional Scrum Master,Google Analytics

Database :MySQL, IBM Db2, Oracle 10g, 11g,Oracle 11i, SQL Server

Cloud Technologies : Hadoop, HBase, Hive, Impala

INTERNATIONAL PUBLICATIONS

W Nityanand International Journal of Computer Application Volume: 141 – Number 14 May 2016

Leadership Activities

Face of Finance NYC (FoF NYC), Event Management Head

Association for Computing Machinery (ACM), Public Relations Head

Contact this candidate