Senior Database Engineer

Ranjit Singh DATABASE ENGINEER **********@*******.***

EPIC CERTIFIED 916-***-****

Nationality:

US Citizen

KEY SKILLS AND EXPERTISE

Over 20 years of IT experience in System Analysis, Design, Development and Testing in Software Development.

Over 15 years of work experience in Health domain with well-versed knowledge in medical coding concepts but not limited to ICD-9, ICD-10, CPT, HCPCS, DRGs, Inpatient, Outpatient, CLAIMS, LDA and IP Flowsheets, Pharmacy (MED), HNO Notes and FINANCIAL etc.

Over 10 years of Database Administration experience and knowledge of all facts of Database design, Backup, Restore, Maintenance plan, Disk Space, Data Replication, Production support, User Provision, and Creating & Monitoring SQL agent jobs.

Involves in gathering business requirements that will facilitate the planning and the implementation phase of the data warehouse.

Extensive experience of Data warehousing with Microsoft SQL Server, SSIS, SSRS, Microsoft PowerBI, SSAS, OLTP and OLAP.

Advanced knowledge of SSMS including but not limited to Stored Procedures, Functions, Views, Triggers, DMV’s, SQL Agent Jobs, LOCKs, Transactions etc.

Involves driving the solution approach to data schema development, business rules, data design and migration processes for the team. Also provide standards, guidelines, processes, and expertise to consistently address recurring data issues including data convergence, data standards and data synchronization.

Well versed knowledge of issues troubleshooting, finding the root causes of issues, and fixing those with minimal documentation.

Expert in Performance Tuning by analyzing Index Fragmentation, execution plans and finding missing indexes.

Mastery over the ‘ETL process’ with many years of experience in extraction of the data from various source systems ranging from Oracle, Informix, SQL Server, Flat files, JSON Format to RDBMS like Oracle and Teradata.

Excellent experience in designing and writing complex SQL code and working with tables, Stored Procedures, User Defined Functions, and Indexes according to the business requirements.

Experience in Data Modeling, Multi-Dimensional data modeling and involved in creation of Star Schema and Snowflake dimensional Schema using ERWIN and VISIO Tool.

Experience in creating efficient ETL Strategy for initial load into the databases as well as incremental load, handling errors in SSIS Packages using Event-handlers, Loggings, Configurations, Transactions and Checkpoints.

Self-motivated, detail-oriented, excellent, and quick problem solver, analytical skills, and quick learner.

Well versed knowledge of Hospital and Professional billing concepts.

Extensively worked on profiling data from various Healthcare Source systems and Financial Systems.

Managed Package Configurations to efficiently deploy ETL Packages from Test Development Environment to Production Environment.

Used AWS and AZURE cloud solutions for data storage and S3 bucket for file sharing.

Responsible to replicate data from On-premises to Cloud solution and Cloud to Cloud solution using third-party tools but not limited to CloudBasix, HVR, DMS etc. Location:

Sacramento, CA (not open to relocation)

LinkedIn:

https://www.linkedin.com/in/ranjitkhattra

Skills:

Advance knowledge of SSMS (T-SQL)

Advance knowledge of SSIS

Database Administration (DBA)

Data Replication (CloudBasix, HVR, DMS)

Production Support and Monitoring Jobs

Production Release, Testing and Support

Database Tuning and Query Optimization

Troubleshooting (Problem Solving)

Analytic Tools (PowerBI, SSRS)

Data Warehousing

Data Modeling Tools (Visio, Erwin)

Inmon and Kimball Methodology

Data Modeling (Star and Snowflake Schema)

Agile and Scrum Methodology

Cloud Solutions (AZURE and AWS)

Epic Clarity Data Models

Version control (GitHub and TFS)

Oracle, MySQL, PostgreSQL

ETL Strategy for Initial and Full Load EDUCATION

Bachelor of Technology in computer Science and Engineering (2006). Communication, Team Player

CERTIFICATION

Informatica Epic Certified in Cogito, Caboodle Data Model, Clarity Data Model, Revenue Data Model, Caboodle Development, Clinical Data Model.

PROFESSIONAL WORK HISTORY

Valley Children Hospital (HEALTH DOMAIN) May 5, 2021 – CURRENT Senior Cloud Database Engineer / Administrator 9300 Valley Children's Pl, Madera, CA Valley Children’s Healthcare – one of the largest pediatric healthcare networks in the nation – provides Central California’s only high-quality, comprehensive care exclusively for children, from before birth to young adulthood. With more than 640 physicians and 3,500 staff, Valley Children’s delivers high-quality, comprehensive care to more than 1.3 million children. PROJECT DESCRIPTION: -

Provides day-to-day support and guidance in handling the daily schedule of department production jobs, release changes to TST and PRD.

Using AWS cloud solution to store Datawarehouse, and S3 bucket for file sharing.

Responsible to replicate data from On-premises to Cloud solution using third-party tools but not limited to CloudBasix, HVR, DMS etc.

Technically stable with data dictionary, data security and application database environments through appropriate monitoring/control.

Effective management support through the timely response to management staff problems and needs.

Optimized lot of legacy process with minimal documentation and promoted which were required for new DW.

Create custom logic / followed business rules using advance programming in T-SQL including Stored Procedures, Views, Functions etc.

This project involved design, development, and deployment of business intelligence solutions using SSMS for data storage and TSQL programming SSIS, IBM Infosphere DataStage for ETL and SSRS, PowerBI for presentation layer.

Extracting data from different Health care systems for Patient Care, Care Provider, Appointment scheduling, Revenue systems, Clinical systems and Financial Systems etc. which run on heterogeneous systems like but not limited to EPIC-CLARITY, EPSI etc. to SQL Server and Oracle for custom registries/data marts and data warehouse.

Currently working on InBasket project where I am responsible to create brand new data mart including the design of tables, complex stored procedure including all the business rules, View(s) to return final useful outcome of data and their relationship to each other.

Also responsible to create solutions using programming in advanced T-SQL for custom requests and supplied reports in PowerBI and SSRS including but not limited to Provider Productivity Report, Pressure Injury Report, Sedation Details Report, Peripheral IV Report, Cather Report, COVID 19 reports, Nurses Productivity Report, Pharmacy dashboard, Med Order Scan dashboard etc.

Manage and maintain overall health and performance of all SQL Server environments throughout the organization. Identify queries bloating cache causing performance degradation and create SQL guide plans and indexes to resolve those.

Provide AWS cloud migrations, managed services and database administration / monitoring services.

Developed NodeJs apps/processes to replicate MSSQL to MySQL databases (Innodb storage engine)

Developed processes to bulk-copy data into Snowflake via nodejs.

Monitored Postgresql Aurora performance utilizing pg_stat_activity.

Defined cloud growth models, estimates, and usage predictions.

Researched, analyzed, documented, and summarized cloud provider offerings and technologies.

Extensively using RedGate tools for DBA support, finding the gaps during release cycles.

Use GitHub for version control and code release. UCD MEDICAL CENTER (HEALTH SYSTEM) AUGUST 4, 2014 – May 2, 2021 Senior Cloud Database Engineer / Administrator 1651 Alhambra Blvd, Sacramento CA UC Davis Medical Center is a nationally recognized academic medical center offering primary care for all ages, specialty care in 150 fields, and the latest treatment options and expertise for the most complex health conditions. Some highlights about UCD:

* Nationally ranked in multiple specialties * Rated Sacramento’s top hospital

* Home of nationally ranked children’s hospital * Patient-centered primary care model PROJECT DESCRIPTION: -

Responsible for supporting TST and PRD Servers, monitoring jobs, user provisioning, troubleshooting issues, promoting code.

This project involved design, development, and deployment of business intelligence solutions using SSMS for data storage and TSQL programming Informatica and SSIS for ETL and Business Objects and Tableau for presentation layer.

Used AWS and AZURE cloud solution to support data storage, and S3 bucket for file sharing.

Replicated data from On-premises to Cloud solution using third-party tools but not limited to CloudBasix, HVR, DMS etc.

Created custom logic / followed business rules using advance programming in T-SQL including Stored Procedures, Views, Functions etc.

Optimized lot of underperforming process with minimal documentation and promoted based on approval.

Extracting data from different Health care systems for Patient care, Care Provider, Appointment scheduling, Revenue systems, Clinical systems and Financial Systems etc. which run on heterogeneous systems like but not limited to EPIC-CLARITY, EPSI, Tele-Tracking, United Health Care, Press Ganey, LAWSON, MSOW, McKesson, Call Centers, Anthem, CIGNA, Western Health Advantage, Blue Shield, Health- Net, LIS, OPTUM-P4P, OPTUM-ONE etc.

Primarily worked to create and maintain custom Registries/Data marts/Data Warehouse but not limited to Diabetes, Sepsis core Measure, Transfusion, Patient-Centered Medical Home, Accountable Care Organization Population, Tethered Meta Registry, PRIME, Stork, Hip Fracture, ED Imaging, Surgery, process CLAIMs data to support pay for Performance and report to Payer’s/IHA.

Worked closely with OPTUM team to provide them with all the Medical CLAIMS data but not limited to Managed Care Claims (Professional as well as Institutional) and Indemnity Claims (Professional as well as Institutional).

Supported OPTUM project by exporting all the NPI data provided by NPPES, Members data, Pharmacy data, Lab data from QUEST, CLAIMs data as well as Providers data.

Troubleshoot security group connectivity issues.

Designed physical database and recommended optimizations of existing databases.

Managed a 24 TB database performance covering tables with 4 billion records.

Extensively use RedGate tools for DBA support, MySQL, Aurora PostGres SQL, GitHub for version control and code release. STANFORD MEDICAL CENTER (HEALTH SYSTEM) OCTOBER 7, 2013 – AUGUST 1, 2014 Lead Data Integration Engineer and Data Warehouse, ETL Administrator 1830 Embarcadero Rd, Palo Alto CA Stanford Hospital & Clinics, with multiple facilities throughout the Bay Area, is internationally renowned for leading edge and coordinated care in cancer care, neurosciences, cardiovascular medicine, surgery, organ transplant, medicine specialties, and primary care. PROJECT DESCRIPTION: -

I was leading a team of 5 other ETL developers including offshore team members.

Responsible for supporting TST and PRD Servers, monitoring jobs, user provisioning, troubleshooting issues, promoting code.

Created custom logic / followed business rules using advance programming in T-SQL including Stored Procedures, Views, Functions etc.

This project involved design, development, and deployment of business intelligence solutions using SSMS for data storage and TSQL programming, Informatica and SSIS for ETL and Business Objects for presentation layer.

Optimized lot of underperforming process with minimal documentation and promoted based on approval.

Extracted data from different Health care systems for Patient care, Care Provider, Appointment scheduling, Revenue systems, Clinical systems and Financial Systems etc. which run on heterogeneous systems like but not limited to EPIC-CLARITY, EPSI, Tele-Tracking, UHC, Press Ganey, LAWSON, MSOW, McKesson, Call Centers.

Built out an EDW (Enterprise Data Warehouse) with clinical and financial data sourced primarily from EPIC EMR. The EDW enables clinicians and managers to analyze operational performance and patient-care outcomes against defined metrics.

Worked closely with vendors, customers, and offshore resources to build source marts and subject area marts from which clinical and operational dashboards (Qlikview), reports (Business Objects, SSRS, Crystal) and other visualizations are produced.

Managed Package Configurations to efficiently deploy ETL Packages from Test Development Environment to Production Environment.

Actively supported business users for change requests.

Participated in coding, testing, implementing, debugging and documenting ETL development using Informatica.

Worked on multiple projects as project team member. Consulted with Application users for needs assessment.

Assisted in the business process redesign and documentation as needed.

Translated high level business requirements into functional specifications.

Worked with the team on System Performance optimization issues.

Used GitHub for version control and code release. CITY OF HOPE (HEALTH SYSTEM) DEC 19, 2012 – OCTOBER 2, 2013 Lead Data Warehouse Architect and Administrator 800 Royal Oaks Dr, Monrovia CA City of Hope is one of only 41 National Cancer Institute-designated Comprehensive Cancer Centers nationwide and a founding member of the National Comprehensive Cancer Network. An independent biomedical research, treatment and education institution, City of Hope is a leader in the fight to conquer cancer, diabetes, HIV/AIDS and other life-threatening diseases. PROJECT DESCRIPTION: -

Lead 3 other ETL developers, this project involved design, development, and deployment of business intelligence solutions using SSMS for data storage and TSQL programming, SSIS for ETL and Business Objects for presentation layer.

Extracted data from different Health care systems for Patient care, Care Provider, Appointment scheduling, Revenue systems, Clinical systems and Financial Systems etc. which run on heterogeneous systems like but not limited to SIS, SER, EPSI, Tele-Tracking, UHC, Press Ganey, PULSE, LAWSON, MSOW.

Worked on creating new Data Warehouse from Scratch according to the user requirements which involved creating new data model, ETLs and creation of different types of reports.

Involved in tuning SQL queries, optimization of ETL packages and reports.

Provide Production Support of the entire EDW (Enterprise Data Warehouse).

Responsible for Deployments, Migrations, Deployment Groups, Operational activities, resolving daily ETL job issues.

Responsible for User Security, Repository backups, Application upgrades, service packs and installations.

Plan and oversee the transitions between developments, testing and production phases.

Work with Offshore Team to manage the daily Operations, Development and Migrations.

Extensively used TFS and Visual Source Safe for version control. CONSULTANT Senior Database Engineer/Administrator

CCS GLOBAL TECH – SAN DIEGO, CA JULY 18, 2011 – DEC 14, 2012 SUN TECHNOLOGIES – INDIA JUNE 14, 2006 – JUNE 10, 2011 SNO. WORKING SYSTEM DESCRIPTION

1. HEALTH SYSTEM

Worked on transforming the data about medication errors and healthcare-associated infections (HAIs). The project involved modifying existing data warehouse, ETLs and creation of different types of reports for medication safety Systems. Involved in tuning SQL queries, optimization of ETL packages and reports. 2. INSURANCE SYSTEM

The main objective of the project was to add new types of loans like wedding loan, large purchase loan, vacation loan etc. and also maintains the data warehouse with various analysis. Created several SPs, functions and updated SSIS packages to transfer the data according to the business requirement. 3. HEALTH SYSTEM

This project involves Patient Screening and Surveillance of Veteran patients. Based on the requirements and filter conditions, reports have been generated to screen patients diagnosed with different types of symptoms based on various medical codes and charges codes (ICD9 codes, CPT codes, CDM Codes). 4. BANKING SYSTEM

Projects initiated in creating multiple complex Stored Procedures to support the front-end applications along with creation of efficient ETL strategy to grab data coming in from different heterogeneous sources, perform various data operations and dump it into Data Warehouse and Data Mart according to the business requirements. One of the major scopes of the project was also to create SSRS reports from DW and SSAS Cubes for better analysis and making business decisions purposes.

Contact this candidate