Summary

• Around 8 years in SAP BW, BI,Business Objects, R/3 and ECC 6.0 as lead with experience in deployment and developing business process and system solutions.
• Strong analytical, communication, interpersonal skills and able to adapt quickly to new technologies.
• Highly successful in managing multiple projects/tasks at same time.
• BI Modeling - InfoProviders design (DSO, InfoCubes, InfoObjects), Datasources, Transformations, DTP's, InfoSources, Creating Update rules, Transfer rules, Multi providers, InfoSets, Aggregates, Process Chains and Open Hub.
• Extensively worked on Business Objects tool 4.0 components Universe, WEBI, Crystal Reports and Dashboards.
• Good experience in development of SAP BO Universe Designer by using SAP BI- InfoProviders (Info Cubes, DSO objects, Info Sets and Multiproviders) and BEx Queries as Back-end Target Database.
• Good Technical skills with SAP BI-BO Integration.
• SAP Business Objects (SAP BOBJ)- Developed OLAP universes connecting to SAP BEx Queries, and created WebI reports .Scheduled the web intelligence reports. Linking BO reports on external portal.
• BI Extraction - Extensive experience in activating and customizing in LO Cockpit extraction (SD, MM (IM, Purchasing), PP, QM), Timestamp extractors FI AP, FI AR, FI GL, COPA, HR and also Custom Extractions from SAP systems.
• BI Reporting - BEx Analyzer, BEx Query Designer, Web Application Designer (WAD), Web analyzer, RKFs, CKFs, Variables, created custom queries using Conditions, Exceptions, Workbooks, Query views, Customer exits and RRI's.
• BW operations - Data load management, event processing, experience in automating data loads using Process Chains and batch jobs, monitoring the process chains, data loads (Full /Delta), Aggregates and BW Transports.
• Experience working on implementation projects using ASAP methodology.
• Extensive hands-on experience in project proposals and project preparation, blueprinting, designing, developing, testing, user training and supporting BI system
• Extensive experience in BW Administrator Workbench (Data Warehousing Workbench)
• Extensive experience with three System landscape (Development- Quality- Production)
• Experience to drive projects through full development cycle within project and budget parameters.
• Worked on all phases of project from blueprinting, configuration, development, integration testing. Solution delivery and result-oriented individual in analyzing project situations and implementing solutions.
• Designed logical data models based on functional requirements and load strategy specifications to capture source data, data consolidation mechanisms and integration scenarios for reporting.
• Generated Data Sources in APO, Created real-time reports out of remote cubes in APO-DP.
• BEx Reporting- Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, RRI, Visual Composer, Reporting Designer, BEx Analyzer and Ad-hoc Queries.
• WEB Reporting and Enterprise Portal: Expertise in creating web reports using custom web templates, integration with Enterprise Portal, Publishing I views, creating workbooks and Roles.
• Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.

Technical Skills

Operating Systems: MS-Windows XP Pro/NT/98/95, 2000 Server, HPux11v3, AIX, Linux.

Reporting/Designing Tools: Business Explorer, Web Application Designer, MS Visio, Business Objects, Crystal Reports 8.0/9.0/X/XI/XIr2/2008,Crystal Enterprise 9.0/ 10.0, Business Objects XI R2/ R3, Business Objects Universe Designer.

ERP: SAP R/3 4.6c/4.7 EE, ECC 5.0/6.0, EP 6.0/7.0, SCM 5.0/7.0, SRM 5.0/7.0.

SAP Modules: CRM, FI-CO, SD, MM, PP, HR

Professional Experience:

Confidential, Pennsylvania, PA (Sep 10 - May 12)
SAP- BO Consultant
Responsibilities:

• Performed requirement gathering , analyzed the new requirements, wrote the functional requirement documentation
• Study the business, study the data sources and study the data model to implement a reporting system for State farm business user requirement.
• Collaborate with business users to research existing business and system processes.
• Plan the technical design and prepare the technicaldocument and get approval from business user.
• Identify the tables, dimensions and facts. Identify the relationship between tables as per design doc, link the tables and set the Parameters and cardinalities on the Universe Designer.
• Identify the loops, like chasm tram and fan trap loops and resolve it with alias (mostly for fan trap) and contexts (mostly for chasm trap) and perform integrity check.
• Create business logic classes and create objects like dimension, details, measures and conditions.
• Developed and maintained the linked Universes in the Universe Designer for defining the business oriented data structure from the Star schema.
• Set the row level, column level and table lever security as per document.
• Export the universes to repository along with list of values (LOVs) as required.
• Worked extensively with @functions including @aggregate aware, select, prompts and @where to overcome database integration issues.
• Used Web Intelligence / Webi Rich client for web based Ad-hoc query and reporting.
• Creating Reports on Webi Intelligence, Webi Rich Client, Crystal Reports and created Xcelsius Dashboard reports, Widgets and Business View Manager as per End user requirements.
• Worked with Crystal Solutions Dashboard and Visualization (XCelsius) to provide the client with dashboards to illustrate consolidated views of key metrics and KPI's. Implemented the clients requisition to build intense dashboards with several what-if business scenarios and visual components incorporated in to these dashboards and utilize the available historical data and analyzed data. These dashboards were imported in to MS Excel, MS office and PDF files.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed custom Hierarchies to support drill down reports.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data using Alerter.
• Generated Webi reports, Crystal Reports, Xcelsius Dashboard, BO Audit reports, including formatting options such as Grouping, Sorting, Drill-down, Parameter prompts, Slice and Dice and Hyperlinking reports
• Worked with BO Designer, InfoView, WebIntelligence, WebIntelligence Rich Client, Desktop Intelligence, CMC, CMS, Crystal Xcelsius.
• Exposure to Migrate BO XI R3 to SAP BOBJ 4.0
• Migrated BOXIR2 content to BOXIR3 including Universe, reports and security
• Involved in BOXIR2 & BOXIR3 server installation by following change management process
• Worked with Business Objects XI R2 & R3 Administration (e.g., Creation of Users , Groups and controlling their rights to reports, security set up at folder level, group level, Installation, LDAP configuration, Certification to use server authentication
• Worked with SAP BW tables.
• Worked with Business Objects Security Viewer to create and view existing security setup
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Integrator XIR2 and Business Objects Data Quality & Data Insight with proper IQ and OQ documentation
• Experience in migrating BO Universe, reports, dashboard reports, ETL jobs from one environment to another environment
• Worked extensively with SAP BW tables and SAP SD Tables.
• Worked with SAP NetWeaver BI functionality
• Worked with SAP BW 7.0.
• Peformed Data Modeling (Knowledge of Multi-Dimensional Modeling, creation of InfoCubes, DSOs, InfoObjects, MultiProviders, InfoSets, VirtualProviders, Aggregates, Administration of Data Targets, and Process Chains)
• Ability to source data from different source systems (SAP systems and Flat files)
• Performed Reporting (SAP BW Business Explorer tools - Query Designer and BEX Analyzer)
• Created Period reports shift or daily report, weekly, monthly and annual reports and financial reports
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports
• Tested the reports thoroughly created by other developers, as per the report specifications
• Wrote requirement document and design documentation for Universe and reports
• Created Object Packages to schedule group of reports
• Defined Calendar, based on user requirement and scheduled reports
• Modify report content and export reports in multiple formats, based on user input
• Participated in recursion, unit and QA testing of the screens that were developed
• Designed best practices for production support for day-to-day end user requirements
• Created Data Integrator ETL jobs to load source data to target table.
• Created Data Quality jobs to clean the data and integrated DQ jobs to Data Integrator

ENVIRONMENT: SAP BOBJ 4.0 / Business Objects XI R2 /XI R3 (Designer, Supervisor, Web Intelligence, Performance Manager, Data Integrator), Crystal Reports, Crystal XCelsius, IBM DB2 UDB 8.0/7.0, SQL Server 2005/2000, V2R5, Oracle 10g/11i/9i, SAP BW 7.0, SAP Netweaver, Erwin, Window XP

Confidential, Dallas, TX (Jan 10 - Aug10)
Sr. SAP Data Warehouse Administrator

• Developed, Implemented and Maintained complex Xcelsius Dashboards for Government Systems and Information Technology business units using SAP BW7.0, Bex Queries, BOBJ3.1x Universe, WebI Docs, Info burst and Xcelsius2008 software.
• Performed what if analysis and forecasting with Xcelsius.
• Experience developing dashboards with drill down capabilities, hierarchy mappings, and dynamic visibilities within Xcelsius.
• Worked on creating Dashboard for Remedy Incident Management, Change Management, Problem Management Systems to track Customer satisfaction surveys, SLA, Backlog, Request Tickets and Top 10 old tickets, Prioritized Tickets.
• Have working knowledge with SAP BW7.0/7.3: Info objects, Data sources, Transformations, ABAP to get Routines working in transformation, DTP, DSO's, Info Cube, Multi provider and BW Bex Queries.
• Experience creating various report formats and use of multiple data sources.
• Possess working knowledge of BOE XI 3.1x, Business Objects 4.0, InfoView/BI Launchpad, Lifecycle management (LCM).
• Provided support to reports/dashboards by performance tuning, problem solving, debugging and unit testing.
• Designed and implemented Metrics dashboard utilizing SAP BICS connection as well as using Universe, WebI docs for detail reports through Open Doc. (for Example: IMS, Earned Value, Staffing, Risk, Milestone and CONC Metrics)
• Developed and supported complex Cognos reports for Accounting (Travel management Group) using Concur Report Studio tool.
• Created project related documents to support reports and Xcelsius Dashboards.
• Worked closely with teammates on issues that came up during development and implementation stages of the project.
• Kept self, superiors and subordinates informed of project status.

Confidential, Cary, NC (May 07 - Nov 09)
Sr. BW/BO CONSULTANT

• Conducted workshops and gathered reporting requirements from end users, carried out GAP analysis on KPIs, generated functional and technical specifications and data flow diagram across systems/applications.
• Customized MM, SD, Asset Utilization and FI Cubes and DSO based on the GAPs and build customized reports. Enhanced extractors, transformations with user exits and start routines using ABAP codes.
• Installed Business Objects, SAP Integration kit, InfoView, Rich client, Crystal reports, Data Federator, Data Services, Data Integrator, Voyager, Live office & Xcelsius software. Exposed to BO explorer functionality.
• Co-ordinate with SAP Basis and BOBJ Admin in applying patches, upgrade enabling BIA, CMC activities.
• Installed Data Services/Data Integrator extracted data from Legacy DB and loaded to BW for reporting.
• Configured and mapped tables to access data thru' Data Services for transformations of Master Data and Transaction data applying business rules in order to harmonize data for global reporting under one platform.
• Integrated data from SAP and non-sap data thru' Data integrator and used and transformed the same for corporate reporting across various plants located globally across various geographical locations.
• Build Business Objects Universes, Connections and defined Web Intelligence report using webi Rich client and exported to web intelligence server - Infoview for further testing and business use.
• Build Executive and Operation dashboards in Xcelsius using several options or combinations of i.e. Live Office and new BW Connection (BICS) components and published in portal Iview and in InfoView.
• Build custom organization Hierarchy in BOBJ (diff from BW) which enhances ability to drill down both reports and dashboards from executive to operational level details, aggregated at Hemisphere, Region, Geo Market, and Country and at Product line level details.
• Build Webi report connecting to from SAP ECC/BW tables and integrated the data from diff. sources.
• Worked with BO admin in migration of Universes, reports and dashboards across 3 landscapes using LCM (Life Cycle Management tool), build entire folder structure on Infoview to match with SAP Info area.
• Scheduled all Live Office reports to cache it in LCM to support Executive dashboards and flash reports, used hyperlink, Open doc functionality for multilevel drill down.
• Installed BIA accelerator and tuned on required cubes to improve query performance in BW and BO.
• Trained end user in defining new queries, execution of reports in BW/BO and conducted user acceptance Sig-off session before global roll out.

Confidential, Pittsburgh, PA (Oct 06 - March 07)
Sr. BI CONSULTANT
Responsibilities:
Sales Analytics Project

• As a Sr. SAP BW Developer, responsible in discussing business solutions for KPI-C with Business Analysts
• Involved in Design and development of the infrastructure for KPI-C metric Analytics Project for the live perfect order percent.
• Perfect order metrics were derived out of the 2lis_11_VAITM

P1960 Project

• Responsible for Data Modeling in the Data Warehousing effort of the CRM (IBase, Service Contracts, Service Order, and Service Order Confirmations) and Master data(Business partner) for the SAP BW.
• Based on the GAP analysis, activated available Business content and created necessary custom Objects like Info objects, ODS and InfoCubes.
• Customized and Enhanced the Data sources in CRM to meet Business requirement including few of the most Critical Extractors: CRM IBase, CRM Service Contracts & Financial internal Order.
• Written Data Transformation Rules with ABAP to combine the data from different Sources to remain Consolidated into Info cube.
• Created Generic data source CRM Finance internal order using table VIAOM_CRMSRV_OBJ.
• Implemented Datamart interface Scenario with ODS updating several Data targets.
• Designed and scheduled Process chains for automating the delta loads.
• Created and Loaded hierarchies using flat-file to display the Service Code data in hierarchical form in the reports.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Partitioning/Repartitioning and Compression.
• Worked with Open Hub Service for sending the data from BW system to Data services for data cleansing and data Integration purpose.

Reporting:

• Created Drill through queries from summarized InfoCube to detail ODS data.
• Developed BW-CRM Analytic Reports using the BEx Query Designer such as
• Installed Bases without Service contracts,
• Number of Service Contracts Per Installed Base Category,
• Remaining Term of Service Contracts,
• Expiring Service Contracts item.
• Designed SAP universe over a consolidated BEx query and developed reports using WEB-I and BEX query as data source to address reporting needs such as Contract availability for an IBase.
• Used WEB-I for Adhoc reports and XCelsius to generate corporate Dashboards for reporting Time and Material and Entitlements.

Confidential, Waltham, MA (Aug 05 - Sept 06)
SAP BW Jr. Consultant
Responsibilities:

• Performed post-upgrade activities such as Replication of data sources, Activation of Transfer Structures etc.
• Created master data Info sources for uploading attributes, texts and hierarchies from SAP R/3 system.
• Monitoring of daily loads and analyzing the reasons for frequent load failures.
• Maintain reconciliation's to verify the data in SAP R/3 with SAP BW.
• Implemented a BW data warehouse solution for reporting HR and CCA data.
• Implemented InfoCubes for Payroll, Headcount, and Personal actions, Staffing Assignments, Appraisals and Recruitment.
• Responsible for designing and development complex Extractors using Functional modules for various HR areas.
• Worked in the area of Cost Center Accounting, Personnel Cost Planning, HR Payroll and Personnel Time Management.
• Responsible for designing and development complex extractors using functional modules for various HR areas.
• Extracted data from Data Sources like 0HR_PACP_1, 0HR_PT_1, 0HR_PT_2 and 0HR_PY_1.
• Used inbuilt info providers such as 0CCA_O09 (for "actual"), 0PACP_C01, and 0PY_MC02. Also worked on custom reports for cost center accounting, actual line items overview and comparison of personnel cost plans.
• Created process-chains to automate the Data Loads, Rollups into Aggregates, creating and Deleting indexes to improve performance.
• Analyzed Info cubes created and maintained aggregates to improve the performance.

Confidential, India (Nov 04 - July 05)
SAP BW Consultant
Responsibilities:

• Involved in full life implementation of the project right from the requirements gathering to the support and maintenance phase.
• Extensively worked on SAP BW functionality like LO Extraction, transfer rules, update routines, start routines, developed custom BW cubes for specific user requirements that could not be met by using Standard Business Content.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying extended Star Schema modeling principles in Data Design, used expert knowledge of data warehousing concepts, Info Cube data design and reporting.
• Designed Sales MultiCube over the Sales Order, Delivery and Billing cubes to provide visibility of data across the sales cycle in the same query.
• Activated Standard Business Content and loaded large volumes of production data into Info Cubes pertaining to SD & MM.
• Installed and Enhanced LO Cockpit Data Sources in purchasing to include additional fields using the USER Exits, and enhanced all the corresponding Info Cubes and ODS objects according to the reporting requirements.
• Extensively worked on the design and development of the Process Chains. Migrated the entire job stream from Info package Groups to Process Chains to make ease of monitoring the jobs.
• Created custom Master data sources using tables, views, ABAP query and set up Delta for custom fields.
• Designed ODS Structure, extracted data to ODS structure through flat files and enhanced standard data sources.
• Actively involved in activating and modifying the Queries using Business Content to evaluate Customers, Vendors and Sales Data.
• Created jump queries, Info Set queries, Variables, Calculated Key Figures, Structures, Exceptions & Conditions for reporting on ODS objects & Info Cubes.
• Developed queries in Query builder and set up the authorization profiles for the end users.
• Developed Sales Web queries so that the users can access the data through the Internet.
• Worked on Query development, Templates and Workbooks in BEx Analyzer

Education Qualification
Bachelor of Technology in Civil Engineering