Summary
Overview
Work History
Education
Skills
Technical Skills
Certification
Timeline
Generic

Srujan Kumar Goregey

Data Analyst | Software Developer
Richmond,VA

Summary

Experienced IT professional with over three years of expertise in Cloud Technologies and Data Science, holding a master's degree in Data Analytics Engineering. Proficient in programming languages such as Python, Java, and SQL, with a good understanding of functional programming. Hands-on experience with various AWS services, including Amazon EC2, Amazon S3, and IAM roles. Skilled in predictive modeling, statistical analysis, and applying machine learning models. Strong experience in data cleaning, reshaping,building ETL pipelines and generating segmented subsets using Databricks, Numpy, Pandas and PySpark. Microsoft Certified Azure Administrator Associate (AZ-100) professional with expertise in DevOps methodologies, Jenkins, Docker, and Splunk.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Capital One
Richmond, VA
08.2021 - Current
  • Built marketing and servicing campaigns for US Partnership Cards using Fractal and Salesforce Marketing Cloud tools
  • Conducted A/B tests to increase customer engagement by analyzing business requirements, performing data segmentation, integrating customer data into emails, enforcing compliance approvals, and analyzing performance using DataBricks, Snowflake, PySpark, and AWS S3
  • Identified 1 million inactive accounts, developed campaign to close them, and reclaimed 2 billion USD in inactive exposure by collaborating with cross-functional teams
  • Simplified reporting by creating aggregated data sets and developed Tableau dashboards to visualize key performance metrics, enabling leadership to make informed business decisions
  • Ensured data integrity and correctness by validating metrics and end user reports
  • Developed and executed business reports and performed ad-hoc data analysis for performance monitoring
  • Created Databricks scripts to extract data from Snowflake tables and upload files to onelake S3 buckets using PySpark and Python
  • Manipulated data and built new features using Python and PySpark
  • Trained new team members on Fractal, Q/A testing, A/B testing, and Databricks scripts.

Data Scientist

Allwyn Corporation
, USA
01.2021 - 05.2021
  • Collaborated with healthcare analytics team to develop predictive models using regression to analyze total charges incurred by hospitals and length of stay for patients diagnosed with lung cancer and mental illness, using Python, AWS SageMaker, EC2, and S3
  • Conducted detailed data analysis using SQL and Python to determine data structure, content, and quality
  • Utilized SPSS to analyze, load, and convert large ASCII files into CSV format and used data-wig library to impute missing values for categorical and continuous data
  • Designed dashboards using ggplot, Python matplotlib, Power BI, and Tableau to analyze important features and model performance and present findings from analysis.

Software Developer

Applied Info Sciences
Hyderabad
09.2018 - 12.2019
  • Containerized Drupal web applications and implemented CI/CD pipelines in Jenkins
  • Secured and troubleshooted Azure Web App for Containers
  • Created SharePoint Site Collections, Site Pages, Lists, and Nintex Forms, and utilized REST APIs to retrieve data from SharePoint lists and display JSON data in Site Pages
  • Automated data entries using Power Apps
  • Monitored multiple applications using Microsoft Azure Cloud Services (PaaS, IaaS), Application Insights, and Splunk
  • Provided initial assessment and possible workarounds for production issues
  • Collaborated with application developers to guide development and implementation of Cloud applications, systems, and processes using DevOps methodologies.

Business Intelligence Analyst

Open Text Corporation
Hyderabad, India
03.2018 - 09.2018
  • Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information using MS SQL and Java
  • Developed reports using Business Objects functionalities like Queries, Graphs, Charts, Slice and Dice, and Drill Down functions
  • Responsible for developing and maintaining web application reports, visually effective dashboards, and charts using JavaScript and Open Text Analytical Designer tool in the organization's intranet and extranet portals for data reporting
  • Created automation framework using Selenium for many reports, reducing processing time
  • Kept up to date on best visualization practices and dashboard designs, ensuring standardization and consistency of reporting
  • Projects
  • Breast Cancer Prediction | Python, SQL
  • Conducted a performance comparison between different machine learning algorithms (SVM, CNN, Decision Tree, k Nearest Neighbor) on the Wisconsin Breast Cancer dataset
  • Image Classification using VGG16 | Python, Keras, TensorFlow
  • Built an image classification model using the VGG16 predefined model, achieving 92.7 top-5 test accuracy for the ImageNet dataset.

Education

Master's - Data Analytics Engineering

George Mason University
Fairfax, VA
01.2020 - 2021.05

Bachelor's - Computer Science

Jawaharlal Nehru Technological University
Hyderabad
06.2014 - 2018.05

Skills

Java, Python, R programming, SQL (MySQL, PostgreSQL), C programming, JavaScript, HTML/CSS

undefined

Technical Skills

Statistical Analysis, Data Visualization, Data Modeling, Data Mining, Ad-hoc Data Analysis, Scalable Automation,Data Integration, Data Validation, Data Warehousing, Interactive Visualizations, ETL pipeline, Machine Learning, Cloud Computing, Data Structures and Algorithms, and Object-Oriented Programming.

Certification

Microsoft Certified Azure Administrator Associate (AZ-100)

Timeline

Data Analyst

Capital One
08.2021 - Current

Data Scientist

Allwyn Corporation
01.2021 - 05.2021

Master's - Data Analytics Engineering

George Mason University
01.2020 - 2021.05

Software Developer

Applied Info Sciences
09.2018 - 12.2019

Business Intelligence Analyst

Open Text Corporation
03.2018 - 09.2018

Bachelor's - Computer Science

Jawaharlal Nehru Technological University
06.2014 - 2018.05
Srujan Kumar GoregeyData Analyst | Software Developer