Shawanda Simpson Email & Phone Number

Stennis Space Center, Bay St. Louis, Ms

Technical Lead for HRIS L2Business Analyst for all of HR

* Produced monthly charts for use in the Capacity Utilization Package (CUP) for the Outfitting Shops and Paint; tracked capacities by man hours, pipe details, and square footages* Employed historical/current data to project future business and determine workforce requirements for next 3-5 years * Developed automated system of macros and SQL queries; drastically improved accuracy and reduced total process from 3-4 weeks to 1 hour * Produced “What If” scenarios for determining optimal scheduling to maintain feasible, steady workloads (process improved from 1 week to 20 minutes) * Created new Access database for Capacity Planning to use for monthly CUP Package * Provided training in SQL programming; independently learned AutoCAD 2014, gathered tribal knowledge, and compiled it into useable data sets* Achieved greater understanding of planning, scheduling, and budgeting of workloads for the ships; ensured self-improvement of SQL development and VBA programming skills * Enhanced collaborative and independent system design and implementation skills* Excelled in system requirements discovery, process improvement, and system implementation; expanded knowledge of data structures, data relationships, and data standardization

Pascagoula, Ms

* Designed new and modified existing metrics, created and maintained databases, researched bill history, and uploaded data changes to MARS* Developed system to track Earned Value (EV)-related budget and scheduled changes in MARS; achieved system of Access databases linked to SQL data tables and matrices, SQL queries, functions, and procedures that compiled/archived user response(s), generated summary reports, and compiled metric packages * Ensured development, automation, and subsequent distribution of common Cost Management Package (CMP) for all EV Ships* Authored queries, functions, and procedures in SQL using SQL Server Management Studio; enhanced VB/VBA programming skills * Received TAP award for exceptional interpretation of EV Change Tracking System project from conceptualization to implementation

Pascagoula, Ms

* Completed all processes to generate monthly Contract Performance Report (CPR), including a detailed Format 5 and various other metrics, for the LHA 6 contract for submittal to the Navy* Amassed, analyzed, formatted, and archived essential data​: Budget Allocation Requests, monthly Change Orders, Program Work Authorizations, Department Work Authorizations, and MPM and wInsight projects; ensured Estimate at Complete and Budget at Complete were balanced to COGNOS at Cost Center level* Published database of Variance Analysis Reports (VARs) for responses from Control Account Managers; compiled and analyzed VAR responses and described variances within Work Breakdown Structure Legs* Employed MPM, wInsight, Connect 64, wInsight Administrator, and Business Data Warehouse

Pascagoula, Ms

* Supported all Engineering Control Account Managers (CAMs); provided complete performance detail and trend analysis to support timely CPR analysis* Established and maintained Engineering Work Packages for all current programs and PMB Budget and EAC hours at all levels * Co-created replication of Consolidated Database for Engineering for use during transition from CDB to new MARS ERP Software* Enhanced Data Support systems to ensure compatibility with MARS* Collaborated with Engineering Department to ensure smooth transition to MARS by creating numerous instructional packages on the functionalities of MARS* Awarded Personal Outstanding Achievement Award for my Exemplary Work Ethic and Attitude

Pascagoula, Ms

* Planned, designed, and implemented process improvements to Data Support functional systems; streamlined process to create data integrity, stability, and reproducibility of results* Developed Data Support Training and Daily Functions Manual and new metrics to illustrate trends in actual hour expenditures as compared to budgets, schedules, and work scope* Gained proficiency in MS Office Suite through self-directed study and recreation of existing reports, spreadsheets, databases, and websites; reduced completion time by nearly 85%

Bachelor'S Degree, Mathematics And Computer Science, 3.86

Graduated with Highest Honors.

Mathematics And Computer Science

Activities and Societies: Phi Theta Kappa, Alpha ChiI wrote an English Comp II Argument term paper titled "Tell Me Your Secrets Kennewick.