|
|
|
|
Programmer/Analyst Resume
|
| Desired Industry: Computer Software/Programming |
SpiderID: 26914 |
| Desired Job Location: Neptune, New Jersey |
Date Posted: 5/24/2009 |
| Type of Position: Full-Time Permanent |
Availability Date: |
| Desired Wage: |
|
|
U.S. Work Authorization: |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: |
| Highest Degree Attained: |
Willing to Relocate: |
Objective:
Seeking a position that leverages my achievements, skills, energy and talent for identifying process and application needs and developing the solutions.
Experience:
VONAGE
Holmdel, New Jersey
MIS Software Specialist
Automate data flow and reporting functions for Corporate Communications, Human Resources, Facilities, MIS and other Vonage departments
Create web-based applications using ASP.NET/VB.NET. These applications typically front a SQL Server database on the backend.
Write database queries using SQL to select, insert, update and delete data from web front-end to SQL database.
Create and maintain SQL Server databases.
Write SQL procedures and automated jobs to perform tasks at regular intervals.
Collect user requirements, write specifications, create and maintain project plan, manage project change requests and project changes.
Support Microsoft Office applications
Write custom solutions using Microsoft Office – using one or more applications as a single solution. Solutions, such as:
• Write VBA code to perform calculations and create graphs in Excel and create a PowerPoint presentation placing graphs on separate slides – all from within Excel.
• Write VBA code to parse incoming e-mail and update Access database with information in message and send response to originator.
• Perform automated mail-merge in Word using Access database.
November 2003 – September 2006 (Employee/Consultant)
November 1998 – January 2001 (Employee/Consultant)
PARAGON COMPUTER PROFESSIONALS, INC.
Cranford, New Jersey
Staff Manager (Paragon – In-House Operations):
In-House Trainer (Paragon – In-House Operations):
Technical Interviewer (Paragon – In-House Operations):
Assignments:
NOVEMBER 2003 – AUGUST 2006 (CONTRACT)
BRISTOL-MYERS SQUIBB: PRINCETON, NEW JERSEY
Access/Excel/VBA Developer
Created Excel-based application to parse “Audit Trail” data from REMEDY Help Desk Ticket extract. This data was then imported into an Access database for analysis. This application was subsequently re-written to run in Access.
Created Excel- and Access-based “SLA Scorecard” for reporting a complex series of metrics. This application is similar in appearance to an existing one but all reporting criteria are table-driven, as-is the conditional formatting used. This application made extensive use of VBA in Access to prepare data for export to the Excel template.
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.
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.
NOVEMBER 1998 – OCTOBER 2000 (CONTRACT)
TELCORDIA TECHNOLOGIES: PISCATAWAY, NEW JERSEY
CBT Developer:
Developed and maintained computer-based training (CBT) application for the FORCE scheduling software using click2learn (formerly Asymetrix) ToolBook.
Re-created the FORCE GUI using PaintShop Pro.
Developed applications with Microsoft Excel/VBA/VB and Microsoft Access on an as-needed basis.
July 2003 – September 2003 (Contract)
VOLT PROCURESTAFF NJ
Parsippany, New Jersey
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. Created “intelligent” user-forms for data entry.
Developed custom “Office Automation” suite to handle all aspects of office operations.
May 2003 – June 2003 (Contract)
ARCH INSURANCE (ECLARO)
Financial District - New York, New York
Access/Excel/VBA/VB Developer
Created a multi-user Access database for the Operations Department to track the status of insurance policies from inception through issuance. This application imported 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.
May 2003 (Contract)
CADBURY ADAMS USA LLC (PATEL CONSULTANTS CORPORATION)
Parsippany, New Jersey
Excel / VBA/VB 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”.
November 2003 – February 2004 (Contract, part-time)
December 2002 – February 2003 (Contract, part-time)
HONEYWELL INTERNATIONAL, INC. (VERTICAL RESOURCES, INC)
Morristown, New Jersey
Excel / VBA/VB Developer
Updated and enhanced existing reports using Excel and VBA/VB. Added and improved the readability of all charts and graphs. Created UserForm to aid in data entry and review. Created custom functions and used array formulas to make the application more flexible and easier to maintain.
May 2002 – February 2003 (Employee)
AIG AMERICAN GENERAL
Neptune, New Jersey
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 controls Microsoft Excel, Microsoft Access, Seagate Crystal Reports, Monarch and Lotus Notes Mail via OLE Automation and maintains a record of when the report was last delivered and the next due date. The “Ad Hoc Reports” application allows various reports to be viewed (Crystal Reports), printed, saved to file (Excel) and/or e-mailed. These reports access 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.
December 2001 – February 2002 (Contract)
MERCEDES BENZ (VERSATECH CONSULTING, INC)
Montvale, New Jersey
Excel / VBA/VB Developer
Created an Excel application, driven by VBA/VB, to automate the report-generation process. The application imports 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.
Education:
EDUCATION
• Brookdale Community College
• Moravian College
TECHNICAL EDUCATION
• Course 2559: Introduction to Microsoft Visual Basic.NET Programming using Microsoft .NET
• Advanced Microsoft Access 2000 (Computer Insight)
• Microsoft Excel 5.0 - Advanced: Advanced Data Analysis and Reporting (CompUSA)
• Microsoft Word 6.0 - Advanced: Managing Long Documents (CompUSA)
• Creating Web Pages: HTML Scripting (CompUSA)
• Advanced PC Troubleshooting seminar (Essential Seminars Inc.)
• Project Management for IS Professionals seminar (Dunn and Bradstreet)
• Asymetrix International Developers Conference 1994
Affiliations:
• LinkedIn – http://www.linkedin.com/pub/0/730/107
• Plaxo – http://joevalencia.myplaxo.com
Skills:
SOFTWARE
Microsoft Office Professional Suite: Excel, Access, Word, PowerPoint, FrontPage, Image Composer, Project, Outlook, Microsoft Visual Studio, SQL Server / SQL Server Managerment Studio, OpenOffice Suite, click2learn (Asymetrix) ToolBook, CoffeeCup HTML editor, HomeSite HTML editor, Microsoft Internet Explorer, Netscape Communicator
PROGRAMMING / SCRIPTING LANGUAGES AND TECHNOLOGIES
Visual Basic (VB), Visual Basic.NET (VB.NET), ASP.NET, Visual Basic for Applications (VBA), SQL / SQL Server, HTML 3.2 and HTML 4.0, Cascading Style Sheets (CSS) , DevExpress web controls
Additional Information:
CERTIFICATIONS, BRAINBENCH
Business Communication, Business Math, Business Writing, Computer Fundamentals (Win 2000) , Customer Requirements Analysis, HTML 3.2, HTML 4.0, Internet Concepts, Internet Research and Evaluation (U.S.) , ITAA Information Security Awareness, Managing People (U.S.) , MS Access 2000 Fundamentals, MS Excel 2000, MS Front Page 2000, MS Internet Explorer 6.0 Fundamentals, MS Outlook 2000 Fundamentals, MS PowerPoint 2000 Fundamentals, MS Word 2000 Fundamentals, Presentation Skills, Problem Solving - Qualitative, Problem Solving - Quantitative, RDBMS Concepts, Software Business Analysis, Software Testing, Systems Analysis, Technical Writing, Web Design Concepts, Word Processing Fundamentals
AWARDS
• Vonage IT Department Internal Recognition Award – four times between October 2007 and April 2008
• Vonage Outstanding eXample (VOX) – four times between October 2006 and September 2007
• Lucent Technologies Excellence Team Award – 1997
VOLUNTEER WORK
• Juvenile Diabetes Research Foundation (JDRF) Walk for a Cure Volunteer
• Boy Scouts Merit Badge Counselor, serve on Board of Review Panel, troop community service projects and an adult leader on camping trips
• My Way Home Animal Rescue – web development
• Hamilton United Methodist Church – web development
• Neptune Little League – web development
WEBSITES
• Professional:
o Joe Valencia – Programmer – http://valenciaConsulting.bravehost.com
o Norpak Corporation – http://www.norpak.net
o Hamilton United Methodist Church – http://www.gbgm-umc.org/humc1/
o My Way Home Animal Rescue – http://www.mywayhomerescue.com
o Neptune Little League - http://www.angelfire.com/planet/neptunell/
o Neptune Wrestling – http://neptunewrestling.comxa.com
• Personal
o Joe Valencia Photography – http://photoByJoe.bravehost.com
Candidate Contact Information:
TheJobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|