Summary of Qualifications

• Highly organized and detail-focused Certified Quality Data Analyst by ASQ with a track record of managing on-time, on-budget projects that deliver substantial business benefits translates technical/analytical results into valuable business insights and recommendations.
• Excellent computer skills proficient with Microsoft Office 2010,Windows 7, Excel, Access, Visio, Microsoft Project Standard 2007, Visual Basic 2005/8, SQL Server 2005/8, SQL Server Analytical Services SSAS , SQL Server Reporting Services SSRS , Crystal Reports XI, Cognos, SAP/Maximo/WES, Oracle 11i, Hyperion/Brio, Deltek/Costpoint, Lawson

Work Summary

Confidential

Network Administrator

• As the Project Accounting Manager, supported the government and commercial billing teams by overseeing accounting systems and ensuring data from various sources Costpoint, RSMS and contractual database were readily available and accurate. Responsibilities included:
• Supervised Billing Team associates
• Accessed government requirements to support EPA billing out of MS Access db RCMS and generated Cognos BI reports with GL data to provide billing backup
• Maintained, reviewed and implemented contractual master data with RCMS database
• Led department training in Costpoint
• Served as a system administrator and BI reports developer for production reports and queries in financial systems including Cognos, Microsoft Access and Excel

Confidential

Client Services Analyst

• Compiled and interpreted utility-related energy data and respective databases. Compiled standard and customized reports on electric, gas, water, sewer and other utility and energy data
• Tracked service type, vendor, location, rate and energy load, including kW and kWh by month or invoice cycle and by fiscal year in order to support regular monthly reporting
• Assisted with financial accrual, variance, and trending analysis reporting
• Used analytical abilities to determine and identify trends in expense and usage data
• Assisted in searching for regulatory issues and rebate programs as part of energy project management
• Facilitated energy trending and benchmarking process for clients
• Located and evaluated sites that are not within the client's standard profile for energy use and/or cost and report these outliers to appropriate client personnel

Confidential

Business Operations Specialist

• Responsible for project setup, administration and closeout in SAP ERP system
• Added change orders, revised and entered billing events
• Provided review outstanding A/R, performed customer invoicing
• Participated in tracking and reporting of project status
• Prepared Purchase Requisitions that will be converted into PO's
• Using SAP ERP system, opened and closed charge numbers, and downloaded project costs and commitments

.

GENERAL ELECTRIC Aviation via a Staffing Company 2010-March2011

A/R Reporting Analyst

• Responsible for the day-to-day management of special projects within the commercial collections department Boeing with guidance from the Director of Analysis Reporting
• Provided analytical support to various collection levels within the Department billing, cash application and client disputes
• Assisted the Director of Analysis Reporting with tracking and reporting requirements: utilized excel dashboards for collection efforts tracking Days Sales Outstanding, unapplied cash reporting, oracle invoice coding on the collection actions taken and follow up efforts
• Worked with collection and cash application managers as required reviewing and executing category-specific tracking and reporting and ensuring consistency with guidelines across all levels

Confidential

Collections

• Designed and developed reporting and reporting applications based on relational database technologies implemented solutions using a wide variety of server and client technologies including MS Excel, SQL Server 2005
• Independently reviewed, monitored, reconciled, and reported on all relevant departmental metrics and played an active role in month end reporting Independently verified accuracy of data sources Avaya auto dialer, Consumer Database and IEX work management tool
• Prepared daily and monthly management updates: collections productivity analysis, scheduling adherence reporting and operations matrix
• Coordinated employee scorecard and incentive tracking database changes and analysis
• Utilizing Excel 2007 created a PivotTable report to analyze collection data from OLAP Online Analytical Processing sources for Operations and HR departments to provide back-up for commission pay-outs for Auto-dial, Mid-range and Recovery departments
• Created PrivotTable charts for additional bonus pay-outs for top performing collection agents that meet RollRate for various Accounts Receivable aging buckets

Confidential

Project Coordinator

• Tracked project milestones and billing in Microsoft Dynamics and published results on SharePoint site on pharmaceutical projects
• In collaboration with project managers, initiated implementation of proposal system in CRM by generating a task list performed on various projects

Confidential

Billing Analyst

• Awarded additional contract time to work on Six Sigma project modeled business and system processes based on findings through use case scenarios, workflow diagrams and data models
• As a part of a team contributed to a large initiative across Power Services division to create robust financial, resource allocation and metric reporting tools to assign freight costs to the proper repair jobs. The management of freight costs is outsourced to a 3rd party named AIMS. Freight carriers send invoices to AIMS directly who identify all costs, and assigns them to jobs and process payments through US Bank. By utilizing a data-definition query to AIMS database created a pass-through query in MS Access to investigate any unallocated freight costs that are not assigned in any job and generated reports to back-up month-end Journal Entries for Finance department. At billing, freight costs are booked to direct expenses and passed to clients for reimbursement bringing a significant amount of additional revenue

Confidential

IT Project Coordinator

• Hired to assist with KM Repository implementation a vital tool for monitoring all aspects of IT project life cycle by publishing project data and status on a SharePoint 2007 site. Collaborated with senior management on collecting and summarizing supporting data of strategic importance to IT organization from then on Project Managers have access to key performance indicators KPI like Total Contract Value, project WIP and A/R balances, project market segmentation and customer satisfaction indicators that can be used to actively guide business performance and Risk Review Meetings. Successfully interfaced with corporate accounting staff in dealing with billing issues and profit recognition processes.

Confidential

Accounting Technician

Key Contributions:

• Microsoft Access Database development stepped in on short notice to identify business requirements, prepare technical specifications and developed Access database for rebate remittance program for third party auto parts distributors for various manufacturing facilities
• Developed enhancements for daily shipments reporting connecting sales database for auto parts with inventory specification data substantially reducing rebates payout time and improving relationship with distributors