Data Analyst Quality

RAMALINGESHWAR KONDA

DATA ANALYST

Boston MA ****3 Phone: 508-***-**** Email: ********************@*****.*** LinkedIn PROFESSIONAL SUMMARY

• Experienced Data Analyst with nearly 5 years in data analysis, specializing in Python, SQL, and R, with advanced data processing and ETL automation for streamlined workflows.

• Proficient in databases like MySQL, Oracle, MongoDB, and PostgreSQL, utilizing optimized SQL queries for data integrity and efficient retrieval.

• Expert in data visualization through Tableau, Power BI, Matplotlib, and Excel, transforming complex data into actionable insights for stakeholders.

• Hands-on experience with AWS services (EC2, S3, Lambda, IAM) to ensure secure data storage, performance monitoring, and process automation.

• Skilled in data cleaning, wrangling, warehousing, and governance, ensuring data quality, accuracy, and regulatory compliance in high-stakes environments like healthcare.

• Strong analytical skills in A/B testing and data mining, uncovering key trends in customer behavior, product performance, and healthcare outcomes.

• Competent in Agile and Waterfall methodologies, facilitating cross-functional collaboration and timely project delivery.

• Proficient with version control tools like Git, and equipped with excellent communication and presentation skills for translating complex data into meaningful insights for business decisions. TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Analyst Aug 2024 - Current

Blue Cross Blue Shield MA

• Enhanced data quality by cleansing large-scale healthcare datasets in Python, addressing duplicates, missing values, and standardization, achieving a 20% reduction in error rates and ensuring compliance with HIPAA and other healthcare regulations.

• Optimized SQL queries for claims and patient data by implementing indexing and query tuning in MySQL and Oracle databases, achieving a 30% improvement in execution times while maintaining data accuracy and integrity.

• Developed data visualizations using Matplotlib, Seaborn, and Excel, highlighting key trends in healthcare costs, patient outcomes, and insurance claims to support executive decision-making.

• Ensured patient data security by integrating AWS CloudFront and IAM roles, achieving full HIPAA compliance and utilizing CloudWatch for real-time infrastructure monitoring, reducing system downtime.

• Created interactive dashboards in Tableau and Excel to provide healthcare management with insights into operations, patient care, and resource allocation.

• Conducted resource flow analysis and project management assessments to identify inefficiencies in healthcare service delivery, enhancing resource utilization.

• Leveraged data mining and A/B testing techniques for healthcare initiatives, uncovering patterns in patient care and optimizing outreach programs through refined targeting strategies.

• Designed and implemented data governance frameworks to ensure data accuracy, consistency, and compliance across healthcare data sources, supporting reliable reporting and regulatory adherence. Programming Languages Python, SQL, R.

Databases MySQL, Oracle, MongoDB, PostgreSQL.

Libraries NumPy, Pandas, Matplotlib, Seaborn, Pytorch, tenserflow, scipy, keras, scikit learn. Cloud Technologies AWS (EC2, S3, Lambda, IAM, Cloudfront). Data Visualization Tableau, Power BI, MS Excel.

Methodologies Agile, Waterfall.

Version Control Git, GitHub.

Analytical Skills

Data Cleaning, Data Wrangling, Data Warehousing, Data Governance, Data mining, A/B Testing, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving. Data Analyst Nov 2020 – Dec 2022

KPMG India

• Automated ETL tasks by developing custom Python and SQL scripts, significantly increasing workflow efficiency and accuracy for large-scale data analysis processes.

• Utilized NumPy and Pandas for advanced data manipulation, cleaning, and transformation across large datasets, ensuring data quality and integrity throughout all stages of analysis.

• Created insightful visualizations and conducted statistical analyses using Matplotlib and SciPy, enabling stakeholders to gain actionable insights into business metrics and emerging trends.

• Used Tableau for data blending, combining data from multiple sources to deliver a comprehensive view of business operations, facilitating well-informed, data-driven decision-making.

• Optimized SQL queries by implementing indexing and query tuning techniques, improving database performance and retrieval speed, resulting in more efficient analysis.

• Leveraged AWS services like EC2 and S3 to ensure secure, scalable storage solutions, enhancing access to large datasets and reducing analysis time.

• Applied A/B testing and data mining techniques to uncover customer behavior patterns and evaluate marketing initiatives, refining strategies and driving more effective campaign outcomes.

• Effectively communicated complex analytical insights to stakeholders using Excel charts and clear presentations, aiding in strategic planning and data-informed decision-making. Technical Data Analyst Jul 2018 – Oct 2020

Vedanta India

• Generated statistical summaries and visualizations to identify key patterns and trends in civil engineering datasets, supporting data-driven project insights.

• Crafted complex SQL queries for data retrieval, filtering, aggregation, and joining across multiple databases for infrastructure project analysis.

• Utilized PostgreSQL features like partitioning, replication, and full-text search to improve query performance by 25%, enhancing data handling for structural analyses.

• Set up Oracle Data Guard and Real Application Clusters (RAC), increasing uptime and data availability by 30% for critical civil engineering projects.

• Employed Pandas for comprehensive data cleaning, handling missing values and removing duplicates from structural and geological data, improving data quality by 30% and reducing processing time by 15%.

• Designed Power BI dashboards to integrate data from sources like material quality reports and project progress, increasing report accessibility by 35% and expediting decision-making.

• Utilized advanced Excel formulas (e.g., VLOOKUP, INDEX-MATCH) for managing costs, resources, and schedules, enhancing processing speed by 25% and reducing financial reporting errors by 15%.

• Leveraged AWS S3 for secure storage of large datasets and managed structured data in AWS RDS and unstructured data in DynamoDB, ensuring data integrity and robust accessibility. PROJECT

Business Insights Adventure Works Dataset

Using the Adventure Works Dataset, a thorough Tableau project was created with dynamic sales overview, customer insights, product performance, and geographic insights dashboards. Demonstrated proficiency in analytics, business intelligence, and data visualization to deliver practical insights for well-informed decision-making. EDUCATION

Clark University Jan 2023 - May 2024

Masters of Science in Data Analytics

TKR College of Engineering and Technology Sep 2014 – May 2018 Bachelor of Technology in Civil Engineering.

Contact this candidate