Post Job Free

Resume

Sign in

Project Financial Analyst

Location:
Missouri City, TX
Posted:
December 13, 2019

Contact this candidate

Resume:

SUMMARY:

Optimize strong financial & business analytical and project management skills in Financial, IT and Business side, with focus on functional analysis, project management, compliance, document control, application management, process improvement, reporting and dash-boarding. Previous experiences in Healthcare Industry, Oil & Gas, Banking & Investments, Bio-Pharma & Life science, Construction & Engineering EPCM, & Insurance & Federal government.

EDUCATION:

Manila, Philippines

MBA, Finance-De La Salle University

BSBA, Major in Accounting & Management, University of the East

CERTIFICATIONS / TRAINING:

A+ Certification Course & Network Essentials, CTREC, Houston, TX

Licensed Insurance Agent, Life, Health and Property & Casualty:

Re-Insurance; Licensed Real Estate Broker, State of California

Mortgage Origination Course, Dearborn-Leonard Hawes School of Real Estate, Houston, TX

Licensed – Life & Health Insurance, State of California &Texas

Licensed Mortgage Broker/Loan Officer, State of Texas

Financial Analysis; Credit Policy and Procedures; Risk Management Program, Principles of Economics; Strategic Planning; Agile Project Management & Methodology, Earn Value Analysis & Management

Team Management Systems Software Training (SCO Unix O/S Platform)

TECHNOLOGY SUMMARY:

MS Office 2007-2010, Excel spreadsheet, MS Access, PowerPoint, MS Word, Outlook, MS Project,Visio

Had training in SAP System R/3 Environment ( FICO), SAP Business Object (BPC), SAP WBS (Work Breakdown Structure),SOX Compliance, JD Edwards Accounting software on AS 400 Platform; Team Management Systems (TMS), Accounting & Business Management software run in SCO Unix O/S platform

A+ Course and SMS System, Crystal Reports, IDX, HCC System, Network Essentials for Windows NT& 2000

SMS & HCC Systems, IDX Systems, SQL, Hyperion –SQL Queries –Data extraction and Oracle Data base, Oracle Platform (PaaS), Hyperion Essbase & Enterprise Information Warehousing Systems, Microsoft Project, Project Management & Control, Earn Value Management System, Project Development & Execution Process with Agile Methodology.implementation.

WSO (Wall Street) System

PROFESSIONAL EXPERIENCE:

TAS Systems, Inc. –Project Management/Controller /Sr. Analyst 12/2008 – To Date

Contract On Call -, when Off the project, for Washington DC, Houston & California Operation, New England States, handling project overseeing & management for the company’s Corporate, Federal, State and City government clients in the areas.

Designing the company’s Short & long term corporate outlook, feasibility studies, business process improvements, business and financial plan for its Houston, TX, Los Angeles operation.

Handling account management, business process & analysis, client site visits and identify business process requirements. Interface with TAS Project Managers on site

Provide Monthly existing project reports to management.

Client: Lonza Biologics, Inc, Lonza Group, Portsmouth, NH

Project Cost Controller/ Global Engineering Projects-EPCM ( Contract) 02/2015- 03/2017

On Contract assignment, handling project cost controllership of capital projects (CAPEX) with total budget of $156 MM Mono Suite Plant Project & $37.8MM Cell Therapy Plant Expansion Project.

Implementation of standardized capital project planning, capital construction,controlling and execution processes and driving of consistent application of these processes across Lonza’s strategic growth projects. Effective working with and providing of guidance to project teams to support project management standardization and driving of improvements for project management processes

Developing standard processes, tools and complex financial model templates that support the planning, cost controlling and management of capital projects and construction.

Preparation and implementation of project initiation activities including creation of accounts with accurate and consistent WBS structures in SAP System

Setting up of budget tracking systems and project schedule, performed routine cost and schedule risk assessments. Working with Lonza Finance in setting up capital plant construction and expenditures. (CAPEX).

Working with the project contracts team with negotiations with the prime and sub-prime contractors. Provide guidance and assistance to main contractor in the proper preparation of cost, schedules & Project Milestones Statistics ( Rate of Performance). Estimates at Complete (EAC)

Work with Vendors on work estimates, review & audit invoices prior to approval

Creation of Capex TMetrics, CPI, SPI Earned Value Analysis & Mgt. reports, accurate cash flow plan vs. actual and routine 6 month/annual rolling forecasts and project monthly status reports.

Monitor and control commitment plan vs Actual spend and variance reporting and Financial Audit for SOX compliance.

Support the project Change Management process with an appropriate documentation system

Preparation, planning and execution of project closeout activities including assignment of assets for depreciation for SOX Compliance.

Client : Chevron Corp- Upstream & Production Mid Continent –Houston, TX 03/2014- 10-2014

IT PMO Project Controller ( Contract) through Tech Mahindra

Handling forecasting and budget management & control,monitoring amounting to $ Millions for all IT and capital asset projects for Upstream. Variance reporting and project finance management dashboard reporting on a monthly basis.

Perform planning, delivery & support of large scale upstream tech program, development of cost estimates for both non-labor and labor resources to conform with the IT projects allocated budget set by the PMO governance committee

Closely interface and coordinates with Project Managers, stakeholders, Project Team, functional and business units on project task, project road map, deliverables and resource on-boarding & other requirements and change management process implementation

Worked with Project Work Breakdown Structure Code in SAP and Extracting OPEX and CAPEX Actual spend Vs Budget & rolling Forecast.

Identify issues, Reconcile cost variances and allocate to proper cost centers

Revalidating the Project Schedule, Identifying unallocated tasks, leveling resources, tasks with no predecessors. Getting agreement with PMO and Base lining the Project Schedule and timeline

Kaiser Permanente, MSSA Office, Burbank, CA 04/2012 – 12-2013

Financial / Sr. Business Analyst (Contract)

Contract assignment with Kaiser Permanente, MSSA Office, Burbank, CA – handling project implementation for the institution’s health plans nationwide and re-structuring existing health plans and pricing analysis to conform with the US Dept. of health and Human services guidelines.

Work closely with project Implementation team lead in re-designing Kaiser’s health plans for its members.

Define and document health plan data quality checks, consistencies

Upload new health plans in SharePoint and Document Control Management Systems

Client: Bank of New York Mellon, Houston, TX 08-2011-03/2012

Financial Modeling/Business Analyst –Analytics ( Contract )

Contract Assignment, Handled financial modeling analysis system for the bank’s CDO (Collateralized Debt Obligations) securities, with Corporate Trust Department utilizing WSO (Wall Street) Systems

Client: Chevron Corp., Office of the Chief Information Officer, Downstream- Strategy,

Planning and Architecture department, Headquarters, Houston, TX 07/2009 – 07/2011

Project Financial Analyst / Project Controller (Contract)

Business, Financial, Audit & cost analysis for Chevron’s global supply chain & manufacturing IT projects; interfaced between IT project managers, PMO and Governance & Finance group on financial related issues and project timelines, projects funding, deliverables & closing, Assets under Construction (AUC’s), Depreciation schedule for AUC’s and other requirements for SOX Compliance

Analyzed historical and current cost structure utilizing the SAP systems and Hyperion Essbase

Created & allocated (WBS) Work Breakdown Structure cost element to global cost centers and business units utilizing activity based costing (ABC); prepared and handled monthly financial analysis, audit & cost reporting for all IT projects both Operating (OpEx) and Capital (Capex) expenditures vs. budget plan of $68MM/year

Handled cost centers accounts reconciliation, variances, managed & posted Journal entries adjustment & account accruals in SAP systems

Handled Vendor account analysis and project management related to Chevron’s Global IT projects

Designed financial & budget cost model for management reporting and SOX Compliance

Assisted the Global IT Project Controller on SAP Month End Close and Downstream Global IT project management and Business Analysis

Handled various Business Analyst and PMO analyst functions during Chevron Resource Optimization Management (ROM) project implementation until final transition was in placed in 2010

Handled IT Project Controllership and budget management functions from 09/2010 through 03/2011

Client: Government of the District of Columbia, Washington, DC,

Office of the Chief Financial Officer, Department of Budget & Planning 12/2008 – 06/2009

Project Financial / Business Analyst (contract)

Performed as Project Team Lead Financial / Portfolio Analyst for the Cost Driver Project being implemented by the District of Columbia Government across all its agencies

Consulted with IT and Business units/users on applying technology on business opportunities and planning and implementation of cross functional applications

Collaborated with Business units/Users in gathering/modeling business metrics & requirements/data, business processes and business rules to ensure solutions met business objectives

Elicited business requirements using interviews, document analysis(BRD), requirements workshops, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis, and/or viewpoints

Analyzed historical and current budget/appropriation and expenditures; identifying key cost elements and developing methodology, working model of services, identify drivers & utilizing activity based costing, establishing basic metrics related to the cost elements; Budget variance analysis with emphasis on the Dept. of Health and Human Services, Dept. of Healthcare Finance (Medicaid Management Administration)

Performed forecast of cost/expenditures using linear regression, moving average and trend. Government Cost Accounting and FAR

Developed Cost driver database for all cluster agencies such as Dept. of Health and Human Services, Medicaid, Transportation, Regulatory and Consumer affairs, and other agencies

Designed Cost driver templates/metrics for future integration to DC financial information systems

Project completed 06/30/2009

Global Healthcare Resources Corp. / Global Workforce Resources, LLC 08/2007 – 11/2008 Business & Financial Consultant (Part-Time)

Healthcare Consulting, provided business process improvements, financial, information systems, clinical management, and recruitment services for Global’s Client hospital facilities in the State of Texas, Mississippi, Louisiana, Florida, Alabama and other Southern States

Provided recruitment services for Global’s major Clients in Construction and Engineering Companies in the US and international projects

Provided consulting services to Global home health facility and health care staffing services in the City of Beaumont, Baytown, Texas and other counties

University of Texas, M.D. Anderson Cancer Center 07/2002 – 07/2007

Sr. Financial Reporting Analyst, Managed Care Finance / Sr. Decision Support Analyst, Dept. of Financial Services (Full Time)

Provided analysis of MDACC and Physician’s Managed Care Contract activities

Supported the Institution by tracking the profitability of Third Party Payor & Managed Care Contracts

Analysis of hospital, clinic and physicians’ charges, cost, payments, and net revenue related to each contract

MC Receivables tracking, audit and collection

Handled 26 Managed Care Contracts with a total business portfolio in the amount of over $300 million/year

Provided Financial & logistical support to Managed Care Contract Administrator

Extracted managed care patient data from SMS, IDX Systems- ICD 9-CM systems, Oracle and other various databases in the Institution, utilizing Hyperion, Brio and SQL applications and performing analysis to include DRG’s, charges, costs, payments, expected reimbursement, and revenue

Analyzed variances between actual and expected reimbursement and identified denied charges including Medicaid and Medicare

Reviewed and analyzed Charge master’s Database & regularly mapping out DRG’s to Physicians CPT Codes

Created financial models & reports that analyzed cost/reimbursement by MS-DRG, major diagnostic category, etc.; included variable and fixed costs, case mix, and actual reimbursement; examined payer profitability utilizing ABC, cost accounting techniques to adequately reflect operating costs

Responsible for compiling data & data Management in MS Excel, Access Data Base for Managed Care Finance Department to insure accuracy in financial reporting & timely ad-hoc reporting

Conducted financial analysis of Managed Care and Cancer Manager activities and worked closely with a variety of MDACC departments, outreach and representatives from external affiliations on operational and financial issues; handled the Institution’s Physicians and other departments and business unit’s profitability report on an Ad hoc basis

Performed as Project Team member on the HCC Contract Management System Implementation

Interfaced with other business units in, gathering and modeling business requirement /data, business processes, and other business rules in order to ensure alternatives were carefully considered and that the chosen solution met business objectives

Responsible for documenting, developing and finalizing business and functional

Handled special project for the Bone Marrow Transplant business & Financial analysis and created the Bone Marrow Transplant managed care contracts Data base in Excel & MS Access

Horn, Wallace, Cole, CPA’s 07/1999– 06/2002

Client: Halliburton/Brown & Root, Houston, TX

Project Financial Analyst, 1 year ( Contract)

Assigned to international Haliburton Joint Venture Pipeline project in Carmen, Mexico

Handled joint interest / inter-company’s past year consolidated financial re-construction and Balance Sheet reconciliation and Management financial reporting

Analyzed, audited & reconciled Balance Sheet and Revenue & Cost center accounts

Performed joint interest/inter-company’s project accounting, Variance, revenue and cost analysis and project cost allocation

Performed account reclassification and adjustment for various profit and cost centers

Client: Shell Corp, Houston, TX

Cash / Treasury Analyst-Specialist,/Analyst - 2 years( Contract)

On Contract Assignment with Shell/Texaco Alliance Project assigned to Financial Operation Center (FOC-SAP), Equiva Services, LLC., a Business Unit of Shell/Texaco/Saudi Aramco Alliance

Handled Balance Sheet accounts Reconciliation, analysis, audit & accounts tracking & research, reconciliation of Inter-company’s Cash transactions using SAP R/3 financial systems

Electronic Banking Reconciliation of Cash Accounts- Fedwires/Lock Box deposits/Electronic funds Transfers, $MM Funds movement, Cash Flow & analysis

Analyzed and posted journal & correcting entries, adjustments to SAP G/L accounts

Handled cash accounting for foreign currency conversion to conform with International Accounting Standards & GAAP & to insure data accuracy on the G/L accounts

Prepared monthly bank reconciliation reports on various cash accounts

Cash Variance analysis & Reports using MS Access

Terminal Cash Accounts periodic monitoring and balancing

Designed and standardized reconciliation reports and supporting schedules

Managed and maintained controls of EBS Cash accounts on daily basis on SAP/R3 System



Contact this candidate