Kaiser Permanente (Apr 2017 - Present)
- Data integration solution using Enterprise ETL Tools - Informatica and Oracle PL/SQL for pharmacy GL. DevOps solutions using Python for Business Teams.
- Building operational and interactive reports for pharmacy, care delivery business and KP International.
- Automation of dynamic report generation using PL/SQL, shell scripts and custom report delivery using Tableau rest API
- Designed and built CRM forms on oracle apex for program management to the new engagement. Understand, designed back-end transaction data model and reporting solution.
- Implemented python airflow and migrated cron jobs to airflow for ease of maintenance.
- Setup intranet portal on Apache server, integrated Tableau report for real time data refresh.
- Build SharePoint cloud site and KP Wiki page for data warehouse team to manage work intake and share/integrated reports. Project tracking, code management and SOX compliance reporting using DevOps Tools.
Skill Stack: Informatica, Tableau, OBIEE, Oracle Apex, Oracle, MySQL, SAP BO, Linux, Cloud Services, JIRA, Git SCM, PLSQL, Shell, SoapUI, Apache Webserver and Python Airflow