
Reporting and Automation
Report samples
Codes and snippets of my work in Automation
01

Reporting
Script Generated
-
Allow automation of customized emails to resolve common issues
-
Compare transaction data from database and CSV and generate report
-
Generate daily report with visuals for claims not billed only
-
Generate daily report with visuals for claims without fax only
-
Generate different group by reports after cleaning and integrating data from different tables
-
Generate pending and rejected records report from database after cleaning
-
Uncover data issues in matching external vendor requirements or specifications
-
Update problematic claims status after resolving and generate new report
Presentation
-
Select Administration of Behavioral Therapy to Probationers - Presentation
-
Real Estate Descriptive and Predictive Analysis of NYC - Presentation
Written
-
Select Administration of Behavioral Therapy to Probationers - Report
-
Investigating Current Profitability, Recommendations, and Sustainability for Dropbox - Report
-
Real Estate Descriptive and Predictive Analysis of NYC - Report
-
Proposal of new business "Fleats: An Automated Drone Food Delivery Platform"
-
Recapitalization buyout for a US$ 173.3MM Middle East marine services conglomerate - Blind Teaser
02
Automation
-
Add missing ICD code descriptions through API and convert ICD-9 to ICD-10 codes
-
Allow automation of customized emails to resolve common issues
-
Check for correct billing method, bill correct claims only, and email database fixes to supervisor
-
Check payment W-9 data issues and email resolutions to employees
-
Email to specific user only.py
-
Find discrepancies between records loaded into database and customer files and email to supervisor
-
Fix State given address check sum of charges verify facility name given NPI and update database
-
Generate daily report with visuals for claims not billed only
-
Generate daily report with visuals for claims without fax numbers only
-
Store ASC X12 alerts automatically cross verify status with other tables create report and format it
-
Update pending and rejected claims progress flags and email to supervisor
-
Update problematic claims status after resolving and generate new report
