SUMMARY

• 7+ years of IT experience in the area of SAP Business Objects as a Developer. Extensive experience related to business analysis, requirement gathering and documentation of functional and non - functional requirements, Universe development, validation of data for consistency and report development.
• Experienced in gathering & analyzing requirements, implementation, testing and developing reporting solutions for leading clients.
• Experienced in SAP BO XI Universe Design tool (UDT), Information Design Tool (IDT), Web Intelligence, Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.
• Expertise in the front end business warehouse components likeBEx analyzer, Query designer, Web Application Designer, Web Reports,WEBI,Xcelsius Dash Boards, crystal Reports, voyager.
• Expertise in using Business Objects Suite 4.0/XI 3.1/XI R2/6.x and various types of Reports and Charts using Web Intelligence, Desktop Intelligence and Crystal Reports 2008.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Experience in building dashboards using Xcelsius 3.1/2008/4.5 , QaaWS, Web service connections,Live Office, XML.
• Created Universes from wide variety of databases with facts and dimension objects, joins, conditions, Filters, LOV's, cardinality, resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, @ Functions, Aggregate Awareness in Business Objects Universe Designer
• Created WEBI reports andCrystal reportsand deployed them through InfoView with SAP BW universe as source and created Inventory accuracy dash boards usingXcelsius
• Worked extensively with Business Objects functionalities like Alerters, Filters, Query Prompts and Drill filters and worked with multiple data providers
• Proficiency in Archiving and Bursting ofBusiness Objectsreports using JDK
• Extensive front-end experience with BEx Query Designer ; Experienced in BW-BO integration development using BOBJ tools - Universe Designer, Information Design Tool, WebI, Xcelsius/dashboards, QaaWS, LiveOffice & Crystal reports, Central Management Console
• Experienced in designed universes in BO XI and applied row level and object level securities on different groups and users, also worked on new features like Index awareness, Derived tables and Central Management Console (CMC)
• Experience in BOBJ 4.0 version with BI Launch Pad, SAP Business Objects Dashboard design 4.0
• Experienced in developing Desktop Intelligence, Web Intelligence and Crystal Reports using different Data Sources
• Experience in analysis of database schemas like Star Schema and Snowflake Schema used inrelational databasemanagement systems, dimensional and multi-dimensional modeling
• Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI's and visually accentuate critical business controls
• Extensively worked on DB2, SQL,PL/SQL, Oracle and MS SQL Server databases
• Proficient in design, development and implementation phases
• Strong analytical skills and in depth experience in Business Process analysis coupled with documentation and self organizing skills
• Hands on experience in creating and building Web Intelligence (Webi) Reports in SAP BI 4.0 using universes and Business Explorer (BEx) Queries
• Hands on Experience in Performance Tuning and Troubleshooting of BO applications and BO Reports, Oracle andTeradataQueries
• Experience in working with Data warehousing tools like Informatica Power center
• Have strong interpersonal skills with excellent verbal and written communication

TECHNICAL SKILLS

BI/OLAP: SAP Business Objects 4.0/XI3.1/XIR2/6.x, CMC, Designer, InfoView, Web Intelligence, Desktop Intelligence, Import Wizard, Crystal Reports XI/10/9, Crystal Enterprise XI/10/9, Dashboard,Voyager

Data Modeling: Star-Schema Modeling, FACT & Dimension

Database: Oracle10g/8i/ 9i, MS SQL Server 7.0/2000, MySQL 5, Teradata

Operating Systems: Windows 2003/XP/NT/2000/98/95, Unix

Languages: SQL, PL/SQL

ETL Tools: Informatica Power Center

Others: MS Office 2003, MS Project

PROFESSIONAL EXPERIENCE

Confidential, NY

Business Objects Developer

Responsibilities:

• Worked with business users in collecting project specifications by conducting user requirements gathering sessions, follow up meeting and workshops.
• Created Functional and Technical Design specifications (TDS) for ETL processes. Data cleansing according to defined Business rules.
• Analyzed requirements and technical specifications by partnering with Business analysts to develop reports that confirm to the enterprise standards.
• Involved in moving the BO XI 3.2 objects to BI 4.0 and resolving issues faced during the process.
• Converted BO XI 3.2 universes to BI 4.0 universes and resolves issues during this phase.
• Created design documents and report validation documents based on validation policy of the organization
• Created Universes and complex reports against hugeOracleDatabase.
• Developed reports for managers to existing reporting requirements, developed the KPI reports for Agent’s performance, at region, territory and channel level
• Developed Xcelsius 2008 Dashboards on top of QaaWS andLive Officeconnections
• Worked on Designing and Building of Universes, creation of Classes and Objects using Universe Design Tool
• Used the Information Design Tool (IDT) to create Universe by creating Connection, Data Foundation and Business Layer
• Maintaining and Configuring theVBApplication for Autobind process and was responsible for management reporting.
• Implemented BOBJ solutions on top of SAP BI 7.0,SAP ECC
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, ECC systems as per the system landscape
• Created new Universes and fine-tunes existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @ Functions
• Created Joins and resolved loops by creating Aliases and Contexts
• Used Filters, Prompts, Alerts, Cross-tabs, Charts, Demographic Charts, multiple parameters, flash objects
• Worked on Setting up hierarchies in the Universe for providing drill down options in the reporting environment
• Built Cross-tab reports, Standard reports, Drill-Down Reports using Filters, Alerter, Parameters using Crystal Reports
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs etc by using Chart expert of Crystal Reports
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter
• Created Reports using DeskI and WebI Reporting and Xcelsius dashboard design
• Created interactive Dashboards and Business Representations by importing data from Excel sheets.
• Developed and designed Xcelsius dashboards for higher level management and provided support.
• Made Reports user friendly by implementing user prompts, alerters, conditions and filters
• Created WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas
• Created User Prompts, Conditions and Filters to improve the report generation
• Resolved BO Report performance issues by fine tuning of complex Pl/SQL andTeradataqueries, and tuning universe design/OLAP model and normalizing/denormalizing of database tables/views
• Customized the user interface to meet the needs of end users withBusiness ObjectsSDK with VBA.
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL* Plus.
• Tuned SQL to improve the performance of the reports
• Provided training to business users about Business Objects reports
• Involved in meetings on deciding strategies and planning the workarounds for reports

Environment: Business Objects 4.0, XI 3.1 SP2, SP3, SAPBW7.0, ECC 6.0 Desktop Intelligence, Web Logic 6.0, Crystal Reports 2008, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQL, UNIX.

Confidential, Herndon,VA

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports
• Created a Universe using bothUniverse DesignerandInformation Design Tool
• Created interactive Dashboard designs, Web Intelligence Charts and Crystal reports likeDual Axis, Combined Column and Line, Surface Chart, Stacked Column and with Variable Slice Depth
• Created multiplereportsfromdifferent Data Providers
• Providedvarious interactive ways in viewingthe report by creatingInput controls, Prompts,Combo box, Drop down, Radio buttons and Check box options
• Performed variousAnalysison the reports likeFilters, Ranking, Controls, Data Tracking, Alerts, Breaks and Sorts
• Used the Information Design Tool (IDT) to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) andLive OfficeReports.
• Created variousMaster Detail,Cross tab, Horizontal and Vertical tablesand published them on SAP BILaunch pad/Info view
• Created relevant Cross-Tab reports, Bar Charts, Line Charts for the reports
• Created differentVariablesdepending on the requirements
• Created‘Drill-Through’reports to provide users with detailed information by creatingCustom Hierarchiesat Universe Level for analysis purpose
• Designed and developed all the tables, views for the system inOraclewith simple queries
• Developed Stored Procedures Using OraclePL/SQLprogramming to improve the performance of the reports using complex queries.
• Developing windows forms usingVB.Net and reports webI.
• Created BEx reports using filters, calculated key figures, and restricted key figures for use in BOBJ Tools like Universe Designer, webi, Dashboard designer
• Created, optimized, reviewed, and executedTeradataSQL test queries to validate Reporting data
• Converted .unv to .unx using IDT for creating universes from multiple Relational/OLAP sources
• Involved in installation and configuration of BO Enterprise XI components, Xcelsius, Crystal Reports, Live Office, SAP BI/ BOBJ Integration Kit
• Developed SAP Business Objects Universe, solved SQL traps, loops in Universe Dimensions and Measures
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables, resolving Loops, Chasm Traps, Fan Traps by creating Contexts and Alias tables and checked the integrity of the Universe
• Developed different kinds of Xcelsius dashboards like Profilt Loss Analysis, Product costing Dashboard with what-if Scenarios
• Exported Universes to the Repository to make resources available to the users for ad-hoc report needs
• Improved the performance by usingConditions, @Functions, @Prompts, @Select, @Whereat the universe level for filtering of data

Environment: SAPBI7.3, SAP ECC 6.0, BEx and SAP Business Objects, Xcelsius 2008, Crystal Reports XI,Live Office Windows

Confidential, KS

Business Objects Developer

Responsibilities:

• Analyzed the business requirements for reporting needs and worked with ETL team to understand the data in the form of fact tables, dimension tables and measures
• Created New Universes and modified existing Universes by interacting with Business Analyst, Data Architect to make more efficient universes and tested them on the reports
• Designed and maintained logical and physical enterprise data warehouse schemas, developed and deployed new data marts along with modifying existing marts to support additional business requirements
• Created periodical reports such as daily, weekly, monthly, quarterly and annual reports
• Created SAP BW OLAP Universes on top of SAP BW Queries to access the BW data in SAP Business Objects. Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports
• Created analytical, operational, relational, What-if Model Dashboards in Xcelsius using QAAWS andLive officeto enable executive’s view of the business performance.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up and Drill down functionality
• Analyzing the ExistingOracledatabase PL/SQL code to Map with new system Database Teradata
• Implemented the Reports Module usingVBwhere users can select various filters and create reports
• Developed the application UsingVB/Java scripting, HTML, DHTML
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, R/3 systems as per the system landscape
• Improved the performance and reduced the complexity with the use of @functions (@aggregate aware, @select, @prompt, @where)
• Resolved BO Report performance issues by fine tuning of complexPl/SQLand Teradata queries, and tuning universe design/OLAP model and normalizing/denormalizing of database tables/views.
• Created Alias tables and Contexts to resolve loops and tested them to ensure correct results
• Imported / Exported the Universes from/ to repository to make them accessible to end users
• Created WebI reports and crystal reports and deployed them through InfoView with BW universe as source
• Coded the module inVBto create the filters and store them in the database for use by interviewers.
• Designed Dashboards using Xcelsius and developed detailed level reports using WebI. Exported XML output for BW queries as a source for Xcelsius dashboards
• Created Reports using Crystal Reports
• Made new classes, objects and structural changes to Universes in Designer, including adding new objects, updating tables and joins
• Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups and applied to the groups defining the priorities for different Access Restrictions
• Implemented Security Features of Business Objects like row level, object level to make the data secure
• Developed ad-hoc reports using reporter and used various techniques like Master-Detail, Breaks, Filters, Slice and Dice, Ranking

Environment: SAP BI 7.0, SAP ECC 6.0, BEx, SAP Business Objects XI 3.1

Confidential, Irvine, CA

Business Objects Developer

Responsibilities:

• Interacted with Business users to gather requirements and developed functional specifications to translate them into technical specifications
• Designed the Universe using Business Objects Designer. Defined Classes and Objects appropriately in the Universe
• Creation of Universe in the Designer and making connection with theOracleDatabase.
• Created Joins, Aliases and Contexts for solving the chasm traps and fan trap problems in the universe
• Created Hierarchies, predefined filter conditions and prompts in the universe
• Created custom objects using functions like @prompt, @select, @where, @variable
• Worked extensively on advanced DESKI reporting features like Drill Down, Slice and Dice, Alerts for creating Business Objects reports
• Organized data in the reports by using Variables, Filters, Sorting, and Ranking in the canned reports
• Created custom hierarchies and defined scope of analysis for allowing drill options in the reports for detailed analysis at various levels of data
• Created Derived tables, Developed Stored Procedures, Packages and Triggers database usingPL/SQL.
• Created Alerters using Business objects to highlight columns based on business criteria
• Tuned the performance of the reports by defining the indexes on the correct columns
• Deployed and scheduled reports via Broadcast Agent
• Involved in Performance tuning of the databases involving theTeradata
• Inserted drill filters in the Web Intelligence reports, which help the end users to run a report based on multiple selection criteria

Environment: Business Objects XI R2, Desktop Intelligence, Web Intelligence, Oracle 8.1.6, Windows 2000, UNIX Scripts

Confidential

Business Objects Developer

Responsibilities:

• Involved in the creation of Universes, Classes, Objects and Hierarchies for Multidimensional Analysis of the database usingBusiness Objectsfor the Accounting, Insurance, Technical and Sales departments of the company.
• Weekly Production moves made to the universe.
• Created Dimension, Detail, as well as complex Measure objects, adding tables, revalidating joins.
• Created Master-Detail reports using Drill down/up functionality for the Decision Support System regarding the company’s Sales Revenue, Insurance and Loan Analysis.
• Used Ranking for showing the extreme ranges of data like maximum and minimum data representation.
• Drill mode Analysis helped to find out the factor behind breakdown of sales.
• Ran queries in SQL Server and validate the data in Full Client reports.
• Migrated the universe and the canned reports Testing (QC) environment to the Production Environment. Analysis, design and implementation of reports inBusiness Objectsfor the deployment of strategies in the Business Analysis.
• MonitoringBusiness ObjectsBroadcast Agent and Web Intelligence servers.
• Scheduling of reports on a daily/weekly/monthly basis using Broadcast Agent Server.
• Business ObjectsAdministration - like adding/deleting users, set up passwords and rights for users and groups’ maintenance of BO Repository by scan and repair.
• Trouble-shooting failedBusiness Objectsreports by analyzing the SQL, generated by the report.

Environment: Business Objects XI/6.x, Crystal Reports, Performance Management, Business Objects Designer, Business Objects Reporter, Dashboards, Web Intelligence, Broadcast Agent, PL/SQL, Windows 2000 Server.Windows 2000, UNIX Scripts