Home

[email protected] - SAP BODS Developer Resume

[email protected]

Location: Annandale, New Jersey, USA

Relocation: Yes

Visa: H1B

SUMMARY 12+ years of professional IT experience in analyzing requirements, designing, building, highly distributed mission critical products and Applications. Worked as an ETL Developer and SQL developer as SAP BODS Technical Consultant using Business Objects Data Integration Data Services (BODI/DS 3.2, 4.0 and 4.2) Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS) and Business Objects Web intelligence reporting. Implementing RFC connection and them to interact with SAP systems. Implementing ABAP data flows in SAP BODS to extract the data from SAP ECC system. Implemented Slowly Changing Dimension Type 2 (SCD Type 2) for the required dimensions by using TABLE_COMPARIOSN Transform, HISTORY_PRESERVING Transform and KEY_GENERATION Transform Used the LOOKUP_EXT functions to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables Experience in debugging execution errors using Data Services logs (Trace, Statistics, and Error). Tested data flows and scripts against sample data and real data. Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements. Experience in Automation of jobs through Management console & creating Batch jobs based on Client requirement. Configuration of Local Repository for each application Environment. Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Project Management and Testing. Knowledge on developing logical and physical schema of the database using data modeling. Experienced with SQL queries, views and stored procedures Extensively worked on Metadata management for user provided files. Knowledge on Repository Manager Configuration, Job Server configuration, Management Console. Experience in Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration. Experience in Release management process including development, testing and production. Worked on SAP BODS Information Steward like creating the rules, binding rules, score card setup and data profiling. Worked in preparing technical documents like Data Mapping Document and Unit testing evidence documents. Worked on validations on preproduction and production deployments. Troubleshoot failed jobs in Preproduction and production environments Communicate and Co-ordinate with Offshore TECHNICAL SKILLS ETL Tools Business Objects Data Services XI 3.2/4.0/4.2 ERP SAP R/3 (4.6 C/4.7), ECC 5.0, ECC 6.0 SAP S/4 HANA Databases SAP HANA, Teradata, Oracle 10g, SQL Server 2005/2008. Reporting SAP Business Objects, Web I report Languages and Others SQL, Big Data Tools HADOOP HDFS, Map Reduce, PIG SQOOP and BPM tool PEGA Operating System MS-Dos, Windows 9X, Advanced 200X Server and Linux Packages/Tools Remedy, HPQC Programming Languages C, C++, Java, SQL, PL SQL EDUCATION: Master of Computer Applications (MCA), 2009 from Acharya Nagarjuna University, India PROFESSIONAL EXPERIENCE: Client: Universal System Technologies (Farmington hills, MI) Mar 2021 to till date Role: BODS Developer Responsibilities: Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. Resolve the issues based on request submitting by the Users Create new data stores to connect different servers We Implemented Recovery Mechanism for unsuccessful batch jobs execution. fixing the issues of failures jobs. Work on Map operation, Case, Table comparison, history preserve and key generation transformations. SAP DS jobs using in-built and third-party schedulers. Attending the daily meetings and discuss with requirements and about solving the issues Experience using ABAP data flows in BODS while loading data from SAP systems Developing and executing advanced data profiling, data validation scenarios. Prepare mapping documents and deployment instructions documents and shared them into business folders. Creating rules and binding them against the source data Experience in developing scorecards, dashboards and Data Quality mappings. Maintain BODS Security as per the client specifications and interacted with client on daily status calls Reload the data for the particular period of missing data. Create and manage Jobs for Data extract and Load. Must possess excellent analysis and data logic skills. Identifies bad records and root cause of them and avoid them loading into tables. Technologies: SAP Business Object Data services 4.2 Version, SAP Data services management console, SAP HANA Studio, Information Steward, CA Work load Automation (AUTOSYS Edition), Toad for Oracle 12, JIRA, Service Now, HP Service Manager and ITSM Client: Norwegian Cruise Line (Miami, FL) Jan 2019 to Oct 2020 Role: BODS Developer / BODS Consultant Responsibilities: Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. Involved to preparing DMRs and built Jobs for different subject areas and tested thoroughly. Create project flow like jobs, Workflows and Data flows As part of production support Monitoring daily ETL scheduled jobs. Troubleshooting the issues and fixing them. Integrating with SAP (SAP HANA, SAP BW) and NON-SAP systems to extract and load the data. Work on code migration from low level environment to high level environment like DEV, QA to PROD Schedule the jobs in ESP. Set up the DS inbuilt and third-party schedules Run the jobs for monthly end loads on adhoc basis Write SQL scripts for Data base changes Work on incidents to fix issues and debugging them to resolve Create batch files and schedule them in third party tool Adhoc execution of the jobs in Management Console. Used the LOOKUP_EXT function to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables Resolve the issues based on request submitting by the Users Create new data stores to connect different servers We Implemented Recovery Mechanism for unsuccessful batch jobs execution. Give on call support for fixing the issues of failures Work on Map operation, Case, Table comparison, history preserve and key generation transformations Identify metrics and measurements for data quality scorecards. Automation of SAP DS/IS jobs using in-built and third-party schedulers. Attending the daily meetings and discuss with requirements and about solving the issues Experience using ABAP data flows in BODS while loading data from SAP systems Developing and executing advanced data profiling, data validation scenarios. Prepare mapping documents and deployment instructions documents and shared them into business folders. SAP Information Steward (Rules development, Profiling Rules development, Scorecard setup and basic IS administration). Creating rules and binding them against the source data Experience in developing scorecards, dashboards and Data Quality mappings. Maintain BODS Security as per the client specifications and interacted with client on daily status calls Reload the data for the particular period of missing data. Create and manage Jobs for Data extract and Load. Must possess excellent analysis and data logic skills. Identifies bad records and root cause of them and avoid them loading into tables. Technologies: SAP Business Object Data services 4.2 Version, SAP Data services management console, SAP HANA Studio, Information Steward, CA Work load Automation (AUTOSYS Edition), Toad for Oracle 12, JIRA, Service Now, HP Service Manager and ITSM Client: City National Bank (Los Angeles, CA) March 2017 to Dec 2018 Role: BODS developer/ BODS Consultant Responsibilities: Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. Involved to preparing data mapping reports and built Jobs for different subject areas and tested thoroughly. Creating project flow like jobs, Workflows and Data flows As part of production support Monitoring daily ETL and Informatica Cloud scheduled jobs. As part of the development side involved in connecting the systems SAP ECC and S4 HANA to extract the data from them. Troubleshooting the issues and fixing them. Working on code migration from low level environment to high level environment like DEV, QA to PROD Getting the Quality of data monitor results to find the null values or bad data Scheduling the jobs in CA workload automation ESP edition Creating connections in IC and migrating the code from lower environment to prod environment Set up the DS inbuilt and third-party schedules Run the jobs for monthly end loads on adhoc basis Writing SQL scripts for Data base changes Working on incidents to fix issues and debugging them to resolve Creating batch files and schedule them in third party tool Adhoc execution of the jobs in Management Console. Used the LOOKUP_EXT function to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables Resolve the issues based on request submitting by the Users Creating new datastores to connect different servers We Implemented Recovery Mechanism for unsuccessful batch jobs execution. Giving on call support for fixing the issues of failures Developing and executing advanced data profiling, data validation scenarios. Working on Map operation, Case, Table comparison, history preserve and key generation transformations Attending the daily meetings and discuss with requirements and about solving the issues Prepared mapping documents and deployment instructions documents and shared them into business folders. Experience in developing scorecards, dashboards and Data Quality mappings. Maintaining BODS Security as per the client specifications and interacted with client on daily status calls. Reloading the data for the particular period of missing data. Create and manage Jobs for Data extract and Load. Identifies bad records and root cause of them and avoid them loading into tables. Worked on daily and monthly manual loads. Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator. Implemented SCD Type2 for the customer selected dimensions using Table Comparison, History Preserving and Key Generation transforms. Working with source team for the required source data. Daily interaction with the clients to provide business expected results. Executed complex jobs in Debug mode and traced out errors using logs. Deployed the jobs and validating them in PPD and PROD environments. Experience in developing scorecards, dashboards and Data Quality mappings. Technologies: Business Objects Data Services 4.2, SQL Server 2005, Oracle 10g, SAP ECC, S4 HANA, BPC, CA Workload automation (ESP edition), JIRA and Service Now Client: Unilever, Hyderabad (Cap Gemini) Oct 2013 to Feb 2017 Role: Consultant Responsibilities: Extracting the data from SAP ECC Extractors, tables and deliver data to Target Teradata, flat files using SAP BODS. Implementing ABAP data flows in SAP BODS environment to extract the SAP ECC tables, IDOCS Implementing RFC connections and testing them to communicate with SAP systems. Defined separate data store for each database to allow Data Services to connect to the source or target database. Strong experience in Object development using extract, mapping/transform tools Experience writing the SQL scripts Worked on SAP BW Source and targets like Open hub destination, Transfer structures in SAP BODS Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. Knowledge on exciting LSMW scripts. Worked on Data Quality transformations Set up the DS and IS inbuilt and third-party schedules Test planning, processing/tracing messages, researching errors and conducting root cause analysis to identify corrective action Implemented the changes in jobs according to the change request document. Implemented parallel processing (multithreading) for better performance. Extracted data from Flat Files, Databases and moving into staging area and transform and finally load into the Oracle as target. Developed different phases like Stage, SDL, EDW (EL Enterprise Layer) to process the data Modifying the incoming data through Platform, Data Integrator transforms. Implemented SCD Type2 for the customer selected dimensions using Table Comparison, History Preserving and Key Generation transforms. Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator. Used BODS Data Integrator Transforms PIVOT and REVERSE_PIVOT to apply the row level and column level transformation according to reporting requirement and implemented without PIVOT Transforms by wiring the SQL scripts. Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator. Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs. Technologies: SAP Business Objects Data Services 4.2, Teradata, 13, DB2 UDB 9.x, Oracle 10g, SQL, SAP ECC Client: K-Swiss, Inc, Hyderabad (Tech force IT services) Oct 2010 to Oct 2013 Role: SAP BODS Consultant Responsibilities: Extracting the data from SAP Extractors, Tables, SAP BW Sources, flat files, Excel, Oracle which are dynamic in structure using BODS. Implemented dynamic SQL queries to load the data into target. Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. Involved to preparing DMRs and built Jobs for different subject areas and tested thoroughly. Worked on Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration. Extensively working on SAP BODI Designer Components- Projects, Jobs, Workflows, Data Flows, ABAP Data flows, Data Store and Transformations, Formats. Designed various mappings for extracting data from SAP Source systems and relational tables. Using designer to create source definitions, design targets, create jobs and develop transformations. Created different transformations for loading the data into oracle database e.g. Query transformation, Merge, pivot, Case, Table comparison, Key Generation and map operation transformation. Created the embedded dataflow to reuse the logic. Developed SCD Type2 Effective Date Range by using History Preserving transformation according to the business requirements. Implemented Recovery Mechanism for unsuccessful batch jobs execution. Worked on transforms like query, table comparison, SQL, CDC, merge, case, key, date generation. Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data. Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implement in Data Integrator jobs. Migrated all the Projects of the team from DEV TO TEST TO PPD TO PROD, & scheduled the jobs as part of the Administrator. Worked on all the standards & guidelines best practices Documentation, and also the functional & Technical design specification documentation. Resolving the tickets within a specified SLA time. Implemented conditional flow to load either full load or delta load. Monitoring the jobs and report failed jobs Technologies: Business Objects Data Services 4.0, SAP HANA, SQL Server 2005, Oracle 10g, DB2 9.x, SQL Keywords: cprogramm cplusplus quality analyst sfour sfour rlang information technology golang business works hewlett packard microsoft procedural language California Colorado Florida Michigan