JOHN WHITTED 812-***-****

Staunton, IN ***** ad1dcl@r.postjobfree.com

SUMMARY

Business analysis, development and support of Oracle based applications

Fifteen years’ experience providing and troubleshooting, business analysis, application support, development, systems analysis, testing, and implementation using standard, AGILE and other iterative system development life cycle methodologies such as SAFe Agile and KANBAN

Fifteen years' experience with Oracle 10g,11g,12c, EBS release 12, Reports 2.5-10g & Forms 4.5-6i-10g, PL/SQL, UNIX, LINIX, HTML, TCP/IP, Netezza, Aginity Amp, TOAD, SQL Server 2005, SQL Server 2008, Visual Studio 2005 - 2008, JAVA, TFS, Crystal Reports ver. 10 - XI, C#, .Net Framework 2.0-3.5, Windows, SQL, T-SQL, SQL*Plus, PL/SQL Developer, Oracle Designer 9i, Clintrial, Business Objects, MS Excel, MS Word, MS Access, Visio, Visual Source Safe, TOAD, SQL Developer

Twelve years business analysis and end-user support of various .Net & Oracle-based applications new development, application support and enhancements

Strong Customer Service skills that emphasize customer experience with over 20 years of business analysis, development and troubleshooting hardware and software solutions

EDUCATION

Bachelor of Science - Management Information Systems & Statistics/Quality

May 1997

Indiana State University, Terre Haute, IN

EMPLOYMENT

Systems Analyst – Indiana Public Retirement Systems from December 2022 – June 2023

Business and system analysis of business financial requirements of a retirement system

Meet with business partners to determine business needs and requirements

Document system requirements and technical descriptions for developers

Troubleshoot PL/SQL code to fix bugs or enhancements

Use of Agile methodologies, ceremonies and planning

Develop and unit test bug fixes and enhancements to applications.

Develop and enhance PL/SQL procedures to resolve break-fix trouble tickets

Used Jira and Teams to communicate with team members

Created PL/SQL procedures and SQL scripts to derive business needs and system

requirements

Tune Oracle queries, packages and tables

Strong written and verbal skills

Proficient with Teams, Jira and Word

Senior Software Engineer – Avangrid, contracted through Wipro from May 2021 – June 2022

Record and track test runs and defect in HP ALM

Created PL/SQL procedures and SQL scripts to population data sets and testing scenarios

Write detailed, concise test cases, test scenarios and expected results

Develop and maintain testing requirements

Prepare test data for integration and performance testing environments

Troubleshot data set inconsistencies and established project conventions and minimum requirements for data sets

Collaborated with senior management and SMEs to establish requirements and other milestone deliverables

Participated in team workshop on HP ALM and other project specific tools

Identified and validated application defects in Jira

Trained and mentored new hire testers with project specific tools and concerns

Strong written and verbal skills

Proficient with Teams, Excel, Visio and Word

Lead Software Engineer - Fedex Ground, Contracted through WIpro from May 2019 – January 2021

Mentor, train and support off-shore resources.

Provide business analysis and software support of geographic and route planning software

Document and automate recurring production support issues or break-fixes

Create unit test plans and unit test conditions.

Use of Agile methodologies, ceremonies and planning

Develop and unit test bug fixes and enhancements to applications.

Develop and enhance PL/SQL procedures to resolve break-fix trouble tickets

Business analysis of software solutions and user acceptance testing.

Production support bug fixes using automated as well as ad hoc procedures.

Strong troubleshooting skills of software, application and database

Sound understanding of business requirements and application of Agile methodologies

Liaise with users to ensure deliverables are meeting or exceeding expectations.

Tune Oracle queries, packages and tables

BI Developer - Kroger, Contracted through Sogeti from October 2018 - May 2019

Work with the business resources to provide business analysis of user requirements.

Provide administrative and software support of Business Applications

Validate business requirements are properly configured in test cases and plans

Create unit test plans and unit test conditions.

Provide Agile project management following SAFe framework

Develop bug fixes or small enhancements to applications.

Support automated and ad hoc processing of business rules refined from current business requirements and user acceptance testing.

Deploy bug fixes or enhancements via the standard change control process.

Experience running and troubleshooting ETL processing with Informatica

Ability to translate business problems and opportunities into plans of action including scope and delivery strategy with guidance.

Provide Business requirements analysis, including the documentation of current and future state business processes, and analyzing their interaction and interdependencies to support process design.

Oracle Developer - Archway Marketing from March 2015 - January 2018

•Support and maintain Proship shipping application

•Process Ad Hoc transactions and reports for order and shipping processes

•Troubleshoot, track and resolve software issues on ticket system

•Maintain, troubleshoot and configure application servers

•Application design using standard and AGILE system development life cycle methodologies

•Develop and enhance application user interface using Oracle Fusion Middleware Forms 11g

changes or resolve trouble tickets

•Developed LINIX, SQL and PL/SQL scripts

•Develop business logic in EBS release 12 AP

•Troubleshot JAVA applications

•Proficient in the use of PL/SQL Developer and Excel to create Ad Hoc reports for Managers

Oracle Developer - Sony DADC from Sept 2013 - March 2015

Support and maintain three manufacturing ERP applications on Oracle 11g - Oracle Manufacturing 11i standard and customized modules, a fully custom and a third-party order entry application

Develop business logic in EBS release 12 AP

Facilitate functional design and functional documentation with subject matter experts and monitor project progress

Maintain and track version control of all objects across seven database instances using PVCS

Provide application design using standard and AGILE system development life cycle methodologies

Develop and enhance application user interface using Oracle Forms 6i and reports using Oracle Reports R6i

Develop and enhance PL/SQL packages, procedures, functions and triggers to support system wide changes or resolve trouble tickets

Define, monitor and maintain system processes in Concurrent Manager tool

Tuned code changes using Explain Plan, TKPROF and database monitoring tools

Write technical design and enhancement documentation

Developed UNIX, SQL and PL/SQL scripts

Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer

IT Support Technician - Alorica from Jan 2009 - Sept 2013

Develop, support and maintain ERP applications on Oracle 10g and 11g

Maintain and track version control of all objects through the development process

Maintained and troubleshot end user hardware and application trouble tickets

Educate and mentor users in usage and functionality call center applications

Design of application used AGILE and SDLC system development life cycle

Developed PL/SQL packages, procedures, functions and triggers

Developed UNIX, SQL and PL/SQL scripts

Maintained network and internet connectivity in support of call center telephony and PCs

Write technical design and enhancement documentation and preformed systems analysis

Wrote implementation scripts to promote code through various test, QA and production environments

Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer

Administered Microsoft Active Directory

Contact this candidate