Requests
3
3
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Health Cost IQDatabase & ETL Developer
Mar. 2018 - Dec. 2024Chandler, Arizona, United StatesCreated complete ETL and database systems for each client of the company:
o Analyzed data vendors’ files, map to warehouse data elements – Anthem, Express Scripts, Benelogic, Artemis, etc.
o Create SSIS projects to automate the files processing including load, transform, o Populate production o Create aggregates based on the data for medical and pharmacy Rx claims and eligibility
o Utilize Johns Hopkins ACG system to populate output tables of predictive healthcare costs
o Combine data from multiple sources and aggregates to populate reporting tables
Automate file downloads and processing into SQL Server 2014 (& 2017 later) using SSIS
Set up new clients’ databases and Johns Hopkins’ ACG (Associated Clinical Groups) processes. Create database objects – tables, views, procedures, functions, data types etc.
Create the data model for the warehouse as per clients’ specific reporting requirements. The model to be used for medical and pharmacy claims data and member eligibility. The data / aggregates to be used for healthcare predictive model analytics by company’s data scientist that design the clients’ dashboards in Tableau.
Provide support to data analysts with complex aggregations, query writing for dashboards
Backup / Restore databases
Created a database to extract a complete set of data from a client’s database and Anonymize (de-identify) and set up a demo database for the marketing team to demonstrate to potential clients. Created functions to anonymize Personal Identifiers using publicly available data. Admin tasks with PowerShell scripts ex-backup Tableau server and put on SFTP server daily basis and similar tasks
Enhance the design of the data warehouse to accommodate the changes in a large new client’s requirements
Train new employees on our system and processes, database environment. Create documentation for ETL processes for various clients for use by any new employees and / or for reference purposes...
(see resume for complete description)
Health Data IntelligenceDatabase Developer / ETL / DBA
Mar. 2017 - Oct. 2017Columbus, Ohio, United States
MAXIMUSDatabase, ETL Developer & Support
Jul. 2013 - Mar. 2017Greater Denver Area- Worked on the back-end of Provider Data Management Systems (PDMS) for multiple states
- Rewrite the CAQH data processes to improve performance and requirements changes
- Provided technical support on client submitted issues
- Developed ETL solutions to automate the data load from various government sites
- Excel VBA tool to automate data input data processing
Public Utilities Commission of OhioDatabase & ETL Developer
Jan. 2013 - Jun. 2013Columbus, Ohio Area- Design and develop ETL application to gather data from multiple sources from local sites into centralized federal systems
- Designed and developed Relational model for back-end database for user application
Sedgwick CMSConversion Specialist
Oct. 2012 - Jan. 2013Hilliard, OH- Data migration from end-clients' old systems to Sedgewick's systems
- Develop ETL to transform source data into the new system, automatically reconcile
- Created stored procedures for the validation SSRS report based on 72 validation criteria
Sharlak Technologies, LLCConsultant & Trainer
Jan. 2011Columbus metropolitan area, Ohio, United States
Intch is a Professional Networking App for the Future of WorkSee more people like Humayoon on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
38110 people
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC
33
Investor Relations Manager @ ExxonMobil