Technical skill
Database Skills:
 Designing database structures and tables
 Query tuning and optimization
 Developing functions, views, and stored procedures
 Relation Database Management
 SQL Server 2014/2016/2017/2019
 NoSQL (Redis)

Data Warehousing skills
 Data Modeling (Conceptual, Logical and Physical)
 Dimension Modeling
 Data Modeling Using ER Studio
 Datawarehouse/DataMart Operations
 Master Data Management (MDM)

ETL Skills
 ETL/Data Lineage Architecture and Mapping
 Data Cleansing and Validation
 Audit/Meta Process
 SSIS, Azure Data Factory, Azure Data Flow

Reporting Skill
 SSRS, Crystal Report, SAP BO
 Precision BI
 Power BI Dashboard/Reports

Python Skill
 Data Engineering with Python (Panda, NumPy, SciPy, Scikit, Matplotlib, seaborn)

Cloud Skills
 Microsoft Azure
 Azure Blob Storage, Azure Data Lake
 Azure synapse analytics
 Directus.io

Scripting Languages
 .Net (C#, MVC API), Node.Js, HL7, Unix shell scripting

Experience, Roles and Responsibilities
Role: (Data Warehouse Engineer/Data Engineer) (20-Apr-2021 to 30-june-2022)
 Work with Business Users and Managers to understand the business needs and Design
the Data Model to fulfill the needs.
 Managing Project estimations for analytics.
 Modeling Datawarehouse/Data mart, Data Lineage using ER studio.
 Architecting the optimal Model and ETL Solution to extract and load the data from different source system to EDW. Establish and enforce technical standards for deliverables of projects.
 Lead Data warehousing and ETL team Member to achieve deliverable standards.
 Development of embedded power BI dashboard and paginated reports.

Role: (MS Systems Analyst)(6-March - 2017 to 19-Apr-2021)
 Work collaboratively, train and lead geographically distributed teams across India and US.
 Architecture/Modeling design of database/Warehouse/Datamart to support complex healthcare BI Reports and dashboards.
 Development, Deployment, and maintenance ETL pipelines using ADF/SSIS.
 Creating dashboard and reports using PowerBI and SSRS.
 Writing complex queries to support one of Top 10 EMRs in US market.
 Codes, tests, debugs, implements, and documents programs or technical configuration using C#, .NET, SQL, SSIS, SSRS, SAPBO and Precision BI.
 Involved in predictive analysis (Feature selection, Model development, training, and deployment) in SQL server

 Role: (Developer) (23-July 2015 to 24-feb 2017)
 Developing Node.js, SQL (SSRS), No SQL scripts for the real-time communication and Rule-Engine modules. Developing Asp.Net and report (SSRS) modules for Etech’s indigenous product ICE.
 SQL development using stored procedure, views, Indexed views (Materialized View) , Indexes, Triggers, Functions
 R&D of the potential features of product and L2 support Professional Certificates
 AZ-900 Azure fundamental, DA - 900 Azure Data Fundamental
 Microsoft Certified: Azure Data Engineer Associate
 MSCD APP Builder (Microsoft Certification)