Summary

• Over 8 years of Experience in Business Intelligence with focus on SAP Business Objects XI 3.1/R2/6.x/5.x (Designer, Info view, Desktop Intelligence, Web Intelligence, Crystal Reports, CMC, Query as a Web Service), Xcelsius, Business Objects SDK.
• Expertise in Designing, Development and deployment of complex Universes for Performance Management and Reporting needs.
• Expertise in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, Cardinality, Resolving join path problems like Loops and Traps in the Universes using Aliases, Contexts, Aggregate Awareness in Business Objects Designer.
• Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
• Proficient in utilizing the Crystal Reports and Xcelsius 2008 Query as Web service.
• Tested Business Objects reports for data validation and compared results with TOAD.
• Having knowledge on the SDLC methodologies like Waterfall model, JAD and RAD.
• Knowledge on developing Webi & Crystal reports out of OLAP Cubes.
• Excellent skills in developing and generating Adhoc reports, complex dashboards, Business views, along with User Acceptance Test and data accuracy test.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Extensively worked on SAP Business Objects Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduling of Reports in CMC on Daily, Monthly, Weekly basis.
• Experience in Installation, Administration of Business Objects Enterprise and Migration from SAP Business Objects XIR2 /6.x to XI 3.1.
• Efficiently mapped business requirements and processes to technical solutions.
• Created Style-guide, Templates & Technical Designs for the Xcelsius 2008 Deliverables.
• Understanding of BOE Reporting, Semantic Layer and Authentication/Authorization concepts as it relates to Xcelsius development.
• Expertise in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Extensive experience administrating and supporting Business Objects Servers and Services.
• Worked on various Business Object Reporting functionalities such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Exceptionally motivated and skilled in effective time management and meeting user requirements with uncompromising detail.
• Ability to adapt to changing professional work environment to implement software solutions in an efficient manner.
• Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated. Exceptional ability to quickly master new concepts and applications.

Technical Skills:

BI/ OLAP Reporting Tools: SAP Business Objects XI 3.1/3.0/r2/r1/6.5.1/6.1b/5.x (Designer, Reporter, Supervisor, CMC, CMS, Web Intelligence/ Info view, Broadcast Agent, Auditor, Performance Management, Application Foundation, Webi SDK, BO SDK using ASP and JSP), Crystal Reports XI r2/r1/10/9/8,

ETL Tools: Data Integrator XI r2,Informatica 8.5.1/7.1/6.x/5.x, SQL Server SSIS/DTS

RDBMS: Oracle 10g/9i/8i/7, MS SQL Server 2005/2000, DB2, Sybase 10x. /7, Teradata r6/V2r5

Languages: J2EE, XML, Java Beans, Servlets, JSP, ASP, VBScript, JavaScript ,Java 2, PERL, C++, C, VB, Shell Scripting

Servers: Web Logic Application Server, Web Sphere, TOMCAT

Tools: MS Project, TOAD and SQL Navigator

OS: AIX, Sun Solaris, Linux UNIX, Windows NT/2000/2003

Education:

Master in Computer Science And Bachelors in Computer Science

Professional Experience

Confidential Mooresville, NC Jun 2009 to till date SAP Business Objects Developer

Lowe’s is a diversified house improvement Provider with stores around the North America and South America. Lowe’s is the second largest house hold retailer in the US by assets and the second largest in the market cap. I have involved in developing Business Objects Universes for Price Variance project and upgrade the SAP BO versions from XIR2 to XIR3.

Responsibilities:

• Extensively involved in setting a new SAP BO 3.1 Environment.
• Successfully installed and configured SAP Business Objects 3.1 on Staging Environment, Applied Service Pack and fix pack.
• Used Import Wizard tool to migrate all the objects from SAP BO XIR2 to BO 3.1.
• Tested all the reports that are migrated and analyzed the performance of the BO 3.1 using Load Runner by creating many virtual users.
• Resolved the performance issues in SAP BO 3.1
• Installed and Configured SAP BO 3.1 on Production Environment of different regions.
• Experience in scheduling of repository backup and tuning the Business Objects servers for a better performance.
• Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
• Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch.
• Requirement Collection, Documentation & high-level design.
• Configured Crystal reports 2008 to develop reports using Custom Coded functions.
• Updated and maintained Universes to meet new reporting requirements.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Created Repository with multiple universe and document domains for Development and Test
• Environments and distributed the BO Main key among the enterprise.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Documented all the differences between the two Versions XIR2 and XI 3.1, for the end users to understand the new environment effectively.
• Responsible for writing the SQL queries for the data validation and testing the reports.

Environment: SAP Business Objects XIR2/3.1, Crystal Reports XIR2/2008, Universe Designer, Web I ,Publication Wizard, Import Wizard, Dashboard Manager, Reporter, Designer, BO SDK, Web Intelligence 2.x/6 and Info View, Windows XP, Oracle 10g.

Confidential, Sacramento, CA Oct 2008 to Jun 2009 SAP Business Objects Developer

Description: Neo Pharma Pharmaceuticals is one of the nations leading diversified health care benefits companies, serving members with information and resources to help them make better informed decisions about their health care. Neo Pharma Pharmaceuticals offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life, long-term care and disability plans and medical management capabilities. Our customers include employer groups, individuals, college students, part-time and hourly workers, health plans and government-sponsored plans.

Responsibilities:

• Requirements Gathering and Business analysis
• Familiarized the business, its strategy and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Created Sets, Metrics, Rules, using Set Analyzer and Dashboard Manager.
• Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers.
• Experience in cleansing data in DI using proper data types and mappings and to create Workflows using object library and tool palette to execute data flows.
• Linked two universes sales and customer using kernel approach.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Extensively worked on OLAP cubes for building universes.
• Performance tuned Business Objects Data Integrator XI jobs to ensure optimal performance.
• Extensively used Data Integrator to cleanse and populate target database.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Created reports using WEBI, DESKI, full client.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Knowledge of Crystal Reports reporting system including Crystal Server reports distribution infrastructure.
• Experience with Crystal Xcelsius dynamic data presentation software.
• Extensively Used Informatica forr ETL Process.
• Created the stores procedures and functions at the back end.
• Fine-tune the existing universes to enhance their performance.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).

Environment: Business Objects XI r2/3.1, Web Intelligence, Web Intelligence Rich Client, Crystal Reports 2008, Crystal Xcelsius Designer 2008, QAAWS, Teradata V 12.0, SQL Server 2005, Rational Clear Quest, BMC Remedy, Oracle 10g, TOAD, PL/SQL, WebSphere, Tomcat, Windows and UNIX

Confidential PA Sep 2007 to Sep 2008 SAP Business Objects Developer

Description: This Project is an initiative tasked with reducing complexity, terminating inefficiencies, generating operational efficiencies with enhanced automation and improving speed to market. The Workflow is a sub-project of this program tasked with implementing a technology-based solution for improving operational efficiencies in the enrollment processing

Responsibilities:

• Requirements Gathering and Business analysis
• Familiarized the business, its strategy and implementation.
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Created Dev and Test and Prod environments as per the best practices.
• Implemented Security with CMC for single sign on for end user activity.
• Implemented Import wizard & publisher for migrating reports & universes.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Migrated reports from BO 6.5 to SAP BO XI2.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
• Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Rational tools.
• Experience in cleansing data in DI using proper data types and mappings and to create Workflows using object library and tool palette to execute data flows.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Assisted the Application team in data modeling and T- SQL coding in Oracle.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Knowledge of Crystal Reports reporting system including Crystal Server reports distribution infrastructure.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.

Environment: SAP Business Objects XIR2/6.5/6.1, Data Integrator, Dashboard Manager, Xcelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager.

Confidential Charlotte NC Oct 2006 to Sep 2007 SAP Business Objects Developer

Description: Duke Energy is a diversified energy company with a portfolio of natural gas and electric business, both regulated and non-regulated, and an affiliated real estate company. Duke Energy supplies, delivers and processes energy for customers in North America and selected international markets .Duke Energy uses full client access for distributing their reports across users and departments.

Responsibilities:

• Involved in Full life cycle of the project for migration process from legacy crystal reports to SAP BO XI (requirement gathering to implementation for post and pre migration process).
• Developed post and pre migration check list.
• Worked with SAP BO vendor and conducted an assessment on the current environment to understand the best strategy for the migration process to BO XI.
• Worked resolving the loops in universes using aliases and contexts.
• Worked on Loan acquisition and Loan processing reports.
• Understanding and analyzing the key benefits, baseline of existing environment for number of servers, defined users, active users, number of reports and universes.
• Initially conducted migration on test servers to test report breaks and successful migration.
• Developed technical Design Document, Developers check list document, unit test plan, script document, Validation infrastructure document etc.
• Developed report technical document to compare pre and post migrated reports.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Worked with BO Admin on security levels for both Desktop and Web Intelligence reports .
• Implemented the best practice of naming the universe connection same across the repositories so that the migration would be seamless across repositories using import wizard.
• Worked on Import Wizard for migrating to XI R2. Using this wizard Desktop Reports (.rep) and WEBI reports (.wid) are migrated to higher versions (XI).
• Worked with the supervisor in setting up the security & scheduling, which is done manually in the central management console and publishing wizard.
• Verification and validation is on the migrated reports to check the migration success.
• Provided Crystal Reports training for the other programmers.

Environment: SAP BO XIR2, SQL, PL/SQL, Business Objects Info View (WEBI), Designer, Windows XP.

Aditya Birla Sunlife Insurance, Mumbai July 2003 to Sep 2006 Business Objects Developer

Description: This project deals with different types of policies like Protection Solution, Children Futures plan, Wealth Protection Solution, Health Protection Solution Retirement Policy, Rider Policy. This Birla Sun life Insurances growing rapidly in our INDIAN domestic market.

Responsibilities:

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Analyzed user requirements and sorted the best possible ways of representing the data.
• Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections.
• Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository.
• Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
• Created complex reports using cascading prompts.
• Created variables, formulas and used contexts (in, for all, for each).
• Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice & Dice and Drill up/down functionality.
• Tested reports before posting them to the repository (query optimization & performance).
• Migrated Universe/Reports from Development/QA to production.
• Used Crystal Reports to develop custom and dynamic reports.
• Designed and analyzed the reports using Crystal Reports.
• Designed, developed and maintained a wide dashboard using Excel and Xcelsius.
• Customized the user interface to meet the needs of end users with Business Objects SDK with VBA.
• Creation of prototype dashboards to demonstrate use of Interactive Metric Trends (IMT) for executive-level users.
• Involved in Migrating users, Universes, report objects (Webintelligence, Full Client), personal categories, inbox documents.
• Supported Business Objects Administrator in creating users and allocating rights to them.

Environment: Business objects 6i, DESKI, Dashboard manager, Crystal Reports, Oracle8, SQL Server 2000,
MS Office, Window 2000 and SQL Loader.