Project Real Estate

VAQAS KHAN

Financial Analyst

Contact: 209-***-****

abntl3@r.postjobfree.com

Summary:

• Over 4 Years of Finance and Accounting analysis experience that includes financial

statement analysis, competitive analysis and recommendation.

• Cost reduction plans and supplement revenues.

• Database maintenance including name, address and phone numbers on SAP system.

• Data extraction tools in SAP for analysis.

• Data manipulation using Pivot Tables and Scenario analysis.

• Reconciliation of statements and making adjustment entries for accuracy.

• Team player to work with different departments and ensure to meet deadlines.

• Reviews costs and performs cost benefit analysis related to projects and programs.

• Interprets past data to project performance in future.

• Solid understanding of P&L and B/S Statements

• Compile and report Gross profit and operational income.

• Records, classifies, and summarizes financial transactions and events in accordance with

generally accepted accounting principles (GAAP).

• Monitor forecasts and actual for significant variances.

• Analyze market spending commitments and track actual.

• Forecasting using regression and trend analysis.

SKILLS

Applications: SAP, Word, Excel, Power point, SPSS, Star Office, familiar with Oracle

Reports Crystal reports, Access, Excel, Hyperion Essbase, BisNet, Oracle BIC

Operating Systems: Windows 2000/ 98 / 95 /, Sun Solaris

ERP: SAP R/3 4.6, SAP FICO

Investments: Real Estate, small loans, stocks.

Accounting Concepts: SAB 101, FASB, SEC, SOX, GAAP, Accrual accounting

PROFESSIONAL EXPERIENCE

Black and Veatch Corporation (02/2009 – Present)

Financial Analyst - Project Controls

• Generate weekly hour reports for Project Managers and Engineers

• Generate weekly cost reports for Project Managers on PG&E Substations and T-lines.

• Involve in forecast and budgets for each project.

• Monitor variances and let the Manager knows about it.

• Monitor Budget hours/cost and report on variances

• Generate Estimates on new and existing projects for additional work

• Monitor progress of each phase of the project for any delays

• Check invoices and request client for release of payment

• Update BisNet application for all updates on performance

• Log on to Xion application to see the available funds to the project

• Record Work Order (CWA) and release the funds to the Project Managers

• Review PIC sheets for monthly global meeting with the Project Controller

• Attend weekly meetings to update on forecast, budgets, expenses and revenues

Chevron Corporation, CA (06/2007-10/2008)

Technical Financial Analyst- (Contract)

• Generate Primary and Secondary expense report on SAP

• Format Excel reports to upload on Access database

• Generate Revenue report from BW module

• Use Pivot Tables to analyze data and make presentation

• Reconcile data on SAP with data on Excel for accuracy

• Use V-lookups to automate data generation from huge database of over a million rows

• Support Senior Financial Analyst on the performance analysis of products and services

• Generate Detail Reports for each individual product line

• Generate performance charts to help management visually analyze the company

performance

• Detail orientation to Junior Analysts

Spearhead Technologies, CA (03/2003-05/2007)

Financial Analyst

• Financial ratio analysis and Qualitative modeling.

• Develop BUDGET plans and sent for Management approval

• Resource Budgeting based on performance and future objectives

• Objection handling and assistance in strategy formulation for business development team

• Track Budgeting goals with actual performance for variance

• Headcount Analysis – Trended actual, forecast / budgeting

• Employee incentive analysis and commissions forecast

• Pivot tables for cross-analysis and reconciliation for accuracy

• Review SAP postings and enter JV of accruals or corrections

• Inventory revenues, invoicing, collection and follow-up.

• NPV, IRR and ROI modeling.

• Financial Statement analysis for growth, variance, forecast and budget analysis.

• Cost reduction models and recommendations.

• Resolving transaction and recording issues.

• Recommendations on the investment opportunities in market.

• Periodic reporting on financial performance and its impact on the company plans.

Premier One Funding Group, CA (04/2002-02/2003)

Loan consultant

• Extract data from various sources and do analysis to review market growth.

• Perform Cluster analysis to segment market for appropriate loans types.

• Develop and discuss new financial products and monitor their performance for each

region on monthly basis.

• Competitive analysis and benchmark for the performance appraisal.

• Develop tools and templates to measure the financial and operational information that

include financial ratios, performance indicators, and revenue forecasting, pricing and

management reports.

• Led a team of telemarketers and web marketers for business development and

promotion.

• Loan processing, documentation and escrow detail.

• Provided primary and secondary research expertise and project coordination in support

of business decisions.

• Risk analysis on the credit worthiness and credibility of clients for different loan options.

EDUCATION:

• MBA (1)- Finance

• MBA (2)- Marketing Management

California State University Hayward

Bachelors - Business Administration

• License: California Real Estate Sales Person

o Working on California Real Estate Broker License

o CPA- Part-1

Contact this candidate