Jagadish Chigurupati
Hyderabad
Summary
Accomplished Data Analytics Engineer with 9+ years of experience in the field. Specialized in Data Analytics, Business Intelligence, and Data Engineering, successfully working across diverse industries like Healthcare, Distributor Shipment, and Retail. Proficient in utilizing advanced technologies such as Snowflake, Azure SQL, and Power BI. Excels in designing Data Warehouses, Data Modeling, and fulfilling Reporting requirements. Adept at developing data-driven strategies and collaborating with cross-functional teams. Strong analytical skills deliver valuable insights for business growth.
Overview
10
10
years of professional experience
Work History
Principal Data Analytics Engineer
Providence Global Center
07.2020 - Current
- Designed and implemented Registry Management Systems(RMS) and BI platform, low code solution for workflows of various registries such as Stroke, Heart Failure, Cardiovascular diseases. Leveraged metadata driven architecture to automate and manage new fields and transformations without any ELT tools, enhancing efficiency and consistency for database agnostics which helped in saving more than 35 hours/week for each Registered Nurse and 50% development efforts.
- Design Data Model for 160+ tables and create Centralized Data Sets, Power BI semantic models and reduce the maintenance of more than 200+ hours/month.
- Develop Power BI semantic models and enhance performance and better user experience and connecting to various environments, working with semi-additive measures and performance tuning, dynamics report changes.
- Create data pipelines, row level security, object level security, dynamic data masking objects in Snowflake Cloud.
- Designed advanced BI reports to monitor operational efficiency, provider efficiency and patient monitoring.
- Convert complex legacy code written in form of stored procedures from SQL Server, Oracle to Snowflake Cloud.
- Convert SSIS packages from SQL Server to Snowflake compatible.
- Extract additional data from SQL Server, Dynamics 365, Oracle to Snowflake, Azure SQL using Azure Data Factory.
- Perform ETL operations through Snowflake stored procedures and scheduling in Control-M for connecting various sources across multiple platforms.
- Served as subject matter expert in areas such as Data Warehousing, Data Modelling and Business Intelligence.
- Developed deep expertise in HIPAA compliance, provider systems, Electronics Health Records(EHR), HFM, Genesis, Revenue, Registry Management, regulatory requirements and clinical workflows.
- Designed and implemented Revenue Analytics which integrates HFM and Genesis data on hospital billing, professional billing and cash reserves at cost center level and being used by CFOs. Integrated Kodiak RCA data and provided insights on estimated and actual reserves.
- Other work include Patient Experience Analytics, Marketing Analytics and Physician Clinical Networks.
- Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments.
Senior Software Engineer
Accion Labs(previously InRhythm Solutions)
06.2015 - 07.2020
- Clients: Altria, RBH, MARS, STG, GTU, ITG
- Design and develop end to end solution for transforming data from various sources such as external files, databases and provide reporting solutions.
- Create Medallion Architecture in the databases and data warehouses and data mart.
- Utilized , Azure Data Factory and Synapse inbuilt commands to load data from various sources.
- Load data from various sources such as flat files, parquet files into data warehouse.
- Develop dashboards, visualizations through Power BI.
- Understand Master database and designing tables, developing stored procedures and views.
- Develop on complex algorithms for prediction of products. Ex: Out of Stock, Low Inventory.
- Create SSIS packages for processing of various data sources and data transformations.
- Successful migration of client data from SQL Server to Oracle DataMart.
- Refresh heterogeneous sources through Control-M.
Education
Bachelor of Technology - Electronics and Communication Engineering
St. Martins Engineering College
05-2015
Skills
- Snowflake Cloud
- Power BI
- Advanced analytics
- Data warehousing
- Azure Data Factory
- Business intelligence
- T-SQL
- Azure Synapse Analytics
- SSIS
- Control-M
- Databricks
- Python
- PL/SQL
- Azure
Languages
English
Telugu
Hindi
Personal Information
Timeline
Principal Data Analytics Engineer
Providence Global Center
07.2020 - Current
Senior Software Engineer
Accion Labs(previously InRhythm Solutions)
06.2015 - 07.2020
Bachelor of Technology - Electronics and Communication Engineering
St. Martins Engineering College
Similar Profiles
SAI DEEPTHI DUVVURISAI DEEPTHI DUVVURI
Lead Service Engineer at Providence Global CenterLead Service Engineer at Providence Global Center
Anil Kumar VanteruAnil Kumar Vanteru
Manager / Principal Architect at Providence Global CenterManager / Principal Architect at Providence Global Center
SHRAVANI SAMAVEDAMSHRAVANI SAMAVEDAM
Senior Information Security Analyst at Providence Global CenterSenior Information Security Analyst at Providence Global Center