John R. Holdsworth

  • Sr. Business Analyst/ Product Owner/ DBA
  • Tampa, FL
  • Member Since Mar 20, 2023

Candidates About

 

 

 

 

John R. Holdsworth

 

SUMMARY

·         Agile-Scrum, Waterfall, Process Improvement, Market Strategy

·         In-depth knowledge of software development life cycle (SDLC), project planning techniques and information modeling techniques

·         Expertise in gathering, analyzing and documenting business requirements and developing Business Requirement Documents and Functional Requirement Specifications.

·         Advance technical knowledge with good understanding of business processes

·         Comprehensive knowledge of presentation software, word processing software and spreadsheets.

·         Expert at gathering requirements creating a plan, user stories and managed the project through implementation

·         BI and reporting expert, UAT Testing, developing VB.net, SQL and JavaScript in production environments.

·         Expertise in Integration Test Plans which was used by functional team as well as development team.

·         Lean – Standardize Job Aides, Workplace Organization, 5 S, Visual Control, Value Steam Mapping, Poka Yoke, Gemba Walks

·         Six Sigma – VOC, Data collection and Measurement System Assurance, Process Mapping SIPOC, Capabilities Analysis, Work Load Analysis, Design of experiments, Quantitative Analysis Tools (Check sheets, Histogram, Pareto)

·         Strong business, financial, pricing, procurement, & estimating analysis skills including development of CER, Parametric, IRR, Payback, Cash Flow, GAP, ROI, Breakeven, and Risk Analysis.

·         Conducted root cause analysis and identified opportunities for process improvement and methods resulting in cost savings and efficiencies.

·         Skilled in organization, time management, and planning skills with great attention to detail.

·         Managed multiple projects and tasks simultaneously while delivering quality within defined timelines.

 

Professional Experience

Tribridge

Tampa

Sr. Business Analyst/ Product Owner - Contractor                                                                                                                February 2018- April 2018

·         Writing User Stories, Acceptance Criteria, and Acceptance Tests

·         Working with two feature teams developing a new software product

·         Functioning as a technical product owner for features on an existing product

·         Created Epics, User Stories, Acceptance Criteria 

·         Daily scrum meetings, retrospectives, grooming sessions and architecture meetings

·         Streamlines features for releases

·         Identified potential issues that need to be addressed to scale the product

·         Made recommendations for continuous integration and process improvements

 

Environment: Jira, Aha, JS Node environment, Python Django Backend, MS Office Suite, SCORM engine, LMS api’s

 

Raymond James

Clearwater

Lead Technology Data Analyst - Contractor                                                                                                                          June 2017- February 2018

·         Creating dashboards with actionable metrics.

·         Created SSRS reports and edited existing reports.

·         Used visual studio, visual studio data tools, sql developer, and eclipse

·         Identified degraded systems and helped created to create a road map mitigation.

·         Created reports for IT service and delivery business units.

·         Created reporting for over 40,000 ETL jobs to identify opportunities for improvement.

·         Created a dashboard displaying all of securities certificate errors and past term, near term or long term certifications.

·         Creating a data warehouse for a single pane of glass view of the businesses metrics.

·         Working with the security team to identify vulnerabilities, and create actionable notifications.

·         Automate processes with PowerShell, SSIS, Talend, and various scripts.

·         Evaluated processes and helped identify the root cause.

·         Analyzed and developed project plans to eliminate critical production failure issues.

·         Using FMEA’s, Data Analysis, Lean Six Sigma principles and tools to enable the stability program.

 

Environment: CA Suite,  BMC Control-M, Venafi, Qualys, Dynotrace,  ODI, Talend, SQL Server, Oracle, PowerShelll, Splunk, Service Now, Angular, JavaScript, Tableau, QlikView , Microsoft Office Suite, BDNA,  Apptio TCO, Lawson

 

MCIM                                                                                                                                                                                         January 2016 – June 2017 Sarasota

Business Data Analyst/ DBA

·         Data conversion from Microsoft SQL Server to Oracle SQL Server

§  Daily and Weekly meeting Identify requirements

§  Mapped fields

§  Converted the database on the 1st attempt

·         App Server Migration

§  Gathered business requirements, functional requirements and technical requirements. Created test plan and coordinated and managed testing.

·         Database Server Migration

§  Gathered business requirements, functional requirements and technical requirements. Created test plan and coordinated and managed testing.

·         Implemented New Web Portal

§  Gathered business requirements, functional requirements and technical requirements. Created test plan and coordinated and managed testing.

·         Edit and make production changes to .Net Environment

§  Gathered business requirements, functional requirements and technical requirements. Created test plan and coordinated and managed testing.

·         App, Web, and Database Server Rollout

§  Scoping

§  Created business requirements, functional requirements and technical requirements

§  Created test plans based on the requirements

§  Executed plan and drove results

·         SSRS, SSIS

§  Created and edited multiple SSIS jobs

·         PLSQL Database Administrator & T-SQL Database Administrator

§  Performed maintained, performance tuned, issued grant privileges, created views, procedures, and schemas

·         Creating Ad Hoc Reports with Crystal Reports

§  Met with business leaders to gather business requirements, functional requirements, technical requirements and designed to meet or exceed the needs of the business

·         Scoping projects, test cases, identify requirements for large scale business/technology projects

·         Utilize various requirements gathering techniques to ensure a holistic understanding of the business goals, scope and needs

·         Transform requirements (business, data & system) into clear & concise, formal specifications (according to methodology, architecture

·         (ex:SOA), and technology standards)

 

Environment: IIS, PLSQL Developer, Microsoft SQL Server, Visual Studio, SSIS, SSRS, Tropics, Gen Source, MS 2008 and 2012 servers, Team Viewer, Microsoft Office, Access, Sage etc                                                                                                       

 

Bankers Financial Corporation                                                                                                                                                         April 2013 – September 2015      St. Petersburg

Business Process Analyst

·         Responsible for generating innovative solutions to bridge the gap between business and IT.

·         Performs the tasks of gathering, analyzing and storing information.

·         Rolled out Salesforce Knowledge (installed, created workflows, gathered requirements and implemented)

·         Managed Appirio strategy sessions regarding Salesforce rollout. We implemented business/IT strategy requirement sessions for every business unit creating requirements for a common language (one centralized data model)between multiple different businesses in Salesforce.

·         Managed multiple projects involving Sales force, Lawson, Image Now, Planet Press, Apex and many other software suites.

·         Worked with multiple ECM and BPM Service Now, Blue Works Live (IBM), and Image Now.

·         Handles the responsibilities of analyzing and documenting business requirement.

·         Provides supports to supervisors by documenting organizational structures, internal processes and clients’ business requirements.

·         Delivered multiple projects that saved the company thousands of dollars multiple times.

·         Evaluated the current state using various lean and six sigma tools then I delivered a story board with recommended improvements some were short term and others were long term projects that would get transitioned to various teams.

 

Environment: Microsoft Office, Visio, Microsoft SQL Server, Planet Press, Selenium, Image Now, AS400, VB.Net, Salesforce, Blueworkslive, SQL, JavaScript, Agile, Balsamiq mockups, IBM, Lawson, Adaptive, Object if Lune, Jira, Selenium, Right Fax, Streem, Avaya, Service Now, Manage Engine, XML, etc..

 

Education

University of Michigan Lean Office and Service Certified                                                                                                                                             August 2014 Ann Arbor, MI

University of South Florida, Bachelors Degree in Economics and General Business                                                                          Graduated Summer 2011 Tampa, FL

Tampa Bay Technology High School Academy of Engineering                                                                                                                                           May 2004 Tampa, FL