Abraham Simmons

ad05k9@r.postjobfree.com 470-***-**** Atlanta, GA

https://www.linkedin.com/in/abraham-simmons-97b401166/ SUMMARY

Seasoned Business Systems Analyst with 9 years of experience in delivering comprehensive reporting solutions and data analysis across diverse industries. Expertise in translating complex business requirements into actionable insights and developing strategic solutions to enhance decision-making processes. Proficient in a wide range of data tools and software applications, driving operational efficiency, supporting risk assessment, and improving client satisfaction. Seeking role as Business Systems Analyst.

WORK EXPERIENCE

Business System Analyst

• Delivered comprehensive reporting solutions and data analysis across multiple industries, translating complex business requirements into actionable insights to enhance decision-making processes.

• Developed strategic solutions, utilizing a broad spectrum of data tools and software applications to drive operational efficiency and support risk assessment.

• Improved client satisfaction through expert data analysis and the implementation of tailored reporting solutions. Allegion (TCS)

Business Analyst Senior Jul 2023 - Nov 2023

• Facilitated cross-departmental cooperation to develop enduring data solutions, effectively interpreting complex business requirements into technical specifications.

• Led the onboarding of ALFAK and Great Plains data source systems onto Azure, utilizing Microsoft 365 for reporting, ensuring seamless data migration and validation.

• Developed and implemented project workflows, delivering timely status updates and comprehensive reports to all relevant parties.

• Constructed dynamic, visually engaging dashboards and reports using Power BI, conducting in-depth analysis on tested and deployed scripts to ensure optimal performance. USAA (TCS)

Reporting Analyst Senior Jan 2022 - Jul 2023

• Delivered comprehensive data analysis and reporting solutions, utilizing advanced proficiency in SQL, Tableau, and data reporting/analysis tools, to drive business intelligence and solve complex business problems in the Property

& Casualty sector.

• Collaborated across departments to conduct thorough analyses, reviews, and estimations for client requests, resulting in clear, data-driven recommendations to enhance business performance and growth.

• Managed and facilitated daily project management calls utilizing AGILE methodology, ensuring effective progression and completion of Commercial line property and casualty insurance projects.

• Developed and optimized data views, dashboards, and analysis, employing tools such as Google Analytics and Google Tag Manager, to provide actionable insights to the marketing team, positively impacting the business's bottom line.

Compass Group (Canteen One)

Business Data Analyst Jun 2021 - Jan 2022

• Oversaw the management and enhancement of Business Objects universes and reports, contributing crucial technical documentation for solution development and collaborating with a range of professionals including business analysts, project managers, and data engineers.

• Conducted comprehensive technical analysis and design documentation to meet business requirements, with a focus on integrating vendor JSON files for reporting. This involved working closely with product managers on roadmap planning and prioritization.

• Identified potential business expansion opportunities through thorough data gathering and analysis. Influenced stakeholders to garner support for business projects, and ensured optimal business outcomes by improving processes and managing selected initiatives.

• Selected and deployed debugging tools to analyze, test, and debug software, recommending improvements and identifying automation opportunities. Developed and supported the JDE application and Data Integrator for vendor data management, and created Entity Relationship Diagrams (ERDs) for source-to-target mapping. Developed reports and dashboards in Power BI, Excel, Power Pivot, AWS, SAP ERP to monitor and understand business performance.

Advocate Health Advisors

Life & Health Insurance Producer Jul 2020 - Jun 2021

• Assessed client needs thoroughly and recommended fitting insurance plans, utilizing exceptional customer service skills to provide clear communication and assist clients in navigating a range of insurance options.

• Engaged in property and casualty insurance initiatives, facilitating daily scrum calls and conducting grooming sessions to enhance project management practices, demonstrating a deep understanding of specific rating procedures for Property and Casualty coverage.

• Showcased proficiency in AML, AHIP, and HIPAA compliance, establishing out-of-pocket expense limits for clients to safeguard against unforeseen healthcare costs, and ensuring client access to preferred healthcare providers at minimized costs.

AT&T, Atlanta, GA

Sr Data Analyst Jul 2018 - Jul 2020

• Developed and optimized data systems to bolster real-time file ingestion and data integrity, utilizing tools such as Toad, Teradata, Vertica, and relational databases.

• Utilized predictive modeling to identify potential areas of intervention, thereby enhancing performance and operational efficiencies.

• Leveraged advanced data visualization tools such as Tableau, SQL, SAS, and Power BI to effectively communicate complex data and analysis to meet sector-specific needs.

• Developed and implemented custom ETL pipelines utilizing Python, ensuring seamless data integration and efficient SQL script ingestion.

TRUIST, Atlanta, GA

MIS Business-Aml Risk Analyst Jul 2016 - Jul 2018

• Led AML risk analysis for both new and existing business requirements, successfully implementing and maintaining compliance solutions in accordance with KYC regulations across Retail and Private Wealth sectors.

• Enhanced operational efficiency and accuracy by leveraging data management tools such as Teradata for thorough data analysis, QA testing, and alert investigations, while collaborating with non-technical teams to automate financial reporting and system projects.

• Played a pivotal role as a liaison across operational, financial management, and sales teams, facilitating effective vendor management, forecasting revenue sales, and addressing high-risk activities in Retail Banking, Private Wealth Management, and Wholesale Banking.

WEST ROCK, Norcross, GA

Lead Implementation Consultant/Ba May 2016 - Jun 2016

• Led cross-functional teams to successfully integrate system standards and data models, improving architecture and enhancing customer visibility across various divisions. This was achieved through effective project management, rigorous QA testing, and data normalization and validation procedures.

• Utilized a strong understanding of SQL to identify business problems and recommended data-driven solutions. This was supplemented by the use of various tools, including MS Access/Excel with VBA Macros, SAP BO, Sales Force, and Power BI for project management, data analysis, and reporting.

• Conducted comprehensive data analysis and documented findings, providing vital insights for future improvements. This involved investigating and documenting discrepancies, managing project resources efficiently, and creating detailed design specifications for the implementation of cross-functional system architecture. COCA COLA, Atlanta, GA

EQ Business Analyst/Master Data Analyst Oct 2015 - Dec 2015

• Spearheaded the development and implementation of data warehouse solutions, leveraging tools such as SQL Server Management Studio, Erwin, and MS Access/Excel with VBA to manage complex data sets and optimize validation processes.

• Conducted User Acceptance Testing for an automation tool, identifying defects, conducting data cleansing, and performing master data lookups, thereby enhancing data integrity and operational efficiency.

• Played a critical role as a Business Analyst during the transition of territories, ensuring accurate validation of equipment and parts, and incorporating new rules into the automation process for enhanced validation. SEDGWICK CMS, Atlanta, GA

Business Analyst/Sr. Data Analyst Aug 2012 - Jan 2014

• Managed data analysis and transformation, utilizing SQL Server Management Studio, Visual Studio.net, SSRS, Hyperion, Business Objects, Data Model Tools, MS Access, and Excel with VBA to generate vital reports for risk assessment, healthcare coverage analysis, and strategic decision-making.

• Led the development and implementation of custom client reporting systems for claim and incident analysis, fulfilling ad-hoc requests for litigation and client operations, and enhancing business efficiency.

• Implemented an address validation system to improve Return on Investment (ROI) at the internal call center, ensuring adherence to data standards and specifications, and leveraging advanced data manipulation techniques for efficient data retrieval and analysis.

EDUCATION

Keller Grad School of Mgmt

M.S. in Project Management/Info. Systems

2006

DeVry University

B.S. in Computer Engineering

2003

MGTC Warner Robins

AAS in Electronics Communications Technology

1999

CERTIFICATIONS

Business Intelligence Design, New Horizons - Atlanta, GA 2015 Salesforce CRM/ERM Training, Quotum Tech - Alpharetta, GA 2018 SKILLS

Microsoft Office Tools (Word, Excel, PowerPoint) • Data Analysis • Statistical Modeling • Data Visualization Techniques • SQL/MySQL • MS Access & Excel VBA Macro/Functions • Python • R Programming Languages • Machine Learning Algorithms • Predictive Modeling Techniques • Big Data Technologies (Hadoop, Spark, Hive)

• Data Manipulation • Analytical Reporting • Teradata Management • Data Mapping & Transformation • MDM Validation • SQL Server Management Studio • Visual Studio.net • SSRS • Hyperion • Business Objects • Data Model Tools • Project Management • Custom Client Reporting • Claim and Incident Analysis • Troubleshooting • Debugging & Testing • UAT & Validation for Quality Control • Data Quality Testing • Unit & Integration Testing

• Business Requirements Gathering • Project Completion Skills • Stakeholder Management • Conflict Resolution • Service & Support • Root Cause Analysis • Process Improvement • Technical Documentation • Time Management & Prioritization • Regulatory Compliance • Roadmap & Strategic Planning • Team Leadership & Vendor Management

• Report and Dashboard Creation • Tableau • Power BI • Sales Force • SSRS/VS.net • Access • Anaconda • Hyperion

• Sas • SQL Server • Financial Reporting Automation • Research & Analysis • Ad-Hoc Reporting • Data Management

• Data Discovery and Modeling • Data Mining • Data Profiling • Mapping & Transformation • Business Intelligence

• ETL Automation • Decision & Risk Analysis • AML Risk Process & Analysis • Trend Analysis • Quality Assurance

• Claim & EDI Analyst • Forecasting • Software Development • Troubleshooting • Debugging & Testing • Ifs • UAT

& Validation for Quality Control • Data Quality Testing • Unit & Integration Testing • Project Management & Development Business Skills

Contact this candidate