THOMAS J. GRONSKY
Denver, NC ***** 240-***-**** *********@*****.***
SharePoint and Database Engineer
Accomplished, meticulous, and user-oriented SharePoint, software and database engineer with 30+ years of experience in all facets of system development lifecycle within IT and Sciences environments and working on projects for private, public, and government agencies. Recognized for exceptional programming skills with expertise in database design and development. Proven record in data analysis, data loading, and designing ETL processes. Demonstrated outstanding communication skills, with ability to manage requirements needs for clients and key stakeholders via UML modeling and Joint Application Development sessions. Commended and received awards for top performance.
Key Accomplishments:
Enhanced mission-critical MS Access database linked to SharePoint 2013 with 2 GB of data for U.S. State Department Bureau of Diplomatic Security Office of Antiterrorism Assistance Training Directorate
Migrated 2 GB database to SharePoint 2013 using InfoPath within 90 days
Received award for contribution to Information and Technical Solutions Division achievement of CMMI Maturity Level 5 for Software Engineering
Created help desk and drug-testing databases for US Marshals Service, running on Pyramid minicomputer platform, using UNIFY/ACCELL
Designed and developed automated data loader (ADL) process for managing Oracle Financial database
AREAS OF EXPERTISE
Lifecycle Development ● Database Design & Development ● Data Analysis ● Process Improvement
System Optimization ● Troubleshooting & Correction ● Requirements Management ● Technical Writing
Coding ● Training ● Document Development ● Functional/Regression Testing ● Workflow Planning ● SCRUM
Programming Languages and Databases
TypeScript ● Dataverse ● MS Access ● VBA ● ASP.NET ● HTML ● CSS ● JavaScript ● XML ● C# ● C ● C++ ● Korn/C Shell Perl ● SQL ● SQL*Loader ● BASIC ● FORTRAN ● Oracle ● MS SQL Server ● ADABAS/NATURAL ● UNIFY/ACCELL
Operating Systems and Applications
PowerApps ● Power Automate ● SharePoint Online/13/16 ● ShareGate ● SharePoint Developer ● DFFS ● InfoPath
MS Forms ● Power BI ● MS Dynamics 8.2.0/9/365 CRM ● Customer Voice ● HubSpot ● Nintex Workflows
Jira ● Azure DevOps ● Office 365 ● Azure ● Windows ● UNIX ● Linux ● VMS ● SunOS/Solaris ● NeXTSTEP
Requirements Analysis and Testing Tools
JAD Sessions ● UML ● RUP ● Use Cases ● Requirements Traceability Matrix ● MS Visio ● MS Project
PC Paint ● PVCS Tracker ● TestDirector ● Test Plans & Test Cases
PROFESSIONAL EXPERIENCE
Lead Software Engineer – Wells Fargo Bank, NA
COLLABERA, INC., CHARLOTTE, NC, November 2022-November 8, 2024
Migrated thirty sites from SharePoint 2013/16 on-premises to SharePoint Online in Azure environment using Jira to track sprint progress as part of a Treasury SharePoint Team migration effort
Designed, developed, tested, enhanced and maintained Power Apps applications and associated Power Automate flows including connectors to SharePoint, Outlook, Teams, Excel and HTTP for Liquidity Risk Management
Created, modified and maintained SharePoint elements including sites, lists, libraries, forms, surveys, task lists, workflows, links and other web parts using OOTB functionality on SharePoint Online platform
SharePoint and CRM Developer – Hargray Communications Group/Cable ONE
CHARLOTTE, NC, December 2020-November 2022
Designed and developed Dynamics 8.2.0/9/365 CRM forms and database elements for Hargray Communications Group
Created and maintained Dataverse tables and Power BI dashboards for Dynamics 365 CRM production databases
Created prototype SharePoint issue tracking system for CableONE
SharePoint Developer/Administrator – Wells Fargo Bank, NA
SIGNATURE CONSULTANTS, CHARLOTTE, NC, January 2020-November 2020
Created SharePoint list applications enhanced with DFFS including tabs, rules, side-by-side fields, read-only fields, hidden fields, field CSS, help text, access by permission group, custom HTML headers, custom JavaScript, custom CSS, cascading dropdowns and email delivery/integration
Designed, developed and maintained Business Technology sites and forms for Conduct Management including enhancement with CSS, JavaScript and InfoPath
Created, modified, tested and maintained SharePoint elements including sites, lists, libraries, forms, surveys, task lists, workflows, promoted links and other web parts using OOTB functionality
Served as SharePoint administrator and Tier 2 support specialist for Customer Impact and Customer Harm applications
SharePoint Developer MATRIX RESOURCES, INC., CHARLOTTE, NC, March 2019–December 2019
Designed, developed and maintained Information Security and Information Policy Adherence site collections for Wells Fargo Front Line Risk Management
Served as secondary site collection administrator responsible for granting permissions, creating user groups and monitoring system resources and usage
Created, modified, tested and maintained SharePoint elements including sites, lists, libraries, forms, task lists, workflows and other web parts using OOTB functionality
Created SharePoint list applications enhanced with DFFS including tabs, rules, side-by-side fields, read-only fields, help text, access by permission group, HTML and CSS
Completed SharePoint Designer 2013 training and attestation with Corporate Risk SharePoint Support
SharePoint Designer/Developer PLANET TECHNOLOGIES, INC., GERMANTOWN, MD,
June 2017–July 2018
Designed, developed and maintained mission-critical e-forms using InfoPath and Office 365 SharePoint Online list forms for DoJ client to support admin and field users
Created and maintained MS Access database for HR reporting and graphing of health care data
Created, modified, tested and maintained SharePoint elements including sites, lists, web parts, forms and user/group permissions using SharePoint Designer, InfoPath, Flow and CSS on Office 365 SharePoint Online
SharePoint Designer/Developer PRINCETON INFORMATION, LTD. RESTON, VA,
October 2016–February 2017
Designed and developed multiple team sites in Office 365 SharePoint Online for the U.S. Food and Drug Administration, Center for Devices and Radiological Health to support more than 1700 end users
Created, modified, tested and maintained SharePoint elements including sites, lists, web parts, forms and user/group permissions using SharePoint Designer, PowerApps, InfoPath and CSS on Office 365 SharePoint Online
Assisted in preparation of user and system administrator documentation
System Architect (SharePoint/Access) EDGESOURCE CORP., ALEXANDRIA, VA, August 2015–May 2016
Developed and enhanced MS Access reports, modules, forms, queries and dialogs linked to SharePoint and SQL Server for U.S. State Department Bureau of Administration Office of Operations Office of Real Property Management
Created and maintained SharePoint elements including sites, lists, master files, Nintex workflows and user/group permissions using SharePoint Designer, ASP.NET and CSS on Office 365 SharePoint Online
Developed customer satisfaction surveys for office intranet using ASP.NET, CSS and inline C# and JavaScript
Created project request forms using SharePoint and InfoPath to shift to an efficient, paperless office
Sr. Consultant (SharePoint Developer) INFUSIONPOINTS, LLC, NORTH WILKESBORO, NC,
November 2014–May 2015
Veterans Health Administration SharePoint Designer and Developer for Service-Oriented Architecture Research and Development (SOARD) in SCRUM environment
Developed Environmental Management Services (EMS) Office 365 SharePoint Online site for SOARD EMS personnel
Completed and submitted monthly Office 365 SharePoint deliverables and surveys
Completed SharePoint administration duties including assigning and verifying permissions
Assisted team members of other work groups with SharePoint requests and issues
Department of Veterans Affairs Homeland Security Presidential Directive 12 (HSPD-12) Program Management Office (PMO) SharePoint Lead
Designed and developed HSPD-12 PMO Office 365 SharePoint Online site and associated SharePoint content for badge processing managers and other stakeholders
Completed and submitted monthly PIV card statistical reports, monthly Office 365 SharePoint reports and other deliverables as required
Completed SharePoint administration duties including adding/removing users and assigning permissions
Sr. Technical Consultant (SharePoint/Database Developer) ACUITY, INC., HERNDON, VA,
January 2013–May 2014
Enhanced mission-critical MS Access database linked to SharePoint for U.S. State Department Bureau of Diplomatic Security Office of Antiterrorism Assistance Training Directorate
Created and maintained SharePoint elements including site pages, lists, document libraries, Nintex workflows and user/group permissions for over sixteen users
Provided computer and application assistance to train twenty delivery officers and program managers, improving efficiency and productivity by 30%
Migrated database to SharePoint using InfoPath within 90-days
Software Engineer GLOTECH, INC., ROCKVILLE, MD, February 2012–October 2012
Created and improved C shell and Perl scripts for Telephone Application (TA) Oracle testing for Federal Bureau of Investigation (FBI), improving testing accuracy by 10%
Loaded terabytes of data from FBI partner sources into Oracle, adjusting data for 100% accuracy
Database Engineer VISION IT, INC., PONTIAC, MI, August 2011–January 2012
Installed and configured HP product Universal Configuration Management Data Base for Quick Provisioning (QP) team testing for Hewlett-Packard (HP) contractors and General Motors, N.A.
Designed and developed tables for QP software using MS SQL Server 2008 R2 in SCRUM environment
Data Analyst TECH OPPS, INC., LANDOVER, MD, 2010-2011
Designed, developed, coded, and implemented data correction scripts with total accuracy for JPAS clearance system using SQL and Perl scripts for Hewlett-Packard
Programmer/Analyst APEX SYSTEMS, INC., BALTIMORE, MD, 2007
Designed, developed, coded, and tested Perl scripts including secure shell data transfer functionality for client PDF processing requests for RR Donnelley
Requirements Analyst/Tester COMMUNICATIONS RESOURCE, INC., MCLEAN, VA, 2006-2007
Managed requirements for web based AQAS (Agriculture Quarantine Activity Systems) for government customers of USDA APHIS PPQ
Access and SQL Database Designer COMPCAMP, INC., SILVER SPRING, MD, 2006
Designed and tested Employee Performance Plan data base using MS Access 2003 for over ten government customers of Director/Office of AIDS Research Office
Requirements Analyst/Tester CHM, INC./FCBS, INC., FALLS CHURCH, VA, 2004-2006
Managed requirements for Worldwide Port System (WPS) and Ocean Cargo Systems Branch projects for Northrop Grumman Mission Systems contractors and the U.S. Army
Prepared and updated engineering change proposal (ECP) process flow diagrams and screen mockups using Visio 2000 and PC Paint
Submitted problem reports (PRs) and associated correspondence using PVCS Tracker, creating and maintaining PR status spreadsheets using MS Excel 2000
Worked for U.S. Bureau of Census to manage requirements for Census Coverage Measurement
Received award for contribution to Information and Technical Solutions Division achievement of CMMI Maturity Level 5 for Software Engineering
ADDITIONAL WORK EXPERIENCE
Principle Designer/Developer (Biofacts Database & Scheduler) THE MARYLAND ZOO IN BALTIMORE
Software Engineer ACS STATE AND LOCAL SOLUTIONS, INC.
Database Engineer THOMSON FINANCIAL/WIESENBERGER
Principal Engineer I BANCTEC SYSTEMS, INC.
Technology Consultant II MANUGISTICS, INC.
Technical Consultant COMPUTER SCIENCES CORPORATION
Senior Software Design Engineer/System Administrator TRIDENT DATA SYSTEMS, INC.
Software Design Engineer MARTIN MARIETTA CORPORATION
Computer Specialist (GS-11) (US Marshals Service, IRMD) UNITED STATES DEPARTMENT OF JUSTICE
EDUCATION & PROFESSIONAL DEVELOPMENT
The University of Maryland, B.S. in Computer Science
The Pennsylvania State University, B.S. in Microbiology
oALL-IN-1 3.0 Application Programming I
oALL-IN-1 Integrated Office System 3.0 Management
oThe Booch Method of Object-Oriented Analysis (OOA)
oObject-Oriented Programming (OOP) with C++
oObject-Oriented Design (OOD)
oADABAS Fundamentals
oLotus Notes 4
oTCP/IP Networking
oOracle Forms 3.0
oNext