| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Power Bi Sql Server, SQL Developer, ETL Engineer, Data Architect Jacksonville, FL Sql Server Dba Saint Johns, FL Senior MS SQL Server DBA Gainesville, FL Data Analyst Sql Server Jacksonville, FL Software Engineer Sql Server Jacksonville, FL Java full stack developer Jacksonville, FL java developer St. Johns, FL |
|
Click here or scroll down to respond to this candidateCandidate's Name
MS-Access / SQL Server Developer & Database AnalystEMAIL AVAILABLE PHONE NUMBER AVAILABLELINKEDIN LINK AVAILABLE FL, Street Address , USHighly 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 ExperienceState of Illinois DCFS (for 22nd Century Tech.) Nov. 13th, 2023 June 27th, 2024MS-Access / SQL Server Developer / DBA - Remote WorkEngaged 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, 2023MS-Access / SQL Server Developer / DBA - RemoteRevitalized 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, 2023MS-Access / SQL Server Developer / DBA - Remote WorkDelivered 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, 2021Sr. 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, 2020SQL Server Developer / DBAMigrated 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, 2019Business AnalystServed as key member of banks Fund Administration organizations 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, 2018Sr. 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 2018Sr. 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 2017Sr. 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 2017Sr. 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 2016Sr. 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 2015Sr. MS-Access Developer/Consultant/Configuration ManagementOptimized 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 2015Visual 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 2015Sr. 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 2015Sr. 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 2014Access / SQL Server / Data Warehouse Developer, Capital Stress Testing via Global Technical TalentMaintained 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 ExperienceDevelopment Team Lead / SME / Business Analyst / Data Architect (Oracle) via UST Global Independence Blue Cross Philadelphia, PASr. Microsoft Access/Excel/SQL Developer via TEKSystems Ahold Financial Services Carlisle, PASr. Microsoft Access Developer via Sun Technologies, Inc. Lockheed Martin King of Prussia, PASr. Microsoft Access/SQL-Server Developer IT Impact Hershey, PA / Chicago, ILSr. Microsoft Access & SQL Server Developer via Sysmind, LLC PA Dept. of Public Welfare BIS Harrisburg, PASQL Server Programmer/Analyst / PHP Developer via Modis Paytime Payroll Mechanicsburg, PAConsulting VB.Net & MS-Access Developer via Modis Sovereign Bank/Santander Reading, PASr. Microsoft Access Developer via TEKSystems AHold USA Financial Services Carlisle, PAData Analyst via TEKSystems AmeriHealth Mercy Harrisburg, PAMicrosoft Access/Excel Developer via Sapphire Technologies Bank of America Newark, DEConsulting Microsoft Access/Excel Developer via JFC Staffing Foot Locker, Inc. Camp Hill, PA corporate officesConsulting Sr. Microsoft Access/Excel Developer via Arcus HIGHMARK, Inc. Camp Hill, PASr. MS Access Developer/SQL Server Developer/Data Architect via CompTech Associates, Inc. HESS Corporation Woodbridge, NJConsulting Microsoft Access Developer via iSpace, Inc.DaVita Berwyn, PAConsulting Microsoft Access Developer via Modis, Inc. Nationwide Better Health, Inc. Columbus, OHSenior Microsoft Access Programmer / Analyst via CompterAid, Inc. The Hershey Company Hershey, PAConsulting Microsoft Access Programmer/Analyst Legal Medical Staffing, Inc. Voorhees, NJSr. Programmer / Analyst Harrison Career Institute Voorhees, NJConsulting Microsoft Access Programmer/Analyst Stanley Tools, Inc. Louisville, KYProgrammer/Analyst Westmoreland Mechanical Testing & Research, Inc. Latrobe, PAOperations Manager/COO Family Internet, Inc. Pittsburgh, PANetwork Engineer / Application Support Engineer CADVANSYS King of Prussia, PACAD / Visual Basic Programmer Ewing Cole Cherry Brott Philadelphia, PACAD Programmer / Systems Manager Nelson & Associates Philadelphia, PACAD Programmer/Network Support Engineer The Kling-Lindquist Partnership (TKLP), Philadelphia, PACAD / Database Programmer Geonex Vernon Graphics Norristown, PAComputer Center Operations Staff Foster Medical Corp Blue Bell, PAComputer Center Operations Staff SEI Corporation King of Prussia, PAEducationExeter Township Sr. High School - GraduatedAlbright College - Main Campus part-time studies to supplement High SchoolDrexel University Full-time studies in Computer EngineeringPenn State University - Berks Campus part-time studies in Computer ScienceHarcum Jr. College Certificate: AutoCAD/AutoLisp ProgrammingCertificationsCertified Solmon IV Systems EngineerMCAD VB.Net / MCP Microsoft Certified Application Developer / Microsoft Certified ProfessionalAwardsOwner LinkedIn.Com group: Professional Microsoft Access Developers Network [PMADN], 2008Nominated for Microsoft Access MVP award, 2012.Microsoft Community Contributor Award for supporting Access Developers in Public forums, 2011 |
