• Requirements gathering, preparation of technical design document for Data Migration ( to S/4 HANA) and BI projects
• Design and Development of ETL data pipelines
• Design and Development of New BO Webi dashboards and reports
• Rebuilt Power BI reports in SAP Business Objects Webi
• Undertake root cause analysis and problem investigation

• Monitor, coordinate and respond to support incidents as per SLA?s
• Provide analysis of system defects as and when required
• Develop and Implementation of ongoing change requests for ETL, Data Quality and Reporting requirements
• Responsible for S/4 HANA migration objects like SD, MM, FI, WM etc
• Design and Development of BO dashboards and reports
• Undertake root cause analysis and problem investigation
• Liaise / promote and foster good working relationships with clients
• Understand / adhere to quality / security standards and processes applicable to the role
• Create and maintain technical documentation and contribute to project deliverables where applicable

• Responsible for preparing Technical design spec
• Data extraction using SAP DS from SAP ECC, ESRI application database (Oracle)
• Database views design and development for SAP Information Steward (IS) rules
• IS Rules development
• Development of Data Quality dashboard/reports design and Development (Webi)

• Responsible for preparing functional/ Technical design specs and Field Mapping Documents
• Work with business data owners to process map operational procedures for cleaning against source data from multiple systems
• Pre-mapping Analysis, Data profiling, Data cleansing & Transformation
• ETL Job(s) design, development and testing
• Loading data to SAP using IDOCs and LSMW/LTMC
• BODS Jobs maintenance and Scheduling
• Reporting (Migration):
  • Business Objects Universe
  • Webi reports
  • Dashboards design and Development
• Work with and support the program team during test/UAT project phases on all aspects of data, conversion, pre/post load validation and sign-off

• Responsible for gathering requirements and preparing functional/Technical design specs and Field Mapping Documents
• Premapping Analysis, Data profiling etc
• SAP BODS upgrade for one of Camelot projects
• Data Quality Management and Information Governance prior to Migration
• BODS Batch and Real Time jobs design and development
• Jobs Maintenance and Scheduling
• BI Reports: Business Objects Universe, Webi reports, Dashboard design and Development

• Responsible for gathering requirements and prepare design and mapping documents
• Analyze source data and fix the issues before migration
• Design and Development of ETL jobs for Article Master, Customer Master, Inventory, PO, Sales Order, Finance (FI)data migration
• Sending data to SAP ECC through IDocs
• Transfer data to SAP ECC using RFC from SAP Data Services
• Reviewing others ETL jobs and UNIT testing
• SAP BO Universe design and development and Webi reports development

• Responsible for gathering requirements and prepare design documents and mapping documents
• Analyze and interpret complex data on target systems
• Design and Development of ETL jobs which includes reusable Data flows and Custom functions
• Jobs scheduling and Maintenance
• BO Universe design and development
• Helping in fixing some production issues and BAU issues

• Coordinate with ETL team to implement ETL procedures for all new projects and maintain effective awareness of production activities according to required standards and provide support to all existing applications
• Responsible for gathering requirements and created design documents and mapping documents
• Worked extensively with Sales, Finance teams to design data migration from Legacy system to SAP
• Configured the Data services to connect to the SAP R/3, BI and Loaded data to SAP BW
• Analyze and interpret complex data on target systems
• Design and Development of reusable Data flows
• Development of BO Universe for new RDM reports
• Provide support to Jobs schedule and maintain compliance to same.
• Solving moderately complex issues in target data architecture design processes (e.g. data management process modeling, data entity matrix design)
• Document all test procedures for systems and processes
• Coordinate with business analysts and users to resolve all requirement issues and maintain quality for same
• Guides junior staff on considerations in the design of architecture building blocks

develop a data warehouse and associated data marts for ProjectPlane,Ad?s and CH Projects (Data Migration)

develop a data warehouse and associated data marts for their Contract Management and Fleet management systems

• Analyse business requirement and drill downs required for development of the project
• Design & Creation of Universes required to get the data in the desired format to get published
• Customizing new reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc
• Staging the data for cleaning & accuracy from the production server to warehouse at a schedule time with the help of stored procedures
• Standardizing the reports by minimizing the manual intervention with the help of stores procedures & Packages
• Designing the Sales & Purchase BO reports' Layouts as per user requirements
• Identifying the Scope of the reports as per the respective region.
• Identifying the data sources required to generate the high level business performance report
• Designing the database & Normalizing different tables into a standard data structure
• Due to heavy size of the databases of difference sources, table partitions have been used to enable quick processing of queries
• Merging different tables into a single materialized view to keep up the pace
• Cleaning the data as per the required format with the help of cursors on daily basis

• Extracted transaction data from SAP R/3, using Generic extractors
• Multidimensional Data Model using Extended Star Schema, Developed Info cubes, ODS, Info Source and Data Source
• Created, Start Routines, Transfer rules and Update rules for Info Sources and Info Cubes
• Provided support for data load, validation, performance monitoring and tuning
• Involved in troubleshooting data load in the information supply chain to enable successful implementation
• Creation of DataSources for attributes, texts and hierarchies
• Data modelling and implementation of InfoObjects
• Support at data corrections of ODS objects and InfoCubes
• Development of transfer and update rules in ODS objects and InfoCubes
• Creation of transformations and Data Transfer Processes (DTP)
• Preparation of Infosets, Service InfoCubes and Multiprovider (MP)
• BW Data load scheduling, monitoring and troubleshooting data extraction / load problems
• Created queries with Variables, Filters, conditions, and Restricted & Calculated Key figure
• Developed BEx Reports for Various reports