SUMMARY

• Application Design and Development
• u Designed and developed a wide variety of applications, including:
• Tracker application suite - captures opportunities to drive coaching / training at the front lines of customer support leading to better trained agents and happier customers.
• ACH and Monthly Electronic Remittance Reports reduced time to create the report from 30 minutes to 30 seconds
• Accounts Payable Invoice Approval System distributes and tracks invoices for payment approval. Maintained detailed audit trail making the system SOX compliant.
• Management
• u Staff Manager responsible for as many as 15 consultants.
• u Led successful application design project teams, including a White Glove Customer Support application, from inception through completion. This application played a large role in reducing customer turnover by 20 in 6 months and improved program efficiency by 90 .

Programming Languages and Technologies

Visual Basic VBA, VB6, VB.NET, .NET ASP.NET, VB.NET, C, SQL / SQL Server, LINQ, MySQL, HTML, PHP, Cascading Style Sheets CSS, CSS Frameworks Blueprint, JavaScript, jQuery, AJAX, ToolBook

Software

Microsoft Office Access, Excel, Outlook, PowerPoint, Word, Project, Visio, Microsoft Visual Studio, Microsoft SQL Server Management Studio, DevExpress .NET Controls, CoffeeCup HTML Editor, HomeSite HTML Editor

Volunteer Service

Juvenile Diabetes Research Foundation JDRF, Boy Scouts of America, Lustgarten Foundation, American Federation for Suicide Prevention, My Way Home Animal Rescue, Hamilton United Methodist Church, St. Luke's United Methodist Church, Neptune Little League, New Jersey Marathon

Employment History

Confidential

Web Application Developer

• Develop enhancements to existing web-based software servicing the insurance industry. Write SQL queries and update HTML. Create ASP.NET enhancements to the application using C .
• Reduced template generation time by 50 through Microsoft Word VBA automation.
• ASP.NET, C, LINQ, SQL Server, HTML, CSS, Word, VBA

Confidential

.NET Developer

Consultant on contract with International Flavors Fragrances IFF . ASP.NET application for tracking and analyzing chemicals using Visual Basic and Oracle. The application was already in-progress when I was brought in to complete. I was responsible for page layout, application code and database interaction. ASP.NET, VB.NET, ORACLE, HTML, CSS, jQuery, AJAX

Confidential

Data and Application Specialist

• Built ASP.NET applications using Visual Basic and SQL Server used to improve data collection, retrieval and analysis. Met with end-users to gather requirements, designed and built web interface, wrote application code, database interaction and was responsible for all back-end database requirements.
• Migrated four 4 Access databases into a single web-based application with a SQL database back-end. Cleansed the data and implemented controls to ensure uniform data input. The application was designed to assist with identifying potential insurance fraud and therefore the data needed to be as consistent as possible. ASP.NET, VB.NET, SQL Server, HTML, CSS, Excel, Access, VBA, AJAX, LINQ

Confidential

Microsoft Excel/VBA/VB Developer

• Consultant on contract with Ann Taylor in New York, New York as a Microsoft Excel / VBA Developer. Automated the data collection and report generation process. Using Excel VBA I automated the consolidation process of bringing data from multiple, disparate spreadsheets into a single workbook for reporting purposes. Wrote custom functions such as a multi-criteria VLOOKUP . Excel, VBA
• Provide technical expertise, advice and development services, as-needed. Develop Microsoft Excel workbooks and write VBA code to automate repetitive processes.
• uCreated workbook to prompt user for data file, imported data, removed bad data, created and formatted chart thereby improving efficiency by more than 200 .
• uDeveloped the technical guidelines for the redesign of the customer-facing corporate website. The new site has resulted a dramatic rise in customer inquiries.
• uDesigned and developed the Spec Sheet functionality allowing the customer to print information for a single product. Site makes extensive use of HTML, CSS, PHP and PostgreSQL.
• Excel, VBA, HTML, CSS, PHP, PostgreSQL

Confidential

Software Engineer II

• Developed ASP.NET web applications with VB.NET, C and SQL Server to aid and improve the day-to-day operations of the company as-well-as acting as an in-house Microsoft Office developer and consultant. Collect user requirements, write specifications, create and maintain project plan, manage project change requests and project changes. Create and maintain SQL Server databases. Write SQL procedures and automated jobs to perform tasks at regular intervals.
• Created more than 50 ASP.NET and 10 Microsoft Office-based applications servicing every area of the company's operations. These applications continue to save the company over 250,000 per year in increased productivity, error reduction and improving the customer experience leading to increased retention.
• u ASP.NET applications include:
• Wireless Phone Bill application - lead to identifying and saving 70,000 a month due to waste and abuse.
• Fitness Center Management application allows employees to register for the on-site fitness center, request lockers, change payment plans, etc There is a administrative section to allow the fitness center management to send mass e-mail announcements, assign lockers, cancel memberships and other administrative functions.
• Tracker application suite - captures opportunities to drive coaching / training at the front lines of customer support leading to better trained agents and happier customers.
• Accounts Payable Invoice Approval System distributes and tracks invoices for payment approval. Maintained detailed audit trail making the system SOX compliant.
• u Microsoft Office applications include:
• MIS Employee database included information such as start date, scheduled training, requested training and scheduled days off for all MIS employees. This application gave the managers the ability to track and report on training and availability of their direct reports.
• Vonage Outstanding Example VOX application was a hybrid ASP.NET / Microsoft Office application. The web front-end stored data in a Microsoft Access database. . The application performed an automated mail-merge in Word using data from the Access database to create personalized certificates. This application improved efficiency of the collection of data and distribution of certificates by more than 250 .
• ASP.NET, VB.NET, C, SQL Server, HTML, CSS, VBA, Excel, Access, PowerPoint, Outlook, Word

Confidential

Paragon Computer Professionals

• Staff Manager with as many as 15 consultants reporting to me. Duties included training new consultants, approving timesheets and expense reports and the first line of contact with the consultants' client manager. I also acted as a Technical Interviewer responsible for testing the expertise of prospective Paragon consultants, as-well-as existing employees looking to broaden their skill sets.
• Consultant on contract with Bristol-Myers Squibb in Princeton, New Jersey as a Microsoft Office / VBA Developer. Under direction from the business analyst I was responsible for all aspects of the SLA Scorecard development and acted as the Microsoft Office SME for the group.
• u Identified an irregularity with the data and created an Access-based application to parse Audit Trail data from REMEDY Help Desk Ticket extract. This data more accurately reflected ticket resolution performance and saved the company 1,000's each month.
• u Created Excel Add-Ins to store and retrieve PivotTable filter settings and document all aspects of a workbook including forms, code, named ranges and formulas. This allowed the user to create pre-defined, complex reports and recall for later use.
• u Automated the creation of numerous PowerPoint presentations used to report metrics. The reports are created in Excel and charts are dynamically created, copied and pasted into appropriate PowerPoint slides. This process is all done with Excel and is transparent to the user. The reports were then able to be run overnight thereby freeing up man-hours during the business day.
• Excel, VBA, Access, PowerPoint, Word

Adjunct Instructor

Responsible for teaching computer classes to students of varying skill levels. Classes taught include: Basic Computer Skills, Introduction to Windows and PowerPoint, The Internet and Application Integration, Microsoft FrontPage, Microsoft Publisher and Relational Database Management with Microsoft Access

Confidential

Access/Excel/VBA Developer

Developed and administered a multi-user Access database for tracking temporary personnel assignments and processing payroll. Led small group responsible for analyzing and cleansing data. Data was consolidated from existing data in the form of Excel spreadsheets submitted by various business units. Created daily management status reports. Automated data import and ad-hoc reporting using VBA. Excel, Access, VBA

Confidential

Microsoft Office/VBA/VB Developer

Consultant on contract with Arch Insurance in New York, New York as a Microsoft Office / VBA Developer. Created a multi-user Access database for the Operations Department to track the status of insurance policies from inception through issuance by importing new policies from an Excel spreadsheet automatically on a regular schedule. Reports were scheduled to be created and exported to Excel and automatically distributed via e-mail using Outlook. The database made extensive use of VBA to import and export data, automatically update forms based upon user action, perform record searches and send e-mail, as well as SQL queries created on-the-fly for ad-hoc reporting. Automated creation of PowerPoint presentations. Excel, Access, VBA

Confidential

Excel / VBA/VB Developer

Consultant on contract with Cadbury Adams USA in Parsippany, New Jersey as a Microsoft Excel / VBA Developer. Created SKU tracking and reporting application using Excel and VBA/VB. The application is a catalog of all SKU numbers used by the organization. Created user form for data entry. Automated all aspects of application maintenance including backup, field heading changes, password changes and adding SKU families . Excel, VBA

Confidential

Technical Assistant:

• Conceived, designed and created multiple Visual Basic front-ends for creating and distributing reports. The Report Switchboard application controls all aspects of the report generation process from preparing the raw data to sending finished report via e-mail to all on the distribution list. This front-end controlled Microsoft Excel, Microsoft Access, Crystal Reports, Monarch and Lotus Notes Mail via OLE Automation and maintained a record of when the report was last delivered along with the next due date. The Ad Hoc Reports application allowed various reports to be viewed Crystal Reports, printed, saved to file Excel and/or e-mailed. These reports accessed data in an Access database via SQL in Visual Basic. Created applications for Microsoft Word to search for and print only required data from large reports on-demand using VBA.
• u Dramatically reduced the time required to create reports while improving accuracy
• Closed-end MOB Report from 4 hours of manual work to 30 seconds Visual Basic /Excel
• Non-Suspense Monthly Report from 1 hours to 45 seconds Visual Basic /Access/Excel
• ACH Report from 30 minutes to 30 seconds Visual Basic/Excel
• Monthly Electronic Remittance Reports from 20 minutes to 30 seconds Visual Basic/Excel

Confidential

Excel / VBA/VB Developer

Consultant on contract with Honeywell International in Morristown, New Jersey as a Microsoft Excel / VBA Developer. Updated and enhanced existing reports using Excel and VBA/VB. Added and improved the readability of all charts and graphs. Created User Form to aid in data entry and review. Created custom functions and used array formulas to make the application more flexible and easier to maintain. Excel, VBA

Confidential

Excel / VBA/VB Developer

• Consultant on contract with Mercedes Benz in Montvale, New Jersey as a Microsoft Excel / VBA Developer. Created an Excel application, driven by VBA/VB, to automate the report-generation process. The application imported a Sybase-generated, comma-separated, data file containing approximately 3,000 records into a main worksheet and then creates detailed reports from that data. The application consisted of six 6 user-forms that were used to assist the user. A form was used to navigate the user's directories to locate the data file the application does all of the importing automatically. The other forms are used to narrow the scope of some reports based upon user-entered criteria.
• Consultant on contract with Pfizer in Parsippany, New Jersey as a Microsoft Excel / VBA Developer. Made changes to, and fixed problems with existing spreadsheets. Added a comboBox to set the autofilter criteria for the data spreadsheets - this ensured that all of the information contained in the charts was consistent. Used VBA/VB to eliminate duplicate records in data. Excel, VBA

Confidential

ActivityBase / Microsoft Excel / VBA/VB Developer

Consultant on contract with Aventis Pharmaceutical in Bridgewater, New Jersey. Excel, VBA Responsible for the development of protocols and templates using ActivityBase. Gather assay and experiment information from scientists, develop and test templates. Create custom procedures, using VBA/VB, based upon requests from scientists. These procedures included custom print routines, finding and highlighting the source of data in a table and navigating between worksheets and worksheet regions within an application. Created custom application to analyze data structure and make the file readable for ActivityBase.

Confidential

• In-House Trainer:
• Taught Introduction to HTML and Cascading Style Sheets CSS to fellow Paragon employees.
• CBT Developer:
• Consultant on contract with Telcordia Technologies in Piscataway, New Jersey.
• Developed and maintained computer-based training CBT application for the FORCE scheduling software. Re-created the FORCE GUI using PaintShop Pro. Developed applications with Microsoft Excel/VBA/VB and Microsoft Access on an as-needed basis. ToolBook, PaintShop Pro, Excel, Access, VBA

Excel/VBA/VB Developer:

Consultant on contract with Macro4 in Parsippany, New Jersey. Excel, VBA

Confidential

Programmer/Analyst:

Consultant on contract with Lucent Technologies in Bridgewater and Warren, New Jersey. I developed Excel-based applications. Edited sales proposals to make them more client-friendly and created a boilerplate in Word to generate proposals. Built the first intranet sites in Bridgewater. Excel, VBA, Word, HTML, CSS, FrontPage