Reports Project
Resume:
Rubin Chelladurai
SAP BO/BI Consultant
********@**********.***
Summary
Have been in the datawarehousing and Business intelligence practice through my career and have worked on the complete enterprise information solution offered by SAP.
Have extensively worked on the reporting solutions offered by SAP and migration of SAP BI (Business Intelligence) system.
10+ Years of experience in SAP Business Objects (BOBJ) 4.1 Sp5/4.0/XIR3.1/XIR2 using different tools like IDT, UDT, BI launch Pad, Business Object universe Designer, Desktop Intelligence, Web Intelligence, InfoView, Dashboard, Scorecards, Central Management Console, Xcelsius 2008, Design Studio, Crystal Reports 2011, Tableau 8.3, Oracle 11g/10g/9i.
Over 3 years of experience in Xcelsius 2008 using QAAWS & Web services, Live Office.
Developed dashboards using SAP Xcelsius. Delivered Decision Support Systems(DSS) involving integration of SAP business objects with SAP Business warehouse(Business Objects Universe built over BEX Query developed on top of multiprovider). Proposed the design for the DSS and have good exposure to the SAP BW environment that was loaded using SAP Data Services to meet the design proposed.
Good understanding on ETL concepts which involves creation of complex Jobs, Work Flows, Data Flows and using different Transformations to successfully load data from multiple sources into a desired target.
Experience in gathering business requirements and building Universes, Reports and Dashboards.
Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness, applied row level and object level securities on different groups and users using Business Objects Designer.
Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects 4.0/XIR3/XIR2/6.5.
Worked with Crystal Reports 2011 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
Used Universe Webi Reports as a Data source of Xcelsius to build the dashboards through live office & QAAWS to consume live data.
Excellent understanding of Data Warehouse architecture, Star Schema, Snowflake Schemas, Fact and Dimensions Tables.
Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
Involved in gathering, analysing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
Involved in all the stages of Software Development Life Cycle.
Expertise in SQL, PL/SQL, My SQL, Stored Procedures, Functions, Cursors, Packages, Views, Indexes
Proficient in working on development environment in different RDBMS (Oracle, DB2 etc)
Strong writing and documentation skills for the management, development and control of documentation.
Good work experience on the banking and finance domain and have worked with brokerage/banking firms offering Brokerage Service, Bank Service, Option Link Service, Loan / Lending Service, Credit Card Business.
Competency: Business Objects (SAP BI 4.1, XIR3, XIR2 & 6.5), Xcelsius 2008 SP3, Business Objects Live Office XI 3.1 SP3, Query As A Web Service, SAP System – Business Objects Integration, Tableau 8.3
Technical Skills
Operating System
Unix, DOS, Windows
Programming Languages
C, PL/SQL
Scripting Languages
HTML
Databases
DB2, Oracle, Netezza
Reporting tools
Business Objects (SAP BI 4.1, XIR3, XIR2 & 6.5), Web Intelligence, Desktop Intelligence, Infoview, Universe Designer(UDT, IDT), Crystal Reports 2011, Xcelsius 2008 SP3, BusinessObjects Live Office XI 3.1 SP3, Query As A Web Service, Tableau 8.3
Tool used in the querying DB2 database.
Quest Central.
Tool used to query Netezza database
Squirrel
Education
Bachelor of Engineering in Electrical and Electronics, Anna University, Chennai, India, 2006.
Certification:
2012--1Z0-047-ENU Oracle Database SQL Expert - English - (ENU)
Oracle Testing ID:OC1176185 --Registration ID:252328930
Professional Experience:
Texas Instruments (TI), Texas Jun 2014 – To Date
SAP BI/BO Consultant
Project: Decision Support Reporting
The old version (XIR3) of the Texas Instruments’ (TI) reporting environment was migrated to SAP BI4.1. All the SAP Business Objects reports and associated universes were migrated to a best practice standard. The activity consisted of development, unit test, system test, user acceptance test, documentation, knowledge transfer, business readiness and initial support and transition to TI support.
Tableau Experience:
Texas Instruments has identified Tableau to design and deploy data visualizations. Have started working on Tableau 8.3 as a Developer and Analyst. Development includes report design and monitoring of system usage. Have knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Have started working on the development of Dashboard reports for the Key Performance Indicators for the top management.
The following activities were carried out:
SAP BI 4.1 Migration Project:
Involved in the preliminary communications sent to the Business SMEs.
Identify Candidates for migration (BO Webi/Deski reports, Universes).
Worked on the Clean-up of the reports to consider for migration to the new environment. Document the connections/universes in the existing environment for comparison in the new BI4.1 environment.
Created usage reports using 360 Eyes.
Involved in the Documentation and creation of Best Practices - Document Connections, Document Universes.
Carried out a Sample Migration (Remedy/Other Small Candidates).
Migration was carried out in waves. Some of the Critical business areas like Finance, Sales and Marketing were considered in the first phase.
XI3 Soft Freeze was applied - Public Folder Lock - Lock Ability to modify universes/connections, Lock ability to create any new reports, Lock ability to modify and existing reports.
Supported throughout the execution of the Migration Plan.
Setup groups - Copy Users/Groups. (Carried out by the BO Platform Team)
Copy Required Content. (Carried out by the BO Platform Team)
Worked on DESKI conversions to Webi.
Worked on scheduling reports in the new BI4.1 environment and pausing existing schedules in the old environment
Reports/Universes validations were carried out after migration. Worked and solved the report migration issues (majorly due to the calculation engine changes).
Open Document New Syntax.(Change in URL syntax to open in a new window)
XI3 Hard Freeze - Lockout all but BO Admins.
Documented the lessons learned.
HR BO Reports Support:
Worked with HR users/managers to know their business need while gathering the reporting requirements and provided several mock-up reports to finalize the requirements.
Provided time estimates based on analysis of report specs and BRD.
Created Universes and complex reports against Oracle Exadata Database.
Set up Universe level conditions to restrict data based on report requirements.
Created Webi reports with multiple data providers and synchronized the data using Merge Dimensions option in BO.
Designed complex reports based on discussions with user groups and created various objects using built-in @functions like @prompt, @select, @where, and @aggregate.
Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
Created reports using all the BO functions like hyperlinking, Prompts, input controls, dimensional and Measure variables to show the accurate results.
Created reports with pass over filters from one tab to the other.
Writing Complex SQL queries and matching the data with database and reports.
Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Tuned and enhanced universes with SQL queries for the report performance.
Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
Generated the Business Objects reports involving complex queries, sub queries, unions and intersections.
Worked with Platform Team to Schedule the Reports in the Production Environment on the Monthly and Weekly basis.
Created Web Intelligence Ad-hoc and canned reports.
Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
Did unit testing and Integration testing after the development of universe and report.
Involved in User acceptance testing and giving BO training to User.
Johnson Controls Inc. (JCI) Nov 2012 - Jun 2014
Business Intelligence Support & Best Business Practices application support
Project Lead
Project:
The project involves analytical reporting support for the Best Business Practices application. The application is used for reporting the KPIs of the individual manufacturing plant’s operations across geographies and adopts the best practices inferred across all the plants.
The following activities were carried out:
New reports/dashboards development.
Best Business Practices (BBP) is a dashboard built using Business Objects to compare and rank the Plant Performances.
Worked on creating dashboards against the Key Performance Indicators of the Plant Performance Metrics such as Electricity Utilization etc.
Used Alerters to highlight the performance rating against each metrics.
Used the ‘In’ and ‘Out’ context operators to aggregate performance metrics across the plants.
Created varied linked reports to drill down the performance metrics.
Enhancement to the existing reports and dashboards.
Based on functional requirement, have worked with the data management teams in creating and enhancing the data models and creating an end to end BO traceability document.
The BBP Engineering module consisted of Bubble Charts that were not supported in the BO XIR3 version. To support the Bubble Chart, Xcelsius tool was used.
Worked on creating Bubble Chart using the Xcelsius dashboard tool and embedded it in Crystal reports that were used in the Engineering module.
PSCU Financial Services Jan 2011 - Oct 2012
Project Lead
The project involves restructuring, rationalization/upgrade of complete Business Intelligence (BI) reporting environment. Its scope includes assessment and transformation of the “PSCU Financial Service Business and Technology Landscape” with respect to the requirement of reducing individual data sources into a data warehouse and providing a gateway to access the warehouse. Meeting this requirement would enable PSCU Financial Services to reduce the resources required for sharing data and also provide various revenue opportunities
The following activities were carried out:
Integrated information architecture with multi-region flexibilities
Architecture supporting near real-time reporting and analytics
Phased implementation plans with periodic deployments
‘Performance One’ application enhancement:
The customer was utilizing the ‘Performance One’ application built using Crystal Reports 2011 to track the performance of the Credit/Debit lines of businesses.
Worked on the enhancement of the ‘Performance One’ application to introduce the ‘Risk Management’ module.
Analysed the existing Crystal Reports embedded in the in the ‘Performance One’ Application.
Created additional reports to support the introduction of the ‘Risk Management’ module.
Worked with Crystal Reports 2011 for creating complicated reports including sub-reports, parameter based reports, graphical reports; formula based well formatted reports to support the ‘Risk Management’ module.
TAFE (Tractors and Farm Equipment’s) / TCS May 2010 to Dec 2010
Project:
To meet its growing demand for new products in different Horse Power(HP) segments, TAFE planned for collaborative engineering and manufacturing environment to reduce New Product Introduction (NPI) cycle time. The program review mechanism was planned through the development of NPI Program Management Dashboards.
Responsibilities
Requirements gathering and architecture finalization.
Design, Infrastructure Setup
Enable users to get a “Business View” of data
Facilitate Data based Decision Making that would drive and improve the Business.
Separate dashboards to cater to the decision needs of different levels of TAFE users, viz. Senior Management, NPI Project Manager, NPI PMO members and Functional leads, Operational users contributing to each NPI project.
Preference to have a true dashboard presentation allowing users to have multiple analytics and parameters viewed at a single glance thus allowing an overall view of the program or project
Focus on key dimensions of Timeline, Cost, and Performance.
Warranty Costs and Failures.
Number of NPI Tractors sold and Sales Revenue maintained through the dashboards
Provision to make key subjective feedback available from the project to include those aspects that are not measured by the processes (e.g.) Key risks, key decisions, reasons for delays/overruns, next steps for course corrections actions.
Carried out the following activities:
Design, Infrastructure Setup and Proof of Concept.
Detailed Data flow from source to target.
Development of Reports and Dashboards.
Created Web Service Links using QAAWS (Query as Web Services) and implemented into Xcelsius dashboards.
Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.
Validation and Testing of the Dashboards.
Deployment of the dashboards as .swf files in the BO Infoview.
Technical Documentation.
Knowledge Transition and Technical Training to the end user.
Astrazeneca, Nov 2008 – Dec 2009
Datawarehousing and Business Intelligence (DW & BI)
Project:
In Astrazeneca around five applications had Business Objects(BO) 6.5 version(old and support withdrawn) to be migrated to Business Objects XIR3 version. This project involved comparison of the two system features and properties of new system must exactly match with old system. Redevelopment work is done in new system if there is a mismatch. Later, the system is tested, reviewed and delivered to the client.
Responsibilities
Development, maintenance and support of the Business Intelligence(BI) system.
Migration of the BI system.
Carried out the following activities:
Development of Webintelligence/DeskI(Desktop Intelligence) reports and universes in BO XIR3 and 6.5 Versions.
Migration of reports/universes from BO-6.5 to BO-XIR3.
Conversion of deski reports to Webi Reports in BO XIR3.
Creation of the Security model in the new environment.
GORDON FOOD SERVICES May 2008 - Oct 2008
Datawarehousing and Business Intelligence (DW & BI)
GFS BO(Business Objects) Migration is a data warehousing based migration project. The reports in BO 6.5 version are migrated to BO XIR2/XIR3 version.
Carried out the following activities:
Development, support and maintenance of the Business Intelligence(BI) system
Migration of the BI system.
Involved in the migration of reports/universes from BO-6.5 to BO-XIR3
Resolved issues that arose during migration such as formatting, URL link errors, merged dimensions, scheduling, analytics, cases etc and redevelopment of chart, tabular, trend reports if necessary.
Involved in the publication of reports.
Done the testing required post migration and involved in UAT.
E*TRADE FINANCIAL Corp. May 2007 – May 2008
Datawarehousing and Business Intelligence (DW & BI)
Project:
E*TRADE Marketing Finance and Marketing Campaign team working with their Business Line Partners and delivers daily, weekly, Monthly and Quarterly reports for their Business Analytical purpose. Acceptance Testing takes place in On-site. Development of Detailed Design document, coding and System Testing are carried out at offshore, in India. However, project requirements necessitate the presence of a few members onsite to deal with the client on a day-to-day basis to perform the tasks related to the scope of the project
Responsibilities
Requirement Analysis
Preparation of High level Design document
Perform Data Mapping and Design Extracts
Reporting and Analysis in the areas like Marketing, Customer Development and Cross Selling to existing customers.
Worked in areas such as Retail, Banking Deposit, Lending and Product Development.
Contact this candidate