May SeGuin 949-***-**** R. S. M. CA *****, email: *********@*****.*** .
Summary:
• Responsible for ensuring the highest standards of financial excellence, fiscal integrity, project management, and stewardship of resources.
• Centralize Contract Revenue streams in Revenue recognition solution. Comply with ASC 606 & IFRS 15 standards. Automate calculations, reduce the period-end closes, gain a complete picture of your organization’s revenue streams – both recognized and deferred.
• Extensive experience in Financial Accounting Reporting, Revenue Recognition, Budgeting / Forecasting, Annual Operating Planning, and Data Monitoring and Reconciliation, Financial Statements Consolidation, Implementation of Internal Controls & Auditing, Exp preparing and documenting global transfer pricing studies, and Budget & Actual financial Flux Analytics, Cost Accounting, Strategic Pricing.
• Analyze financial data, statements, and trends and conducts due diligence to inform strategic decision-making for individuals, institutional investors, and private companies and manages investment portfolios, and in compliance with FAR (Federal Acquisition Regulation) guidelines.
• Assess market conditions, including a company’s financial performance, and prepares forecasts and reports that enable clients to make informed financial choices.
• Provide advisory services to help companies issue new stocks and bonds and sells issued securities to investors.
• Experienced in CAS interpretation and application. Comprehensive knowledge and expertise in performing financial functions, including Cost Accounting Standards (CAS), Extensive Knowledge of U.S. GAAP and Cash Flow, Government Contracts accounting rules (FAR & DFARS).
• Well around of FASB + IRFs 15 compliance, possess Merger & Acquisition knowledge and Due Diligence engagements skillsets.
• Experienced with Well around experience of FAR, ITAR, DFAR, and USG regulations. Calculate Business ROI, NPV, and financial models.
• ERP & implementation: ORACLE, OBIEE, JD Edwards E 1, PeopleSoft, Quickbooks, AS400, ADP Payroll, Blackline, Cognos, Great Plains, Hyperion (HFM), MAS 90/200, Mink, NetSuite, SAP, SmartViews, Essbase, ProSystems, Tableau, Workday, Infor Visual, etc.
• Conduct market research to identify potential M&A targets, including compiling and synthesizing comparable transactions.
• Proficient in Microsoft Office Suite: Excel skills (eg. Pivot Tables, Vlookups, HVlookups, XlookUp, Indexmatch, Sumifs, IRR, NPV, CAGR, Macros, etc.), Word, Access, Outlook, PowerPoint, Publisher), Skype, M/S Team, Webex, Zoom, Google Meet. Studying Power BI + SQL.
• Exceptional problem solving and analytical skills, Perform and oversee monthly/quarterly reporting for private equity and real estate funds. Investors’ Financial Management, Procurement and Supply Chain Management & Project Portfolio Management modules.
• Strong in Oracle Financial Statements Consolidation Process & managed multiple Foreign Currency Exchange Rates.
• KPIs and metrics to measure the effectiveness and efficiency of the financial highlight improvement – from sales through closing, and beyond. Education:
• Pursued MBA in Accounting, California State University, Los Angeles, CA
• BS in International Business, CCU=Chinese Culture University; Majored in Accounting, National Taiwan University.
• CPA Exam: Passed, a CPA Candidate. *Registered Tax Preparer: CTEC ID: A229308, IRS: P01408861. EFIN: 308608. CaDRE: 01031516.
<<< Experience & Accomplishment >>>
Consultant, Sr. Cost Analyst, Controller, Interim Costing Manager, Tax Analyst, Financial Analyst, ThermoFisher Scientific, The SeGuin Group, Cole Instruments, Cadence Aerospace, H&R Block, Honeywell International, R.S.M. CA 07/ 2017 ~ 09/2024
* Formulated Various Cost Accounting Analysis, Daily O/T Labor Costs analysis, Absorption & Efficiency Updates, Month & Quarter-End-Closings, * various Variance Analysis, RM/WIP/HW/MOH/FG Accounts Reconciliation, Standard Costing Cost-Roll Simulation, and Costing Re-Rolls, Cycle-Count-Inventory Accrual, Monthly MRB Inventory Adjustments, monthly Sales & Gross Profit Analysis, Ad Hoc Projects. * Designed & Implemented various Expense Reports. * Built Cost models for various products/components/services * Detailed Cost Analysis on financial results (trends, performance metrics, benchmarks), and KPI developments, and ADP Payroll processes. * Analyze all of New Sales Orders from Wireless Clients. SOX compliance & Filings. ASC 606 Implementation. * PORs (Purchase Orders Requests) Process and Sales Invoicing, and Internal Audit system. * Maintain and ensure the integrity of financial data in HFM, CMR, and the Data mart Analysis. * Allocated to the appropriate projects for accurate Sales Revenue tracking systems, and streamlined the process. *Enhanced Operational financial modeling, Cash flow management, Analyzed Project Revenue & Trending Analysis, Budgeted & Actual Analysis / Comparison, and other analytics requests. • Strong experience creating cost accounting standards and reporting for government contracts. • Experience developing and delivering financial briefings, documentation, reports and financial advice to Senior Management, personnel, and other external organizations. * Enhanced Operational Productivity OEF Estimates, Monthly AMR Profit & Loss Pulse Analysis, Production Project Pipeline healthy checks. * Month-End Closes, Financial Statements Consolidation, MOR Productivity Tool, Indirect Spending Reconciliation, and Comments. *Production Sites support, Freight Logistic data reconciliation / Validation, IOS Calculation & reporting, Inventory Valuation & Cycle-Count Audits, and SAP migration backfill. * DOS, EHS, DLE Traction, HFM & Essbase, Ad Hoc Analysis & Reports, and research Variances. Monitor and manage data related to revenue, weekly bookings, backlog, standard costs, and GLA (General Ledger Accounting) in Data mart. * Assist with historical information, investigating, and underwriting potential real estate investment opportunities, performing due diligence activities, interacting with lenders & investment partners, and facilitating purchase transactions. * Prepared SOP for a large production site @ Frederick DC.
• Support cross functional teams in executing M&A transactions. * Improve operational effectiveness and scalability through M&A deals.
• Analyze financial data, statements, and trends and conducts due diligence to inform strategic decision-making for individuals, institutional investors, and private companies and manages investment portfolios. In compliance with FAR (Federal Acquisition Regulation) guidelines. Senior Accounting Advisor, Sr. Financial Analyst. Dell Software, FloorX Inc. Lake Forest 01 / 2016 – 04 / 2017
• Built a Sales Contract & Revenue Model Analysis, Rebuilt / Reconstructed for all of Years 2015 & 2016 -- 2 years’ Sales Revenues and Tracking analysis, Profit & Loss via many different venues, for CPA’s Tax Returns’ filings. Prepared Audit Schedules for IRS, KPMG + PWC + CPA firms. Built a Sales Contract & Revenue Models, & Resolved previous years’ Payroll Tax Returns Lien pending issues.
• Analyzed Monthly and Quarterly financial results & Profitability, Regional and Global Flux Analysis, to identify trends and explain variances between actual and budgeted results. Trend analysis of Lab Cost, or movements. Performed extensive Global Consolidation, Reconciliation, & Consolidated Financial Reports. Consolidated details Global Fixed Assets accounts Roll-Forwards, & Depreciation reconciliation.
• Coordinated with worldwide Regional Controllers / Managers for financial Flux Analytics & Trends Analysis process.
• Experienced with SOP, IFRS Compliance reports, Software Revenue Recognition, and Ad-Hoc reports.
• Conduct market research to identify potential M&A targets, including compiling and synthesizing comparable transactions.
• Support cross functional teams in executine M&A transactions. Improve operational effectiveness and scalability through M&A deals.
• Assisted in CFR (Executive financial reporting package) & Mapping Models, SOX compliance & Filings.
• Designed & Implemented various Expense Reports, Accruals & Reviews, Foreign Exchange Rates input, Dashboard Maintenance, Conduct regular tie-outs and reconciliations across financial systems to ensure data consistency; Data Integrity and Issue Resolution.
• Prepared various G/L Analytics, and updated the financial system for various departments / entities.
• Implemented ASC606 Contract Revenue recognition, Prepared Hedging Impact Analysis exposure, gain & loss query, analyzed more than 72 subsidiary companies, reporting to Treasury Manager, Ensured Month-End & Quarter-End Closes completeness.
• DSO (Sales Order / Day) and A/R Bookings Detailed Analysis, analyzed Quarterly Deferred revenues, and the related COGS for in-transit shipments to customers, in collaboration with EMEA, & APAC 4 Analytics trend. Taking lead in identifying and resolving data gaps and discrepancies across all financial systems. Analyze financial data, statements, and trends and conducts due diligence to inform strategic decision-making for individuals, institutional investors, and private companies and manages investment portfolios. * Assessed market conditions, including a company’s financial performance, and prepares forecasts and reports that enable clients informed financial choices. Controller / Senior Cost Accountant AG Electronics & ITT Corporation, Santa Ana, CA 10 / 2014 – 12 / 2015
• Responsible for Financial Planning and Analysis (FP&A) and supporting our short and long-term financial strategy by leading annual budget,
• Periodic forecast processes, developing and generating financial management reporting, analyzing financial trends, calculating the financial effect of potential business decisions, Profitability analysis programs, and advising business leaders of their impact.,
• Prepared and consolidated monthly & annual financial statements for 2 entities (including elimination entries).
• Designed & Implemented Corporate Forecast / Budget, various CAPEX & OPEX Reports, Accruals & Reviews, plus Cash-Flow management.
• data to effectively produced financial reports and Financial Statements Consolidation, managed E-Commerce.
• Validated ASC605,606 Revenues, Inventory & Overhead variance analysis, and built up Budget systems.
• Assisted the Cost Accounting Manager with the monthly close process and a variety of accounting functions.
• Performed extensive analysis of plant accounting financial data and complex reconciliations: profit margin review, backlog margin review, inventory/stock review, BOM, CIP, COGS, WIP & ER Inventory review & Variance Analysis reports.
• Coordinated with supply chain management to ensure compliance and documentation on the Bill of Materials. Financial Project Manager r XIN Irvine, LLC. (Xin Yuan Development, Inc.) Irvine, CA 08 / 2011 - 09 / 2014
• Real Estate investment portfolio consulting & financing arrangements for a land developer, collaborated with Builders / Investors.
• Prepared, and presented Cash Flows and Operations Impact, Sales Revenue Forecast & Actual analysis for comparison.
• Experienced Construction & Real Estate new Construction & Property Management Accounting online software program.
• Worked with investor relations on ad-hoc requests from investors. IRR (Internal Rate of Return) on Investment analysis.
• Responsible for Project Management & Investment schedules, performance measurement, schedule of individual partners' capital and an understanding of fund and joint venture partnerships. Provided detailed, accurate analysis of Contract terms and conditions.
• Functional utilized real estate industry knowledge and an investor focused mindset to meet the needs of high profile investors.
• Assisted the Managing Director with underwriting, entitlements, functional ASC 606 reports, and the marketing campaigns.
• New development business, market research, site acquisition, due diligence, managing the design process, financing, and zoning.
• Assisted with each client’s credit report, obtain proof of funds, and Mortgage Operational & application process.
• Assisted the Escrow Trust Fund Accounting management, and sub-Contractors Bids & Placement, and Cost Estimates. Finance Manager & Tax Accountant t The SeGuin Group, Quest Mortgage R.S.M., CA 02 / 2009 - 07 / 2011
• Prepared Individual Income Tax Returns for High Net-worth individuals, S Corp, LLC, & C Corp.
• Daily Cash Management, Monthly Banks and Balance Sheet Reconciliation, Payroll processing & wage garnishments.
• Prepared Audit schedules, G/L Reconciliation, performed deep dive sub-ledger systems to obtain granular-level actual data set analytics.
• Coordinated and mentored on facilitating process design, help determine Strategic Goals, and strategic transformation initiatives.
• Tax Compliance, plan and conduct examinations, and related investigations of individual and business taxpayers.
• Designed & Implemented various Expense Reports, Accruals & Reviews, plus Cash-Flow management, A/R, A/P, financial analysis.
• Experienced Construction & Real Estate Accounting softwares. • Working on Tax Prep & Review for real estate clients.
• Prepared Fiduciary, Partnership, Corporate, Payroll, & Individual Income Tax Returns, Tax Compliance & Research.
• Fund Analyst, Sr. Cost Analyst, Internal Auditor, Accounting Manager Various Corporations, 01 / 2002 – 12 / 2008
• Assistant to Corporate Controller, prepared monthly Journal Entries, posted on custom-built web-based system (Vilden). A/P reviews and approvals. Financial Statements Consolidation, Sales Revenue Analysis, BOMs, structures and routings, A/R monthly reconciliation, and Audit schedules.
• Generated Detailed Sales Revenue utilizing the estimates, Pricing Proposal Models, SOX compliance & Filings, Reconciled all Intercompany transactions, and Balance-sheet general ledger accounts monthly, and quarterly, incorporated financial objectives, in fully compliant.
• Provided fluctuation analysis explanations for various components of worldwide gross margins for both domestic operations and foreign subsidiaries. Performed risk analysis utilizing company risk analysis tool, + frequent RMA transactions / reporting. experience in CAS interpretation and application. Comprehensive knowledge and expertise in performing financial functions, including the use of Cost Accounting Standards (CAS), and Set-up/maintenance of stock codes,
• Designed & Implemented various Expense Reports, Accruals & Reviews, plus Cash-Flow management, A/R, A/P, financial analysis, KPI, and Month-End Closing. * Developed Sales Revenue, Pricing Proposal Models, and Profitability Strategy. Reconciled all Sales transactions, Deferred Revenue, all related accounts monthly, and quarterly, incorporated with financial objectives & process improvements.
• Managed a winning Pricing Proposal that incorporates financial objectives fully compliant with company’s policies & procedures.
• Coordinated Mutual Fund analytics, and preparing various analyses for the Monthly Finance Presentations along with Quarterly Board Reviews.
• Worked for Pre-Verizon, PIMCO Newport Beach, & KIA Motor America, C.C.I./ I.M.I. & Pioneer Circuits, Inc., USL US Lines., etc…