Senior Application Developer (Oracle PL/SQL, VBA) Resume Allentown, PA - Hire IT People

SUMMARY:

18 - year career of professional client/server application, database development
11 years as an Oracle PL/SQL developer in a high-volume, batch driven, transaction based Oracle (RDBMS) / LINUX environment
18 years of VBA development experience primarily in MS-Access and MS-Excel
18 years of SQL (Structured Query Language) experience in a variety of RDBMS
Primary industry exposure includes energy and manufacturing. 11 years at Confidential Solutions a subsidiary of Confidential -500 Confidential Corporation and 3.5 years at Cabot Supermetals a division of Confidential -500 Cabot Corporation.
Multidisciplinary IT experience with all phases of the SDLC including analyzing business requirements, design, prototyping, development, implementation, and maintenance of custom business applications to automate and optimize business processes, increase operational efficiency, and increase revenue/profits.

TECHNICAL PROFICIENCIES:

Programming: VBA, MS-Access 2.0 - 2010, Oracle PL/SQL, SQL, MS-Excel 97 - 2010, VB 5.0/6.0, ADO, VB/C# .NET, XML, C++, C, T-SQL, ODBC

Databases: Oracle 8i, 9i & 11g, MS-Access, MS-SQL Server, DB2, FoxPro

Reporting: Access, Word, Excel, Crystal Reports, and ActiveReports

Tools: SQL Navigator, Oracle SQL Developer, PVCS, JSC, Tivoli Workload Scheduler, TFS, VSS, SQL* Loader, DTS, TOAD

Systems: WINDOWS (all), UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Allentown, PA

Senior Application Developer (Oracle PL/SQL, VBA)

Responsibilities:

Expert level competency in the configuration of complex energy products in Confidential .
Demonstrated career-long commitment to improving billing accuracy and timeliness as both directly affected Confidential ’s SLAs with clients.
Meeting or exceeding client SLAs resulted in Confidential receiving substantial performance bonuses.
Contributed to enhancements in performance and scalability of Confidential and nightly batch billing processes. Areas of focus included performance tuning of SQL, PL/SQL, and job execution. Participated in a number of database performance initiatives throughout assignment as active client account enrollments increased from a few hundred thousand to peak levels of over 1 million and volume of transactions increased from 10K bills per week to peak levels of 50K per night. A considerable percentage of Confidential 's revenue is derived from the number of bills processed and number of accounts maintained.
As the SME in Confidential 's proprietary billing system provided extensive guidance and support to business operations and fellow IT staff. In addition to subject matter guidance, mentored numerous developers as to PL/SQL and VBA best programming practices.
Configured and successfully implemented the Client Billing application utilized by Confidential to invoice clients for all services provided. Assumed the role as the IT SME in client contract implementation and maintenance. Facilitated all initial contract configurations and reviewed all periodic changes. Consolidated, re-engineered, and decommissioned numerous ad hoc applications into one central application. Upon implementation, Confidential realized net gains of $4000 per month in revenue as errors in previous methods of calculating billing fees were corrected.
Excelled at configuration, automation, and creation of Backing Sheets ( Confidential ). Confidential are MS-Excel spreadsheets containing calculation details of complex energy charges, are available for download to clients and their customers, and are a critical component of Confidential representing proof of calculation accuracy. Designed, prototyped, and co-developed a scalable, completely automated, high performance batch process to create Confidential utilizing C# .Net, Open XML Document technology, and Oracle back-end.
Salvaged business relationship with major client. Post failed implementation of the Settlements Automation in Confidential project re-engineered entire process and rewrote 90% of the associated PL/SQL code. Post redesign, both batch and GUI on-demand processes functioned per original client specifications. Illustrative of a common career task, assess, provide recommendations, and / or correct flawed processes.

We provide IT Staff Augmentation Services!

Senior Application Developer (oracle Pl/sql, Vba) Resume

Allentown, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship