BACKGROUND

5+ years of experience in IT industry as a SAP Consultant including 3 years Experience in SAP BW and 2 years experience in SAP Business Objects Reporting Applications.

• Undergone complete life cycle Implementation of BW, which includes data modeling, design, support etc for BW BO projects.
• Expertise in Back-end BW Components like Extractors, Info Objects, Info Sources, Update rules, Transfer rules, Info Cubes, Info Packages, DTP Loads etc and front-end Business Warehouse Components Queries, Calculated key figures, restricted key figures, Structures, Variables etc in Bex Analyzer along with monitoring the data loads and troubleshooting the failed data loads.
• Worked extensively with SAP BW components like LO Extraction, Generic Extraction and Data Source Enhancements.
• Experience in Automation of master data and transactional data loads using Process Chains, Managing and maintaining non-R/3 Master Data, Daily extracts and cube builds, Performance tuning on query level, back end level and on Data target level.
• Expertise in designing and building the Universes and assigned privileges to the users.
• Sound knowledge of Dashboard Manager and Crystal Xcelsius. Created complex dashboard using Crystal XCelsius.
• Expertise in working with other modules of Business Objects like Designer, Web Intelligence, Info view, Qwaas, Live Office and CMC.
• Working knowledge of SAP modules HR, SD, MM, CRM.
• Has good working knowledge of Database/Data Warehouse Concepts like Oracle, DB2, and SQL Server.
• certified in the Health Insurance Domain and QA Testing methodologies.

Technical Skills

ERP Packages:

SAP ECC 7.0

SAP Products:

SAP BW 3.5, 7.1, SAP BO 3.1, 4.0(Webi, Universe Design, Crystal Reports, Xcelcius, Dashboard), SAP BODS (Basics)

Languages:

C, C++, ABAP

Databases:

MS SQL Server, DB2, Oracle

Operating Systems:

Windows 2000/XP, IBM-MVS.

MAINFRAME Related:

JCL, VSAM, COBOL, File Aid, SPUFI, QMF, CICS.

Tools and Utilities :

Quick Test Professional (QTP), Quality Center (QC), Test Director, Clear Quest, Visual Studio.

Experience
Customer : Confidential,Feb 2012 – Aug 2012
Project: Claim IT HIPAA 5010 Data reporting
Organization: Confidential,

Confidential,is one of America’s leading health care and related benefit organizations with more than 21 million members and one of the nation’s leading managed care companies with more than 1 million managed care members, providing a full spectrum of products and services including health care, dental, vision, pharmacy, group life, disability and long term care coverage.
The objective of the reporting is to analyze the volume of data handled using 5010 format and turnaround time of the claim processing. The different sources of this data were OLAP data from SAP BW, DB2 databases.

Roles and Responsibility as Business Objects Developer:

• Analyze the data model/data mart to design the universe.
• Involved in data warehousing to achieve optimum user requirements and created structure of different universes.
• Resolved the loops and tested the designed universe in Business Objects designer.
• Used drill-down analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.
• Developed the Revenue (Premiums), Expense (Claim Payments) and Profitability reports with multiple data providers in Business Objects.
• Extensively worked with formatting the reports according to the user requirements.
• Created reports using WebI and Dashboard design embracing best features available.
• Implemented ROW Level security at the region level to manage the sensitivity of the data.
• Developed the multidimensional reports in Business Objects by translating the business validations. Involved in Performance tuning of report execution in business objects.
• Designed and linked the universes for query reporting and analysis using designer module. Import and export business object’s reports and universes to repository.
• Implemented the Alerts to alert the manager as per the limit set on the claim processing time for each of the claim engines.
• Displaying and publishing the data with charts on the web.
• Editing list of values and make a different kinds of prompts as user requirements.
• Making different types of formulas and user define functions and formatting reports.
• Maintain Repository with updated Universes, Documentation and appropriate privileges to user groups.

Environment: IBM DB2, SAP BW 7.0 and SAP BO 4.0

Customer : Confidential,Nov 2010 – Dec 2011
Organization: Cognizant Technology Services

Project Description:
Confidential,there are multiple applications handling the claim processing and new policy enrollments depending on the variety of the products offered in the industry. The objective of this long term project is to extract and enable the analysis of the summary level information from each of these different claim engines and Enrollment applications.

Roles and Responsibility:

• Requirement collection from the business users and analyze the requirements
• Design BI architecture that includes the Levels in the data flow and the staging in the BI system.
• Design different info providers depending on the field requirements in the reports.
• Created transformation between the source and the target objects.
• Design the separate process chain for the Batch, online and interface data flows
• Create jobs for the each process chain and submit to the External scheduling system which triggers the jobs on the daily basis.
• Developed the BEx queries in BW and made them available for Webi Reporting and Universe build.
• Context techniques are been used in BW to avoid LOOPS at the universe level in BO environment.
• Replace the existing reports with the BO Webi Reports.
• Migrate the 3.x content data sources to the BI7.0 data sources
• Replace the 2LIS_03_S196 and 2LIS_03_S198 with 2LIS_03_BF data source.
• Designed COLUMN level Security in the BO environment on the DOB and SALARY columns.
• Assigned the COLUMN level security to the user groups
• Resolved the loops and tested the designed universe in Business Objects designer.
• Designed and linked the universes for query reporting and analysis using designer module. Import and export business object’s reports and universes to repository.
• Used drill-down and slice and dice analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.
• Environment : BO 3.0, BI 7.0, ECC 6.0, Bex Query Designer

Customer: Confidential,Jun 2007 – Oct 2010
Project : Pricing Data Warehouse
Organization: Confidential,
Role : BW Developer
Project description:
Confidential,is the leading provider of products, services and technologies supporting the health care industry. Headquartered in Dublin, Ohio, Cardinal Health, Inc. (NYSE: CAH) is a $103 billion, global company serving the health-care industry with a broad portfolio of products and services. Through its diverse offering, Cardinal Health delivers integrated health-care solutions that help customers reduce their costs, improve efficiency and deliver better care to patients. The company manufactures packages and distributes pharmaceuticals and medical supplies, offers a range of clinical services and develops automation products that improve the management and delivery of supplies and medication for hospitals, physician offices and pharmacies. It is an essential link in the healthcare supply chain, providing pharmaceuticals and medical products to more than 60,000 locations each day.
It basically extracts from production data bases and does processing based upon the requirement and loads into three Data Warehouses. The final tables are associated with the Business Objects. Business Users use these objects to generate reports. They use the data generated from Pricing Data Warehouse application while dealing with the customers and third party suppliers.

Environment: SAP BW 7.1, SAP CRM 4.0.

Responsibilities:

• Analyzed and Mapped Business Processes to BW, preparation of Project documentation and Business Blue Prints using ASAP methodology.
• Involved in understanding Business requirements and defining Project Planning, Project task and delivery; performed detail data analysis of both data elements requested by the business and data source (CRM and SAP R/3), and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart; translated business requirements into multidimensional data model.
• Worked on standard business content CRM Cubes like 0CSAL_C01-CRM Activities, 0CRM_C04-CRM Opportunities, 0CSAL_C06 - CRM Quotations for Sales Contracts and 0CSAL_C04 - CRM Sales Contracts.
• Modified standard business content and created custom Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW.
• Enhanced existing Master and Transactional Data sources according to the requirements and wrote ABAP routines in Transfer rules, Update rules and Start routines.
• Worked on BEx Analyzer and generated management reports matching user requirements. Used number of variables, calculated Key figures and restricted Key figures wherever required in queries for the reports.
• Improved data load and query performance by doing compression, aggregates, partitioning and Number range

Resource Management System
Confidential,helps to keep track of the materials getting shipped from the ware houses.
Environment: SAP BW 3.5 & 7.1, SAP R/3, SD, MM.

Responsibilities:

• Extracting Transaction data from SAP R/3 using database views and Functional Module.
• Created the Generic Extract Structure for Transactional data using Views and Function modules as per the extraction requirements.
• Modified Update rules, transfer rules, update routines, and transfer routines as per client requirements in Info Source, ODS and Info cube levels.
• Schedule data loads into BW from R/3 involving initial data loads delta data loads. Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.
• Worked on BEx Analyzer and generated management reports matching user requirements. Used number of variables, calculated Key figures and restricted Key figures wherever required in queries for the following reports.
• Involved in Performance tuning of queries by maintaining Aggregates, compression, partitioning and indexing of Info cubes.
• Created Drill down (RRI) through Queries from summarized Info Cube to detail ODS object.
• Involved in the analysis and development of SAP BW applications, modeling the data and defining the Data Sources.
• User Training- created documents for user training, providing post-production support.

Customer: Confidential, Jan 2007 – May 2007
Project Name: Billing Advantage
Organization: Confidential,

Project description:
Confidential, is one of the largest insurance and financial services companies in the world. This project involves in design and development of a Life Insurance Data mart in Enterprise web reporting system. This Insta-Reporting comprises essential key performance Indicators and reports of life Insurance business. This system covers various subject areas of life insurance such as Policy, Claims, Premium, Loss Ratio, and Growth rate. This provides end-to-end Analysis. The Data mart was developed and star schema was designed to handle the various reports. The Reporting is being developed using Business objects.

Roles and Responsibilities as BO Developer:

• Understanding the Requirement specification documents from both technical and business perspectives,
• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports.
• Designed and implemented Data Models to meet existing and future anticipated reporting requirements. Also involved in modifying the existing data model as per requirement.
• Designed Universes using BO designer by retrieving data from database, exported them to specific universe domains.
• Implemented various types of joins including equijoin, outer-join, theta-join, self-restricting join, defined cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes
• Extensively worked with Web Intelligence and Info View to create thin client reports based on the business requirements.
• Designed and Developed Web I Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Drill Down, @Functions and Formulae to analyze the data.
• Analyzed, designed, built and tested reports while working directly with end-users and technical members of the team.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.

Environment: IBM DB2, SAP BW 7.0 and SAP BO 4.0

Customer: Confidential,) June 2006 – Dec 2006
Project Name: Funds Transfer System-Convergence system- Testing
Organization: Confidential,
Role – BW Developer

Project description:
Confidential,Transfer System through which money can be transferred from one account to another account. MATS transfer system is converged with the existing FTS System for business advantage. Modifications are made throughout the FTS system and existing Interfaces to handle the Transactions received for hMEL Customers. MATS continue to receive all transactions as they currently do and will send all transactions to FTS for further processing.FTS will notify MATS of Transaction status and MATS will continue to advice their customers. The scope of testing is System testing (Pre Convergence), SIN Testing (Post Convergence), UAT Support.

The project aimed at consolidating the data of the applications handling primarily the Human capital management. This is a full cycle implementation involving the Extracting, Transforming and loading the data using BW. Reports are developed using BEX and BO 3.1 (WebI & Xcelcius)

Roles and Responsibilities:

• Understand and analyze the HR Functional Requirements from the stakeholders meeting.
• Prepare the Technical & Functional documents for the Personal Administration and Organizational Management Reporting data flows.
• Design the architecture of the BI system which includes the Levels in BW data flow and WEBi Reporting in BO environment.
• Review and finalize the naming conventions for the development objects and reports.
• Designed COLUMN level Security in the BO environment on the DOB and SALARY columns.
• Created the User Groups for Personal Administration and Organizational Management.
• Assigned the COLUMN level security to the PA and OM user groups
• Created the alerts on the appraisal column to alert the manager if the employee has below BE (Below Expectation) appraisal consistently for two times.
• Created the Validation on the Report user whether the user belongs to HR or Non HR user group.
• Used INCLUDE Universe concept in BW to use EMPLOYEE master data for the all employee validations.
• Implemented SLOWLY Changing dimensions concepts in BW based on the time dependency.
• Enhance the data source 0HR_PA_1 for the Post and Nopost data.
• Create the data source for the Post, Nopost and Position attributes
• Partition the info providers physically one for each other.
• Developed the WEBi reports for External Entrants, Exits and Actions for Personal Administration data.
• Developed the WEBi report for Position Headcount for Occupied, Unoccupied and Vacant positions.
• Create process chains for the data loads and schedule them periodically

Environment: BO 3.1, BI 7.0 and ECC6.0

Experience

Confidential,Feb 2012 – Aug 2012
Confidential,Oct 2010 – Nov 2011
Confidential, June2006 – Oct 2010

Education

Course: Bachelor of Technology (82%)
Major: Mechanical Engineering

EXPERIENCE
SNAPSHOT

Technical
Specialization

• SAP BI
• SAP BO
• SAP BODS(Basics)

Training

• Business Objects Data Services
• HP Quick Test Professional (QTP)
• HP Quality Center (QC)
• Mainframes (COBOL, CICS, DB2, VSAM, JCL)

Database Concepts