Project Manager Analyst

Anita Bubna

*** ****** ***. *******, ** ************@*********.*** Cell (925) 330

1155

Business / Financial Data Analyst with over 5 years strong work experience

in IT domain with 2 years in a bank. Strong hands on technical experience

in programming, data extraction, validation, analysis, and building models.

Mastered the skills in reconciliation and cleansing of data flowing from

multiple sources. Demonstrated keen insight of business user's reporting

requirements. Provided training, documentation and on going support to

users to ease their transition to new solutions.

Experience in following:

Financial Forecasting & Planning Advanced EXCEL (Scenarios,

solver, pivots)

Budget Variance analysis VBA/ JAVA programming

Financial Modeling Access, SQL

Financial Reporting & Analysis MS Project, Visio, PowerPoint

Revenue recognition PeopleSoft

PROFESSIONAL EXPERIENCE

BRITISH TELECOM (ins), Santa Clara, CA 2009

Operational Financial Analyst (Contract)

o Independently handled monthly financial forecasts for two operations

within the U.S. with $40 million in total annual revenue.

o Key participant in monthly operational review meetings between the

operation head, CFO, Finance manager to provide explanation on trends

and variances in the monthly P& L.

o Developed VBA code to simplify the consolidation of the budget/ plan data

for various operations.

o Provided ad hoc analysis and Access and Excel based reports to support

strategic decision making.

o Independently handled global intercompany transactions - reconciliation

and conflict resolution in case of disputes.

Fireside bank, Pleasanton, CA

2007-2008

Financial Analyst

o Developed financial models for over 60 business units to forecast

operating expenses, headcount, and capital expenditures.

o Created trend analysis reports for contract volume, deposits, charge off

and other key operating metrics.

o Established checks and reconciliation procedures to ensure accuracy of

data in various plan models.

o Collaborated with senior management to review and improve the financial

reporting and planning processes.

o Significantly improved budget variance analysis reports by making them

concise, supported with evidence, and clearly highlighting actionable

items.

o Redesigned database structure of key tables in Access to streamline

financial reporting.

o Designed several ad hoc reports for the management using SQL, VB,

Advanced Excel (pivot tables,

macros, scenarios, solver, arrays)

o Created PowerPoint presentation of the financial plan for periodic board

meetings.

B.S. in Business Administration, Finance Summa cum Laude (GPA

3.9) 2003-2006

CSU Eastbay, Hayward, CA

Anita bubna PAGE 2

Asia Online, Danville, CA 2000

Business Analyst/ Project Manager, Web Development

o Won client confidence by demonstrating keen understanding of unique

business models and delivering customized technology solutions

o Expedited stalled projects by reengaging difficult clients and resolving

conflicts creatively.

o Motivated offshore development team to deliver both on quality and speed

by providing them clear and detailed documentation on client requirements

and changing needs.

o Excelled at concept selling to clients and was requested to assist the

business development team in negotiation/ presentations.

o Ensured on -time and on-budget delivery of project deliverables by

tracking on MS Project.

Lee & Nee SOFTWARE. Kolkata, India 1996-1999

Principal, Web development

o Founded a web design and development startup.

o Analyzed client's business needs and proposed technology solutions.

o Prepared project proposals, negotiated contracts and closed deals.

o Achieved a customer retention ratio higher than 80%.

o Managed a seven member production and business development team.

o Executed over 60 web design/application and multimedia projects annually.

EDUCATION

B.S. in Business Administration, Finance Summa cum Laude

(GPA 3.9)

CSU Eastbay, Hayward, CA

Certificate in Software Development & Systems Management

National Institute of Information Technology, India (NIIT)

ACADEMIC PROJECTS

Corporate Valuation: Built a model for determining the corporate value of

Lithia Motors, Medford, OR. Completed five year projections of P&L, balance

sheets, and free cash flow statements. Reconciled share value computed by the

model to actual stock price on a given date.

Investment Analysis: Created an online investment portfolio on

stocktrack.com. Determined the investment objective, asset allocation plan,

conducted industry and security analysis, formulated investment strategy, and

analyzed portfolio results.

Business Plan: Prepared a comprehensive business plan for an online resale

store.

Contact this candidate