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
Visualization tools - Tableau- Tableau Online (Admin duties), Tableau Desktop, Tableau Prep, Tableau Bridge, Power BI, Amazon Quick Sight
Python for Data Analysis and Data Science-Data structures, Control structures, Functions, Numpy, Pandas, Matplotlib, Seaborn
Univariate and Multivariate Analysis, Exploratory Data Analysis, Regression Algorithms using Python
Excel - Charts, Functions, VLookup, Macros
GitLab, GitHub, ClickUp
Visual Studio Code, Jupyter Notebook
Strong Communication and Leadership skills
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