Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Data Modeling
Etl Tools
Databases
Statistical
Ehr Dbs
Automation
Cloud
Awards Activities
Training Seminar Conferences
Visualization Tool
Personal Information
Affiliations
Certification
Languages
Work Availability
Timeline
RAJ JANNAVARAPU

RAJ JANNAVARAPU

Frisco,TX
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Summary

Detail-Oriented technology passionate and committed to improving strategic direction of the organization by identifying opportunities, creating, and implementing data driven strategies that generate revenue and enhance quality improvement/initiatives. Design and implement reporting/statistical/predictive modeling utilizing diverse sources of Health Care/ Pharmaceutical/Retail/Financial data that draw appropriate conclusions and actionable strategies.

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy and transform data into actionable intelligence. Capable of turning analytical findings into storytelling impactful dashboards that influence the direction of risk management and marketing strategies. Proven ability and affinity for problem solving, enabling business growth and opportunity through technology, and big picture vision for long term sustainability.


Overview

17
17
years of professional experience
7
7
Certification

Work History

Sr. BI Solutions Architect/ Developer/ Admin

CVS Healthcare
06.2023 - Current
  • Participation in BI systems life cycle from requirements analysis through BI Application implementation.
  • Managing monitored BI application systems for high level of availability in system resources.
  • Managed installation, upgrade and deployment projects and provided on-site direction for BI engineers.

Principal BI Engineer/ Architect

Christus Health/ Denovo
10.2015 - 05.2023
  • Responsible for design and architecture of high performing BI Health Applications to analyze and proactively identify participation of members of the product across timeliness
  • Designed a Ticket Ship Arrivals Application that would replace the current ticket shipping application through Power Apps and Power BI Visualizations
  • Developed reporting platform with 345 reports, 10 Executive directors Dashboards and Scorecards using Clinical data models using power query, power pivot, external data sources, REST API’s optimizing queries, and data sets for excellence
  • Delivered critical complex Dashboard with proof of concept and demos to Business users providing a clear and precise understanding of the desired application for NAC Customer Corp Accounts Team at Interstate Batteries client
  • Responsible for providing the Architecture required to support the out-of-box functionality that the dashboard needs to provide on-the-fly aggregated calculations on Azure data lake
  • Architected aggregated logical design for self-serving environment allocating efficient reporting across National Analytics Corp (NAC) groups using Power BI for Operational and MicroStrategy for self report builder
  • Environment: AWS S3, Power BI, PostgreSQL, Mongo DB, Hadoop, Hive, Impala, MicroStrategy

BI Solutions Architect

MedAssets
08.2014 - 10.2015
  • Deployed BI solutions as actionable insights to Interactive Hospital Information Products- AR Analytics/Payor Analytics and Denial Analytics
  • Architected Payor Analytics applications to provide support to Claims department, Case Management, Reimbursements, Payments to identify the useful patterns and obtain insights to adjust the services accordingly
  • Implemented and supported 5 main types of Healthcare Analytics like Descriptive, Diagnostic, Predictive, Prescriptive and Discovery Insights Dashboards
  • Architected Denial and Revenue Cycle Analytics applications providing insights with KPI’s like Remittance % by Insurer, Increasing Recovery % by prioritizing accounts, Timely Resubmissions with accuracy 98% and Accelerating Cash Flow with lower A/R Days
  • Environment: Oracle OBIEE, Oracle DB 12c, Exasol, Data Mining, MS Visio, MicroStrategy

Principal BI Architect

Corelogic
07.2008 - 08.2014
  • Trained new staff on Housing Infrastructure inventory control and cash management Applications
  • Developed BI Roadmap for CoreLogic Tax Business Intelligence to deploy BI Applications through Power BI, Query Optimizer, DAX in Operational apps and with MicroStrategy Administration, Architecture and Security Infrastructure (LDAP Authentication) for analytical canned and self-reporting applications
  • Proficient requirements analysis, design, and technical delivery of critical business reports, dashboards, and analytical tools using MicroStrategy 9.2 against a Teradata data warehouse and other data sources like oracle, SQL server and IBM DB2
  • Environment: SQL Server, MicroStrategy, DAX, Power BI, D3 Visualizations Integration.

Sr. BI Consultant

Michaels Stores
03.2008 - 06.2008
  • Prepared daily Retail Store sales report, Revenue reconciliation, Audit report and Quarterly profit and loss using MicroStrategy, Tableau, excel and access
  • Examined documents for completeness, accuracy, or conformance to standards, debit, credit and total accounts in access
  • Implemented complex retail business logic using composite techniques in MicroStrategy Desktop 8.1.1
  • Environment: SQL Server, Oracle 10, MicroStrategy, Tableau, Excel, Visio, PowerPoint, Data Analysis.

Tech Lead

Cbeyond
03.2007 - 03.2008
  • Upgraded reporting platform from earlier 7.5 version to MicroStrategy 8.1, to avail the latest features of development tools
  • Provided Top/Bottom Performing Telephony Services across locations, sites and zip codes using geo spatial maps identifying critical markers for Growth Opportunity
  • Environment: Project Management, MicroStrategy 7.5/8,1.1, Excel, Geo Spatial Maps Integration.

BI Consultant

eBay
05.2006 - 05.2007
  • Developed Yearly Executive Sales reports and Quarterly Top 25 KPI’s Dashboard enabling insights on historical data
  • Identified Growth opportunity in overall retail sales by categorizing top sales margin by product in region across similar timeframes like TMTY vs TMLY (this month this year versus same month last year)
  • Environment: MySQL, Business Objects, Cognos, MicroStrategy, Excel Reporting, PayPal Portal Analytics.

Education

Bachelors of Information Technology -

CQU University Australia
05.2004

Skills

  • Solution Architecture
  • Cloud Modernization
  • Big Data Analytics
  • Data Engineering
  • Business Intelligence
  • Requirements Gathering
  • Interpersonal Skills
  • OLAP/OLTP Analysis
  • Planning
  • Designing
  • Coding
  • Unit Testing
  • Problem-Solving
  • Communication
  • Agile Methodologies

Accomplishments

  • Achieved 90.25% accuracy rate in identifying a hospital intake rate by season by completing data integrity checks at 100% rate, with supported cloud BI design and implementation of business intelligence system, using Microsoft Power Apps, including Power BI for visualization efficiently.

Data Modeling

  • Erwin
  • MS Visio
  • Star /Snowflake Schemas
  • Resource optimization
  • Predictive Modeling
  • Time series
  • Healthcare Analytics

Etl Tools

  • Azure Data Factory
  • Azure Synapse
  • Informatica
  • SSIS
  • SAS Data Integration Studio
  • SSAS

Databases

  • Hive
  • Impala
  • Snowflake
  • Exasol
  • AWS S3
  • Azure SQL database
  • PgSQL (PostGre)
  • SQL-Server
  • Oracle
  • Teradata
  • Netezza

Statistical

  • SAS EG
  • Tableau
  • MicroStrategy
  • R Programming
  • R Studio

Ehr Dbs

  • Epic
  • Meditech
  • Clarity

Automation

  • Jenkins
  • Kubernetes
  • Power Automate
  • Apache Maven

Cloud

  • AWS
  • Azure
  • Google Cloud Platform (GCP)

Awards Activities

  • Certified Project Designer (C.P.A)
  • Certified Report Developer (C.R.D)
  • Certified Reporting Dashboard Designer/ Developer/Engineer (M.C.E / M.C.A/ M.C.D)

Training Seminar Conferences

  • EPIC Clarity Database Systems Design and Modelling (2022)
  • Meditech Digital Messaging XML Training
  • The Digital Health Summit Conference

Visualization Tool

  • MS Pages
  • Microsoft Power Apps
  • MicroStrategy
  • Tableau
  • Power BI
  • Infor Birst
  • QlikView
  • Looker

Personal Information

Title: Sr. Business Intelligence Developer/ Architect

Affiliations

  • Lions Club
  • Association of Information Technology Professionals
  • Toastmasters

Certification

  • Certified PMP, Microsoft -2007
  • Certified MicroStrategy Administrator
  • Certified BI Engineer
  • Certified BI Architect

Languages

English
Full Professional

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Sr. BI Solutions Architect/ Developer/ Admin - CVS Healthcare
06.2023 - Current
Principal BI Engineer/ Architect - Christus Health/ Denovo
10.2015 - 05.2023
BI Solutions Architect - MedAssets
08.2014 - 10.2015
Principal BI Architect - Corelogic
07.2008 - 08.2014
Sr. BI Consultant - Michaels Stores
03.2008 - 06.2008
Tech Lead - Cbeyond
03.2007 - 03.2008
BI Consultant - eBay
05.2006 - 05.2007
CQU University Australia - Bachelors of Information Technology,

Similar Profiles

CREATE PROFILE
RAJ JANNAVARAPU