Dynamic data Analyst with a proven track record, excelling in SQL and PL/SQL to optimize data processes. Recognized for robust data engineering solutions and enhancing operational efficiency. Strong analytical skills complemented by effective communication, driving impactful results in complex environments.
Visual Studio, MS SQL Management Studio, Visio, Toad, and SQL Developer
Azure, Windows Server, HP Unix, Linux CentOS
Data collection, cleansing, validation, integration, visualization, interpretation, presentation, statistical analysis
Effective verbal and written communication, analytical problem solving, attention to detail, team collaboration, strong work ethic, business management
Worked in a small cross-functional team to design and build a web-based catering management platform using Oracle Cloud DB/APEX. Used Integrated APEX AI-driven features to enhance user experience. Project development paused due to funding constraints.
Data Engineer-Analyst
Utilize Health
Nashville, TN
09.2019 - 10.2022
Designed and implemented an on-site SQL Server data warehouse to integrate medical claims, clinician profiles, and CDC disease mapping. Ingested claims data from multiple carriers and applied advanced SQL techniques to extract, clean, and validate large datasets.
Performed statistical analysis on health insurance claims data—including recovery time, cost, and readmission rates—to evaluate the impact of clinician interventions. Compared outcomes between controlled and experimental groups to assess statistical significance. Delivered findings through aggregated/detailed reports and dashboards to management.
Produced ad hoc reports to management and clinical teams based on operational needs.
Data Analyst
Applied Health Analytics
Nashville, TN
02.2018 - 05.2019
Designed and developed an Azure SQL Server DW for member surveys, coaching & outcomes, clinicians, member hierarchy, health and prescription insurance claims, CDC/disease codes, fit bits, and HL7 feeds. Creates SSAS OLAP reporting. Built advanced SQL stored procedures, functions, and indexed views for member cohorts, data cleansing, imputation, aggregations.
Installed, configured, and maintained an 8-node Hadoop cluster, Hive, Sqoop, Spark, and Python on Linux CentOS. Set up a data platform for modeling and machine learning.
Applied multivariate regression, factor analysis, Markov chains, jump diffusion, and dispersion models to identify members at risk and fit claims data to estimate claim size and frequency.
Implemented SQL Server I/O performance bottlenecks and generated PBI/PBRS dashboard to monitor and resolve production server bottlenecks. Optimized SQL Server configuration, maintenance plans, database settings, and performed extensive SQL running.
Entrepreneur / Database Analyst
Athens Family Restaurant
Nashville, TN
11.2005 - 11.2016
Designed, developed and deployed web-based restaurant management software with built-in reporting engine, inventory management, ledger, employee scheduling, BOM costing and menu pricing optimizer using PL/SQL, APEX, JavaScript, and Linux.
Database Programmer – Contract
F.I.S. Global
Tampa, FL
12.2011 - 06.2012
Supported on-site and offshore teams in coding, testing, and integrating new functionality in the company's online payment system – PAYGO. Maintained and tuned PL/SQL packages and created stored procedures to return REF CURSOR types for PAYGO frontend.
Programmer Analyst
Investments Scorecard / Informa USA
Nashville, TN
12.2009 - 03.2011
I wrote the initial PerformanceIQ project technical specifications document, flowcharts, and performed upstream and downstream impact analysis on existing database infrastructure with schema changes.
Prepared design documents with schema impact analysis and cost estimates for all of my assigned projects, and presented the proposed design in design review sessions with the chief architect and team leads.
Coded proposed database objects, dynamic SQL, procedures, functions, triggers, indexes, views, and synonyms in T-SQL, and reviewed code with the chief architect and team leads.
Created and implemented unit test cases, and reviewed them with the chief architect and team leads. Performed unit testing prior to submitting the project to QA, and fixed bugs if needed.
Performed thorough integration testing, and wrote the necessary installation scripts.
I participated in production support and resolved production issues. Wrote SQL queries to provide data to business analysts as needed, and maintained VB6 code.
Implemented internal utilities in VB.NET using the MVC design pattern.
Senior System Analyst
Nortel Networks
Nashville, TN
09.1997 - 11.2009
Gathered business requirements from senior order, fulfillment management of the Enterprise Solutions (ES) division, produced functional/design specifications. Designed and developed operations SQL DW/DM PL/SQL objects, Coded SQL Loader, Perl scripts to load data dumps from legacy ERP/CRM, and migrated MS SQL DBs, FoxPro DBs to Oracle 10g.
Implemented several Oracle packages for customer orders, backlog, shipments, moving and non-moving products, shortages, product cycles/forecast, and business units KPIs.
Planned, designed, developed, tested, deployed, and maintained a dedicated global BI/Analytics data mart, COGNOS OLAP structures. I developed a C# desktop tool to enable OM and FM teams to run ad hoc queries against the BI data mart.
I received the "Most Talented Employee" award while working within the Nortel IT organization in 1999.
Technical Instructor
Executrain of Nashville
Nashville, TN
01.1996 - 05.1997
Instructor-led, hands-on training in Visual Basic, Visual Basic for Applications (VBA), and beginners / advanced classes in a wide range of Microsoft products.
I received the Instructor of the Month award twice during my work at the company.
Education
Master of Applied Mathematics -
Middle Tennessee State University
Murfreesboro, TN
12.2014
Masters of Computer Science -
Middle Tennessee State University
Murfreesboro, TN
12.1997
Bachelor of Mathematics -
Bethlehem University
Bethlehem, Palestine
12.1990
INTERESTS
My primary interest is focused on the free boundary problems and their application in American options valuation in multi-state regime switching economies, jump diffusion models, high order exponential time differencing (ETD) schemes, with penalty/Linear complimentary constraining methods
