Power Bi Lead Data

Manikanta Ramisetty

469-***-**** *********.**@*****.*** Open to Relocation.

LinkedIn: www.linkedin.com/in/manikanta-ramisetty

PROFESSIONAL SUMMARY

Lead Data & Analytics Consultant with 15+ years of experience delivering end-to-end enterprise BI, data warehousing, and analytics solutions across industries.

Proven expertise in Snowflake, Power BI, Microsoft Fabric, SAP BW/4HANA, SAP Datasphere, and SAP Analytics Cloud (SAC).

Designed and developed semantic layers, governed dashboards, and planning models using Power BI, SAC, and Datasphere to drive data-driven decisions.

Strong in data modeling using aDSOs, CompositeProviders, Open ODS Views, and HANA Calculation Views, with SQL, SQL Script, and ABAP for advanced transformations.

Successfully led hybrid reporting architectures integrating SAP ECC, S/4HANA, Snowflake, and external systems via CDS Views, ODP, Qlik Replicate, Azure Data Factory, and Databricks.

Hands-on experience with SAP BTP, including Data Intelligence, SAP Connectivity, and business rules framework for real-time, secure data orchestration.

Recognized for driving data governance, performance optimization, and cross-platform BI strategies across SAP and modern cloud ecosystems.

TECHNICAL SKILLS:

Data Warehouse: Snowflake, DBT, ELT pipelines, Streams & Tasks, Materialized Views

Analytics & Visualization: Power BI, Fabric, SAP Analytics Cloud (SAC), Webi, Analysis for Office, Lumira, Qlik, Application Designer

Cloud Data Integration: SAP BTP (Data Intelligence, Connectivity), Azure Data Factory, Databricks, SAP Datasphere Pipelines

SAP BW/BI: SAP BW/4HANA, BW 7.5, SAP Datasphere, BWMT, BEx, Open Hub, APD, ETL Design

SAP HANA & Modeling: CDS Views, HANA Calc Views, SQLScript, SLT, SAP BODS, HANA Studio, Eclipse

SAP ERP Integration: SAP ECC, S/4HANA, LO Extractors, ODP, Generic Extractors

Programming: ABAP, SQL, JavaScript, CSS

Other Tools: GitHub Actions (CI/CD), Tabular Editor, Synapse, Microsoft Fabric, SSIS/SSRS

Certifications & Highlights:

Snowflake Certified SnowPro Core

Microsoft Power BI Certified Data Analyst

SAP BW/4HANA Certified Consultant

Hands-on with SAP BTP: SAP Connectivity, Cloud Application Programming (CAP), SAP Data Intelligence

PROFESSIONAL EXPERIENCE:

Client: HF Sinclair Mar 2023 to till date

Project: R&R Data Management

Role: Lead Data & Analytics Consultant

Technologies: Snowflake, Power BI, Fabric, Qlik Replicate, DBT, SAP BW/4HANA, Datasphere, BTP, SAC

Responsibilities:

Collaborated with business stakeholders, product owners, and cross-functional teams to gather analytics and reporting requirements, translating them into scalable and BI design specifications.

Built scalable Snowflake data models across raw, staging, curated, and consumption layers using SQL, CTEs, Materialized Views, and clustering techniques to support downstream BI reporting and AI workloads.

Developed modular and reusable DBT models to transform Snowflake data in alignment with Medallion architecture (Bronze, Silver, Gold), implementing robust testing, documentation, and lineage tracking.

Enabled near real-time data ingestion into Snowflake using Qlik Replicate with Change Data Capture (CDC) from SAP ECC and S/4HANA, ensuring minimal latency and high data accuracy.

Applied performance tuning on Snowflake queries, implemented proper partitioning, and leveraged Snowflake metadata functions for incremental loads and auditing.

Designed and developed Power BI dashboards integrated with Snowflake, SAP, and Fabric datasets using advanced DAX, composite models, and dynamic user-based Row-Level Security (RLS).

Created semantic models in Power BI and Fabric, optimizing performance with star schemas, measure tables, and Direct Lake datasets for enterprise reporting.

Implemented Microsoft Fabric Lakehouses and Pipelines, building unified self-service analytics solutions using KQL, delta tables, and Lakehouse connectors.

Modeled SAP BW/4HANA data structures using aDSOs, CompositeProviders, and Open ODS Views, enabling operational reporting and planning integration.

Developed ABAP routines and CDS View-based extractions via the ODP Framework to provision SAP data for Snowflake and reporting tools.

Built SAP Datasphere models including Fact Views, Dimension Views, and Analytical Datasets, supporting hybrid reporting via Power BI and SAC.

Delivered SAC dashboards and stories for executive-level KPIs using both live BW/4HANA connections and Snowflake-based import models.

Conducted workshops and training sessions to enable adoption of Power BI, SAC, and SAP Datasphere by business users across functions.

Client: Shell Oil and Gas Oct 2016 to Mar 2023

Project: Falcon

Role: Lead Data & Analytics Consultant

Technologies: Snowflake, Power BI, SAP BW, SAC

Responsibilities:

Collaborated with business teams and IT stakeholders to gather reporting, analytics, and data integration requirements, aligning with Shell’s global BI strategy.

Designed Snowflake data models (staging, curated, and consumption layers) using CTEs, Materialized Views, and schema optimization techniques to support enterprise financial and operational analytics.

Enabled secure and governed access to Snowflake data using RBAC, masking policies, and external access controls for compliance and multi-team consumption.

Integrated SAP BW/4HANA datasets into Snowflake, leveraging extraction via CDS Views, ODP Framework, and ABAP logic for harmonized analytics pipelines.

Optimized Snowflake performance by tuning SQL queries, implementing proper clustering and caching strategies, and analyzing query profiles to reduce cost and improve speed.

Worked on Snowflake pipeline orchestration, including incremental loads, data reconciliation, and data validation logic across hybrid reporting tools.

Developed Power BI dashboards by consuming curated Snowflake and SAP datasets, using advanced DAX, slicers, bookmarks, and drillthroughs for actionable insights.

Established consistency and trust in reporting by implementing data validation frameworks between Snowflake, Power BI, and SAP BW layers.

Built SAP BW/4HANA models including aDSOs and CompositeProviders, aligned to Shell’s financial KPIs and downstream SAC/Power BI reporting.

Delivered SAC dashboards and stories to executive users by integrating BW/4HANA and Snowflake data via live and import models.

Client: Robert Bosch, Stuttgart, Germany. Feb 2012 to Sep 2016

Role: Senior SAP BW/BI Consultant

Responsibilities:

•Created and installed custom data sources and standard data sources respectively.

•Installed business content infoObjects, DSOs, Infocubes, Multiproviders and respected transformations, DTPs.

•Created infoObjects, infocubes, DSO, Transformations, DTPs and BEx queries.

•Based on BW infocubes and BEx queries created Universes (semantic layer).

•Created connections between BW and BI to utilize BW reports to develop universes and Webi reports.

•Involved in design, development, testing and support after go-live.

•Created analytical views and attribute views, calculation views, user management and authorizations.

•Created infoObjects, Infocubes, multiproviders, structures, formulas in transformations and in BEx.

•Responsible for Requirements gathering, providing effort estimation & Gap Analysis.

•Responsible for Design Sessions & User workshops.

•Designed and implemented SAP HANA data modeling using DSO, Composite provider Attribute View, Analytic View, and Calculation View (Graphical as well as Scripted), Analytical Privileges, Decision Tables, Procedures Hierarchies in the HANA.

•Preparing Design Documents (Technical/Functional) & User Training Documents.

Client: Panasonic Pte Ltd, Singapore, Singapore. Mar 2011 to Aug 2011

Role: Senior SAP BW Consultant

Responsibilities:

Designed and implemented SAP BW/BI data models using InfoObjects, DSOs, InfoCubes, and MultiProviders to support critical business reporting requirements.

Developed and optimized BEx queries with custom variables for YTD, QTD, and prior fiscal year comparisons using ABAP user exits. Provided user training and resolved reporting issues.

Created detailed functional and technical specifications, led test case creation for QA, and supported the business with report validation and documentation during go-live and post-deployment.

Client: Proctor & Gamble, India. Aug 2010 to Feb 2011

Role: Senior SAP BW Consultant

Responsibilities:

Collaborated with business stakeholders to analyze requirements, understand existing business processes, and identify required configuration and data modeling changes to meet reporting needs.

Translated business requirements and functional specifications into technical specifications, including data flow diagrams, InfoProviders, and ETL logic for SAP BW/4HANA implementation.

Developed and optimized BEx queries and analytics reports by interpreting complex business challenges into effective BI solutions, ensuring high usability and data accuracy.

Client: Huawei Technologies Co., Ltd, India. Jul 2009 to Aug 2010

Role: SAP BW Consultant

Responsibilities:

Designed and developed core SAP BW data models, including InfoObjects, Transformations, and DSOs, to support enterprise-wide reporting needs.

Implemented performance optimization techniques by creating Aggregates on InfoCubes and managing hierarchies to enable faster and more structured reporting.

Configured and scheduled end-to-end Process Chains for both master data and transaction data loads, ensuring reliable and automated data refresh cycles.

Training and Seminars:

Trained SAP Phoenix team on SAP BW, SAP BI, SAC and HANA.

Conducted Bootcamps for NA, EMEA and APAC users in Power BI, Power Apps and Power automated.

Accreditations:

Best team performance Award for Falcon project.

Best employee Award for Consumer lifestyle project.

Project star award from Shell Oil and Gas.

EDUCATION:

Bachelor’s degree in Electronics and communication Engineering from JNTU, India

Contact this candidate