Data Analyst Power Bi

Shweta Goyal (Do not need visa sponsorship)

Email: **********@*****.***

Address: ***** ****** **** ****, **********, MD 20613 Phone: +1-301-***-**** LinkedIn: https://www.linkedin.com/in/sg-shwetagoyal INTRODUCTION

Technical Skills: R, MySQL/SQL,Tableau, Power BI, HTML, CSS, JAVA, C++, MicroStrategy, MS Project, Microsoft Office Suite Analytics Tools: Oracle Web trends, Adobe Analytics, Google Analytics, Minitab, MS-Office, pivot tables & charts, multiple criteria lookups, nested logical/IF formulas, data cleansing, array formulas, Datameer, Google Tag Manager (GTM), Google Data Studio, Big Query, GCP, Tealium Tag Management, Power Pivot, Smartsheet, Power Automate.

Project Management Tools: SharePoint, ServiceNow, JIRA, Confluence, Trello, Procore. Business Skills: Project Management Planning & Coordination, Budget and Expense Control, Data Analysis, Customer Relationship Management, Strategic planning, CPM, PERT, Requirements Gathering & Business Analysis, Agile project development life-cycle concepts. Certifications:

SCRUM MASTER ACCREDITED CERTIFICATION™ - Credential ID – 638***********; https://www.scrum-institute.org/certifications/Scrum- Institute.Org-SMAC7042f8644c-638***********.pdf

Accredited Business Analyst (Project Requirements Analyst) Certification™ (APRA™) - Credential ID – 592**********; https://www.io4pm.org/certifications/IO4PM.Org-APRA9c5c840446-59256343469023.pdf PROFESSIONAL EXPERIENCE

Total Wine & More Rockville, MD

Business Data Analyst, Store Operations January 2021 – December 2023

• Produced reporting infrastructure for KPI program for the Sales Organization that resulted in an 85% increase in sales revenue in measured metrics.

• Created, implemented, and automated an in-house Competitive Battle Plan, streamlining the company’s strategic policy on how to deal with competitors.

• Conducted in-depth analyses of invoicing issues, budgets and used metrics to identify discrepancies.

• Developed several key reports that increased the efficiency in stores, like Pull List Dashboard, LISA Dashboard, Virtual Warehouse, New Item Request and Seasonal Item Rollup. Used Objective and Key Results (OKR) tool to set goals, monitor objectives and deliver results.

• Successfully introduced, developed, and executed, ‘Cork Recycling Program’ in all the stores, thereby reducing the cork waste to 73% in the first quarter itself.

• Implemented and maintained reports and dashboards, providing real-time project data. Developed and maintained training modules and Standard Operating Procedures (SOPs).

• Worked closely with Store Communication team to integrate reports in Reflexis.

• Worked closely with EDAP team to integrate reports in EDAP/Power BI.

• Responsible for taking data analysis and insights capability to the next level; working with data infrastructure to collect, clean and analyze datasets from different sources, auditing existing visualization dashboards, and working with stakeholders to recommend and create new reporting/insights.

• Interface with business groups and cross functional teams as needed to ensure the effective implementation of project controls systems and processes to achieve standardized project reporting and dashboard solutions. Total Civil Construction & Engineering, LLC Lanham, MD Business Intelligence Data Analyst May 2020 – December 2021

• Successfully developed and implemented software ‘TBA’ – TCCE Bid Analyzer, using data mining and data warehousing, with software’s like, Power BI, MySQL, MS Access, and successfully predicted two state highway bids to a 98% accuracy.

• Developed and maintained data models to identify trends, patterns, and insights on the operational production rates of the crew, equipment and more thereby providing calculative counsel to operational leadership for business improvement using ServiceNow.

• Maintained and tracked the status of contracts, budgets, project expenditure and successfully tracked work orders, change orders in Procore.

• Effectively defined the key insights and metrics which the business needs to address, and developed appropriate business intelligence datasets, analytics, dashboards, or methods, in collaboration with program leadership.

• Successfully created data models and understood dependencies between source systems while supporting initiatives for data integrity and normalization.

• Worked with individual project teams in operations, providing them administrative support for including but not limited to, request for quote(s), initiate and maintain project financials namely, change orders, work orders, payment requisitions, vendor management and more. A2Z Developers, LLC Columbia, MD

Business Analyst Intern November 2019 – May 2020

• Developed application for a client in the retail industry which helped increase customer retention by 20%.

• Formulated user stories and acceptance criteria, gaining extensive research and documentation experience in IT projects.

• Helped in developing test cases to validate the application’s features and functionality thereby increasing accuracy of solutions.

• Supported Team Leads in coordinating sprint meetings and conference calls while performing general administrative tasks related to project activities, document template management, and internal coordination. Surtel Technologies Pvt. Ltd. Indore, India

Business Analyst April 2014 – October 2017

Project Brief: SAP Implementation for Briggs and Stratton (based in Wisconsin, USA)

• Used database management software (MySQL) to analyze consumer trends and updated business strategies accordingly.

• Performed in-depth analysis of market trends and practices which led to the implementation of new marketing strategies and a 3.8% increase in the yearly revenue.

• Recommended and implemented web-based SharePoint repository for projects, helping organize, maintain, and distribute project information in a streamlined manner resulting in 11% increase in project efficiency.

• Gathered user requirements, managed, and prioritized them.

• Managing product backlog, project status, and collaboration with end customers’ and development teams ensuring implementation of advanced reports in Agile environment.

• Assessed system impacts, provided GAP and process analysis as well as cost/benefit analysis for system or product/service-related initiatives. EDUCATION

University of Maryland, (GPA: 3.75/4.0) College Park, MD Master of Engineering, Software Engineering Graduated - May 2020 Prestige Institute of Management & Research, (GPA: 3.65/4.0) Indore, India M.B.A., Finance Administration Graduated - May 2013 Rajiv Gandhi Technical University, (GPA: 3.5/4.0) Indore, India Bachelor of Engineering, Information Technology Graduated - June 2011 PROJECTS

Data Gathering & Analysis - Data Analytics for Information Professionals

• Objective: To bust an existing myth using real time data and computations.

• Approach: Conducted explicit interviews with students, recording their responses, analyzing it using R (Multiple Regression Testing using backward elimination method) and thereby successfully concluding the studies. Created designated forms using Google Forms and successfully used the same for gathering data of almost 200 university students. BindMind Database: E-Learning Management Platform - Database Design & Implementation

• Objective: Design, develop and implement a relational database for a real time website.

• Approach: Worked with MySQL and XAMPP towards the design of database of Online yoga learning system. Also formed elaborate ERD Diagrams using MySQL workbench to forward engineer the logical design to create the physical database. Recreational Wellness & Awareness Domain Project - Managing Software Engineering Projects

• Objective: Manage software team to maximize output with detailed deliverables.

• Approach: Successfully developed various project investigative tools such as Project charter, business plan, Gantt Charts, Stake holder strategies, scope statement, work breakdown statement, RASI Responsibility assignment matrix, Earned Value graphs, Cost budgets & estimates, Pareto Charts, IDEF, User acceptance documents using Integrated Lean Project Management (ILPM) framework which is an implementation-oriented hybrid of traditional Project Management Institute (PMI) and Agile project management paradigms. BindMind: E-Yoga Learning & Management Platform - Software Design & Implementation

• Objective: Develop a real time e-website.

• Approach: Worked as Project Manager, orchestrated a team of 6 members and worked towards successful development and delivery of BindMind, an online yoga learning platform. This platform enabled the instructors and students to share messages relating to yoga exercises, availability, personal requirements in addition to other course related inquiries like timings, quizzes, certifications etc. BindMind was developed using Angular 8, WebStorm/IntelliJ IDEA/Virtual Studio Code, Eclipse & Spring Tool suite and MySQL as database and Git as version control. Also, successfully introduced the idea of user stories, personas & abuse cases for a better understanding of the domain. Personal Address book: Web based Personal Phonebook - Programming on the Web

• Objective: Develop a 24x7 accessible e-phonebook that can be accessed from anywhere.

• Approach: Successfully developed an online real-world phonebook using tools: HTML, CSS, PHP and MySQL; which included both the server-side and the client-side programming. The project included a server-side data store such as a relational database, an administrative interface that uses an HTML form and server-side script to allow authorized users to create new, update and delete their respective records in the database.

Contact this candidate