Amy L. Hill
Amelia,OH
Summary
Dynamic Lead Business Analyst with a proven track record, enhancing data integration and streamlining processes. Expert in Data Warehouse and Team Leadership, I significantly improved project delivery times. Skilled in SQL and fostering collaboration, my approach boosts efficiency and innovation across technical and analytical domains.
Overview
26
26
years of professional experience
Work History
Lead Business Analyst
American Modern Insurance Group
Amelia, USA
01.2023 - Current
- Manage a team of onshore and offshore Business Analysts.
- Create and maintain business requirements, functional requirements, and data mapping documents as required for projects and production support.
- Elicited, analyzed, and defined business and solution requirements, as well as stakeholder needs, with a focus on data integration to downstream systems.
- Understand, analyze, and translate business requirements into a technical solution.
- Defined and refined process workflows, documented workflow changes, and maintained updates in SharePoint.
- Demonstrate strong technical aptitude and skills, including data warehousing, integration, data mapping, and support for developers and data modelers throughout the project lifecycle.
- Participate in and lead Agile/SCRUM ceremonies aligned with project management best practices.
Senior Business Analyst III
CBTS
Cincinnati, USA
10.2022 - 01.2023
- Develop requirements in support of an overall IT strategy
- Provide documents to business problems
- Understand, analyze and translate business requirements into a technical solution
- Act as a leader within the team, provide technical solutions to business requirements
- Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task analysis, and workflow analysis.
Senior Business Analyst
TQL (Total Quality Logistics)
Cincinnati, USA
05.2021 - 10.2022
- Collaborate with software development team, Business Analyst, Product Owner and internal users providing technical expertise of system enhancements and software development in an Agile development environment
- Provide new technology solutions, including gap analysis and capable of plugging into any phase of the software development life cycle
- Elicit requirements using interviews, document analysis, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, competitive product analysis, task and workflow analysis, and/or requirement workshops
- Participate in daily SCRUM meetings, Sprint reviews, Retros and Planning meetings, support Agile team with deployment, development and implementation of software enhancements and new features
Senior Technical Analyst
Great American Insurance
Cincinnati, USA
01.2021 - 05.2021
- Serve as a support for back-office applications for the Enterprise Data Warehouse, including orchestrations from front-end systems, ETL processes, relational databases, and downstream data marts.
- Serve as QA support for the document distribution web application for specialized insurance business units.
- Serve as a back-end Systems and Business Analyst for the Enterprise Data Warehouse, during a multi-phased project to retire legacy system
- Collaborate with ETL development Team, Business Analyst and internal users providing technical expertise of system mappings and enhancements
- Performs highly complex maintenance and problem resolutions on software applications
- Prepares technical requests for program development, logic, coding and corrections
- Demonstrate strong technical aptitude/skills including data warehousing, integration, data mapping, support developers and data modelers through the project lifecycle
- Execute, debug, create and update integration and smoke tests during the Agile Software development lifecycle of Document storage system
- Define reporting/data requirements for business unit technology needs
- Identify data required in the data warehouse environment to meet the users’ current and potentially future needs
- Analysis, design, implementation and maintenance of data warehouse and/or related productivity tools for the business groups
- Test and validate data, assist data modelers and data architects with physical data design
- Work independently on projects or as a part of a team communicating with a Project Managers on project deliverables, act as consultant to the ETL and front-end programmers
- Define business rules, maintain data dictionary, create integrated data mapping agreements, develop conical xml messages for testing
Business Technology Analyst
Great American Financial Resources
Cincinnati, USA
07.1999 - 11.2010
- Define business technology needs and requirements for TPA (Third Party Administration) department
- Serve as liaison between business users and IT Department
- Designed, developed, debugged, and deployed a custom database replacing manual processes for distribution from annuity contracts
- Gathered user business requirements and designed/developed user interfaces based on requirements utilizing Visual Basic and MS Access
Business Report Specialist
Great American Financial Resources
Cincinnati, USA
03.2004 - 11.2008
- Design reports and develop analytical solutions to a wide range of business challenges, with focus on business expansion and retention
- Create, test, and deploy reports to support business objectives of senior management, field VPs, and sales agents
- Serve as liaison between business users and IT Department—from defining user requirements through report design, development, documentation, testing, deployment, user training, and technical support—while ensuring data integrity throughout the process
Business Analyst II
Great American Financial Resources
Cincinnati, USA
08.2001 - 03.2004
- Analyzed business operations and identified process improvements with both client server application and daily premium accounting department procedures
- Established specifications for system enhancements, built text matrixes, and implemented system enhancements
- Developed training materials, trained business users and provided technical/production support
Supervisor, Premium Accounting
Great American Financial Resources
Cincinnati, USA
07.1999 - 08.2001
- Directed the activities of 8 team members accountable for application of cash receipts (premium and loan payments)
- Researched accounts, associated suspense accounts, and oversaw the billing cycle
- Hired, trained, evaluated and documented employee performance
- Led by example and encouraged employees to work as a team to accomplish business objectives
- Improved employee performance and morale by welcoming suggestions and ideas
- Cultivated a sense of teamwork, while encouraging individual initiative
Education
Associate of Arts - Computer Information Systems-Database Management
Skills
- Data Warehouse
- Data Collection
- Documentation
- End-user Training
- Technical Support
- Team Leadership
- Process Improvement
- SoapUI
- Stylus Studio
- CXML
- My SQL
- SQL Server 2005
- SQL Developer
- Visio
- JavaScript
- OOP
- Visual Basic
- Oracle
- Microsoft Office Products
- JIRA
- Azure DevOps
- Rally
- Informatica
- GitHub
- IntelliJ
- TOAD
- Jenkins
- Quick to learn and apply new technical/software skills
Timeline
Lead Business Analyst
American Modern Insurance Group
01.2023 - Current
Senior Business Analyst III
CBTS
10.2022 - 01.2023
Senior Business Analyst
TQL (Total Quality Logistics)
05.2021 - 10.2022
Senior Technical Analyst
Great American Insurance
01.2021 - 05.2021
Business Report Specialist
Great American Financial Resources
03.2004 - 11.2008
Business Analyst II
Great American Financial Resources
08.2001 - 03.2004
Business Technology Analyst
Great American Financial Resources
07.1999 - 11.2010
Supervisor, Premium Accounting
Great American Financial Resources
07.1999 - 08.2001