Created 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 eligibilityo Utilize Johns Hopkins ACG system to populate output tables of predictive healthcare costso Combine data from multiple sources and aggregates to populate reporting tablesAutomate file downloads and processing into SQL Server 2014 (& 2017 later) using SSISSet 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 dashboardsBackup / Restore databasesCreated 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 tasksEnhance the design of the data warehouse to accommodate the changes in a large new client’s requirementsTrain 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)

- 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

- 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

- 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