Developer Data
Resume:
Ali Usman
******.**@*****.***
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