We provide IT Staff Augmentation Services!

Senior Consultant - Sap Hana/bods/bw/bobj Resume

New, JerseY

SUMMARY:

  • SAP HANA and BI/BOBJ Consultant with more than 11 years of SAP consulting experience in Oil and Gas, Manufacturing, High - Tech, Energy, Financial, Sales and Distribution industries.
  • Worked for top clients like, Royal Mail UK, Confidential, Glaxo Smith Kline, Confidential, Confidential, and Confidential & Confidential .
  • Worked on International roll outs for US clients.
  • Successfully taken-to-live 2 Implementations and global roll outs.
  • Expertise and Excellent work experience in Business Objects reporting, ETL and Data Warehouse Solutions, SAP Best Practices, ASAP Methodology, Agile methodology, Reporting using SAP tools across multiple SAP systems including SAP HANA, BODS, BOBJ, SAP BW 7.0/ 7.4 and RDBMSs (Oracle, Teradata, SQL Server).
  • Expertise in HANA modelling using attribute view, analytical view, calculation view, decision tables, sequences etc.
  • Excellent Experience Working on Business requirements, Solution Proposals, Technical Specifications, Delivering Solutions, and Hyper care.
  • Excellent Project Experience translating business challenges/complexities into business requirements, Designing, Developing and Implementing Complex Business Objects, ETL and SAP HANA Solutions.
  • Rich Experience Directly Interacting with senior IT Management and Business SPOCs; working across business and technology teams to ensure alignment of Business Needs & Solution Architecture.
  • Experienced in activating SAP HANA-Optimized BW content in BW 7.4 for Data modelling.
  • Experienced in Working with business Sub process leads and functional consultants to figure out the gaps in functional requirement and proposing BW modelling designs.
  • Experienced in developing Virtual Data Mart and EDW core layer after content activation.
  • Experienced in Activating Material, Product and Customer Master and loading Text attributes.
  • Experienced in designing solutions using BODS from different source systems into BW and HANA.
  • Hands on knowledge of creating Transient providers based on Analytic index.
  • Experienced in Designing solution to enable consumption of Sales to Retailers and Distributor Inventory from BW to APO system.
  • Experienced in performing Code review, Technical Unit testing (TUT) with architect and client COE’s
  • Experienced in creating advanced DSO, Open ODS views and Composite providers using BW modelling tools in eclipse environment.
  • Experienced in defining Transport strategy for integrated environments.
  • Hands on experience of creating SLT configuration and ODP Logical System.
  • Hands on experience in preparing Database view for source tables for the replication.
  • Hands on experience of creating Advanced DSO’s in Eclipse environment.
  • Good Experience in designing data warehousing Solutions across CPG and ISU domains.
  • Good Knowledge of CPG and Utilities industry stages and business cycle.
  • Successful implementation of one end to end project in HANA.
  • Over 2-year real time project experience implementing SAP HANA Solution.
  • Experienced in SAP HANA data provisioning, data modelling using Attribute View, Analytic View, and Calculation View, Decision
  • Table, Sequence, and programming including SQL and SQL Script.
  • Experienced in SAP HANA administration including managing schemas, data model objects, import/export content, and SAP HANA Security.
  • Experienced with data provisioning technologies for HANA such as SLT & BODS.
  • Experienced with Currency conversion for user defined currency by input parameter.
  • Experienced with Language dependent text to provide text according to logged in user.
  • Experienced with User input methods using Input parameters and restrict data using Variables and filters.
  • Experienced with different referential join, inner join, left outer join, right outer join, text join and temporal join.
  • Experienced with Union, projection, aggregation and join calculation view.
  • Experienced with security features in HANA i.e. SQL, Analytical, Package and System privileges.
  • Good experience of SLT data provisioning, administration, and its monitoring.
  • Hand on experience of HANA XS, ODATA services, CDS Views and web APIs development.
  • Hands on experience of data provisioning using SDA and SDI offering of SAP.
  • Knowledge of S4/HANA Finance, Embedded Analytics and Designing Fiori applications.
  • Experience with on HANA Application Lifecycle Manager to transport Code from one landscape to another.
  • Hands on experience of creating ABAP CDS views and using them as source for developing reporting solutions.
  • Experienced with advance replication setting for data filter, table restructuring and table partitioning to handle big data for modelling.
  • Knowledge of Integrating Tableau and HANA.
  • Successfully implemented 3 Business object implementation projects using BOBJ tools like Dashboards, Xcelsius, Interactive analysis, Webi, explorer, Lumira etc.
  • Experienced with requirement gathering, data profiling, and documentation of business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
  • Experienced in SAP Business Object report development using IDT, UDT, Web Intelligence, Design Studio, Dashboard Designer, Analysis, explorer, Excel, QAWS, Query browser, BICS connection and Live office.
  • Experienced in SAP Business Object administration like user management, promotion, scheduling, SSO, connection creation, manage services.
  • Experienced in SAP ECC table data model and analysis and integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, BODS etc.
  • Experienced with web tools like Launch pad and CMC (Central Management Console).
  • Experienced with BW Bex queries and BW 7.x.
  • Experienced with ETL tools such as SAP BODS by making various connections to load and extract data to and from third party databases (SAP, Oracle etc.) or systems.
  • Experienced with Production Support role 24/7 to resolve the issues.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Senior Consultant - SAP HANA/BODS/BW/BOBJ

Responsibilities:

  • Leads requirements gathering sessions with Power Users and End Users for CO-PA. FI, MM and SD analytics requirement.
  • Created holistic and optimal functional model designs that can accommodate multiple business requirements and collaborates with Power Users to ensure any near future requirements are incorporated in the overall design solution.
  • Facilitates modelling sessions and design walkthroughs with development team members.
  • Maintains functional documentation, data dictionary and other artifacts critical to the BI team’s ability to accelerate report development and increases overall data structure understanding.
  • Educates Power Users on model designs and mapping of data to business processes.
  • Assist Power Users with complex report requirements and guides and directs Power Users to appropriate models for report design.
  • Responsible for following escalation process, development, engagement, publishing and other guidelines as defined by the Organization.
  • Collaborates with technical teams to clarify functional requirements and provide input in technical design as needed.
  • Reviews test cases provided by requestor and ensures test data is available in software development quality environments.
  • Reviews unit testing results, participates in integration testing and coordinates user acceptance testing with initial requestor.
  • Identifies new enhancement opportunities.
  • Assist in project prioritization, business case development, and various technical implementations program initiatives.
  • Participates in testing of new and updated models and application upgrades.
  • Provides feedback on system performance and report findings to admins and developers.
  • Follow change management protocols, validates transports and applies agreed best practices.
  • Managed and delivered a migration project to move Customer profitability reports to BICS connections from Universe.
  • Designed reporting solutions by using BW models based on following extractors.
  • Delivered a Reporting solution which enabled business to compare forecast to production plan for materials to identify areas/items where planning information is not properly flowing down. Forecast and production planning data was extracted from APO in BW and moved to reporting layer. A Bex query and BICS connection was developed with a WEBI report on top of it.
  • Developed and Supported Reporting solutions for Inventory, Purchasing, Planning, Plant Operations, Supply Network Collaboration, and Transportation business areas.
  • Collaborate with System Administrators in production support of the SAP BOBJ and SAP BW platform.
  • Implemented appropriate security policies in collaboration with security team within the BO repository.
  • Designed reporting solutions for Logistics and Transportation department to improve the efficiency of inbound deliveries and shipments within plants and customers.
  • Designed BODS ETL solution to enable reporting on Point of Sale data for Canada region using BODS and BW 7.x.
  • Designed BW Objects, Bex Queries using BI 7.x environment.
  • Designed Universes and BICS connections with UDT/IDT on BOBJ 4.1 environment.
  • Knowledge of BOBJ CMC, Data services CMC and BOBJ security setups.
  • Developed WEBI, Crystal Reports and Analysis for office using BI Launchpad.
  • Enhanced BW standard extractors using BADI’s and Exit.
  • Developed Custom extractor for Sales, Logistics and Procurement data.
  • Working with process owners (OTC, R2R, P2P, MM etc) in designing reporting solutions as per business needs.
  • Performing month end reconciliation between source systems/Financials and reporting systems.
  • Organized testing requirement gathering sessions with BW/BOBJ Architect and process owners.
  • Prepared test plan for BOBJ reports of A2R, P2P, O2C and F2C functional areas.
  • Involved in finalizing smoke test for pre-cutover and post -cutover activities with business.
  • Designed testing strategy for BOBJ report roles validations after Go-live.
  • Writing test scripts in HP QC to test BOBJ reports for following areas like Finance, Order Management, Sales, Sales and Profitability Analysis, Supply Chain.
  • Created Test set within Test Lab for Quality testing and mock prods testing.
  • Tracked the execution of test cases and shared the status reports to client management team.

Confidential

Senior Consultant - SAP BODS/BW/HANA/BO

Responsibilities:

  • Provided design documents and translates into component-level designs to accelerate development.
  • Provided design expertise in support of development team efforts to provide flexible reusable components to increase cost effectiveness. Analyzes designs and reviews design of applications and suites of applications to ensure that customer specifications are satisfied.
  • Assists in reviewing and analyzing gathered information in technical research and in evaluating tools and methodologies to ensure that designs adhere to current industry, client and company standards. Develops and provides technical documentation; participates and oversees test-plan development, integration and deployment.
  • Participated in business process work sessions, project meetings and joint applications development sessions to ensure that product design decisions are communicated to departmental personnel.
  • Functions as a domain expert and works closely with software developers to explain the application design, and coordinates activities between the two functions to enhance product quality and efficiency.
  • Utilized experience in development methodologies, coding documentation, testing methodology and industry standards to define and develop project requirements, functional specifications and detailed design of application solutions for clients.
  • Provides leadership and work guidance to less experienced personnel. Guides the work to less experienced developers to create, maintain and communicate details of application designs to ensure that designs are according to specifications.
  • Developed Data store connection in BODS for Teradata as source and BW 7.4 and HANA Native as target.
  • Developed Data services Data source in BW 7.4 based upon Data Services Logical system
  • Imported the BW Data source (template tables) in Target Data Store of BODS.
  • Imported tables from Teradata to Source Data Store.
  • Developed Data store connection between BODS and BW (7.4) data source.
  • Developed Project, Job, Workflow, and Dataflow to move data from Teradata tables to BW.
  • Validating dataflow and executing job to perform data transfer from source to target.
  • Coordinating with offshore BODS development team for performing code reviews.
  • Activating SAP HANA-Optimized BW content in BW 7.4 to support Analytics for O2C, F2S and P2P areas.
  • Working with business Sub process leads and functional consultants to figure out the gaps in functional
  • Requirement and proposing BW modelling designs which would support the corresponding report.
  • Activating HANA optimized Business Content for Billing, Conditions, Delivery and Sales Overview areas.
  • Installing HANA Live views.
  • Objects under Virtual Data Mart and EDW core layer were maintained after content activation.
  • Activating Material, Product and Customer Master and loading Text, attributes and Hierarchy.
  • Developed Custom info objects for Outlet Master/Transaction data coming from Teradata into BW.
  • Hands on knowledge of creating Transient providers based on Analytic index.
  • Designed and developed solution to enable consumption of Sales to Retailers and Distributor Inventory from
  • BW to APO system.
  • Developed BW Model on top of Supply Chain Event Management Extractors like Event Handler Header data, events (Expected and Unplanned) and Group of Expected Events.
  • Performing Code review, Technical Unit testing (TUT) with architect and FUT with COE from client.
  • Created ADSO, Open ODS views and Composite providers using BW Modelling tools.
  • Actively involved while defining Transport strategy for integrated environments.
  • Hands on experience of creating HANA objects using SQL.
  • Created tables like Product, Region, and Sales in the Schema.
  • Activating Modelling views using Grant and user SYS REPO.
  • Created new Package in Content within the Schema.
  • Created Attribute View, Analytic views, and calculation views.
  • Created Analytic View using Left Outer join between Sales and Region Attribute View based upon
  • Region Id.
  • Created Inner Join, Left Outer Join, Right Outer Join and Full Outer Join between Customer and Sales Order tables.
  • Performed Schema Mapping in Modeller Perspective.
  • Created Analytic Privileges for users.
  • Performed Data Provisioning with SLT replication for SAP TM and SAP EWM tables in corresponding TM and
  • EWM schemas in HANA Studio.
  • Performed SLT configuration with SAP and HANA native systems.
  • Experience of creating IDT connection between HANA Native and Web Intelligence for reporting.
  • Created BICS connections with Analysis office and Lumira to enable Analytics based on Bex queries and
  • BW Infoproviders.
  • Migrating WEBI reports based on Universe to BICS connections.
  • Performed POC’s to enable Lumira analysis based on HANA views and BW info providers.
  • Business Intelligence Development Guideline for BW 7.4 SP06 on HANA and HANA Native (SP7).
  • SAP BW on HANA and ECC Transport Procedures as per MillerCoors Landscape.
  • SAP Data Services naming standard document.
  • Interface technical template for flat file load to HANA.
  • Interface technical template for SAP BW 7.4.
  • Interface technical template from Non-SAP Systems to HANA by BODS.
  • Helped business users in finalizing the Functional Specifications for areas like OTC (Order to Cash),
  • A2R (Account to Reporting), F2S (Forecast to Stock) and Interface Analytics (ANA).

Confidential

Senior Consultant - SAP BI Senior Consultant (Offshore Lead)

Responsibilities:

  • Supporting BI modelling and reporting for CCS, EAM Generation, FI, HR, Master Data and Supply Chain.
  • Monitoring process chains in production environment and tracking jobs performance.
  • Maintaining and Enhancing Multiproviders, Info cubes, DSO’s, Infosets in existing BI landscape.
  • Monitoring and Maintenance of BODS data load jobs which extract data from third party systems.
  • Performed effort estimation of each phase of development for Minor enhancements.
  • Performed extraction for Open items, Sales Statistics and Cleared items data from ECC to BI.
  • Enhancing Open items, Sales statistics reports based upon new requirements from users.
  • Maintenance of WEBI reports based upon universes created upon Bex Queries.
  • Web Intelligence Report development using Universes developed on Bex Queries.
  • Performing Unit testing of Bex reports and Web Intelligence Report.
  • Creating Functional and Technical specifications for minor enhancements.
  • Actively involved in requirement gathering and sign off activities with stake holders.
  • Preparing end user training manuals for BI.
  • Mentoring new members in offshore BI team to speed up daily support activities.
  • Coordinating with onsite team and client SME’s and sharing daily status updates with them.
  • Publishing weekly SLA reports with onsite and offshore Service delivery managers.
  • Actively handled data load dependencies from Redwood Scheduling tool.
  • Leading offshore BI/BO application team and also playing role as an SPOC.
  • Involved in full life cycle implementation, which includes Analysis, Requirements gathering, and realization.
  • Interacted with Business Users and Business Analysts to understand and document the requirements.
  • Universes for end user reports generation using SAP BI/BO web intelligence.
  • Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.
  • Created HANA modelling scenarios and activities such as adding a system, creating schemas and developed
  • Complex SQL scripts in Calculation views for MPSC Customers.
  • Designed SAP HANA Security including User Management, Roles, and privileges.
  • Involved in Information Design Tool - Creation of Data Foundation, Universe for reporting on top of HANA views.

Confidential

Senior Consultant - SAP BI Consultant

Responsibilities:

  • Creating new queries in Bex Analyzer on existing multiproviders and Infocubes.
  • Creating restricted and calculated key figures.
  • Implemented BI Authorizations (Hierarchical) for different users.
  • Development and Maintenance of BO universes based on SAP BW.
  • Coordinating with Enterprise Portal team to publish Bex queries in BI Portal.
  • Web Intelligence Report development using Universes developed on Bex Queries.
  • Performing Unit testing of Bex reports and Web Intelligence Report.
  • Creating Functional and Technical specifications.
  • Actively involved in requirement gathering and sign off activities with stake holders.

Confidential

Senior Consultant - SAP BI Consultant

Responsibilities:

  • Coordinating with onshore consultants and business owners to understand reporting requirements and capturing them in Functional documents.
  • Created Functional and Technical specifications, including Master data, Infocube, Multiprovider, DSO and
  • Query Designs.
  • Loading Hierarchies, Attribute, and Text data into Info Objects.
  • Managed BI System Testing and Integration testing from offshore and onshore.
  • Performing Reconciliation of ECC (FICO and OTC) data with the data in corresponding BI reports.
  • Visited client side (UK) for Knowledge transfer required for BI Integration Phase.
  • Leaded a team of 4 Associate Consultants from offshore.

Confidential

Senior Consultant - SAP BI Consultant

Responsibilities:

  • Installing and Activating the Standard Info Cubes, Info Objects and various other relevant Objects.
  • Preparing Functional and Technical documents as per business requirement and change requests.
  • Enhancing Standard Info cubes, Info Objects, and Data Sources.
  • Creating generic data sources (using Function Module and View) to fetch the data from R/3 and CRM.
  • Installation from BI Contents.
  • Data modelling using extended star schema concepts
  • Using Aggregates and Partitioning to solve performance related issues.
  • Creating queries in business explorer (BEx).
  • Created Replacement path variables, Customer exits to populate variables.
  • Creating and monitoring process chain.
  • Performing Structural and Authorization testing of BI reports.
  • Transportation of all developments to Quality and production environment.
  • Writing and Executing test scripts to test BI reports.
  • Created CRM and HR data with Functional Consultants for Regression and Integration testing.
  • Performing Unit and system integration testing for BI reports.
  • Performing Reconciliation of ECC (CRM and HR) data with the data in BI reports.

Confidential

SAP Consultant

Responsibilities:

  • Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
  • Involved in submitting the Ticket Status (Open/Close) report.
  • Maintain Work History for all the tickets until it is closed down.
  • Involved in validating data consistency in reporting with Data Target against PSA after loading.
  • Involved in developing the SLA reports at end of every month.
  • Involved in Debugging Update Routines, Start routines, Transfer Routines.
  • Involved in maintaining lot of documentation for all the Support Activities.
  • Writing test conditions from the functional specification.
  • Writing test scripts from functional specifications in test plan within Mercury Quality Centre.
  • Executing test scripts manually using Mercury quality centre.
  • Raising defects in Mercury Quality Centre.
  • Raising defects in quality centre and assigning them to the defect manger.
  • Performing regression testing after code merges.
  • Develop Test cases for integration and user acceptance testing.
  • Configure changes to Access sequences to allow for customer hierarchy (used specifically to group customers) using hierarchy node and access sequence to pick up product hierarchy.
  • Configured Rebates, and tested pricing requirements for Pricing Condition type and Rebate Condition type (e.g. include/exclude certain order types or user ids).
  • Performed scenario testing, and integration testing for the Order-to Cash.

Confidential

Associate SAP (BI)

Responsibilities:

  • Installed Business Content Sales Overview Cube and designed and activated Customer service to meet user needs. Created several ODS objects which acts as data staging.
  • Configured Data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for Periodic loads.
  • Involved in Creating and maintaining Info Cubes, Operational Data store, PSA, Info Objects, Info Areas, Multiproviders, Info sources, Data Sources, and Info Packages.
  • Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using Bex Analyzer, Designed and developed several workbooks and global Views.
  • Gathered reporting requirements and designed the data flow From SAP R/3 to BW for Specific Functional areas Like, FI-CO, Sales Distribution.
  • Configured The Business Consolidations cube loaded R/3 data and designed and developed several Reports.
  • Involved in creation of reporting using BEx Analyzer such that the execution time is evenly distributed throughout the report by using free characteristics, Restricted Key figures, and Calculated Key figures, Variables, Exceptions.
  • Uploaded master and Transactional data from flat files, SAP BW and SAP R/3.
  • Transported developed objects from development box to quality box.
  • Created ODS, Cubes and Multiproviders to load the transactional data according to the BW star schema documents and data flow diagrams.
  • Loaded the master data and transactional data.
  • Updated Data through PSA for Info Cube, ODS using Delta, Full update.
  • Updated Data from ODS to Info Cube using with Delta Update.
  • Worked with LO-Cockpit, CO-PA,FI/CO, Generic extractions
  • As a Technical Consultant, I have been Involved to develop Reports using BEx Query Designer.
  • Understanding the specifications provided by the functional consultants, interacting with onsite team to get to know the exact requirements, suggest them the changes where required and then develop the objects as per the evolved specifications.
  • Developed flexible queries using Filters, Free Characteristics, Navigational attributes in BEX analyser to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
  • Involved in Creation of Reports such that the execution time is evenly distributed throughout the Report using Restricted Key Figures, Calculated Key Figures, Variables, Exceptions, Conditions and RRI concept.
  • Maintain Aggregates, Rollups, and Compression for improving query performance.
  • Creation of Process Chains for Master Data and Transaction data.
  • Executing Consolidation task in Confidential system against each Group Reporting Account.
  • Performing reconciliation of data between ECC, BW and Confidential systems.
  • Worked on Transport management to transport objects across landscape (DEV, QA & PROD).

Hire Now