PROFILE:

18+ years’ consulting experience creating database applications and managing system development life cycles: working with clients to analyze and streamline business functions through automation; designing, developing, and deploying database applications; report writing/chart design; training users and providing general technical support.

IT SKILLS:

• MS SQL Server 2008/2005/2000 , Windows Vista/XP/2000/NT 4.x.
• MS Access 2010/2007/2003/ XP/2000, MS Excel 1010/2007/2003/ XP/2000, Visual Basic 5.0, PowerBuilder 6.5
• VBA 6.0, DAO 3.6, ADO 2.5.

WORK EXPERIENCE:

Confidential

Responsibilities:

• Designed and created a data management system for computer/electronics retail division to track orders, inventory, and sales.
• Trained sales staff to perform daily tasks involved in managing sales, customer interaction, and order processing.

Confidential, Alpharetta, GA

Responsibilities:

• Migrated MS-Access 2003 Database to 2010 and redesigned front and back end databases.
• Eliminated redundancies in table structures and relationships.
• Redesigned existing interfaces to improve user experiences by consolidating multiple data entry pop up forms as well as rewriting code to improve process flow.
• Created user guides (both technical and user)

Confidential, Malden, MA

Responsibilities:

• Redesigned existing database application to improve network and overall database performance.
• Migrated database from MS-Access 2003 to 2010, consolidated user interfaces, reports, and queries through the elimination of redundancies and creation of code.
• Rebuilt tables and modified existing relationships to improve data retrieval.
• Created technical and user manuals to assist with redesign process and track structural enhancements to database.

Confidential, Boston, MA

Responsibilities:

• Designed, developed, tested, and deployed a MS-Access 2010 database application for HR staff to streamline process of assigning job banding information to company-wide job titles.
• Database replaced cumbersome and inefficient use of Excel file in a multi-user environment.

Confidential, Framingham, MA

Responsibilities:

• Designed, developed, tested, and deployed a MS-Access 2010 database application used for emailing client sales and goals information by account.
• Integrated automated email functionality to send out report charts created during bi-weekly ETL data extracts.

Confidential, Framingham, MA

Responsibilities:

• Designed, developed, tested, and deployed ETL database applications used by Merchandising and Finance to manage scorecard reporting.
• Redesigned and streamlined MS-Access Scorecard applications.
• Provided knowledge transfer to business analysts upon completion of projects.
• Managed weekly MS-Access reporting.
• Provided automated solutions in the development and redesign of various existing MS-Access database applications.

Confidential, Boston, MA

Responsibilities:

• Rebuilt Graduate Enrollment database in Access 2010, migrating from Access 2003 version.
• Set up automated feeds to extract data from external sources (.csv and Excel files).
• Wrote queries to enable easy migration from one version to the other.
• Provided user and technical manuals.

Confidential, Framingham, MA

Responsibilities:

• Modified database structure to work efficiently in a multi-user network environment.
• Redesigned existing Access reports.
• Recreated Excel reports and charts referencing database in Access and integrated them to run seamlessly
• Automated data feeds into database to reduce data processing and reporting runs by 8 hrs to 1 minute.

Confidential, Boca Raton, FL

Responsibilities:

• Tasked with streamlining order processing and billing operations using Excel, Word, and Access automation.
• Redesigned existing Access databases to streamline data mining and cleansing operations against SQL Server.
• Worked with end-users to enhance existing database applications and streamline data management processes through automation with MS-Access, MS-Excel, MS-Outlook, Cognos, PeopleSoft, and Visual Studio.
• Liaised between end-users and project leads on MS-Access database conversion projects.
• Rewrote/consolidated database code, queries, forms, and reports resulting in streamlined business processes.
• Automated the execution of monthly processes to pull and load employee data into MS-Access databases and data validation for potential data issues.
• Redesigned a SQL Server database and SSRS reports using Visual Studio.net.

Confidential, Wilmington, MA

Responsibilities:

• Redesigned ROI database application to better serve client’s needs - including redesigning forms, reports, and table structures.
• Integrated time tracking functionality to provide accurate time keeping data for customer invoicing.
• Debugged existing VB application managing client’s business accounts and generating client financial reports.
• Documented and rebuilt deployment platform.

Confidential, Canton, MA

Responsibilities:

• Trained end-users to build Business Objects reports.
• Converted and redesigned MS-Access/Excel automated applications, providing technical support where needed.
• Reduced data mining times for three critical business processes by redesigning and streamlining existing database applications using automation in SAP, Business Objects, MS-Access, SQL Server, Lotus Notes and MS Excel.
• Redesigned MS-Access and Excel-based applications, converting them into SQL Server-based applications.
• Integrated manually intensive billing process using Word automation.
• Modified data management database application in preparation for migration to SQL Server platform.
• Migrated database backend to SQL Server 2005; converted queries to stored procedures and views where applicable; redesigned MS-Access front-end using unbound forms to minimize data flow and improved data access times.

Confidential, Boston, MA

Responsibilities:

• Enhanced an existing multi-user application used for logging insurance claims; created unbound forms to improve performance and stability in network environment.
• Streamlined VBA code for adding, editing, and updating data.
• Worked with end-users to improve miscellaneous features during testing and debugging phases.
• Created miscellaneous ad-hoc reports for department manager to help track claims processes.

Confidential, Cambridge, MA

Responsibilities:

• Created a multi-user application to store server inventory information.
• Developed user interfaces to export SQL server data into Excel and reformat data for distribution among end-users assigned to validate data integrity.
• Added custom security measures for data edit and update privileges to restrict access to sensitive information.
• Created reports to help principal users ensure compliance during data verification process
• Launched redesigned MS-Access/SQL Server database for improved performance.
• Restructured database tables on server and user interfaces in order to optimize performance across a VPN.
• Replaced remaining form and report queries with store procedures and views where applicable.
• Implemented and integrated additional user interfaces along with supporting objects into the front-end database in order to facilitate data processing.
• Integrated several business processes - bid submission based on material and labor estimates, purchase orders, billing/invoicing, and job scheduling.

Confidential, Boston, MA

Responsibilities:

• Modified existing reports based on evolving needs and simplified report creation and management processes.
• Created an error control interface to scan incoming data imports in temporary tables for discrepancies and allow user to make corrections before adding data to the application’s main tables.
• Designed and developed multi-user database applications for Accounting Department to process Homeland Security funding for municipalities submitted via Adobe .PDF documents.
• Integrated various database applications used by the Fiscal Department to track funding released to municipalities.
• Modified existing databases, user interfaces, and reports.
• Designed and developed a multi-user database application to facilitate data mining for monthly reporting; reduced hours used by 75%.
• Created reports to display monthly forecasts.
• Participated in testing, debugging, and adding enhancements at various stages of development.