Data Migration Sap Bi
Resume:
Jayant Kumar Nayak ***** Independence Pkwy, Plano, TX 75025
SAP Analytics/Planning, Auditing
*********@*****.***
Summary
SAP Integrated Business Planning (IBP) Functional Certified, NetWeaver 2004s-BI 7.0 Certified, HANA Certified, Over 22 years of SAP BI/Tableau/BODS/HANA experience in IT Industry, including full life cycle Implementation and production support for SAP BI/BObj Projects for diversified Business Organizations,
Experience in Big5 Consulting Companies, that includes areas on SAP BW 3.X, BI 7.0 and SAP Business Object 4.0, BODS, Dashboard Design, Information Design Tool/Business Layer using Xcelsius 2008 and SAP FI, SD, MM, HR, BCS.
Involved in internal audit and working with external auditors
Working experience on S/4 Data Migration cockpit
Working on SAC Planning model performing NetEx, Sales Planning, Forecasting
Extensive experience in assessing the company business process, Developed BOBJ Reports for Enterprise customers and partners to implement enterprise solution.
Validating and testing Rules and Views in Information Steward.
Expertise in various versions of SAP BW / BI including 7.0 with multiple implementation experience with ABAP, BEX, WAD, Crystal Reports and BOBJ 3.X/4.0
Expertise in all the areas of BI, Data Extraction, Data Modeling, Data Loading (ETL), Performance Tuning, Reporting and Administration
Expert level skills in extracting data from ECC, SD,FI-CO,FI-AP, FI-GL using Business Content extractors, Generic extractors, Sql Server, Flat Files and HANA.
Experience in BOBJ4.2, Dashboard, Crystal Reports, Web-Intelligence, Infoview, IDT, Xcelsius.
Strong Knowledge of third-party tools (Redwood, HP SM7 and Solution Manager) used for SAP Batch job monitoring, ticket tracking and SAP Transport Management.
Documented Test Plans and complete Unit Testing of Developed Objects and Reports. Worked with Quality Assurance business resources to complete System and Integration Testing.
Expertise in HANA scripts, HANA Data modeling scenarios and activities of developing schemas, importing table definitions, adding connections.
Setting preferences for modeler, HANA studio with overall experience in all aspects of modeling in SAP HANA.
Worked with BODS Data services 4.0 flat files from SAP, efficiently using FTP to get/put the files from/to SAP R3 Application Server for the target table population.
Created Process Chain and Meta chain to automate Data load into Cubes, ODS and other InfoProviders
Technical Skills:
Languages: VB, ASP, HTML, JavaScript
Databases: MS SQL Server, HANA
Reporting: Crystal Report, BEx, WebI, Tableau, Power BI,SAP Analytic Cloud, Analysis Office
OLAP: SAP BI, BOBJ 3.X/4.1, BODS, S/4 Data migration, Embedded Analytics
Testing Tools: ECATT, Mercury Tools, ALM
Tools: Redwood, SM7, ControlM
Platforms: MS DOS, Windows, Win NT
Experience/Project Work
Industry: Telecom
Duration – Jan 2024 – ongoing
Environment – S4 HANA Data Migration, SAC Planning
Responsibilities –
Performing internal audit, validating risk assessment and validation of controls
Preparing and presenting audit reports to management and KPMG, working on improvement of validation controls
Working on SAC Planning Model, NetEx, Working AGT, CorpFin
Involve in SAC Planning Transport and Security of the objects
Developing CDS views for the S4 Hana reporting
Create and Execute Sql scripts to validate data between S4 and SAC Reports
Preparing planning activities using SAC Planning
Creating OData services for Power BI Report creation
Monitoring IDOCs and fixing the issue if data load fail
Creation of Hierarchies, BEx query and Analysis Office for group reporting
Industry: Industrial Manufacturing
Duration – Dec 2023 – Jan 2024
Environment – S4 HANA Data Migration, Embedded Analytics, Bobj
Responsibilities –
Data migration to S4 system using BODS
Create and Execute Sql scripts to validate data between S4 and SAC Reports
Creation of Data recon report to validate data after the migration
Monitoring IDOCs and fixing the issue if data load fail
Handling of Purchase Info Record, Source List, Open PO,STO data load
Industry: Retail
Duration – Sep 2022 – Nov 2023
Environment – S4 HANA, BODS Data Migration, SAC
Responsibilities –
Involved in S4 HANA Data migration using BODS
Performing data quality analysis and managing follow-up resolution with service providers to ensure reporting accuracy.
Experience in extracting data from SAP ECC, Flat files and loading data to S4 system.
Handling MATERIAL, BOM, Purchase Info Record ( PIR), SourceList master data load and Open PO Transaction data load to S4 HANA system
Create and Execute SQL scripts to load/validate data from ECC source to S4 HANA Staging tables.
Developing Pre/Post data validation reports to ensure the data integrity after the data load from ECC to S4 HANA
Checking the Failure IDOCs and fixing them for smooth data load
Developing BODS jobs to accommodate the changes in Data migration activities.
OData service to consume data in Power BI.
Industry: Car Rental
Role: Team Lead S4HANA, SAP Analysis Office, S4 HANA Data Migration
Duration – July 2021 – Aug 2022
Environment – S4 HANA, SAP Analysis Office, SAC
Responsibilities –
Involved in S4 HANA Data migration using Embedded Analytics
Performing data quality analysis and managing follow-up resolution with service providers to ensure reporting accuracy.
Experience in extracting data from SAP ECC, Flat files and loading data to S4 system.
Exposing S4 HANA Data Models into SAC using live connection
Create and Execute Sql scripts to load data from R/3 source to S4 HANA Staging tables.
Developing Pre/Post data validation reports to ensure the data integrity after the data load from R/3 to S4 HANA
Developing business reports/workbooks using Analysis Office as Embedded Analytics tool
Involve in transport of Workbooks, Roles and make the Workbooks available for business users across the environment.
Industry: Telecom
Role: Team Lead SAP BI HANA, BODS, Tableau, Data Migration, Power BI, Project Management, Internal Audit
Duration - Oct 2015 - June 2021
Environment - SAP BW 7.3, BOBJ 4.X, HANA 1.0, BODS, Tableau
Responsibilities –
Involved in BODS Projects like End-to-End implementation, Data migration and Upgradation.
Worked on Mapping and coding of data conversion objects.
Participated in mapping sessions, Performed mock load activities.
Uploading legacy data from a flat file (txt, csv) directly into the HANA tables
Fixing migration errors by comparing with S/4HANA Target Value list
Involved in the auditing of the migration solution and implemented controls for risk assessment
Worked on performance of data transfer by using multiple files and transfer the data for these files in parallel.
Developing Workflows, Data flows based on the RAR specifications using various stages in BODS.
Experience in extracting data from SAP ECC, Flat files, Oracle systems with Data Services
Working on SAP RAR Project. Developing HANA Models, Validating and creating reports using Business Objects, Tableau
Testing of BODS jobs to validate the SAP RAR functionality is fulfilled.
Developing/Maintaining Corporate Dashboard using Tableau
Build and publish customized, interactive Tableau reports and dashboards using stack bars, scatterplots, geographical maps, and other innovative plot and chart tools•
Act as a subject matter expert on data refresh scheduling and work cross-collaboratively to modify schedules on Tableau Server•
Industry: Retail
Role: Lead Consultant Bobj 4.1, BODS 4.0
Duration: March 15 – Sep 2015
Responsibilities:-
Working as Team Lead in maintaining the SAP System
Working on resolving issues and development of SAP BW 7.3 Issues
Creating BEx queries as data sources for Crystal Report 2013 and WebI
Developing WebI, Crystal reports using BICS connection
Maintaining Bobj Admin related activities
Creating BODS jobs to distribute data between heterogeneous systems.
Validating and testing of Views/Rules in Information Steward.
Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
Creating customized existing reports using sub-reports and charts to present information.
Creating the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
Creating Crystal reports using ERP Datasource, OLAP Connections, XML datasource, created OLAP grid report using OLAP datasource.
Writing formulas to calculate the group summaries based on the group levels in Crystal Reports.
Creating reports across the channels (Sub Reports Drill-down, dynamic grouping, Master/Detail, Crosstab, graphical, aging reports etc).
Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the data in Crystal Reports.
Creating Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Crosstab reports.
Creating Users, User Groups. Granted access to BOE applications to users and added security restrictions (Application level, Folder level, Object level) based on the user profile and user groups.
Exporting Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.
Performed Extraction through ABAP DF, Pre-Lad Validation, Transformation, Post Load Validation
Used Strings Functions, Different Transforms to achieve the Business Rules
Industry: Retail Industry
Role: Lead Consultant Bobj 4.1, BODS 4.0, BW, HANA
Duration: Jan 14 – March 15
Responsibilities: -
Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
Worked on Upgradation of Bobj 3.X to Bobj 4.1
Involved in Testing of BODS Upgradation project
Bobj report data reconciliation with back-end BW systems
Sales & Inventory data validation from BW POSDM with Bobj reports
Validated POSDM data like aggregated sales, Payment Data, Promotion and Bonus buys from BObj reports
Used Bobj tools to migrate Reports from BO XI to BO 4.1
Used RCT to convert Deski reports to WebI and fixed the partially converted reports
Scheduling reports, created events, created Dynamic Distribution list to distribute WebI publications
Involved Converting Standard Infocubes to SAP HANA optimized Infocubes
Performed periodic check on Analytic Indexes, HANA optimized models
Executed SAP delivered reports to ensure that all post migration steps are executed and finished successfully
Demonstrated SAP best practices for SAP HANA data modeling, used decision tree for modeling BWoH
Industry: Consulting
Role: SAP BW 7.3, HANA, BI 4.0
Duration: May 13 – Dec 13
Responsibilities: -
Worked on complex WebI report related to KPMG Tax areas.
Assigned with KPMG-TAX practice end users and train them on Bobj.
Bobj report data reconciliation with back-end BW systems
Followed LSA while developing BW objects
Analyzed existing BW application, creating BEx queries.
Requirement gathering for BO reports
Directly interacted with Business users and developing Reports for KPMG-TAX business area.
Migrating Reports from BO XI to BO 4.1
Scheduled, Promoted WebI, Crystal Reports to it available for end users.
Developing Cross tab reports, Drill up/Drill down reports, Drill through reports, Line charts, stacked charts and Bar graphs.
Created complex Crystal Formulae and field level formula for interactive reporting
Industry: Oil Industry
Role: SAP BW BOBJ HANA
Duration: Nov 11 – Dec 12
Responsibilities:
Extended the global tax provision processes and updated supporting applications including Longview (GPT) and Enterprise Reporting System (ERS) to meet specific U.S. requirements to achieve global scalability
Developed SAP BI objects for data modeling and setup extraction procedure to Fill data in BI Objects
Created and Maintained BWA Index
Worked extensively with BEx Query Designer for developing reports and designed Universe on top of BEx query
Used BODS to extract data from BW server and updating in HANA
BOBJ Dashboard Design, Information Design Tool/Business Layer in Business Objects XI Architecture, Xcelsius /Dashboard Design for Financial Revenue/Tax, GFRM Validation Report, User Management, Configuration Management
Implemented Best Practices in Business Objects WebI over SAP NetWeaver BEx to ensure smooth functioning of BEx objects in BOBJ.
Involved in data load performance improvement, query optimization.
Worked on latest features in Business Objects XI 4.0 Information Design Tool/Business Layer using Xcelsius 2008/Dashboard Designer.
Experience in HANA based BI reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins. Experience with HANA scripts while creating complex SQL views for custom based HANA applications.
SLT for HANA Data Replication Design Content Management, Row-level Security setup, Custom Access Levels and User Management in a multi-sourced HANA based environment.
Implemented HANA on top of BW and created reports on top of that using BI 4.0 reporting interface.
Environment: SAP BI 7.0, BOBJ 4.0,3.X,SAP ECC 6.0, BCS, Net Weaver, Oracle 10g,HANA 1.0,BODS
Industry: Public Sector
Role: SAP BOBJ-BI
Duration: May 11 – Dec 11
Responsibilities:
Worked on BOBJ creating WebI reports, Used Import Export tool for Report Migration
Adept Designing/Developing the Business Objects Universes, Ad-hoc/ Canned Reports, Complex Reports using predefined conditions.
Reconciled Data with ECC Tables, BI Datasource and BO reports.
Created Generic Datasource for FI-Vendor related report, used standard ECC Tables and Custom Tables
Created BW Objects to extract and store data for Reporting purpose
Developed Process Chains to load HR Master data and transaction data, scheduled the process chains for daily, weekly and monthly loads. Monitoring the process chains in the development box
Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
Involved in establishing SAP BW connectivity with Universe Designer and Business objects Infoview, using SAP integration kit. And installed java connector to import the roles of the SAP user to Business objects.
Built Universe's Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using WebI, Xcelsius 2008.
Environment: BOBJ 3.X, SAP BI 7.0, SAP ECC 6.0, BCS, PL/SQL, Net Weaver, Oracle 10g
Industry: Hi Tech
Role: Lead Consultant SAP BI/BOBJ
Duration: May 09 – April 11
Responsibilities:
Development of Functional Design
Converted Functional Design to Technical Design
End-End Implementation for Report Development
Worked on Generic Datasource from Financial Module
Developed BOBJ WebI Reports on top of the BEx query
Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
Environment: BOBJ 3.X, SAP BI 7.0, SAP ECC 6.0, BCS, PL/SQL, Net Weaver
Industry: Consulting
Role: BOBJ Report Developer
Duration: April 08 – Dec 08
Responsibilities:
Created WebI report and Universe using JCO connectivity.
Worked extensively on WebI Reports
Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.
Created complex crystal formulae
Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports.
Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
Created complex Webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
Formatted Webi reports and scheduled them to be burst as pdf to the report to web server.
Involved in scheduling the crystal reports as object packages, creating the schedule events on test server using CMC
Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems
Environment: BOBJ 3.X, PL/SQL, MS .Net
Industry: Energy Industry
Role: SAP BI/BOBJ Consultant
Duration: Feb 07 – Feb 08
Responsibilities:
Worked extensively on BW Process chains to schedule the job in Redwood.
Worked on ECC Tables & Programs, Created Variants for SD,MM, Tested the program along with Variants, scheduled the job in Redwood using dynamic Variants.
Scheduled BO reports using Redwood Cronacle.
Wrote test conditions from the functional specification
Worked on Redwood Cronacle to setup SAP Background Job scheduling.
Worked on SAP BI, Redwood and other ECC jobs.
Created Process chains, Variants, to test the executable programs before schedule in redwood.
Scheduled IBM Datastage jobs in Redwood.
Prepared and uploaded Allegro and PNC Lockbox files using FTP and validation through SAP Background Batch jobs
Used BEx Query Designer as a Front-End Tool to build Queries and Reports, data validation
Scheduled SAP background Batch Jobs using REDWOOD.REDWOOD is a batch job scheduling tool from SAP
Environment: BOBJ 3.X, SAP BI 7.0, SAP ECC 6.0, CRM, SD, APO, PL/SQL, Net Weaver, Redwood
Industry: Publishing
Role: SAP BW 3.5 Consultant
Duration: April 06 – Jan 07
Responsibilities:
Enhancement and creation of SAP transactional data extractor specifically for SD modules
Worked on LO cockpit for Maintenance of extract structures, maintaining InfoSources and activating the update
Coordinated with Onsite coordinator and understanding their requirements
Enhancement of SAP standard master/transactional data extractor
Created Info cube, ODS, info objects, info sources, and routines for new custom development
Involved in the loading of transactional and Master data from flat file as well as from R/3 system
Wrote Exit function to set variables and creating different types of variables for BEx reporting
Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets
Supported the client by providing long-term solutions to the tickets by doing root cause Analysis
Involved in knowledge transaction with the team
Environment: SAP BW 3.5, SAP ABAP/4, SAP R/3 4.7, PL/SQL, SD, MM, Oracle 9i
Industry: Public Sector
Role: SAP BW Consultant
Duration: Feb 05 – March 05
Responsibilities:
Involved into Activities of monitoring, production support and extraction
Interacted with Onsite coordinator and understanding their requirements
Involved in Testing of BW Reports
Involved in Data Reconciliation from different datasources with BW server
Used Mercury Quality Center to track defects and assign the testing defects to respective developer
Tested enhancements and change requests
Loading of master and transactional data from flat file as well as from R/3 system
Built BEx Queries and web reports and workbooks; wrote Exit function to set variables and creating different types of variables for BEx reporting
Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report and Time sheet maintenance of the support team
Supported the client by providing long-term solutions to the tickets by doing root cause Analysis
Maintain list of all the activities for all the tickets until it is closed down
Developed Crystal Reports for FACES application
Environment: SAP BW 3.5, SAP ABAP/4, SAP R/3, Oracle 9i
Industry: IT Services, Intranet Application Projects
Role: Sr. Crystal Report Developer
Duration: Feb 01 – Jan 05
WWW.FUNDMATRIX.COM
This is a web-based intranet application for Karvy Mutual Fund services. It has customers like Reliance-MF, IDBI-MF, UTI-MF, SBI-MF, JM-Morgan-Stanley-MF, and Franklin-Templeton-MF. This project gives online information of different Load structures, Brokerage Charge and NAV Reports.
Responsibilities:
Crystal Report Developer
Coded and designed the front end, Testing, Doing Documentation
Database connectivity using SQL 2K
Environment: ASP 3.0, SQL Server, Crystal Report
Education & Certifications
MS IT with Cyber security major from Colorado Technical University
Master of Business Administration
CIRSC from ISACA
SAP Integrated Business Planning Functional (IBP) Certified
APICS – CSCP Certification Certified
SAP NetWeaver 2004s – BI 7.0 Certified Consultant
SAP HANA Certified.
SAP Analytic Cloud Certified
Tableau Desktop Certified
Microsoft Certified Professional (MCP) in ASP.Net
Talend ETL Certified Professional
Contact this candidate