Accomplished in leading technical projects and enhancing data-driven decisions at MAXIMUS Federal Services, I excel in SQL Database Administration and operational efficiency enhancement. Leveraging advanced Microsoft Suite skills and a knack for process design, I've significantly contributed to critical infrastructure support and strategic development initiatives, demonstrating a robust blend of analytical prowess and team leadership.
Overview
19
19
years of professional experience
Work History
SENIOR DEVELOPER
MAXIMUS Federal Services
McLean, VA
02.2021 - 09.2024
Provide Infrastructure and Technical Support to the VDAT Help Desk:
Supports the infrastructure service delivery standards
Supports the development and interface of vendor apps/systems into the VDAT Help Desk
Provides touch labor support for new system integration/interface
Provide report development within Salesforce and Genesys along with using other tools that include Tableau
Develop Sprints and Tasks within Jira for project management
Provide various Visio data and process flows
Participate in compiling metrics on a weekly and monthly basis.
Facilitated team research and future development with strategic guidance on changes.
Developed and manage a team time off calendar in MS Access.
Created a Help Desk Specialist Grading Tool using MS Access and SharePoint List for Project Coordinators
Enhanced Excel Projection file providing abilities that included buttons to automatically update PowerPoint slides
SENIOR ENGINEER – DATABASE ENGINEER
MAXIMUS Federal Services
11.2009 - 02.2021
Collected Medicare Compromised Data from various contractors for consolidation and analysis
Assisted with the National Compromised Numbers Database (NCND) Requirements Document
Developed requirements for the CMS national compromised database including ERM (Entity Relational Model)
Created business rules to find and verify compromised data
Developed a 3rd/4th normalized MS Access database to house research data to be published to the contractors
Led team members in finding processes/functions that can be improved and developed Use Cases
Developed various work instructions and training manuals to support the team tools and functions
Developed a dynamic reporting module and continue to develop various Analytic reports
Worked with Mapitude (geographic mapping software) to develop various demographic reports
Supported Medicare UPIC Contractors when issues with the CNC database and Templates arise
Participated in CMS JAD Compromised Data Claim process mapping sessions and Tabletop Testing Group
Trained staff members on various Medicare fraud issues and database techniques
Assisted with moving CNC database into Oracle and developing reports in Oracle SQL Developer
Provided the Oracle team with the proper design documents to help enhance the web-based system
Ran various test on the monthly Oracle PUMP file to make sure the data is correct
INDEPENDANT CONTRACTOR/CONSULTANT
10.2005 - 11.2009
CLIENTS AND SERVICES PROVIDED
AlphaNet, Inc
– Provide Data Analytics/Solutions for AlphaNet Survey results within Salesforce
Provided Data Mappings from Salesforce files to SQL Server tables used for generating various survey analytics
Reviewed current Views and Store Procedures to understand the process flow and how to streamline the data reporting
Provided innovative solutions to improve the data manipulation and for future data integration
Developed new store procedures to map survey data more efficiently for reporting requirements
Performed analytics on various survey tables to find areas for improvement
RPI Consultants – Provided Business Analysis and MS Access Database Development
Provided VBA improvements to the MS Access SCLHS Customer Service Tracking Tool
Reconciled Lawson Vendor Tables and developed Duplicate Payment and Vendor Tools in MS Access with VBA
Remapped various Lawson RW (Report Writer) reports and reconciled data for a client reorganization
Supported Bon Secours' Treasury Database
LDA INC
- Microsoft Great Plains Consultants - Provided various Business services
Developed Microsoft FRx and Crystal Reports for Microsoft Dynamics GP Financial System
Assisted with implementation work and website development
Children’s Hospital of Philadelphia – Provided financial and system services
Reconciled various bank accounts year 2008 and 2009
Built a two-tier Cash Log Reconciliation database in MS Access that included a dashboard reporting module
Improved the complete bank reconciliation process
Medstar Health, Inc
– Provided Report Development, Project Management and Business Analysis
Project Manager for the financial reporting re-engineering project
Identified areas that needed process/functional improvements through JAD sessions
Enhanced Excel Financial reports with VBA
Re-wrote and converted MS Access ODBC Lawson Reporting tools to MDE files
Implemented improvements for Lawson Reports and provided user manuals with graphical Visio models
Alpha Engineering – Provided Report Development and Data Analysis for STARLIMS (Environmental Software)
Developed Crystal Reports for STARLIMS, a SQL Server Based Environmental Software
Assisted with Data mapping from old software packages to STARLIMS
Developed a Bathroom Remodeling Quote Tool using MS Access 2007
MMC 20/20 – Provided business and data analysis for various Medicare projects
Aided with data conversions from a SQL Server Part D Enrollment system to an Oracle based system
Developed MS Access data conversion tools with VB
Developed a Risk Membership Survey Formatting tool
Developed Part C and Part D Reconciliation Tools
Provided other various Medicare technical and analytical support including documenting data dictionaries
Worked with Risk Analyst to find processes/functions that could be improved and developed Use Cases