Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Naveen Pudukapu

Toronto,ON

Summary

Results-driven IT professional with over 5 years of experience in Database Development, Administration, and Business Intelligence Reporting. Proven track record in transforming raw data into actionable insights using complex SQL queries and ETL processes, while excelling in cloud technologies like AWS. Expertise in Power BI and Tableau for creating advanced visualizations and dashboards, facilitating informed decision-making for clients. Strong collaborative skills enhance team performance in Agile environments, focusing on user requirements and data integrity.

Overview

6
6
years of professional experience

Work History

Data Analyst

Telus
Toronto
01.2022 - 12.2024
  • Outlined necessary project components through teamwork in JRD discussions.
  • Developed ETL pipelines utilizing AWS Glue Studio for efficient data migration from S3 to RDS.
  • Collaborated with clients and stakeholders to identify business needs.
  • Conduct thorough data analysis utilizing diverse tools and technologies.
  • Analyzed legacy database tables with T-SQL queries for data cleansing reports.
  • Developed dashboards with Tableau to monitor key performance indicators.
  • Conducted exploratory analysis of complex datasets using Python libraries such as NumPy and Pandas.
  • Maintained documentation of all the processes related to Data Analysis.
  • Automated manual reporting processes by developing scripts in Python or R.
  • Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Designed and implemented SQL scripts to validate comprehensive data transfers.
  • Implemented partitions in tabular models for Power BI.
  • Leveraged newly integrated Power BI features to streamline business intelligence processes.
  • Handled data from Oracle, SQL Server, Flat Files, Excel, and XML.
  • Optimized accessibility of published Power BI content across various platforms.
  • Created custom metrics with DAX expressions based on specific business criteria.
  • Developed OLAP Cubes to present summarized data views.
  • Leveraged SSRS, SSIS, T-SQL, and Visual Studio for report generation.

BI Developer

Lifeworks
Toronto, Ontario
05.2019 - 12.2021
  • Analyzed reporting requirements to create insightful visual representations.
  • Designed and implemented dashboards using Tableau to provide interactive visualizations of business data.
  • Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
  • Configured databases, cubes, and queries for optimal performance in the BI environment.
  • Optimized existing SQL queries for better performance when running against large datasets.
  • Built OLAP cubes using SSAS for advanced analytics capabilities.
  • Collaborated with business users to analyze requirements and translate them into technical specifications.
  • Utilized Power BI and Power Pivot to create data analysis prototypes.
  • Extracted data from Azure SQL DB, CSV files, and SQL Server 2016 using Power BI.
  • Leveraged various databases to import data into Power BI.
  • Utilized advanced queries to generate dynamic Power BI reports.
  • Developed T-SQL queries and stored procedures for data manipulation.
  • Developed various data visualizations with Power BI, including Lines and Pies.
  • Developed KPI's, partitions, perspectives, and calculated measures.
  • Managed deployment of the application during User Acceptance Testing.
  • Designed Report Level Filters in Power BI aligning with specified needs.

Education

Post-Graduate Certificate - Cloud Computing For Big Data

Lambton College of Applied Arts And Technology
Toronto, ON
03-2019

Skills

  • ETL development
  • Business intelligence tools
  • SQL programming
  • Requirements gathering
  • Data modeling
  • Data warehousing
  • Data quality management
  • Programming languages

References

References available upon request.

Timeline

Data Analyst

Telus
01.2022 - 12.2024

BI Developer

Lifeworks
05.2019 - 12.2021

Post-Graduate Certificate - Cloud Computing For Big Data

Lambton College of Applied Arts And Technology

Similar Profiles

CREATE PROFILE
Naveen Pudukapu