Developer Sql Server

JOHN M. BATES

**** ****** **., #82-571-***-**** Alexandria, VA 22311 ***********@*****.***

WORK EXPERIENCE

*/**** *******: Senior .Net Developer / Architect. Possess outstanding communication and technical skills. Seeking a long-term position working in the DC area or working remotely.

15 years of advanced-level experience with Microsoft technologies. Extensive experience working with Agile teams and independently as a Senior .Net Developer, Scrum Team Lead, Technical Project Manager, and System Architect.

Experienced in all aspects of web and desktop application development including: meeting with clients to gather Business Requirements, documenting Technical Requirements and Design, developing and using E/R designs, UML documents, and Use Case scenarios.

Approximately 80% of work experience is focused on hands-on development including implementing design patterns, Object-oriented development, ORM implementation, SQL and T-SQL coding, transaction processing, front-end design and development, TDD, Unit and System Testing. Front-end experience includes supervision, design and development using tools such as Razor, CSS, HTML 5, JQuery, and AngularJS.

Design pattern experience includes MVC, MVVM, Singleton, Factory Method,

Decorator, Observer, and others. Extensive experience with SQL Server, ETL, Data

Marts, and normalized database design.

Senior or Lead Developer for applications addressing Heathcare, DOD Budget

Submission, Accounting, Financial Analysis, Public Utility Billing, Securities

Trading, HR Management, Hotel Billing, Job Tracking, Federal Grant Distribution,

Project Scheduling, Contact Management, and other applications.

10/87 - 8/00: United Mine Workers of America, Office Automation Manager.

Responsible for technical and administrative management of programming and

help desk staff. Responsibilities include project management, staff training,

requirements analysis, and hands-on application development. Designed,

developed and supported 27 dBase and Clipper desktop applications.

8/82-9/87: U.S. Navy, PC Programmer/Data Processor, enlisted.

Develop COBOL applications supporting Navy operations. Operate IBM 3070

mainframe computers, provide technical training to departmental staff.

Microsoft Certified Software Developer, Visual Basic, 1995

University of Maryland, Computer Science, 1986

Public Trust Security Clearance, 2010/2012

SKILLS

MS Visual Studio 2.0/3.0/3.5 /4.0/4,5/VB6/VBA C#/VBScript/Salesforce

ASP.net/VB.net/ADO.net Google API/Windows Mobile

SSIS/ETL/SSAS/DTS/Linq/Spring.net MVC/MVVM/WWF/WPF/TDD/nUnit

WCF/Web Services (SOAP/REST/Web API) AngularJS/Javascript/CSS/JQUER/BootstrapY

XML/XSL/XSD/XSLT/IHTTP/AJAX Knockout.js/NHibernate /Entity Framework

BO Crystal Reports X/XI/Dashboards/SSRS MS Project/Erwin ERX/Rational Suite

SQL Server 2004/2008/2012/Data Tools/Oracle 11g/MySQL AWS/Azure

Silverlight/XAML/JSON/Exchange Web Services Visual Source Safe/Subversion/TFS/Git

APEX SQL/DevExpress/Infragistics Great Plains/Quickbooks

Win2010/ Win 8/IIS/Apache/Linux/LAMP Photoshop/MS Word/Excel/Access

L PROJECT / CONSULTING LIST

Senior .Net Developer, TSPi, Reston, VA 12/2014 – Present

Worked as Senior Developer and architect on a .Net project for US Department of Treasure. Worked closely with Treasury department heads to gather and document business and functional requirements. Provided life-cycle development of an Investigations system. Designed database and wrote sophisticated T-SQL stored procedures. Supervised and provided code review for three junior developers. Developed MVC 5 web application with RESTfule services, Razor forms, and SSRS Reports. Utilized Visual Studio 2013, C#, SQl Server 3022 T-SQL, WCF, XML, AngularJS, Bootstrap, Entity Framework, XSLT, MVC 5, and SSRS.

Senior .Net Developer, Ciber, Inc., Alexandria, VA 2/2013 – 1/2014

Worked remotely as hands-on Sr. .Net Developer and Team Lead. Provide life-cycle design and MVVM, WPF, and MVC 4 development services for a combination front-end web Razor and Winforms application. Participated in and conducted SCRUM meetings and reviews. Perform requirements analysis and interact regularly with clients. Architect various design patterns. Converted 25 wireframes to WPF web pages. Integrated data with cloud-based Salesforce database. Developed client and server WCF SOAPWeb Services, client data transfers, and XAML forms. Participated in Win Mobile application development. Implemented video recording and playback module in desktop system. Gathered requirements for detail and summary SSRS reports and supervised development. Developed many sophisticated SQL stored procedures some with transaction processing. Implemented JSON processing. Created Entity Framework ORM and Linq routines. Deployed system on MS Azure cloud service. UUtilized SQL Server 2012, SQL Data Tools, C#, Test Driven Development, nUnit, Visual Studio 2012, TFS, SSRS, Entity Framework, XML, AngularJS, Windows Presentation Foundation (WPF), VB.Net, AJAX, WCF SOAP, XML, XSLT, CSS, APEX SQL, JSON, MS Azure, Telerik, AngularJS, HTML5, JQuery, and Windows Mobile SDK.

Senior .Net Developer, Tower Strides, Inc., Chantilly, VA, 10/2012 – 1/2013

Work as Senior .Net Developer designing and developing a .Net MVC SQL Server addressing Risk Management. Utilized Linq and Entity Framework to develop data models, methods, and business layers. Utilized Exchange Web Services (EWS) to implement email processing. Worked closely with client to gather requirements and design SQL databases and stored procedures. Developed many sophisticated stored procedures. Architected Factory and Singleton design patterns. Designed wireframe mock-ups and converted to HTML5/CSS/JQuery front-end web pages. Developed MVC 4 architecture. Hosted system on MS Azure. Utilized SQL Server 2012, VS 2012, VB.Net, Agile Scrum, VSS, CSS, HTML5, MS Azure, JQuery, Entity Framework, TDD, nUnit, SSRS, and MVC 4. Project lost government funding.

Senior .Net Developer, Project Performance Corp. (Kforce, Inc.), McLean, VA, 7/2012 – 10/2012.

Work as Senior Net Developer on an Agile team. Designed and developed MVVM C# WPF (Devexpress) front-end and SQL Server application. Developed XAML WinForms, data bindings, and associated code. Implemented data serialization, Multi-threading, XML / XPATH/XSD routines and asynchronous SQL Server (Entity Framework) data management routines. Developed WCF Restful application. Implemented EDI Framework and transaction processing routines. Implemented service on Amazon Web Services (AWS) Project was completed and delivered for testing.

Sr. Senior .Net Developer, World Bank (Experis, Inc.), Washington, DC, 3/2012 – 6/2012.

Worked as Senior Developer designing and programming a .Net Visual Basic MVC 3.5 IOAS application. Gathered requirements from departmental stakeholders. Supervised a four person off-shore team. Developed WCF SOAP Web Services XML data model, controllers, and HTML5 and JQuery views. Developed Telerik Rad Grid interfaces. Developed HTML-based eLarning website to train remote users. Implemented Ajax callbacks, Socket Connections, and JQuery collapsing accordion and toolbars and developed 8 SSRS reports. Implemented SQL Injection prevention capabilities. Utilized Exchange Web Services (EWS). Wrote many sophisticated PL/SQL stored procedures. Implemented SOAP Web Services. Utilized Visual Studio 2010, VB.Net, SSRS, TDD, AJAX, MVC 3, SSRS, WCF SOAP, Oracle 11g, HTML, Enterprise Library, WCF, Telerik, CSS, SSIS, and JQuery. Project was completed and delivered for testing.

Data Integration and SSIS Developer, Vacation.com (The Midtown Group), Alexandria, VA 6/2011 – 3/2012

Worked as senior developer and Integration Specialist designing and developing a variety of corporate solutions. Met regularly with departmental and vendor stakeholders to gather requirements. Utilized Salesforce, SQL Server 2010, .Net 4.0, C#, SSIS, eConnect, and other tools. Provided Salesforce administration services, developed triggers, formulas, custom forms, SSRS reports, integrated 3rd party applications, and performed extensive SSIS data migration and integration services. Developed 50+ SSIS ETL packages. Implemented Section 508 compliance in web pages. Developed custom .net Cruisespace application and addressed user requests and bugs. Designed and implemented project to migrate a .net Customer Service application to Salesforce. Developed Windows Services applications. Wrote technical and user documentation. Worked remotely on many aspects of the project.

Senior SQL, SSIS, and ETL Developer, E*Trade (CEI, Inc.), Arlington, VA, 12/2010 – 4/2011

Worked as senior developer and architect designing and developing several SQL Server and Oracle SSIS packages to schedule and manage loading and transform of data. Managed large datasets. Gathered and documented business requirements and design documents. Developed E/R Data Models using Rational Suite, SSAS Workflow processes, Multi-threading routines, T-SQL stored procedures and functions and optimized performance. Developed 25 sophisticated SSIS packages and 10 SSRS BI reports. Developed SQL transaction processing routines. Project was completed and all systems utilized in production. Created Crystal-reports based Dashboard and charts. The system uses Oracle 10i, SSIS 2008, .APEX SQL, Net 3.0, Crystal Reports, Visual Basic, SQL Server 2008.

Senior .Net Developer, Patent Submission System, US Patent and Trade Office (Cortechs, Inc.), Alexandria, VA, 8/2010 – 12/2010

Worked as senior developer designing and developing Winforms Patent Submission modules and modifying a VB6 application and MS Word templates. Created modules to parse and update XML components of Patent Submission Application. The system uses Oracle 10i, XML, XSLT, VB6, SSRS, MS Word, VB.Net, and Visual Basic for Applications..

Team Lead / .Net Developer, Clinical Data Synchronization System, Northrop Grumman (Softek International), McLean, VA, 6/2010 – 7/2010

Worked as architect and senior developer developing a WinForms application used to gather, integrate, and summarize field clinical information across several countries. Supervised 3 developers. Met with customer and gathered requirements and created design documents including business requirements, Use Case diagrams, E/R diagrams, UML Class charts, and test plans. The system uses Infragistics tools, Google Maps API, TDD, Smart Client Factory (MVC), WCF, Linq, TDD, WPF and XAML, SSIS, JQuery, T-SQL, C#, SQL Server 2008, and VB.net 2008. Project ended due to budget constraints.

Team Lead and Sr. .Net Developer Survey System, Data Tree (About Web), Gaithersburg, MD, 4/10

– 6/2010

Worked as lead developer and architect migrating and converting a legacy ASP survey and reporting

system to the PAGE web SQL production application. Implemented Single-Sign-on (SSO). The PAGE system is used by DOE to manage federal grants. Implemented client and server Web Services protocols. Utilizes Asp.net 3.5, C#, Siliverlight, Infragistics, SSRS, XML, WPF, C#, SQL Server 2008, AJAX.

Clinical Trials System and Mobile System, Society of Nuclear Medicine (About Web), Reston, VA, 12/09 –4/10

Worked as lead developer and architect supervising three mid-level developers designing and programming a web-based clinical trials management system. Worked closely with SNM staff gathering requirements. The system facilitates tracking and testing of medical scanning equipment and associated nuclear materials. Provided IIS administration and optimization. Developed server and client SOAP WebServices data integration module and developed SQL OLTP and transaction processing routines. Designed and developed a Windows Mobile application using Visual Studio. Application is used to gather voting information by the government of Jamaica. Used MapInfo API to create GIS interface. Wrote UML, E/R, and user documentation; includes SSRS reports. Utilizes Asp.net 3.5, C#, TDD, SQL Server 2008, Web Services (WCF), Linq, MapInfo, SSRS, Smart Card API, Crystal Reports.

Web e-Commerce System, Sunchain, Incorporated, Fairfax, VA (remote work), 5/09 – 12/09

Worked as lead developer for a Franchise Organization. Performed life-cycle development including requirements documentation, Use Case, E/R design and documentation and developed public-facing PHP web application.. Application facilitates retail purchases for 60 retail franchises. Performed all work remotely. Utilizes PHP, OLTP, MySQL, CSS, Javascript, HTML, and Microsoft Reporting Services (SSRS).

Federal Project Management, US Department of Commerce, Silver Spring, MD, 10/07 – 4/09

Worked as senior developer for a Federal Agency. Designed and developed a web-based project and budget analysis and tracking system. Application manages 2B of Federal funds. Converted legacy ASP system. Utilized VBA and developedWord application, Agile Methodology, integrated with Sharepoint, developed WebParts, nUnit Testing, DTS, Linq, Asp.net 3.0, C#, SQL Server 2005, Web Services, and Crystal Reports and Active Reports.

Job Management System and Mobile Application, The Countertop Company, McLean, VA, 11/06 – 10/07

Worked as senior developer. Designed and developed for a DC-area Residential Contractor franchise, the web system provides flexible calendaring capabilities, customer, job, and employee scheduling, job management, e-mail management, invoicing, and other capabilities. Integrated with SalesForce CRM and Great Plains Accounting. Developed a Windows CE mobile application to provide field service workers with job schedule information. Utilizes ASP.net 3.0, C#, AJAX, WinForms, VB6, Crystal Reports, Microsoft Exchange Server, Windows Services, and Microsoft SQL Server 2005.

Learning Management System, University of Maryland, College Park, MD, 2/05 – 11/06

Designed and developed for a State University, the web system provides comprehensive learning management including e-learning integration, e-commerce, student self-registration, tests and evaluations, invoicing and financial management, student correspondence, grades and attendance, Great Plains, Quickbooks and Goldmine CRM integration, and more. Integrated a third-party Rustica SCORM engine and created a HRM-related SCORM course. Supervised an off-shore development team. Utilized Sharepoint, created lookups and Active Directory single sign-on. Utilized Agile Methodology, ASP.net 2.0, VBScript, Crystal Reports, Rustica SCORM, Web Services, Web Forms, and Oracle.

Utilities Customer Management, Washington Gas, Chantilly, VA, 6/04 – 1/05

Worked as lead developer for a Public Utility, the ASP.Net web system is used by Customer Service representatives to respond to and record service issues. Designed large Oracle database to manage customer service issues. Developed 12 Crystal reports. Utilizes PHP, Crystal Reports, and Oracle.

Facilities Management, Completed Systems, Inc., Fairfax, VA, 4/03 – 5/04

Worked as lead developer for a Federal Agency, the web system is used to track and analyze facility space, personnel, budget and financials, and office requirements for projected government requirements. Utilizes ASP.net 2.0, Javascript, SQL Server, Sharepoint, C#, AJAX, Web Services, and Crystal Reports Server.

Fixed Asset Trading and Analysis System, Bank of New York, New York, NY, 9/02 – 4/03

Designed and developed a Bond tracking and analysis system used by BONY traders. Identifies appropriate assets, supports analysis based on variable spreads and other criteria. Also developed a financial calculator and a Portfolio Management system. Utilizes ASP.Net, VB6, SQL Server, and Crystal Reports.

Financial Calculator and Asset Tracking System, CDA Financial, NY, 6/02 – 8/02

Tracks assets and provides “what-if” calculation of amortization rates, inflation, investment properties, fixed assets, net worth, and other items. Utilizes VB6, MS Access, and Crystal Reports.

Capture Management, Unisys Incorporated, Reston, VA, 3/02 – 6/02

Worked as project manager for a Government Contractor, the web system is used to organize and manage information related to responding to government RFPs and RFQs. The application provides document management services and tracks the progress of contract development and the bidding and award process. Utilizes ASP.net 2.0, VBScript, VBA, SQL Server, and Crystal Reports.

Document Management, World Bank, Washington, DC, 11/01 – 2/02

Worked as project manager, designed and developed for an International Banking Institution, the system is used to store, track, share, and report on documents utilized by the organization. Utilizes Visual Basic and SQL Server.

Logistics Management Institute, Fairfax, VA, 3/01 – 11/01

Worked as lead developer, developed for a Logistics organization, the system is used to track and allocate materials shipped across the USA based on shipping routes and material packing requirements. Utilizes VB6, Visual Basic, SQL Server, MapInfo, and Crystal Reports.

AT&T, Orlando, FL, 6/00 – 12/00

Worked on-site in Orlando as a Sr. Developer. Utilized Foxpro for Windows to develop a business customer billing and phone utilization reporting product. The “Billing Edge” product was shipped to AT&T customers. Utilized Foxpro for Windows and MS Access.

Contact this candidate