Still Struggling with Tech Hiring? Discover Olibr's Solution Now!
Login / RegisterDeveloperClient
Login/Register

Vivek Dubey

Delivery Manager

  • Noida, UP
  • 8 years

Available From: Available

    Candidate's About

    With 11+ years in IT, I specialize in project management, delivery, team leadership, and Azure technologies. Skilled in analyzing projects, clarifying requirements, and designing efficient systems, I enhance productivity and cost-effectiveness.

    Work & Experience

    D

    Delivery Manager

    Feb 22 - PRESENT

    Technology

    • Icon
      SQL
    • Icon
      Python
    • Icon
      Tableau
    • Collaborate with clients to define project objectives, requirements, and timelines.
    • Lead a team of project managers, ensuring effective communication and resource allocation.
    • Monitor project progress and budget adherence, taking corrective actions when necessary.
    • Foster a culture of continuous improvement and innovation within the project team.
    • Maintain stro...
    Read More
    M

    Manager

    Jun 18 - PRESENT

    Technology

    • Icon
      Tableau
    • Icon
      SQL
    • Icon
      Azure
    • Provide technical leadership and guidance to the Liquid Hub Analytics team.
    • Lead the design and architecture of analytics solutions and systems.
    • Collaborate with cross-functional teams to define project objectives and requirements.
    • Mentor and coach team members, fostering skill development and growth.
    • Ensure adherence to coding standards and best practices.<...
    Read More

    Next gen Tool

    Manager

    The main objective of this project is to collect all the financial data of firm and then report it to senior management for analysis

    ·       Migration of current On Prem SQL Server to Microsoft Azure.

    ·       Creating Pipelines , Designing data distribution strategy in SQLPool.

    ·       Created SSIS packages to populate data from various data sources

    ·       Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate,

    ·       Conditional split, SQL task, Script task and Send Mail task

    ·       Scheduled the SSIS packages to run at different intervals to load the data

    ·       Prepared tableau Dashboards with Quick filters, Parameters and sets to handle views more efficiently

    ·       Created Tableau Dashboards with interactive views, trends and drill downs along with user level security

    ·       Assisted in UI path project to transform manual distribution of excel report to automatic generation

    ·       Evaluated employee performance on a monthly basis and coached and trained accordingly increasing

    ·       quality of work and employee motivation

    ·       Coached and mentored the team new members as per  the requirement

    • SQL
    • Excel
    View Details
    S

    Senior System Engineer

    Feb 12 - Jul 16

    Technology

    • Icon
      SQL
    • Icon
      Tableau
    • Icon
      Python
    • Design, implement, and maintain IT systems and infrastructure.
    • Collaborate with clients to define technical requirements and solutions.
    • Ensure system security, performance, and reliability.
    • Troubleshoot and resolve technical issues and outages.
    • Monitor system health and implement proactive maintenance.
    • Install and configure hardware and software comp...
    Read More

    IFRS9

    Senior System Engineer

    Nationwide Building Society is a British mutual financial institution and the largest building society in the world

     

    ·       Strewed a team of 8 members

    ·       Created the build plan to commit timelines.

    ·       Extracted data from various sources like SQL Server, CSV, and Excel & Text file from Client servers and through FTP.

    ·       Handled Performance Tuning and Optimization on SSIS, with strong analytical & troubleshooting skills for quick issue resolution.

    ·       Involved in creation/review of functional requirement specifications & supporting documents for business systems

    ·       Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers

    ·       Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio

    ·       Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

    ·       Planned SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

    ·       The packages created included a variety of transformations for example Slowly Changing Dimensions, Look Up, Aggregate, Derived Column, Conditional Split, Multicast, Data Conversion etc

    ·       Reviewed & tested packages, Fixing bugs using SQL 2008 Business Intelligence Development Studio

    • SQL
    • Excel
    View Details

    Education

    U

    Bachelor of Technology in Electronics and Communications

    Uttar Pradesh Technical University
    2008 - 2011

    Certificates

    4

    448 SQL SERVER 2008, BUSINESS INTELLIGENCE DEVELOPMENT AND MAINTENANCE.

    4

    461 Querying MS SQL SERVER 2012

    M

    Microsoft Certified Azure Fundamentals AZ900 Certification

    M

    Microsoft Certified Data Fundamentals. DP900 Certification