Joshua Allen

• Achievements:
• • Promoted to Advisor and led a small team of developers contributing to various projects over a period of 2+ years.
• Project contributions include:
• • Built a Data Engineering pipeline supporting client dashboards for Enterprise Operations (EOA). Worked with IT teams to setup Kafka consumer\producer for Claims data. Stack: Kafka > Python (Pandas, SQL Alchemy) > Oracle > Tableau. Deployed through Jenkins CI\CD. Scheduling and automation using Direct Connect and Unix server for file transfers..
• • Contact Center Data Product: Multiple, stable contributions to Databricks production codebase via Github Actions CI/CD pipeline. Stack: SQL Server > Apache Spark JDBC + Terraform > Databricks Rawzone.
• • Contact Center Data Product: Facilitated implementing Collibra data quality & observability via cross department, director-level coordination.
• • Acted as liaison between Operations and IT for adoption of proprietary AI tool "SQL Co-pilot".
• • Facilitated implementing Alation data governance platform for Enterprise Operations (EOA) via cross-department coordination and vendor support.
• Responsibilities:
• • Spearhead new working partnership with IT Engineers and Enterprise Operations. High visibility.
• • Lead small team of developers contributing to project-based work.
• • Explore industry leading Data Engineering & AI tools and onboard\train others.
• • Act as liaison between IT and Operations for special projects.
• • Adhere to SAFe 4 Agile Methodologies.
• • Assign and track project work on Jira boards.

Achievements:
Call Transfer Dashboard, US Medical
• Worked with stakeholders and call center project managers through 2022 to develop an SSIS Package for call transfer root-cause analysis under Cigna's US Medical portfolio.
• The package uses 10 data sources to create a rolling 12-month master table, refreshed daily, which is then ingested by Tableau. The presentation layer dashboard has 50 users per month, and 325 views on average.
• By November 2022 stakeholders had identified $3.2M in OPEX savings through analysis using the dashboard.

Responsibilities:

• Build ETL pipelines using Informatica Powercenter that feed into a large Oracle enterprise data warehouse. Job config files and misc. Runtime storage maintained on Unix servers.

• Create datasets for analysis by gathering and translating requirements into complex, multi-step queries.

• Work closely with DBA team to audit data integrity and tune database performance.

• Work closely with Tableau developers during UI design processes.

• Support analytics and data science teams by providing large datasets and subject matter expertise for claims, provider, membership, and client data.

• Present data to large audiences and upper management.

• Maintain data dictionary for enterprise-wide use.

Achievements:

• Established daily inventory and production metrics for Team of 50+ . The reporting used 13 data sources via Oracle, SQL server, Excel, & XML.

• Provided day-to-day visibility into 13 group mailboxes with 1300 working folders used by team of 50+.

• Fully automated 6 reports and 3 emails with inline charts and attachments used by Call Center management in EU region. 30 manual hours per month of work effort reduction.

• Created 15+ Cognos reports supporting daily ETL extraction for multiple dashboards, QA analysis for off shore teams, provider reconciliation, and Weekly\Monthly reporting for claims production.

Responsibilities:

• Build data analytic dashboards and reports supporting multiple business units.

• Gather and analyze project requirements assessing scope and complexity.

• Design and train staff on sustainable BI solutions ranging from simple to very complex.

• Write and maintain technical documentation for developers and users.

• Root cause analysis for outliers and deviations from data trends.

• Collaborate with IT and business partners to ensure are feasible relative to the business needs.

• Maintain daily\weekly\monthly legacy reporting such as scheduled automations using MS Access, MS Excel, Qlikview COM API, Cognos 10.

• Develop and improve automated jobs which extract and prepare data for transformation layers.

• Provide subject matter expertise for QA, Claims, Premium, and Clinical data and business processes.

Achievements:

• Created dashboard providing Claims QA trending at Client, Analyst, and Manager level with raw data extract feature for 200+ FTE's.

• Created dashboard providing Contact Center QA trending at Client, Analyst, and Manager level with raw data extract feature for 100+ FTE's

• Developed balance scorecard, inventory snapshots, and time series performance for 200+ FTE's. Architected ETL process which warehouses 15 millions records per year from 8 data sources. Reduced time-to-insight from several hours to minutes.

• Developed Dashboard merging two workstreams into one, establishing age and turnaround time measurements.

• Built Cognos reports for trending and detail drill-through for claim adjustments, rework, and overwork on a monthly basis.

• Converted 5 reports from MS Access VBA to scheduled Cognos jobs improving reliability and reducing maintenance costs.

Responsibilities:

• Determining scope of each request and prioritizing with existing work.

• Translating requirements into tangible objectives.

• Develop self-serve solutions around ad-hoc reporting trends.

• Provide value-added insights with each release of BI’s recurring deliverable reports.

• Provide SME support for QA data, Claims data, and granular business processes.

• Creating/designing Qlikview Dashboards for production or as internal utilities.

• Deploying and publishing QlikView applications on server in partnership with IT.

• Maintain legacy reporting infrastructure consisting of scheduled MS Access automations, Cognos reports, and daily/weekly/monthly deliverable reporting.

Achievements:

• Automated manual intake gatekeeping process by establishing queue's, turnaround time and age of requests via a custom taging system. Reduced manual work effort from 60 hours per month to 10 hours per month.

• Developed client-side, adhoc dashboards for a 3-day workshop to improve claims processing insights for 200+ FTE's across multiple sites.

Responsibilities:

• Build data analytic dashboards and reports supporting multiple business units.

• Perform key reporting functions (routine and ad-hoc).

• Support data consolidation and automation activities to support global management reporting and analytics.

• Root cause analysis and corrective action planning.

• Day to day operational analytics to both managerial and front line partners.

Responsibilities:

• Coach team of auditors on processes and performance.

• Perform and continue to develop “Audit-the-Auditor” program.

• Participate in projects and manage multiple deadlines in a complex business unit.

• Identify process gaps in CSR work instructions and partner with Contact Center to address.

Responsibilities:

• Assist customers and healthcare providers with complex benefit cases over the phone.

• Reduce Open-call Inventory.

• Meet performance metrics such AHT, After-Call, Adherence, and Quality.