Rammohan P Email & Phone Number

Bengaluru, Karnataka, India

· Analyzing the Business Requirements (functional & technical) with the Business users.· Participated in requirement gathering sessions and developed Business Objects Data Services jobs specifications on excel sheets based on information acquired from analysis of source data, user requirements, Business rules and Enterprise standards.· Understanding the requirements and feasibility in the form of Field Mapping Document and Functional Specifications.· Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous & homogeneous source systems.· Used various transformations like Case, Map Operation, Table comparison, History Preserving, Pivot, Reverse Pivot, Data transfer, Merge, Query, Row Generation, SQL, and Validation.· Scheduled, monitored and fixed the errors of the jobs.· Tested all the BODS ETL Jobs in Dev environment, validated and fixed the Bugs before moving them to QA.· Delivered the code with at most zero defects.· Worked on SAP HANA database to create preload, readiness and post load reports.· Handled time critical Development requirements, Delivery review, interacted with offshore team.· Responsible for preparing the technical documents and component test scenarios after the development.· Created Calculation Views in SAP HANA database for small objects.· Helped all my team members in completing their deliverables on time.

· Created multiple data store configurations in Data services local object library with different databases.· Developed initialization scripts which control Workflows & Data flows.· Used Built-in Functions, Built-in Transformations as part of transformation logic.· Used SAP ECC, SQL server 2008 and flat files as source and target.· Created R/3 ABAP Data flows for retrieving SAP data in Data services.· Extracted data from SAP ECC system and generated preload files for business validation to load data to GEP target system by using business rules.· Loaded source data into Excel files for the objects Contract Utilization, Contract Holder, Contract Exception Report.· Performed Mappings, Validations (Lookup, Mandatory, Format) and Preload files to load data from source SAP ECC (Phoenix and Tempo) to the respective staging tables of each phase.· Designed Data Validation by using check tables Lookups and validation transformations.· Defined LSMW dataflow to load data from transformed staging tables to tab delimited text file which is further processed using LSMW methodology for vendor object.· Loaded customer master data into SAP system by using DEBMAS IDOCS.· Maintained reconciliation report to verify the loaded data in SAP ECC.· Worked on Address cleansing for Customers, Vendors and Employee master data using SAP Data Cleansing tool and SAP BODS Data Quality transforms.· Defined LSMW dataflow to load the data from enrichment staging tables to tab delimited text file into SAP server directory which is further processed using LSMW methodology.· Designed the target file structure as per the target custom IDOC structure of SAP ECC.· Checked the validations in lookup tables using LKP tables of the configuration data in SAP.· Designed jobs for Account Payable and Account Receivable transactional objects

· Created multiple data store configurations in Data services local object library with different databases.· Developed initialization scripts which control Workflows & Data flows.· Used Built-in Functions, Built-in Transformations as part of transformation logic.· Used SAP ECC, SQL server 2008 and flat files as source and target.· Created R/3 ABAP Data flows for retrieving SAP data in Data services.· Extracted data from SAP ECC system and generated preload files for business validation to load data to GEP target system by using business rules.· Loaded source data into Excel files for the objects Contract Utilization, Contract Holder, Contract Exception Report.· Performed Mappings, Validations (Lookup, Mandatory, Format) and Preload files to load data from source SAP ECC (Phoenix and Tempo) to the respective staging tables of each phase.· Designed Data Validation by using check tables Lookups and validation transformations.· Defined LSMW dataflow to load data from transformed staging tables to tab delimited text file which is further processed using LSMW methodology for vendor object.· Loaded customer master data into SAP system by using DEBMAS IDOCS.· Maintained reconciliation report to verify the loaded data in SAP ECC.· Worked on Address cleansing for Customers, Vendors and Employee master data using SAP Data Cleansing tool and SAP BODS Data Quality transforms.· Defined LSMW dataflow to load the data from enrichment staging tables to tab delimited text file into SAP server directory which is further processed using LSMW methodology.· Designed the target file structure as per the target custom IDOC structure of SAP ECC.· Checked the validations in lookup tables using LKP tables of the configuration data in SAP.· Designed jobs for Account Payable and Account Receivable transactional objects

· Involved monitoring the Batch jobs and taken actions for the failure jobs. And provided the RCA for failures so to fix the issues permanently.· Involved in Unit testing, SIT.· Involved implementing CR against the code changes in BODS.· Handled P3 and P4 type of tickets.· Extensively involved on monitoring the tickets using Remedy ticketing Tool.