Ken Ray
Wildwood,FL
Summary
Professional with significant experience in business analysis, skilled in data-driven decision-making, and process optimization. Strong focus on team collaboration and delivering impactful results. Reliable in adapting to changing needs while leveraging skills in stakeholder management, requirement gathering, and strategic planning. Recognized for analytical thinking, problem-solving abilities, and effective communication.
Overview
25
25
years of professional experience
1
1
Certification
Work History
SR Business Analyst
Orange County Florida
05.2020 - Current
- Responsible for managing more than One-Thousand reports for the Planning Environmental & Dev Services Department.
- Primary liaison between the 23 departments, hundreds of users, and the reporting development team.
- Responsible for upgrading applications, responsible for the User criteria while interfacing with the Technology side making sure the upgrade went smoothly, all documentation was provided and testing of the upgrades before release to the end users.
- Created workflow diagrams to help understand how workflows throughout all the different processes.
- Created and developed monthly and quarterly status reports that provided better insight on how the reporting team could better serve our wide customer base which was both internal users and external services like the State of Florida.
- Documented the entire work flow for the Environmental Protection Department that will serve as the primary guide for converting to a completely new software package
Technical Business Analyst
Spectrum
09.2018 - 05.2020
- Responsible for data mapping, API Interface Design Documentation and analysis between the customer facing provisioning software to Oracle M6 Metasolv.
- Created the internal documents for the mapping and converting of data from Spectrum's legacy system to the new Metasolv format
- Created flow diagrams depicting how the data will migrate from inbound xml request to outbound xml responses.
- Used SAP BO Admin Tool to develop three layers of repository and analyzed current business intelligence or trend data to support recommendations for action
- Prepared a monthly Reporting Package using SAP Business Objects for management by importing data into the repository, building Universes and producing interactive reports.
Business Intelligence Analyst
Lee Hecht Harrison
04.2017 - 09.2018
- Responsible for upgrading all existing systems (39) to increase performance and improve user experiences. All solutions were architected in the .net framework and consisted of multiple API's including RESTful and C# code.
- Performed risk analysis on all in-house applications and associated 3rd party applications. The risk analysis was initiated by GDPR requirements.
- Interfaced with all stakeholders to ensure their commitment to the recommend solution changes was acceptable.
Sr. BI Administrator/Engineer
Comptroller's Office State of Texas
01.2015 - 04.2017
- Designed a new BI 4.1 environment for all the Texas Government agencies within Comptrollers Business unit. This amounted to 11 different divisions/Agencies.
- Architected and engineered a new reporting structure by designing a new BI 4.1 environment, implementing it and the converting the existing 3.X platform to the new 4.1 structure. This included converting Universes, Reports and conversion from MS SQL DB to a DB2 database.
- Organized and implement SCRUM using the Agile method from the old Project Mgmt style. I was the SCRUM Master on this project.
- Responsible for trouble shooting issues with the BI environment in general including debugging Apache issues which is where most of the Java problems happen.
- Responsible for all service patches and upgrades.
- Custom configured the new BI environment with the CPA logos and colors
- Tuning the environment by adding additional servers depending on the workload and the end use of the products (Webi, Explorer etc.) were experiencing the most issues.
- Upgraded the 4.1 system to 4.2 for all 3 environments (Dev, QA & Prod)
Sr. BI Solutions Architect
Bright House Networks Tampa
06.2013 - 01.2015
- Organized and Architected a new customer facing interface for billing and services.
- Introduced and managed a SCRUM Product team using the Agile method as SCRUM Master.
- Architected the entire solutions by properly building the SCRUM Development Team utilizing Bright House employees existing skill sets.
- Performed the initial requirements gathering process acting as the liaison between the customers and the business team.
- Designed and implemented a new BO 4.1 environment with multiple servers
- Migrated and converted existing single 4.0 environment to multi-server 4.1 environment
- Business Development End User Liaison
- Created Universes against Oracle using IDT
- Performed Business Objects Enterprise architect reviews for improving end user reporting experience.
- Created Report, ETL and Data Architecture specifications.
- Performed SAP/BO Enterprise 4.0 & 4.1 upgrades, server tuning and troubleshooting (opening tickets w/ SAP when necessary and leveraging my extensive network).
- Consulted client on how BI 4.1 Enterprise security worked (via Enterprise and Universe security).
- Gathered security requirements from client for BI 4.0.
- Implemented BI 4.1 Enterprise folder/object security and implemented Universe data filtering security.
- Implemented report bursting using BI 41 Enterprise Profiles per client requirements.
- Managed a team of 3 developers
Sr. BI Solutions Architect
Florida Department of Business Professional Regulations
01.2012 - 06.2013
- Architected a reporting environment for all of the FBPR divisions.
- Upgraded 3.x environment to 4.1
- Migrated and converted existing single 3.x environment to multi-server 4.1 environment
- Business Development End User Liaison
- Created Universes against Oracle using IDT & UDT
- Performed Business Objects Enterprise architect reviews for improving end user reporting experience.
- Created Report, ETL and Data Architecture specifications.
- Performed SAP/BO Enterprise 4.0 & 4.1 upgrades, server tuning and troubleshooting (opening tickets w/ SAP when necessary and leveraging my extensive network).
- Consulted client on how BI 4.1 Enterprise security worked (via Enterprise and Universe security).
- Gathered security requirements from client for BI 4.0.
- Implemented BI 4.1 Enterprise folder/object security and implemented Universe data filtering security.
- Implemented report bursting using BI 41 Enterprise Profiles per client requirements.
- Created Complex Webi reports to better understand Business Licensing, Inspections and results
- Utilized SSIS and BO Data Integrator to incorporate data from multiple sources into newly designed Universes.
- Wrote new and modified existing SSRS reports.
Sr. BI Solutions Architect
Honeywell Aero Space Phoenix
01.2010 - 01.2012
- Redesigned the Data structure and reports for AP moving from Oracle to Hana.
- Business development end user liaison
- Converted existing SSRS reports into Crystal and Webi depending on the need.
- Designed the ETL and Data Architecture specifications for the Data Engineering group.
- Performed an in-depth review of their entire BO 3.2 environment and did fine tuning on the structure for better performance.
- Managed a team of 4 developers
Sr. Solutions Architect
TD Bank Mount Laurel
08.2008 - 01.2010
- Designed a new intranet for internal use.
- Managed a team using MS Project of 11 individuals
- Generated Functional Specifications after interviewing 16 department heads
- Implement the project and built the internal team using internal resources available
- Oversaw the QA team to make sure that the software delivered performed per the Functional Specifications and obtained End User signoff
- Controlled the overall project and delivered the expected and desired results to all user with signoffs 3 months earlier than the due date.
Sr. Solutions Architect
Boeing Travel Company Saint Louis
08.2000 - 08.2008
- Created the specifications to convert an antiquated ms-dos based data structure into MS SQL
- Developed and redesigned the internal Travel System converting an aged ms-dos green screen system using the old AS400 with Green Screen into a more modern and user friendly environment using .net.
- Orchestrated corporate standards, guidelines & application guidelines for the entire Boeing company allowing employees to self-book their business trips.
- Designed all the interfacing applications using Sabre as the backbone of the process.
- Wrote interfaces to Hertz & Avis systems.
Education
No Degree - Computer And Information Sciences
Washington U. St. Louis
Skills
- Business process analysis
- Application upgrades
- Workflow documentation
- Data mapping
- API interface design
- SAP Business Objects
- Business intelligence reporting
- Risk assessment
- Agile project management
- SCRUM methodology
- ETL development
- Database migration
- User acceptance testing
- Stakeholder engagement
- Technical documentation creation
- Reporting structure design
- Cross-department collaboration
- Requirements gathering
- Agile methodology
- Stakeholder management
- Business process improvement
- Data analysis expertise
- Process development
- SQL proficiency
- Business administration
- KPI tracking
- Data analysis
- Operations analysis
- Business intelligence tools
- Competitive analysis
- Tableau experience
- Technology architecture analysis
- Business solutions development
- Project management
- Quality assurance
- Systems analysis
- Product management
- Microsoft Office Suite
- Test case scenarios
- Technical writing
- Product development
- Consulting
- Web-based reporting tools
- Customer needs assessment
- Analytical thinking
- Agile methodologies
- Workflow optimization
- Functional specifications
- Decision-making
- Strategic thinking
- Attention to detail
- Time management
- Problem-solving
- Needs assessments
Certification
ACPMPO - Agile Certified Product Manager Product Owner
Certificate 14698118, January 2020
Timeline
SR Business Analyst
Orange County Florida
05.2020 - Current
Technical Business Analyst
Spectrum
09.2018 - 05.2020
Business Intelligence Analyst
Lee Hecht Harrison
04.2017 - 09.2018
Sr. BI Administrator/Engineer
Comptroller's Office State of Texas
01.2015 - 04.2017
Sr. BI Solutions Architect
Bright House Networks Tampa
06.2013 - 01.2015
Sr. BI Solutions Architect
Florida Department of Business Professional Regulations
01.2012 - 06.2013
Sr. BI Solutions Architect
Honeywell Aero Space Phoenix
01.2010 - 01.2012
Sr. Solutions Architect
TD Bank Mount Laurel
08.2008 - 01.2010
Sr. Solutions Architect
Boeing Travel Company Saint Louis
08.2000 - 08.2008
No Degree - Computer And Information Sciences
Washington U. St. Louis