Data Analyst Machine Learning

SATYA RUDRARAJU

*****.****@*****.*** 470-***-**** LinkedIn

Data Analyst Highly Analytical Data Analyst with 5+ years of experience extracting, transforming, and visualizing data to drive business insights. Expertise in SQL, Python, Tableau, Excel (including VBA), and statistical modeling. Proven success in designing reporting tools, streamlining data pipelines, and delivering high-impact business solutions in fast-paced environments like Johnson & Johnson.

PROFESSIONAL EXPERIENCE

Data Analyst, Jhonson & Jhonson New York, NY Aug ‘2023 - Present

Skills – Python, SQL, MySQL, Pandas, NumPy, SciPy, and Matplotlib, Tableau, Excel, KPI, Agile frameworks, VBA, AWS S3, Redshif

●Participated in all stages of the SDLC within Agile frameworks.

●Analyzed transactional data using SQL and Excel, identifying trends and performance gaps.

●Created machine learning models using Python libraries such as Pandas, NumPy, SciPy, and Matplotlib.

●Built data visualizations and dashboards in Tableau to monitor KPIs, leading to a 38% improvement in landing page conversion rates.

●Automated data ingestion workflows using AWS Glue and integrated datasets from S3 into Redshift.

●Built scalable ETL pipelines using PySpark and AWS Glue to process large datasets.

●Wrote and optimized SQL queries for data retrieval from MySQL and SQL Server databases.

●Managed data cleaning, wrangling, modeling, and interpretation to deliver actionable insights.

●Built Excel-based reporting tools using advanced formulas, pivot tables, and VBA macros for real-time tracking and visualizations.

Data Analyst, TechTastic LLP Hyd, IND May ‘2018 - Feb ‘2021

Skills – Python, SQL, Power BI, Waterfall methodology, Excel, Data Warehousing

●Followed the Waterfall methodology to meet strict project deadlines.

●Managed large-scale data mining efforts, writing complex SQL joins, views, and stored procedures to support BI reporting needs.

●Developed Python automation scripts for data processing and testing.

●Designed interactive data stories in Google Collaboratory using Python and its analytical libraries.

●Published and refreshed Power BI reports, managing workspaces and apps efficiently.

●Created stored procedures and complex SQL views using joins for optimized data querying.

●Performed extensive data wrangling, including merging datasets, removing duplicates, handling nulls, and detecting outliers.

PROJECTS

Marketing Campaign Analysis Python, Tableau, SQL

●Conducted a detailed analysis of customer engagement data from a multi-channel marketing campaign.

●Cleaned and transformed raw datasets using Pandas and SQL for accurate insights.

●Built a machine learning model to predict customer conversion rates with 82% accuracy.

●Created an interactive Tableau dashboard to visualize campaign performance, helping stakeholders identify the most effective channels.

Sales Performance Dashboard SQL Server, Power BI, Angular J.S

●Developed an automated Power BI dashboard to track regional sales trends and KPIs in real-time.

●Used SQL Server to write stored procedures and views to provide fast, structured access to sales data.

●Incorporated dynamic filters and drill-down options to help leadership make informed strategic decisions.

●Developed dashboards to help executives make strategic decisions based on regional sales trends and KPIs.

Customer Churn Prediction Python (Pandas, SciPy, Matplotlib), MySQL

●Analyzed customer usage data to identify churn patterns using statistical and machine learning techniques.

●Performed data wrangling and exploratory data analysis in Python; visualized findings with Matplotlib and Seaborn.

●Created and evaluated predictive models (Logistic Regression, Random Forest) to reduce churn by 15%.

TECHNICAL SKILLS

Methodologies: SDLC, Agile, Waterfall

Languages: Python, R, SQL, Angular

IDEs: Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2

Visualization Tools: Tableau, Power BI, Microsoft Excel

Databases: MySQL, SQL Server

Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving

Operating Systems: Windows, Linux

EDUCATION

Master’s in computer science – St. Leo University Aug ‘2021 - May ‘2023

Bachelor’s in computer science – Amrita Vishwa Vidyapeetham Jun ‘2014 - May ‘2018

Contact this candidate