Oracle Database Developer

 

Conscientious, diligent, and enthusiastic individual with over 14 years IT experience with 13 of them with one of the worlds largest retailers. Spent the last 10 of 13 years as an Application Developer. Adept in all aspects of the software development lifecycle (SDLC). Specialized in Oracle database development in Customer Order and Supply Chain systems. Consistently recognized as possessing excellent documentation skills, being a strong team player, being honest, always willing to help, and having the ability to learn new things very quickly.

†††††††††††††††

 


Technical Skills

 

Databases:

Oracle 7, 8i, 10g, SQL Server 2005

 

Languages:

Professional: SQL, PL/SQL, VB6, DCL, KornShell, Perl

Educational: ASP.net, HTML, PHP, C, C++, C#

 

Tools:

VB6, OracleForms, WinCVS, Rational ClearCase and ClearQuest, IBM Mercury QualityCenter, Dreamweaver, Toad, SQL Navigator, Helpline, HP ServiceDesk, Microsoft VisualStudio (2005, 2008)

 

 


Professional Experience

 

THE COUNTY OF BERKS, Pennsylvania††††††††† †††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††2010

Oracle Application Specialist(2010)

Worked in Oracle E-Business Suite (ERP) to support the modules (Purchasing and General Ledger) used by the County.Worked with MyOracleSupport to find resolutions to user issues. Tested Oracle recommended solutions in non-Production environments. Modified report scripts written in SQL.

 

 

THE FRAMEWORK FACTORY, Las Vegas, NV††††††††† †††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††2009-2010

Web Developer (2009-2010)

Worked part-time from my home in Reading, PA with small tasks to support and test client websites. The company owner created his own content management system like Drupal or Joomla that he supplied to all his clients. Wrote basic test scripts in Visual Studio. Found and fixed several program bugs. Setup my own SQL Server, Visual Studio, and IIS.

 

 

IKEA North America Services, LLC, Conshohocken, PA†††††††††††††††††††††††††††††††††††††††††††††††††††††††††† ††††††††††††††††††††††††††††††††††††1995-2009

Application Developer (1999-2009)

Development, maintenance, and support of Supply Chain applications including analysis, implementation, documentation and testing. Programming in Oracle Forms, VB6, Unix/VMS Shell scripting, SQL, and PL/SQL (Packages, Procedures, Triggers, and Functions) in Oracle 7, 8i and 10g databases. Integration of new systems. Training and support for new team members and consultants. Was on a rotation for second level support including carrying a pager for 7x24 coverage.

         Involved in projects of all sizes including:

o    A time registration system for entire IT organization to accurately track coworker time. Helped design the database table structures, indexing, and referential integrity.

o    Web-based customer order tracking system using Oracle Application Server and PL/SQL generated web content. Enabled store coworkers to more easily track customer orders during customer service.

o    New application for Warehouse Order Management that provided near real-time capabilities and allowed for 24/7 operations.

         Singlehandedly saved a key system from being shut down by the users by finding the root causes of the major issues and solving them by re-engineering the problematic code to eliminate the problems, adding error handling, and reducing the runtime from 10 hours to 30 minutes (95% reduction). The users then kept the system and their order processing was greatly improved. And this system was given to a business unit in Sweden since it was running so well.

         Improved development process by producing better documentation, better code, and better test cases.

         Lowered incident rate by registering more Problems in Service Desk than the rest of the team combined.

         Improved test process by registering more Defects in Quality Center than the rest of the team combined and fixing more test cases than them.

 

 

 

Support Specialist / Support Engineer (1997-1999)

Handled support for Supply Chain applications and users. Training of users and coworkers. Carried pager for 7x24 support coverage.

         Expanded role of the Wholesale Support Team to include systems used by other Supply Chain business units which added support for over 100 users.

         Produced and maintained major increase in solve rates by:

o    Forging strong relationships with users, developers and other IT groups.

o    Creating templates for the users to help explain issues.

o    Self learning DCL, SQL, PL/SQL, Oracle Forms 3 and IKEA developed applications.

o    Expanding support documentation for group to solve incidents faster.

         Helped Data Center group by carrying their pager when needed.

         Lead team that created Systems Support intranet site.

 

Data Center Operator (1996-1997)

Provided first level support for all of North American Operations including user administration, desktop support, reboots, coordination of third party support, routine data backups and restores. Carried pager for 7x24 support coverage.

         Promoted into Support Specialist after only three months on the job due to an excellent ability to pick up new skills and use them effectively. Despite my supervisor being out on leave and being by myself 2 days every week.

 

Stock Control Supervisor (1995-1996)

Maintained inventory accuracy in the retail store. Also, provided systems support for in-store systems and trained store personnel in stock control basics.

         Improved inventory process by running training sessions for floor coworkers and managers.

         Improved relationships with Business Area Managers and transport/flow coworkers at the NJ warehouse.

 

 

 

 


Education

 

 

Bachelorís of Science Degree in Computer Science, Arcadia University, Glenside, PA

         Graduated in top 10% of class 2002 with 3.75 GPA

         Distinguished Deanís List Ė Every semester.

         Inducted into Phi-Kappa-Phi National Honor Society for graduating in top 10% of class.

         Inducted into Alpha Sigma Lambda National Honor Society for excellence as a working adult.

         Specialized in C/C++, Java.

         C++ tutor for 3 semesters.

 

With IKEA - Outside Training in: OpenVMS, Oracle7, 8i, 10g, SQL, PL/SQL, Oracle Forms 4.5, PL/SQL Web Development, Rational Unified Process, Time Management, Communication And Interpersonal Skills for IT Professionals,

 

With IKEA - In House Training in: JAVA, AIX, Korn Shell, OO Analysis & Design using UML, PPS for Users, and the Unified Process with UML.

 

Self Learning in: SQL, PL/SQL, DCL, Oracle Forms3, PHP, MySQL, Perl, ASP.net with ADO.net, C#, Joomla, SQL Server 2008.

 

Recent classes in: ASP.net and Computer Networking.