SUMMARY:

10 years plus IT experience, has Strong VBA skills in both MS Access and Excel

TECHNICAL SKILLS:

Microsoft applications: MS Office Suite and MS Office Tools

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, Princeton, NJ

Consultant

Responsibilities:

• Designed and built reporting applications using MS Access, Excel and Sharepoint.
• 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

Confidential, Iselin, NJ

Consultant

Responsibilities:

• Built applications with MS Access 2007 and Excel VBA for end clients and staff
• 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.)
• Worked with share point platform

Confidential, New York, NY

Consultant

Responsibilities:

• Automated current Excel templates to coincide with new parallel/database platform
• Body of Excel reports included building Macro routines/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 include regional, headcount and average cost numbers

Confidential, Jersey City, NJ

Consultant

Responsibilities:

• Analyzed spreadsheets for password discrepancies and issues using Excel
• Research/analysis required knowledge of various language, procedures, scripts and snippets.
• Research/analysis required some C#, SQL, VBA knowledge

Confidential, South Brunswick, NJ

Consultant

Responsibilities:

• 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 Dow Jones 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

Consultant

Responsibilities:

• 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, Long Island City, NY

MIS Mgr. /Ops Support II

Responsibilities:

• 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 Objects to indentify trends in prospective “At Risk” customers versus other High Wealth clients

Confidential

Responsibilities:

• Devised extensive MS Access/MS Excel overdraft reporting system using macros, complex queries, and 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; development 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 using Vlookup/Hlookup, index and match
• 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
• 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 customers based on location demographics between branch offices.

Confidential

Responsibilities:

• Analyzed 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

Confidential, Torrance, CA

Applications Developer

Responsibilities:

• Designed reporting templates for Confidential management, credit risk and commercial loan departments
• Assisted MIS team in implementing database solutions for credit reporting and change management
• Debugged coded modules of junior developers
• Built and monitored M.S. project plan reports for the applications development team
• Technical support included work with UNIX batch files, MS office suite applications as well as third party applications