SUMMARY:

• Programmer/Analyst with strong VBA/SQL skills specializing in Windows applications, full life cycle experience.
• Adept at working independently as well as within a team.

TECHNICAL SKILLS:

MS Access 2013/2010/2007/ 2003/2000/97 /7.0/2.0, MS Excel 2013/2010/2007/ 2003/2000/97, MS SQL Server 2014/2008 R 2/2000/6.5/6.0, Visual Basic for Applications (VBA), SQL, T - SQL, MS Visual Basic 5.0/4.0/3.0, ODBC, Data Access Objects (DAO), ActiveX Data Objects (ADO), Windows 7/XP/NT 4.0/ ME/95/3.11 Environments

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/Analyst (Consultant)

• Assumed development and maintenance of Project Matrix request ticketing system using MS Access 2013, VBA and SQL.
• Responding to user requests to the Database Support Team for assistance with various Compliance/Quality Assurance databases/spreadsheet programs using MS Access, MS Excel 2013 and MS SQL Server 2012, VBA and SQL.
• Writing VBScript files used to create user specific versions of databases to allow for free updating of front end databases.
• Creating and maintaining VBA code libraries which contain functions that can be called from any MS Access database that contains a reference to the library.

Confidential

Programmer/Analyst (Consultant)

• Maintenance and modification of Special Property Pricing and Data Cleansing tools using MS Access and MS Excel 2007/2013 .
• Writing and modifying MS Access and MS Excel VBA and ADO code to pass parameters to and execute SQL Server stored procedures and replace existing MS Excel data with updated data .
• Creation and maintenance of MS Access queries, tables and forms .
• Maintaining control and versioning of Special Property Pricing and Data Cleansing tools .

Confidential

Programmer/Analyst (Consultant)

• Development and maintenance of Inventory Barcode Management System using MS Access 2013/2003, system linked to SQL Server 2014 tables as well as using local tables, development of forms, modules, queries and reports, allows users to track current inventory by scanning barcodes of locations (such as shelves, bins etc.) and barcodes of inventory items.
• Development of Inventory Reporting System using MS Excel 2013/2003, users generate reports when opening their personal Excel file which would connect to the Inventory Barcode Management System using ADO and dynamically create tabular, pivottable and chart reports on separate worksheets with VBA.
• Development of Sales Tax Rates Importation system MS Access 2013/2003, system allows users to process current month sales tax rate information; sales tax rate .csv files are sent monthly from vendor, saved to permanent network location and imported to Access database for processing against previous months, archives past records for updated rates, uploaded into SQL Server 2014 database for use in intranet applications which allow users to search tax rate information by zip code or city.
• Ad hoc querying and reporting using MS Access 2013/2003and MS Excel 2013/2003.

Confidential

Programmer/Analyst (Consultant)

• Conversion of Client Request Management System to MS Access 2013/2010 .ACCDB format/MS SQL Server 2008 R2 from MS Access 2002 .ADP data project format /MS SQL Server 2000; maintenance, debugging and continued development of SQL Server database and .ACCDB, VBA programming, creating MS Access queries and reports.
• Creation, maintenance and modification of MS SQL Server 2008 R2 tables, stored procedures, functions and views, remediating existing MS T-SQL syntax for ANSI compatibility requirements.
• Creating run time dynamic MS Access SQL pass through queries with changing parameters to execute stored procedures previously linked in .ADP format.
• Maintenance and modification of Client Profile MS Excel VBA applications; importing SQL Server data using ADO, creating and modifying user forms, dynamically generating pivot table, chart and worksheet driven reports.
• Assisting remote users with connectivity driven errors.

Confidential

Programmer/Analyst (Consultant)

• Development and maintenance of Client Billing System and Billing Worksheets using MS Access and MS Excel - system imports and processes MS Excel and text files in multiple formats from multiple sources, and uses ODBC and DAO to extract SQL Server data into a MS Access database, applies complex criteria in queries to build output MS Excel files delivered to finance personnel to create taxable/non taxable billing MS Excel worksheets, development and maintenance of MS Excel formulas/VBA programs used in Billing Worksheets, ad hoc querying and reporting.

Confidential

Programmer/Analyst (Consultant)

• Assumed development and maintenance of North American Sales, Projected, and Innovation Reporting systems using MS Excel, MS Access, VBA programs for MS Excel and MS Access, Hyperion Essbase, and Nielsen Nitro.
• Systems used ODBC, DAO, ADO and Hyperion Essbase API calls to retrieve data for reporting from SQL Server 2008, Oracle 10/Hyperion Essbase for all reports, ad hoc querying and reporting.

Confidential

Programmer/Analyst (Consultant)

• Development of Mutual Funds Support Billing System using MS Access - system processes data imported from MS Excel data files, creates MS Access invoice reports which are converted to Adobe .pdf files using VBA, along with supporting Excel cusip-level detail files, all of which are programmatically attached to Outlook email messages and mailed to appropriate client contacts using VBA programs.
• Development of Financial Advisors MS Excel Global Investment Community tracking tool - system allows financial advisors to track investment products by sector, category and rating, developed using MS Excel and VBA.

Confidential

Independent Programmer/Analyst (Consultant)

• Providing modification, new development and debugging of clients’ various databases and spreadsheet applications using MS Access 2003, 2007 and MS Excel 2003, 2007.

Confidential

Programmer/Analyst (Consultant)

• Assumed development and maintenance of Client/Counterparty Integration System - system tracks novation and cutover statuses of clients/counterparties and trades being migrated from ABN AMRO to Confidential systems using MS Access 2007.
• Development of Excel spreadsheet applications for product stream users to indentify client ID issues using MS Excel 2003, 2007.
• Ad hoc querying and reporting requests using MS Access 2003, 2007, MS Excel 2003, 2007.

Confidential

Independent Programmer/Analyst (Consultant)

• Providing modification, new development and debugging of clients’ various databases and spreadsheet applications using MS Access 2003, 2007 and MS Excel 2003, 2007.

Confidential

Programmer/Analyst (Consultant)

• Assumed development of several, as well as new development of, International Equities, FX, Swap, Fixed Income, Trade Settlement and Cleanup Tracking systems, Reconciliation systems, Depot Breaks systems, Cash Breaks systems using MS Access 2003/2000/97 and MS Excel 2003/2000/97, maintenance and enhancement of systems at the request of users.
• Meeting with FX traders and trade support personnel to gather specifications for new development and modifications of reconciliation systems.
• Designed programs to dynamically create MS Excel pivottables, charts, and graphs from MS Access and MS Excel to provide statistics for Fails, Cash account and Depot account breaks.
• Designed import/export programs using MS Access to import/export data to and from text and MS Excel files sent from enterprise systems for processing, querying BPSA Sybase data warehouse.
• Migrated/converted legacy MS Access 97 databases to 2003 format.
• Created Reflection VBA macros to run daily cleanups into ADP records system.

Confidential

Programmer/Analyst (Consultant)

• Participated in development of Lens Index Tracking system using MS Access 2000 and MS SQL Server 6.5.

Confidential

Programmer/Analyst (Consultant)

• Designed and developed Escheatment Tracking System using MS Access 97, converted from DataEase 5.15 (Wrote DataEase export procedures required to be exported for use into MS Excel), development and maintenance of reports using Crystal Reports 7, wrote command files for installation of users’ systems, various reporting and maintenance on existing systems.

Confidential

Programmer/Analyst (Consultant)

• Designed and developed Year 2000 Vendor Compliance Survey using MS Access 97, analyzed, normalized and converted data from Lotus Notes 4.6, back end was later converted to MS SQL Server 6.5.