Professional Profile:

• 6+ years of experience in working with SAP Business Objects Suite and SAP BI/BW, EDW and ETL
• Experience in 2 full life cycle implementation in SAP BO following ASAP methodologies which involves Documentation, Requirement analysis, Blue Printing, Gap Analysis,Realization, Data extraction, Data modeling, Data loading, testing, production Support, End userdocumentation, Reporting and Go-Live check
• Experience in Installation and Configuration, Creation of repositories and security configurations; Performance tuning and optimization of BI solutions including capacity planning, migration procedures,and usage analysis
• Experience in interacting with Business Users to analyze the business process and requirements andtransforming requirements into screens, designing/analyzing database and documenting
• Expertise in business warehouse components - Info Objects, Standard and Custom Info Cubes, DSO\'s,Info packages, DTP\'s and Transformations.
• Worked on BW system, Data Warehousing concepts including data modeling, ETL, Query, ReportDesign, BW Web Reporting and Open Hub Service
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes,partitions, and Info cube compression techniques.
• Experience in Design and Development of Universes using Business Objects Enterprise productsnamely - Business Objects XI R3/R2, Crystal Reports and Xcelsius
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Crystal reports, Xcelsius and Central Management Console (CMC)
• Experience in Integrating Business Objects with SAP BI
• Knowledge of Migration and Upgrades to Business Objects XI 4.0
• Expert in writing complex SQLs for optimized Reports and optimizing existing reports
• Developed various reports using Desktop Intelligence and Web Intelligence using the Universes built
• Experience in implementing Business Objects report management with Finance, Sales and Marketing
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alertsfor creating business objects reports
• Provided Technical Assistance/Support to analysts, business community and responded to inquiriesregarding errors, problems, or questions with programs/interfaces
• Created the Universe and report check list templates, which are used as check points before movingthe migrated objects into QA and Production environments
• Worked closely with the Architects to address the performance issues from the server side
• Generated reports with complex, business views, ad-hoc reports, dashboards, list of values (LOV)along with user acceptance test (UAT)
• Published Crystal Reports on to Business Objects Infoview and provided access to the end users
• Expertise in using Import Wizard to migrate reports and universes between different environments likedevelopment, testing and production
• Experience in creating users and user groups, restricted access of the users as needed using CentralManagement Console (CMC). Involved in managing users, groups, folders and published reports
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling
• Experienced on creating dashboards using Crystal Xcelsius 2008 by importing data files to create thevisualization utilizing QAAWS and Live Office.
• Created Executive dashboards for the upper management showing summary metrics for the KeyPerformance Indicators (KPI\'s)
• Strong planner and organizer with demonstrated ability to develop business solutions that increaseefficiency, productivity, and profitability
• Resolved performance issues by writing stored procedures and command objects in crystal reportsand performed unit testing, system integration testing, and user acceptance testing at various levels
• Articulate with excellent communication and leadership skills and the ability to develop creativesolutions for challenging client needs

Data Warehouse:

• Designed and implemented Star schema, Snowflake schema and Multi-Dimensional modeling
• Designed the overall data warehouse architecture (e.g., ETL process, ODS and Data Marts), technical requirements, technical and data architectures for the data warehouse
• Provided executive level product support for the data warehouse initiatives
• Defined and Directed key business drivers for the IT and data warehouse projects
• Derived project scope that directly support the key business drivers
• Evaluated and Recommended data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI tools)
• Designed the ETL process, including data quality, testing, information access and delivery effort for the data warehouse
• Defined and directed the implementation of security requirements for the data warehouse and supporting applications
• Defined and directed data warehouse meta data capture, access effort and meta data standards for the data warehouse

Business Objects Enterprise Administration:

• Responsible for designing Business Objects Architecture for high availability and failover
• Completed capacity planning for Business Objects to support large number of End-users
• Experience in installing Business Objects XI R2 and Business Objects XI 3.x on multiple windows servers
• Clustered multiple Business Objects servers together for load balancing
• Expert in migrating or upgrading from lower versions of Business Objectsto Business Objects XI 3.x
• Configured Business Objects Auditing and configured auditing on all services
• Setup Business Objects Audit reports to monitor system
• Experienced in Business Objects Clustering and performance tuning of Business Objects XI R2/3.x system
• Expert in Business Objects XI R2 & Business Objects 3.x Server configuration
• Expert in setting up User, Groups and Folders and their security
• Experience in full life cycle implementation of Business Objects XI R2 & Business Objects XI 3.x
• Expert in Supervisor module of 6.5.1 and previous versions.
• Expert in designing/maintaining security using Central Management console in XI R2 & 3.x
• Expert in using Custom Access list for user and group management in Business Objects XI 3.x
• In depth knowledge of Business Objects 6.5/ XI/3.x suite architecture.
• Used LDAP security authentication in Business Objects XI R2/3.x
• Applied multiple patches and monthly hot fixes when required
• Created and tested backup and restore for Business Objects Servers
• Set up a Business Test and System Test Environment in one Test Environment using two universe domains but one document domain in Business Objects 6.5
• Support Production Reporting environment on 24/7 basis.
• Resolved BOXI server administration issue within SLA
• Worked as Subject Matter Expert (SME) for Business Objects to use in OLTP/OLAP reporting
• Responsible for designing of Business Objects Architecture and user authentication.
• Worked to Integrate Java front End application with Business Objects using Java SDK
• Link of WebI reports would display on User screen and user can open any report without UserId/Pwd
• Deployed single sign on between Java Application and Business Objects

Business Objects Universe Design and WebI Reporting

• Proficient in working on Business Objects Reports design on OLTP/OLAP system
• Created Advance Objects in Business Objects Universe Designer for reporting
• Created ALL values prompt and match pattern prompt using wildcards for WebI reporting
• Customized List Of Values (LOVs) to have ALL values selection prompt in WebI Reporting
• Arranged LOV data as A-Z index using Cascading LOVs for easy selection on WebI Reports
• Knowledge of Applying Table Mapping Access Restriction using Designer
• Expert in using Index Awareness Primary Key and Foreign Key for faster execution of reports
• Excellent in training users to develop Reports/Universe and use Business Objects XI R2/3.x
• Created security at object level and row level in Business Objects XI R2/3.x Reports
• Extensive development knowledge creating reports and universe for complex calculations and business functions.
• Setting up Alerts and Data Tracking in Business Objects Web Intelligence Reports
• Used variables and functions in Business Objects 6.5.1/XI R2 and XI 3.x
• Expert in providing ad-hoc reporting capability
• Expert in Using Import Wizard for migration of reports from one environment to another
• Expert in resolving Business Objects Loops and Traps
• Created Publication for delivery to the End users
• Created Universe for development of Dashboards to monitor Drug dispensing/Distribution
• Created aliases and contexts to resolve universe problems
• Created universe using aggregate aware so that summary report runs on summarized tables
• Used Data Synchronization to merge data from multiple universe into single block in a document
• Used Combined queries and sub-queries to design Advanced WebI Reports
• Worked with Input and Output calculation context to display required calculations in the block
• Expert in resolving issues identified from Integrity check.
• Created multiple universes on SAP BI 7.0 Infocube and BEx Queries
• Developed many WebI reports over SAP BI 7.0 BEx queries and infocubes

Business Objects SAP BI Integration

• Installed SAP GUI on Business Objects servers for SAP connectivity
• Worked with SAP BI team to Import SAP transport required for SAP integration
• Installed Business Objects SAP integration Kit for SAP BI 7.0.
• Enabled SAP authentication through CMC
• Imported SAP users and Roles
• Configured SIA for Secured Network Communication (SNC) on Business Objects servers
• Configured SNC setting on CMC
• Configured program ID, Gateway Host and Gateway service parameter on registry of BW publisher service
• Worked with BI team to configure RFC destination and Create Business Objects enterprise definition on SAP BI servers
• Used optional variables, mandatory variables, and variables with default values of SAP BI in OLAP universe and Web Intelligence
• Leveraged delegated search for SAP variables in Web Intelligence reports on OLAP uinverses
• Created OLAP universe with hierarchies and hierarchy node variables
• Used hierarchy and hierarchy node variables in web Intelligence
• Used Keydate variable and keydate variable dependencies in Webi reports
• Created smart Measures using Database delegated functions
• Used custom calculation in OLAP universes
• Created Xcelsius models with QaaWS and SAP variables
• Created Crystal Reports on SAP R/3 ABAP functions
• Developed Business Objects OLAP universe and prepared reports on SAP Infocube

SAP BI and BEx Queries:

• Knowledge and basic understanding of InfoObject, InfoArea and InfoCube in SAP BI 7.0
• Knowledge of user defined Hierarchies and Time dependant Hierarchies
• Knowledge of Restricted, Calculated and properties of Key figures
• Knowledge of Use of variables for flexible reporting

Crystal Reports XI R2/2008

• Expert in development of Crystal Reports XI/2008
• Created Grouping and Hierarchy in Crystal Reports
• Created multiple reports over SAP BI 7.0 data
• Defined Grouping and Sections
• Created multiple Sub-reports
• Expert in Optimizing reports based on Report Processing Model
• Created reports on Multiple BEx queries/Infocubes
• Expert in optimizing poor performing Crystal Reports

Xcelsius/QAAWS/ BI Widgets/Live Office

• Expert in creating Executive Dashboards for management
• Expert in requirement gathering, documentation, design and development of Dashboards
• Created multiple connected Xcelsius model
• Used multiple charts, slider, gauges for Xcelsius dashboards
• Created connected Xcelsius models on Universe using QAAWS
• Used Live Office connectivity to created connected Xcelsius dashboards on old canned reports
• Expert in displaying Web Intelligence Report Part and Xcelsius dashboard part in BI widgets
• Used Business Objects XI 3.x widgets to display Web Intelligence report part and Xcelsius dashboard part on Users's desktop on Windows XP service Pack 2

Management and Others

• Good team leading skills and the ability to work well with different levels of people
• Excellent Communication Skills including verbal, Written and presentation skills
• Manage customer expectations with strong facilitation and negotiation skills
• Self-starter and eager to learn new technologies with strong Analytical skills
• Committed to customer service and teamwork
• Expert in managing team in Onsite-Offshore model
• Easily adopt changing technologies to bring more values to the organization
• Create functional specifications, operational definitions and detailed design
• Excellent in using Excel/MS-word and other MS-Office tools

Technical Expertise:

• Databases/ERP: Oracle 7.x, 8.x, 9i and10g, DB2, IDS, SQL Server 2005, MySQL, Teradata
• Development/DBA Tools: SQL, PL/SQL,SQL Developer 3.0
• Testing Tool: Test Director, Jira 3.6.2 and Mercury Quality Center
• Data Analysis and BI Tools: Business Objects XI R2, Business Objects XI 3.x, Business Objects XI 3.x BI widgets, SAP BI 7.0, Crystal Report XI/2008, Xcelsius Enterprise, QAAWS
• Packages: MS-Office (Excel, Word, PowerPoint, Visio), MS-Access

Educational Background:

• Bachelor of Technology in Electrical and Electronics Engineering

Professional Background:

Confidential, Hagerstown, Maryland (Aug 2011- Current)
BO Admin/Developer
Confidential, is a Business Unit of Volvo Group (Headquartered in Gothenburg, Sweden) which mainly concentrates in production of Engines and Transmissions for North and South American Markets. The Hagerstown Facility is one of its kinds, where product innovation and quality improvement, are key for its success. This facility still uses its legacy system called Cullinet for inventory management and accounts settlement. Recently they have planned to switch over to SAP and Business Objects (for Reporting).

Responsibilities:

• Co-ordinated with the Architecture Design team on the New SAP Finance System
• Actively work on design, development, and documentation of reports generated in Web Intelligence and Crystal Reports
• Generated Xcelsius Dashboard reports for Executive management for clear representation of data
• Responsible for manage, deploy and configure the entire infrastructure on Central Management Console (CMC)
• Customize user access levels and give specific user access to different users
• Executed performance testing with 3000 users (including 150 Hagerstown users) to make sure application and Business Objects reporting is working fine if application is used by all counties
• Many optimizations were done in BOXI to support 3000 concurrent users
• Prepared Documentation and provided production support for the created reports
• Created many Ad-Hoc Reports based on user requirements and feedback

Environment: Business Objects XIR3, Universe Designer, Web Intelligence Rich Client, CMC, CCM, Info view, Crystal Reports 2008, Xcelsius 2008, SAP BW, SQL, Ad-Hoc reporting

Confidential, Pensacola,FL. Jan 2010 - July 2011
Business Objects Administrator/Developer
Confidential, is one of the leading National Healthcare Billing Management and Technical Solutions Company in US. Its main focus is to develop and deliver quality healthcare technologies to providers and employers who can deliver healthcare to communities. In doing so, it has increased its client base substantially since it was founded in 1995.

Responsibilities:

• Involved in capacity planning of Business Objects Architecture in order to provide robust reporting Architecture
• Gathered requirements from users for refining and fine-tuning of existing WebI reports
• Utilized Data Services as ETL tool and Business Objects Enterprise as reporting tool for designing/loading Data Warehouse
• Use Xcelsius 2008 to create dashboards for Upper Management Reports
• Managed a team of 5 in Onsite-Off-shore model
• Involved in Installation of Business Objects tools on windows servers as well as create and maintain backup/restore strategy

Environment: Documentum, Oracle 10g, Teradata, Business Objects 6.5/XI R2/3.x, Crystal Reports XI R2/2008, SAP BI 7.0, SAP Integration Kit, Business Objects Data Services XI 3.x (Data Integrator), QAAWS, Xcelsius 2008

Confidential, Columbus OH Jun 2008 - Dec 2009
BO/DWH Developer
Confidential, is one of the largest insurance and Finance Services in the world. It is a well-diversified insurance company which offers insurance in Auto, Home, health and many other services. In order in incorporate its growing business and standardize a single reporting system, Nationwideimplemented Business Objects as its main Reporting system

Responsibilities:

• Involved in a team to create a Database structure and different report templates for most of the Business users
• Interacted with end users to gather Requirements, and develop user documentation
• Create and manage new users, control access levels, assign and maintain report level and user level security in CMC
• Tested universes and reports for issues related to migration to higher environment
• Built new report templates using multiple data providers
• Create new Connections by editing existing one to run the report in different database
• Involved in the process of development, testing, UAT and finally production
• Created Xcelsius dashboards using QAAWS and Live office connection
• Developed Xcelsius Dashboard integrated with web services and XML Data Connection
• BW Queries, BW cubes and R/3 data were used as the main data sources.Extensive knowledge of Info-cubes,Info-Areas, Info-Objects, Key Figures, Characteristics and Hierarchies

Environment: Business Objects XI R2/R3.1, Web Intelligence XI R3, Crystal reports 2008, Xcelsius, DB2, SAP BW, Oracle10g, SQL, Import Wizard, CMC, Windows.

Confidential, Frisco TX Aug 2006 - May 2008
BO/DW Developer

Responsibilities:

• Involved in developing data warehouse for the project and integrate that with the Business Objects
• Used SAP BW for Sales and distribution department to view and analyze the sales data
• Created reports in Web Intelligence on Business Objects 6.x. by pulling information from Universes

Environment: Oracle 9i, SAP BW, Business Objects 6.x