SUMMARY:

• Versatile, innovative and motivated analytical professional with extensive experience and industry knowledge as a business and data analyst within highly competitive markets. A strategist committed at organizing and streamlining business processes and producing analyses identifying potential risks using good judgement with attention to detail to ensure accuracy. Communicator with high integrity and an ability to prioritize and meet deadlines. Proven record of leading complex projects while collaborating with others from inception to completion and communicating results to appropriate audience. Self - managed individual with ability to direct multiple projects simultaneously. Adept at pulling data from various sources; SQL queries, Unix environment, Service Now Queries and creating visualizations in Tableau and/or MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Risk Data Analyst

• Supports the activities of the Enterprise Risk organization through the development of dashboards and data analysis of risks. Assists with key risk processes, including monthly early detection of production and loss anomalies. Have solid understanding of segment level risks and their relation to financial forecasts and results.
• Responsible for data accuracy and data mapping between different data sources and reporting for the insurance division with respect to Business Intelligence.
• Manage the process of updating monthly dashboards in SharePoint through SQL tables and Excel spreadsheets. Update and prepare client setup with risk indicators, benchmarks and risk ratings.
• Review dashboard information at client level each month for accuracy and identify operational and underwriting profitability risks.
• Review internal account records, reports and trends to determine root cause of any negative account/client profitability and devise solutions aimed at improving profitability.
• Act as liaison with Assurant Data Analytics team to help ensure that data requests are accurate and complete.
• Develop and document risk scenarios. Understand potential risks as it pertains to time and resource requirements. Leverage experience and knowledge to provide guidance and direction to other departments.
• In Agile environment, participated in the development of New Business Process Request System as Team Member. Did various testing and made recommendations for improvements.

Confidential, Atlanta, GA

Data/Business Analyst

• Responsible for deriving, documenting and gaining approval for data accuracy and data mapping between different data sources and reporting for the insurance division with respect to Business Intelligence
• Liaison between actuarial group and IT development and reporting team to create resolutions. Gathered and understood business needs, determined prioritizations and organized to meet stakeholder needs.

Confidential, Atlanta, GA

Senior Health Information Consultant (Business Analyst)

• Produced weekly and monthly incident analysis report with Tableau and PowerPoint.
• Identified opportunities to improve business processes through analysis of data and transforming results into action plans.
• Perform strategic data analysis and research to support business needs.
• Collaborate in the establishment of business rules and subsequent adherence.
• Identified and translated data trends into strategic recommendations for program development.

Confidential, Atlanta, GA

Business Data Analyst

• Lead analysis and reporting for Dealer Equity program. Identified trends and implemented procedures to increase shareholder profitability.
• Oversaw formation of cession statements and reports for shareholders.
• Main contributor of development and testing of new reporting system, including business processes involving output and controls, to improve customer satisfaction as well as establishing internal benchmarks for accuracy and efficiency.
• Lead C-Level and client communication and reports for program, including pro-formas and share value projections.
• Teamed with financial service institutions and marketing to set up dealer accounts.

Confidential, Norcross, GA

Business Data Analyst

• Obtained comprehensive understanding of data content and business processes
• Collected, organized and processed data from multiple sources and verified accuracy. Prepared and disseminated monthly data reports for insurers and other clients (large data sets sent and/or received primarily using FTP sites - internal and external). Served as a primary point of contact for any inquiries. In charge of the development, testing and implementation of new strategies, processes and reporting to increase efficiency and accuracy.
• In charge of monthly reporting to insurers including Assurant, XL, Zurich, Cigna, Lloyd s & Royal.
• Extensive use of MS Excel spreadsheets with pivot tables and SQL data queries to effectively manage business results and make improvements. Merged data files from Unix ascii output and reports, SQL queries for analysis.
• Drove business analysis, forecasting, trend analysis and development of programs by examining business results by coverage, deductible, sales date range, odometer and other factors to improve aggregate, as well as, dealer specific business programs and operations.
• Analyze participant’s business results and where needed recommend business mix changes or implementation of multiplier rates to preserve profitability and / or reverse negative trends. Produced reports intended to generate increased revenue and reducing losses / expenses. Extensive use of SQL and advanced MS Excel (pivot tables, vlookups, …)
• Participated in the building and implementation of new earning formulas.
• Project Manager for new client setup and subsequent data reporting and communication. Gather information from client. Setup data transfer requirements. Aligned client data and reporting requirements with company capabilities and collaborate with programmers if changes or additions were needed. Inform client of timeline and make sure deadline is met by leading testing of output, perform any corrections and eventual production drop. Follow-up with client to ensure requirements of request have been met.
• Served as APCO’s Risk Management coordinator to facilitate external auditing performed by policy underwriters / insurers for annual insurance company audits. Was the Risk Management SME in regard to operational procedures and controls, along with any contract or claim inquiries. Audit scores were greatly improved regarding Risk Management operations.
• Support C-Level Executives and other business units (Accounting, Finance, Claims, Sales, Marketing, Underwriting, Compliance) with regular and ad hoc reporting, specific analyses as requested, identify reporting deficiencies, recommend and implement operational improvements to track key performance metrics.
• Involved in the establishment of dealer equity program coordinating different functions of company, insurers, offshore administrators. Developed pro-formas and share value projections for shareholders. Instructed sales agents in the use of these to generate sales.
• Trained and provided guidance to colleagues in the use of company (Unix based) system and other resources to produce reports and interpret results, improved data accuracy, program management and set-up. SME for company reporting and database setup for internal and external requests.

Confidential, Atlanta, GA

Senior Statistical Analyst (Business Analyst)

• Provided labor statistics and analysis focusing on civilian and public labor force employment, unemployment and periodic changes by job sector. Analysis on statewide and metropolitan statistical area basis.
• Findings used in narratives, graphs and charts within monthly state publication, Georgia Labor Market Trends.
• Recognized as a primary contact for government personnel, researchers and general public inquiries.