Home

Chandresh - Data Integration | Data Engineer | Data Visualization

[email protected]

Location: Remote, Remote, USA

Relocation: No

Visa: GC EAD

CHAND Corp to Corp only Team Lead | Developer Cell: 817-678-0872 Senior Health Care Data Analyst Email: [email protected] Data Integration | Data Engineer | Data Visualization Experienced professional with over 13 years of demonstrated expertise in Business Intelligence (BI), AWS, Collibra (DQ, DG), Healthcare Data Analyst / Tableau Visualization, ETL processes, SQL, Redshift and Oracle technologies. Proven track record of successfully executing full life cycle BI implementation projects, specializing in BI tool selection, meticulous requirements gathering, comprehensive analysis, and innovative design and development of DW/STAGE/BM/DM & Visualization tools. Known for unwavering diligence, responsibility, rapid adaptability, effective team leadership, strong work ethic, and meticulous attention to detail. Possesses exceptional written and verbal communication skills. Skills Analytics: SAP BI 4.2, Tableau (2023), Power-BI. Reporting - WEBI Reports, SSRS, Tableau Reports. ETL - SAP Data Services (SAP BODS), SQL Server Integration Services (SSIS), AWS (Glue). Data Quality/Validation Collibra DQ (Data Quality), SQL Script(s), Oracle Script(s), AWS Athena. Database SQL (SSMS), ORACLE (TOAD/ODBC), RedShift (AWS), MySQL (WORKBENCH). Lead/Management JIRA, Confluence, Service-NOW, OKTA, One Note. Applications 3M, Siemens (PA & PM), Clinical HCI (McK), STAR (ADT), CV (Chart Viewer), Patient Volume Tracker/Account Tracker. Education Master s in computer science / University of Bridgeport CT, USA Bachelor s in computer science / Gujarat University India Certification Certified in AWS Cloud Practitioner Experience JAN 2016 PRESENT Envision Healthcare Corp. / Parsippany, NJ Role: Team Lead | Developer | Data Analyst. EHC is a multispecialty medical group and healthcare management team providing anesthesiology, emergency medicine, hospital medicine, radiology, surgical services, and women s and children s health services, with more than 40,000 Physicians, across 1800 clinical departments in healthcare facilities in 45 States and the District of Columbia. As a Team Lead, responsible to meet/decide with Manager/Users to gather Requirement/Changes and discuss impact/result on system/DWH. Analyze the upcoming new data from new/existing client and generate the ETL Process, reporting for validation, reconciliation, clinical operations, scheduling, billing progress measures, to see if any changes require from client/provide data quality-measurement report. Responsibilities: Interacted with the Sites/Clients/Business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data strategy resulting in both operational and analytical reporting. Also, as a Key member of EDF project to move data from On-premises to AWS Cloud for NE group. Using Various sources (Flat files, MDM HL7 messages, CSV files, SQL scripts), create an ETL processes(for various EMR source systems) to load (into Stage, Business Model , Data Mart and Chart Viewer), ADT HL7(Patient Registration), Clinical Data (Clinical Tracking, Physician Notes, Physician Documentations), Finance(Hyperion Financial, Budgets; Forecast; Actuals), Clinical Credentials System (Clinical Providers , Staff), Shifts (Providers schedules, Hours worked/Scheduled), Billing ( Data Reconciliation, RTI Billing, Volume Tracker, Account Tracker, Link Invoices at the Visits/patient level), Patient Volume, data into SQL & ORACLE (Target servers) databases. Create multiple SSIS ETL (.DTSX) processes, to look for any XREF (cross references values, from External or Internal Billing/Clinical System) from any of the sources, which are not in Target Or need to be in Target prior to loading sources data, to prevent ETL process failure, by using Conditional Split, Data Conversion, Derived Columns, Lookups, Merge, Merge Join, Multi cast, Union All, SQL tasks, Script task, Fuzzy lookup, send email and Sort, to perform/data analysis, Containers, like For Each, For Loop, Sequence, which can be used for multiple sites at one-time data load. Schedule ETL JOBs to load multiples sites with an Automation process, and set-up and email alerts, when/if ETL process failed/warning due to some reason. Troubleshoot/Resolve an ETL process failure while loading source data, why it happened /how it can be avoid going forward, document each error/log, to keep track of ETL process/performance. Create custom SQL (to validate/analyze) scripts on Patients Clinical data (involves ADT, Chart, Physician Notes) to do an analysis, on Daily Operational reports, Productivity Reports, Discharge Summary Reports. Created AWS GLUE Job, including Lambda function to triggers any new files/data from SQL gets into S3 Bucket, so that crawler can scan/insert the new data into existing/new tables. Created Collibra s DQ (Data Quality) jobs to monitor Data Qualities from multiple Sources on daily basis, including setting up an Alerts/Rules/Find Dups/Nulls/Notifications from Collibra to Email, to notify Team. Imported an Assets into Collibra s DG (Data Governance) from Power-BI/Tableau, make it visible to an Executive team to visible for knowledge/changes as per request. Review/Recon. /Validate Billing (Billed & Pending) data, by writing SQL codes or creating a SAP WEBI Reports, to do an analysis on linking the patients/visits at an Invoice level, to validate to make sure all patients are getting linked, if any new Demographics codes, ICDs, CPTs, E&M, Cash, Charges, Procedure, Insurances codes needs to be added, and use these custom SQL script to create WEBI reports. Using SQL Views/Tables/Stored Procedure to read Physician/Clinical Notes and separate signatures/timings to do an analysis on Quality/Compare with Billed/coded, at patient level/by who. Created a Tableau Dashboards/Story, to monitor daily data load activity at the site level, Provider Productivities, Hours worked at site level, Patient Volume, Missing Signatures activity, authorized person singing, and billing/financial data. Also, set-up and ranking, alerts, sub-reports, footer, headers, groups, Links, Charts, and maintain company standard format for all reports, using report functions and schedule reports as per requirement basis, to send via Email or directly into Printers. Create Deployments/Tickets/Documentations using JIRA/Confluence and use JIRA Tickets to assign/view progress of the deployment, to schedule new ETL process or any SQL codes needs to be executed in Production environment, after testing into QA/UAT environment. Promoted from BI/ETL Developer to BI/ETL Team Lead. Guiding and ensuring delivering of timely and successful projects and task to meet Bussing needs. Report weekly & shows progress to Manger, to discuss, upcoming changes/ challenges to make them aware of team progress, to avoid any delay to client deliveries. Environment: SAP Business Object 4.x/ Web Intelligence Rich Client (WEBI), SSIS ( 21), SQL, ORACLE, SSMS (2021), RedShift (DBeaver, 22.2), JIRA, ServiceNOW, Confluence, OKTA, AWS S3/GLUE/Athena/Lambda, Collibra ( 23.05), Tableau ( 22.2136). APR 2013 JAN 2016 Englewood Hospital & Medical Center / Englewood, NJ Role: Team Lead | Developer | Data Analyst. For the project of ICD9 to ICD10 remediation on any reports or data extracts that will be impacted the ICD codes changes. Also, a lead role in creating Universe, Reports/Data Extracts using SAP Business Object 4.1 Information Design Tool (for Universe) and Webi Rich Client (for Reports) and using SQL & ORALCE custom command to create a Crystal Reports. Created a dashboard to shows daily patients flow activity from one system to another system and, created a dashboard to reflect the Financial Information. Responsibilities: Gathering user requirements and analyze the ICD 9 Coding Reports/Data Extract and convert then to ICD 10 Codes (tested in Test environment) and Prepare Work Bench Structure (WBS). Modified exiting Universe (UDT) and implemented new Universes (IDT) according to the reporting needs, by creating LOVs, detecting Cardinalities, Resolving Traps (Chasm, Fan) and using Contexts, also developed Hierarchies and Derived Tables. Worked extensively with @function (i.e., @select, @prompt, @where, @aggregate aware) to create Universe Objects (Dimension, Measure or Details). And create a WEBI (Web Intelligence) using Universe as of source and Crystal Reports using Universes and custom PL/SQL (SQL, ORALCE) Command. Created a Complex WEBI reports with multiple queries, custom SQL, using complex function, merging dimensions at report level, drill down, drill up, drill across, complex filter etc. Also, scheduled them on Info view/CMC to run on frequent basis, based on the requirements. Also create Sub reports called/linked from the main report to implement logic by using Crystal Reports. Created On-Demand/Complex reports with Cascading parameters, Formulas, Grouping, cross tabs, charts (Bar Chart, Line, Pie, Stacked), Cascading Parameter, Cascading LOV s using Crystal Reports with the source of Universes as well as Custom PL/SQL command (SQL, ORALCE). Created a Dashboard to reflect the patient s flow from one system to another and show In-Details Charge/Payment/Adjustments information on patient level using Tableau. Created a Sequence Container, Control Flow, Data Flow, Script Component, Email Task, For Loop, For Each Loop, Fuzzy Lookup, Variables, Data Conversion, Derived Columns, Merge Join, Multitask, Flat files Destination (with different Delimited), Excel Destination and OLE DB Destination in SSIS (SQL Server Integration Services) packages using multiple Data source, and generate reports and setup scheduling email/scheduling to send the output file to user based on the requirement. Worked on SQL/Stored Procedures/ Views Querying, Tuning and Optimization of reports custom command in SQL and ORALCE. Environment: SAP Business Object 4.1/4.0, SAP Crystal Reports 2013/2011, SQL Server 2012/2008, SQL Server Integration Services 2012/2008(SSIS), Oracle 11g, Toad, TERADATA, Xcelsius, Web Intelligence Rich Client. JAN 2012 MAR 2013 Comerica Bank / Livonia, MI Role: Developer | Data Analyst. Responsible for creating the Universes (using BO 3.2) and Reports (using WEBI & Crystal Reports), also scheduling the reports based on the requirement for Credit/Debit/Claim/Loan Department. Created on-demand reports that reflect the real-time transaction activity. Created reports using cascading LOV s. Environment: Business Objects 4.0(IDT), Crystal Reports XI 2011, Xcelsius, Info view, CMC, SQL Server 2008, T-SQL, Oracle PL/SQL. JAN 2011 DEC 2011 Central Grocers Inc. / Joliet, IL Role: Developer | Data Analyst. Responsible for creating Universes to track the items (Delivered, Damaged, In Stock, Out of Stock) on daily basis by different category, and responsible for creating a report that reflect financial information based on the item s category. Environment: Crystal Reports 2008, CMC, SQL Server 2008, T-SQL, Oracle PL/SQL. Keywords: quality analyst business intelligence sthree database information technology procedural language Connecticut Illinois Michigan Nebraska New Jersey Pennsylvania