SUMMARY

• Wif 8+years of IT - experience inSAP BusinessObjectswifexperience in Administration, Designing, Development, Production Support, Application Maintenance and Testing using wide range of reporting systems wif 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 3full life cycle implementation projects and 1 production support project.
• Extensive noledge of applications like Web Intelligence, Desktop Intelligence, Crystal Reports, Design studio 1.0, 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 teh time to teh clients.
• Performance monitoring and tuning of teh environments to ensure smooth operation.
• Configuration of Business Object processing, job, destination server parameters and performance tuning to achieve a reliable system.
• Developed captivating interactive Xcelsius Dashboards using QaaWS, SAP Netweaver BW Connections and Query Browser (BO 4.0) on top of SAP data sources as well as on NonSAP 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 wif various functions like Input Controls, Graphs and Breaks, Drill Down & Drill Up, Slice and Dice.
• Had a formal internal training wif SAP on teh interactive data analysing and visualization tool- SAP LUMIRA.
• Hands on experience in creating stories directly on top of HANA or on top of BO universe as teh data sources.
• 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.
• Knowledge in Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cube Creation, Info-Source, Multi-Cubes, ODS object creation.
• 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 wif 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 teh 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
• Good Knowledge of Data Provisioning and replicating data from source system to HANA Database using SLT, Sybase Replication Server and Business Objects Data Services. (Trigger based, Log based and ETL).
• Implementation,training and maintenance of client/server Data Warehouse and Data Mart systems in multiple domains.

TECHNICAL SKILLS

Tools: SAP BO XI R2/ XI R3/ BI 4.0/BI 4.1 (SP2), SAP HANA 1.0 (SP4 & SP5), 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.

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 teh projects initiated at time of my joining and on which I was assigned as BI technical resource to one of them.
• Performed Requirements & Gap Analysis of teh Reporting needs.
• Designed & Developed Supplier Scorecard Dashboard using Dashboard Design tool, to automate rating of suppliers and to generate a scorecard dat halps 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.
• Implemented Design studio applications using Archius ChartsPlus components.
• Installation of 3rd party components for design studio on BOBJ server.
• Promotion of Content design studio applications using LCM Jobs.
• Created CSS files to link Design studio applications.Created Universe on top of sales calculation views created in HANA. Extensively worked wif HANA studio in creating calculation views over teh data marts.
• 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 audit reports to keep track of application usage statistics.
• Integrated SFDC portal wif Business objects and passing parameters from SFDC to teh WEBI reports to look teh report wif desired selections. Intigrated explorer and WEBi into dashboards.
• Designed Master/Detail dashboards based on universe built on top of HANA views.
• Modified/Migrated some of teh existing dashboards/sheets and published them on server and portal using Xcelsius/Dashboard Designer.
• Performed Unit Testing, Integrated Testing coordinating wif Business Users. Provided Functional & Technical Documentation as required by Client.
• Developed Mobile Dashboard based out of Dashboard 4.1 SP03, wif auto refresh based on daily, weekly and Monthly refreshes.
• Used Lumira to Create stories on teh business scenarios as a part of POC on teh new project pipeline wif Lumira desktop.
• Trained users on how to share and view Lumira stories wif browser using Lumira cloud and Lumira server for SAP HANA. As part of training worked on teh documentation for Lumira setup and basic tutorial guide for users.
• Worked on creating data sets dat merged different data sources for story creation in SAP Lumira.
• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports
• Created various Dynamic LOV’s and New parameter classes using SQL for Crystal Reports 2011 using Business View Manager as semantic layer.
• Used QAAWS connections to retrieve data from HANA tables based on user access for a unique one pager application.
• Used Design Studio on top of HANA to create some impressive visualization as a part of POC approvals.
• Provided Post Go-live support and addressed any issues at each implementation / Phase.
• Document teh work flow of application and conduct train teh trainer sessions wif training material.
• Design flow: Bw data extract from SAP and Non- SAP sources and providing this as source to HANA where calculation views are created on top of which teh base universe is created. Making use of those universes to build Dashboard, WEBI and Explorer views which are internally integrated.

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 teh Purchasing Scenario and activated business content data sources.
• Administered for a while on installation, maintenance, assigning roles and upgrading patches.
• Teh 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 teh project from project realization phase, testing and go live phases.
• Gatheird 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 Netweaver BW Connection for KPI representation and to reflect user adoption Metrics at department level for teh ease of user.
• Acted as teh dashboard specialist for Revenue dashboard, Loans and Inventory dashboard.
• Involved in Tuning and server configurations for different environments.
• Involved in Design of data models and data mart constructs.
• 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
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Used teh BO tool Analysis Edition for OLAP to reflect teh BI queries in more viewable and presentable format for analysis of teh data.
• Worked on data modelling such as creation of info objects, application components, info areas, data sources, DSO, Cubes, transformations.
• Design & Development of IDT universes wif calculated measures and custom filters.
• Design, install, and configure system for new implementations, upgrades, and maintenance.
• Manage incidents, including complex troubleshooting across technologies.
• Coordinate configuration, change, release, capacity and availability capabilities.
• Installed and Setup teh BI Mobile 4.0 & Explorer.
• Designed “Pricing Defensibility and Pricing Corridor Dashboard Using Dashboard Designer 4.0 wif BICS and as well created user groups for Webi & Crystal report email bursting wif user specific data.
• Extensively involved in training users for Web intelligence, Crystal Reports, and Xcelsius.
• Published Crystal Reports on to Business Objects Infoview and provided access to teh end users.
• Developed Crystal Reports wif Web Elements. Where they use a Custom Function library for Crystal Reports which allows you to easily embed web controls on to teh report.
• Created Packages, Schemas (Universes), Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Functions and also modified teh system generated joins.
• Had an internal training in HANA1.0 application for creating Universes on top of HANA calculation views and developed teh Webi reports and dashboards using IDT (Information design tool).
• Experience working wif large volumes of data and being able to build summary tables for teh dashboard.
• Closely interacted wif business team and completed teh 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 wif 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 ofadhoc, canned reporting and Dashboards.
• Created a multisource universe for bringing teh data from different sources along wif managing and personalising teh information spaces for analyzing teh financial data using teh BO Explorer.
• Created teh Exploration view sets and exploration views. Scheduled teh information spaces for indexing.
• Created Universe using functionalities such as Prompts, Pre-defined conditions; Customized LOV’s, resolved teh problem like Chasm Trap, Fan Trap and Loops using Aliases and Contexts, Aggregate Tables, Derived Tables, Index Awareness, Shortcut Joins, Functions, Custom Hierarchies.
• Created Ad-hoc and standard reports using functionalities such as Conditional Formatting, Input Controls, Combined Queries (Union, Intersection, Minus), Alerts, Breaks, Sections, Scope of Analysis, Ranking, Sorting, Formulas, Variables, Merge Dimensions, and used different formatting such as Vertical, Horizontal, Cross tab, Charts etc.
• Resolved Loop Problems by creatingalias tables and checked teh integrity, to find join problems and detect keys.
• Preparing detailed Technical Specification for teh Dataflow, Data Marts and Reports based on teh client requirement.
• Assisted on developing SAP DS which includes Data Warehouse and Data Mart Design
• Designed and created a Financial Dashboard dat gives teh overall perspective of teh financial system.
• Created teh Column Charts dat provides teh comparison of teh Planned, Budget Update and Actual data.
• Used teh Dynamic visibility functionality of teh Dashboard designer and also teh BIWS from teh scheduled WebI reports to improve teh performance of teh Dashboard.
• Used Open document to connect WebI report to Dashboard for drill down purposes.
• Created and implemented teh design plan for teh data warehouse in teh SQL Server 2008.
• Involved in Unit Testing of Reports and validating teh Report Data against teh source systems.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions wif 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 wif users to gather user requirements and documented them for further reference.
• Interacted wif Business Users to no their business needs and TEMPeffectively develop and modify Universes and Reports.
• Implemented System Development Life Cycle (SDLC), Validation and Verification.
• Created Universes using Designer component of SAP BOXI 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 Xcelsius2008 bound to Live Office using prompts.
• Also worked on QAAWS to create connections b/w WEBI and Xcelsius Dashboards.
• Generated controlled reports data by working wif Universe and queries and used filters, sorts and rankings.
• Designed and createdhighly formatted reports using SAPCrystal reports 2008, like Income Statement.
• Worked on Crystal reports 2008 for advanced functionalities which are not available wifin in WEBI (Stored Procedure, Alerts wifin a graph and superimposing one graph over teh other, multiple y-Axis etc) for Sales reports.
• Created QAAWS connections using Query as a Web Service client tool from universe on BEx queries wif 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 teh performance of teh dashboards. Reduced teh dashboard loading time by scheduling teh backed source Webi reports and by selecting teh filter option changing wif refresh on trigger option to pick from teh latest instance.

Environment: SAP BOXIR3.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 teh proposed solution about teh financial system.
• Created Classes and Objects in teh universes and prepared financial reports, HR reports, standard and Adhoc reports.
• Created and modified teh Crystal Reports for various financial groups using teh Universe as a main data provider.
• Prepared quarterly, monthly, yearly reports for Net Investment, Incomes, Fees and General Ledger.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Prepared Dashboards for teh Net Investment and Interest to analyze teh return on investment.
• Prepared various other reports using master details, cross-tabs, slice and dice and drill methods as per teh specifications provided by teh 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 teh data secure.
• Migration of teh Dashboards from crystal xcelsius 4.5 to Xcelsius 2008 and Dashboard designer.
• Used Query as a web service to get teh data from teh database and created dashboards in Xcelsius for teh end-users in order to have visualization of data.
• Generated teh 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.
• Created Universes over BEx queries and Infocubes of SAP BI using Universe Designer.

Environment: SAP Business Objects XI R2 / XIR3.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 teh standard, analytical and ad-hoc reporting requirements of teh Business Objects users.
• Involved in setting privileges to different User Groups Coordinating wif Supervisor and DBA using Supervisor Module.
• Involved in testing (Users, UniverseReports (FC/Webi) throughout migration process across old system.
• Created Various Cross Tab and Master Detail Reports to view teh data in an analyzed way.
• Created Alerters using Business objects to highlight columns based on business criteria.
• Created teh 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 teh available Universes and resolved Chasm-traps and Fan traps in teh universes.
• Gave my thoughts and ideas to teh data-modelling team in designing a new data mart for future reporting applications and conducted end user training for IT users at local health units for basic reporting skills.
• Trouble shooting and tuning of teh reports to reduce teh performance time of teh reports.
• Tuned teh queries to improve teh Performance of teh existing Reports for various functional areas.
• Applied security features of Business Objects like report level & object level security in teh universe so as to make teh sensitive data secure.
• Extensively worked on Broadcast Agent for scheduling and distributing teh 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 teh Repository.
• Developed, Tested, Promoted and Maintained teh WEBI Reports, also had modified teh 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.
• Scheduling daily, weekly and monthly reports usingBO XI Scheduler using Events, creating Calendars. UpgradedBO XI R2 to BO XI R 3.0Enterprise Environment. Used Java SDK's.
• Formatted Reports as per teh User requirements using extensively teh functionalities in Business Objects, which allows teh users to analyze teh data.
• Extensively usedCalculations, Variables, Break points, and 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 and integration as well.
• Designed interactive Dashboards such asPopup, Tabs etcand many creatively styledXcelsius Reportsto best support needs using TEMPeffectiveHCI Principals.
• 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.