Summary
Overview
Work History
Education
Skills
Certification
Timeline
Volunteering Experience
BusinessAnalyst

Soujanya Kusampudi

Senior Data Analyst
Hyderabad,TG

Summary

Meticulous and result-oriented Senior Data Analyst with 5+ years of experience in Client-communications, ETL processes, Data Visualization and Analysis. Passionate about transforming data into a valuable asset to help guide business decisions. Efficient at managing multiple priorities and team-members.

Overview

5
5
years of professional experience
8
8
years of post-secondary education
4
4
Certificates

Work History

Senior Data Analyst

Pramahasoft
Hyderabad
11.2024 - Current
  • November,2024 - Current
  • Working as Senior Data Analyst and leading a Data team of 5.
  • Developing ETL processes in collaboration with the development team to transform raw data into usable formats.
  • Wrote python scripts using Numpy and Pandas for data cleaning and formatting.
  • Leading stakeholder meetings to understand client requirements, streamline projects and arrive at deliverables.
  • Developing client-facing Tableau reports and dashboards to effectively communicate and present data insights and summaries.
  • Writing SQL queries- to create database schemas, tables, views, triggers and stored procedures, to extract and load data into Tableau in the desired format using complex joins.
  • Building Tableau reports on data derived from combining various data sources like database servers, external Excel files, text files.
  • Administering Tableau online- user-access, client permissions, managing various project folders, groups and refresh schedules.
  • Managing the data team, recruiting and training new members into the team, thereby augmenting the Organization's capabilities to handle large data projects.

Senior Data Analyst

CareMonitor (HQ: Sydney, Australia)
Hyderabad (remote)
02.2023 - 10.2023
  • February,2023 - October,2023
  • Worked as Senior Data Analyst and Head of Data team.
  • Lead: Data Visualization project for 6 months, serving the Health Ministry of an Australian state.
  • Held project stakeholder discussions, customized and built numerous Tableau reports.
  • Served as Tableau Online-Administrator and maintained various projects and related Tableau reports.
  • Wrote PostgreSQL queries for Tableau reports, debugged and optimized existing queries.
  • Engaged in extensive client calls and email discussions regarding project requirements, challenges faced mid-project, project deliveries and documented all project stages.
  • Documented all Data team related processes for future training purposes.

Data Analyst

BioUrja Group (HQ: Houston, USA)
Hyderabad
01.2022 - 02.2023
  • January,2022 - February,2023
  • Worked on US Power trading based ETL project and gained hands-on experience with python-based data extraction from various APIs, cleaning and transformation of raw data to meet business needs and uploading data into snowflake tables.
  • Moderate experience with Project Management-ETL project-team of 4
  • Developed tables, views and stored procedures on Snowflake.
  • Wrote SQL queries for data testing, analysis and tableau reports.
  • Developed Tableau reports for Data visualization and Analysis using Custom SQL Queries, Joins, Merging, Parameters.
  • Created Data Quality testing processes using Tableau reports and Excel-ODBC connection based semi-automated templates.
  • Monitored daily success/ failure alerts of scheduled VisualCron jobs, debugging and resolving issues encountered.
  • Synthesized complex analytics-based insights into simple, actionable recommendations given to Traders.

Associate Data Analyst

A-STAK Consulting Services
Hyderabad
06.2018 - 12.2021
  • June,2018 - December,2021
  • Worked extensively on data cleaning and formatting using Excel.
  • Extracted data from the database using SQL queries and developed valuable summaries and visualization charts on Excel.
  • Tested and validated Visualization reports developed on Power BI against Excel data.
  • Worked on enhancing and modifying Power BI dashboards to meet clients' requirements.
  • Held weekly presentations for clients on Visualizations developed by the data team.
  • Collaborated with various Stakeholders across projects and facilitated targeted communication between business teams and the data team.
  • Planned and assigned sprints to the Data team, followed up on tickets and generated weekly work reports for the data team.

Education

Master of Science - Computer Science

California State University, Long Beach
California, USA
08.2016 - 05.2018

Bachelor of Technology - Computer Science

Gokaraju Rangaraju Institute of Engineering-GRIET
Hyderabad
08.2012 - 05.2016

High School Diploma -

Narayana Junior College
Hyderabad, India
06.2010 - 04.2012

Secondary School -

Little Flower High School
Hyderabad, India
06.2009 - 04.2010

Skills

SQL - MySQL, Snowflake, PostgreSQL

Certification

Executive Post Graduate Programme in Data Science and Artificial Intelligence-for working professionals- IIIT-Bangalore (currently pursuing)

Timeline

Senior Data Analyst

Pramahasoft
11.2024 - Current

Senior Data Analyst

CareMonitor (HQ: Sydney, Australia)
02.2023 - 10.2023

Data Analyst

BioUrja Group (HQ: Houston, USA)
01.2022 - 02.2023

Associate Data Analyst

A-STAK Consulting Services
06.2018 - 12.2021

Master of Science - Computer Science

California State University, Long Beach
08.2016 - 05.2018

Bachelor of Technology - Computer Science

Gokaraju Rangaraju Institute of Engineering-GRIET
08.2012 - 05.2016

High School Diploma -

Narayana Junior College
06.2010 - 04.2012

Secondary School -

Little Flower High School
06.2009 - 04.2010

Volunteering Experience

-Member of 'We The Change' non-profit organization; organized and volunteered at events in Orphanages, Old-age homes

-Senior volunteer/ animal rescuer at Animal Welfare NGOs

-Collaborated with Educational Institutions and organized Ecological clean-up drives

Similar Profiles

CREATE PROFILE
Soujanya KusampudiSenior Data Analyst