RIPON ROY

Over a Decade of IT Experience: With over 13.8 years of expertise in the IT industry delivering end-to-end data solutions across BW/4HANA, SAP Analytics Cloud, Datasphere in leading complex digital transformations, migration projects and delivering high-performance solutions. I bring extensive knowledge in business analysis, process improvement, and stakeholder management, ensuring impactful delivery of business solutions with specialization in SAP, HANA, Azure and Microsoft reporting tools. 

Agile Expertise: Strong proficiency in Agile methodologies, including creating user stories, and operational designs that align with business goals, allowing for efficient collaboration between business stakeholders and technical teams.

Leadership in Business Analysis: Proven ability to lead and coordinate design processes, resolve conflicting requirements, and ensure solutions comply with regulatory standards while meeting customer and business objectives.

Tata Consultancy Services | Assistant Consultant, Lead SAP BW4HANA Consultant and Solution Architect, Technical Architect, Power BI Data Analyst – TataSteel UK, TataSteel Netherland and British Steel UK | 2018 – Present

• End To End (SDLC lifecycle) Solution Designed: Implemented SAP Supply Chain and Finance Accounting reporting solution for TataSteel UK, valued at £400k. 

• Led end-to-end Migration: Migrated SAP BW 3.x to BW 7.x and then SAP BW 7.5 to BW/4HANA, Improving performance by 40% for BW systems. Migration of 200+ legacy BEx queries to BW/4HANA-compliant analytical queries. 

• Business Planning and Analytics: Integrated BW/4HANA models with SAP Analytics Cloud for advanced business planning and analytics. Developed SAC Dashboard, Stories and SAP Datasphere data models, leveraging SAP BW Bridge for enterprise-wide analytics. 

• Stakeholder Management: Collaborated with Tata Steel UK CFO's team to deliver 30+ critical SAP reporting solutions. Unified various Senior stakeholder views to create a cohesive business need, balancing value, risk, and customer experience while adhering to regulatory standards. 

• Third-Party Integration: Architected, Configured and automated Open Hub Destinations (OHD) for seamless data bridge between SAP BW and non-SAP Data Marts to distribute semantically enriched data from BW, BW/4HANA to 3rd party environments, including Oracle Data Warehouse, Google Cloud Platform, Azure Data Lake and BI tools (Tableau/Power BI). Sensitivity: general 

• Dashboard Designing: Involved in designing the Sales, Finance dashboards in Power BI and Spotfire. 

• Performance Optimization: Improved BW extractor, reporting, Transformation (Start, Field and End Routine, Customer Exit) performance by 30% using SAP BW ABAP coding. 

• Redesigned: Critical data flows restructured using ADSO, HANA-optimized Composite Providers, Open DSO, LSA++ and Hybrid modelling to work with both On-Premise and Cloud environments. 

• Published SAC Stories and automated distribution of PDF reports to 200+ stakeholders via scheduled email delivery. 

• Utilized SAC Calendar to orchestrate complex data refresh tasks, ensuring that dashboard updates are perfectly synchronized with backend BW/4HANA Process Chains. 

• Ideation & Documentation: Contributed to the ideation process by creating detailed problem statements and business objectives, producing epics and user feature stories that form the project backlog. 

KEY ACHIEVMENTS 

• Led successful SAP Supply Chain Data Reporting Solution: Designed, Developed and supported end-to end SAP Inventory Stock, Finance Balance sheet-P&L, Cost Centre, GL, Controlling, Production Planning, Forward Margin, Sales Orders, Invoice and Delivery report in a fast-paced Agile environment, resulting in improved data accuracy by 30% and a 20% reduction in reporting time. 

• Third-party integration success: Played a crucial role as Solution Architect along with Developer in bridging the gap between stakeholders and technical teams in Supply Chain Project. This led to the successful implementation of new requirements for seamless integration across various departments.

• Business Planning and Analytics Success: End-to-End Data flow Architected and Designed for seamless data integration between SAP BW/4HANA and SAC. Utilized Data Actions, Live and Import Connections to S/4HANA and BW. 

• Operational design and process improvement: Developed and implemented comprehensive operational designs, improving business processes while ensuring regulatory compliance and alignment with business objectives. This effort enhanced stakeholder alignment and streamlined the delivery of business outcomes. 

Tata Consultancy Services | IT Analyst, Senior SAP BW4HANA Consultant – ESB (Electricity Supply Board), Ireland | 2016 – 2017 TATA CONSULTANCY SERVICES 

• Simplified BW/4HANA data models, supporting real-time reporting needs 30% faster. 

• Applied partitioning, indexing techniques, optimizing BW/4HANA processes for large data volumes. 

• Migrated legacy SAP BW system to SAP BW/4HANA, enhancing performance using Native HANA Modelling. 

• Explored Standard HANA CDS view, developed customized Composite Provider, Calculation View solutions. 

• Facilitated team operations, monitoring daily data loads, reducing failures 50% via service improvement. 

• Created Business Explorer, Power BI, Spotfire, Business Object reports for 10+ business units. 

• Led end-to-end SDLC for data integration,testing projects, ensuring 95% on-time completion. 

• Engaged stakeholders on SAP Data reporting, implementing solutions effectively for 20+ requirements. 

• Worked as part of UAT testing teams for client. 

Tata Consultancy Services | Assistant System Engineer, SAP BW4HANA Consultant – NatSteel Holdings Pte Ltd, Singapore and TATA Steel (Thailand) | 2012 – 2016 

• Developed, managed SAP Quality Management Inspection, FI Accounting Invoice, Inventory reports. • Provided BW training and L1, L2 support for BW reports to 100+ end-users. 

• Optimized 3.x BW Dataflow, migrated to SAP BW 7.X, improving data processing 40%.

 • Collaborated with business users (SD/MM/FI) to define requirements, build 50+ BEx reports. 

• Designed, developed SAP Supply Chain Data Reporting for Inventory Stock, Finance Controlling modules. 

• Optimized BW extractor, reporting performance using SAP BW ABAP, reducing run time 30%. 

• Supported SAP Data Reporting for Production Planning, Human Resource, Sales and Distribution modules. 

• Analyzed business specification documents, accordingly Designed and executed end-to-end test scenario and created document containing planned vs actual test execution plan.

Bachelor of Engineering in Computer Science and Engineering | JADAVPUR UNIVERSITY, Kolkata | 06/2008 – 05/2012