SUMMARY:

• Holds 13+ years of experience in the area of SAP Technologies: BW 7.0, 7.3; BOBJ 4.0, 4.2; BPC 10.0, BW/HANA and HANA Studio. Can build and maintain successful client relationships with communication, innovation, creativeness and dedication to provide simple and efficient services and solutions. Good at researching and learning new technologies and knowledge sharing.
• Strong knowledge in SDLC and good experience in Analysis, Design, Test Plan, Unit Testing, Integration Testing, Performance Testing, Regression Testing, and User Acceptance Testing.
• BW Modeling - Extensive experience in data modeling using BW extended star schema and entity relationship model. Worked actively in building enterprise data warehousing strategies and techniques. ETL build mechanisms, ABAP routines at ECC extractor level and also at BW object level.
• Customizations - Extensively worked on activating standard Business Content, enhancing the SAP delivered structures and building Generic data sources according to the business requirement.
• BEX Reporting - Expertise in front-end Business Warehouse components (BEX Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• BO Reporting - Expertise in Relational and OLAP Universe designing, well versed with Business Objects 4.0, 4.2, Universe Designer, IDT, Web Intelligence and Dashboard reports.
• BO CMC - Strong Experience in Administration activities like creating and managing services, monitoring/granting permissions and rights to users, user groups and Promotion management to deploy the changes between the landscapes through Central Management Server.
• BO Upgrade - Worked on multiple BOBJ upgrade (4.0 to 4.2) project responsibilities and delivered the project on time with very minimal defects in post go-live. Effectively coordinated with SAP and closed the issues on time.
• BPC - Worked on creating Dimensions and its members. Activating the models. Execute plan reports and reconciling. Script logic, EPM Data Manager Packages build up, Lite Optimization, Audit reporting on BPC user level and environment level. Build solution to Integrate Actual COPA data with forecast data in BPC. Capable to handle any scenario in BPC development and support perspective.
• HANA Design Studio - Expertise in creating Information views (Analytical, Attribute and Calculation views). Good knowledge on Lumira designer desktop to turn data into graphical representation.
• Good knowledge on Analysis office integrated with MS Excel fetching data from SAP BW or different sources and perform data operations and publish reports to BO web users or mobile applications.
• S4 HANA - Worked on S4 HANA go-live with roles and responsibilities from BW end. Working with Business closely on UAT and signoff on the S4 functionality changes.
• Worked on projects related to different ERP modules like SD, MM, SCM, FI, COPA, VISTEX, BPC modules. Experienced in each and every phase of BW project implementation (KPI, user requirements analysis, test plans, data modeling, Standard objects activation, ETL Development, ABAP routines, reports design and implementation, initial load from source systems, periodic update process chains, data migration from legacy systems, end-user training and support).
• Performance Tuning: Performed tuning measures of BW BEx Queries by limiting the number of rows and maintaining filters to restrict larger data set, Aggregates on Infocubes, Mounting Infocubes on BW Accelerator, and refreshing usage statistics for the same.
• BODS - Used BODS to extract data from SAP ECC and third party database to load the staging layer. Expertise in BODS code migration using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs Manage repositories and perform metadata reporting.
• Experience working with Open Hub Services to push data out of SAP BI using Data Services.

  Configured the Data services to connect to the SAP R/3, BI and Relational db layer.

• Developed Test Scripts, Test Cases and SQL QA scripts to perform Unit testing.
• Good team player with excellent communication and knowledge sharing to team members in guiding them to develop new objects and helping in troubleshooting the issues. Making team to understand the client requirements and deliver the assignments on time and with quality.

TECHNICAL SKILLS:

• SAP BW/BI 7.0 7.3; SAP BOBJ 4.0
• 4.2; SAP BPC 10.0
• SAP BW HANA
• SAP R/3 ECC6
• SOH
• S4 HANA; HANA SQL script

PROFESSIONAL EXPERIENCE:

Confidential, CA

Responsibilities:

• Involved in Altera Integration Project. Developed various BOBJ reports in Webi.
• Involved in creation of Data Model as per the biz requirement.
• Created HANA Information views (Attributes and Calcuation views) based on multiple tables in the backend and created BOBJ Webi reports on top of them.
• Linked CHM Distributor master data with EDW transaction data using information views in HANA.
• Extensively worked on BOBJ IDT creating Universes on HANA views and relational database EDW. Created Alias tables, Joins, Derived tables as per the project needs.
• Created TS/FS/Test Cases templates. Preparation of the Test Plans and maintaining the Test directory. Used SAPDAT transport mechanism that is integrated with BOBJ CMC to deploy changes across landscapes.

Confidential, Plano, TX

Responsibilities:

• Strong knowledge in SDLC and good experience in Analysis, Design, Test Plan, Unit Testing, Integration Testing, Performance Testing, Regression Testing, and User Acceptance Testing.
• Accomplished professional with expertise in RICEFW development and worked in the areas of Implementation, Integration and Upgrade projects.
• Creation of Interactive graphical Dashboard on HANA views using Design Studio. Created information views in HANA design studio to integrate third party data with SAP ECC and then used this data for MSTR reporting on top of these views.
• Worked on Sales, Delivery and Billing data in SAP ECC from the underlying logistic tables combining fields from different tables in design studio to show the live data for reporting.
• Created BO Dashboard using components like Scorecard, InfoCharts etc to provide customer analytic information for the sales team at high level for better planning and forecast.
• Worked on Bai Integration project from BW end as it was acquired by the company.
• Worked on the various end to end SAP projects such as VISTEX, FIGL, HR, COPA and SCM area. Interaction with cross-functional teams to better understand the Business requirements.
• Worked on VISTEX project to create and enable new data flow objects in BW to develop the smooth business transactions with its customers who are in agreement related to Promotions and chargebacks using Billback module.
• Worked on Spend Analytics project to develop a single data repository for Spend data that will enable DPS to understand and leverage spend on various spend classifications.
• Created custom extractor for GL data set as part of this Spend Analytics Project to extract data depending upon the additional field’s requirement those are not part of the standard extractor.
• Worked on BW HR Project to enable the business reporting on SAP BW replacing the third party reporting strategies like Kronos, etc…
• Experience in setting up UC4 jobs for BW and its dependencies from source system for a smooth data update avoiding any data lags btw ECC and BW systems.
• Worked on Business Objects 4.0 reporting techniques, Universe building on SAP and non-SAP systems using IDT, Performance tuning, Experience in creating Webi and Dashboard reports.
• Handled the BPC application Business requirement gathering to build Dimensions, script logic, Transformation files, Generate background jobs and upload data to Planning cube.
• Worked on creating Jump reports (RRI) to enable the detailed/lower level reporting in BW BEx.
• Experience in enhancing the standard LIS Extractors with new fields based on the Business requirement for reporting. Maintained Line-item dimensions which optimizes reporting performance.
• Experience in creating Generic extractors based on View and Function module to pull the additional fields data for Sales Orders transaction data, Master data texts, relevant data from R/3.
• Extensively worked on Inventory data management in BW.
• Worked with SAP HANA Specific catalogue objects - schema, Database tables (Column Based, Row Based), Column views, Views, Sequences, db trigger.

Confidential

Responsibilities:

• Involved in extracting from APO like Demanding Planning, Detail Scheduling to extract data into SAP BW.
• Worked on CPS S&OP Redesign project to redirect the data extracting from different source in an efficient way. Involved in fixing the performance problems with this design.
• Worked on POSDM new Architecture project to meet the future Business requirements based on Freestyle Business that spread over countries.
• Developing components for the Middle Tier using COM implementing various business rules
• Worked on extracting Vertex tax data to BW which was the tool for TAX application consulting. Participation in high level meetings with Business teams for BRR and the project plans.
• Experience in building and extracting COPA data from ECC to BW for planning the Marketing, CPS Business requirements.
• Worked on performance tuning of BOBJ reports, using Aggregates awareness, Conditions, Variables, Context, Loops, aliases, etc.. at Universe level.
• Explicitly worked on SAP CPS (Redwood) implementation project for job scheduling requirements. Installing Platform Agents and integration with other no SAP Servers.
• Experience in Archiving based on Business requirements in BW space for Obsolete/Sunset Application/History data and moved the same to file server.
• Review of BW Early Watch Reports to explore performance improvement areas in BW system as well as from BASIS and DBA standpoint.
• Performed Master data and Transaction data extractions (SAP, Non-SAP) and automated the data loads using Process Chains.
• Created Web templates, Performed customization of web templates, Web reporting, web items and web templates using Web Application Designer (WAD) and query designer.

Confidential

Responsibilities:

• Involved in the development of POS components for Freestyle Business.
• Involved in writing Start Routine for transformations and End Routine in Transformations.
• Involved in development project for HR to maintain the partition levels for better reporting performance and avoiding any chance for corrupting the Infocube in future.
• Involved in development project with CPS to know the daily sales performed based on the number of kits used for a material based on Plant and Distribution channel etc..
• Part of BW team with a team of 8 members managing the Business requirements in Production box. Commitments and confirmations to Business on the SLA’s. Provided solutions to the ongoing recurring day to day issues and recommendations for application support team.
• Also involved in writing Start routines, End routines and field level routines in building the Transformations to different source objects. Created Multi providers and info sets.
• Gathered data by consulting with the functional specs and decided to implement custom made InfoCubes as per the biz requirement.
• Personalized transfer structures, communication structures and update rules based on the requirements and scheduled the Info-packages for data loads.
• Enabled the standard FI TX BI content datasource based on the requirement and availability and added few extra fields that are required for TAX reporting.
• Created Jump reports (RRI) to enable the detailed/lower level reporting.
• Involved in creating Customer exits for the reports.
• Involved in pulling the data from Non-SAP system to SAP via BODS modeling.
• Good exposure on Process chains, like creating and modifying process chains, adding Info packages to Process chains.
• Analyzed the BW database size growth and scheduled the PSA and Change Log data deletions.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.

Confidential

Responsibilities:

• Design of layouts, Coding with coding standards, peer review of objects Testing - Unit testing & Integration testing, and preparation of Test Plans.
• Analysis of the specifications provided by the clients and Design & Development of Objects.
• Defect management and daily status calls during testing. Incident tracking and resolution based upon priority. Analysis of Data Flow diagrams for all critical applications.
• Regular Data loads to BW and its maintenance. Developed reports with better reporting performance.
• Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.
• Developed some of the most complex business rules by means of update rules/start routines.
• Designed front-end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
• Review of partitions on Infocubes, adding/merging partitions to improve query performance.
• Fixing of the recurring issues from BW/BO perspective.
• Enhancement of various Reports depending on Business requirements.
• Development of reports to meet the new functional requirements of the Business.
• Introduction of new methods and education of team members on functionalities.

Confidential

Responsibilities:

• Detailed technical & design document preparation, test case preparations, code enhancements and testing.
• Created TS/FS/Test Cases templates, migrated objects from development to quality and from quality to production.
• Created workbooks over the Queries and maintained via Process chains.
• Monitored daily BW uploads and LO Cockpit Jobs, re-peat scheduled the Cockpit jobs when daily uploads were delayed, resolved several issues during uploads.
• Daily Data load Monitoring of the BW jobs. Ensured daily data load from R/3 to BW is successful.
• Design and Development, Regression Testing & Integration Testing
• Preparation of the Test Plans and maintaining the Test directory.
• Working on ALE/RFC/iDoc settings and configuration.
• Maintaining Quality standards and Procedures in the project.
• Good knowledge in Functional flow of SD and MM.