Customer Service Manager
Resume:
**********@*****.**
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.
**********@*****.**
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.
**********@*****.**
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
**********@*****.**
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
**********@*****.**
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.
**********@*****.**
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