RM

Raj Miryalkar

available

Last update: 16.12.2022

SAP BODS Consultant, SAP BODS Consultant, SAP BODS Consultant - Asst.Project Manager

Graduation: MBA in Information Technology , B.E in Computer Science
Hourly-/Daily rates: show
Languages: English (Full Professional)

Keywords

SAP Applications Data As A Services Data Migration Communication Databases Legacy System Migration Workbench Business Intelligence Data Mining IDoc Microsoft SQL Servers + 42 more keywords

Attachments

CV-Miryalkar-ATTRA-AUG-22-Updated_161222.docx

Skills

EXPERIENCE SUMMARY
Having 10.9+ years of total IT experience comprised of
  • 6.9 years as Sr.SAP - BODS - BO Consultant
  • 1.2 years as Asst.Project Manager
  • 3.7 years as experience in .Net
SAP EXPERIENCE SUMMARY
  • Solid organizational skills and multitasking skills.
  • Created High level Understanding documentation with ER diagram (Objects: RTC Inventory, Picket status and Multi-box)
  • Created Technical documentation (Objects: RTC Inventory, Picket status and Multi-box)
  • Worked on building Batch Jobs to meet the project specific requirements using SAP BODS- Designer, Workflow, Conditional flows and Data flows.
  • Worked with Platform transforms, Data Integrator and Data Quality Transforms.
  • Designed jobs using Data Integrator transforms to load the data from various sources into the target systems, using different transformations like Query, Table Comparison, Merge, Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation, Case Transform etc.
  • Worked on Various Transforms like Query Transform, Case Transform, Merge Transform, Validation Transform, Row Generation Transform, Key Generation Transform, Table Comparison Transform, History Preserving Transform, Pivot Transform, Reverse Pivot Transform, SQL Transform.
  • Data migration from Legacy system to SAPECC by using LSMW, Custom T-code Function, IDOC.
  • Experience in migration of legacy data to SAP ECC using Sap Data Services, LSMW, Batch / Direct input, BAPI, and IDOC.
  • Loaded the data into S/4 HANA through IDOCs and LTMC
  • Master data loading and Transaction data loading thru LSMW
  • Created complex SQL scripts for various projects
  • Worked on LSMW to load data into target systems using automated batch jobs and collecting error logs to validate and correct errors in loading and transformation
  • Developed and Implemented of Data Migration jobs using SAP Business Objects Data Services 3.2, 4.0,4.1,4.2
  • Migrated data from various legacy system to SAP system.
  • Good Hands on experience in SAP Data migration project, from Legacy system to SAP ECC.
  • Experience in building ETL process and Migration process to meet the project specific requirements using SAP BODS- 3.2/4.0/4.1/4.2
  • Having knowledge on  HANA Database
  • Experience in managing all stages of data migration from Data analysis, user acceptance testing, user sign-off, Cut-Over plans, Migrating Code to Dev/QA/ Prod landscapes, post go-live validations, Error reporting, Change requests, Defect management, Metrics and Training resources.
  • Ability to translate business requirements into technical project plans and able to prioritize multiple projects and tasks
  • Leading and participating in meetings at the operational and project level
  • Managing high priority tasks, enhancements and bugs related to assigned projects.
  • Extensive worked on data extraction, transformation and loading from data sources like Oracle, SQL Server and flat files.
  • Experience in Automation of jobs through Management console & Creating Batch jobs.
  • Used Central Repository for Multiuser Environment.
  • Experience in executing batch jobs & real time services & implementation of Recovery Mechanism for unsuccessful batch job execution.
  • Providing inputs to prepare the implementation schedule, tracking the progress of milestones.
  • Creating and maintaining comprehensive project documentation.
  • Having good issue resolution and people management skills.
  • Building Working relationships with team members, vendors, and other departments involved in the projects.
  • Having Excellent communication skills and working well with Team.
  • Having Strong leadership skills, Excellent planning, organizing skills, communication and interpersonal skills.
  • Excellent client-facing and internal communication skills.
  • Competitive Experience in Business Intelligence (Data Extraction using Data Services, Data warehousing, BI Reporting) using SAP Business Object Data Integrator/ Data Services 3.x/4.x, SAP Business Object XI R3/R4( Web Intelligence, UDT & IDT) and SQL Server 2005/2008 R2 Database, creating repository, analysis and dashboards .
  • Experience in developing the Business Objects Universe and updating the existing Universe.
  • Strong knowledge of Business Intelligence concepts.
  • Experience in different phases of Software Development Life Cycle (SDLC) like requirements gathering, preparation of technical specification documents, unit testing and UAT of database and reports
  • Good Knowledge on banking Domain.
  • Involved in interaction with the Business Users and Clients to analyze the business process and requirement gathering.
  • Good Work Ethics with excellent Communication and Interpersonal Skills.
  • Ability to work in both Team and Individual Environment.

Project history

12/2013 - Present
Senior Technical Lead - SAP BODS
ATTRA INFOTECH PVT LTD (Banks and financial services, 500-1000 employees)

Project
Client : CAL (Continental Acceptances Ltd) Bank
Industry : Banking
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.0
Database : Oracle 11g
Report : Business Object Reports 3.1
Dashboard : Xcelsius
Role : BODS Developer


Description: CAL (Continental Acceptances Ltd) Bank is one of the commercial banks which offers
foreign exchange products. The aim and objective of this project is to develop reports and
dashboards w.r.t departments.
Responsibilities:
* Developed the universe with involvement of different phases such as reports specifications,
analysis, design, development and maintenance of the Universes.
* Resolved loops by creating Aliases and Context.
* Testing/Debugging/trouble shooting Business Objects Universe modifications in Designer to
include database connections, new objects, updated tables, and joins.
* Created Derived tables in the universe for complex queries.
* Applied Row level restriction and Objects level restrictions for individual users.
* Created FRS documents and test cases for universe and reports.
* Created the reports using Business Objects functionalities like drill down, cross tab, master
detail and charts.
* Scheduled the WEB Intelligence Reports to BO user inbox and send copies to the external
user's mailbox in MS Excel/PDF formats.
* Developed Webi reports using webi rich client and Infoview.
* Developed Dashboards using Live office.
* Involved in testing the reports. Tested and verified the result set of SQL query of the
reports in database with application.
* Involved in requirements gathering from the business users to build the reporting
application.
* Worked on CMC to create user profiles for different departments.

12/2022 - 12/2022
Junior Software Developer

Project
Client : ITAB-CTS, HEMEL HEMPSTEAD, SKILLIANTECH,UK
Industry : Manufacturing
Project Scope : Support
Environment : ASP.Net 3.5, SQL Server 2005.
Role : Junior Software Developer



Description: Manufacturing interior designs such as shelves, racks and more with transportation for
different retail companies such as Sainsbury, Tesco etc.
Roles and Responsibilities
* Designed the Database table schema using SQL Server 2005
* Created Indexes and Stored Procedures using T-SQL and tested the application to the
requirement
* Developed web parts for various modules.
* Created Triggers and Views for the designed Database
* Involved in Designing the application with Architect and have taken part in Database design

12/2022 - 12/2022
Software Developer

Project :
Title : Web System
Team Size : 3 Members.
Environment : ASP.Net 3.0, SQL Server 2005.
Role : Software Developer


Roles and Responsibilities
* Configured web part connections.
* Designing and Coding.
* Developed SQL Data Reports using SQL Reporting Services for Pay Slip Module.
* Created Stored Procedures and Cursors using T-SQL and tested the application to the
requirement.
* Created Triggers and Views for the designed Database.

12/2022 - 12/2022
SAP BODS Consultant
Advantiqs Technologies India P.Ltd


12/2022 - 12/2022
SAP BODS Sr.Consultant
CUSCAL - CARD PAYMENTS(VISACARD & MASTERCARD)

Client : CUSCAL - CARD PAYMENTS(VISACARD & MASTERCARD)
Industry : BANKING SERVICES - Australia
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.2
Database : Oracle 12C
Role : SAP BODS Sr.Consultant


Responsibilities

* Generated the ABF file which holds the OIF (Optional Issuer Fee) calculations for the Opt -
In clients
* Generated the reports for Daily Transaction and Summary in .csv formats w.r.t each client
* Uploaded the Wiki pages for ABF file generation process, Daily Transaction reports and
Summary reports
* Uploaded the LLD (Low Level Design) document for ABF file generation process, Daily
Transaction reports and Summary reports
* Got the knowledge on CONTROL - M process
* Got the knowledge on EFT process
* Building Batch Jobs to meet the project specific requirements using SAP BODS- Designer,
Workflow, Conditional flows and Data flows.
* Created various Exceptional Handlings within the JOB
* Worked with Platform transforms, Data Integrator and Data Quality Transforms.
* Solid organizational skills including attention to detail and multitasking skills.
* Ability to translate business requirements into technical project plans and able to
prioritize multiple projects and tasks based
* Having excellent communication skills and working well with Team.
* Having Strong leadership skills, Excellent planning, organizing skills, communication and
interpersonal skills.
* Excellent client-facing and internal communication skills

12/2022 - 12/2022
SAP BODS Consultant
COSTCO WHOLESALE; MERCK India Ltd

Client : COSTCO WHOLESALE
Industry : RETAIL COMPANY
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.2
Database : Oracle 11g
Role : SAP BODS Consultant


Responsibilities

* Created High-level understanding documentation for various objects like RTC INVENTORY,
PICKTICKET, PICKTICKET STATUS
* Created Technical documentation for objects like RTC INVENTORY, PICKTICKET, PICKTICKET STATUS
* Created Job for objects like RTC INVENTORY, PICKTICKET, PICKTICKET STATUS
* Worked on building Batch Jobs to meet the project specific requirements using SAP BODS-
Designer, Workflow, Conditional flows and Data flows.
* Worked with Platform transforms, Data Integrator and Data Quality Transforms.
* Solid organizational skills including attention to detail and multitasking skills.
* Ttranslate business requirements into technical project plans and able to prioritize multiple
projects and tasks based

Client : MERCK India Ltd
Industry : HEALTH CARE - LIFE SCIENCE
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.2
Database : Oracle 11g
Role : SAP BODS Consultant


Responsibilities

* Worked on building Batch Jobs to meet the project specific requirements using SAP BODS-
Designer, Workflow, Conditional flows and Data flows.
* Worked with Platform transforms, Data Integrator and Data Quality Transforms.
* Solid organizational skills including attention to detail and multitasking skills.
* Ability to translate business requirements into technical project plans and able to
prioritize multiple projects and tasks based
* Sound understanding of end to end Data Migration process including Extraction, Data
Profiling, Transformation and Generation of Load ready data files in LSMW format.
* Migration of legacy data to SAP ECC using Sap Data Services, LSMW, Batch / Direct input,
BAPI, and IDOC
* Developed Technical designs, BODS/LSMW Build, Unit testing.
* Developed and Implemented of Data Migration jobs using SAP Business Objects Data Services 4.2
* Migrated data from various legacy system to SAP system.
* SAP Data migration project, from Legacy system to SAP ECC.
* Building ETL process and Migration process to meet the project specific requirements using
SAP BODS- 4.1/4.2
* Managing all stages of data migration from Data analysis, user acceptance testing, user
sign-off, Cut-Over plans, Migrating Code to Dev/QA/ Prod landscapes, post go-live
validations, Error reporting, Change requests, Defect management, Metrics and Training
resources.
* Extensively worked on creation of SAP BO UDT and IDT
* Developed Webi reports using SAP BO WEBI rich client and BI launchpad.
* Developed SAP BO Dashboards using Live office.
* Developed SAP BO Crystal reports
* Extensive worked on data extraction, transformation and loading from data sources like
Oracle, SQL Server and flat files.
* Experience in Automation of jobs through Management console & Creating Batch jobs.
* Used Central Repository for Multiuser Environment.
* Experience in executing batch jobs & real time services & implementation of Recovery
Mechanism for unsuccessful batch job execution.
* Leading and participating in meetings at the operational and project level and providing
continuous feedback on project status.
* Managing high priority tasks, enhancements and bugs related to assigned projects.
* Providing inputs to prepare the implementation schedule, tracking the progress of milestones.
* Creating and maintaining comprehensive project documentation.
* Having good issue resolution and people management skills.
* Building Working relationships with team members, vendors, and other departments involved in
the projects.
* Having excellent communication skills and working well with Team.
* Having Strong leadership skills, Excellent planning, organizing skills, communication and
interpersonal skills.
* Excellent client-facing and internal communication skills

12/2022 - 12/2022
SAP BODS Consultant
TIMKEN India Ltd

Client : TIMKEN India Ltd
Industry : Manufacturing
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.2
Database : Oracle 11g
Role : SAP BODS Consultant


Responsibilities

* Extensive worked on data extraction, transformation and loading from data sources like SAP,
Oracle, SQL Server and flat files.
* Worked on building Batch Jobs to meet the project specific requirements using SAP BODS-
Designer, Workflow, Conditional flows and Data flows.
* Worked with Platform transforms, Data Integrator and Data Quality Transforms.
* Having excellent communication skills and working well with Team.
* Having Strong leadership skills, Excellent planning, organizing skills, communication and
interpersonal skills.
* Excellent client-facing and internal communication skills


Project
Client : KCB (Kenya Commercial Bank)
Industry : Banking
Project Scope : Implementation
ETL Tool : Business Object Data Services 4.1
Database : Oracle 11g
Report : Business Object Reports 4.1
Dashboard : Dashboard
Role : BODS Consultant


Description:
This Project has been developed for Kenya Commercial Bank, which is one of the largest banks in
Kenya. We generated reports for different departments within a bank such as Finance, Branch, IT,
Sales, Retail and analyze how the customers are investing in Bank, trade stocks, bonds and mortgages
by business users. The project involved in development of various complex, Ad-hoc and canned
reports. Large manipulations were done to generate reports that could help the managers to analyze
and improve the performance of the bank.

Responsibilities/Deliverables:
* Extensive worked on data extraction, transformation and loading from data sources like
Oracle, SQL Server and flat files.
* Worked on building Batch Jobs to meet the project specific requirements using SAP BODS-
Designer, Workflow, Conditional flows and Data flows.
* Worked with Platform transforms, Data Integrator and Data Quality Transforms.
* Experience in Automation of jobs through Management console & Creating Batch jobs.
* Used Central Repository for Multiuser Environment.
* Experience in executing batch jobs & real time services & implementation of Recovery
Mechanism for unsuccessful batch job execution.
* Created different reports containing charts showing revenue and operating income by different
divisions.
* Created the Finance, sales and branch reports on top of Oracle Data base.
* Worked on merge dimension to compare actual data with Budget data from different data
providers.
* Applied Alerts and Ranking for the data in the WEBI report according to the requirements.
* Extensively worked on Conditions, Query level filters and Report level filters.
* Developed universes using Designer, have created Web Intelligence reports and Created
dashboards using Xcelsius.
* Understanding the Client Specifications based on the requirement.
* Build the new universes as per the user requirements by identifying the required tables from
Data Warehouse and by defining the universe connections.
* Created Classes and Objects as per Technical specification and specified the hierarchies.
* Developed critical reports like drill down, master/detail for analysis of parts benefits and
headcount.
* Created complex reports using the multiple data providers and synchronized the data providers
by merging the common objects in Report Level.
* Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined
objects and custom Hierarchies for drill down purposes.
* Have created 2 universes (Finance and Branch) Based on the department wise in KCB and
exported the universes to the Repository to make resources available to the users.
* Designed and Developed WEBI Reports as per the Users Requirements using the features in
Business Objects including: Master/Detail, Charts, Cross Tabs, Drill Down, and Formula to
analyze the data.
* Have created the daily, weekly, monthly reports on MM (Money Market), FX(Forex), Retail
banking to deliver the CBK (Central Bank of Kenya).
* Involved in creation of interactive Dashboards and Business Presentations by importing data
from Excel sheets using Xcelsius.
* Documented requirements and performed Gap analysis to identify the gaps.
* Created the documents for the generated reports such as FRS and Test case documents.
* Have involved to take the regular backup of the objects (Reports and dependencies) by using Promotion
Management (.Bair file).
* Involved to create the users for development Group and testing group and assign the
appropriate access level to particular group.
* Have done the unit testing in development system and created the test cases documents.
* Scheduling the reports daily, weekly , monthly as per end user requirement.
* Have configured the mobile Webi reports in BI 4.0 SP4 to display Webi reports in mobile.
* Configured the BI Launch pad banner logo with "Cock - Pit" logo

08/2018 - 12/2022
SAP BODS Consultant
MarlabsInnovations P.Ltd


03/2017 - 02/2018
SAP BODS Consultant - Asst.Project Manager
Mahiti Infotech P.Ltd


02/2015 - 01/2017
SAP BODS Developer
ATUMIT INDIA P.Ltd


02/2013 - 11/2014
SAP BO Developer
Lera Technologies P.Ltd


02/2011 - 10/2012
Junior Software Developer
ITAB CTS Ltd.


01/2006 - 12/2007
Software Engineer
Flair (Konnet Solutions) Technologies P. Ltd


Local Availability

Only available in these countries: India
Profileimage by Raj Miryalkar SAP BODS Consultant, SAP BODS Consultant, SAP BODS Consultant - Asst.Project Manager from BENGALURU SAP BODS Consultant, SAP BODS Consultant, SAP BODS Consultant - Asst.Project Manager
Register