SUMMARY:

Innovative and quality - driven Senior Software Engineer/Oracle Developer with expertise in relational databases, Oracle PL/SQL, SQL, writing procedures, functions, packages, dynamic code, complex queries, and scripts.

COMPUTER SKILLS:

Programming Languages: Oracle PL/SQL, SQL, Microsoft Visual Basic .NET, Visual Basic for Applications, Basic UNIX scripting

Database: Oracle 11g/10g, Microsoft SQL Server, Microsoft Access, PostgreSQL, Sybase

Programming IDEs: Allround Automations PL/SQL Developer, Quest SQL Navigator, Oracle PL/SQL Developer, Microsoft Visual Studio 2010/2012/2015 , Informatica PowerCenter, IBM Data Studio

ETL: Informatica

Office Suite Applications: Microsoft Access, Excel, Outlook, PowerPoint, Word

Data Modeling: Oracle PL/SQL Developer Data Modeler

Internet/Intranet: Microsoft IIS, Microsoft SharePoint

Platforms: Microsoft Windows 7/8/8.1/10, Microsoft Server 2003/2008/2012 , Microsoft Small Business Server 2003/2011

EXPERIENCE:

Confidential, Durham, NC Merrimack, NH

Senior Software Engineer/Developer/Oracle Database Developer

Responsibilities:

• Lead Oracle developer for the creation of APIs for a new Oracle configuration database that interfaced with IBM’s WebSphere Message Broker.
• Participated in design meetings, and worked with Architects and Database Administrators during the design phase of projects
• Performed data modelling based on requirements and specifications.
• Developed automation procedures to dynamically generate database object DDL scripts based upon schema structure, which provided a means to successfully transfer a database schema to a different database or schema so 10+ developers could work without interfering with testing efforts.
• Wrote a process to transfer data from 100+ production database tables to development, integration, and quality assurance Oracle databases using the Oracle Data Pump access driver and external tables. The code was written in a manner to allow the selection of one or multiple top-level records, as well as all top-level records and all associated records in child tables.
• Created PL/SQL scripts to identify table hierarchy, primary and foreign key relationships, and associated constraints so data insertion and deletion would be performed in the correct order.
• Documented, presented, and implemented coding standards for Oracle database development.
• Performed extensive research to provide a proof of concept for the use of stored procedures in an IBM DB2 z/OS mainframe in an effort to reduce process complexity and eliminate legacy systems.
• Performed analysis and provided options to improve performance between databases and applications accessing them.
• Participated in Peer Code Reviews.

Senior Software Engineer/Developer/Oracle Database Developer

Confidential

Responsibilities:

• Designed and developed a PL/SQL process to compare 400 corresponding tables containing millions of records between two separate databases (Production and Pristine Staging) where all data is expected to be identical, and to write the discrepancy results to an Office Open Excel XML file. All code for the process, including the creation of the Excel XML file, was written in PL/SQL. The new code replaced an older checksum process, reducing processing time of 10 to 30 hours down to 4 to 20 minutes, approximately a 93% improvement in processing time.
• Created as part of a team, a desktop application used by 200+ associates to load Oracle Advanced Benefits configuration data outlined in Microsoft Excel into the Oracle database using Oracle Advanced Benefits’ APIs. The application virtually eliminated the need for manual data entry, allowing its end users to focus on additional tasks.
• Developed stored PL/SQL packages/procedures/functions for the Oracle Advanced Benefits system.
• Wrote scripts to correct data errors in the production database.
• Designed and developed multiple processes and applications using various combinations of Visual Basic .NET, PL/SQL, Visual Basic for Applications and Excel to automate manual tasks, increasing associate productivity, and each becoming a mandated part of everyday processes.
• Trained onshore and offshore developers in proper troubleshooting techniques for the mandated applications and processes.
• Mentored junior developers to ensure they followed standard coding practices, and produced efficient code.
• Participated in the Windows 7 application compatibility testing effort.
• Proactively prepared self-help and system setup documentation for use by associates and technical support personnel to assist with application installation, troubleshooting, and use.

Software Engineer/Developer/Oracle Database Developer

Confidential

Responsibilities:

• Designed, developed, and maintained multiple desktop applications and tools used by 200+ associates in their everyday work.
• Developed packages, procedures, and functions per provided specifications as rules to determine client participant benefits in the Oracle Advanced Benefits application for approximately 40 clients.
• Created a SharePoint site to use as a central dissemination point for application installation, troubleshooting, and general information.

Associate Technical Design Analyst

Confidential

Responsibilities:

• Developed and maintained a reporting application in Microsoft Access which connected directly to a Lotus Domino database. The application was used for numerous reports, including work request tracking, returned for rework, and cycle time.
• Wrote Oracle PL/SQL procedures and complex multi-table queries.

Confidential, Andover, MA

Senior Inventory Analyst

Responsibilities:

• Developed a purchase order, project planning, and inventory tracking application.
• Performed purchasing functions, assisting the senior purchasing agent.
• Managed and maintained a stockroom for the engineering facility.