Ali Usman

917-***-****

abgir6@r.postjobfree.com

SUMMARY

US Citizen with Over 6 years of experience in IT specifically Business

Objects XI R3.x/R2/6.X, Business Objects Designer, Reporter, Supervisor,

Info View and Web-Intelligence, Xcelsius, Crystal Reports

Good experience in overall BO XIR3.0/XIR2 application architecture and able

to Design, Deploy, Support the application architecture

Extensive experience with creation of WEBI Rich Client reports and

Dashboards using Crystal Xcelsius 2008

Involved in designing Universe and creating reports on XIR2/R3.0/R3.1

Extensively Worked on Webi report and Desktop Intelligence for XI

R2/R3.0/R3.1

Experience in Optimization and Performance tuning of new and existing

Business Objects universes and reports.

Experienced in migration of Business Objects 6.5.1 to XI R2//R3.0

Well versed in Business Objects (6.X and XIR2) with experience in

Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web

Intelligence, Infoview, Dashboards, Auditor and Schema Design

Good knowledge and experience in using Querying and Reporting modules of

Business Objects Enterprise XI. Worked on Web Intelligence to develop and

publish thin client reports.

Expertise in retrieving data using Business Objects Universes, personal

data files, stored procedures and free hand SQL methods.

Highly experienced in Handling Live Office and QAAWS, and Xcelsius and Webi

Integration

Good analytical and documentation skills with ability to communicate at all

levels.

Planning, organizing, and coordination skills

Ability to work in groups as well as independently with minimum supervision

and initiative to learn new technologies and tools quickly.

Willingness to learn, fast learner and flexible work attitude

Excellent communication (verbal and written) and interpersonal skills

EDUCATION

Bachelor in Business Administration

EXPERIENCE

L'Oreal, New York, NY Feb 2012 - Oct 2012

Business Objects Developer

Responsibilities

Extensively used Designer to design various universes for different

business groups,

created classes, aliases, help text, simple reports and complex

reports using cascading prompts.

Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap

using Multi Parse SQL.

Used @functions like @select, @where and @prompt function to create

prompts, which enabled user to select the values dynamically.

Designed cascading prompts in the universe to filter the list of account

names based on business units.

Customized the list of values (LOVs).

Performed Administration tasks like setting up user profiles, assigning

rights and privileges for groups, setting up categories using CMC, and

maintenance of BO servers in XI 3.1 .

Scheduled reports from CMC and monitored if critical reports ran

successfully.

Worked as a Business Objects developer for a full life cycle of Universe

and Report to production implementation. Created complex reports in

Business Objects with various data sources to leverage reporting needs.

Interacted with end users, regularly in order to generate the reports

required. Various Business

Object reporting functionalities were used such as Slice and Dice,

Master/detail, User

Response function and different Formulas

Extensively used functionalities like Calculations, Variables, Breaks,

Sorting, Drill Down, Slice and Dice, Alerts for creating Business Objects

Reports.

Developed reports using both Full client and WebI,. Created complex reports

by linking data from multiple data providers, using free hand SQL and

functionalities like Combined Queries.

FedEx, New York, NY Jun 2011 - Dec

2011

Business Objects Developer

Responsibilities

Worked on Web Intelligence to develop, publish and schedule thin client

reports.

Created ad-hoc reports with multi prompts to retrieve required data for the

user and to minimize unnecessary load on the server.

Developed complex reports in WEBI using date functions, Calculations,

formulas & Filters and link reports and perform drilling using Open Doc

function in InfoView.

Develop various reports in WEBI and performed Slicing/Dicing, Multi

Tabbing, Cross Tabbing, Drilling, Scheduling and created Master Detail

Reports.In-depth knowledge in creation of WEBI and DESKI reports, Develop

Analytical reports using Alerter, Custom Sort and apply Graphs, Sections

and breaks according to the requirements.

Created reports for various Portfolios using the Universes as the main Data

Providers.

Used multiple data providers, Union, Intersection, minus and Master/Detail,

cross tab and Charts to create Webi reports

Created critical visualization using Business Objects Crystal Xcelsius 2008

the Business Dashboard

Created KPI visualization for the client dashboard using live data (Query

as a Web Service) which address the performance of the LOB at the

Organization Level

Created Ad-hoc Reporting menu in Xcelsius

Created several Crystal reports, Webi Rich client reports and utilized

Xcelsius for dashboard reports and graphical presentation.

Used QaaWs (Query as a Web Service) to feed data into Xcelsius.

Involved in Full development life cycle of Universe design.

Designed the Universe by creating the Business Objects data model selecting

and providing joins between the tables, Indicating cardinalities.

Created reports using Business Objects functionalities like Slice and Dice,

Drill Down, Cross Tab, Alerter and Formulae etc

Scheduling daily, weekly and monthly reports using BO XI Scheduler using

Events, creating Calendars

Formatted Reports as per the User requirements using extensively the

functionalities in Business Objects, which allows the users to analyze the

data.

Solving performance issues in reports using SQL queries and tuning of

reports. Extensively used Calculations, Variables, Break points, and

Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business

Objects reports.

Created Reports using the Universe, Stored Procedures and Free Hand SQL as

the Data providers.

Estee Lauder, Long Island, NY Sep 2010 - Mar

2011

Business Objects Developer

Responsibilities

Developed General Ledger and Accounts receivable universes using Designer.

Developed reports in Web Intelligence

Wrote a full functional specification document for the security to be

implemented in Business Objects

Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap

using Multi Parse SQL. Created Custom Hierarchies for several groups

Studied repository of XI R2 to check the chances of moving oracle's user

name and passwords to BO XI R2 repository directly through PL /SQL

Was involved in Star Schema customization / Design session

Installed and configured Business Objects Enterprise XI R2 using

Apache/Tomcat on Dev and QA boxes.

Created complex Xcelsius dash boards to reflect User Adoption Metrics.

Used fact tables, dimension tables to design specific Universes and

subsequently created Business Objects Reports and Crystal Xcelsius

Dashboard.

Performed Live Office Connections From BOBJ Technologies to Dashboards

through Xcelsius 2008

Client: LIRR, Jamaica, NY Jun 2009 - Jul

2010

Business Objects Developer

Responsibilities

Created Deski reports from various data sources(SQL, ODBC, Oracle, DB2,)

Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs,

Standard and Summary.

Developed universe in Business Objects 6.0 for the Sales and Marketing

Department to Analyze Sales and enable Marketing Team to make informed

decisions.

Used Live Office to move the data from the database into Excel and created

dashboards in Xcelsius.

Created Periodic, Demographic and Comparative Reports. All the reports were

scheduled on a Daily, Weekly, Monthly and Yearly basis.

Deployed QAAWS (Query as a Web Service) to feed data into Xcelsius.

Imported data from QAAWS using Web connector in Xcelsius.

Analyzed revenue by sales person, by product, by services

Resolved Loops using Aliases and Context addressed chasm trap and Fan Trap

using Multi Parse SQL. Imported data from Excel to compare Actual Vs Budget

Created complex reports using functionalities like Slice and Dice, Drill

Down, Scope of Analysis, Master Detail. Exposure to MS SQL Server 2000

Exported reports to the repository for InfoView users. Configured Broadcast

agent using Supervisor for scheduling reports

Excellent understanding and work experience of EXCEL functions with

Business Query reporting

Client: HPHC - Boston, MA Apr

2008 - Mar 2009

Designation: Business Objects & Crystal Reports Developer

Responsibilities:

Created repository using Supervisor, created users and groups, assigned

rights to users and groups

Created Universes, Classes and Objects for management systems.

Resolving Loops using Aliases and Contexts and check Integrity of the

Universe and exported them to the Repository to make resources available to

the users and groups.

Updated and maintained Universes based on changing user requirements and

data source changes.

Developed and Deployed complex reports. Used multiple data providers,

Union, Intersection, minus and Master/Detail, cross tab, Charts.

Using report wizard generated reports in crystal reports

Worked with report formatting such as combined database fields using text

objects as well as mapping old fields to new names using crystal reports

Created OLAP-only reports based solely on the cube in crystal reports

Linked subreports to display related data elements from more than one

database table

Using Business Objects created users and their profiles and applied

securities to them

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.

Created Report level variables by using Used Variable Editor

Analyzed the reports using the Drill Through, Slice and Dice

Created reports on web using web intelligence, distributed the reports to

different users.

Scheduled and monitored reports using Broad Cast Agent (BCA).

Worked on using the import wizard in moving reports and universes from Dev

to UAT and to Production environments.

Client: Univision - Teaneck, NJ

Feb 2007 - Dec 2007

Role: Business Objects Developer

Responsibilities:

Involved in Full project life cycle (requirement gathering to

implementation phase).

Worked very closely with upper management to get detailed information on

what information they require in each report

Created/Modified Universes and linked with the existing Universes with

Oracle backend and exported to repository.

Created Users and implemented security features.

Created Slice and Dice, Drill down and Cross Tab reports.

Used the formatting options like cross tab representation, section breaks,

data sort options, calculations, font, colors, etc.

Various ad hoc reports were created using User module in Business Objects

according to the given requirements.

Extensively used Designer to design various universes for different

business groups. Created classes, aliases, help text, simple reports and

complex reports using cascading prompts, decode objects, etc.

Implemented row and object level security in business objects supervisor

module.

Worked with Dimension modeling using Star Schema (ROLAP).

Managed the scheduling options stored in the repository and also involved

in changing the document descriptions.

Created Business Objects reports, Queries with constant interaction with

the end users. Trained end users in understanding the reports.

Functionalities such as Slice and Dice, Drill mode and Ranking were used

for Multidimensional Formatting.

Client: U.S Financial Group - Jersey City NJ Dec

2005 - Jan 2007

Role: Junior Business Analyst

Created Reports in MS Excel and Business Objects for End Users.

Identified requirements, monitored development, and created training

materials and documentation for a new web portal for private equity clients

through collaboration with project team, internal and external

stakeholders.

Created a metrics reporting framework to track and quantify application

development status

Worked 20 hours per week while studying a full course-load at City

University Of New York

|Operating Systems |Windows 95/98/XP/Vista/2003 |

|RDBMS |Oracle 10g/9i/8.i, MS SQL Server |

| |2000,2005, MS Access |

|OLAP and Reporting |Business Objects XI R3.0/R2/6.x |

| |(Supervisor, Designer, Business |

| |Object and WEBI, Crystal Report |

| |XI/9.0,7.0/7.1 |

|Scripting Languages |SQL, PERL, Java Script and VB |

| |Script |

|Other Tools |Toad, Visio |

Contact this candidate