Resume of Business Object Developer

Title
Business Object Developer

Primary Skills
Business Objects, Oracle, Informatica, more...

Location
US-MI-Farmingation (will consider relocating)

Posted
May-31-07

PROFESSIONAL SUMMARY

• Over 6 years of professional experience in I.T. industry with 3+ years of experience using Business Objects 5.x/6.x/XI (Supervisor, Designer, Business Objects, Info View), Web Intelligence 6.x/XI
• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules
• Experience in installation of Business Objects XI Enterprise and configuration of CMS with Oracle 9i on Windows
• Proficient in using different databases like Oracle10g/9i/8i, MS SQL Server and MS Access 2000
• Thorough experience in using Central Management Console (CMC)
• Migrated Objects, Documents and universes from Business Objects 6.5 to Business
Objects XI Enterprise using import wizard
• Involved in scheduling and publishing report to BO repository
• Working knowledge of new features of Business Objects XI including Index awareness, Derived tables, Single sign on support, Central management console
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems
• Extensive knowledge of Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager
• Proven problem solving skills with excellent analytical, communication and interpersonal skills
• Ability to work independently as well as a team member
TECHNICAL SKILLS
Reporting Tools Business Objects Enterprise XI r2/6.x/5.x, Oracle Developer 2000.
ETL InformaticaPowerCenter7.1.2/6.1.x(Workflow Manager, Workflow Monitor Worklets, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations)
RDBMS Oracle 10g/9i/8i, MS SQL Server 2000, MS Access
Programming SQL, PL/SQL, HTML
Operating Systems Windows 2000/NT/XP,UNIX,LINUX



Sisters of Mercy Health System Jun 06- Till Date
Chesterfield, MO
Sr. Business Objects Consultant
The data comes from different operational sources and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports. The objective is to automate the entire data load on a schedule basis and generate reports for the management to take corporate decisions.


Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Managed existing Universes, created Classes, Objects and applied Hierarchies based on Business logic
• Created Contexts and Aliases for resolving loops and checked the Integrity of the Universes
• Migrating existing reports in Business Objects 6.5 version to new version XIR2
• Created reports using the Universes, Stored Procedures and Free Hand SQL as the data providers
• Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
• Created complex reports using aggregate awareness functions for SQL enhancement
• Generated reports for web users using Web Intelligence
• Formatted the reports as per the business requirements
• Involved in Importing/Exporting the Universes to repository to make it available to the users
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports
• Used Web Intelligence for web based query and reporting
• Scheduled the reports to be emailed to end users daily in PDF and TXT formats from Infoview
• Trained the users in viewing/scheduling the reports using the Info view
• Published reports using Info View
• Involved in various discussions with the end users to analyze Meta Data.
• Interacted with the Data Warehouse team and suggested ideas to improve the model of the Data Mart, which can help in tuning the SQL and improve the performance of generating reports
• Involved with the ETL team in developing several Mappings using corresponding Sources, Targets and Transformations in Informatica

Environment: Business Objects XI r2 (CMC, Designer, Deski), WebIntelligence XI r2 (Info view), Oracle 9i, SQL, PL/SQL, Unix Windows XP.

Roche Chemicals May'05-May' 06
Nutley, NJ
Sr. Business Object Consultant
Roche is a research-based, global Pharmaceutical Company responsible for the discovery and development of today's most innovative medicines. Roche has a long history of pioneering developments in pharmaceuticals. The Project includes creating the reports to monitor the sales of the various products as per the region and by pulling the historic data from the EDW (Enterprise Data Warehouse), which is on Oracle.

Responsibilities:
• Interacted with the Data Warehouse team and suggested ideas to improve the model of the Data Mart, which can help in tuning the SQL and improve the performance of generating reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies
• Created derived tables in Universe
• Extensively used Designer to design various universes for different business groups
• Created Classes, Measure Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators
• Exported the universes to the Repository to make resources available to the users
• Interacted with business users in getting the reporting requirements
• Created Daily, Weekly, Biweekly and Monthly reports
• Created complex variables, multiple breaks, sorts in the reports
• Aided in setting up Multi-Dimensional Analysis, the Slice/Dice & Drill using the Hierarchies Editor
• Formulated Data to appear in Master-Detail, Cross-Tab Reports
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• Published Documents on the World Wide Web for access to authenticated users via Info View
• Responsible for analyzing business requirements and developing queries and reports using BO full client and other web development tools like info view to provide Web-enabled data analysis solutions to business clients

Environment: Business Objects 6.5/XI, Oracle 9i, SQL, PL/SQL, Windows XP

DTE ENERGY Mar 04-Apr 05
Detroit, MI

Business Object Developer
The Detroit Energy (DTE) manages the flow of electric power to approximately 10 million Detroit customers. The employees of DTE, who work in the field have to be certified in a certain area they work for, and their certification needs to be renewed periodically, based on this information Universe and Reports were created and viewed from different perspective.

Responsibilities:
• Understand the business requirements and derived technical specifications from functional specifications
• Implemented Star Schemas while designing Universe by identifying Facts and Dimension Tables
• Created numerous universes using Designer module with secured and shared connections to databases by analyzing the reporting requirements
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) to overcome the problems with database when integrating with BO.
• Created Report level variables
• Created Templates for standardizing the Structure of our Corporate Documents
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Query Prompt and Drill filters
• Used the Universes, Stored Procedures as source for Business Objects Querying, Analysis and Reporting
• Analyzed the reports using the Drill Through, Slice and Dice
• Created reports on web using Info View Portal and ZABO, distributed the reports to different users
• Used Broadcast Agent for scheduling and distributing the documents
• Troubleshooting and Customization of Reports after Upgrade
• Used Broadcast Agent Server to refresh Daily / Weekly / Monthly Reports and send to users in Production Environment
• Training Info View and Power Users for Business Objects tool Usage
• Interacted with Users for analyzing diverse Reports
• Worked with the ETL team by using Informatica to load data relating to production and equipment information into the organization's data warehouse
• Developed Mappings for Slowly Changing Dimensions extensively using Dynamic Lookup Cache and Lager Technique
• Design and develop the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing
• Designed and developed testing procedures and test plans
• Responsible for maintenance of Test and Development Databases

Environment: Business Objects 6.0/5.1.2, Informatica Power Center 6.2, Oracle 8i/9i, SQL, PL/SQL, Erwin, SQL*Loader, HP UNIX, Win 2000

Citigroup, Frankfurt, Germany Sep02-Dec03
BI Analyst

Project: Global Transaction Services
The GTS Data Warehousing project is involved in the design and development of Trade Management Data Mart for CitiDirect within the Citibank. This ETL initiative gets data feeds from 15 source systems across the globe. The Trade Management data mart is further used to provide trading reports via BI tools.

Responsibilities:
• Analyzed business requirements for ETL
• Worked closely with business analysts to understand the business needs for decision support data
• Prepared business-mapping requirements
• Developed end-to-end ETL processes for Trade Management Data Mart
• Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load into the target warehouse
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources
• Imported various heterogeneous and homogenous sources using Informatica PowerCenter6.2 Source Analyzer
• Developed various transformations using the Transformation Developer in the Informatica PowerCenter Designer
• Created various reusable transformations in designer such as Time Dimension using Informatica PowerCenter Mapplet Designer
• Extensively worked on Confirmed Dimensions for the purpose of incremental loading of the target database
• Tuned the Session Parameters to increase the efficiency of the sessions in Workflow Manager
• Tuning of the mappings and scripts for a better response
• Implemented Materialized view for persistent data and for faster processing
• Created and Maintained Universes using Business Objects Designer
• Developed various reports in Business Objects that have drill down capabilities
• Used Business Objects free hand SQL to generate Ad-hoc reports
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Modifications, additions, deletion of user profiles in the supervisor module in Business Objects
• Helped in maintenance work related to reports
• Generated Ad-hoc reports as requested by the team lead using Business Objects free hand SQL

Environment: Informatica PowerCenter 7.0/6.2, Business Objects 5.1, Web Intelligence, Info View, Oracle9i/8i, PL/SQL, Shell, MS SQL 2000, SUN Solaris UNIX.

PORSCHE Ltd., Bad Homburg, Germany Nov 01 - Aug02
Oracle DBA/Developer
Project: PUDIS (Diagnosis Information System)
The System to be developed was a complex Diagnostic Evaluation System based on a large diagnostic database(35 GB in size) .The System was designed to support the development engineers in order to identify weak points in Vehicle System respectively subsystem. The PUDIS System is conceived as a Highly Graphical Oriented Distributed Client/Server system. The Communication between the Client and the Server has been implemented using HTTP Tunnelling. The Persistence layer is maintained by Oracle BC4J Components.

Responsibilities:
• Database Administration
• Installed oracle9i, Developer Suite
• Creating Users , Groups and Privileges to users
• Import/Export using Dmp FILE into Database
• Created Standard Reports Using Oracle Developer 2000(Report Builder)
• Created the SQL Statements and stored procedures for the Oracle Database
Environment: Oracle 9i Developer Suite (Report Builder), Oracle 9i, Windows 2000

Pajo Soft, Bangalore India Mar 01-Oct 01
Factory Management
Oracle Developer
This site gives the total information about the inventory, production and dispatch.
The System to be developed as a Software which takes care of all our Daily sales, accounts and inventory and has a facility to provide good day-to-day reports.

Responsibilities:
• Installed Oracle 8,Developer 2000
• Database Creation, Users Creation and Granting Privileges to users
• Involved in the re-organization of the table structures
• Created tables, indexes, and views
• Utilized triggers
• Generated Forms ,Reports as per user Requirement using Oracle Form Builder and Oracle Report Builder
• Created Daily, Weekly, Biweekly and Monthly reports

Environment: Oracle 8, Oracle Developer 2000, windows 2000

EDUCATION: Masters in Advance Software Engineering.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-MI-Farmingation »
View all resumes in US-MI »

View other Business Object Developer resumes, Programmer / Developer resumes