Developer Data

Douglas T. Gherardi

Certified Microsoft Access Database Expert

Brooklyn, New York

Email: ************@*****.***

Dear Sir/Madam,

I am pursuing a position as a Data/Reporting Analyst or Microsoft Access/SQL/VBA Database Developer utilizing my experience and deep expert skills in Microsoft Access, SQL, Excel, and VBA. I am a Degreed Mechanical Engineer and a Microsoft Certified Access Database Expert with over ten years of New York City corporate experience designing, developing and administering all versions of Microsoft Access databases and Excel Spreadsheets. I am an experienced professional in all areas of Microsoft Access Database design such as; Relational Data Modeling to at least the 3 rd

Normal Form, statistical

data analysis, sophisticated nested Queries, complex robust Report design, User-friendly Graphical User Interface, and efficient VBA Programming. I am very experienced in applying complex business logic/processes to an underlying relational data model and building the requisite Microsoft Access Database with supporting VBA code. I look forward to discussing the details of any open Ms Access Database Developer or VBA/SQL Developer or Data/Reporting Analyst position with you at your earliest convenience.

Thank you for your time and consideration.

Sincerely,

Douglas T. Gherardi

Douglas T. Gherardi

Brooklyn, New York

Email: ************@*****.***

POSITION

Seeking Data/Reporting Analyst, Microsoft Access, SQL, or VBA Developer position. EDUCATION

M.S.

Columbia University, Manhattan, N.Y., 1996 - 1997

Master of Science in Applied Statistics, Psychometrics, Measurement & Evaluation in Education B.S.M.E.

Manhattan College, New York, N.Y., Graduated 1986

Bachelor of Science in Mechanical Engineering

CERTIFICATION

Microsoft® Certified Access Database Expert

SOFTWARE

Microsoft® Access all versions, SQL, Microsoft® Excel, Visual Basic Programming Language for Office Applications

(VBA), QlikView, PowerPoint, Word, Visio, AutoCAD, LISP, Mathematica, FORTRAN, Pascal, MathCAD. WORK EXPERIENCE

Jan2019– Current

Title: Microsoft Access Database Developer (Contract Work), New York Tri-state area

• Several short-term projects both on-site in the New York Tri-state area and remotely.

• Migrating data from legacy database systems and Excel Spreadsheets to both Microsoft Access 2016 and SQL Server Databases,

• Creating, developing and enhancing Forms and Reports.

• Creating and developing new Queries that captured new metrics data.

• Enhanced existing User Interfaces.

Feb2018– Dec2018

Company: RPS Bollinger Inc., Sports Health Insurance Company, Short Hills, New Jersey Title: Microsoft Access Database Developer (Contract Work)

• Supported & developed five MS Access Databases that supported the entire national operations of the company. This also included the Company Billing operations and daily Check creation.

• Successfully supported the migration of all the company’s software from a local network to a new Citrix VPN environment.

• Successfully supported the replacement of all desktops with new laptops throughout the company which aligned with the company’s goal of allowing all employess the ability to work from home during severe weather power outages.

• Authored a User-Manual for all MS Access Databases.

• Authored Process Document that encapsulated all the Data Models and Table relationships for all the MS Access Databases.

• Redesigned all the MS Access Reporting Processess by changing all Report formats from Microsoft Word Documents to Adobe PDF Documents.

• Major Challenge: All five existing MS Access Databases were designed over a period of seven years. Unfortunately, all the existing MS Access Databasses did not conform to standard Database industry best practices and as a result I was instructed to re-design the FrontEnds and the BackEnds as well as all the VBA programming code. I was able to successfully re-design the FrontEnds so that they were more intuitive for the Users and as a result data input efficiency increased substantially. I also redesigned a substantial part of the VBA coding for all five databases making it more efficient and easier to read, maintain & develop. Mar2017 – Feb2018

Title: Microsoft Access Database Developer (Contract Work) Worked various short-term corporate assignments in the New York Tri-State area as a Microsoft VBA Software Developer using Access, Excel and Word.

Feb2015 – Feb2017

Company: Align Communications Inc., Data Center Technology Company, New York, New York. Title: Microsoft Access/VBA Database Software Developer (Full Time)

• Sole developer in the Company’s Internal Tools Applications designed in MS Access.

• Redesigned, in MS Access, two of the major tools used by the Data Center Inventory Department. o One was named “D.C.I.” Data Center Inventory Tool, which was designed to capture and track all of the typical metrics associated with Data Center Inventory processes. o The second tool named A.S.M.T. “Asset System Management Tool”, was designed to capture and track the inventory and migration of Data Center Assets from one location to another. It also tracked the work flow process to facilitate the migration process.

• I was also responsible for supporting these two applications in production mode in the field. This required in-field tweaking of the two mentioned apps to conform to the particular nuances of the current client’s needs in the field. This at times required me to participate in the field with the teams who were doing the Data Center migration or inventory.

Sept2013 – Mar2015

Company: Credit Agricole French Bank, New York, New York. Title: Microsoft Access/VBA Database Software Developer (Consultant)

• Lead developer in the Bank’s global project to upgrade all of their Microsoft Office applications to MS Office 2010.

• Created a MS Access database which captured, tracked and reported on all of the Microsoft Office application upgrade status information with automated reporting.

• Manually fixed several hundred Excel and Access applications so that they functioned properly in MS Office 2010.

• Major challenge was engaging with all the floor traders who’s Excel and Access applications required manual fixing.

• Coordinated my efforts with a SharePoint application which tracked general information on the status of all upgrades.

Aug2013 – Aug2013

Company: Hofstra University, Long Island, New York. Position: Microsoft Access/VBA Database Software Developer (Consultant)

• Created and developed Microsoft Access Database, which captured, tracked and reported all student transfer course credit information.

• Automated the data import from the University’s central computer.

• The database was designed to communicate the transfer course credit information to all the appropriate department heads via email and Microsoft Word document templates.

• Automated the Report generation.

• Created technical database software documentation. Jan2013 – May2013

Company: Bank of New York Mellon, N.Y., New York.

Position: Microsoft VBA Software Developer (Consultant)

• Project Manager and lead VBA Developer for the Bank’s worldwide Microsoft Office upgrade project, which involved scanning millions of Microsoft application files to be upgraded from previous versions to MS Office 2010.

• Used an automated tool to upgrade most of the Microsoft Applications to MS Office 2010 and had to use manual remediation for the remainder.

• Created a MS Access Database Reporting Tool to track and report the team’s progress and metrics.

• Managed an offshore team in India which supported the upgrade project.

• Created the Project Work Flow Process Diagram.

• Created a 45 page Project Operating Manual, which detailed all the methodologies, procedures and protocols. August 2010 – Jan2013

Company: MetroTax Inc., Brooklyn, New York.

Position: Microsoft Access Database and Excel Developer (Consultant)

• Created and developed a Back-End Microsoft Sequel Server Database which tracked Sales, Inventory, Insurance, Travel & other Business processes totaling up to three million dollars in yearly revenue.

• Created and developed all of the User Interfaces for all office applications via Ms Access Forms with OBDC connections to the Ms Sql Server.

• Created and developed all Ms Access and Excel standardized reports.

• Extensive use of VBA scripting and sophisticated query design. June 2010 – Aug 2010

Company: A.I.G. Inc (LECG Corp. was the sub-contractor), Manhattan, New York. Position: Microsoft Access Database Developer. (Short-term contract)

• Created a database which captured and tracked Metrics associated with the status of ongoing global financial projects.

• The Front-end was created using MS Access 2010 with automated data input from a SharePoint portal.

• Created MS Access Databases/Applications to automate Human Resources global bonus payout calculations, compensation market data analysis, and head count reporting.

• Developed data input screens with calculation formulas and user-friendly auto-updates that eliminated errors and significantly improved controls.

• Designed import menu screens to auto-upload data from multiple Excel spreadsheets (local and international sources).

• Held meetings with users at both pre-design and post-design stages to gather requirements and solicit feedbacks, then, incorporated feedbacks at final post-design stage.

• Designed and wrote procedures manual to train users in managing the databases. Feb 2009 – Apr 2010

Company: Dept. of Homeless Services, New York City Government, Manhattan, New York. Position: Microsoft Access Database and VB.NET WinForms Developer. (Long-term contract)

• Maintained several Ms Access Databases with complex VBA code, which were used to track and process all NYC homeless adults with children from the Homeless shelters to subsidized apartment housing.

• Successfully created and rolled out a .NET WinForms Enterprise application using VB.NET and ADO.NET, which replaced three existing Ms Access Database applications.

• Wrote stored procedures in T-SQL (Transact-SQL).

• Created User .NET WinForms application documentation Apr 2008 – Apr 2008

Company: LISC Corporation, Manhattan, New York.

Position: Microsoft Access Database & Excel Developer Consultant. (Short-term contract)

• Successfully imported all the end of year Financial Excel Spreadsheet data into an existing Ms Access Database Financial Reporting Tool. The financial Excel data sets represented millions of dollars for the Operational, Fundraising and Grant budgets for the entire 2007-year for all LISC Departments nationally.

• There was significant massaging of the imported data sets so that it would conform to the existing relational data model.

• Modified existing EOY Financial standardized reports and sub-reports.

• Modified and developed complex nested Queries.

• VBA programming code development.

• Created a user-friendly Graphical user interface (i.e. forms) so that any user would be able to easily launch and preview and print all standardized Financial Reports. Oct 2007 – Jan 2008

Company: Entergy Corporation, Indian Point Nuclear Facility, New York. Position: Microsoft Access Database Consultant, VBA Application Developer. (Short-term contract)

• Successfully upgraded over two thousand inter-departmental Ms Access Databases from Ms Access 2.0 & 97 to Ms Access 2003. The Databases were being used to track and maintain the infrastructure of the Indian Point Nuclear Power Plant facility.

• The process of conversion included qc’ing the original unconverted databases then upgrading them using VBA automation and then qc’ing the final upgraded version.

• Created and developed two MS Access Database Applications, which automated the upgrade and q/c processes.

• More than 100 databases needed to be modified by upgrading the outdated D.A.O. VBA code to the current A.D.O. VBA methods.

Nov 2006 – May 2007

Company: College Board Inc., Market Strategy & Analytics, S.A.T. Program, New York City Position: Microsoft Access Database Consultant, VBA Application Developer. (Short-term contract)

• Created and developed a complex MS Access Database Application that employed a user friendly Interface, stored procedures, VBA code and linked SQL Server tables to manage, track and report S.A.T. Respondent Metric Data for High School Students across the United States and it’s territories and contained both student-level and aggregated data.

• The application used a series of complex nested Pass-Through Queries via a remotely located Oracle Database to capture snapshots of aggregated S.A.T. metric data over time.

• The Application was one of several primary reporting tools that the Director of S.A.T. Marketing and his staff used to leverage the S.A.T. product against it’s major Market competitors.

• Generated analyses of student participation and performance in College-Board programs.

• Coordinated closely with the Business Analysts to develop stored procedures to output summary data to standardized reports.

• Designed, developed, and implemented quality assurance procedures; developed test scenarios and documented issues.

• Developed and maintained procedures to extract load and validate data from Oracle into the Ms Access application.

• Wrote Ad Hoc Queries and generated reports on an ongoing basis.

• Completed the modeling, optimization and documentation of the Ms Access Database Application. Oct 2006 – Nov 2006

Company: Harlem Hospital Center, Columbia University, New York City Position: Microsoft Access Database Consultant, VBA Application Developer. (Short-term contract)

• Created and developed a stand alone MS Access Database application which tracked and reported the salaries of all Harlem Hospital Center Employees including the Staff Medical Doctors over a period of four years.

• Worked with the guidance of the C.F.O. within a very tight deadline of one month. The total salaries tracked for the four-year period was well over 400 million U.S. dollars. Jan 2006 – Sept 2006

Company: Pharmacon International Inc, Wall Street, New York City

(A leading Healthcare Management Company for pediatrics) Position: Microsoft Access Database Consultant, VBA Application Developer. (Short-term contract)

• Designing and developing Internet-based and IVR (Interactive Voice Response) patient assessment and evaluation applications using VBA and Microsoft Access and other development tools and components.

• Processing and evaluating large health system databases using Ms Access, generating resource utilization and benchmarking reports by applying advanced mathematical and basic statistical analysis

• Programming of computerized decision analytic and other mathematical models.

• Designed standardized Reports.

• Wrote stored procedures in T-SQL (Transact-SQL).

• Assisted in the development of the ALERTS Health-e-PAL chronic Health Management Program for pediatrics. Children enter their home test reading into the system database via phone (IVR) or Internet, and the information is forwarded to their doctor so they can monitor the patient in between visits. May 2005 – Jan 2006

Worked as an independent Microsoft Access Database Consultant on short-term database design projects in New York City.

Dec 2003 – May 2005

Company: Bankruptcy Management Corporation. L.A. California and Manhattan, New York Ranked Second in the Bankruptcy Industry during this time. Position: Data/Reporting Analyst, VBA Application Developer, Ms Access Database Architect. (Full-time position)

• Primary responsibility was using Ms Access Database techniques in uploading raw source Account Payables and invoice data, averaging in the millions of dollars, to the Company back-end Ms Access and Sequel server databases and then generating sophisticated reports and producing letters of Notice to Creditors

• Conducted data collection with accuracy, speed and relevance

• Interpreted data analyses accurately and communicated relevant details to non-technical staff

• Understood how individual analyses related to the overall business objective

• Remained accurate and positive under extreme pressure

• Meet court-ordered deadlines and carries out assignments efficiently

• Took ownership of tasks while remaining self-directed

• Communicated status, logic and results of analysis clearly and concisely

• Wrote stored procedures in T-SQL (Transact-SQL).

• Listened effectively when getting guidance regarding technical aspects of bankruptcy

• Managed documents effectively following internal document organization systems

• Provided reliable quality control over Bankruptcy data

• Created standardized Bankruptcy Internal Reports using powerful queries

• Created, developed & implemented several Ms Access Database applications incorporating BMC business rules and procedures. This included designing the Back-End and the Front-End (GUI)

• Created a “Preference Analysis” Application, which codified all the Business Rules and Bankruptcy Laws pertaining to a Preference Action in a Case. It was able to generate sophisticated reports based on the raw source data files from the Debtor AP system, which reflected various Preference scenarios. Jun 2003 – Dec 2003

Company: DOAR Communications Inc., Long Island, N.Y. A highly technical leading edge Litigation Support Services Company Position: Senior Data Analyst, VBA Programmer, and Developer. (Full-time position)

• Primary duties included working with databases to manipulate data, create load files and interface with existing systems for the purpose of delivering finished sets of data (i.e. Meta Data from files and electronic documents) to clients. Application of Access VBA and all aspects of Windows operations. Interfaced Ms Access data with well know litigation support applications (i.e. Concordance, IPro, LiveNote, Summation, CaseShare).

• Responsible for ensuring the accuracy and timeliness of document and metadata acquisition, aggregation, management, and distribution.

• Created and developed Ms Access modules to manipulate and track data and files from various locations using High Level Windows operations.

• Converted standard graphic files to PDF files with searchable OCR text behind each document.

• Created and developed standard Visual Basic code to enhance all Ms Access database applications. This involved the utilization of both DAO and ADO programming methods.

• Created User Friendly Front-End and Back-End Ms Access Database applications for inter office data information tracking. (i.e. Tracked Electronic Document Meta Data information and Employee Time tracking database)

• Interfaced with Managers, Information Technology, Client Services and Corporate development to troubleshoot system problems and come up with workarounds or ad hoc solutions. Apr 2003 - May 2003

Company: The Corporate Headquarters of Pfizer Inc., Controllers Group, Manhattan, N.Y. Position: Data/Reporting Analyst, Database Architect, and Developer. (Short-term contract)

• Chief Database Architect in the creation, design and development of a Microsoft Access 2000 database application called the “Fixed Assets Tool” which captured and tracked over $1,000,000,000 worth of tangible fixed assets (i.e. Land, Buildings, and Machinery) from hundreds of locations all over the world. These fixed assets were acquired through Pfizer Inc.’s acquisition of the corporate company Pharmacia Inc.

• Designed the Back-End relational data tables and the Front-End graphical user interface (G.U.I. i.e. data input forms, reports, drop down menu navigation)

• Coordinated the collection of business and technical requirements between Pfizer Inc.’s Controller’s Group and Information Technology Group with the Corporate Company of Ernst & Young’s Finance Group, which supplied all the financial fixed asset raw data.

• Designed and developed queries to calculate “Net Book Values” from Pharmacia Inc. and Pfizer Inc.’s “Fair Book Values” which were both linearly depreciated over a two-year time frame. Time frames were broken out into both quarterly and monthly periods. The tangible fixed assets from Pharmacia Inc. were re-categorized by Pfizer Inc., which resulted in a depreciated “Fair Book Value” for each fixed asset.

• Created a Financial Journal Entry report, which could then be exported directly into an Excel spreadsheet.

• Wrote stored procedures in T-SQL (Transact-SQL).

• Visual Basic Code creation and development with form event driven triggers.

• Successfully completed the functional rollout of the database application within an aggressive one month period. Feb 2003 - Mar 2003

Company: The Corporate Law Firm of Schulte Roth & Zabel LLP, Manhattan, N.Y. Position: Database Developer, Admin, Litigation Support Dept. (Short-term contract)

• Created, designed and developed a Microsoft Access Visual Basic database application called the “Database LaunchPAD”. This application enabled all Attorneys, Paralegals and Lit. Supp. Staff the ability to launch all the firms’ database applications, such as Concordance, Summation, Livenote with the appropriate database file. It kept track of who opened a database and when it was opened. Designed standard canned reports. The development included designing the Front-End data input forms and reports, Back-End relational data tables, and Visual Basic Code development.

• Performed data clean up and data quality control on Concordance and MS Access VBA databases for the Intellectual Property Dept.

• Uploaded scanned electronic documents into Ipro and Concordance using data load files.

• Created MS Access Visual Basic databases with real-time interfacing. Standardized databases, which were linked to the IPro document Images with the coded information in the MS Access database. The end-user would click a button, which would automatically launch the IPro application with the appropriate scanned IPro document image.

• Performed data manipulation on all databases so that they conformed to an efficient relational data model. Aug 2001 - Oct 2002

Company: The Corporate Law Firm of Kasowitz, Benson, Torres & Freidman LLP, Manhattan, N.Y. Position: Senior Database Administrator, Litigation Support Dept. (Full-time position)

• Principal database architect for the design & development of all the Law Firm’s MS Access databases for employment, bankruptcy, litigation, matrimonial & product liability cases.

• Designed & implemented a Database to capture, track, and redistribute over $2,500,000 to more than 450 cooperative apartment owners in Manhattan, N.Y., from a special master restitution fund.

• Designed a Case Management Tracking Database for all Law cases. The database tracked key dates over time and typical Attorney/Plaintiff/Defendant information associated with a Law case.

• Created, designed and implemented a Paralegal Resource Database. This enabled all Paralegals and Litigation support access to all Law/Paralegal Internet resources.

• Developed canned Case Law review reports for courtroom presentations and submissions.

• Uploaded scanned electronic documents into Ipro and Concordance image databases using standard data load files.

• Designed and implemented a Scanned Document Imaged Management Database system which tracked and viewed electronic documents in the IPro software and their associated coded information in the MS Access Visual Basic Database.

• Performed data manipulation on all databases so that they conformed to an efficient relational data model. Oct 2000 - Feb 2001

Company: A Wall Street Computer Financial Services Firm: Zeborg LLC, Manhattan, N.Y. Position: Microsoft Access Database Architect and Developer. (Short-term contract) Project description: Principal database architect for the Front and Back End design of a Re-engineering Financial Savings Tool/Database. Modeled the data to capture and track financial savings from a number of programs and projects for Zeborgs' client American Express. The Database was then able to apply Zeborgs' financial metric models to capture and report profit and losses over a five-year period.

• Built, tested, & implemented a user-friendly G.U.I. front end for all end users, principally C.E.O's & C.F.O's.

• Designed the Back-End data model to accurately capture existing and future data. The data model adhered to referential integrity.

• Designed database process to control & track savings for American Express programs over a 5-year period to facilitate achieving $1 billion in savings.

• Built metrics based "control board" (GUI) to ensure management can monitor savings realization and make any required mid-course corrections.

• Interfaced the Database with the Internet so that Managers could view real time data display including 3D charts and standard financial metric reports.

• Windows NT Environment using Microsoft Access on a Web Server. Mar 2000 - Oct 2000

Company: Fortune 500 Corporate Insurance Firm, Axa Inc., Architecture & Innovation Dept., N.Y., N.Y. Position: Microsoft Access Database Architect, Developer. (Short-term contract) Project description: Principal database architect for front and back end design. Built, tested, and implemented a replicated database to collect and track employee and consultant time spent on projects using Microsoft Access 97 in a L.A.N. environment. Multi-user real time data entry from two locations; one in Paris, France and one in Manhattan, New York.

• Built User-friendly G.U.I. front end for end users and also for the Timekeeper and Admin staff.

• Designed the Back-End data model to tag all hours by a department and team structure and tied this data to the appropriate programs and projects. The data model adhered to referential integrity.

• Report generation, including multi-level department roll-ups and missing time sheet status.

• System handled approximately 50 U.S.A. users and 100 Paris users. The data was synchronized automatically once a day to ensure current data between the two offices. Oct 1999 - Feb 2000

Company: The Corporate Law Firm of Proskauer Rose LLP, Litigation Supp. Dept., Manhattan, N.Y. Position: Microsoft Access Database Architect, Developer, and Admin. (Short-term contract) Project description: Principal developer and administrator for all Microsoft Access Databases.

• Created and developed all databases in a Client-Server environment for all national offices.

• Developed all Client-Attorney databases

• Created and administered a Conference database

• Created and administered a Multi-Media Client-Attorney Database with financials

• All databases incorporated mail-merge and report features

• Created standard GUI data entry input forms for all databases

• Created the relational data model and tables for all databases Oct 1998 - Aug 1999

Company: An Aerial Advertising Company AirLogo, Manhattan, N.Y. Position: Microsoft Access Database Architect and Developer. (Short-term contract) Principal developer on a three man design team which designed and developed a Microsoft Access Company Database, which included:

• Inventory

• Scheduling

• Client information

• Accounts Receivable and Payable

• GUI, Graphical User Interface

Jan 1997 - Sept 1998

Company: A Fortune 100 Marketing & Advertising Corp., Young & Rubicam, Manhattan, N.Y. Position: Microsoft Access Database Architect, and Developer. (Short-term contract) Project description: Collaborated with a team of Software Developers and Designers on the database design of a multi- million dollar global brand market research study. The project was conducted to understand how brands develop and decay. Data about different aspects of brand equity and consumer consumption were collected from about 10,000 brands from 20 different countries. It is the largest undertaking the company has worked on. My involvement with the project was as the principal database architect in the design, development and implementation of a one Gigabyte Microsoft Access multi-user Networked Database, named B.A.V., Brand Asset Valuator. The end-users primarily generated cross-tab reports and generated charts and graphs after using statistical data mining techniques. I also assisted with the development of the front end or interface for the end-users. This project involved a lot of one-on-one client contact with upper and lower management executives through out the database design process in order to incorporate all design parameters and specifications.

Jan 1993 - Jan 1997

Company: An Educational Software Design Company, FlashCard Software Company, Manhattan, N.Y. Position: Company Owner and Principal Microsoft Access Database Architect,Developer Project description: Managed a team of four people in the creation, design and development of a Microsoft Access Educational Foreign Language Software, which includes Spanish, Italian, German, French, Japanese and Chinese. The software was later compiled and distributed using the Microsoft Access Developers Toolkit. Mar 1991 - Jan 1993

Company: A Computer Aided Design Consulting Firm, Consulting for Architects Inc., Manhattan, N.Y. Position: Temp assignments as an AutoCAD Designer/Developer & Computer Systems Consultant I assisted in the design of architectural and engineering blueprints and all computer aided design applications. Assignments included Architectural, Structural, Civil, Electrical, and Mechanical Engineering design firms in New York City.

Sept 1986 - Feb 1991

Company: A Mechanical Engineering Design Firm, MDM Engineers P.C., Manhattan, N.Y. Position: Director of Computer Aided Design & Computer Systems. (Full-time position)

• Created the C.A.D. Department using the AutoCAD application software

• Responsible for all Architectural & Engineering projects designed in AutoCAD

• Established C.A.D. design standards and procedures, implementation, training and inter-department coordination.

• Modified the AutoCAD software, using Auto LISP, to meet the needs and demands of the Engineering design and production

Contact this candidate