SAP BO Consultant Resume

Name : XYZ                                                                                                  E-mail ID: ABC@gmail.com

Phone No.: xxxxxxxxxxxxx                                                               Current Job: BO Consultant

Professional Summary with Industry for over 9 years on SAP BI, Business Objects, Xcelsius, OBIEE and R/3 as lead with experience in deployment and developing business processes and system solutions for Financial, Pharmacy, Retail, Manufacturing verticals.

• Hands on experience with SAP BPC installation and SAP integration Kit with BO XI R2 environment.
• Knowledge of Business Objects Integration with SAP BI 7
• Knowledge in Planning, Designing, Developing and Deploying Data warehouses / Data Marts, SAP Rapid marts with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
• BI Modeling, Data Extraction, AWB, Constructing BW Objects like Info Cubes, ODS.
• Hands on experience in designing and maintenance of InfoProvider and MultiProviders and familiar with creating and customizing of PSA.
• Proficient with planning, Implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse.
• Comprehensive knowledge using SAP ASAP methodologies in Business Information Warehouse Database design, Development, Installation Configuration, Capacity planning and Performance.
• Well versed in On-site and offshore Methodologies.
• Excellent Communication, analytical and Interpersonal skills as a Technical Project Manager mentored team members and lead implementations from Blue print to Go-Live.

Technical skills

SAP BPC 5.1 and 7, BI 7, BW 3.5
SAP R/3 SAP ECC 6.0, 4.6C ,4.7, Modules: FI-CO, MM, SD, HR and EM
SAP Technologies EDI/IDOC, ALE, BDC, SAP SCRIPT, USER EXITS
Databases SAP R/3, MS Access and SQL Server.
Reporting Tools OBIEE, Business Objects, BEx and web reporting, MS- Excel,
Operating Systems UNIX, Linux, Windows 98/2000/NT/XP, 2000 / 2003 SERVER

Professional Experience

Projects

9. Project Name: SAP BO Installation and Integration
Client Cupertino Electric Inc
Role BO Consultant
Duration 05/2010 -- Till date
Team Size: 1 Location: San Jose USA Module: BO


Roles & Responsibilities:

• Installation and Integration or SAP BI (Edge) and established interface to Oracle 10g

• Configuring .rpt file reports in CMC and replacing SAP BO in place of a tool called Penta.

• Configured SSO using Kerberos and Vintella to enable NT users to loin all SAP BO applications using Windows AD

• Built reports using SQL statements and training to BO developers on how move on with the tool and project.

• Built and distributing functional specification documents to BO developers and Business users across the organization.

• Migrated reports to Xcelsius for better analysis.

• As a Business analyst developed Unit Test cased and Integration test cases and conducting testing.

• Responsible for reports sign off from business users and making sure the reports suffice the business requirements.


8. Project Name: SAP BPC Product Support
Client SAP America
Role Asst Senior Consultant
Duration 11/ 2009 -- 04/2010
Team Size: 18 Location: New jersey, USA Module: BPC 7.5 and BO


Roles & Responsibilities:

• Primary responsibility includes troubleshooting BPC 5.X/7.X MS, NW product issues.
• Provide remote assistance for installations of SAP BPC versions 7.5, 7.0 and Xcelsius
• Installed Business Objects XI R2 & XI 3.1, BO products including, Web Intelligence, Performance Manager, Crystal Xcelsius and continued Infrastructure support.
• Good command on designing reports using Xcelsius dashboard and using Xcelsius Designer.
• Hands on experience in using Components browser, Canvas, Grid tool, Object browser? etc.
• Handling Configuration of BPC Appsets, Applications and Dimensions, Defining Data Model, Data Management.
• Work with business users across locations and provide support at various levels.
• Document troubleshooting steps and make them reusable notes.
• Identifying BPC limitations and raising the same escalation to management so that it will be taken with SAP
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable


7. Project Name: SAP BO -- Implementation (ALGO)
Client Fitch Ratings
Role Team Lead
Duration 08/ 2008 -- 10/2009
Team Size: 5 Location: New York, ,USA Module: BPC 5.1, BI 7, BO

Fitch Ratings is a well know Global Leader in offering credit ratings to corporate and banking sectors. The SAP BPC/BI objective is to optimize the operating cost and system with ERP system inside Fitch.
This product gives the end Business Analyst to adhere/streamline with the SAP features in terms of data management and granulized reports as they required.


Roles & Responsibilities:
• Involved from Blue Print preparation stage and contributed in Outlook Soft-CPM design development.
• Installed Xcelsius 2008 with SAP3 on the server and handled using the Xcelius 2008 to develop the executive Dashboards.
• As a Business Objects Admin created rolls and groups in Central Management Console and based on the profile give access to Business user.
• Developed executive dashboards for the Regional Managers and Finance Directors.
• Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligent, Live Office, Xcelsius and CMS XI
• Maintained Consolidation required dimension properties, Worked on Legal Consolidations.
• Defining Data Model, Data Management, Role assignments of char & key figures and mapping.
• Involve in building financial & budgeting reports and applying functions based on requirements.
• Command on System Integration (SI&T) practices and also addressed BPC product limitations.
• Automated BPC to BI data loads from application server to BI data targets using logical file name in infopackage.
• Reviewing User Survey to know the customer satisfaction with the resolved issues
• Frequently visiting onsite team (Canada) for gathering Business requirements and to bridge gaps in business understanding between onsite and offshore teams.


6. Project Name: MWRD -- US Govt. Project.
Client MWRD -- US Govt. Project. Chicago
Role Team Lead
Duration 10/ 2007 -- 08/2008
Team Size: 3 Location: Chicago IL, USA Module: BPC 7.0 , BO


Roles & Responsibilities:

• Involved in System Study & Business Requirements Analysis & Documentation.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Creating, enhancing, and testing of universes and reports in coordination with DBA and architects.
• Used Designer to create Dimensional, Detail and Measure objects
• Resolved loops in universe using contexts and aliases and also Implemented aggregate awareness function.
• Development of Dashboards using Crystal Xcelsius 2008.
• Created Dashboard, Chat and Containers, Selectors using the Xcelsius components
• Created Dashboards using Filters, List View, table, Line, Column and Pie charts (combination bar graphs, combination bar and line graphs, and line graphs will be used to display metrics.)
• Created the weekly tab will show the last 10 operating date, defaulting to the current calendar date
• Involved in creating Tables and relationships.
• Developed complex queries and reports using different data providers in the same report
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc
• Worked on the monthly tab which will show the last 8 weeks (4, 4, 5 calendar weeks) defaulting to the week that includes the current operating date.
• Involved in managing full project lifecycle including: upfront requirements analysis, documentation, project plan management, user acceptance coordination, production rollout, end-user training and providing post implementation adoption management and customer service
• Involved in production supporting on various platforms like UNIX, Windows NT/2000/XP/98
• Worked on Dashboard Design and Development, capable of analyzing requirements documentation
• Automated Excel sheet data using VBA to reflect on power point slides as various data graphs
• Created and deployed Web Intelligence Reports through Info View
• Converted existing Crystal Reports to Business Objects.


5. Project Name: Application Center for Data Excellence
Client Arcelor Mittal
Role Team Lead
Duration 01/ 2007 -- 10/2007
Team Size: 7 Location: East Chicago, IN. USA Module: BI/BO

Project Description
Arcelor Mittal is the world's largest steel producers with 11% of global production. It has 10 plants in three sub regions (FCWE Region) across France, Belgium, Germany and Spain. IT Supply Western Europe (ITSWE) is the IT arm of Arcelor Mittal in Western Europe which manages IT operations of Flat Carbon Western Europe.
Its main objectives are developing standard solutions for Arcelor Mittal Group, optimize costs and industrialize process, involve in new development related activities in SAP based system for Commercial Flat Carbon business unit.

• As Arcelor Mittal was a kickoff project to implementation partner, contributed in building Change Request Process, Technical Documents format, Unit Test Cases and Unit Test Results Templates.
• Represented onsite for reverse Knowledge Transfer to client to exercise understanding of applications.
• Worked on Business Object Importer, BO Editor, Data Integrator and Redefining Display and Existence Check Methods.
• Worked on BO Rapid Marts DDL for schema creation and Sample universes.
• Responsible of few applications and nominated as first point of contact.
• Handled Change Requests as per the process.
• Converted Functional Specifications to Technical Documents, prepared Unit Test Cases & Unit Test Results.
• Worked on Info object creation tool which can create as many number of objects without manual intervenes.
• Created ODS, Cubes, Multiproviders and learnt concept of Dummy Cube.
• Moved newly developed fields to BI from R/3 and embedded in data targets in order to impact reporting.
• Worked on Transport requests, integration testing in quality and production system.
• As a peer reviewer for all development earned good command on requirement gathering and impact analysis.


4. Project Name: Development for new requirements.
Client GlaxoSmithKline
Role Team member
Duration 08/ 2006 -- 01/ 2007
Team Size: 2 Location: Boston, MA. USA Module: BW


Project Description
GlaxoSmithKline plc is a UK-based pharmaceutical, biological, and healthcare company. GSK is the world's second largest pharmaceutical company and a research-based company with a wide portfolio of pharmaceutical products.

Contribution
As a BW consultant performed the following activities: -

• Designed Data flow for Demand/No Demand application.
• Data Extraction from SAP MM of SAP R/3.
• Created BW Objects, Update rules and Info Packages, Data Targets and Multi providers in accordance to the application.
• Achieved in viewing single next date of demand instead of multiple dates to check the latest date.
• Built Process Chains for Activities loads & Fact Sheet Loads
• Extensively worked on Transport requests.
• Handled Automation of currency conversions.
• Implemented Elimination of Internal Business Volume when transactions occur in interim company warehouses.
• Responsible of Unit test cases.
• Prepared user Project Documentation and as well as technical documentation for End users and IT core team members


3. Project Name: Phase one Implementation
Client Kenmore UK Limited
Organization Axon Solutions Ltd
Role Implementation team member
Duration 09/ 2004 -- 08/ 2006
Team Size: 7 Location: London, United Kingdom Module: BW


Project Description

Kenmore Property Group is a co-investing, trading and development property and fund management group active in the UK, Europe and Middle East, which reached £1.7 billion at 30 April 2007

Axon Solutions was responsible for implementation process extracting data from various sources and loading into info cubes.

Contribution

As a BW consultant performed the following activities: -

• Created and activated custom Info Cube as per the data model for SD Sales over View (Sales Order, Billing Document, Sales Order / Billing).
• Data Extraction from SAP SD of SAP R/3 and Flat File into the SAP BW.
• Extracted the transaction data FI-CO from R/3 to BW by maintaining the extract structures, maintaining data sources, replicating the data Sources into BW.
• Good knowledge on GAAP, G/L, A/R, A/P and Cost Accounting
• Created ODS update rules and Info Package to load data, installed Business Content.
• Extensively worked on BW Scheduler to load data into Info Cube, and ODS and Monitor the Status of the data loads.
• Created Aggregates to improve system query performance.
• Created Multi-Provider from Delivery and Billing info cubes.
• Monitoring the data loading, failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets.


2. Project Name : Production Support
Client John Deere
Role Production support Team member
Duration 09/ 2002 -- 08/ 2004
Team Size:6 Location: Boston, MA. USA. Module: BW

Project Description

John Deere is the world's leading manufacturer of farm equipment. The company offers a complete line of farming services and solutions with products sold and serviced through the industry's premier dealer network.

Unifords Technologies is providing production support wherein tuning query performance and resolving trouble tickets.

Contribution

• Initiated an extract process in B/W at regular intervals, changed the Logical Business date so that the extracted data gets updated into B/W staging areas -- ODS.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Analyzed and corrected production support problems as they occur in the SAP BW system.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Maintaining the queue -- related to the system generated tickets and customer generated tickets.
• To communicate with the customer who posted the Ticket.
• Daily monitoring of Info cubes and ODS object requests.


1. Project Name : Production Support
Client Monsanto.
Role BW Consultant Trainee
Duration 06/ 2000 --08/ 2002
Team Size: 9 Location: India Module: BW

Project Description

Monsanto is an agricultural company. It is a global company with locations in many countries. Monsanto is a global leader in the vegetable and fruit seed industry. It supplies more than 3,500 seed varieties to commercial fruit and vegetable growers.

Unifords Technologies is providing variety of IT services to Unlived its vegetable and fruit industry.

Contribution

• Involved in Activating Business Content for Standard Info Cubes, ODS objects, Info Sources and Info Objects of SD module.
• Worked with Info Cubes like Sales Overview, Delivery Services and Info Sources like Sales Order and Delivery.
• Learned how to extract the transaction data by LO-cockpit from R/3 to BW by maintaining the extract structures, maintaining data sources, replicating the data sources into BW.
• Worked on Administration Workbench, customized Info Objects, Info Sources and Info Cube.
• Learned creation of Aggregates to improve system query performance.
• Learned how to work with PSA in monitoring the data transfer from Source System into BW.

Business Objects Administrator Resume

Name : XYZ                                                                                                  E-mail ID: ABC@gmail.com

Phone No.: xxxxxxxxxxxxx                                               Current Job: Business Objects Administrator

Objective

To obtain Business Objects Administrator position that fully utilizes my experience and abilities.

Related Skills 

Vast working experience with Business Objects SDK
Profound knowledge of Data Warehouse development
Proficient with Enterprise Data Warehouse implementations
Ability to translate business requirements into a technical solution
Ability to work in a fast paced environment
Ability to handle multi tasks 

Work Summary 

Business Objects Administrator, 2010 - Present
Cybersoft Technologies Inc - Houston, TX

Assisted in development and implementation of Business Objects backup and recovery plans.
Developed effective standards, best practices.
Developed support procedures for Business Objects version XIR2 / XIR3 infrastructure.
Administered and supported multiple environments.
Administered and provided design guidance for BI reporting solutions.
Assisted other staff in the use of the Business Objects toolset. 

Education 

B.S. in Information Technology, 2010
Michigan State University, East Lansing, MI
GPA 3.75 (on scale of 4.0) 

SAP Business Objects Developer Resume

Name : XYZ                                                                                                  E-mail ID: ABC@gmail.com

Phone No.: xxxxxxxxxxxxx                                                          Current Job: Business Objects Developer

Summary

• Over 7+ years of experience in Business Intelligence using SAP Business Objects4.0,XI-R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008,Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management(CCM), Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Exclusive Experience in SAP BW connectivity with Universe Designer and Business objects Infoview using the SAP Integration Kit
• Strong Knowledge and Experience in Business Objects tools & SAP Business Objects from 2003.Strong knowledge and Skill in Data Integrator & Data Quality Tools.
• Excellent experience in designing Business Objects universes, complex BO reports both full clientand Web Intelligence Reports.
• Strong SAP ECC Knowledge in SAP ECC 6.0 (FICO,MM,PP,SCM,SD)
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Extensive experience on Prototyping the new technologies like Business Explorer/Polestar XI 3.1,
• Used Live Office and QAAWS(Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards).
• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.
• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports.
• Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
• Extensive knowledge in SQL, PL/SQL& T-SQL programming and trouble shooting
• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
• CompleteSoftware Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Excellent communication, interpersonal, training, analytical and technical skills.

Technical Skills

BI Tools: SAP Business Objects 4.0, XI 3.1, R1/R2 6.5.x,Crystal Report 9/10/ XI/ 2008,Xcelcius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI, Full Client, Web Intelligence, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0,Live Office
ETL Tools: BO Data Integrator (ETL), Data Services
Platforms: Windows (all flavors), Debian Linux
Databases: SQL Server 2000/7.0/6.5, Terawatt, Oracle 10g, 9i/ 8i, Access, DB2
Languages: C, Java, SQL, PL/ SQL,T-SQL, HTML/CSS
Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office, Erwin, Toad, Clarity, Epic.

Education

Bachelors in Computer Science

Professional Experience

SAP BOBJ Certified
Confidential, Houston, TX FEB 2012 - CURRENT
Role: - Business Objects Developer

Project Details:-Confidential, District is a fully integrated healthcare system which includes 14 community health centers, eight school-based clinics, a dental and dialysis center,mobile health units, a rehabilitation and specialty hospital and two full-service hospitals; Ben Taub General Hospital and Lyndon B. Johnson General Hospital. They had Epic as an eMar and Clarity as their primary reporting data warehouse. They implemented functional specific data marts on top of Clarity and had requirements of creating universe, webi reports and dashboards. I have extensively worked on developing their provider incentive scorecard reporting and dashboard, which they use to track their provider performance across all facilities under their healthcare umbrella

Responsibilities:-

• Created two complex dashboards which uses live office to feed the data into xcelsius from the source webi reports
• Developed Provider scorecard reports using Webias the reporting tool
• Developed complex webiCore Measures Scorecard report which is used by the organization to track various core measures of the hospitals by month, quarter, year against the benchmarks
• Developed a complex provider scorecard dashboardwith multiple tabs using dynamic visibility. This dashboard shows the high level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports
• Re-Developed an existing dashboard which shows the high-level rolling 12 month information of patient medication administration. This dashboard also had drill down capabilities to get to the detail data by month and by facility.
• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office and changing the live office refresh option to pick from the latest instance.
• Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity
• Developed a complex provider scorecard universe which involved multiple fact tables. Created multiple contexts to resolve loops. Performed integrity checks and documented them
• Validated the source to target data for referral and medications scanning data marts.
• Created sql test scripts to validate the source to target data for the provider scorecard datamart.
• Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Worked on creating Webi reports as a part of the homeless project
• Created trending images and published them to the server images folder and used them in the webi reports to show trending of the data
• Formatted webi reports and scheduled them to be bursted as pdf to the report to web server.
• Created information spaces in business objects explorer and performed indexing on them
• Worked on a different internal project Radiation Oncology software upgrade from Lantis to Mosaiq 2.3
• Worked on validating the canned crystal reports with the end user and customized some ofcanned reports and created new reports as a part of new user requests
• Created an user log crystal report with input optional prompts, to report all the fields which were required for the internal security compliance which were not there in the user log which was shipped with the application
• Involved in scheduling the crystal reports as object packages, creating the schedule events on test server using CMC
• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems

Environment :- SAP Business Objects XI 3.2, SAP BI/BO 4.0,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, Report2Web, Business Explorer/Polestar, Oracle 10g/11g, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio, Clarity, Epic Hyperspace

Confidential, Plymouth, MN Oct 2011 - Jan 2012
Role:-Business Objects Developer/Admin

Project Details: -Confidential, a child company under the Omnicom Group is an advertising media agency, which acts as a liaison between the advertiser and the advertisee for ad publishing. They had very complex requirements in desinging and building universes, webi reports and dashboards various business needs.

Responsibilities:-

• Fulfilled the business objects development needs for various departments. And also performed the day to day admin tasks.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Handled various tickets for business objects issues for the end users.
• Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
• Some daily admin tasks included verification of all BO user logins and security checks, Testing theavailability of all universe connections, Monitoring day to day scheduled jobs on Broadcast Agent (BCA)
• Modified the default session timeout, for the infoview as the users complained about being session timeouts frequently.
• Migrated some of the Hyperion reports to business objects, developed similar reports in webi
• Edited the existing Hyperion Reports, to add new prompts for the reports by changing the front end scripts and sql queries.
• Handled Bobj Administration tasks, to create new usersand groups, handle password resetsand assignsecurity. Was involved in upgrading the service pack.
• Created a stable environment for Business Objects XI 3.1 by scaling the number of processing servers based on the user base and access frequency.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate),complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus Considering best business Practices using Web intelligence Rich Client
• Scheduled Webi reports and Hyperion reports based on the requirement.
• Moved the developed webi, crystal reports and universes between development, QA and production environments using import wizard.
• Was involved in training the end users over the newly developed crystal and webi reports.

Environment:-SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, SQL Server 2008/2005

Confidential, Lexington, KY Nov2010- Jul 2011
Role: - SAP BOBJ Developer/Admin

Project Details: -Confidential, manufacturer of the entire line of quality sleeping products. They have a very robust SAP infrastructure and had requirements dealing with SAP BOBJ to Build Universe, Reports, and Dashboards for various department needs.

Responsibilities:-

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
• Involved in establishing SAP BW connectivity with Universe Designer and Business objects Infoview, using SAP integration kit. And also installed java connector to import the roles of the SAP user to Business objects.
• Performed day to day admin tasks like monitoring DB Services, creation ofuser groups and handled password resets, monitoring of user activities/ sessions, universe connection and availability checks.
• Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.
• Involved in creation of Reports, formatting reports, generation of charts, barsetc as per user requirements using Webi, Xcelsius 2008.
• Developed new set of standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required.
• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.
• Creating complex Data flows with inner R/3 data flows and declaring parameters at different levels of Workflow.
• Creation of different data stores to get SAP tables.
• Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source system.
• Worked on Polestar to generate complex reports for the data required. Simultaneously export reports and making it easily available to Decision makers.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Performed ETL activities using Data Integrator and Data Services, by extracting data from various Sources.
• Design, develop, and implement Xcelsius dashboard against SAP BW data sources. Established the design pattern for all future Xcelsius development using Live Office and QaaWS as connectors
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008 and embedded Xcelsius onto Crystal Reports for better results and also provide users with clear understanding.
• Worked on certain issues and dealt with Info View, CMC.

Environment: -SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC.

Confidential, Philadelphia, PA Nov 2009 - Sep 2010
Role: - SAP BOBJ Developer

Project Details: - Confidential, is a content management company; I have worked extensively on developing their new product, Dynamic Open text vendor Invoice management Interactive Dashboard which is sold by old by SAP asSAP Invoice Management by OpenText. This Dashboard is to be used in around 114 countries around the world. One Single Dashboard dynamically adjusts to various requirements without any modifications.

Responsibilities:-

• Build Xcelsius Dashboards using SAP Web services created from SAP NetWeaver. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.
• Various SAP Functional Modules have been used as a source and ABAP programming to extract, aggregate and deliver the data to Xcelsius using SAP Web services.
• Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.
• Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
• Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Designed dashboard using best practices and advanced filtering techniques to dynamically filter and serve as the source for the dashboard.
• Optimized dashboard performance for speed of thought analysis even with large data volumesand simultaneously allowed user customization on the fly.
• Worked Extensively with Flash Variables, web services and made Generic Dashboards toenhance Performance in Situation to Decrease Load on the Parent Dashboard, and Designed Child Dashboards to Distribute Load among Various Child Dashboards to Mitigate the Performance Issues
• Used Complex excels functions and logics to support data requirement. Ex: -Vlookup, hlookup, choose, Nested IF's, Value, ISNumber, ISNA, Match, Indexetc to name a few.
• Built Password Protected Dashboard and Created a Scenario to Trigger Multiple Web Services on User Authentication.
• Built Many Static Dashboard Models during all my Work Requirement in due process to Create Generic Live Model Using Web Services, Flash Variables etc.
• Done extensive testing across various scenarios to see the dashboard working across multiple complex and varying scenarios.
• Used various Custom SAP functions exclusively for Xcelsius to help in this process to additionally implement thousand separators and decimal Operators to support various different number formats.

Confidential, Houston, TX Dec 2008 - July 2009
Role: - SAP BOBJ Developer

Project Details: -A top-tier oilfield service company, Baker Hughes delivers solutions that help oil and gas operators make the most of their reservoirs. Work included developing Universes, Dashboards, and Scorecards etc. Worked with Data services to move data from legacy systems and enforce quality and reduce redundancy.

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Work included Developing, Testingand enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
• Developed, Tested, Promoted andMaintained theWEBI Reports, also had modified the existing reports based on user requirements, Also solved any issues/errors encountered
• Responsibilities required acting as the Key Person for maintaining Universe's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolved loops,Fan Traps and Chasm traps using context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulaeetc using Web intelligence.
• Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0 Enterprise Environment. Used Java SDK's.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Used Polestar for better interaction with predefined data sets to generate quick visualized reports
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice,Alerts etc in Creating Reports, formatted old reports, generated charts, barsetc as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
• Designed interactive Dashboards such as Popup, Tabs etc and many creatively styled Xcelsius Reports to best support needs using effective HCI Principles.
• Manipulating data through various presentation styles using Crystal Reports 2008 such as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment:-SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0.

Confidential, Dallas, TX Feb 2007 - Dec 2008
Role: - SAP BOBJ Developer

Project Details: -Confidential, is the world's top financial institution. I was assigned to use SAP BW to extract data and build dashboards in Xcelsius, and build and modify existing reports and simultaneously create and design reports using SAP BOBJ.

Responsibilities:-

• Worked as a Business Analyst for requirement gathering for business and functional reporting.
• Work included Universe Designing, Requirement Gathering, Setting up Joins, Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes based on additional Requirements etc Using Designer.
• Developed Crystal Reports fromSAP BW (Business Warehouse) using BEx Query as the extraction tool.
• Created Crystal Reports with ole object extracting image file from the database and URL links.
• Created custom formulas to display RGB colors in crystal reports.
• Customized the formatting of the Crystal Report using formula's at the section level.
• Created formula's for Crystal Reports 2008 and stored it on the Crystal Repository to be used across the organization. Created reports with dynamic grouping based on parameters.
• Designed logic for Xcelcius 2008 dashboard in Microsoft Excel for Data Visualization.
• Involved in using Job Server in creation of real time jobs. And also involved in Performance tuning at source, transformation, and target levels.
• Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Integrator.
• Involved in Creation of jobs that specify data mappings and transformations by using Data Integrator Designer.
• Used Data Integrator to load data from different sources (SQL, Text files) to the target database
• Performed Unit , System and Regression testing of the Business Objects Data Integrator ETL jobs
• Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into staging area
• Created Jobs, Workflows, Transformations and Data Flows according to requirement to integrate source data in to Target data ware house
• Analyzed various Data Warehouse Models like slowly changing models, Conceptual Models, Logical Models. Also Designed and developed Data Integrator scripts for data transformation.
• Extracted data source for cube from SAP transactional system and flat files.
• Created BEx queries for analysis of data using BEx analyzer as the tool.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports.
• Used and monitored Info View, CMC and also assigned Roles, and set User Groups and rules and according principles and also monitored security and other CMC controlled functions.
• Developed Drill Downs report using Graphs in Crystal Reports 2008.

Environment: - Windows Server 2000/2003/XP, Universe, Crystal Reports 2008, Data Integrator, Xcelsius 2008, BEx Query designer& Analyzer, Info View, CMC, Oracle 10g, SQL Server 2005.

Confidential, Bellmawr, NJ May 2006 - Jan 2007
Role: -BOBJ Developer

Project Details: -Vertis Communications is a premier provider of targeted advertising and marketing solutions to America's leading retail and consumer services companies. Building and Updating Universe's and Reports based on requirements. Have Developed Monthly, Quarterly Reports as required by the Management.

Responsibilities:-

• Created finance, sales, retail reports using Crystal Report.
• Collected requirements from business and functional user and transformed into design specification for other developers in the team.
• Developed Existing Universes and added additional Links, Joins according to the requirement and sorted Loops, Traps.
• Created Views, Stored Procedures, Queries and tables to create the reports.
• Team lead for crystal development with responsibilities to set up the Crystal Server, Info view, reporting structure, role and rights.
• Developed new reports using Crystal Reports XI and Oracle 10g as database.
• Developed reports out of legacy database such as Microsoft Access.
• Developed reports by joining more than one database such as SQL server, Oracle database.
• Created dynamic and static parameter based report and scheduled it on the Crystal Server.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Created company specific formula and used Crystal repository to store generalized formulas for reusability. Also Used Stored Procedure to generate reports.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Used Data Integrator in ETL activities. Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area. Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Passed parameters dynamically to Crystal Report in .net application at runtime.
• Developed Drill Downs report using Graphs in Crystal.
• Trained all the Users of the Reports on using Info view and exporting reports to various formats.
• Tested the reports in for quality and end user validation to match the amount and quantities figures against the transactional system.
• Developed Crystal OLAP reports using Microsoft Analysis service as the Data Warehouse.
• Developed Dashboards using Crystal Xcelsius.

Environment:-Windows Server 2000/2003/XP, Data Integrator, Designer, Crystal Xcelsius, Crystal XI, Data Integrator, Oracle 10g, SQL Server 2005, Microsoft Access.

Confidential, Dallas, TX Oct 2005 - Mar 2006
Role: -BOBJ Developer/Admin

Project Details: -Confidential, one of the top beverage and snacks manufacturers in the world. Work required maintaining, documenting, designing needs for various departments according to their requirements involving various Customer details, Groups etc. Designed, Updated Universes and also build reports utilizing various functionalities of Crystal reports. Maintained User Security, Publishing and Other Monitoring Duties as needed.

Responsibilities:

• Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
• Involved in Installation and Configuration of all products of Business Objects 6.5.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Exported universes to the repository to making resources available to the users.
• Created reports using the Universes andFree-hand SQL as data providers.
• Involved in development and deployment of Complex Reports.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports which offered robust performance and ability to balance Loads.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for Webi and Info View clients using Broadcast Agent server.
• Used Supervisor to Grant User rights and roles etc.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involved in creation of Filters, prompts and setup Hierarchies for Multidimensional Analysis.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decodefunctions,using Crystal reports XI.

Environment: - Business Objects 6.5, Designer, Webi, Full-client, broadcast Agent, Supervisor, Crystal reports XI, Oracle9i, PL/SQL, and Windows NT/XP.

Confidential - Chennai, India April 2003 - Aug 2005
Role: -BOBJ Developer

Project Details: -Worked for Several Clients who needed a Semantic layer and easy platform to Query and get reports to answer several questions regarding their Business. So mainly set up roles, rights, built Universes, and designed reports to provide better interaction and better Data Visualization.

Responsibilities:

• Created & Modified Universes for various functional areas of high level reports group usingDesigner.
• Customized LOVs in Universes for quicker performance of reports. Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Changed the universe parameter settings to optimize the performance of universe.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, and Formulae's etc.
• Created reports according to different requirements Such as Summary Charts etc Using Wizards andWeb intelligence2.x.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
• Used Supervisor, Info View to manage Users etc.
• Various Programming tasks included developing Reports using free hand PL-SQL, and T-SQL procedures.
• Created reports using Crystal Reports 9/10with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers. Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.

Environment: - Business Objects (Designer, Reporter) 6.1, Supervisor, Broadcast Agent, Crystal Reports, Oracle 9i, PL/SQL, T-SQL, Web intelligence2.x.