Eshant Garg Email & Phone Number

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 +.

San Francisco, California, US

• 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.

Tempe, AZ, US

• 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.

San Francisco, CA, US

• 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.

Costa Mesa, CA, US

• 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.

London, GB

• 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.

Teaneck, New Jersey, US

• 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

• 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.
• 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.

B.Tech, Computer Science

Sec High School, Mathematics And Computer Science