VBA Developer at State of NJ Department of Human Services-Office of Child Care

Applications Developer using VBA, MS Access and Excel based skills. Built and automated in house applications; gathered user requirements; documented all applications created; incorporated SQL into VBA code; assisted end users; performed maintenance on existing code; modified and updated current reports; Macros, formulas, functions and procedures.

SQL Programmer at Hackensack Meridian Health Care

Adjusted/formatted/gathered data for yearly IRS submission review; assignment involved work with VBA macros, pivot tables, functions/formulas; retrieved outside data sources for compilation; automated Excel worksheets with VBA/macros to filter redundant data; modeled and tested compensation metrics using VBA and formulas.

Access VBA/SQL developer at SPS

Workforce Optimization – Network and Infrastructure. Modified sales commission metrics reports; collaborated with business to modify, prepare and adjust reports; rolled up bi-monthly reports using Excel/SQL Server; automated spreadsheets with VBA; reviewed stored procedures to validate reporting process; documented modifications; created pivot tables for data analysis.

Access 2010 developer at Medtronic

Modified and debugged legacy MS Access 2010 applications.

Access Developer at Tyco International

Security products and services; Data analysis/development support for HR Reporting; Designed and built reporting applications using MS Access 2010 and MS Excel; Archived/migrated historical Excel 2007 data to MS Access 2010; Worked on SharePoint platform to upload MS Access / Excel applications and maintain backend DB environment; Programmed with VBA and SQL; Data modeling/automation of HR reports.

Access Developer at JPMorgan Chase & Co.

Mortgage Banking; Migration and SAS remediation projects; Built applications with MS Access 2007 and Excel VBA; Migrated Excel 2007 procedures/macros to MS Access 2010; Created and modified Excel reports; Interacted with SharePoint to link Excel and Access apps; Analyzed pre-production data for transparency and DB compatibility; Migrated data to SQL Server; Developed import/export routines.

Access / Excel Developer at AIG Inc.

MIS strategy team; Excel macros/Access VBA/SQL developer for MIS; Automated monthly HR compensation figures; Built Macroroutines and pivot tables; Data analytics including regional headcount and costs; Converted Excel templates to Access/SQL, scrubbed data.

Excel Support at Deutsche Bank

Excel data analyst for Global Infrastructure Technology; Analyzed spreadsheets for password discrepancies; Knowledge of C#, SQL, VBA; Provided data analysis for Asset Management group.

Excel / Access Developer at The Dow Jones Corporation

Financial applications developer for Dow Jones; Gathered business requirements; Developed for Wall Street Journal indexes; Worked on Barron's indicators; Wrote complex VBA/SQL logic; Ensured data transparency between XML, Illustrator and MS Access; Migrated reports to new platform; Created import/export routines with MS Excel/Access; Created dashboards.

Excel Support at Credit Suisse

Private Banking business report developer; Gathered requirements; Built/redesigned financial templates; Monitored credit risk and asset points; Worked with Excel 2003; Used advanced formulas and lookups.

MIS Mgr. /Ops Support II at Citigroup

Private Bank (Credit Control) role; Redesigned risk loss database; Performed daily credit risk metric analysis; Reconciled monthly reports; Gathered end-user requirements; Mentored interns; Built/maintained reporting using Business Objects and MS Excel; Helped in data warehousing and data mining to identify at-risk customers; Created dashboards and reports; Coordinated with audit/compliance teams; Led projects and training; Supported SharePoint integration for reporting and data access.

Access 2010 developer at Medtronics

Technical: Modifying and debugging legacy MS Access 2010 applications.

Access Developer at Tyco International

Business: Security products and services. Data analysis/development support for the HR Reporting group. Designed and built reporting applications using MS Access 2010 and MS Excel. Archived/migrated historical Excel 2007 data to MS Access 2010 databases. Worked on SharePoint platform to upload MS Access / Excel applications and maintain backend DB environment. Programmed with VBA and SQL. MS Excel VBA/SQL development involved importing and exporting to other MS Office applications as well as automating spreadsheet functions and procedures through macros. MS Excel front end work involved creating ad hoc spreadsheets involving complex functions and formulas as well as form design. MS Access DB development included creating Macro and VBA/SQL procedures to build and automate new and enhanced legacy files. Produced MS Access / Excel pivot tables and graphs through VBA/SQL programming. Monitored data transparency between excel HR legacy files and post-production MS Access databases. Analyzed

Access Developer at JPMorgan Chase & Co.

Business: Mortgage Banking. Consultant for Mortgage banking division. Development support for migration and SAS remediation projects. Built applications with MS Access 2007 and Excel VBA for end clients and staff. Migrated Excel 2007 procedures and macros to MS Access 2010. Created and modified Excel reports using formulas and functions. Excel/Access VBA/SQL included work with Arrays, pivot tables and graphs. Designed import/export MS Excel and Access VBA procedures to interact with other MS Office applications (i.e. PowerPoint Graphs, MS Word, etc.). Operated within share point platform to link MS Excel and Access applications while maintaining backend rights. Analyzed and validated all excel pre-development data for transparency and DB compatibility. Adhered to data transparency across pre/post production. Wrote complex business logic in VBA/SQL and helped migrate from Excel 2003/07.

Excel Support at Credit Suisse

Business: Private Banking. Report developer for Private Banking. Gathered business requirements from department managers and end-users. Utilized knowledge of Private Banking metrics in building and redesigning financial templates. Data analysis included monitoring of credit risk and asset points for high-net-worth clients. Development tools included MS Excel 2003. Devised complex formulas and functions for reporting templates. Spreadsheet analysis involved Lookup functions (Vlookup, Hlookup, match, index, offset, etc.) and formulas.

MIS / Data & Reporting at Citigroup

Multiple roles within Private Bank (Credit Control) including risk data maintenance, reporting and accounting controls. Participated in 2009 bailout program activities, mentored interns on database design and programming methodologies, implemented data mining/warehousing using Business Objects, and migrated legacy data to SQL Server 2005+. Led development of dashboards and ad hoc reports, ensuring data transparency and accuracy across systems.

CBNA/Audit & Compliance/Credit Risk at Citigroup

Supported the Audit and Compliance group as a developer, analyst and project coordinator. Designed and implemented summary reports for business groups, collaborated on SAP projects, developed MS Access/MS Excel overdraft reporting system using macros and VBA, migrated data to SQL Server, and created dashboards for executive review.