Data Analyst

CAREER OVERVIEW

Experienced Business Analyst with a demonstrated history of working in a variety of industries. Entrepreneurial data artist skilled in converting numbers into meaningful visualization and reports. Result-driven with proven track record of identifying and executing projects to enhance efficiency and thus yielding profits to the business. CORE SKILLS

Data Analytics Data Visualization Report Building Pricing & Strategy Business Analysis Project Management Report Building BI Tools (Tableau, Power BI, Looker) Business Process Optimization TOOLS & DATABASES

Tableau, Looker, Power BI, Qlik sense, MS Access, Smartsheets, SharePoint, Salesforce, Catalyst, Visio, MS Excel, MS Project, MySQL, JIRA

PROFESSIONAL EXPERIENCE

Business Analyst / Fortisview, New Jersey 3/2020 – Present

• Established process improvements and standards around data gathering and persistence.

• Worked with various business groups and process owners to design, optimize and document business processes.

• Created a product roadmap, reviewed it monthly with stakeholders, and leveraged industry insights to drive product forward.

• Built data visualization dashboards and reports; optimizing available tools (e.g., Tableau, Power BI). Including front- end design and back-end data setup/configuration (overall understanding of SQL and curation of database sources) Business Analyst - Pricing & Reporting / Aramark, Philadelphia 2/2016 – 11/2019

• Accountable for providing complete price recommendation and execution for ~1200 clients through Catalyst.

• Identified and documented requirements for the development of global pricing tool “Catalyst” by creating use cases and process flows using Microsoft Visio during the design phase.

• Expert in designing ETL data flows creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server.

• Designed data viewer dashboard in MS Access by extracting, cleaning, and merging from different tables using SQL scripts.

• Work with analytics team to develop key model performance indicators (e.g. predicted vs. actual metrics and tracking changes to key variable coefficients), and re-specify methodology when required

• Refine and own core set of KPI’s to run the business

• Created and maintained data flow diagrams for existing and future ETL processes.

• Responsible for submitting status report to management summarizing completed milestones and tasks for development of the global pricing tool

• Created and implemented new category mapping program to map 1.8 million items to the designated new categories resulting in capturing 7% of the lost revenue.

• Build reports in Tableau that provides weekly, monthly and quarterly sales report and provide annual forecast.

• Devised and executed granular pricing strategies that synthesize data points of customer elasticity and competitor pricing for retail businesses.

SHUBHAM SINGHI

*************.****@*****.*** / M: 646-***-**** / Jersey City, NJ LinkedIn : https://www.linkedin.com/in/shubham-singhi/

• Lead the project for standardizing and assigning all beverage, CPG and coffee products a tier price based on their geographical location.

• Developed and implemented strategy initiatives on post analytics for retail businesses influencing key areas such as data capturing, pricing, quantitative analysis.

• Involved in formulating pricing strategy plan for next 3 years by quarter based on food inflation, Labor inflation, CPI and ECI.

• Lead a team of 3 offshore resources to identify risks, gaps and vulnerabilities in projects through auditing measures that improved business performance.

Pricing Analyst / Infoincept LLC (Client- Aramark) 10/2015 – 02/2016

• Accountable for providing price execution for all LOB’s.

• Responsible to provide end to end price recommendations for all manual sites under business dining & healthcare Line of businesses.

• Initiated and own the new global manual data collection process and tracking system via Smartsheets resulting in capturing ~30% lost revenue through pricing from manual sites.

• Created dashboard in Qlik sense that provides monthly and quarterly sales report. Data Analyst Intern / Ecs Inc., New Jersey 01/2014 - 05/2014

• Involved in the study and understanding of existing system and data architecture and proposed changes necessary to incorporate the new data models.

• Merged spreadsheets from different sources to create a more compact and centralized data platform for easy updating and data analysis using MS Excel advance functions.

• Transformed large amounts of raw data from excel sheets into searchable databases for team to access eliminating use of excel spreadsheets by 80%.

EDUCATION

Pace University - New York, USA 2014

Master of Science: Management Information Systems

Rajiv Gandhi Technical University - Indore, INDIA 2012 Bachelor of Engineering: Information Technology

ACCOMPLISHMENTS

• Certified Microsoft Associate in Database Administration Fundamental.

• Certified Microsoft SQL professional (Udemy)

• Certified Tableau Essential Training (LinkedIn Learning)

• Certified Power BI Desktop Essential Training (LinkedIn Learning)

Contact this candidate