We provide IT Staff Augmentation Services!

Database Consultant Resume Profile

SUMMARY OF QUALIFICATIONS

  • Excellent data analysis and reporting using Microsoft Access and VBA, Microsoft Excel on various database backends, including Oracle, SQL Server.
  • Advanced level Microsoft Access and VBA experience to streamline logistics, target marketing and fund raising efforts, and track donations, inventory and people.
  • Advanced ability to clearly communicate to both non-technical and technical staff regarding project issues, direction and milestones thus, enhancing inter-departmental relationships and business flow
  • Effective leadership and management skills to manage direction and tasks both for team and self, using eloquent oral and written communication to guide projects.
  • High performance in a fast-paced work environment with a keen ability to mult-task while meeting deadlines

TECHNICAL EXPERIENCE

  • Databases and Reporting: Microsoft Access, MySQL, SQL, SQL Server
  • Computer Languages: Visual Basic for Applications VBA ADO, DAO in Microsoft Access, SQL, HTML, JavaScript, CSS, SDLC
  • Operating Systems: Windows XP, Vista, 7
  • Browsers/Internet: Safari, Mozilla Firefox, Microsoft Internet Explorer, Google Chrome, FTP
  • Business Applications: Microsoft Excel, Microsoft Office Suite incl. Microsoft Publisher, Microsoft Project , Adobe Acrobat, Quicken
  • E-mail: Thunderbird and various webmail applications outlook.com, Google Mail

PROFESSIONAL EXPERIENCE DATABASE CONSULTANT

Confidential

  • Extensively utilized Microsoft Access and Visual Basic for Application VBA functions to analyze tables, modify and create forms, and migrate vast amounts of data.
  • Utilized Excel and Access to assist in data extraction, transformation and loading, ensuring report accuracy.
  • Maintained multiple databases after going live to ensure proper operations
  • Communicated, through written and verbal communication, to both technical and non-technical staff on status, issues, progress and testing.
  • Developed, debugged and implemented SQL Coding inside VBA Modules against an SQL Server back end for complex queries, using outer and inner joins across disparate tables when necessary.
  • Developed, debugged, documented and implemented VBA Modules to ensure proper operation and business requirements were executed efficiently
  • Developed business requirements and proposals for success measurement in marketing, fundraising, technical and business projects.
  • Created complex ad-hoc queries and reports with data extracted from various data sources to enhance efforts in fundraising and marketing.

INDEPENDENT DATABASE CONSULTANT

Confidential

  • Utilized Microsoft Access with Visual Basic for Applications VBA to analyze data and migrate to SNAP Health Center which used a SQL Server backend.
  • Utilized Excel to assist in data extraction, transformation and loading to assist in assessment of their database systems.
  • Developed SQL Coding against a SQL Server back end for complex queries, using outer and inner joins across disparate tables.
  • Maintained multiple databases after going live to ensure proper operations, including Backup, Compact and Repair and bug solutions
  • Developed Visual Basic for Application VBA functions in Microsoft Access to assist in data migration, extraction and analysis for Maryland State Department of Education reports to gain funds.
  • Analyzed MARC 21 library data for extraction and inclusion into required reports by the State of Maryland in order to obtain grant funding from the State.
  • Developed a complex and user friendly Student Information Management System in Microsoft Access for outcome-based data analysis to determine a student's direction, IEP and other needs.
  • Developed and executed data transformation SQL procedures in Microsoft Access to extract and transform data from a 4D database to satisfy requirements for the upload of data to State Department of Education.
  • Developed business requirements and proposals for success measurement in marketing and fundraising projects.
  • Created complex ad-hoc queries and reports with data extracted from various data sources to provide complete data so fundraising and marketing efforts were focused and effective.
  • Communicated to both technical and non-technical staff on status, issues, progress and testing.

SYSTEMS ANALYST

Confidential

  • Analyzed data and developed statistical reports for various workgroups and individuals in support of business goals.
  • Created complex ad-hoc queries and reports with data extracted from various data sources.
  • Extensively imported and exported data to/from Microsoft Access and other applications.
  • Cooperated directly with user groups and individual users to develop workgroup-wide database applications.

DATABASE ADMINISTRATOR

Confidential

  • Fully reverse-engineered, documented, designed, developed, implemented, supported and maintained multiple custom multi-user database applications as per workgroup requirements, including Computer Hardware Inventory, Storeroom Inventory and various material repositories using Visual Basic for Applications VBA and SQL to maintain data integrity, streamline operations and increase operations effectiveness.
  • Created complex ad-hoc queries using Access and SQL and reports with data extracted from various data sources.
  • Communicated to both technical and non-technical staff on status, issues, progress and testing.
  • Analyzed data and developed statistical reports for various individuals, workgroups and 3rd party entities in support of business goals.
  • Extensively imported and exported data to and from Microsoft Access from various applications and file types.
  • Created a front end and back end for different usergroups
  • Cooperated directly with user groups and individual users to develop workgroup-wide database applications to assist in their daily duties.
  • Gained, through initiative, general knowledge of employer's administrative and technology structures and components.
  • Led an internal technology organization to help define Information Technology initiatives in relation to education of visually impaired as well as support of administrative staff.
  • Documented standards and guidelines for the intended user base on developed database applications.
  • Consulted with executives in planning an enterprise-wide application for Student Information Management
  • Participated and consulted in Annual Plan meetings with Senior Staff for continual business and technological improvement so fundraising and marketing of services were effective.

FRONT END WEB DEVELOPER

Confidential

  • Led, managed and coordinated Web Development Team to meet challenging deadlines and requirements.
  • Cooperated closely with the creative team to help the company achieve branding and deploy their product on the Internet.
  • Created cut guides and images for continuity of design throughout the development cycle.
  • Developed HTML, JavaScript and Cascading Style Sheets CSS for production.
  • Documented standards and guidelines for the intended user base and development environment.
  • Documented required deliverables to the Web Development Team and from the Web Development Team.
  • Coordinated efforts with Engineering Team to ensure proper integration of HTML and JSP.
  • SENIOR LEAD CONTINUITY DIRECTOR Contract Confidential
  • Led and managed development team in exploring and implementing DHTML, HTML and CSS utilization.
  • Provided HTML prototypes for demo purposes
  • Provided HTML templates for my team and utilized quality checkpoints before delivery to the client.
  • Developed HTML, JavaScript and Cascading Style Sheets CSS for development and production.
  • Emerged as a recognized leader in helping increase quality and output of development team.
  • Enforced change control measures for faster delivery of the product and enforced coding standards to ensure well-formed HTML.
  • Gathered, documented and reviewed requirements from creative team and clients.
  • Cooperated with the client and the creative team closely to help the client achieve branding on the Internet.
  • Created cut guides and images for continuity of design through the development cycle of several websites.
  • Coordinated efforts between the creative and technical teams to ensure quality development for clients.
  • Maintained the file structure for archiving and version control.

Hire Now