SUMMARY

• Highly accomplished SAP Business Objects professional wif over 10+ years of extended experience in Business Intelligence Solutions development using various tools from business intelligence technologies of SAP,BO4.0/BO4.1, BOXI3.1, BOXIR2, Crystal Reports 2011/2008, Xcelsius Dashboard 4.0/2008.
• Delivered results impacting business to great value for my employers.
• Extensive noledge on data architecture, database - related technologies, software platforms and architecture assessments specifically in DW architecture
• Strong Experience in understanding of entire Dataware Housing project Life Cycle Management.
• Worked extensively in leading, developing and implementing report solutions on Business Objects
• Proficient in in Implementation, configuration, administration, migrations and support of Business Objects Enterprise XI R4.0 / R3.x/R2/6.x and Crystal Enterprise
• In depth noledge in Advance Analytics, Dashboard Designs, Ad hoc Query Report
• Strong Experience in Universe,WEBI,Crystal Reports and Dashboard Design
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Skillfully drove execution of migration from BO3.1 to BO4.0/BO4.1/4.2BO5.1.7 to BOXIR2/BOXIR3.1

TECHNICAL SKILLS

BI Tools: SAP BO4.2/BO4.1/BO4.0,BOXI3.1,BOXIR2,BO5.1.7,Crystal Reports XIR2/2008/2011SAP BO Dashboards/Xcelsius, BO Explorer,BI7.0/7.2/7.3

Operating Systems: Windows XP/ 7/2003/2008/2012 , Linux, etc.

Database: Oracle 10g/11g, Sql Server 2005/2008/2012 , Teradata12/13

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr. Business Objects Administrator

Responsibilities:

• Designed road map for BO4.2 infrastructure implementation that included server sizing, pre-installation, installation process, server configuration, and clustering and security implementation.
• Installed and configured BO4.2 Sp2 on windows 2008/2012 servers
• Supported all facets of Enterprise Reporting Solution.
• Performed a lead role in providing skilled technical support associated wif server operation and maintenance.
• Tuned Adaptive processing server using System Configuration Templates for Optimal
• Migration activities between dev,qa and Production environments
• Monitoring BO Servers for report executions and BODS job servers for data loads.
• Configured Auditing to track BO application usage statistics in day to day activities
• Created audit reports for Peak load,Top ten long running reports and Top ten most usage reports and sending it to Management on weekly basis.
• Automated cleanup of BO users inactive sessions
• Coordinated wif SAP to resolve teh BI4 performance issues and implemented fine tune procedures such as Adaptive Processing Services Split, Java heap size increase, Tomcat heap size and session time outs.
• Maintained Microsoft Server 2008R2 and 2012R2.
• Managed application environment including structures and security.
• Configure data source connections on servers (Oracle, MSSQL, DB2, etc)
• Consult wif and make recommendations to Technical Managers regarding hardware and software upgrades, and maintenance contract issues.
• Responsible for solution version management, including service pack, fix pack, and hot fix testing and installation.
• Research (along wif development team) teh latest advances in teh SAP reporting suite of products and make recommendations to Agency.
• Manage report object and historical instances (failed and successful). Worked wif users to purge unused objects.
• Performed system maintenance.
• Provides system governance oversight.
• Responsible for monitoring solution status through regular checks throughout teh day.
• Periodically reviews failed instances and investigates issues.
• Assists users wif “Best Practices” for teh reporting solution.
• Assists users in troubleshooting reporting solution related issues.
• Serves as a liaison between Agency and solution’s contract holder/manager regarding SAP Enterprise Agreement matters..

Environment: SAP BO 4.2SP2, 4.0SP8, BO DS4.2, BODS4.0SP3, SAPBOX3.1, Oracle 11g, Oracle 12C Tableau9.1, Oracle EBS R1213, Sql Server 2008, Redhat Linux5.7

Confidential, Chicago, IL

Sr. Business Objects Consultant

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC) like requirements gathering, preparation of technical specification documents, designing and developing reports, unit testing and UAT
• Interacting wif teh Business Users to analyze teh business process and gathered teh requirements
• Analyzing teh present Oracle EBS and BI Architecture for identifying and understanding teh reporting gaps and requirements
• Developed prototypes in requirement analysis phase for better Report designs
• Preparing estimation plan for technical design, coding, unit testing and system testing.
• Designing business mapping layers as per teh requirement to specific domain on top of relational databases tables, views using Universe Designer and Information Design Tool.
• Developing BO universes utilizing BO features such as contexts, aggregate awareness, index awareness, derived tables, @functions, row-level security, object-level security, dynamic cascading prompts, custom hierarchies for drill down and filters.
• Implemented row-level security based on user roles in IDT
• Developed Dashboard Reports which has bar charts, bar stacked charts, heat maps, Area charts, Bubble Charts, Arrow Charts, Gantt Charts, Pie Charts & Scatter Plot.
• Creation of highly interactive and CREATIVE dashboard reports wif drill down functionalists
• Performed and documented Unit testing and involved in UAT for both Webi reports and Dashboards.
• Created drill-through reports using opendoc functionality
• Involved in migration of BOBJ objects using Promotion Management.
• Review teh reports and teh technical and functional documentation.
• Worked wif team to ensure deliverables/milestones are being met as per teh project plan.
• Involved in Post Production go-live support.

Environment: SAP BO 4.0SP8,BODS4.0 SP3, SAPBOX3.1, Oracle 11g,Oracle 12C RAC,Oracle EBS R1213,Sql Server 2008

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Coordinated wif business users in identifying various metrics for reporting, developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, R/3 & SQL systems as per teh system landscape.
• Created universes as per teh requirement to specific domain on top of relational databases tables, views using Universe Designer and Information Design Tool.
• Created BO universes (UNX/UNV) on top of SAP BW - Cube/Multiprovider/Bex queries.
• Supported Business Objects wif BW cubes and query design wif a good understanding of BW.
• Developed WEBI reports on top of OLAP and relational universes and Bex queries. Modified existing reports to support new and additional business requirements.
• Used Restricted (RKF) and Calculated Key Figures (CKF), Filters, Structures, Conditions, Formula Variables, Replacement path variables, customer exit variables and user entry variables in teh Query Designer to develop WEBI reports.
• Developed Crystal Reports on top of operational in development to supply business wif improved flexibility and functionality.
• Created Xcelsius dashboards for visual understanding of information and published to BO Enterprise.
• Created interactive Dashboards and business presentations by importing data from Excel sheets using Crystal Xcelsius.
• Migrated universes, connections, WEBI Reports and Crystal Reports as part of Content Migration from BOXI3.1 to BO4.0 Using Upgrade Management Tool.
• Converted universes from UNV (Universe Designer) format to UNX (Information Design Tool) support format.
• Conducted thorough data validation using different unit test cases.
• Supported integration testing performed by client and resolved defects on time.
• Documented functional and technical specifications for teh reports developed.
• Changed existing queries according to teh adhoc requirement of teh client time to time.
• Reviewed and updated existing reports to comply wif Business Intelligence and Reporting standards.
• Performed analysis to investigate and troubleshoot data inconsistencies and data integrity issues.
• Participated in client interaction meetings and training sessions.
• Supported noledge transfer to BO developers and end user

Environment: SAP BO4.1, BOXI3.1, Information Design Tool, Universe Designer, Web Intelligence, Upgrade Management Tool, Crystal reports 2008/2011, Sql Server 2008, SAP BI7.3, Windows 2008

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Conducted requirement collection sessions and prepared Business Requirement Documents.
• Analyzes and identifies core business process for Reporting application design
• Understanding Business requirement and translating them into Operational requirement to deliver teh appropriate documents as needed
• Responsible for documenting functional requirements (including data flows and high-level source to target data mappings) as part of creating advanced global reporting initiatives.
• Developing prototypes in requirement analysis phase for better Report designs
• Preparing estimation plan for technical design, coding, unit testing and system testing.
• Designing business mapping layers as per teh requirement using Universe Designer and Information Design Tool.
• Migrated Web Intelligence report from XI 3.1 to BOBI 4.0 using Upgrade Management Tool
• Developed Complex WEBI and Crystal reports based on teh customer needs.
• Expertise in using Upgrade management Tool and Report Conversion Tool for migrating teh Universes and Reports between different environments
• Work closely wif Operations Manager and Marketing/Business Development Manager to TEMPeffectively implement teh overall business goals.
• Provide customer engineering service support, system troubleshooting and technology solution recommendations.
• Contribute to teh team for providing necessary inputs to teh data model.
• Co-ordinate wif various content development teams across organization and bring in teh feedback/best practices to teh product.
• Do teh feasibility for teh content development requirements during teh initial phases of teh product.
• Contribute towards Technical analysis and development of mediation and other modules.
• Design documentation and fault correction for teh issue raised.

Environment: SAP BO4.0, Business Objects XI 3.1, Information Design Tool, Universe Designer, Desktop Intelligence, Web Intelligence, Crystal Reports, Oracle 10G, SQL Server 2005/2008, Windows 2008

Confidential, Chicago, IL.

Business Objects Developer

Responsibilities:

• Interaction wif business partners for requirement gathering; collaboration wif business community to understand, documentation and prioritization of teh requirement.
• Assisted data designers wif semantic models for ad hoc reporting.
• Prepared high level designs specifications and supported prototypes in requirement analysis phase.
• Designed BO universes utilizing BO features such as contexts, aggregate awareness, index awareness, derived tables, @functions, row-level security, object-level security, dynamic cascading prompts, custom hierarchies for drill down and filters.
• Created complex WEBI Reports using multiple data sources such as universes, business views wif BO features as linking data providers, combined queries, hyperlinks, breaks, sections and ranking.
• Implemented security in Universe objects to restrict report access for users belonging to different geographical locations.
• Created necessary views and aggregate tables to enhance performance of reports to satisfy customer requirement.
• Developed various charts and graphs as bar chart (side by side, stacked), line graphs and pie charts by using chart expert of Crystal Reports 2008.
• Supported crystal complex reports that required running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields and messages.
• Developed several complex reports including multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database using Crystal Reports.
• Used stored procedures, Free Hand SQL and excel files as data providers for creating reports.
• Provided SQL tuning and optimization using indexes and optimizer hints, materialized views and aggregated tables.
• Conducted unit testing and peer reviews.
• Migrated BO 5.1.8 DESKI and WEBI reports to BOXIR3 using Import Wizard.
• Converted BOXI DESKI reports to WEBI reports using Report Conversion Tool..
• Proposed and developed new designs for some reports which were not migrated from BO5.1.8 DESKI to BOXIR3 WEBI.
• Scheduled and distributed reports to users using CMC/Infoview and monitored and converted reports to PDF.
• Maintained and supported Existing reports and universe.
• Published reports to repository from where end user viewed reports on infoview after authentication.
• Created BIAR files for backup and recovery of teh CMS.
• Utilized source code control management systems (VSCC) to tightly integrate teh activities of teh teams.
• Participated in QA and UAT processes by modifying code to fix critical defects in order to ensure approval of teh deliverable(s).
• Provided expert help for all BO developers in design and development of universes and reports.
• Resolved users’ problems wif BO reports.
• Presented advanced features of Business Objects to end users to enable them to develop queries and reports easily for adhoc analysis.

Environment: BO5.1.7, SAP BOXIR3, CCM, CMC, Import Wizard, Universe Designer, Web Intelligence, Crystal Reports 2008MS SQL Server2005, Oracle 9G, Teradata

Confidential

Business Objects Developer

Responsibilities:

• Analyzed existing database and designed Universes, using Designer module to generate reports.
• Resolved data integrity issues that appeared among various data and business entities.
• Developed classes, objects and created Universes to retrieve data from Oracle database for reporting needs of management and end users.
• Used various functionalities of Universe such as Cardinalities, Contexts, Joins and Aliases to resolve Loops and checked integrity of Universes.
• Provided Aggregate Awareness in Universe to make TEMPeffective use of teh Summary Tables to improve performance and response time of teh reports.
• Created Web Intelligence and Desktop Intelligence reports wif multiple data providers like Universes, Personal Data Files and free-hand SQL
• Applied security features such as report level and object level security in Universe.
• Created multi master-detailed reports wif slice-and-dice and drill modes for multi-dimensional analysis of retrieved data from SQL server 2000 and used LOV’s, cascading prompts. Utilized teh Business View Manager feature of Crystal Reports to generate reports.
• Organized data in teh report, inserting filters, sorting and highlighting data.
• Used Web Intelligence to create, analyze and publish Business Objects reports to various user groups in Info view.
• Authenticated users, provided privileges, and made resources available to users through repository.
• Documented all design and development efforts in accordance wif Software Development Life Cycle standards.

Environment: Business Objects 5.1.7, Business Objects XI R2, Crystal Reports XIR2, Oracle 8i, and SQL Server 2005.

Confidential

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about teh financial system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating teh pay roll reports for sales, marketing reports for marketing group users.
• Interacted wif customer support regularly, in order to generate teh reports required and to resolve teh existing issues.
• Created Universes by defining connections and retrieving data from database.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing teh universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created and modified teh Crystal Reports for various financial groups using teh Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Imported/ Exported teh Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in teh universes.
• Involved in creating various reports by extracting data from Data Marts
• Created reports using Oracle Databases and Personal Data File Providers.
• Monitored and solved teh issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Business Objects XIR2/6.5 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), Crystal Report XIR2, MS Access, Oracle 9i, SQL, PL/SQL and Windows 2003.