Professional Summary

9 years of experience in SAP with primary focus in BI/BW and SAP BOBJ. Well versed with migration projects as well as proficient in SAP BI/BW and BOBJ Implementation and Production Go-Live and Support.

• Experience in new features of SAP NetWeaver 2004s.
• Extensively Worked on Management Cockpit SAP ECC SD MM Finance and SEM-GTS, WM, TM.
• Experience in all phases of BW applications using ASAP methodology
• Experience in ETL process, Transformation Rules and DataTranfer Process (DTP).
• Migrated from 3.X to SAP NW 2004s. (BI 7.0)
• Involved in the data extraction of LO-Cockpit.
• Extracted data for LIS, Generic (View, Info set Query) extractors.
• Proficiency in Performance Tuning using Aggregates, Rollups, Compression, Partitioning and indexes.
• Involved in Clustering (Reclustering), Partitioning (Repartitioning) of Infocube.
• Involved in Production Support and Issue Resolution. Involved in debugging of process chain, monitoring and schedule data loads.
• Experience in OpenHub and Infospokes.
• Experience in writing and routines in Transfer rules and Update rules to cleanse, transform and load the data to the data targets.
• Experience in Design and Development of Queries, Reports and Workbooks using Calculated Key figures. Experience in Design and Development of Queries using restricted key figures.
• BW reporting using BEx Analyzer, Web Analyzer. Designed applications using Web Application Designer.
• Experience in VB Scripts
• Expertise in all modules of BOBJ suite (BO Reporter, Designer, Web I, and InfoView).
• Installation and Configuration of BusinessObjects XI along with performance manager.
• Administrating BusinessObjects and Crystal Enterprise.
• Planning the implementation of migration to BusinessObjects XI.
• Designing security model for users to access the report.
• Deployed clustered environment (BO XIR2, XI 3.1) for multiple clients.
• Administration of user rights for various BO application for XI R2 and XI 3.

Education

• Bachelor's Degree (B.E) in Computer Science Engineering

Technical Skills

SAP BI : SAP BW 3.1c, BW 3.5, BI 7.0,BI 7.1 , SAP BO XI 3.1
Trainings : SAP SEM-BPS
ERP : SAP R/3 4.7, EP 7.0 and CRM 5.0
Databases : Oracle 8.x, DB2
Platforms : IBM AIX, HP UNIX, Sun Solaris, Win NT - 2K

SAP-ABAP/4 Skills:

ABAP/4 WORKBENCH - Object Browser, ABAP/4 Editor, Function Module.
DATA DICTIONARY - Tables, Structures, Data Elements, Domain.

Confidential,Santa Ana CA June/08 Till Date
SAP BI & BO Consultant
Environnent: SAP BI 7.1, SAP BO XI 3.1, SAP SD, MM & FI

Ingram Micro Inc. is the world's largest technology distributor and a leading technology sales, marketing and logistics company. As a vital link in the technology value chain, Ingram Micro creates sales and profitability opportunities for vendors and resellers through unique marketing programs, outsourced logistics services, technical support, financial services and product aggregation and distribution.
Responsibilities:

• Involved in different phases of the project including Project preparation, Blueprint phase and Realization.
• Installation of BOE XI 3.1 on AIX 6.1.
• Creating groups and users in BOE XI 3.1.
• Creation of super bex query.
• Creation of universes
• Creation of webi reports
• Using 360 view designed security .
• Maintaining security profiles for users.
• Installing & configuring Xcelsius.
• Installing & configuring Live Office.
• Installing & configuring Crystal Report 2008.
• Solving reporting and administration related issues
• Installed and Configured Business Objects XIR3.1 complete suit on Windows..
• Configured Clustered for Test and Production Servers.
• Integrated Business Objects with SAP BW/BI with Portal Integration kit to publish the reports onto the Enterprise using BW/R3 portal.
• Designed User security for all the Application in Ingram and defined Super Users, Power Users, View Users and Developers applied.
• Configured Java Info view Single Sign on (SSO).
• Maintained Users and Groups Security by creating AD groups and attaching it the folders on the Enterprise.
• Tested and implemented SMTP email and FTP scheduling feature in Business Objects
• Responsible to make sure Email, FTP, Business Objects Inbox and Unmanaged Disk options of scheduling are always up and running.
• Performed Performance tuning for all the servers in CMC.
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as data source.
• Migrated Universes and reports from 6.5 Windows to XIR3.1 using Import Wizard tool
• Maintain the repositories for different environments like DEV, QA and PROD
• Regularly synchronized the QA, DEV environments with Production reports.
• Served as a Focal point with Vendors, database administrators, server team in maintaining the web servers.
• Identified the business requirements with the help of existing documents and business needs.
• Identified the end user requirements (BEx Reports, Workbooks) and security requirements.
• Interacted with management and end-users to gather the requirements and conducted GAP analysis.
• Created many Proof of Concepts to help understand the requirement with the Business and also to analyze the performance issues in the design
• Configured SAP BI Data Staging layer for different scenarios.
• Extracted data for various data sources for SAP SD, MM and FI and SCM-WM, SCM-GTS, SCM-TM data from ECC GTS and TM to BI.
• Created Functional Specifications which drive Technical Specifications, Development, Data Mapping and Testing
• Identified list of pre delivered business content to be activated by functional components, data sources, info cubes, objects, queries, workbook and roles in SAP SD MM FI AND SCE.
• Designed, developed and configured BI objects for SAP SD MM AND FI SCM (WM,GTS & TM) as per the business requirements
• Configured data loading strategies for master data, transactional data and delta uploads.
• Configured and created DSO objects to stage the data from different data sources and transferred the DSO contents into various data targets and Info Cubes based on the requirement.
• Created WebI, XCelsius, and Voyager reports for al process area.
• Worked extensively on the new features of Netweaver BI 7.0 BEx Analyzer. Created queries using BI- Reporting variables (using Offset values) for ITD (Inception to date), YTD (Year to date) and MTD (Month to date)
• Responsible to support the issues with reports on the crystal enterprise environments ( Development, UAT, Test and Production )
• Involved in 24x7 supports and worked extensively with Remedy Ticketing Tool.
• Experience in Install and configure Clear Case.
• Maintained Different Version of universes and Reports in Clear Case

Confidential, May/07 to June/08
SAP BI & BO Consultant
Environnent: SAP BI 7.1, SAP BO XI 3.1, SAP SD, MM & FI

Modules: BI 7.0, ECC 6.0, HCM, FI-CO, MM, Business Objects, Xcelsius, WebI, Crystal Reports.

NYPA embarked on building an Enterprise Data Warehouse as a single point of repository for the company wide reporting needs. NYPA engaged the Sage Group to build a roadmap and a detailed design to implement the EDW solution.
As part of this effort a series of workshops and requirement gathering sessions were conducted with several business units for 6 weeks.

• Conducted workshops with business users towards requirements gathering to deliver a functional design document.
• Analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques, with an emphasis on actual implementation in BI.
• Created data objects for the reporting areas, which includes building all structures within BW that supports the reporting, such as Extractors, Generic Extractors, Data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info Package groups, Info Objects, ODS, Info Cubes, Queries, Variables, Calculated key figures, Info Set Queries, Workbooks, Analyzer, Browser, ITS, 3rd party reporting tools (Business Objects, Crystal), Roles, Transports, etc.
• Apart from creating an end to end blueprint document, involved in BI build specific to ECC HR (PA, OM, Time, Benefits) and IS-U CCS. Worked with both Business content and Non-SAP sources, enhanced content to adhere to business requirements.
• Validated the BI data extracts from the IS-U data sources related to Device Management, FI-CA, Billing and Invoicing to various data targets related to IS-U
• Worked on enhancing the standard extractors and built custom extractors to meet the ISU - CCS reporting requirements
• Enhanced the standard HR extractors and cubes for PA, OM, Time and Benefits as part of the reporting requirements.
• Validated the BI data extracts from the HR data sources related to OM, PA, PD, Time and Benefits, FI-CO, MM, Purchasing data sources to various data targets in BW.
• Worked with Basis Support on the installation of BOE 3.x and the integration to SAP BI 7.0
• Developed Dashboards using Xcelsius via WebI/Live office functionality - reflecting Financial/Transmission/Performance metrics of NYPA. Data used for the dashboard was both from SAP and non-SAP sources.
• Worked with Security team to upgrade the role and authorization objects of BI 7.0 roles for Web reporting.

Confidential,NC Sep/05 To April/07
SAP BI Consultant
Environment: SAP BI 7.0, SAP EP 7.0 and SAP CRM 5.0, Complaint Management System.

Lenovo is an innovative, international technology company formed as a result of the acquisition by the Lenovo Group of the IBM Personal Computing Division. Lenovo is a global company with executive offices in Raleigh, North Carolina, USA, Beijing, China, and Singapore. Its principal operations are in Beijing, China, and Raleigh, North Carolina, USA, with an enterprise sales organization worldwide. The company employs more than 19,000 people worldwide.

Responsibilities:

• Maintained Info packages.
• Involved in taking necessary actions in order to correct info packages by way of doing Manual Update, Reconstruction and Running info packages manually depending on the case.
• Involved in monitoring process chain and checking the logs.
• Maintaining customer posted tickets and system-generated tickets.
• Maintained documentation for each and every error.
• Maintained Reconciliation's to verify the data in SAP CRM and SAP BW are same or not after the data loads. Maintaining Work History for all the tickets until it is closed down.
• To communicate with the customer and operation desk who post the ticket.
• Involved in escalating high-prioritized tickets regarding extractions, performance issues and also loads failures.
• Involved in solving reporting issues.
• Involved in solving WAD reports.
• Involved in taking necessary actions in order to correct Variables as user requirement.
• Involved in taking necessary actions in order to correct calculated key figures and restricted key figures as user requirement.
• Involved in publishing new WAD reports to Enterprise portal
• Involved in assigning the roles to the user in category wise.
• Involved in solving the EP issues linked with BI Reports

Confidential,Raleigh NC Jan/03 to Aug/05
SAP BI Consultant
Environment: SAP 3.5, SAP BI 7.0, SAP EP 7.0 and SAP CRM 5.0, Complaint Management System
Lenovo is a global company with executive offices in Raleigh, North Carolina, USA, Beijing, China, and Singapore. Its principal operations are in Beijing, China, and Raleigh, North Carolina, USA, with an enterprise sales organization worldwide. The company employs more than 19,000 people worldwide.
Responsibilities:

Lenovo has implemented CRM modules for tracking the Sales Opportunities and Activities and BI 7.0 for their reporting.

• Onsite BI Consultant for the Lenovo implementation project
• Responsibilities include creation of both Opportunity reports and Activity reports
• Some of the critical Activity Reports included Calling Activity Summary and Calling Activity Detailing reports
• Activation of Standard Cubes like Opportunities (0CRM_C04), CRM lead Management (0MKTG_C01).
• Worked on enhancement for data source 0CRM_SALES_ACT_1(added zlentask).
• Activation of standard ODS like 0CRM_SALES_ACT_1 (Activities)
• Activation of Standard ODS like CRM Opportunity Item, header, Monitor and ODS for Activities.
• Worked on Enhancement for Data Source 0CRM_OPPT_I (Added the Six Z Fields like zquantity, zstatus, zprobability etc).
• Activation of standard ODS like 0CRM_lead_I and 0CRM_lead_h
• Created multiprovider for 0CRM_OPPT_H and 0CRM_OPPT_I
• Worked on Generic Data Source zcalendar, zlenweek, zprediction and zmatrix.
• Created Process chain for transaction data.
• Created process chain for Master data
• Activated standard reports like forward looking pipeline, FLP Extract reports, Bridge reports, Forecast reports, Activities reports and business partner reports.
• Created detail Custom reports using Opportunity item ODS.
• Created Summary Custom reports using Opportunities Cube.
• Created a four variable for detail reports
• Created Business partner reports
• Created WAD reports on standard reports, detail reports and Summary reports.

Confidential Jan/02 to Dec/02
SAP BW Consultant
Environment:SAP R3, SAP BW 3.5, SD, FI

TIC is one of the largest industrial contractors in North America with annual revenues in excess of $1.2 billion. In today's rapidly changing marketplace, it is important to understand the financial stability of the organizations involved in significant business transactions.

Responsibilities:

• Performed Knowledge transfer to the offshore team during the KT phase to understand APCI's business process and their BW landscape.
• Responsible for data extraction from R/3 source system using LO, COPA Data Extraction and Flat file to BW.
• Involved in Data Extraction using LO Cockpit (LBWE) and enhanced the extract structures using user exits to support the business needs.
• Involved in Development: Activated the standard Data Sources for Sales and Distribution data. The Data Sources activated are 2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_13_VDHDR and 2LIS_13_VDITM for Orders, Delivery and Billing Data.
• Customized and implemented standard Info Cubes for SD Customer, Deliveries, Purchase Order and Shipment overview.
• Created new Aggregates as needed and deleted the unused aggregates for the Purchasing data and Sales Order Info cube
• Customized data sources to add fields like Company code for selection to filter the data based on Company codes while loading the data into BW.
• Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters. Data extraction from Flat Files and non-SAP source systems using DB Connect.
• Worked extensively in Query Designer in building Queries and saving in Workbooks. Created Custom Queries using Conditions, Exceptions, Variables and Structures.