SUMMARY:
Information Technology Consultant with over 9 years of SAP Business Objects experience including SAP BI/BOBJ Developer and Admin with SAP BI 7.3, SAP BI 7.0, BW 3.5, and BI 4.0 Configuration, Implementation, Support, and Migration. Experience in Full Life Cycle Implementations, including Requirements Definition, Design Analysis, Coding, Data Modeling, Technical Upgrades, Documentation, Client Training, and Production Support. Extensively worked on preparing Functional & Technical specifications for BI BOBJ Reporting Requirements in Finance, Controlling, Manufacturing, Pharmaceutical, and Retail Industries. Experience in Data Modeling, Data Extraction, Data Migration, Data Integration, Data Testing, and Data Warehousing using Business Intelligence Tools. Good understand on SAP HANA and created Packages, Attribute Views, Analytical Views, Calculation Views in Information Modeler Tool. Expertise in troubleshooting and resolving complex BOBJ Integration with SAP BI issues like hierarchies, OLAP universe performance optimization and design, support/fix packs upgrades and content migration issues. Experience in Designing the Multidimensional Cubes, DSOs, and Multi-Providers. Utilize Application Process Designer (APDs) for developing various data models as per business requirements. Expertise in creating complex queries in BEx Query Designer/Analyzer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, Structures, and WAD Reports. Expertise in Installation and Configuration of BI 4.0, BOBJ XI 3.1/3.0/R2, SAP BI/BOBJ Integration Kit, Crystal Reports XI R2/2008. Expertise in BOBJ 4.0 version with BI Launch Pad, Information Design Tool, Interactive Analysis, Dashboard Designer, Upgrade Manager, and Life Cycle Manager. Expertise in Business Objects tools – Universe Designer, WEBI, DESKI, Crystal Reports, Xcelsius, Live Office, QaaWS, Infoview, and CMC. Expertise in Designing, Creating, and Testing Universes (OLAP/OLTP). Involved in development of Xcelsius dashboards using Live Office, QaaWS, and BICS connections. Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling Methodology, Filters, Ranking, Sections, Graphs and Breaks. Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, Stored Procedures and Functionalities like combined queries. Extensively worked on Central Management Console (CMC) in maintaining Objects, Universes, Connections, Folders, Users, User Groups, Calendars, Events, and Categories in BOBJ 4.0/3.1. Hands on experience on both Load Performance Tuning and Report Performance Tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning. Performed SQL Server/Oracle administration tasks and creating Stored Procedures, Views, Triggers, Functions and Query Tuning/Optimization. Active team player with excellent communication skills, interpersonal skills, analytical, problem solving and self motivated fast learner.
EDUCATIONAL QUALIFICATIONS:
Masters Degree in Computers Science. Bachelors Degree in Computers Science. Higher Diploma in Software Engineering I.T. ACQUAINTANCE:
Programming Languages:
C, C++, Java, Visual Basic, PL/SQL
Databases:
Oracle 10g/ 9i/ 8i, SQL Server 2K5/2K/7.x, DB2, MS – Access
Front End Tools:
MS-Office, MS-Visio, TOAD, SQL Developer
SAP ERP/BI/BW:
SAP BI 7.3/7.0, SAP BW 3.x, ECC 6.0
BOBJ Tools:
BOBJ BI 4.0, BOBJ XI 3.x/R2, Xcelsius 2008, Dashboard Design, Crystal Reports Enterprise 2011, Crystal Reports 2008/XI R2, Universe Designer, Information Designer Tool, WEBI, Interactive Analysis, DESKI, Live Office, QaaWS, BICS, BOBJ Explorer, CMC, CMS, Infoview, BI Launch Pad, Import Wizard, Upgrade Management Tool, Life Cycle Manager (LCM), Report Conversion Tool, Query Builder.
Data Modeling:
Dimensional Data Modeling, Star Schema, Snow-Flake Schema, Logical & Physical Data Modeling
ETL Tools:
Data Services/Data Integrator, Informatica
Application Servers:
Aptify 4.5, Trackwise Application 6.0, Bea Web Logic, IIS
Automation Tools:
Team Foundation Server, Rational Clear Quest, Rational Clear Case
Operating System:
Windows XP/2003 Server, UNIX, Sun Solaris, Mac OS
PROJECT DETAILS:
Project Title: Endeavour Phase II
Client: Confidential,NY
URL: Confidential,
Role: Sr. SAP BI/BOBJ Consultant
Environment: SAP BI Netweaver 7.3 EhP1/7.0 SP21, ECC 6.0, SAP BOBJ 4.0/XI 3.1 SP4, Business Explorer (BEx), Information Design Tool, Universe Design Tool, WEBI, Interactive Analysis, Xcelsius 2008, Dashboard Design, Crystal Reports Enterprise 2011, Crystal Reports 2008, BI Launch Pad, Infoview, Upgrade Manager, Life Cycle Manager, Import Wizard, QaaWS, Live Office, BICS, Central Management Console (CMC), SAP BOBJ Integration Kit XI 3.1 SP3, SAP BW Publisher, Essbase, Enterprise Portal, Tomcat Server, Windows
Business Area: FI – GL, AP, AR; QM, SD, MM, POSDM
Duration: March’11 – Present
Responsibilities:
Actively participated in all phase of the project – Scoping, Requirements Gathering, Gap Analysis, Blue Print, Design, Realization, and Post Production Support transition to Offshore BI team. Designed and developed functional and technical specifications for BOBJ reporting on top of SAP BI/BW and ECC as per the system landscape. Involved in migration of BOBJ XI 3.1 SP4 to BOBJ 4.0. Implemented SAP BI solutions to replace the aging legacy solutions which were based on Custom Planning Tools, Essbase reporting systems and move their entire Complex Planning and Reporting to SAP BOBJ WEBI, Crystal Reports, Xcelsius Dashboards, and BEx Extracts. Designed Complex Multiproviders to integrate POSDM Sales/Inventory/Purchasing data and provide reporting on huge data using BWA. Involved with the design of complex BI reports by utilizing Global/Local CKFs, RKFs, Exceptional Aggregations, User Exit Variables, and Conditions. Responsible for analyzing and creating SAP BI queries to mimic their legacy reports built over 10 years. Involved in the design and development/broadcasting of 56 Business Critical Queries (total of 190 reports based on 58 base queries). Some of the significant ones were: Merchandise Monthly Projection Report (MMPR) Merch Weekly By Dept/Style/Attributes Merch Daily Adhoc Midweek Recap Business Overview Recap Daily Flash Recap Store Plan and Allocation Age Shipment Report Inventory Control Template Sourcing Template Purchase Order Extract Goods In Transit Reports Cost Inventory Template By Store/Dept/Brand/Company Finance Template Gross Margin Reports Responsible for integration and development of BOBJ WEBI reports designed on BI query based Universes in the areas of Merchant Analytics, Inventory Management, and Purchasing. Created WEBI reports with multiple data providers and synchronized the data using merged dimensions. Responsible for the transports of all development objects using SOLMAN. Responsible for creating a daily reconciliation process for MMPR to detect issues before broadcasting the reports to business users. Supported BI implementation to align with the corporate strategy of opening stores in Canada. Supported the implementation of Multichannel reporting strategy to report on Sales/Movements across Multi Brands/Distribution Channels (Retail/Factory/Internet) Involved in improving performance issues in most of the reports. Ann Taylor has lot of complex reports developed using Navigational Attributes, lot of key figures used in the reports by which it will kill the performance of the report. To improve performance we suggested users to follow the below scenarios: Include filters as much as possible into the report. WEBI reports have query stripping to be checked. Set “Use selection of structure elements” in SAP BW RSRT Properties tab. Improve performance by capturing OLAP MDX Cache. By scheduling report user can’t wait for report to run. User will login into the Infoview and right click on the report then select “View Instance” by that user can see scheduled report data. Involved in defining security roles to the users to different groups like Back Office, Inventory, Merchandise, Supply Chain, Business Overview, and Flash. Imported all SAP roles into BOBJ, created User Groups, and assigned SAP Roles to User Groups in CMC. Created roles/iViews in SAP portal for the user to access WEBI reports and Dashboards using Single Sign On (SSO). Involved in validating installation of BOBJ 4.0 and its integration with the SAP BW 7.3 and SAP BWA 7.2. Used Import Wizard, Upgrade Manager, and Life Cycle Management tool and transported objects – Dimensions, Detail, Measures, Universes, Connections, Calendars, Events, and Publications from Development to Quality to Production. And integrated with respective BW environments and setting up the Single Sign On (SSO) across all the environments. Trained end users from different departments of Business Objects at Ann Taylor. Project Title: Data Warehouse Implementation & Financial Reports
Client: Confidential,DE
URL: Confidential,
Role: Sr. SAP BOBJ Consultant
Environment: SAP BOBJ XI 3.1 SP3, WEBI, Crystal Reports 2008, Universe Designer, Xcelsius, Live Office, Infoview, Central Management Console, SQL Server 2005, Aptify 4.5, Visual Studio 2008, SQL Server Integration Services (SSIS), Windows.
Business Area: FI – GL, AP, AR
Duration: Sept’09 – March’11
Responsibilities:
Gathered detail requirements from Finance Director, Business Users and delivered functional and design specifications through the use of Organization documentation standards. Involved in Full Life Cycle implementation of SAP BOBJ Reporting. Involved in extraction of data and created a SQL Server Jobs to replicate data from Accounting Package legacy system which is on Fox Pro Database into SQL Server 2005 database using SQL Server Integration Services (SSIS) and scheduled to run for nightly refresh. Involved in Data Modeling, Data Warehousing and designed different Schemas. Designed and developed complex OLTP Universes against SQL Server databases for General Ledger, Account Payable, Account Receivable, and Aptify applications. Created complex WEBI Reports and were formatted according to the user requirements using BOBJ functionalities like Breaks, Alerts, Ranking, Sections, Calculations, Slice & Dice, Master & Detail, Drill Down, and Variables. Created complex Crystal Reports using sub-reports, parameterized reports, and cross-tab reports for huge volume of data and pixel perfect well formatted reports. Involved in development of reports with Drill Down capability using WEBI in Infoview, worked on Adhoc Query, Reporting and Analysis. Broadcasted/Scheduled WEBI reports to individual recipients using Infoview Scheduling functionality. Worked with Admin team to integrate Dashboards, Reports into SharePoint Portal and Infoview for end user access. Involved in report migration from Crystal Reports to WEBI. Involved in designed and developed Business Critical Reports. Some of the significant reports are: Financial Statements Budget Management Reports Budget Planning Reports Budget Projection Reports Comparative Statement of Activities Reports Current vs. Proposed Budget Reports Designed and developed complicated reports using BOBJ functionalities like Hyperlink reports using OpenDoc, Graphical reports, Formula base well formatted reports. Created different User Groups like Accounting, Councils, Committees, Directors, and Global Affairs. Provided access to different user groups based on their related departments in Central Management Console System. Created Audit reports against SAP BOBJ Audit Database to track Organization functionalities and used BOBJ Query Builder. Trained end users how to use the SAP Universe in Infoview to create their own Ad-hoc reporting. Performed Unit Testing, System Testing, and User Acceptance Testing for Universes, Reports, and Security Management.
Project Title: Corrective Action and Preventive Action (CAPA)
Client: Confidential,IN
URL: Confidential,
Role: Sr. SAP BI/BOBJ Consultant
Environment: SAP BI 7.0, ECC 6.0, Business Explorer (BEx), BOBJ XI 3.0, Universe Designer, WEBI, Crystal Reports 2008, Infoview, Trackwise Application 6.0, Oracle 10g, Toad, Windows.
Business Area: Pharmaceutical
Duration: Jul’08 – Aug’09
Responsibilities:
Involved in all phases of SDLC, Gathering, Analysis, Blueprint, Document Functional/Technical Requirements, and Testing Universe and Reports. Involved in implementation of Full Life Cycle Management. Interacted with functional experts to gather the Project/Client requirements and conducted gap analysis. Involved in creation of Generic Extractors, Cubes, ODS, Mapping in BI. Extensively worked with the BEx Query Designer, BEx Web Application Designer (WAD), and BEx Analyzer. Involved in enhancement of the queries using Aggregation, Compression, and Partitioning. Involved in designed and development of critical reports like: FDA Audit Reports Complaint Management Reports Event Management Reports Quarterly Quality Metric Reports Designed, developed, and modified OLAP/OLTP Universes which are created against BEx Queries and Oracle Database. Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics. Created complex reports using the multiple data providers and synchronized the data providers using merge dimensions. Developed complex reports using BOBJ functionalities like Cross-Tab, Conditional, Drill-Down, Charts, Sub-Reports, Time Logics, Averages, Calculations, Variables, Breaks, Alerts, Ranking, and Sorting. Developed the Quarterly Quality Metrics report for end users to view Quarter wise using Drill Down option. Involved in creating complex queries, views, custom functions and Stored Procedures. Created Universe consisting of Derived tables to create the report for different Business Segments. Created Bar Charts, Line Charts and Bar Charts using Chart Expert in Crystal Reports. Business purpose is to create a metrics report in which end users want to display charts by quality events for particular date range. Developed reports using Queries, Slice & Dice, Drill-Down, Functions, Master & Detail, and Formula. Created various LOVs for ease of Adhoc reporting in the process of building Universes. Created summary level dashboards which will show the information by Area Level and Region Level.
Project Title: Calibration Manager (CalMan)
Client: Confidential,CA
URL: Confidential,
Role: SAP BW/BOBJ Consultant
Environment: SAP BI 7.0, ECC 6.0, Business Explorer (BEx), BOBJ XI R2, Universe Designer, WEBI, Crystal Reports XI R2, Infoview, Oracle 10g, Toad, Windows.
Business Area: Pharmaceutical
Duration: Jan’08 – Jun’08
Responsibilities:
Worked closely with the Business Lead and Application leads to understand the Business Model, Business requirements and developed the reports. Involved in Full Life Cycle Implementation of Calibration Manager. Involved in creating the Software Functional Specifications (SFS) and Software Detailed Design (SDD) documentations for all the reports under Calibration Manager. Involved in development of BEx queries to be used exclusively in BOBJ. Reports were created to query against the Business Objects OLAP/OLTP Universe. For this modified the existing CalMan OLTP Universe by adding Complex Objects, Derived table, and updated the Joins and Contexts. Created Calibration, Instrument Details, Instrument Performance, Instrument Reverse Traceability, Instrument Missing Notification, and Measurement Data Template Reports in Calibration Manager Project using Business Objects XI R2. Involved in creating the dynamic cascading prompts using Business Views and Optimized all the existing Business Views. Developed parameterized Crystal reports and customized reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, crystal syntax to create formulas for the reports.
Project Title: Product Complaint System
Client: Confidential,CA
URL: Confidential,
Role: SAP BOBJ Consultant
Environment: Crystal Reports XI R2, Trackwise Application 6.0, Toad 7.6.0.11, Oracle 9i, Clear Case, Windows XP, Windows 2003 Server.
Business Area: Pharmaceutical
Duration: July’07 – Jan’08
Responsibilities:
Worked closely with the end users and decision makers to understand the business and develop the reports. Involved in creating the Software Functional Specifications (SFS) and Software Detailed Design (SDD) documentations for all the reports under Product Complaint System Project. Involved in Clear Case for Version Controlling for all the Software Functional Specifications (SFS), Software Detailed Design (SDD) and Software Unit Testing (SUT) documentations for all the reports. Created Product Complaint Summary Detail, Complaint Contact, Product Complaint Rate, Complaint By Product By Defect Type, Complaints By Month/Year, Complaints Currently Open-Executive Summary Report, Complaints Open and Overdue – Executive Summary Report and Executive Summary Reports in Product Complaints System Project. Written all the Test Cases to perform Software Unit Testing (SUT) for all the 8 reports under PCS Project and executed all those Software Unit Test documents according to the test cases. Involved in creating the Views using Toad 7.6.0.11 and designed the layouts of the reports. Integrated all these reports with Trackwise Application. Developed parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, crystal syntax to create formulas for the reports. Explored several reporting features such as multiple sub-reports, for generating complex reports. Very good experience in creating multiple levels cascading prompt for both static and dynamic parameter. Created reports with number of sub-reports using different type of sub-report (Linked, Unlinked and On-demand sub-report). Created reports by extracting the data from Oracle 9i database into the Views. Involved in changing the Database location as per the user requirements from the Database tab in the Crystal Reports XI R2. Involved in creating the Bar charts, 3D Riser charts and Pie Charts from the chart expert. Business purpose is to display the charts by complaints received for particular date range. Project Title: Payroll Cost Hour Reduction
Client: Confidential,FL
Role: SAP BOBJ Crystal Reports Developer
Environment: Crystal Reports XI R2/10, Crystal Enterprise XI/10, Oracle 10g, TOAD, Windows XP
Business Area: FI - AP
Duration: Oct’06 – Jun’07
Responsibilities:
Gathering of requirements from different department’s viz., Payroll, Budgeting, Accounts and Production Planning. Design and Development of reports using dynamic data connections, Data foundations, Business Views Created reports using dynamic drop downs. Created employer cost reduction report using number of Filters, Dynamic drop downs and various list boxes for selection Created reports with formatting options such as Grouping, Sorting, Alerting, Field Highlighting, Drill-Down, and Parameter Prompts. Created multiple levels of cascading prompts for both Static and Dynamic parameters. Created the Business Views from the Crystal Enterprise and developed the reports using the Business Views as the data source in the crystal designer Created Integrate Employer Cost Reduction report with Oracle 10g database using Views and Stored Procedures. Developed scripts to create tables, views, synonyms, sequences, PL/SQL stored procedures, and functions. Involved in transformation of the existing crystal reports to meet user requirements. Published the reports in Business Objects Enterprise XI Scheduled for monthly and weekly run. Involved in scheduling the reports to run on daily/weekly/monthly basis and email the results to user in required format. Client: Confidential,INDIA
URL: Confidential,
Role: SAP BOBJ Consultant
Environment: SAP BOBJ XI R2, Universe Designer, WEBI, Crystal Reports, Oracle 9i, Toad, Windows.
Business Area: FI – GL, AP, AR; SD, Logistics
Duration: Sept’05 – Oct’06
Responsibilities:
Involved in deployment of Business Objects Reports on Web by using Web I and Broadcast Agent. Involved in Installation and Configuring of all products of Business Objects. Created Repository and assigned privileges to users and groups using Supervisor. Analyzed existing database and designed Universe using Business Objects Designer module for generating reports. Resolved loops by creating Aliases, Cardinalities, Joins & Contexts and checked integrity of universes. Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail, and Formula features. Automated document Scheduling, Publishing, and Distribution for Web I and Infoview clients using Broadcast Agent Server. Involved in optimizing Universe developing time and SQL Tuning to increase the query performance. Involved in creating the reports using the Universe as the main data provider and writing the complex queries including Sub queries. Project Title: ePurchase System
Client: Confidential,INDIA
URL: Confidential,
Role: Business Objects Reports Developer
Environment: Business Objects 6.5, Universe Designer, Full Client, Broadcast Agent (BCA), Supervisor, Oracle 9i, PL/SQL, Windows
Business Area: FI – GL, AP, AR, SD
Duration: Jan’04 – Aug’05
Responsibilities:
Creating, developing, maintaining, and testing the Universe for running the queries against the Database. Involved in Installation and Configuring of all products of SAP Business Objects. Created Repository and assigned privileges to users and groups using Supervisor. Created BOBJ reports using the Universes and Stored Procedures as main data providers. Designed the Universe by creating the Business Objects data model, selecting/joining tables, Indicating cardinalities, created aliases to resolve the loops, used Aggregate Aware function and created the objects which are grouped into classes based on Business Functionality. Presented data in Reports as per the User requirements using Various BO functionalities. Exported the Universe/Reports to the Repository/Broad cast Agent for automation. Managed project time-cost estimation and delivery schedules. Planned the effort and resources in the project plan. Preparation of Unit Test Plan and Unit Testing. Client: Confidential,INDIA
URL: Confidential,
Role: Business Objects Reports Developer
Environment: Business Objects 6.1, Universe Designer, Supervisor, Broadcast Agent (BCA), Crystal Reports, Oracle 9i, PL/SQL, Windows
Business Area: Pharmaceutical
Duration: Jun’02 – Nov’03
Responsibilities:
- Involved in Analysis, Requirement Gathering, Specification, Design, Development, Coding, Spread Sheet Modeling, Reporting and Reviews.
- Involved in creating Universes for various functional areas of high level reports group.
- Created Customized LOVs in Universe for quicker performance of reports.
- Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the integrity of Universe.
- Used SQL against the database to check data retrieved.
- According to the customer information created Complex report using Universe as main data provider.
- Exported Universe to the repository making resources available to the users.
- Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom Sorts, Cross Tab, Master Detail and Formulas.
- Exported reports to the Broadcast Agent and used the Broadcast Agent server to schedule and monitor the reports.
- Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL Command Objects, Selection Criteria, Grouping, Sub-reports, etc.
- Interacted with various users for reporting requirements.
Privacy Policy
