We provide IT Staff Augmentation Services!

Access Database Administrator Resume

5.00/5 (Submit Your Rating)

Jacksonville, FL

SENIOR DEVELOPER:
Access ~ VBA ~ SQL ~ DreamweaverPerformance and results-driven Applications Development professional with extensive experience in the design, development and implementation of full lifecycle systems development (SDLC) across government agencies, the Department of Defense, major corporations and small businesses.

  • Leads development activities utilizing Microsoft Excel and Access, VBA, Visual Basic 6, VbScript and SQL.
  • Advanced expertise in the development of technical and non-technical documentation.
  • Initiates, develops and delivers development projects in alignment with organizational needs.
  • Creates training materials, and conducts all levels of training for management and users.

CORE COMPETENCIES

  • Application Development
  • Technical Support
  • MS Access / VBA
  • Data Migration / Integration Training Material Development
  • Reporting
  • Tracking
  • Management and User Training

TECHNICAL COMPETENCIES

Languages: COBOL , VbScript , VBA , Visual Basic 6.0 , SQL , MySQL , T-SQL, HTML ,JavaScript , Coldfusion MX ~ CSS ~ QMFOperating Systems: UNIX ,Linux ,Windows (all versions) , SQL Server (2000 & 2005), DB2 ,Unisys , WangSoftware: MS Access (98, 2000, 2003, 2007, 2010) , MS Excel , MS Word , MS Power Point  , MS Outlook ,Dreamweaver MX , Adobe Photoshop , Flash Point , MS Project, RoboHelp ,Crystal Reports 2008 ,MS Visio ,Visual Source Safe ,PVCS , Oracle , SAP Business, Objects , SharePoint ,COGNOS 8 & 10 , AQT (Advanced Query Tool)

PROFESSIONAL EXPERIENCE

Confidential
Jacksonville, Florida , December 2011 – Present
An industry-leader in property acquisition and sales, loan origination services, mortgage processing services and process management services for bankruptcies and foreclosures.SQL Report Analyst III
As a member of the Default Solutions team work with team members and business partners to ascertain reporting needs, and develop and deploy reporting solutions utilizing SQL stored procedures and Crystal Reports.

  • Ensure timeliness of delivery to meet prescribed timeframes.
  • Thoroughly documented the Attorney Performance Reporting (APR) ETL process utilizing Word, PowerPoint and Visio.
  • Recommended process improvement strategies for the APR ETL process including the development of an integrated client configurable front end.
  • Train new team members.
  • Honored with an employee bonus and promotion to level III.

Confidential
Tallahassee, Florida , February 2011 – November 2011
An industry-leading technology services company, specializing in IT staffing.Access Database Administrator
Provided IT expertise for Technisource client Citizens Property Insurance Corporation. Produced COGNOS 8 and 10 reports. Utilized the Advanced Query tool to export data from the SQL server, legacy DB2 databases and the data warehouse repository. Imported data from backend data sources into MS Access 2007, facilitating Excel 2007 reports, as well as .csv and .txt files. Conducted internal development and COTS system analysis, including ePAS, WIND (DB2), POINT (DB2), IMS (Inspections), Image Right (Document Management System) and Image Right Reporting (BPR) to inform design, processing and reporting improvements.

  • Met reporting requirements by utilizing COGNOS Query Studio and the Image Right Reporting Tool (BPR) in collaboration with the company Business Analyst.
  • Facilitated the creation of ad hoc reports that identified operational improvements by developing an MS Access 2007 database to track agency calls that were forwarded to Citizens Underwriting Department.
  • Created database systems design documents, user manuals and implementation guidelines that included establishing MS Access 2007 database references.
  • Proactively developed 3 prototype database systems that included inspection ordering and processing, as well as management reporting, and enabled data merges with letters and forms and created Outlook emails.
  • Spearheaded change and testing for database modifications and augmentations.
  • Initiated security modules to hide the MS Access 2007 ribbon, tables, queries, forms and modules utilizing VBA.

Confidential, Columbia, South Carolina , March 2008 – Present
An entrepreneurial business IT consultancy.Consultant
Provides comprehensive support and programming services to small business owners and individuals, ranging from database and web development to training users.

  • Delivered professional database and web site services utilizing HTML, Dreamweaver MX, CSS, JavaScript, Adobe Photoshop, MySQL, SQL, Visual Basic 6.0, VBA, MS Access (2003 & 2007), MS Excel and MS PowerPoint.
  • Established web sites to incorporate latest technology including blogs, help systems, slide shows, PowerPoint presentations converted to flash presentations, videos and RSS feeds.
  • Developed databases that included an inventory tracking system, property management system, financial tracking system and contact management system.

Confidential
St. Louis, Missouri , September 2010 – October 2010
A multi-line health care enterprise operating primarily in two segments: Medicaid managed care and specialty services.Database Analyst – client: Absolute Total Care
Assimilated predefined Excel spreadsheet data in the production of a single online data file for the Information Systems Manager for state required report gathering. Partnered in the development of databases that tracked computer hardware and telecommunications inventory.

  • Redeveloped a corrupted MS Access 2003 database for the Pharmacy department.

Confidential
Greenville, South Carolina • June 2009 – January 2010
An IT staffing agency.Information Systems Data Specialist - client: Absolute Total Care
Prioritized and scheduled development activities to ensure accuracy and timely project delivery in cooperation with subject matter experts. Gained knowledge of SAP Business Objects to deliver scheduled MS Excel downloads and pro forma reports. Identified potential automated report candidates to guarantee timely reporting of pre-scheduled State delivery dates. Instituted sites, lists, libraries, document workspaces, data views, meeting workspaces, surveys and reports using SharePoint.

  • Empowered ad hoc trend data charts for Absolute Total Care’s Pharmacy Department with the development of a database system that interfaced with MS Excel 2003.
  • Saved extensive labor costs, enabled data verification, produced exception reports, and mail merged data into numerous data fields on multiple mail merge documents with the development of 2 database systems that immediately processed mail merge documents for Pharmacy Denial Notices and Pharmacy Prior Authorization Notices.
  • Slashed outsourced printing costs with the production of Absolute Total Care’s Medicare and SCHIP provider directories.
  • Championed a Right Fax Email Services module integration to automatically fax and merge data with minimal user interface.
  • Authored comprehensive user manuals, as well as systems and design configuration.

Confidential
Blythewood, South Carolina • November 2008 – February 2009
A global leader in providing technology-enabled business solutions and services.Data Analyst
Partnered in the Human Resources Affirmative Action team’s annual production cycle. Performed data mapping from 1 system for input and output to other systems.

  • Revamped MS Excel and Access modules to enable required output for other process entry.
  • Produced numerous MS Excel and MS Access reports.

Confidential
Marlboro, Massachusetts • September 2007 – February 2008
A full service solutions company specializing in staffing, technical recruiting and project management.Reports Analyst / Access Developer – client: Blue Shield / Blue Cross
Produced accurate and timely pre-scheduled, predesigned MS Access reports, identifying and remedying issues. Configured ODBC connections and developed solutions for SQL and QMF queries.

  • Developed reports with MS Excel, VbScript, VBA and Visual Basic 6.0.
  • Consulted with subject matter experts in determining problems and developing solutions.
  • Partnered in quality assurance (QA) operations.

Confidential • May 2006 – June 2007
Columbia, South Carolina
An entrepreneurial franchise operation, offering opportunities for individuals to own and operate their own in-home care service for the elderly, handicapped and disabled.Owner Operator
Drove all business activities and franchisee support. Served as the Enterprise Network Administrator, configuring computers and installing software. Created all business and franchise policies, procedures, and training manuals. Oversaw the activities and trained a 4-member office staff and a caregiver team. Developed and managed business budgets.

  • Developed a MS Access/MS Excel database system to track expenditures for importation into QuickBooks.

PREVIOUS EXPERIENCE

Confidential, Washington DC 
Applications Engineer

  • Saved on manpower and reduced the Law Firm’s directory production from 5 days to 10 minutes with the development of a text-based system that generated the Human Resources directory, and designed a web application to view and print the directory, as well as updating abilities to enable the Human Resources Department to update data on employees through the web.
  • Employed SQL DBA expertise in creating tables, security modules, queries, stored procedures and triggers.
  • Established sites, lists, libraries, document workspaces, data views, meeting workspaces, surveys, reports and web pages utilizing Dreamweaver, MX, Coldfusion and SharePoint.

Confidential, Baltimore, Maryland
IT Specialist (self-employed)

  • Performed network troubleshooting, updated user’s access rights, documented the network configuration and developed user software problem solutions.
  • Instituted a membership tracking system utilizing VBA and Visual Basic 6.0.

Confidential, Vienna, Virginia
Lead Programmer Analyst – client: Compaq

  • Created test procedures, plans and cases, and conducted client server unit, module and systems testing, as well as web based and mainframe applications, employing customized automated testing tools and manual processes.
  • Tracked test tracking with Visual Source Safe.

Confidential, Alexandria, Virginia
Programmer Analyst

  • Facilitated software vendors’ employee training participation tracking with the development of a training database (Access 2003, SQL and VBA).
  • Authored system configuration documentation and a user manual that included work flow diagrams, flow charts and system screen shots.
  • Provided technical training, guidance and resource support for end users.

Confidential, Washington DC
IT Consultant – client: Development and Modernization Department

  • Planned a development project to establish a property profile database, a budget tracking system and a building requirements database (Access 2003, SQL and VBA).
  • Identified and documented the client’s database business requirements.

Confidential, Minneapolis, Minnesota 
Programmer Analyst – client: Internal Revenue Service (IRS)

  • Ascertained and documented database business and reporting requirements, including work flow diagrams, flow charts, pseudo code, data mapping, system configuration and a user manual.
  • Instituted a Y2K access database contingency system for the recovery and restoration of operational functions, and used RoboHelp to develop an internal help system. .[Access 2000, SQL, VBA]
  • Trained system end users.

Confidential, Washington DC 
Management Information Specialist

  • Furnished technical directions for contractor related functions by partnering in the development of technical specifications, statements of work, task orders, requirements and other acquisition documentation.
  • Planned, developed, implemented, modified and maintained information systems in collaboration with contractors.
  • Interfaced with clients to absorb their business environment, budget process, IT technology products, as well as service needs and requirements.
  • Made IT product and service, contract vehicles, and financial process recommendations, and oversaw contractor performance, ensuring compliance with contract terms.

Confidential, Minneapolis, Minnesota
Systems Tester – client: U.S. Postal Service

  • Created test plans and cases, and tested legacy, client server and web applications, evaluating test results against expected results and recorded deviations.

Confidential. Washington DC
Programmer Analyst

  • Saved ~$150K by designing and choosing hardware and software, securing vendor services, and implementing a 5 user Novell Token Ring Network with 4 D.C. Housing Authority remote sites.
  • Participated in the organization of special projects, choosing inventory control hardware and software, resolving HUD OIG Audit findings, creating the warehouse budget, developing asset distribution tracking systems while meeting with upper management to coordinate activities, and leading local news network tours of the warehouse facility.
  • Received letters of appreciation for participating in the HUD OIG Audit Response Project and the Administrative Priority Task Force.
  • Managed contractor, software updates, program ad hoc reporting and user interactions.
  • Conducted and documented cost/benefit analysis for various COTS and customized software packages. While developing functional requirements.
  • Executed data conversion from the Wang Mini-Computer to the Netware Server environment, performing data integration to link warehoused data on the Wang Mini-Computer to the Netware Server.
  • Wrote training material, operational manuals, user guides and implementation manuals utilizing WordPerfect, and led informal and formal training sessions.

Confidential, Rockville, Maryland
Programmer Analyst – client: National Association for Journeyman and Plumbers

  • Wrote program specifications while coding, testing and implementing various applications utilizing COBOL, DPS-1100 and ECL in a Unisys 1100 environment.

Confidential, Greenbelt, Maryland
Programmer Analyst – client: U.S. National Guard (possessed Secret to Top Secret Clearances)

  • Performed data importation from the Unisys 1100 mainframe into an Oracle applications housed on a Unisys 5000 minicomputer, writing programs based on developed program specifications.

Confidential, Vienna, Virginia
Programmer AnalystDeveloped program specifications and coded, tested and implemented applications, created training materials, and led formal training sessions for HUD regional staff members utilizing COBOL, DPS-1100, DMS-1100, TIP-1100, QLP-1100 and ECL in a Unisys 1100 environment.

  • Honored with a Certificate of Appreciation for technical instruction in the training of CHUMS Phase II, form the U.S. Department of Housing & Urban Development, Washington, DC.

EDUCATIONComputer Science

We'd love your feedback!