We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

Mclean, VA

SUMMARY:

Successful advisor and analyst with broad experience in business analysis, economics, business intelligence, costing, Activity Based Costing (ABC), statistics, Business Process Reengineering (BPR), process modeling and simulations, along with the concomitant analytics requirements gathering and client - facing, proposal writing, purchasing, and inventory control in the public and private sectors resulting in new contracts, follow-on work, cost savings, increased efficiency and effectiveness and customer satisfaction.

COMPUTER SOFTWARE SKILLS:

SPSS, JMP, MiniTab, R and intermediate use of SAS statistical software, Tableau, MicroStrategy, SAS ABM, Oros ABC Activity Based Costing software and familiar with Lifecycle Costing, IGrafx and Savvion BPR/Simulation software, Visio process software, Excel, WordPerfect, Word, Access, PowerPoint, Project, intermediate us of SQL and Visual Basic for Applications (VBA), TOAD for Oracle.

EXPERIENCE:

Senior Business Analyst

Confidential, McLean, VA

Responsibilities:

  • Lead quantitative and cost analysis for Confidential .
  • Developed 25-Block risk quantification for project intake and estimation of portfolio, program and project ROI.
  • Developed customer satisfaction surveys and performed survey analysis.
  • Developed Confidential Departmental Scorecard, Project, Program and Portfolio Key Performance Indicators (KPIs).
  • Oversaw Confidential Data Governance and reporting standards.
  • Performed Recursive Partitioning (Machine Learning Decision Trees) to determine the likelihood and characteristics of projects and programs not meeting performance targets.
  • Performed Survival Analysis (aka Reliability, Duration, Event Analysis) for Program and Project Change Requests to aid in risk quantification and identification of temporal patterns of request submission. Calculated probability of requesting a CR, the probability of requesting a second CR, given a first CR and the associated increase in budget and duration.
  • Performed Cluster Analysis for project classification in determining time-series regression modeling of budget and durations in relation to differences between project methods and funding areas to aid in project estimations and performance measurement.
  • Developed various Tableau and MicroStrategy reports and dashboards related to portfolio, program and portfolio performance and departmental operations for departmental and C-level consumption.
  • All analytics includes concomitant collection of problem statements, objectives, period of performance, points of contact, requirements gathering, data dictionaries, process maps and delivery of results, dashboards, written reports, data dictionaries, working papers and model specifications.

Senior Quantitative and Process Analyst

Confidential, Dulles, VA

Responsibilities:

  • Performed quantitative analysis to determine cause for customer system incident (downtime) ticket backlog, leading to staff level analysis. Performed quantitative analysis on staffing levels and time-series incident ticket input flows to identify staffing levels and ticket incident timing as the cause of backlog.
  • Performed quantitative and statistical analysis on customer satisfaction (Net Promoter Score (NPS)) for determinants of high and low NPS ratings and performed correlations against customer incident ticketing.
  • Reviewed and enhanced NPS survey regarding comprehensiveness, exhaustiveness and mutual exclusivity.
  • Developed initial Sales and Marketing Department quantitative analysis models and analyzed and identified the positive relationship between key customer management efforts and contract renewals, high NPS scores and add-on sales.
  • All analytics includes concomitant collection of problem statements, objectives, period of performance, points of contact, requirements gathering, data dictionaries, process maps and delivery of results, dashboards, written reports, data dictionaries, working papers and model specifications.

Lead Senior Quantitative, Predictive and Costing Analyst

Confidential, Vienna, VA

Responsibilities:

  • Developed quantitative and qualitative models and analytics for IT PMO and Comptroller departments.
  • Documented model processes, procedures and data manipulation for Comptroller ABC model and IT PMO.
  • Performed data analysis to identify data quality anomalies and entry errors for IT and Comptroller departments.
  • Developed Software Development Life Cycle (SDLC) phase staffing level regression (curves) for enhancement and more effective estimation of projects.
  • Developed quantitative Excel-based SDLC estimation templates based upon historical quantitative data for project managers during project consideration and intake.
  • Performed root cause analysis on PMO project change request (CRs), effects of CRs on project duration, staffing and budget, which led to Navy's ITPMO being named PMO of the Year by Project Management Institute (PMI).
  • Performed Survival Analysis to illustrate and predict major project Change Requests on software development.
  • Lead PMO transition to Tableau data mart-based reporting from disparate sources.
  • Performed Business Process Reengineering (BPR) for IT PMO SDLC removing project process redundancies, rework and shortening processing time.
  • Developed custom Excel VBA macros to perform extraction, transformation and load (ETL) of disparate data.
  • Developed and trained staff on IT PMO’s first cross-sectional data analysis, data mining, statistics and Tableau.
  • Performed correlations, linear regressions and ANOVA to identify, illustrate and measure process relationships to aid in actionable recommendations.
  • Performed Cluster Analysis on hours and duration for software development projects to identify commonalities and develop project estimation templates and to assign cluster identification for performance measurement.
  • Linearly modeled and graphed software development project risk relating to project duration uncertainties.
  • Graphically depicted alignment/misalignment of projects relating to risk, value and priority.
  • Performed modeling activities for Confidential Acorn Shared Services Manager (SSM) and Performance Analyst (PA) Activity Based Costing (ABC) models and developed alternative structures future models.
  • All analytics includes concomitant collection of problem statements, objectives, period of performance, points of contact, requirements gathering, data dictionaries, process maps and delivery of results, dashboards, written reports, data dictionaries, working papers and model specifications.

Senior Quantitative and Predictive Analyst

Confidential, Springfield, VA

Responsibilities:

  • Performed statistical and data analysis and data integrity analysis on multiple systems containing millions of records for over 100 years.
  • Utilized SAS as final compilation source to gather data from disparate sources into one reporting resource using SAS, SQL (TOAD), Access and .CSV extractions.
  • Utilized SAS to perform data error detection, reporting and graphing to determine to source of errors. Identified and created separate weekly error reports to serve as a data quality aid resulting in data quality reports to the data entry personnel level.
  • Utilized SPSS Survival Analysis to determine likelihood of leaks and 3rd party damages to pipelines.
  • Utilized SPSS and R Recursive Partitioning (Machine Learning Decision Trees) to determine the characteristics and likelihood of leaks and test current hypothesis.
  • Utilized SAS to graphically depict the effects of delayed data submission of contractors to data entry on data entry errors.
  • Utilized SPSS Autocorrelation, Partial Autocorrelation and Cross Correlation to identify lag time between the introduction of dry gas and resulting gas leaks. This aids in predicting upcoming pipeline leaks and prioritizing future maintenance and work.
  • Developed centralized library containing data dictionaries, process maps, points of contact, SQL and SAS data code, final report submissions, software testing scripts and documentation.
  • Performed process reengineering to increase efficacy to data entry, inventory and payables.
  • Developed Excel-based budget analysis and reporting capabilities.
  • Developed Access-bases (SQL) project analysis and reporting capabilities.

Manager

Confidential, Alexandria, VA

Responsibilities:

  • Engagement Manager and Subject Matter Expert (SME) for Confidential Air Traffic Controller Staffing Standards Program. Reviewed, statistically analyzed and updated the ATC Human Capital Staffing availability factor.
  • Provided longitudinal and cross-sectional statistical analysis and oversight to identify seasonal, weekly, daily, shift and holiday trends and scheduling for the daily air traffic totals for 23 En-Route facilities.
  • Deconstructed previous Confidential TVT staffing model and explained variance between new and previous models and presented on-scope quantitatively derived workforce planning requirements.
  • Tested TVT model assumptions using t-Tests and sample size calculations, which resulted in the identification of an underestimation of labor availability.
  • SME for IMF Office of Budget and Planning (OBP) Analytic Costing and Estimation System ABC model that developed, presented and wrote a deliverable for four (4) ABC model structure alternatives, scenarios, attributes staging tables, reporting and process reengineering options for SAS ABM software.
  • Programmed costing and reporting capabilities utilizing MS Access and SPSS statistics software.
  • Contributed to IMF Request for Proposal ( Confidential ) for ABC software, including software and Confidential requirements, leading to the purchase of SAS ABM software and implementation.
  • SME for Confidential Activity Based Information costing model that developed performance metrics and automated data collection and formatting, reducing monthly task times by 30 percent.

Manager

Confidential, McLean, VA

Responsibilities:

  • Developed proposal, performed as project manager for Acquisition of Criminal Debt Collection Statistical Study.
  • Lead Analysis to quantify the debt outstanding, amount and percentage collectible and probability of collection for 20 factors. Performed literature reviews and analysis of previous collection efforts, data collection and assessment, performed statistical tests (Descriptive Statistics, factor analysis, ANOVA, Recursive Partitioning (Machine Learning Decision Trees) and Logistic Regression) and analysis on over 1 million cases (9 million separate fines and assessments), determined probability of debt collection and quantified debt collectible and provided recommendations.
  • Deliverables brought before U.S Congress and Government Accountability Office ( Confidential ).
  • Tested Confidential study sample size, margin of error (moe) against population finding an 11.2% moe for their model.
  • Tested operational results of Confidential recommendation versus prior EOUSA practices finding prior efforts 20% more effective in collecting debt than the recommendation.
  • Discovered and performed analysis on 7 segments as opposed to the single segment utilized in the Confidential studies.
  • All analytics includes concomitant collection of problem statements, objectives, period of performance, points of contact, requirements gathering, data dictionaries, process maps and delivery of results, dashboards, written reports, data dictionaries, working papers and model specifications.
  • Project manager and SME for Working Capital Fund QC review that identified opportunity, wrote proposal, developed ABC modeling, surveying, and data sourcing.
  • Developed and directed BPR of Operations Service Staff and reviewed and developed WCF User Fee (charge-back) structure.
  • Developed Access (SQL) database that restructured and developed budget data requests database and managerial reporting email and reporting facilities to track information requests from US Congress to FBI.
  • Mapped, developed and performed process simulations for workforce requirement for Budget Execution Unit.
  • Deputy manager/lead analyst for fingerprinting costing model development and workforce analysis.
  • Project manager and lead developer/analyst for ICE OFM User Fee costing model. Consolidating model by 21% while increasing costing, staffing and production reporting capabilities and developed study results.
  • Project manager and lead developer/analyst for Immigration User Fee Account (IUFA) costing models determining user fees and developed study results.

Hire Now