.NET 2012/2013, C#, SQL Server 2010/2012/2014Formulate SQL Server Integration Services (SSIS) processes to import third-party data, cleanse, and standardize data elements to improve matching to existing data that resides on a larger scale data warehouse. Improvise general SQL stored procedures, views, and functions that any data source can apply to the ETL process. Develop any data source specific tables, stored procedures, views, and functions required to process the data.Provide expertise and systems support in developing and enhancing business systems to provide new or enhanced products to clients or effective planning, reporting, and analysis tools to internal functions.Formulate and define systems scope and objectives based on both user needs and a good understanding of application business systems and requirements. Devise or modify procedures to solve complex problems considering equipment capacity and limitations, operating time, and form of desired results. Analysis of business and user needs, documentation of requirements, and translation into proper system requirement specifications.Technologies Used: MS SQL Server 2019 | Visual Studio 2019 | SmartGIT | VB Script 2017

Motivate, inspire, and instruct students from age 3 to adult on TaeKwonDo techniques, forms, self-defense drills, and sparring tactics and strategies.

Motivate, inspire, and instruct students from age 3 to adult on TaeKwonDo techniques, forms, one-steps, three-steps, and sparring tactics and strategies.

Created a VB .NET component, utilizing Infragistics controls, to provide users with the ability to build report header hierarchy for existing and new Crystal Reports.Created Audit Tracking stored procedures and database triggers to track user inserts, updates, and deletes performed on particular audited tables.Added an additional tool to the current VB .NET application which allows users to view the audit history of audited tables and provides the ability to undo audits if necessary.Converted VB .NET functionality into SQL Server stored procedure processes to reduce the amount of resources required of the desk top application.Technologies Used: MS SQL Server 2005 | VB.Net 2010 | Team Foundation Server | Crystal Reports 2011 | Infragistics NetAdvantage 2013.1

Application Developer tasked with enhancing a Visual Basic 6 legacy application used for programming, updating, and monitoring irrigation pivot systems. Create a Python module displaying a pie graph depicting field segments that failed validation. Repair the web-based time tracking reports to retrieve the required data.Increased number of available COM portsConverted grouped commands sent to the pivot panels to single commands; retrieving the individual responses for display in the user interfaceIncorporated additional properties made available to usersGained knowledge of the Python programming language in the course of creating a module to display a pie graph indicating which segments of a field that failed validationProvided an easy-to-read graphic to expedite the revalidation process by indicating specific failed location pieces of a fieldInvestigated the reporting structure of the web-based time tracking system; modifying the embedded query criteria to retrieve the appropriate data for each reportTechnologies Used: Visual Basic 6 | Python | C++

Senior System Administrator on the Nebraska Health Information Initiative (NeHII) statewide Health Information Exchange (HIE) responsible for providing a balance of high-level consumer support and hands-on electronic medical records (EMR) implementation assistance to new clients.System administration for the statewide HIE including system configuration updates, security auditing, user access set up and maintenance, and system and application maintenance.Continued communications between clients and vendors providing support and problem resolution of system and application issues.Verify demographic bulk loads and user access Physician Address Book (PAB) data for proper formatting, data type, and data requirements.Monitor user access system requests and user response times two seconds or less; creating weekly, monthly, and quarterly reporting and graphs.Monitor the incoming and outgoing feeds for errors and work with the vendor to resolve any errors or feed issues.Create weekly, monthly, quarterly, and annual reports and graphs depicting the progress and status of consumer consent, the number of reports split by feed, the number of new users, and the number of demographic records by facility.Maintain weekly fact sheet; identifying multiple types of statistical information on the progress of NeHII.Designed, developed, and maintained company websites and maintained the NeHII website.

Designed and developed the EDI processes for ESCO/Marketers electric and gas commodity data communication with Utilities using the state of New York X12 implementation guidelines, XML schemas and files, and MS SQL Server stored procedures and functions. Participated with team members on proposed solutions, analysis, and design issues and suggested solutions, alternatives, and enhancements to improve performance and overall system functionality. Kept open communications with the Client, Account Manager, and Business Analysts to ensure that processes and system functionality were in the best interest not only for the client, but for the over system and company as well. Performed support tasks for all company clients on multiple different platforms including Visual Basic 6, Visual Studio 2005/2008 (VB.NET), Microsoft SQL Server 2000/2005, and Crystal Reporting.

Designed and developed a VB 6/MS Access 2002 Defect Tracking and Reporting application utilizing the Data Environment and Data Reporting tools which assisted managers to pinpoint outages and system downtimes. Designed and developed a VB AdHoc Query tool for developers that emulated existing Oracle tables to assist in the creation of SQL statements which could then be integrated into VB Code.Supported the Workflow Information Tracking System (WITS) that was put into place for the financial institution to track checking, savings, consumer loan, and mortgage information through a VB user interface utilizing mainframe data, Oracle stored procedures, and FIleNet imaging, faxing, and documentation. Redesigned and developed the WITS VB interface to accommodate the new HTML mainframe system. Using a Web Browser control to provide the ability to utilize data on the mainframe without losing functionality was an integral part of expanding the WITS interface and improving productivity.