Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Opentotravel
Opentoremote
Timeline
Generic

Bhanu Kaviti

Hyderabad

Summary

Experienced Data/BI Architect with 14+ years in BI implementations, data warehousing, and system optimization. Skilled in MicroStrategy, QuickSight, Tableau, Power BI, SQL, metadata management, and ETL tools (Qlik Replicate, Glue, Airflow). Expertise in designing data marts with star/snowflake schemas. Proficient in AWS services (Glue, EC2, RDS, S3, CloudFront, Route 53) to build scalable, secure cloud solutions. Strong leader with a proven track record in driving projects from concept to production, and optimizing development cycles.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr. Business Intelligence Engineer III

Amazon
Hyderabad
01.2024 - Current
  • Company Overview: FinOps delivers business-focused analytics, providing timely data, insights, and analytics across Service Centers (SCs) and global functions. Amazon’s vision is to empower AR and AP departments with advanced data capabilities and real-time, actionable insights. Automated reporting and built a Data Warehouse using SQL & Python on Redshift, including CCOGS Agreements in Limbo report.
  • Enhanced AR balance visibility, reducing AR balance and analyst hours by 80%, saving FTE annually, and improving decision-making.
  • Designed data model for credit note system, transforming raw data into structured insights.
  • Addressed data cleansing challenges, resolving issues with special characters and inconsistent patterns.
  • Enabled seamless integration with credit note operations dashboards, improving operational efficiency.
  • Led data sharing for Brand Coverage project, driving significant cost savings.
  • Delivered actionable AR data on Debit Balance Inflow, Contra COGS, and Distributor Returns, empowering strategic decision-making.
  • Enhanced Gross Debits dashboard to analyze trial balance over three months, focusing on open invoices and aged items.
  • Provided insights for invoice clearing, vendor reconciliation, and identifying write-offs, driving efficiency and visibility.
  • Streamlined data pipelines by replacing views with optimized tables, improving system performance and productivity.
  • Developed enhancements like audit recoveries, VRET analysis, and dispute linkages, increasing BAM by 72 basis points.
  • Reduced BAM CDO Dashboard refresh time from 937 seconds to 10 seconds by optimizing queries.
  • Collaborated with FinOps teams to align data sources with strategic insights, improving decision-making across operations.

Sr. Business Intelligence Engineer III

Amazon
Dallas
03.2021 - 12.2023
  • Company Overview: The Global Workplace Health and Safety team at Amazon ensures the highest standards of safety and well-being for all employees.
  • Led a team of five professionals to provide actionable insights for C-suite inquiries, driving efficient decision-making and executive alignment.
  • Redesigned data models to be scalable for future enhancements, and identified gaps in existing models.
  • Proposed and implemented a quartile-based approach to flag bottom performers by incident rates, contributing to the CX Deck presented to Andy Jassy.
  • Standardized data points for CX Deck reporting, and streamlined reporting processes for faster, more accurate executive decision-making.
  • Redesigned Clark’s OBR report and introduced a methodology for setting monthly goals at the organizational level, aligning with yearly targets.
  • Developed intuitive dashboards for visualizing incident rates across business units, orgs, and sites.
  • Suggested improvements in data distribution on base tables, enhancing performance in data joins and filters.
  • Collaborated with the DE team to onboard standardized tables to Andes, and cleaned up unnecessary tables in the rpt schema, optimizing Redshift resources.
  • Wrote complex queries (cross joins, CTEs, stored procedures, window functions) to flag underperforming locations, and reduce incident rates.
  • Improved Tableau performance by re-creating optimized tables, ensuring consistency in data across all reports.
  • Created rolling and snapshot data to track incident rates and maturity, aiding OSHA compliance.
  • Standardized Tableau connections ensure consistent data presentation across multiple reports.
  • Automated weekly reports by building and executing ETL processes with Amazon’s internal tools, improving reporting efficiency.
  • Worked with Redshift to process data via S3 buckets, supporting the CAMP reporting tool.
  • Gathered business requirements, proposed solutions for data representation, and enhanced executive decision-making.

Sr. Data/BI Architect/Lead/Developer

NTTA (North Texas Tollway Authority)
Dallas
02.2016 - 03.2021
  • Company Overview: The North Texas Tollway Authority (NTTA) is an organization that maintains and operates toll roads, bridges, and tunnels in the North Texas area.
  • Led a team of eight professionals for five years, managing resources, ensuring project success, and aligning team goals with organizational objectives.
  • Implemented CDC using Qlik Replicate from Oracle to Microsoft APS (PDW), and created CT_INS, UPD, and DEL tables for the MPP Database.
  • Built and maintained SSIS packages for data transformation and validation, resolving complex issues with slow data loads, and redo log file management.
  • Developed an EDW layer from Landing Database on APS and designed a solution based on T-SQL, SSIS, SSAS, and SSRS.
  • Created data source views, dimensions, cubes, and optimized SSAS performance using partitioning, calculations, and aggregations.
  • Generated dynamic reports from SSAS cubes using SSRS 2012, and worked on performance tuning of SSIS packages.
  • Designed complex SSAS solutions to analyze business performance using multiple dimensions, hierarchies, and KPIs.
  • Installed MicroStrategy servers and created an Ad hoc schema layer for users to easily analyze data with drag-and-drop functionality.
  • Developed dashboards and dossiers for executives to simplify transaction analysis at various levels.
  • Consolidated users' Excel-based pivot tables into a reporting layer, reducing manual effort, and improving analysis efficiency.
  • Maintained SQL code, designed schema objects, and implemented snapshot tables to meet business requirements.

Sr. Data/BI Architect/Developer

Hachette Book Group
New York
05.2012 - 01.2016
  • Company Overview: Hachette Book Group (HBG) is a leading U.S. publisher. publisher. publisher. Trade publisher and a media group involved in books, digital, broadcast, travel retail, and sports rights.
  • I worked as a BI Architect in a team of three, designing and developing EDW layers on Oracle, and architecting MicroStrategy semantic layers on Linux servers.
  • Created logical data models, source tables, and columns to build MicroStrategy schema objects (Attributes, Facts, Hierarchies) based on business requirements.
  • Developed a metadata repository and statistical tables, and used MicroStrategy Desktop for project creation and configuration.
  • Designed reports to analyze Order to Cash (OTC) system data, and utilized tools like Project Merge and Object Manager to manage environments.
  • Built efficient Ad-Hoc reporting architecture, enabling users to create self-service reports.
  • Employed Web Customization Editor (WCE) for report customization, and created SQL-based architecture for converting Oracle forms to MicroStrategy.
  • Managed server-side reports and created DB instances during the MicroStrategy deployment.
  • Led the full data warehousing lifecycle, including logical and physical data models, using star and snowflake schemas.
  • Developed dynamic dashboards with panel stacks, selectors, and created joins/relationships based on data models.
  • Conducted meetings to gather business requirements, performed quality reviews, and documented processes.
  • Created and modified attributes, facts, and hierarchies, and developed complex reports using metrics, filters, and custom groups.
  • Utilized pass-through functions and transformations for advanced reporting (e.g., year-over-year comparisons).
  • Delivered personalized reports via the MicroStrategy Narrowcast server, and upgraded MicroStrategy from 9.0.2 to 9.4.1.

Sr. Data/BI Developer/Architect

State of Tennessee (Office of Information Systems)
Nashville
  • Company Overview: The TFACTS (Tennessee Family and Child Tracking System) application is created for the genesis of focused federal support for the statewide automated child welfare information systems (SACWIS) to improve the functionalities of the Tennessee Department of Children's Services.
  • Designed and developed the MicroStrategy system, creating schema objects, attributes, facts, hierarchies, transformations, and relationships to model data.
  • Captured business requirements for reconciliation reports, and designed metrics for complex reports in MicroStrategy.
  • Developed public objects, including metrics, derived metrics, compound metrics, and filters for report generation.
  • Created report components, templates, and filters to generate grid and graph-based reports, including auto-prompt filters for dynamic user input.
  • Conducted quality analysis and managed production migrations of MicroStrategy objects using object manager and project duplication processes.
  • Developed various report types, including group-by, ranking, fact comparisons, prompted, and consolidation reports.
  • Designed drill maps for drill-through functionality in reports and generated advanced reports combining templates and filters.
  • Upgraded MicroStrategy from 9.0.1 to 9.2.1 on Linux and created custom attributes using OLAP services.
  • Developed dynamic monthly dashboards with multiple panel stacks, selectors, and customized widgets for decision-makers.
  • Designed intuitive, interactive dashboards in Flash and DHTML, incorporating features like time sliders, bubble graphs, and heat maps.
  • Worked extensively with MicroStrategy Intelligence Server, Web, and Administrator for report configuration and management.
  • Troubleshot MicroStrategy prompts, filters, templates, and consolidation objects in an enterprise data warehouse environment.
  • Managed user access by creating security filters and assigning privileges through the MicroStrategy Administrator.
  • Optimized SQL and metrics calculations using VLDB properties and handled data nulls and zeroes.
  • Developed PL/SQL scripts and wrote complex SQL queries for change requests and report generation.
  • Created metadata and statistic tables for MicroStrategy projects on a DB2 database.
  • Implemented report services and used Narrowcast server to distribute documents to end users.
  • Created datamart reports and free-form SQL reports to populate database tables.

Education

Masters - Computer Science

University of Northern Virginia
Virginia, United States
12.2010

Bachelors - Information Technology

Jawaharlal Nehru Technological University
Hyderabad, India
05.2009

Skills

  • SQL
  • PL/SQL
  • T-SQL
  • Amazon Redshift
  • Oracle
  • Microsoft
  • MariaDB
  • MicroStrategy
  • MicroStrategy architecture
  • MicroStrategy reporting
  • MicroStrategy Desktop
  • MicroStrategy Intelligence Server
  • MicroStrategy Report Services
  • MicroStrategy OLAP Services
  • MicroStrategy Reporting Suite
  • Tableau
  • PowerBi
  • Technical reporting
  • Prototype building
  • Critical thinking
  • Technical writing
  • Big data analysis
  • Data analysis
  • Team collaboration
  • Analytical problem solving
  • Time management
  • Data management
  • Amazon QuickSight
  • OBIEE
  • Parallel Datawarehouse
  • Informatica ETL
  • Informatica PowerCenter
  • Apache Airflow
  • ETL Manager
  • Qlik Replicate
  • SSIS
  • SQL Loader
  • AWS Glue
  • Cloud computing
  • Project management

Certification

  • Certified Power BI Developer, Edx, 04/01/18
  • Certified Project Designer, MicroStrategy, 04/01/17
  • Certified Architect, MicroStrategy, 04/01/17
  • Certified Report Developer, MicroStrategy, 04/01/17
  • Certified Data Scientist, MicroStrategy, 04/01/17

Personal Information

  • Date of Birth: 09/13/88
  • Gender: Male
  • Nationality: India

Opentotravel

True

Opentoremote

True

Timeline

Sr. Business Intelligence Engineer III

Amazon
01.2024 - Current

Sr. Business Intelligence Engineer III

Amazon
03.2021 - 12.2023

Sr. Data/BI Architect/Lead/Developer

NTTA (North Texas Tollway Authority)
02.2016 - 03.2021

Sr. Data/BI Architect/Developer

Hachette Book Group
05.2012 - 01.2016

Sr. Data/BI Developer/Architect

State of Tennessee (Office of Information Systems)

Masters - Computer Science

University of Northern Virginia

Bachelors - Information Technology

Jawaharlal Nehru Technological University
Bhanu Kaviti