SUMMARY

• With 8+ years of IT - experience in SAP Business Objects with experience in Administration, Designing, Development, Production Support, Application Maintenance and Testing using wide range of reporting systems with SAP Business Objects BI 4.0/4.1, Business Objects XI 3.1/XI R2 & Crystal Reports 2008/2011.
• Involved in requirement gathering, gap analysis and developed functional specifications, technical Specifications and prepared business blueprint documents.
• Expertise in Design, Development and Deployment of BI solutions for Corporate reporting requirements and involved in 3 full life cycle implementation projects and 1 production support project.
• Extensive knowledge of applications like Web Intelligence, Desktop Intelligence, Crystal Reports, Design studio 1.5, Dashboard 4.0/4.1 (Xcelsius 2008), Universe Designer, Information Design Tool, Central Management Control, Microsoft Live Office, BEx Query Designer, BEx Analyzer.
• Implemented Business objects on multiple servers performing load balancing and clustering in order to have high availability all the time to the clients.
• Monitoring onsite/off shore development process. Documenting every stage of the SDLC.
• Developed captivating interactive Xcelsius Dashboards using QaaWS, SAP Net weaver BW Connections and Query Browser (BO 4.0) on top of SAP data sources as well as on Non SAP sources.
• Developed highly formatted Crystal Reports using options such as Grouping, Sorting, Sub-reports, Formula Fields, Alerts and Field highlighting on top of any data sources.
• Experience in Designing, Testing and Deploying BO Universes. Developing WebI reports with various functions like Input Controls, Graphs and Breaks, Drill Down & Drill Up, Slice and Dice.
• Had a formal training with SAP on the interactive data analysing and visualization tool- SAP LUMIRA.
• Worked on creating, organizing, and scheduling reports using Central Management Console (CMC), Infoview and BI Launch Pad. Created User profiles, groups and security for BI end-users.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path.
• Expert in BI Testing process in functional Unit Testing, Data validation, System & Integration testing.
• Accessed Analytic and calculation views from BO Analysis via ODBC connection (BOBJ Integration).
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence (Webi), BO Analysis. Enabled BO Explorer to search data present in HANA

TECHNICAL SKILLS

Tools: SAP BO XI R2 / XI R3 / BI 4.0/BI 4.1 (SP2), SAP HANA 1.0 (SP4 & SP5), Design Studio, Universe Designer, Deski, WEBI/WEBI Rich, Info View, SAP BW 7.3 / BI 7.0, BEx Query Designer, Broadcast Agent, CMC Performance Management, Report Conversion tool, Import Wizard, Crystal Reports 2008/2011 and Crystal Reports Enterprise 4.0, IDT 4.0.

Dashboard Tools: Dashboard Designer, Xcelsius 2008, Tableau 8.0.

Reporting: BEx, WebI, Analysis-Edition for OLAP/ MS Office, Explorer and Live Office.

Operating Systems: Windows NT/XP/2000/7/Vista, Linux.

Databases: Oracle 8i/9i/10g, DB2, IDS, and My SQL

Program Languages: C, C++, Java and .Net, PL/SQL, SQL*PLUS

Source Systems: SAP ECC AND CRM.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Senior SAP BOBJ/HANA Developer

Responsibilities:

• Part of POC and BRD for two of the projects initiated at time of my joining and on which I was assigned as BI technical resource.
• Performed Requirements & Gap Analysis of the Reporting needs.
• Co-ordinated daily stand up meetings as a part of the agile methodology.
• Follow up with business after every sprint to add additional requirements and prioritize the changes for every milestone.
• Designed & Developed Supplier Scorecard Dashboard using Dashboard Design tool, to automate rating of suppliers and to generate a scorecard that helps evaluating performance of suppliers on regular basis.
• Created executive summary, vendor and category scorecard dashboards, including hierarchical selectors, flash variables (linking to dashboards), KPI level sales and marketing information based on live SAP data.
• Used various components like scorecards, alerts, tab set, dropdown boxes, Combination chart, bar chart, Radio buttons, and value in user interface.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Installation of 3rd party components for design studio on BOBJ server.
• Created PL/SQL scripts for the analyst and the testing teams to validate the data on Bo reports.
• Created CSS files to link Design studio applications & Universe on top of sales CV’s created in HANA.
• Extensively worked on creating a generic Universe that serves the purpose of all general reporting.
• Created Universe using functionalities such as Prompts, Pre-defined conditions; Customized LOV’s, resolved the problem like Chasm Trap, Fan Trap and Loops using Aliases and Contexts, Aggregate Tables, Derived Tables, Index Awareness, Shortcut Joins, Functions, Custom Hierarchies.
• Applied security features of Business Objects like report level & object level security in the universe so as to make the sensitive data secure.
• Built Multiple WebI detail reports connected to BI services pointed at Web Intelligence blocks. Reports launched by and receiving prompts from Dashboard Designer.
• Created multiple Web Service (BIWS) connections from WEBI reports and used them as data source for dashboards.
• Created multiple WEBI audit reports to keep track of application usage statistics.
• Integrated SFDC portal with Business objects and passing parameters from SFDC to the WEBI reports to look the report with desired selections. Integrated explorer and WEBi into dashboards.
• Performed Unit Testing, Integrated Testing coordinating with Business Users. Provided Functional & Technical Documentation as required by Client.
• Developed Mobile Dashboard based out of Dashboard 4.1 SP03, with auto refresh feature.
• Used Lumira to Create stories on the business scenarios as a part of POC on the new project pipeline with Lumira desktop.
• Trained users on how to share and view Lumira stories with browser using Lumira cloud and Lumira server for SAP HANA. As part of training worked on the documentation for Lumira setup and basic tutorial guide for users.
• Worked on creating data sets that merged different data sources for story creation in SAP Lumira.
• Used QAAWS connections to retrieve data from HANA tables based on user access for a unique one pager application.
• Provided Post Go-live support and addressed any issues at each implementation / Phase.
• Document the work flow of application and conduct train the trainer sessions with training material.

Environment: SAP Business objects 4.1 SP02, BI 7.3, WEBI, IDT, Design Studio 1.5, Dashboard Design Tool, BO Explorer, SAP HANA, SAP Lumira 1.23 and Crystal Reports.

Confidential, Washington, DC

Senior Lead SAP BO Developer

Responsibilities:

• Involved in MM (Purchasing) Business Requirements Gathering, prepared functional Design & technical Design Documents, designed the Purchasing Scenario and activated business content data sources.
• Administered on installation, maintenance, assigning roles and upgrading patches.
• The role involved in building data mart and linking universes and working on reporting tools in order to create different sales reports like purchase orders etc for different clients.
• Involved in the project from project realization phase, testing and go live phases.
• Gathered user requirements for BO reports and Dashboards. Prepared Business Blueprint Documents (Report Specs) to understand process design and flow.
• Developed SAP Dashboards using Dashboard 4.0, on top of SAP BI Queries (Bex Queries) using SAP Net weaver BW Connection.
• Acted as the dashboard specialist for Revenue dashboard, Loans and Inventory dashboard.
• Involved in Tuning and server configurations for different environments.
• Experience in SAP Upgrading: from SAP BO 4.0 to SAP BO 4.1
• Experience in SAP Administration: Maintenance: health checks, patching, scheduled maintenances and systems re-starts, Create and schedule regular backup
• Used the BO tool Analysis Edition for OLAP to reflect the BI queries in more viewable and presentable format for analysis of the data.
• Design & Development of IDT universes with calculated measures and custom filters.
• Design, install, and configure system for new implementations, upgrades, and maintenance.
• Installed and Setup the BI Mobile 4.0 & Explorer.
• Designed “Pricing Defensibility and Pricing Corridor Dashboard Using Dashboard Designer 4.0 with BICS and as well created user groups for Webi & Crystal report email bursting with user specific data.
• Extensively involved in training users for Web intelligence, Crystal Reports, and Xcelsius.
• Developed Crystal Reports with Web Elements. Where they use a Custom Function library for Crystal Reports which allows you to easily embed web controls on to the report.
• Created Packages, Schemas (Universes), Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Functions and also modified the system generated joins.
• Had an internal training in HANA 1.0 application for creating Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Experience working with large volumes of data and being able to build summary tables for the dashboard.
• Closely interacted with business team and completed the QA testing, conducted workshops (Trained Business Users how to use Reporting)

Environment: SAP BOBI 4.0, Mobil 4.0, HANA 1.0, Linux, Ms Office, Visio, MS Outlook, Oracle 10g, SQL Server 2008, BI 7.0, Dashboard Designer and Crystal Reports.

Confidential, Houston, Texas

Senior SAP BO Developer

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Extensively worked on SAP Business Objects BI 4.0 suite tools like Information Design Tool (IDT), WebI, WebI Rich Client, BI Launch Pad, Dashboard Designer and QaaWS.
• Created universes in IDT which facilitated requirements of adhoc, canned reporting and Dashboards.
• Created a multisource universe for bringing the data from different sources along with managing and personalising the information spaces for analyzing the financial data using the BO Explorer.
• Created the Exploration view sets and exploration views. Scheduled the information spaces for indexing.
• Resolved Loop Problems by creating alias tables and checked the integrity, to find join problems and detect keys.
• Designed and created a Financial Dashboard that gives the overall perspective of the financial system.
• Used BIWS from the scheduled WebI reports to improve the performance of the Dashboard.
• Used Open document to connect WebI report to Dashboard for drill down purposes.
• Involved in Unit Testing of Reports and validating the Report Data against the source systems.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Provided training to end users to use various functionalities of Business Objects.

Environment: SAP BO BI 4.0, WebI, WebI Rich Client, Information Designer Tool, Dashboard 4.0, BO Explorer, SQL Server 2008, Visual Studio 2008.

Confidential, Rochester, NY

SAP BIBO Developer

Responsibilities:

• Interacted with users to gather user requirements and documented them for further reference.
• Interacted with Business Users to know their business needs and effectively develop and modify Universes and Reports.
• Implemented System Development Life Cycle (SDLC), Validation and Verification.
• Created Universes using Designer component of SAP BO XI R3.1 and exported it to Infoview for other users to generate reports.
• Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports.
• Created cross-tab reports using Web Intelligence by utilizing prompts, alerter etc and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius 2008 bound to Live Office using prompts.
• Also worked on QAAWS to create connections b/w WEBI and Xcelsius Dashboards.
• Designed and created highly formatted reports using SAP Crystal reports 2008, like Income Statement.
• Worked on Crystal reports 2008 for advanced functionalities which are not available within in WEBI.
• Created QAAWS connections using Query as a Web Service client tool from universe on BEx queries with prompts as input values and query results as output values.
• Created Dynamic Dashboards using Xcelsius on top of SAP BI system (BEx Queries).
• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source Webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.

Environment: SAP BOXI R3.1, SAP BI 7.0, ECC 6.0, Functional Areas: MM (Purchasing), SD.

Confidential, Arden Hills, MN

SAP BIBO Developer

Responsibilities:

• Participated in project planning to analyze business requirements and outline the proposed solution about the financial system.
• Created Classes and Objects in the universes and prepared financial reports, HR reports, standard and Adhoc reports.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Prepared quarterly, monthly, yearly reports for Net Investment, Incomes, Fees and General Ledger.
• Prepared Dashboards for the Net Investment and Interest to analyze the return on investment.
• Prepared various other reports using master details, cross-tabs, slice and dice and drill methods as per the specifications provided by the end-user.
• At times converted Deski Reports to Webi using Report Conversion Tool.
• Implemented Security Features like report level, row level, and object level to make the data secure.
• Migration of the Dashboards from crystal Xcelsius 4.5 to Xcelsius 2008 and Dashboard designer.
• Used Query as a web service to get the data from the database and created dashboards in Xcelsius for the end-users in order to have visualization of data.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Created BEX reports using conditions, Filters, Free Characteristics, Calculated Key figures, Restricted Key Figures and Variables.

Environment: SAP Business Objects XI R2 / XI R3.1, SAP BI 7.0, Crystal Report 2008, Xcelsius 4.5 / 2008, WebI, Deski, Universe Designer, Oracle 9i, PL/SQL.

Confidential, Houston, TX

SAP BO Developer

Responsibilities:

• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Involved in setting privileges to different User Groups Coordinating with Supervisor and DBA using Supervisor Module.
• Involved in testing (Users, Universe Reports (FC/Webi) throughout migration process across old system.
• Created Various Cross Tab and Master Detail Reports to view the data in an analyzed way.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc
• Used Free Hand SQL for creating complex Reports, which were not possible to produce using the available Universes and resolved Chasm-traps and Fan traps in the universes.
• Trouble shooting and tuning of the reports to reduce the performance time of the reports.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Extensively worked on Broadcast Agent for scheduling and distributing the documents.

Environment: Business Objects XI 3.1 (Supervisor, Designer, Reporter), Broadcast Agent, Web Intelligence, Info View, Auditor, Oracle 9i/10g, SQL Server 2005, Xcelsius, Windows NT/2000 server.

Confidential, Bloomfield, CT

BO Developer

Responsibilities:

• Work included Developing, Testing and enhancing existingBusiness 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.
• 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.
• Designed interactive Dashboards such asPopup, Tabs etcand many creatively styledXcelsius Reportsto best support needs using effectiveHCI Principles.
• Manipulating data through various presentation styles usingCrystal Reports XIsuch ascharts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment: Business Objects XI R2, Crystal Xcelsius 4.5, Info View, Crystal Reports XI, Web Intelligence, Business Explorer (Polestar) XI 3.0, SAP BI/BW 7.0, Sql server 2005.