SUMMARY:

• Over 8 years of IT industry experience of which 6.5 years in SAP BW (3.5, 7.x) in SRM module.
• Experienced in translating requirements to functional specs and then designing the datawarehouse.
• Knowledge and experience in overall SAP BI Architecture.
• Involved in multiple full lifecycle of product development.
• Involved in upgrading from BW 3.5 to BW 7.x.
• Extensively worked in extended star schema data modeling, real time data modeling and Lean BI data modeling.
• Extensively worked in reporting tools ( BEX Query designer, BEX Web application designer, Xcelsius, WEBI) and front end integration.
• Extensively involved in support and testing activities.
• Experienced in extraction of data from ECC, Flat files and relational database.
• Sound knowledge of generic datasources, enhancement of standard datasources using customer exit and BADI, LO Cockpit, archiving, integrated planning.
• Experienced in ABAP workbench.
• Experienced in Partner development infrastructure tool for Business by design.
• Functional experience in SRM processes.
• Experienced in agile methodology.
• Good understanding of Best practices in SAP BW and performance tuning of existing models.
• Experience with working with teams in different geographical location.

TECHNICAL SKILLS:

ERP: SAP BW Versions: 3.5 7.0, 7.01, 7.02

Languages: ABAP/4, PL/SQL

Database: Oracle 8i

Tools: BEX tools, Business Objects tools, Oracle Reports 6i, 9iOracle Forms 9i

PROFESSIONAL EXPERIENCE:

Confidential

Principle Software Engineer

Responsibilities:

• Worked with functional consultants to get the requirements for reports, dashboards, and Key performance indicators.
• Based on the requirements designed the standard BW Content, reports, Authorizations and data flows.
• Developed standard BI content for SRM (Purchase Order, Purchase Request, Contract, Supplier Invoice, Request for Quotation, Supplier Quote, Shopping cart)
• Involved in development and loading of master data object (Purchasing Organization)
• Designed the dimensions for the infocubes in order to increase the performance.
• Designed and developed the multiprovider and infoset based on the reporting requirement.
• Designed and developed Query start authorization PFCG roles (single and composite) for authorization.
• Configured the reports in the portal (iview).
• Created dashboards using web application designer.
• Migration BW 3.5 to 7.0
• Developed BI Content for BW 7.X
• Created standard datasource for RFQ Request using datasource builder (DSDB) and was involved in creating the application callback class for extracting data to BW.
• Experience with full loads and delta loads.
• Designed and modeled BI content like infocubes, Datastore objects, multiprovider, Infoset, hybrid provider.
• Developed transformations and start routines using ABAP to in corporate Business logic and data manipulation.
• Created Open Hub Destination Objects (InfoSpoke) to transfer data from standard Data Store Objects to Flat Files.
• Designed and developed process chains to automate the data loads.
• Designed and developed the authorizations (standard and analysis authorization).
• Defined authorization relevant infoObjects and loaded the authorization DSO’s with data.
• Created visual composer models to create a information consumer pattern (ICP) in the overview page of workcenters.
• Created and used different types of variables (authorization, hierarchy to restrict the query results and to check authorization.
• Involved in migration of the BW content to near realtime data acquisition scenario.
• Created objects for near realtime data acquisition ( realtime datasource, Realtime daemon, Hybrid providers)
• Defined report to report navigation.
• Validated Integration of BOBJ Xcelsius with BW infrastructure. This involved defining query with property “Allow external access to this query” . Created a remote function module based on “RRW3 GET QUERY VIEW DATA”. Created a web service using this function module in transaction SOAMANAGER and consumed this in the Xcelsius.
• Created reusable web items to display Charts in the front end.
• Involved in performance optimization of queries by maintaining Aggregates, Compression, partition and Indexing of Infocubes, caching strategies.
• Used the RSRT transaction to debug queries.
• Migration to Lean BW (Realtime analytics). This is a Main memory based model where TREX persistency was used.
• Designed and developed Analytics enablement Object to store additional data/ calculation that does not come from the backend.
• Create FSI Queries to get data from backend.
• Designed and developed Lean BI metadata objects like Query definition (QDEF), Multidimensional Analytical view (MDAV), Union Multidimensional Analytical view (Union MDAV), Keyfigure Composite(KFC), Report Face, Display settings and analysis pattern.
• Authorization is based on Access control list which was included in the FSI views.
• Involved in unit testing of all the BW content created in the development system
• Involved in setting up (installing BW Content) test systems and quality system for further testing.
• Involved in testing data flow from datasource to the data target.
• Involved in performance testing of load and report read times (sm50 - source system extraction time, rsa3 - extraction time, st05 sql trace, RSRT- Read time)
• Involved in functional testing to see if the report data is correct
• Involved in Regression testing whenever there are changes to the BW content or NW changes are imported.
• Involved in testing the authorization concept.
• Responsible for monitoring of internal message queue and customer message queue.
• Analyzing issues in the test system / customer system and providing bug fixes.
• Involved in the creation of hotfix in case of customer issue and creation of notes to fix the issue.
• Monitored the data loads in internal system, reconstructed request from PSA whenever required.
• Overall responsible for purchasing manager Workcenter.
• Configured the approval tasks (Purchase order approval, shopping cart approval, supplier invoice approval etc) in the object work list.
• Configured reports from different areas into the managing Workcenter.
• Developed SRM specific reports and dashboards for the manager Workcenter.
• Developed the SRM specific KPI’s and configured them in the Workcenter.
• Lifecycle Management in Partner development Infrastructure
• Partner development infrastructure is a tool used by SAP partners to build add on’s of different levels of integration that used Business By design as a platform.
• I was involved in design, development and maintenance of the backend operations of the Copernicus tool used for creating the partner add-on. Agile methodology was used in this development
• Designed and Developed the backend logic for roles of different kinds of users involved in the partner development using ABAP Workbench
• Involved in the writing/modifying function modules for the following backend operations that are called by the partner frontend tool (Copernicus tool)during different phases of the add-on development.
• To handle and maintain the lifecycle status of the partner development project
• Registering the add-on in the product and production management system (PPMS)
• To make calls to add on assembly kit (AAK) and other tools in backend
• To trigger test deployment of add-on’s
• To trigger release of the add-on to service market place.
• Involved in testing the entire add-on creation and deployment process since this needed to be done every day.
• Adobe Form Development For SAP Business ByDesign Supplier Relationship Management (SRM)
• Overall responsible for adobe form integration for SRM area.
• Planning tasks for each sprint and making sure the deliverable are completed
• Prioritizing tasks and making sure the delivery is on time.
• Co-coordinating requirement gathering and testing activities
• Monitoring the internal and customer message queue and assigning the issues to developers.

Confidential

Responsibilities:

• Requirement gathering for the new Business function RFQ Request.
• Designing the backend and UI functionalities
• Created UI prototype using UI designer
• Involved in writing design document and technical documents.

Confidential

Developer

Responsibilities:

• Developed different components in oracle apps like interface, extension, programs, forms, reports, shell scripts, alerts etc.
• Understanding the client’s goal of bringing their operations spread across various countries into a single unified platform and how it will aid in reducing maintenance costs and also assist in leveraging synergies in process and technology across the various divisions round the globe.
• Understanding of the linkage between the Oracle Applications front end and UNIX back end.
• Developed and customized reports as per the client’s requirements, which included the design of the query for fetching the data from back end and making proper layout to display the reports in the specified format in PO, OM, INV, WIP modules.

Environment: Oracle report builder, Oracle Forms builder, Toad