Website: https://learncloud.info/Udemy Profile: https://www.udemy.com/user/eshant-garg/Youtube: https://www.youtube.com/channel/UCMNZ-LMoWewHm-Cu74L9zUwFacebook: https://www.facebook.com/eshantgargazureI have created below courses so far:AI-900: Microsoft Azure AI Fundamentals Video Course + Queshttps://www.udemy.com/course/azure-ai-fundamentals/?referralCode=D2196B4AD419DD514E88DP-900: Microsoft Azure Data Fundamentals Video Course + Qnshttps://www.udemy.com/course/azure-dp-900/?referralCode=BAEF302C965987CB503ADP-200: Implementing an Azure Data Solution [Bestseller]https://www.udemy.com/course/dp200exam/?referralCode=F1399AA31D3FBEFD2A00DP-201: Designing an Azure Data Solution [HigestRated]https://www.udemy.com/course/azuredp201/?referralCode=E2B089FF6241FE87B46EAzure Data Engineer Technologies for Beginners [Bestseller]https://www.udemy.com/course/microsoft-azure-database-and-analytics/?referralCode=BDD4366CEFEBA9B875B7Microsoft Azure Data Lake Storage Service (Gen1 & Gen2) [Bestseller]https://www.udemy.com/course/microsoft-azure-data-lake/?referralCode=1188D1122009F1EB1D1EAzure SQL Data Warehouse Synapse Analytics Servicehttps://www.udemy.com/course/azure-sql-data-warehouse-synapse-analytics-service/?referralCode=4295C2C6E6B6055205EALearn Azure Cosmos DB basics this weekend in 3 hourhttps://www.udemy.com/course/azure-cosmosdb/?referralCode=647620FACEBD902BE889Learn Hadoop and Azure HDInsight basics this evening in 2 hrhttps://www.udemy.com/course/azurehdinsight/?referralCode=CBAB7C203201C6B1C963*** Free Courses ***Introduction to Hadoop basics in 30 minshttps://www.udemy.com/course/hadoop-concepts-for-absolute-beginners/?referralCode=8EE5B7BFBCDF5E326751Introduction to Cloud Computing for Beginners in 30 minshttps://www.udemy.com/course/cloud-computing-basics/?referralCode=97EFBF5DCF669E549530

Responsibilities • Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL [Azure Data Lake Analytics]. • Data Ingestion to one or more Azure Services – (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) • Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. • Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. • Migrated all packages from SSIS 2008 to SSIS 2014 version • Optimizing and redesigning packages as per the new data flow design • Redesigned data flow structure according to VFK business needs and introduced ODS concepts in design.

• Responsible for overall database development and performance across all 5 scrum boards.• Assist Data scientists in Power Pivot reports and SSAS Tabular.• Develops and maintains the SSIS ETL design from an enterprise perspective. Understands the complexity behind the data model and data quality to support build enterprise wide data architectures.• Write and maintain Operational and Analytical SSRS Reports• Provide inputs on HLD, and review/validate the LLD of Database modules/changes.• Evaluate current database environments, provide strategic and tactical recommendations that will meet current and future business needs.• Provide ongoing suggestions for improvement and innovation within the department.

• Develop data extractors and loaders, Manage the data conversion process and data push process to the various development/production environments.• Created many SSRS dashboard reports for Immediate management, business analysts and direct clients.• Maintaining Internal SSRS reports and SQL Scripts and Produce reports for clients and internal staff using SSRS.• Perform ad hoc queries and assists in the development of reports based in response to internal and external requests using Microsoft SQL Server and SSRS• Supports data integration and enterprise Business Intelligence initiatives and projects.• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data using SSIS.

• Provide inputs on HLD, and review/validate the LLD of DB modules.• Design, develop, enhance and optimize store procedures, triggers, functions and other database objects.• Configure domain registry for email, sms alerts and priority attributes in cheetah mail system.• Review client requirements, perform gap and impact analysis, and provide inputs in creating the detailed schedule.• Provide strategic and tactical direction in the area of database management and maintenance of enterprise data and database infrastructure.• Evaluate current database environments and make recommendations that will meet current and future business needs.• Make changes in existing SSIS packages and assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities• Assist application development teams with planning and implementing database changes as well as query/job optimization.• Proactively identify and act on opportunities to improve database systems and Processes.• Provide ongoing suggestions for improvement and innovation within the department.

• Design, Implement and maintain database schema, tables, stored procedures, UDFs, triggers, constraints, Indexes, schemas, functions, views, rules and other database objects• Monitoring, optimizing and tuning of queries and other SQL Server database objects. • Created, configured, maintained and optimized SSIS ETL packages to clean, validate, standardize and move data from DM (Data management) OLTP environment to RM (Relational management) OLAP environment.• Develops and maintains the ETL design from an enterprise perspective. Understands the complexity behind the data model and data quality to support build enterprise wide data architectures.• Develop data extractors and loaders, Manage the data conversion process and data push process to the various development/production environments.• Created many SSRS dashboard reports for Immediate management, business analysts and direct clients.• Maintaining Internal SSRS reports and SQL Scripts and Produce reports for clients and internal staff using SSRS.• Perform ad hoc queries and assists in the development of reports based in response to internal and external requests using Microsoft SQL Server and SSRS• Supports data integration and enterprise Business Intelligence initiatives and projects.• Understand the project vision and requirements, and contribute to the creation of the supplemental requirements, building the low-level technical specifications for a particular platform and/or service solution• Ensure new features are modeled to integrate with existing application and provide a consistent data model.• Provide direction on adoption of new technologies and best industry practices in the field of data architecture and modeling.• Collaborate with business analysts source system experts and other team members to determine data extraction and transformation requirements• Maintain and enhance SSAS cube ‘Fusion’ functionality by editing/adding dimensions, attributes, hierarchies and aggregations.

• Lead team of 4 people and responsible for meeting the daily SLA for all major products, also escalation point and responsible for all tasks assigned to CLCS team• Built high priority code using T-SQL and complex SQL Server systems according to the functional specifications, detailed design, maintainability, and coding and efficiency standards• Created Low-Level Design (LLD)/detailed design for the project with possible alternate solutions to meets business requirements• Work closely with internal customers analyzing problems and to design, create and maintain SSRS reports, and ad-hoc SQL scripts.• Perform quality checks on SSRS reports and exports to ensure exceptional quality• Working on Operational and Analytical SSRS Reports• Created data-driven packages in SSIS as part of the automating the process for the referral process.• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data using SSIS.• Creates detailed documentation of data warehouse and data marts, Cube structures, and ETL as part of project solutions and presents results to Technology.• Designing high quality and robust data access layers, which includes the design specification of the Stored Procedures and/or Web Services detailed within Systems Design Specifications (SDS) and Technical System Specification (TSD) phases.• Participate & contribute in systems design sessions and contribute to Technical System Specifications (TSD) documents for the database components.• Represented as a technical subject matter expert for the internal team on areas like system functionality and approach including solving systems operations issues, performance initiatives.• Reviewed, analyzed, and performed data integrity checks on data to ensure consistency with data requirements.

• Supports day to day administrative operational duties for the database plateform such as service requests, and tickets, backups, restores, monitoring, security include logins, user accounts and roles, update statistics, performance tuning, system troubleshooting, rebuild/reorganize Indexes, weekly migration and other tasks as assigned and expected from DBA.• Troubleshoot issues related to performance, blocking, deadlocking, log, connectivity, security, CPU, memory, I/O disk space and other resource contension, support 24x7 production enviroment• Completed all assigned tickets within SLA, regular application and database support and provided desire reports to customer• Delivered L3 application/database technical support to current and new business applications• Work with change control and ticketing systems to coordinate changes with other infrastructure teams• Manages the design and distribution, performance, replication, security, availability and access requirements for large complex databases. • Work with IT and business teams to address issues specific to the database/application• Responsible for assuring system availability and performance of Database systems• Coordinate with members of the team, rest of the organization and any others needed to ensure proper implementation, support and maintenance of database systems.• Responsible for improvement and maintenance of the databases to include rollout and upgrades.• Implements measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.• Ensures all databases are up and running, performance tuned and accessible • Responsible for implementation and release of database changes according to agreed timescales and costs.• Schedule SQL Server jobs for automating data transfer between both internal and external data systems• DBA in-charge of all production, QA, replication, reporting, and development databases.