Summary
Overview
Work History
Education
Skills
Proficiencies
Timeline
Generic

Venkata Yeluri

Clarksburg,MD

Summary

Analytical professional with many years of experience building business strategy and developing creative plans for success. Data-driven expert in software built for cutting-edge metric analysis. Detailed report generator surveying and synthesizing sales data in record time.

Overview

16
16
years of professional experience

Work History

Data Analytics and BI Specialist

EVERSANA
Yardley, PA
01.2020 - Current
  • Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
  • Maintained a library of standard reports used across all departments within the organization.
  • Extensive experience with Power BI for creating interactive dashboards and data visualizations.
  • Proficient in integrating Power BI with various data sources, optimizing DAX queries, and managing workspace environments.
  • Skilled in using Power Automate to streamline workflows, automate data processes, and connect systems effectively.
  • Expertise in Report Builder for generating custom reports, designing parameterized reports, and managing SSRS environments.
  • Advanced knowledge of database administration tasks, including performance tuning, backup/restoration, indexing strategies, user and role management, and stored procedure development.
  • Oracle: Experience in PL/SQL development, database performance optimization, schema management, and troubleshooting.
  • Proficient in database management tasks, including collection indexing, replica set configuration, backup and recovery, and query optimization.
  • Skilled in connecting and consuming RESTful APIs for data extraction, automation, and integration with reporting tools and databases.
  • Proven ability to handle user access control, manage data security policies, monitor database health, and ensure compliance with organizational IT standards.
  • Proficient in Python for data analysis, ETL processes, automation scripts, and API integrations.
  • Created complex SQL queries to analyze and report on large datasets.
  • Provided technical support for existing reports, dashboards or other tools.
  • Developed and maintained data warehouses, data marts, and operational databases.
  • Researched best practices related to Business Intelligence techniques and strategies.
  • Participated in design reviews for proposed changes to BI architecture.
  • Coordinated with external vendors to ensure successful delivery of software components within deadlines.
  • Used Python processes and validation between Excel and databases to create a data feed and place files in S3 and SFTP.
  • Skilled in libraries such as Pandas, NumPy, SQLAlchemy, and PyMongo for data manipulation and database operations.

Solution Architect

Dexcom
San Diego, CA
10.2024 - 01.2025
  • Data pipeline project creates data extracts from the SQL server, providing a daily incremental data feed across CBK, Rebates, and Medicaid.
  • Developed a process in Python for an end-to-end solution and uploaded files to the AWS S3 location.
  • Created 3 data pipeline processes: CBK, Rebates, and Medicaid, adding error handling and logging.
  • Developed SQL Server stored procedure for rebates in order to control much volume and customer logic.
  • One-time process historical data for a period of 2 years.
  • Purpose of data extraction for Tableau reporting.

Data Analytics and BI Specialist

Gilead
Foster City, CA
02.2024 - 08.2024
  • Created or reviewed technical design documentation to drive accuracy of reporting solutions.
  • Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
  • BRG upgrade project moving from processing environment to MN environment.
  • The enhanced tableau CE monitoring report modifies the underlined object pointing to MN, the starburst environment, and updates the SQL logic to the current upgrade.
  • Redesign the Tableau DPI dashboard, adding new requirements, and ensuring all data is coming from the Starburst environment.
  • Created complex SQL queries to analyze and report on large datasets.
  • Synthesized current business intelligence or trend data to support recommendations for action.

Solution Architect

Teva Pharmaceuticals
Parsippany, NJ
01.2023 - 02.2024
  • 2023 MDM Clean Up Product, Pricing, Trading Partner, and GP Pricing.
  • All cleanup activities happen through a custom Oracle stored procedure.
  • All NDC9 and NDC11 product cleanups across 21 attributes have been completed across 2,100 NDCs.
  • COT cleaned up across active customers' sales over the last two years on CBK and rebates.
  • Created a deployment script that can be used to deploy easily and log creation during deployment.

Data Analytics and BI Specialist

Gilead
Foster City, CA
06.2022 - 12.2022
  • BRG implementation project into the processing environment.
  • Building an interface between Model N, validating, and BRG covering entity files into the processing environment.
  • Applying the hashing binary algorithm to validate transaction outbound files, moving data into the processing environment.
  • Identifying duplicate records D0, sending back to Model N Validata from the processing environment.
  • Developed Tableau reports on 340B, which save the reconciliation process for manufacturers across PBM.
  • End-to-end interface development implemented in Oracle and OpenJDK.

Data Analytics and BI Specialist

Sanofi
Bridgewater, NJ
01.2021 - 06.2022
  • RMGP upgrade integration from the Sanofi pasture system into the Sanofi Model N revenue management system.
  • Providing guidance, design, and development in reporting.
  • Reviewing reporting design documents as part of migration.
  • Review the overall development, customer report design, and provide solutions.
  • Migrate the APP server and Cognos server into the Sanofi AWS cloud.
  • Developed and maintained data warehouses, data marts, and operational databases.

Lead Consultant

Biogen
Cambridge, MA
05.2020 - 12.2020
  • Involved in the GP unbundling project implemented with Apex and the backend Oracle.
  • Created a contract master SQL query for GP unbundling.
  • Created import package loading target tables, data into unbundling tables.
  • Developed Oracle PL/SQL packages and procedures for unbundling the project.
  • Modified AMP reports from NDC-11 to NDC-9.
  • Provided the Medicaid detail SQL query for reconciliation.
  • Addressed managed care and chargeback report issues.
  • Migrated all Cognos time zone report issues on Model N cloud.
  • Supported day-to-day RM, GP, and Medicaid operations in a timely fashion.

Data Analytics and BI Specialist

Lifescan
Milpitas, CA
01.2020 - 05.2020
  • Created a managed care detail report in Cognos.
  • Created a Validata reconciliation report for KPMG.
  • Address existing reports, performance issues.
  • Created a lot of SQL queries for audit purposes.

Lead Consultant

Genentech Inc.
South San Francisco, CA
07.2019 - 01.2020
  • Developed Cognos 11 reports for price type BPR, AMP, ASP, NM state reporting, and NFAMP reporting.
  • Utilizing JavaScript within Cognos Reports to enhance both prompt and report output functionality.
  • Created JavaScript in Cognos for expanding and collapsing reports.
  • Development of GP reports allows the business to drill out directly from Cognos Reports into the Model N Flex system to allow for greater analysis.
  • Development of GP reports allows the business to drill down directly from the Model N Flex system into custom-built Cognos reports.
  • Created complex, custom GP UI alerts in the GP application by using XML files.
  • Created backend database GP alerts.
  • Created test scripts to find differences between reports run in Model-N’s Flex 7.10.

Lead Consultant

Amneal Pharmaceuticals.
Bridgewater, NJ
03.2019 - 07.2019
  • Gathered GP report requirements, and designed and developed BP reports.
  • Developed Cognos 11 reports for price types BPR and BPI reporting.
  • Created complex Oracle SQL as per report needs.
  • Supported the upgrade of Flex GP, which required developing test scripts, and diagnosing and resolving complex issues.
  • Assisted with the upgrade from Cognos 10 to Cognos 11, where issues were identified, documented, resolved, and retested.

BI Consultant

Teva Pharmaceutical.
North Wales, PA
01.2019 - 03.2019
  • Gathered requirements for MDM, chargebacks, rebates, contracts, Medicaid, and direct sales for testing BO.
  • Doing testing on RM data using the following tools: (BO), BI for Excel.
  • Created a lot of SQL test scripts to evaluate BO reports.
  • Created test scripts between Flex and BO for UAT.

Lead Consultant

Sanofi.
Bridgewater, NJ
12.2016 - 12.2018
  • Involved in gathering and analyzing requirements, and preparing the specification document as per the business requirement.
  • Involved in the complete software development life cycle (SDLC).
  • Migration Project (SURF): Cars to Model N Flex Upgrade.
  • Migrated PBC, UBC, and MDM reports from CARS to Model N FLEX.
  • New development in Cognos 11.0.5 from Impromptu and Cognos 10 reports.
  • Created over 140 reports in Cognos 11.0.5.
  • Created complex package reports, Claim package, and Admin Fee package reports in Cognos 11.0.5.
  • Designed metadata models using Framework Manager, and published packages to the Cognos connection.
  • Setting up cardinality (minimum, maximum, and optional), determinants to avoid double counting, supporting loop joins, optimizing data sources, and identifying dimensions and facts.
  • Created complex reports with advanced features such as master-detail relationships, conditional formatting, render variables, drill-through definitions, filters, prompts, page sets, page breaks, and bursting using Report Studio.

BI Consultant

Impax Laboratories Inc.
North Wales, PA
06.2016 - 12.2016
  • Involved in gathering and analyzing requirements, and preparing the specification document as per the business requirement.
  • Involved in the complete software development life cycle (SDLC).
  • Working on the Chargeback and Managed Care Report.
  • Working on the CARS/Revitas data model, and I have many systems.
  • Working on Master Data, Contract, Submissions, Adjudications, and Settlements in many cars.
  • Working on the user interface for chargebacks and rebates.
  • Created cubes for a large volume of data, and created reports in Workspace Advanced.
  • Created a complex tech pops dashboard using Active Reports.
  • Created different data source connections: BW, Oracle, SQL Server, and flat files to create a dashboard.
  • Worked on a separate set of data: SAP, Concur, Plan365, Cars, and GTN.
  • Loaded a large volume of flat files into the database by using DataStage.
  • Created complex SQL and loaded data into the SQL Server by using DataStage.
  • Implemented various server jobs in DataStage.
  • Created portal pages and provided user access.
  • Created security roles in Cognos administration.
  • Implemented patches to Cognos 10.2.1.
  • Created materialized views for a large volume of data.
  • Moved reports from development to testing, and testing to the production server.
  • Provided administration support and development support for development and production issues.

Flex BI Consultant

Allergan.
Irvine, CA
02.2012 - 05.2016
  • Involved in gathering and analyzing requirements, and preparing the specification document as per the business requirement.
  • Working on the Chargeback and Managed Care Report.
  • Working on the CARS/Revitas data model, and I have many systems.
  • Working on Master Data, Contract, Submissions, Adjudications, and Settlements in many cars.
  • Working on the user interface for chargebacks and rebates.
  • Involved in the complete software development life cycle (SDLC).
  • Created metadata model using Cognos 8.4, 10.2 Framework Manager.
  • Designed metadata models using Framework Manager, and published packages to the Cognos connection.
  • Created row-level securities for all framework structures.
  • Created prompts, cascading prompts, conditional variables, and bookmarks with multiple report pages and multiple prompt pages in Report Studio.
  • Created some active reports in managed care reports.
  • I have been involved in creating cubes using Transformer.
  • Developed various reports: MTD, QTD, YTD, last fiscal year, and current fiscal year reports.
  • Used SQL query (DDL, DML, PL/SQL), stored procedures, functions, and triggers.
  • Created materialized views for a large volume of data.
  • Moved reports from development to testing, and testing to the production server.
  • Provided administration support and development support for development and production issues.

Cognos Developer/Oracle Developer

CVS Caremark.
Detroit, MI
09.2011 - 02.2012
  • Created detailed Cognos technical documents based on Cognos architecture and functional requirement specifications (FRS), and system use cases (SUC).
  • Gathered business requirements, performed data analysis, created mapping documents, and conducted code reviews.
  • Performed source-to-target data mapping.
  • Designed and managed physical and logical data models of enterprise data warehouses, data marts, and operational data stores.
  • Created and maintained technical and project documentation according to the established standards, implementing reports and models based on detailed technical design documents and architecture.
  • Analyzed the data and created standard list reports, crosstab reports.
  • Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
  • Used SQL query (DDL, DML, PL/SQL), stored procedures, functions, and triggers.

Cognos/Oracle Developer

The Beacon Mutual Insurance Company
Detroit, RI
04.2009 - 09.2011
  • Interacted with end users to identify key dimensions and measures that were relevant quantitative metrics in the analysis.
  • Worked efficiently as a collaborator and interacted well with the ETL Architects and Database Architects in challenging and solving the issues.
  • Collecting the metadata and creating models using the Framework Manager.
  • Created relationships between tables and created different layers, like the database layer, business layer, and dimensional layer.
  • Created packages and published them for Report Studio reporting.
  • Created detailed business reports using Report Studio, and ad-hoc reports using Query Studio.
  • Assigned security at various levels: package level, data level, object level.
  • Built models using Framework Manager, a ReportNet tool.
  • Scheduling large amounts of jobs, such as reports or event notifications.
  • Tested and improved report performance.

Education

Master of Science - Electrical, Electronics And Communications Engineering

San Francisco Bay University
Fremont, CA
01-2010

Skills

  • Oracle SQL
  • PL/SQL
  • T-SQL
  • SQL Server
  • Python
  • Pandas
  • IBM Cognos Analytics
  • Framework Manager
  • Cognos Connection
  • Power BI
  • Power Automate
  • Report Builder
  • Power BI Admin
  • Tableau
  • Tableau Admin
  • Business Objects
  • IBM DataStage
  • Informatica PowerCenter
  • Model N
  • Revitas
  • MS Visio
  • Windows
  • Linux
  • UNIX
  • PL/SQL Developer
  • Toad for Oracle
  • SQL Server Management Studio
  • Microsoft Office 365
  • SharePoint
  • Teams
  • Git
  • JIRA
  • Confluence
  • Data warehousing
  • Data modeling
  • Business intelligence analysis
  • BI tools expertise
  • Business analysis
  • Data analysis
  • Data operations
  • Custom reporting
  • Data security
  • SQL programming

Proficiencies

Oracle SQL, PL/SQL, T-SQL (SQL Server), Python, Oracle Database (19c, 12c, 11g, 10g, 9g), SQL Server (2019, 2017, 2014), IBM Cognos Analytics (11.x), Power BI, Tableau, Business Objects (SAP BO Web Intelligence), Tableau Desktop, Tableau Server, Power BI, Power Automate ,Report builder, IBM DataStage, Informatica PowerCenter, Python-based ETL pipelines, Model N, Revitas, MS Visio, Windows (10, 11), Linux (Ubuntu, Red Hat), UNIX, Oracle SQL Developer, PL/SQL Developer, Toad for Oracle, SQL Server Management Studio (SSMS), Microsoft Office 365, SharePoint, Teams, Git, JIRA, Confluence

Timeline

Solution Architect

Dexcom
10.2024 - 01.2025

Data Analytics and BI Specialist

Gilead
02.2024 - 08.2024

Solution Architect

Teva Pharmaceuticals
01.2023 - 02.2024

Data Analytics and BI Specialist

Gilead
06.2022 - 12.2022

Data Analytics and BI Specialist

Sanofi
01.2021 - 06.2022

Lead Consultant

Biogen
05.2020 - 12.2020

Data Analytics and BI Specialist

EVERSANA
01.2020 - Current

Data Analytics and BI Specialist

Lifescan
01.2020 - 05.2020

Lead Consultant

Genentech Inc.
07.2019 - 01.2020

Lead Consultant

Amneal Pharmaceuticals.
03.2019 - 07.2019

BI Consultant

Teva Pharmaceutical.
01.2019 - 03.2019

Lead Consultant

Sanofi.
12.2016 - 12.2018

BI Consultant

Impax Laboratories Inc.
06.2016 - 12.2016

Flex BI Consultant

Allergan.
02.2012 - 05.2016

Cognos Developer/Oracle Developer

CVS Caremark.
09.2011 - 02.2012

Cognos/Oracle Developer

The Beacon Mutual Insurance Company
04.2009 - 09.2011

Master of Science - Electrical, Electronics And Communications Engineering

San Francisco Bay University

Similar Profiles

CREATE PROFILE
Venkata Yeluri