Puneet Dixit

• Company Overview: Industry: Utilities and Energy
• Leading the Data, Analytics and Reporting portfolio for the largest SAP NextGen transformation in North America estimated around $950 M.
• Collaborated with 25+ members of senior leadership to drive data-driven decisions by delivering strategic vision for Enterprise BI and operational oversight of enterprise-wide reporting and analytics functions.
• Brainstormed with executive stakeholders to create strategic initiatives aligned with company’s goals by managing 7+ teams responsible for enterprise data warehousing, data visualization, data extraction, data profiling and data conversion.
• Considered as a trusted thought partner, helping pressure-test ideas, frame trade-offs, and anticipate what’s needed before it’s asked.
• Supervised the SAP S/4 HANA design, development and maintenance of data models, dashboards and performance metrics that support 15+ critical business decisions.
• Lead efforts to develop standardized dashboards that provide actionable insights across the business which helped reduce manual reporting, ensuring real-time access to data for key stakeholders.
• Driving the Business Self Service with business executives, cross functional Integration, Organization Readiness and Technology Integration teams to transform and reduce the operational reports with $8M savings.
• Collaborate with engineering teams to ensure data pipelines and aggregation layers meet business needs, ensuring scalability and reliability.
• Work with senior stakeholders to define key performance indicators (KPIs) and success metrics for measuring business performance and progress against objectives.
• Lead a team of data professionals providing mentorship, guidance, and oversight on projects while fostering a collaborative and innovative environment.
• Assessment/evaluation of solution strategy, technology impacts, development strategy for NextGen transformation.
• Migration/Upgrade of data warehouse from on premise to SaaS solutions.
• Empower team members to work closely with functional stakeholders and become embedded business partners.
• Present complex analyses and insights through clear storytelling tailored to executive audiences.
• Oversee the data strategy, data profiling, data conversion, KPI dashboards, reporting tools, and self-service analytics that provide visibility into performance across the business.
• Driving best practices in architecture, data warehousing, and analytics tools, ensuring scalability and resilience.
• Collaborate with analytics engineering to ensure robust, scalable data pipelines and reporting infrastructure that meet evolving business needs.
• Leading the strategy in migrating reporting systems from legacy systems to SAP S/4HANA.
• Leading the integration with GCP, Snowflake with enterprise ERP systems.
• Responsible for designing and implementing real-time operational reports and dashboards using SAP tools.
• Experience with data governance and metadata management.
• Designing SAP data structures, data extraction, transformation, and loading (ETL), and querying capabilities.
• Responsible for architecting and designing large data platforms, data warehouses, streaming applications, data ingestion, integration, and distribution pipelines.
• Demonstrated strong organizational and time management skills while managing multiple projects.

• Company Overview: Industry: Pharmaceutical and Eye care
• Chaired initiatives related to educating analytics team on S4HANA innovations and value add features for both user communities and technology teams.
• Lead and manage a team of senior and junior BI developers, providing guidance on industry best practices and aligning with company and team policies.
• Responsible for architecting and optimizing data models, ETL processes, and pipelines to ensure efficient data ingestion and transformation.
• Proven experience using latest technologies for data ingestion, integration, transformation, storage, mining, warehousing, data analytics, and manipulation.
• Designed the roadmap to be flexible and adaptable to evolving business needs and technological advancements. This involves regularly reviewing and updating the roadmap to reflect changes in the business environment, emerging technologies, and shifting priorities, ensuring agility and responsiveness to new opportunities and challenges.
• Developed a consolidated technology roadmap that aligns with customer vision and business priorities.
• Connect the dots between existing capabilities to analyze and integrate current technological capabilities to form a cohesive global tech strategy. This involved identifying synergies and gaps, ensuring that all technological efforts are aligned and contribute to the overall strategic objectives.
• Mentor and develop team members to align their personal and professional goals with career growth opportunities.
• Navigate complex ideas with a strong understanding of stakeholder management and communicate effectively to simplify intricate concepts into actionable messaging that aligns with business priorities.
• Manage, prioritize, and align data, reporting, and analytic requirements with business needs while overseeing their development and implementation with the operations BI team.
• Provide leadership in large-scale data warehouses and enterprise data visualization tools and socializing business self-service reporting strategy.
• Produced ~ $5 M valued use case and roadmap for Embedded Analytics with efficient analysis on S4 HANA migration and integration with SAP Data warehouse.
• Responsible for providing architectural guidelines and development standards for building data warehouse and developing analytical applications.
• Responsible for designing cross functional scenarios for reporting and analytics.
• Lead a global team (US & India), including hiring, coaching, and performance management.
• Design of SAP HANA data modelling objects like Schemas and tables on HANA, Creating attribute view, analytical view and Calculation views, Scripted views Analytical Privileges, Stored Procedures including variables, parameters, unit and currency conversion, table functions and triggers for Analysis, design and modelling for the main SAP functional areas.
• Extensive Implementation of Data extraction from SAP and non-SAP source systems, including business content extractors, generic extractors, CDS views, BODS, SLT and data transformation in SAP BW.
• Routines in Info packages, DTPs, using ABAP programming, HANA Scripted Calculation views, Stored Procedures using advanced SQL and HANA Functions.
• Used Enterprise Architect tool to perform Conceptual/Logical/Physical modelling.
• Used Web IDE to build data models using Core Data Services (CDS), HDB Artifacts, Flowgraph, Calculation Views, Analytic Privilege, function/store procedure, under SAP HANA XSA environment.
• Created and assigned HANA XSA User Roles to Nodejs Application using Role Collection, Role Template, Scope and Attributes.
• Worked extensively with SAP HANA Business Content for modelling. Created views (Attribute, Analytical, calculation, SQL Scripts and Procedures to meet the business requirement.
• Used extensively SAP HANA Studio on model design with packages, start join, measures, hierarchies, variable and filters.
• Paid attention to detail while completing assignments.
• Learned and adapted quickly to new technology and software applications.
• Proved successful working within tight deadlines and a fast-paced environment.
• Demonstrated strong organizational and time management skills while managing multiple projects.

• Company Overview: Industry: Consumer Packaged Goods (CPG)
• Lead multiple solution design initiatives for this business transformation.
• Conducted workshop sessions on reporting requirements with multiple business stake holders for Record-to-Report (R2R), Order-to-Cash (OTC), Procure-to-Pay(P2P) and Supply Chain (SCM) domains.
• During design phase, proposed and setup HANA Content Hierarchy structure, design time HANA objects, design time security objects.
• Assisted in setup and installation of embedded analytics business content in S/4 HANA with CDS Views.
• Review all technical specifications based on functional specifications that outlines required dimensions, measures and business rules to meet and satisfy the business reporting requirements.
• Responsible for the design and development of several data models based for IT delivered reports and Business self-service reports consumption.
• Developed custom views to extract business partner (BP), material ledger prices for analytics.
• Worked with Basis/Infrastructure teams to increase memory for fixing some WEBI reports out of memory issues in Production.
• Mentored team with Design principles like statement performance, application Performance and how to use query plan Analysis - explain plan & visualize plan.
• Ensuring day-to-day deliverables are in aligning with contractual obligations with the client to meet the regular milestones.
• Coordinated development activities with offshore team for status updates, clarifications and issue resolutions.
• Developed Extractors, BADI, User Exits, Start routine, End Routines, Field Routines in Transformations.
• Design and build of reports using WEB Intelligence Reporting, Crystal reports, Open Hub Concept, including documenting the design and analysis of reports using Analysis Office.
• Build Queries using Query Designer using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and aggregation for reusable queries.
• Monitoring/reviewing the quality and integrity of the reporting objects, including optimization of HANA model performance by analyzing Expensive Statement Trace, SQL Plan Cache, Runtime Statistics, Plan Visualization.
• BW4/HANA Modelling using Composite Providers, Open ODS Views, Advanced DSO, CDS Views, ODP/ODQ, Virtualization, Data Flows, New BW4/HANA Content Activated New GL Totals and Line Items data sources and build the Data flows with enhancements to extract new FI-GL data to Data warehouse.
• Created ADSO, Open DSO Views to meet the different business requirements using SAP BW Modelling perspective.
• Created Prototypes, Data flows with enhancement routines, Start, End and Expert routines.
• Activated and implemented the BI technical content And Enhanced the Data flows and data target for sales Orders, Delivery, Billing etc.
• Configured Lo-Cockpit, Enhanced the Extractors, tested and collected the components to transports.
• Technical Review of all BI Deliverables And applying the OSS notes, preparing functionality test plan after applying the support packages.
• Developed BW-BEx Queries with calculated, restricted, formula key figures, exceptions and conditions, exit routines.
• Developed Visualizations, Storyboards for different KPI of ageing AR/AP Customers and Vendors (business partners).
• Provided clear step by step instructions with ability to support proposed actions with solid backup information based on prior experience and SAP best practice.
• Performance tuning by Partitions, Indexes, Cache Warmup, Tracing the Query outputs, Redesign the cubes based on Dimensional Table sizes, Database Statistics, BW Statistics, Early Alert Watch Report, ABAP and SQL trace.
• Performance tuning of extractors, transformations, variable exit routines, queries using ABAP Trace, SQL Trace.
• Prepared training manuals for Business users and knowledge transfer to IT Staff.
• Performed Pre-Migration and Post Migration Activities.
• Converted Standard Info Cubes to HANA optimized Info Cubes.
• HANA Composite Providers (HCP) are created to take advantage of virtual Providers and HANA information models to get improved performance of reporting.
• Followed LSA++ Architecture guidelines for future development of data targets and data flows.
• Industry: Consumer Packaged Goods (CPG)

• Company Overview: Industry: Consumer Packaged Goods (CPG)
• Performed various roles as Solution Architect, Team Lead and Lead Developer in various phases of the project and based Team’s bandwidth and deliverables.
• Guided a team of 10+ with day-day work plan & reviews with onsite and offshore.
• Worked with Implementation Partner’s team for seamless integration of newly developed solutions.
• Responsible for guiding entire team on coke policies on design & development.
• Presented all Design approaches and responsible for gaining approvals from BI Review Board meetings.
• Responsible for designing the robust central data warehouse and analytical solutions for mergers from multiple other entities from bottling group.
• Responsible for gathering data requirements and prepared technical specifications.
• Executed complete redesign of data loads from SAP & non-SAP Systems.
• Prepared end to end data flow design documents for educating team about design process.
• Conducted several meetings with senior management to explain and convince design approaches.
• Worked with various client and implementation partner teams to integrate solution and resolve any data quality related questions.
• Responsible for designing 15+ interfaces to extract data from Non-SAP Systems.
• Worked with functional teams to finalize design changes and lead the development.
• Responsible for organizing several data loads in the system with 100+ process chains.
• Responsible for helping partner’s team to bring changes related to company's re-org into ongoing solution development.
• Responsible for reviews of transports, post migration checks and issues resolution.
• Worked closely with basis, infrastructure, SAP Teams to keep team’s productivity as high as possible during system copy, production space, access related issues.
• Worked on BADI, script logic changes for best response time with templates.
• Worked closely with team to design accelerators for data reconciliation with source system.
• Designed and developed on dashboard for month end closing process updates for project team communication.
• Performed HANA upgrade process with pre-& post checks and post upgrade data loads.
• Developed several calculation views to evaluate HANA advantages in development and performance perspective.
• Worked with SAP on potential issues and required NOTEs & evaluation of upcoming changes via Release Notes.
• Handled several pre-sales effort for HANA evolution and worked on estimates for development, resource and road map for current & future projects.
• Industry: Consumer Packaged Goods (CPG)

• Company Overview: Industry: Manufacturing (Media, Journals, Books etc.)
• Requirement Analysis, Business Blueprint and Delta Business Blueprint.
• Responsible for overall Solution Design for SAP BW/HANA, Business Objects, Data Services landscape.
• Leading the 48 member team across data and analytics , working closely with Business Stakeholders.
• Ensuring day-to-day deliverables are in align with contractual obligations with the client to meet the regular milestones.
• Single point of contact for offshore team and business stakeholders.
• Developing contingency plans as part of crisis management.
• Worked with users to sign off the reports after getting the UAT.
• Mentoring the technical users and business users.
• Conduct regular review meetings with internal / external stakeholders – monitoring the SLAs and take preventive actions in slippage.
• Chair Project Board meetings and provide status updates on deliverables. Identify any risks or issues requiring management attention.
• Responsible for working with legal and other cross functional teams to review processes, tools and materials to ensure compliance with guidelines and policies.
• Responsible to understand business requirements and translate technical solutions.
• Responsible for prioritizing several competing requests and managing demands from multiple key stakeholders.
• Responsible for identifying and implementing creative solutions to problems.
• Responsible of managing a heavy workload and operating in a fast-paced environment.
• Provided clear step by step instructions with ability to support proposed actions with solid backup information based on prior experience and SAP best practice.
• Performance tuning by Partitions, Indexes, Cache Warmup, Tracing the Query outputs, Redesign the cubes based on Dimensional Table sizes, Database Statistics, BW Statistics, Early Alert Watch Report, ABAP and SQL trace.
• Performance tuning of extractors, transformations, variable exit routines, queries using ABAP Trace, SQL Trace.
• Prepared training manuals for Business users and knowledge transfer to IT Staff.
• Performed Pre-Migration and Post Migration Activities.
• Converted Standard Info Cubes to HANA optimized Info Cubes.
• Modified Process chains to remove obsolete Process types related Info provider loads to optimized load performance in BW data flows.
• Info cubes are exchanged for DSO in the Multi Provider when Info cube and DSO are having same data for reporting purpose HANA Composite Providers (HCP) are created to take advantage of virtual Providers and HANA information models to get improved performance of reporting.
• Followed LSA++ Architecture guidelines for future development of data targets and data flows.
• Industry: Manufacturing (Media, Journals, Books etc.)

Company Overview: Industry: Hi Tech

• Reporting: Build, support, and maintain a wide range of dashboards and reports, ensuring that each asset features rigorous analytic approaches and strong visual design.
• Analytics: Design and construct analytic decision-making pipelines, turning raw data into action recommendations for users across the company.
• Teaching: Ensure that associates are trained on the tools, systems, and dashboards that were build, and are empowered to deliver independent analytics of their own.
• Implementation: Worked to understand business problems, design quantitative solutions, and translate those solutions into rigorous requirements for our Data Engineering teams.
• Data: Complete ownership of the structure, availability, completeness, and accuracy of data, ensuring that each component of our analytic processes can be trusted and relied upon.
• Created and maintained comprehensive system and project documentation, including change requests, functional requirements, test plans, and cutover plans and delegated appropriate tasks to junior analysts.
• Reviewed and refined data models for development projects, self-service and assisting team members in understanding and adhering to established standards.
• Established trust with business leadership to ensure data and deliverables reflect advanced data analytics best practices.
• Created dashboards for different KPI of media, revenue, expenses for different media products.
• Worked on giving privileges to _SYS_BIC, _SYS_REPO and _SYS_BI, analytic privileges.
• Involved in Designing and implementing security model for HANA Users and Administrators.
• Performed importing and exporting landscapes, tables and models, documentation, user management in SAP HANA.
• Raising OSS Messages and contacting with SAP AG for trouble shooting.
• Worked collaboratively with Project managers, SAP Offshore consultants and partner consultants to develop consulting and project methodology, techniques, tools and solutions.
• Leveraged knowledge of data warehouse and software development methodologies to contribute to the overall planning of Projects by recommending approaches, identifying resources and developing timelines.
• Prepared training manuals for Business users and knowledge transfer to IT Staff.
• Industry: Hi Tech
• Developed comprehensive system designs and configurations to optimize operational efficiency across departments.
• Conducted gap analysis and process mapping to identify areas for process improvement and system integration.
• Collaborated with stakeholders to gather requirements, translating business needs into technical specifications for SAP solutions.
• Spearheaded change management initiatives, ensuring smooth transitions during system upgrades and modifications.
• Championed knowledge transfer sessions to ensure smooth handover and adoption of newly implemented SAP systems among endusers.
• Delivered cost savings by identifying opportunities for process automation within the client''s existing ERP landscape.
• Implemented process improvements, driving efficiency gains within client organizations using SAP tools.
• Leveraged expertise in multiple industry verticals to provide insightful recommendations on best practices for efficient use of deployed SAP systems.
• Kept abreast of the latest SAP technologies and industry trends, ensuring that clients receive cutting-edge solutions tailored to their specific needs.
• Facilitated user training sessions, improving user adoption rates and overall satisfaction with SAP functionalities.
• Evaluated project performance metrics, providing strategic recommendations for continuous improvement in SAP operations.

• Company Overview: Industry: Retail
• Responsible for the architecture, design and development of data models for FI, CO-PA, SD and MM application areas for the SAP BW project implementation.
• Participated in the process workshops in the blueprint phase and gathered the reporting requirements pertaining to the logistics and finance application areas.
• Interacted efficiently with the Subject matter experts (SME), Business analysts (BA) and Functional analysts (FA) to gather the definitions and calculations of KPIs and translated the reporting requirements to the SAP terminology.
• Performed Gap analysis using the reporting requirements by comparing with the standard business content. Developed the technical specification documentation and block diagrams for the data models.
• Responsible for the back-end design and development of summary and detailed reports for Sales and gross profit (SGP) analysis, A/R overdue analysis by profit center, GR/IR reports, Inventory value at period end, Balance Sheet. P/L statements to support Vega reporting and for Internal reporting purposes.
• Generated the data sources to extract the self-defined CO-PA hierarchies into SAP BW for reporting.
• Created new generic data sources in ECC using Function modules to extract Sales data as per the business logic for Sales by commission reports.
• Responsible for the development of various Test cases/scenarios and validation of BI reports at various stages of testing such as Unit Test, Functional Unit Test and detailed Integration Testing.
• Actively involved in improving query performance and system performance by Identifying long running queries.
• Worked on a pilot program for the business users to demonstrate the abilities of SAP BI/BW to use SAP business objects suite including Web Intelligence , Crystal reports and dashboards.
• Assisted in installing SAP BOBJ integration Kit and developed Roles in BW which are necessary for BW BOBJ integration.
• Industry: Retail

• Company Overview: Industry: Retail
• Involved in converting ER diagram to multi-dimensional modelling.
• Developed Models based on BW design and Web Intelligence reports.
• Worked on BW Data flow modelling including Extractors, Routines.
• Enhancement of complex standard data sources.
• Developed AR/AP and GL related data flows.
• Responsible for user training related for Finance and Supply chain power users.
• Consumed BW query models in IDT using Business objects.
• Activated the business content delivered objects to support reporting (Sales, Purchase and Production Orders).
• Developed report to report interface for drill down within BI from summary to detailed reporting.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Improve Performance of queries by creating indices, aggregates, compress and refresh DB statistics of Infoproviders.
• Designed & developed the Universe with classes and objects according to the business rules and created WEBI reports for Multidimensional Analysis.
• Scheduled the WEBI reports using Info view.
• Analyzed, developed, and documented how to prepare a standard query structure in BEx Query Designer in order that query to be used in the Business Objects.
• Involved in training the end users and knowledge transfer to the maintenance team and prepared the end user training manuals, transition documentation and post go live maintenance manuals.
• Created process chains and job scheduling ABAP programs to automate Job flow.
• Customized data flows with end routine, start routines, field routines.
• Developed extract programs for custom data sources with full and delta load functionality.
• Activated and implemented the BI technical content.
• Technical Review of all BI Deliverables and applying the OSS notes, preparing functionality test plan.
• Developed Open Hub objects to distribute sales backlog data to external reporting systems.
• Created process chains and job scheduling ABAP programs to automate job flow.
• Developed BEx queries, Crystal reports using formula fields, parameter fields and group fields.
• Created Universe on Sales Orders, Delivery, Billing and Backlog, Materials Movements and Purchase Order cubes using universe design tool.
• Developed orders, delivery and billing reports using universe and web intelligence.
• Published User Training Manuals, trained users on web intelligence and crystal report features.
• Industry: Retail