Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Abhishek Pamulapati

Calgary,AB

Summary

Experienced professional with 3+ years in Azure Data Factory, Databricks, Azure Synapse, ADLS, Azure SQL, AWS, and Power BI.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst- Full-Time

Black Diamond Group
03.2023 - Current
  • Developed Sales profit/loss report which for leadership steering committee for visibility on sales of asset which increased the operational efficiency and revenue generation by 80 percent
  • Supported and maintained more than 100 PowerBI reports over 40 plus PowerBI apps on PowerBI service
  • Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures.
  • Automated the upload process to SharePoint for a business by implementing ETL pipeline which increased efficiency by 40 percent.
  • Implemented role-based access control (RBAC) to segregate user permission in PowerBI service using user groups and permissions to manage sensitive data and reports.
  • Send email notifications about ETL issues reports to development team by using Send Mail Task/Script Task/Execute SQL Task along with system stored procedure to send emails
  • Realized a 40% reduction in average turnaround time (TAT) through developing and automating a key ETL data pipeline and achieved significant resource optimization by saving cost.


Analytics Engineer

Planet Green
09.2019 - 12.2020
  • Responsible for performing SQL scripting development task like creating, altering, and updating tables. Developed stored procedures, queries, views, joins and indexes by using T-SQL.
  • Performance tuning to optimize SQL queries using SQL Profiler and Query Analyzer and using Explain plan and execution plans.
  • Developed MS SQL server stored procedures, User Defined Functions, Views and Triggers using T-SQL statements from scratch.
  • Tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
  • Analyzed data if a user reports any issue. Verified the data granularity. Fixed the production issues
  • Created SSIS packages to clean and load data to data warehouse.
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task
  • Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
  • Created Power BI Visualizations and Dashboards as per the requirements.

Education

Master’s degree -

University of Windsor
04.2022

Bachelor’s degree -

JNTUH College of Engineering
Hyderabad, IN
06.2019

Skills

  • Proficient in software development methodologies
  • Expertise in ETL tools: SSIS, Azure Data Factory, AWS Glue
  • Proficient in Python, Pyspark, SQL, Shell scripting, and Go
  • Database management: MS SQL Server, Postgres, Teradata
  • Data processing tools: Spark, ADLS Gen2, Hadoop, Databricks, Snowflake
  • Other : AWS, Azure, GCP, Docker, CI/CD, Git, DataModelling, DBT

Certification

DP-203 Azure Data Engineer Associate, Databricks Data Engineer Associate, DP-900 Azure Fundamentals, Data Camp Data Engineer Associate, Databricks Lakehouse Fundamentals

Timeline

Data Analyst- Full-Time

Black Diamond Group
03.2023 - Current

Analytics Engineer

Planet Green
09.2019 - 12.2020

Master’s degree -

University of Windsor

Bachelor’s degree -

JNTUH College of Engineering

Similar Profiles

CREATE PROFILE
Abhishek Pamulapati