Mayank Tiwari Synapse/Databricks,SQL,Data factory,PowerBI
No reviews yet

I am willing to provide SQL in-Depth knowledge to students who wants to learn about its basics and for the experiences as well to take there career to another level.
I have command over SQl Development, SQL Optimization, Power BI and Azure Data Factory as well.
I use to work in South Africa and I had trained my subordinate there to grab a good command in SQL from scratch.
My style of teaching is to explain everything with example. Once cannot memorize the technical skills, with example I tend to clear the concept.
Knowing how to create scripts in SQL is another thing and implementing it in real life is another. With my vast experience in SQL in professional environment, I can provide real life example to relate which make it very easy to developed, implement and optimize it.

Apart from SQl, I am proficient in ETL, Data warehousing and worked on Databricks, Synapse and Azure data factory, I can help you create your CI/cd pipeline as well and can help you in creating optimized notebook in Pyspark or Scala for Databricks and Azure synapse.

I can also help you in creating reports in SSRS and in PowerBI

Subjects

  • Power BI Beginner-Intermediate

  • SQL Developer Beginner-Intermediate

  • Azure Data Engineer - Data Factory Beginner

  • Azure Synapse Beginner-Intermediate

  • ETL Data warehouse Beginner-Expert

Experience

  • Senior Data Engineer (Mar, 2022–Present) at Tata consultancy services
    Creating Synapse notebook and migrating from ADB as well.
    ▪ Writing Complex SparkSQL, Scala code for data validation
    ▪ Databricks to Azure Synapse Migration
    ▪ Created ADF Pipeline to retrieve data from different sources
    ▪ Designing data architecture of different data layer (Raw, Gold or Cooked)
    ▪ Processing csv files to tabular model and creating PowerBI report
    ▪ Writing optimized Scala code to take backup of ADB entities and clean the resource
    Creating CI/CD pipeline and compete the Production Deplpoyment
  • Data Engineer (Dec, 2020–Mar, 2022) at Applied information Science, Hyderbad
    Creating Synapse notebook for data transformation, file generation and data segregation
    ▪ Created Complex Power BI dashboard and reports
    ▪ Created Bing Map report with API integration.
    ▪ Created ADF Pipeline to retrieve data from different sources
    ▪ Used Copy activity, web activity and Different kind of loopssuch as UNTIL.
    ▪ Used Azure Key Vault to store and retrieve credentials and use it in ADF Pipelines
    ▪ Used Azure Logic app to retrieve files from SharePoint through ADF and use it in Power BI report
  • Report Developer (Apr, 2018–Nov, 2020) at Choppies Group, South Africa
    Keeping track of Project deadline by conducting daily Scrum call with Team member.
    Design the architecture of Integration
    Created and Optimized Sql Stored Procedures
    Writing SQL Procedures, Functions, Tables, Triggers, Index, Cursor.
    Using ROLLBACK and COMMIT in SQL Procedures to maintain data integrity
    Creating SSIS Packages to transfer data in ORACLE
    Creating reports on SSRS and using in-Built SSIS reports.
    Creating SSRS Reports as per demand by management
    Creating Basic C# .Net application to meet business requirements.
    Setting up maintenance plans and scheduling jobs.
    Performing Backup & Restore Operation
    Monitoring and Trouble-shooting alerts and performance issues and resolving blocking issues
    Heath Check of Databases, Checking SQL related error logs
    Updating the Client with any changes or updates with respect to Production Servers.
    Gathering data requirements and designing and fine-tuning of databases as per the requirement of clients.
    Experience in Import, Export, Backup, Restore, SQL Agent Jobs and Database Monitoring tools
    Implementation of SQL logins, roles and authentication modes as a part of security.
    24*7 provides application and database support to all clients across various countries.
    Preparing SQL scripts for data integrity and verification.
  • SQL Developer (Jan, 2013–Apr, 2020) at Polaris Software Lab (I) Ltd., India
    Keeping track of Project deadline by conducting daily Scrum call with Team member.
    Design the architecture of Integration
    Created and Optimized Sql Stored Procedures
    Writing SQL Procedures, Functions, Tables, Triggers, Index, Cursor.
    Using ROLLBACK and COMMIT in SQL Procedures to maintain data integrity
    Creating SSIS Packages to transfer data in ORACLE
    Creating reports on SSRS and using in-Built SSIS reports.
    Creating SSRS Reports as per demand by management
    Creating Basic C# .Net application to meet business requirements.
    Setting up maintenance plans and scheduling jobs.
    Performing Backup & Restore Operation
    Monitoring and Trouble-shooting alerts and performance issues and resolving blocking issues
    Heath Check of Databases, Checking SQL related error logs
    Updating the Client with any changes or updates with respect to Production Servers.
    Gathering data requirements and designing and fine-tuning of databases as per the requirement of clients.
    Experience in Import, Export, Backup, Restore, SQL Agent Jobs and Database Monitoring tools
    Implementation of SQL logins, roles and authentication modes as a part of security.
    24*7 provides application and database support to all clients across various countries.
    Preparing SQL scripts for data integrity and verification.

Education

  • Master of Computer Application (May, 2010–May, 2013) from GLA institute for technology and management–scored 72

Fee details

    ₹3,000–5,000/hour (US$35.93–59.88/hour)

    depends on type of work, if apart from getting the work done needs to educate as well, then it will go up to 5000, if only work needs to be done and you are associated with an organization it will be 4000-5000 and if you student and want to learn from basic it will vary from 3000-5000

Reviews

No reviews yet. Be the first one to review this tutor.