OBJECTIVE:

Position as a Database Engineer / Developer in a challenging environment that requires excellent analytical skills, communication skills, documenting ability and focus and devotion to the timely completion of challenging tasks. The position that will be successfully fulfilled will be one that leverages an extensive history of database development, ETL design, expert understanding of data, scripting in various languages (Python, Javascript, VBA, etc.) and complex query analysis and creation.

SUMMARY:

• Vast experience successfully meeting the technical demands of some of the nation’s leading and best - known corporations, as an Oracle Developer and Oracle Applications DBA.
• Vast experience with a broad range of database technologies (in descending order of predominant experience: Oracle PL/SQL & SQL (19c, 12c, 11g, 10g, 8i), Oracle DBA (12c, 11g, 10g, 8i), SQL Server, Interbase, Interbase procedure code, SAS, SAS code, and MySQL).
• Experience with the following client-side development languages (in descending order of predominant experience/date): Python, Java, Javascript, HTML, C#, VBA (MS Access, Excel and Word), Delphi, FoxPro.
• Experience writing Unix Shell Scripts (Bash) to transform data and move files.
• Experience creating workflows and maintaining existing workflows using job scheduling tool Control-M, AutoSys and Oracle Scheduler.
• Extensive experience with Oracle PL/SQL programming objects such as packages, functions, procedures, triggers and other Oracle Database object (constraints, indexes, sequences, etc.).
• Extensive experience working with various built-in Oracle packages such as UTL FILE, DBMS UTILITY, DBMS HTTP, UTL RAW, DBMS LOB, DBMS SQL, DBMS OUTPUT, DBMS JOB, DBMS HS, DBMS STANDARD, etc.
• Experience working in Data Warehousing environments where data normalization was secondary and query performance was primary.
• Experience working in OLTP environments where data normalization was one of the most important priorities.
• Experience tuning Oracle SQL for performance maximization and troubleshooting slow-running PL/SQL code.
• Excellent communication skills.
• Excellent writing, documentation skills.
• Good leadership skills, with strong desire to learn and have opportunities to acquire more through experience, education and bold, regular application.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle SQL and PL/SQL Developer

Responsibilities:

• Effectively used Oracle v19c to develop, analyze and troubleshoot SQL and PL/SQL code, resolve performance issues and tune queries for maximum performance.
• Effectively and reliably achieved all requested tasks in a timely manner.
• Taught and led technical team to use Materialized Views to optimize query performance.
• Taught and led technical team to use Fast Refresh for Materialized Views.
• Taught and led technical team to use Partitioned Tables to optimize system performance.
• Successfully completed over 20 hours of required Python training, and passed resulting tests.

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities

• Effectively used various versions of Oracle (12c, 11g, 10g, 8i) to develop, analyze and troubleshoot code, as well as resolve performance issues and conduct performance tuning.
• Expertly conducted ad-hoc Oracle SQL and PLSQL Development in the interest of troubleshooting Production and Development issues.
• Supported, troubleshot, repaired and enhanced Java Spring applications used for processing worldwie payment processing for telecommunications services.
• The payment system in question collected over $1Bn/month.
• Successfully and effectively acted as a dynamic intermediary between end clients and application development staff to identify, describe and triage technical issues such as requirements details and performance issues.
• Designed and implemented technical solutions to needed code fixes and enhancement requirements.
• Effectively documented detailed diagrams of the parts of the system I upgraded, analyzed or repaired, for interdisciplinary/cross-team reference and use.
• Troubleshot, designed and implemented Oracle ODI data transformation jobs for various versions of Oracle Database (12c, 11g, 10g, 8i).
• Directly engaged application development staff and customer support staff to find dozens of lost, in-question and duplicate payments or charges in a vast system of Linux OS transaction files totalling over $1Bn per month in transaction value.
• Reconciled dozens of transaction files to database table records for use by customer support specialists and other system personnel, and reported on the reconciliations.
• Began mastering a payment and billing sytem comprised of dozens of interrated but independent units. Each unit was potentially based on a different technology: Oracle, Linux Bash, MySQL, SQL Server, PostGres, DB2, AWS Cloud, Cassandra, etc.
• Made significant contributions to the draw down of a massive backup of open Tickets, by resolving, retiring, triaging and delegating the Tickets.

Confidential, Tampa, FL

SQL Developer

Responsibilities

• Monitor, maintain and enhance legacy Oracle application that was the correspondence tracking centerpiece for this Fortune-200 corporation. Tracking correspondence critical task for state Medicare/Medicaid compliance requirements.
• Used Oracle 12C, partition analysis and resolved performance issues, made performance enhancements, and was the Oracle Subject Matter Experience for their Content Management System (CMS).
• Created many packages, stored procedures, triggers and anonymous blocks (SQL files) for the CMS application to accommodate needed enhancements and fixes.
• Led team of junior developers and business analysts through process of requirements analysis and development fulfillment.
• Performance tuning on aging system, where bloated tables with very old but still needed data was the norm.
• SQL analysis for SQL written in previous versions of Oracle, when data and system architecture characteristics were completely different.
• Interface various departments to achieve requirements: DBA Team, internal customers, System Admins, management, lateral teams, etc.
• Document system characteristics, changes and future recommendations.
• Powerpoint presentations for proposed solutions and team direction.
• Successfully led team through requirements and development schedules.
• Made critical recommendations on PL/SQL bug resolution, development enhancements, SQL and PL/SQL performance enhancements and database development strategy.

Confidential, Kissimmee, FL

SQL Developer

Responsibilities

• Backend development using SQL Server T-SQL programming language.
• Create T-SQL procedures to parse and process data for a Confidential processing system.
• Create front-end systems for various clients in the Confidential banking industry using MS Access.
• Document all created systems and some existing systems using HTML and Javascript.
• VBA development for Microsoft Access front-end solutions.
• VBA development for Excel for data analysis.
• Successfully created many T-SQL procedures and functions to process Confidential data.
• Successfully created front-end systems using MS Access for Confidential pool processing teams at client sites.

Confidential, Largo, FL

.NET Developer

Responsibilities

• Backend development using Oracle PL/SQL (10g, 8i) programming language.
• Backend development using Unix shell scripting (Korn/Bash).
• PL/SQL Developer for existing OLTP system and new OLTP system requirements.
• PL/SQL Developer for existing Data Warehouse and new Data Warehousing requirements.
• Extensive job scheduling created/monitored/managed using Control-M.
• Interview prospective new software development employment candidates.
• C# development.
• Shell scripting.
• Manage code using Team Foundation Server.
• Troubleshoot database performance problems.
• VBA development for Excel for data analysis and interactive presentations.
• HTML and Javascript development for interactive presentations.

Confidential, St. Petersburg, FL

SQL Developer

Responsibilities

• PL/SQL Developer for OLTP peer to peer payment system
• Backend development using Oracle PL/SQL programming language.
• Created new PL/SQL packages according to specs defined in FRD.
• Migrated code to Subversion source control system.
• Collected user requirements, documented requirements and created/modified code according to the collected requirements.
• Wrote Unit Tests for requirements and documented results to management / users.
• Created Contact Management system piece for on-line P2P payment system referred to in title of this section.

Confidential

Volunteer

Responsibilities

• Backend development using Oracle PL/SQL programming language.
• Translate business logic into PL/SQL code
• Responsible for Federal Regulatory Reporting for Confidential 's international back office operations
• Data modeling required for new tables
• Advanced SQL involving analytic functions and subquery factoring
• Maintain and make periodic changes to legacy VBA (MS Excel) reporting system.
• Install and maintain IBM Websphere for use with proprietary enterprise grade data analysis tool (Symphony RPM).
• Install SymphonyRPM data analysis software on server and clients and did initial cube / query design.
• VBA development with Excel to support and existing Regulatory Reporting financial application.
• Quick mastery of complex business logic
• Mastery of formal business documents not encountered before: BRD's (Business Requirements Document), FRD's (Functional Requirements Document), TDD's (Technical Design Document)
• Easy assimilation into a large organization with formal team structure
• Mastery of legacy VBA system that generated hundreds of preformatted government reports.
• Successfully installed and confirmed operation of IBM Websphere (single instance version).
• Successfully installed and confirmed operation of Symphony RPM data analysis tool, server and client packages.

Confidential, St. Petersburg, FL

SQL Developer

Responsibilities

• Using Oracle PL/SQL to auto-generate web pages based on advanced business logic.
• Developing web pages for Osceola County Sheriff’s Office using HTML, Javascript.
• Application development using C# in .NET development environment.
• Reading/referencing Cobalt legacy code for prototyping new designs.
• Creative incorporation of Oracle database technology to automate manual web page development.
• Quick mastery of complex application flow involving hundreds of search options containing various types of crime data requests (gun, article, vehicle, criminals, missing persons, etc.).
• Consistent on-time delivery of projects.

Confidential, Tampa, FL

Volunteer

Responsibilities

• Locate, schedule and organize speakers for monthly meetings.
• Locate venues for special events, coordinate speakers for same.
• Elected to board of Confidential Oracle Users Group
• Expert Presenter at Confidential Oracle Users Group: Object-Oriented Development in PL/SQL

Confidential, Sarasota, FL

Web Developer

Responsibilities

• Write SQL statements to extract data from SQL Server database.
• Modify existing T-SQL procedures to accommodate changing business logic.
• Create portal web sites for new clients to company based on template using ISAPI DLL's, HTML, and Javascript.
• Customize existing portals to meet changing business requirements for existing clients.
• Implement security measures on existing sites to protect from SQL Injection and cross-site scripting attacks.
• Troubleshoot errors in portal functionality, report causes, suggest repair measures and repair.
• Research needed security measures, report and implement.
• Created connections to SQL Server databases, wrote required SQL statements and used return data in web site functionality.
• Quickly and successfully mastered new development language on the job: javascript.
• Performed all job duties at a high level of performance.

Confidential, Tampa, FL

ETL Developer

Responsibilities

• Backend development using Oracle PL/SQL programming language.
• Analyzed existing PL/SQL code and created new PL/SQL code in procedures, functions and packages. Also created new SQL in client application to be transferred to Oracle for execution: client application was Informatica 7.1.
• Extensive use of Oracle's analytical functions (SUM with Partitions, Lead/Lag, Rank, First/Last, etc).
• Extensive experience writing Oracle inline views, which improved performance and created code that was highly readable.
• Extensive experience creating Oracle subqueries, which improved performance and created code that was highly readable.
• Extensive experience writing correlated subqueries in Oracle, which improved performance and created code that was highly readable.
• Extensive use of Oracle SQL for advanced business logic: Queries often exceeded 2,500 lines in length and accessed tables containing hundreds of millions of rows of data.
• Analyzed existing SQL statements and PL/SQL objects to incorporate new business logic into the process or to troubleshoot performance issues that arose for various reasons. Among these reasons were changing data structures that broke existing code, new business rules that needed to be implemented, new datasets that needed to be incorporated and new functionality that was being required.
• Performed data modeling tasks so that new ETL's could be developed and implemented, so that existing ETL's could be repaired and upgraded and so that performance on existing processes could be improved.
• Collaborated successfully with other team members (managers, architects, DBA's, interface developers) so that the end result was of high quality to the end user.
• All work done in Oracle 10g, 11g.
• Informatica server administration duties performed as part of rotating on-call pager duty.
• Managed and edited files in Unix environment. Wrote Unix shell scripts.
• Contributed to the development of massive Business Intelligence tool used by Confidential executives on a daily basis. The DSS Tool (DSS = Decision Support System) provided an overview of business activity from all Confidential retail centers nationwide, among other things.
• Provided team management with on-demand reporting on design statistics, content statistics and performance statistics for the data warehouse that contained the data used in the DSS BI system.
• Troubleshot DSS BI code for reporting anomalies, and fulfilled inquiries from executives for statistics support, background and substantiation.
• Proposed, designed and implemented changes to the data warehouse metadata for required modifications. Modifications included changes in reporting requirements for certain statistics, new statistics being required, statistics being retired and statistics being archived, recalled or otherwise maintained as a result of regulatory requirements.
• Successfully performed all required assignments.
• Performed well on the DSS team by being cooperative at all times, willing to lead and follow as the situation deemed each role to be appropriate.
• Eagerly volunteered for all-night burn sessions preceding major system changes to ensure flawless performance for Confidential executives on the morning of scheduled deployment.

Confidential, St. Petersburg, FL

Oracle Developer

Responsibilities

• Managed 400-million+ record database of lead contact records, including Oracle DBA responsibilities associated therewith (making sure space is available in tablespaces, adding datafiles to tablespaces, creating and managing indexes, monitoring performance and making adjustments, etc.). Oracle 10g.
• Wrote hundreds of functions and procedures using Oracle PL/SQL.
• Created dozens of packages in Oracle PL/SQL.
• Created data models in Oracle databases for all matter of business: payroll, sales commissions, accounting, marketing, loan processing.
• Transferred data in/out of Oracle databases using Heterogeneous Services: Borland Interbase, Microsoft Access, flat files, Microsoft FoxPro, Microsoft Excel, SQL Server.
• Setup and maintained VPN systems for 40+ branch offices all over the country so that daily reporting needs could be met.
• Created, led and implemented strategy to clean and standardize data (name, addresses, phones) and identify duplicate records. 30 million+ records in Oracle. Oracle 10g.
• Accessed XML data on websites using PL/SQL using UTL HTTP package and processed data using XMLDOM package. Oracle 8i.
• Provided all manner of Business Intelligence reports to executives on all departments of business: marketing, sales, payroll, loan processing, demographics, employee performance.
• Constant and continuous production of ad-hoc reports for all departments of business.
• Created client applications in MS FoxPro, MS Access, MS Excel, Delphi (version of Delphi shipped with loan origination software Empower) that used Oracle as back-end. Oracle 8i, 10g.
• Researched and reported to executives and management new software initiatives, met with vendors, compiled requirements and features and installed and implemented newly acquired systems.
• Storage and masking of credit card data, submission of credit card data to transaction processing companies for sales.
• VBA development for Microsoft Access to create new departmental business solutions and to support existing solutions.