SUMMARY:

• A seasoned “ Full Stack ” Microsoft solutions expert with over 17 years of experience planning, developing, testing, implementing & supporting complex fully customized Microsoft .Net based solutions for clients serving a multitude of industries such as: HealthCare, Telecommunications, Manufacturing, Accounting, Sales, Marketing, Small Business, Point of Sale, Business Intelligence, Statistical Analysis, Public Health, and many others and most were Confidential 500 companies
• Extensive involvement in every aspect of the software development life cycle from: research development, proof of concept, requirements gathering, database design, data collection & ETL processes, application architecture, server specifications & implementation, complete application development, QA/UAT testing, build and release management, change control, and continued production support.
• Experience in all roles: Engineer, Architect, Team Lead, Developer, Database Administrator, and Project Manager; often simultaneously within structured environments of varying degrees on teams large and small. Several including the most complex were developed exclusively from complete scratch every: requirement, design, line of code, test plan, document, script, image, style sheet, etc. also managed project.
• Professional experience and talents aren’t enough to satisfy curiosity, passion, drive and certainly don’t end at five o’clock. This passion and effort is responsible for becoming an avid guitar player and singer frequently performing locally. Personally restored an extremely rusted 1973 VW Beetle to show car quality restoration, welding, construction, woodworking, computers from the age of 7, describes the personality and vast knowledge, skills, talent, and assets that are being brought to the table.

TECHNICAL SKILLS:

• Telecommunication, Manufacturing, Healthcare, Consulting, Technology, Product Placement, and POS Point Of Sale
• ASP.Net: Web Forms, MVC 2 & 5; Classic ASP: Intranet, .COM, Mobile, GUI Design, Custom Server Controls
• Windows Forms, Windows Services, Web Services, Console Application Development
• High Performance Multi - Threaded Service Oriented Applications & Services
• Server Clustering, Fail over & Load Balancing (SQL & Web)
• Full SDLC Software Development Lifecycle Methods: Agile, Scrum, Waterfall, CMMI
• SOA Service Oriented Architecture: XML, jSON, REST
• C#, VB.Net, Frameworks: 1.0, 1.1, 2.0, 3.5, 4.0, 4.5
• ASP.Net: WebForms, MVC 2, MVC 5
• HTML, JavaScript, AJAX, XML, XSL, jSon, jQuery, RESTful
• MS SQL Server: 2016, 2012, 2008, 2005, 2000, 7.0, 6.5; Installation, Administration, Clustering, Development
• Oracle 9i, 10i; PL/SQL
• OLTP, OLAP, ETL: SSIS, SSRS
• ADO.Net: Entity Framework, LINQ, JSON
• Data Warehousing, Data Modeling
• Visual Studio 2015, 2013, 2012, 2010, 2008, 2005, 2003, 2002, 6.0
• Microsoft SourceSafe, TFS Team Foundation Services, GitHub
• Crystal & SQL Reports; Telerik, Infragistics Controls, Visual AccountMate, ACCPAC.
• OnBase, FACETS, EAM

PROFESSIONAL EXPERIENCE:

Confidential, Annapolis Juntion, MD

Software Engineer / C# Developer / SQL DBA / Project Manager

Responsibilities:

• Designed & Implementation of a SQL & C# based check Processing system that took data exported from a CMS system (Centers for Medicare & Medicaid Services) known as CRIS. The data came without addresses most of the time therefore I had to poll 4 disparate systems using either the Provider Medicare ID or NPI (National Provider Identifier) in order to find the all possible options for a mailing address. Address options were then presented in an interactive report allowing the user responsible and most knowledgeable to choose the correct address. The end result of this system was a proprietary text based file format that was then exported to ADP for checks to then be printed returning a positive pay file which then was imported back into the database completing the process.
• Worked on another application rewrite which the mailroom used to enter incoming mail primarily primarily medical records which were entered into this system and linked with the parent case record in the medical review system and created a cover sheet with barcodes; digitized the medical record which completed the case intake process. These cases consisted of either Quality or Appeal submitted to Confidential for third party review by our professional medical staff; this service being the primary source of revenues for the company.
• As a project manager participated in the CMMI Level 3 certification audit process which Confidential was seeking CMMI Level 3 status sought after in order to open the tap for vast amounts of contracts with CMS (Centers for Medicare & Medicaid Services). Authored various templates, complete documents, set standards and requirements, procedures, best practices, and was interviewed multiple times and was a key person throughout the audit process performed by an outside company BroadSword which ultimately was successfully attained.

Skills: Visual Studio 2015, C#, SQL Server 2016, SSIS, T-SQL, Agile, TFS, CMMI (Level 3)

Confidential, Pasadena, MD

SQL DBA / SSIS Developer / Team Lead / Application Creator

Responsibilities:

• Worked on the large city & county wide DPW project upgrading manual “sight on site” read mechanical water meters with the latest networked digital read meters primarily installed by industry leader iTron also provider of the new meter management software.
• Built all ETL processes using SSIS, C#, XML/XSD, Flat Text File, sFTP to interconnect existing systems primarily legacy billing system with the new ChoiceConnect software used by iTron to communicate with the new digital meters as well as identify new meter installations.
• Test Driven development using Agile, VS2013, SQL Server Projects and Microsoft TFS Team Foundation Services.
• Team lead responsible for all code and generating & managing deployments, generating change control reports, and release notes.

Skills: SQL Server 2012 & SQL Azure Cloud, SSIS, T-SQL, Visual Studio 2013, C#, XML/XSD, Agile, TFS, SSRS, sFTP, SQLPROJ, Source Control.

Confidential, Glen Burnie, MD

Senior Solutions Developer (DBA, SQL, SSIS, C#)

Responsibilities:

• Designed & Implemented new architecture to an existing outgoing postal mail data export system only supporting a single row dimension incapable of supporting line item detail for display grid format.
• Under the new architecture the system could now accommodate a more robust & complex letter/check that could use multiple records from one or many sources to populate line item detail, grid, or other dynamic formats
• Implemented dozens of new letters and checks each had their own sql proc to query its specific datasource and criteria collectively known as "triggering logic" inserting results to a shared letter extract staging table each row generating a letter. Any requiring detail line item rows were inserted to their own separate staging table both store captured data for mail merge in generic shared format with ambiguous column names and data types for easy reuse and not requiring the export format to change each time.
• Designed architecture for integrating a new exception handling process that would capture issues in the source data prior to and exclude problem data from being exported & posted.
• Built a high performance multi threaded C# web service & console application which pulled image files out of the OnBase Document Management Server of specific pages from the original new member paper application submitted and combined them into a new PDF document. A batch would run for a few hundred files at a time and place into a single zip file that was then uploaded to our print vendors ftp site along with normal mail merge data extract containing letters which references pdf file attachment to put it the same envelope. I used .Net 4.0 System.Threading.Tasks namespace new in 4.0 and it proved to be faster and simpler than older methods prior to it.

Skills: MS SQL Server 2005-2008, SSIS SQL Integration Services, Visual Studio 2005 & 2008, C#, OnBase, FACETS, EAM, CMS, Microsoft Office

Confidential, Baltimore, MD

DBA / SQL & SSIS Developer / Application Developer

Responsibilities:

• Developed SSIS packages utilizing a data encryption process with secure ftp transfer between Confidential
• General database design, SQL & SSIS Development, and support.

Skills: MS SQL Server 2005-2008, SSIS SQL Integration Services, Visual Studio 2010

Confidential, Catonsville, MD

Senior Web & SQL Developer

Responsibilities:

• Developed an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Developed database schema design, stored procedures, triggers, indexes, ETL processes, security for the ASP.Net application.
• Created several reports using SSRS SQL Reporting Services 2005 & 2008

Skills: MS SQL Server 2008, SSRS/SSIS - SQL Server Reporting & Integration Services, Visual Studio 2008/2010, .Net 3.5-4.0, MVC 3, C#, ADO.Net, LINQ, AJAX.

Confidential, Sparks, MD

.Net Architect / Project Lead

Responsibilities:

• Developed a new web portal for brokers to get rate quotes, bind new policies, file and track claims, and manage leads
• Created application architecture, design, and application security, GUI front end, graphic design, and all database and objects.
• Interviewed & qualified junior developers involved in making hiring decisions, managed, led & mentored hired team members.

Skills: ASP.Net MVC 2, .Net 3.5, C#, Visual Studio 2008, ADO.Net Entity Framework, LINQ, HTML, JavaScript, AJAX.

Confidential, Timonium, MD

Senior .Net Developer

Responsibilities:

• Supported and assisted enhancement development of production released ASP.Net 2.0 application.
• The application was a data entry, reporting, and scheduling application used to manage IT related work orders within the county.
• Supported and fixed bugs.

Skills: ASP.Net 2.0, Visual Studio 2005/2008, C#, JavaScript, Oracle, PL/SQL, HTML.

Confidential, Columbia, MD

Senior Application Developer

Responsibilities:

• Developed a new invoicing application with an inventory and customer management component, payment tracking & application of payment to particular invoice(s) down to the line item level.
• Created a new database schema and ETL process to extract and normalize data from two existing systems and fit the single system design.
• Planning, documentation, all application design, designed all database schema, developed all stored procedures, and ETL processes.

Skills: .Net 2.0, Visual Studio 2005/2008, C#, ASP.Net, SQL 2000/2005, JavaScript, Microsoft AJAX control library, developed custom AJAX controls.

Confidential, Towson, MD

Team Lead / Architect / DBA / Sr. Application Developer

Responsibilities:

• Technical team lead of a large scale invoice and work order processing system.
• Created applications framework, structure, database design, data acquisition / warehousing components and security.
• Managed the technical direction of the project and a team of 4 junior developers.
• Coordinating releases, creating change control reports.
• Leading other junior developers, and technically responsible for the application and its state at all times.
• Instituted detailed application life cycle processes set team development procedures & protocols and ensured they were followed.
• Organized all of the requirements and made delegations of tasks to junior developers involved in the project development.
• Prepared application’s for demos during early phases to sell management and potential users on the benefits and value of the application to achieve funding for the application.
• Assumed various roles during the development of this application, including team technical lead of a team of 4 Jr. developer, database administrator, data architect, software architect, project manager and technical advisor.
• Setup fail over clustering production environment with a shared raid array between two servers for the database
• Setup load balancing clustering between two web servers both utilizing hardware clustering and Microsoft Cluster Services.
• Created a failure alert system to allow 24 hour cluster monitoring status which alerted via text messaging and email.

Skills: Visual Studio .Net 2002/2003/2005 , VB.Net, C#, ASP.Net, TSQL, ETL Processes, DTS, SQL Server 2000/2005, HTML, JavaScript, XML, Web Services, AJAX, ANTS Profiler, SQL Compare, Infragistics Controls.

Confidential, Hunt Valley, MD

Responsibilities:

• Exclusively developed an ASP.Net 2.0 web based solution, using MS SQL database
• Utilized SSRS SQL Server Reporting Services to create several reports the application used.
• The goal for the application was to simplify and streamline a business process for P&Gs Cosmetics Division.
• The process entailed designing retail product display units to promote new products in numerous retail stores.
• The existing method included shared excel files based on a very complex template, numerous manual processes
• Participated in a lengthy & complex process of developing requirements which involved several client employees from multiple divisions.
• Exclusively designed architecture with multiple tiers including: user authentication, user access security, data access, & business facade.

Skills: .Net 1.1 / 2.0, C#, VB.Net, JavaScript, SQL Server, SSRS Reporting Services.

Confidential, Baltimore, MD

Responsibilities:

• Primarily responsible for developing & supporting windows service oriented screen scraping applications.
• Secondarily responsible for developing ASP.Net front end interfaces to administer screen scraping services and report on collected data.
• Screen scraping was utilized to emulate mainframe sessions to acquire data from older mainframe systems, mechanize data entry and complex multi-step processes hundreds of times faster than a manual human user could possibly complete and with 100% accuracy.
• Created and maintained web, console, and service oriented (web & windows) applications .
• Developed database schema design, stored procedures, triggers, indexes, ETL processes, security.
• A considerable amount of time was spent completely rebuilding existing screen scraping applications that were notoriously problematic and required constant monitoring and support.
• Exclusively developed a base framework, enterprise resource templates, and documentation to set the standard best practice of all screen scraping applications to be built upon reducing notorious problems with reliability and performance..
• Made several contributions to the development team of useful generic components, server controls, and design practice guidelines.

Skills: Visual Studio.Net, Microsoft SQL 2000, TIRKS, PICS, Attachmate, VB.Net, C#.Net, ASP.Net, XML, Web Services, JavaScript, HTML, Infragistics.

Confidential

Exclusive Web Application Developer / DBA

Responsibilities:

• Exclusive developer/DBA of an intranet site to collect and report on mill production, product quality, and user entered data.
• Developed an engineering/maintenance logging & scheduling component
• Designed and developed a complex document management system
• Built a highly utilized delay & alarm tracking application
• Created extremely advanced reports with intense statistical analysis calculations using complex charting components
• Developed a highly custom charting component by using GDI+ to dynamically create an image file pixel by pixel to visually represent trending data that did not fit any available or typical charting component available.
• All front end systems were developed using ASP.Net 1.0, back-end databases in MS SQL 2000, SQL DTS and .Net console applications were utilized for automated data extraction from Flat File, Excel, Oracle, SQL, WonderWare InSQL Server, and other proprietary manufacturing data sources.

Skills: Visual Studio 6 / .Net 2002-2003, Dreamweaver MX, VB, C#, ASP, ASP.NET, ADO, ADO.Net, JavaScript, XML, Web Services, GDI+, SQL, Oracle, Component One Charts.