CAREER PROFILE:

• Programmer/Developer/Systems Analyst with excellent communication skills, adaptable technical ability, and diversified business experience. Ability to handle life cycle projects. Capable of working under tight deadlines while maintaining professional standards and teamwork. Experienced working with all levels of management.
• Over 15 years programming experience including experience in the financial industry.
• Ability to handle life cycle projects as well as work in a team environment.
• Ability to learn and master new environments and languages quickly.

TECHNICAL SUMMARY:

Proficient in MS Access, MS SQL Server, MS Excel, Visual Basic, VBA, T-SQL, ADO, DAO, ODBC, and Crystal Reports. Experienced working with Windows XP and Windows 7 operating systems.

EXPERIENCE:

Confidential

• Creation of a client server database using MS Access 2010 to be able to export data from a legacy database system IBS into LSMW Excel spreadsheets in order to export data into SAP.
• This included gathering business requirements for the project and creating written specifications for the project.
• Implement business rules into the MS Access database in order to export data properly to SAP.
• Assist in the creation of data mapping templates.
• Create LSMW Excel export templates.
• Create an MS Access database to be used for SAP data validation after the conversion project into SAP is completed.
• Create an MS Access database to create reports that were in the legacy database program that will not be in SAP.
• Create written documentation and help files for the databases.
• Teaching the users how to use the Access programs.

Confidential

• Creation of a client server database using MS Access 2010 as the front end and SQL Server as the backend.
• This included gathering all business requirements for the project and creating written specifications for the project.
• Conversion of multiple Excel Spreadsheets into the new database.
• Setting up the program so that certain users only have access to specific parts of the program.
• Working with an IT company to be able to allow users to dial in remotely.
• Teaching the users how to use the program.

Confidential

• Creation of a multi user MS Access database in version 2010 using Windows 7 to track all of the companies accounting processes. This included proposals, billing, work attribution, employee time tracking and reports.
• Gather all business requirements for the program and create written specifications for the project.
• Worked with the IT Department to get all computers properly setup to run the program. i.e. Runtime version, trusted locations, etc.

Confidential

• Convert an existing multi user MS Access database from version 2003 to version 2010 using Windows 7. This included fixing some existing bugs in the program.
• Restructured some of the tables in the database because they were not normalized.
• Created new forms to allow better use of data for viewing, editing and searching.
• Created new reports and modified existing reports.

Confidential

• Convert an existing multi user MS Access database front end with a DB2 backend from version 2003 to version 2010 using Windows 7. This included fixing some existing bugs in the program and also adding new functionality.
• Update and convert two VB.net programs with a DB2 database backend to run under Windows 7.
• Both of these projects involved dealing with upper management and end users to gather the specifications for the project. This also involved setting up Virtual Machines with different operating version XP and Windows 7 for testing and coordinating with the users to setup test scenarios and testing schedules
• Provided documentation detailing all updates and modifications to the programs.

Confidential

• Make modifications to existing Crystal Report reports to a Cost Profitability Analysis Model financial program using Visual Basic as a front end and MS Access as the backend using VBA.
• Creation of new reports using Crystal Reports and also modifying existing reports.
• Fix multiple existing bugs in the program.
• Also working with staff to decide which modifications need to be made to the existing program.

Confidential

• Create a MS Access 2007 client/server database to track scheduling of elevator inspections, clients, etc. This involved creating the table design and structure of the database, the creation of multiple input forms and multiple reports.
• Import existing data from multiple Excel spreadsheets into the new database.
• Cleaning the imported Excel data to be able to parse it into multiple tables.
• Teach the users how to use the program.

Confidential

• Conversion of an existing Access 2000 database to Access 2007. This was an overall redesign of the existing program converting it to a CRM System and adding new VBA code and modifying existing VBA code.
• Reworked the table structures including indexes, identity and foreign keys to fix existing issues.
• Create and modify existing Crystal Reports.
• Fixed multiple bugs in the existing program and also increased the overall speed of the program.
• Reworked multiple accounting reports and fixed bugs in existing reports.