Senior Financial Analyst Project Manager

John Walker

** ****** ***** **. ********** FL ***44 (Tallahassee Area)

********@*****.***

https://www.linkedin.com/pub/john-walker/65/425/b93https://www.linkedin.com/pub/john-walker/65/425/b93

Cell- 850-***-****

Home- 850-***-****

EXPERIENCE

Government Analyst Florida Department of Health Dec. 2016 – Present

The Division of Medical Quality Assurance (MQA) serves an essential role in Florida’s healthcare process, working closely with the boards and councils in licensing, regulating, and providing information about the one million healthcare professionals and facilities licensed in the state of Florida.

●Responsible for executive reporting for the Bureau of Operations in the Medical Quality Assurance division of the Florida Department of Health.

●Budget preparation and analysis for the Strategic Planning Services Unit.

●Expense processing and reconciliation for the Strategic Planning Services Unit.

Project Manager Government Services Group Feb. 2016 – Sep. 2016

Established in 1996, Government Services Group, Inc. (GSG), is a Florida based consulting firm specializing in local, state and federal government storm water, water & wastewater, grants management, community development, fire services, revenue enhancement, and program administration

.

●Calculated rates, prepared presentations and conducted meetings with local governments across the state of Florida for Special Assessment and other alternative financing programs.

●Created complex financial models for multiple projects.

●Interacted with key state holders including city managers, county commissioners and real estate developers.

Senior Financial Analyst Verizon Oct. 2006 – Nov. 2014

A subsidiary of Verizon Communications Inc., Verizon Wireline is engaged in delivering broadband and wireline communications services to consumer, business, government and wholesale customers. Wireline's communications products and services include voice, Internet access, broadband video and data, internet protocol network services, network access, long distance, and other services.

●Served as Project Management liaison for the Revenue Accounting organization attending project meetings for new marketing initiatives to determine impacts.

●Drafted and submitted business requirements for projects impacting Revenue Accounting.

●Performed User Acceptance (UAT) and Production Parallel testing for new marketing products and other projects such as billing system migrations and development projects for Verizon’s revenue accounting close engine (RACE), SAP, Verizon’s revenue location code manager applications (RLM/LCM) and Verizon’s product mapping applications (GPR/FINTRAN).

●Facilitated the processing of SAP master data additions and updates.

●Played a central role in the month-end close cycle as a member of the Revenue Segmentation group ensuring that all Revenue Location Code data was properly locked down.

●Worked with the Billing Quality Assurance group to reconcile revenue impacting Location Codes and provided a monthly report to senior management.

●Performed monthly Billing to Accounts Receivable reconciliation for multiple billing systems that passed all Sarbanes Oxley certification tests by external auditors.

●Assisted with daily product mapping at the surrogate key level using web based and SQL queries ensuring that new products were booked correctly to the ledger during the close process and that commissions were directed properly

●Provided various ad hoc reporting and analysis of revenue, product mapping, telecom traffic, circuit, and location code data.

Selected Accomplishments

●Assisted management in working with Marketing, Revenue Accounting, SAP and RACE development organizations in the development and testing of a new financing model that allowed for the leasing of equipment to customers by Verizon Business.

●Participated in the testing and successful migration of several legacy billing systems.

●Participated in the testing and successful migration of the revenue location code manager applications from an oracle based to a web based platform.

Financial Analyst Siemens One (Under Contract with H&H Staffing) Jun. 2006 – Oct. 2006

A wholly-owned subsidiary of Siemens Corporation Siemens One is the sales and marketing organization that enables customers to realize the potential of integrating Siemens' products, services and solutions.

●Responsible for managing the company's inter-company billing process.

●Coordinated the preparation, compilation and distribution of monthly executive financial report package.

●Performed accounting analyses, including researching transactions, performing required account reconciliations and other financial analysis requested by corporate controller.

●Played a central role in the month-end financial close cycle, including the preparation of complex journal entries, analytical account reviews, interaction with remote accounting support staff and adherence to demanding monthly close calendar.

●Responsible for the supervision of an accounting intern.

Selected Accomplishments

●Helped streamline the accounts payable process significantly reducing the review and approval cycle for vendor payments.

●Developed sophisticated Excel-based rollup models that the company relied on to ensure their budgeting process was completed in a timely manner with a clear trail of assumptions for each department and organization.

Project Manager MariTEL USA (Independent Contractor) Nov. 2005 -Mar. 2006

A privately held company providing marine communications services and, through the Spectrum Development Group, facilitates private marine and land based VHF network solutions for government entities, utilities, and the private sector. MariTEL's major stakeholders include American Tower (NYSE: AMT), Northwood Ventures, Wqfra Partners and MCT Ventures.

●Ran coverage area studies using the EDX application that were used in the site selection process.

●Managed the tower activation process including the scheduling, ordering and installation of utilities.

Selected Accomplishments

●Designed and created a form driven Microsoft Access database used both as a tool in the network rollout project and for ongoing asset management

●Successfully assisted senior management with meeting FCC deadlines in the rollout of a nationwide wireless network.

Dec. 1992 - Apr. 2005 The experience below was all with the same company as BellSouth Cellular merged into Cingular Wireless and AT&T.

Marketing Support Manager Cingular Wireless Apr. 2002 -Apr. 2005 Founded as a merger of BellSouth and SBC Wireless Operations in 2001. Cingular was the largest wireless company in the United States with more than 57 million subscribers.

●Coordinated and prepared monthly sales and financial package using Hyperion Essbase, Business Objects and Oracle continually streamlining the process through automation.

●Prepared annual budgets and monthly sales and revenue forecasts for the National Promotions Marketing organization.

●Updated and distributed Marketing's Device Roadmap and was subject matter source for handset feature data posted on the company's sales portal website.

●Drafted launch announcement documents for new handsets and devices and created feature/price cards used in retail stores nationwide

.

Selected Accomplishments:

●Worked with Business Objects staff in designing the standard canned reports for handset and accessory sales tracking.

●Created an access database and monitoring process which significantly reduced fraud in the company’s rebate program.

●Developed a competitive analysis that became a monthly report used as a resource by executives in setting handset pricing.

●Created all handset and accessory ad hoc promotion tracking reports for the National Promotions organization.

Product Manager/Analyst BellSouth Cellular I Cingular Wireless Nov. 2000 - Apr. 2002

BellSouth Cellular Corp. companies, BellSouth Mobility and American Cellular Communications Corporation provided wireless communications services to more than five million customers in 13 states.

●Produced monthly executive report package on accessory sales and revenue.

●Prepared business cases models used to gain approval for accessory sales promotions.

●Produced reports for the weekly tracking and post mortem analysis of accessory promotions.

Selected Accomplishments:

●Developed a database used during the Cingular Wireless merger that integrated sales data from BellSouth and SBC inventory systems which allowed for standardized and consolidated reporting.

●Served as the Supply Chain organization’s liaison to Accenture consulting staff contributing to a successful system conversion from JD Edwards to I2 and Business Objects.

●Developed a forecast model used by the Supply Chain organization for managing days of inventory and demand planning.

Financial Analyst BellSouth Cellular Oct.1997 - Nov. 2000

BellSouth Cellular Corp. companies, BellSouth Mobility and American Cellular Communications Corporation provided wireless communications services to more than five million customers in 13 states.

●Created and published a comprehensive monthly sales and financial report package that included actual versus budget, flow share, trending and variance analysis.

●Prepared and submitted annual field budgets for over 200 business units in the Georgia region.

●Played a central role in the month-end financial close cycle, including the preparation of complex journal entries and analytical account reviews.

Selected Accomplishments:

●Automated the updating of the region's Microsoft Excel forecast model and the monthly financial report package with actuals using excel macros.

●Coordinated with IT department the development of a Microsoft Access database solution that cut in half the time devoted to the bottoms up field budgeting process.

Business Operations Analyst BellSouth Cellular Mar.1995 - Oct 1997 BellSouth Cellular Corp. companies, BellSouth Mobility and American Cellular Communications Corporation provided wireless communications services to more than five million customers in 13 states.

●Prepared and submitted annual field budgets for over 50 business units.

●Published monthly financial report package with variance analysis.

●Played a central role in the month-end financial close cycle, including the preparation of complex journal entries and analytical account reviews.

Selected Accomplishments:

●Developed guidelines for and conducted audits of company owned retail stores resulting in significant improvement in days of inventory and the reconciliation of bank deposits.

● Played a key role in ensuring a successful Internal Audit by conducting pre-audits for all departments according to the company's internal control checklist

Direct Sales Representative BellSouth Cellular Dec.1992-Mar.1995

BellSouth Cellular Corp. companies, BellSouth Mobility and American Cellular Communications Corporation provided wireless communications services to more than five million customers in 13 states.

●Responsible for acquiring new subscribers within an assigned territory primarily through cold calling on small businesses.

Selected Accomplishments

●Consistently exceeded quota with average monthly attainment of 165%.

●Awarded Top Producing Sales Representative for the Georgia region 1993.

EDUCATION

Georgia State University, Atlanta, Georgia 1992

Bachelor of Science in Aviation Administration - Urban Studies

Contact this candidate