Associate Business Analyst

Pratik Sadiwala

Contact No.: 714-***-**** Email: **************@*****.*** LinkedIn: linkedin.com/in/pratiksadiwala EDUCATION

Master of Science in Information Systems, Business Analytics (May 2020) California State University, Fullerton, California, United States Post Graduate Diploma in Business Management (May 2015) Maharaja Sayajirao University of Baroda, Vadodara, Gujarat, India Bachelor of Business Administration in Marketing Management (May 2014) Sardar Patel University, Vallabh Vidyanagar, Gujarat, India STRENGTHS AND EXPERTISE

Strengths: Data Analysis, Data Visualization, Databases, Business Intelligence, Data Management, Project Management, Financial Analysis, Operations, Business Operations, Reporting, Business Process, Analytical, and Organizational Skills. Certifications: Tableau Desktop Specialist.

Statistical Programming Language: R, Python, and SAS. Technical Expertise: SQL, Tableau, Power BI, SAP, Excel, Access, Visio, Salesforce, JIRA, Google Analytics, Google Suite, MS Office Suite, and Amazon Web Services (AWS). PROFESSIONAL EXPERIENCE

Associate Business Analyst, Deepak Prints, India (November 2016 - June 2018)

• Analyzed datasets on MS SQL using complex queries to derive key metrics & identify trends for database marketing.

• Produced financial reports for evaluating projects, tracking budgets, and assessing consumer variances via Excel.

• Extracted data from Salesforce and interpret data in Excel by implementing data analysis techniques to measure business performance, derive key insights, and create data visualizations for business analysis.

• Communicated business requirements & trained employees on utilizing Tableau for business intelligence solutions.

• Built interactive reports & dashboards in Tableau to track KPIs, share market analysis, and operational metrics.

• Proactively collaborated with cross-functional teams like the product and marketing to perform ad-hoc reporting for data-driven decision-making about pricing and product analytics using MS SQL & Tableau. Business Analyst, Deepak Prints, India (July 2015 – October 2016)

• Developed & maintained datasets on MS SQL via data definition language (DDL) and data manipulation queries.

• Conducted competitive analysis to recognize emerging segments for sales opportunities, which increased sales by 23%.

• Interpret market research data in Excel by applying statistical analysis for customer segmentation, pricing, sales forecasting, and product demand estimation.

• Provided reports in Excel (Macros, VLOOKUP, & pivot charts) to measure the effectiveness of marketing campaigns. ACADEMIC PROJECTS

Delivr E-commerce Food Delivery Service, Business Database Management

• Defined key metrics like user acquisition, retention rate, conversion, etc. with SQL data manipulation queries & joins.

• Calculated the revenue, cost, and profit using common table expressions (CTE’s), aggregation, and window functions.

• Prepared data for reporting by sorting results & used bucketing analysis to calculate a 48% variance in user behavior. VanArsdel International Sales & Market Analysis, Principles of Business Intelligence

• Transformed data in Tableau to ensure data integrity through data validation & managed table relationships with joins.

• Created sets, parameters, and calculated sales measures for yearly trend analysis, sales forecasts, and variance analysis.

• Used forecasting and trend line tools to determine the best products for achieving the predicted sales growth of 15%.

• Developed custom reports & dashboards, showcasing, market share, sales forecasts, and sales breakdown structure.