Manasa Bitla

Data Analyst | Eli Lilly (Pharma & Healthcare)

Apr 2021 – Oct 2024

(3 years focused as Data Analyst)

• Designed and maintained regulatory and clinical dashboards to support FDA compliance and internal audits.
• Analyzed patient and clinical trial data, improving data accuracy and helping reduce trial delays by 20%.
• Automated data extraction and transformation using SQL and Python, reducing manual reporting effort by 50%.
• Built Power BI dashboards for R&D and sales performance, enabling leadership with real-time insights.
• Developed SQL queries using joins, CTEs, and window functions for reporting and analysis.
• Implemented data quality checks and basic anomaly detection for adverse event reporting.
• Collaborated with cross-functional teams to translate business requirements into actionable insights.
• Automated audit and reconciliation reports, improving accuracy and reducing manual effort by 60%.Developed interactive dashboards using powerBI, improving data visualization for stakeholders.

• • Designed regulatory compliance and clinical dashboards supporting FDA and internal audit requirements.
  • Conducted patient and clinical trial data analysis, improving data accuracy and reducing trial delays by 20%.
  • Automated ETL pipelines using SQL & Python, increasing reporting efficiency and reducing manual effort by 50%.
  • Built Power BI dashboards to track R&D and sales performance, enabling leadership with real-time decision support.
  • Developed SQL solutions using complex joins, CTEs, and window functions for data extraction, transformation, and
  reporting.
  • Implemented data quality checks and anomaly detection for adverse event reporting, ensuring compliance.
  • Partnered with cross-functional teams to translate business needs into insights for savings analysis and contract
  reconciliation.
  • Automated audit and reconciliation processes, improving accuracy and reducing manual time by 60%

• Designed, executed, and maintained automated test scripts using Selenium and Python, validating web and backend functionality across multiple applications.
• Prepared and queried test data using PostgreSQL, ensuring data accuracy and consistency for test scenarios and application validation.
• Built automated test frameworks and validation scripts to improve testing efficiency and reduce manual QA effort.
• Collaborated with internal teams and stakeholders to interpret test results, report defects, and verify fixes, ensuring smooth system integration and release readiness.
• Conducted cross-browser and cross-platform testing, including functional, regression, and performance checks, improving test coverage and reducing production defects.
• Supported QA efforts in customer-facing applications, simulating user workflows to identify issues that could impact data integrity, system behavior, and end-user experience.

• Skilled in software development, testing, and quality assurance with strong knowledge of SQL Server, Scala, and NoSQL databases (HBase, Cassandra).
• Proficient in automation and testing tools including Selenium, HP UFT, SOAP UI, Eclipse, and experienced in API request/response validation.
• Strong expertise in functional, regression, and performance testing, along with test/defect management tools (IBM RTC, RQM, HPQC, Star Team).
• Adept at Big Data & Mobile application upgrades, project estimation, and cross-team collaboration with excellent problem-solving and leadership skills.