Summary

• Microsoft Office Experience over seven years intermediate to advance user:
• o Excel: pivot tables graphs, macros , vlookups, hlookups, and other formulas
• o Word: Merge documents, various tables, templates
• o Power Point: slide presentations, slide templates
• o Microsoft Access: design, customization, reports

Project Manager

• o Did requirement gathering, design, testing, training materials, and documentation of Bill of Lading system that accommodated approximately 12K different SKUs and special shipping instructions and state agricultural compliance
• o Worked on TSA database upgrade project gathering requirements from SME at several different federal entities involved. Participated in UAT and process analysis.
• Managed staff of 21 as part of TSA contract that encompassed five different TSA divisions in addition to simultaneously performing assigned duties for two positions on the contract. Created weekly deliverables, arranged special team training, and performed interviews to fill any vacancies on the contract.
• Recognized by Director of Redress and Director of Operations on attention to detail and system security notes and system documentation.
• Recognized by Vice-president of Operations at LTC Global for detail and thoroughness of process improvement and documentation of upgraded business system.
• JIRA Project Administrator to manage defects on website.

ADDITIONAL KEY AREAS OF KNOWLEDGE AND EXPERTISE

Work Experience

Overall Experience as Project Manager/Analyst: 1999-2014

Confidential

Data Business Analyst,

• Using SAS Enterprise 4.3 created pull lists for the Business Class Marketing staff.
• Created MS Excel reports consolidating information from Midas and GEM databases of demographic information for Marketing Executives.

Confidential

Project Matrices and Reporting Analyst, ACA-FFM/JIRA Project Administrator

• Using JIRA created metrics for tracking the progress resolution of errors impacting the healthcare web-site through extractions and graphic dashboards.
• Manages defects and users in DEV JIRA.
• Manage users, permissions, screens, and workflows.
• Liaison with other contracted entities to determine the final resolution of reported issue generated by users of the web-site that is not eligible for final acceptance testing.
• Updates JIRA with acceptance testing results as reported to the team leads and updating formal reports
• Manage special, ad-hoc requests from the companies involved in the project concerning the status of a defect
• Key Accomplishments
• Member of JIRA support team and Project Administrator of JIRA.
• Covered for JIRA Administrator when project member on vacation

Confidential

Data Analyst, Deloitte Contract, 800 MHz Transition Administrator Project

• 7/15/2013-12/13/2013
• Compiled data to created Tableau visualizations to show progress of the project by region and major categories.
• Created new dashboards reports. Updated current dashboards designs.
• Created monthly dashboard reports using Tableau
• Maintained data archive of source files.
• Created process documentation and technical specifications for reports.
• Key Accomplishments
• Created training materials and trained staff to use Tableau.

Confidential

Administrative Assistant, DHS OPO Contract

• 5/20/2013 to 7/14/2013
• Provide administrative support to the management team of the DHS internship program.
• Create layout drafts for graduation programs, invitations, and certificates for the Homeland Security Acquisition Institute.
• Update spreadsheets with participants contact information and maintain time-off/sick leave requests.
• Create tracking survey using Survey Monkey for upcoming graduation.

Confidential

Project Manager for contract and Team Lead for Redress and CRD

• Maintain Microsoft Access database used to consolidate downloads from RMS system into workable Microsoft Excel Pivot Tables.
• Part of team involved in DHS Trip program upgrade project: including software lifecycle and gathering data requirements from the various federal agencies involved.
• Create reports on weekly, monthly, and quarterly basis. Reports include Power Point slides and MS Excel graphs, for senior management and other senior government officials.
• Maintain MS Access database and generate special reports using data extracts.
• Manage team of contractors responsible for processing incoming requests into DHS TRIP program.
• Member of planning team and test team for the CRM DHS TRIP upgrade project. Acceptance tester for the database.
• Create weekly and monthly deliverables to meet VetFed contractual requirements, including feedback on staff tracking billable hours, and presentations.

Confidential

Program Manager for Test Key Authentication Renewal Project and Systems Analyst

Managed records and information of global membership.

Tracked official correspondence sent via courier and facsimile and SWIFT.

Updated MS Excel spreadsheet and generate fulfillment statistics.

Created daily test messages using SWIFT system.

Key Accomplishments

Managed the Renewal project to update SWIFT contingency contacts

Learning Evolution, Office Team Temporary position replacing sick staff

5/2010-5/2010

Acceptance testing for web-based learning portal being developed for several large corporations.

Confidential

Business Analyst II

• As part of the Retail Printing Systems team tracked inventory going out to the Wal mart Stores for installation including special overnight shipments to technical staff.
• Processed incoming data from shipping system and updated test database and spreadsheets.
• Using JBM Electronics Gateway Management System GMU updated test results of transmissions from various locations and updated records with store numbers.
• Wrote scripts for call center in regard to contacting stores to check on installation readiness.
• Did analysis of workflow and suggested improvements to ADM manager. Created pivot tables and analyzed workflow for project manager.
• Key Accomplishments
• Accomplished lowering the reschedule tasks for an ADM through calling stores an improvement of approximately 60 .
• Analyzed processes and made suggestions to project manager for process improvement.

Confidential

New Business Specialist

• Part of management team charged with transition process from one database to new Oracle system improving overall company performance.
• Processed incoming data for transmission to remote data entry team and verified that work was completed in a timely manner for our clients and agents.
• Wrote SQL queries and managed data transmissions to Oracle warehouse.
• Organized and, delegated tasks to coworkers to meet required on projects by using interpersonal and time management skills to meet deadlines.
• Experienced with an understanding of organizational changes and matching the skills need of the team and individual team members to the company goals.
• Analyzed workflow and proposed improvements to data consolidation of applications that that was integrated into the new Oracle system with a process rate improvement of approximately 20 percent.
• Created Visio flowcharts for meetings and process change documentation.
• Supervised and trained temporary workers, who worked on processing backlog data, mentored and supported staff resulting in superior team performance, and reduction of backlog.
• Key Accomplishments
• Was recognized by management for writing processes leading to highly improved overall workflow documentation.
• Using MS Excel pivot tables created metrics to measure quantity and quality of work processed by remote office so that data was entered in a timely manner for our agents and clients.

Confidential

Technical Service Representative

• Analyzed and tested the interface and processes of service management systems for developers to ensure data was processed according to the standards of the Customer Service Center.
• Compiled monthly MS Excel reports of customer feedback for the stores across the United States.
• Reviewed new database and planned process changes and new user functionality in compliance with the strategic planning of the company.
• Created training material and trained new hires in the proper work processes, use of, and service management systems procedures of the Customer Service Center.
• Key Accomplishments
• Was recognized for team building skills, proactive in developing staff toward increased effectiveness in current role and preparation for broader responsibilities
• Created Word merge document that changed the procedure for the handling of follow up cards mailed to client substantially decreasing processing time.

Confidential

Logistics/Traffic Clerk

• Did strategic planning for handling orders and loads for peak shipping season and did analysis after Christmas.
• Project manager on BOL project to customize MS Access database. Project went from inception to implementation in three months database had no errors and after 18 months of use it was integrated into permanent shipping system. Was consultant on integration project.
• Did training presentation to managers. Did remote instruction of customized MS Access database.

Key Accomplishments

• Was recognized by coworkers and management for large amount of data processed daily.
• Was recognized for Project Management --creating Access database using SQL and saving the company a significant amount of money.