Technical

• Summary: Hardware: IBM PC XT/AT, IBM Mainframe
• Languages: VBA, SQL, MDX Essbase
• Software: Windows NT 4.0/XP, MS Access versions 95 2010
• MS-Word, MS-Excel, Visio, MS SQL Server 2005/2008,
• Monarch 11.1, Hyperion Report Tool 11.1.2, Essbase
• Concepts: Problem Analysis, Program design and techniques, RAD,
• Debugging, File updating and manipulation, Table handling.

Experience:

Confidential

Title Excel Developer/Hyperion Reports Developer

• Utilized MS Excel 2010 to modify and enhance existing report applications. Work included SQL development, VBA development, form development and report development.
• Utilized Hyperion Reporting Tool to convert existing Excel reports into Hyperion reports. Also utilized Essbase to validate datasets requested by users.

Confidential

Title Access/Excel Developer

• Utilized MS Access 2010 to modify and enhance existing global database applications. Work included SQL development, VBA development, form development and report development
• Implemented customized security in all applications that allowed for user login which controlled access permissions within the database and enhanced audit trail capability.
• Re-vamped reporting system. Work included initial report analysis to determine which reports were needed then worked with end users to enhance/create reports. Also used Excel 2010 to create customized reporting dumps so users could analyze data outside the system.
• Enhanced existing import/export so users could pass data along to local admins in central offices.
• Created documentation package for application handoff to individual countries. Documentation included user guides, database schemas technical documentation regarding code, and data dictionary.

Confidential

Title Access/Excel Developer

• Utilized MS Access 2003/2010 to create global reconiliation database application which allowed users to cull data from multiple data sources SQL Server, propiertary systems, internal flat files and reconcile data. Worked involved extensive query VBA development along with form development.
• Used Monarch 11.1 to create data templates which imported data directly from static reports.
• Used Excel 2003/2010 to maintain / upgrade existing Excel applications. Work included automation/logic development using VBA.
• Interfaced with the Enterprise team suggesting ways to implement existing Access/Excel apps into new .NET application being developed.
• Created Technical Documentation for all applications worked on. Documentation included technical documents that included data maps, explanations for all modules, queries and variables used in each system as well as external feeds.
• Created training packages for end users

Confidential

Title Access/Excel Developer

• Utilized MS Access MS Excel 2010 to streamline and automate an existing Excel Dashboard application. Work included creating a new data entry form which included drill down / filtering capabilities
• Created Technical Documentation for all applications worked on. Documentation included technical documents that included data maps, explanations for all modules, queries and variables used in each system as well as external feeds.
• Created training packages for end users
• Utilized VBA to calculate and capture data. Coding involved DAO recordsets, dynamic query creation and automation to port the data to the Excel Dashboard.
• Improved the functionality of the Dashboard by creating standardized ranges to accept data from Access., reducing the need for manual entry.

Confidential

Title Database Analyst/Programmer

• Utilized MS Access 2010, developed several new databases to assist with the EFT Fund Basket Creation. Databases were multiuser, housed on a Citrix server and deployed globally. Work included Front end form development, SQL/Query development and heavy VBA development
• Utilized MS Excel 2010 to develop tactical spreadsheet solutions for fund managers and support personel. These apps performed ETF investment calculations and featured input forms and FTP download capabilities. Work included VBA and form development with Excel.
• Acted as support person for existing UDT Tactical solution databases Access 2003/2007/2010 .
• Utilized Business Integration tools SSIS / SQL Server 2008 to create packages which imported data from various flat files and SQL Server into Access for processing and report production.
• Interfaced with the Company Strategy Development team a liason for integrating existing Access databases into .NET/SQL server solution.
• Created Technical Documentation for all applications worked on. Documentation included technical documents that included data maps, explanations for all modules, queries and variables used in each system as well as external feeds.
• Created training packages for end users

Confidential

Title Database Analyst/Programmer

• Utilized MS Access/MS SQL Server, developed several new databases to assist with the 941/941x processing and validation. Database front end as well as reports and reporting functionality was created in MS Access 07. MS SQL Server was used as the back end datasource.
• Updated a series of existing Access 03 stand alone databases to Access 07, ensuring operation, documentation and performing enhancements as needed. Also performed enhancements to allow existing databases to check for 941/941x validations
• Acting as a liaison between FISA and OPA, worked with the design team in the development of the new 941/941x process to be Utilized between both entities. This included the design of project flow charts as well as logic flow charts using VISIO.
• Performed daily data analysis on OPA data to ensure all data which passed thru the OPA verification process was correct.
• Utilizing Excel 07 Excel VBA, created a spreadsheet application utilized to validate W2 data passed from the FISA group as well as union working within NYC.

Confidential

Title Database/Spreadsheet specialist

• Performed updates on an existing legacy Access '03 database. Work included documentation, report writing, Query updates and planning analysis.
• Implemented an archiving solution which rolled off legacy data into an archive database, keeping 3 years current in production database. Work included development of new archive database, associated queries and development of a work flow to accomplish task.
• Analysis included analyzing existing manual work flows and see how best to include these workflows could be incorporated into the Access application.
• Maintained and updated existing Excel 03 spreadsheet applications Utilized in daily sales/advertising figures. Work involved updating spreadsheets and Excel VBA modules.
• Prepared complete documentation package which included all work flow information as well as software workflow, data mapping and code documentation of existing apps. This effort will be Utilized for an upcoming migration to be performed next year.

Confidential

Title Database/Spreadsheet specialist

• Worked on numerous in-house Access 07 databases and performed updates. Updates consisted of report enhancements, new logic, updating of queries and form development. All facets of Access were Utilized including extensive VBA and SQL development.
• Performed similar updates to in-house Excel 03 spreadsheet application Utilized to reconcile tax forms for large corporations. Work included updating various spreadsheet input forms, spreadsheet reports and associated modules .

Confidential

Title Database consultant

• As part of company acquisition, migrated data from old database to new Access 2003 database. Developed new structure which included table creation, normalization, and cleansing of the data.
• Developed custom queries for data analyzation and created extensive VBA modules to allow for automation as well as processing of data after import.
• Created custom reports within Access for various departments within HESS.

Confidential

Title Database consultant

• Utilized Access 2003, converted an existing Excel application into a standardized Access database. Work included all phases of Access including Form Report design, SQL and VBA development. Application was designed to allow for a multi user environment serving users both in Europe and North America.
• Utilized Visio to create new logic paths and data flows for project.
• Developed an export tool to allow data to be transferred into pivot tables for end user use.
• As lead developer, coordinated all user input requirements into Technical Documentation as well as rollout of product. Training was also conducted.

Confidential

Title Database consultant

Worked on existing Access 2003 database. Product was Utilized for HR and needed to have functionality added to it. Work included extensive VBA coding, SQL, form design and report design.

Confidential

Title Database consultant

• Working with the Risk analysis group, designed reporting database to replace current reporting tool Lotus Notes for the SOX reporting initiative. Utilizing Access2003, created user interface, reports both summary and detail reports on all processes, issues actions plans, Query design and application modules. Work covered extensive SQL and VBA.
• Performed data migration from aforementioned Lotus notes app. Created multiple downloads as well as a user interface to extract data utilizing Excel and import data into Access reporting database.
• Helped with design of new backend MS-SQL / Sybase to replace the current Lotus notes application. Work included data modeling Erwin as well database design/development utilizing DBArtisan.

Confidential

Title Database consultant

• Developed a analysis database in Access 2002 for the Six Sigma team to allow for Managers and Financial advisors to analyze and compare Merrill Lynch product lines. Included the integration of Fee schedules, Product calculators and multiple user interfaces.
• Coordinated mass data migration from multiple data sources as part of this effort.
• Work included extensive VBA coding, extensive SQL development, and data reconciliation/verification utilizing MS Excel, MS Access and T-SQL .

Confidential

Title Project manager/consultant

• Coordinated the Migration of 6000 Access97 databases into Access 2000. Work included project plan development, project team management and coordination of inventory of databases between multiple site locations.
• To help facilitate rapid conversion, developed step by step conversion guide for end users, allowing any a user of any expertise to convert his/her database.
• Acted as technical lead to convert those databases which had problems converting or had errors during conversion process. Performed troubleshooting where needed and converted the database after fixes were implemented.

Confidential

Title - Computer consultant

• Working as a database programmer/analyst, enhanced multiple existing Access 97 apps. Work included extensive Visual Basic coding, report development , SQL development, Excel VBA programming, fixing of existing bugs, and taking user requests.
• Participated in multiple facets of the overhaul of Horizon's database systems which included working on the IS solutions team. Purpose of this team was to develop and implementation of a strategy for replacing existing database structure with a new and more viable solution. Team worked not only on an development level but also on a company wide level, interfacing with multiple departments as well as cabinet level.
• Participated in the data migration/conversion project of existing Access databases into the FACETS Claims system. Project involved data cleanup field mapping SQL Server 2000 , and creation of an EDI interface to send data back and forth between the systems ASP.NET .
• Utilized Oracle SQL , extracted data from existing Oracle database to supply the new FACETS Claims system. Process involved writing multiple queries to update MS Access Transfer database which was Utilized to scrub data.

Confidential

Title - Computer consultant

• Acting as lead developer, enhanced existing Access 97 application. Work included extensive Visual Basic coding, report development , fixing of existing bugs and migrating app to Access 2002
• Addressed new user requests and developed an import module Excel 97 VBA which allowed for the integration of data from various vendors that worked with the Novartis Marketing Dept.

Confidential

Title - Computer Consultant

• Working as a Visual Basic Developer maintained and performed
• enhancements on purchased 3rd party software Utilized for maintaining
• patient records thru the hospital network. Work included extensive VB
• coding, module/class development, report development using Crystal
• Reports, and Data Dictionary development.

Confidential

Title - Computer consultant

• Acting as lead developer, inherited multiple Access 97 applications and refurbished/streamlined them into working order. Work involved table normalization, visual basic coding, reconstruction of the user interface and enhancing the overall app with various user requests.
• Joined all 4 applications into one large application. Back end resides on a central server while the front end is distributed to end user machines. Work involved table streamlining, logon interface and enhanced report development.

Confidential

Title - Computer consultant

Enhanced existing Access 2000 application. Work included extensive Visual Basic coding, report development and the fixing of existing bugs.

Confidential

Title Web Master

Utilized MS Front Page, developed, maintained and enhance website for the REB foundation. Work included Page development, ASP development HTML coding, and Java script coding. Also designed a database interface to allow new users the ability to not only register with the site but to also allow simple searches for members..

Confidential

Title - Computer consultant

• Acting as project lead, developed, implemented and maintained application for engineering dept. Designed custom menus, queries, reports and forms within a self contained format for Central Engineering Dept. Process also included upgrading existing apps from Access 2.0 up thru Access 97..
• Responsible for implementation and distribution of runtime versions utilizing Access Developers Tookit on all engineering department laptops approx 75 users ..
• Developed on-line help modules to be incorporated into application.
• Developed/implemented/performed training for new users. Also performed help desk support for developed applications

Confidential

Title - Computer consultant

• Utilized PowerBuilder/SQL Server. Work included datawindow and window development, powerscript coding for department applications, and SQL coding.
• Utilizing Access Visual Basic, developed and maintained
• programs for the accounting department ,and, provided help desk
• support for end users.
• Prepped macros for migration into PowerBuilder/SQL Server 6.0 database by acting as an interface between SQL DBA and mainframe DBA.

Confidential

Title - Database Administrator/Programmer Analyst

• Provided QC/Database Administration for the Hardware Services
• Department utilizing Access.
• Developed a secondary shipping/receiving system utilizing Visual Basic Microsoft Access. This system was Utilized to interface with in-house help centers via client server and involved macro/module development and database development.
• In conjunction with aforementioned shipping/receiving system, developed a second database using Microsoft Access. This was Utilized to monitor productivity in Hardware Services Department. Reports, Queries, Data entry forms Custom menus were created to accomplish daily tasks.

Confidential

Title - System Administrator/Programmer

• Planned and installed a Laboratory Information Management Network, serving 32 users in company. Researched both software and hardware which would best suit my company's needs and coordinating an implementation schedule for wiring, hardware, and software. System was implemented and running in three weeks.
• Utilizing SCO UNIX performed system administration functions such
• as database security, backup/restore functions, file maintenance, and
• maintaining system integrity.
• Utilizing Progress and Xponent, performed maintenance and developmental programming, involving customizations/creation of on-screen menus, company reports, data entry screens, and database field manipulation. Also, maintained database integrity by writing code to fix mistakes quickly and efficiently, without having to bring down the system.