acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

***** *********** ***, *

TX

¬ Professional Summary

• Over 7 Plus years of professional experience in IT Industry with 6 years of experience

using Business Objects 4.0 XI3.1/XIR2/6.5/6.1b/5.1.6, Web Intelligence 6.x/2.x, Business

Objects Designer XIR3/XIR2/6.5/6.1b/5.1.6, Business Objects Developer Suite (Broadcast

Agent, Supervisor, Designer, Infoview) and Application Foundation/Dashboard Manager.

• Extensive Experience in Creating Crystal Reports, Web Intelligence/Full Client/Desktop

Intelligence and Xcelsius Dashboards in Business Objects 4.0 XIR3/XIR2/6.5/6.1b.

• Experience in Creating Applications, Dashboards, Metrics, Rules and Analytics using

Performance Management XIR2 and Application Foundation6.5.

• Experience in integration of various data sources like Oracle and SQL Server.

• Experience in creating proof of Concept (P.O.C) to migrate from Business Object to

Microsoft BI (MSBI 2012).

• Involved in identification of technical limitations of SSRS and PowerView in reference

with Crystal Reports and Dashboard design Objects.

• Expertise in handling all the business objects components such as CMC, Supervisor,

Designer, Publisher, Web Intelligence, Broadcast Agent, Query Tool, Performance Manager,

Dashboard Manager, import wizard, LCM.

• Good Experience in maintaining and scheduling reports using Broadcast Agent in

production environment and supporting users in creating Web Intelligence reports and

administering the BO activities.

• Participated in all phases of the systems development life cycle (SDLC) from requirements

gathering till testing and production.

• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written

in Oracle and SQL Server.

• Good communication skills, strong decision making skills, organizational skills, and

customer service oriented. Excellent analytical and problem solving skills.

• Installed and configured business objects servers in a clustered environment and performed

sizing of different servers for better performance and load balancing.

• Redesigned the security model by moving towards windows active directory authentication

and implemented AD Authentication and Single Sign On.

• Implemented additional layer of security on the Business Object's web application server

using SSL from internal as well as third party certificate authorities (which is basically HTTP to

HTTPS)

• Migrated from XIR3.1 to BI4.1 using the Upgrade Management Tool by incremental

upgrade process.

• Resolved object and security issues after the upgrade.

• Optimized the report's performance by tuning the network and server configuration.

• Provided support to the server related issues and assigned tickets to the appropriate teams.

• Worked with SAP Support for unresolvable issues.

• Provided work arounds for the complex issues related to development.

¬EDUCATION

Business Management and Admin, Bachelors of Sc Jan 2001 – June 2005

City University Of New York, Brooklyn, NY.

acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

14739 RAVENSCROFT WAY, S

TX

Technical Skills

B Business Intelligence/ Reporting Business Objects 4.0 XIR3.1/XIR3.0/ XIR2, (CMC/CMS/LCM/UMT), Information design tool,

Tools Report Conversion Tool, Deski, Webi, Dashboard Design, Designer 6.5/, 6.1/5.x/4.xCrystal Reports

2011 Ent, Crystal Reports 2008, Xcelsius, Voyager, Explorer, Lumira, Dashboard design, Universe

Design Tool, Qaaws, Live Office.

Other Reporting & Visualization Hyperion, Peoplesoft, SSRS, Infomaker, Pentaho, Jasper, Birt Reports, Tableau, QlikView,

Tools Dashboard Design, Roambi, Salesforce, Domo Power pivot and PowerView

Tools/Applications: St ITIL, JiRA, PVCS, BMC Remedy, Service Now, Gaskit, Rightangle, Map Info, Actix Analyzer,

InSite, Maximo, Openlink, ICE, TMS, Railworks, SCADA, Impact (Power charts) Cerner.

E ETL Tool In Informatica, SQL, DTS, BODI/BODS

L Languages P PL/SQL, SQL PLUS, SQL Navigator, Toad

R DBMS M SAP BW, Oracle 10g/9i/8i/8.0/, SQL Server 2005/2000/7.0/6.5, MS Access.

O Operating System W Windows 2000/XP/Vista/7/8, Unix

§EXPERIENCE

Williams, Tulsa, OK Business Object Specialist Feb 2011 – May2014

The project role is supporting Gaskit Application (accounting application, which nominate, allocate,

assign, Bid on Contracts), and uses Crystal Reports as its core reporting tool. Overtime, New projects

acquirement involved RightAngle Application (Trading), TMS (Terminal Management System), Service

Now (ITIL), Railworks (Transportation), OPPL (Discovery and exploration) and MIDP (Legacy). Briefly

involved in SDLC processes of 3 major applications. Involved in evaluating technical aspects migrating

to MSBI. Done POC of SSRS (Migration of crystal reports to SSRS).

Responsibilities

• In process of creating P.O.C to Implement MSBI, conversion of crystal reports to SSRS reports,

POC for dashboard design objects using PowerView.

• Involved in migrating warehouse database from Oracle 10g to 11g database

• Generated freehand SQL Crystal reports and PL/SQL scripts to install, create and drop database

objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and

synonyms.

• Performance tuning of complex SQL queries, Procedures and date Functions using SQL

Navigator.

• Designed the data requirements by analyzing the existing prompt reports.

• Designed and Developed existing prompts reports in Crystal Reports Developer 8.5

• Implemented Crystal Enterprise development environment by installing Crystal Enterprise on IIS

5.0 web server.

• Recommended changes and updates on Views used by prompt reports.

• Deployed and tested the Crystal Reports on Crystal Enterprise 8.0 environment.

• Break/Fix, enhancements request, and maintenance of Crystal Reports for Gaskit application.

• Linked and modified multiple Universes using Information Design Tool.

acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

14739 RAVENSCROFT WAY, S

TX

• Created complex Xcelsius Dashboard for Gaskit, Straingauge, Service now application.

• Created Xcelsius dashboard using LiveOffice and QaawS, with multi Tabset component

displaying and consolidating all Data display in 3 tabs.

• Train Power user to view and use dashboard information effectively.

• Provided production support during and/or after office hours on technical Business Objects

related issues and/or data analysis on data related issues to team lead and end users.

• Modified and enhanced all clients’ standard Business Objects reports for scheduling.

• Assisted/guided end users to efficiently use the universes in building simple and complex reports.

• Developed and Deployed complex reports. Used multiple data providers, Union, Intersection,

minus and Master/Detail, cross tab, Charts.

• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the

problems with database when integrating with Business Objects

• Created templates for standardizing the Structure of our Corporate Documents.

• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters,

Sorts, Query Prompt and Drill filters.

• Analyzed the reports using the Drill Through, Slice and Dice

Environment: BusinessObjects XI 3.1/4.0, Designer, Information Design Tool, Web Intelligence,

Desktop Intelligence, Crystal Reports 2008/2011, InfoView, Dashboard Manager, SQL, Oracle 10g, SQL

Server 2008, Xcelsius 2008, MS Excel, MS Visio.

Global Wireless Solution. Dulles, VA B.O Developer Jan 2010–Dec 2010

Responsibilities:

• Communicate with the user and developer community; understand their requirements and

created, designed Business Objects universes.

• Created Universes against Oracle Database using Aliases and Context to resolve loops.

• Created reports using Universe, Stored Procedures and Free hand SQL as Data Sources.

• Created graphs/charts for the reports.

• Exported the Universes to the Repository to making resources available to the users.

• Created reports synchronizing data from more than one sources.

• Recreated reports that had been developed in Oracle Discoverer.

• Involved in SQL tuning for better performance while generating Ad-Hoc reports.

• Involved in taking requirements, writing specifications for generation of reports.

• Created Linked reports with multiple prompt as passing parameters within Application

Created Complex Crosstab reports with multiple queries.

• Report creation using full client and Web intelligence (thin client).

• Created Metrics and Dashboards using Application Foundation.

• Created alerts using Dashboard Manager so that whenever a change in the report the end

users get alerted.

• Implemented security for the end users based on users job function.

• To train users and developers in the use of Business Objects.

SAINT BARNABAS, NJ Business Objects Developer March 2009-Nov 2009

acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

14739 RAVENSCROFT WAY, S

TX

Responsibilities:

• Gathered requirements from the management for functionality, display and effectiveness

of the reports, Created initial Classes & Objects, qualification for the Universes in both on/off

line modes

• Defined Aliases and Contexts to resolve the join issues in the Universe, Solved the issues

during designing such as loops, Cartesian product due to fan trap and chasm traps

• Exported the universes to the Repository for making resources available to the users,

Created custom LOVs and Hierarchies, which helps the report users to select the list of values

and also to drill down to lower levels

• Created the new Views and Aggregate tables for report performance, used @functions to

create predefined conditions and prompts to filter the data and dynamic user selection.

• Generated BO reports for several levels and used drill analysis in Business Objects 6.5.1,

which allowed users to view data at a more detail level than current level

• Developed Drill down, Link Report reports, sub reports, used various Charts and Graphs

like Bar Chart (Side By Side, Stacked), Line graphs, Pie Charts etc

• Organized data in the reports by using Filters, Sorting, Ranking, Created Alerter based on

business criteria, Created reports on web using InfoView Portal, distributed the reports to

different users

• Used the Broadcast Agent Server to Schedule, Refresh and Monitor the Reports, Worked

with flat files, Oracle as sources

Environments: Business Objects 6.5.1(Supervisor, Designer, Reporter), Web Intelligence 6.0,

BCA, Oracle 9i, PL/SQL, Windows 2000 Server, Unix, Sun Solaris, Impact (Power Chart)

Cerner.

Virgin Mobile Inc. Business Objects Developer Aug 2008-Dec 2008

Business Problem: Data Warehouse has been constructed by gathering the different databases

from numerous source systems. The data has been organized according to requirements of the

organization. The different modules are designed to support tactical reporting requirements on

current data and strategic reporting requirements on historical data (Data Warehouse)

Responsibilities:

• Translated business requirements into Universe design using Designer, Generated full

client, thin client reports in Business Objects and Reporter according to client specifications

• Designed, developed, implemented and maintained Universes using Business Objects

Designer, Resolved issues like loops by creating contexts to remove the cyclic dependencies

• Created the reports using Business Objects functionalities like Slice and Dice, Drill down,

@Functions, Cross Tab, Master/Detail and Formulas etc Involved in Creating Users, User

Groups and setting up the User Profiles using the Supervisor Module

• Used @functions to create predefined conditions and prompts to filter the data and

dynamic user selection

• Developing Various Reports Using Universes, Free hand SQL's as per user requirement,

Generated reports for web users using Web Intelligence and Info View

• Used Broadcast Agent server to Schedule and monitor Reports as per the terms and

conditions, Environment: Business Objects 5(Designer, Reporter, Info view, Supervisor,

Broadcast Agent), Windows NT, Oracle 8, SQL, PL/SQL

acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

14739 RAVENSCROFT WAY, S

TX

Environments: Business Objects 6.0(Supervisor, Designer, Reporter), Web Intelligence 6.0,

Oracle 8i, PL/SQL, Windows 2000 Server

UNISYS, NY Business Objects Developer Dec 2007-June 2008

Business Problem: The purpose of this project is to design & develop a reporting database for

the LMIRS legacy system, schedule the updates of this Data Warehouse on a daily basis at a

pre-defined time and deliver in Crystal Report with Universes that will satisfy the reporting

requirements for LMIRS under writer.

Responsibilities:

• Designed and maintained Universes using different schemas in the Oracle Database

• Migrated and converted BO 5 reports and universes to 6.1

• Created user groups, users, folder level security by using Supervisor 6.1

• Created new Universes, Reports and modified existing Universes and reports

• Took care of production support issues BO Reporting system

• Detected cardinalities, loops, and checked the Integrity of Universes

• Created custom Time hierarchy Year-Qtr-Mon-Week and Year-Mon-Week in Universe

using BO Designer

• Created classes, subclasses and objects including complex measure objects according to

the business requirements

• from the Universe schemas and database tables

• Modified the existing Universes by merging different Classes, resolved the Loops and

Chasm Traps by context

• Documented different application architecture's and dataflow across different applications

and platforms

• Trained people to use and create reports

• Maintained and administered production and development repositories

• Exported Reports on to WebI Server and using Document Agent Scheduled Reports as

Daily, Weekly, Monthly using Info view in Web Intelligence

• Published and Migrated reports in Development/Test to Production Domains

• Worked on the Master, Kernel and Component approach during the linking of universes

• Analyzed, designed, developed and tested reports while working directly with end-users

and technical members of the team

Created the reports using Universes as a main data provider and using the Powerful

business objects functionality’s like @ functions, user response and formulas.

Estee Lauder, Long Island, NY Business Objects Consultant Jan 2007- Oct. 2007

Responsibilities

• Involved in gathering the user requirement, reporting requirements and prepare the

requirement specifications document. This involved interviewing the business users and

understanding the current reporting system.

acfxa9@r.postjobfree.com

DANISH AHMAD

VOICE : 918-***-****

14739 RAVENSCROFT WAY, S

TX

• Installed and configured Business Objects 5.1.6 on Oracle Database.

• Created Business Objects Repository while building Business Objects solution.

• Developed Business Objects Universes with Classes, Objects and condition objects and

developed hierarchies to support drill-down reports.

• Created Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the

Universes.

• Created the reports using Business Objects functionality’s like Queries, Slice and Dice,

Drill Down, Cross Tab, Master Detail and Formulae’s etc.

• Created Store procedures and used as Data providers for some complex reports.

• Scheduled Business Objects reports through Broadcast Agent.

• Built full client and WebI reports. Provided OLAP functionality and worked extensively

with data warehousing.

• Set up groups and users for Business Objects deployment. Managed user profiles using

Supervisor.

• Modified Universes with pre-calculated aggregates from summary tables.

• Used the Drill Down/up function to analyze data.

• Created the reports using Universes as a main data provider and using the Powerful

business objects functionality’s like @ functions, user response and formulas.

Contact this candidate