Swathi Nuthalapati
Ohio,USA
Summary
Results-driven Data Analyst with 5+ years of experience in analyzing complex datasets, developing insightful visualizations, and driving data-informed decision-making. Skilled in SQL, Python, data visualization tools like Power BI and Tableau, and statistical analysis to solve business challenges. Seeking a challenging role to leverage expertise in data modeling, ETL processes, and predictive analytics to optimize business performance and support strategic objectives.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Huntington National Bank
Ohio, USA
02.2024 - Current
- Company Overview: Huntington National Bank is a leading financial institution, specializing in commercial, and small business banking
- Developed predictive models on large-scale datasets using advanced statistical modeling, machine learning, and deep learning techniques to solve business problems
- Extensively used Python and R (libraries: Pandas, NumPy, Matplotlib, Seaborn, and SciPy) for developing machine learning algorithms and conducting data analysis
- Employed Excel (Advanced Level) to perform data manipulation, create pivot tables, and automate repetitive tasks for business reporting
- Utilized SQL queries to extract, manipulate, and aggregate data from relational databases, optimizing queries for performance in cloud environments like AWS (RDS) and Google BigQuery
- Designed and developed interactive dashboards using Tableau, Power BI, and Looker, providing stakeholders with real-time insights and visualizations
- Managed and processed big data using Hadoop, Apache Spark, and Kafka, and stored large datasets on AWS S3
- Deployed AWS services such as S3, Redshift, and EC2 to manage data storage, processing, and reporting, driving insights for various business teams
- Worked with ETL tools such as Informatica, Alteryx, and custom ETL pipelines to efficiently extract, transform, and load data from multiple sources
- Applied machine learning techniques like classification, regression, and clustering, utilizing tools like Scikit-learn and TensorFlow to create predictive models and optimize business processes
- Conducted deep learning research for Natural Language Processing (NLP) clustering and implemented neural networks for complex analytics
- Gained Power BI certification, reinforcing expertise in creating highly interactive and user-friendly dashboards for business analysis
- Utilized Snowflake for building and managing cloud-based data warehouses, optimizing data workflows and enhancing query performance
- Provided performance analysis and insights using SQL, Python, and machine learning models to solve business problems related to customer behavior, product performance, and market trends
- Filtered duplicate or unauthorized write requests using Google Cloud Functions written in Python for data governance
- Collaborated with cross-functional teams to ensure data accuracy and consistency across platforms, leveraging AWS and Google Cloud for data integration
- Huntington National Bank is a leading financial institution, specializing in commercial, and small business banking
- Environment: Excel, SQL, Python, R, Pandas, NumPy, Matplotlib, Seaborn, SciPy, Tableau, Power BI, Looker, Hadoop, Apache Spark, Kafka, AWS S3, Redshift, EC2, Google BigQuery, Informatica, Alteryx, Snowflake, Scikit-learn, TensorFlow, Google Cloud Functions
Data Analyst
Kroger
Ohio, USA
05.2023 - 01.2024
- Company Overview: Kroger is retail company, one of the largest supermarket chains, Kroger offers a wide range of products including groceries, pharmacy services, apparel, and home goods
- Utilized advanced Excel functions such as pivot tables, macros, and VBA to efficiently manage and analyze large retail datasets
- Integrated diverse data sources, including SQL Server DB, BigQuery, and Azure SQL DB, into Power BI to generate interactive and insightful reports
- Employed Azure Data Lake and Azure SQL Database for scalable data storage and processing, enhancing the architecture of data pipelines and ensuring smooth integration with cloud-based services
- Developed and implemented data analysis models using Python and R, utilizing libraries like Pandas, NumPy, Matplotlib, Seaborn, and Scipy for in-depth data exploration and visualization
- Built machine learning models with R and libraries like Scikit-learn, SciPy, and NLTK, focused on predictive analytics to improve business outcomes
- Designed interactive and insightful dashboards using Tableau, Power BI, and Looker, translating complex data into clear visual representations for stakeholders
- Handled large-scale data processing with tools like Hadoop, Apache Spark, and Kafka, ensuring efficient real-time and batch data management
- Developed and optimized ETL workflows with tools like Informatica, Alteryx, and custom-built pipelines to automate and streamline the data extraction, transformation, and loading process
- Applied machine learning techniques, such as regression, classification, and clustering, to predict customer behavior, optimize product placement, and forecast sales
- Automated the reporting process and enabled real-time data workflows through Power BI, delivering key business insights and performance metrics
- Leveraged Snowflake for fast, efficient querying of both structured and unstructured data, optimizing the storage and retrieval process to meet business needs
- Collaborated with cross-functional teams to understand business requirements and translated them into data-driven insights, driving informed decision-making across retail operations
- Conducted A/B testing and statistical analysis to evaluate the effectiveness of marketing campaigns, pricing strategies, and customer loyalty programs
- Kroger is retail company, one of the largest supermarket chains, Kroger offers a wide range of products including groceries, pharmacy services, apparel, and home goods
- Environment: Excel, Pivot Tables, Macros, VBA, SQL Server DB, BigQuery, Azure SQL DB, Power BI, Azure Data Lake, Azure SQL Database, Python, R, Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit-learn, NLTK, Tableau, Looker, Hadoop, Apache Spark, Kafka, Informatica, Alteryx, Snowflake
Data Analyst
Kaiser Permanente
Bangalore, India
10.2021 - 11.2022
- Company Overview: Kaiser Permanente is a leading health insurance provider known for its integrated care model that combines health insurance with medical care services
- Applied Python for machine learning tasks, including using Convolutional Neural Networks (CNN) and Deep Belief Networks (DBN) to analyze healthcare data
- Employed unsupervised and supervised learning methods with Python Scikit-learn, Pandas, and NumPy to analyze high-dimensional data
- Conducted data modeling operations and generated reports using Power BI, Pandas, and SQL
- Utilized Python libraries like wxPython, Twisted, and Matplotlib for data visualization and analysis
- Used Beautiful Soup and Matplotlib to scrape and visualize healthcare-related data from various sources
- Configured Hadoop tools such as Hive, Impala, and Sqoop for large-scale data processing and integration
- Worked with both structured and unstructured data, performing data cleaning, visualization, and applying machine learning techniques to business problems
- Developed machine learning models using Python and Anaconda to predict customer behavior in the health insurance domain
- Built Help Desk Chatbots using Google DialogFlow to enhance customer support and provide instant solutions
- Integrated data from SQL Server DB, BigQuery, and Azure SQL DB into Power BI for comprehensive reporting and analysis
- Created and optimized stored procedures and SQL queries to enhance data retrieval and reporting efficiency
- Developed DAX Queries to create computed columns and tables based on business requirements in Power BI
- Proficient in using Power BI Desktop and Tableau for data visualization, reporting, and analysis with visualizations such as bubble charts, scatter plots, geographic maps, and pie/bar charts
- Combined Python and Tableau to automate the creation and modification of dashboards, performing table-level calculations to derive meaningful insights
- Created Docker images based on Docker files and pushed them to Docker Hub repositories for streamlined application deployment and management
- Kaiser Permanente is a leading health insurance provider known for its integrated care model that combines health insurance with medical care services
- Environment: Python, Convolutional Neural Networks (CNN), Deep Belief Networks (DBN), Scikit-learn, Pandas, NumPy, Power BI, wxPython, Twisted, Matplotlib, Beautiful Soup, Hadoop, Hive, Impala, Sqoop, Firebase, SQL Server DB, BigQuery, Azure SQL DB, DAX, Tableau, Docker, Docker Hub
Programmer Analyst
McKesson
Bangalore, India
04.2019 - 09.2021
- Company Overview: McKesson Corporation is a global healthcare services, It is one of the largest healthcare companies in the world, providing a wide range of services and healthcare management solutions
- Developed and implemented predictive models for user behavior data using Machine Learning techniques on large-scale datasets
- Wrote Python scripts using Apache Spark and Elastic Search to create interactive dashboards visualized in Grafana
- Led the development of Natural Language Processing (NLP) initiatives, including the creation of chatbots and virtual assistants to enhance customer service
- Established business questions and designed SQL databases in AWS (RDS) based on key features and metrics schema
- Utilized Hadoop, HDFS, MapReduce, Hive, Pig, and Spark for managing large-scale data processing in AWS (EMR)
- Stored and retrieved vast datasets using AWS (S3) for the company’s personal marketing website
- Defined, executed, and interpreted complex SQL queries in AWS (RDS), including subqueries, joins, aggregations, and window functions to track and analyze product sales
- Defined relationships between measure groups and fact tables in the data model
- Developed data analysis prototypes using Power BI and Power Pivot, and visualized reports with Power View and Power Map
- Published Power BI reports and dashboards for web and mobile access, ensuring they remained up-to-date through Power BI Gateways
- Optimized data processing performance using partitioning and bucketing techniques in Hive
- Explored and visualized data across multiple dimensions using Power BI and Tableau
- Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services for seamless data integration
- Built and deployed a help desk chatbot using Google DialogFlow to assist in answering client questions and reduce the workload of the technical support team
- McKesson Corporation is a global healthcare services, It is one of the largest healthcare companies in the world, providing a wide range of services and healthcare management solutions
- Environment: Python, Apache Spark, Elastic Search, Grafana, Natural Language Processing (NLP), AWS (RDS), Hadoop, HDFS, MapReduce, Hive, Pig, AWS (EMR), AWS (S3), SQL, Power BI, Power Pivot, Power View, Power Map, Power BI Gateways, Tableau, Google DialogFlow
Education
Master’s - Computer Science
Wright State University
Skills
- Data Analysis & Programming
- Advanced Excel Skills
- SQL Queries
- Python (pandas, NumPy, Matplotlib, seaborn, scipy)
- R Programming
- Data Visualization
- Tableau
- Power BI
- Looker
- Big Data & Cloud Technologies
- Hadoop
- Apache Spark
- Kafka
- AWS (S3, Redshift)
- Google BigQuery
- Azure Data Lake
- ETL & Data Integration
- ETL Tools (Informatica, Alteryx, Custom ETL Pipelines)
- Machine Learning
- Machine Learning (Scikit-learn, TensorFlow)
Certification
- POWER BI CERTIFICATION
- SNOWFLAKE CERTIFICATION
Timeline
Senior Data Analyst
Huntington National Bank
02.2024 - Current
Data Analyst
Kroger
05.2023 - 01.2024
Data Analyst
Kaiser Permanente
10.2021 - 11.2022
Programmer Analyst
McKesson
04.2019 - 09.2021
Master’s - Computer Science
Wright State University
Similar Profiles
Jeff KimpanJeff Kimpan
Senior Portfolio Underwriter at Huntington National Bank/PNC BankSenior Portfolio Underwriter at Huntington National Bank/PNC Bank
Tyler AckermanTyler Ackerman
Personal Production Assistant at Huntington National BankPersonal Production Assistant at Huntington National Bank
Walter WoodsWalter Woods
Senior Manager, Vice President – Cloud Cybersecurity Risk at Huntington National BankSenior Manager, Vice President – Cloud Cybersecurity Risk at Huntington National Bank
Michael SiehoffMichael Siehoff
Vice President - Portfolio Manager III at Huntington National BankVice President - Portfolio Manager III at Huntington National Bank
HARISH KUMARESANHARISH KUMARESAN
Student Worker at Vikings MarketStudent Worker at Vikings Market