MANASI PATEL

Fullerton, California +1-617-***-**** ac29lo@r.postjobfree.com https://www.linkedin.com/in/manasipatel91

Self- motivated, enthusiastic and passionate analyst with 3+ years of experience in data analysis, forecasting, data modelling and visualization. Showcased excellent understanding of business operations and analytics tools to optimize statistical efficiency and business quality. Ability to present data in concise and compelling way to the executives and stakeholders. EDUCATION

California State University Fullerton Aug. 2015 - May 2017 Master of Information Systems and Decision Science (Business Analytics) 3.96 University of Mumbai Jul. 2009 - May 2012

Bachelor of Engineering (Information Technology) 3.40 PROFESSIONAL EXPERIENCE

Business Intelligence Analyst – XDimensional Technologies, Inc. Jul. 2017 - Present

• Remodel data conversion process to integrate data from 3rd party system into Nexsure data model using SQL, BI tools. This process improves the performance efficiency by 50%

• Design dashboards and drilldown reports in Power BI to track sales KPIs for different customers. This provides a better improved and interactive tracking system for sales team. Data Analyst Intern (Sales Operations) - Verizon Digital Media Services Sep. 2016 – May 2017

• Analyze, segment and forecast sales, revenue data. Transform raw data of won deals into meaningful insights and recommend management, how to improve revenue, profits and deal size by 30-40%.

• Lead a cross functional team initiative to validate data integrity across multiple systems. This helped the teams to reflect accurate forecast numbers and perform analysis with accurate data. Business Intelligence Intern - Exsilio Solutions Jun. 2016 – Aug. 2016

• Design end to end business intelligence solution for the United States domestic airline industry data.

• Perform ETL operations using SSIS to load primary, secondary data (million+ records) into warehouse from multiple data sources with different formats such as excel, CSV, JSON. Design data models based on warehouse using SSAS.

• Partner with stakeholders to identify and recommend key metrics to get insights of airline industry.

• Built reports, dashboards using Excel services and Power BI to visualize key metrics and perform drill down analysis. Business Intelligence Analyst - Accenture Services Pvt. Ltd. Feb. 2013 – Jun. 2015

• Translate report automation business requirements into effective action plans and deliverables using SSIS and SSRS.

• Evaluate the action plan using requirement traceability matrix. Plan, coordinate and execute acceptance testing.

• Proactively seek opportunities to optimize existing business processes, improved processing efficiency by 50%. ACADEMIC PROJECTS

Data Mining for Airbnb Aug. 2016 – Dec. 2016

• Perform data preprocessing and develop a classification model using several methods (Logistic Regression, CART, K- NN) to classify Airbnb listing as preferred or not and understand correlation between key factors. Data Analytics for Hotel Pacifica Ocean Jan.2016 – May. 2016

• Developed regression model on Hotel’s customer review data to infer which rating factors (predictors) highly influence Net Promoter Score. Recommended factors that helped hotel to improve its customer service.

• Data Visualization in Tableau to discover and interpret pattern, trends of customer demographics, booking behavior. Yelp Data Challenge Jan.2017 – May. 2017

• Performed text mining using NLTK along with sentimental analysis on customer reviews to identify most commonly used negative and positive words customers use to share their experience. TECHNICAL SKILLS

• Expertise: SQL, Advanced MS Excel, SSIS, SSRS, Power BI, Data Modelling/Warehousing, Data Analysis, Data Mining & Segmentation, RDBMS

• Databases: Oracle 10g, MS Access, Hadoop (Hive, Pig)

• BI & Visualization Tools: SSAS (OLAP, MDX), Tableau, Qlik View, Qlik Sense

• Statistical Packages: R, SPSS.

• Other Tools: MS Visio, MS Office, Team Foundation Server, SharePoint, Salesforce.com, Google apps

• Certification: SQL Server Certification

• Programming: Python, HTML, VB, C#, VBA, Linear

Programming

Contact this candidate