Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Durga Prasad Dhulipudi

Mississauga,Ontario

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven ability to understand customer requirements and translate them into actionable project plans. Dedicated and hard-working with a passion for big data.

Overview

6
6
years of professional experience

Work History

Uber Driver

Uber
03.2023 - Current
  • Skilled at working independently.
  • Self-motivated, with a strong sense of personal responsibility.
  • Proven ability to learn quickly and adapt to new situations.
  • Worked well in a team setting, providing support and guidance.

Associate

Amazon Delivery Station -DTO3
08.2022 - 02.2023
  • Enhanced team productivity by streamlining communication and implementing efficient project management tools.
  • Developed strong client relationships through timely and thorough follow-up on inquiries and concerns.
  • Optimized departmental processes with the implementation of innovative strategies, resulting in improved efficiency and reduced costs.
  • Increased customer satisfaction by resolving complex issues and providing exceptional service at all times.

Fashion Associate

Walmart
04.2022 - 08.2022
  • Enhanced customer satisfaction by providing personalized fashion advice and product recommendations.
  • Increased sales through effective up-selling and cross-selling of complementary items.
  • Managed inventory and ensured proper stock levels for high-demand products.
  • Assisted in visual merchandising, creating eye-catching displays to attract customers.

Customer Service Representative

Itronics Info Solutions
03.2018 - 01.2020
  • Enhanced customer satisfaction by promptly addressing concerns and providing accurate information.
  • Streamlined call center processes for improved efficiency and reduced wait times.
  • Resolved customer complaints with empathy, resulting in increased loyalty and repeat business.
  • Assisted customers in navigating company website and placing online orders, improving overall user experience.

Data Analyst

UST Global
06.2020 - 02.2022
  • Conducted detailed analysis of functional and non-functional data elements using data profiling techniques, facilitating effective mapping from source to target data environments.
    • Generated comprehensive UML diagrams, including context, Business Rules Flow, and Class Diagrams, to improve understanding of data flow processes.
    • Applied ETL methodology extensively in a complex Enterprise Data Warehouse (EDW) environment, utilizing Informatica for data extraction, transformations, and loading processes.
    • Orchestrated test design activities and conducted allocation testing from the front end/user interface to ensure data accuracy and reliability.
    • Played a key role in data mining, transformation, and loading activities, smoothly transitioning data from diverse source systems to the target system.
    • Designed and developed interactive dashboards in Tableau to address crucial business questions, offering valuable insights for decision-making.
    • Authored SQL and PL/SQL queries, as well as stored procedures, implementing business rules and transformations for efficient data processing.
    • Proficiently utilized various Informatica transformations, such as Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored Procedure, and Normalizer, to ensure seamless data integration.
    • Conducted thorough analysis of solution architecture and design documents, emphasizing Source to Target mappings and detailed design across multiple tracks.
    • Designed and developed pre-session, post-session routines, and batch execution routines using Informatica Server, optimizing session runs.

Education

PGDM - Marketing Management

Georgian College of Applied Arts And Technology
Barrie, ON
08.2023

PGDM - Project Management

Georgian College of Applied Arts And Technology
Barrie, ON
08.2022

Bachelor of Science - Agriculture

Pondicherry University
Puducherry
03.2020

Skills

  • MS Office
  • Teamwork and Collaboration
  • Multitasking Abilities
  • Project Planning
  • Data Entry
  • Appointment Scheduling
  • Report Generation
  • Complaint Resolution
  • Data Collection
  • ETL and BI Tools: SSRS, Report Builder, Focus, Power BI, Tableau, Informatica
  • Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script, Python
  • Databases: SQL Server, Oracle, MYSQL, No-SQL
  • Data Modelling: Star-Schema Modeling, Snowflake-Schema Modelling, FACT and dimension tables, Pivot Tables, Erwin
  • Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Business Intelligence Development Studio (BIDS), SQL CMD
  • Testing Tools: Win Runner, Load Runner, Test Director, Quality Center, and Rational Clear Quest

Languages

English
Full Professional

Timeline

Uber Driver

Uber
03.2023 - Current

Associate

Amazon Delivery Station -DTO3
08.2022 - 02.2023

Fashion Associate

Walmart
04.2022 - 08.2022

Data Analyst

UST Global
06.2020 - 02.2022

Customer Service Representative

Itronics Info Solutions
03.2018 - 01.2020

PGDM - Marketing Management

Georgian College of Applied Arts And Technology

PGDM - Project Management

Georgian College of Applied Arts And Technology

Bachelor of Science - Agriculture

Pondicherry University
Durga Prasad Dhulipudi