| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Candidate's Name
PHONE NUMBER AVAILABLE-(CELL)E-MAIL: EMAIL AVAILABLE
OBJECTIVE:A POSITION AS SAP BW Consultant.SUMMARY OF PROFESSIONAL SKILLS
With 13+ years as an SAP BW/BI/HANA Developer/Consultant. Possesses very strong back end expertise, including data model design, and query building. Production support experience, conversant with SLA s, incidents, tickets, troubleshooting, fixing data load issues etc. Experienced translating requirements into functional and technical specifications/documentation. Offshore Coordination experience.. Experience in design & development of reporting solutions. Worked in SAP Native BW (3.0, 3.1, 3.5, SAP BI 7.0), SAP BW 7.3, SAP BW 7.5, R/3 4.6c, 4.7, ECC5.0, 6.0, SAP S/4HANA, SAP BW/4HANA, Oracle, SQL, AS/400, Cognos, Development, Testing / Quality Assurance, Production environments. Strong experience in SAP BW on HANA. Optimization of BW providers to HANA compatibility. Importing BW models as HANA models. Worked on platforms, SAP S/4HANA and SAP BW/4HANA Experienced with SAP Analytics Cloud/SAC and Embedded Analytics. Created and enhanced S/4HANA CDS views by implementing Annotations for Master Data(@Anyalytics.dataCategory: #DIMENSION), Transaction Data(,@Analytics.dataCategory:#FACT, @Analytics.dataCategory: #CUBE) etc and enabling Query (@Analytics.query: true) runs using TCode -RSRT. Validated query/ consumption view entry in table RSRREPDIR. Implemented Annotations relating to default rows, sorting in queries, aggregation etc. in scripted HANA CDS Views. Involved in complete life cycle implementation of SAP BW, SAP BW/4HANA . Use of HANA CDS views and mixed scenarios. Concepts around Attribute view, Analytic view, and Calculation view pertaining to HANA (HANA Views). LSA/LSA++ implementation./ Familiar/Exposure with SAP BW Integration Planning (IP). Experienced in modeling Planning objects (Aggregation Level, Filter, Planning Function, Planning Sequence, Data Slicer). Conversant implementing Planning Function types (Copy, Repost, Revaluation, Distribution by keys/Reference Data). Handled SAP CRM datasources. AWS, Snowflake, (Cloud Warehouse data) experience. Worked with business analysts to gather business requirements. Familiarity with ABAP programming (Configuring, filling and looping through Internal Tables, using Field Symbols, Binary Search on Reads, User Exits (CMOD), Start, End, Expert routines, Customer Exits(Global Variables etc)) Capability with the BEX Query Designer in designing queries set ups, to be consumed by third party systems e.g. Web Service. SAP Portal experience. SAP BW upgrade from SAP BW 3.5 to SAP BI 7.0 experience Migrated all BW 3.5 objects (update rules, transfer rules, infosources and datasources) to BI 7.0 (transformations and Data Transfer Processes, DTP s) Proficient in building and maintaining InfoCubes, ODS objects and Aggregates. Experienced writing ABAP coding in transformation routines(Start, End, Expert, Characteristic/Keyfigure) Semantically Partitioned Objects (SPO) on DSOs and Cubes. (SAP BW/BI 7.3). Performance tuning (BW Statistics, partitioning, compression, aggregates, Indexes etc) Strong understanding and application of Performance Tuning Techniques on data loads and query/reporting performance issues. Creation of Key Figures and Characteristics. Modules experience include; FI (AR, AP, GL), CO-PA, PP, SD, MM, HR/HCM,LO(Logistics Datasources), Asset Accounting. Produced reporting for new FI/GL Accounts inclusive of PL Line (Assets, Liabilities, Equity, Revenue, Cost of Sales, SGA, Amort and Depreciation, Income Tax etc.) Implemented multiple currencies-currency translation. Loaded hierarchies. Maintained Process chains to automate and schedule the loads Experience in post go-live production support and break/fix Good understanding of multidimensional and extended star schema modeling. Configuration of Transient Providers, Analytic Indexes, Open ODS Views, MultiProviders, Infosets, InfoPackages and InfoSources. Analyzed business requirements, needs and objectives and mapped them to BI processes/solutions.
Ability to activate standard Business Content from BI and R/3, ECC6.0, SAP S/4HANA ends. Conversant with datasource enhancement and data extraction Ability to load InfoCubes using PSA s and ODS; data loading (initial/delta updates); master data extractions and loading from flat files. Knowledgeable in the creation and use of Generic Extractors/DataSources in extracting data. Deep understanding of concepts around communication structure, transfer structure, the use of transfer rules and update rules in data extraction, transformation and loading. Familiar with the use of Business Objects (BOBJ) - (Crystal Reports, Web Intelligence (WebI), Dashboard (Xcelsius) as a reporting tool. Experienced in integrating and extracting data into Business object (BOBJ) environment from the SAP BW/BI database system. Loaded data from BW/BI to BPC environment for planning purposes, both Master Data and Transaction Data. Conversant with Transformation files in mapping, Conversation files to maintain formatting, Data Manager and Run Packages integrated with Process Chains. Experienced in loading data from Non- SAP Sources-Oracle, SQL: DB Connect, SAP BO Data Services. Maintained Process chains to automate and schedule the loads Conversant with Informatica. Hands on ETL (Extraction, Transformation, and Loading), data staging techniques and metadata tools.(Data Services, DB Connect). Experienced with data extraction from S/4HANA Experienced integrating BW queries into other applications. Conversant with extracting data from R/3ECC, SAP S/4HANA inclusive of LOGISTICS Cockpit. ODP and ODQ frameworks. Experienced in HANA BW modeling tool (SAP HANA Studio) Experience in SAP HANA data modeling using Attribute View, Analytic View and Calculation View Use of HANA CDS views and mixed scenarios. Conversant with Table Functions, AMDP, SQL view, Graphical views Creation and definition of data transfer logic to migrate data from the ODS, InfoCubes to the warehouse environment to support query and reporting needs. Use of Transformations and DTP s in data loads. Capabilities with SAP Business Explorer. The use of the Query Designer and Bex Analyzer in query development and presentation. Experienced in Report to Report Interface (RRI) -Jump Reports. Familiar with Business Warehouse components used in query design like calculated key figures, restricted key figures, structures, variables, exceptions and conditions. Good understanding in the use of multiple currencies in BI reporting. Experienced in Order to Cash (OTC) and Procure to Pay (P2P) Experienced with the use of BEX Information Broadcaster and the Download Scheduler to distribute reports. Ability to interface BW with SAP and non SAP systems. Conversant with Enterprise Systems Platform (ESP) Workload Manager. Familiar with Lotus Database, ManageNow, Remedy, Software Configuration Management (SCM), Project Portfolio Management System (PPMS), HP Quality Centre (HPQC). Demonstrable capability in the Open Hub Destination, Info Spoke technology/Extraction of data from BW to third party/teradeta, cognos etc. Familiar with the daily monitoring of production loads and process chain set ups. Integrated standard programs to load, activate and purge jobs via ESP (Enterprise Systems Platform). Prepared and documented Project Estimates relating to SIT (system integration testing), P2P (promote-to-production) activities, SMTD (system maintenance and technical document), Core Configuration/Deployment, Tracking and Mentoring, UAT Support (execution, defect fixes and release), Impact Analysis, Unit and Integration Tests, Functional and Technical Designs (preparation and review). Production support experience, fixed issues after root cause analysis (RCA) Familiar with tickets resolution and SLA s. SAP BW Archiving experience. Deep understanding of the concept of data temperature (hot, warm, cold) and the need to implement 'Information Life Cycle Management' to data. Archived data from ADSO, InfoCube, DSO with the selection profile (Time Slice Archiving/Request based Archiving) relating to NLS (Near-Line Storage). Reload of NLS/Archived data back to Infoprovider (ADSO, INFOCUBE, DSO) Performed settings for Sybase IQ and SAP BW on HANA system connections test in the BW Administration Workbench. Performed connection tests for Sybase IQ and SAP BW on HANA (running programme ADBC_TEST_CONNECTION). Accessed NLS tables /archived data (Programme RSDA_SYB_PARTITION_MONITOR) Programme RSDA_SYB_PARTITION_MONITOR-monitor and possibly reduce the number of partitions due to frequency of archiving. Conversant with the Partion Monitor for Near-Line table in Sybase IQ. Configured BEX Query Designer to access NLS/Archived data for reporting purposes. Familiar with DTO (Data Tiering Optimization) and the implementation of Static and Dynamic Partitioning in BW/4HANA. Built process chains with the process type 'Archive Data from Info Provider' to automate archiving. Conversant with SAP BW Security/ Authorizations modeling/Analysis Authorization. Experienced in the use of SLT (SAP Landscale Transformation) Replecation Server as an ETL tool to replicate data (inserts, updates and deletes) to the HANA Database for real time reporting. Good understanding of SLT data provision scenarios ( Load, Replicate, Stop Replication, Suspend, Resume). Abreast with the functions of the components ( DB Trigger, Logging Table, Read Module, Control Module and Write Module) involved in the data flow within the SLT. Transferred Master Data and Transactional Data from SAP ERP (S/4HANA, ECC) and to Amazon Simple Storage Service (S3)data lake/3rd Party. Generated OData Service in SEGW (TCode) Exposed SAP datasources (extractors and CDS Views to OData API's/Service, ODP-Based Data Extraction via OData). In the Amazon Management Console created Amazon S3 bucket. Created the necessary connection to the Source System (ECC, S/4HANA), and configured Amazon AppFlow to load data to Amazon S3 via the OData Service. Run the data flows at various frequencies ( on a schedule, in response to a business event, or on demand). Extracted data from SAP BW/4HANA via OData Service BW Infoprovider into the storage of the receiving application/3rd Party Generated SAP OData Service on SAP BW Queries. Registered generated OData Service ( /n/IWFND/MAINT_SERVICE). Importance of the Function Module RSEQ_NAT_GENERATION in the successful registration of OData Service. Implemented Data writeback from SAP Analytic Cloud (SAC) to SAP BW4 HANA through Open Data Protocol (OData) Services. Experienced with AMS as a supporting tool for generation of alerts and service requests for incident resolution/tickets by subject matter experts and ITSM processes. HANA Data Modelling experience. Experienced with HANA modelling, (Attribute Views, Analytic Views, Calculation Views, Data Provisioning,) Developing Information Models using Graphical & Script-based Calculation Views such as Dimension, Cube, Cube with Star Join etc. Knowledge of the different types of joins that go into the creation of the information views. Usage of different types of nodes in calculation views and aggregation of measures. Creation of restricted and calculated columns along with filters.EMPLOYMENT HISTORY
Client: General MotorsApril 2014 - May 2024Capacity: SAP BW HANA Snr Developer As Lead, regularly communicated project progress, issues, and risks to Project Manager. Acted in capacity as thought leader to successfully architect, design, model, implement, integrate, test and maintain BI and related applications. Worked with business and functional teams to define and convert business requirements, processes and designs into comprehensive, robust, efficient, scalable and stable BI Solutions. Worked with the Project Manager to check if the topology defined for the BW implementation is right and if all factors have been taken into consideration.
Worked with the Project Manager to check the development work completed. Managed BW testing and validation. Managed and organized BW transports between systems. Demonstrated experience in managing application changes for SAP BW systems by reviewing technical specs, configuration document and development. Demonstrated experience in performing budgeting related activities. Worked in a team environment using a structured development process and delivered on time and within budget. Identified impact to business resulting from newly configured or improved business functionality, and identified methods for addressing business change impacts. Participated in high level planning and design discussions with Business Analysts. Extensively used SAP Analytical Cloud/SAC leveraged on Query Designer to build interactive reports for the business employing Linked Analysis. Involved in End-to-End development in SAP BW/4HANA modeling ADSOs, Composite Providers, Open ODS views, DTPs, Transformations, InfoObjects etc Loaded data from S4/HANA/Source via ODQMON ( Operational Data Provisioning) . Created and enhanced S/4HANA CDS views by implementing Annotations for Master Data(@Anyalytics.dataCategory: #DIMENSION), Transaction Data(,@Analytics.dataCategory:#FACT, @Analytics.dataCategory: #CUBE) etc and enabling Query (@Analytics.query: true) runs using TCode -RSRT. Validated query/ consumption view entry in table RSRREPDIR. Implemented Annotations relating to default rows, sorting in queries, aggregation etc. in scripted HANA CDS Views. Involved in complete life cycle implementation of SAP BW, SAP BW/4HANA . Developed standard and custom SAP BW Extractors, SAP BW on HANA features such as advanced DSOs, Composite providers, Open ODS views, exposing BW models as HANA views Involved in testing the extractors, data loads and reports before transporting into production. Extracted Master data and Transaction data from SAP ECC SD module.
Uploaded master data and transactional data from Flat File and SAP ECC to BW system.
Worked extensively on standard and custom defined LO Extractions. Used LO-COCKPIT structure for extracting sales order, delivery, billing information. Filled setup tables, performed initialization and started delta process.
Integrated purchasing extractors and pulled reports to track supplies relating to orders. Integrated sales extractors and pulled reports to show outstanding sales orders and backlogs. Integrated Production Planning extractor and pulled reports to track production orders to fulfill order to achieve on-time delivery (performance). Integrated Billing and Accounts Receivable extractors to monitor and follow-up outstanding balances. Used extractors and cubes such as: 2LIS_11_VASCL, 2LIS_11_V_SSL, OSD_C02; 2LIS_02_SCL, 2LIS_02_SGR, 0PUR_C10: 2LIS_04_P_ARBPL, OPP_C04; 2LIS_13_VDITM, OSD_C03; OFI_AR_4, OFIAR_C04. data to the HANA Database with the use of SLT. HANA Data Modelling experience. Experienced with HANA modelling, (Attribute Views, Analytic Views, Calculation Views, Data Provisioning,) Developing Information Models using Graphical & Script-based Calculation Views such as Dimension, Cube, Cube with Star Join etc. Knowledge of the different types of joins that go into the creation of the information views. Usage of different types of nodes in calculation views and aggregation of measures. Creation of restricted and calculated columns along with filters. Involved in mixed/hybrid scenarios (HANA views and BW data integration). Handled data loads from ECC, S/4HANA to the HANA Database with the integration of SLT (SAP Landscape Transformation) Replication Server, for both Master Data ('Load' scenario) and Transaction Data ('Replicate' scenario) for real-time reporting. Good working knowledge with Data Services BODS. Experience with JIRA. Employed data manupulation techniques like transformation, conversion and filtering in updating data to the HANA Database with the use of SLT.Client: Coca-Cola
May 2013 - October 2013Capacity: SAP BW Consultant. Implemented COPA (Cost and Profitability Analysis). Built COPA datasources for two Operating Concerns. Carried out enhancements on COPA datasources(CMOD, user exit wrote ABAP logic to populate new fields). Replicated datasources from SAP ECC to BW/BI environment. Migrated datasources from 3x to 7.3 functionality. Created and designed COPA Cube. Further hands-on creation and design of History and Consolidated Cubes. Created DSOs, DTPs, Infopackages, Mapped using Transformations. Created custom infoobjects (Zobjects) to enhance infoproviders (DSOs, Cubes, Multiproviders) Modeled a Reversal Cube, integrating it with the COPA Cube for data load reversals.
Build Multiproviders and assigned infoobjects to cubes (mappings within multiproviders). Developed Process Chain to automate loads. Loaded both Master and Transactional Data. Involved extensively in the design and modification of queries using the BEX Query Designer. Used Structures, integrating Formulae and Selections within structures. Configured Calculated KeyFigures (CKFs) based on Framework to meet requirements. Configured CKFs for elements/components of Cost of Goods Sold (COGS) (COGS-standard, COGS-funding and tax, COGS-variances). Configured CKFs for Gross Revenue, Discounts and Authorized Revenue.
Configured CKFs for both Non-Marketing and Marketing Deductions. Derived Net Sales Revenue (NSR) a.k.a Dead Net Sales based on Revenues and Deduction- a CKF. Derived Gross Profit based on NSR and COGS-a CKF. Configured Restricted KeyFigures (RKFs) with filters on Currency, Unit of Measure, Operating Concern etc. Made changes to/modified existing queries to conform to new business requirements. Formulated reporting in alternated units of measures by dynamic conversion at query run time based on Unit of Measure variable on the selection screen. Created variables. Maintained Quantity Conversion with a fixed unit as source and variable as target. Maintained unit input as text in variables employing Replacement Path as a process in query development. Created Views based on standard queries from BEX Analyzer and saved them to the Portal for User access. Developed various reports such as Gross Profit Analysis, Sales Analysis Performance(Comparison), Sales Analysis Performance(Trend), Mix Analysis ( Discounts, Volume, NSR, GSR),Top # Monthly, Top # Yearly, COPA Gross Profit Statement, COPA Net Income Statement, Contribution Margin, Daily Sales Details, Accounts Receivable (OTC-Order to Cash) etc. Carried out both unit and integrated tests. Created test scripts and documented tests, taking screenshots. Carried out transports from Development to Testing/QA and to Production.Client: Corning Cable Systems
May 2012 - March 2013Capacity: SAP BW Consultant Architected design in the implementation of CO-PA Involved in requirement gathering. Put together both functional and technical documents. ASAP methodology. Experienced with CO-PA re-alignments. Installed and activated business content. Utilized the IT Change Management (ITCM) tool/Cherwell to create an RFC (Request For Change) to move transports into production with Risk Assessments. Involved in transport imports and re-imports (STMS, SE10). Conversant with Clarify. Accepted and Created cases for troubleshooting. Co-ordinated and liased with Basis team in HAPO (High Availability Planned Outage) activities. Created and re-scheduled process chains. Carried out unit and integration tests. Documented test plans. Worked with Query Designer in creating queries, incorporating structures, calculated key figures, formulae, variables, conditions, exceptions, restricted key figures. Worked on performance related issues by Creating Aggregates & Roll-Ups, Compression, InfoCube partitioning (logical and database), Line Item Dimension and Indexing.
Utilized Business Objects (BOBJ) reporting tools (Crystal Reports, Web Intelligence (WebI), Dashboard (Xcelsius) in building reports. Configured generic datasources. Performed datasource enhancements, CMOD, User Exits configuration and customization. Created new cubes, DSOs, Zobjects. Semantically Partitioned Objects (SPO) on DSOs and Cubes. Used Clarify to create cases relating to troubleshooting/fixes. Maintained mapping, transformations, DTPs, Infopackages. Implemented Open Hub Services for data load from BW to a third party/cognos reporting.WIPRO TECHNOLOGYNovember 2010 - February 2012Capacity: SAP BW Developer. Had a series of meetings with client to contineously gather new requirements for implementation. Built ODS s and Cubes from the scratch. Built ODS s and Cubes patterned after existing ODS s and Cubes. Configured Infosources for Flat file load. Maintained Update and Transfer rules between providers and Infosources. Created new Zobjects, incorporating them in ODS s and Cubes for data loads. Configured custom InfoObjects as providers for Master Data loads. Created new Infoset, included new ODS and existing ODS s in the new Infoset. Created new Multiproviders, included new Cubes and existing Cubes in the new multiproviders.
Maintained correct mapping of objects within the Infoset and Multiprovider. Enhanced existing datasource in ECC6/SAP R/3 with new fields, created new Zobjects in BW to map appropriately. Built new Generic datasources to load data from tables in SAP R/3, built new providers (Staging ODS) to load the data in BW. Replicated datasources. Built Infopackages both for Initialization and Delta loads. Loaded data into BW using the tool, APD (Analysis Process Designer). Performed data extraction to consolidate data in Business Planning and Consolidation (BPC) cubes with SAP Net Weaver 7.0 BI as the backend server. Involved in UAT (User Acceptance Testing). Built reports employing Business Objects (BOBJ) reporting tools (Crystal Reports, Web Intelligence (WebI), Dashboard (Xcelsius). Leveraged P2P (Procure-to-Pay) vis- -vis Material Management (MM). Integrated extractors and cubes relating to purchase orders and goods receipts to track incoming orders. Integrated extractors and cubes relating to invoices and accounts payable to monitor and track payments. Used purchasing cubes and extractors such as Purchasing Data (0PUR _C01), Vendor Evaluation (0PUR_C02), Purchasing Groups (0PUR_C04), 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_02_SGR,), OFI_AP_4, OFIAP_C04 to fulfill reporting requirement.
Generated invoices for items with the extractor 2LIS_06_INV. Worked extensively in the Testing environment / Quality Assurance, conducted Unit and Integration testing on developed objects and structures. Liaised with Data Warehouse (DW) for Unix Scripting for Flat File loads from other Non-SAP sources (IP-Island Pacific, Commertrics, MQ, Prothesus, B2B, E-Commerce etc.), WCS, into BW. Produced reporting for new FI/GL Accounts inclusive of PL Line (Assets, Liabilities, Equity, Revenue, Cost of Sales, SGA, Amort and Depreciation, Income Tax etc.) Implemented multiple currencies-currency translation. Conducted System Integration Tests (SIT) Documented Test Plans, run Test Plans in Test Lab. in HP Quality Center. Took Screen Shots as attachments. In the Production environment, worked with other consultants to incorporate and schedule ESP jobs for automated data loads in Infopackages. Prepared ISS Requests for Quality Assurance / QA (test environment) and P2P (Promote-to- Production) relating to transports. Extended or set to Complete SCM Status. Prepared ESP drafts (Regular and Emergency). Participated and experienced in Business Intelligence Accelerator (BIA/BWA) upgrade.
Deleted and rebuilt BIA/BWA indexes.
Conducted BIA/BWA Connection Availability and System checks. Deleted data intermittently from cubes before index rebuild where technically sound, taking into cognizance of DB2 load balancing effect. Run test reports with and without BIA/BWA index to authenticate performance improvement before and after upgrade. Performed monthly BIA/BWA Re-org. /Reorganize BIA/BWA Landscape via TREX ADMIN tool in Advanced Mode. Created Infopackages for uploading master and transaction data. Created and maintained Process chains for daily delta loads.
Worked on performance related issues by Creating Aggregates & Roll-Ups, Compression, InfoCube partitioning (logical and database), Line Item Dimension and Indexing.
Worked on Query Design including Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables. |
