Andy Ng Email & Phone Number

Texas, United States

Remote

Monthly Close - Prepared journal entries to adjust financial and operational activitiesVerified and reconciled ledger and balance sheet activityValidate all bank activities and reconciled all cash activitiesDeveloped hourly burn reporting for business and brand management teams

Remote

Financial Reporting - Gather data from salesforce and internal data warehouse to produce footnote disclosures for 10Q and 10K purposes.Manage large datasets using Power BI to produce an executive dashboard showing multiple KPI's for different time periodsReview significant contracts over $250K to ensure proper set up in Salesforce and revenue recognition

Monthly Close - Review all contracts to ensure proper set up in SAP for revenue recognition in accordance with ASC 606Reconcile GL accounts such as pre-billed, earned but unbilled, deferred revenue and miscellaneous credit liabilities to capture the current months activities. Any leftover balances are reviewed with client teams to take actionCollaborate.

Greater New York City Area

Financial -Work with the merchandising team to achieve company goals by providing financial support and guidanceGather forecasted/actual numbers from merchandising on inventory and markdowns to provide financial insight and how it will affect the companies bottom line for given departmentsPrepare a rolling operating forecast on a monthly basis using.

New York

Monthly Close -Prepare journal entries for financial close and submit into TM1Provide variance analysis for monthly activity versus budget and estimate, provide detailed explanationsCollaborate with sales team to manage expenses and provide actions to stay within budget/estimatesForecasting/Budgeting - Work with the head of sales for Structured Finance to.

Greater New York City Area

Greater New York City Area

Duties - Prepare a pricing parity report showing the difference between COM pricing and stores pricing; work with merchandising team to resolve issues between pricingSupport merchandising team by reviewing the submitted markdowns and it's potential effect on financialsReview price changes to ensure they are in compliance with company and legal.

Duties - Produce sales recaps for each of the merchandising groups showing top and bottom sellersForecast future sales based on historical trends and future economic conditionsReport sales by location showing managing a large subset of data using ExcelPlan and prepare a comprehensive report of gross margin by location using actual data and estimates.

Duties - Pull markdown information submitted by merchandising to validate for proper submission and submit for process approvalPrepare reporting for top and bottom sellers by general merchandising groupSupport transition to a new markdown system by testing and providing feedback