Data Analyst

BIJAL SHAH

*** *. ****** ****, ******, NJ ***** Tel: 917-***-**** Email: *****.***@*****.***

Objective

I am an adaptable, motivational and collaborative team member with excellent interpersonal skills seeking a job as a Data Analyst /Business Analyst with expertise in creating data reports, data manipulation, and business process improvement that can result in direct cost savings and increased revenue in a progressive company.

Summary

Analyzed large complex data from the Business Warehouse (SAP) by creating Pivot tables and Charts for quick understanding for internal team members.

Scheduled and facilitated joint application design (JAD) sessions related to the project with IT team and stakeholders.

Have created dashboards in SAP business warehouse for easy and quick viewing of summarized data for internal stakeholders.

Generated financial models and templates utilizing Excel spreadsheet, including Pivot Tables, V Look-ups, and Macros.

Gathered requirements from various stakeholders and communicated to the technical team.

In depth knowledge of Pharmaceutical / Medical Devices Industry and Retail Industries.

Core Competencies

Data Analysis

Business Analysis

Target Evaluation

Cost Benefit Analysis

Root Cause Analysis

Pivot Tables

V lookup/H Lookup in MS Excel

Forecasting and Planning

Business Process Improvement

Data Visualization

Education

Avtech Institute of Technology, South Plainfield, NJ, April 2016- Sep 2016

Business Analysis (Pending IIBA certification) Microsoft Office Specialist

Bhavan’s College, Ahmedabad, India: Post Graduate Diploma in Business Management

St Xavier’s College, Ahmedabad, India: Bachelors of Science in Electronics

Professional Experience

Financial Analyst- Nine West Holdings, NY Jun 2017-Current

Generated monthly financial statements and monthly reconciliation of accounts for the company’s marketing budget.

Maintained extensive and complex Excel spreadsheet analysis of marketing budget.

Reconciled monthly credit card statements and process invoices to maintain accurate receiving reports.

Provided assistance at month-end and quarter-end closes and account reconciliation.

Month-end financial close, journal entries, accruals, financial statements, and financial reporting performed using SAP.

Conducted periodic interviews with Budget Owners to maintain accurate accruals and expenses.

Data Analyst – DePuy Synthes (Johnson & Johnson Company) May 2016-Jun 2017

Created multiple workbooks on competitor level and platform level for company Market Model.

Designed Input guide for future recording of the sales by product category and by competitor in the desired format.

Analyzed large and complex data from different sources and created master report for management.

Identified data discrepancies and creating algorithm for effective analysis.

Interpreted Data from the earnings call and other third party internet sites of key market competitors.

Forecasted revenue using present data and historical data.

Worked on Tableau reports for analysis of revenue and Market Share.

Jet Airways, Jersey City, NJ

Data Analyst Business Intelligence- US &CA Jun 2010 - Mar 2016

Analyzed large complex data from the Business Warehouse (SAP) by creating Pivot tables and Charts for quick understanding for internal team members.

Designed a process for backend calculation for external stakeholders and reduced turnaround time from 60 days to 7 days. This led to better relationship and growth in business significantly.

Devised appropriate procedures for various channels of distribution to gain maximum benefit in terms of growth in revenue and cost reduction.

Created Business Requirement Design Documents (BRD).

Scheduled and facilitated joint application design (JAD) sessions related to the project with IT team and stakeholders.

Have created dashboards in SAP business warehouse for easy and quick viewing of summarized data for internal stakeholders.

Prepared PowerPoint presentations and Excel spreadsheets for business meetings.

Performed strong numerical, interpretative, analytical and diagnostic skills; performed Gap analysis on financial data to understand the business process.

Collaborated with stakeholders across 3 continents for understanding growth of business in terms of revenue and reduction in cost.

Devised options for revenue growth due strong in- depth knowledge of the industry.

Created a safe, collaborative, atmosphere that enabled innovative approaches.

Combined Pricing, Schedules and Yield management that produced significant improvements in revenue management function.

Performed in-depth market analysis to be competitive during fulfillment of external RFP’s.

Performed data mining activity to churn important information for quick decision making.

Imparted training on ticketing module and revenue reporting to USA and CA city and airport staff.

Contributed innovative ideas to retain customers on Jet Airways.

Have offered solutions for conflict management, thus strengthening relationship with customers.

Support Analyst May 2007 - Jun 2010

Identified areas for business improvement.

Designed and analyzed maps and flowcharts of current and future business processes.

Reported on the likely impact of process modifications.

Flagging up potential problems at an early stage.

Developed a clear understanding of existing business functions and processes.

Reported bugs and interacted with the software development team to resolve issues.

Professional Skills

Word, Excel, Outlook, PowerPoint, Visio, Access, PL/SQL, knowledge of Agile Methodology, SharePoint, and SAP,VBA, Macros

Status : US Citizen

Contact this candidate