Sign in

Data Warehouse

Dallas, Texas, 75225, United States
July 31, 2011

Contact this candidate

PH: (973)***-**** Dheeraj Email id :

Experienced Sr. Bo consultant and Developer with extensive experience in tools like SAP Business Objects, SAP Data Integrator, Crystal Reports, Crystal Xcelsius, Oracle, SQL Server, IBM DB2 and Sybase

• Experience and knowledge in Data Warehouse (EDW), Business Intelligence (BI).

• Expertise in BO-XI R2/R3 (Universe, Reports & Admin) and in BO-6.5 (Designer, Supervisor, Reporter, Webl and Broad Cast Agent), Crystal report design, Dashboard Design.

• Expertise Knowledge in Data Warehousing concepts , SQL , design and development of Universes and for reporting solution in BO for Operational Reporting System.

• Experience in designing and developing Security Structure/ Model in BO XI R2/R3 environment and well experience in BO admin activities.

• Expert in Installation and Configuration of Business Objects Product Suite.

• Expertise in Universe designing, developing and generating complex, adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and Data Accuracy Test.

• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

• Extensively worked in Migration related projects as a BO Admin. Experience in BO Enterprise Sizing estimation.

• Expertise in Business Objects Data services XI tools like designer and administrator

• Extensive experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.

• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.

• Experienced in designing the logical and physical Data Modeling/ER-Modeling using ERwin tool/ER Studio and designing the data warehouse using star schema/snow-flake schema and dimensional modeling.

• Strong knowledge in developing products under Windows 2003/2000/XP/NT, UNIX environments. Good experience in Operating System and Networking concepts.

• Experience in gathering requirements and documenting functional and technical specs

• Excellent Communication with different user communities in organization

Technical Skills

Reporting Tools Business Objects XI 3.1/R2/6.5/5.1, Crystal Reports 2008/XI/10, SAP BI 7, Cognos 8

Dashboard tools Crystal Xcelsius 2008/4.5, QlickView 9

ETL tools Business Objects Data Services/Integrator XI 3.2/11.7, Informatica 8

Data modeling Erwin 7/4, Embarcadero, MS visio

Database Oracle 11i/10g/9i/8, MS SQL Server 2008/2005/2000, IBM DB2 UDB 6.0, Sybase 11

Operating system Windows, UNIX

Others MS Office, MS project, TOAD, Remedy, MS Visual source safe, Bugzilla etc.

Work Experience:

Client: Parkland Hospital, Dallas, TX April 2009 to Present

Role: Sr Business Objects Developer


Worked on Multiple project include Development and maintenance of Business Objects BI application platform

Migrated reports, Universes, users from BO 6.5 to XI 3.1.

Managed the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.

Implemented best practice and recommendations of the Business Intelligence

Designed and Implemented Reporting architecture based on Business Objects

Installed and Configured BOBJ, Service Packs, Hot Fixes, Productive Pack etc on Engineering servers to extensively test the impact before installing them in Dev, QA and Prod.

Defined BO XI 3.1 user security model, users, groups, and Role based user, Universe Security Authentication and Active Directory.

Worked on BO Data Services Designer to build mappings in ETL to load data from flat files.

Involved in Maintenance of universes and reports from Server to Server on the deployment.

Configured the Email/FTP setup in the DEV, QA, and PROD Environments.

Created Auditor reports and tracked user access of reports and Universes.

Management of content and data migration through Dev, QA and Prod environments.

Performed administrative tasks in CMC and CCM

Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.

Strictly followed the Release Management schedule as per client guidelines.

Used Sybase, shell scripting, Perl, XML, and HTML on HP9000s, Sun and NT workstations

Scheduled the Web Intelligence/CR reports using the CMC by creating event based triggers.

Production support activities and fixing the live data issues.

Worked with ETL and database teams working on data warehouse tasks

Worked on building dashboards using Crystal Xcelsius

Provided training to business users in creating reporting reports, publishing and distributing reports

Environment: Business Objects XI 3.1, Data Services XI 3.2, Oracle 11i/10g, Windows

Client: Scottrade, St Louis, MO Sep 2007 to Mar 2009

Role: Data Warehouse Developer


Created reports using WEBI, Crystal Reports, Desktop Intelligence, and Xcelsius .

Created Aliases and Contexts for solving the join problems in Business Objects.

Used various join methods like Inner-join, Outer-join, when creating Universes.

Created Hierarchies and Predefined Conditions using Business Objects.

Created reports using Webi, QAAWS, Desktop Intelligence, Xcelius, Crystal Reports.

Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By Region wise, and Reports Based on time like Year, Quarter, Month, Week, Geographic Reports and Comparative Reports.

Created, used customized, dynamic list of values (LOV’s) while creating Universes, Reports.

Interacted with users to develop business requirements for the development of Reports.

Created and linked multiple queries for some complex reports. Prepared the Functional Specification and interacting with user and getting the requirement

Created the ETL Mapping for all source files which used by CIR like ITS Feed Files and UDB Etc.

Prepared the user manual document and trained all end users

Obtain all business clarifications from the customer through BA.

Ensure all unit test cases are aligned to the business requirements

Developed and Review all the reports and universes

Ensure that all deliverables are validated tested and approved by the BA for meeting all the business requirements and acceptance criteria.

Adhere to all quality processes that will be implemented by the database teams

Maintain proper versions of the code and adhere to configuration management process defined by the PM.

Involved in Performance tuning of Reports.

Presented Trainings to the higher managements using PowerPoint through webx.

Trained the key users for usage of Info view module.

Trouble shooting the issue (Development related) which arises during the time of UAT.

Environment: BOE XI 3.1, Data Integrator, Desktop Intelligence, CMC, CMS, Import wizard, Report Conversion tool, Xcelsius and IBM DB2

Client: Prudential Financial, Livingston, NJ Aug 2005 to Aug 2007

Role: Business Objects Developer/Admin


Developed Adhoc, Workflow, Exception, Performance reports for National, Regional, Department level reporting.

Made daily, weekly, monthly, semi annual reports as when required within the given timeframe.

Used complex calculations, created variables, Breaks, Drill Down, Slice and Dice, Alerts, folding of tables.

Created charts, tables to display summary of the data.

Tested reports against ITSM (remedy user) for the verification of the data generated.

Recommended addition of new objects in the universe as appropriate.

Created Custom Filters, Global filters, Predefined Conditions in developing reports.

Migrated Microsoft Excel, Access reports to Business Objects reports.

Developed reports which show monthly, Year to Date Performance of the department

Documented the work done, Worked with and trained the users appropriately for future handling of the reports.

Created Aliases and Contexts for solving the join problems in Business Objects.

Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.

Created Hierarchies and Predefined Conditions using Business Objects.

Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By Region wise, and Reports Based on time like Year, Quarter, Month, Week, Geographic Reports and Comparative Reports.

Involved in various discussions with end user to analyze Meta data.

Extensively used Calculations, Variables, Break points, and Sorted inputs. Drill Down, Slice and Dice, Alerts for creating Business Objects reports.

Planned coordinated and executed Business Objects 6.5 deployments for end-users and documented the entire project.

Created Drill-Through reports to provide users with more detailed information and query linking.

Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.

Formatted the Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.

Environment: Business Objects XI R/2, Business Objects 6.5, Web Intelligence, Designer, Desktop Intelligence, Supervisor, CMC, SQL Server, Oracle, Windows

Client: Indo Asian Energy Management, India May 2004 to June 2005

Role: Software Engineer


Involved in Full life cycle design and development of Business Objects Reporting Application.

Involved in design, development of the complete Decision Support System using Business Objects.

Multi source Extraction Transformation and loading into the Repository using Informatics Repository maintenance and security.

Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations, Mapplets and Mappings using Designer Tool set of Informatics.

Created different sales report, revenue reports and involved in development and maintenance of Universe using Designer. Generated business objects reports with Slice & Dice and Drill down Capabilities for Reports on a periodic basis.

Created customized web reports per requirement of client and Scheduled reports using Business Objects Broadcast Agent.

Created, Modified and publishing reports using WebI. Created classes, objects and filters at Universe level and resolved loops using contexts and aliases. Worked on cleaning the current universe in terms of naming convention and designing the better security.

Created User Defined Functions and Materialized Views.

Involved in resolving the loops, using contexts and checked the cardinalities, Integrity of the Universes.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.

Developed complex queries using different data providers in the same report.

Created reports based on the stored procedures.

Scheduled Reports using Broadcast Agent.

Environment: Business Objects 6.5, 5.1, Web Intelligence, Desktop Intelligence, Supervisor, Oracle 9i , Windows


Bachelors in Electronics and Telecommunication Engineering

Contact this candidate