Data Analytics, Business Analytics, Data Visualization, Project Mgmt

AYUSHI BHATNAGAR

adv5eu@r.postjobfree.com LinkedIn +1-680-***-****

EDUCATION

Master of Science in Information Systems, GPA 3.82 Anticipated May 2023 Syracuse University, School of Information Studies Syracuse, NY Bachelor of Engineering in Electronics Aug 2015 – Jun 2019 Fr. Conceicao Rodrigues College of Engineering Mumbai, INDIA SKILLS / CERTIFICATIONS

Skills:

Business Analytics and Visualization: Tableau, Power BI (DAX, Data Modelling, Deployment), Google Analytics, MS Office 365(Excel, PowerPoint, Word), SharePoint

Programming Languages: Python, R, .NET, Java

Project Management: MS Projects, WBS, Agile, Scrum, Salesforce, Smartsheet Database Management: MS Access, MS SQL, Oracle SQL ERP and ETL Tools: SAP, Alteryx

Industry Knowledge: Stakeholder and Customer Relationship Management, Contracts, Procurement Analytics Certifications:

Google Analytics Individual Certification, Power BI Data Modeling with DAX WORK EXPERIENCE

iConsult Collaborative Syracuse, NY

Data Engineer: Analytics and Process Optimization Apr 2022 – Nov 2022

• Analyzed data using statistical techniques for the City of Syracuse Project. Handled over 60,000 data entries using Python for data cleaning, integration, and transformation to derive actionable insights.

• Streamlined data collection process and improved performance by redefining 2 major projects.

• Executed unit tests using both manual and automated tools. Processed the data set to enhance the extraction of visual data insights by 60%.

• Conducted deployment testing, documentation, implementation and facilitated post-implementation support. Bombay Realty - The Wadia Group of Companies Mumbai, INDIA Assistant Manager – Analytics Jun 2019 – Jun 2021

• Synchronized with cross-functional departments including finance, contracts, audit, legal, and stakeholders for over 20 procurement projects with TCO analysis. Prepared RFP, and RFQ for sourcing and procurement.

• Designed customized dashboards to track the KPIs and project milestones using Smartsheet. Applied conditional formatting and built Gantt charts to visualize timelines and dependencies. Improved the project timelines by 15%.

• Managed databases using SQL and MS Access for easy retrieval and modification of data.

• Responsible for technical and commercial analysis through quantitative and qualitative data. Obtained savings of 10% through value engineering. Calculated payback periods that improved vendor selection, saving costs by 30%.

• Assessed 5 commercial procurement packages by leveraging Excel functions: VLOOKUP, Power Pivot, Conditional formatting, and data simulations to maintain supply chain processes with detailed analysis.

• Created KPI on Tableau for creating over 15 vendor management dashboards. Developed reports, charts, and graphs to provide actionable insights and recommendations to the management.

• Implemented business project management tools like SAP for creating requisitions and inventory management of over 15 CAPEX projects, vendor creation, and CRM.

PROJECTS

Integration of AI with Floyd Systems Aug 2022 – Dec 2022

• Team Lead for Integration of AI technology with Floyd’s Systems for better customer satisfaction.

• Created project charter and built a Work Breakdown Structure on MS Projects for 2 product lines.

• Increased the quality assurance by 20% and overall customer satisfaction by 15%.

• Implemented the Visual Inspection Systems with Agile sprints for resolving manual inspection issues, formulated budget, and carried 5 rounds of negotiations for the project. Sales Data Analysis for an E-Commerce Website Jan 2022 – Mar 2022

• Derived insights for over 10 metrics to strengthen the site performance of an E-Commerce Website using Google Data Studio and Power BI.

• Monitored website health using DAX functions to track user engagement and traffic.

• Generated power pivot tables to perform information analysis and obtain insights to reduce bounce rate by 20%.

Contact this candidate