Information Technology Data

MANSI AGARWAL

** ****** ***, *** # ***, Jersey City, NJ – 07304 Email: *********@*****.*** Phone: 206-***-**** A graduate student in Information Technology having hands on experience in financial domain and a strong background in data analytics, predictive modeling and business analysis. Actively seeking full time opportunity to leverage my technical and analytical skills. EDUCATION

Rutgers Business School January 2017 - Present

Masters in Information Technology & Analytics GPA: 4.0/4.0 Coursework: Analysis for Business Intelligence, Data Analysis & decision making, Quantitative Skills, Business Data Management, Business Forecasting, Data Mining, Introduction to Data Science, Web Analytics, Financial Management Certification from Institute of Chartered Accountants of India (equivalent to CPA) April 2004-May 2006 Chartered Accountancy

Coursework: Financial Reporting, Financial Management, Auditing, Risk Management) TECHNICAL SKILLS

R Programming Python MySQL Google Analytics Tableau

Business Analysis Financial Modeling Git hub Advanced excel Hyperion WORK EXPERIENCE

Intuit Inc Data Analyst March 2013 – April 2014

Partnered with business leaders to build expense budgets, utilizing Time series forecasting techniques in R programming to improve forecast accuracy.

Utilized Python pandas to perform data analytics – collection, pre-processing, organization and prediction, for structured & unstructured dataset and subsequently provided actionable insights to each business unit.

Identified key expense drivers and provided Risk & Opportunity Analysis to assist business drive cuts/expense trade-offs.

Implemented visualisations and dashboards using Tableau for management.

Created a robust operating & governance mechanism between Technology, Finance & other teams.

Revamped plan/forecast templates in Microsoft excel using agile methodology. Kraft Foods Inc Financial Analyst August 2011 – October 2012

Acted as business analyst for designing pricing templates in Microsoft excel. Performed complete cycle of business analysis– requirement elicitation from stakeholders, communicating to technical team, designing the user interfaces in excel and monitoring the output.

Provided Financial Modeling & Analytics expertise for the outsourcing initiatives, which included developing initial business case, creating templates for suppliers & benchmarking supplier costs.

Provided Governance for Facilities Management Contract which included managing Financial provisions of the contract, facilitating compliance & audit reviews, approving & monitoring the baseline changes. J.P. Morgan Chase Financial Analyst March 2008 – July 2011

Finalized financial statements and monthly performance reports for investment funds.

Calculated Net Asset value for the fund & designed dashboards using MS excel to depict trends in fund performance.

Analyzed past years data, to arrive at run rates for various expenses by month.

Performed property valuation using financial modeling, sensitivity analysis. ACADEMIC PROJECTS January 2017 – Present

Conducted business analytical study on NYC restaurant violations using regression techniques in R programming, enabling development of a predictive model to determine grade for their upcoming inspections.

Used data mining techniques in R programming, to predict if a patient will show up or miss scheduled appointment. Utilized tableau to analyse relationship between various attributes and make recommendations for stakeholders.

Designed & implemented relational database for boutique hotel business in MySQL.

Used regression techniques in Python, to predict sales for BigMart & analysed significant relationship between various attributes.

Conducted time-series forecasting for New Jersey Housing prices. Fitted Holt Winters Seasonality Model with 90% forecast accuracy.

Used principle of simulations and MS excel solver, to arrive at the optimal quantity to be ordered by a newspaper vendor.

Performed in depth web analytics for a small-scale business using google analytics and provided implementable recommendations for improving their web traffic, managing bounce rate & creating brand awareness.

Analysed the web performance of Quality Alloys Inc, fitted a prediction model to predict their revenue using R programming and provided implementable recommendations for increasing their revenue.

Using D-code, a natural language programming tool, created spreadsheet model for a fictional hacker company, to predict if they should shut down hacking business or continue.

Using B-wise, a natural language programming tool, simplified the complex process to climb Himalayas (fictional case study) and created an expert decision tree where a mountaineering applicant can check their eligibility before registering.

Contact this candidate