Mayur Prashant Nayak

Mayur Prashant Nayak

About

Detail

Azure Data Engineer
Houston, Texas, United States
Contact Mayur regarding: 
Flexible work
Starting at USD60/hour

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • VERISK CRIME ANALYTICS INC
    Azure Data Engineer
    VERISK CRIME ANALYTICS INC
    May 2022 - Current (4 years 4 months)
    Develop, design data models, data structures and ETL jobs for data acquisition and manipulation purposes. Develop deep understanding of the data sources, implement data standards, maintain data quality and master data management. Expert in developing JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data. Expert in using Databricks with Azure Data Factory (ADF) to compute large volumes of data. Performed ETL operations in Azure Databricks by connecting to different relational database source systems using JDBC connectors. Developed Python scripts to do file validations in Databricks and automated the process using ADF. Developed an automated process in Azure cloud which can ingest data daily from web servi
  • Grubhub
    Azure Data Engineer/ETL Developer
    Grubhub
    Nov 2020 - Apr 2022 (1 year 6 months)
    Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules. Understand business use cases, integration business, write business & technical requirements documents, logic diagrams, process flow charts, and other application related documents. Used Pandas in Python for Data Cleansing and validating the source data. Designed and developed ETL pipeline in Azure cloud which gets customer data from API and process it to Azure SQLDB. Orchestrated all Data pipelines using Azure Data Factory and built a custom alerts platform for monitoring. Created custom alerts queries in Log Analytics and used Web hook actions to automate custom alerts. Created Databricks Job workflows which extr
  • Frost Sullivan
    Data Analyst/Engineer
    Frost Sullivan
    Jan 2018 - Oct 2020 (2 years 10 months)
    1. Designed and Developed Tableau dashboards from scratch to generate actionable insights and solutions for client services. 2. Unified dashboard which displayed Implementation and Opportunity stages; Opportunities won by sales rep, features most used, Live customer count, breakdown by Persona of users etc. which helped in increasing product’s sales by 4 % and improving the overall user experience. 3. Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers. 4. Build and published customized interactive reports and dashboards, report scheduling using Tableau server. 5. Created action filters, parameters, and
  • Schbang
    Data Analyst
    Schbang
    Jun 2015 - Dec 2017 (2 years 7 months)
    Roles & Responsibilities 1. Worked through all the phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Production and Post-Production Support. 2. Developed Stored Procedures and User Defined Functions for providing input feed for front end applications. 3. Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and joins. 4. Designed and worked on Extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS. 5. Developed a 360-business dashboard in Tableau with multiple panels and parameters for Salesforce team. 6. Map sources to targets using Excel Macro functions, SQL scripts, i
Education verified_user 0% verified
  • University of Mumbai
    Bachelor of Commerce - BCom, Computer Science
    University of Mumbai
    Apr 2012 - Aug 2014 (2 years 5 months)
    Skills: Problem Solving · Customer Service Management · Commercial Banking