Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rishi Vemulapalli

New Hudson,MI

Summary

A highly skilled and detail-oriented BI Developer with over 7 years of experience in business intelligence development and data migration, skilled in building, validating, and deploying interactive dashboards using Power BI and Qlik Sense. Extensive experience in managing data migrations from Teradata to Google BigQuery (GBQ), and PostgreSQL, and in automating reporting processes. Proficient in Python scripting, SQL, and BI reporting tools, with a strong track record of streamlining reporting workflows, and ensuring data accuracy across platforms. Adept at transforming complex business requirements into actionable insights, and providing valuable decision-making support to stakeholders.

Overview

7
7
years of professional experience

Work History

BI Developer

Ford Credit
Dearborn, MI
05.2024 - Current
  • Coordinated data migration projects, managing the migration of reports from Teradata to Google BigQuery (GBQ), and PostgreSQL.
  • Performed row-level and count validations using the DVT tool to ensure data consistency between Teradata and GBQ.
  • Developed an automated web scraping solution using Python (Selenium packages) to download WebFOCUS reports, and integrated the automation scripts with Git for version control.
  • Built and implemented a Python-based PDF and Excel report validation framework using OpenCV, NumPy, pdf2image, Poppler, and Pandas, enabling pixel-to-pixel image comparisons and detailed row and column validations; maintained documentation on SharePoint.
  • Conducted unit testing on WebFOCUS reports, identifying discrepancies and impediments between Teradata and BigQuery environments.
  • Created sample procedures for InfoAssist business view validation in non-production environment.
  • Created and managed ReportCaster schedules for automated email and FTP report deliveries to higher environments during migration phases.
  • Validated WebFOCUS portals for standard reports, and authored comprehensive Unit Test (UT) documentation.
  • Utilized Beyond Compare and Spreadsheet Compare tools to validate PDF and Excel report accuracy in non-production environments.
  • Performed code enhancements and fixes in WebFOCUS to accommodate changes resulting from data migration to GBQ and PostgreSQL.
  • Supported production migration activities, resolving bug files, and implementing enhancements post-go-live.
  • Validated QlikSense reports during the development phase using QlikSense Desktop to ensure data accuracy and dashboard functionality.
  • Conducted post-development validations in the QlikSense SaaS-based pre-production environment, ensuring compliance with business requirements.
  • Deployed validated QlikSense dashboards and reports to production environments, coordinating with business and DevOps teams.
  • Performed Power BI report validation, ensuring that data models, DAX measures, and visualizations accurately reflected source data and met business KPIs.
  • Worked on bug fixes and performance optimizations in Power BI dashboards before production deployment.

BI Developer

Centene
, MO
01.2023 - 05.2024
  • Developed and maintained WebFOCUS solutions using App Studio, InfoAssist, Business Views, and Portals for data visualization and reporting.
  • Led the migration of reporting solutions from WebFOCUS to QlikSense, ensuring a seamless transition of reports and dashboards, with minimal disruption to business processes.
  • Developed QlikSense dashboards to enhance data visualization and provide interactive, intuitive reporting for business users.
  • Designed and implemented GCP services, including Compute Engine, Cloud Storage, Cloud SQL, BigQuery, and Cloud Functions, to streamline data processing and reporting workflows.
  • Managed CI/CD pipelines and automated deployments using Terraform and Tekton.
  • Applied data modeling expertise to ensure accurate data representation and optimized performance across business domains.
  • Built and maintained ETL pipelines in Airflow on GCP, automating daily data jobs, and simplifying legacy SQL for improved scalability.
  • Implemented data ingestion using REST APIs with Python, integrated data pipelines into BigQuery, and optimized data flows.
  • Performed Power BI report validation, ensuring that data models, DAX measures, and visualizations accurately reflected source data and met business KPIs.
  • Worked on bug fixes and performance optimizations in Power BI dashboards before production deployment.

BI Developer

PEAPOD DIGITAL LABS
10.2021 - 01.2023
  • Developed and maintained QlikSense dashboards to track customer experience metrics, providing key insights to management for improving customer satisfaction.
  • Collaborated with stakeholders to translate business requirements into QlikSense dashboards, enhancing data accessibility, and enabling self-service analytics.
  • Migrated legacy reports to QlikSense, optimizing data models for better performance and scalability.
  • Built big data pipelines using Sqoop, HQL, Pi-Spark, and Oozie, migrating pipelines to Google Cloud BigQuery.
  • Implemented Airflow DAGs for automating daily ETL tasks and enhancing pipeline reliability.
  • Developed executive dashboards using Tableau, QlikView, and other BI tools to deliver critical business insights.
  • Managed AI/ML projects to derive predictive metrics, building large datasets for experimentation.

WebFOCUS Reports Developer

Foothills Bank
06.2018 - 08.2021
  • Developed and maintained WebFOCUS reports using Developer Studio to meet business objectives in the Sales and Marketing domain.
  • Designed dynamic WebFOCUS dashboards to provide real-time insights into Sales, Marketing, and Financial performance.
  • Implemented WebFOCUS Managed Reporting Environment (MRE) to streamline reporting processes and provide self-service capabilities.
  • Collaborated with data warehouse teams to integrate data sources into WebFOCUS for accurate reporting.
  • Conducted unit testing and validation of WebFOCUS reports, ensuring data integrity and report accuracy.
  • Developed WebFOCUS ReportCaster schedules to automate report distribution and ensure timely delivery.

Education

Master of Science - Computer And Information Sciences

University of Bridgeport
Bridgeport, CT
12-2022

Skills

BI & Reporting Tools: Power BI, QlikSense (Desktop & SaaS), WebFOCUS App Studio (v82, v83), ReportCaster, QlikView, Tableau, Alteryx

Data Integration & ETL Tools: Informatica, DataStage

Programming & Scripting Languages: Python, Java 20, JavaScript, HTML, XML, Focus, PL/SQL

Databases & Cloud Platforms: Google BigQuery, PostgreSQL, Teradata, Oracle, DB2, SQL Server 2000/2005, Hadoop, Google Cloud Platform (GCP)

Operating Systems: DOS, Windows, AIX Unix

Data Modeling Tools: Oracle Designer, Erwin

Validation Tools: Beyond Compare, Spreadsheet Compare, DVT

Version Control & Collaboration: Git, SharePoint, Jira

Timeline

BI Developer

Ford Credit
05.2024 - Current

BI Developer

Centene
01.2023 - 05.2024

BI Developer

PEAPOD DIGITAL LABS
10.2021 - 01.2023

WebFOCUS Reports Developer

Foothills Bank
06.2018 - 08.2021

Master of Science - Computer And Information Sciences

University of Bridgeport

Similar Profiles

CREATE PROFILE
Rishi Vemulapalli