Developer Analyst Programmer Manager Data .Net

Ellen Spampinato

Email: *********@********.***

Address: *** *** **

City: Phoenixville

State: PA

Zip: 19460

Country: USA

Phone: 484-***-****

Skill Level: Experienced

Salary Range: $80,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Skills:

Project Management

o Agile ScrumMaster

o Microsoft Visio

Web Programming

o HTML,JavaScript

o Dojo, JQuery

o Java, JSP

o Eclipse

o JBOSS

Other interfaces

o PowerBuilder

o VB 6.0

File programming

o C, pro-C

o Korn shell scripts

o FTP, isql, sql*plus

File managment

o Visual SourceSafe

o StarTeam

Databases

o Stored procedures

o Oracle (PL-SQL)

o Sybase SQL

o MS Access

MS Office VBA

o VBA forms

o Excel, Access, ODBC

o Word, PowerPoint

Help Files

o DocToHelp

o RoboHelp

MS Visual Studio

o VB 6.0, ASP, VBScript

o .NET (VB.NET, ADO.NET, ASP.NET, C#)

Employment History:

September 25, 2006-Present

Analyst/Programmer. [Company to be named on request] eligibility, accounting, and insurance name-lookup systems. Maintain/upgrade/enhance systems with Oracle (formerly Sybase or MS Access) database backend, batch processes in C, Java and Korn shell scripts, JSP web interfaces, web services, and MS Access front end (Accounting system only). Use Agile project management for creating and supporting file load processes, data storage, and retrieval for use in external applications. Upgrade JSP web application for eligibility and insurance name lookup systems. Document processes and train other employees and contractors to support and troubleshoot all three systems. C/Pro-C, Korn shell, Sybase, Oracle PL-SQL, Java, JSP, dojo, JQuery, Office VBA, VB6, VSS, StarTeam.

June 27, 2006-July 7, 2006

Programmer/Analyst. Merck & Co, Inc., Lansdale, PA. (Through Tekmark Inc.) Sups. Candy Golden-Gelegotis and Alexandria (Sandy) Merchant. Add enhancement to existing Access/Excel application to provide aggregate calculations and reports for an additional user-defined layer between existing data layers. Update user interface and user instructions.

April 26, 2006-May 30, 2006

Programmer/Analyst. First Consulting Group, Wayne, PA. (Short-term consulting). Sup. Scott C. Bailey. Upgrade external pharmaceutical client's existing Word template with new formatting styles and custom VBA features. Perform code reviews and unit testing. Update user training manual from Windows/Word 2000 to Windows XP/2003 enviroment, including upgraded features. Support QA testing and test script creation.

February 6, 2006-April 10, 2006

Programmer/Analyst. Merck & Co., Inc., Lansdale, PA. (Through Tekmark Inc.) Sups. Candy Golden-Gelegotis and Alexandria (Sandy) Merchant. Redo/complete existing Access/Excel application that makes aggregate calculations based on raw data and exports this data to formatted multi-sheet Excel workbooks. Handle different levels and breakdowns of aggregate calculations and generate reports for different levels.

October 17, 2005-December 30, 2005

Programmer/Analyst. Centocor, Inc., Wayne, PA. (Through PSCI) Sups. Ed McCaney and Jeff Gardner. Work with Medical Writers to create Excel/Word VBA application to generate Word documents based on data coordinated from several SAS-output datasets (Excel spreadsheets). Create Word and Excel Add-Ins with functionality to aid in formatting data before and after document generation. Write user instruction manual for installation and use of application and add-ins. Write technical documentation for support of application and add-ins.

May 9, 2005-May 27, 2005

Programmer/Analyst. Fingerprint Interactive, Philadelphia, PA. (Short-term Freelance) Sup. Richard Corkery. Debug, complete, and unit-test existing C# web applications with SQL Server back-end databases. Visual C#, ADO.NET, ASP.NET, SQL Server, VB.NET.

July 27, 2004-April 29, 2005

Programmer/Analyst. Quest Diagnostics, West Norriton, PA (Through TekSystems, Plymouth Meeting, PA) Sup. Robin Killian. Work with team to support and upgrade cash accounting and tracking system (Captracks) in MS Access and Oracle. Gather requirements; run adhoc queries; provide second-level support; plan, program and roll out new versions and enhancements. Oracle 9i, stored procedures, triggers, TOAD, ADO, VBA, SQL (Oracle and Microsoft Jet), Access forms, VB 6, VSS.

November 2003-December 2003

Analyst/Programmer. Merck MRL, Blue Bell, PA (Short-term Freelance). Sup. Pat Biddy. Upgrade intranet ASP application to reflect mandated changes in Forms Printing ordering procedures. Redesign web pages, add/remove controls, add/remove session variables, update VBScript, javaScript and and ADO code.

March 1, 2001-September 5, 2003

Analyst/Programmer. Merck MRL, Blue Bell, PA (Through EDP/Tac) Sup. Sally Tano. Work with in-house customers to design, develop, support and upgrade single-user applications in MS Office VBA/GUI (Excel, Access, Word); VB 6 with DAO; ASP with JavaScript, VBScript, ADO. Applications could include: custom dialogs, creation of multiple sub-documents, emailing capability (Outlook object library and CDO library), communication between different applications (Word Excel, Word Access/ADO/DAO, Access Excel.), automatic formatting (page numbers, headers, footers).

April 24, 2000-February 28, 2001

Analyst/Programmer. Merck MMD, Lansdale, PA (Through EDP/Tac) Sup. Jay Rojohn. Design/develop MS Word 97 templates. Develop VB document assembly application with ADO.

October 12, 1998-February 11, 2000

Analyst/Programmer. SmithKline Beecham, Collegeville, PA (Through EDP/Tac) Identify areas for automation in administrative/secretarial/budget forecasting processes in the Clinical Data Operations group. Provide data storage and transfer solutions using Access 97, Excel 97, VBA and Lotus Notes 4.5: Invoice-tracking and reconciliation (Access 97); mail-enabled survey database (Notes) for intra-departmental survey project; headcount forecast process/storage (Access) and reporting (Excel); departmental headcount database.

November 3, 1997- October 9, 1998

Programmer/Analyst. Working Data Group, Wayne, PA. In a small company dedicated to surveying, processing and reporting customer satisfaction for utility companies: MS Access 97 database design, administration, and data processing; Visual Basic for Applications (MS Word, Outlook, Powerpoint, Access, Excel); Visual Basic 5.0; Windows NT and peer-to-peer network administration; print queue and print server management; automating surveys by e-mail using Mabry mail tool (VB control); general hardware and software support for data-entry group.

May 16, 1997-October 31, 1997

Access VBA Developer. Comcast Cable Communications, Inc., Philadelphia, PA. (Through EDP) Created an MS Access 95 database application to input, process and store raw data on customer satisfaction surveys (provided monthly in a fixed length text file by a third party), calculate and store standard scores, and generate formatted Excel reports based on those scores. Created VBA procedure to process project-related text files not stored in the database. Provided documentation and one-on-one training for users of application.

August 26, 1996-May 2, 1997

Network Analyst/Database Developer. CoreStates Bank, Philadelphia, PA. (Through InfoQuest) Created network diagrams and accompanying databases using Clicknet and MS Access 2.0. Created specialized reports using MS Access and Access Basic. Trained permanent employee in use of ClickNet and accompanying database. Developed multiple-table workflow and equipment inventory database to keep track of equipment and line upgrade rollout to 600 bank branches.

July 14, 1996- August 23, 1996

Excel VBA Developer. Comcast Cable Communications, Inc., Philadelphia, PA. (Through EDP) Created an application to read sequential and text-delimited data files into an MS Access database and generate and print ormatted MS Excel worksheets and charts using Access Basic and Excel Visual Basic for Applications add-ins. Created Visual Basic procedures to examine, compare and modify related text files. Trained users in application use and data management.

January 31, 1996- April 5, 1996

WordBasic/Lotus Notes Developer. RDMS Document Structure Team, SCS Dept., SmithKline Beecham, King of Prussia, PA. (Through Kelly Services). Developed Word 6-based templates using WordBasic, developed help files using RoboHelp. Performed quality checks on pre-alpha-release templates. Developed and modified discussion and project tracking databases in Lotus Notes 3.2.

May 1995- January 30, 1996

Lotus Notes R.3 Developer/Training Registrar. RDMS Project, SmithKline Beecham R&D, King of Prussia, PA (Through Kelly Services). Updated and modified structure (views, forms, user access) of training and installation database on Lotus Notes system for use by team. Created new "bug" database in Lotus Notes for use by team. Created new discussion database for RDMS users. Scheduled RDMS product user testing, training and installation for employees in US and UK.

May 1994-February 1995

Service Associate. Individual Investor Technical Support, The Vanguard Group, Malvern, PA. Assisted training staff in transition from WordPerfect 5.1 to Microsoft Word 6.0. Provided informal software/PC/network support for training staff. Set up training staff-owned OS/2 LAN directory for group and remote access to online training documents. Maintained training schedule and planning tools and provided training productivity reports using MS Word, MS Excel, and Lotus Notes. Researched alternative scheduling methods and software.

April 1992- September 1993

Scientific Translator (Editor/Analyst). Biosis, Philadelphia, PA. Translated/wrote English language abstracts and keywords of French and Russian scientific research articles, specializing in biotech and genetics. Worked occasionally in Spanish, Italian, Catalan, Bulgarian, Ukrainian, Belorussian, Serbo-Croatian, and Polish.

Education

April-June, 2004 Programming and Web Technology Certification. Penn State Great Valley, Malvern, PA. VB.Net, Oracle, ADO.Net, ASP.Net, Visual C#, UML

May, June, 1996

Lotus Notes Application Development 1 and 2 (Release 4). Professional Training Services, King of Prussia, PA. AD1 completed May 20-22. AD2 completed June 17-20.

June, 1995

Professional Certification in Data Processing. (Unfinished) Montgomery County Community College, Blue Bell, PA. Courses completed: Pascal, C, Object-Oriented C++; systems analysis and design; LAN administration and support, data communications; PC hardware and upgrade.

May, 1991

B.A. French and Russian. Pomona College, Claremont, California

Foreign study: Strasbourg, France Fall, 1989; Moscow, USSR Summer, 1991

Other

General: Biology, chemistry, drug development, physics, calculus

Foreign Languages: French, Russian; reading knowledge of Spanish, Italian; "Tourist" German

Hobbies/Volunteer Work:

Theater: actor, singer, stage manager, technical crew (Lighting and Sound), production manager, hospitality coordinator, set construction, volunteer board member

Music: violin, guitar, bass guitar; volunteer electrician/lighting tech at outdoor music festival.

Contact this candidate