Scott Koch Email & Phone Number

Union, KY, US

Cincinnati, Ohio, United States

- Support a Fortune 25 retailer in delivering on their commercial and operational goals- Product Lead for a program comprised of 9 different product/engineering teams enabling commercial teams to deliver over $1B in revenue to the organization.- Lead and coach a team of 7 Product Managers responsible for Enterprise Data Product & Services ranging from data.

Cincinnati, Ohio, United States

- Responsibility for building data products focused on price, promotion, and cost data used by data scientists to optimize retail and promotion prices for product catalog.- Launched multiple new data products, including one that combined cost from numerous sources to create a single source-of-truth data asset as well as an asset focused the view of a.

Cincinnati, Ohio

- Used SQL and PySpark to analyze data assets from Kroger and 3rd parties to find patterns in the data, detect anomalies, and troubleshoot issues in the downstream science packages.

Cincinnati, Ohio

• Develop and manage VBA code for new and existing MS Access and Excel department tools
• Create SQL queries using IBM Data Studio for extracting various statistics to enable strategic decisions
• Lead design of SQL queries to identify data anomalies and errors to keep client records in pristine condition
• Incorporate ETL concepts for implementation of PRT solutions
• Coach and develop analysts responsible for quality assurance testing and production support of two systems
• Manage testing strategy for large-scale projects involving numerous departments and teams

Cincinnati, Ohio

• Taught myself SQL to extract key data points from payout system and provide more timely support to production area
• Championed the use of IBM Data Studio within team to enhance testing and production support capabilities
• Coached and developed analysts responsible for quality assurance testing and production support on multiple systems
• Hired, trained, and led team of inexperienced, new onshore and offshore testers across multiple product lines
• Managed project deliverables and testing resources for system and product enhancements
• Evaluated direct reports based on enterprise’s performance management model

Cincinnati, Ohio

• Taught myself VBA programming to better capture product data for my director
• Wrote queries daily to provide leadership team with data needed to make product and resource decisions
• Created new reports for management, built new applications for tracking data, and developed innovative solutions to automate manual processes.
• Maintained existing database applications, built ad hoc queries to assist with department audits, and served as a subject matter expert for the data available in the department
• Developed an Access database application for tracking in-good-order rates for the applications received for each of our 23 annuity products which led to additional process improvements across the department
• Built and maintained Excel data analytics tool presenting data related to newest, most popular annuity product

Cincinnati, OH

• Led and tested enhancements and updates for an administrative system and a front-end system, both supporting an Enterprise Annuity product
• Created test plans and test matrices; performed System-Integration and User-Acceptance Testing
• Provided production support to the business areas for in-force contracts.
• Implemented and led a group, comprised of management and associates within the department, that shared ideas for using Excel, Access, and other tools to improve testing efficiency and quality
• Developed and implemented a new Excel testing tool that combined our Test Plan, Test Matrix, Risk Assessment and Reporting statistics into one collaborative workbook which increased efficiency and reduced the amount of.
• Served as department lead on Enterprise testing initiative

• Provided production support for the Enterprise Single Premium Immediate Annuity administrative system, as well as support for testing efforts of system enhancements and upgrades.
• Achieved greater accuracy during a calculation modification project by discovering errors in, and correcting, several formulas on the Actuarial calculator spreadsheets resulting in incorrect values

• Provided client consultation over the phone for multiple products and lines of business
• Researched contract errors and ensured resolution
• Processed contract changes

• Reviewed and processed incoming annuity applications
• Balanced new money reports
• Collaborated with internal wholesaler team for proper issuance of troublesome annuity contracts.
• After discovering an issue in which payments were processing on the wrong day, determined which contracts were impacted, worked with the business area on corrective action, and developed a system solution

Bachelor Of Science - Bs, Finance And Financial Management Services

Activities and Societies: Sigma Phi Epsilon Fraternity

Bachelor Of Science, Financial Management

Activities and Societies: Sigma Phi Epsilon, Beta Gamma Sigma