SUMMARY:

• Having 13+ years’ Experience in IT including SAP BW4HANA/BI 7.4/ABAP / BO / HANA in data modeling, data loading and involved Mainframe Enhancements Projects. Has good Domain knowledge in Manufacturing, Healthcare, Financial, Telecom and Retail.
• Extensive experience in implementing back - end BI/BW Components including Extractors, Data Sources, Info Objects, Info Sources, Transformations, Info Cubes, Multi providers, Standard DSO, Write-Optimized DSOs, Open Hub Extracts, Data Transfer Process (DTP), Info Sets, Info Packages, Update Rules, Transfer Rules, Info Cube aggregates.
• Major responsibilities include BI/BW Architecture, Backend and frontend development, Technical and Functional specifications documentation, Development, Performance tuning, Go-Live and Post-Production support activities.
• Good knowledge on ABAP related to SAP BI.
• Good Experience on Business Object Data Services (BODS 4.2) version.
• Extensive Knowledge in developing data models in HANA 1.0 SP12
• Extensive Knowledge in SAP SD (OTC) Functional Flow.
• Good Knowledge on Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Expertise in Data Modeling using multi Dimensional/Star schema and extended star schema models.
• Extensive hands on experience using BEX analyzer in developing queries using conditions, exceptions, selection variables, Customer exit variables, Formula Variables, Replacement path variables, Structures, Calculated and Restricted key figures and exception aggregations.
• Expertise in extracting data using Logistic Cockpit, COPA, Generic extractors.
• Extensive experience of Data Source Enhancement Transfer and update rules with start and end routines, User exits, loading (Full/Delta Up-Load), Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User profile Maintenance.
• Developed and Optimized Aggregates using the proposals from BI Statistics and Queries.
• Compression of Info Cubes and Aggregates was performed as part of regular maintenance activities.
• Info cubes were partitioned whenever necessary. Line item dimensions were used while modeling the info cubes.
• Maintained performance settings for query execution, developed indexes and captured DB Statistics.
• Periodically monitor and maintain the global and local OLAP Cache persistence parameters to improve query performance.
• Strong Knowledge in SAP BO reporting tools above SAP BI/BW to develop formatted reports using Crystal reports, Universes, Design Studio, Lumira, Web Intelligence (WEBI) and Xcelsius.
• Expert in Universe designing, developing and generating WEBI Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Handled BO Promotion/Demotion tickets created by Users.
• Handled BO User Creation in CMC.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Principal Consultant

Environment: Software SAP R/3, BI 7.4 HANA, BO

Languages: SAP BW/ABAP

Responsibilities:

• Involved Requirement Gathering and understand existing BW system
• Involved Design discussion and preparing functional specification
• Involved BW Modeling and Bex queries for PFR, OOS and Distress reports

Confidential

Sr. Principal Consultant

Environment: Software SAP R/3, BI 7.4 HANA, SAP SD

Languages: SAP BW/ ABAP

Responsibilities:

• Involved Requirement Gathering and understand existing BW system
• Trained SD Complete life cycle with stakeholders and involved production issues.
• Attended Business meetings to understand the business at client place.

Confidential

Sr. Principal Consultant

Environment: Software SAP R/3, BI 7.4, BO

Languages: SAP BW / ABAP

Responsibilities:

• Design functional specification and technical specification for Tax and Revenue Management module.
• Extracted data from various source systems (Nexus, Retrack and ECC) and modelling objects in BW system such as DSO, Info Cube and Multi provider.
• Created ABAP code for field routine, end routine and Start routine of master data look up and Transactional data look up.
• Create generic data sources using ABAP function module as per the requirement.
• Enhanced the standard data source for additional fields as per the requirement
• Created Bex reports for Register Activities, Register activates Tax payer, collection reports…etc.
• Optimize the data loads performance by writing the ABAP Code in Generic data source such as open cursor and fetch cursor in the function module.
• Working with Basis team to resolve any system related issues like IDOC struck or System hang.
• Created WEBI report on top of Bex reports GGST Return Data, TGST Return Data, Combined Arrears, Account Statement, Age Analysis, Schedule report ……Etc.

Confidential

Sr. Principal Consultant

Environment: Software SAP S4HANA, BO

Languages: PL/SQL

Responsibilities:

• Interacting with Business Users to understand the Business requirements and prepared/reviewed technical documents for implementing the solutions as per Business needs.
• Involved Requirement Gathering and understand existing S4HANA system
• Developed calculation views to achieve business requirement.
• Design functional specification and technical specification for Plant Maintenance EAM Reports.

Confidential

Sr. Principal Consultant

Environment: Software SAP R/3, BI 7.4/HANA/BO

Languages: SAP BW / ABAP

Responsibilities:

• Extraction of Data on Daily/Weekly/Monthly basis from various R/3 and Non R/3 system to BW system.
• Monitoring of data loading through process chains and Info Packages and DTP’s.
• Involved Performance tuning of Process chain Data Loads.
• Involved in prioritized tickets regarding extractions, performance issues and also load failures.
• Maintaining work History for all the tickets until it is closed down.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Closely work with the IT functional Portfolio Managers (SD, FI and MM) and the Business to determine how SAP BW can be expanded to meet their reporting needs.
• Worked on Enhancement of Data Source in R/3 and BW to in corporate additional fields and Extraction of Data related to additional fields for the extractors.
• Performed unit testing and data validation of newly developed and enhanced objects in Quality BW system in terms of providing an efficient solution.
• Involved in Transportation of various BWD Objects to BWT System.
• Enhanced Dso’s and Cube’s with new info objects and populated the data accordingly to help of reporting.
• Involved Cut over Activity for implement new enhanced changes into production smoothly.
• Working with Basis team to resolve any system related issues like IDOC struck or System hang.
• Resolved customer reported tickets through Email and Phone.
• Actively participate within the team to support other team members as required. Share ideas and provide advice, guidance and assistance to others within the team in order to develop the capability of the team and self
• Designed WEBI reports on top of Universe as per client requirement.
• BO Promotions / Demotions (Reports, Universes’) moving Dev to QA and Prod as Developer Request.
• Modifying BO (Universe’s) to add new fields with existing Reports.
• Refreshed Updated structures in IDT and Creating WEBI Reports as per user request.
• Involved Partner Migrations from universe to Bex Query Creations.
• Involved End to End Implementation right from ECC Changes, BW Changes and BO Report creation and tested in Dev region, QA Region and then Prod Region.
• Involved Cut over activities and closely working with Basis Team for any issues arises.

Confidential

Lead Consultant

Environment: Software SAP R/3, BI 7.0

Languages: SAP BW / ABAP

Responsibilities:

• Develop relationships with the key business partners in each EMEA market to understand their reporting needs.
• Closely work with the IT functional Portfolio Managers (SD, FI and MM) and the Business to determine how SAP BW can be expanded to meet their reporting needs.
• Design and develop technical BW solutions based upon business requirements for consistent use of BW across the European business, in conjunction with the global strategy. This will be achieved through close integration with the central SAP R/3 and BW teams.
• Enhanced Data Sources 0FI AR 4 for the extract structure DTFIAR 4 appended fields Industry Key and Sales Office, Business area using enhancement RSAP0001.
• Enhanced and Generated Special Purpose Ledger Summary Extractor Data Sources 3FI SL XX TT, 3FI SL XX SI appended fields Industry Key, Sales Office, GPP Portfolio, Sold to, Sales Distribution Channel, Sales Division and Payer Business area using enhancement RSAP0001.
• Enhanced Data Sources Profitability Analysis-COPA appended fields Sales Office and Ship To Party Business area using enhancement RSAP0001.
• Maintained Supporting Master Data Objects and replicated Data sources in BW System.
• Worked on Enhancement of Data Source in R/3 and BW to in corporate additional fields and Extraction of Data related to additional fields for the extractors.
• Performed unit testing and data validation of newly developed and enhanced objects in Quality BW system in terms of providing an efficient solution.
• Involved in Transportation of various BWD Objects to BWT System.
• Enhanced Dso’s and Cube’s with new info objects and populated the data accordingly to help of reporting.

Confidential

Lead Consultant

Tool: BO: WEBI

Environment: Software SAP R/3, BI 7.0, BO

Languages: SAP BW/ABAP

Responsibilities:

• Develop relationships with the key business partners in each EMEA market to understand their reporting needs.
• Closely work with the IT functional Portfolio Managers (SD, FI and MM) and the Business to determine how SAP BW can be expanded to meet their reporting needs.
• Design and develop technical BW solutions based upon business requirements for consistent use of BW across the European business, in conjunction with the global strategy. This will be achieved through close integration with the central SAP R/3 and BW teams.
• Contribute to the full project life cycle (project management, design, development, testing, training etc) to ensure the delivery of BW projects is on time and to budget.
• Actively participate within the team to support other team members as required. Share ideas and provide advice, guidance and assistance to others within the team in order to develop the capability of the team and self
• Production systems support, regression testing, reconciliation and monitoring of monthly releases of new developments into Production.

Confidential

Project Lead

Tool: BO: WEBI

Environment: Software SAP R/3, BI 7.0, BO

Languages: SAP BW/ABAP

Responsibilities:

• Involved in Analysis of the new design.
• Involved in the Client/Onsite communication for any client side clarifications, for assignment of work, for discussing on project status related issues.
• Extensively worked with Enhancement of existing data flow for the new requirements of customer
• Developed various BW objects like Info object, info cube, ODS, Multiprovider.
• Involved in initializing the LO data sources - 2LIS 11 VAITM and 2LIS 11 VASCL by activating the Business Content Data Sources, Enhancing the Variable in Report with Enhancement RSR00001 and Function exit EXIT SAPLRRS0 001.
• Worked on Enhancement of Data Source in R/3 and BW to in corporate additional fields and Extraction of Data related to additional fields for the extractors.
• Created Customer Exit in reports for displaying present year and last year Data for given input Date.
• Created generic extraction using Function Module for getting condition data using zxxxxx structure for the fields Sales Doc, record date, Net Value of document currency, Flag indicator, Item number Etc.
• Enhanced Data Sources 0FI AR 3 for the extract structure DTFAR 3 appended fields profit center, controlling area, Business area using enhancement RSAP0001.
• Performed unit testing and data validation of newly developed and enhanced objects in Quality BW system in terms of providing an efficient solution.
• Involved in managing of info cubes, which involves info cube content, performance issues like Indexes, Statistics, and Compression of info cube and Rolling up the data to the Aggregates.
• Involved solving performance related issues by applying partitioning, Aggregates and Compression.

Confidential

Technical Lead

Tool: Remedy

Environment: Software SAP R/3, BI 7.0, BO

Languages: SAP BW/ABAP

Responsibilities:

• Extraction of Data on Daily/Weekly/Monthly basis from various R/3 and Non R/3 system to BW system.
• Monitoring of data loading through process chains and Info Packages and DTP’s.
• Involved in prioritized tickets regarding extractions, performance issues and also load failures.
• Maintaining work History for all the tickets until it is closed down.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• To inform the onsite people if there any Deadlocks.
• To communicate with customer who posted the ticket.
• Resolved customer reported tickets through Email and Phone.

Confidential

Senior Software Engineer

Tool: Remedy, Changeman, Expeditor, Omegaman

Environment: (with skill versions)

Software: Mainframes OS/390

Languages: COBOL,CICS,DB2,JCL,Platinum,Endevour

Responsibilities:

• Providing permanent fixes for Development problems.
• Analysis of SOAP Defect messages.
• Giving End to End User support to understand them Confidential technologies.
• Code development, test plan preparations and testing.
• Monitoring Ticket tracking Tool and Assigning tickets to Team members.
• Analyzing CICS Region Logs
• Monitoring CICS Performance and throughput using Omega man.
• Doing Health checks for every CICS regions.
• Monitoring DB2 performance and throughput using Omega man.
• Continuously touch with CICS Support for Recycling CICS regions.

Confidential

Senior Software Engineer

Tools: Expeditor, Endeavor

Environment: (with skill versions)

Software: Mainframes

Languages: Cobol, JCL, CICS and DB2,File-AID

Responsibilities:

• Doing Major enhancements for the all MMIS Subsystems..
• Providing appropriate solutions to the CSR Logs.
• Maintaining application and technical support and documentation..
• Communicate directly with the SME for analysis and implementation of work requests.
• Executing CSR requests which involves analysis, coding, testing, implementation, and documentation
• Ensuring timely deliveries of work requests and quality of deliverables as per laid down processes
• Implementing Confidential rule in all MMIS subsystems.

Confidential

Software Engineer

Responsibilities:

• Maintenance & Enhancement of the existing programs in order to meet the changing business requirements.
• Code development, test plan preparations and testing.
• Providing permanent fixes for production problems.
• Maintenance of Quality standards.
• Conduct reviews and other quality related procedures.
• Monitoring Ticket tracking Tool and Assigning tickets to Team members.
• Proactive towards train the new joinees, ability to interact with Clients.
• Involve Project related Quality Activities