Sql Server Project

Robert H. Woods, Jr., MBA

**** ***** ***** ***** *******, GA. 30034 (404) - 212-7796 ******.*.*****@*******.***

Objective Experienced software engineer seeking a challenging position where technical skills, managerial skills, sales skills, project management skills, extensive knowledge of Web and Mainframe applications, excellent interpersonal and analytical skills will be fully utilized and further developed.

Technical Skills

ASP.NET 3.5 / 4.0 VB.NET HTML/CSS/JAVASCRIPT VISUAL SOURCE SAFE

VISUAL STUDIO TRANSACT SQL SQL SERVER 2005/2008 UMBRACO

NUnit SEO/Web Analytics ADO.NET NHibernate

CRYSTAL REPORTS 11xi XML/XSLT WEB SERVICES PL\SQL

ORACLE JIRA / IBM RTC STORED PROCEDURES LINQ

MVC 3 AGILE/SCRUM C#.NET JQuery

Professional Experience

6/11 – Present UnitedHealthGroup, Atlanta, GA

Senior Applications Developer

• Responsible for managing software development of corporate electronic medical record billing software system. Project involves using C#.NET, MVC 3, SQL Server, VB.NET, JQuery, LINQ JAVASCRIPT, TEST DRIVEN DEVELOPMENT and NUnit. Project software methodology consisted of AGILE/SCRUM with IBM Rational Concert for source code and document repository.

3/11 – 6/11 INFOR, Atlanta, GA

Consultant

• Worked on Microsoft FAST Search software that was incorporated into INFOR global corporate support site. Project involved using MVC 2, C# and SQL SERVER.

3/10 – 3/11 Verity Professionals, Alpharetta, GA

Consultant – Software Engineer

• Responsible for managing software development of ADP integration with SALESFORCE software systems. Project using C#.NET, SQL Server and SALESFORCE API Web Services.

• Responsible for managing software development for ADP data import ELOQUA software.

Project involves using C#.NET, SQL Server and ELOQUA API Web Services.

9/08 – 2/10 Jackson HealthCare, Alpharetta, GA

Web Developer

• Responsible for managing daily maintenance of Jackson Healthcare corporate websites. Code involves heavy usage of C#, VB.NET, Classic ASP, LINQ ASP.NET and SQL Server 2005.

• Worked on Health Portal project involving physician scheduling. Project consisted using code generation tools (i.e. Schematrix), Facade, factory and design patterns, C#, ASP.NET 3.5, SQL Server 2005, NHibernate and NUnit testing.

• Converted existing Jackson Healthcare websites to UMBRACO CMS platform. Projects involved using C#, XML WebServices, SQL Server, ASP.NET 3.5, XML and XSLT. Also, designed new web applications within the UMBRACO CMS platform.

• Projects were designed within the Agile Scrum methodology. Also, used Model View Presenter and Multi-Tier architectures for most web application projects.

5/08 – 9/08 Physician Oncology Services, Atlanta, GA

Developer Analyst

• Responsible for all health web applications that assisted all physician administering cancer treatments. Applications are written using ASP.NET, C# and SQL Server 2005.

Page 2

• Consulted on a daily basis with end users on issues with web applications.

• Designed a helpdesk application using IRONSPEED, C#, ASP.NET and SQL Server 2005.

8/07 – 4/08 Network Communications, Inc., Lawrenceville, GA

Developer II

• Created and consumed Web services to interact with NCI clients. Code involved using VB.NET, ASP.NET, COM, ADO.NET, Visual Studio 2003/2005/2008 and SQL Server 2000/2005. Also, responsible for providing support on NCI online critical systems.

• Coded Mass Import programs that insert (XML, text files, excel files) mass data into SQL Server databases. Developed several N-TIER applications in VB.NET and C# .NET 1.1/2.0/3.5. Also, used ADO.NET coding standards to access SQL Server 2000/2005 databases.

• Created critical crystal reports for NCI Sales team on NCI SQL Server Report Server.

• Interact with NCI vendor clients on periodically concerning XML file structures needed to allow NCI mass import processing.

• Responsible for all web application support and code maintenance on NCI Apartmentfinder.com website on a daily basis. Web application written using VB.NET, ASP.NET, XMLRPC, JavaScript, HTML, CSS, ASP, Crystal Report and SQL Server databases. Also, ensured 3 party websites were able access NCI SQL Server databases.

• Developed and maintained NCI Advertising Management System website, written in Classic ASP, VB, XML, XSLT and COM.

4/07 – 7/07 Meeting Expectations, Atlanta, GA

Web Application Developer

• Responsible for coding, developing and maintaining Meeting Expectation’s Oracle Applications User Group Global web site. Web site consists of SQL SERVER, ASP.NET, VB.NET, CSS, classic ASP, COM and JavaScript code developed within n-tier structure.

• Developed web forms for conversion of OAUG website to .NET Framework 2.0, using VB.NET and SQL Server database.

• Conducted status meetings with team members on web application problem resolutions, development and maintenance.

5/06 - 4/07 CDI CORP, Atlanta, GA.

Consultant

• Responsible for managing and coding Gwinnett County Data Migration project. Data Migration project involves transferring Mainframe production data files to an ORCALE database. Developed scripts and database control files to assist DBAs in creation of ORACLE tables.

• Code, Design and Develop Visual Basic application for Tax Commissioner’s department. Tax Commissioner’s Project provides reporting on all Tag and Title taxes within Gwinnett County.

• Project involves Visual Basic, ORACLE database, HTML/JAVASCRIPT, Stored Procedures and Crystal Reports for reporting.

• Design and Develop MS Access 2003 VBA application for Boards and Authority department at Gwinnett County. Application purpose is to allow supervisors to add, delete, update and provide email reports on Board Members of Gwinnett County districts.

• Lead developer on major conversion of Voter Registration/History mainframe application to a client server platform. Rewrite consists of using Visual Basic, ORACLE, Stored Procedures, Triggers, SQL Scripts and Crystal Reports.

8/04 - 5/06 AVON PRODUCTS INC., Atlanta, GA.

IT Analyst

Page 3

• Responsible for creating and developing all window and web applications for the Avon Atlanta Branch facility. Application created using MS ACCESS 2003, VB.NET and EASYTRIEVE for report retrieval. Also, backend consisted of SQL SERVER 2000, DB2, ORACLE and IMS

databases. Also, responsible for creating DTS packages, stored procedures, and backups on SQL Server 2000 development and production databases

• Developed an interactive Business Intelligence Reporting tool using MicroStrategy 8.0 which allows Division, District, Sales and Department Managers financial report creation.

• Provide maintenance on Avon Atlanta IT Intranet Request application, written in classic ASP.

• Interact with Billing, Order Prep, Merchandising, Transportation and Sales Departments on project basis to analyze and gather requirements in order to design applications within the supply chain structure. Applications are design using VB.NET, ASP.NET and Access 2003 development languages. Also, used Excel spreadsheets and Macros for Region Sales Reporting.

• Responsible for maintenance of Avon’s Atlanta SQL Server 2000 development and production databases. Daily monitor SQL Server 2000 databases through Enterprise Manager and SQL Query Analyzer.

• Responsible for analyzing and developing clear and concise functional and non-functional requirements specifications, conduct requirements workshops using formal and informal processes, develop user interface prototypes, business process models, and workflows.

• Created functioning e-commerce sites using ASP.NET with VB.NET and C#.NET as the working language and SQL Server 2000 database. All Projects consisted of using n-tier architecture design (presentation, business and data tiers). Also, projects involved heavy use of web user controls and SQL Server stored procedures.

4/02 - 8/04 WALGREENS, Atlanta, GA.

Assistant Manager

• Supervised over 20 employees on a daily basis.

• Responsible for overall store operations.

6/00 - 11/01 Nova Information Systems, Inc., Atlanta, GA.

Authorization Application Developer

• Code, test and implement modifications on Nova’s authorization system. Nova’s authorization system application platform consists of VOS Stratus, Micro focus COBOL, COBOL, Oracle 8i Database, SQL Navigator and UNIX. The authorization system is a 24-hour transaction processing system that processes over 50 million transactions a year.

• Design, code and implement a client server User Setup Access system. The User Setup Access system is used to provide access to all internal applications used by Nova Information System employees. The User Setup Access system is coded in a VOS operating Stratus environment using COBOL, Delphi and an Oracle 8i database platform.

• Responsible for performing a technical role in developing design deliverable (Conceptual Design, Functional Design, Systems Technical Design, Programming Specifications and Unit, System and Integration Test Plans).

• Code modification on Nova’s authorization system for corporate purchasing credit cards to be process from point-of-sale device to authorization to settlement of funds.

6/99 - 6/00 CGI, USA, Atlanta, GA.

Application Developer Consultant

• Responsible for application development, training and working with business analysts on the Universal Billing System product, application platform COBOL, CICS and VSAM. Designed based upon an existing PC DOS based version. The conversion involved writing over 30 new

Page 4

• CICS programs, 20 new on-line screens, 10 new copybooks and 2 new VSAM files. Universal Bill Plan system used by CGI’s clients to determine strategies for invoicing auto, property or life policies. Also, used XPEDITOR, INTERTEST, CEDF and VIASOFT to debug programs.

6/97 - 6/99 Bank Of America, Atlanta, GA.

ATM Settlement Programmer Analyst

• Documented, designed, developed, tested and implemented quality ATM Settlement2 software applications following established detailed procedures. Environment consisted of COBOL, JCL, VSAM, ISPF, TSO, PANVALET, MVS, XPEDITOR, FILE-AID, CHANGMAN, CEDF, EASYTRIEVE-PLUS, IBM UTILITIES.

5/96 – 6/97 MasterCard International, St. Louis, MO

Stand In Programmer Analyst

• Coded, tested and implemented modifications to the Stand-In Authorization CICS online and COBOL batch production systems. Also, made production program modifications to the Account Management System, which uses a DB2 database to maintain its data.

• Developed CICS online international Regional Service Center Member Host Emulator.

Education FLORIDA INSTITUTE OF TECHNOLOGY, Melbourne, FL.

MBA, Information Technology Management, May 2012

FLORIDA AGRICULTURAL AND MECHANICAL UNIVERSITY, Tallahassee, FL.

Bachelor of Science, Computer Information Systems, April 1995

References Available upon request

Contact this candidate