PROFESSIONAL EXPERIENCE

Over 8+ Years of solid experience in the field of IT with prominence on SAP Business Objects (BOBJ) /Business Objects Data Services (BODS), Business Intelligence (BI) including four full life cycle implementations in BI3.5/7.0 and BOBJ 3.1/4.0

• Proficient in all phases of software development life cycle (SDLC) including requirements gathering, Analysis, Design, data conversion, system implementation, Performance tuning, Testing and Support.
• 5+ years hands on experience in SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional/Real-time Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update rules, Transfer rules, Routines, Process Chains and Event management for Automation process, Transformations in BI 7.0/7.3 NW 2004s
• Hands-on experience in working with Business Objects 4.0 implementations and upgrades
• Hands-on experience with SAP BOE XI Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, Web Intelligence (WebI), BO Dashboards, Crystal Reports, Xcelsius, Web Intelligence Rich Client, Desktop Intelligence (DeskI)
• Adept in using of Data services Designer, Job Server Manager, Repository Management, Access Server ,Data services Management Console in Business Objects Data Services(BODS).
• Knowledge with SAP HANA modeling, administration and replication methods such as ETL based(BODS), Trigger based(SLT) and DXC(Direct Extractor connection)
• Obtained relevant experience in ASAP methodology subsequent implementation phases such as Project Preparation (includes business requirement collection, business process analysis, gap analysis), Business Blueprint, Realization, Final Preparation (includes data loads, unit test, integration testing, power and end user testing), and Go Live & Support.
• Experience in creating Repositories, designing Universes, WebI reports, publishing and scheduling
• Extensive knowledge with Hands-on experience with data Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using BO Data Integrator and BO Data services
• Strong experience with OLAP reporting in BW/BI and implementation of BEx Analyzer
• Worked extensively with BEx Query Designer, BEx Analyzer, WAD (Web Application Designer) for developing reports, analysis, and Web reporting. Skilful in BW Extractions, BW Modeling and BEX Reporting/Analyser
• Hands-on experience on Queries, Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Crystal reports, Authorizations, User profile maintenance, BEx Analyzer, Info set query, RRI, Web reporting and Workbooks.
• Good understanding of BI 7.0- DSO, Transformation, DTP and remodeling Info Providers
• Thorough knowledge of data warehousing principles including data modeling, extract / transform / load processes, job scheduling, indexing, and OLAP processing, defining and using aggregates based on queries and execution plans
• Extensive experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, customizing SBC objects, custom data warehouse development, managing ETL jobs, troubleshooting failed processes
• Expertise in creation of Basic cube, Remote cube, Transaction cubes and DSO. Good understanding of Data Modeling using BW Extended Star Schema.
• Involved in managing of Info cube, which involves Info cube content, performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.
• ETL experience in extraction of various source data like RDBMS, flat files, XML files, Data profiling, Transformations and testing data quality using BODI.
• Strong exposure to reporting in IBM COGNOS BI 8/10 and usage of Report Studio, Query Studio, Analysis Studio and Framework manager
• Extensively usedUser conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerters, Sub queries, Promptsfor creating efficient Business Objects reports.
• In-depth knowledge in creating reports, queries and performing analysis with IBM Cognos 8 BI
• Hands on working experience with Windows98/2000/XP/Vista/Windows7/Mac, MS office
• Experienced in working with database systems including SQL server, Oracle, Access and HANA

TECHNICAL SKILLS

BW 3.5 & BI 7.0/7.3

SAP Versions:

4.6C, 4.7 & SAP ERP (ECC 6.0)

SAP BW/BI:

DW Workbench, DTP, Info Cube, DSO, Transformation, new PSA, BI Accelerator

Reporting:

Business Objects Enterprise 12.0, BO XI 3.1, Business Objects 4.0, Info View/Launch Pad, Xcelsius2008/DashBoards4.0, Web Intelligence(WebI), Desktop Intelligence (DeskI), Crystal Reports 2008/4.0, BEx Analyzer, BEx Query Designer, QAAWS, IBM Cognos BI 8/10:Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager.

ETL Tools:

BI 7.0/7.3, Business Objects Data Services(BODS)4.0/3.2/3.1 (Designer, Repository Manager, Job Server Manager , Metadata integrator, Management Console), BO Data Integrator XIR2/11.7/11.5

Database:

Oracle, Teradata, Microsoft SQL Server, Access, HANA

Applications:

VMware, Microsoft Office – Word, Excel, PowerPoint, Outlook, Project

Languages:

ABAP, C, C++

Web Technologies:

HTML, DHTML

Operating System Skills:

MS-DOS, WINDOWS’95/98/XP/Vista, WINDOWS 2003/2008 Server, Linux

WORK EXPERIENCE
CLIENT NAME: Confidential, June 2012 – Present
LOCATION : Raleigh, North Carolina
ROLE : Sr. Analyst- Business Objects

Description: With its corporate headquarters in Raleigh, North Carolina, CARQUEST Auto Parts is the premier supplier of replacement products, accessories, supplies and equipment for virtually all makes of automobiles, as well as light and
heavy-duty trucks, off-road equipment, buses, recreational vehicles and agricultural equipment. Additionally, it distributes
And sell tools, equipment, chemicals, paint and accessories.

Responsibilities:

• Gathering requirements by working with business users, project managers and technology directors and involved in analysis and deployment of SAP Business Objects 4.0 upgrading from BO 3.1
• Migration of all objects from existing BOE3.1 on Solaris to 4.0 on windows 2008 R2 using import wizard and upgrade management tool (UMT). Configuring the CMC, CMS in 4.0 as per the user requirements.
• Configured promotion management and version management to migrate objects in and around both development and production systems. Configured Auditor, Monitoring, Events and applications in the CMC
• Assigning the security at both object level and folder level based on organisational structure and organisational groups
• Configured the distributed environments for the different applications and servers including dashboards on different servers.
• Configured the servers on the new 4.0 environment as per the user requirements. The configuration includes sizing of both adaptive processing servers and job servers for high performance and through output while running scheduled jobs and on demand reporting
• Modification of the WebI reports and universes and creation of new reports.
• Validation of all objects during the post migration including Universes, WebI reports, dashboards.
• Resolving of scheduling and on demand issues that occurred during the migration from 3.1 to 4.0 and post implementation
• Knowledge transfer to the users and the system administrators. Developing of windows shell scripts to run batch files in a distributed environment and automatic scheduling of services
• Configuring the object level access restrictions to the universes as per the organisational needs and requirements
• Configuring the BI 4.0 system for mobile applications and BI integration with Oracle Apps
• Configured the Launch pad, Web Intelligence for all users as per the requirements.
• Designed, developed and formatted reports in WebI using Drill Down, Cross Tab, linked reporting, master detail and Formulae’s.
• Created a road map for peer review and testing of post-production activities and before live procedures
• Designed and implemented new sales dashboards using QWAAS, live office and BI services
• Developed a new business critical universe and reports with in a short span of time.

ENVIRONMENT: BOEXI3.1/ 4.0, BODS 4.0, Solaris, AIX, VMware, Windows 2008 R2, Oracle 11g, Sql server 2008, BODS 4.0

CLIENT NAME: Confidential,Aug 2011 – April 2012
LOCATION : Akron, Ohio
ROLE : Business Objects Consultant/BO Administrator

Description: Confidential,of tires for automobiles, commercial trucks, light trucks, SUVs, race cars,
airplanes, farm equipment and heavy earth-mover machinery. It operates 23 manufacturing facilities in the
United States and Canada and also maintaining facilities in Europe, Latin America and Asia. The company also
Operates more than 1,800 retail outlets for the sale of tires to consumers, approximately 60 tire retreading facilities
and approximately 160 warehouse distribution facilities.

Responsibilities:

• Requirement gathering by working with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture that can be considered \'best practice\' and scalable
• Participated in Business Objects 4.0 up gradation Project.
• Administered the 4.0 environment with respect to managing servers, users, reports, universes, applying patches
• Maintaining both development and production systems in sync and resolving the scheduling and on-demand issues
• Involved in building and designing Universes and resolved Loops and Traps using Contexts and Aliases.
• Created Aggregate awareness functions on multiple summary tables to improve the query performance.
• Updated Universes as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Set up Universe level conditions to restrict data based on report requirements.
• Created reports using Business Objects functionality’s like slice and Dice, input controls, sections, linked reports, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Used Import Wizard to migrate reports from one environment to another environment.
• Designed the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Developed variousfull client and thin client reportsusing Business Objects andWeb Intelligence.
• Wide usage ofDrill modeandSlice and Dicetechniques to modify the reports in accordance with the user’s analysis needs.
• Worked extensively onDesigner,Web Intelligence (WebI),Desktop Intelligence (DeskI),Crystal reports,Central Management Console (CMC) and
• Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Created QAAWS and live office connectivity to WebI for refreshing dashboards with current data

Environment: Business Objects XI3.1/4.0,Windows 2008R2, Oracle11g/10g, SQL server, TOAD, SAP ECC6, ABAP, SD, MM and FI/CO

CLIENT NAME: Confidential,Sep 2010 – July 2011
LOCATION : St. Louis, Missouri
ROLE : Business Objects Consultant

Description: Confidential, is an American multinational financial services corporation with its headquarters in the
MasterCard International Global Headquarters, New York, United States. Throughout the world, its principal business is to process payments between the banks of merchants and the card issuing banks or credit unions of the purchasers who use the "MasterCard" brand debit and credit cards to make purchases. MasterCard Worldwide has been a publicly traded company
Since 2006. Prior to its initial public offering, MasterCard Worldwide was a cooperative owned by the 25,000+financial institutions that issue its branded cards.

Responsibilities:

• Requirement gathering by working with business users, Financial Analysts, Project managers and involved in

Analysis and creation of architecture that can be considered \'best practice\' and scalable

• Converted existing Excel Reports and MS Access to Business Objects Reports.
• Created new linked reports with advanced drill down functionalities and graphical layouts as per requirements
• Defined and created classes, objects, conditions, users and measure objects to capture complex formulae.
• Designed and implemented new dashboards utilizing the live office connectivity
• Utilized/managed various components of Business Objects Enterprise (BOE) XI 3.1 - Web Intelligence Rich Client, Central Configuration Manager (CCM) –Central Management Server (CMS), and BW Publisher for Crystal Reports reporting from Business Explorer (BEx).
• Worked extensively onDesigner,Web Intelligence (WebI),Crystal reports,Central Management Console (CMC) and
• Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Involved and assisted the administrators in maintaining the production, QA and development environments
• Architected the Web Deployment strategy for Business Objects Web Reports using Web Intelligence,

automated document Scheduling and Publishing using Broadcast Agent.
ENVIRONMENT: Business Object Xi 3.0/3.1/3.2Info View, Xcelsius 2008, Crystal Reports 2008, Oracle, SQL server

CLIENT NAME: Confidential, Oct 2009 – Aug 2010
LOCATION : Saskatoon, Saskatchewan
ROLE : Business Objects Consultant

Description: Confidential, is the world\'s largest publicly traded uranium company, based in Saskatoon, Saskatchewan. In 2010, it was the world\'s largest uranium producer, accounting for 16% of world production. Cameco operates several uranium mines in North America and Kazakhstan. Through the Bruce Power Limited Partnership (BPLP), Cameco also participates in nuclear power generation in the province.

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination ofchartandtables.
• Developing complex universes by using advanced features like aggregate aware, Conditions and hierarchies to Perform linking of universes by Kernel method to optimize the universe development and performance improvement.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Worked on Powerful business objects functionality\'s like functions, Variables, user response and formulae.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Created the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments.
• Created the reports using Crystal Reports functionalities likeAddQueries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown listsetc.
• Developed dashboards usingBusiness Objects Xcelsius.
• Extensively usedCalculations,Break points, Drill down,Slice and Dice, FunctionsandFormulas,Filters & Alertsfor creating Complex reports.

ENVIRONMENT: Business Object 3.0/3.1, Xcelsius 2008 and Crystal Reports 2008, Oracle, SQL server, Business Objects XI3.1(Designer, Business Objects DeskI, CMC,), Web Intelligence XI3.1,(WebI), Info View.

CLIENT NAME: Confidential, Dec 2008 – Aug 2009
LOCATION : Toronto, Ontario
ROLE : Business Objects Consultant

Description: Confidential,is the third largest bank in Canada by deposits and market capitalization. It serves some 19 million customers in more than 55 countries around the world and offers a broad range of products and services including personal, commercial and corporate and investment banking with assets above $575billion.

• Working with SAP BI and BO Business users, Project managers, architects and involved in requirement gathering, analysis and creation of best practice architecture
• Worked with SAP BO, BI, Basis, and R/3 teams and involved in providing integrated solutions
• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using BUSINESS OBJECTS XIR2.
• Created OLAP Universes using BOE XIR2 - Universe Designer on top of SAP BI queries, (enabled OLE DB for OLAP) and Info Cubes / MultiProviders; created/modified classes, objects, dimensions, measures and details.
• Created RDBMS Universes using Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts
• Created queries and reports, Web Intelligence (WebI) documents in Java/.Net Info View and created Web Intelligence (WebI) reports on top of the Universes created using the Designer
• Utilized/managed various components of Business Objects Enterprise (BOE) XIR2 - Web Intelligence Rich Client, Central Configuration Manager (CCM) –Central Management Server (CMS), and BW Publisher for Crystal Reports reporting from Business Explorer (BEx).

ENVIRONMENT: : Business Objects XIR2, Informatica Power Center 8/7.1.4/6.2 Oracle 10g, Info view, Flat files, XML files, ECC6, ABAP, SD, MM, FI/CO

CLIENT NAME: Confidential, Aug 2007 – Dec 2008
LOCATION : Toronto
ROLE : Business Objects Consultant

Description: Confidential,Financial Group is the largest financial institution in Canada, as measured by deposits, revenues, and market capitalization. The bank serves 17 million clients and has 80,100 employees worldwide with total
assets of over $750billion. The company corporate headquarters are located in Toronto, Ontario

Responsibilities:

• Responsible for requirement gathering by working with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture that can be considered \'best practice\' and scalable
• Created Universe for Data warehouse system and creating of WebI, Xcelsius and Crystal Reports.
• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager
• Created the reports using universes as the main data provider.
• Created universe objects like Dimensions, Details and Measures, Conditional Objects and Prompts Functions to meet the requirements.
• Created different types of reports likeMaster/Detail, Cross TabandCharts
• Created Hierarchies and Predefined Conditions using Business Objects.
• Created various Reports like Financial Reports, By Region wise, and Reports Based on time like Year, Quarter, Month,

Week and Geographic Reports

• Created the Universe and report check list templates, which are used as check points before moving the migrated

Objects into QA and Production environment

• Created the User Groups and Users, Set up the privileges to them according to their requirement.
• Created and managed Universes of different sources and linking them in the Designer.
• Interacted with the Business analyst and the Manager in gather the business requirements to design and develop reports.

ENVIRONMENT: : Business Objects 6.5/ XIR2, BI 7.0, BEx, SAP ECC6, ABAP, SD, Oracle 10g, Solaris10

CLIENT NAME: Confidential, June 2006 – Aug 2007
LOCATION : Montreal, Quebec
ROLE : BI/BW Consultant
Description: Confidential,is a Canadian aerospace and defense company and over the years it has become a large manufacturer of regional aircraft, business jets, mass transportation equipment, recreational equipment and a financial services provider. Bombardier was a Fortune Global 500 conglomerate company. Its headquarters are in Montreal, Quebec, Canada.

Responsibilities:

• Created Info Cubes, Info Sources, update rules, Data Sources and replicated Data Sources.
• Experienced in Designing of queries, workbooks from Info Cubes.
• Created Communication structures, transfer structures, transfer rules & update rules for the info cubes and the ODS.
• Installation of Business Contents objects as per Business Requirements.
• Involved in extracting data from SAP R/3 using LO Extractors.
• Created characteristic and key figure Info Objects from the Standard Content, customer defined and loaded into Info objects, ODS objects, Info Cubes, Created Info Packages, scheduling and monitoring.
• Transported the developed BW objects to quality and production.
• Actively involved in monitoring the data transfer from source system into BW.
• Data uploading from R/3 & non R/3 Systems (Oracle / Flat Files).
• Support, Optimization and revamping of scheduling and monitoring the system.
• Problem resolving related to data loading and query performance.
• Optimization of major cubes with aggregates and compression.
• Involved in creation of reports using Query Designer such that by using Conditions, Exceptions, Free Characteristics, Restricted Key figures, calculated key figures, user entry Input Variable and formula Variables.

ENVIRONMENT: BI 7.0, BW 3.5, BEx, SAP ECC6, ABAP, SD, MM, FI/CO, Oracle10g

CLIENT NAME: Confidential, Jan 2004 – May 2006
LOCATION : Hyderabad, India
ROLE : BI/BW Consultant

Description: Confidential, has been a diversified company that has 11 business segments: Information and Telecommunication Systems, Electrical Systems, Social and Industrial Systems, Automotive Systems, Electronic Component Devices, Construction, and Financial services.

Responsibilities:

• Monitoring and Fixing of Failures
• Maintained multi-dimensional Data Models for Data warehouse and ODS.
• Maintained Info objects, Navigational attributes, Info Sources, Transfer Rules, Transfer Structures, ODS, Update rules, Info cubes, etc.,
• Assigned Data sources to the Info Source, Defining Transfer Structures, and Metadata maintenance for the Info Source and source system.
• Actively involved in Development of LO and Generic extractors.
• Activated and installed required objects from Business content.
• Identified and modeled data sources from the OLTP side to be converted into Info Sources.
• Activated and installed technical content Info Cubes, queries to prepare BW statistics report.
• Created Info package for both Initialization and delta and loaded. Monitoring the data loads into info-Cubes which were scheduled periodically.
• Created a Classical Report to find out Stock availability for a particular storage location using select options Plant, Company Code, Material Number, and Storage Location.
• Created an Interactive Report that List details Vendor No ands address in the Basic list and Bank details Like Account Number, Bank Name and Bank details in the Secondary List
• Created a Report to find out total of net Purchase Order Values for a particular Vendor

ENVIRONMENT: SAP BW 3.5, SAP R/3 4.7, BEx Analyzer, BEx Browser, SD, MM, FI and CO, Oracle 10g Windows NT.

ORGANIZATIONAL STRENGTHS

• Committed to understand organizational missions and to understand ethics and public
• Excellent in organizing information, people or things in a systematic way
• Effective in demonstrating skills in team building and in managing workflow
• Ability to understand creative processes and capable of systems thinking
• Highly motivated and a quick learner with a positive attitude and great interpersonal skills
• Dedicated, well-organized team player with solid research and reporting skills
• Skilled and fostering relationship with people from diverse background
• Capability to adapt to new situations, settings and to tolerate change well

EDUCATION

Bachelor of Technology (Electronics and Communications Engineering)