Sharon Chen Email & Phone Number

New York, United States

New York, New York, United States

Gb

Technologies: Python, Apache Airflow, GraphQL, Hasura, Datadog, Azure DevOps, Git.

Philadelphia, Pa, Us

Technologies: Python, C, HTML, JavaScript, SQL.Teaching Assistant:• Supported CIS 5210 Artificial Intelligence and CIS 5510 Computer & Network Security.• Hosted private office hours to answer student questions on coding homework/projects and course contents.• Monitored and responded to student questions in the communications forum, and ensured questions were answered within 24 hours.• Graded student work according to an established rubric and provided constructive feedback.Academic Coach: • Mentored and tutored new students. • Hosted information sessions with fellow coaches on topics important to student success.

Gb

Technologies: Angular, Typescript, C#, .NET, Git, Azure DevOps.

New York, Ny, Us

New York, Ny, Us

Jersey City, Nj, Us

• Monitored P&L for 8 cost centers to identify abnormal entries and fix them in time with accounting team during close.• Analyzed prior period actual expenses and headcounts to conduct re-forecast and budget of EBITA expense for 8 cost centers for adjustment and approval by product Vice Presidents.• Built P&L dashboards in Excel for overall commercial line, containing 40 cost centers with the view of actual vs forecast by MoM, QoQ, and YoY comparison, and updated daily during month close.• Provided financial analysis of revenue by customer for 22 revenue accounts for product managers’ review for trends or potential missing revenue; work with billing team to sort out discrepancies.• Investigated and explained key drivers of material variance of revenue during monthly close for corporate finance team’s review.• Prepared 3 monthly P&L Deck PowerPoint to demonstrate P&L results including comparison to Prior Year, Reforecast, and Budget and explain key drivers of these variance, and then presented to product Vice Presidents.• Reviewed contracts and prepared invoice information on customer billing for a product; reviewed subscription and transaction billing to ensure compliance with revenue recognition standards (ASC 606). • Created and maintained a database of contract pricing rules by combining prior month transaction billing reports and contract information for monthly transaction billing review, which has shortened 2 hours compared to prior process.• Assisted in implementation of new process with IT and product teams for improving transaction billing accuracy by providing insights in the billing process and contracts.

Jersey City, Nj, Us

• Performed timely completion of monthly closing process by recording journal entries for 4 foreign entities, including bank activities, accrued expenses, payroll, fixed asset depreciation, and prepaid amortization. Prepared reconciliation and analysis after the close.• Booked general journal entries for local and foreign currencies wire payments and internally developed software projects after analyzing time and labor. Recorded intercompany cash transfer and intercompany eliminations accordingly. • Generated daily cash report to summarize prior day collections and operating expenses and today’s forecast cash inflow and outflow. Discussed with manager and updated monthly cash forecast for future cash activities.• Managed around 20 long-term and short-term escrow assets and liabilities accounts; monitored and recorded escrow release; reconciled and prepared quarterly escrow roll forward schedule in Excel. • Ran queries for 10 expense and balance sheet accounts in Oracle PeopleSoft and utilized Excel to analyze month over month fluctuation by base currency of each business unit. • Analyzed and reviewed monthly fluctuation on Internally Developed Software projects. Then communicated with project managers in each business unit for commentary on material fluctuations. • Completed Canadian (FY2017) and Singapore (FY15-17) statutory audits within 1 year by investigating GL accounts to respond to auditor’s inquiries on trial balances, presenting to auditor the support for foreign currency revaluation, and reviewing draft Financial Statements before management signoff.• Reconciled 70 local and foreign currency bank accounts monthly using Excel, investigated discrepancies, and communicated with A/R, A/P, payroll, and tax teams to resolve discrepancies within 1 month.• Assisted with SEC (10-Q / 10-K) filing tie-out and recalculation for various sections.• Assisted in providing supports for internal and external audit on expense and balance sheet accounts.

• Compiled UPK program expenditure reports for School Year 2015-2016 in Excel using QuickBooks data.• Assisted in preparing UPK program budget for School Year 2016-2017 based on prior budget and expenditure report.• Performed bank and Business Credit Card reconciliations in QuickBooks monthly. • Reviewed unpaid invoices and generate checks for A/P in QuickBooks. Posted AR collection in QuickBooks.• Calculated total hours according to employees’ timesheet for approximately 50 employees. Prepared journal entries to record payroll and payroll tax monthly.• Recovered $20,000 by discovering unpaid tuition for one student after auditing ACS payment.

Arlington, Virginia, Us

Master'S Degree, Computer And Information Technology (Mcit)

Bachelor’S Degree, Public Accounting And Business, Management, And Finance

Study Abroad