Odenton, MD 21113
Phone: (410) 774-5814
Email: Vongie@vsdatabase.com
PROFILE AND STRENGTHS
Competent, intelligent, and personable computer professional with over 15 years of experience along with considerable experience developing and programming database and computer support programs. Computer literate in a wide variety of technology and software applications. Developed excellent reputation for creating, designing, presenting, implementing, and evaluating accurate and effective processes. Qualifications include:
|
· Communications · Computer Languages · Management Skills · Organizational Skills · Team Building/Motivation |
· Program Analysis · Program Development · Program Evaluation · Quality Assurance · Project Lifecycle |
· Strategic Planning · Support Services · Systems Requirements · Policies and Procedures · Project Planning/Budgets |
COMPUTER TECHNOLOGY
|
· Visual Basic (6 and .NET) · Visual Basic for Applications (VBA) · Microsoft Office 2000 Developer Tools v1.5 · Microsoft Office 2003/2007 · Windows XP/2000/2003/Vista (Client & Server) · Microsoft SQL Server 2000/2005 · SQL Server Reporting Services · Crystal Reports (Professional/Enterprise) · Microsoft Visual Studio 2003/2005 · Microsoft Exchange
|
· Relational Database Design and Development · File Management and Data Structures · Systems Analysis and Design · Microsoft Internet Information Server (IIS) · Web Technologies (HTML, FrontPage, JavaScript, SWISH and ASP.NET) · Windows Sharepoint Services · Configuration and Data Management · Microsoft Project and Visio · Microsoft Project Server · Knowledgeable of LAN and WAN |
Certified Help Desk Manager, 2002
Computer Consultant, 2004 – Present
Started and run a computer consultant company that specializes in database/web application programming utilizing the latest technology for a variety of clients. Developed operational, accounting and decision support systems for Museum, Postal Services, Churches, and other organization.
Database Systems Manager, Washington, DC
Scope of responsibility as the Database Systems Manager includes management of all database system, the Siriusware point-of-sale system for the museum ticketing and retail, and the Micros point-of-sale system in the restaurant.
· Project lead for designing and managing the online ticket system for the ISM.
· Project lead for upgrading museum Point-of-Sales systems by researching the product, visiting vendors, scheduling installation, overseeing training for end-users and IT staff, preparing for data conversion, and testing without any data loss.
· Coordinated and implemented new installations and/or upgrades with IT and other departments to ensure smooth integration of new or revised programs, procedures, hardware or software
· As lead developer/programmer on special projects my duties consist of designing, developing, planning and implementing the following programs
- Build eight computers interactive programs for the new “Enemy Within” Exhibit;
- Build Group Tour Schedule Calendar program. This program connect with the company point-of-sales system to pull and calculate schedule group tours information and populate the group schedule public calendar in Outlook for the administrative staff;
- Build database program that track and monitor museum hourly capacity for the Visitor Services Operatives and Managers in a Windows 2000 environment. This application is link to the point-of-sales system to pull and calculate tickets sales; and
- Build Guest Comment System for the museum. This system allow visitor to enter their information for survey and marketing purpose.
- a web front-end to an SQL-based Gift Card application
- a Capacity application/report
- a Help Desk application
· Scheduled automated backups of databases, query and stored procedure development, troubleshooting, and database performance monitoring.
· Issued user profiles and security authorization in Active Directory and other enterprise systems.
· Responsible for designing, customizing, and generating reports for executive and department managers from various database sources using SQL Server Reporting Services, Access, Excel (Pivot Table) and/or Crystal Reports this also includes writing or modifying stored procedures and/or queries.
· Interacted with end-user and acted as liaison between users and primary software vendor for customer support, conflict resolution, design specifications, and quality.
As the Team Leader of the IT Department my duties involve overseeing daily activities of an AV Technician, two Network Administrators, and a Web Designer. Manages IT activities to ensure successful completion of projects; provides technical guidance to the IT staff; assist in the recruitment, retention, and development of staff; serves as primary point of contact for end-users, department managers, and executive staff; manages IT administration, and personnel activities and schedules.
Sr. VB Programmer and IIS Administrator, Beltsville, MD
· Assisted and coordinated new installations and/or upgrades with departments to ensure smooth integration of new or revised programs, procedures, hardware or software.
· Hands-on experience resolving network and hardware problems.
· Designed and developed multi-user database application systems that track employee’s 401K contribution, loans, payment and eligibility status using Microsoft Access2000 and VBA in a Window NT environment.
· Designed and developed reports from IPC (Visual FoxPro) database application using Crystal Reports for corporate and remote locations.
· Creating reports from ABRA payroll system using R&R Report Writer and Crystal Report.
· Writing and debugging programs in Visual Basic for Windows NT and Citrix environment.
· Developed Excel macros using VBA to automate the process of fetching, formatting, linking, and embedding data into Access2000 for use in producing reports.
· Writing documentation's for programs and database applications.
· Worked closely with software vendor for design and reporting issues of IPC.
· Established and maintain liaison with other executive staff and outside vendor.
· Trained staff on Microsoft Office 2000, Crystal Report, and IPC database structure.
· Developed Crystal report programs with Visual Basic as the front-end. Passing parameters to Crystal from Visual Basic program.
· Implemented the company Intranet.
Sr. Systems Development Specialist, Washington, DC
(Sensitive Security Clearance)
· Defined and developed an Employee Service Center database application to track and monitor United States Postal Employee benefit information for the DC, Baltimore, and Virginia area using Access97 for the Employee Service Center Counselor.
· Writing documentation (Test plan, User guide, and Administrator guide).
· Supported and trained end-users on the database application.
· Deploying database on client server and remote sites.
· Maintained and enhance database as needed.
· Designed, developed, and implemented reports from Oracle database or stored SQL procedures using Crystal Reports for the General Counsel Law Department in Washington, DC. Conducting interviews with Attorneys and Legal Secretaries and creating data sets for building reports with Crystal SQL Designer.
· Posted crystal reports on the General Counsel Law Department web site using ReCrystallize Pro.
Application Support Specialist, Beltsville, MD
· Analyzed, designed, developed, and implemented reports from access database using Crystal Reports for 18 regional customers.
· Troubleshoot existing codes in Crystal Reports and Excel.
· Developed Excel macros using VBA to automate the process of fetching, formatting, linking, and embedding data into Excel for use in producing weekly management reports.
· Writing documentation on new reports and procedures.
· Designed and developed front-end Graphical User Interfaces (GUI) using Visual Basic.
· Retrieved and analyzed data using access queries, macros, and pivot tables.
· Priorities reports with management and staffing coordinators, generate reports and export to proper medium, identify problems in work-in-process/help improve processes, and validate and analyze data.
Access/Visual Basic Developer, Beltsville, MD
Defined and developed a scheduling database application using Access as the back-end and Visual Basic as the front-end. This application tracks projects status by departments.
Analyst/Configuration Management Specialist, New Carrolton, MD
· Configuration Management Officer for Y2K project. Responsible for tracking and documenting change task requests using Access. Meeting with external and internal customers.
· Automated marketing analysis weekly processes using VBA.
· Created reports using crystal reports from access database.
· Track software problem reports with the usage of Interactive CCR Automation System (ICAS).
· Scheduled and conduct software delivery package review meetings.
· Provided Configuration Management support to Project Configuration Management Board and Configuration Review Board.
· Provided Data Management support to the EOS Data and Operations System. Duties are, identifying, collecting, logging, and controlling contract deliverable items and drawings.
· Maintained and updated EMIS and Library database using FoxPro. Establish a library to retain copies of all official documents.
· Identified any executable files on the various EDOS nodes that have changed from the official baseline version using scripts in UNIX.
· Performed QA functions, such as conducting final physical configuration audits before deliverables.
Computer Specialist, Lanham, MD
· Created excel system to track budgets involving multiple managers, programs, and projects.
· Generated monthly analyses and reports on staffing activity.
· Compiled, calculate, and summarize statistic data for budget reports.
· Assisted other departments in updating and cleaning up errors in a FoxPro database system.
· Developed spreadsheet models for financial and logistical planning. Initiated, implemented, and managed Work Order Authorization audit for the department to verify compliance with company and government policies using Access.
· Supervised and manage three employees.
· Created reports using crystal reports from access database.