Business Analyst Power Bi

Thummala J

********.****@*****.*** +1-909-***-**** United States, UNITED STATES

PROFESSIONAL SUMMARY

Business Analyst with 6+ years of experience specializing in data analysis, process optimization, and reporting for organizations in the inspection, certification, and life sciences sectors. Core expertise includes business requirements gathering, data modeling, and delivering actionable insights using tools such as Python, R, SQL, Power BI, Tableau, and ServiceNow. Skilled in ETL and data integration with platforms like SSIS, dbt, Snowflake, and Google BigQuery, supporting accurate and timely analytics for operational improvement. Adept at translating complex data into clear business solutions, facilitating communication between technical and business teams, and supporting digital transformation initiatives. Recognized for driving efficiency and data quality across cloud and on-premises environments while supporting process improvement in highly regulated and data-driven industries.

TECHNICAL SKILLS

Languages & Scripting: SQL, Python, R, .NET (C#)

Databases & Data Warehousing: SQL Server, PostgreSQL, MySQL, Snowflake, Google BigQuery, Data Modeling & Schema Design

ETL / Data Integration Tools: SSIS, dbt (Data Build Tool)

Reporting & BI Tools: Power BI, Tableau, Domo, SSRS (SQL Server Reporting Services)

Web Technologies: Blazor, React (Basic exposure for frontend integration)

Optimization & Simulation Libraries: Pyomo, PuLP, Gurobi, CPLEX, Google OR-Tools

Analytics & Observability: Snowplow, NewRelic

Domain Knowledge: Ad Tech, Credit & Lending Analytics, Health Informatics, FCRA Compliance, Bureau Data (TransUnion, Experian, Equifax)

Others: Git, Agile Collaboration, Data Governance & Documentation, API Integration & Decisioning System

Business Intelligence & Reporting: Power BI, Tableau, SSRS

Data Quality & Monitoring: NewRelic, Snowplow

Cloud Platforms: Google Cloud Platform

Service Management Platforms: ServiceNow

Data Modeling & Query Tools: SQL

Programming Languages: Python, R

WORK EXPERIENCE

SGS North America Inc, Business Analyst Aug 2023 – Present

●Gathered business requirements from environment, health, and safety teams and documented user stories to guide data analysis and reporting solutions using SQL and cloud-based data warehouses.

●Developed and optimized SQL queries and data models on Snowflake and Google BigQuery to support large-scale analytics and ensure reliable data for laboratory and monitoring services.

●Designed and maintained interactive dashboards in Power BI and Tableau to help stakeholders monitor laboratory performance, testing trends, and compliance with industry standards.

●Built and maintained ETL pipelines using dbt and SSIS to integrate, clean, and transform environmental and laboratory data for downstream reporting and analytics.

●Used Python and R to automate data validation, statistical modeling, and routine analysis workflows, supporting regulatory and quality assurance requirements in testing and inspection.

●Documented business processes and data flows, translating operational needs into clear technical specifications for analytics and reporting teams.

●Tested new analytics features and dashboard enhancements, gathering feedback from end users to ensure solutions met business and regulatory needs.

●Connected with cross-functional teams to clarify requirements, manage expectations, and facilitate communication between technical staff and business stakeholders.

●Helped develop training materials and supported end users in understanding new dashboards and data tools, focusing on usability and successful adoption.

●Monitored data quality and system performance using NewRelic and Snowplow, identifying issues and recommending improvements to maintain high standards for data-driven decision-making.

Citeline, Data Analyst May 2018 – Dec 2020

●Developed and maintained ETL workflows using SSIS to integrate and transform large volumes of clinical trial, drug development, and regulatory data for analytics platforms supporting pharmaceutical decision-making.

●Built optimized SQL queries, stored procedures, and database functions on SQL Server, PostgreSQL, and MySQL to support high-performance analytics for life sciences data and improve data accessibility for research teams.

●Created operational and analytical reports using SSRS, delivering insights on clinical trial progress, regulatory compliance, and competitive landscape to business stakeholders and analysts.

●Used Python with simulation and optimization libraries such as Pyomo and PuLP to model drug pipeline scenarios, supporting strategic planning and risk evaluation in pharmaceutical development.

●Designed and refined system requirements by working with cross-functional teams—including compliance, business, and analytics—to ensure enterprise data solutions met evolving regulatory and clinical needs.

●Enhanced front-end data tool components using Blazor and React, providing user-friendly interfaces for internal data review and business intelligence in drug development projects.

●Tested new reporting features and dashboards, collecting user feedback to validate that solutions supported regulatory documentation and day-to-day decision-making for clinical data teams.

●Documented business processes, data flows, and system features to establish clear technical specifications for ongoing enhancements and regulatory audits within the life sciences domain.

●Supported the development of user training materials and sessions focused on new reporting tools and data workflows, helping business teams adopt technology for improved clinical and operational outcomes.

●Monitored data quality and job performance in ETL and reporting systems, identifying discrepancies and proposing improvements to maintain compliance with industry standards and data integrity requirements.

Informa Data Monitor Health Care, Data Analyst Jun 2016 – Apr 2018

●Build, maintain, and enhance ETL workflows using SSIS and other ETL tools to support business intelligence and reporting needs.

●Develop automated data pipelines for ingestion, transformation, and loading of data into data warehouses or databases.

●Write and optimize complex SQL queries, stored procedures, views, and functions across multiple RDBMS platforms (SQL Server, PostgreSQL, MySQL).

●Design and maintain relational databases and data models to support integration and reporting needs.

●Develop and maintain .NET applications related to data integration workflows and system automation.

●Contribute to the design, implementation, and maintenance of data warehousing solutions.

●Leverage SSRS (SQL Server Reporting Services) to create and maintain reports and dashboards.

●Monitor, analyze, and optimize the performance of ETL processes and SQL queries.

●Debug and resolve data-related and application integration issues in a timely manner.

●Work collaboratively with frontend teams using Blazor or React to integrate data services with user interfaces.

●Support the integration of web-based reporting tools or dashboards within .NET applications.

●Prepare technical documentation for data integration flows, stored procedures, and system configurations.

●Ensure data security, quality, and compliance with internal standards and industry best practices.

EDUCATION

Master’s in Health Informatics, Health Informatics 2022 - 2023

University of Wisconsin – Milwaukee

Bachelor of Pharmacy, Pharmacy

Jawaharlal Nehru Technological University, Kakinada, India

CERTIFICATIONS

Base SAS Certification - SAS Institute

Contact this candidate