Business Objects Consultant Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

ANNA  MANZOOR

manzooranna@gmail.com

Long Island, NY

Cell: 718 650 9876

SUMMARY:

·         Over 6 Plus years of professional experience in IT Industry with 5 years of experience using Business Objects XIR 3/2/6.5 applications.

·         Extensive Experience in Creating Web Intelligence/Full Client/Desktop Intelligence/OLAP Reports in Business Objects XIR 3/2/6.5.

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

·         Knowledge in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

·         Experience in Creating Applications, Dashboards, Metrics, Rules and Analytics using Performance Management XIR2 and Application Foundation6.5.

·         Involved in identification of Facts, Measures, Dimensions and Hierarchies for OLAP models.

·         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.

·         Experience in installation of Business Objects components including BO repository creation and support and administration.

·         Efficient in Optimizing, Debugging and testing SQL queries and Stored Procedures written in Oracle 10g/9i/8i and SQL Server 2008/2005/2000.

·         Good communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.

 

TECHNICAL SKILLS:

BI/Reporting Tools:   Business Objects XIR 3/2/6.5, Central Management Console (CMC), Import Wizard, Report Conversion Tool, Deski, Webi, Supervisor6.5/6.1b, Designer 3/2/6.5, Crystal Reports 10/8.5, Crystal Xcelsius 2008/4.5.

RDBMS:                     Oracle 10g/9i/8i/8.0/ 7.x, SQL Server 2005/2000/7.0/6.5 and MS-Access.

Languages:                 SQL, PL/SQL, Visual Basic, C++

Tools/ Software:          Crystal reports 10/8.5

Operating Systems:    Windows 2003/2000/XP/NT 4.0

MS Office Tools:         MS Word, Excel, Power Point, Access, Outlook Express, Live Office

EDUCATION & CERTIFICATION:

·         Masters in Business Administration (MBA)

·         Business Objects Certified Professional, Web Intelligence XI 3.0 Level 1

PROFESSIONAL EXPERIENCE:

CHASE Bank, New York, NY                                                                                                May 2010 – Present  

Business Objects Consultant                             

Responsibilities:

·   Designed custom AD-HOC reports, test plans, strategies and detailed test objectives for Unit, system integration, and UAT testing

·   Created Universe from scratch, resolved loops, Traps and exported to the repository

·   Developed test cases to test the reports in positioning of data items, incorrect drills, incorrect date formats, headings, prompts etc.

·   Involved in testing universes and reports for correct mapping of the objects and data correctness.

·   Analyzed specs and database model to generate the reports for the sign-off specs

·   Preparing the Design document after understanding the requirements

·   Created BO Universe and Webi reports

·   Set up of Aggregate Awareness and Hierarchies in the Universe.

·   Created critical visualization using Business Objects Crystal Xcelsius 2008 the Business Dashboard.

·   Formatted reports accordingly the specs given.

·   Created Drill down Reports, On Demand Sub Reports, Sub Reports and Chart reports for the Business Needs. set info view to schedule the reports.

·   Created prompts and conditions.

·   Scheduled reports to run and refresh daily using Broadcast Agent Server.

·   Wrote Formulas to calculated the Percentages and Summaries based on the group levels

·   Developed ad-hoc reports for end users.

·   Formatted reports accordingly the specs given.

·   Worked on Powerful business objects functionalities like @prompts, @functions, @Variables, user response and formulae.

 

Citigroup, warren, NJ                                                                                     Jan 2009 – April 2010           

Business Objects Developer                               

Responsibilities:

·   Developed universe in Business Objects XIR2 for  IBD global banking to overcome the user requirements

·   Created complex webi reports, setup hierarchies, cascading list of values, prompts and implemented complex calculations.

·   Administration and managing Business Objects XI R2 users, groups, folders, and categories.

·   Worked in Crystal Reports including creating reports from various formats ,including: Access, Sql, Oracle, XML, Txt files etc

·   Created reports using web intelligence with Standard, Summary, Cross Tabs and Grouping.

·   Optimized Crystal Reports performance for large reports(reduced page generation time)

·   Combined Hyperion/Oracle Essbase MOLAP data with Oracle Actual using business objects , linked reports in Business Objects

·   Developed complex reports of sales revenue by sales person, By product, by Broker.

·   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

·   Developed user interface for the reports using Visual Basic

·   Scheduled reports through CMC and Infoview

·   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.

·   Reports Developed with PL/SQL Procedures and Free Hand SQL

·   Developed java objects and stored procedures to upload the data from flat file to oracle data database.

·   Designed the Hi Performance universe by joining several dimensions to the fact table like Accounts, Returns

·   Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report

·   Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements

·   Created alerts, breaks, filters and ranks in the report

·   Prepared user documentation for hands on training for end user community

·   Developed Access front-end to facilitate the importation of data files into the SQL Server backend.

·   Developed contact management system in Access. Perform Unit test, UAT, Smoke test on the reports

Austin Energy, Austin, TX                                                                              Sep 2008 –Mar 2010

Business Objects Consultant

Responsibilities

·         Responsible for gathering the requirements from their users and preparing the specs and schedule docs.

·         Involved in Writing Detailed Level Documentation for reports and Universe design.

·         Responsible for designing the reports according to client’s requirement using Business Objects 5.1.6.

·         Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle 8i data sources.

·         Created Business Objects Repository while building Business Objects solution.

·         Involved in the designing and Building of Universes, Classes and objects. 

·         Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

·         Exported the universes to the Repository to making resources available to the users.

·         Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.

·         Scheduled Business Objects reports through Broadcast Agent.

·         Built Full client, WebI and OLAP reports. 

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

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

·         Created charts like pie charts, bar graphs, line graphs. Analyzed the data in charts using slice/dice, drill up/drill down.

·         Created complex OLAP Business Objects Reports connecting to Oracle Data Warehouse Databases

·         Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.

·         Responsible for developing all types of reports including Cross-tab reports using Crystal Reports 8.5.

·         Responsible for designing and development of on demand sub reports.

·         Responsible for writing the formulas to manipulate the data using Basic/Crystal Syntax.

Eli Lilly, Indianapolis, IN                                                                                    Sep 2006 – Aug 2008

Database Developer / Report Developer

Responsibilities:

·         Designed Entity Relationship Diagram and Normalized the database

·         Built Universe and created reports in Business objets XIR 2

·         Experienced with disaster conditions and restore the production database

·         Involved in data modeling of the data warehousing system

·         Involved in Logical and Physical Data Modeling

·         Worked on standard document for disaster recovery solutions.

·         Installed and configured SQL Server 2000 on windows NT, Windows XP

·         Installed all the updates and the service packs for both windows XP and the SQL

·         Created documentation for the server procedure and policies

·         Created alerts, breaks, filters and ranks in the report

·         Prepared user documentation for hands on training for end user community

·         Developed Access front-end to facilitate the importation of data files into the SQL Server backend.

·         Developed contact management system in Access. Perform Unit test, UAT, Smoke test on the reports

·         Built a live dashboard using Xclesius, Query as web service.

Download Resume Format