Sql Server Software Engineer
Resume:
Edward Thomas
**********@*****.***
(primary) 412-***-****
Pittsburgh, PA 15212
www.linkedin.com/in/edward-thomas-b1034913
Security Clearance: Secret (Active)
EXPERIENCE
SUMMARY:
Perform multi-platform full life-cycle software development including business rule identification through interfacing with business management, methodology experts and end-users and technical specifications, application design, construction, and testing.
Complete relational database modeling and construction in MS SQL Server, MySQL, Oracle, and MS Access. Data conversions programs are written and run to migrate to new systems. TFS, Git version control systems are used.
Designed and developed websites and applications using CMS, PHP (OOP), XML, WAMP, XAMPP, SQL, C#, MVC 5, Visual Basic, ASP.NET, and Python.
User Interface (UI) designs were completed in HMTL, JavaScript (jQuery, AngularJS, React), AJAX, and CSS. Wireframes were provided. Bootstrap framework was used for mobile development.
Continuous training in technologies: C#, Python, Machine Learning, Artificial Intelligence, and Blazor.
COMPETENCIES:
• Software Development (20+ years) • Web Development (20+ years)
• Database Design and Development (20+ years) • Research Analysis (20+ years)
• Software Engineering (20+ years) • Data Analysis (20+ years)
• Data & Database Conversion (20+ years) • Systems Administration (5 years)
• Project Management (10 years) • Information Assurance (1 years)
SUMMARY OF SKILLS, TOOLS, AND TECHNOLOGIES:
Programming Languages: Visual Basic (20+ yrs), SQL (20+ yrs), HTML (20+ yrs), PHP (15 yrs),
JavaScript (10 yrs), CSS (10 yrs), C# (8 yrs), XML (8 yrs), AJAX (5 yrs), Python (5 yrs), JSON (4 yrs), jQuery (3 yr), T-SQL (2 yrs), ColdFusion (2 yrs), Perl (1 yr), AngularJS (1 yr)
Databases: MSSQL (8 yrs), MySQL (13 yrs), Oracle (5 yrs), and MS Access (19 yrs)
Frameworks: ASP.Net (9 yrs), MS MVC (7 yrs), CodeIgniter (2 yrs), CMS (Joomla, Drupal) (1 yr)
Operating Systems: Windows (20+ yrs), WAMP (13 yrs), XAMPP (13 yrs), Linux (7 yrs)
CERTIFICATIONS:
Project Management Professional (PMP)
Microsoft Certifications: E011-2854, E010-1469, E009-4323, E007-6223
oMicrosoft Certified Professional Developer (MCPD): NET, WIN
MCPD: ASP .NET 4.0
oMicrosoft Certified Technology Specialist (MCTS): WCF, WPF, ASP
MCTS: Web Applications Development 4
MCTS: Accessing Data (ADO .NET) 4
MCTS: Windows Communication Foundation 4
DETAILS
Project Manager / Research Analyst / Software Engineer
Abovo Technical Services, Pittsburgh PA.
February 2024 – Present
Managed staff DevOps team to update and maintain SQL Server databases using SSMS and networks. Updated databases processes to operate in industry best practices. Increase space efficiency by up to 50% using GFS database backup procedures.
Crafted a plan to create and implement a SQL Server test environment that was brought online protecting the production system from maintenance and user errors causing downtime.
Carried out code reviews for C# and T-SQL programmers. Oversaw code development pipeline using Azure DevOps.
Created PowerApps applications using SharePoint lists.
Build a suite of SQL Server Instances. Implemented Ola Hallengren scripts for GFS back up system. Created job run in SQL Server Agent and System Scheduler with code residing internal to the jobs and externally in PowerShell (ps1) files.
Created a .NET 8 API that created and supplied critical information triggered by and stored in the SQL Server econsystem.
Created VB scripts to transform data into system ready formats.
Coded features and maintained Angular applications.
Conducted research: Utilizing open-source media reporting and criminological data to identify commonalities in terrorist activity patterns within 20th century America.
Analyzed qualitative data: Including frequency, period, sequences, and absence, revealing a strong correlation between incident patterns and time-series and longitudinal analysis of media reporting.
Utilized CP Office Automation: Created document management system in VB, Access.mdb for tracking and analyzing data resources.
Cognitive Insights initiative: In Visual Studio IDE utilizing .NET 8 to further data mining efforts I created a C#, .NET Core application attached to a SQL Server DB via Entity Framework to perform file I/O operations utilizing asynchronous APIs to analyze, integrate and summarize proprietary information using AI applications such as ChatGPT and Gemini.
Media Inventory system: In Visual Studio IDE utilizing .NET 8 and using C#, Blazor, Bootstrap, and SQL Server DB, I created an inventory to track reviewed media products in .NET Core.
Software Engineer
Dynamics, Inc., Pittsburgh PA.
May 2019 – January 2024
REPAK (Ecommerce Application): Designed and developed a robust ecommerce application using C#, .NET 6 (MVC, API, WPF), SQL, AWS, Docker, MySQL, and JSON. Integrated with Avalara API for tax automation. Carried out CI/CD processes in AWS.
Market Basket Analysis: Leveraged Python, MySQL, machine learning, NLP, AI, and TensorFlow 2.0 to analyze customer purchase patterns and provide actionable insights.
EPACK (Ecommerce Application): Developed and maintained an ecommerce platform utilizing C#, .NET (MVC), SQL, AWS, React, CSS5, and Bootstrap. Front-end UI/UX development included mobile screen implementations.
Benchmark DB: Conducted a benchmarking study recording the performance of MySQL, PostgreSQL, and TimescaleDB using Python scripts and SQL queries. Authored a report documenting the findings.
Kind-Tap (Financial Application): Developed a proof-of-concept financial application using MS Excel, then built a production-ready application with C#, .NET 6 (MVC, API), .NET Core, SQL, MySQL, and JSON within an MVC architecture. Implemented unit testing for robust code quality.
Owner / Project Manager / Software Architect
Abovo Technical Services, Pittsburgh PA.
March 2008 – April 2019
Managed medium sized teams in all aspects of the software development lifecycle, including business idea generation, planning, development, and deployment. Held meetings to update the staff of correct processes and procedures with technology concerns. Communicated best practices and project goals and timelines to the development team. Oversaw all hiring activities.
Led and mentored development teams, assigned tasks, and ensured timely project completion.
Designed and implemented various web applications using LAMP and Windows stacks, incorporating technologies like PHP, MySQL, SQL, ASP.NET MVC, jQuery, and AngularJS. Many applications were attached to SQL Server DBs via Entity Framework.
Developed and maintained CMS websites using Drupal, Joomla, and WordPress.
Built quantitative trading programs using Python, SQL, MSSQL and MySQL to analyze stock data and execute trades.
Director of Information Systems, Interim; Senior Consultant
PATF, Pittsburgh PA.
July 2014 – June 2015
Managed a team in all aspects of the software development lifecycle (business idea generation, planning, development, deployment) and a team of networking contractors. Held meetings to update the staff of correct processes and procedures with technology concerns.
Conducted a comprehensive business process analysis to identify areas for improvement and recommend software solutions.
Successfully implemented a new client services software system, resulting in increased productivity and improved service delivery.
Managed IT infrastructure, including Active Directory, MS Exchange, SonicWall, and Symantec Backup Exec.
Enhanced the Phoenix Data System and Prevention application with new features and functionalities using VB and SQL.
Led the hardware procurement process, ensuring alignment with organizational needs, budget constraints, and HIPAA regulations.
Senior Consultant; Lead Software Engineer
Booz Allen Hamilton: Lexington Park MD.
October 2011 – February 2014
Army Information Technology Agency (AITA): Analyzed and documented the business process for cost modeling and customer obligations. Designed and developed the DSIAS system using OCR technology to automate contract data entry, resulting in significant time and cost savings. Upgraded and maintained the Pricing Tool (PT) application using VB, Access, Adobe, and SQL Server.
Pentagon, USMC: Developed the BIC Inventory system for the US Marine Corps using MS Access, XML, and VBA. Designed and prototyped a web-based version of the BIC system using C#, MSSQL, and Visual Web Studio.
NAVAIR (DECKPLATE): Worked on web applications utilizing Cold Fusion, JavaScript, C#, HTML, MSSQL, and SQL with an Oracle database to track and report equipment maintenance. Implemented security enhancements to the MEASURE system to mitigate cyber threats like CSRF attacks and SQL injection.
EXTENDED DETAILS:
WEBMASTER: Personal Website: burgthumper.net
OWNER: Fineview Inn, LLC
Training:
Windows Server 2019 Administration, Active Directory and Windows Server
Udemy: C#, Python, Machine Learning, Artificial Intelligence - 2020-2022.
HIPAA & Information Assurance and Security Certifications, DoD - 2010
Microsoft SQL Server: Data Warehousing, OLAP cubes and ETL, Skill-Port - 2010
EDUCATION:
Masters Certificate in Cyber-Security Technologies, University of Maryland University College 2013
Bachelor of Science in Mathematics/Economics. University of Pittsburgh.
Contact this candidate