Vijay Kunusoth

Senior SAP BODS Consultant

#510-***-**** ac166j@r.postjobfree.com

SUMMARY:

* ***** ** ********** ** SAP BODS/ETL Development/SAP BI/SAP INFORMATION

STEWARD. This includes Integration, Implementation, Data warehousing and Business Intelligence

SAP Data Services for development and integration with SAP R/3 systems, flat files and RDBMS

(Sql server & Oracle).

Experience in Data Migration with transformations, receiving and sending Idoc's, / LSMW / BDC/ BAPI / RFC.

Expertise in implementing Data Quality (Data Enrichment, De-Duplication etc.) using various components present in SAP Data Services and information steward.

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Worked on various Data sources like SAP systems, BW source, Oracle, Sql Server, Flat files.

Slowly changing dimensions type 1 and type 2.

Platform and Data integrator transformations.

Performance tuning, Error handling mechanisms and Recovery mechanisms.

Deployment, Code review, Unit testing and preparing test cases and technical specification.

SAP BODS inbuilt functions and BODS scripting.

Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.

Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.

Strong experience in cleansing the data using Data Quality transforms, Creating Work flows, Data flows, Abap data flows, File Formats, Scripts and Data stores.

Strong experience in supporting ETL batch jobs using SAPBODS designer console, monitor and scheduling the jobs using Admin console.

Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.

Strong experience in using BODS as an external system for ETL between ECC and BI.

Created complex Jobs, Work Flows, ETL Frameworks, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.

Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema modelling, Snowflake Schema, fact and dimension tables.

Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment.

Hands-on expertise in Development, Upgrade and Implementation Projects at all stages of BODI /BODS rollouts i.e. Requirement Gathering, GAP Analysis, Blue Print, Development and Go-Live using ASAP Methodology in Software Development Life Cycle.

Tivoli Scheduler, Control M, UC4.

Worked on various Data sources like SAP systems, BW source, Oracle, Sql Server, Flat files, SAP HANA.

Applications with BOXI R3.1, 4.0 and knowledge of working with Data modeling tools like ERWIN. Used DB tools like SQL Developer and TOAD.

Experience in Data Profiling and Auditing in Data Migration, Data Integration, Data Conversion, Data Quality, Information Steward, SAP Data Service (BODS / BODI) interface for complex jobs with various data sources (Flat files, Oracle, SAP ECC, Microsoft SQL Server) and loading data into SAP BW and SAP ECC system.

Hands on experience towards Migration scenarios, scheduling and publishing the reports, Used Scheduling tools like Tivoli, Autosys&SAP Redwood (CPS).

Education

Bachelor of Technology (Electronics and Communication Engineering -JNTU (HYD).

Professional Experience

KRAFT HEINZ, Chicago, IL September 2016 – Till Date

As a SAP BODS Consultant/Admin

Responsibilities:

Involved in Development for different applications in KRAFT HEINZ.

Migrated Code from IBM Data stage to SAP BODS.

Analyze and understanding the code in Data stage and implement the same in SAP BODS.

Worked on different sources like flat files, SAP BW Open hub tables, oracle, sql server, SAP ECC,

SAPBW, SAP HANA, SAP MDG and other SAP R3 sources including SAP MDG.

Configured Data stores for SAP systems and databases and worked with SAP Security and BASIS

Teams in getting required authorizations to pull the data from SAP systems.

Developed Batch jobs, workflows, Data flows, scripts.

Worked on transformations like SQL, Table comparison, Merge, Map operation, Query.

Used Central Repository to deploy jobs to other environments and for multi user development.

Performance tuning of the jobs, Design review developed by other team members.

Involved in the Unit Testing, prepared test cases and Bug fixing and prepared Technical Spec.

Load the data from Data stage and BODS and compare the both sets and match data BODS data to

Data stage output data.

Created substitution parameters, system configurations, and global variables.

Experience in writing scripts for file watcher logic, Job control tables logics and also used VB

Scripts, windows scripts and executed in BODS using Exec function.

Scheduling the jobs and running the jobs in debug mode to trace the issues.

Scheduled the jobs in Production.

Deployed the jobs using Central Repo and ATLs.

Debugging execution errors using SAP Data Services logs (trace, Monitor, and error) and by

Examining the target data. Configuration of BODS, Repository creation and server management administration.

Central Repository configuration and best practices for version control

Scheduling the jobs and User Management in Management Console

ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).

Liaise with Business users and Business Analysts regarding requirements.

Developed Source to Target Mapping as per the requirements and Data Integrator jobs to different repositories and code migration purposes.

Migration the data from different GSAP servers to 1SAP Server to maintain all their operation from one system. Worked on Major Modules like Vendor Master and Designed the Data Migration Plan and implemented it in 1SAP Server.

Involved in Migrating Legacy data from non-SAP systems to the SAP systems (SAP ECC\BW\CRM\FI).

Developed code with standard IDOC's for transformation of SAP extracted data and loading it to SQL Server Tables.

Involved in code enhancement, testing based on change request (CR) from end users.

Environment:SAP Business Objects Data Integrator / Data Services (BODI / BODS), SAP ECC, SAP BW, Business Objects XI Suite, MS SQL Server 2008, Oracle 10g, ER Studio, MS Access 2000.

Microsoft, Redmond, WA January 2015 – August 2016

SAP BODS Developer

Responsibilities:

Coordination of offshore resources and objects, Post go-live support and optimizations. Worked on the existing interface performance tune.

Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.

Developed complex interfaces jobs for various systems SQL Server, Oracle, Flat file, JDE, SFDC, SAP BW, SAP ECC and Salesfoce.com, Prepared mapping documents and designed jobs accordingly.

Worked on the IDOC'S, Batch time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects using the Data Services Best Practices AIO methods by using IDOC methods.

Worked on the BW open Hub tables to extract the data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS using BODS. Used BW extractors as source, Used ABAP Data flows and Data Transport transform.

Experience capacity sizing PAM and Data Service architecture, Recommendation on Hardware Sizing and Architecture.

Experience in Data services administration and responsible for Installation and set-up of the data services as cluster environment for load balancing and data migration technical infrastructure, best practice migration content, strategy and standards.

Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.

Worked on the scripting & prepared a standard Incremental load template which enables the job failure/success notifications.

Provided BODS application development, support and maintenance for existing BODS interfaces.

Analyze and Review, functional requirements captured into Data Migration Functional Specifications and Define the process for review and delivery of data migration documents.

Simultaneously worked in multiple projects for production support as onsite coordinator and also working with the Deployment team to design new interfaces.

Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.

Requirements analysis and preparing Conceptual data models, gap analysis and associated solutions. Designed and developed functional specifications, technical specifications and Code review, Designed Logical, Physical models.

Automated the BODS Tool to Audit, Validation, Tracing and debugging Batch job; Capturing changes in data (Initial/Delta load) using Table Comparison, History Preserving, Key Generation Transforms.

Extensively worked with Different Transformations like Table comparisons, Date generation, Key generation, Query, Merge, Map operations, Validations, Pivot etc.

Experience in developing data migration interfaces to Salesforce.com

Monitor and worked on fixing issues with daily autopsy’s scheduled DW process jobs, performance tuning existing BODS jobs.

Coding custom functions and scripts used in Data Services project along with standard data migration based on business/functional specifications.

Environment:SAPBODS 4.1/4.2, MS SQL Server 2008, Oracle 11g, SAP BW, SAP ECC, Sales force, Windows.

San Diego Gas and Electric (Sempra Energy), San Diego CA. Mar 2012 – Dec 2014

SAP BODS Developer

Responsibilities:

Involved in project for Data Analytics team from start to its inception, responsible for implementing BOBJ 4.1 on SAP HANA 1.0.

Worked with ERP TFC\'s closely to understand the business process, coordinate with business analyst and TFC\'s on specific business rules.

Worked on SAP IS Utilities to help facilitate data migration.

Participate in Data Mapping workshops and follow-up meetings with the client business, DML\'s, DMC\'s and TFC\'s.

Created custom templates and custom lookups and shell jobs and used them in various business needs.

Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.

Worked extensively with SALES & DISTRIBUTION team to design data migration from Legacy system to SAP.

Installed & configured BODS XI 4.0 SP1 in Development & Production Server.

Created Local, Central and Profiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.

Configured the Data services to connect to the SAP R/3, BI and CRM.

Developed workflows to load data into Customer Master Sales data (KNVV) and Partner roles (KNVP) from legacy systems.

Developed jobs to load the legacy system data into COND_A04 IDOC (KOMG, KONH, KONP segments) by referencing SAP AIO SD pricing job.

Used Open Hub Services to push data out of SAP BI using BODS.

Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.

Used Data Integrator and Platform Transforms extensively.

Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.

Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS.

Interacted with both Legacy and Functional teams to design the mapping to load data into Customer Master IDOC (DEBMAS06).

Moved the projects from DEV to ST, ST to UAT and UAT to Production.

Scheduled the jobs, managed users and repositories in Management Console.

Drill down the Analytics to the detail level data.

Participated in detailed report design and created design specifications documents at report level.

Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.

Sound understanding of end to end Data Migration process including Extraction, Data Profiling, and Transformation and Generation of Load ready data files in LSMW format.

Ability to interpret, configure and implement data mapping / transformation business rules into Data Services

Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

Environment: SAPBODS 4.2, SAP R3, SAPBW, Oracle, SQL Server

Lenovo, Bangalore,India Aug 2010 – Feb 2012

SAP BODS Developer

Responsibilities:

Ability to interpret, configure and implement data mapping / transformation business rules into Data Services

Monitored BO scheduled jobs after major implementations and ensured post implementation support.

Initiated DBA interactions for resource requirements and modifications.

Created new mappings and updated old mappings per changes in Business logic.

Worked with various business groups while developing their applications, assisting in Database model design and SSIS (SQL server Integration Services)

Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients depending upon business requirement.

Transformed data from different heterogeneous data sources like Oracle, Teradata and ERP legacy data to SQL Server 2005 using OLE DB connection providers by creating various SSIS packages.

Tested, Cleaned and Standardized Data by meeting the business standards using Fuzzy exact lookups using SSIS tasks.

Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.

Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Server.

Scheduled the monthly/weekly/daily reports to run automatically.

Performed all DBA tasks like scheduling, index re-org, batch jobs and user creation.

Created report models for ad hoc reports when the end user wants to see the reports on fly.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Worked on UNIX(AIX) environment.

Performed server builds, installation on AIX(IBM) servers.

Troubleshooting and support on IBM p-series hardware.

Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.

Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.

Moved the jobs into QA and Production.

Strong Programming experience in MS SQL SERVER using T-SQL, SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services).

Hands on experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server and SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services)

Environment: SAP BODS 3.2/4.0, Oracle 10g, Windows XP

Safeway Corporation, Bangalore, India June 2009 – July 2010

Informatica Developer

Responsibilities:

Analyze the specifications and identify source data, which needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.

Implemented Slowly Changing Dimension type2 methodology for accessing the full history of accounts and transaction information.

Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Used Debugger to check the data flow in the mapping and made appropriate changes in the mappings to generate the required results.

Involved in the development of Informatica mappings

Resolving the Tickets and build UNIX Scripts for FTPFiles.

Problem Resolution Document Preparation

Developed mappings to load data in slowly changing dimensions.

Created Sessions in workflow manager and monitored it using workflow monitor.

Environment: Informatica 8.6, Oracle 9i, UNIX, Sybase, Windows 2000

Contact this candidate