Data Base Developer
Location : Jaipur, India,
Experience : 7 Year
Rate: $20 / Hourly
Availability : 1 Week
Work From : Any
Category : Information Technology & Services
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)
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
