VB / Database Developer/Project Manager Resume

Title
VB / Database Developer/Project Manager

Primary Skills
VB, Sequel Server, MS Access, C#

Location
US-TX-Dallas (will consider relocating)

Posted
May-18-09

SUMMARY:
• 18 years Professional Work Experience in Software Development Life Cycle (SDLC).
• 17 years experience with Visual Basic
• 7 years experience with Microsoft SQL Server, MS Access and Object Oriented Programming (OOP)
• 6 years of expertise with Visual Source Safe, Photo Finish, Hijaak Pro.
• 5 years of experience with Oracle, COM/COM+, DCOM, ADO, ODBC, OLEDB, MS Sequel Server-Stored Procedures and Triggers, Data Transformation Services (DTS) Packaging, Microsoft Visio, MS Front Page, MS Project, Adobe Illustrator
• Over 2 years of experience with Visual Studio C#, Visual Interdev, Crystal Reports, Oracle, e.Power Workflow Software, Adobe PhotoShop, Math Programming, Smart Draw 6, Corel Draw. RS232 Communications Methodology, Symantec VPN, HTML VB Script.
• Working experience with ASP .NET, VS.NET, VB.NET, .Net Framework, VC++, BizFlow (workflow), OCR for Forms, Data Transformation Services (DTS), Electronic Data Interchange (EDI), Great Plains Accounting integration, Peregrine Service Center.
• Hands on Projects: Equipment Ordering System (EOS) -- PepsiCo, Single Carrier High Speed Modem (SCM) -- MRC -- Serial Communications; Automated Prescription System (APS) -- McKesson APS, Project Management Reporting System (SBC), Work Distribution, Data Capture -- Warehouse Operations (DLA), Aviation Engineering Support Application (NAVAIR), General Motors Vehicle Distribution/Auto Auction, US Army Personnel Data Capture and Distribution (Fort McPherson, GA), US Army Tactical Mapping/Graphics Application (TacMaps), Interactive/Multimedia presentation, Application modification and maintenance, Help Desk Standard Operating Procedures (SOP) establishment, Great Plains Accounting integration -- Rocky Mountain Technology Group.
• Effective Communication with team members and team training/leadership.
• Excellent Ability of Problem Solving and SDLC conceptualization/product development

EDUCATION:
• MA-Master of Management Information Systems - 1991
• BS-Bachelor of Science, Chemistry, Minor: Math, Data Processing - 1981
• US Army Command & General Staff College Graduate - 1998
• US Army Operations Research/Systems Analysis (ORSA) Graduate -- 1992

CERTIFICATION:
• Operation Research Systems And Systems Analysis - US Army School of Logistics Management

TECHNICAL BACKGROUND:
GUI: Visual Basic 3.0/4.0/5.0/6.0/. Net. Visual Studio 2003-8, C#
RDBMS: Microsoft SQL Server 6.0/7.0/2000-2005, Oracle 7, 8.0, 8i, MS Access 95/97/7.0/00/02 Oterro Database Engine, RBase.
Web Technology: ASP 2.0/3.0/.NET, HTML, VB Script, Java Script, Front Page 97/00, Visual Interdev 1.0/6.0
ActiveX Technology: COM, COM+, DCOM.
Web Server: Internet Information Server 2.0/3.04.0/5.0, Personnel Web Server
Web Browser: Internet Explorer 2.0/3.0/4.0/5.0
Operating system: Windows 95/98/NT 4.0/00/02, MS-DOS 3.0/4.0/5.0/6.0, Vista
Languages: Visual Basic 2-6.0, VC++, C#, Java, COBOL, FORTRAN IV, RPG, Assembler, Math Programming, Visual Studio 2005-2008
Version Control: Visual Source Safe 6.0, Veritas 8.0, Perforce
Reporting Tools: Crystal Reports 3.0/8.0, Word 95/97/98/00/5.0/6.0, Excel 95/97/4.0/5.0. MS Project 98/00, Lotus Notes 6.0, MS Office 2003, 2005
Case Tools: Microsoft Visio, Smart Draw 6.
Others: Outlook 97/98/00, WinZip 8.0, PowerPoint 97/98/00, Adobe Acrobat 4.0/5.0. XML

VARIOUS CLIENTS AND POSITIONS:
PepsiCo (Pepsi Cola), 5600 Headquarters Dr, Plano, TX 75024
29 September 2008 -- Present
IT Consultant (Senior Analyst/Programmer)
Equipment Ordering System (EOS) Project: Primary responsibility to develop and support Web based EOS services across the PepsiCo Application Environment.
Responsibilities:
• Perform development and support of EOS services used to assemble, compile and transmit financial and equipment data
• Work directly with users, manages and developers to understand requirements and determine appropriate analysis techniques
• Analyze, design, code and test efficient and highly scalable data solutions
• Prepare, maintain and publish documentation including application user guides and support instructions
• Serve as Subject Matter Expert for EOS with full accountability for ensuring operational continuity and supportability.
• Maintenance of architecture, documentation and reports
• Participate in peer code reviews.
• Performance and status reports to management.
• Develop and analyze product reports
• Provide integration with Change Management Board
• SAP data integration with data feeds -- R5 Integration.
• Data feeds for Oracle accounting -- Financial Asset Management Teams
• Perform requirements analysis and design documentation
• Remote VPN maintenance.
• Complete monthly close procedures
• Strong analytical and communication skills.
• Ensure application compliance with the Sarbanes-Oxley Act (SOX)
Environment: Windows XP, Visual Studio 2005-2008, Visual C#, ASP, Visual Basic, MS Access, Microsoft Excel, MS Sequel Server, Stored Procedures, Triggers, Views, Microsoft Query Analyzer, Microsoft Data Transformation Services (DTS), Oracle, SAP, VPN remote work, OOP, XML, FTP, Microsoft Outlook.

Microwave Radio Communications - Bldg. 6, North Billerica, MA 01862-1256
15 December 2005 -- 27 June 2008
IT Consultant (Software Engineer)
Radio Transmitter/Receiver Serial Communications Projects: The position is responsible for managing, developing and maintaining the User: Customer/Factory Radio Interfaces (GUI) s plus develop new communications middleware. The interface supports multiple radio transmitter/receiver systems. Maintain the software and the production environments. Provide support for the engineering users of the system. Primary technical lead/consultant between Engineering and Applications support for the User Interface applications. Supervise User Interface testing. Remote development work: Manila Philippines.
Responsibilities:
• Project plan development and construction.
• Preparation of project architecture, planning and documentation
• Participate in peer code reviews.
• Performance and status reports to management.
• Develop and analyze product specifications; develops documentation
• Develop software architecture for software design with special attention given to integration of all interface applications -- universal Configurator
• Ensure that the applications are consistent in look and feel, underlying architecture where applicable.
• Perform requirements analysis and design documentation
• Analyzes technical product problems and makes recommendations
• Interface and work with product documentation and product certification groups
• Perform software builds using Microsoft Visual Studio 2005, and provide first line of product integration testing
• Provide all necessary information to the manufacturing for using setups of the applications
• Integrate, store and manage software source code
• Monitor product defect reports and interface between development leads and the certification group
• Accomplish seamless integration into new development with existing projects
• RS232 Communications Methodology
• Develop and supervise product testing and test plans to include automated testing, script testing.
• Remote VPN troubleshooting and programming maintenance
Environment: Windows XP, Microsoft Excel, Microsoft Outlook, Microsoft Office, Visual Studio 2008, Microsoft Visual Studio: Visual Basic 6.0, Visual C++, Microsoft Windows HyperTerminal, Perforce Source Code Storage, C#, VPN remote work, OOP, XML, FTP.

Amrerigroup, Inc., 4425 Corporation Lane, Virginia Beach, VA 23452
10 November 2005 -- 8 December 2005
IT Consultant (Assistant Project Manager/Business Analyst)
CaseTracker: The project focus is on customer management controlling workflow and customer data throughout the agency.
Responsibilities:
• Project plan modification using Microsoft Project.
• Analysis and modifying resource requirements and allocation.
• Time/Task planning and adjustments.
• Preparation of systems documentation
• Provide documentation for successful plan reviews.
• Perform daily reports to management.
• Gather and prepare requirements for proposed software architectural changes.
• Prepare Change and Risk Assessment documentation.
Environment: Windows XP, Microsoft Excel, Microsoft Outlook, Microsoft Office, Microsoft Project, Microsoft Sequel Server, Microsoft Query Analyzer, FTP.

McKesson APS, Inc., 4333 Shreveport Highway, Pineville, LA 71360
12 April 2005 -- 8 October 2005
IT Consultant (Software Engineer)
Automated Prescription System Software (APS): The project focus is on pharmacy management software controlling pharmacy workflow throughout the entire pharmacy. The APS software offers customizable solutions options for the entire pharmacy. The software consists of station-by-station process for filling prescriptions, imaging and data entry plus Bar code verification. The APS software provides a customizable interface with hardware components.
Responsibilities:
• Programming (primarily in Microsoft Visual Basic and Microsoft SQL Server) and replacing the DCOM portion of the driver component (AccuMed) with TCP capabilities.
• Model construction for proposed replacement system.
• Determine and document user requirements
• Preparation of systems documentation consisting of current system architecture with proposed replacement modules.
• Develop and implement intense component testing methodology and validation process.
• Phased integration of system changes with the removal of DCOM components.
• Provide module documentation for successful code reviews.
• Phased configuration testing for product performance and load balancing.
• Perform daily reports to management.
Environment: Visual Studio 2003, Visual Basic 6.0, XML, OOP, Microsoft File Scripting, Windows XP, Visual Source Safe, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Performance Manager, Microsoft Office, Microsoft Project, Microsoft Sequel Server, Microsoft Query Analyzer, McKesson Pharmacy 2000©, Pharmacy 2000® Workflow Software and AccuMed? Dispensing Technology

EMPATH Consulting, Inc., 1430 Regatta Blvd. Richmond, CA 94804
3 January 2005 -- 11 March 2005
IT Consultant (Hospital Optimization Engineer)
Hospital Services Software: Medical Software for emergency department and inpatient hospital process management. Provide software for patient and departmental ability to manage people and resources.
Responsibilities:
• Programming (primarily in Microsoft ACCESS 2000, Microsoft Access 2002, Visual Basic for Applications and Microsoft SQL Server) of EMPATH's Dashboard Systems.
• Installation and support for Dashboard System modifications at the client site, and resolution of problems with already- installed modules.
• Preparation of Dashboard Systems documentation consisting of User Help Screens and User Support documentation in support of Pharmacy and Operating Room departments.
• Coordinated with project manager to identify requirements for maintaining application tables, dictionaries, and parameters for system operation and configuration.
• Manipulate file input for data validation, manipulation and updating sequel server tables.
• Installed patches/fixes provided by the EMPATH in accordance with change control procedures.
• Creating ad hoc reports and data extracts as required by business customers
• Provided module documentation for successful code reviews.
• Perform data daily reports to management.
Environment: Visual Basic 6.0, VBA, OOP, Windows XP, MS Access, Microsoft Excel, MS Project, Microsoft Office, Adobe Acrobat 5.0.

Coram Health Care, Inc, 1471 Business Center Dr, #500, Mt Prospect, IL 60056
1 November 2004 -- 19 November 2004
IT Consultant (Project Manager/ Project Lead Developer)
Clinical Services Software: Medical Software for home infusion service and support system. Provide capability to update specific product costing from legacy system to production environment.
Responsibilities:
• Analyze, design and develop processes for updating master product cost from legacy system.
• Developed automated tool for packaging, transmitting and updating sequel server master tables
• Developed 2 products -- stand-alone exe for manual launching pricing updates and program serving as a windows service module for monitoring automated file transfers.
• Created modified existing Sequel Server tables and fields
• Legacy system FTP CSV files as data input. Manipulated file input for data validation, manipulation and updating sequel server tables.
• Modified existing ASP scripts for GUI user interface.
• Provided module documentation for successful code reviews.
• Perform data daily reports to management.
Environment: Visual Basic 6.0, ASP, COM/COM, HTML, OOP, Windows XP, Microsoft Sequel Server, Microsoft Query Analyzer, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft Data Transformation Services (DTS), Adobe Acrobat 5.0. FTP.

SBC (now AT&T), Inc., 2000 W. Ameritech Center Dr, Hoffman Estates, IL 60179
March 2004 -- November 2004
IT Consultant (Project Management Software Development)
Integrated Tracking System (ITS): The Integrated Tracking System (ITS) is a Network organization, mechanized management tool which tracks project initiative development. ITS input provides managers and users within Network Services Integration Management and the New Technology Introductions organizations crucial project management environment and reporting tools. ITS provides a multitude of status and performance metrics reports. ITS initiative information provides Network Organizations, Product Marketing, Finance and Regulatory services the ability to monitor, organize and report project status and problem areas immediately to senior management.
Responsibilities:
• Analyze, design and develop processes for maintaining ITS for SBC
• Install/configure development and reporting tools as required for product improvement, maintenance and coverage.
• Conduct new ITS development and enhancements as directed.
• Perform and document ITS data transactions to fulfill business requirements to satisfy customer data reporting needs using VSView OCX. Modify and create new user ITS interfaces to capture data. Provide reporting functionality and capability on SBC organization with drag and drop modification capacity.
• Created customizable Presentation Reporting system to permit user to auto generate MS Power Point Presentation/ briefing slides with embedded real time data plus exporting into individual HTML files.
• Support reporting requirements to determine best methodology for system/user interface
• Prepare system documentation and interface with leadership and assist in migrating new system versions into the production environment.
• Perform data daily, weekly backups on system and user information using Veritas Version 8.0
Environment: Visual Basic 6.0, COM/COM, HTML, IIS, Oterro, RBase, OOP, Windows 2000, Microsoft Excel, Microsoft Office, Microsoft Outlook, Adobe Acrobat 5.0 and VS View Enterprise Studio, Veritas Version 8.0, Q Messaging, Microsoft Net Meeting

Corridor Consulting, 20 Mall Rd, Suite 261, Burlington, MA 0183
August 2003 -- December 2003
IT Consultant
Army Central Clearance Facility Adjudication System: The Army Adjudication system processes thousands of security clearances daily. This multi-user system, supporting hundreds of simultaneous users, is designed with menu and windowing features that provide a consistent, easy to use interface. The system enhances the productivity of the adjudication staff through increased accuracy of record keeping, updated individual case files, and interface with other systems.
Responsibilities:
• Analyze, design and develop workflow processes for conversion of intelligent agents (COM/DLL Objects) to support paper/electronic document conversion, email operations, and work distribution with Bizflow workflow system for the Army Central Clearance Facility.
• Describe/document data requirements and transactions needed for defining business requirements and ensuring data model meets stated requirements
• Installation and configuration SQL Server 2000, Apache TomCat and Bizflow Process Designer, BizFlow Forms Developer and BizFlow System Manager.
• Prepare system documentation and interface with senior leadership and assist in integrating the project into operation.
Environment: Visual Source Safe 6.0, Visual Basic 6.0, JavaScript, OOP, COM/COM, HTML, IIS, Microsoft SQL Server 2000, Windows 2000, Microsoft Visio 4.0, Microsoft Sequel Server, Microsoft Query Analyzer, Microsoft Excel, Microsoft Office, Microsoft Project, Microsoft Outlook, SSL, VB Script, Handy Soft BizFlow, BizFlow Forms, Adobe Acrobat 5.0.

Rocky Mountain Technology Group, 207 N Broadway, Billings, MT 59101
October 2002 -- May 2003
Software Engineer
Billings Auto-Auction System: Visual Basic/SQL Server application development. Architect and development of 3-tier EDI components to communicate with Ford Motor and General Motors Companies. These components were developed using SQL Server 2000, DTS, and Visual Basic to provide Electronic Data Interchange with Ford and other vehicle manufactures from a common Auto Auction Management database. Development of an Auto Auction Management System user interface and database components with interface for Great Plains accounting package.
Responsibilities:
• Analyze, design and develop Visual Basic Modules for troubleshooting and testing of data capture, packaging and data transfer between major Auto Manufacturers and Auto Auction houses using Data Transformation Services (DTS) and Electronic Data Interchange (EDI).
• Develop project plan for test scheduling and program migration/implementation.
• Develop user training requirements and documentation.
• Conduct User training sessions
• Interface with senior leadership and integrate the project into operation/production.
• Develop and manage automated documentation program
• Complete plan for system re-architecture tracking and modifications.
• Communicate with customer and application development team to ensure customer data requirements and data transactions will meet operational requirements.
• Determine the best possible interface method for integration with General Motors/Ford data and database reporting structures.
• Determine user needs for Database data design and maintain internal versions of such Databases to fulfill user requirements.
Environment: Visual Basic 6.0, COM/COM+, HTML, OOP, IIS, Microsoft SQL Server 2000, Stored Procedures, Microsoft Data Transformation Services (DTS), Visual Source Safe 6.0, Crystal Reports, MS Access 2000, Windows 98/NT/2000, Microsoft Visio 4.0, Microsoft Sequel Server, Microsoft Query Analyzer, Microsoft Excel, Microsoft Office, Microsoft Business Solutions - Great Plains Accounting System, IBM Lotus Notes 6.0.

ArchAngel Software, Fayetteville, NC
March 2002 -- October 2002
Senior Software Product Developer
Desktop Software Projects: These projects are related to different areas of concentration to satisfy retail product sales requirements. Some of the titles developed are The Interactive, Multi-media High School Yearbook Toolkit, the Mission Essential Task List Program and Kids Identification Program (similar to the Amber System) and US Army Tactical Maps -- Mapping and Reporting Software Series.
Responsibilities:
• Analyzed, designed and developed standardized procedures and Visual Basic based tools for the testing and deployment of products.
• Conducted database design; development, table definition, construction and record set manipulations to produce reports and graphs for user and managerial data analysis through MS Access custom queries/reports.
• Maintained customer/project databases
• Processed output requests including files, financial reports, product reports, status reports, and graphic file specifications/requirements.
Environment: Visual Studio 6.0, Visual Basic 6.0, OOP, COM/COM, ADO, Microsoft SQL Server 2000, Visual Source Safe, .NET, VS.NET, VB.NET, .Net Framework, Windows 98/2000/XP, Active Server Pages (ASP), MS Front Page, IIS, Visio, Smart Draw 6, HTML, MS Project, MS Access 2000, Microsoft Office, Microsoft Excel, Photo Finish 4.0, Hijaak Pro, Adobe Illustrator, and Adobe PhotoShop 9.0/10.0/11.0.

Integic, Inc, 14585 Avion Parkway, Chantilly, VA 20151
October 1999 -- March 2002
Project Manager/Senior Programmer
I) “One Stop” -- US Army In/Out Processing System: Full-scale reengineering of in/out processing and an automated electronic workflow process to support hundreds of simultaneous users. Provided solutions that realized significant bottom-line results. Conducted a thorough business process analysis to identify areas where improvements could be made. The concept of a one-shop center resulted. The system automatically distributes information and track status, and provides clearance verification.
II) Defense Logistics Agency: Three Defense Supply Centers, Philadelphia - participate in this e-commerce application, Procurement Gateway is an integrated extranet, driven by a process that converts documents from a proprietary format to the universally accepted Portable Document Format (PDF) and posts them to the Gateway Web site.
III) Naval Air Systems Command (NAVAIR): Assisted in the design and implementation of an integrated, common entry point through NAVAIR's corporate Web infrastructure supporting thousands of USMC and US Navy customers. The NAVAIR portal equipped with a search engine that lets NAVAIR personnel quickly pinpoint relevant information. Includes specialized application access and information, such as e-mail, calendaring, Enterprise Resource Planning (ERP) and other personal productivity and core applications accessed right from the desktop. Includes “Collaboration Tools,” which allow personnel across the geographically dispersed NAVAIR TEAM to meet and share information on-line.
Responsibilities:
• Analyze architectural/system requirements, prepare work plans, perform validation testing, design, and develop, test and install software systems.
• Project manager and lead programmer in the design, development and implementation of the "One Stop" In/Out Processing system at Ft. McPherson, GA.
• Supervised the "One Stop", Sequel Server database maintenance and preparations for future integration into SIDPERS 3.
• Provide briefings and materials to more than 20 SES and Flag level military and government officials and other government agencies describing "One Stop" project.
• Other Integic Projects
• Develop data transfer controls, OCR Data acquisition and cataloging, Data file FTP, linking 26 remote warehouse sites with a central data hub using an Oracle database for the Defense Logistics Agency (DLA).
• Assisted in the design, development and operation of records acquisition (document OCR) archiving system for Apache at Redstone Arsenal, Huntsville, AL.
• Develop program modules for workflow integration/distribution, OCR information acquisition, automated Internet inquiry system at the Army Central Clearance Facility, Ft. Meade, MD.
• Develop and test the custom distribution workflow and email notification system at Cherry Point, NC (NAVAIR).

Environment: Visual Studio 6.0, Visual Basic 6.0, OOP, COM/COM+, DCOM, Active X, HTML/DHTML, VB Script, JavaScript, IIS, ADO, Microsoft SQL Server 7.0, Microsoft Query Analyzer, Oracle 7.0/8.x, Visual Interdev 6.0, Windows NT 4.0, Front Page, Adobe PhotoShop, Photo Finish 2.0/4.0, Hijaak Pro, WinZip 7.0/8.0, MS Word, MS Project, MS Office, ePower workflow, MS Visio, Smart Draw 6.0, OCR for Forms, Cold fusion 4.0, Adobe Acrobat 4.0/5.0.

AVM Software, Fayetteville, NC
May 1996 -- October 1999
Software Product Developer
I) Desktop Software Support System: Identify the precise nature of user problems, develop help desk procedures and provide a programming solution. Take what the user thinks their problem is and reduce to step-by-step instructions for problem resolution. Design and develop desktop software graphic products, with quality assurance and testing, including product application maintenance and support.
• Design, develop and implement a structured methodology for problem/error reporting and resolution users and problem data for analysis
• Develop and deploy organized, standard methodology for commercial software product development.
• Design and deploy 24/7 on-line product support, error-reporting procedures and help desk procedures.
II) Desktop Software Projects: These projects are related to different areas of concentration to satisfy retail product sales requirements. Some of the titles developed are The Mission Task List Program, Military Demolitions, The Professional Sniper and The Expert Field Medical Badge Test Study Guide Pro.
Responsibilities:
• Responsible for database design; development, table definition, construction and record set manipulations, report and graph production for user and managerial data analysis
• Develop and deploy over standard methodology for commercial software.
• Design and deploy 24/7 on-line product support, error-reporting procedures and help desk procedures.
• Maintained customer/project databases and processed output requests including files, financial reports, product reports, status reports, and graphics database files.
Environment: Visual Studio 6.0, Visual Basic 4.0, 5.0, 6.0, COM/DCOM, VB Script, JavaScript, HTML, MS Word, MS Access 95/97, MS Excel, MS Project 95/98, MS Office 95/97, IIS 4.0, ADO, Visual Interdev 6.0, Crystal Reports, Visual Source Safe, Windows NT 4.0, Adobe Acrobat, Adobe Photoshop, IE.


OTHER INFORMATION
Salary: Negotiable
Willing to Relocate: Yes
Availability: Immediate
Languages: Spanish (Military Rating - 2, 2); Russian: (Military Rating - 1, 1); Korean (Military Rating - 1, 0), Tagalog, Basic
Other qualifications: Qualified as Environmental Chemist (2 Years experience) and Toxicologist (2 Years Experience) using GC, Mass Spec, Flame Ionization, RIA, Chromatography, UV and other techniques plus wet analysis methodologies and data reporting.
Retired US Army Major, 26.5 Years with Worldwide assignments.
Over 25 years personnel management experience responsible for organizations of 400+ personnel

REFERENCES
Available on Request

Certifications
Operations Research/Systems Analysis (ORSA) US Military Qualified


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Dallas, TX | Resumes in Texas

View other VB / Database Developer/Project Manager resumes, Programmer / Developer resumes