SUMMARY:
Over 7 Years of experience in Information Technology Industry. Have extensively worked on all stages of SAP BusinessObjects Business Intelligence development in Manufacturing, Healthcare and Telecom Industries
Experience in SAP Business Intelligence and SAP BusinessObjects 4.0( XI 3.x/R2)
Extensively worked on Xcelsius (Dashboard Design) and Crystal Reports
Experience in Implementation, configuration, administration, trouble shooting and supporting of BusinessObjects Enterprise XI 3.x/R2/6.x and Crystal Reports
Expert in designing, developing, maintaining and optimizing the Universes using both Designer Tool and Information Design Tool (IDT 4.0)
Effectively administered and supervised the BusinessObjects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports
Experience in creating different type of Web Intelligence (WebI) and Crystal reports including: Cross-tab, Conditional, Drill-down, Top/Bottom N, Summary, Form/Mailing label, OLAP CUBE and Sub-reports

• Experience in Training & Supporting Business User reporting needs using BusinessObjects
• Experience in usage of LCM and Import Wizard Tools (BO Admin)

Good experience with advanced Xcelsius concepts like What If Analysis, Dynamic Visibility, Narratives, Interactive Charts, Hierarchies

• Strong experience in SQL, SQL*Plus, Stored Procedures, Triggers and Packages
• Expertise evaluating the performance of SQL statements and PL/SQL modules

Good knowledge and experience in Data Warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas
Experience connecting Dashboard with SAP BI Service, QaaWS and Live Office
Experience in writing Functional documents, Technical documents, and User Test Case/Guide documents
Knowledge about BusinessObjects Data Services (BODS/BODI) and BO Explorer

• Strong exposure to Software Project Development full life cycle
• An effective communicator with clients and team members

Microsoft Certified Professional in Developing and Implementing Web Application with Microsoft Visual C# .NET and Microsoft Visual Studio .NET 2003

• Business Intelligence Tools: SAP Business Intelligence 4.0(Central Management Console, Central Configuration Manager, Central Management Server, Web Intelligence(WebI), Information Design Tool(IDT), Universe Design Tool(UDT), BI Launch Pad, BO Explorer, Dashboards, CR 2011, CR Enterprise, Upgrade Manager), BusinessObjects XI 3.1/R2 (Central Management Console, Central Configuration Manager, Central Management Server, DeskI, Import Wizard, WebI, Designer, InfoView, Performance Manager, Crystal Reports, Xcelcius 2008, LCM, Voyager), BusinessObjects 6.5/ 5.1.7 (Reporter, Designer), Broadcast Agent (Document Agent/Publisher), BCA, Crystal Xcelsius 4.5/2008, Live Office, QaaWS.
• RDBMS/Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008, Sybase, DB2, MS Access, TOAD
• ERP: SAP R3, ECC, SAP BI 7.0
• ETL Tools: Informatica Power center 6.x/7.x., SAP BusinessObjects Data Services(BODS/BODI), SAP NetWeaver
• Data Modeling Tools: MS Visio, Rational Rose, ERWIN 4.0
• Languages & Web Technologies: C, C++, C#, Java , JSP , JavaScript, SQL, PL/SQL, C#.NET, ASP.NET, HTML, DHTML, CSS, CGI- PERL, ASP, VB-Script, Shell Script ,Dreamweaver
• Others: QTP, MS-Office 2003, Lotus Notes

MS in Computer Science

Bachelor of Production Engineering (Manufacturing Technology with Management Sciences)

Client: Confidential,MD Jun ’11 - Now
Role: Sr. Techno/Functional BusinessObjects Consultant
Confidential,is to Design and Develop SAP BusinessObjects XI 3.1 based WebI Reports and Update the existing Universe.

Responsibilities:

• Interacted withBusiness Users and gathered Business requirements in meetings
• Involved in analysis of Business Processes and translated them to Functional and Technical Design documents including Report layouts
• Involved in updating existing Universes using Universe Designer
• Where-in created Hierarchies for the Report
• Used Web Intelligence (WebI in InfoView) to create ad-hoc and canned reports
• Where-in used Hierarchies to support Drill-down in report
• Created new objects for the added columns in the database using Universe Designer and exposed them to WebI reports
• Used Open Doc. Parameters to link reports in WebI
• Improvised the reports based on Business User input
• Involved in preparing Test case documents for reports and in performing Unit tests
• Where-in wrote SQL Scripts to run on Teradata for Unit testing
• Created and tracked Incident Records
• Was involved in Unit testing the reports and fixing them in QA environment

Environment: BusinessObjects XI 3.1, Universe Designer, WebI, InfoView, Teradata 13.0

Client: Confidential,Dallas, TX
Role: Sr. BusinessObjects Consultant Aug ‘11 – May ’11
Confidential, is a regulated electricity transmission and distribution company. It has been delivering electricity to consumers throughout East, West, and North Central Texas. Project is to Design Develop and Maintain SAP Business Intelligence 4.0 based Universe, Web Intelligence (WebI) Reports for a Dashboard and Update the existing Dashboard.

Responsibilities:

• Interacted with Database Architect, Business Analysts and Sales Users to gather the requirements and Business logics
• Involved in analysis of Business Processes and translated them to Technical Design documents.
• Design, develop and maintained Universe using Information Design Tool(IDT)
• Where-in created secured connections to SQL Database
• Worked extensively in creating ad-hoc WebI reports
• Where-in created Cross-tab reports, Drill-down reports and used Merge dimensions
• Reviewed and changed Dashboard using the Dashboard Design(formerly Xcelcius) according to the requirement
• Where-in used BI Services to expose the WebI reports to Dashboard
• Created Summary and Detailed Sub-Reports on the Dashboard
• Extensively used BI Launch pad to access the WebI reports
• Used QaaWS to expose data to Dashboard Design
• Assisted the Users as a BusinessObjects Admin
• Where-in created User-Groups and assigned Roles to the Users
• Assisted BO Admin to promote Dashboard using LifeCycle Management Tool (LCM)
• Worked with Business User for testing the Dashboard
• Involved in Writing Detailed Level Documentation for Reports and Universe design and User Guide for Dashboard
• Worked on tickets, by implementing and testing the Change activity

Environment: SAP BusinessObjects BI 4.0, SAP BW/BI 7.3, Information Designer Tool, Web Intelligence(WebI), BI Launch Pad, LCM, Dashboard Design(formerly Xcelcius), SQL Server 2008.

Client: Confidential,MN
Role: BusinessObjects Consultant Jan ’11 – Jul ’11
Confidential,is a large Health Care Company based in Minnetonka, Minneapolis. Developed and Maintained SAP BusinessObjects XI R3 based Universe, Web Intelligence (WebI) Reports and Dashboards on Kidney Transplant Health Databases.

Responsibilities:

• Interacted withBusiness Users and gathered Business requirements in BI Scrum meetings.
• Involved in analysis of Business Processes and translated them to Technical Design documents.
• Design, Develop and Maintained Universes using Universe Designer
• Where-in created Secured Data Connection to SQL and SAP BW Databases
• Used Web Intelligence (WebI) to create ad-hoc reports containing multiple data providers and complex charts to present the Business users with a better graphical representation of the data
• Where-in used Hierarchies to support Drill-down in reports, Functions and Variables
• Created new objects for the added columns in the database using Universe Designer and exposed them to WebI reports
• Involved in creating both Static and Dynamic Dashboards for Kidney Transplant Project using Xcelcius
• Rebuilt BEx Queries based on Dashboard requirements using BW Query Designer
• Rebuilt reports based on requirement
• Used QaaWS to expose the Universes through Web Services for use in Dashboard
• Assisted BO Admin in creating Batch-jobs using LifeCycle Management Tool (LCM)
• Involved in testing the developed Universes and Reports for final deployment.

Environment: SAP BW/BI 7.0, BusinessObjects XI 3.1, Universe Designer, WebI, InfoView, LCM, Xcelsius 2008, BW Query Designer, SQL Server 2008

Client: Confidential,Marshall, MN
Role: Sr. BusinessObjects Consultant May ‘10 – Dec ‘10
Confidential,is a leading food manufacturing company. Schwan’s food products are serviced across the globe and it is fourth largest food manufacturing company in US. The project was to Design and Develop the Reports for existing Dashboards using SAP BusinessObjects tools.

Responsibilities:

• Interacted with Business users and Business Analysts to gather the requirements and Business logics
• Involved in analysis of Business Processes and translated them to Technical Design documents.
• Reported the Management on project status in Status meetings
• Extensively worked on Sales and Service Dashboards which were designed for the Field Managers and Corporate use
• Where-in used QaaWS and BEx as Data Providers for the Dashboards
• Involved in creating BEx Queries based on Sales Dashboard requirements
• Where-in used Query Designer and Query Analyzer
• Used Web Intelligence (WebI) to create ad-hoc reports containing multiple data providers and complex charts to present theBusiness users with a better graphical representation of the data
• Where-in used Hierarchies to support Drill-down in reports, Functions and Variables
• Extensively used InfoView to access WebI Reports
• Designed, developed and Scheduled reports for Dashboard
• Assisted BO Admin to promote Dashboard using LifeCycle Management Tool (LCM)

Environment: SAP BW/BI 7.0, SAP BusinessObjects XI 3.1, WebI, InfoView, Xcelsius 2008, SharePoint, SQL Server 2008

Client: Confidential,Dallas, TX
Role: BusinessObjects Consultant Aug ‘09 – Jan ‘10
Confidential,is a leading provider of infrastructure software. Novell helps its customers to reduce cost, complexity and risk of computing on any platform. Was involved in multiple projects to design and develop Reports using SAP BusinessObjects tools.

Responsibilities:

• Interacted withBusiness users and gathered business requirements in BI Scrum meetings.
• Involved in analysis of Business Processes and translated them to Technical Design documents.
• Design, develop and maintain Management reports using BusinessObjects tools
• Developed Managing Distributor(MD) and Accrual Reports using Crystal Reports
• Created ad-hoc reports on WebI for business users with quick, consistent and accurate data
• Further created drill-down to detailed reports using WebI
• Resolved data differences in reports using SQL, MS Access and Excel
• Enhanced existing Crystal Reports by adding Sub Reports and Dashboards based on requirements
• Designed Dashboards using Universe, WebI reports and Live Office in Xcelsius
• Regularly interacted with business users for training on existing reports and for new requirements they need.
• Created detailed and summary reports on Partner Payment using Crystal Reports
• Extensively used selection expert and formula features on Crystal Reports
• Designed Visualization reports on Sales using Xcelsius
• Where-in used Universe, QaaWS and Live office to generate the Dashboard on SAP BW Data source
• Broadcasted reports to Business users using InfoView Scheduling feature

Environment: SAP BW 3.5, SAP BusinessObjects XI R2, WebI, Crystal Reports, Xcelsius 2008, Oracle 10g, TOAD

Client: Confidential,Austin, TX
Role: BusinessObjects Consultant Dec ‘07 – Apr ‘09
Confidential,develops medical technology and services that focus on putting more control into the hands of those who treat cardiac, neurological and other body ailments. The Project was to Design and Develop Universe and WebI reports for Sales Performance and Revenue Dashboards on SAP BW.

Accomplishments:

• Gathered Business requirements from the Functional experts and conducted GAP Analysis.
• Involved in analysis of Business Processes and translated them to Technical Design documents.
• Implemented the Sales Performance and Revenue Dashboards on SAP BW data source.
• Designed and developed two Relational Universes, which suits the standard, analytical and ad-hoc reporting purpose for Business Users.
• Where-in implemented aggregates, linked universes, drill-through and dynamic modules.
• Resolved Join path problems like Loops and Traps in the Universes using Aliases and Contexts.
• Exported the universes to the Repository to make resources available to the users.
• Created complex reports using BusinessObjects functionality\'s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Created complex reports for various Portfolios using the Data Providers.
• Created complex reports using InfoView and Zero Admin BusinessObjects (ZABO) for distribution to users.

Environment: BusinessObjects 6.1b, Web Intelligence 2.7.4, Teradata, Windows Server 2003, SAP BW 3.5, Zero Admin BusinessObjects (ZABO)

Client: Confidential,Plano TX
Role: BusinessObjects Consultant Aug ‘06– Nov ‘07
Confidential,is a leading provider of value added products to the telecom sector. It developed an application benchmarking of Network Data to simultaneously analyze multi-technology, multiple network data throughput performance so as to investigate competitors within their respective markets and address business issues (i.e. service level agreements or SLAs) related to network performance.

Accomplishments:

• Gathered requirements from Business Users in Developing and Modifying Universes and Reports accordingly
• Where-in detected cardinalities and checked the Integrity of Universes
• Created Hierarchies from providing drill down options for the Business User
• Implemented object level, row level, user level security in BusinessObjects
• Created WebI Reports using Sorting, Hierarchies, Drill up, Drill down, Filter, Calculations, @ functions and formatted the complex reports
• Developed executive reports using Web Intelligence and Desktop Intelligence
• Generated and Published Reports in Info View using Web Intelligence
• Used crystal enterprise services for web publishing and scheduling
• Acquired an excellent understanding and work experience of excel functions in Xcelsius
• Tested reports in development and QA environments and ultimately moved to production

Environment: BusinessObjects XI R2, Web Intelligence XI R2, Oracle 9i, TOAD, SQL Server 2005, Teradata, LDAP, Windows XP, Crystal reports, Crystal Xcelsius, Rational clear case, Informatica 7.0.

Client: Confidential,Austin, TX
Role: BusinessObjects Reporter Aug ’05 – Jul ‘06
Confidential,is a leader in the design and manufacture of high performance analog semiconductors. Intersil products address three of the industry’s fastest growing markets - flat panel displays, optical and power management. Intersil is a semiconductor company with substantial revenues, leading global customers, a strong balance sheet and exciting growth potential. Designed, Developed and Maintained Universe, WebI Reports and Crystal Reports.

Responsibilities:

• Interacted with Business users and Business Analysts to gather the requirements and Business logics
• Involved in analysis of Business Processes and translated them to Technical Design documents
• Involved in the Designing and Building of Universes on Oracle Data Source
• Created Universes from the underlying Oracle Apps HR and Finance Data marts based on the business requirements
• Constantly worked on complex reports in providing for a report generation based on user needs using WebI
• Created reports based of free hand SQL and Universe objects
• Replicated reports created in internal reporting tool using Report Retriever (an in house reporting system) to BusinessObjects
• Used multiple data providers such as Universe and personal data files in generating report.
• Responsible for developing all types of reports including Cross-tab reports using Crystal Reports
• Involved in creating ASP.NET Web pages for accessing Crystal Reports using Visual Studio .NET and C# on existing Web Portal
• Involved in Writing Detailed Level Documentation for reports and Universe design

Environment: BusinessObjects 5.1.7, BusinessObjects Info View (Web I), Report Retriever reports, Visual Studio .NET 2003, C#.NET, DB2, Oracle 9i, TOAD, Windows NT

Client: Confidential,Dallas TX
Role: Developer Jan ’05 – Jul ‘05 Confidential,were newly introduced for the Customer Contact Management Systems for IVR. The Project involved development of “Server Management Tool” a Web Portal using Visual Studio .NET 2003. This tool tracked changes on the servers and gave detailed information of over 600 servers with multiple applications on each.

Accomplishments:

• Gathered requirements and Server data from both Database Administrator and IT teams
• Produced Business and Technical documents in MS Word, MS Visio and MS Power Point
• Used C#.NET to implement the Business logic
• Used ASP.NET to create Forms
• Where-in wrote Store Procedures against the existing database using Visual Studio .NET features
• Performed Unit Testing through Visual Studio .NET
• Prepared testing documentation and led testing activities with the Application and Testing Teams.
• Performed designed and developed usage reports on servers using Crystal Reports for Visual Studio .NET
• Created Crystal Reports for showing updates on servers after a Change Activity in Production and also Status changes in Servers.
• Where-in created Sub-reports and Crosstab Reports
• Wrote test scripts for testing the web portal and the reports
• Trained the end users from the Application and Production teams
• Provided detailed documentation of Web Portal and Report generation
• Resolved tickets opened in CMIS based on priority level

Environment: Visual Studio .NET 2003, C# .NET, Crystal Reports, Oracle 9i, Windows NT.