Senior PL/SQL Developer
Resume:
BRAD ROWE
********@***.***
Position/Title
Senior Oracle PL/SQL Developer
Security Clearance
Secret - DOD
Software Summary
* ** ** *****: Oracle, SQL, PL/SQL, ODI, SQL Loader, TOAD, SQL Plus, Jira, SVN, Flyway, SQL Navigator, SQL Developer, Perl, C/C++, Visual C++, Visual Basic, COBOL, MVS/COBOL II, MICROFOCUS COBOL2, UNIX.
Oracle Skills
Procedures, Triggers, Packages, Functions, Views and Materialized Views, Analytic Functions, Bulk Collect, Forall, Partitioning, Virtual Columns, Query Hints, Join Methods, Bind Variables, Nested Tables and Varrays; Tables (IOT, Partitioned), Indexes (Composite, Function Based, Bitmap), Constraints (FK, PK, Check).
Experience
Mr. Rowe has over 27 years of information technology experience, with a primary focus on all aspects of software engineering activities, which includes software design, analysis, programming, testing, and implementation of applications software. He is an Oracle Certified Professional with more than 21 years of solid Oracle experience. Mr. Rowe has proven experience as a technical team leader on large-scale technology engagement currently using Agile methodologies, where he brings a unique balance of excellent customer relationship and technical skills. Experience designing, developing, enhancing, and maintaining multi-tier applications using Oracle (Forms, Reports, Developer 2000, SQL, PL/SQL). Mr. Rowe is exceptionally proficient in SQL and PL/SQL tuning, and Perl scripting.
Employment History
Senior Oracle PL/SQL Developer, Leidos, VA, 2021-2026
Brad is a senior Oracle PL/SQL developer currently supporting the NLAC program. As a senior developer in the NLAC development team, he has completed all the tasks assigned to him in the timeframe and the hours allocated. He comes with a deep understanding/knowledge of Oracle and has taken the initiative to apply his skills and experience to the betterment of the NLAC program. He provides innovative and knowledgeable feedback and has worked on many occasions with the System Architect supporting complex NLAC database issues.
Brad has taken on many roles in NLAC modernization. He has cross trained and has become one of the primary ODI developers which is key to the NLAC modernization effort. While working on the modernization effort, Brad was one of the key contributors on the “sourcing workflows” effort by actively collaborating with the System Architect and building the N2bridge code and the Archiving and Purging code. He has also actively collaborated with the java team and the test team in building the appropriate DB code to complete the complex modernization tasks and has jumped in readily to assist other team members whenever there was an issue. He has also actively participated in the development meetings and offered valuable suggestions. He has successfully completed the required Security+ certification.
Brad is a very friendly and pleasing person and works well in a team environment. He has provided mentorship to other team members in explaining and help resolving issues in the overall modernization effort. Overall, Brad is a very valued team member and a great asset to the team.
Senior Oracle Engineer, Leidos, Vienna, VA, 2018-2021
Mr. Rowe currently provides Oracle support for TSA’s HRAccess application after the successful migration from Metastorm to Process Suite BPM. Mr. Rowe designs, develops and supports O&M related responsibilities. He works closely with Business Analysts, Product Owners, QA, CM, SMEs and Program Managers. Mr. Rowe is fluent in all aspects of the Oracle language. This includes object creation and maintenance, optimization and tuning, data modeling, advanced programming techniques and trouble shooting. Mr. Rowe also supports operations maintenance tasks such as data cleanup, production trouble shooting and data fixes as well as providing Ad-Hoc reports upon request.
Senior Oracle Developer, CSRA, Arlington, VA, 2016-2018
Mr. Rowe serves as one of three senior Oracle developers on the TSA HRAccess migration of Metastorm BPM processes to Process Suite BPM. Mr. Rowe is responsible for logical and physical designs, refactoring legacy PL/SQL code and objects for optimization. Mr. Rowe uses metrics from TKProf, Autotrace, Explain Plan, and custom session queries to optimize processes for throughput and efficiency. Familiar and experienced with optimization techniques such as Analytic Functions, Bulk Collect, Forall, Partitioning, Function Based Indexes, Virtual Columns, Query Hints, Join Methods, Bind Variables, Nested Tables and Varrays. Mr. Rowe also maintains and develops objects such as Tables (IOT, Partitioned), Indexes (Composite, Function Based, Bitmap), Constraints (FK, PK, Check), Triggers, Packages, Functions, Views and Materialized Views.
Senior Systems Engineer / VIS Developer, CSRA / eNTEGRITI, Washington, DC, 2002-2016
Mr. Rowe served as the senior Oracle developer for the USCIS VIS project. Designs and develops Oracle 11g stored program units and objects using SQL, PL/SQL, SQL*Plus, SQL Navigator and TOAD. He has also developed advanced programs using Perl to facilitate automated DB builds and deployments.
Mr. Rowe is a Certified Oracle Professional designing and creating new database schemas, tables, views, packages, procedures, functions, triggers, indexes, foreign and primary key constraints, object types, classes, and materialized views for the VIS project. Uses TKProf, Autotrace and Explain Plans to analyze existing code statistics for efficiency/performance, and applies necessary and effective tuning techniques for throughput and efficiency. Coordinates and performs release builds of the applications and mentors the deployments into staging and production environments.
Mr. Rowe has demonstrated proficiency and received recognition in managing the implementation of Oracle technology. Familiar with new and advanced Oracle 11g features. Mr. Rowe is also fluent in SQL and PL/SQL performance tuning and optimization.
Oracle Developer/Business Objects Developer, PSINET/COGENT Communications, Herndon, VA, May 2000 to June 2002. Mr. Rowe was recruited to replace three contracted custom Oracle applications consultants. Served as application developer supporting PSINet’s customers and nationwide user community. Designed, developed, and supported Oracle Forms applications and Oracle 7/8 database program units: created and modified tables, schemas, data, views, sequences, constraints, synonyms, scripts, packages, procedures, functions and database triggers, using SQL, PL/SQL, SQL*Plus, Developer 2000, and TOAD. Received excellent reviews from management and user groups. Maintained all aspects of PSINet’s Business Objects data warehouse and end user domains, developing all universes, ad hoc, canned reports for 2000+ end users. Trained end users on Business Objects. Performed ETL of Cogent’s data into PSINet’s systems after merger. Developed staging tables, load processes (packages, triggers, scripts, etc.), and views, to enable data analysis and due diligence.
Programmer/Analyst, Distributed Solutions, Inc., Herndon, VA, November 1998 to May 2000.
Mr. Rowe served as 1 of 4 developers creating and maintaining a government procurement software suite. Coded front end and back end applications in Visual Basic, Visual C++, and COBOL. Migrated Win16 applications developed in Visual C 1.52 to Visual C 6.0 for Win32. Tasks included updating syntax, replacing obsolete APIs, and recreating all old static libraries and dynamic link libraries. Performed analysis on applications developed in Visual C++ and Visual Basic. Resolved outstanding anomalies and developed new features. Maintained and developed back end using CA-Realia II Workbench for COBOL, creating COBOL DDLs, and accessing standard ISAM files for a Visual Basic front end. Performed ongoing maintenance and development on new features for PC applications using COBOL as the back end and Visual Basic as the front end.
Junior Programmer/Analyst, Information Analysis, Inc., Fairfax, VA, April 1998 to November 1998. Mr. Rowe performed Year 2000 analysis by developing and qualifying data element seed lists. Identified date formats and determined proper remediation techniques—windowing or expansion—using UNICAST 2000/PC and CA-Fix/2000 for VSE or MVS. Performed migration of COBOL-68 and COBOL-74 to COBOL II and COBOL-85 using CA-Migrate. Trained new staff members on techniques and various utilities.
Education
Associate's Degree in Software Development, 1998 (National Technical (CLC) of Los Angeles, Los Angeles, CA). 4.0 GPA.
Professional Associations
Oracle Certified Associate
Oracle Certified Professional
CompTIA Security+ ce
Member, National Technical Honor Society
Contact this candidate