Management Manager

Samba Boddu Sr. SAP BO Consultant

abqaby@r.postjobfree.com

Ph: 703-***-****

SUMMARY:Over 8+ years of experience in Business Objects BI 4.0/XI 3.1/XI R2/6.x/5.x with extensive knowledge in all phases of Software Development Life Cycle (SDLC)Involved in Analysis, Planning, Building, Testing, Migration, Maintenance, Support and Enhancing complex Business Objects Universes, Reports and Dashboards for the Enterprise Data environmentsMigration Specialist, Migrated from Business Objects earlier versions XI 3.1 to BI 4.0Experience in Optimization and Performance tuning of new and existing Business Objects universes and reportsWorked Extensively on Web Intelligence ReportsExpertise in planning, designing, developing, maintaining and distributing Universes using Universe

Designer Tool (UDT) and Information Designer Tool (IDT)Hands on experience with Linked universes and Multi source universesImplemented Object level, row level security using Universe designer and view level security implementation in IDT Business layerCreated and implemented security for users and groups inside the CMC and assigned the access levels as per the organizational guidelinesExtensively worked on latest features in Business Objects BI 4.0 SP4Proficiency in Scheduling, Publishing and Distribution of Business Objects reportsGood experience on Crystal Reports development including working with complex report designsExpertise in converting Desktop Intelligence Reports to WEBI ReportsExpertise in writing complex and optimized SQL queries using joinsExperience in creating Interactive Dashboards by using QaaWS and Live Office through Integration to the BO WEB PortalSound knowledge of Data Warehousing Design Methodology, Data Warehouse ConceptsSound Knowledge of OLAP universes sourced from SAP Info Cubes and BEx queriesSound knowledge of creating BICS connection through IDT and CMCExperience in working on several data sources like Oracle, Teradata,DB2, SQL Server and SAP BWExpertise knowledge in Incident Management, Problem Management, Change Management, SLA Management, IT governance and Release management processesExpertise in Unit test, Environment test of the BO reports and UniversesAbility to adapt to new technologies very quickly and has excellent troubleshooting and problem solving skills

TECHNICAL SKILLS:

BI Tools Business Objects (BI 4.0/XI 3.1/XIR3/XIR2/6.x/5.x),BI Launch pad, Infoview, Interactive Analysis, Web Intelligence, Desktop Intelligence, Report Conversion Tool, Information Design Tool, Universe Designer, Business View Manager, Crystal Reports 2008/2011, Crystal Report for Enterprise, Xcelsius 2008, Dashboard designer, Live office, Query As A Web Service (QaaWS), Voyager, Import Wizard, Life Cycle Management (LCM), Promotion Management, SDK, Central Management Console, Central Configuration Manager

Operating Systems Windows NT /2000/XP/2003, MS-DOS, UNIX

Languages SQL, PL/SQL

Databases/Source Oracle 10g/9i/8.x/7.x, MS Access 2000, Teradata 6.0/13.0, IBM DB2, MS SQL 2000/2005/2008, SAP BW

Tools MS Office Suite, Toad 7.4, Oracle SQL Developer, Teradata SQL Assistant,

Service Center, MS Project Management, ADMS, Clarify.

PROFESSIONAL EXPERIENCE:

Hewlett Packard (HP), Plano, TX May, 2012– Present

Sr. Business Objects Developer

Description: HP Company is a leading global healthcare technology services company delivering business solutions to its clients. Data Warehouse subsystem, otherwise known as the Decision Support System (DSS) is provided as a part of the solution. The data is on Oracle Relational Database Management System (RDBMS) and accessed through the SAP Business Objects applications. HP Business Exchange Services (BES) provides scalable B2B solutions and services to its clients and trading partners.

Responsibilities:Involved in gathering, analyzing, and documenting business specifications for Business Objects Reports.Involved in system analysis and design of the Business Objects Reports.Generated reports using Business Objects XI R2/R3.1/BI 4.0 to provide information for Cigna. Involved in developing simple queries to more complex reporting queries by functional area using Business Objects.Provided Business Objects solutions to user queries.Converted .UNV universe (XI 3.1) to .Unx universe (BI 4.0) using Information Designer ToolDesigned, Developed and Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependenciesDefined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting levelDeveloped derived tables in the Business Objects Universe to build complex queries.Linking Data Providers and Universes to build complex queries.Resolved loops using Contexts, and Aliases.Resolved Fan Trap issues in the Business Objects Universe design.Created different types of reports such as Master/detail, Cross Tab, Bar charts, 3D charts, Column Charts and Pie charts in Web IntelligenceCreated the reports using Business Objects functionality’s like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.Involved in Unit Testing and System Testing for Business Objects Reports.Expertise in analyzing user’s UAT findings and provided solutions to their queries.Developed several Complex Reports using various features include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports. Created several dashboards using Crystal Xcelsius.Designed and Developed Xcelsius dashboards / analytics and exported to several formatsAcquired an excellent understanding and work experience of EXCEL functions in Xcelsius

Environment: Business Objects XI R3.1/BI 4.0, Universe Designer, Information Design Tool (Unx), Web Intelligence Rich Client, Life Cycle Management, CMC, Crystal Reports, Dashboard Designer/Xcelsius, Live Office, Info view/BI Launch Pad, CMC, Designer SDK, Crystal Reports 2008/XI, Xcelsius 2008/XI, SQL, PL/SQL, Oracle 10g, Service Center, MS Project Management, ADMS and Clarify.

7-Eleven, Plano, Texas Sept 2009 – Apr 2012

Role: Senior BI-BO Consultant

Description: 7-Eleven, Inc. is the world’s largest operator, franchisor and licensor of convenience stores with approximately 40,900 outlets worldwide of which more than 8,400 are in North America. 7-Eleven also is one of the nation's largest independent gasoline retailers. Today, offering customers 24-hour convenience, seven days a week is the cornerstone of 7-Eleven's business. 7-Eleven focuses on meeting the needs of convenience-oriented customers by providing a broad selection of fresh, high-quality products and services at everyday fair prices, speedy transactions and a clean, friendly shopping environment. Each store's selection of about 2,500 different products and services is tailored to meet the needs and preferences of local customers.

Responsibilities:BI Model migration to Business Objects BI 4.0 Identify list of tables, joins, calculated columns and reports in BI Data Warehouse modelUsed secured database connection; create new Unx Universes from BI Data warehouse modelsUsed BI 4.0 Information Designer Tool to design Universes, join tables, creating prompts and applies Contexts and Aliases to remove loopsCreated folders, sub folders same as BI warehouse Model hierarchy and Created Objects along with business name and description.Created calculated Attributes as per the BI model definitionPublish/Retrieve .unx Universes from/ to repository to make them accessible to end-usersCreated WEBI reports from BI model reports using corresponding UniversesConducted Review meeting with BI model owner to review Universe for corresponding BI ModelMigrated Universes and WEBI reports to QA and Production using Life Cycle Management Console (Promotion Management)Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and ReportsDeveloped various Complex Ad hoc and Complex Canned Reports Using Mainly Universe (UDT and IDT) as the main Data ProviderInteracted with users to know their approach and assist in developing and modifying Reports accordinglyExtensively used various techniques like Sectioning, Ranking, Filters, breaks and sorts to develop the reportDeveloped Web Intelligence reports making use of several Queries (Union, Intersection, Minus)Created Dashboard reports using Alerts Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objectsCreation and maintenance of OLAP universes sourced from SAP Info Cubes and BEx queries. Worked on performance tuning of universes and reports to increase performance Created interactive dashboard reports by using QaaWS and Live Office through integration to the BO WEB PortalCreated complex Crystal Reports Created OLAP universes sourced from SAP Info Cubes and BEx queries in SAP BWCreated BICS connection through IDT and CMC for WEBI reportsExported reports into XLS, PDF, CSV and XML formats as per the client requirementUsed Scheduler for scheduling and distributing the documentsUsed Life Cycle Management console (LCM) to take BIAR files for backup

Environment: Business Objects BI 4.0/XI 3.0/3.1 - Universe Designer, Information Design Tool (Unx), Web Intelligence, Web Intelligence Rich Client, Life Cycle Management, CMC, Crystal Reports, Dashboard Designer/Xcelsius, Live Office, Teradata 13.0, SAP BW, Teradata SQL Assistant, MS SQL Server, Service Center, MS Project Management, ADMS and Clarify.

Sara Lee, St. Louis, Missouri Sept 2006 – Aug 2009

Role: Senior BO Developer

Description: Sara Lee Corporation is a global manufacturer and marketer of high-quality brand-name products for consumers throughout the world, based in Downers Grove. Sara Lee Businesses are Sara Lee Food & Beverage, Sara Lee Foodservice and Sara Lee International. Sara Lee has a wide offering of high quality consumer products throughout the world. Most of its international and local brands hold leading positions in their markets. In many countries Sara Lee also provides coffee systems and food products via the foodservice channel.

Responsibilities:Involved in gathering, analyzing, and documenting business requirements for building Business Objects Universes and ReportsCreated technical specification document for creation of Universe, Joins, Contexts, and Cardinalities of the tablesInvolved in full life cycle of Business Objects reporting ApplicationUsed Aggregate awareness in universesResolved issues during designing Universe such as loops, Cartesian product due to fan trap and chasm trapsDeveloped and Deployed Desktop Intelligence, WEBI Reports through InfoviewInvolved in Weekly/Monthly/Quarterly batch cycle monitoringInvolved in exporting/importing the documents to/from the CMSCreated Crystal Reports using Universe Created custom and ad-hoc reportsDeveloped Derived tables in the Business Objects Universe to build complex queriesWorked extensively on business objects enterprise architecture, migration of Crystal ReportsCreated Crystal Xcelsius Dashboard from SAP data stored in a MS Excel spreadsheet sourced through Crystal Reports or Web Intelligence Live Office, Query as a Web Service (QaaWS)Analyzed user’s UAT findings and provided solutions to their queriesInvolved in Unit test, Environment test of the BO reports (Deski and WEBI), Dashboards and UniversesAcquired an excellent understanding and work experience of EXCEL functions in XcelsiusWorked on 24x7 production support modelMigrated the universes and reports from Dev to QA and then to Production environment using Import WizardDocumented parameters, fields, and logic used for developing of reports and universe

Environment: Business Objects Enterprise XI R2/XI 3.0/3.1(Designer, WEBI, Desktop Intelligence, Rich Client, Import Wizard, CMC), Crystal Xcelsius 2008, Oracle, Toad, Live Office, QaaWS, Service Center, ADMS, Clarify.

Embarq, Chennai, India Apr 2006 – Aug 2006

Role: BO Developer

Description: EMBARQ provides a suite of communications services to customers in its serving areas. EMBARQ, which is expected to rank among the Fortune 500, brings common-sense ideas, reliable service and a renewed commitment to the communities it serves. EMBARQ focuses on offering its customers practical, innovative products and competitive pricing. The company operates in 18 states offering local and long distance voice, data, high speed internet, wireless and entertainment services.

Responsibilities:Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issuesCreated Universes by defining connections and retrieving data from databaseCreated Aliases and Contexts for solving the Join Problems in Business ObjectsCreated New Classes and User Objects in designing the universesExported Universes to the Repository to make resources available to the usersScheduled various reports on Daily, Weekly and Monthly basis to other server through FTPCreated Charts to display summary data using universe as main data providerExtensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports Planned, coordinated and executed Business Objects Deployment for end-usersPublished reports using Info View, and trained users for ad-hoc reportingCreated Crystal Xcelsius Dashboards using different chart types and maps

Environment: Business Objects BO 5.x/6.x/XI R2/3.0 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), Crystal Reports, Crystal Xcelsius, MS Access, Oracle 8.x/9i, SQL, PL/SQL, Windows 2000.

Hotels.com, Mumbai, India Feb 2004 – Mar 2006

Role: BO Developer

Description: Hotels.com is the Internet's largest specialized provider of discount accommodations worldwide. Hotels.com provides discount accommodations in more than 8,000 premiere properties in over 350 major destinations in North America, the Caribbean, Europe and Asia. Its Internet booking engine enables consumers to quickly and efficiently compare price, quality, location, amenities, and availability of hotel rooms, and confirm reservations online within seconds.

Responsibilities:Created a new universe using Designer based on the new reporting requirementsDetected cardinalities and resolved the loops using contexts and aliasInvolved in gathering Business Principles and Standardization for ReportsDeveloped several complex reports (include multiple grouping, drilldown, parameter fields, formulae) and retrieving data from more than one database using Crystal ReportsWorked on complex reports that require running totals, sub-totals, sub-reports, cross-tab and conditional display of groups, fields, messagesCreated, managed & formatted standard reports, master/detail reports and cross tab reports using Report ManagerCreated various dashboard reportsCreated design for running multi-flavor reports; Date, Weekly and MonthlyWorked extensively with the major functionality of Crystal Reports like Nested Groups, Static Parameters, Cascading Parameters and AlertsPublished reports using Crystal Management ConsoleScheduled reports by setting the run-time parameters and charted by customizing the optionsInvolved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and RefreshingProvided 24/7 Production supportModified existing universes and WEBI reports as per Business requirementsCreated and worked on Row level security, Object level security and various predefined security settings depending upon users and group needs using SupervisorScheduled and monitored reports by using Broadcast Agent

Environment: Business Objects BO 5.x/6.x/(Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and InfoView), Crystal Reports, Crystal Xcelsius, MS Access, MS SQL SERVER 2000, SQL, PL/SQL, Windows 2000

EDUCATION: Master of Science in Computers from Nagarjuna University, India

Contact this candidate