IT Financial Analyst

Devarati Dasgupta

Cell: 757-***-**** ● Email: ****************@*****.*** ● LinkedIn: www.linkedin.com/in/devarati-dasgupta-161a5178 Professional Summary:

Financial/Business Analyst with 5 years of experience. Areas of expertise include Forecasting, Budgeting, Variance Analysis, M&A Analysis, Financial Modelling and Quality Assurance. Skills:

Technical Skills: Functional Skills:

• MS Excel Skills: vlookups, hookups,

Pivot Tables, Excel Modelling

• Financial Analysis

• Gap Analysis

• Database: MY SQL, Oracle • Valuation

• Languages: SQL, VBA • Business and Strategic Analysis

• ERP Tools: SAP • Project Management

• Methodology: Waterfall, Agile • Capacity Planning

• Microsoft Tools: Word, Excel,

PowerPoint, Project, Access

• Strong Written and Verbal

Communication Skills

• Project Mgmt. Tools: PPMc • Data Mapping and Analysis

• Other Tools: Tableau, Minitab, SAP

ARIBA, SAP Analysis for Office (AO)

• Requirement Gathering, Mapping

and Analysis

EDUCATION

• Mason School of Business at College of William & Mary: MBA, graduated 05/2016

• University of Mumbai, BE Electronics and Telecommunication, graduated 06/2011 Work History

PG&E 05/17 – PRESENT, SAN FRANCISCO, CA

IT Financial/Planning Analyst (Contract)

• Support IT Program containing ~ 15 IT Funded Projects and ~200 Client Funded Projects.

• Manage Budgets of ~$1Million/year for IT Funded Projects and ~ $10 Million/Year for Client funded projects.

• Review and analyze project spending throughout project lifecycle.

• Communicate daily with Project Managers and Program Manager regarding project status, updates and financials.

• Developed a new financial report to track monthly financials for client funded projects saving ~ 40 hours of reporting effort.

• Proactively monitor and analyze monthly project costs and perform variance analysis using SAP Analysis for Office (AO) tool and model in MS Excel using Pivot Tables.

• Support labor forecasts with projects and coordinate material and service procurement, contract/license management and vendor management.

• Actively use SAP ARIBA for creating requisitions and following up on purchase orders for contracts/materials.

• Lead bi-weekly meetings with Project Managers for variance explanations and monthly meetings with Program Manager and leadership to analyze spending and variances and provide Financial recommendations.

• Review and approve Project Change Requests (PCR), follow-up on projects going operative and execute the Project Closure Process for projects which are closing.

• Use PPMc tool for tracking projects.

WELLS FARGO 08/16 – 02/17, SAN FRANCISCO, CA

Business/Financial Analyst (Contract)

• Owned and built budgets and forecasts for the QA functional resources for a whole QA division.

• Performed monthly forecasts for >70 QA resources across >100 projects.

• Managed budgets of ~ $1 Million/release.

• Executed and reported gap and variance analysis.

• Improved and streamlined the forecasting accuracy and efficiency of the financial forecasting model and the capacity utilization model.

• Coordinated daily with Project Managers, QA Leads, Finance Leads and Management regarding financial forecasts and budgets.

TRIPBOUND 03/16 – 05/16: WILLIAMSBURG, VA

Finance and Data Analyst (Short Term Project)

• Performed Demand and Revenue Analysis and Forecasting for the next three years

• Performed Inventory Analysis and Forecasting for the next three years.

• Consult to the CEO regarding strategic decision

COLONIAL WILLIAMSBURG 08/15 – 04/16: WILLIAMSBURG, VA Business/Finance Analyst (The College of William and Mary Consultancy Project)

• Successfully conducted Market Research and Finance/Data Analysis project providing marketing solutions to increase the number of tourists for CW by 100% LIFENET HEALTH 06/15 – 08/15: VIRGINIA BEACH, VA

Finance (MBA) Intern

• Led project across multi-disciplinary teams to analyze expiring inventory and identify solutions to maximize revenue which will lead to revenue generation of approx. $2 million/mo.

• Demonstrated Mergers & Acquisition analysis skill by conducting market research and detailed valuation of target company presenting findings to CEO.

• Designed Cost Allocation Model calculating tissue recovery cost rate by type, and designed model to help determine profitability compared to competitor organizations.

• Built automated reports using pivot tables for sales revenue by product type and five- year trend of raw materials.

• Spearheaded product pricing project across Finance, Contracts, Marketing, Client Services and Accounting to deliver detailed report and flowchart. ACCENTURE 08/11 – 04/14: BANGALORE, INDIA

Business Analyst

• Conducted business analysis of complex projects for a Global Investment Bank

• Project involved planning, preparation and execution of application releases along and coordination with stakeholders, clients, third-party vendors and users across the globe

• Demonstrated thoroughness and attention to detail while managing application releases with zero production defects

• Managed cross-functional teams and important client relationships

• Took initiative by leading a white paper initiative for an international conference where seven white papers were contributed

• Performed Requirement Gathering and Analysis, Test Preparation, Estimation and Execution

Contact this candidate