Oracle Resume
Framingham, MA
Operating Systems, Languages, and Applications Expertise
Oracle PL/SQL, stored procedures, VB 6, SQL Server 2008 stored procedures, T-SQL, ANSI-SQL, VBA, Erwin, Oracle Forms, SQL plus, Toad, Access, HTML, ASP 2.0, VB Script, Java Script, Crystal Reports, C, Solaris, X-windows
Software and Database Experience
Confidential. Framingham, MA
Sr. Developer
2009-2010
Improved efficiency of existing Oracle PL/SQL and SQL Server T-SQL queries. Modified existing SQL to comply with the ANSI-SQL standard. Increased performance of several key reports in MS Word using an HTML solution that changed execution time from minutes to seconds. Alerted software staff to ANSI-compatible functions to reduce code changes between Oracle and SQL Server versions. Designed, documented, coded, and tested forms/tables and VBA/Word reports for the Edison/Safe VB6 nuclear plant design application which interfaced to Oracle 11g and SQL Server 2005 databases.
Confidential. Norwood, MA
Sr. Database Analyst
2007-2009
Drastically improved performance of many existing Oracle PL/SQL queries to run in seconds as opposed to hours. Consistently received high marks from all the business analysts I supported in regard to competency and effectiveness. Debugged several problematic programs that other team members could not fix. Coordinated and managed tasks sent to offshore programmers. Ran quality assurance checks on work completed by offshore programmers. Provided Oracle SQL support for Health & Benefits client carrier files. Communicated very effectively between clients and staff.
Confidential. Merrimack, NH
Software Developer
1997-2003
Resolved all Y2K applications issues before the millennium occurred, and ran apps without error post Y2K. Analyzed and modified existing systems developed in C, C++, VB, and Sybase for Y2K compliance. Completed VB Script, Java Script, ASP 2.0, Unix and C++ classes. Provided PL/SQL Oracle developer support for the Advanced Benefits group. Provided Oracle developer support for Oracle databases to support the Internet Operations Center.
Confidential. Ashland, MA
Software Contractor ( part-time work)
1997-1999
Designed and developed a VB 6.0 application to maintain phone traffic for commercial and military installations. Designed the entire MS Access database following standard normalization rules, and then moved the design to an MS SQL Server database. Created reports using Crystal Reports. Created an ad-hoc query form that allowed end users to create and run queries without knowing SQL. Demonstrated the system to personnel at Hanscom Air Force Base.
Confidential. Lowell, MASr. Database Engineer
1996-1997
Redesigned several existing forms that could not effectively be maintained because of spaghetti code and poor documentation. Collaborated and built good rapport with end users to collect requirements for new Oracle Forms modules for existing sales and customer account management system (Oracle Forms 4.5, 3.0, PL/SQL). The system supported clients of compressed fax transmission service to Japan. Attended the Oracle Forms 4.5 course.
Confidential. Waltham, MA
Sr. Programmer Analyst
1995-1996
Hired for my Ingres database client-server expertise and my ability to learn new technology. Took the Oracle Forms 3.0 course in 1 week and immediately began to design, code, and test modules of the PAS system that manages the entire PHCS network of healthcare providers. Forms were created and maintained with Oracle Forms 3.0, PL/SQL, and SQL. Created Oracle reports using the Oracle SQR reporting tool. Completed the Client/Server course. Promoted to senior level after 1 year. Recruited to Unifi Corporation by an acquaintance during the Oracle Forms 4.5 training.
Confidential. Marlboro/Sudbury, MA
1983-1995
Software Engineering Specialist, 1991-1995: Designed and developed Ingres front-end database applications with embedded SQL and C to support Amsterdam Air Traffic Control Systems. Developed QA tests and procedures to exercise the ExxonValdez transponder software system. Created flight scenarios for target acquisition and radar tracking for air traffic control applications. Attended Ingres client server development course.
Hardware Engineering Specialist, 1983-1991: Diagnosed and repaired processor boards to the chip level within the Patriot missile ground radar module. Wrote diagnostic programs to troubleshoot processor modules using the Fluke 9010 in-circuit emulator with its own proprietary language.
Sales ExperienceConfidential. Worcester, MA
Health Insurance Agent
2006-2007
Licensed health insurance broker selling to individuals in the Midwest and South. Phone sales to individuals who requested health insurance information via web portals.
Confidential. Maynard, MA
Sales Account Manager
2004-2006
Managed sales efforts from initial call to the award of the purchase order. Managed initial customer engagements via web demos. Assisted with initial presentation to determine needs and interest level.
Confidential.
Sr. Sales Agent
2003-2004
Marketed health insurance products to small businesses and self-employed individuals. Used company-provided and self-generated leads.
Hardware Experience
Confidential. Hudson, MA
Sr. Hardware Technician
1980-1983
Diagnosed and repaired bank terminal and credit authorization machines to the chip level. Wrote test programs that exercised these hardware modules using the Fluke 9010 in-circuit emulator.
Education and TrainingOracle-Certified Associate: Preparing for the PL/SQL exam for Oracle certification (OCA); have already passed the SQL portion for the certification.
Enrolled Online toward MSTS Certification: SQL Server 2008: Installing, Querying and Security, completed 6/14/10; SQL Server 2008 for Developers, in progress.
Confidential: Client/Server Certificate Program * Framingham, MA * Course of study included Client Server Fundamentals, MS Access, Visual Basic, MS SQL Server, PowerBuilder. Designed and developed client/server applications. Part-time student.
Confidential: Framingham, MA * Computer Science Major * Part-time
Confidential: Merrimack, NH * C++, JAVA, Java Script, VB Script, ASP 2.0, Unix courses
Confidential: Burlington, MA * Computer Technology Major * Part-time
Confidential: Waltham, MA * Computer Technician Program * Full-time
Confidential: Lowell, MA * Music Major * Full-time
Confidential: Worcester, MA * General Studies * Full-time