Summary
Overview
Work History
Education
Skills
Certification
Certificates
Timeline
Generic

Sagar Bhatia

Arlington,Virginia

Summary

  • 12+ years of experience in delivering end-to-end BI Projects with good analytical and problem-solving ability.
  • Working as Senior BI Engineering at Amazon creating analytics dashboards & solutions for IT Services ORG. Also worked as BI lead for Analytics COE team for large Media & entertaining organization with in-depth expertise in Tableau, Power BI & MicroStrategy.
  • Managed critical BI initiatives working directly with business to understand there need & suggest best reporting solutions.
  • Worked on Multiple tool evaluation initiatives to identify right set of BI tools for Business needs. Tools evaluated like Tableau, Power BI, MicroStrategy, DOMO & Looker
  • Managed multiple BI tool comparison projects like BO to MicroStrategy, BO to Tableau, MicroStrategy to Tableau
  • Worked on BI solutions On Prem & On-cloud. AWS Certified Solutions Architect – Associate.
  • Experience in Leading and managing the BI team in planning, designing, coding, testing, debugging, configuring and documenting packaged application systems and/or custom software development solutions
  • Delivered tool agnostic solutions & hands on work experience on MicroStrategy, Tableau & Power BI
  • Proven ability to successfully work for multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.)
  • Strong experience in Full Life-cycle BI and Data warehousing projects inclusive of requirements analysis, proof-of-concepts, design, development, testing and implementation.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr BI Engineer

Amazon
08.2021 - Current
  • Work with senior leadership to develop IT Services analytics strategy and solutions
  • Design, develop, implement, Test, document and operate large-scale, high-volume, high-performance data structures for Business intelligence analytics
  • Implement data structures using best practices in data modelling to provide on-line Reporting and analysis using Business intelligence tools and a logical abstraction layer Against large, multi-dimension Al datasets and multiple sources
  • Gather business and functional requirements and translate them into robust, scalable, operable solutions that work well within the overall data architecture
  • Analyze source data systems and drive best practices in source teams
  • Analyze large amount of data, discover & solve real world Problems, and build metrics to Help business teams in making Decisions
  • Participate in the full development cycle, end-to-end, from design, implementation and testing to documentation, delivery, support & maintenance to produce comprehensive, usable dataset documentation and metadata
  • Evaluate And make decisions around data Set implementations designed and proposed by peer data engineers
  • Evaluate and make decisions around the use of new or existing software products and tools
  • Project Details Global Media Company

BI Architect & Administrator

InfoCepts LLC
12.2014 - 08.2021
  • Providing end to end BI solutions to different Business units
  • Helping business users to choose right BI tool based on their current and long-term needs
  • Supported BI needs for 15+ applications in tools like Tableau, MicroStrategy & Power BI
  • Managing multiple BI environments like Tableau and MicroStrategy for various business units
  • Design and develop reporting solutions using BI Tools for on Premise & Cloud
  • Participate in High level design discussions and document them
  • Coordinate with the onsite and offshore teams for understanding the requirements and knowledge transfer
  • Involve in designing Teradata semantic layer and review ETL logic
  • Design & Develop Reporting metadata to support both canned & Adhoc reporting needs
  • Creating Schema objects, Reports, Dashboards & Visual insights for BI users
  • Perform quality assurance activities and fix defects
  • Perform governance checks to make sure best practices & guidelines are implemented
  • Deploy BI Projects across different environments
  • Assist Business Analysts in test planning and execution
  • Work and deliver the product enhancements proposed by the end users or business analysts
  • Provide L2 & L3 Support in production
  • Support Admin Activities in MicroStrategy and user Adhoc issues
  • Tableau architect and designer for Ecoview Project
  • End To end Delivery of these projects; right from requirement gathering, BRD Creation, Planning, Designing, Development, QA & Support
  • Ensuring best practices are being followed by various project teams
  • Creating dashboards and reports for BI users
  • Setting up end to end BI (MicroStrategy, Tableau) environments that includes Install, Upgrade and configure
  • Recently Upgraded MSTR from 10.1 to 11.1 and Tableau from 8.1 to 9.0.4
  • Implemented code review process for better governess
  • Conducting monthly BI team meetings between various business units to go over challenges and provide solutions or directions
  • Involved in resource planning meetings
  • Project Details Global Media Company

MicroStrategy Architect

InfoCepts PVT
12.2013 - 12.2014
  • Analyzed report specifications and prepared use case and design documents
  • Performed requirements analysis and source data analysis
  • Defined and created MicroStrategy objects including attributes, filters, metrics, hierarchies, templates, prompts and reports
  • Following the best practices in Building the Schema and Public Objects
  • Created requirements specification, Test case documents for each every report requirements
  • Designed and created MicroStrategy reports according to design specifications
  • Extensively worked on Report Services Documents
  • Developed Graphical reports showing complex graphs
  • Designed and developed reports using MicroStrategy Document Objects
  • Project Details Global Market Research Firm Converged Product Line

MicroStrategy Architect

InfoCepts PVT
02.2013 - 11.2013
  • Worked on Data warehouse creation
  • MSTR Schema object and reports creation & modification
  • Optimized query Performance and report design for different requirements
  • Worked on VLDB properties of MSTR to improve query & report performance
  • Worked with SDK team on POC’s to cover critical scenarios
  • Identified Performance improvement areas at different layers (DB, MSTR, MSTR Web SDK) & worked on optimizing it
  • Completed requirement analysis for different sections of an MSTR Document
  • Project Details Global Consulting Firm MyBuzzMetrics(MBM 2.5 & MBM 2.6)

Senior Java & Data Warehouse Developer

08.2012 - 02.2013
  • Involved in requirement gathering for new feature & change requests
  • Participated in all high level design discussion
  • Co-ordinated with the onsite team for development and support issues/queries
  • Created low level design documents for all new design approaches and also provided estimates for same
  • Explained the design models with team members & assisted them in proper development
  • Worked across all the modules for change requests & new features
  • Developed code & unit tested the same
  • Deployed code in different environments
  • Coordinated with various teams QA, BMG, Marklogic for various scenario
  • Worked on Bug fixes
  • Project Details Global Consulting Firm MyBuzzMetrics (MBM 2.0 & MBM 2.1)

Senior Java & SQL Developer

Plan Reengineering
12.2011 - 07.2012
  • Created low level design documents of Service Layer modules
  • Involved in Database design and Service Layer Core components development
  • Designed and developed several modules like for Scheduling, Users, Synchronizer, export etc
  • Designed and developed Scheduling or reports & widgets, Users
  • Created test cases including multithreaded test cases for all scenarios to ensure thorough and extensive testing
  • Analyzed & fixed any issues that came up during development tasks
  • Co-ordinated with Service layer and Flex UI teams for various modules delivery
  • Co-ordinated with the onsite team for development and support issues/queries
  • Deployed code on different environments
  • Worked on Bug fixes, Change request & enhancements
  • Project Details Global Market Research Firm

TIBCO Developer

Infocepts
02.2011 - 12.2011
  • Performed impact analysis, design and modification of 157 TIBCO processes within short span of time
  • Developed new features & also worked on change request
  • Enhanced legacy code to provide proper results & better performance
  • Developed new reports as per requirement and also merged few existing reports
  • Worked on implementing Lazzy loading logic in project
  • Implemented CLE (Comman Exception Logging) framework to give detail of all application exceptions
  • Identified any integration and technical issues proactively and provided multiple design options to overcome tool limitations
  • Explored TIBCO ActiveMatrix Service Grid Concepts
  • Analyzed & fixed any issues occurring during development tasks
  • Co-ordinated with the onsite team for development and support issues/queries
  • Documented issues faced and their solutions
  • Worked on deploying and managing TIBCO AMX Servers
  • Project Details

Education

Executive Program in Business Analytics - Business Analytics

Indian Institute of Management (IIM) Calcutta
Calcutta, India
08.2014

Bachelor of Engineering - ELECTRONICS

RAMDEOBABA KAMLA NEHRU ENGINEERING COLLEGE
Nagpur, India
04.2010

Skills

  • Working with senior leadership to design analytics strategy & solutions
  • End-To-End BI Project design & delivery
  • Business Intelligence Tools: Tableau, QuickSight, MicroStrategy, Power BI, Thought Spot
  • Data Modeling : Normalized, De-normalized, Star and Snowflake Schemas
  • Databases: RedShift, MS-SQL, Oracle9i, Teradata, MySQL 50, Snowflake
  • Ticket/Project Management Tools: Service Now, JIRA, Asana
  • Programming Languages: SQL, Python, JavaScript
  • Domain Knowledge: Retail, Media & Entertainment, Global Marketing, Consumer-Generated Media, Telecom

Certification

SQL Essentials education and training Introduction to Data Warehousing Data Warehouse Design Data Integration Consulting Skills Training including communication skills, project management, time management and client management

Certificates

      

  • AWS Certified Solutions Architect, Associate
  • MicroStrategy Certified Analyst, Designer & Admin
  • Tableau Designer
  • Certified Analyst in Microsoft power BI
  • Lean Six Sigma Green Belt certified from Benchmark Six Sigma RABQS.

Timeline

Sr BI Engineer

Amazon
08.2021 - Current

BI Architect & Administrator

InfoCepts LLC
12.2014 - 08.2021

MicroStrategy Architect

InfoCepts PVT
12.2013 - 12.2014

MicroStrategy Architect

InfoCepts PVT
02.2013 - 11.2013

Senior Java & Data Warehouse Developer

08.2012 - 02.2013

Senior Java & SQL Developer

Plan Reengineering
12.2011 - 07.2012

TIBCO Developer

Infocepts
02.2011 - 12.2011

Executive Program in Business Analytics - Business Analytics

Indian Institute of Management (IIM) Calcutta

Bachelor of Engineering - ELECTRONICS

RAMDEOBABA KAMLA NEHRU ENGINEERING COLLEGE

Similar Profiles

CREATE PROFILE
Sagar Bhatia