Reports Crystal

SHARJEEL QURESHI

Green Card - Permanent Resident 513-***-**** ********.****@*****.***

PROFESSIONAL SUMMARY

Over 7+ years of experience in the Information Technology industry with extensive skills dedicated to SAP Business Intelligence, Business Analysis and Database applications using tools like Business Objects, Crystal Reports and Xcelsius.

Proficient knowledge on Business Objects 4.0, 4.1, and 4.2

Business Objects Administration, Security and implementation of Security for Reports

Implementation of Strategies for Security of SAP Business Objects

SAP Business Objects (BO) Expert and consulted various clients at various stages of a project

Experience in administering, integrating, installing, upgrading SAP Business Objects enterprises

Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.

Experienced in developing Dashboards, Pixel Perfect Reports using SAP BO – Xcelsius 2008, Crystal Reports, and WEBI.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals and teams at all levels.

Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users.

Created Crystal reports using 2008 and 2011

Created Training Curriculum based on Clients Data

Implemented training strategies for Super Users, Report Consumers and BI Report Developers

Experienced in maintaining work independently and within a team environment with high pressures

Created WebI reports using Sections, Breaks, Alerts, Ranking and using report level variables to mimic user requirements.

Strong RDBMS concepts and working experience using database Tables, Views, Stored Procedures, Functions, and Packages using SQL.

Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.

Worked with various Relational Databases Oracle 10g/9i/8i, SQL Server 2000/2005/2008

Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Implemented Security Features of Business Objects like Row Level, Object Level and Report Level

Experience in created reports using WEBI and Webi Rich Client

Excellent experience in creating Sub Reports, On Demand Reports, Linked Reports, Cross Tab Reports and Graphical Reports.

Worked with Business Users to analyze the business process and suggested necessary changes to schema objects to cater their reporting needs.

Managed onshore and offshore teams of developers and analysts (8+ people)

TECHNICAL SKILLS

SAP Business Objects 4.0, and4.1 Central Management Console

Info view BI LaunchPad

Business Intelligence BI MySQL

Desktop Intelligence Universe Designer

Administrator Reports

Import Wizard Crystal Reports 2008/2011

CCM Report Conversion Tool

Publisher and Auditor Web Intelligence

Performance Management Information Design Tool

Promotion Management MS SQL Server 2005/2008

SAP BW Windows NT/2000/XP, UNIX

Oracle 8i/9i/10g/11g Flat File Systems MS Access SQL

Sybase

EDUCATION

Wayne State University, Detroit, MI

BSc. in Business Administration

Graduation date: May 2002

PROFESSIONAL EXPERIENCE

Fifth Third Bank, Cincinnati, OH Aug 2015 – Present

Role: SAP Business Objects Administrator

Responsibilities:

Worked on Business Objects Business Intelligence Platforms 4.1, and 4.2 components Central Management Console, BI Launch Pad, Information Design Tool, Designer Universe, WEBI, and Crystal Reports.

Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects and Applied Contexts and Alias Tables to remove Loops and Traps.

Involved in performance tuning and optimization on Business objects Universes.

Worked on Central Management Server CMS, Central Configuration Manager CCM to manage the Business Objects

Stop/Start the Business Objects application when required, including troubleshooting issues while restarting the application.

Involved in day to day Business Objects Server maintenance.

Implemented best practices for using Business Objects Suite.

Provided support to resolve client technical issues.

Planned the DR activity and performed the DR test activity.

Customized the Adaptive Processing Servers as per the environment.

Added additional services when required due to high utilization of the BO server.

Involved in performance tuning of Business Objects and WEBI reports and published reports to WebI.

Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects

Administered, maintained and supported BO environment on various platforms like Windows 2000/XP/98.

Managing the User rights on Business Objects Applications like Desktop Intelligence, Web Intelligence, Designer, Dashboards etc and Folder Security for different groups of Users.

Worked extensively on maintenance, and optimization of universes for Business Objects and Web

Scheduled the reports according to the user requirements based on the Oracle database connectivity.

Creation of Folders in CMC and implementing security on various objects of CMC (folders,

Applications, Universe and Connections).

Exported the universes to the Repository to make resources available to the users and created reports for various portfolios using the Universe as the main data Provider.

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

Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

Created linked reports for Web Intelligence reports using open document functionality.

Created Ad hoc reports with Business Objects and finally deployed them in Web Intelligence.

Managed new user controlling access levels and assigning and maintaining report level and user level security in CMC and row level and object level security in universe to incorporate security for sensitive information.

Documented all the changes made to the Universes and Reports for future references.

Provided end user training for basic and advanced reporting skills.

Technicolor, Burbank, CA Aug 2014 – Aug 2015

SAP Business Administration

Responsibilities:

Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.

Worked on Business Objects Enterprise XI 3.1 and 4.0.

Performed upgrade from Business object 3.1 to 4.0

Created Ad hoc reports with Business Objects and deployed them in Web Intelligence.

Created Complex prompts for users to restrict data in the reports as per client requirements.

Migration of reports and universes from Dev to QA, UAT and Prod.

Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).

Used Import Wizard for the Migration process. Migrated users, universes, reports and Converting Deski Reports to WEBI using Report Conversion Tool.

Created Universes on top of Oracle and Teradata.

Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects and Applied Contexts and Alias Tables to remove Loops and Traps.

In Designer module created Tables and relationships i.e. cardinalities and improved the performance.

Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

Exported the universes to the Repository to make resources available to the users and created reports for various portfolios using the Universe.

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

Documented all the changes made to the Universes and Reports for future references.

Provided end user training for basic and advanced reporting skills.

GlaxoSmithKline, Philadelphia, PA July 2013–Aug 2014

Role: SAP Business Objects Developer

Responsibilities:

Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.

Assisted and involved in installation and configuration of Business Objects 4.0.

Analyzed and worked on issues imposed during BI 4.0 installations and testing and coming up with work-around to resolve compatibility issues.

Worked on Business Objects tool 4.0 components Universe, WEBI, and Crystal Reports.

Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects and applied Contexts and Alias Tables to remove Loops and Traps.

Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.

Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).

Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

Created Crystal Reports using Crystal Reports 2008 and 2011

Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

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

Generated Desktop Intelligence and Web Intelligence Reports using Business Objects Functionality’s such as Slice and Dice, Drill Down, Master/detail, Cross tab, Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking, User Response, Formulas, Calculation contexts/ extended contexts and @Functions.

Created linked reports for Web Intelligence reports using open document functionality.

Created Ad hoc reports with Business Objects and deployed them in Web Intelligence.

Worked extensively on different data providers like flat files, Excel files, Free Hand SQL for the creation of documents.

Documented all the changes made to the Universes and Reports for future references.

Provided end user training for basic and advanced reporting skills.

United Health Group, Hopkins, MN, Aug 2011 - July 2013

Role: SAP BO Developer

Responsibilities:

Requirements gathering from different level of users (SME, senior level managers etc, creating functional/technical specifications for the requirements and developing prototypes.

Worked on Business Objects XI R 3.1.

Implemented automated weekly restarts of BO Servers

Scheduled reports through CMC and Infoview.

Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to comply with their needs and requirements.

Analyzed the existing database schema, retrieved the Fact and Dimension tables and created Joins as identified in the Universe design.

Gained excellent work experience of Financial Business Objects reporting and Universe development

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

Created complex webi reports for business users.

Created Drill down Reports, On Demand Sub Reports, Sub Reports and Chart reports for the Business Needs.

Implemented automated weekly restarts of BO Servers.

Conducted monthly usage assessment for Users and Content (Audit)

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

Created Custom Hierarchies for several groups

Provide support for the Operations Risk Department workflow enhancement efforts includes Data issue identification and analysis, data mapping, data contents of reports and source of data contents.

Created Crystal Reports using Crystal Reports 2008

Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible through Infoview

Analyze data processes to support the automation, efficiency and reporting of Bank reporting.

Interview end users to determine requirements for data, reports, analyses and metadata.

Maintain and create a registry that helps to find business and process metadata in all of its locations.

Wrote Report Specification documents

Scheduled reports through CMC and Infoview.

Bank of New York, Mellon, PA May 2009 - Aug 2011

Role: Jr. SAP Business Objects Developer

Responsibilities:

Gathered requirements from end users to create universes and reports.

Extensively used BO XIR 3.0 as a Universe and Report creation tool.

Built the Universes for end user report generation using Designer module

Detected Joins and checked the Cardinalities

Resolved Universe problems like Loops, chasm trap fan trap using Alias and context

Developed and created classes with Dimension, Detail & Measure objects

Developed Custom hierarchies to support drill down reports

Created Derived tables in the Designer to enhance the capabilities and performance of the universe

Implemented cascading prompts in universe

Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects

Check the integrity of the Universes, and export the universes to Repository for making available to users

Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae

Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis

Involved in data modeling of the data warehousing system by creating facts and look-up tables using business objects.

Contact this candidate