TECHNICAL SKILLS:

LANGUAGES: Visual Basic 3.0 - 6.0, Visual Basic for Applications (VBA), SQL, Lotus Domino

DATABASES: MS Access (all versions), Paradox, dBase III+/IV, FoxBase, FoxPro, Clipper, SQL Server, Oracle 9i

OTHER EXPERIENCE: MS Excel (all versions), MS Word, Crystal Reports, WordPerfect, Lotus 1-2-3, MS FrontPage, HTML

INDUSTRY EXPERIENCE:

Application Analyst

Confidential

Responsibilities:

• Provide support for systems reporting for the Default Practice/Real Estate software (Perfect Practice).
• Quickly learn new and older system applications and their working environments
• Gather and analyze user requirements
• Documentation skills are essential for tracking work tasks, projects, and the creation and reporting of metrics for delivered work product.
• Ability to analyze software applications. Design and develop application interfaces, if necessary.
• Work directly with end users and the management team to design application enhancements and custom reports.
• Provide timely and thorough documentation, report creation and maintenance procedures for all reports created or edited
• Project Management and managing multiple projects simultaneously will be a large part of this positions responsibility
• Advanced knowledge of database structures and search methodologies.
• Must be able to interact communicate with all levels of employees on a daily basis.
• Extensive knowledge of Microsoft Access, Excel and Crystal Reports.
• Design, integrate, troubleshoot, and maintain Crystal Reports, Access DB reports, and Excel files.
• Work independently on Crystal reports and similar automated reporting and analysis work
• Great communication skills and able to gather user requirements through written communications as well as face-to-face meetings.

Access Developer

Confidential

Responsibilities:

• Implemented multitudes of modifications and new development (VBA) in the Access application responsible for tracking all products for packaging, invoicing, billing and label printing among many other functions, including Excel 2010 VBA/reporting

Data Analyst

Confidential

Responsibilities:

• Supported the Marketing Category Analytics group, working with a multitude of Access databases using VBA to create files which were then ported into Excel 2010 spreadsheets to provide various weekly and monthly metrics for regional managers

Access Developer

Confidential

Responsibilities:

• Responsible for the day to day support and development of the company’s main database, as well as providing network support and database administration.
• Implemented many automated processes to provide real time appraisal and BPO work orders to appraisers nationwide

Data Analyst

Confidential

Responsibilities:

• Generated hundreds of weekly, monthly and quarterly reports meeting specific client-driven requirements using MS Access, MS Excel, COGNOS and TACL; documented steps where necessary and performed knowledge transfer for off-shore support

Consultant

Confidential

Responsibilities:

• Created personalized URLs, trigger emails and broadcast emails for financial institutions nationwide with respect to the Regulation E effort utilizing HTML, some Java and MindFire software

Access Developer

Confidential

Responsibilities:

• Wrote the application to run a data migration for a large pharma company into the Information Request Management System.
• Additionally wrote the validation protocol documentation

Consultant

Confidential

Responsibilities:

• Briefly supported the NJ office in writing LegaSuite microflows to automate mainframe batch operations

Consultant

Confidential

Responsibilities:

• Supporting the legal department by implementing modifications to a complex hierarchical Access database; providing various metrics to senior management as well as providing ad hoc reporting requirements

Consultant

Confidential

Responsibilities:

• Supported the Executive Advantage accounting program by obtaining spend and transaction data from Confidential and compiling monthly metrics to the program manager; provided analysis expertise for Marketing Operations; automated the import process (VBA) into Access as well as the formatting process in the resultant Excel spreadsheets (VBA)

Consultant

Confidential

Responsibilities:

• Supported the generation and posting of multitudes of milestone tracking reports on the corporate intranet for both internal and external management; modified several small MS Access applications to increase overall process efficiency; included analysis of data from one generation to the next to assure accuracy of systems providing raw data

Application Programmer

Confidential

Responsibilities:

• Supported modifications and new development of the internal dealer quote application (VB6, Excel VBA, ODBC) as well as the online dealer quote system (SQL Server, HTML, Java Script); provided back up help desk support for plant personnel; performed various network administrative duties as assigned (Active Directory, tape backup, new user setup)

Software Engineer

Confidential

Responsibilities:

• Served as part of the project team responsible for application remediation for the conversion to Windows XPSP2 and Office 2003, including the modification of VBA and VB code where necessary as well as the preparation of supporting documentation onto SharePoint

Consultant

Confidential

Responsibilities:

• Built an application using MS Excel and Visual Basic for Applications (VBA) for the Sales Representatives to develop and track equipment configurations for existing and prospective customers

Business Analyst

Confidential

Responsibilities:

• Built an application using MS Access 2002 and Visual Basic for Applications (VBA) for the Industry Customer Service Representatives to track a multitude of aspects pertaining to both incoming and outgoing call interaction with customers, including order tracking and hotlinks to applicable ship tracking websites
• Built an application using JWalk ("green screen" screen-scraper) targeted for the same users which provided the ability to read/write data in both AS/400 (JDEdwards) and MS Access data, presented seamlessly in a single front end
• Designed the company website using Nexgen's eCommerce software utilizing Lotus Notes technology providing the means for B2B specifically pertaining to order entry, order status and price & availability, as well as HTML pages; additionally redesigned the company’s industrial website
• Development of many additional databases (VB6, MS Access) utilized by personnel company-wide as well as automated daily spreadsheet application written in Excel VBA which also generated automated emails
• Responsible for registering the company's retail products in the 1SYNC Global Data Registry for synchronization with customers

Consultant

Confidential

Responsibilities:

• Developed an application in MS Access and Visual Basic for Applications (VBA) which is used to track volume and money pertaining to fuel exchanges between the client and approximately 40 partners

Consultant

Confidential

Responsibilities:

• Supported existing and developed new applications for the Corporate Billing and Human Resource departments (MS Access, Visual Basic, ODBC, VBA, VB, Excel and SQL Server), after having assisted initially with the Year 2000 compliance project