PROFESSIONAL SUMMARY:

Applications Developer / Data Analyst / Reports Designer

TECHNICAL SKILLS:

Business applications: MS Office Suite / MS Office Tools/ Sharepoint

Database environment: Microsoft SQL Server Management Studio 2008, MS Access

Operating Systems: Windows / Mac OS

Languages: VBA / SQL

Modeling Tools: MS Visio

Reporting Tools: Business Objects / MS Access

PROFESSIONAL EXPERIENCE:

Confidential - Trenton, NJ

VBA Developer

Responsibilities:

• Applications Developer using VBA, MS Access and Excel based skills
• Built and automated in house applications for both Access and Excel platforms
• Gathered user requirements from business owners
• Documented all applcations created
• Incorporated SQL into VBA code
• Assisted end users/team in debugging desktop applications
• Performed maiintence on existing code
• Modified and updated current reports
• Other technical components in building reports and applications: Macros, formulas, functions and procedures

Confidential, Neptune, NJ

SQL Programmer

Responsibilities:

• Adjusted/formatted/gathered data for yearly IRS submission review
• Assignment involved work with VBA macros, pivot tables, functions/formulas
• Retrieved outside data sources from business users for compilation of final workbook deliverable
• Automated excel worksheets with VBA/Macros in order to filter redundant data
• Used VBA and formulas for modeling and and testing of compensation metrics

Confidential, Parsippany, NJ

Access VBA/SQL developer

Responsibilities:

• Modified sales commission metrics reports
• 50 % technical / 50 % working with the business to modify, prepare and adjust reports
• Worked with Excel/SQL server to roll up bi-monthly reports
• Used VBA in collaboration with application designer to automate spreadsheets
• Reviewed stored procedures to validate successful reporting process
• Documented all coding modifications and procedures for team members
• Excel work involved creating pivot tables for data analysis

Confidential, Eatontown, NJ

Access 2010 developer

Responsibilities:

• Modifing and debuged legacy MS Access 2010 applications

Confidential, Princeton, NJ

Access Developer

Responsibilities:

• 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 Sharpoint 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 and validated post production data for junior analysts

Confidential, Iselin, NJ

Access Developer

Responsibilities:

• 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

Confidential, NYC, New York

Access / Excel Developer

Responsibilities:

• Excel macros/Access VBA/SQL developer for MIS strategy team
• Report data to include monthly HR compensation figures for senior managers
• Automated current Excel templates to coincide with new parallel/database platform
• Body of Excel reports included building Macroroutines/scripts and creating efficient pivot tables via VBA/SQL
• Worked on converting Excel 2007 reports to MS Access 2007 Database
• Helped DB team gather user requirements and building import routines for Access DB
• Data analytics included regional, headcount, average cost numbers and metrics scrubbing

Confidential, Jersey City, NJ

Excel Support

Responsibilities:

• Excel data analyst for Bank technology division in support of the Asset Management group
• Research/analysis required knowledge of various language, procedures, scripts and snippets.
• Analyzed spreadsheets for password discrepancies and issues using Excel
• Research/analysis required some C#, SQL, VBA knowledge

Confidential, Monmouth Junction, NJ

Excel / AccessDeveloper

Responsibilities:

• Financial applications developer for Confidential Corporation, working onsite within the Market Data Group
• Gathered business requirements and made development changes with user groups
• Worked on Wall St. Journal covered indexes for U.S. major stock markets as well as bonds, rates and yields
• Worked on Barron's weekly included financial indicators for Gold and Silver prices
• Assisted Business groups and end-users in streamlining and proposing technical solutions for quality control, data analysis and post-live production
• Involved in writing complex business level logic in VBA/SQL
• Adhered to strict template rules governing data transparency between XML, Illustrator and MS Access databases as provided by the Market Data Group
• Imported/Converted CSV files to MS Excel
• Development tools included work with MS Excel/Access VBA, Adobe Illustrator CS2 and XML
• Foundation of work involved customizing MS Access/Excel 2003 Confidential reports for migration to June 2011 live platform
• Implemented cross-platform integration by using XML
• Created error handling routines for all macro and modules/worked with Lookup, functions and formulas during design/analysis stages
• Contributed to MS Access utility application which created a more efficient report development process

Confidential, NYC, New York

Excel Support

Responsibilities:

• 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 hi-net worth clients
• Development tools included work with MS Office Excel 2003
• Devised complex formulas and functions for reporting templates
• Spreadsheet analysis involved Lookup functions (Vlookup, Hlookup, match, index, offset, etc.) and formulas

Confidential, New York, NY

Student

Responsibilities:

• Completion in C# programming f Completion in ASP.Net / ADO.Net programming f Completion in SQL Maintenance 2008 f Completion in SQL Administration 2008
• Coursework in Web Development

Confidential, Long Island City, NY

MIS Mgr. /Ops Support

Responsibilities:

• Participant in 2009 Federal Government bailout program for Global Wealth Management
• Redesigned comprehensive department risk loss database
• Reviewed and analyzed daily credit risk metric reports for client exposure and risk loss
• Revised and reconciled monthly structured lending product reports
• Gathered business requirements from end users
• Mentored interns on database design and programming methodologies
• Performed complex calculations with Business Objects and MS Excel to allocate hedge fund accounts
• Imported large Business Objects CSV files to MS Excel/MS Access
• Designed queries for Business Objects Ad Hoc universe
• Validated data transparency guidelines between Business Objects metrics and MS Access tables
• Work involved extensive macro coding with MS Access and MS Excel applications
• Reporting tools include Business Objects and MS Access as backend sources/MS Excel as a front end platform
• Languages used include VBA and SQL
• Data mining / warehousing of finanical metrics using Business Objectsto indentify trends in prospective “At Risk” customers versus other High Wealth clients
• Archived/converted/ risk data from Excel 2003 to MS Access 2007
• Supported the Audit and Compliance group as a developer, analyst and project coordinator
• Designed and implemented summary reports for business groups within the department
• Collaborated on SAP project
• Met weekly with business officers, project managers and end users to formulate and update Project plans and special ad hoc reports
• Devised extensive MS Access/MS Excel overdraft reporting system using: macros, complex queries, import/exporting VBA routines, as well as functions and pivot tables
• Imported large CSV data files to MS Access/MS Excel
• Maintained data warehousing of MS Access tables using data normalization and cleansing schemes
• Developed department web site using Dreamweaver and MS Visio
• Successfully controlled project plans through initial startup and lessons learned
• Trained staff members on MS Project
• Submitted reports and documents via oral and hard copy presentations using advanced MS office suite
• Project coordinator: Assembled and analyzed project plans templates for future department mergers and acquisitions; advisor on all programming and technical issues
• Migrated MS Access database to SQL server 2005 platform
• Created front end interfaces and efficient dashboards for MS Excel/MS Access and Crystal Reports, with SQL server as a back end
• Developed and implemented excel functions and formulas such as Vlookup/Hlookup, index, match and aggregators
• Worked with web development team to design, maintain and debug intranet web site using .Net, CSS and HTML skills
• Reporting experience using SSRS and SSIS reports and analysis
• Share point administrator uploading project plans and consumer reports
• Helped with MS Access migration using SQL Server 08, MS Access 2003/2007 and MS Excel 2007
• Assisted in construction of web site design
• Used SQL server SSRS in conjunction with Visual Studio, XML and MS Excel based data sources
• Worked in SSIS management studio environment to create projects and packages as well as worked with import/export wizard
• Assisted in migrating legacy databases to SQL server
• Migrated/converted Credit risk data from Excel 97 to Excel 2003
• Designed and maintained front end Access database linked to backend SQL server
• Worked with data mining / warehousing applications seeking to establish future trends in Consumer Banking customersbased on location demographics between branch offices.
• Role as Business Analyst covering metric analysis and reporting
• Implemented trend analysis reporting with MS Exceland Crystal Reports
• Increased manual reporting process by migration to automated platform using MS Access/Excel and SQL server 2000 periodic metric reports for deviations from benchmark standards
• Converted (CSV) files to MS Excel and MS Access
• Built macro based reports
• Provided graphic statistical analysis and dashboards to management
• Responsible for developing operations database for website administrators
• Migrated/converted Excel 97 Bankcard data to Excel 2000