Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Jaswanth Paladugu

DeKalb,IL

Summary

Data professional with3 years of experience in OLTP and OLAP systems, specializing in E-R data modeling and developing database schemas such as star and snowflake for both relational and dimensional models. Experienced in building and implementing data analysis frameworks, leveraging a structured approach to address complex analytical challenges. Proficient in designing and executing Python scripts for data manipulation, analysis, and visualization, coupled with a strong command of SQL for efficient data extraction and transformation. Skilled in implementing data cleaning procedures and configuring preprocessing pipelines to ensure high-quality datasets for analysis. Adept at designing interactive dashboards in Power BI for key performance indicator (KPI) visualization and creating customized visualizations using Python’s matplotlib and seaborn libraries. Proficient in data modeling, warehousing, and building effective ETL pipelines. Competent in Python, Java, and SQL, as well as contemporary programming languages for sophisticated data processing and analysis. Knowledgeable about AWS Glue, which guarantees safe data management and analytics. Strong in cleaning datasets, optimizing query performance, and using big data frameworks such as Hadoop, Hive and Spark to large-scale data solutions. Knowledgeable about creating interactive dashboards and providing insights with Power BI, Tableau, and AWS Quick Sight, which facilitates data-driven decision-making. Capable of working with cross-functional teams to transform business needs into scalable and dependable data solutions. Proven track record in automating reporting workflows, simplifying analytics processes, and improving operational efficiency through advanced techniques. Implementing state-of-the-art solutions for managing complicated datasets by consistently keeping up with new developments in big data and AWS technologies. Having Experience in Data integration which streamlined by proficiency with ETL tools and non-relational databases (object storage, graph, and document models). Proficient in developing analytics applications using Python and other scripting tools to support key business functions and optimize processes.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Business Intelligence Analyst

R1 RCM
06.2020 - 07.2022
  • Project Objective: To deliver actionable insights and scalable data solutions by converting complex datasets into functional outputs using SQL, Python, and Snowflake
  • The project focused on ensuring data accuracy, resolving client-reported issues, and enhancing operational efficiency through Tableau dashboards and A/B testing analysis
  • It also aimed to support Agile development by extracting and integrating data from diverse sources and maintaining critical banking software for optimal user experience
  • Responsibilities:
  • Converted complex data sets into actionable insights using SQL & Python, leading to enhanced operational efficiency
  • Converted complex data sets into actionable insights using SQL and Python, applying advanced analytics techniques to identify patterns, trends, and correlations, which drove operational improvements and optimized processes across departments, enhancing overall operational efficiency
  • Designed and implemented data mappings and workflows to transform raw data into structured formats, ensuring adherence to established development guidelines and enabling seamless data movement between systems to support business functions and decision-making
  • Addressed and resolved over20 defects and change requests raised by clients, collaborating with cross-functional teams to identify root causes, implement fixes, and test solutions, leading to client satisfaction and timely project delivery
  • Regularly monitored Tableau dashboards to ensure real-time insights were delivered to clients, proactively identifying and resolving issues, ensuring stakeholders had access to accurate and timely data for decision-making
  • Utilized a hypothesis-driven approach to analyze A/B testing results, statistically evaluating test performance and providing actionable recommendations to optimize business strategies and drive better decision-making
  • Extracted data from various database sources like Oracle, SQL Server, JIRA, and other internal issue trackers, supporting Agile project development by providing accurate, relevant data for reporting and analysis
  • Provided maintenance support for critical Lloyds banking software, troubleshooting issues, applying updates, and ensuring the system remained functional, secure, and compliant with regulatory requirements for millions of users
  • Leveraged Snowflake as a cloud-based data warehouse solution, optimizing data processing with improved query performance, scalability, and reduced data retrieval times, enhancing the overall performance of business intelligence tools
  • Environment: MS SQL Server, Python, SQL Enterprise Manager, MS Excel, JIRA, Agile and Waterfall methodologies, NumPy, Panda

Business Technology Analyst

Cognizant
08.2018 - 06.2019
  • Project Objective: To enhance operational efficiency and client satisfaction by translating business requirements into functional data solutions using SQL, Python, and Snowflake
  • The project focused on creating actionable insights, monitoring Tableau dashboards, analyzing A/B testing results, and resolving client-reported defects
  • Additionally, it aimed to streamline Agile development by integrating data from diverse sources and maintaining critical banking software for millions of users
  • Responsibilities:
  • Converted complex data sets into actionable insights using SQL & Python, leading to enhanced operational efficiency
  • Designed and executed data mappings and workflows in adherence to established development processes and guidelines, effectively translating business requirements into functional solutions
  • Successfully addressed and resolved over20 defects and change requests raised by clients, contributing to project success and client satisfaction
  • Responsible for regular Tableau dashboard monitoring ensuring the timely insights to the client
  • Utilized hypothesis-driven approach to analyze A/B testing results & offer recommendations based on the test performance
  • Have extracted data from various database sources like Oracle, SQL Server, accessing JIRA tool and other internal issue trackers for the Agile Project development
  • Provided maintenance support for the Lloyds banking software used by millions of users to create accounts, open overdraft
  • Leveraged Snowflake as the data warehouse solution, resulting in enhanced data processing efficiency and scalability, leading to faster query performance and improved data retrieval times
  • Environment: MS SQL Server, Python, SQL Enterprise Manager, MS Excel, JIRA, Agile and Waterfall methodologies, NumPy, Panda

Education

Master of Management Info Systems - undefined

Northern Illinois University
Dekalb, IL
05.2024

Bachelor of Technology - undefined

Aditya Engineering College
Kakinada
01.2018

Skills

  • Data Visualization: Tableau, Power BI, Seaborn, Matplotlib
  • Python Libraries: Pandas, SciPy, NumPy, Seaborn
  • Language & scripting: Python, SQL, PySpark
  • Database Tools: Snowflake, My SQL, SQL Server, Oracle
  • Tools: Erwin, Jira, Excel, Confluence, Jupiter Notebook, Geotab, MS Office
  • Big data Technologies: Hadoop, Airflow
  • Industry Knowledge: Informatica, Azure Services

Certification

Pega certified system architect (PCSA) 85V1 from Pegasystems

SAP Certified Application Associate - Bussiness process integration with SAP S/4 Hana 2020

Timeline

Business Intelligence Analyst

R1 RCM
06.2020 - 07.2022

Business Technology Analyst

Cognizant
08.2018 - 06.2019

Master of Management Info Systems - undefined

Northern Illinois University

Bachelor of Technology - undefined

Aditya Engineering College
Jaswanth Paladugu