Data Analyst Analysis

Harini Vallabhaneni

*******************@*****.*** • 470-***-**** • www.linkedin.com/in/harini-vallabhaneni-591082228

Experienced Data Analyst skilled in leveraging SQL, Python, R, SAS, Power BI, ETL, and Tableau to transform complex data into actionable insights. Proficient in developing dynamic dashboards, conducting in-depth data analysis, and optimizing data models to enhance business decision-making.

EDUCATION

Master of Science, Business Analytics East Texas A&M University, Commerce, Texas December 2024

Coursework: Applied Statistics, Data Analysis and Statistics, Data management, Data Visualization and Reporting, Programming for Analytics, Grade:80

Bachelor of Technology, Electronics & Communication Engineering Sasi, Jawaharlal Nehru Technological University, Grade:3.8

Coursework: Communication Systems, Networking & Communication Protocols, VLSI, Data Structures and Algorithms, Probability, Statistics, DBMS, Signal Processing, Python Programming.

CERTIFICATIONS:

Microsoft AZURE DATA Fundamentals DP-900

WORK EXPERIENCE

Data Analyst Deloitte, Hyderabad, India Sep 2021 – June 2023

As an Analyst made an impact at prudential Insurance Project and Led a team of 3 in Group Reporting ETL and SAS, acquiring valuable managerial experience, demonstrating leadership and project management skills.

Conducted quantitative analysis and performed end to end Execution & Validation for 6 business units across several cycles in SIT & UAT using SQL and ETL processes, boosting productivity by 80% and ensured a smooth transition with data Analysis & Testing.

By Interacting with the Business and Functional team to understand new changes and gathered information for the system and worked on JIRA to upload test cases and to raise incidents.

Analyzed large data sets with SQL to identify trends and draw insights resulting 29% increase in operational efficiency.

Engineered data pipelines in Azure Data Factory, implementing custom machine learning workflows for seamless ingestion from ADW, SQL Server, and Azure Kusto’s, reducing processing time by 30%.

Created detailed Power Bl dashboards drawing from Data Cubes, ADLS Containers, Azure (Databricks, SQL DB), bringing about a 60% improvement in visualization efficiency and report generation time.

Created ETL pipelines to import aggregated data into the analytical platform from NoSQL and SQL Server databases and retrieve individual data from those databases.

Leveraged ETL tools such as SSIS and Informatica to seamlessly transform and load data from various sources, ensuring data accuracy and integrity.

Written SQL test scripts to validate data for different test cases and test scenarios.

Presented complex financial findings to non-technical stakeholders using visualizations and reports generated with Tableau and Power BI.

Collaborated with business teams to define key performance indicators (KPIs) for healthcare operations, enabling data-driven measurement of business performance.

Developed and maintained interactive dashboards using Tableau and Power BI, delivering real-time insights.

Utilized Python Libraries for data preprocessing, analysis, and visualization, enhancing the accuracy and effectiveness of insights extracted from healthcare and pharmacy data.

Proficiently utilized Excel for advanced data preprocessing tasks, including data cleansing, transformation, and complex formula implementation. Employed Excel& VBA (Visual Basic for Applications) to automate repetitive processes, enhancing efficiency in integrating diverse datasets into Tableau.

Streamlined data extraction processes by leading a team initiative, resulting in a 30% reduction in data processing time.

Data Analyst MAQ Software, Hyderabad, India Nov 2020 – Sep 2021

Monitored and analyzed operational metrics using AWS CloudWatch, identifying system performance trends, and optimizing service efficiency.

Developed and maintained SQL queries and Python scripts for data extraction, data mining, and advanced statistical modeling.

Designed and automated Alteryx workflows for data transformation, reducing manual data processing time by 40%.

Created interactive dashboards and reports using Tableau and other visualization tools to track key performance metrics and predictive insights.

Applied machine learning models such as regression analysis, clustering, and time-series forecasting to predict call volumes and enhance customer satisfaction.

Conducted sentiment analysis on customer feedback using NLP techniques to identify areas for service improvement.

Performed A/B testing and experimental design to evaluate the impact of new support strategies and optimize agent performance.

Built customer segmentation models using clustering techniques (K-Means, DBSCAN) to personalize customer support strategies.

Developed anomaly detection algorithms to flag irregular patterns and enhance fraud detection mechanisms.

Managed cross-functional projects, collaborating with customer service, IT, and operations teams to implement data-driven process improvements.

Provided actionable insights through effective verbal and written communication, delivering presentations to leadership and frontline teams.

Automated a predictive analytics dashboard, enabling real-time monitoring of customer service KPIs and reducing manual reporting time by 30%.

Implemented text mining techniques on customer interaction data, uncovering key pain points that informed a new customer service training program, improving customer satisfaction scores by 12%.

PROJECT EXPERIENCE

Gained knowledge in Verilog and Completed project “Generating symmetric key by using Cryptography” with C language.

Gained knowledge in Data Analytics and Engineering and completed project “A Data warehouse solution for Urban k pop dance studio enhancing operational efficiency and customer Insights” urbankpopdance.com with the SQl and ETL process using SSIS and SSMS transformed the data and for the visualization used to the tableau to show the findings to improve the business.

ACHIEVEMENTS

“PROGRAMMING WITH PYTHON” offered by “Internshala”

The Complete PL/SQL Bootcamp: “Beginner to Advanced PL/SQL” by “Udemy”

Internet of Things, Machine Learning and Soft Computing offered by “NPTEL.”

Tableau Essential Training Certificate by “LinkedIn”

SKILLS

Programming Languages: SQL, PL-SQL, Python (TensorFlow, pandas, NumPy, scikit-learn), R, Java, C, CSS, HTML.

Databases: MySQL, MS SQL Server, Postgres, MongoDB, Cassandra, AWS S3, Cosmos DB, Azure Databricks.

Data Engineering & Cloud & Others: JIRA, Azure Datawarehouse, SAS, MS Office, ETL / ELT, Kubernetes, Docker, Airflow, Snowflake, Alteryx, AWS Cloud Watch, A/B Testing, Git, Jenkins, SAS, SSIS, SSAS, SSRS, Agile, Scrum, Power point

Visualizations Tools: Tableau, Power BI, OTBI, Google Data Studio, Seaborn, MATLAB, Microsoft Excel,Matplotlib.

Contact this candidate