Data Analyst Analytics

Location:

Marrero, LA

Posted:

April 05, 2025

Contact this candidate

Resume:

Marlon F.

Funes

*** ***** **** ***

New Orleans LA 70117

(504) -782-5987

**********@*****.***

Marlon Funes

I earned my Google Data Analytics Professional Certification in June 2022. Data wrangling with statistical analysis using SQL and Python. Data visualization using Tableau and R programming languages. Pursuing a Junior Data Analyst or Associate Data Analyst position.

Skills

SQL – Must variants / DQL – DML – DDL

Programming Languages – R, Tableau & Python

Limited Shell Scripting – Unix /Linux Shell

Spreadsheets – Pivot Tables & VBA

MS Visual Basics – Function & Macros

Workday Adaptive Planning

Power BI Programming

SAS Programming

Cognos Statistics

Math & Statistics Knowledge

Experience

APRIL 2023 – MARCH 2025

LOUISIANA DEPARTMENT OF HEALTH – CDC OFFICE IN LOUSIANA

BENSON TOWER 1450 POYDRAS ST NEW ORLEANS LA 70112

DHHS LA Data Analytics - ELR

Federal mandate to report Electronic Lab Reporting for Infectious Diseases results to DHHS LA using code messaging like, HL7 and CSV format from all health facilities like clinics, hospital, doctors, and laboratories clinic offices in the state of Louisiana.

oUsing SQL queries to investigate and detect any issue from these lab results.

oMaintain and update all issues from these type of formats on JIRA.

oAssistance to epidemiologist team to resolve problems with all facilities.

oAssistance with developed fellow team member to monitor and resolve any issues with Rhapsody server.

oHL7 & ECR Code Standardization and experience troubleshooting these coding issues.

oExperience writing logic for health Information systems and data exchange interface engine responsibilities.

oAssist meeting from federal agencies regarding the mandate and all relevant news and regarding all updates for incoming and proposed changes on this standardization with all states.

oMonitor and update the LOINC and SNOMED libraries in Rhapsody.

oAssistance from epidemiology teams for their expertise regarding STD, COVID-19, LEAD, EPI and Heavy Metals results.

oMonitor the agencies if compliance with mandate using PowerShell Scripting.

oTrain the facilities on the proper way of using HL7 and CSV format lab results Meeting with most facilities with recurrent issues and discuss way to dissolve these issues.

oAssist fellow co-workers on their responsibilities during OOO. Maintaining cross-training with all team members.

oContact facilities to remind them about the mandate and the responsibilities to forward infectious diseases as soon as possible.

oManual updates to results to properly digest HL7 and CSV messages using SQL.

DECEMBER 1998 – MARCH 2022

PAN-AMERICAN LIFE INSURANCE – 601 Poydras St New Orleans, LA 70130

Group Actuarial Research Assistant – Dec 1998 – June 2016

Over 20 years’ experience data analytics with an IBM DB2 RDBMS, worked with sub-languages commands of SQL with DQL, DML and some DDL statements to extract and manipulation of primary data from in-house administrative and financial databases or systems.

Data visualization and validation data reports using MS Office tools for the actuarial, financial, administrative, and audit stakeholders.

Data cleansing, ad-hoc investment, and data mining with primary in-house databases, for different projects regarding administrative, compliance, and audit-trail projects.

Over 18 years of actuarial analytical work, mathematical, and statistical methods to assess insurance risk in general group insurance line of businesses(lobs).

Monthly lobs product reserves:

oDue & Unpaid Premium & Commission Accruals.

oUnearned Premium & Commission Accruals.

oPending Life and Health Claims Accruals.

oValuation Reinsurance agreement Pooled contracts Accruals.

oSupport the Statutory and GAAP compliance with required reserves.

Valuation lob liabilities product claims reserves:

oclaim cost for pricing variables life and health benefits.

oEstablishing life claims reserve – using factor methodology

oEstablishing medical claim reserve – using lag (incurred vs paid) or run-off claim triangle, trend and completion factors methodology.

Quarter Financial Statements Notes

oGeneral Policyholder exhibits; demographic and general claim statements.

oAnnual Statements compliance exhibits line 11, 12, Page 40.11, and Page 50.70.

oProfit Sharing valuation for participating polices. Incurred vs Paid Loss Ratios determination of benefits. Valuation and estimation of Risk Sharing Agreement, self-funding arrangements and retrospective premium liabilities arrangements.

Developing, Maintenance and Training of product Quote Rating and Renewal tools:

oDeveloped the quoting spreadsheet program. Using Excel VBA functions and macros and overall tools to all underwriters in the field.

oHTML Renewal quoting engine, maintaining the proper tables, updates, changes and approve user behavior of tool.

Overall establishing compliance proper paper trail, backup, and storage of any material evidence for any inside or outside audit agency, rating agency, and commissioner examination in site.

Meta Data Team Member – To provide feedback and overall ideas about dealing with data mining procedures, data mappings, and overall experience dealing with confidentially PI information and relevant data regarding our clients and partners.

Financial Planning & Analytics - July2016 – March 2022

Data wrangling and general Ad-hoc analytics functions from admin and financial in-house databases for financial planning and reporting of expenses, actuals, budget, forecasting and cash-flow statements.

Visualization of budget, expense, actuals, accrued reserves, cash-flow, and P&L reports using Tableau Desktop and Prep software.

Assessing and maintaining various detailed financial modeled reports, variance, trend, scenario and long-range planning, with monthly and quarterly financial KPI reports.

Assistance and collaboration with team member and department during test-budget process. Presentation of proper exhibits and demonstration for the proper way of mitigating time-constraints during this stressful budgeting process.

Implementation, assistance and modeling of Workday Adaptive Planning (WAP), a programmable software tool for budgeting and forecasting reporting.

Handful of additional projects with different team member to facilitate access to the Workday Adaptive Planning tool.

Maintenance and assistance of historical actuals, expenses, and forecast datasets from general ledger to the different report’s needs of the WAP tool.

Maintaining Cognos reporting with automatization from general ledger system to different stakeholders key Q&A reporting, during monthly, quarterly and annual basis financial needs.

Assistance to CEO, CFO, Sales, Marketing, Legal, Accounting, Financial, and Actuarial stakeholder during monthly and quarterly reporting during strategic plan assignments.

Monthly and Quarterly financial statements with consolidating and reconciled financial statements.

Education

JUNE 2022

Google Data Analytics / www.coursera.org

Press ctrl + click to view

MAY 2022

IBM Data Engineering Foundation / www.coursera.org

Press ctrl + click to view

MARCH 2023

SAS Programmer Professional / www.coursera.org

Press ctrl + click to view certification progress – full certification by March 2023.

MAY 1989

Warren Easton High School

New Orleans LA

Activities

Avid code writer of Machine Learning Algorithms models for data analytics using Python. Jupiter’s conda junior programmer developer. Loving the idea of creating my own ETL or ELT pipelines for relaxing and lazy weekend outings. Logging extreme number of hours of Conda-script-code to evaluate my algorithms hypothesis and prefunding ideas about data analytics with ML models, i.e. Numpy, Scikit-learn, and Pandas. Decision Trees, Artificial Neural Network, Logistic Regression, Recommender Systems, Linear Regression, and many more skills gained over the last 24 months just on my own time.

Also, I am a runner and bicyclist around the city of New Orleans. Before Covid-19 I was a mentor and coach to a group of beginner runners to improve their goal to become a fitter person with emotional-intelligence advice. I am also a music lover and crazy-passionate about code. Particularly SQL and Python for data analytics, I love data for the simple fact that really enjoy the progress of clues and discovering during the visualization of insights from the raw data.

Other Certifications

NOVEMBER 2022

Life, Accident, Health & Annuities Broker / LIC # 1026706

VALID – 03/31/2024

STATUS – TERMINATED

MARCH 2018

LOMA FMLI / www.loma.org

Certification from FMLI – Providing certification upon request

Future Reference

Mr. Willie Henderson - SHHP General Manager Infections Diseases LA – OPH

504-***-****

******.*********@**.***