Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Generic
Ankit Shukla

Ankit Shukla

Noida

Summary

Practical Database Engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering five-year background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Engineer

Quara Holding
Gurugram
08.2023 - Current
  • Data Analytics and ETL Expert: Applied Google Analytics for comprehensive data analysis.
    Proficient in Looker Studio for creating impactful visualizations.
  • Azure Data Factory (ADF) Specialist: Designed and executed robust ETL processes using Azure Data Factory.
    Ensured smooth data extraction, transformation, and loading.
  • Power BI and SQL Proficiency: Created insightful reports and dashboards using Power BI.
    Developed and optimized SQL queries for effective data handling.
  • Key Contributions at Quora Holding: Elevated data-driven decision-making processes.
    Successfully implemented ETL strategies, enhancing data integrity.
  • Collaborative Team Player: Effectively collaborated with cross-functional teams.
    Contributed to fostering a data-driven culture within the organization.
  • Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.

Marketing Data Analyst

GreyOrange
Gurugram
09.2022 - 07.2023
  • . Created custom roles in Azure Active Directory for access control management of users and groups across multiple subscriptions.
  • Deployed applications to the cloud using ARM templates with CI and CD pipelines in Azure DevOps.
  • Azure Data Factory Transformation: Excelled in utilizing Azure Data Factory for efficient data transformation.
    Seamlessly transferred data between locations to support marketing initiatives, enhancing data transformation capabilities.
  • Created dashboards to monitor customer engagement levels and ROI of campaigns.
  • Global Marketing Collaboration: Key role in building and scaling Marketing Operations globally.
    Ensured cohesive and efficient frameworks for streamlined processes.
  • Tools Implementation and Management: Selected, implemented, and monitored automation tools like HubSpot, Salesforce, DemandBase, SEMrush, and ZoomInfo.
  • Automation and Reporting Impact: Implemented A/B testing methodologies, significantly improving campaign performance and reducing customer acquisition costs.
  • System Administration and Integration:Managed integration points and vendor relationships as the primary system administrator.
    Oversaw contracts, renewals, ensuring optimal system performance.
  • Data Reporting and Visualization Proficiency: Generated, maintained, and consolidated daily/monthly reports.
    Developed SQL reports using advanced queries and created custom dashboards in various platforms.

Data Specialist

C2FO
Noida
06.2021 - 09.2022
  • Azure Data Factory Expertise: Utilized foundational skills in Azure Data Factory for efficient data transfer between cloud locations.
    Implemented copy activities with conditions to streamline data movement.
  • Optimized existing queries used in daily operations by providing recommendations based on best practices.
  • Performed ETL operations to move data between databases.
  • Corrected data errors and entered missing information into new data parcels being processed for clients, maintaining compliance with guidelines.
  • Data Science Collaboration: Collaborated with the Data Science team, specializing in onboarding new suppliers.
  • Account Optimization: Analyzed and consolidated accounts for Global ESRM (sans-AMER) to optimize book management and minimize assignment issues.
  • Reports and Analytics: Generated, maintained, and consolidated daily/monthly reports using advanced SQL queries.
    Created visualizations on Power BI, Google Studio, and Tableau for comprehensive insights.
  • Management Reporting: Delivered business-related reports using Power BI and Tableau, tailoring insights for specific requirements.
    Published monthly dashboards and team performance updates for stakeholders.
  • Data Technologies Proficiency: Proficient in MS Excel, SQL and Power BI reporting.
    Hands-on experience with SSRS and NoSQL databases.
  • Multifaceted Skill Set: Ensured effective data analysis, reporting, and visualization.
    Growing proficiency in Azure Data Factory for enhanced data transfer and management capabilities.

Data executive

OYO
Gurugram
05.2019 - 07.2021
  • Diligently managing administrative tasks, I maintained and organized extensive office files and updated the company's contact and mailing lists for optimal efficiency
  • Additionally, my responsibilities extended to monitoring ongoing marketing strategies and utilizing Power BI tools to map hotel chains, ensuring comprehensive dashboard oversight
  • My role included actively monitoring queries and reviewing feedback to enhance business operations
  • Notably, I significantly improved Review Conversion for Booking.com by 50% through the development of an automated guest communication process using Python, employing AB testing for optimization
  • Complementing these achievements, I possess foundational knowledge of Azure Data Factory, utilizing Microsoft Azure for account management
  • I leverage Power BI for reporting and analysis, extracting data from SQL databases to contribute to informed decision-making
  • This broadens my skill set to seamlessly integrate and utilize tools for enhanced operational insights.

Business Analyst

foodpanda
Gurugram
10.2018 - 03.2019
  • Monitoring the data of customers and restaurant reviews
  • Praised for initiatives and problem-solving abilities
  • Interacting with Marketing, Operations and Product team to prepare & maintain dashboards on a weekly basis for deep dive into different metrics and provide useful insights.
  • Managed projects and served as primary liaison between client and multiple internal groups to clarify goals and meet standards and deadlines.
  • Delivered timely support by tracking issues and communicating resolutions to end users.
  • Analyzed existing systems and processes to identify areas of improvement.

Education

Bachelor of Science - Maths 'Hons'

Bundelkhand University
01.2017

Skills

  • AZURE DATA FACTORY
  • ETL
  • Data Modeling
  • DATA BRICKS
  • Data Warehousing
  • Data Analysis
  • SQL and Databases
  • POWER BI
  • TABLEAU
  • SALESFORCE
  • SNOWFLAKE

Certification

  • Analyzing and Visualizing Data with Microsoft Power BI
  • Analyzing and Visualizing Data with Microsoft Excel
  • IAB Digital Marketing and Media Foundations Certification

Personal Information

Title: Data Engineer

Timeline

Data Engineer

Quara Holding
08.2023 - Current

Marketing Data Analyst

GreyOrange
09.2022 - 07.2023

Data Specialist

C2FO
06.2021 - 09.2022

Data executive

OYO
05.2019 - 07.2021

Business Analyst

foodpanda
10.2018 - 03.2019

Bachelor of Science - Maths 'Hons'

Bundelkhand University

Similar Profiles

CREATE PROFILE
Ankit Shukla