Resume

Sign in

Data Sap

Location:
Hyderabad, Telangana, India
Posted:
September 23, 2020

Contact this candidate

Resume:

PROFILE:

Expertise in Business Objects Data services 4.0 & 4.2 ETL for Data Migration and Integration.

Experience in Up-Gradation of BODS 4.0 to 4.2 and handling the issues.

Experience in configuration of BODS environment and registering repositories in the CMC and manage security setting for repositories, Server grouping and load balancing in CMC.

Handling the Admin activities in BODS Web and App servers.

Implemented of 3 full life cycle implementations on SAP Migration projects, starting from Blue printing stage to Production.

Experience in integration of various data sources like Database, SAP Systems into the Staging Area.

Involved in extracting data from SAP R/3 Systems and generated ABAP code by using ABAP Data flows.

Using LMS RDS Template and Enriching Data, as per SAP Standards.

Implemented SCD (Slowly Changing Dimensions) in the projects.

Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files and SAP sources like ECC and BW.

Worked extensively with Business Objects Data Services/Integrator to create complex Data flows using Query, Table comparison and all transformations

Data stores creation on sources and targets of SAP ECC, BW, MDG and Databases.

Administering and maintaining BO Data Services management console and repository management.

Scheduling of SAP BODS Batch jobs in DSMC and in third party schedulers.

Capable of working as a Team Member or Individually with minimum supervision.

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Fully capable in building Unit test cases and achieving the Unit tested results for the development assigned.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Implemented CSI’s on Special Characters, Old files deletion and automation of email with Attachments etc.

Creating Mapping Documents from given functional workbooks.

Experienced in Production Support role 24/7 to resolve the issues.

TECHNICAL SKILLS:

Programming Languages : MS-SQL

Migration Tools : SAP BODS 4.0 &4.2

RDBMS : MS SQL Server 7.0 – 2008.

Operating Systems : Windows NT 4.0 Server – Windows

EDUCATIONAL QUALIFICATIONS:

Bachelor of Tech in computer science from Nimra College of Engineering, JNTUK passed out in 2012.

PROFESSIONAL EXPERIENCE:

Project Description:

Verizon Communications Inc. is an American multinational telecommunications conglomerate and a corporate component, global communications & technology leader known for its 4g & 5g wireless networks, broadband & fiber optics, video & advertising platforms, internet of things.

Responsibilities:

Responsible for the Development/ Testing BODS jobs as per the functional and mapping documents.

End to End Data Migration from Files, SAP Tables to specified Target systems and replication of data.

Expert-level mastery in designing and developing complex mappings to extract data from excel sheets and RDBMS tables and target systems like SAP, File Formats, Tables etc.

Loading data in to SAP MDG via IDOCS .

Reconciliation of data in preload, post loads, data validations related to business Partner, Material Master, Vendor Master, Classifications, Location Creations.

Project Description:

Ulta Beauty is a chain of beauty stores in the U.S, Employee data was stored in ECC and sent to third party systems, requirement is replacing ECC with Success factors and SAP BODS and then sent to Target systems.

Responsibilities:

Responsible for the Development/ Testing BODS jobs as per the functional and mapping documents.

Developed the jobs as per ULTA Standards

Expert-level mastery in designing and developing complex mappings to extract data from Success factors, Text files, excel sheets and RDBMS tables and target systems like HANA, text files etc.

Exporting the job via Central repositories by maintaining Version of the jobs.

Implemented SCD (Slowly Changing Dimensions) in the projects.

Worked with functional team for the development of jobs.

Project Description:

Becton Dickinson is a global medical technology company that is advancing the world of health by improving medical discovery, diagnostics and the delivery of care, after the Acquisition of Care Fusion a global medical technology corporation serving the health care industry there was huge requirement of merging the Customers, Items, products data of care fusion and BD into a Central Database.

Responsibilities:

Creation of Mapping documents needed for developing and communicating with the onshore team.

Extracting the Customers and products data from source tables and staging.

Merging the data in different data flows according Business logics with various data filtering and quality checks.

Using LMS RDS Template and Enriching Data, as per SAP Standards.

Applying the filter conditions on the records to match the conditions using validation transforms.

Loading the merged data in to output files and loaded in to success factors via connectors.

Project Description:

Unilever is having many servers handing BODS applications, as the new version of SAP BODS are available for Better performance of the applications and to maximize operational efficiency, to improve data quality and gain access to heterogeneous sources and applications, which includes several enhancements to functions, procedures, and authorizations that provide secure integration with SAP systems as part of KEC.

Responsibilities:

Installation of IPS and DS patches

Upgrading and Configuring Local/Central repositories in CMC and Repository Manager.

Configuring SAP RFC, Job Server and Access Server.

Assigning security roles and authorizations to users for DS and Data stores.

Examining IPS and DS settings, configuration Parameters and data store connections.

Taking the backup of jobs to ATL files and testing the jobs before and after installations.

Generation of new BATCH files after upgrade if necessary.

Handling SIA, Tomcat, Server node and installation issues.

Review of Bug fixes and new functions implemented.

Validating of Jobs at top level and fix the errors.

Project Description:

Unilever had designed this project to unify underlying processes of Supply Chain across Southern Cone, Middle Americas and Great Caribbean. Unilever deployed the SAP solution that would underpin a new set of standardized processes. The middleware layer supporting these interfaces consists of an unsupported version of a Business Object product called BODI v 6.5 for data extraction from SAP systems SAP BODS will extract data from three existing systems SAP ECC, SAP BW and PeopleSoft. This extracted data will be stored in a SAP BODS database prior to a transformation process. Once the data has been transformed the data is then loaded to several recipient systems

Responsibilities:

Designed, Developed and Supported complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions and Loading Data into Target using flat files, XML files and from database tables used as source files.

Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator, Query Transform, Map Operations, Table Comparison, SQL, and Validation Transforms.

Recovering Data from Failed sessions and Workflows.

Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.

Used Global variables, Local Variables and Parameters between Work flow and Data flow as per business requirements.

Configured database Data Stores and File Formats to allow Data Services to connect to the source or target database and files.

Worked on Central repositories and maintained Version checking of Data services objects.

Supporting and executing performance investigations and Tuning.

Identification of erroneous records and sending this data by email using BODS to all the stake holders after every execution of a batch job.

Project Description:

As The aim of this project is to send financial reporting data from each core SAP ECC instance to a Cap Gemini (CG) server ( hosted externally ) for the purpose of performing analytics on the data against key financial KPIs.

Responsibilities:

Calling a unique SAP ECC functional module by passing program and variant names from BODS interface.

Capturing file name as success parameter from SAP ECC function module on completion of SAP ECC job.

Transferring the files from SAP ECC application server to Cap Gemini server via SFTP without any transformations.

Project Description:

SAP Business Objects that renders the information from Unilever Country wise Data Warehouse (UCDW) and SAP BW and SAP ECC. In other words, the SAP BODS for the Cordillera-Unilever Mexico project includes both frontend and backend. Frontend is defined as using the appropriate BI tool(s) for the presentation layer to the end-user and defining the supporting components for it. The backend is defined as the Data Warehouse using Layered, Scalable Architecture (LSA) and the ETL (Extract, Transform and Load) objects that support the reporting requirements. Extensively involved in Data Extraction, Transformations and Loading (ETL processes) from Source to target systems using BODS Designer.

Responsibilities:

Analyzing and gathering project requirements, developing and designing business objects data services programs customized to meet specific business needs.

Designed, Developed and Debugged complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.

Extensively worked on various transformations like Map Operation, Table Comparison, Key Generation, Query, History preserving, and Case.

Tuned Data Integrator Mappings and Transformations for the better performance of the jobs

Implemented incremental load for extract data from source tables to staging tables.

GENERAL INFORMATION:

Language Skills : Fluent in writing and speaking English, Hindi and Telugu.

Citizenship : Indian Citizenship.

D.O.B :31-01-1991

MD. ABDUL SAMAD

● adgc3t@r.postjobfree.com ● Ph No: 970*******

7 years of IT Experience in Development, Support and Administration in the fields like SAP Business Objects Data Services (BODS-ETL) and RDBMS

Employer: Deloitte

Position: SAP BODS Consultant (Developer) Duration: From Feb-2019

Project : 01 Title : Verizon Data Migration

Client : Verizon Communication Role : BODS Developer

Team Size : 5 Environment : DEV and QA Servers

Employer: INFOSYS

Position: SAP BODS Consultant (Developer) Duration: Feb-2018 to Feb-2019

Project : 01 Title : ULTA

Client : ULTA Role : BODS Developer

Team Size : 3 Environment : DEV and QA Servers

Employer: CAPGEMINI Technology Services India Ltd

Position: SAP BODS Consultant (Developer) Duration: Nov-2016 to Feb-2018

Project : 01 Title : BD LMS

Client : Becton Dickinson (www.bd.com) Role : BODS Developer

Team Size : 2 Environment : DEV, QA and Prod servers

Employer: Extranet Software Solutions (Subsidiary of Enterprise Software solutions, New Jersey, USA)

Position: SAP BODS Consultant (Developer & Technical Support Duration: Sep-2013 to Nov-2016

Project : 01 Title : BODS Version Upgrade

Client : Unilever Role : BODS Admin

Team Size : 3 Environment : DEV, QA and Prod servers.

Duration : Aug-2014 to Oct-2015

Project : 02 Title : Cordillera-Unilever Tech Integration R4 & R5

Client : Unilever Role : BODS ETL Developer, Admin and Support

Team Size : 10 Duration : Jan-2015 to Nov-2016

Environment : SAP Business Objects Data Services XI 4.0 (Version 14.0), CMC and SQL Server 2008.

Project : 03 Title : MCHI ZBC Analytics

Client : Unilever Role : BODS Consultant & Admin

Team Size : 6 Duration : Oct-2015 to Nov-2016

Environment : SAP Business Objects Data Services XI 4.0 (Version 14.0), CMC and SQL Server 2008.

Project : 04 Title : Cordillera Mexico & Brazil Integration R3

Client : Unilever Role : BODS Consultant

Team Size : 10 Duration : Sep-2013 to Nov-2016

Environment : SAP Business Objects Data Services XI 4.0 (Version 14.0), CMC and SQL Server 2008.



Contact this candidate