Sign in

SAP Busiess Objects/BI Consultant

Calgary, Alberta, Canada
October 16, 2016

Contact this candidate



Professional Profile

About ** years of experience in Information Technology Industry with 3 plus years of expertise in developing SAP Business Objects 4.0, Xir3.1, Xi3, Xi2 and Data Warehouse applications.

Experience with data warehouse and dimensional data modelling.

Thorough understanding of data warehouse and dimensional data modelling.

Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/2003/2008/XP

Technical hands-on expertise using OLAP tools like SAP Business Objects Xi3.1 (Webi Reports, Webi Rich Client, Universe Designer, Info view, Dashboard Builder, Crystal Xcelsius and CMC)

Expert in tuning and optimized the performance of SAP Business Objects Xi3.1 queries

Proficient knowledge on SAP BO XI Architecture and new features.

Expert in Universe designing and development

Design and implement of x-Celsius Engage 2008 Dashboard and visualization with dimensional data connection by using ‘Query as a Web Service (QAAWS), and Live Office

Expert in designing and developing the complex corporate report, Ad hoc reports, and dashboard Reports

Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.

Worked with Webi and Webi Rich Client Xi3.1 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.

Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.

Design, development and coding with ORACLE 10g/9.2/8.x/7.x, SQL Server 2012/2008

An enthusiastic and project-oriented team player with solid communication and leadership skills

Ability to develop creative solutions for challenging client needs

Experienced in interacting with business users to analyse the business process and requirements, documenting and rolling out the deliverable on time


Report/OLAP Tools

Business Objects Xir2, Xi3.0, Xi3.1, 4.0, Universe Designer, Web-Intelligence, Web-Intelligence Rich Client, Info View, CMC Administrator, Dashboard Builder, Qlik View Analytics,Crystal Report, Crystal Xcelsius 2008, 4.5, Report Conversion tool, Import Wizard and Life Cycle Management (LCM)

ETL Tools

SSIS,SAP Data Integrator Xir2, Xi3, Informatica 8

Web/Application Servers

Tomcat Apache Server, IIS 6.0,5.0,4.0, BEA Weblogic 5.1/6.1


Oracle 9i/10g, SQL Server 2000/05/08, MS Access 07/10, DB2, Netezza, Sybase, SQL*Loader


SQL, PL/SQL, T-SQL, C, C++, Java1.2,2

Testing Tools

Win Runner, Test Director, QTP, Quality Center, Load Runner

Web Publication Tools

MS Front Page, MS Publisher, CSP, ASP, HTML, DHTML, JavaScript, JSP, Java 1.2

Operating Systems

Win NT Server 2003/08, Ms DOS, Win XP/Vista/Win 7, AIX, UNIX

Educational Qualifications

MSc Computer Science 2007

Sikkim Manipal University New Delhi, India

Advanced Diploma in Computer Hardware 2002

ET&T Govt.of India New Delhi, India

Certificate in Software technology 2005

Software Technology Group New Delhi, India.

Bachelor’s in Electronics 2000

New Delhi, India.

Trainings & Certifications

SAP Data Analysis for BI and DW Developer

Java, Web Services, MVC Architecture

Oracle 9i DBA


Work Experience

ERP Technicals Inc. Calgary July 2013 – Present

SAP Business Objects Analyst/Developer


Translated business-reporting requirements into universe strategies and design.

Updated about 40 existing universes as per daily report development requirements.

Updated the universes by defining parameters, inserting tables, creating classes and objects, making joins, resolving the loops, creating aliases and contexts, testing universe structure, performing integrity tests and fixing cardinalities.

Resolved the loop issues through aliases and contexts.

Developed Business Objects Reports from simple to complex levels by using linking, sub-queries and union functionalities when developing reports from many Data Providers.

On the basis of the requirements recommended and made changes on the Business Objects universes and developed business objects reports.

Analysed the SQL when developing reports.

Dimensional data modelling experience star schema / snowflake schema/Fact Constellation

Analysed, prepared and maintained the system documentation.


Business Objects 5.1/6.5.1 Crystal Report, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Supervisor, SQL Server2003, 2008, 2012, Oracle 9i, SQL, PL/SQL, Windows 2000/XP

BirdEye Inc. USA(Remotely) Jan 2015-Dec.2015

Software Consultant Sunnyvale USA

Administration of a range of business applications and Analytics

Training customers on the applications and dashboard

Ensuring availability and performance of business applications

Maintaining high quality documentation

Communicating effectively with the user community

Writing advanced SQL queries for data retrieval

Technical hands-on expertise using OLAP tools like SAP Business Objects Xi3.1 (Webi Reports, Webi Rich Client, Universe Designer, Info view, Dashboard Builder, Crystal Xcelsius and CMC)

Technical Instructor Dec.2011- April2013

Dalhousie University Halifax NS

Area of Instruction: UNIX, Linux, Shell scripting, Windows, MAC, LAN Networks

Developed IPMS (Networks) Delta training curriculum for Royal Canadian Navy.

Conduct, monitor, evaluate, and record training activities or program effectiveness. Organize and develop training procedure manuals, guides and course materials such as handouts visual materials, Lab. Exercises for hands on training materials.

Working with Moodle LMS, Blackboard system at Dalhousie University and Smart boards for day to day conduction work

Technical Consultant Oct.2011 – Nov.2011

NTT Data Halifax NS

Application and implementation of Microsoft Active Directory,Citrix and VM technologies

SQL server 2012

Remote Administration software: Managing Active Directory, users and groups, servers, and application modules with remote administration software from Dame Ware.

PB Learning /Database Analyst June 2004 – Sep. 2011

KVS Ministry of Education, Govt. of India New Delhi India.

Analyzed, designed and developed data model for a fictional travel agency database system

Captured and documented business requirements in detail project plan and text documents

Installed, configured, maintained and supported Oracle 9i,on Windows and Linux platforms

Created Oracle databases and required Objects, ERD, physical and logical design

Defined and created users, roles, views and profiles to provide the security of the database system

Analyzed, designed and implemented Star Schema data warehouse for an Educational Institution and data analysis

Generated BI reports using Excel (Pivot Table)

Performed database backup (full, differential, partial) and restore activities

Contact this candidate