SUMMARY

• Over 9+ years of experience in Business Objects Enterprise Suite, Broadcast Agent Server, Publisher, Supervisor, import wizard and Info view, with SQL - Server, Teradata and Oracle databases.
• More than two Years of Experience as SAP Business Objects Data Services (BODS).
• Involved in full life cycle BW implementations along with other Post-Implementation and Post Maintenance projects in SD MM and FI/CO functional areas.
• Worked extensively on Administrative Workbench (AWB)/Data Warehousing Workbench (DWB) for Data Modeling, Scheduling and Monitoring data loads.
• Proficient of various data design models - Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models.
• Extensive experience in SAP BW/BI components like Info Cubes, Multi-Cubes, Info Source, Info Package, Data source, Info Objects, ODS (DSO), Update rules, Update routines, Transfer rules, Transformations, DTP.
• Expert in Performance tuning using Aggregates, Rollup, collapse, Partition, Repartition and Compression.
• Strong hands-on experience in BW/BI front-end and back-end development with a deep understanding of the SAP BW/BI tools and techniques.
• Expertise in designing Universes, WebI Reports, DeskI reports, and Full Client Reports.
• Experience in installation and configuration of Business Objects and Web Intelligence, creation of repositories with user groups and security implementation.
• Expertise in Business Objects XI R2/3 CMS, Universe design, Scheduling, import wizard, Publish wizard, Lifecycles manager, Desktop Intelligence, and Web Intelligence.
• Extensively worked on Business Objects 3.1, Business Objects XI R2, Crystal reports XI R2, XCelcius 2010, Tableau.
• Consulted on Tableau server performance enhancements; and server reconfiguration based on workbook complexity and data extraction

PROFESSIONAL EXPERIENCE

Confidential, Lake Mary, FL

BO Analyst Developer

Environment: BO 4.2, WebI, IDT, SQL server, Tableau

Responsibilities:

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Worked with several users, and interacted with them to gather requirements
• Ability to simplify, translate and explain complex processes write SQL statement and scorecard & dashboard formula.
• Developed WebI reports, extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks, Alerts, input controls.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, and Ranking.
• Extensively used slice and dice features, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.
• Improved performance by using @function, (@aggregate aware, @select, @Prompt, @where)
• Build Cascading Prompt, Cascading List of Values in BO - Universe Designer
• Build Row Level Security in Business Objects by Creating a Data Security Profile and Row Level Security In Business Objects Using a Security Table.
• Build and design new and change existing Universes, Classes and objects, resolved loops and Traps using Contexts and Aliases while designing Universes, setup Universe level conditions to restrict data based on report requirements.Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Experience in building dashboards, score cards, metrics using Xcelsius, using query-browser for adhoc reporting.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of customers, project, time and location dimension.
• Built Tableau dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
• Implemented hierarchies in Tableau with Region as the highest level followed by Country and City with other details.
• Used CMC for User creation and given folder permission to the user.
• Created user right & permission using security editor based on the profile for report access.
• Worked on Publication and scheduling in sap BO.
• Experience using CMC in an administrative capacity, including creating User & Roles, troubleshooting security issues, and folders rights.
• Monitoring all the related CMS, Audit and Reporting Database services
• Verifying Web applications (CMC, Info-view, Custom Applications) availability
• Monitoring day to day scheduled report jobsfromInstance Manager
• Provide technical support for existing reports, dashboards, or other tools.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Work with users requesting data pulls or reports, to clarify data availability, data access issues, user requirements, and set priorities.
• Write requirements documents for the customer requesting data formal approval.
• Write specifications for the team programmers and/or report developers. Perform quality assurance on data and reports to ensure they meet the specified user requirements.
• Write technical and user documentation for data marts and applications.
• Analyze data from multiple data sources to establish true definitions of the data and what types of additional data are needed, in what format, to what level of specificity.

Confidential, New York, NY

BO Analyst Developer

Environment: BO 4.1, WebI, IDT, Sybase IQ.

Responsibilities:

• Lead & manage project technical team BI Analytics deliverables to ensure business objectives are met.
• Proficient in converting user requirement into functional specs and technical specs.
• Prepare appropriate documentation and ensure that new functionality is properly transitioned to reporting users.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Recommended SAP best practices for developing Universes, reports and dashboards.
• Build and design new and change existing Universes, Classes and objects, resolved loops and Traps using Contexts and Aliases while designing Universes, setup Universe level conditions to restrict data based on report requirements.Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Extraction data from different source systems and building universe design in BO and delivering dashboards & Webi reports.Created Derived tables in the designer to enhance the capabilities and performance of the universe, Customized Universe Level Prompts as per functional Requirements.
• Created reports using Business Objects functionality's like Drill Down, Cross Tab, and Formula's.Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 4.1 like Optional Prompts, Functions, and Alerts.
• Improved performance by using @function, (@aggregate aware, @select, @Prompt, @where)
• Build Cascading Prompt, Cascading List of Values in BO - Universe Designer
• Build Row Level Security in Business Objects by Creating a Data Security Profile and Row Level Security In Business Objects Using a Security Table.
• Migratedobjectsfrom BO 3.x to BI 4.1 using upgrade management tool.
• Used Promotion Management (LCM) to promoteobjectsfrom one environment to other environment - Dev to QA and to Production.
• Created Breaks, input control, filters at different levels of the reports and applied ranking in the Webi reports.Extensively worked with formatting the reports according to the user requirements.
• Resolved data issue and bugs in the data design, and also fixed report as per customer requirement.
• Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development.
• Created transport in sap BO using promotion Manager, and maintain reports, IDT, Universe, and Connection in Version Management.
• Used CMC for User creation and given folder permission to the user.
• Created user right & permission using security editor based on the profile for report access.
• Worked on Publication and scheduling in sap BO.
• Experience using CMC in an administrative capacity, including creating User & Roles, troubleshooting security issues, and folders rights.
• Followed sap best practices in report development and maintenance of universes.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Work with users requesting data pulls or reports, to clarify data availability, data access issues, user requirements, and set priorities.
• Write requirements documents for the customer requesting data formal approval.
• Write specifications for the team programmers and/or report developers. Perform quality assurance on data and reports to ensure they meet the specified user requirements.
• Write technical and user documentation for data marts and applications.
• Analyze data from multiple data sources to establish true definitions of the data and what types of additional data are needed, in what format, to what level of specificity.

Confidential, Baltimore, MD

SAP BO Analyst Developer

Environment: BO 4.1, WebI, IDT, Celsius 2010, ECC 6.0, SAP SRM.

Responsibilities:

• Gathered requirement, analyze sap standard BI content and data models, and performed Gap Analysis; and added new functionality in the areas of Finance & Controlling, & SRM.
• Involved in the designing and Building of Universes, Classes and objects, resolved loops and Traps using Contexts and Aliases while designing Universes, set up Universe level conditions to restrict data based on report requirements.Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Check the integrity of the Universes, and export the universes to Repository for making available to users
• Created reports using Business Objects functionality's like Drill Down, Cross Tab, and Formula's.Created.
• Resolved data issue and bugs in the data design, and also fixed report as per customer requirement. Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Developed Dashboards according to user specifications.Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development.
• Created transport in sap BO using promotion Manager, and maintain reports, IDT, Universe, and Connection in Version Management.
• Used CMC for User creation and given folder permission to the user.
• Created user right & permission using security editor based on the profile for report access.
• Worked on Publication and scheduling in sap BO.
• Build Cascading Prompt, Cascading List of Values in BO - Universe Designer
• Build Row Level Security in Business Objects by Creating a Data Security Profile and Row Level Security In Business Objects Using a Security Table.
• Migratedobjectsfrom BO 3.x to BI 4.1 using upgrade management tool.
• Used Promotion Management (LCM) to promoteobjectsfrom one environment to other environment - Dev to QA and to Production.
• Design and develop universes, SQL reports, web-intelligence reports, analytical dashboards, metrics and KPI’s. Develop database DDL scrips, ETL packages and data models for reporting purposes.
• Design and develop external user interface dashboards for information display.
• Work with developers to resolve complex data analytics problems with advance SQL queries and data transformations. Design data flow logistics from various sources into reporting environment.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Worked with data services to load ETL data.

Confidential, Valencia, CA

SAP BO/BW Analyst Developer

Environment: BO XI R3 Import Wizard, Webi, Oracle, sap BOBJ.

Responsibilities:

• Gathered requirement, analyze sap standard BI content and data models, and performed Gap Analysis; and added new functionality in the areas of Finance & Controlling, sales & Distribution, Material Management.
• Explore SAP BI reports, Spending Analytics to delve into your procurement activities and pinpoint how much you’re spending, with which suppliers, and on what materials. Establish procurement key performance indicators (KPIs), conduct in-depth analyses of your procurement spend, and generate meaningful business intelligence that will help you identify your biggest cost savings opportunities and determine where you have the greatest negotiating power with your supplier.
• Explore SAP BI/BO reports, on Sales & Distribution and Material Management analysis, Base on Sales order, Delivery’s, Return’s & Billings, Fulfillments.
• Used and Enhance Profit center extract using BW, 0EC PCA 1, 0EC PCA 3, 0EC PCA 4 only provides the balance by period (BALANCE ) without sale period information, this is provided in 0EC PCA 3.
• Design comprehensive report that shows you how to in corporate financial, sales, and purchasing data in the same SAP BW report to glean the overall business implications of your financial activities and decisions.
• Involved in Performance Issues like Creation of aggregates, RollUp and Compressed the InfoCube to improve the query response.
• Optimized web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.
• Configured/fine-tuned the performance parameters of all BO processes.
• Performance tuning of Webi reports on OLAP Universes using optimization techniques like query stripping.
• Involved in performance tuning of infoset & multi-provider and also in enhancement features of info-cube like partitioning, Indexing, maintaining aggregates and compression. Extensively worked on BEx-Analyzer and create BEx-Queries, Exceptions, Conditions, Calculated Key Figures, and Restricted Key Figures.
• Generate universe on Top of BEx Query, Developed Webi report, and Implemented Process Chain to automated Entire system including data load, BEx broadcaster. Given expert recommendations for how to in corporate more comprehensive SAP BI slice-and-dice capabilities directly building advance feature in Webi report. Build, execute, and link complex calculations so that your reports generate more detailed analyses and results.
• Work on KPI & Metrics, formulas, both simple and complex, for rolling up granular income statement data into higher level intercompany balance sheets using SAP BW. Move from standard balance sheet and income statements to detailed reports that include financial ratios and KPIs such as return on assets, inventory turns, and return on investments.
• Provide a better understanding of how best to generate month-end financial reports, including cash flow reports, Balance-sheet, income statement. worked on Semantic-Partitioned-object (SPO), Data-Flow, manage to create model with different source, and have SPO based on Period and region and Data-Source and manage to bring data from different country and region.

Confidential, Dublin, OH

SAP BO/BW Analyst Developer

Environment: BO XI R3 Import Wizard, WebI, Teradata, sap BI.

Responsibilities:

• lead and manage SAP BW & BO architect role, completed full life cycle BI Implementation, gathering requirements, analysis, data modeling.
• Gathered requirement, analyze sap standard BI content and data models, and performed Gap Analysis; and added new functionality in the areas of Finance & Controlling, sales & Distribution, Material Management.
• Worked with End-users, gather requirements, Functional and Technical specs, and transformed them into a data model using extended star schema.
• Worked with various standard as well as custom BI/BW data source in FICO, FI-CA, FI-GL, IM, MM, HR and SRM and enhanced the extract structure to support business needs.
• Used extractors; New General Ledger (FI-GL), Segment Reporting (FI-GL), & Profit Center Reporting (FI-GL), and flourished financial management reports; high level Balance sheet, income statement, cash flow statement, and G/L Account Balance (Analysis), analyzes G/L account balance basis on (opening, debit, credit, total) using sap standard BEx and bring the data to SAP BO Level.
• Generate Business Objects universes ; info cube 0OPA C30 and 0OPA C20 analysis report like Orders: Actual/Plan/Variance - Statistical Key Figures, Cost Elements, Breakdown by Period and partner, Actual/Plan/Variance Totals, Budget/Actual/Commitments and Actual Line Items.
• Designed the architecture and lead the development of data providers and reports on the CO-PA Transaction Data in BI 7.0
• Used extractors; CO-PA Transaction Data (S GO) (0CO PA 10), and generate reports like PA Net sales(Analysis), Contribution Margin I and II, Operating Profit (Analysis) CM I & II and published Webi reports on enterprise portal environment.
• Designed and developed various Data targets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets.
• Enhanced procurement extractor like2lis 02 Itm, 2lis 02 Scl,2lis 02 Hdrand populated into the procurement infocubes0pur C07, 0pur C08, And 0pur C09as per customer requirement.
• Createdsetup tablesfor the LO-Cockpit extraction, performingV3 updateusing LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.
• Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution (SD) modules(salesorder "2lis 11 vahdr/vaitm", shipping/delivery "2lis 12 vchdr/vcitm")and(billing "2lis 13 vdhdr/vditm”).
• Done performance, worked with aggregates, rollup and compressed the infocube to improve the query performance.
• Worked with BEx, and developing complex custombobjreports, Extensively usedformula and formula with condition.
• Optimized web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.
• Implemented Row Level Security in Business Objects. And provided the security access management by creating users/groups/folders, and given the access rights to the available set of users based on their profile (Based on Sales hierarchy).
• Worked on Business Objects universe-designer base on Kimball methodologies, creating semantics Layers on-top-of Teradata, with Class & objects having business naming conventions, hierarchies, aggregate awareness, Cascading LOV, creating new derived objects, shortcut joins, defined alias tables and Contexts to resolved loops, fan and charms trap.
• Worked with scope of analysis to give more details on the results returned by each of the objects in a query.
• Extensively used Formula & Variables, and Used the Slice and Dice feature.
• Design/build combined queries on the same/different universe, build union/ intersection/ minus Query between Combined Query.
• Design functionalities like Breaks, Filters, Query Prompts, Conditions, Alerts, Ranking, Sorts and highlighting data.
• When designing the Universe and building Webi report all care was taken of performance.
• Wrote complex freehand SQL in Teradata and Compare report test result.
• Created transport in sap BO using promotion Manager, and maintain reports, IDT, Universe, and Connection in Version Management.
• Used CMC for User creation and given folder permission to the user.
• Created user right & permission using security editor based on the profile for report access.
• Worked on Publication and scheduling in sap BO.
• Experience using CMC in an administrative capacity, including creating publications, troubleshooting security issues, folder and category administration.

Confidential - MT Laurel, NJ

SAP BO Developer

Environment: BO XI R3 Import Wizard, Lifecycle Manager, Web I, Visio, Rational Rose, Oracle 10.2

Responsibilities:

• Conduct BusinessUsers Interface, participated in the business meetings and prepared business requirement documents (BRDs), detail design document (DD). During the BRDs development period, certain outstanding critical issues, decision not made for items were resolved thru email and extra business meeting were conducted.
• Gathered business requirements from each individuals and prepared conceptual data model and technical High Level design documents in MS Visio.
• In design Data modeling build structures and relationships between them, created data elements using in rational Rose 7.0
• Expertise and hands-on in advanced data modeling techniques, including star schemas, Kimball methodologies & ETL strategies.
• Studied existing reports (Legacy system) from different system, and consolidate those reports in different category, with help of existing reports build functional & technical model.
• Build indexes, primary & foreign key and joint relation with DIM and Fact Tables.
• Allocated and manage Table spaces with data volume and the traffic load.
• When designing the modeling all care was taken for performance.
• Worked on Business Objects universe-designer suite including, creating semantics Layers, with Class & objects having business naming conventions, hierarchies, aggregate awareness, Cascading LOV, creating new derived objects, shortcut joins, defined alias tables and Contexts to resolved loops, fan and charms trap.
• Follow SAP best practices in model design, universe creation, and business object report development.
• Have experienced in Designing/developing/maintaining Business Objects Universes.
• Created advanced and complex Business Objects Webi reports using Universes, Used the Drill Down/Up functionality to analyze data in Web I. Used Drill filters statement with open document.
• Wrote complex freehand SQL in Oracle Plus and used EXPLAIN PLAN to fine tune the query.
• Store procedure & SQL views were created based on customer requirement.

Confidential, St Louis, MO

SAP BO Developer

Environment: BO XI R3 Import Wizard, Lifecycle Manager, Designer, Webi, Crystal.

Responsibilities:

• Designed and developed universe using universe designer for ICOMS system, and tested and fixed issues identified and know with prior universe.
• Experience creating advanced and complex Business Objects reports using Universes, Used the Drill Down/Up functionality to analyze data in Webi. Used Drill filters statement with open document, Added Hyperlinks with Drill filters parameters for master/detail report analysis.
• Created complex reports using the multiple data providers and join and synchronized the data providers by linking the common objects to create the common report.
• Done the report format changes and fixes issue which were prior Webi and Crystal reports. And documented the universes/report changes and fixes.
• Created, managed & format standard, master/detail reports with Crosstabs, Vertical/ Horizontal Tables. Work with advance features like set Section and subsections, merge dimensions, add Query and Combined Query.
• Worked with scope of analysis to give more details on the results returned by each of the objects in a query.
• Extensively used Formula & Variables, and Used the Slice and Dice feature.
• Design/build combined queries on the same/different universe, build union/ intersection/ minus Query between Combined Query.
• Design functionalities like Breaks, Filters, Query Prompts, Conditions, Alerts, Ranking, Sorts and highlighting data.
• Troubleshoot and provided quick resolutions to development and production issues.
• Implemented Row Level Security in Business Objects. And provided the security access management by creating users/groups/folders, and given the access rights to the available set of users based on their profile.
• Maintained development and Production BOE environment and used import wizard & Lifecycle manager, for moving the objects from development box to production box. Overcome the Issue of CUID in different Landscapes.
• Done performance in Webi, universe designer and fine tune query performance, with help of Explain Plan in oracle.
• Store procedure & SQL views were created based on customer requirement.
• Wrote complex freehand SQL in Oracle and used EXPLAIN PLAN to fine tune the query.

Confidential, Indianapolis, IN

SAP BW Developer

Environment: BW 3.5, Oracle 9i, UNIX, BEx, WAD, BEx Query, BEx Analyzer

Responsibilities:

• Core responsibility is Preparation of Data flows, functional feasibility analysis, Business Blue Print, activity execution, Preparation of cutover activities and Post go live support.
• Gathered requirement, analyze and translate business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Develop and maintain project schedules including activities, resources, hardware, internal and external partners. Produce and deliver presentations to executives concerning project progress, issues, and risks.
• Performed Gap Analysis after studying existing system and gathering Business Requirements from end-user for Sales & Distribution (SD) and Account receivable (AR).
• Responsible for gathering requirement and performed Gap Analysis after studying existing system; contract AR alternation to Business content, and added new functionality in Dunning and FI-CA: Open Items. Line Item Extractor for General Ledger Accounting.
• Develop Design document in area of extractor alternation A/R line, A/R transaction, and payment history.
• Designed and maintained Sales InfoCube, DSO, InfoObjects, and Data source. Enhanced Business Content Data source as per requirements. Extracted Sales data using Logistics Cockpit (LO Cockpit), and Scheduled data loads, both for delta and full uploads.
• Created & enhanced existing transfer rules, transfer routines, update rules, start routines to maintain data consistency.
• Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Implemented CO-PA for profitability analysis to meet use requirements.
• Created MultiProvider for logical integration of Sales & Distribution InfoCube and ODS.
• Implemented Process Chain to automated Extraction of Data from R/3 to Sales and Distribution (SD) InfoCube and ODS in BW.
• Worked extensively on both-end of Enterprise Data Warehousing; bank-end and front-end, worked on enhancement of Data source, done enhancement using user-exit & badi, created view and sql query and pull information from the other table to the enhanced Data source.
• Extensively worked on BEx Analyzer and to create Queries, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and web templates.
• Designed and optimized queries (top customers, monthly incoming orders, product analysis, returns) and created reports using BEx Analyzer.
• Created Jump Queries using RRI (Report to Report Interface) to give facility to drill down Report from summarized format to detailed format. Used Web Application Designer to develop web reports.