SUMMARY

• SAP BW/BI/BO Professional with 8+ years of extensive experience in SAP Business Intelligence.
• Expert in SAP BW (Data modeling, Extraction, Reporting) BW Accelerator.
• Extensive experience in BW configuration such as building Info Objects, Data Store Objects, Info Cubes, MultiProviders, Info Sets, Aggregates, Hierarchies, Data Sources, Info Packages, DTPs.
• Experienced in SAP Business Objects suite of products like Web Intelligence, Universe Design Tool, and Information Design tool, Crystal Reports, Xcelsius, Dashboards and Data Services.
• Knowledge in functional areas such as SD, MM.
• Expertise in creating Universe(s) from scratch, updating existing universe, with measures, dimensions, joins, filters, Cardinality, Alias, Contexts, List of values, Aggregate Awareness, Resolving Loops, Derived Tables, linked universe.
• 2 full Life Cycle implementations (End - To-End) performing key roles in Requirement gathering, Design and Development.
• Strong experience in BW production support activities including monitoring teh daily Process Chains and resolving several data load and reporting issues.
• Expertise in BW Performance Monitoring and Tuning activities like improving data load performance by parallelization techniques and reporting performance by creating Aggregates, Indexes, compression and Partitioning .
• Experience in ABAP activities related to BI in Field level & Transformation routines, User Exits. Creating Generic Data sources with Tables, Views and Function Modules.
• BI Expertise in teh areas of SD, MM, QM, PS, HR, FI, and Account based COPA SCM, CRM, IS-Utilities.
• Worked with Global Claims and Bill back Agreements models to report on Claims and Rebates.
• Extracted data usingBWextraction structures such as LO Cockpit, Generic & Standard Extractors.
• Extensively worked on various Business Objects reports functionalities likes queries, report filters, Cross tab report, master detail, breaks, alerts, sorts, ranking, prompts, complex calculations, graphs, input controls.
• Created complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Worked with conditional formatting, prompts, report filters, input control, ranking and sorting.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, derived tables and input controls.
• Experience working on Unix environments and CA Workload Center Scheduling tool.
• Good Knowledge ofData Warehouse Concepts and Data Modelling approaches like Star Schema modelling, Snowflake Schema modeling, Fact,LookupandDimensionstables.
• Involved in performance tuning of BOBJ reports at Universe level and report level.
• Experience with Dashboard Designer and CMC tool.
• Proficient in coordinating and managing teh activities between on-site and off-shore teams.
• Strong Experience in Sybase and SQL Server 2005 database development like procedures, triggers, and complex queries, dynamic SQL, query performance and tuning.
• Active team player and as an individual withExcellent Communication,Interpersonal skills, self-motivated fast learner, good leadership skills and teh ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Languages: C#, ASP.Net, Java.

IDE: Microsoft Technologies (MS Visual Studio 2005), Eclipse.

BI/OLAP: BEx Query Designer, Web Application DesignerSAP BO 4.0, BO XI 3.X, Webi, Crystal Report, Xcelsius Dashboards, Desktop Intelligence, BI Launchpad, IDT & UDT

ETL: Dataservices 4.0

ERP Tools: SAP R/3, ECC 6.0

Databases: Sybase ASE (12.5, 15.0.3), MS SQL Server 2005, MS-Access.

Database Skills: Indexes, Triggers, Procedures, Cursors, Query writingDatabase design, performance tuning in Sybase and SQL Server 2005, T-SQL.

Database Tools: SQL Advantage, MSManagement Studio, Aqua Datastudio.

Utilities: BCP, ISQL, defncopy (only on Sybase).

Operating Systems: Windows 9x, 2008, UNIX, Linux, Sun Solaris.

Bug Traking Tools: Resolve IT, Footprints.

Scheduling Tools: CA Work Load Center, Autosys, cron jobs .

Version Control Tools: MS visual source safe, subversion, SVN.

Software: MS Office, Visual Source Safe, MS-Office-VISIO 2007.

Domain: Market Research, Media Intelligence, Banking.

Others: Hardware & Networking of win2k troubleshooting.

PROFESSIONAL EXPERIENCE

Confidential, Lexington, KY

Sr. SAP BW/BO Consultant

Environment: SAP BW 7.0, 7.3, ECC 6.0, Business Objects 4.0, Dashboard Designer, Webi, Crystal Enterprise.

Responsibilities:

• Acting as a bridge between offshore development teams and client to address and teh issues and methodology to follow for root cause analysis.
• Designed and developed various Data targets and Info providers like DSO (ODS), Info cubes, Info objects, Multiproviders and Info sets using Admin workbench.
• Analysed business reporting requirements dat could be satisfied with SAP business content and delivered cubes and installed teh necessary objects.
• Worked with several users, and interacted with them to gather requirements, and transformed them into a data model with teh concept of extended star Schema.
• Using Business Objects as front end tool for Reporting
• Extensively working on FICO module including different applications such as Cost Center Accounting, Account based COPA, Product Costing, Accounts Payable, Accounts Receivable, New General Ledger, Travel and Asset Accounting.
• Working on Open Hub for proving data to other systems
• Data Modeling based on BW Extended Star Schema as per teh Business requirement.
• Designed and built InfoObjects, InfoCubes, DSO, Multiproviders based on business requirements and prepared a Design documents.
• Created transformations and Data Transfer Processes to load data from PSA to Target.
• Modified standard and created custom datasources, InfoObjects, DSO and Infocubes.
• Used LO and Business content extractors to extract data from SAP ECC 6.0. Also used Flat file extraction from other data sources.
• Involved Up gradation from BI 7.0 to BW 7.3 version.
• Transporting from development box to QA & Prod.
• Conducted Training sessions for Users and prepared Training Material.
• Created Start, Field and End Routines in teh transformations.
• Created Variable Exits and routines at info package level for data selections.
• Created Meta process chains to load teh master data and transaction data into teh targets.
• Created RRI from high level report to detailed level reports.
• Involved in performance tuning like Creation of aggregates, compression of Info cubes, Creation of BIA indexes to improve teh Query response.
• Populated various data targets like Info objects, ODS and Info cubes, with Master data and Transactional data from ECC 6.0, legacy systems and flat file interface via Data Staging area (PSA).
• Extensively performed huge data loads into DSO and Info cubes from ECC as well as teh legacy systems.
• Created Webi reports from multiple data providers and synchronized teh data using merge dimensions option.
• Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data using teh Information design Tool.
• Created detailed reports with Drill-down capability using Interactive Analysis, worked on
• Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
• Extensively used teh Bex Query designer and Analyzer for customizing and troubleshooting queries for creating teh foundation for reporting out of business objects.
• Developed 5 Complex Interactive Analysis reports involving multiple bex queries to a single report, Calculated Key Figures, Restricted Key Figures, Hierarchies, Reports with Input Controls etc
• Applied row level and object level securities to different groups to restrict teh data in Supervisor module.
• Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.
• Monitored daily process chain runs and resolved any data load issues.
• Worked on support issues like data reloads as required, fixing bugs. Resolved issues connected with running teh query.

Confidential, Minneapolis, MN

Sr.SAP BW/BO Developer

Environment: SAP ECC 6.0, SAP BI 7.2, Business Objects Enterprises 4.0, XI3 Suite (Central Management Server, Central Management Console, Import Wizard), Designer, Info-View, Reporter, Unit Test, Crystal Report, WebI, Xcelsius, SQL server.

Responsibilities:

• Participated in teh full software development life cycle.
• Managed Security for various reports and Universe in teh Development, Test, Stage and Prod Environments using Central Management Console (CMC).
• Managed user rights for BO Applications like Web Intelligence, Designer for Different Group Users in teh Central Configuration Manager.
• Extensively performed huge data loads into DSO and Info cubes from ECC as well as teh legacy systems.
• Migrated users/groups, Universes, Reports, Access Level From one environment to other using Import Wizard and Life Cycle Manager (LCM)
• Developed, tested and implemented new Functions and Stored Procedures, Triggers etc.
• Responsible for SQL tuning and optimization using Explain Plan and Indexes.
• Extensively worked with teh performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making teh customized Query to teh Report generated Query
• Responsible for creating teh Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Published Teh Xcelsius Dashboards to teh users and involved in sharing Knowledge with Team members

Confidential, San Antonio, TX

SAP BW/BO Developer

Environment: SAP BW 7.0, ECC 6.0, Business Objects XI R3.1, Crystal Reports 2008, Xcelsius 2008, Sybase.

Responsibilities:

• Created several WebI and DeskI reports using Multi-fact star schema with conformed dimensions.
• Created complex reports using functionalities like Slice and Dice, Drill Down and Scope of Analysis.
• Exported reports to teh repository for Info View users. Configured CMC for scheduling reports.
• Migrated reports from XIR2 to XIR3.1; used migration wizard to migrate repository and its components.
• Performed Inventory Management Load, using LO Cockpit, from multiple R/3 systems into BW.
• Implemented Slowly Changing Dimensions to keep track of historical data.
• Implemented Data warehousing schemas including Star-Schema and Snow-Flake Schema.
• Implemented & supported teh Business Intelligence tool, Exact GPS. Designed and developed several Info cubes and reports for Sales, Accounting and Operations data.
• Designed and implemented solutions using master data and operational data source (ODS) tables.
• Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.

Confidential, San Jose, CA

Sr. Business Objects Developer

Responsibilities:

• Created Universes from multiple databases for different business groups from different Databases.
• Defined teh business names, create predefined conditions, prompts and custom hierarchies.
• Responsible for maintaining Development, Testing and Production Repositories and providing round teh clock support during Production stage.
• Resolved issues like loops by creating aliases and contexts as required to remove teh cyclic dependencies
• Applied row level and object level securities to different groups to restrict teh data in Supervisor module.
• Created Web Intelligence documents and published them to corporate documents to share teh resources between teh user communities.
• Created New Universes and modified teh existing Universes and used @functions like @select, @where and @prompt in teh process of building teh universes
• Involved dashboard layout design and internal data mapping design.
• Worked on teh SQL tuning and optimization of teh Business Objects reports.

Confidential, Lebanon, NJ

Business Objects Developer

Environment: Business Objects XIR2 Suite (Desktop Intelligence, Central Management Server, Central Management Console, and Import Wizard), Supervisor, Xcelsius, Designer, Reporter, Unit Test, Crystal Report, Web I, BCA, Sybase, Windows 2003 server/XP

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Created Universes from multiple databases for different business groups from different Databases.
• Created classes and objects and defined teh business names, create predefined conditions, prompts and custom hierarchies.
• Responsible for maintaining Development, Testing and Production Repositories and providing round teh clock support during Production stage.
• Resolved issues like loops by creating aliases and contexts as required to remove teh cyclic dependencies
• Applied row level and object level securities to different groups to restrict teh data in Supervisor module.
• Modified teh existing universes by adding new objects, conditions and prompts based on teh business requirements.
• Developed Web Intelligence and Info View with advanced features like drill down and drill filters.
• Created Web Intelligence documents and published them to corporate documents to share teh resources between teh user communities.
• Created New Universes and modified teh existing Universes and used @functions like @select, @where and @prompt in teh process of building teh universes
• Involved dashboard layout design and internal data mapping design.
• Worked on teh SQL tuning and optimization of teh Business Objects reports.
• Created Crystal Business Views using BO XI R2 using Business View Manager and exported them to teh repository to create Crystal Reports.
• Created Crystal Reports using both Universes and Business views based on teh Business Requirements.

Confidential, Harrisburg, PA

Business Objects Developer

Environment: Business Objects XIr2/6.5, Web Intelligence, Informatica, Desktop Intelligence, Unit Test, CMC, Sybase, Xcelsius, WEBI.

Responsibilities:

• Involved in gathering user requirements.
• Created teh Logical and Physical Model using classic Star-Schema.
• Defined Complex Security set up for end users.
• Configured user rights and security.
• Designing, creating, enhancing, testing BO universe, reports.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of teh system.
• Created teh full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
• Tuned teh reports for better performance using SQL.
• Designed templates for Webi documents and customized Webi Front Page.
• Developed functions and procedures and change control documents for BO.
• Linked Webi reports for different hierarchies.