SUMMARY:

• 14+ Years of IT experience including 12+ years in Business Objects.
• 11+ Years of experience in Analysis, Design and Development of software applications and Business Intelligence projects under different environments.
• 2+ Years of Tableau development experience.
• Skilled in Data Model design and development using various tools like ERWIN 3.5, VISIO 2000.
• Involved in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions and related data marts.
• Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per the needs of the client and maintain documentation of the reports for future reference.
• Experience in installation and configuration of Business Objects and Web Intelligence, creation of repositories with user groups and security implementation.
• Over 11+ years of experience in Business Objects Enterprise Suite and Expertise in designing Universes, WebI Reports, DeskI reports, and Full Client Reports.
• Expertise in SAP Business Intelligence 4.0, 4.1, 4.2 tools and SAP HANA1.0 Data bases.
• Expertise in upgrade projects in the SAP Business Intelligence environments (XI R2,XI R3,3.0,3.1,4.0,4.1,4.2)
• Assist and manage the design, prototyping, development, testing, and production support of multiple universes.
• Expertise in SAP Business Objects XI Rel 2/XI 3.1 (CMC, CMS, CCM), 6.5.1/5.x Universe design, Scheduling, Import wizard, Publish wizard, Business views, Desktop Intelligence, Designer and Web Intelligence.
• Extensively worked on Business Objects 6.1 and 6.5, Business Objects XI R2/XI R3.1, Dash Board Manager, Xcelsius 4.5, Xcelsius 2008 and Performance Manager
• Extensively worked on Dashboard Designer and Design studio (SAP BI 4.1).
• Experienced working with Microsoft Power BI tool.
• Experienced working with Universe Builder to build OLAP Universes from SAP BW data source like InfoCubes and BW Query.
• Hands on experience in developing reports out of SAP BW.
• Proficiency in Advanced Analysis for Microsoft office and OLAP.
• Experience in SAP BO Integration kit, Created Reports and Universe using SAP BEX queries.
• Trained in BO best practices and testing Universe.
• Certified Professional in Business Objects Enterprise XI 3.0 and Business Objects Web Intelligence XI3.0.
• Sound knowledge of data quality processes, and data mappings, Star and Snowflakes schemas.
• Experience in Extraction, Transformation and Load (ETL) tool Informatica, SAP Data Services.
• Excellent Business Analysis skills - ability to transform business users input to software requirements and specifications.
• Experience in creating the functional and Technical documentation.
• Excellent Programming and analytical skills
• Excellent communication and interpersonal skills

TECHNICAL SKILLS:

Operating System: Windows 95/98/NT 4.0/2000, XP, UNIX, GIS (Gentran Integration Suite)

Databases: Oracle 7.x/8i/9i/11i, SQL Server 6.5/7.0/2000, MS SQL Server 2000, MS Access 2000, Teradata, SAP HANA1.0, Sybase 14, 15, 15.6,16

Data Modeling Tools: Erwin 4.1

ETL Tools: Ab Initio, Informatica 6.1, 8.x, DataStage

Business Intelligence Tools: SAP BI 4.2 SP3,4.1 SP6, 4.0 Business Objects XI R2,R3/6.X/5.x, Designer 6.X/5.x,CMC,CMS, Supervisor5.X 6.X, WebI, WEBI Rich Client, DESKI, Crystal Report XI, QAAWS, Live Office.

Crystal Tools: Crystal Xcelsius 4.5 and 2008

Dashboard Tools: Dashboard Designer, Design Studio 1.31.6,2.0, Power BI, Lumira1.31,Tableau 9 and 10.1,2,3

Languages: C, C++, COBOL, PL/SQL, HTML, BPML, Visual Basic, Java, JSP, J2EE

Methodology: Structured System Analysis & Design

PROFESSIONAL EXPERIENCE:

Confidential,Schaumburg,IL

Sr. Business Objects Developer

Environment: SAP Business Objects 4.2 SP3, SAP BW, HANA 2.0, Lumira 1.31, Design Studio 1.6, SAP Data services 4.1

• Created HANA connections and trined users to create the WebI reports using HANA connetions.
• Created Universes using HANA and Bex query’s.
• Developed dashboards in Design studio connecting using IDT unx,Had to develop Universe in situations where Ranking was not a possibility in Design Studio.
• Worked with Business Users/Business Managers to understand 4.2 environment.
• Provided User traninig in Lumira.
• Created Universe documentation and Reports techinical documents.

Confidential,Houston,TX

Sr. Business Objects Developer

Environment: SAP Business Objects4.1 SP6, 4.2 SP3 patch4, Sybase 15.6,16, Oracle, MS SQL Server 2008, APOS, Power BI, Lumira 1.31

• Converted Sybase database .unv to .UNX and change the data source for WebI reports.
• Worked on SAP BI 4.1 SP6 to SAP BI 4.2 SP3 upgrade.
• Worked with Business Users/Business Managers to Fix the issues in 4.2 environment.
• Updated join operators Manualy in sybase IDT unx .
• Pointed the .unv based reports to .unx, tested the report, compared with unv based reports.
• Created Audit reports using Audit universe and database.
• Created Lumira visualization using UNX universe.
• Created data visualizations using Microsoft Power BI.

Confidential,Mason,OH

Sr. Business Object Developer

Environment: SAP Business Objects 4.1 SP2, SP6 suite tools, Oracle, MS SQL Server 2008, SAP BW, Design Studio 1.3, SAP Lumira 1.28

• Upgrading SAP BO 4.1 SP2 servers with SP6 on Windows 2008 server System.
• Created Audit WebI reports using Activity universes.
• Created WebI reports using Freehand SQL and applied the conditional formatting and chart features
• Developed dashboards using Design studio.
• Created visualizations using SAP Lumira
• Installed the BI 4.1 sp6 in Clustered environment.
• Backend source for the reports and dashboard were Bex queries.
• Worked on the Business Users reporting issues, provided the user traning on WebI
• Maintian the BOE systems up and running.
• Converted the .unv to .UNX and tested the .Unx are working correctly.
• Working different Teams to support their BOE Application reports and universes.

Confidential,Houston,TX

Sr. Business Objects Developer

Environment: SAP Business Objects 4.1 SP4 suite tools, Sybase 15.6,16, Oracle, MS SQL Server 2008, APOS

• Installing and upgrading SAP BO server on Windows 2008 server.
• Converted the .unv to .UNX and change the data source for WebI reports.
• Extensively worked on Promotion Management to move the objects from Dev to Test and BHU,BHP
• Worked on Upgrade from SAP BO XI 3.1 to SAP BI 4.1 SP4.
• Fixed the BI 4.1 errors and used Input/Output context operators in reports.
• Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created parameters and quick filters. Created sets to display top products based on their spend
• General troubleshooting experience using server logs
• Converted the 3.1 DeskI reports to WebI reports using RCT.
• Change Datasource unv to UNX using APOS migrator.
• Fixed the conversion errors from DeskI to WebI.
• Worked with Business Users/Business Managers to Fix the issues in 4.1environment.
• Done the Data validation for 3.1 to 4.1 reports, fixed the data mismatch and Fold and Unfold option
• Resolving CQ tickets as quick as possible.

Confidential

Sr. Business Objects Developer/Administrator

Environment: SAP Business Objects 4.1 SP5 suite tools, Sybase 11, BSM version 8.1.00, Remedy, Tableau 9

• Involved in the requirements, created technical specs
• Created the Country, Geo, Customer Reports.
• Created Compliance .unx using IDT tool.
• Created IDT universe using BMC remedy for BSM version 8.1.00
• Created WebI reports using remedy BSM version 8.1.00 unx.
• Created Business Requirement Document and Technical Specification Documents.
• Expertise with tableau migration and scheduling.
• Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards
• Experience in taking back ups and restoration of Tableau repository
• Migrated SAP BI reports from 3.1 to 4.1 and Dev to Test to Prod.

Confidential,Minnetonka, MN

Sr. Dashboard Designer/ Design Studio

Environment: SAP Business Objects 4.1 SP5 suite tools (Dashboard Designer and Design Studio), Oracle 11g

• Involved in the requirements, created technical specs and functional specs.
• Based on the requirements created. unx using the IDT.
• Created CSM and CSR dashboards using. unx connection.
• Created Proof of Concepts (POC) using Design studio.

Confidential

Sr. Business Objects Developer/Administrator

Environment: SAP Business Objects 4.1 SP5 suite tools, QC10, SAP Business Objects 3.1, SQL server

• Installing and upgrading SAP BO server on Windows 2008 server.
• WebI system administrations like user activities/ sessions, enable/ disable users and modules
• Converted the. unv to .UNX and change the data source for WebI reports.
• Extensively worked on LCM for transporting objects.
• Worked on Upgrading from SAP BO XI 3.1 to SAP BI 4.0.
• Fixed the BI 4.0 errors and used input context operators in reports.
• Resolving QC tickets as quick as possible.

Confidential,San Ramon,CA

Sr. Business Objects Developer/Analyst

Environment: SAP Business Objects 4.0 SP4 suite tools (IDT, Dashboard Design and Universe Designer), SAP BW, QC10, Advanced Analysis for OLAP and Microsoft Office, BI Launch Pad, SAP BODS 4.0,BMC

• Work closely with Business Users and Business Analysts to gather the requirements.
• Created User specification documents and reviewed with Business Analyst and System Owners.
• Created reports using SAP BICS conncetion.
• Tested the SEMS reports and fix the defects.
• Extensively worked on WEBI reporting using SAP BW Objects (BW Query, InfoCube and Multiprovider ) as data sources.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Created reports using Opendoc syntax.
• Deloped SAP, NON SAP ETL Integrations such as SalesForce.com, MDM integration solutions and sending data in to BW PSA’s.
• Created univerese using BMC remedy data base and reports on top BMC universe.
• Created Jobs, Workflows and Data Flows according to specifications and implemented their business logic.
• Used different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions like ifthenelse(), substr, lookup, lookup extetc
• Worked with Universe Builder to build OLAP universes from SAP BW Data targets like InfoCubes .
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Designer, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.

Confidential,LA,CA

Sr. Business Objects Developer

Environment: SAP Business Objects 4.0 SP4 suite tools (IDT, Dashboard Design and Universe Designer), Oracle10g, QC10

• Work closely with Business Users and Business Analysts to gather the requirements.
• Created Multi Source .unx using Information Designer Tool.
• Created User specification documents and reviewed with Business Analyst and System Owners.
• Created Views using LIMS(Laboratory information Management Systems),LEMS( Laboratory Method Execution System),CIMS(Consumable inventory Management System) databases.
• Imporved performance of Reports and Query’s.

Confidential

Sr. Business Objects Developer

Environment: Business Objects XI 3.1, Tera Data, SAP BI 4.0(IDT, Dashboard Designer, Presentation Layer), MS SQL server, Informatica

• Work closely with Business Users and Business Analysts.
• Worked on Upgrading from SAP BO XI 3.1 to SAP BI 4.0.
• Worked with SAP Technical support team in upgrade issues and remediations.
• Created User specification documents and reviewed with Business Analyst and System Owners.
• Functional test of migrated SAP BO 3.1 reports to BI 4.0.
• Modified the Opendocument syntex with new BI 4.0 syntex.
• Fixed the BI 4.0 errors and used input context operators in reports.
• Created Connections for Information Designer Toll(.UNX) and exported to BOE server.
• Created universe and reports using Dervied tables
• Tested Report data with Source System Data(MS SQL server )
• Run the test cases and test scripts in QC

Confidential,Denver,CO

Sr. Business Objects Developer

Environment: Business Objects XI R2, Oracle10g

Responsibilities:

• Involved in requirements gathering.
• Created report mockups and conducted sign-off meetings.
• Created WebI reports using multiple data providers
• Formatting the Reports to the Users requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down & @functions.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Linking of two reports using open-document syntax.
• Created Cross tab reports.

Confidential,Thousand Oaks,LA,CA

Sr. Business Objects Developer

Environment: Business Objects XI 3.1 fp3.3, Tera Data, Crystal Xcelsius 2008 sp3, QAAWS, live Office, Informatica 8.6, Mercury Quality Center.

• Work closely with Business Users and Business Analysts.
• Worked on Upgrading SAP BO XI3.1 FP1.1 to SAP BO XI3.1 sp3 FP3.3.
• Worked with SAP Technical support team in upgrade issues and remediations.
• Fixed errors (#Multivalue Error,No Data in Reports,#ERROR,#DIV/0 ) in upgrade process.
• Redesigned universe row Level security.
• Worked on Breaking down one universe into multiple universes as per application.
• Worked on complex reports and Xcelsius Dashboards.
• Update the Report Specification documents as reports and universe fixes.
• Interacted with the Business Analysts to gather the requirements and developed Technical Specification documents and Report Templete design document.
• Worked closely with the testing team in fixing reports and universes.
• Update the status of the defects in the defects tracker tool QC.

Confidential,IL

Sr. Business Objects Developer/Dashboard Production support

Environment: Business Objects XI3.0 and XI 3.1, Oracle 10g, Crystal Xcelsius 2008, QAAWS, DataStage

• Interacted with the Business Analysts to gather the requirements and developed prototypes in the form of PDF’s or Power Point Slides of the Dashboards for the initial presentation to the users.
• Developed WEBI reports in Business Objects XI R3.1and Xcelsius Dashboards in Xcelsius 2008.
• Linked the Webi reports to the dashboards KPI’s using Open doc Syntax.
• Developed multiple dashboards so that the user can navigate from one dashboard to the other.
• Expertise in developing drill down reports and hyperlinked reports.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Extensively used QAAWS to retrieve the data from the universe objects.
• Formatted the raw data retrieved from Universe Objects in Xcelsius spreadsheet using VLOOKUP, IF, AND, OR, CONCATENATE and many other excel formulae/functions that are supported in Xcelsius .
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Resolved the production tickets within specified time lines.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Extensively worked on drill mode to view data in different Perspectives.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Prepared Test Cases and Test Scripts for Unit Testing.
• Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout migration process.
• Interacted with the Administrators in the Performance Tuning of the Dashboards.

Confidential,Chicago, IL

Sr. Business Objects Developer

Environment: Business Objects XI R2, XI3.0, ECC 6.0, Oracle 10g, Crystal Xcelsius 2008, QAAWS, Voyager Erwin, Informatica, 8.x JSP, J2EE,MS SQL Server 2008

Responsibilities:

• Involved Design of Logical and Physical Model.
• Designed and Developed the Physical model and logical model.
• Involved Requirement Gathering and prepared Technical Speciation Documents.
• Designed Report Template Design Documents and Design the Universe.
• Developed critical WebI and DeskI reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Designed Universes based on SAP BW info Cubes
• Installed SAP Integration Kit for Business Objects Edge Series 3.0
• Created and Configured Roles in BW and Imported the roles into BOE(Business Objects Enterprise system )
• Created Linked Reports using Query Builder.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides

Confidential,San Francisco,CA

Business Objects Developer

Environment: Business Objects XI R2, ECC 6.0, Portal 7.0, Informatica, Oracle 10g, My SQL server 2000, and Java SDK

• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Created hierarchy and conditions in the universes.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects 6.1

Confidential, Chicago

Developer / Designer / Team Lead

Environment: Oracle 10g, Business Objects XI R2, Oracle Applications 11i (GL, AP, AR, HRMS), COBOL, SQL Loader

• BO WebI /DeskI Reports are generated using Oracle AP, HRMS and GL modules.
• Migrating BO Reports version 5.x to BO XI R2.
• Knowledge on Asset Management
• Fine tuning the performance of Universe and Reports.
• Modified the Universes, add additional Dimension, Detail, and Measure Objects according to the requirements.
• Extracted Data from COBOL file system and inserted into Oracle DB.