Andrew Bonniwell
Richmond,VA
Summary
Self-motivated Business Information- gatherer, preparer, and presenter with 15 years of experience in data presentation. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing comprehensive understanding of warehouse operations and documentation needs. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
16
16
years of professional experience
Work History
Data Management Analyst/Data Engineer
SunTrust Bank/Truist Financial
10.2013 - Current
- Reduced manual data entry errors by creating user-friendly templates and standardized input formats.
- Optimized database performance with regular maintenance, indexing, and query optimization strategies.
- Championed strict adherence to company-wide data governance policies, fostering a culture of accountability among employees handling sensitive information.
- Troubleshot data-related problems and coordinated maintenance or modifications to correct defects.
- Used standard document management tools to register documents and maintain databases used to produce logs, transmittal receipts and other reports.
- Collaborated with multi-functional roles to communicate and align development efforts.
- Developed and modified programs to meet customer requirements.
- Validated warehouse data structure and accuracy.
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
- Developed, implemented and maintained data analytics protocols, standards, and documentation.
- Developed and delivered business information solutions.
- Contributed to the development of annual performance metrics by supplying accurate, up-to-date data on key business indicators.
Senior Consultant
Deloitte and Touche
08.2009 - 10.2013
- Member of the core project team in developing a new service line surrounding the Medicare 3-day payment window
- Developed several standardized project processes for use in data analytics
- Served as a technical reviewer on various data pieces throughout a project cycle
- Performed the project manager role for several projects simultaneously which involved leading client calls, coordinating team members and tasks, and documenting and summarizing weekly status updates
- Trained several new individuals on data analytics as well as Microsoft Access
- Built several Access based tools to shorten time spent on repetitive tasks.
- Delivered high-quality solutions for clients through comprehensive research and analysis of industry trends.
- Presented findings and recommendations to executive-level stakeholders, effectively communicating key insights and action plans.
- Prioritized projects and project tasks depending upon key milestones and deadline dates.
- Streamlined project management processes, improving efficiency and reducing overall costs.
- Identified business issues through careful collaboration with key stakeholders.
Data Analyst
Apex (Contracted to Ernst & Young)
04.2008 - 08.2009
- Prepared Medicare bad debt logs for various hospitals across the United States
- Used relational databases to recreate patient accounting systems in order to maximize the number of claimable patient accounts
- Followed continually changing Medicare and Medicaid rules and regulations to advise clients on claimable bad debt balances
- Worked with hospital staff to prepare audit support for Medicare bad debt listings
- Extracted and verified significant quantities of financial and demographic data using Microsoft Access, Monarch, Excel, and other software applications.
- Streamlined data processing for faster results by implementing advanced analytics tools.
Education
MBA -
Averett University
11.2010
BA -
University of Richmond
05.2006
Skills
- ETL development
- SQL Proficiency
- Data Quality Assurance
- Data Governance
- Real-time Analytics
- Data Modeling
- Report Development
- Data Cleansing
- Metadata Management
- Data profiling
- Relational databases
- Data Aggregation Processes
Timeline
Data Management Analyst/Data Engineer
SunTrust Bank/Truist Financial
10.2013 - Current
Senior Consultant
Deloitte and Touche
08.2009 - 10.2013
Data Analyst
Apex (Contracted to Ernst & Young)
04.2008 - 08.2009
MBA -
Averett University
BA -
University of Richmond
Similar Profiles
Brian LeBlancBrian LeBlanc
Vice President, Retail Credit Operations Insurance Servicing Senior Manager at Truist Financial Bank (formerly SunTrust Bank)Vice President, Retail Credit Operations Insurance Servicing Senior Manager at Truist Financial Bank (formerly SunTrust Bank)
Jay BickhamJay Bickham
Project Manager/Program Manager at SunTrust/Truist FinancialProject Manager/Program Manager at SunTrust/Truist Financial
JAN NATIONSJAN NATIONS
EXPERIENCE , Assistant Vice President, Collaboration Analyst, Data Management at Truist Financial/SunTrust Banks, IncEXPERIENCE , Assistant Vice President, Collaboration Analyst, Data Management at Truist Financial/SunTrust Banks, Inc