SUMMARY:

• 20 years as Financial Business Analyst
• Managed information technology projects and conducted budget and forecast modeling
• Expertise using popular financial management and business software programs
• Production Management in Information Technology, Real Estate, & Construction

TECHNICAL SKILLS:

Microsoft Office: Access, Excel, PowerPoint, Word

Accounting/Finance: SAP (Systems, Applications and Products)

Other: ERP (Oracle Hyperion, Peoplesoft) systems

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Financial Business Analyst

Responsibilities:

• Since 2011, have offered project management consulting services (e.g., accounting month - end close, general ledger accounting per GAAP (generally accepted accounting principles), and SOX (Sarbanes-Oxley), budgeting and forecasting, banking, human relations, financial analysis, P&L (Profit & Loss) and balance sheet analysis and reconciliation, internal auditing, database creation and administration, financial modeling, project management and PMO (project management office), Confidential (key performance indicator).
• Note that I have worked in multiple industries from Banking, Chemical Distribution, Construction, Manufacturing, Oil & Gas to Trading.
• I also offer English-Japanese translation services to businesses. For personal and business purposes, I have traveled extensively to Confidential, Confidential, Central Confidential, South Confidential, and Confidential, which has enhanced my language skills and breadth of cultural knowledge.
• As a financial analyst working for international corporations, I often worked on and shared information with multi-national, multi-lingual, cross-disciplinary teams.
• Currently, working as Project Manager - Construction Renovation Confidential .

Sr. Financial Business Analyst and PMO Lead

Responsibilities:

• Contracted to provide finance and project management services for Shell IT on over 30 global real estate projects totaling more than $30MM.
• Projects included handling accrual management with account reconciliations; developing tracking systems in Access and Excel for procurement, inventory, ad-hoc requests; serving as key contact and finance lead for HP ( T-Systems and other global third-party vendors about their IT hardware and services; tracking actual versus budget expenses using administrative systems per GAAP (generally accepted accounting principles), financial trackers, and online programs such as Aries, PM (Project Management) Dashboard, PRT, and SERP Timewriting; supporting business units from downstream to upstream and from real estate to service operations; and conducting weekly reviews of resources and vendors.

Confidential

Sr. Financial Business Analyst

Responsibilities:

• Supported line managers on BP’s trading floor in Commercial Energy, Power, and Natural Gas Liquids to help them maintain, operate, and conduct forecast analysis of IT-related hardware, software, and services. Built database of employees and contractors using Microsoft Access.
• Conducted accrual analysis and implementation per GAAP. Fulfilled ad-hoc requests of financial-related analysis for teams throughout BP.

Confidential, Alaska

Sr. Financial Analyst

Responsibilities:

• Supported the COO, VP of Finance, Country Directors and Country Managers in the following locations:, Gulf of Confidential, North Confidential, Dominican Republic and Northern Confidential, Confidential, Confidential, and the Confidential ).
• Built Access database linked to Excel and PowerPoint presentations to analyze and report monthly financial results consistently across all locations in North Confidential and Northern Confidential to track revenues; gross profit; SG&A (selling, general and administrative expenses); inventory; and accounts receivables.
• Advised business entities of possible process problems, losses and risk exposure. Identified opportunities for development and implementation of improvements in the operations and financial infrastructure processes. Assisted management in the development and implementation of HR (Human Resources) company-wide policies, procedures, process improvements, and best practices to maximize performance and reduce risk exposure.
• Ensured that HR policies and procedures were followed consistently by implementing accounting controls, improving operational processes, and promoting GAAP compliance.

Sr. Financial Analyst

Responsibilities:

• Conducted analysis of financial and legal indentures. Handled model and stress testing using Microsoft SQL (structured query language) Server relational database management system of multimillion dollar financial contracts for private and commercial investors. Continuous adherence to SOX (Sarbanes-Oxley Act) and GAAP rule and regulations.

Sr. Financial Business Analyst, Corporate Accounting

Responsibilities:

• Developed, managed and administered corporate accounting month-end close accounting files per GAAP and SOX rules and regulations, reports and procedures using Data Warehouse/Excel Cube Pivots for upper management and other department heads, internally and externally. Reports included Operating Profit Statements, Balance Sheets, Actual versus Budget Analysis, and more for numerous departments.
• Developed and administered Microsoft Access and SQL Server tracking and reporting databases for various departments, including HR (Human Resources), Sales, Real Estate, Leasing, Construction, Top 500 Acquisition, Legal, and Procurement.
• Created ad-hoc files and reports using Microsoft Excel, Access, and SQL Server.

Financial Business Analyst

Responsibilities:

• Conducted financial modeling and usage analysis. Created periodic financial results. Investigated variances of rental equipment in regards to rate, volume, and quantity.
• Did ad hoc reporting, budgeting and forecasting using Cognos Finance & Planning per GAAP and SOX rules and regulations.
• Designed, implemented, and maintained database in Microsoft Access, Excel and SQL Server.

Confidential

Sr. Financial Business Analyst

Responsibilities:

• Executed financial modeling and metric analysis. Created periodic financial results and investigate variances. Conducted ad-hoc reporting, budgeting and forecasting.
• Designed, implemented, and maintained Corporate Radar system using Microsoft Access and Excel plus SQL (structured query language) Server.
• Established policies and procedures for management per GAAP and SOX rules and regulations, security, maintenance, and database use.
• Trained and ran quarterly workshops for employees in 14 Latin American offices. Supported budgeting and forecasting.
• Helped lead CPM (Cost Performance Management) team on project that saved $1 million dollars annually.

Financial Analyst II

Responsibilities:

• Analyzed and interpreted operating database tables from financial system applications.
• Prepared monthly and periodic financial reports for month-end reconciliation per GAAP and SOX rules and regulations.
• Developed, implemented and updated effective financial and operational reporting systems to meet current reporting needs and future enhancements.
• Provided operations and financial organizations with timely, accurate and meaningful information.
• Maintained and prepared records to ensure completeness and accuracy and brought inconsistencies to the attention of management.
• Managed department accounting requirements using PeopleSoft to track accounts (receivable/payable).
• Served as a reference for and maintained files of information frequently requested by management.

Senior Financial Analyst

Responsibilities:

• Handled analytic management of accounts related to IT contracts for the Chemical Energy Group. Managed department accounting requirements using SAP and Paper Vision to track accounts (receivable/payable) for major energy clients per GAAP and SOX rules and regulations.
• Prepared forecasts and project budgets. Conducted variance analysis and month-end P&L reporting using Hyperion Pillar.
• Involved in SAP conversion and received training in Business Warehouse

Confidential

Financial Analyst, Risk Management

Responsibilities:

• Managed department accounting requirements using AS400. Handled monthly journal entries, monthly reconciliations of actual vs. budgeted costs, annual department and insurance budgets, and quarterly insurance reserve analysis per GAAP and SOX rules and regulations.
• Developed and analyzed management reports to chart and schedule premium costs, claim costs, claim frequencies, trends, causations, etc.
• Developed and implemented methodology to track, record, and analyze total cost of insurance risk.
• Automated monthly financial reports.