John H Lindquist

Melbourne, FL *****

ad4x0h@r.postjobfree.com

Professional Summary

●Energetic IT professional with 35+ years delivering proven software solutions with vast knowledge and experience in a variety of industries and work environments.

●Detail-oriented, proficient at building and maintaining professional relationships. Solid technical leadership skills with demonstrated proficiency in leading and mentoring junior analysts and developers, and to communicate clearly and appropriately to all levels of the management.

●Strong problem-solving skills, adaptable, proactive, and willing to take ownership of the project. Exceptional ability to keep management informed of status changes and progress and to produce high quality technical results. Actively coordinate with peers, management, and internal customers.

●Project management experience managing personnel, defining project scope, determining personnel needs and cost, presenting project proposals to management committee, tracking the full lifecycle of the project, and managing external development teams located nationally and internationally and various cross functional business groups

Summary of Qualifications

●Advanced knowledge of Oracle products from Oracle 6 to Oracle 19c with emphasis on the database design, development, testing, and production deployments, building complex and efficient SQL queries, PL/SQL scripts, SQL tuning, triggers, stored procedures and packages and use of SQL Loader and Data Pump. Demonstrated knowledge and understanding of various database administration functions that included complex data modeling, data analysis, optimization and tuning of databases, data abstraction, debugging SQL, writing automation and data extraction scripts, familiarity with ETL (Extraction, Transformation and Load) processes for data migration.

●Experience installing, administering, and maintaining WebLogic Server 12.2.1.3.0 that included the Fusion Middleware Infrastructure as well as Oracle Identity Management (OIM), Oracle Forms and Reports 12c for Linux RHEL6 & RHEL7 and Windows 10.

●Advanced expertise in SDLC, Object-Oriented Analysis/Design (OOA/OOD), Agile, Waterfall and Oracle Development methodologies. Skilled at requirements gathering and definition, prototyping, proof of concept, design, development, implementation, technical writing, writing testing and deployment scripts and experience with CMMI, AS9100, and ISO9001.

●Excellent oral and written communication skills, extensive knowledge of Microsoft Suite including: Access, Word, Excel, Outlook Express, PowerPoint and Visio. Reporting tools experience: Oracle Reports, Oracle Discoverer, SSRS, Hyperion and Crystal Reports; excellent organization skills and ability to perform detail-oriented work. Strong problem-solving skills, time management skills, adaptable, proactive and willing to take ownership of the project.

Technical Skills

METHODOLOGIES AND CONCEPTS: Agile, Waterfall, OOA/OOD, SDLC, CMMI, KANBAN, Unit and Module Level Testing

DATABASES: Oracle (6i, 7, 8, 9i, 10g, 11g, 11i, 12c, 19c), MS SQL Server, T-SQL, MySQL, dBase, DB2

DATABASE TOOLS: Oracle Designer, Oracle Discoverer (Administration and Design), Oracle Forms and Reports (6i, 7, 8, 9i, 10g, 11g, 12c), 19c), SQL Loader, TOAD for Oracle and SQL Server, Visual FoxPro, SQL Developer, SQL Navigator, Aqua Data Studio for Oracle, Erwin

SOFTWARE: Configuration Control utilizing PVCS, Harvest, GIT and Oracle CM control tool, R & R Studio, IBM Rational tools: ClearQuest. ClearCase, RTC, Team Foundation Server (TFS) and Visual Studio. Strong proficiency with Microsoft suite of tools: (Access, Word, Visio, Excel, Outlook Express, SharePoint and PowerPoint)

LANGUAGE KNOWLEDGE: Ada, Basic, C, C++, ProC, COBOL, FORTRAN, RPG, SQL, PL/SQL, MySQL, Transact-SQL, HTML, CSS, some Java and Unix/JCL/Perl/bash shell scripting and command line interface.

REMOTE ACCESS: HTTP, SMTP, telnet, NFS, FTP, SFTP - WinSCP, Putty, FileZilla, MobaXterm, Bitvise SSH Client

PLATFORMS/OPERATING SYSTEMS: Microsoft Windows (95, 98, 2000, NT, XP, 7, 8, 10, 11), Unix, Linux, Red Hat, VMS, SUN OS, DEC VAX, NFS

Professional Experience

March 2023 to Present

Akkodis, remote for Omaha Public Power District – Oracle Application Developer

Supporting OPPD by performing Oracle Forms and Reports upgrade from Oracle 11g to Oracle 19c with any upgraded changes to the application. Supporting 18 OPPD applications upgrades and testing of 261 Forms and 350 Reports, modifying Oracle tables, views, packages, procedures and functions, while utilizing Windows Servers and Oracle 19c databases.

Oct 2022 to March 2023

Cornerstone Staffing, remote for Brown & Brown Insurance Company – Oracle 12c Developer

Supporting the BB Protector Plans group by performing Trouble Ticket Analysis of their existing Oracle Forms, Oracle Reports, and HTML Insurance applications. Analyzing and troubleshooting the application issues or logic, Oracle PL/SQL, Oracle Forms & Reports, database objects and integrations that comprise Brown & Brown Protector Plan applications. Use of Oracle 12c, GIT source and version control, JIRA Trouble ticket tracking, Azure DevOps, and some Java and Python scripting under an Agile scrum/Kanban environment.

June 2022 to Oct 2022

IMCS Group, remote for Omaha Public Power District – Oracle Application Analyst

Supporting OPPD by performing Application Analysis of their existing Oracle Forms applications. Analyzing and documenting the application logic, Oracle PL/SQL, stored procedures and integrations that comprise OPPD’s Oracle Forms Applications.

June 2021 to May 2022

Kelly Services, remote – Oracle 6i/11g Developer

Supporting Galson Laboratories SGS, Syracuse, NY, with Oracle Forms & Reports 6i and Oracle 11g database, maintenance and new development of their in-house client-server-based system, LIMS, Laboratory Information Management System. Providing expertise in modifying and upgrading Oracle Forms & Oracle Reports 6i, delivered feature enhancements, defect fixes and contributed to code-reviews, discussions, and worked with in-house C-based language - idxl, Linux shell scripting, SQL scripting and PL/SQL code modifications and some DBA functions and source control was performed through TFS.

July 2020 to April 2021

IKM TeckChek, remote – Test Author for Oracle 19c Assessment development

Review, evaluate, update, or add new questions to upgrade the test assessment for Oracle 19c from Oracle 12c.

May 2020 to June 2020

VariQ, Elizabeth City, NC – Application Developer

Participating in the design and coding of software products. Troubleshooting problems and providing customer support for application issues. Consulting with project teams and end-users to identify application requirements. Instructing, assigning, directing, and checking the work of other software developers on the development team. Participating in special projects as required, including providing support to Aviation Logistics Division, creating implementation plans for the Configuration Management and System Engineering teams, and attending branch level meetings in addition to daily stand-up meetings.

Prepares comprehensive test plans and conducts tests. Analyzes test results and recommends moderately complex corrections to more experienced software engineers.

Working in a LINUX environment; Ingres ABF and using the following tools: Ingres 4GL, Ingress Report Writer, Subversion, SQL, Linux Shell Scripts, and a participant on an Agile SCRUM Development Team.

May 2019 - October 2019

Centennial Technologies, remote from Melbourne, FL - Senior Oracle Developer

Senior Oracle Consultant instrumental in migrating all existing Oracle 6i objects, for United States Department of Education Federal Student Aid (FSA) legacy system Post-Secondary Education Participants System (PEPS) and the Electronic Application for Approval to Participate in Federal Student Financial Aid Programs (eApp) re-platforming project, to Oracle 12c. Providing expertise in converting and upgrading Oracle Forms, Oracle Reports, Menus, PL/SQL Libraries (PLL), Object Libraries (OLB), SQL and PL/SQL code modifications.

Responsible for the sole conversation, testing and distribution of Oracle Reports and assisted in the conversion of Oracle Forms, replication of look and feel of the original 6i system and 508 compliance. The system was originally a Windows based system being upgraded to Linux 7 with source control through Tortoise SVN (Subversion), development with Oracle 12c Reports and Forms Builders and SQL Developer for database management.

April 2017 - May 2019

MAK Solutions, remote from Melbourne, FL - Senior Oracle Consultant

Senior Oracle Consultant migrating all existing Oracle 6i objects, for Memphis Light, Gas and Water (MLGW) BANNER project, to Oracle 12c. Providing expertise in converting and upgrading over 1300+ Oracle Forms, over 1300+ Reports, Menus, PL/SQL Libraries (PLL), Object Libraries (OLB), SQL and PL/SQL code modifications, created and modified bash, sh and ksh scripts.

Solely responsible for the new installation, configuration, administration, and all maintenance tasks for the WebLogic Server 12.2.1.3.0 that included Java 8 JDK version 1.8.0_151.0, Fusion Middleware Infrastructure and Oracle Identity Management (OIM), Oracle Forms and Reports 12c for Linux RHEL6 & RHEL7 and Windows 10 as well as all upgrades, patches, and enhancements to the Middleware and WebLogic servers. Explored the possibility of replacing existing app with Application Express (APEX).

April 2016 - August 2016

Apex Systems, Orlando, FL - Senior Oracle Developer

Senior Oracle Developer, located onsite at Westgate Resorts, utilizing TOAD for Oracle and provided Oracle 11g Forms and Reports, PL/SQL and SQL support to create and modify existing forms, stored procedures, and tables, debug poorly conceived complex queries, perform trigger creation and code maintenance in support of the Westgate Master Reservation (MR) system.

Provided expertise in writing software to implement requirements for enhancements and bug fixes of in-house custom applications and commercial off the shelf software packages. Integral part of a software team to handle integration, debugging, testing, and troubleshooting of Westgate software releases based on trouble ticket resolution or change order management.

Revamped client software by building, testing, and deploying Oracle 11g SQL and PL/SQL queries, packages, procedures, functions, triggers, forms, and reports. Modified and updated existing ProC code, VMS and JCL scripts and batch file processing, remote file processing through FTP, telnet, and File Copy processing to and from remote NFS servers via WinSCP and Putty.

January 2016 - February 2016

AceApplications, Orlando, FL - Senior Oracle Developer

Senior Oracle Developer, located onsite at Transcore, for Software Development and Analysis support for new transportation software/upgrades for the Central Florida Expressway Authority, Lee County Expressway Authority and the Florida Turnpike Expressway Authority projects.

Captured, compiled, reviewed, defined, validated and documented business processes, software requirements and database solutions and implementations. Worked with client PLLs to analyze database changes and make suggestions to improve efficiencies, access time and possible tuning solutions.

Improved the client software functionality by building, testing and deploying Oracle 10g SQL and PL/SQL queries, packages, procedures, functions and triggers. Utilized C programming, PERL scripts, Java, VMS and JCL scripts and batch file processing, SFTP and TC/IP file transfer protocol.

March 2015 - October 2015

Fahrenheit IT, remote from Melbourne, FL - Principal Business Analyst

Main Business Analyst/Project Manager, performing remote work for TeleTech Holdings onsite in Melbourne, FL, to support eight different TeleTech Call Center projects utilizing an Agile Methodology for half of those.

Documented comprehensive technical processes in addition to the creation of business and functional requirements documents (BRD/FRD) for applications and reporting.

Analyzed and determined business problems/opportunities for multiple concurrent projects. Performed extensive Data Analysis utilizing Visual Studio for both Oracle and SQLServer backends, Supported the implementation of Oracle Financial Application Module using sub-modules Accounts Payable and Accounts Receivable

Authored detailed business requirements documents, functional specifications, use cases, test cases, process flow, data flow, state, and UML models to communicate business needs to developers and non-technical management.

Managed personnel, defined project scope, determined personnel needs and cost, presented project proposals to management committee, tracked the full lifecycle of the project, and managed external development teams located nationally and internationally and various cross functional business groups.

September 2014 - October 2014

RoTech Systems Group, Winter Park, FL - Business Systems Analyst IV

Business Systems Analyst IV to support the Rotech Tracking System (RTS), an Oracle and Java based system to track customer healthcare records containing PSI, insurance, and provide service and goods information for the customers to the various location personnel.

Collaborated with various internal business units and external users, to investigate and analyze location and management requests for additions or changes to the system.

Gathered, compiled, reviewed, defined, validated and documented business processes and software requirements. Assisted the software developers through the designing, coding, testing, and deployment phases by providing Oracle 10g SQL queries and step by step processing for the development effort.

December 2013 - June 2014

Insight Global, Orlando, FL - Senior Oracle Consultant

Provided Oracle expertise as a Senior Oracle Consultant, onsite ate Wyndham Vacation Ownership, specializing in PL/SQL development utilizing TOAD for Oracle and provided Oracle Forms 9i, PL/SQL and SQL support to create and modify existing forms, stored procedures, and tables, debug poorly conceived complex queries, perform trigger creation and code maintenance and provided data analysis utilizing R & R Studio.

Enhanced the Wyndham software by performing problem definition, developed, created and improved the database structure, debugged and updated existing forms, testing of enhanced PL/SQL and SQL code, created scripts for ETL and Hyperion developers, created functional technical specs, end-user documentation, server load balancing and implementation and post-implementation phases of two large software projects utilizing Oracle 11g based off of trouble ticket resolution and change order management.

June 2011 - October 2013

Phase One Consulting Group, remote in Melbourne, FL - Database Architect/Senior Software Engineer

Provided expertise to a wide variety of government clients as an Oracle Database Administrator and Architect, SQLServer Developer, senior PL/SQL and SQL developer, Senior Requirements Analyst, and Technical Database Consultant. Lead Developer on the VA Homeless Management Information System project and performed SQL Server administrative support and technical analysis as well as supporting the creation of on-line survey portals for Veteran’s and Veteran advocates.

Led the team for the VA VBMS-R application as the Oracle Database Administrator, Technical Lead for the Agile project team, responsible for the day-to-day operations on lower-level database environments (Dev, Test, QA, UAT) and interfaced with the VA DBAs on pre-production and production software and database releases. Provided extensive PL/SQL and SQL expertise to 50+ developers and testers.

Streamlined the VA BMS/BH project as the Oracle PL/SQL & SQL developer and information/database architect which also included SQL Server database support with Transact-SQL (T-SQL) development, built Visual FoxPro applications and utilized experience and skills to deliver multiple technical documents and database architecture diagrams.

February 2001 - September 2009

Lockheed Martin Space Systems, Cape Canaveral, FL - Senior Systems Designer Staff

Technical Lead and Database Architect for creation, development, deployment and maintenance of the Material Acquisition System (MAS), an Oracle and web-based Lockheed intranet system to support the logistics, requisition, tracking, stocking and all financial aspects of support for the Naval Ordinance Test Unit (NOTU) for the Fleet Ballistic Missile (FBM) program. Responsible for all database definition, database architecture, ERD’s, all migration activities, database creation, development and to improve the database structure utilizing data modeling tools.

Led the development of the Calibration Exchange Pool (CEP) program, an Oracle 9i developed web-based forms, reports and Discoverer program for logistical tracking of submarine upgrades, at SWFLANT and SWFPAC.

Spearheaded the requirements gathering, system concept and design, deployment, and for all aspects of user and customer interface, tutoring and training junior software engineers in various software development and verification activities, how to plan, analyze, design, test and document software and contribute to system integration.

Facilitated exporting data, creating new SQL queries and tuning existing queries, find/debug SQL or PL/SQL code issues, and performing testing within the database.

Lead developer for implementation of Oracle EBS modules to replace existing PL/SQL and Oracle forms functionality. Modules used were the Server Fulfillment, Order Management’s fulfillment functionality, the Supply Chain Management’s Value Chain Management and Orchestration and Fulfillment modules with emphasis on the Order Management process, and the Applications Financial Module’s Fixed Assets.

Extensive knowledge of Oracle Discoverer (Administration and Design), Oracle Forms and Reports (6i, 7, 8, 9i, 10g), PL/SQL, SQL Loader, TOAD for Oracle, ClearQuest for requirement and error tracking, Agile Team Lead for the system development life cycle, Configuration Control utilizing Serena, data extraction/data migration with FTP processing to perform data cleansing and data validation from external DB2 and Sybase databases to the main Oracle database and knowledge of Oracle XML DB Repository usage.

Education

Moorpark College Moorpark, CA - No degree, field of study - Liberal Arts

Pacific Career College Moorpark, CA - Technical Certificate in Computer Programming

Security Clearance – lapsed

Contact this candidate