PROFESSIONAL SUMMARY

Applicant has 6+ years of experience in IT industry with Data Warehousing, SAP Business Objects Suite : Web Intelligence, Business Objects Designer, Crystal Reports 2008, Info View, QWAAS, LiveOffice and Xcelsius, along with the experience in development of SAP BW Backend Components and in ECC Extraction.

• Involved in Installing Business Objects, Creating Repository, Creating Users and User Groups using CMC.
• Expert in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Expertise in designing and building the Universes, Linking/Including the Universes and assigned privileges to the users.
• Sound knowledge of Crystal Reports and Xcelsius.
• Expertise in working with other tools of Business Objects like Designer, Web Intelligence, Info view, Qwaas, Live Office and CMC.
• Has good working knowledge of Database/Data Warehouse Concepts like Oracle, DB2, and SQL Server.
• Expertise in Designing Universes on different relational databases such as Oracle, SQL Server, DB2.
• Experience in building efficient and user oriented universes using Designer and creating reports using WebIntelligence and WebIntelligence Rich Client.
• Good work experience in migration of BusinessObjects from XI R3.1 to 4.0
• Implemented Live Office, created performance Dashboards (Xcelsius and Dashboard manager) across multiple domains in XI R3.1.
• Experience 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 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.
• Objects transports from Development system to Quality and Production Systems.

TECHNICAL SKILLS

ERP Packages:SAP ECC 6.0

SAP Products:SAP BI 7, BW BEx Reporting, SAP BO 3.1(Info view, Webi, UDT, Crystal Reports, XCelsius, QWAAS, Live Office), SAP BO 4.0(IDT, Launch Pad, CR for Enterprise, Dashborad Design), SAP BO (With SAP and Non SAP as Backend), SAP BODS (with SAP BW and Non SAP)

Languages:C, ABAP/4

Databases:MS SQL Server, DB2, Oracle

Operating Systems:Windows 2000/XP, IBM-MVS.

MAINFRAME Related:JCL, VSAM, COBOL, File Aid, SPUFI, QMF, CICS.

Testing Tools :Quick Test Professional (QTP), Quality Center (QC), Clear Quest.

Technical Specialization

• SAP BI 7
• SAP BO XI 3.1, 4.0
• ABAP in BW
• SAP BODS (with BW)

PROFESSIONAL EXPERIENCE

Client : Confidential Jan 2012 – Aug 2012
Role : Business Objects Developer
Project : Claim IT HIPAA 5010 Data reporting

Brief Description:
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.

Responsibilities as a Business Objects Developer:

• Analyzed the Functional Design requirements and converting them to technical requirements.
• Preparation of Detail Design Specification documents for Universe and Report Development.
• Assisted the Data Services team in the design of database summary tables and preparing the detail design document on ETL Process to load these tables.
• Involved in data warehousing to achieve optimum user requirements and created structure of different universes with IBM DB2 as backend.
• Created Universes in such a way, that would enable to create Ad-hoc reports and analyze them in different angles using techniques like slice and dice, drill down.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in the universes.
• Designed and linked the universes for query reporting and analysis .
• Defined Custom Hierarchies at Universe level to implement drill down functionality in the reports.
• Resolved loops in existing universes using Aliases and defining Contexts.
• Implemented Aggregate aware function and set up aggregate navigation with objects derived from standalone tables within the universes.
• Import and export business object’s reports and universes to repository.
• Developed the reports like 820 Controls and Balances report, 834-Enrollment and cancellations by the member etc with multiple data providers in Business Objects.
• Created reports using WebI and Dashboard design embracing best features available.
• Migrated the Webi reports from 3.0 universe to 4.0 universe.
• Implemented ROW Level security at the region level to manage the sensitivity of the data.
• Involved in Performance tuning of report execution in business objects.
• Implemented the Alerts to alert the manager as per the limit set on the #HIPPA Claims rejected at the region level.
• Maintain Repository with updated Universes, Documentation and appropriate privileges to user groups.
• Used Crystal Xcelsius 2008 as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into visuals such as Pie-Charts, Bar Graphs, Scorecards that can be shared via PowerPoint and PDF files.
• Prepared System Test Scripts based on extensive System Testing.

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

Client : Confidential Mar 2011 – Dec 2011
Role : SAP BO Developer
Project : Confidential Specialty – Claim Processing (Life and Disability) project

Project Description:
In Confidential environment, 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.

Responsibilities:

• Requirement collection from the business users and analyze the requirements
• Design different info providers depending on the field requirements in the reports.
• Extracted the data from MS SQL server tables to SAP BW as a target using SAP BODS with Plat form and Data Integrator Transforms.
• Created transformation between the source and the target objects.
• Created DTP and loaded the data from PSA to InfoProviders in BW.
• Developed the BEx queries in BW and made them available for Webi Reporting and Universe build.
• Alias, Context techniques are been used in resolving LOOPS at the universe level.
• Replace the existing reports with the BO Webi Reports.
• Assigned the COLUMN level security to the user groups
• Designed and linked the universes for query reporting and analysis using designer module.
• Used drill-down analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.
• Generating the Crystal reports on the top of Universe and sap Bw/Bex.

Environment: BO 3.0, BI 7.0, BEx, MS SQL Server, SAP BODS

Client: Confidential Nov 2006 – Mar 2011
Role: SAP BI BO Developer
Project : Pricing Data Warehouse

Project description:
Confidential is the leading provider of products, services and technologies supporting the health care industry. Headquartered in Dublin, Ohio, Confidential. (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, Confidential 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.

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.
• Migrate the 3.x content data sources to the BI7.0 data sources
• 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.
• 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

Environment: SAP BI 7, SAP CRM 4.0, SAP BO 3.1.

Client: Confidential Nov 2006 – Mar 2011
Role: SAP BI BO Developer
Project: CIMA- Convertors Inventory Management

Management System 
CIMA- Convertors Inventory Management Assistant is a customized version of PRMS(ERP Package) to meet cardinal’s business requirements. Confidential-El Paso primarily focuses on the production and replenishment of health care products.
This project involves in creating a dashboard, Webi Reports for Inventory management, using Live office connections on SAP BW.

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 Webi Reports with SAP BW as backend.
• Created OLAP universe on Bex queries and loaded the data to the webi reports through semantic layer.
• Created Dashboards on universe and webi using Qwaas and Live Office connections.

Environment: SAP BI 7, SAP ECC – Purchasing, Inventory, Invoice, QM, SAP BO 3.1.

Client: Confidential , Columbus, OH Jun 2006 – Nov 2006
Role: BO Developer
Project Name: Billing Advantage

Project description:
Confidential is one of the largest insurance and financial services companies in the world.
It is a well-diversified insurance company which offers insurance in Auto, Home, health and many other services. 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.
In order in incorporate its growing business and standardize a single reporting system, Confidential implemented Business Objects as its main Reporting system.

Roles and Responsibilities:

• 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.
• BW Queries, BW cubes and R/3 data were used as the main data sources. Extensive knowledge of Info-cubes, Info-Areas, Info-Objects, Key Figures, Characteristics and Hierarchies.
• Created Xcelsius dashboards using QAAWS and Live office connection.
• Involved in the process of development, testing, UAT and finally production.
• Create and manage new users, control access levels, assign and maintain report level and user level security in CMC.

Environment: Oracle 10g, SAP BO XI R2/R3.1, Crystal Reports, Xcelsius, DB2, SAP BW, Import Wizard, CMC.

Training:

• Business Objects Data Service