Leveraged my technical skillset to create and implement process improvements by creating customized databases to be used for customer account reconciliation, internal contract tracking, monthly G/L accruals and data input. Loaded monthly files received from various IT/database sources into front-end applications. Utilized SQL, TOAD, MS Access, Power BI and Excel to provide ad hoc data analysis for multiple business units including Finance, Sales, IT and Marketing.

Lead team of analysts in providing complete bill audits for large business customers by recreating the billing process utilizing multiple data sources loaded into custom-built databases. Logged audit issues and worked with Sales and IT to drive issue resolution. Liaison with Sales, Marketing, Accounting and IT on cross-functional projects to correct and improve the customer billing experience. Recruiting, training, development, setting objectives, performance reviews and work prioritization for the team. Researched and resolved customer billing escalations.

Lead department providing Billing and A/R support of the National Retail Prepaid Channel. Calculated and posted monthly revenue reserves for accrual. Ensured policies were SOX compliant. Maintained contractual compliance for customer base. Reconciled A/R trade account monthly, reduced account balance by $21M. Established credit limits by reviewing audited financial statements, credit agency reports and industry resources.

Supported B2B Wireless by creating monthly consolidated invoices. Staffed department after the creation of a new group. Transitioned 15 markets onto a new billing system. maintained and enhanced audit controls to ensure invoice accuracy, timeliness, and completeness.

Forecasted expected equipment purchases on a monthly basis. Worked with the factory to ensure proper inventory levels. Produced monthly presentation for executive management identifying potential risks and opportunities. Tracked order fulfillment rates and analysis for product lines MOM and YOY>

Reviewed product pricing and compared pricing range in various businesses in similar segments. Provided Gross and Net margin analysis for each bid, including any proposed product credits, lab equipment or any additional margin impacting items. Calculated ROI and EBT of each bid. Co-ordinated bid review meeting with Sales Primes, Finance and Marketing Directors to discuss the merits of bid and strategy for winning the business.

Prime for Revenue and COS P&L accounts including research, resolution, reconciliation, maintenance, variance analysis, GAAP and Nortel internal accounting compliance.Prime for contract compliance entailing identification of Risk of Loss, Warehousing, Product Credits, Training, Special Payment Terms and any non-standard terminology resulting in Balance Sheet provisioning. Finance Prime for Government Reporting, including original set-up on all Nortel systems, project reporting, consortium reporting and all P&L and B/S activity.Reconciliation of Foreign Currency (F/X) and Inter-company (I/C) balance sheet for business unit.Responsible for Product Line Profitability for the Optical Networking U.S. Business Units.Participated in month-end and year-end close involving Revenue and COS assurance, Balance Sheet usage and provisioning, preparation of U.S. P/L for Carrier Packet Networks.

Prepared Regional 5-year fiscal budgets Provided quarterly and monthly product margin analysis MOM and YOY closing including general ledger entries, preparation of monthly and fiscal year-end reconciliations.Assisted in fiscal year-end audit and preparation of audit package.Specialized in $90 million of inventory accounts involving tracking of inventory balances by location and product mix. Finance liaison with the MIS department involving new finance reporting tools and applications.