VISHWA TEJA BARLA

704-***-**** · ad0bvo@r.postjobfree.com Charlotte, NC 28215

Professional Summary

●SAP Business Objects consultant with over 8 years of BI and Data Warehousing, Data migration & SAP BO Administrator experience.

●Managed onsite and offshore teams for Production Support activities as well as for development and data migration projects.

●Experienced specialized in designing and developing ETLs using various versions of SAP BODS(4.2,4.3).

●Downloaded and reviewed the out of box BPDM Solution for SAP ECC and created the technical and functional specs.

●Well-versed in using Data Services Designer to extract and load data in formats such as Flat Files, Excel worksheets, XML, JSON from SharePoint, and databases like HANA, DB2, Oracle, and SQL server.

●Proficient in SQL.

●Experience in getting files from SFTP path and archive files to SFTP path using shell script.

● Experienced with the SAP MM, SD, WM, PM, FI, CO, QM modules.

●Sound understanding of end-to-end data migration process including extraction, Data Profiling, transformation and generation of load ready data files in LSMW format/Emigalls format.

●Well-versed with Data Quality and Data Movement Control activities in BODS.

●Experienced in Performance tuning and Job run time optimization like code push down etc.

●Experience in different types of transformations like Query transformation, Merge, Case, Validations, Map- operation, History Preserving, and Table Comparison transformations. Experience in code version management tools.

●Extensive knowledge of Job schedule automation tools like Atomic.

●Experienced in creating jobs, workflows, data flows, and transformations to integrate source data into target warehouses, meeting specific requirements.

●Experienced in administration experience of SAP BODS, effectively configured repositories, servers, system configurations, and deployment.

●Demonstrated expertise in handling various file types (IDOCs, XML, tables, text files, CSVs) and transforms.

●Migrated data from Oracle 12g to SQL server 2012 by using SQL server integration service (SSIS) and SQL Server Migration Assistance for Oracle (SSMA).

●Experienced in utilizing Query, Table Comparison, History Preserving, Validation Transform, Key Generation, Map Operation, Lookups, Lookup_ext, table Joins, and custom functions.

●Expertise in data integration transforms like Date Generator, Hierarchy_flattening, Effective date, Table Comparison, and Data Transfer Transform to optimize job performance.

●Extensive experience in loading data into S4 HANA, employing IDOC, BAPI, LTMC, LTMOM, LSMW, Information Steward (IS), and the Data Migration Cockpit.

●Worked with various file formats (CSV, Excel) and databases such as MS SQL.

●Expertise in loading data into SAP ECC Source and S4 Hana target systems using BODS tool.

●Experienced in SQL language utilized for development of reports.

●Experienced in data quality models of data services (BODS).

●Experienced in data profiling using SAP BODS and data insight tool.

●Strong knowledge of Data Modeling Concepts, snowflake schema, multi star schema, extended star schema etc.

●Experienced in customer interactions for requirement gathering, working closely with clients and gathering business level information to be utilized to create universes, reports for ad-hoc and canned reporting usage.

●Worked closely in creating test cases, performing UAT and testing reports to ensure quality.

●Worked on multiple database systems including Oracle, Teradata, and MS SQL Server.

●Integrated SAP HANA with external systems and data sources using technologies like SLT (SAP Landscape Transformation) and SDI (Smart Data Integration), enabling real-time data replication and integration.

●Install, upgrade, configure, deploy, automate, monitor, and optimize the performance of Business Objects application.

●Submit and manage issues and enhancement cases with BI for administration/environment related items.

●Expertise in Administration of Business Objects Business Intelligence Platform 3.1, 4.1/4.3. Expertise in Administration of Business Objects Data Services and Information Steward 4.1/4.2/4.3 BO Servers Upgrade from version BO BI 4.0 to latest version BO BI 4.1. BO Ds and IS Servers Upgrade from version 4.1 to latest version 4.2.

●Develop mechanisms and automation for deploying BI projects and configuration changes across various environments.

●Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

●Proficient in utilizing SAP BOBJ Reporting Tool for creating insightful reports and implementing advanced functionalities.

●In Depth Knowledge in setup of BPDM/RDMS Jobs and end to end functioning.

●Knowledge of the setup of SQL2D12. DS. IS and SAP LOGON.

●Knowledge in setup of lookup job and end to end functionality.

●Worked on heterogenous source systems to extract data and load it into the S4 Hanna via IDOC and LTMC.

●Hands on experience in RICEFW developments.

●Worked on SD, MM, FI, PP.

●Experience in Reporting, Customizing, Implementing, Developing, and Integrating SAP R/3.

●Thorough understanding of ABAP Workbench tools such as ABAP Dictionary, ABAP Editor, Function Builder, and Transactions.

●Support development teams via object/code migrations across environments

●Develop mechanisms and automation for deploying or refreshing BI projects and configuration changes across the various environments, including User/Group Provisioning and DB Instances

●Support BI and development teams with user/group security provisioning in BI

●Facilitate customer user provisioning in Business Objects

●Primary owner of test, build, release process in development and production infrastructures. Responsible for executing standard software source control, QA processes, build plan, deploy software to all development and production environments, continuous improvement of release processes including using automation, manual tools and methods.

●Adopt and communicate new concepts, ideas, techniques, and best practices specific to BI

●Deliver performance tuning of SAP BO architecture.

●Good in Technical issues. problem solving and confident decision making.

●Providing training sessions to the team members on introduction to development on SAP BODS designer.

SKILLS

●Microsoft SQL Server 2008,2014

●Central Configuration Manager

●Oracle

●Windows Server 2003,2005,2008,2012

●HP QC, Remedy, Service-Now

●SAP ABAP

●SAP BOBJ

●Designer, Web Intelligence, Desktop Intelligence, Central Management Console.

●SAP Business Objects

●ETL Processes

●Staging Tables

●Data Analysis

●Reporting Tools

●Data Visualization

●Gather Project Requirements

●Test and Optimize Systems

●Extraction Transformation and Loading (ETL)

●Data Warehouse Development

●Programming Skills

●Business and Technical Analysis

●Business Intelligence Reporting

Work History

Nov 2020 - Current

Sunnyvale, CA

Business Objects Data Migration Consultant / Polaris / Accenture

●Lead team of 6 Developers development team and finalizing the Development approach.

●Experienced in Greenfield S/4HANA Implementation for data migration.

●Applied relevancy rules like dates, Business filter values and plant no.’s during data extraction to get the in-scope data.

●Developed data load strategy, data conversion dependencies and followed Coding principles, Data standards and Naming conventions.

●Loaded data using LTMC & LTMOM, Idoc and Bapi.

●Preload and post load validations to ensure mandatory fields, configuration, formats of the data.

●Helping business in preload validation.

●Responsible for preparing the load files and bug fixes for Material Master.

●Preparing reports for the data Validation.

●Sole Responsible for Business Partner (Customers) to be migrated in S4Hana.

●Successfully migrated the Data in S4 and supported the Go Live activities.

●Moving Code from Dev to QA to Prod using Check in/ Check out.

●Monitoring the scheduled jobs, Analyzing the issues and bug fix in production Environment.

●Developing new jobs as per the business requirements in BODS.

●Used SAP Data migration strategy to migrate from Non-SAP to SAP S4 HANA using SAP Business Objects Data Services (BODS) with SAP BPDM Jobs using IDocs.

●Designing the data Migration Landscape.

●Responsible for conducting the daily review call with internal team and Client.

●Successfully migrated data in Mock t. Cutover. Go-Live and Go-live support.

●Preparing Execution Process documents for the created SAP BODS objects.

●Successfully loaded data in SAP BW for Historical migration.

●Scheduled jobs in third party scheduler.

●Load balancer activity performed in different servers of BODS.

●Administered and managed user groups and securities in BODS(4.2,4.3).

●Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object Data Services (BODS).

●Experience with cluster environment

●Experience with WEBI and Crystal functionalities

●Understanding security set up and environment refresh mechanism, system upgrade and vulnerability patches.

●Experienced in BODS performance tuning techniques like parallel processing, Multithreading, Partitioning.

●Work closely with BI Architects to incorporate server level changes.

●Involved in Functional Acceptance testing (FAT) and User Acceptance testing (UAT) Created Test cases, reviewed and maintained test scripts, analyzed bugs, worked with development team and ETL team members in fixing defects and validating solutions.

●Sole responsible for business partner (Customers) to be migrated in S4Hana.

●Preparing execution process documents for the created SAP BODS objects.

●Analyzed data to see whether Data matches to user Expectations.

●Heavily involved in End user Training and system Documentation.

Dec 2018 - Nov 2020

Hyderabad, India

SAP Business Objects (BODS) Senior Developer / 7-Elevan (Accenture)

●Part of phase-3 requirement gathering and initial discussion to finalize the approach for data migration to s4.

●Created UTC document.

●Worked with Service-Now as a major ticketing tool and led all production support tasks.

●Worked on Finance and costing module, Fund management module also worked on objects like functional location and equipment in PM Module.

●Loaded data for material class, characteristics and classifications via IDOC.

●Experience in working with Table Comparison, Map Operation, Validate, Case, Data Transfer and Query Transforms.

●Experienced in Data Quality Transforms - Global Address cleanse, U.S. Regulatory address cleanse - loaded Quality codes - Q1 and Q2 into the target.

●Moving Code from Dev to QA to Prod using Check in/ Check out.

●Monitoring the scheduled jobs, Analyzing the issues and bug fix in production Environment.

●Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.

●Involved in SAP Business Objects (BODS) system migration Using Report conversion tool, Update Management tool.

●Created a new security structure for Business Objects (BODS 4.2,4.3) and implemented folder-based security.

●Responsible for moving content from one environment to another for full life cycle of new development.

●Used publications with report bursting to leverage daily mass report generation requirement.

●Successfully managed and co-ordinate onsite and Offshore teams.

●Developed reports for given business requirements and received user sign-off.

●Promoted repository objects (Universes, Reports, folders) from one environment to another.

●Defined and led the Development team for new projects using BODS.

●Entered and maintained departmental records in the company database.

●Generated reports to suggest corrective actions and process improvements.

June 2016 - Nov 2018

Hyderabad, Telangana

Business Objects Consultant / Sahari IT Solutions

●Utilized ETL tools such as BODS (Business Objects Data Services) and SAP Information Steward for data cleansing, profiling, and validation tasks.

●Used Data migration techniques like deduplication for customer data, Pattern matching, string matching, validate transform, Domain value check.

●Implemented performance optimization for SAP BODS jobs.

●Experience with loading Master data - Materials and Assets Master data using Inbound IDOC using BODS.

●Used Web Intelligence to Create Reports.

●Created Master/Detail Reports for Reconciliation reports.

●Created different variables and formulae to show different subtotals.

●Created reports using different formulae and variables to match those with that of SQL scripts.

● Allocation of rights to different module access to users.

●Made changes to the universe in the production database to create effective reports.

●Created Universe, Classes, Objects and measures.

●Created Joins complex multi column joins with conditions, Context and Aliases for Resolving Loops and Checked Integrity of Universes.

●Formatted reports as per user requirements.

●Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.

●Suggested modifications in the Universe in existing objects or by creating new objects.

●Used Free-Hand SQL to leverage report requirements to bypass change in the universe.

●Involved in Resolving Problems like 'Chasm Trap' and 'Fan Trap'.

●Involved in User Acceptance Testing, creating test cases and worked for final signoffs.

●Involved with SAP Business Objects (BODS) Administrators to ensure and test correct security and schedule settings.

June 2015 - May 2016

Hyderabad, Telangana

SAP Intern / Aktrix Technologies

●Worked as Business Objects (BODS)Developer intern to develop reports in Web Intelligence, Desktop Intelligence and Crystal Reports.

●Involved in requirement gathering, analysis & development of business reports.

●Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results.

●Specified standards for universes, Classes, Aliases, Simple and complex objects.

●Created joins, cardinalities, resolved loops and checked Integrity.

●Organized data in reports by using filter, sorting, and ranking & highlighted Data.

●Responsible for analyzing source system architecture in SQL Server, involved in Unit Testing and User Acceptance Test.

Education

May 2016

Hyderabad

Bachelor of Science in Engineering

JNTUH

Contact this candidate