Project Manager Management

SWETHA 615-***-****

Sr. SAP BI-BOBJ Consultant acd1z5@r.postjobfree.com

PROFESSIONAL SUMMARY

• Over 7 years’ experience in Business Intelligence as a Business Objects Developer/Analyst covering a broad

spectrum of industries.

• Managed entire reporting processes from design through implementation, including gathering business

requirements, report design, development, testing, and implementation, scheduling and publishing of reports.

• Designed and built universes by selecting and joining tables, setting cardinalities and resolving loops by using of

aliases and contexts.

• Developing and implemented reports using structured SDLC methodologies like gathering, analyzing,

documenting business and functional requirements and data for Business Objects Universes and Reports.

• Extensive experience in using BEx Query Designer to build queries using BW MultiProviders for master data and

transactional data.

• Scheduled Business Objects Reports using Business Objects Central Management Console.

• Experience in Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), End

User Reporting, Web based Reporting & Implementation, Creating Test scripts and user signoff documents.

• Strong knowledge in creating PL/SQL procedures, packages, functions and experience in Relational Database

Management Systems (RDBMS).

• Generated Complex Crystal Reports such as Sub Reports, Drill-Down, Dynamic Grouping, and Cross-Tab,

Graphical, On Demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Linked Reports, Mailing Labels,

and Aging Reports.

• Created Corporate Dashboards, Metrics, Rules, and Alerts, Bar charts, 3D charts, Pie charts, Column charts,

Line charts, Bubble chart and Goals using Xcelsius 2008.

• Performed calculations, created variables, drill options, slice and dice to make reports easier for users to analyze

data and extensively used various Business Objects functionalities.

• Performed scheduling, published those documents to corporate folders and made them available to

Authenticated users.

• Optimized, Debugged and tested SQL queries.

TECHNICAL SKILLS

BI Tools : Business Objects 4.0/XIR3.1/R2/XI (Report Designer, Universe builder, Web Intelligence,

Desktop Intelligence XI), Central Management Console, Broadcast Agent, Crystal

Reports 2008/XI/9.0, Xcelsius 4.5/2008, BEx Query Designer, Advanced Analysis, BEx

Broadcaster, Business Explorer.

Databases : Oracle7.3/8i/9i/10g/11g, MS Access, MS SQL Server

Applications : BMC Remedy 7.0/6.0 ITSM Suite - Service Management disciplines

Other Tools : Toad for Oracle, SQL* Plus, Adobe Acrobat, SharePoint site administration, MS Office.

Operating System : Windows, UNIX

EDUCATION

Bachelors in Computer Science, Jawaharlal Nehru Technological University, AP, India.

PROFESSIONAL EXPERIENCE

Goodyear Tires, Akron, OH Nov 2011 – Present

Sr. Business Objects Analyst/Developer

Goodyear is one of the world's largest tire companies, with operations in most regions of the world. Together with its

subsidiaries and joint ventures, Goodyear develops, markets and sells tires for most applications.

To develop a reporting suite that provides the fleet with all the information they need to minimize costs and improve all

facets of their operation. The largest fleets in the world they rely on the powerful business information Goodyear provides

using Business Objects to make confident business decisions.

Responsibilities

• Worked on gathering, analyzing, and documenting functional requirements and data specifications for Business

Objects Universes and Reports.

• Recommended various universe designer best practices to application teams and created complex universes to

satisfy the business needs.

• Prepared the business requirement documents based on the User comments on their specifications and developed

the mapping documents for designing the Universe and reports.

• Created multiple Universes against SAP BW, InfoCubes, and BEx queries and updated existing Universes using the

Information Design Tool.

• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts etc.

• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and

functionalities like Combined Queries.

• Created reports using functionalities like slice and dice, drill down, cross tab, master detail tables and formulas,

etc.

• Created Alerter’s using Business objects to highlight columns based on business criteria.

• Inserted drill filters in the Web Intelligence reports, which help the end users to run a report based on multiple

selection criteria.

• Gathered requirements from various business users and built queries using BEx Query Designer. These queries

were used in building Web Intelligence reports.

• Designed templates for Web Intelligence reports and scheduled daily/weekly reports to a shared drive, ftp location

and BI Inbox.

• Created and maintained Universe supporting multiple levels of hierarchies for drill reports.

• Provided training to the Users on BEx Query Designer, Advanced Analysis and Web Intelligence tools.

• Created Web Intelligence reports using advanced features like Formulas, Groups, Sub Reports, Hyperlinks,

Alerts, Cross Tabs, Charts and Parameters.

• Setup Multi-Page Reports, Margins, Headers & Footers and provided users with Open Document Functionality

features.

• Created graphical representation of reports such as bar charts, 3D charts, pie charts, column charts, line

charts, bubble charts using Xcelsius 2008.

• Worked on building dashboards in Xcelsius using Live Office Connectivity and also created WSDL’s using Query as

a Web Service (QaaWS) from different data sources to build Xcelsius dashboards.

• Created Daily totals, ROI, Summary balance sheet, Inventory levels, Distribution summary dashboards using

Xcelsius.

• Created Xcelsius dashboards for various teams to monitor workload, support, and financial and other activities.

• Participated in the migration process from SAP Business Objects 4.0 to 4.1 .Migrated universes, reports, and

securities from the Development to Production environment after UAT.

• Provided end user training for basic and advanced reporting skills.

• Developed Test cases based on requirements and provided technical assistance/support to analysts, business

community and troubleshooting for various problems pertaining to reporting, formatting, design of universes and other BO

complexities and actively involved in production support.

Environment

SAP BI/BO 4.0/4.1,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence/Desktop Intelligence, BEx Query

Designer, BEx Analyzer, Universe Designer/Information Design Tool, Business Explorer/Polestar, Xcelsius/Dashboards

4.0.

Kiewit Corporation, St Louis, MO Aug 2010 – Oct 2011

Sr. Business Objects Analyst/Developer

Kiewit is one of North America's largest and most respected construction and engineering organizations.

Project is developed for sales and marketing department of Kiewit. Data from the data warehouse is used to design and

develop reports using Business Objects tool suite.

Responsibilities

• Requirements gathering with project stakeholders and creating dataflow diagrams, functional specifications,

technical specifications, security requirements and other related project management documents.

• Participated in project planning sessions with project managers, business analysts and team members to evaluate

business requirements and outline the proposed solution

• Created Technical Specifications Documents based on requirements from stakeholders.

• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of

development as well as business related information regarding the design process.

• Created complex reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill

Down, Variables, Filters, Breaks, Alerter's and other features.

• Created Web Intelligence reports using advanced features like Formulas, Groups, Sub Reports, Hyperlinks, Alerts,

Cross Tabs, Charts and Parameters.

• Extensively used Crystal Xcelsius for creating Dashboards, Scorecards and reports.

• Imported/ Exported the Universes from/to repository to make them accessible to end-users.

• Worked with SAP BW team to make sure that they are getting correct data from R/3 into BW cubes.

• Created OLAP Universes, WebI reports and Xcelsius dashboards using SAPBW cubes in GL, FI CO, MM and SD

modules.

• Created Daily totals, ROI, Summary balance sheet, Inventory levels, Distribution summary dashboards using

Xcelsius.

• Extensively used BEx Query Designer to build queries on BW InfoProviders and executed them using BEx Analyzer

and Advanced Analysis.

• Created queries with Calculated Key Figures, Restricted Key Figures and Filters.

• Worked with Exceptions and Conditions as part of the BEx Query Reporting and have created various types of

Variables.

• Migrated Universes, Reports, and Securities from the Development to Production environment after UAT. Used

Import Wizard for the Migration process from XIR2 to XI 3.1.

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.

Ann Taylor - New York, NY Jun 2009 – Aug 2010

Sr. Business Objects Analyst/Developer

Ann Taylor is a leading clothing brand in the United States of America. The project dealt with the Sales & Marketing Data

collected from different stores across America. The data was then consolidated into the data mart which was used for the

report generation. The System was primarily designed to provide reports for Performance Analysts who could use the

Daily Operational Reports to investigate discrepancies, thereby creating a streamlined and efficient process.

Responsibilities

• Involved in requirement gathering, creation of use cases, usage scenarios and solution architecture.

• Scheduling meetings with the business users to gather the business analysis reporting requirements.

• Implemented best practices for using Business Objects Suite of products.

• Designing, creating, enhancing, testing BO universe, reports.

• Designed dashboard and scorecard using the Performance Management tool, Dashboard Manager.

• Designed templates for Webi documents and created Webi reports using advanced features like Formulas, Groups,

Sub Reports, Hyperlinks, Alerts, Cross Tabs, Charts and Parameters .

• Involved in gathering requirements and designing BO BI report requirement templates.

• Developed reports like Reports by Period, Demographic reports and Comparative Reports .

• Designed Universes and developed Hierarchies to support drill down reports.

• Trained the user community in making use of universe to create and publish reports.

• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions,

parsing of objects and hierarchies.

• Integrated WebI reports and created pdf documents and power point documents with Crystal Xcelsius.

• Involved in investigation of issues, and providing solutions to assist with problem resolution.

• Created Technical Design Documents, presented Design Review, Code Review and Procedure Document to

production support team and clients before moving the code to Production.

• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors,

problems.

• Actively involved in group meetings and discuss with project manager for resolving the production and release

issues.

Environment

Business Object XI 3.1/R2, Central Management Console 3.1/XI R2, Designer 3.1/XI R2, Web Intelligence 3.1/XI R2,

Crystal Reports 2008/R2, Xcelsius, Management Studio.

Rock Hill Insurance, Kansas City, MO Apr 2008 – Jun 2009

Business Objects Analyst/Developer

This project was developed as an internal project for Field Automation. The field automation department is responsible for

system development and support for Property Insurance. Most of the work was to create summary reports about

Management review details and region wide Sales reports using SAP Business Objects. They needed various

management levels with reports, time series graphs and pie charts using SAP Business Objects.

Responsibilities

• Responsible for analyzing the new requirements and writing the functional requirement documentation and estimating

the man-hours.

• Involved in the installation of Business Objects XI R2.

• Involved in User management tasks such as setting up authentication and adding users and groups.

• Involved in publishing, organizing, and setting security levels for all of the Business Objects Enterprise content.

• Involved in providing security to the Business Objects Enterprise

• Involved in the designing and building Universe, Classes and Objects and reports.

• Designed dashboard and scorecard using application foundation.

• Created Objects, predefined conditions, joins in the Universe.

• Applied aggregate awareness to speed up query time.

• Worked extensively on Central Configuration Manger, Designer, Web Intelligence, Desktop Intelligence and

Central Management Console.

• Created and maintained Universe for Account Analysis subject are for supporting multiple levels of hierarchies for drill

reports.

• Scheduled the Web Intelligence reports using the Central Management Console module.

• Involved in providing general troubleshooting steps and solutions

• Involved in support through all release cycle’s and maintenance of reports after go live.

Environment

Business Object XI 3.1/R2, Central Management Console 3.1/XI R2, Designer 3.1/XI R2, Web Intelligence 3.1/XI R2,

Crystal Reports 2008/R2, Xcelsius.

Infosys Limited Mysore, India Jan 2007 – Feb 2008

Business Objects Analyst/Developer

Responsibilities

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data

specifications for Business Objects Universes and Reports.

• Interacted with users, managers, and business analysts for understanding the business logic and also interacted with

technical leads to understand the Database.

• Created Universes by retrieving the data from database, defining the connections necessary, complex formulas and

generated various reports.

• Involved in writing detailed level documentation for reports and Universe design.

• Used @prompts in the Universe to create user interactive condition objects.

• Built Full Client reports using Business Objects reporting module according to end user requirements.

• Converted the existing full client reports to WebI reports using Report Conversion Tool.

• Created various types of reports such as Drill Reports, Cross Tab Reports, Standard Reports and Master Detail

Reports.

• User/System documentation, user training and testing developed reports for final deployment.

• Performance tuning of Business Objects reports including testing and modification of universe objects as required.

• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into

production.

Environment

Business Object XI R2, Central Management Console XI R2, Designer XI R2, Web Intelligence XI R2, Crystal R2, Oracle,

SQL, PL/SQL, MS Access, MS Excel.

Contact this candidate