Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Timeline
Generic
SRI CHARAN REDDY

SRI CHARAN REDDY

Manager BI Data Engineer
Secaucus,NJ

Summary

Insightful and results-driven Manager with extensive experience in analysis, design, and development within Business Intelligence (BI) technologies. Proven track record of leading teams of Data Analysts and Engineers, particularly in the healthcare sector. Skilled in managing data workflows and pipelines using tools such as Apache Airflow, DBT, Salesforce CRM, Oracle NetSuite, and SQL Server. Expertise includes database integration, BI solution development, data modeling, database administration, DevOps practices, and version control systems. Recognized for strong analytical, interpersonal, and communication skills.

Overview

12
12
years of professional experience
1
1
year of post-secondary education

Work History

Manager BI Data Engineer

Zelis
Morristown, NJ
11.2023 - Current
  • Manage and coach a team of BI Analysts and provide scalable results for the business stakeholders
  • Create meaningful insights using various workflows and multiple technologies
  • Create portal for the client reporting requests using Sigma which acts as a self-service tool
  • Propose, document, and implement new business metrics for SLT and ELT reviews
  • Define rules for data transformation and loading
  • Process Pendo data and create workflows, pipelines using Azure DevOps and DBT
  • Design and implement automated infrastructure for data extraction, computation, processing, and distribution using Snowflake and DBT
  • Take ownership of end-to-end delivery of core engineering responsibilities
  • Collaborate with various teams to deliver internal reports and visualizations
  • Establish best practices and manage ETL workflows in Airflow using Python
  • Create EC2 instances for various developments
  • Manage Jira board for Agile methodology and documentation

BI Data Engineer

Zelis
Morristown, NJ
05.2021 - 10.2023
  • Process Avro files in AWS S3 and load into Snowflake using Azure DevOps
  • Develop complex SQL procedures and functions for Power BI and SSRS reporting
  • Create data modelling techniques for reports used by SLT, ELT
  • Implement data pipelines using Airflow and create scalable pipelines
  • Prepare and modify datasets to support reporting
  • Engage with leadership for requirements gathering
  • Create audit mechanisms for report delivery
  • Schedule cron jobs for report generation
  • Create calculated measures in Power BI for ROI analysis
  • Automate SSRS reports delivery
  • Optimize T-SQL and Python code

BI Data Engineer

MDX Medical Inc
01.2019 - 05.2021
  • Gather requirements from stakeholders for performance and incentive reports
  • Create a new data warehouse in Postgres and migrate data
  • Create local environments using Docker for ETL operations
  • Collect client's data and load into S3
  • Automate and maintain ETL pipelines using Airflow
  • Create staging environment using SSIS for migration
  • Create multiple workflows and pipelines using Apache Airflow
  • Automate server setup using Vagrant and Virtual Box
  • Deploy SSIS packages
  • Develop complex SQL procedures for SSRS reports
  • Create and automate dashboards and reports using Power BI

SQL Server BI Developer

Baanyan Software Services
03.2018 - 12.2018
  • Participate in development meetings for business analysis and requirements
  • Work on SSIS packages development and performance tuning
  • Build and manage SSRS, Tableau, Power BI reports
  • Use DAX for reports and tabular models
  • Implement row-based security in SQL Server Tabular Models
  • Test SQL statements and perform index analysis
  • Use AWS infrastructure for reports administration

BI Developer

EPE Innovations
01.2017 - 03.2018
  • Create stored procedures, views, SSIS packages for database updates
  • Schedule automated updates using Jenkins
  • Create SSRS reports and deploy on SharePoint server
  • Create Power BI dashboards and measures using DAX
  • Analyze and utilize provider and tax filer data
  • Deploy updated reports using SharePoint server and gateway

Sql Server BI Developer

IETE
09.2013 - 11.2015
  • Developed complex T-SQL queries, stored procedures, and database objects
  • Transformed data from MS-SQL Server 2008R2 to MS-SQL Server 2012 using OLE DB connection by creating various SSIS packages
  • Designed and deployed SSIS packages using various Transformations such as Multicast, Merge
  • Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations

Education

Master of Science - Computer Science

University of Central Missouri
Missouri City, MO
01.2016 - 05.2017

Skills

  • Airflow

  • Apache

  • AWS

  • AWS Redshift

  • AWS S3

  • Azure

  • Azure Devops

  • Bash

  • C#

  • Cognos

  • CRM

  • CSS

  • DAX

  • dbt

  • Docker

  • EC2

  • ECS

  • ETL

  • GCP

Accomplishments

  • Enhanced Reporting Efficiency
  • Increased report efficiency by 50% by creating a self service tool for clients using Sigma
  • Team Leadership Success
  • Led a team of 3 BI Analysts and Data Engineers , resulting in a 30% productivity boost.
  • Pipeline Implementation Success
  • Implemented scalable pipelines, improving data processing speed by 40% using Airflow and DBT
  • Data Warehouse Migration
  • Migrated Postgre and SQL Server databases to snowflake

Timeline

Manager BI Data Engineer

Zelis
11.2023 - Current

BI Data Engineer

Zelis
05.2021 - 10.2023

BI Data Engineer

MDX Medical Inc
01.2019 - 05.2021

SQL Server BI Developer

Baanyan Software Services
03.2018 - 12.2018

BI Developer

EPE Innovations
01.2017 - 03.2018

Master of Science - Computer Science

University of Central Missouri
01.2016 - 05.2017

Sql Server BI Developer

IETE
09.2013 - 11.2015

Similar Profiles

CREATE PROFILE
SRI CHARAN REDDYManager BI Data Engineer
Want your own profile? Create for free at Zety.com