Data Analyst - Python, SQL, Power BI Expert

MEGHANA GOLLAPUDI

Mobile: +1-940-***-**** E-Mail: *******************@*****.***

LinkedIn: https://www.linkedin.com/in/gollapudi-meghana-b2929724a/ Data Analyst

SUMMARY

Data Analyst with 3+ years of experience in financial services and healthcare analytics. Expertise in Python data analysis, SQL database management, and Power BI dashboard creation. Built automated reporting systems processing 100K+ records weekly for executive decision-making. Proficient in statistical modeling and machine learning for customer behavior analysis. SKILL SET

Core Competencies

Data Mining & Analysis Business Reporting & Analytics Data Pipelines & Transformations Intelligence Gathering Project Management Business Intelligence Predictive Analytics KPI Development Cross-Functional Collaboration

Machine Learning & Deep Learning Statistical Analysis Analytical & Problem-Solving Aptitude Quantitative Analysis Database Management Data Warehousing Financial Modeling Technical Skills

Programming & Data Science Tools: Python (Pandas, NumPy, SciPy), R, SQL, PostgreSQL, MS SQL Server, Excel (Advanced), Power BI

Big Data & Cloud Platforms: Hadoop, Spark, Hive, YARN, HDFS, Cloudera (CDP), Snowflake, BigQuery, Cloud Computing (AWS, GCP, Azure)

Data Visualization & Analytics: Power BI, Excel Dashboards, Matplotlib, Seaborn, Business Intelligence Reporting

Data Engineering & Security: Data Pipelines, ETL Transformations, Application Deployment, Kerberos Authentication ACADEMIC DETAILS

Masters in Computer and Information Sciences from University of North Texas Bachelor of Computer Science and Engineering from Vignan Institute of Technology and Science, Hyderabad EMPLOYMENT DETAILS

Jan 2025 - Present: Hartford Financial Services Group, USA Data Analyst

Created automated weekly executive dashboards in Power BI tracking customer acquisition, claims processing, and revenue metrics for C-suite leadership

Implemented data validation procedures using SQL and Python to ensure accuracy of customer demographics database containing 75K+ policyholder records

Reduced reporting errors by 20% by applying advanced Excel functions and maintaining strong data integrity.

Built dynamic Excel reports with pivot tables and slicers enabling department managers to analyze regional sales performance and identify top-performing agents.

Streamlined workflows and issue tracking, reducing operational disruptions by 15% and ticket processing time by 12%. Jan 2023 - Jul 2023: Alephys LLC Texas Data Engineer – Information Technology

Created documentation for Spark job monitoring and troubleshooting processes.

Assisted senior engineers with Cloudera platform configuration and testing procedures.

Strengthened security by implementing Kerberos authentication, eliminating unauthorized access risks.

Optimized Cloudera configurations, improving query response times by 20% and overall efficiency.

Built scalable database models, enhancing data retrieval speed by 22% and supporting large-scale storage.

Resolved system bottlenecks, cutting recurring incidents by 15% and improving platform stability.

Delivered multiple projects with 100% on-time completion, demonstrating strong execution and leadership. Jul 2020 - Dec 2022: Fusion Software Technologies, India Data Analyst

Delivered 100% on-time global analytics reports by managing databases and resolving data quality issues.

Partnered with clients to meet scheduled and ad-hoc reporting needs, cutting turnaround time by 12%.

Analyzed datasets to generate actionable insights that supported strategic business decisions.

Built advanced Excel models to automate data retrieval, reducing manual effort by 20%.

Performed data transformations and validations, improving report accuracy by 15%. MAJOR PROJECTS

Credit Risk Analysis Dashboard: Analyzed 50K+ loan applications using Python and SQL to identify default risk patterns. Created Tableau dashboard enabling loan officers to assess risk scores 60% faster. Used logistic regression to predict default probability with 85% accuracy, supporting $2M in loan decisions monthly.

E-Commerce Dashboard: Designed interactive dashboards by compiling large datasets, providing insights to guide community engagement and mental health awareness initiatives.

Netflix Dashboard: Developed a dashboard to analyze Netflix content by extracting, cleaning, and preparing datasets, enabling deeper insights into viewing trends.

ACADEMIC PROJECTS

IOT Robot for Queue Monitoring, Blood Donation & Donor Management System, Farmers Friend Application, Student Management System

Contact this candidate