SUMMARY:

• To obtain a position within the organization and implement the skills and experience that I have acquired.

TECHNICAL SKILLS:

• Advanced skills in Microsoft Access
• Excel
• Explorer
• Oracle and SAP. Proficient in BW/BI
• PeopleSoft
• DESKI
• Essbase/Hyperion
• Crystal
• Microsoft Outlook
• Power Point
• Monarch
• Focus
• J.D. Edwards
• CICS
• RKEM
• Lotus Notes
• FRX
• Epicore
• FDM
• HFM
• & SQL and SharePoint.

PROFESSIONAL EXPERIENCE:

Business Process Analyst

Confidential,Charlotte, N.C

Responsibilities:

• Owns functional operation, maintenance and enhancement of reporting systems and tools.
• Manages and delivers existing and new analytical tools and reports.
• Serves as SME and super user for assigned systems/tools.
• Develops training sessions, demos and documentation to enable accurate and knowledgeable use by other users.
• Manages medium size, cross functional business process improvement projects.
• Facilitates process workshops, provides overall project management, ensures complete and accurate testing, develops and delivers training, develops implementation plans.
• Manages relationships with IT and functional teams to gather, clarify and translate business requirements into technical solutions.
• Drives informed decision making by synthesizing data from multiple sources, analyzing the business relevance to develop and design meaningful and accurate management level reports.

Financial Data Analyst

Confidential, Charlotte, N.C

• Wrote and Utilized VBA to consolidate 30 separate project spreadsheets into 720,000 lines of data within one spreadsheet utilizing functions within Excel to manipulate data and produce reports on a bi - weekly basis.
• Responsible for producing forecasting reports of resource effort, labor, and non-labor based costs that correspond to the Enable project.
• Validation of data accuracy for an IT project consisting of 30 different work streams.
• Ran DESKI queries via BI in order to validate and ensure accuracy of data tables.
• Developed reports in order to interpret data throughout 30 different projects for variance analysis of labor, employee expense, purchases, contract, and other costs classified by O&M and Capital by tower, work stream, activity, and application.
• Communication with project leads to ensure accuracy of data inputs throughout 30 different projects.
• Monthly meetings with 30 different project work stream leads to present and ensure accuracy of data and financials.
• Responsible for producing and detailed analysis of time reporting including discrepancies between cost centers and work streams.
• Coding invoices to ensure that costs are allocated correctly throughout cost centers and individual projects are correctly charged.
• Preparation of journal entries to allocate labor cost throughout cost centers within the project.
• Creation of several Access databases and development of multiple tables and queries to assist in reporting phase metric data for the Enable project.
• Developed reports utilizing VBA language within Excel, including modifying pivot tables based on financial based views and effort based views, adding radio buttons, writing VBA code to unprotect, protect, and adding very hidden tabs within Excel, hiding the VBA code of spreadsheets, hiding macros, or writing other functions requested by management.

Data Analyst

Confidential, Charlotte, N.C

• Prepared monthly closing entries for intercompany, district, suspense, inventory sales and COG sweeps.
• Responsible for booking wage allocations, sales rebate accruals, and booking equity partner income and truing up on a monthly basis.
• Responsible for monitoring airfreight and freight accounts to ensure costs were expensed correctly and posting monthly adjusting entries.
• Subsidiary consolidations and reporting of income.
• Manual allocations of balance sheet accounts across 26 different HFM reporting entities.
• Responsible for the system maintenance within FRX and mapping for 120+ cost centers rolling up into 26 different HFM reporting units.
• Responsible for generating P&L, Trend, and Adhoc reports for 120+ local cost centers.
• Variance analysis of actuals, forecast, and budget.
• Development of OPEX, Sales, and COGS budget for 120+ cost centers from bottom up rolling into 26 different reporting units utilizing formulas and functions within Excel.
• Month end close of the A/R period, balancing outstanding, and rolling the period forward.
• Analyzation of sales data to output reports for sales tax in all states.
• Maintenance, reconciliation, and reporting non-financial data such as HR headcounts within the system.
• Creation of an Access database in order to accurately distribute sales tax cost throughout multiple states based on sales order input.

Project Accountant/Financial Analyst

Confidential, Charlotte, N.C

• Prepare and analyze variance reports such as budget to actuals and prior year to current year and identify key drivers of variances for the Balance Sheet and Cash Flow Statements.
• Support monthly, quarterly, and annual financial close and prepare quarterly presentations.
• Design, develop, and produce sales, accounts receivable, and accounts payable reports utilizing Excel, BW, and SAP.
• Analysis of monthly results versus budget, forecast and prior year, and balance sheet analytics.
• Responsible for entering actual account balances for U.S. entity and forecasting balance sheet accounts.
• Generate transfer price reports and assist with transfer price analysis and support.
• Responsible for completing Working Capital Metrics report for actuals and budget.
• Assist with global inventory reconciliations and account reconciliations.
• Financial Analysis Bridging and other Adhoc reporting upon request.

Legal Accountant

Confidential, Charlotte, N.C

• Booking legal accruals and allocations of accruals throughout different cost centers.
• Responsible for sending wire payments based on legal settlements received from attorneys.
• Quarter end reporting of corporate reserves, litigation expense, and cost center schedules, and communicating these results to upper management as well as the legal department.

Operations Accountant

Confidential, Charlotte, N.C

• Responsible for running various reports via Adhoc Queries, SQL, and Batch Admins within Oracle to download and manipulate data within Excel to produce pivot tables and summary pages in order to measure and monitor revenue, and directing results to different departments within the organization and upper management.
• Trouble shooting and resolving bugs in the VBA code of macros within Excel to change ranges in order to distribute accurate reports in a timely manner.
• Developed operating procedures amounting to 150 pages for approximately 60 weekly reports distributed throughout the organization.
• Monitor and apply Fed and IMT wires to outstanding loans, and following up with lenders when they fail to release funding in a timely manner.
• Confirming accurately to external auditors amounts related to borrowers loan balances including amounts outstanding, principal payments, interest rates, collateral, and guarantors.

Analyst Control and Reporting

Confidential, Charlotte, N.C

• Created, designed, and maintained an Access database to assist with organizational objectives.
• Ran reports within SAP, BW, and Oracle and uploaded data into an Access database via Monarch Pro, and ran a series of update queries to ensure the accuracy of data on a daily basis.
• Created tables, queries, and macros within Access to retrieve and analyze data needed to meet organizational objectives.
• Tracked trends relating to organizational processes based on percentages and use of control charts in order to determine root causes and analyze and improve processes.
• Participant in a team formed to identify processes that needed improvements and map those processes to eliminate waste or add beneficial steps to improve efficiency.
• Trained and managed five teams of colleagues for two years including reviewing files and developing accuracy and production reports and standards.
• Developed standard operating procedures to assist in the off-shoring of different task related to A/R, intercompany transactions, and reporting.
• Responsible for reporting various organizational measures on a weekly basis, including activity ratios, percentages of unbilled sales orders, and organizational trends.
• Designed reports needed for process improvement initiatives within Excel utilizing Functions, Vlookups, pivot tables and charts.
• Downloaded data from SQL server within Excel by editing links and editing connection properties and modifying SQL language to retrieve data for reporting and journal entries purposes.
• Integrate member of a team formed for test validation during data conversion from Oracle to SAP.
• Responsible for various journal entries and reconciliations.
• SAP Super User within the department.
• Assisted upper management in the facilitation of access management for new and existing employees.