| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePage 1 of 15Candidate's Name
Email: EMAIL AVAILABLE Phone: PHONE NUMBER AVAILABLEExperience Summary Have 21+ years of experience as an SAP Data Analytics Architect. Worked primarily on SAP modules SAP BI, BW on HANA, BW/4HANA, SAP HANA, SAP BODS, SAP BPC, SAP BO, Power BI, A4O, SAP SEM and SAP ABAP. Worked on several BW and HANA projects ranging from end-to-end Implementation to Production Support/Data load monitoring in functional areas SAP SD, MM, FICO, HR, PS, PM, SCM, SRM, CRM, TPM, TMS, IS-Utilities, IS- Retail, iQMS. Worked for 18+ years in client facing roles for various customers in Europe, UK, and USA. I am able to lead a team of technical resources, build consensus, solve problems, deal with deadlines and changing priorities, project management and interpersonal skills and ability to interact effectively with partners. Experienced in implementing full cycle Business Intelligence and HANA solutions including, Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Deployment, Maintenance, Training Documentation, End user training & Run Support projects. Expertise in designing Native HANA Information data models on HANA studio like attribute views, analytical views, calculation views, creating variables, Input Parameters, hierarchies, currency conversion, Analytical Privileges, Decision tables, SQL scripting stored procedures, Table Functions, Restricted Columns, Calculated Columns, Flow Graphs, OData Services, SDA Integration (SDI), Performance tuning of HANA models, XS Jobs Scheduler. Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA Expertise in designing BW models in HANA eclipse environment. Worked on design, creation and management of star schemas and Export/Import of Models. Expertise in design and development of SAP HANA & BI objects (Multi providers, Info Cubes, Transient Providers, Composite Providers, DSOs, Advanced DSOs, Info objects, Infosets, Integrated Planning (IPs), Transformations, Info package, DTPs, Data sources, Process Chains, APDs, Open ODS, Open Hubs). Replication and Data Provisioning using Data Services (BODS) and SAP Landscape Replication Server(SLT). SDA Integration to HANA. SQL Scripts to extract data from Database. Experienced in BW on HANA migrations. Good Knowledge on SAP Analytics Cloud platform. Strong knowledge on ABAP on HANA CDS Views, AMDP methods and how to reuse them in ABAP program to get performance benefit of HANA. Utilization of HANA best practices, and HANA performance Optimizations(HANA PlanViz, Expensive Statements Trace, and HANA Memory Consumption). Strong exposure in integrating BODS with non-SAP and SAP systems, use BODS as an external system for ETL using SQL between ECC and HANA/BW. Created complex Jobs, Workflows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target. Extensively used Data Services Management Console to schedule and execute jobs, manage repositories, and perform metadata reporting. Have good exposure in Business Objects in creating Universe, design and development of BO reports using WEBI(Web Intelligence) using Design Studio and Power BI reporting. Expertise in SAP ABAP and customizations for Standard Datasource enhancements, Function module based Generic Datasource developments for complex data extractions, Routines in transformations (Start/End/Expert Routines), user exits and BADI. Created and Maintained Process Chains, Infopackages and DTP to load data to various Info providers in BI. Designed and developed queries for reporting using BEx Query Designer, WAD, Webi and Analysis Office. Hands-on experience with Bex Reporting and in creation of Selections, Formulas, RKF, CKF, Variables, Conditions, and Exceptions, RRI & Bex Information Broadcasting. Worked on currency conversions, unit conversions both at the query and transformation levels. Extensively working on data security and transport management and Experience in LSA & LSA++ architectures. TechnologyBelow is a list of important hardware, software products, tools and methods that I have worked with. Software Products Tools MethodsSAP BI 7.x/3.x, BW/4HANA, SAP HANA, S/4HANA, SAP ECC, SAP BO 4.x, SAP BODS 4.x,SAP BPC 10.x, SAP SEM 3.5, ABAPSolution Manager, Remedy, CSS,TCSM, UC4, RWD Info pack, MantisASAP & SCRUMMethodologyQualificationsDegree and Date Institute Major and Specialization Bachelor of Engineering, Nov 2000 S.L.N College of Engineering Electronics and Communications Page 2 of 15Professional CertificationsProfessional Society / CertificationSAP HANA Certified (C_HANAIMP151 Application Associate - SAP HANA (Edition 2015) SAP BW Certified (C_TBW45_04 - SAP NetWeaver 04 - Business Intelligence) Project AssignmentsThe details of the various assignments that I have handled are listed here, in chronological order. Project GSCM EDWCustomer Cepheid, USPeriod Jan 2024 Till DateDescription Cepheid is an American molecular diagnostics company. Its systems automate traditional nucleic acid tests (tests for specific sequences of DNA or RNA). The tests can be used to identify and analyze pathogens and genetic disorders. Cepheid sells clinical tests for healthcare-associated infections, infectious diseases, sexual health, oncology and genetics. The project development includes developing various advanced BW objects and HANA models for their Sales, Finance, Supply Chain business which provides ability to do various analytics using BO Webi, DBeaver and Power BI.Role HANA ArchitectSolution Environment SAP HANA 2.0, SAP BW on HANA, SAP - ECC 6.0, SAP BO, SQL Server, Power BI Tools Solution ManagerHighlights Understanding the specifications provided by the functional consultants, interacted with business and users to get to know the exact requirements/KPIs for dash boards for Sales, Finance & Supply Chain solution. Designed and created various complex Native HANA information models with graphical, calculated columns, input parameters, variables for Power BI & Webi reports. Created various dash boards through BO Webi & Power BI for Sales, Finance & Supply Chain solution. Created reports using Power BI to track on the daily and weekly snapshots data load status. Created Stored Procedures, XS Jobs for scheduling the data snapshots using SQL scripting. Created Table functions where the graphical views were not sufficient to executing custom functions or complex queries. Worked on the Analytical Privileges, Roles and assigned it to users for restricting the Information Models and data access. Integrated various non SAP sources with HANA using SAP HANA SDI. Migrated Native HANA and BW content from development environment to Production environment using HALM, Transport Organizer, Solution Manager. Trouble shooted/analysed technical problems in the existing BW and HANA models using SAP best practices. Worked with the business team for validation of data against requirements. Documented the process, test plan and progress of the project developments Project SAP BW HANA SolnCustomer Louisiana-Pacific Corporation, USPeriod July 2023 Dec 2023Description Louisiana-Pacific Corporation (LP) is an American building material manufacturer. The LP is pioneer in production of Oriented Strand Board (OSB) panels. LP is the world's largest producer of OSB and manufactures engineered wood building products. LP products are sold to builders and homeowners through building materials distributors and dealers and retail home centres. The project development includes developing various advanced BW objects and HANA models for their Sales, Supply Chain business which provides ability to do various analytics using Power BI & Tableau.Role BI/HANA ArchitectSolution Environment SAP BW on HANA, SAP - ECC 6.0, SAP BO, Snow Flakes, Power BI, Tableau Tools Solution ManagerPage 3 of 15Highlights Understanding the specifications provided by the functional consultants, interacted with business and users to get to know the exact requirements/KPIs for dash boards for Sales, Finance & Supply Chain solution. Designed and created various complex Native HANA information models, calculated columns, input parameters, variables for Power BI & Tableau reports. Created various BW objects (Advanced DSOs, Composite Providers) using advance features of BW Modelling tool. Extensively worked on the large and complex SAP BW transformations to fit the business requirements. Wrote reusable and complex routines using ABAP. Worked on SAP standard data source enhancement and development of generic extractors as per the business needs. Migrated BW content from development environment to Production environment using Solution Manager. Trouble shooted/analysed technical problems in the existing BW and HANA models using SAP best practices. Worked with the business team for validation of data against requirements. Documented the process, test plan and progress of the project developments Project GSCM EDWCustomer Cepheid, USPeriod Apr 2021 June 2023Description Cepheid is an American molecular diagnostics company. Its systems automate traditional nucleic acid tests (tests for specific sequences of DNA or RNA). The tests can be used to identify and analyze pathogens and genetic disorders. Cepheid sells clinical tests for healthcare-associated infections, infectious diseases, sexual health, oncology and genetics. The project development includes developing various advanced BW objects and HANA models for their Sales, Finance, Supply Chain business which provides ability to do various analytics using BO Webi, DBeaver and Power BI.Role BI/HANA ArchitectSolution Environment SAP HANA 2.0, SAP BW on HANA, SAP - ECC 6.0, SAP BO, SQL Server, Power BI Tools Solution ManagerHighlights Understanding the specifications provided by the functional consultants, interacted with business and users to get to know the exact requirements/KPIs for dash boards for Sales, Finance & Supply Chain solution. Designed and created various complex Native HANA information models with both graphical and SQL scripting, calculated columns, input parameters, variables for Power BI & Webi reports. Created various BW objects (Advanced DSOs, Composite Providers) using advance features of BW Modelling tool. Extensively worked on the large and complex SAP BW transformations to fit the business requirements. Wrote reusable and complex routines using ABAP. Created various dash boards through BO Webi & Power BI for Sales, Finance & Supply Chain solution. Created reports using Power BI to track on the daily and weekly snapshots data load status. Created Stored Procedures, XS Jobs for scheduling the data snapshots using SQL scripting. Created Table functions where the graphical views were not sufficient to executing custom functions or complex queries. Worked on the Analytical Privileges, Roles and assigned it to users for restricting the Information Models and data access. Integrated various non SAP sources with HANA using SAP HANA SDI. Migrated Native HANA and BW content from development environment to Production environment using HALM, Transport Organizer, Solution Manager. Trouble shooted/analysed technical problems in the existing BW and HANA models using SAP best practices. Worked with the business team for validation of data against requirements. Documented the process, test plan and progress of the project developments Project I&W Data FreezeCustomer Lamresearch, USPeriod Aug 2020 Mar 2021Page 4 of 15Description Lam Research Corporation is an American corporation that engages in the design, manufacture, marketing, and service of semiconductor processing equipment used in the fabrication of integrated circuits.[2] Its products are used primarily in front-end wafer processing, which involves the steps that create the active components of semiconductor devices (transistors, capacitors) and their wiring (interconnects). The company also builds equipment for back-end wafer-level packaging (WLP), and for related manufacturing markets such as for microelectromechanical systems (MEMS). The project development includes developing various advanced BW objects and HANA VDMs for their iQMS & Supply Chain application/business which provides ability to freeze live data and take off-line, so everyone is referencing in the same data (ensuring consistency/timing).Role BI/HANA ConsultantSolution Environment SAP HANA 2.0, SAP BW4HANA, SAP BODS, SAP R/3 - ECC 6.0, Trackwise, DENODO, A4O Tools Solution ManagerHighlights Understanding the specifications provided by the functional consultants, interacted with business and users to get to know the exact requirements/KPIs for score cards. Created various BW objects (Advanced DSOs, Composite Providers) for staging the data from iQMS system using BW Modelling tool. Exposed ADSOs and Composite Providers to HANA for creating Information models. Performed data modelling and developed various HANA VDMs for iQMS and Supply Chain solution. Designed and created various complex Native HANA information models with both graphical and SQL scripting, calculated columns, input parameters, variables for Power BI & Qlik View dash boards. Migrated Native HANA and BW content from development environment to Production environment using HALM (CTS Export), Transport Organizer, Solution Manager. Trouble shooted/analysed technical problems in the existing HANA VDMs using Plan Viz., SQL Analyzer and performance optimized by redesigning the VDMs using best practices. Worked on the Analytical Privileges and assigned it to users for restricting the VDMs and data access. Created Stored Procedures, Table Functions using SQL scripting. Created complex Jobs, Work Flows, Data Flows and Scripts using various BODS Transforms for data provisioning from iQMS database into SAP BW system. Worked on Denodo Platform for data virtualization by creating active data catalog for semantic search and enterprise-wide data governance. Worked with the business team for validation of data against requirements. Worked on Analytical Privileges for the new calculation views and assigned them to users. Extensively worked on the large and complex SAP BW transformations to fit the business requirements. Wrote reusable and complex routines using ABAP. Documented the process, test plan and progress of the project developments Project Voltron Self ServiceCustomer Kimberly-Clark Corporation, USPeriod Jun 2019 Jul 2020Description Kimberly-Clark Corporation is an American multinational personal care corporation that produces mostly paper-based consumer products. Kimberly-Clark brand name products include Kleenex facial tissue, Kotex feminine hygiene products, Cottonelle, Scott and Andrex toilet paper, Wypall utility wipes, KimWipes scientific cleaning wipes and Huggies disposable diapers and baby wipes.The project development includes developing self-service HANA VDMs for their Supply Chain application/business.Role HANA ArchitectSolution Environment SAP HANA 2.0, SAP APO, SAP ECC 6.0, SAP BW 7.4, TMS, SAP BODS, A4O, Power BI Query Tools Solution Manager, JIRAHighlights Understanding the specifications provided by the functional consultants, interacted with business and users to get to know the exact requirements/KPIs for score cards. Performed data modelling and developed various HANA VDMs in supply chain solution. Designed and created various complex Native HANA information (Attribute views, Calculations Views) models with both graphical and SQL scripting, calculated columns, input parameters, variables for Tableau and Power BI reporting and dash boards. Worked on currency conversions, unit conversions. Page 5 of 15 Migrated Native HANA content from development, testing environment to Production environment using HALM (CTS Export), Solution Manager and delivery units. Trouble shooted/analysed technical problems in the existing HANA VDMs using Plan Viz., SQL Analyzer and performance optimized by redesigning the VDMs using best practices. Worked on the Analytical Privileges and assigned it to users for restricting the VDMs and data access. Created Stored Procedures, Table Functions using SQL scripting. Worked on moving the table configuration in Hana with Import and Export options across the landscape. Worked on Data Provisioning using Data Services (BODS) by designing and develop ETL in BODS, created new Data Services jobs to meet project requirements. Prioritize the work and deliverables according to specified timeframes. Worked on A4O and Power BI Query reports against HANA VDMs as per the customer requirements. Worked with the business team for validation of data against requirements. Worked in a Agile methodology framework.Project CSI Piscataway Data AnalyticsCustomer Camber Pharmaceuticals, USPeriod Feb 2019 May 2019Description Camber Pharmaceuticals is a foreign subsidiary of Hetero Drugs Limited, which is one of the largest global players in developing, manufacturing, and marketing of pharmaceuticals and their active ingredients. Hetero began with a focus on producing active pharmaceutical ingredients(APIs) and has expanded to all stages of pharmaceutical manufacturing, including novel research and commercial sales. Hetero has concentrated on key products where new approaches to synthesis and large-scale production bring significant value to the global market. The project development includes S/4 HANA and Analytics implementation to their business. Role HANA ArchitectSolution Environment SAP S/4 HANA 1809, SAP SRM 7.0, SAP HANA, SAP BODS, SAP BO, A4O, SAC Tools Solution ManagerHighlights Interacted with business and users, gathered and analysed the functional requirements Designed and created various HANA information (Attribute views, Calculations Views) models for reporting. Worked on Extracting flat files in Hana with Import options Designed & created Analytical Privileges, roles and assigned it to users for restricting the data access. Migrated HANA content from development, testing environment to Production environment using delivery units and HALM. Created Procedures using SQL scripting Worked on Data Provisioning using Data Services (BODS). Designed and developed ETL in BODS, created new Data Services jobs to meet project requirements. Monitored the BODS jobs and pushed the data into HANA system. Created A4O & BO Webi reports as per the customer requirements. Worked on the POC for created dashboard stories in SAC. Worked on Incidents which was raised by customer and trouble shoot the issues. Worked with the business team for validation of data against customer requirements. Project MARS Wrigley Confectionary Integration and Transformation Customer Mars Inc., NJ, USPeriod Aug - 2018 to Jan 2019Description Mars Wrigley Confectionery U.S. is the worlds leading manufacturer of chocolate, chewing gum, mints, and fruity confections.The project development includes to provide One stop reporting solution for both finance and external manufacturing using advanced features of BW4HANA with LSA++ Role Sr. BW/HANA ConsultantSolution Environment SAP BW4HANA, SAP HANA, SAP BODS, SAP BO, SAP R/3 - ECC 6.0, CASS, COMPASS (TPM tool)Page 6 of 15Tools Rev TracHighlights Interacted with business and users, gathered details for developing required reporting solution. Created data flows using Advanced DSOs and Composite Providers for global over usage and Freight Payment reporting using BW Modelling tool. Created objects for IP reports. Designed & created Calculation views for further Tableau reporting. Created Analytical Privileges for the new calculation views. Migrated Native HANA content from development, testing environment to Production environment using delivery units. Created complex BODS Jobs to load data from COMPASS database into SAP BW4HANA system. Created Flat file datasource for loading Freight payments into BW systems Developed Aggregation Levels, Filters, Planning Functions, customer exit variables and Planning Sequences for IP reports. Extensively worked on the complex SAP BW transformations in order to fit the business requirements. Wrote complex start and end routines using ABAP. Created one stop reports for both finance and external manufacturing, so that business can manage co-packers (external factories) and exposed the report into BO for further formatting. Worked with the business team for validation of the backend and reporting changes against specific customer business requirements.Project US Petcare EnhancementsCustomer Mars Inc., NJ, USPeriod May - 2018 to Aug 2018Description Mars is an American global manufacturer of confectionery, pet food, and other food products and a provider of animal care services.The project development includes to provide reporting solution for Latest Estimates on the Tactics Spend using advanced features of BW4HANA.Role Sr. BW/HANA ArchitectSolution Environment SAP BW4HANA, SAP HANA, SAP BODS, SAP BO, COMPASS (TPM tool), CASS Tools Rev TracHighlights Created Advanced DSOs and Composite Providers for TPM Statistics data using BW Modelling tool. Exposed ADSOs to HANA and created calculation views in order to provide a base for the Tableau reporting. Created Analytical Privileges for the new calculation views and assigned them to users. Created complex Jobs, Work Flows, Data Flows and Scripts using various BODS Transforms to load data from COMPASS database into SAP BW system. Extensively worked on the large and complex SAP BW transformations and user exits in order to fit the business requirements. Wrote reusable and complex routines using ABAP. Created BEx and BO reports in TPM area for US Petcare division. Worked with the business team for validation of the backend and reporting changes against specific customer business requirements. Documented the process, test plan and progress of the project developments Project Madewell Cross Channel Selling ProjectCustomer JCrew, New York, USPeriod Oct - 2017 to Mar 2018Description JCrew Group, Inc., is an American multi-brand, multi-channel, specialty retailer. The company offers an assortment of women's, men's and children's apparel and accessories. It operates more than 450 retail stores throughout the United States. The company conducts its business through retail, factory, crewcuts, Madewell stores, catalogs and online. The project development includes to provide reporting solution for Madewell products cross channel selling in JCrew and improve data flows using advanced features of BW on HANA and create HANA models and provide base for various reporting tools. Role Sr. BW/HANA ConsultantSolution Environment SAP BW - 7.4 on HANA, SAP HANA, SAP BO, SAP R/3 - ECC 6.0 Page 7 of 15ToolsHighlights Interacted with business and users, gathered and analysed the requirements Redesigned the existing data flows which are based on the LO extractors to fit the business requirements (cross channel selling). Eliminated data aggregation layer (infocubes which were in project scope) where ever possible in order to reduced data layers and increase the load performance. Created and changed some of the Advanced DSOs and Composite Providers for Stock, Inventory, POS receipts and Commission sales using BW Modelling tool. Exposed ADSOs to HANA and created calculation views in order to provide a base for the QlikView reporting and created analytic privileges and assigned them to users. Extensively worked on the large number of complex transformations in order to fit the business requirements. Wrote reusable and complex routines using ABAP. Extensively worked on the Virtual Infoobjects and wrote complex ABAP code to fill the virtual infoobjects in the SAP exists. Extensively worked on the Open Hubs to create complex and business critical outbound interfaces to various systems like DCM, Dayforce, SAS etc. Changed the required BEx & BO queries to amend with the virtual objects so that the data will be populated into the reports at runtime without reloading the history data to the existing data flows. Worked with the business team for validation of the backend and reporting changes against specific customer business requirements. Documenting the process, test plan and progress of the project developments Project DuPontCustomer DuPont, USPeriod Jan - 2016 to Aug 2017Description DuPont is a world leader in Market-Driven innovation and science company and has a history of over 200+ years. This organization works collaboratively to find sustainable, innovative, market- driven solutions to solve some of the worlds biggest challenges, making lives better, safer, and healthier for people everywhere. Its a renowned brand in almost every industry especially Chemicals industry. DuPont has brought world-class science and engineering to the global marketplace through innovative products, materials and services. This project includes various BW, HANA, BODS and BO developments and support.Role Sr. BW/HANA/BODS/BO ArchitectSolution Environment SAP BW 7.4 on HANA, SAP HANA, SAP BO 4.0, SAP R/3 - ECC 6, SAP BO 4.0, SAP BODS, SAP BPCTools Solution ManagerHighlights Interacted with business and users, gathered and analysed the functional requirements Good in designing HANA information models and data models using Transient provider, Composite Provider, Advanced DSO, Virtual Cube, Virtual Info object for reporting. Work on HANA Upgrade/Migration from traditional landscape to HANA. Designed & created HANA Attributes, Analytic and Calculation views, Package, stored procedures using SQL scripting, Analytical Privileges. Migrated Native HANA content from development, testing environment to Production environment using delivery units. Worked on creation of Analytics Privileges as per the business requirement Worked on conversion in analytical view using currency as Unit of Measure Worked on validation of Information Models Worked on Export/Import of Models Worked on design and creation of star schemas Worked as a part of BW on HANA migration team Worked on Data Provisioning using Data Services (BODS) and SAP Landscape Replication Server (SLT). Designed and developed ETL in BODS, modified or created new Data Services jobs to meet project requirements. Monitored the BODS jobs and pushed the data into BW system. Created new mappings and updated old mappings in Transformations of BODS according to changes in Business logic. Created BEx and Analysis Office Reports that meet user requirement. Modified existing BO Webi reports as per the changes requested by customers Worked on Incidents which was raised by customer (like Currency issue, data mismatch issues, short dump, lock issues; hierarchy issue etc) and trouble shoot the issues. Page 8 of 15 Worked on Change Requests to meet the user requirement and transported the objects across the landscape. Worked with BW models in HANA eclipse environment. Actively participated in financial Month End and Year End Closure with in the BPC and BW environment. Worked on ABAP code in the transformations (Start & End Routines) to full fill the business requirements. Worked on user exits, enhanced the standard and generic data sources in order to fix some of the issues and full fill the reporting requirements. Worked on the BO reports and provided enhanced functionalities to the existing BEx reports Collected and transported the objects in SAP BO using Promotion Management tool. Scheduled jobs weekly like loading data, Consolidation jobs, and optimization jobs in the Production system.Project Southern Water Mercury Project Developments Customer Southern Water, UK (Onsite)Period Mar- 2015 to Dec-2015Description Southern Water is the private utility company responsible for the public wastewater collection and treatment in UK for the public water supply and distribution. Some areas within the Southern Water region are supplied by a number of smaller water supply companies. Mercury Program is to improve the customer service substantially in order to have leading customer-facing systems and to deliver a full range of online services for customers. This program is to deliver a new, upgraded (SAP billing and customer relationship management) system and more efficient and effective processes for managing customer queries and data; new online services for customers to allow them to manage their account and interact with us quickly and easily. Project includes design and development of data flows, reports and publish them in enterprise portal, design and develop the data services for extracting data from the non-SAP systems.Role Sr. BW/BODS/BO Architect & Data Migration Project Lead Solution Environment SAP BW - 7.3, SAP BO 4.0, SAP R/3 ECC 6 (ISU), SAP CRM 7.0 EHP2, SAP BODS 4.0, SAP EP Tools Solution ManagerHighlights Managed business requirements, conducted workshops and completed Blueprint Did gap analysis after analysing the user requirements Worked on the data modelling and data extraction from non-SAP systems like TEDDI, CAR& Tallyman using BODS Migrated the data from SW SAP and legacy systems to Target system using BODS Worked on debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data. Monitored the BODS jobs and pushed the data into BW system, so that the data is available for reporting to the users. Worked on various mappings conditions in |
