| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Srinivasa RaoMobile: PHONE NUMBER AVAILABLE | Email: EMAIL AVAILABLESUMMARY:
With 8 years of Information Technology experience, I specialize in designing and implementing advanced solutions that combine Data Warehousing, Informatica, and integration with S/4 HANA using SAP BODS. Led Business Objects Data Services XI upgrade/migrated projects and managed Installation, Configuration, and Administration using SAP BODS Data Services PHONE NUMBER AVAILABLE (BODI 11.5/6.5). Over 5 years of client-side work experience in the United States. Skilled in data migration across O2C, P2P, and R2R processes and integrating non-SAP systems with SAP using Magnitude Source Connect. Experienced in defining business rules, architectural design, dimensional and relational modeling, ETL processes, and analytic application development. Proficient in SAP BW data modeling and integration, ensuring real-time analytics and reporting using SAP BW/4HANA. Expertise in data governance and compliance within SAP BW environments, maintaining data integrity and regulatory compliance. Skilled in developing and implementing reporting and analytics solutions leveraging S/4 HANA's embedded analytics capabilities. Develop custom Fiori applications for S/4 HANA, enhancing user experience and productivity. Experienced in Requirement Analysis, Design, Development, Implementation, and Testing Support of Data Warehousing and Data Integration Solutions using Informatica Intelligent Cloud Services and Informatica PowerCenter. Proficient in SAP ABAP programming for custom developments and data integration, including experience with BAPI (Business Application Programming Interface) and IDoc (Intermediate Document) technologies. Experience in Performance tuning of BODI/BODS & INFORMATICA Mappings at sources, mappings, and target level and tuning the SQL queries. I have experience in Data Validations, SAP Data Interfaces, Data Cleansing, Data Mappings, and Data Conversions of both SAP Master Data and SAP Transactional Data. Within the Sales and Distribution (SD) module, focus on enhancing sales processes, including order management, pricing, and delivery optimization, leveraging S/4 HANA to drive revenue growth and customer satisfaction. Experienced Functional Consultant with proficiency in SAP modules such as Sales and Distribution (SD), Material Management (MM), and other functional areas. Skilled in aligning technology solutions with business objectives to optimize processes and drive organizational success. Proficient in Project Management methodologies and practices. Experienced in Data Storage and Data Management.Technical Skills:CategorySkillsData WarehousingSAP Business Objects Data Services (BODS) 4.2/4.1/3.2/3.1, BOXI R3/R2, BODI 11.7 Informatica, Informatica IICS, SAP BI/BW, Information Steward, SAP Ariba, SAP BOBJBI ToolsSAP BI/BW/HANA, ETL Processes, SAP HANA Modeling, SAP Business Objects 4.x, Crystal Report 9/10/XI/2008, Xcelsius 4.5/2008, InfoView, Bex Query, Bex Analyzer, Desktop Intelligence XI, Web Intelligence, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0 Office, ABAP ConsultantDatabasesOracle 11/10g/9i, SSIS, DB2, Sybase, AWS Redshift, Teradata, Progress, MS SQL Server, PostgreSQLLanguagesSQL, PL/SQL, C, C++, Java, PythonOperating SystemsUNIX, Windows 95/98/00/NT/XP/VistaTools & UtilitiesUNIX Shell Scripts, TOAD, Quality Center 9.0GUIsDeveloper 2000, Microsoft Visual Studio 2005/2008, VB Script, .NETOther ToolsToad 6.3, SQL Developer, SQL * Load, Control M, MaestroJob Scheduling ToolsOracle Workflow, OEM, Control M, Maestro SchedulerData ModelingOracle Designer, Oracle Discoverer, Erwin 4.0/Model ManagerPROFFESIONAL EXPERIENCE:Bank Of The West, Irving, Texas January 2023 CurrentSAP Bods and S4 Hana DEVELOPER PROJECT#1: RESPONSIBILITIES: 1 managed multiple full life cycle SAP implementations of data migration projects, overseeing planning, execution, and post-implementation support. 2 Managed Material, Customer, and Vendor Master Data conversions, from data extraction to validation and loading into SAP systems. 3 Implemented Data Migration Methodology (ETL), conducting data profiling, cleansing, and validation activities to ensure data accuracy. 4 Utilized various data migration tools and solutions like Syniti, BODS, and MDG to automate migration processes. 5 Applied knowledge of MDM solutions for creating and maintaining master data to ensure data quality. 6 Acted as a self-developer on SAP S/4 and other models, integrating converted data into transformation programs. 7 Delivered projects using SAP ASAP & Agile methodologies, adapting project management approaches to meet client requirements. 8 Collaborated with clients to understand business requirements and translate them into technical solutions. 9 Developed and maintained ETL processes using SAP BODS for efficient data extraction, transformation, and loading. 10 Coordinated with key stakeholders to gather comprehensive requirements and transform them into technical solutions, showcasing adept problem-solving skills. 11 Supported continuous improvement initiatives to optimize project delivery and client satisfaction. 12 Designed and implemented data mappings, transformations, and workflows to meet business needs. 13 Monitored and optimized ETL job performance to enhance efficiency and scalability. 14 Scheduled and automated ETL jobs for reliable and timely execution. 15 Documented ETL processes, data flows, and transformations for knowledge-sharing and audit purposes. 16 Developed and executed performance test plans and scenarios to evaluate system performance. 17 Supported day-to-day functional and technical issues related to data migration and transformation with S4HANA & Magnitude Source Connect product. 18 Performed administrative tasks including Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, and Monitoring. 19 Demonstrated expertise in various lookup types such as Lookup Seq, Lookup Ext, and Lookup. 20 Engaged in Installation, configuration, maintenance, migration, and upgrade of several versions of BODS. 21 Engaged in BW Backend Development, contributing to the design and development of SAP BW front-end queries. 22 Monitored system performance during testing to identify bottlenecks and areas for improvement. 23 Implemented a Recovery Mechanism for unsuccessful batch job execution to maintain system reliability. 24 Managed the migration of Jobs and workflows from Development to Test and to Production Servers for integration and system testing. 25 Enhanced code reusability by creating custom functions and reusable components like Workflow, Data flows, batch, and real-time Jobs. 26 Utilized SQL Server applications including SSIS, Stored Procedures, SQL Querying, T-SQL, and OLTP for data processing. 27 Employed Try/Catch mechanisms to handle exceptions and automate the Job Process through scripting. 28 Executed data migration using LTMC Functionality for Transfer data using Files (Excel file), Transfer data by staging tables, and Transfer data directly from SAP System. 29 Designed and deployed robust SAP BI/BW/HANA solutions, ensuring scalability, reliability, and high performance. 30 Demonstrated ability to travel up to 50% to deliver consulting services in diverse client environments.ENVIRONMENT: BUSINESS OBJECTS DATA SERVICES 4.2, Informatica, SAPS4 HANA, Sybase, DB2, AUTOSYS, Tivoli, ORACLE, SQL Server 2005, Sales Rapid Marts, SSIS 10G, SQL, PL/SQL, UNIXPROJECT#2:Whole Foods Austin, TX April 2022 January 2023SAP BODS DEVELOPER
Responsibilities:Responsibilities: 31 Proficiently managed Local and Central Repositories, Job Servers, and Web Admin Client tools. 32 Skillfully operated the Web Admin/Management Console for scheduling and monitoring jobs. 33 Directed Administrative Tasks encompassing Repository, Job Server, and Central Repository configuration, Job Scheduling, and Monitoring. 34 Designed and executed both simple and intricate transformations in Data Flows. 35 Demonstrated expertise in various lookup types (Lookup Seq, Lookup Ext, Lookup). 36 Developed Workflows using object library and tool palette for executing data flows efficiently. 37 Engaged in BW Backend Development, crafting SAP BW front-end queries. 38 Ensured data integrity through meticulous data cleaning in DI using proper data types and mappings. 39 Innovatively created an external application in Webdynpro ABAP to facilitate smooth data transfer between applications. 40 Implemented a Recovery Mechanism to handle unsuccessful batch job execution effectively. 41 Orchestrated the Installation, configuration, maintenance, migration, and upgrade of BODS versions proficiently. 42 Executed seamless migration of Jobs and workflows from Development to Test and Production Servers for integration and system testing. 43 Crafted ETL programs using Informatica to fulfill diverse business requirements. 44 Designed Custom functions and reusable components like Workflow, Data flows, batch, and real-time Jobs for optimal efficiency. 45 Leveraged SQL Server applications like SSIS, Stored Procedures, SQL Querying, T-SQL, and OLTP extensively. 46 Conducted Performance Tuning of jobs, skillfully handling exceptions using Try/Catch mechanisms, and automating the Job Process through scripting. 47 Created HANA objects such as Calculations Views, Stored Procedures, and tables meticulously aligned with functional requirements. 48 Successfully reverse-engineered existing BW Data Flows and rebuilt them as native HANA solutions. 49 Produced SQL scripts, stored procedures, function calls, and designed tables and data loads integrated into HANA views. 50 Spearheaded the creation of HANA objects, ensuring meticulous alignment with functional requirements. 51 Responsible for designing and developing mappings, mapplets, sessions, and workflows for loading data from source to target database using Informatica Power Centre, while meticulously tuning mappings for performance improvement. 52 Executed data extraction from legacy systems to the Staging Area and loaded it to the target database seamlessly using Informatica Power Center.ENVIRONMENT: BUSINESS OBJECTS DATA SERVICES 4.2, Informatica, SAPS4 HANA, Sybase, DB2, SAP BW, ORACLE, SQL Server 2005, Sales Rapid Marts, SSIS 10G, SQL, PL/SQL, UNIX, P2P, Informatica Power Center 10.1. PROJECT#3:Wesco, Inc. Muskegon, MI November 2021 - April 2022SAP BODS CONSULTANTResponsibilities: 53 Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs. 54 Used Informatica Power Center 10.1 for extraction, loading, and transformation (ETL) in the Data Warehouse. 55 Strong experience / past experience in data stores and different file formats, nested data and XML schema, SAP Connection, developing sequential and parallel workflows, interactive debugger, Data Services Management Console, Data Profiler, Job Scheduling, and Unix Shell Scripting.
56 Experience in Data Migration methodologies, specifically around legacy to SAP migration. 57 Involved in Data Cleansing and Data Profiling 58 Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager (Workflow Manager Tools - Task Developer, Workflow & Worklet Designer) 59 Involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, and Monitoring. 60 Extensively worked on the development of mappings and worked with BODS Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation,
61 Scheduling the jobs using third-party scheduler AUTOSYS.ENVIRONMENT: SAP Business Objects Data Services 4.2/4.1 (SAP BODS/BODI 4.0/3.2/3.1), AUTOSYS, TERADATA, SAP INFORMATION STEWARD 4.0, SAP BI/BO 4.0, Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, Report2Web.PROJECT#4:Gmr Infotech, Tamil Nadu, India May 2017 August 2021SAP Bods DEVELOPERResponsibilities: 62 Involved in Migration of Jobs and workflows from Development to Test and to Production Servers to perform the integration and system testing. 63 Created Custom functions to make the code reusable. 64 Extracted data from legacy systems to the Staging Area and loaded the data to the target database by ETL process using Informatica Power Center. 65 Created reusable components like Workflow, Data flows, batch, and real-time Jobs. 66 I worked extensively with SQL Server applications like SSIS, Stored Procedures, SQL Querying, T-SQL, and OLTP. 67 Extensively worked on Performance Tuning of the jobs. 68 Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process. 69 Created HANA objects such as Calculations Views, Stored Procedures, tables, etc. to meet functional requirements. 70 Reverse-engineer existing BW Data Flows and rebuild as native HANA solutions. 71 Ability to write SQL scripts and stored procedures, function calls, designing tables, data loads, and building, modifying, and integrating into HANA views.ENVIRONMENT: BUSINESS OBJECTS DATA SERVICES 4. x, SAP Ariba data. INFORMATICA, SAP HANA, Sybase, DB2, SAP BW, ORACLE, SQL Server 2005, Sales Rapid Marts, SSIS 10G, SQL, PL/SQL, UNIX, WINDOWS XP.Alltel Hyderabad, India Internship: March 2016- May 2017SAP IXp Intern - Digital Sales Development Associate
Responsibilities: Checked the validity of data in the backend DB2 and UDB tables. Involved in validating and testing the clinical trial les and dumping them into the application. Validated whether the inbound trial lens is dumped into the respective applications. Involved in client negotiations in gathering the claims and setting up the environment internally. Interaction with TSO, and JCL as interfaces to MVS Tested.ASPX Forms and User Controls using C#.NET. Validated the inbound and outbound EDI transactions.
Involved in adjudicating medical and pharmacy claims. Developed Test plan and modified the test plan when required in later stages of testing. Defects were created, tracked, reviewed, analyzed, stored test data, and compared using Test Director8.0 Involved in validating Main Frame interfaces for business applications. Involved with the business integrators in gathering the requirements. Involved in setting up the data for the Integrator testing and validating the data setup and claims before they are sent out.EDUCATION: Bachelor of Technology in Electronics and Communications Engineering JNTU Kakinada Guntur, AP 2017 |
