PROFESSIONAL SUMMARY:

• Over 8 years of experience in Software development with hands on experience in SAP Business Objects.
• Worked in Business Intelligence Reporting tools like SAP Business Objects XI R4 (Universe Designer Tool, Information Design Tool, Dashboards, Explorer), XI R3/XI R2/XIR1(Universe Designer, Webi, CMC, Xcelsius Dashboard), BO 4.X (Supervisor, Designer, Web Intelligence).
• Expertise in Business Objectsenterprise Products(Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)and its deployment.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Hands - on experience in developing AnalyticalDashboardsusingXcelsiuswithQaaWSandLive Officeconnectivity.
• Having experience in Creating the reports using Business Objects functionalities like Queries, Drill down, Cross Tab, Master Detail and Formulas etc.
• Created reports using charts, graphs, master-detail reports with drill down options for drill down analysis.
• Created Dashboard for executive view covering selected KPI for the business function
• Migrated Dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment
• Created dynamic filtering, pop ups and what if analysis reports using Xcelsius Dash boards
• Created reports as per user requirement and reports by linking data from multiple data providers.
• Expertise in Development, Maintenance, Upgrade, Integration, Production Support and Re-engineering Projects.
• Solid Experience in writing SQL queries, stored procedures.
• Proficient in design, development, coding, implementation and Support.
• Knowledge on Data Warehousing Concepts and good hands on experience in Oracle as backend.
• Worked on different Business Intelligence Data sources like BW, SQL Server, Teradata, and Oracle.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI 4.0, 3.1(R3.1) Crystal Reports, Central Management Console, Universe Designer, UDT, IDT, Desktop Intelligence, Web intelligence, Webi Rich client, Dashboards 4, Xcelsius 2008, Qaaws, Live Office.

Databases: ORACLE 10g/9i/8i, MS Access, MS SQL Server 2008/2005.

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables

Languages: SQL, PL/SQL, C, C#

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95

PROFESSIONAL EXPERIANCE

Confidential, Denver, CO

Business Objects Developer

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (FRD) to technical requirement documents.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data. Created and distributed Report Templates to Users and Main Data Providers for created these reports are - Universes.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Created Database Connections and designed Business Objects Universes using UDT and IDT
• Involved in Creating Universes and Reports. Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies. Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Created Universes and complex reports against BW Queries.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results
• Created alerter filters and inserted Breaks in designing reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Developed dashboards which get the complete details of the sales info for the client to analyze the scenario and a simulation model for the projected sales for various products
• Created WSDLs using Query as a Web Service (QaaWS) from different Data sources.
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Created Dashboard for executive view covering selected KPI for the business function
• Provided the security access management by creating users/groups and folders.
• Created reports using BI Launch Pad and for distribution to users
• Scheduled jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email and placed in shared path.
• Worked with team closely with Functional Architect, DBA and Analysts.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions and setup Hierarchies for Multi-dimensional Analysis.

Environment: SAP Business Objects XI 4.0, BW Queries, BI Launch pad, Dash Boards, Web Intelligence XI 4.0, UDT, Windows XP.

Confidential, Irving, TX

Business Objects Developer/Admin

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Highly Involved in production support based on the Service center tickets modified/resolved the Reports
• Worked on production issues and worked with development teams on supporting minor enhancements
• Maintained appropriate security and access controls and manage user administration
• Delivered tasks, reporting status and work assignments in a timely fashion
• Handled all the CMC activities
• Involved in Unit, functional and Integration Testing
• Converted business requirements in business/technical requirement documents.
• Created Class and Objects and following the Naming standards.
• Designed Dynamic dashboards using Xcelsius Enterprise
• Created reports for various product lines using the universe as the main data provider
• Created links in BO reports to link summary and detail reports using Hyperlink.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Daily Activities like Server monitoring, Report schedules.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc. in Business Objects Universes and Central Management Console (CMC)
• Created customized Web Intelligence reports from various different sources of data.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation
• Involved in end user and documenting the procedures.

Environment: SAP Business Objects XIR4.0 (UDT, BI Launch Pad, Web Rich Client, BW, Dashboards).

Confidential

Business Objects Developer

Responsibilities:

• Interacted with Business Users to gather the Requirements and Business logics.
• Translated Business Logics to Technical Specification Document.
• Was Responsible for preparing the User Requirement Specifications, Design Documents, Technical Specifications and getting Sign-Off from the Stake holders.
• Created Universes by defining connections and retrieving data from database.
• Created New Classes and User Objects in designing the universes.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
• Extensively used Calculations, Variables for creating Business Objects reports.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Changed the universe parameter settings to optimize the performance of universe.
• Tuned Universes for Report level performance.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Created Reports using Web Intelligence Rich Client, used multiple sources to create reports, Combined Queries,
• Responsible for the deliverables to the business.
• Analyzed the needs of the client and created summarized reporting tables and developed complex reports.
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO

Environment: Business Objects XI R3, Oracle 9i.

Confidential

Business Objects Developer

Responsibilities:

• Interacted with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Converted business requirements in business/technical requirement documents.
• Analyzed the existingOLTP systemand designed and manageduniversesbased on the Business Requirements
• Designed, Developed and Maintained Universesby definingjoins, cardinalitiesbetween tables applyingcontexts and aliastables to remove cyclic dependencies
• Used@functions like @select, @where and @prompt functionto createpromptswhich helps the user to select the values dynamically
• Customized thelist of values (LOV’s)which helps the end users to select the values.
• Created complexCondition Objectsfor easy reporting,Aggregate-Aware objectsfor better performance
• DevelopedBusiness Objects Universeswithclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Created reports usingBusiness Objects functionalitylikeslice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports bylinking datafrommultiple data providers, using free hand SQL and functionalities likeCombined Queries.
• Worked extensively onWeb Intelligencefor any new requests and performance issues.
• Involved in installingWeb Intelligence, creating users, user groups and categories
• Generated reportsfor web users usingWeb Intelligence and Info View.
• CreatedWeb Intelligence documentsand published them to corporate documents.
• Implemented row level Security, object level Security at the Universe level for security purpose.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection

Environment: Business Objects XIR2 (Designer, WEBI, Web Rich Client, Crystal Xcelsius 2008, Oracle 10g.

Confidential

Application Developer

Responsibilities:

• Application completely developed on .NET Framework.
• Design and Developed all the web pages using ASP.NET and HTML.
• Used all the Data connections using Microsoft Enterprise Library.
• Backend code is developed on C#.Net.
• Used Asp.net AJAX controls
• Designed, created tables, views and stored procedures for SQL Server database.
• Application maintained in the production.
• Fixed all the bugs/issues provided by the FAST Team or Planners
• Proven experience in designing, implementing, and deploying global application infrastructure solutions in a Microsoft oriented computing environment
• Implemented webservices and user controls in the application
• Provided datasecurity and privacy for the application

Environment: ASP.NET 2.0, HTML,C#.NET, Microsoft Enterprise Library, Visual Studio.NET 2005, JavaScript, IIS 6.0, SQL Server 2005, Windows 2003 server.