Sql Server Developer/DBA and general data maven

Mark W. Burns

MS-Access / SQL Server Developer & Database Analyst

************@*******.*** • 717-***-****

linkedin.com/in/markwburns • FL, 32218, US

Highly analytical and results-driven professional with over two decades of expertise in database administration, application development, and migration projects. Proven track record in enhancing operational efficiencies and ensuring data integrity across diverse industries, including finance, government, and manufacturing. Adept at leading large-scale database migration initiatives, from planning through execution, with meticulous attention to detail and adherence to project timelines. Skilled in troubleshooting complex database issues and optimizing SQL queries to improve system performance. Adept at managing software development lifecycle including design, development, testing and reviewing changes to databases. Strong communicator and collaborator, adept at interfacing with stakeholders to achieve project goals effectively.

Professional Experience

State of Illinois DCFS (for 22nd Century Tech.) Nov. 13th, 2023 – June 27th, 2024

MS-Access / SQL Server Developer / DBA - Remote Work

Engaged in a large-scale migration project to upgrade and modernize the Department of Children and Family Services (DCFS) database systems. The project involves the transition of approximately 32,000 MS-Access databases through two primary initiatives, involving an MS-Office Upgrade to transition databases from the Pre-Office 2007 *.mdb format to Office 365/2016 *.accdb format and Active Directory Migration to migrate linked data elements from an older Active Directory structure to a new \illinois.gov Active Directory system.

Collaborated with project stakeholders and team members to ensure project milestones and deadlines were met.

Conducted rigorous testing and validation to ensure the reliability and performance of the migrated databases.

Developed comprehensive documentation detailing the migration process, troubleshooting steps, and best practices to aid in future transitions and maintenance.

Spearheaded the conversion of MS-Access databases from *.mdb to *.accdb format, ensuring data integrity and consistency throughout the process.

Facilitated the migration of database-linked data elements to the new \illinois.gov Active Directory system, resolving any connectivity issues and ensuring seamless integration.

METUS (for iStaff, LLC) Suwanee, GA March 10th, 2021 – Dec. 31, 2023

MS-Access / SQL Server Developer / DBA - Remote

Revitalized operational production support and executed application development on MS-Access/SQL + Server (2017) for custom ERP within SAP3 (now SAP4 HANA) at METUS (Mitsubishi Electric/Trane US) via Planning Assistant.

Facilitated transition to new ERP solution in late 2023 and early 2024, phasing out Planning Assistant.

Deployed standard maintenance and supported solutions for SQL Server to safeguard application and database integrity and enhance indexing and performance.

Discover Fin.Svcs. (for Judge Group LLC) April 24th, 2023 – July 21st, 2023

MS-Access / SQL Server Developer / DBA - Remote Work

Delivered production support and performed minor application development for MS-Access/SQL-Server solutions in the Consumer Credit sector.

Restored a severely corrupted MS-Access database application and implemented minor changes to several others.

Newport News Shipbuilding (for ACS Solutions), Newport News, VA November 11th, 2020 – Jan 19th, 2021

Sr. MS-Access/Office Developer & Data Analyst via ACS Solutions, Inc.

Administered development and supported enhancements for MS-Access reporting database applications.

Upgraded selected applications from Office 2013 to Office 2016.

Dansko West Grove, PA April 28th, 2019 – May 5th, 2020

SQL Server Developer / DBA

Migrated and consolidated databases across a multi-server architecture in a non-clustered environment for a business using Microsoft Dynamics NAVISION, alongside other SQL-Server-based applications for web and retail operations. Managed SQL Agent queues, backups with Litespeed for SQL Server, maintenance plans, and general DBA responsibilities across the enterprise.

Upgraded server hardware and modernized with new OS versions and SQL Server 2017 updates.

Evaluated emerging technologies, like MS PowerApps for future use and replace legacy applications.

Wrote new PowerShell SQL scripts, modify and create TSQL views, stored procedures, and functions.

Developed SSIS and SSRS code and jobs using Visual Studio 2019 VB.Net and Transact-SQL scripting.

BNYMellon Wilmington, DE September 17th 2018 – February 21st, 2019

Business Analyst

Served as key member of bank’s Fund Administration organization’s Eagle Onboarding team to support client conversions from legacy systems (IAX and Invest One) to new operating environments and platforms. Created new Business Requirement documents, procedural guides, and instructional materials for the Eagle-based environment.

Completed extensive training on Fund and Fund of Funds Accounting, Accounting Principles, and related Securities Industry topics, enhancing previous Series 6 and 63 licensure and training.

Analyzed and reverse-engineered existing processes and procedures to perform Gap Analysis.

City of Philadelphia (City/County Government) Philadelphia, PA July 30th 2018 – September 13th, 2018

Sr. MS-Access/Office Developer/Consultant & Data Analyst via SoluStaff, Inc.

Delivered technical support to enhance existing MS-Access reporting database applications.

Converted multiple Lotus 1-2-3 Macro workbooks into Excel/VBA.

Developed new MS-Access solution for Cancelled Check/Lost Property Tracking data from various manual Excel sources.

TD Bank Cherry Hill, NJ March 22nd 2018 – July 6th 2018

Sr. MS-Access Developer/Consultant & Data Analyst via ACS Inc. and Wipro.

Conducted RAD development and support for multiple MS-Access databases and tools, integrating data files and an Oracle Data Warehouse from various business units supporting TD Wealth Banking operations.

Executed reverse engineering and data analysis to enhance reporting functions.

Updated existing applications to reflect changes in data sources and ongoing production-level business processes.

JP Morgan Chase Christiana, DE March 13th 2017 – December 8th 2017

Sr. MS-Access Developer/Consultant via Veterans Sourcing Group LLC.

Developed and supported RAD tools to accept data files from various LOBs, including offshore international sources, for importation, processing, merging, standardization, and ETL operations.

Produced outputs to drive Trader/Broker Supervisory Control web portal feeds, supporting international investment and brokerage operations across diverse investment types.

Optum/UHG Minneapolis, MN August 8th 2016 – February 24th 2017

Sr. MS-Access Developer/Consultant via Saxon Global (8/16-12/16) & Apex Systems.(1/17-2/17)

Supported existing MS-Access application/database to track history of telecom phone-switch and toll-free number configurations.

Subaru of America, Inc. Cherry Hill, NJ January 4th 2016 – March 31st 2016

Sr. MS-Access Developer/Consultant via ProActive Staffing Strategies, Inc.

Resolved issues related to corporate-wide upgrade from Office 2007 to Office 2016, impacting Access databases and Access/Excel VBA apps across multiple departments and locations in the USA.

Deployed configuration changes and version-related updates for database applications. Contract concluded on schedule with all issues resolved.

Centurion Group LLC Plymouth Meeting, PA October 12th 2015 – December 16th 2015

Sr. MS-Access Developer/Consultant/Configuration Management

Optimized newly arisen issues in MS-Access/Excel application, code, and reports developed earlier in the year.

Implemented configuration changes to support ongoing SDLC for deployed production version due to role changes in previously deployed database files.

Iron Mountain, Inc. Collegeville, PA July 21st 2015 – September 25th 2015

Visual Basic 6 Developer/Consultant via TekSystems, Inc.

Diagnosed and attempted to resolve issues with an established Visual Basic 6 application caused by updates in Server/OS versions and FTP processes.

Encountered difficulties due to the original developers' use of a customized multi-language resource file format without available documentation or support materials.

The application, last maintained in 2008/2009, had no previous modifications to the resource files, highlighting unresolved issues with project source code and documentation since its original development in the early 90s.

Lannet Co. Inc. Philadelphia, PA June 29th 2015 – July 19th 2015

Sr. MS-Access Developer/Consultant via Judge Technical Services, Inc.

Steered issue resolution in an unfinished MS-Access application developed by another developer.

Identified significant rework needed, leading to disagreements and early termination of the project.

Centurion Group LLC Plymouth Meeting, PA February 13th 2015 – June 13th 2015

Sr. MS-Access Developer/Consultant via e-Primary LLC.

Created an application for client 401K/retirement plan data to redevelop new investment strategies, aiming to reduce administrative costs and increase employee returns.

Devised and deployed custom ETL processing, workflow, and reporting metrics.

TD Bank Cherry Hill, NJ June 16th 2014 - December 31st 2014

Access / SQL Server / Data Warehouse Developer, Capital Stress Testing via Global Technical Talent

Maintained existing MS-Access/Excel application for consolidating, processing, and exporting corporate Stress Testing data from all business units. Supported Board of Directors and Federal regulatory reporting (DFAST, EWST, CCAR, Y-9C, Y-14A, etc.).

Created Tableau reports using Stress Testing data from MS-Access application and internal systems/Data Warehouses.

Additional Experience

Development Team Lead / SME / Business Analyst / Data Architect (Oracle) via UST Global Independence Blue Cross Philadelphia, PA

Sr. Microsoft Access/Excel/SQL Developer via TEKSystems Ahold Financial Services Carlisle, PA

Sr. Microsoft Access Developer via Sun Technologies, Inc. Lockheed Martin King of Prussia, PA

Sr. Microsoft Access/SQL-Server Developer IT Impact Hershey, PA / Chicago, IL

Sr. Microsoft Access & SQL Server Developer via Sysmind, LLC PA Dept. of Public Welfare – BIS Harrisburg, PA

SQL Server Programmer/Analyst / PHP Developer via Modis Paytime Payroll Mechanicsburg, PA

Consulting VB.Net & MS-Access Developer via Modis Sovereign Bank/Santander Reading, PA

Sr. Microsoft Access Developer via TEKSystems AHold USA Financial Services Carlisle, PA

Data Analyst via TEKSystems AmeriHealth Mercy Harrisburg, PA

Microsoft Access/Excel Developer via Sapphire Technologies Bank of America Newark, DE

Consulting Microsoft Access/Excel Developer via JFC Staffing Foot Locker, Inc. Camp Hill, PA corporate offices

Consulting Sr. Microsoft Access/Excel Developer via Arcus HIGHMARK, Inc. Camp Hill, PA

Sr. MS Access Developer/SQL Server Developer/Data Architect via CompTech Associates, Inc. HESS Corporation Woodbridge, NJ

Consulting Microsoft Access Developer via iSpace, Inc.DaVita Berwyn, PA

Consulting Microsoft Access Developer via Modis, Inc. Nationwide Better Health, Inc. Columbus, OH

Senior Microsoft Access Programmer / Analyst via CompterAid, Inc. The Hershey Company Hershey, PA

Consulting Microsoft Access Programmer/Analyst Legal Medical Staffing, Inc. Voorhees, NJ

Sr. Programmer / Analyst Harrison Career Institute Voorhees, NJ

Consulting Microsoft Access Programmer/Analyst Stanley Tools, Inc. Louisville, KY

Programmer/Analyst Westmoreland Mechanical Testing & Research, Inc. Latrobe, PA

Operations Manager/COO Family Internet, Inc. Pittsburgh, PA

Network Engineer / Application Support Engineer CADVANSYS King of Prussia, PA

CAD / Visual Basic Programmer Ewing Cole Cherry Brott Philadelphia, PA

CAD Programmer / Systems Manager Nelson & Associates Philadelphia, PA

CAD Programmer/Network Support Engineer The Kling-Lindquist Partnership (TKLP), Philadelphia, PA

CAD / Database Programmer Geonex Vernon Graphics Norristown, PA

Computer Center Operations Staff Foster Medical Corp Blue Bell, PA

Computer Center Operations Staff SEI Corporation King of Prussia, PA

Education

Exeter Township Sr. High School - Graduated

Albright College - Main Campus part-time studies to supplement High School

Drexel University Full-time studies in Computer Engineering

Penn State University - Berks Campus part-time studies in Computer Science

Harcum Jr. College – Certificate: AutoCAD/AutoLisp Programming

Certifications

Certified Solmon IV Systems Engineer

MCAD VB.Net / MCP – Microsoft Certified Application Developer / Microsoft Certified Professional

Awards

Owner – LinkedIn.Com group: Professional Microsoft Access Developers Network [PMADN], 2008

Nominated for Microsoft Access MVP award, 2012.

Microsoft Community Contributor Award for supporting Access Developers in Public forums, 2011

Contact this candidate