SUMMARY

• Over 8 years of IT experience in SAP Business Objects Developer Suite 4.2/4.1/4.0/XI3.1/XI3.0/XIR2/6.x and experience in all phases of the Software Development Life Cycle (SDLC) such as Requirements gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.
• Experienced in Installation, Administration and upgrading versions of SAP Business Objects in development and testing environments, extensively used CMC for management tasks and CCM to manage local and remote servers.
• Strong experience in Performance Tuning and Query Optimization, Optimizing universe through Linked universes, Aliases and Contexts.
• Solid Experience in writing SQL, stored procedures, functions, packages, Cursors.
• Experienced in the use of Agile and Waterfall methodologies to meet BI requirements.
• Exposure to Agile and Six Sigma methodologies.
• Created multi - source universes to combine more than one source data.
• Created WebI Reports with breaks, sections, merged dimensions, formulas, variables, alerts, filters and query drill.
• Create complex ad-hoc/scheduled WebI Reports using slice and dice, drill down, cross tab, complex variables, Case/If else conditions, multiple data-providers, multiple table/section and master detail type reports.
• Expertise in generating drill-down report, Sub reports, OLAP, Query based reports, Custom made template, Report scheduling, publishing using Crystal Reports.
• Worked on Crystal Reports in Creating Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Created dashboards using Live Office, QaaWS, universe and Bex queries using Dashboard designer.
• Created dashboards using Dashboard Manager with metrics, alters, speedometers and analytic templates to monitor and track business performance.
• Created info spaces on universes for ad-hoc reporting in Explorer.
• Performance tuned indexing process and scheduled to run every day.
• Dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical data modeling.
• Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
• Strong knowledge in designing and developing Data marts, Data warehouse using multi-dimensional models such as Snow Flake and Star Schema.
• Strong Database experience in Oracle 11g,10g/9i/8i/8.0/7.x, DB2, MS Access, MS SQL Server 2008/2005/2000 , SQL Loader, PL/SQL, Oracle DBMS Packages, TOAD, SAP BW and SAP HANA .
• Extensive knowledge in SQL, PL/SQL & T-SQL programming and trouble shooting .
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.

Business Intelligence: Business Objects BI 4.2/4.1/4.0/XI R3.1/R2/R1/6.x,Xcelsius 4.5/2008, Dashboards, SDK, Crystal Reports 2008/XI/10/9,SAP BO DQM 4.0, Design Studio, Central Management Console, Central Configuration Manager, Universe Designer, Desktop Intelligence, Web Intelligence, Webi Rich client, Import Wizard, Report Conversion Tool, Translation Manager, Query As A Web Service (QAAWS), Performance Manager, Crystal reports Enterprise, Auditor, Crystal Report Explorer, Dashboard manager, Tomcat, Data Services

Databases: Oracle 11g/10g/9i/8i, Teradata, IBM DB2 UDB 8.0/7.0, MS SQL Server2005/2000, Sybase, SAP HANA, SAP BW

Utility Tools: Erwin 6.1/4.5/4.1/4.0 , Toad 8.5.1

Programming Languages/Web technologies: Visual Basic 6, PL/SQL, HTML, JavaScript, MS Front Page, Tomcat Apache Web Server, IIS 7.0/5.0/4.0, Microsoft .NET,ASP.NET

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win 2003, Win XP. MS-Dos, Win NT, Red Hat Linux.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Sr. Business Objects Developer

Responsibilities:

• Involved in Full life cycle of Business Objects reporting Application right from requirements gathering till the deployment of the Business Objects reporting system on to the production.
• Worked with end users to gather and document requirements for a SAP Business Objects reporting solution.
• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Designed, Developed and Maintained Single source & Multi source Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies in Information Design Tool.
• Defined and created Hierarchies as per the business rule for the reports to be viewed at selected level. Checked the integrity of the Universes and exported the universes to repository for making available to users.
• Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data.
• Optimized the reports at the universe level and report level to enhance their performance which involved working on SQL parameters, aggregates and joins.
• Created Business Layer using Data foundation and defined @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Created the WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions and Formulas etc. and several Queries (Union, Intersection, Minus)
• Worked with WebI for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
• Developed Crystal Reports and formatted the same with respect to the requirements, added parameters, special fields and used multiple data sources to create the reports.
• Created different Ad-hoc and Complex Canned Reports using Master/detail, Cross Tab and Charts for graphical representation in the reports.
• Developed executive dashboards using Xcelsius/Dashboards with Live Office, QAAWS and BICS connectivity’s.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering, scorecard components, containers, combo boxes, list views, complex excel logic, highly formatted excel model with defined naming conventions for design of these complex dashboards.
• Experience in performance tuning of the BOBJ reports at the universe level and report level.
• Involved in Business Objects administrative activities including creating user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica.
• Created information spaces in business objects explorer and performed indexing on them.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial and customer information systems using Business Objects XI connected to Oracle data source.
• Developed front end queries using Query Designer and Web Application Designer (WAD) and published results on the web.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports and security management.
• Responsible for improving the Business Objects query performance by tuning the Queries, Database and server parameters.
• Responsible for maintaining the BOBJ Landscape (Development, Quality, Staging and Production repositories, universes, reports and connections) and providing round the clock support during the production stage.

Environment: Business Object BI 4.2/4.1, Dashboards, Crystal Reports 2013, Designer, Web Intelligence, Info View, CMC,BO Design Studio, Informatica 8.1, SDK, DB2, SQL, PL/SQL, SQL Server 2012, Oracle 11g, TOAD, Erwin 6.1

Confidential, Cheshire, CT

Sr. Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Gathered and captured all existing Customization/enhancements in available BO system. Involved in preparation of BRD (Business requirement document) and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow.
• Responsible for Designing and building Universes using Universe Design Tool (UDT).
• Resolved Loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created Web Intelligence Reports with different functionalities like cascading prompts, drill down, charts, graphs, ranking, Scope of Analysis and alerts.
• Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
• Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Breaks, Calculations, Alerts, Slice and Dice, Drill Down and @Functions.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Created Explorer Information Spaces for Sales and finance metrics.
• Built Dashboards with high variation of data using Live Office, QAAWS and BI Web Services.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Developed BEx Queries for reporting on InfoCubes, InfoSets and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, conditions providing drill down functionality in reporting.
• Extensively worked on Query building, filtering, Restricted Key figures, variables and query variants using BEx Analyzer.
• Created virtual key figures and calculated Key figures to satisfy the reporting requirements.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Object 4.1, Xcelsius, Dashboards, Crystal Reports 2011, Designer, Web Intelligence, CMC, DB2, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1

Confidential, Phoenix, AZ

Business Objects Developer

Responsibilities:

• Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports accordingly.
• Worked on full life cycle of the project including requirements gathering, prototyping, Effort estimate, Impact analysis, development, UAT, Production and Postproduction support.
• Understanding business requirements in terms of technical specifications for reporting and data analysis.
• Extensively used Business Object Universe, BO XI R2 Reports and Oracle database.
• Extensive analysis to design the Universes and assigned those to respective domains.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defined data loads and query performance issues.
• Created WEBI Reports on OLAP Universe using various formats like Cross tabs, Sections, Breaks, Sort options, Font, Colors and Charts.
• Created WEBI reports and deployed them through info view with BW universe as source.
• Extensively used calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created complex views to overcome loops and contexts.
• Created Queries by defining structures, variables, formulas, exceptions, navigational attributes, conditions providing drill down functionality in reporting.
• Created complicated reports including sub-reports, graphical reports, formula base and well formatted reports according user requirements.
• Created Crystal Reports with Standard Cross Tabs and Grouping.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica, Power Mart and Power Center, Ascential Data Stages 7.5, Data Integrator.
• Created visualizations for Finance department to display important KPIs and metrics in one single view.
• Used live office and QaaWS to give visualizations live data connectivity.
• Developed critical reports having complex drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes.
• Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of SAP Business Objects like row level, object level and report level to make the data secure.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using aliases and contexts.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Generated the SAP Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Responsible for SQL tuning and optimization using Explain Plan, Indexes and optimizer hints.
• Involved in Business Objects support, Problem solving, trouble shooting and developing End user notes.

Environment: Business Object XI 3.1, Crystal reports 2008, Xcelsius 2008, Designer, Desktop Intelligence, Web Intelligence, InfoView, CMC, Teradata V2R7, SQL, PL/SQL, SQL Server 2008, SQL Assistant .

Confidential, Houston, TX

Business Objects Developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created predefined condition, prompts and customized LOV’s in the process of building the Universes.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Extensively created reports in WEBI and DESKI module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
• Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
• Created several Classes, Objects, Conditions, and Measure objects
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Resolved loops, defined contexts and aliases to resolve loops and also tested them to ensure that correct results are retrieved.
• Resolving join path Problems like Chasm Trap and Fan Trap and loops by creating Context and Aliases.
• Exported the Universes to the Repository to make resources available to the users. Created reports from the Universes as the main Data Providers
• Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Developed and supported Business Objects reporting system for various Business units.
• Tested the created reports and modified the relevant objects in the Universe.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence

Environment: Business Objects XIR3,Xelcius 4.5/2008, Web Intelligence, Desk I, SDK, Oracle 10g, PL/SQL, SQL Server 2005, Toad,Erwin, Windows 2007 Server/ XP/Professional and Unix shell programming

Confidential, Denver, CO

Business Objects Developer

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Work included Developing, Testing and enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements, Also solved any issues/errors encountered
• Responsibilities required acting as the Key Person for maintaining Universe's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolved loops, Fan Traps and Chasm traps using context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc. using Web intelligence.
• Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0 Enterprise Environment. Used Java SDK's.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Used Polestar for better interaction with predefined data sets to generate quick visualized reports
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts etc. in Creating Reports, formatted old reports, generated charts, bars etc. as per user requirements using Crystal Reports 2008, Xcelsius 2008 and integration as well.
• Designed interactive Dashboards such as Popup, Tabs etc. and many creatively styled Xcelsius Reports to best support needs using effective HCI Principles.
• Manipulating data through various presentation styles using Crystal Reports 2008 such as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment: Business Objects 6.5/XI, crystal reports, WebI, Designer, Supervisor, Broadcast Agent, ZABO, Oracle 8i/9i, PL/SQL, Windows NT.

Confidential

Business Objects Developer

Responsibilities:

• Created balance sheets- Monthly and Quarterly Breakdowns, Profit & Loss reports for financial accounting needs.
• Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content.
• Participated on teams and projects to understand business needs, recommended solutions, and provided support on the evolving BO environment.
• Created canned and Ad-hoc reports using WebI/ DeskI/ Crystal Reports.
• Extensively Worked on Tables, Charts, Formulas & Variables, Prompts in WEBI.
• Created different types of reports like Master/Detail, Cross Tab, Chart and Ad hoc Reports using End User module in Business Objects.
• Created and managed Universes of different sources and linking them in the Designer.
• Extensively used Calculations, Variables, Break points, Sorted inputs, Drill down, Slice and Dice, Alerts etc. in Creating Reports, formatted old reports, generated charts, bars etc. as per user requirements using Crystal Reports XI.
• Worked on tickets and tasks such as load monitoring issues, user issues and enhancements of existing objects.
• Ensured a high quality solution for all the delivered objects to the client within the schedule.
• Performed end user training sessions in reporting scenarios, and documentation.

Environment: Business Objects XI R2, Crystal Reports XI, Crystal Xcelsius 4.5, WebI, DeskI, SQL Server 2005

Confidential

BO Developer (AMS-Support)

Responsibilities:

• Work included Developing, Testing and enhancing existingBusiness Objects Universes.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements,Also solved any issues/errors encountered.
• Responsibilities required acting as the Key Person for maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolvedloops, Fan Traps and Chasm trapsusing context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• UsedPolestarfor better interaction with predefined data sets to generate visualized reports.
• Extensively usedCalculations, Variables, Break points, Sorted inputs, Drill down, Slice and Dice, Alerts etcinCreating Reports, formatted old reports, generated charts, bars etc. as per user requirements usingCrystal Reports XI, Crystal Xcelsius 4.5.

Environment: Business Objects XI R2, BI 7.0, Crystal Xcelsius 4.5, Crystal Reports XI, WebI, DeskI, SQL Server 2005.