Lokitha Bhoompally

About Lokitha Bhoompally

I am a dynamic Data Analyst with 4+ years of experience in leveraging SQL, Python, and statistical tools to analyze and interpret complex datasets, driving data-informed decision-making across healthcare, finance, and IT domains. Proven expertise in developing 15+ Power BI dashboards, automating data pipelines to reduce processing time by 70%, and implementing A/B testing for actionable insights, boosting campaign effectiveness by 10%. Skilled in cloud technologies like AWS and Azure to enable scalable data solutions and streamline workflows. Adept at cross-functional collaboration, translating technical findings into strategic business outcomes, and delivering impactful insights that optimize performance and enhance decision-making.

Experience

1. Data Analyst

   Excellus BCBS

   Jun 2024 — Present · US

   Proficient in Python libraries (Pandas, NumPy, Seaborn, Matplotlib, SciPy, Scikit-learn) for data cleaning, analysis, and visualization to enhance data-driven decision-making.2. Developed a Data Layer Automation tool using Python, R, and SQL to process over 100GB of Clickstream data, reducing dashboard load times by 75% and saving 8+ hours per project.3. Created dynamic dashboards and reports using Power BI, Tableau, and D3.js, incorporating visualizations such as Pie Charts, Bar Charts, Tree Maps, Line Charts, and Scatter Plots to present actionable insights.4. Conducted A/B testing to evaluate marketing campaigns, identifying KPIs, control, and test groups, and improving customer-targeting strategies.5. Performed EDA to uncover trends and patterns, aligning insights with business objectives and supporting strategic decision-making.6. Utilized Snowflake to automate ETL workflows, significantly minimizing manual effort and improving operational efficiency by 70%.7. Collaborated with healthcare providers to enhance Medicare and Medicaid reimbursement processes, introducing workflow improvements and optimizing reimbursement rates.8. Conducted statistical analysis and Gap Analysis to address data discrepancies, ensuring reliable and accurate datasets.9. Facilitated project success by adopting Agile methodologies and implementing SCRUM practices to promote teamwork and efficiency.10. Extracted insights using SQL, Power BI DAX, Tableau, and Google Analytics to create reports supporting forecasting and identifying marketing trends.

Education

• Vardhaman College of Engineering (VCEH)

  Bachelor of Technology - BTech, Information Technology

  2016 — 2020

• University of Cincinnati

  Master's degree, Information Technology