| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePh no: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEProfessional Summary:Over 14 years of experience in SAP BW/BI, BW4HANA, SAC, BO and involved in major global implementation projects.Extensive experience in SAP HANA and created Packages, Attribute Views, Analytical Views, Calculation & CDS Views in Eclipse IDEExtensive working knowledge on SAP BW4HANA modelling - Open ODS Views, LSA andLSA ++, ODP API (SDA, SDI and SLT)Worked on Calculation Views Graphical and SQL script based, Table functions etc.Involved in migrating existing SAP frontend dashboards (BEX & BO) into Microsoft Power BIExtensive experience working with HANA Studio Open DSO Views, Transient Providers, Composite Providers, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA, LSA and LSA++, ODP API like SLT and SAPI.& Mixed Scenarios)Configured and used SDA (Smart Data Access) for various remote sources to expose as Virtual tables in HANAGood exposure to CDS views.Experience in replication of SAP ECC tables in to SLT and used them in Calculation Views.Extensive implementation and working experience with SAP-BI/BW skills - Data Modelling, Info cubes, Generic Data Extractions, BEX Analyzer & AFO.Expertise in Installation and Configuration of SAP BOBJ BI 4.x/3.x/R2, SAP BOBJ Integration Kit.Experienced in SAP BOBJ BI 4.x version with BI Launch Pad, Information Design Tool (IDT), Interactive Analysis, Upgrade Management Tool (UMT), and Life Cycle Manager (LCM).Designed and developed ETL routines in BODS, Modified or created new Data services jobs to meet project requirement.Ability to interpret, configure and implement data mapping / transformation business rules into Data services.Strong Experience in the functional areas of SAP R/3: SD, MM, PM, PP & FIExtensively worked in Administrative Work Bench for designing Info Objects, Info Cubes, Multi Cubes/ Providers, Info source, Aggregates, ODS /DSO objects, Data Marts, Info sets, Update rules and Transfer rules / Transformations and Data Transfer Process (DTP).Designed BEX Reports by using Formulas, Structures, calculated key Figure, Restricted Key Figure, and used Variables with User Entry/Default Value, Replacement Path, and Customer Exit.Involved in Unit Testing and Integration Testing and BI object Transportation from one instance to another instance.Strong experience in working with multiple BI & business teams and implementing Agile methodologiesI.T. ACQUAINTANCE:LanguagesABAP/4, Java, XML, SQL, PL/SQL, C, C++, VC++ReportingSAP BEX/WAD, Business ObjectsERPS4HANA, SAP R/3 4.X, my SAP (ECC 5.0, ECC 6.0), SRMDW /ETL ToolsSAP BI 3.x, SAP BI 7.x, SAP HANA/BODSOSWindows 7/8/10/NT/2000, Sun Solaris, UNIX, AIX.Data VisualizationSAP Analytics Cloud, Tableau, Xcelsius, Lumira & Design Studio, Power BIData BaseHANA, SQL Server, MS SQL, Oracle, DB2PROJECT DETAILS:Cleint1:Cirrus Logic Inc. Austin, USA (March 2023- Till Date)Role:SAP BW HANA Senior ConsultantEnvironment:BW4HANA, Native HANA, SAP BI 7.5, BW on HANA, SAP BOBJ 4.1 SP 5, Information DesignTool, WEBI, Analysis Edition for OLAP, Analysis Edition for Office, SACBusiness Area:SD, MM, SCM, Concur & FIResponsibilities:oConducted Business workshops and prepared a Detail Design document for business use case.oDefining the SAP HANA components (SAP and Non SAP sources to replicate) replication process and define HANA views.oUnderstanding the SAP ECC Data tables which are identified for dashboard reporting and getting clarification from Business analysts.oExtracted the data using CDS Views.oWorked on BW Modeler prospective for building Data Targets ADSOs.oDesigned and Created Process Chains Using different process types Example: ABAP Program Process type, PSA Request Deletion Process Type and OS command process type, deleting Data target data, deleting overlapping request.oCaptured implementation or changes in Change Ids for transporting the object from dev to quality and production.oResolved issue occurred during transportation of BW HANA Objects.oStudied the existing business rules and understood the client's new reporting requirements by interacting with the Business managers and users.oIdentified the Business content Cubes for Alerts and System availability metrics.oActivated all the required Business content objectsoCreated a BEX Reports on ITSM for SAC.oSuccessfully implemented multiple stories and displayed dataoCreated an Open hub to extract data from Bex Reports to third party tool.oCreated and scheduled a process chain for the Entire flowCleint1:Mosaic Inc. Florida, USA (Aug 2021- March 2023)Role:SAP HANA Technical LeadEnvironment:Native HANA, BW4HANA, SAP BI 7.5, BW on HANA, SAP BOBJ 4.1 SP 5, Information DesignTool, WEBI, Analysis Edition for OLAP, Analysis Edition for Office, SACBusiness Area:SD, MM, PM, SCM & FIResponsibilities:Involved in requirements gathering and managed the team to assign and support the projects in timely manner with documentation and user trainingExtensively worked with Business users, Basis, Offshore developers, and IT team.Worked on creation of calculation views on several SAP modules including Finance, Plant Maintenance, Supply Chain and enabled them for reporting (AO, PowerBI etc.)Extensive experience working with HANA data modelling, SQL scripts, Data Lake and for different reporting needsInvolved in working with information model content like input Parameters, Variables, Calculated columns and Restricted columns.Worked on Analytic privileges and assigning them to the HANA models.Worked with senior level managers and directors for establishing project plans and assigning several team members into different area (HANA, BOBJ, BW, SAC, Data Lake, PowerBI, BODS etc.)Involved in change management and worked with Solman team and Basis team for change movement (CR, CD and Service now requests)HANA SDA (HANA Smart Data Access Accessed tables from DB2 as virtual tables and then persisted the data as column tables in HANAHaving good experience working with PlanViz tool to understand the SQL Query runtime performance.Worked on table functions and complex SQL scripted views.Used SDA to integrate data from remote sources into HANA models.Responsible for conducting business workshops, and prepared business case for SAP BW/4HANA financial reporting at company, division, store level, department, article level reporting.Worked with several teams to coordinate SAP incident resolution and speed up ongoing support.Worked with Cloud Analytics including SAP Analytic Cloud & Azure for different reporting needsExtensively worked with SAP Security and BASIS teams to implement SAP notes and SP upgrades and worked with user Authorizations and roles.Cleint2: Friesland Campina, NJ (Remote) (Mar 2018- July 2021)Role: SAP HANA BW SpecialistEnvironment: SAP Native HANA, BI 7.3, 7.5, BW4HANA SAP BOBJ 4.1 SP 5, Business Explorer (BEX), Information Design Tool, Dashboards Designer (Xcelsius), Web Intelligence, Analysis Edition for OLAP, Analysis Edition for Office, SAP Lumira,, CMC, and Windows NTBusiness Area: MM, PM, QM, PP, SRM, SCM & FIInvolved in full life cycle implementation of HANA, BW, BO and BW/4HANA environments.Worked with all the ETL extraction mechanisms available in HANA E.g.: SDA, SDI, SLT and Data servicesConfigured and used SDA (Smart Data Access) for various remote sources to expose as Virtual tables in HANAHANA SDA (HANA Smart Data Access Accessed tables from DB2 as virtual tables and then persisted the data as column tables in HANAUsed SDA to integrate data from remote sources into HANA models.Replicated SAP CRM tables into HANA using HANA SDA (Smart Data Access) Exposed DB tables as virtual tables in HANA and then persisted the tables in HANAExperience in replication of SAP ECC tables in to SLT and used them in Calculation Views.Worked with Basis team to implement HANA CTS for transporting the Calc Views.Strong experience on enhancing all LO cockpit data sources using standard user Exits for SD and MM and imported them by locking the users and reloaded the data using setup transactions.Worked with business stakeholders to gather the business requirements and implement the Financial BO Reports including Webi, BO Explorer, Xcelcious Dashboards and LumiraWorked with several teams to coordinate SAP implementations including BW upgrades and Support pack implementations, BW on HANA and BW/4HANAWorked on SAP HANA Cloud and Azure cloud for several business needs.Extensively worked with SAP Security and BASIS team in the end-to-end installation and implementation of BO tools, HANA and Upgrades including BW 3.5 to BI 7.0, BI 7.5 on HANA and ECC Enhancement packagesWorked on creation of calculation views on several SAP modules including Finance, Plant Maintenance, Supply Chain and enabled them for reporting (AO, PowerBI etc.)Extensive experience working on BO Webi and Xcelcious dashboards. Worked on CMC for scheduling the jobs and creating events and promotion management.Installed and configuring the business objects data services 4.1 with sap bi handling SAP DS admin activities and sever configuration.Worked with several ticketing systems (Footprints, Rally, Snow) to resolve the production support tickets and worked with BI &Functional teams along with business users to sped up resolving critical issues on time.Extensive experience working with SQL queries and SQL scripting. Worked on several stored procedures for BO universe requirements.Worked with custom CDS views on SAP delivered data sources and exposed as webservice and OData service.Worked with all the ETL extraction mechanisms available in HANA E.g.: SDA, SDI, SLT and Data servicesConfigured and used SDA (Smart Data Access) for various remote sources to expose as Virtual tables in HANAHANA SDA (HANA Smart Data Access Accessed tables from DB2 as virtual tables and then persisted the data as column tables in HANAUsed SDA to integrate data from remote sources into HANA models.Replicated SAP CRM tables into HANA using HANA SDA (Smart Data Access) Exposed DB tables as virtual tables in HANA and then persisted the tables in HANAExperience in replication of SAP ECC tables in to SLT and used them in Calculation Views.Worked with Basis team to implement HANA CTS for transporting the Calc Views.Cleint3: CenterPoint Energy. Houston, Texas (Mar 2015 - Feb 2018)Role: SAP BW / Business Objects ArchitectEnvironment: SAP BI 7.0, BW IP, SAP R/3 4.7, Windows, Flat Files and Legacy systemsBusiness Area: MM, PM, QM, PP, SRM, SCM & FIResponsibilities:Developed reports using BEX Analyzer and BEX Query Designer. Used Aggregates, Restricted Key Figures & Calculated Key Figures for filtering and formula as per the requirement of query.Extensively used RSRT and RSECADMIN transactions for query testing, debugging and analysis authorizations.Created aggregates and compressed the InfoCube data for better performance.Extensively used BEX Web Application designer and other query tools for different reporting requirements.Worked on and supported several BW Integrated Planning related queries and reports Created web templates and published into portal as iViews.Trained end users on testing the BW environment and built test cases.Worked with IP Planning cubes and built the Budgeting and Forecasting report as per the user needsCreated multiple roles and restricted the access using authorization object S_RS_AUTH given to each role separately.Involved in documentation and trained End user in using BEX analyzer and Web Portal. Worked as an SAP BI Administrator and created Users, Roles, Profiles, Assigned Roles to Users, Created Role Based Security, Grant Security Access, Unlock User IDs, Custom Authorization Objects.Conducted training sessions on SAP BEX / BO Reporting to Business Users.Client: NCCCL, India (Mar 2012 to Apr 2015)Role: SAP BW DeveloperEnvironment: SAP BW 3.x/7.x, SAP ECC 5.0 /6.0, BW3.5Business Area: FI, SD, MMWorked on SD, MM and FI Functional areas.Extensively worked on Info cubes, DSO's, multi provides, Aggregates, DTP's, Info packages.Involved in BI object transportation from one instance to other after the testing has been done.Extensively worked on Bex Queries by using functionalities like Restricted Key Figures, Calculated Key Figures, Conditions, Variables, and Filters etc.Worked on Business content Installation as per the requirement.Extensively worked on LO cockpit, filling setup tables for SD, MM data sources.Worked on Generic data sources by using tables, info set queries.Written Abap code in cmod for Master and Transactional data source enhancement. Worked on Analysis Process designer (APD).Having good experience in understanding the KPI's and developed reports and entire data flow as per the requirement.Client:Godrej (Nov 2010 to Feb 2012)Role:SAP BW DeveloperEnvironment:SAP BI 7.01, BW3.5, SEM4.0, Oracle, Windows, Flat Files & Legacy systemsBusiness Area:FI, SD, MMResponsibilities:Worked on SD, MM, PP and FI Functional areas.Worked on Business content Installation as per the requirement.Having good experience in understanding the KPI's and developed reports and entire data flow as per the requirement.Extensively worked on Info cubes, DSO's, multi provides, Aggregates, DTP's, Info packages.Worked on Object Transportation.Extensively worked on Bex Queries by using functionalities like Restricted Key Figures, Calculated Key Figures, Conditions, Variables, and Filters etc.Coordinating with BO Consultants to develop Dash-boards, Webi reports.Extensively worked on LO cockpit, filling setup tables for SD, MM data sources.Worked on Generic data sources by using tables, info set queries.Written Abap code in cmod for Master and Transactional data source enhancement. Worked on customer exit variables and written Abap code for MTD, YTD, QTD, WTD reports Worked on Transformation Routines and code debugging.Worked on Loading Transaction and Master Data by using business content data sources.Created Process chains for Transaction and Master Data and scheduled the Background Jobs for daily and weekly Loads.Having good exp in running Info packages with Full, Init and Delta Updates.Involved in team and status meetings.Involved in peer testing and worked on reconciliation with R/3 data.Client:Reliance capital (Apr 2008 to Oct 2010)Role:SAP BW DeveloperEnvironment:SAP BI (3.5), SAP R/3, Flat Files, Informatica, ABAP/4, Windows, Oracle.Business Area:FI, SD, MMResponsibilities:Involved in the full cycle of development and implementation of SAP BI Project.Installed Business Content objects and data sources from FI module as per the requirements Extracted data from ECC by using standard extractors and flat file source systems.Extensively worked on Start Routine, End Routine and ABAP Debug Viewer.Created number of Info cubes, DSO objects and multi providers as per the need and created aggregates and compressed the Info Cube data for better performance.Extensively worked on Process chain and Meta chains.Involved in designing the variety of Bex Queries using different formulas, RKF and CKFs as per the business needExtensively used variable exits for building the FI reports for MTD, YTD calculations using date variablesInvolved in BI object transportation from one instance to other after the testing has been done. Involved in end-to-end testing phases, user training and documentation. |
