Summary

• Over 7 + years of Experience in Business Intelligence with focus on 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 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 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:

Operating Systems : Windows XP/NT/98/95, UNIX, Red Hat Linux
Business Objects Tools : Business Objects (3.0, XIR2, XIR1, 6.5, 6.1,5.X, 5.0, 4.1.5),
Web Intelligence (XIR2, 2.6, 6.x),
DataIntegrator (XIR2/6.5),
Crystal Reports XIR2/XIR1,
Performance Management, Crystal Xcelsius 4.5, 2008, SAP Integration Kit, Broadcast Agent, CMC Performance Management, SDK, ZABO
RDBMS : Oracle 7.x/8.0/9.1.2, SQL Server, MS-Access, Sybase, NCR Teradata V2 R6, Netezza
4GLs / Front Ends : SQL*Plus, SQL Navigator, Toad
Languages : C, C++, Visual Basic 6.0, PL-SQL, VBA
Office Suites : MS-Office XP/2000/97
Testing tools : Quality Center, Test Director 8.0

Education: Master in Computer Science
Bachelors in Computer Science

Professional Experience

Confidential,NC Jun 2009 to till date
Sr. Business Objects Developer

Confidential, 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 BO versions from XIR2 to XIR3.

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in conversion of the 2-tier reports (Full Client) into 3-tier reports in InfoView.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Deployed the Import Wizard module for the upgradation.
• Created complex reports stating revenue generation per year using cascading and user

objects ,measure objects by using @aggregate aware function to create the summarized reports.

• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Integrate the data sources from existing system and to provide analysis to make business related decisions related to analysis and forecasting using a single integrated data model
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in SQL Server.
• Created reports containing all the information regarding publishers, distributors and retailers using crystal reports XIR2.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Created Contexts and Aliases to resolve complex loops, chasm and fan traps in Universes.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution of news papers to different locations
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Environment: Business Objects XI R2, Crystal Enterprise 10,Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, SQL Server 2005, Oracle 9i/10G, SQL, PL/SQL, Windows XP

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

Description: Confidential,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:

• Involved in Requirement Gathering from users, create report requirements document.
• Logically architect reports developed using Crystal reports and Web intelligence reports.
• Created Canned reports and Web intelligence documents in Business Objects Infoview in cross reference with the Traditional SQI metrics on Survey analysis data.
• Developing PL/SQL scripts and tuning PL/SQL procedures involving Data Migration from Teradata to Oracle.
• Involved in the implementation of BO XI 3.1 using Import Wizard from XIR2.
• Developed Xcelsius components (Chart\'s, Maps, Sliders etc.,) from Excel files.
• Involved in ETL process into DataMart ELLIS creation from Teradata.
• Involved in creation and configuration of BO universe overlying Oracle DataMart.
• Performed Data Quality Tests for correctness of Data and volume for tables using two parallel ETL, processes, one by PL/SQL and the other Oracle Data Warehouse ETL. Tables being populated were stored in two different schemas.
• Tested and maintained several BO Reports during the period of time.
• Created Procedures in PL/SQL for ETL for survey project data from vendor into datamart.
• Designed the Universes, created Contexts and Aliases for resolving Loops in the Universes.
• Transferring system and report debug & optimization knowledge for BOE and CR to internal report developers.
• Worked on Data Integrator tool - Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Managed Folders, Objects, Users, Groups, Servers and implemented Security, Email (SMTP) Functionality , Rights through Central Management Console(CMC).
• Performed complete unit and system testing for Business Objects Universe including creating Test Case scenarios, test stubs and checking integrity. All Testing results and defects were logged into Quality Center
• Involved in the development of Data Integrator mappings and tuned existing mappings for better performance.
• Performed gap analysis between the current state and future data warehouse environment and identified the data gaps and quality issues plus recommend potential solutions. Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope.
• Involved intensively with Business Analytics to understand the system and produce satisfactory results.
• Documented Detail Universe Design and Changes. Maintained Universe Update Log for the team.

Environment: Business Objects Enterprise XI 3.0 SP2, XIR2, Web Intelligence XIR2, Designer, Data Integrator XIR2, Crystal Reports XIR2,Xcelsius, Quality Center, Oracle 9.1.2, SQL Server 2005, Teradata V2 R6, MS Access 2003, TOAD and Windows XP.

Confidential,PA Sep 2007 to Sep 2008
Sr. 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:

• Created four universes for the Project. These include MTSA (IMS Health Sourcing Act), Charge Rollup Detail and Health Rpt Universes.
• Resolved Fan Traps, Chasm Traps and loops to produce the desired SQL from the objects as needed.
• Responsible for designing Star Schemas for all two universes Health Rpt and Charge Rollup Detail as per design solutions. Coordinated with Database team to understand the underlying data structures.
• Involved in creating Desktop Intelligence and WebI Reports for Tax Reporting requirements. Most of the reports prompt user for information before fetching data.
• Provided Drill up and Drill Down facility for most reports which require detail analysis on specific dimensions and Hierarchies.
• Used Central Management Console to verify that the reports and universes are in the desired folder and available in the desired corporate category.
• Involved in migration and production deployment of universes and reports with Application support Team.
• Handset Phase II project involved redesign of the current universe and reports due to changes in the backend data structures and schema to provide more robust information to users.
• Responsible to meet users and Business Analyst in understanding the changes made to the backend.
• Involved in Analysis of Handset Universe redesign and come up with inventory for changed/new objects classes, joins, contexts and obsolete objects.
• Designed and developed Handset Universe with updated information. Involved in recreating all contexts, joins and resolving issues.
• Modified all Reports which required changes by identifying obsolete objects, removing them and replacing them with new objects and regenerating SQL.
• Involved users and Business Analyst during these changes and refined reports till users were satisfied.
• Worked with Data Modeling team in understanding the requirements and creating the logical data model, physical data model and Dimensional data model (Star Schema) using Erwin Tool.
• Provided value added services like new graphs which provide more powerful information to the users and was involved in presentation and user training for new reports usage and features.
• Other Developments include working with SAP BW Bex Reports, Dashboards and Migrations
• Responsible for development of WebI Reports against SAP BW data warehouse. Created reports against SAP BW Info Queries and Info Cubes. SAP Integration Kit provides the ability to create WebI reports for non SAP users to view Bex Reports in Business Objects.
• Worked with SAP report writer as a team in order to develop reports and universe.
• Worked on Migration of reports and Universes using import wizard extensively.
• Used Test Director to log all defects during the development process and as the tasks kept completing and unit test produced successful results respective defects were close until all system test results were successful.
• Involved working as team with the Data Warehouse team, Test team, Users and respective managers.
• Worked on documenting a Segmentation Corporate Tier Dashboard. Document all Web pages containing dashboard components in this case containing one WebI document and two IMT graphs.
• Proposed Reporting Solution for Balanced Score Card provided by BO. (xCelsius)
• Involved in mapping of Performance Manager Universe version measures to Metrics in PM repository. Created Analytics for Metrics, typically IMTs.

Environment: Business Objects Enterprise XI, Web Intelligence XI, SAP Integration Kit, Designer, Desktop Intelligence, Teradata V2 R6, Windows XP/2000, Test Director 8.0.

Confidential,Charlotte NC Oct 2006 to Sep 2007
Role: Business Objects Developer

Description: Confidential,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:

• Created complex universes with Designer to give ad-hoc-reporting capability to the users. Also published the reports to Web Intelligence for high availability.
• Created and maintained several reports like Open AR, OAC, and Residuals for Customers for different portfolios and modified based on the CR (Change Requests).
• Implemented a Crystal Report optimization strategy for report development to obtain optimal performance on Enterprise.
• Interacted with User for Report Requirements. Involved in Requirement Gathering.
• Crystal Enterprise Edition is used to design, develop and Implement business analysis reports. Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Scheduled the reports, Analytics from Infoview, CMC and Scheduler.
• Set up Broadcast Agent report schedules to run the reports on periodic basis.
• Developed VBA Macros for specific tasks like exporting to Excel, opening several reports in batch and gathering properties information, to open several reports in batch and save the reports for all users.
• Always made the deliverables on time, in proper quality and to the user satisfaction.
• Used my expertise in solving the environmental problems which occur for the users who are accessing the reports using ZABO
• Developed Reports, which will allow monitoring the business metrics of the Organization.
• Performed gap analysis between the current state and future data warehouse environment and identified the data gaps and quality issues plus recommends potential solutions. Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope.
• Worked closely with users and IT groups for overall coordination of user acceptance testing and training.
• Involved in preparation of the Test summary report and daily status report.

Environment: Business Objects 6.5/5.1.8/5.1.7, Crystal Reports, Web Intelligence 6/2.x, Windows 2000, Oracle 8.1.7, Microsoft SQL Server 8.0, SQL Navigator 3, Microsoft Visual Source Safe 6.0

Confidential,Mumbai July 2004 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 6, DESKI, Dashboard manager, Crystal Reports, Oracle8, SQL Server 2000,
MS Office, Window 2000 and SQL Loader.