Software Developer Sql Server

Keith A. Sellers

Software Developer

336-***-**** ******************@*****.***

SUMMARY

●As a seasoned Database Administrator and Software Developer with over 11 years of experience specializing in database design, implementation, and optimization. I have a proven track record of managing complex database systems such as SQL Server, MySQL, and Oracle, while leveraging advanced tools like SSMS, SSRS, and SSIS. Over the course of my career I have gained expertise in designing and optimizing relational databases, writing efficient T-SQL scripts, and ensuring data integrity and scalability across multiple environments.

●Adept at troubleshooting, managing database schema changes, and working with cross-functional teams to deliver optimized data solutions. I have also led ETL processes, built complex reporting tools, and normalized legacy database structures to improve performance. My experience spans industries, having worked in remote teams and contributed to database administration projects in both Agile and Waterfall environments. I hold a Bachelor's degree in Computer Science and bring a solid foundation in database management, application support, and technical leadership.

●With excellent problem-solving skills and a collaborative approach, I have consistently implemented large-scale database systems, integrated multiple applications, and delivered high-quality data solutions that meet organizational objectives.

TECHNICAL SKILLS

●Software: SSMS(SQL Server Management Studio),SSRS(SQL Server Reporting Services), SSIS(SQL Server Information Services), MS Word Suites (Word, PowerPoint, Excel, Outlook, Visio), Microsoft Office, Microsoft Project, Microsoft Visual Studio, Visual Studio Code, JIRA, Bitbucket, GitHub, Confluence, SQL Server, Visual Studio, Notepad++, Github desktop, IIS, MySql Workbench, MySQL server, AWS(EC2,SMS,S3,Elastic Beanstalk)

●Databases: Oracle, MYSQL, T-SQL, MS SQL

●Programming Languages: .NET Core, ASP.NET, .NET Nuke (DNN), Java, JavaScript, JQuery, HTML/5, XHTML, SQL Server, MYSQL, CDA,CPT, CSS, C++, C#, LESS, Sass, MATLAB, Perl, PHP, Python, AJAX,VB6, VB.Net, Visual Basic, ASP.NET MVC, Vue.js, Node.js

●Frameworks: Bootstrap, AngularJS, Telerik, Kendo UI, Android SDK, Entity Framework, TFS, OOP, Blazor

●Operating Systems: Windows 8/10, iOS, Linux

●Methodologies: Agile/SCRUM, Waterfall/Iterative

EDUCATION

●Bachelors of Science in Computer Science

UNC-Charlotte- May 2015

oMajor: Computer Science, Minor: Mathematics

oG.P.A in Major: 3.14

●Related Coursework

oDatabase Design & Implementation, Software Engineering, Web Development, Software Architecture & design, Software Project Management, Mobile App. Development(IOS & Android)

EXPERIENCE

WTIWireless - Frank Lee/ Bob Gilbert 05/2023 - present

Calabasas, CA - Remote

Full Stack Developer

●Full-stack Development: Utilize your extensive knowledge of Vue.js, C#, .NET, SQL Server, and Visual Studio to develop highly functional and responsive web applications. Implement front-end and back-end features, integrate APIs, and optimize application performance.

●Migrated 50+ legacy VB.NET endpoints to a modern Vue.js MVC .NET Core application using C#, seamlessly integrating with SQL Server to enhance the backend functionality of a wireless telecommunications customer portal, improving performance, scalability, and maintainability.

●System Design: Collaborate with cross-functional teams, including UX/UI designers, product managers, and fellow developers, to design scalable and efficient software systems. Participate in architectural discussions, contribute innovative ideas, and ensure adherence to best coding practices and industry standards.

●Code Review and Quality Assurance: Conduct thorough code reviews, identify potential bugs, and suggest improvements to ensure high-quality code. Implement testing strategies, including unit tests, integration tests, and end-to-end tests, to maintain software reliability and robustness.

●Database Management: Design and maintain SQL Server databases, ensuring efficient data storage and retrieval. Write optimized and secure SQL queries, implement database schema changes, and optimize database performance.

●Troubleshooting and Issue Resolution: Investigate and resolve complex technical issues, both independently and collaboratively. Use your analytical skills to diagnose problems, propose solutions, and implement fixes promptly.

●Collaboration and Teamwork: Act as a mentor and provide guidance to junior developers, fostering a collaborative and knowledge-sharing environment. Contribute to agile development methodologies, participate in scrum meetings, and actively communicate with team members.

●Research and Continuous Learning: Stay updated with the latest trends and advancements in web development technologies, frameworks, and tools. Conduct research to identify potential areas for improvement and propose innovative solutions to enhance our software offerings.

●Documentation: Maintain comprehensive documentation of code, processes, and project-related information. Ensure that documentation is accurate, up-to-date, and easily accessible to team members.

Environment: C#, .NET Core,VB6/VB.NET, ASP.NET MVC, Visual Studio, Azure DevOps, TFS(Team Foundation Server), T-SQL, SQL Server 2016, Sql Server Management Studio, HTML5, Jquery, Javascript, SAS, GIT, Vue.js

Mark Farrah Associates - Joshua Fredrick 9/2021 - 05/2023

Pittsburgh, PA - Remote

Senior Software Developer

●Responsible for the Upgrade of Mark Farrah Associates’ (MFA) suite of data analysis Portals(80+ pages) and admin tools(25+ pages) from legacy ASP.NET 4.7 to .NET Core 3.1. this included the reconfiguration/re-implementation of Identity Framework for the purposes of ETL with our in house User profile data as well re-writing all legacy web-forms pages in .NET Core utilizing Blazor with Telerik UI to create the front-end views.

●Created a modern timesheet application/calendar in .NET Core that allows users to view a calendar and input the work for the day(s); also created an api endpoint where users can interact with all of their time sheet data(created this for the purposes of admin who used excel)

●Collaborate on the design, development, administration and maintenance of Mark Farrah Associates’ (MFA) suite of data analysis Portals, internal Admin Tools, Corporate Website and backend SQL databases.

●Create and maintain complex TSQL Scripts and Stored Procedures for the purpose(s) of ETL (Extract, Transform & Load) processes, MFA internal reporting, and primarily for MFA’s products. Also responsible for running and monitoring data production procedures to ensure efficient processes and data integrity.

●Develop technical and functional requirements from business specifications and ultimately transform these requirements into functional application code.

●Ensuring the quality of applications through formal testing practices and documentation including unit testing, regression testing, load/stress testing, performance testing, and use cases.

●Building data validation/verification tools to ensure quality control of database updates that support MFA products as well as assisting in infrastructure maintenance and oversight of outsourcing relationships.

●Created a timesheet application/interface for employees to enter their time as well as a web API where users could view timesheet reports in either excel or web form if desired.

Environment: C#, .NET Core, ASP .NET 4.7, ASP.NET MVC,VB6/VB.NET, Visual Studio, Azure DevOps, TFS(Team Foundation Server), T-SQL, SQL Server 2016, Sql Server Management Studio, HTML5, Jquery, Javascript, SAS, GIT, Blazor

High Point University - Robert Sawyer 3/2021 - 9/2021

High Point, NC

Systems Specialist(6 month contract)

●Responsible for the administration, business analysis, relational database normalization, data management, configuration, maintenance, database management and optimization of enterprise level applications that support critical operations and instructional services.

●Generated data analytics based on the query execution plans for our internal data warehousing scripts as a case-study to justify creating a normalized and optimized data structure in its place.

●Supporting and implementing multiple applications and data integrations while maintaining a highly available environment and conforming to established change management protocol.

●Also tasked with documenting known issues, solutions, configuration items, data integrations, and system information along with working within the team and actively supporting each team member and their initiatives.

●Leveraged analysis skills to evaluate the overall state of our data structures and provided recommendations of how to optimize re-implement with minimal downtime to customers.

●Charged with normalizing aging data objects in SQL server as well as documenting the new and improved normalized structures. Along with normalizing data objects another large part of my day-to-day consisted of improving the performance and scalability of existing relational databases or objects for the purpose of more usable and faster generating SSRS reports.

●Entrusted with creating data integrations in SSIS by leveraging batch scripts that would call my Python code responsible for sanitizing, processing data and handling any errors or exceptions that may arise.

●Demonstrated the ability to lead small hybrid teams of developers and coordinate them across various projects and clients.

Environment: PHP, Python, SSRS(SQL Server Reporting Services), SSIS(SQL Server Information Services), T-SQL, SQL Server 2012, Sql Server Management Studio, HTML5, Jquery, Javascript, MySQL, JIRA(Confluence, Bitbucket, Sourcetree), ServiceNow, GIT, AWS

Kreber - Mike Walters 7/2019 - 3/2021

High Point, NC

Senior Developer & Digital Strategist

●Contributed revenue generating ideas and implemented data driven solutions for digital marketing and growth challenges of our clients.

●Responsible for grooming tasks for our remote developers and executing code reviews and QA of tasks worked on.

●As a Senior Developer I also spend a great deal of time creating various database objects with T-SQL to feed the PHP applications I develop. Also responsible for establishing department-wide technical standards regarding the release, deployment and testing of our applications. Within those applications I implemented interfaces designed by our creative team with PHP,CSS, HTML, and JQuery. All of our websites were designed from a “mobile-first” perspective that put cross-browser compatibility at the forefront and ensured clients would get the same experience across platforms.

●Developed various interactive solutions and content management systems(cms) that allowed customers to manage the static content of their websites through admin web pages I had created specifically for them. The content uploaded/managed included documents(pdfs,word), images, videos, spreadsheets, and even a .iso in one obscure case!

●Created process models for guiding customers through various furniture configurations, options and fabric combinations; then later used the logic from the process model to implement a full-on furniture configurator.

●Contributed to all parts of the software development lifecycle - idea inception, focus groups, development, testing, marketing, release/delivery, deployment.

●Lead projects to further enhance our clients customer service and revenue generation via the digital components/applications we create.

●Worked with clients to gather and document technical requirements and then translate these requirements into technical specifications that I then later developed and provided quality reporting of KPI’s and engagement metrics.

Projects: templefurniture.com, parkersouthern.com(temple’s sister website), templeportal.com(admin/customer portal)

Environment: PHP, SASS/LESS, T-SQL, SQL Server 2012, Sql Server Management Studio, HTML5, Jquery, Javascript, MySQL, Jquery, JIRA(Confluence, Bitbucket, Sourcetree), AWS(Cloud Computing, EC2, S3, SMS), GIT

City Of Greensboro - Aimee Walker 8/2017 - 7/2019

Greensboro, NC

Senior Application Developer

●Responsible for upgrading the City Of Greensboro Privilege License/Business Permit legacy Classic ASP website as well as reports to modern .NET Core RC1 and eventually the initial full release of .NET Core. This included the overhaul of legacy multi-form web pages into clean, modern, light node.js user interfaces along with the creation of application controllers that function as Data access to pipe the data to our UI.

●Leveraged C#/.NET to create automated unit tests as well as UI tests using Selenium Grid, before committing any code to the repos as we utilized automated build with Jenkins.

●Run and monitor software performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging.

●Provide user assistance and maintenance to other Web-based systems used within the City.

● Provide technical support to various City Departments for system integration.

● Assist in the development and maintenance of user manuals and guidelines.

●Provide technical support in all areas of design and development.

●Manage project schedules and deadlines.

●Responsible for heading up projects to further enhance our customer service in the area of Web-based programming.

●Worked with customers to gather and document functional & business requirements and then translate these requirements into technical specifications.

●Functioned as a SME for the internal development team for the purposes of designing technical solutions to the issues our customers presented.

●Familiar with the full cycle of project development, implementation, testing and support (SDLC).

●Also responsible not only for managing these projects, but also for writing the code and supporting the applications.

Environment: C#, T-SQL, Microsoft TFS(versioning/source control), SourceSafe, Azure DevOps, Jenkins(automation), SQL Server 2017, SQL Server 2008, SQL Server 2012, Sql Server Management Studio, Crystal Reports XI, VB6, VB.Net, Visual Basic, ASP.NET 4.5.2, .NET Core, HTML5, Jquery, Javascript, GIT

Boulton Creative - Beth Boulton 9/2016 - 8/2017

Greensboro, NC

Full-Stack Developer (Freelance/1099 role)

●Responsible for designing as well as the front-end development of websites for various clients through WordPress. All websites were developed with cross-browser compatibility in mind and implemented contemporary mobile responsive designs to accommodate this.

●Accountable for back-end/server-side development including MySQL as well as SQL Server Management.

●Created analytical landing pages to record data for email/marketing campaigns based on the business analytics and KPI’s provided by the customer.

●Also created admin pages that provided analytical tools for interpreting the data collected during email/marketing campaigns.

●Responsible for cms development in terms of creating CMS like interfaces where users could change or add various static content to their websites.

●Wrote code to extend the functionality of various WordPress plugins and the accompanying front-end development to implement the user interface where necessary.

●Gather business requirements and translate to technical specs

Projects:

●http://www.greensboro.edu

●http://www.reddogfarm.com

●http://www.barronberry.com

●http://www.johnscreekresearchclinic.com

Environment: HTML5, JavaScript, JQuery, PHP, CSS, LESS/SASS, vue.js, Bower, Bootstrap, MySQL, Bitbucket, Gulp, Windows 8/10, MAC

Pay Tel Communications - Steve Stanley 5/2016 - 8/2016

Greensboro, NC

Software Developer(3 month contract)

●Developed a web application that would allow users to interact with a web-service that managed inmate device data.

●Worked in an agile environment with Daily stand-ups, story points, sprint-grooming/planning and bi-weekly demos.

●Implemented and managed various APIs for serving up device data to be presented in our admin device management application; also responsible for the design of the user experience from an aesthetic standpoint as well.

Environment: Agile, C#, .NET Core, AngularJS w/Typescript, JavaScript/JQuery, HTML5, CSS, Telerik Kendo UI, Entity Framework, Gulp, docker, css3,VB6/VB.NET, JIRA, Bitbucket/GitHub, Confluence, Windows(8/10)

Moore Creative – Ryan Moore 12/2014 – 10/2015

Huntersville, NC

Web Developer(6 month contract ext.)

●Developed web-pages and web applications utilizing DNN (.NET Nuke), JavaScript/JQuery, Angular JS, HTML5, CSS, as well as SQL.

●Used SQL to manage slide-shows (rotators), setup user profiles, populate media galleries, as well as various content managers.

●Wrote different types of queries: SELECT, CREATE, INSERT, DROP TABLE, INSERT, INNER JOIN, etc. in order to achieve the above results.

●Generated reports for web administrators.

●Created web pages with cross-browser compatibility and mobile responsiveness in mind; utilizing bootstrap or PureCSS.

Environment: .NET Nuke (DNN), JavaScript/JQuery, HTML5, CSS, SQL, Windows 8/10, C#, NPM

ProctorFree – Jason-Wills Starin 8/2014 – 10/2014

Cornelius, NC

Software Engineer(3 month contract)

●Developed and maintained various Java applications and servlets.

●Utilized various Java/C++ libraries in order to allow for seamless cross-platform performance of our applications.

●Answered and assisted with technical calls related to the software.

●Created a voice recognition application/add-on for our software with Java.

Environment: Agile, Java, JavaScript, C++, HTML5, CSS, Windows 8/10

RELEVANT PROJECTS

Augmented Reality Silverage Comic Book Collection (Software Development Projects)

●Utilized the Xbox Kinect and C#/WCF forms in order to develop a gesture based comic book collection for browsing the collection and reading the comics.

Smart Parking Gate (Digital Image Processing)

●Created a MATLAB application that took advantage of various digital image processing techniques that would take pictures of parking passes, license plates, and vehicle emblems and verify if the vehicle in question matched the parking pass and vehicle make in our database. Basically simulating a smart parking gate.

Movie Rental Interface (Design & Implementation of Databases)

●Developed a Java application with a MYSQL oracle database that allowed for users to look-up, return, or rent movies from our movie collection. The interface was implemented utilizing the Java GUI class and a MYSQL database.

FREELANCE PROJECTS

Crafted: Build Your World 1/2016 - 5/2016

●Using the Unity3D IDE I developed a Minecraft-Like IPad game that included some basic multi-touch features for moving, looking, etc. Within Unity3D I wrote a number of different C# scripts to add realistic physics to various game objects.

Oxford Bible Church Video Gallery 10/2016 - 11/2016

●The application would read a provided VAST URL-string that contained the data which corresponded to the particular list of ads to be played.

World Trivia App (Personal Mobile Application Development) 2/2015 - 3/2015

●Developed an Android app in Android Studio that would parse a XML file of trivia questions and other related information then render the question along with image(s) and answer choices. The app would also keep track of your scores and give the user the option to try again if their score was low

UNC-Charlotte Photo Gallery Application (Personal Mobile Application Development) 3/2015 - 4/2015

●Basically an application that would parse a given JSON file for photo paths and then would render the photos as a gallery. Each gallery would have a main gallery image, then upon clicking that image the user would be allowed to browse the other images associated with a given gallery.

analytical software

Subject matter expertise

database management systems

coding

SAS

SAS

interactive solutions

Contact this candidate