SUMMARY

Anil Kumar Masimukku is a SAP BI & BOBJ consultant with experience in implementation, support and enhancements projects across USA and India. Have Professional experience in designing, development of Data warehouse, Reporting, Business Objects Enterprise XI3.0/3.1/R2/6.X.

Professional Experience

• Excellent experience in Business Objects XI3.0/3.1/R2/6.X (CMC, CMS, Designer, Reporter, Supervisor, Broad cast Agent, Infoview, WEBI, DESKI, Publishing Wizard, Import Wizard, Report Conversion Tool, Crystal Reports 9/10/XI and Xcelsius 2008.
• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1
• Worked on Business Objects with Databases like SQL Server 2000/2005, Oracle, Sybase, flat files, Teradata and DB2.
• Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
• Experience in publishing objects to Business Objects XI 3.1/R2/R1 Enterprise system using Import Wizard, Publishing Wizard and Info view.
• Expertise in creating reports with features like Drill down, Slice and Dice, Ranking, Alerts, Section and Grouping.
• Strong experience in SAP BI/BW 7.0/3.5 – Business Objects/ Crystal Reports, SAP BW-BO Integration, Creation of BI Queries(BEx) and Universe on top of InfoCubes & BI/BEx Queries
• Creation of Bex queries on BI 7.0, 3.5 (Reporting)
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.

TECHNICAL SKILLS

Business Intelligence Tools:

Business ObjectsXI3.1/XI3.0/XIR2/6.x/5.x, Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, CMS, CMC, Live Office, Import Wizard, Report Conversion Tool and QaaWS, Crystal Reports 2008/XI/X,Xcelsius2008, Dashboard Builder, Predictive Workbench 3.1/3.0,BexQueryAnalyzer .

ETL Tools:

Data integrator XI, SAP BW 7.0, 3.5

Data Modeling Tools:

Dimensional data modeling, Physical & logical data modeling, ERWIN, Visio, Star Schema Modeling, Snow flake Modeling

Databases:

Oracle 10g/9i/8i, SQL server 2000/2005, IBM DB2, MsAccess, Teradata, Sybase

GUI Tools:

Developer 2000, Visual Basic 7.X/8.0/9.0, Visual Source Safe 6.0d, TOAD.

Web Application Servers:

Weblogic 7.0, Apache Tomcat 4.0, 5.5.26, Web Sphere, IIS 6.0

Languages:

C, C#, Java (J2EE), SQL, PL/SQL

Scripting Languages:

ASP, Java Script, VB Script, HTML, XML DHTML, CSS

Operating Systems:

Windows Server 2000/2003, Windows XP, Windows NT, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential,Santa Clara, CA Dec 11 –Till Date

Role: Business Objects Developer

The project revolves around creating universes and reports for their Online Financial Portal. Reports such as Company revenue, Department revenue, Profit by Year etc. The data was divided into 5 hierarchical sections: Daily, Weekly, Monthly, Quarterly and Yearly. Final phase is migration from Business Objects XI R2 to Business Objects XI 3.0.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements
  and translate to Technical specifications for Designing Universes.
• Created several Universes using Designer according to the Requirement.
• Improved the performance and reduced the coding with the use of @functions (@aggregate
  aware, @select, @prompt, @where).
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the
  user’s reporting needs.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Exported the universe to the Repository to make resources available to the users.
• Scheduled the universes on daily wise, monthly wise and weekly by using Scheduler
• Updated and maintained existing Universes based on changing user requirements and based on
  changes in data source.
• Applied row level and object level securities on different groups and users.
• Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
  Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment:
Business ObjectsXI 3.1/3.0/R2, SQL Server2005/2008, Oracle 11g/10g/9i, Toad Data Modeler, Web Intelligence XI R2/ XI, Infoview, Live Office, PL/SQL, QaaWS, Windows XP, Windows 2003 Server

Role: Business Objects Developer

Confidential,is developing a transaction reporting system for the federal government in Washington DC. We
have deployed an ODS for various government financial trading partners and developed more than
20 Business Objects reports to capture financial transactions and keep track of the money that flows in and out of the agencies.

Responsibilities

• Work with business users and analyze the Reporting Requirements and Metric Analytics to come up with the technical specifications for the BO Reports from different sources.
• Building universes on top of SAP BW - Bex Queries using SAP Authentications.
• Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.
• Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables pulling of Live Data from Universes as well as Web Intelligence reports on Demand from Database.
• Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and Shortcut Joins.
• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise.
• Created Xcelsius components like charts, menus and containers Mining data and performing statistical analysis using Predictive Workbench.
• Work on Performance Manager to create various Metrics, Analytics and use Dashboard Manager to build Corporate Dashboards.
• Created Rules for Dashboard Manager like Events, Conditions and Actions.
• Adopting strategies for List of Values involving customizing the list of values, Cascading list of values and exporting the List of Values with the universe.
• Use LCM (Life Cycle Manager) for exporting BO Objects from one environment to other.
• Use Database Expert, Group Expert, Select Expert, and Section Expert to create different Crystal reports.
• Developed and Converted Complex DESKI Reports to BOXIR2 -WEBI Using Report Conversion Tool.
• Migrated reports from 6.5 to XIR2 using Import Wizard.
• Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.
• Used CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects.
• Design and deploy the security model for Analytics and Corporate Dashboards.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters, Formulas, Calculated data items, Filters, Sorts, and Query prompt.
• Created reports using Business Objects functionalities like Multiple Data Providers (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail Created Complex Queries in Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In List, Different From), Sub queries, and Grouping Conditions .

Environment:
Business Objects XI R2/6.5, Oracle 10g/9i, SQL Server 2005, Infoview, Crystal Reports XI, Web Intelligence XI, Xcelsius, SAP BW, SAP Integration Kit, QaaWS, Predictive workbench, Visio .

Role: Business Object Developer

Confidential,corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services and wealth management. Developed data warehouse to assist Sales and Marketing Department to categorize their customers based on significant portfolio of services including checking accounts, savings accounts, personal loans and geographical area. Using different ad-hoc analysis, Warehouse is supposed to assist in defining strategy for each customer category.

Responsibilities:

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules like Crystal Reports XI, Desktop Intelligence and Web intelligence.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Strong Integration skills between External Portals with SDK and Xcelsius Dashboards.
• Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsius, QaaWS, Voyager, Live Office, Dashboard Manager.
• Developed Crystal reports from Universes & published developed crystal reports to the Central Management Console and crystal Enterprise Environment.
• Worked with Crystal Report for creating complicated reports including sub-reports, parameter based reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports.
• Involved in the migration of Business Objects system from version 6.5.1 to Business Objects XI R2. Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (FC and Webi), Connections and Universe restrictions to BO XI R2 environment. Also used Import wizard to create repository back up file, Business Intelligence Archive Resource file.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Created Pie charts, gauges sliders to create visual models in Xcelsius using QAAWS and crystal reports.

Environment:
Business Objects XIR2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, Info View, Dashboard Manager, QAAWS, Import Wizard), Business Objects 6.5.1(Supervisor, Designer, Reporter, Web Intelligence), Xcelsius 2008, SQL Server 2000, Sybase, MS Access, TOAD, SQL, PL/SQL, Windows 2003 Server, Crystal Reports XI, TOAD, PL/SQL, Oracle 10g/9i, Windows NT.

Role: Business Objects Developer

Confidential,owns and operates the largest wireless telecommunications network in the United States, based on a total of 87.7 million U.S. subscribers. The project scope is to design and build reports for decision support for personal and phone usage data. Application provides revenue information and tracking system for their customers call time in minutes for billing as part of the contract. Reports were made to facilitate the end user to extract the true up and customer’s liability as well as give detail customer information, Service usages, Billing information, and account details.

Responsibilities:

• Created Business requirements documents for the modifications required for the reports and Universe, which included testing strategy, Business Objects fix and Business requirements etc.
• Cloned all folders, reports and universes, updated connections for new universes, re-pointed reports to new universes and updated logos
• Converted complex reports from DESKI to WebI.
• Resolved different issues in UAT after upgrading reports from XIR2 to 3.1Environment
• Used import Wizard to migrate reports, folders, users, groups, universes from different environments
• Scheduled and published the business objects reports based on the user requirements.
• Added/modified Users, Groups, folders and rights using Central Management Console (CMC)
• Supported hundreds of customers with BMC Remedy ticketing system
• Worked with SAP support to resolve any BO related tickets/issues.
• Involved in Business user meeting in fixing and explaining the reports for its errors and fixes.
• Involved in redesigning the Universe objects based on Business requirements.
• Supported/created complicated Webi reports with the following functionality subqueries, ranking, alerters, charts, filters, and merged dimensions, opendoc command etc
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts
• Involved in Migration and testing of BOXI upgrade from XI R2 to XI 3.1
• Interacted with the end users and provided Production Support
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production
• Organized work to Onshore and Offshore teams using SharePoint.

Environment: Business Objects XI 3.1/R2 InfoView, Designer, Central Management Console (CMC), Import Wizard, Desktop Intelligence, Web Intelligence Rich Client, Crystal Reports, Business View Manager, Report Conversion Tool, Oracle 9/10g, SQL server, PL/SQL Developer, BMC Remedy

Role: Business Objects Developer

Confidential,is the leading Health Maintenance Organization in the United States. This project was developed as an internal project for Human Resources and Sales department. Most of the Work involved creating Summary Reports Management review details and Sales Reports on region Wide levels using Business Objects. Provide various management levels with Reports, time series graphs, Dash Boards and pie charts using Business Objects.

Responsibilities

• Interacted with the Business Users to analyze the business process, gathered the requirements and made necessary changes to schema objects to fulfill their reporting and business needs.
• Analyzed the source data and work with Data Warehouse team in developing Relational Model.
• Designed and Developed Universes by adjusting parameters, defining joins, cardinalities and implementing features like predefined filters and Conditions.
• Created different classes, sub classes by assigning dimensional, detailed and measure objects according to the requirements.
• Created contexts and Aliases to resolve the loops problems in universe, derived tables using inner/ outer and equal joins as per the requirement.
• Assigned privileges according to their profiles based on CMC.
• Developed custom hierarchies in universe level and Scope of analysis in report level to drill up and drill down the reports.
• Used Report Conversion Tool to convert Desktop intelligence reports to Web intelligence reports.
• Worked extensively with PL/SQL, TOAD for writing user defined queries, stored procedures, views, Indexes.
• Worked very closely with ETL team to have necessary Views and data loaded for the creation of Reports.
• Involved in UAT and also in Unit testing.

Environment:
Business Objects 6.5, Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, Import Wizard, Crystal reports, Oracle , PL/SQL, TOAD.

Role: SAP BI & BO Developer

Confidential,USA world’s largest technology distributor & a leading technology Sales, Marketing & Logistics Company. This fortune 100 company distributes and markets IT products from computer hardware suppliers, networking equipment suppliers, and software publishers. The scope of the project includes understanding scenarios & proposes solution in BI & creates reporting solution in BO.

Responsibilities:

• Activated of Standard Business Content to reuse the objects provided by SAP
• Migrated of data flow from 3.x to 7.0
• Created Custom Cubes/DSO to meet client’s requirement
• Created and maintained transformation to maintain data consistency
• Designed and built generic extractor to load inquiries data in BI as standard LO data source does not extract inquiries data
• Created generic extractor using tables/views/function module / domain
• Created a generic extractor to extract classification data in BI to overcome the SAP solution

Business Content Activation carried out for the Infoobjects, InfoCubes, DSO’s and Transformations as per project requirements

• Enhanced the standard data source to meet client requirement
• Wrote ABAP code to eliminate erroneous characters during data load
• Created Super Bex Queries for BO Universe creation
• Created BO Universe on Cube/Multiprovider/Bex Queries
• Created WebI Queries to cater client’s requirement
• Designed and developed process chain to automate the loading process
• Monitoring data loads and job failures
• Resolution of data load errors and Job failures in SM37
• Resolving Help Desk Tickets for BW Production support in Remedy Web

Environment:
SAP BI 7.0 & BO XI 3

Role: SAP BI Developer

Confidential,Oman is the country’s largest business house. The group’s businesses include Vehicles Distribution, Construction & Agricultural Equipments, Oil fields & Special equipment and Travel.As a SAP BI Consultant responsible for Data Modeling, generic data sources and Reports. The scope of this project included implementation of SAP BW 7.0

Responsibilities:

• Created generic data sources to fetch Employee attendance related information from SAP R/3 and then replicated the same to BI
• Data Modeling activities and development of BI reports for analysis of Employee Information viz., Utilization, Efficiency, Productive Hours, etc
• Business Content Activation carried out for the Infoobjects, InfoCubes, DSO’s and Transformations as per project requirements

Environment:
SAP BW 7.0

• Bachelor of Technology in Electronics and Communication Engineering
• Masters in MIS