Robert Newberry
Cincinnati,OH
Summary
Dynamic Senior Programmer Analyst with extensive experience at Western and Southern Life Insurance Group, specializing in RDBMS design and ETL development. Proven track record in automating processes with Python and resolving production incidents, demonstrating strong problem-solving skills and technical expertise in SQL and Informatica PowerCenter.
Overview
6
6
years of professional experience
Work History
Senior Programmer Analyst
Western and Southern Life Insurance Group
08.2023 - 02.2025
- Collaborated with product management to design, build and test systems.
- Designed and implemented scalable applications for data extraction and analysis using SQL and Python.
- Developed ETL pipelines for Data Warehousing using Informatica PowerCenter.
- Analyzed and designed relational databases using both Oracle SQL and SSMS.
- Worked Production Incident resolution involving work stoppage for down stream apps/customers.
- Helped lead project development and to train new employees on our systems.
- Completed over 100 User Stories each year, which included ETL Development, Data Services development, design, and automation.
Programmer Analyst
Western and Southern Life Insurance Group
08.2021 - 08.2023
- Delivered system architecture to support high-availability Internet sites with various internal integrations.
- Tested and deployed scalable and highly available warehousing solutions.
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Improved ETL systems with addition of new features and infrastructure.
- Automated manual tasks using Python, mostly for Reference Data Mastering.
Data Analyst
Western and Southern Life Insurance Group
05.2020 - 08.2021
- Produced monthly reports using reusable SQL queries, and automated those that needed it with ETL.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Used statistical methods to analyze data and generate Gap Analysis documents.
- Analyzed and resolved Production Incidents relative to the Data Warehouse that were causing work stoppages downstream.
- Mastered Reference Data Mastering values internally to the Data Warehouse.
Data Testing/Data Analysis Intern
Western and Southern Life Insurance Group
01.2019 - 05.2020
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.
- Commissioned and decommissioned data sets under mentor supervision.
- Monitored ETL code and changes within each sprint, checking for successful data import and quality.
Education
Bachelor of Science - Computer Information Technology
Northern Kentucky University
Highland Heights, KY05-2020
Skills
- RDBMS Design/Development
- SQL (mainly Oracle/SSMS)
- Python
- C#/NET
- REST/SOAP APIs
- Microsoft Office
- Incident resolution
- Code analysis
- Development lifecycle management
- ETL development (Informatica Powercenter)
- Tricentis Tosca software testing
Timeline
Senior Programmer Analyst
Western and Southern Life Insurance Group
08.2023 - 02.2025
Programmer Analyst
Western and Southern Life Insurance Group
08.2021 - 08.2023
Data Analyst
Western and Southern Life Insurance Group
05.2020 - 08.2021
Data Testing/Data Analysis Intern
Western and Southern Life Insurance Group
01.2019 - 05.2020
Bachelor of Science - Computer Information Technology
Northern Kentucky University
Similar Profiles
REBEKAH HOPPERREBEKAH HOPPER
Claims Examiner at Western And Southern Life Insurance GroupClaims Examiner at Western And Southern Life Insurance Group
Bonnie CeliaBonnie Celia
Staff Manager at Western Southern Life InsuranceStaff Manager at Western Southern Life Insurance
Angela MarshAngela Marsh
Insurance Sales Representative at The Western and Southern Life Insurance CompanyInsurance Sales Representative at The Western and Southern Life Insurance Company