Nitin Verma

About Nitin Verma

SAP HANA Consultant with 6+ years of experience in HANA modeling, SQL development, and data provisioning using BODS and SLT. I specialize in building scalable and high-performance data models, optimizing complex SQL queries, and resolving real-world data issues such as duplication and incorrect aggregation.In my current role at EY, I work extensively on designing SQL-based risk identification logic for Segregation of Duties (SoD) in SAP GRC and SAP BIS. My work involves identifying conflicting user activities, analyzing risk exposure, and supporting compliance reporting for business and audit teams.I have hands-on experience in developing calculation views (Cube and Star Join), implementing performance optimization techniques like filter pushdown, column pruning, and join pruning, and debugging data inconsistencies caused by complex joins and transformations.Beyond development, I actively collaborate with business stakeholders to understand requirements, troubleshoot reporting issues, and deliver solutions that align with business objectives.Core Expertise: • SAP HANA Modeling (Calculation Views, SQLScript) • SQL Development & Performance Optimization • SAP BODS (ETL Development) • SLT (Data Replication – Exposure) • GRC & SoD Risk Analytics • SAP MM & FI ReportingI am always open to opportunities where I can contribute to building efficient data solutions and solving complex business problems.

Experience

1. Senior Consultant

   EY

   Jun 2023 — Present · Gurugram, IN

   Developed complex SQL queries to detect conflicting user activities and access violations, ensuring compliance with internal controls. • Built HANA-based reporting models to analyze user behavior, transaction usage, and risk exposure. • Designed and optimized calculation views (Cube & Star Join) for finance and audit reporting. • Resolved data duplication and incorrect aggregation issues caused by 1:N joins in financial datasets. • Applied performance optimization techniques including: • Filter pushdown • Column pruning • Join pruning • Developed SQLScript procedures and table functions for complex transformation logic. • Implemented analytic privileges for row-level security (e.g, company code-based access). • Built and optimized BODS ETL jobs for data extraction, transformation, and loading into HANA. • Collaborated with auditors and business teams to validate risk scenarios and reporting accuracy.

Education

• GRAPHIC ERA HILL UNIVERSITY

  Bachelor of Technology, Electrical, Electronics and Communications Engineering

  2015 — 2019