Summary OF QUALIFICATIONS

Superior communication presentation analytical and problem solving skills. Work well with all levels of business. Microsoft Office Suite. AS400. Lotus Notes Xelus -Planning Forecast Software Oracle Discoverer Report Creation/Query EssBase SQL Hummingbird TOPS ASO Wachovia JURIS Banking Agile- Planning/Forecasting

• Marketing
• Forecasting
• Performance tracking and evaluation
• Detail Oriented
• Root Cause Analysis
• General Ledger experience
• Financial Statement background
• LEAN
• Marketing Analysis
• Sarbanes-Oxley

Professional Experience

Confidential

Quality Data Reporting Analyst

• Assigned to analyzing multiple files and then consolidating these files into 10 technical file groups. Engaged in changing the process so that the Essential Requirements Checklist is satisfied. Responsible for generating report queries for the purpose of identifying data variances to ensure FDA compliance. Compared exported data to unedited data in order to troubleshoot and resolve discrepancies. Also produced and analyzed ad-hoc reports as part of a systems development team. Took data from source documents and converted them into given formats to be used as inputs for Agile-the Inventory System.
• Planned organized and implemented strategies and activities required to procure regulatory approval for new and revised product lines. Ensured and established compliance for requirements corporate policies and procedures regarding the submission for market approval of medical device products.
• Prepared weekly and monthly reports for the spinal division. Searched and imported stored data to spreadsheets manipulated and distributed data to team members using Microsoft Office Applications. Combined data from multiple data sources into multiple spreadsheets. Used analyzed and presented finalized data. Performed business analysis using critical thinking skills to correlate data.
• Completed evaluation and audit activities. Finalized the completion of Tech files and assisted the regulatory team in closing 41 of the teams overall assignment. Successfully completed the managerial assignments and resolved 15 of the files assigned to my team.

Confidential

Business Administrator/Analyst

• Managed the technical architecture of the current systems and accessed the organization s needs while guiding the infrastructure design.
• Lead in the development of Information Technology s strategic planning while also reviewing analyzing and recommending hardware software and network resources for the Club.
• Developed solutions for the current concerns of Director. Defined analyzed and documented the current requirements. Assisted Director as requested with the completion of monthly projections and annual budget.
• Played a major role in developing and implementing compliance policies procedures and best practices for Boy s and Girl s clubs and the YMCA. Executed internal audits of payroll account reconciliations and assisted in transfer to a new payroll and benefits system. Utilized if statements pivot tables vlook-up macros and other advanced tools to evaluate the efficiency of inventory/stock items for the club.

Confidential

Material Planner Data Analyst

• Had successful experience with eliciting analyzing and documenting the requirements for business processes policies and information systems with a LEAN Sarbanes-Oxley emphasis.
• Created MRP report and loaded into system according to customer firm order FCST. Accessed capacity and materials constraints with LEAN training and techniques. Audited loading process. Managed supply in order to avoid stock outs and obsolescence. Provided analytical support for the material functions and operations.
• Lead capacity and materials review with PM production and material team. Did troubleshooting of critical parts. Developed weekly reports utilizing Microsoft Excel and Access which included the Top 250 Cautionary MRP Run Xelus Forecast Accuracy Planning Chains Master Code file Vendor Pricing variance Selection Code Evaluation and Planning Tool reports all of which entailed data for Planning staff Engineering Doc Control and Production floor. Worked effectively with multiple team members in diverse roles to analyze planning systems
• Responsible for building out spreadsheets that analyzed material constraints Xelus analyses breakdowns and manual flowcharts in Microsoft Excel for Engineering Accounting and Executive Lead Departments.
• Lead in overseeing pricing database of over 90 000 part numbers made price adjustments fixed incorrect data and exported data to different databases. Implemented pricing uploads analysis and troubleshooting. Managed and controlled MRP and all data analysis tools Xelus/BAAN . Work in BAAN V AS400 and Xelus to implement forecasting responsibilities . Reviewed and updated forecasting methods on a weekly basis. ABC analysis cycle counts. Responsible to fully managing assigned parts. Monitored all inventory transactions to insure accurate flow. Managed forecast purchase plans actual demand and inventory.
• Set and maintained inventory parameters to allow forecasts to be accurately translated into MRP schedules. Investigated all inventory discrepancies for assigned parts / programs.

Confidential

Financial Systems Data Analyst Hunter Fan/Thomas Betts

• Created and edited complex formulas advanced data analysis and importation of data from external databases. Develop MACROS and implemented
• Uncovered opportunities to acquire market share from major competitors by analyzing consumer sentiment data and competitor sales data. Identified new data sources and remedied data quality issues that boosted campaign effectiveness by 10 percent. Performed statistical and mathematical calculations. Editing and proofing documents. Assisting with the implementation and execution of a major pricing improvement project.
• Performed advanced mathematical and statistical calculations as well as advanced data analysis and graphing. Writing advanced Microsoft Excel formulas using IF statements and VLookups. Creating pivot tables.
• Provided various reports using data sources such as reporting applications data warehouse dispensing systems and the purchasing systems.
• Validated reports and performed quality checks for data files prior to submission. Recommends solutions initiates corrective action and provides follow up as needed.

Confidential

Escrow Analyst

• Compiled analyzed and prepared all financial information for proper general ledger accounts and sub-systems entries using Microsoft Excel. Verified postings of transactions to the general ledger system including transactions from other systems. Assisted management in preparing for annual external auditors.
• Reconciled accounts and performed ledger entries for 40 assigned Fortune 500 accounts.
• Also led project to purge and updated site which led to improvements of ledger entries for assigned accounts. Lead analysis of Hunter Fan Home Depot and FedEx. Was assigned to a special project team to lead in resolving million dollar variances. Implemented root cause analysis research to better isolate and resolve issues ranging in value from 543.00 to 785K. Overall there was a net savings of more than 195K.
• Worked with Executive management to resolve escrow variances that were more than 10 years in the rears. Was responsible for resolving variances which included refund recovery voids stop cancellations issues and more. As a result of this researched I was able to recover an average of 1 085 per file which was a 7 increase in solution efficiency.
• Because of my leadership on one of my financial assignments/project I was able to help resolve variance discrepancies for more than 10 accounts requiring research. I also participated in archiving the important information and successfully resolved problem accounts and successfully identified differences totaling 1 040 000.

Confidential

Financial Documentation Lead

• Prepared financial reports for internal and external use including the Comprehensive Annual Financial Report and Single Audit Report . Made adjusting and closing entries and audits prepared by businesses. Accessed journal entries for accuracy and sufficiency of funds.
• Worked with actual and budget transactions via an accounting system Excel Access Peachtree and provides financial information and reports. Reconciled the general ledger account balances and records.
• Reviewed data regarding material assets net worth
• liabilities income and expenditures.
• Reviewed items in books of original entry to determine if accepted accounting procedure was followed in recording transactions. Verified journal and ledger entries of cash and check payments purchases expenses and trial balances.

Confidential

Material Planner/Analyst

Confidential

Cummins Research Task Management

• Played a key role in redesigning the company s product offerings in response to a quickly changing market by researching the market extensively and developing comprehensive customer profiles and ETL processes. The profiles allowed management to more easily identify their target market and help to expand the business and expand their market an additional 2 . Supported new and existing applications through analysis.
• Devised strategic methodologies to collect new data. Designed processes to effectively obtain existing data. Implementation of SOX internal controls. Worked with Cummins Sarbanes-Oxley auditors.
• Managed Government contracts and accounts. Issued pricing and lead-time quotes to government. Analyzed data from 50 to 10 000 lines in scope. Used analytical skills to complete A/R research and process evaluation of 5.4 million in receivables which lead to reduction of 4.3 million in receivables. Successfully of lead project while meeting with Government officials to include Admirals Generals and Sergeants about contract.
• Designed and developed a Performance Cell in Microsoft Excel that would evaluate measured and reflected current trends within the Marketing Department which consisted of more than 70 Accounts. This spreadsheet was linked to 15 worksheets within the file and auto populated the data to the main worksheet. Function included V-Lookups Pivot Table/Chart creations Formula Creation Use of if statements conditional formatting and more which cause an improvement to how data was reported in departmental meetings and increased efficiency of report presentations to department executives.