Summary of Qualifications
Technically skilled Excel Data Analyst to provide data cleansing support and validation of data for use in presentations, metrics, and reporting of information. Professional with 10+ years experience as a data analyst, providing support in the areas of project coordination, data analysis, and metrics reporting. Able to translate business needs into complex analysis designs and recommendations. Able to perform complex multiple tasks while insuring seamless support of the overall project timeline. Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts. Strong communication and customer service skills. Strong end-user computing skills (Excel, SharePoint, Power Point, Word).

Confidential, 100 Tournament Dr., Horsham, PA. 18974
07/12 - Present
Excel Data Analyst:
Currently on assignment to develop a new Excel based compliance tracker tool; perform data cleansing and build an Excel user interface to assistance in data collection and metrics. Responsible for validating good data and purging invalid/bad data. Collect user requirements and conduct project status meetings to insure project deliverables are met.

Confidential, South San Francisco, CA. 94080
07/11 - 06/12
Excel Data Analyst:
Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation. Facilitate program and project meetings; maintain Statement of Work and Resource Allocation Trackers. Help remediate Vendor Statements of Work; submit Statements of Work into Contracts database; budget and forecast tracking and variance analysis; work with Finance on accruals; perform general back-office support for Project Managers. Prepare and facilitate weekly PMO meetings; captured meeting decisions and content into Excel based tracking logs. Conduct quality assurance activities regarding data migration and folder permissions. Adhere to and communicate Records Management procedures to customers. Perform SharePoint administration for team.

Confidential, Center Valley, PA, 18034
01/10 - 07/11
Excel Data Analyst:
Create reports and metrics, present them convincingly, facilitate required discussion, and drive superb execution of such reports. Facilitated program and project meetings; maintain Statement of Work and Resource Allocation Trackers. Helped remediate Vendor Statements of Work; conducted follow-up with project team members to ensure open items are brought to resolution. Prepared and facilitated weekly PMO meetings; captured meeting decisions and content into Excel based tracking logs; tracked budget and forecasts.

Confidential, Collierville, TN, 38017
09/10 - 12/10
Excel Data Analyst:
Create and maintain pre- and post- migration checklists / steps. Governance and reporting of Data Center Migration project data for PMO and VP level using Excel workbooks and proprietary
databases. Synthesized data from several data sources to produce consolidated views of project
performance. Daily use of complex Excel formulas and pivot tables to manipulate large datasets.

Confidential, 700 Locust St., Dubuque, IA, 52001
03/10 - 09/10
Excel Data Analyst:
Compiled weekly service delivery implementation metrics using Excel workbooks and proprietary databases. Produced metric decks for review by Project Managers and Executives. Conducted continuous improvement audits and document data gathering workflow processes. Extensive Excel work using pivot tables and complex formulas to manipulate large data structures. Followed up with stakeholders and data owners to fill gaps in data. Participate in developing best practices for product data and content analysis and reporting.

Confidential, South San Francisco, CA. 94080
10/09 - 02/10
Excel Data Analyst:
Assigned with task of post-migration cleansing of technical publication database; reviewed and adjusted project timelines, data categories, developed and applied detailed business rules to determine naming convention and syntax, while working with project managers to determine universal assumptions and qualifications. Worked closely with Program Manager and Executive Leadership to prepare and update documents, presentations, and other project related material as needed. Supported cross-regional document management processes, maintained project plans, and assisted in meeting coordination. Develop, implement, and facilitate process for data identification, segregation, and cleansing. Write documentation, procedures, job aids, and training materials. Perform, SharePoint website development and archiving for Team.

Confidential, Herndon, VA. 20147
10/04 - 02/09
Metrics/Excel Data Analyst:
Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting, hoc reporting, and data manipulation to produce routine metrics and dashboards for management. Responsible for the development and preparation of a broad range of reports and complex analysis focused on program performance and project deliverables. Created PowerPoint decks to produce clear concise and professional presentations quickly for management and other analysts. Provide timely status reports and metrics. Perform, SharePoint website development and archiving for Team.

Special Skills: Proficient in Data Cleansing techniques, Microsoft Office Suite, including Excel, SharePoint, Outlook, PowerPoint, graph making, formulas, pivot tables.