Social Media Data

Mansi Vastani Chicago, Illinois ● adcc0u@r.postjobfree.com ● 815-***-****

5+ years of experience in the field of Analytics with exposure in Finance and IT. Inventive problem-solver with problem-solving skills to work at all management levels. Successful in identifying technical challenges and finding process improvement initiatives. Contributor in cross-functional team environments as well as independent assignments.

HIGHLIGHTS

SAP FICO

MS Excel (V-lookup, Pivots)

SQL Server Management Studio

User Stories and Test Plans

SDLC & Financial Modelling

Agile Project Management

Data Validation

Data Analytics

Tableau and Power BI

SharePoint

MS Visio and Powerpoint

Jira

Strategy & Business Consulting

Research & innovation

Business Intelligence

Machine Learning

Python

R programming

EDUCATION

Master of Science in Management Information Systems, Northern Illinois University - DeKalb, USA Jan 2018 - Dec 2019

Master of Business Administration (Finance), MIT - Pune, India Aug 2011 - Apr 2013

Bachelor of Commerce in Accounting & Financial Management M.S. University of Baroda, India Aug 2005 - May 2008

CAREER HISTORY

Deloitte Consulting LLP, Baton Rouge LA (Consultant) Aug 2019 - Dec 2019

Lead meetings with client and offshore IT team to identify business needs and propose recommendations to leadership.

Create an analytical framework, proactive trend analysis reducing database discrepancies by 50%.

Plan and created data analysis, data interpretation, QA, and automate statistical reporting using SQL, Tableau and Power BI.

Caterpillar Inc., Peoria IL (Student Consultant) Jan 2019 - May 2019

Saved $23M by developing Sales Model in MS Excel, presented reports using Tableau to the stakeholders.

Analyzed complex datasets to identify sales metrics, KPI, and budgeting to translate business problems into actionable results.

Jaykee Consultants, Pune India Jan 2013 - Dec 2017 (Business Analyst- Sep 2013 - Dec 2017)

(Junior Business Analyst- Jan 2013 - Aug 2013)

Led a 3-member analyst team to drive strategic decisions to increase the customer base by 10% and optimize profitability.

Completed project in 90 days in an industry that averages 10 months to completion; the client reported a 40% reduction in processing time.

Coached clients and junior team members on change management of software applications and database management.

Promoted shortly within the company due to strong performance and additional revenue generation of $0.5M.

Saved $3.2M in brokerage fees by building a strong relationship with clients; eliminating third parties.

Assisted with financial analysis, forecasting, ad-hoc reporting and customer support to internal & external clients.

Conduct comprehensive market research on industry data to assist senior analysts in decision-making.

ACADEMIC PROJECTS

Social Media Analysis using Python, Power BI and MS Excel: US Airlines Sentiment Aug 2018 - Dec 2018

Extracted data for text analysis from airlines Twitter handle using data scrapping techniques and integrated data in Excel.

Analyzed trends over time, sentiment analysis, correlation analysis and customer relationship regarding their services.

Developed Topic Modeling, Unstructured text processing, Data Wrangling in Python. Created interactive dashboards using business intelligence tools Power BI and a JIRA dashboard to identify and track issues.

Business System Analysis and Design using MS Visio: Northern Illinois University Ticketing Portal Aug 2018 - Dec 2018

Created a prototype of an interactive User Interface (UI) for the product. Identified software development methods like Waterfall and Agile to determine elements of the migration plan and conversion strategy.

Developed Use Cases, UML Diagrams named Use Case diagrams, Class Diagram, State Machine Diagram, Sequence Diagram using MS Visio. Evaluated risks by creating test cases and test plans.

Big Data Analysis using R, MS Excel: Commercial lending Financial Institution Aug 2018 - Dec 2018

Extracted the data and analyzed the approval or denial of the loan of a customer. The key issue addressed at the completion of the project was to analyze the impact of credit information of a candidate on the outcome of the loan application.

Performed tests such as null hypothesis, correlation, outlier detection, association rules, segmentation analysis.

Designed and built a logistic regression statistical model and predicted the probability of approving the credit.

CERTIFICATIONS AND SCHOLARSHIPS

DELL EMC Academic Associate, Data Science and Big Data Analytics.

Awarded with the scholarship of ‘Dr. Denise Schoenbachler Leadership Award in MIS/SAP Integration’ by the College of Business at Northern Illinois University.

Contact this candidate