Business Analyst Data

SRISHTTI GUPTAA

**.**************@*****.*** linkedin.com/in/s-guptaa (+1) 650-***-****

OVERVIEW

8+ years of experience as a Business Analyst/Data Analyst in S&OP Demand & Supply Planning, Inventory Management, Vendor Management with efficient understanding and capturing Business Requirements, Business Process flow, Business Process Modelling, Data Analysis, SWOT analysis, and Business Analysis. Expert in Advanced Microsoft Office. Flexible and analytical. Demonstrated ability to use numerical data to analyze and drive decision-making. Ability to recognize the strengths of employees and delegate task. Solutions-driven business analyst with experience in using Jira software to plan, track, and release software requirements, leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals.

SKILLS

Programming Languages: C, C++, HTML, XML, SQL and ETL Tools

Data Base: MS Access, Oracle (SQL Series)

Project Management: Jira, HP/ALM, RALLY, Microsoft Project, Microsoft Office, OLAP Crystal Report, Business Requirement Document (BRD), Process Flow, Use Cases, Test Cases, Process Mapping, Process Optimization, Process Streamlining

Operating Systems: MS-WINDOWS, MS-DOS, Apple McIntosh, Linux

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint (2010, 2013, 2016, Online), Scrum, Scrum, Agile, Iterative, Extreme Programming

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

Others: Requirements Gathering & Analysis, User Acceptance Testing (UAT), Project Management, Enterprise Implementations, KPI Dashboards & Scorecards, Data Mining & Analytics, Risk Management, BI, ERP & Big Data Platforms, SAP/SAS Solutions

EXPERIENCE

ESSILOR OF AMERICA, Business Analyst, Remote, Dallas, Texas US October 2021 – Present

The project focused on collaborating with the Research & Development Team (R&D) of a leading Eye Care to make the existing business processes efficient and standardize and streamline operation processes involved and automate existing systems. Lead business process and workflow mapping/analysis using data capture and modeling technologies, methods, and tools. Analyze business, user, and technical requirements for proposed web-based and system solutions.

Created Compliance Report using Excel for the Procurement department and identified procedural areas of improvement to improve the profitability by 8%.

Maintained and updated internal SharePoint website with the latest information and data.

Reviewed legal agreements with suppliers/vendors before its execution.

Prepared forecasting models using R and Python to help higher management make decisions for upcoming quarters, thus reducing operational costs by 4.8%.

Negotiated new rates of required materials and packaging with suppliers.

Tracked suppliers’ performance by checking savings performance and quality assurance.

LEEWAYHERTZ, Business Analyst, Remote, Texas US May 2021 – September 2021

The project focused on coordinating and communicating with Information Technology departments and collecting and validating requirements, specifications, business processes, recommendations and documenting them.

Actively involved in client communication to capture software requirements, and documentation and prepare technical proposals.

Documented all business processes and operating procedures from scratch for an early-stage startup.

Created visual diagrams including flow charts, data diagrams, system designs and similar technical representations.

Prepared technical documentation for the software solutions and designed specifications documentation for enabling the programmer to code.

Provided executives with analytics and decision-support tools used as the basis for reorganization, consolidation, and relocation strategies.

Respond to customer inquiries and complaints, providing quality service to customers and associated travelers requesting travel related assistance.

Reviewed legal agreements with suppliers/vendors before its execution.

VETOQUINOL USA, Senior Business Analyst/Project Consultant, Fort Worth, Texas US August 2020 – May 2021

The project was centered around collaborating with the C-level and other stakeholders to make the existing business processes more efficient after analyzing data as well as come up with strategies to launch a new product in the market based on the recent market study.

Served as consultant for clients surrounding training, product evolution, and updated scope and requirements.

Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

Collaborated with C-level suite and key stakeholders to improve methodologies and operations across 500 employees.

Created a digital campaign for their product Zylkene, a pet supplement that helps treat and prevent anxiety, with an aim to promote purchasing through online platforms such as Amazon.

Conducted informal interviews with pet owners, joined pet-related Facebook groups to research and learn about pet owners in general and performed consumer insights analysis from the collected data.

Prepared social media advertisements to target the consumer market, leading to an increase in online sales by 13%.

GOODWILL INDUSTRIES OF FORT WORTH, Business Analyst, Fort Worth, Texas US April 2018 - June 2020

Goodwill Industries operates as a network of independent, community-based organizations in South Korea, Venezuela, Brazil, Mexico, Panama, Uruguay, the United States, Canada, and eight other countries, with 165 local Goodwill retail stores in the United States and Canada. The aim of the project was to gather and prepare the requirements documents for replacing the existing commercial lines of businesses from legacy to web-based system and help in coming up with strategies to help the financial side of business to cut down on costs post analyzing data.

Analyzed financial reporting in Tableau to find $74K in savings from ineffective vendor subscriptions.

Built automatic reporting around key financial metrics for quarterly public earnings for the company's operation tools line, saving 65 hours of manual work each quarter.

Provided a comprehensive marketing plan with recommendations to increase sales by approximately 13% for the fiscal year 2019.

Worked on search engine optimization and targeted ads, and packaging and product design alterations, with an aim to achieve increased traffic by 17%.

Created Mockups and added them into user stories along with business acceptance parameters.

Performed organizational impact analysis in the process of gathering requirements for both the proprietary as well as customer trades.

XPRESSBEES (BUSYBEES LOGISTICS SOLTIONS PVT. LTD.), Operations Analyst, Pune, India March 2016 - March 2018

XpressBees is the fastest growing express logistics service provider in India catering to end-to-end supply chain solutions. The aim of the project was to gather data and prepare the models to forecast upcoming sales, check manpower loads and assist developers to automate processes and help in coming up with recommendations to help the financial and operational departments of the business post analyzing data.

Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins in the fiscal year 2017.

Prepared a forecasting model to generate a rough estimate of the number of requests, so that the available resources could be planned accordingly.

Established an automated system that could assign deliveries to service representatives based on representatives’ current workload and acquaintance of the delivery location, resulting an increase of 12% on time-delivery.

Assisted in developing KPIs, and tracked KPI progress, presenting reports and insights to C-level suite and stakeholders.

Aggregated data to model finances and operations, communicating reports, insights, and recommendations to 10+ departments.

LARSEN & TOUBRO INFOTECH LTD. (LTI), Business Analyst, Mumbai, India August 2013 - March 2016

LTI is an Indian multinational information technology services and consulting company based in Mumbai. LTI is recognized as the sixth-largest Indian IT services company in terms of export revenues. The major responsibilities of the role as an analyst revolved around collecting data and monitoring processes and analyzing, optimizing, and implementing cutting-edge solutions.

Managed designing, developing, integrating, testing, and maintenance of 20+ existing and new business applications.

Assisted a 4-person executive team with managing information systems solutions and 15+ databases.

Collaborated with a 9-person team in the development of a SharePoint video content library for core communication desk tasks and operational functions.

Documented all business processes and operating procedures from scratch for an early-stage startup.

Continuously monitored and evaluated processes to find areas of improvement, significantly improving the client experience by 32% by advising resource allocation based on project needs.

Interchanged between IT and business contacts to manage project lifecycle, and ensured team achieved 96% of deadlines by communicating realistic expectations.

EDUCATION

UNIVERSITY OF Mumbai, Mumbai, Maharashtra, India March 2013

Bachelor of Arts

Contact this candidate