Resume
Login
Email

Sr Business Objects /Business Intelligence

Location:
Rockleigh, New Jersey, United States
Posted:
October 20, 2009   all resumes
Email:
by32dd@r.postjobfree.com
Contact Info:
*****.*@***********.**.** *******: ***** *****:***-***-****


Name: Kumar
Business Intelligence Consultant
Email: by32dd@r.postjobfree.com

Professional Summary:

• Over 8 years of experience in Information technology with experience in complete life cycle of Software products involving Analysis, Design, Development, Implementation, Testing and support for various data warehousing applications including 7+ years experience in Business Objects.
• Hands of experience in gathering business requirements in Manufacturing, Financial Services, Healthcare, Mortgage, Telecommunications and Retail by interacting with Business Users and translating them into technical specifications.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse and Data Marts using Oracle 10g/9i, MS-SQL Server 2000, DB2.
• Well versed in Business Objects (XIR2 /6.x /5.x) with experience in Designer, Reporter, Supervisor, Infoview and Web Intelligence 6.X.
• Working experience in the new features of Business Objects XI R2 and 6i including Derived tables, Central Management Console, Live Office, Encyclopedia, Discussions.
• Working knowledge in Crystal Enterprise 10, Crystal Reports XI / XIR2. Migrated reports from Crystal Reports 8.5/9/10 to Crystal Reports XI / XIR2.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• Experience in working with the latest Xcelsius 2008, migrating dashboards from 4.5 to 2008.
• Good Understanding of the Business Objects ETL tool Data Integrator consisting of Data Integrator Job Server, Data Integrator Designer.
• Working experience using Universe Designer, Webi, Deski, Publishing Wizard, Import Wizard in XI 3.0
• Working experience in new features of Business Objects Enterprise XI 3.0.
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Extensive experience in creating dashboards using Dashboard Builder, Performance Management, Crystal Xcelsius, Excel, QAAWS, Live Office.
• Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system.
• Extensive experience in working with ETL Team in developing effective Data Marts and Models.
• Extensive experience in working with Ticket tracking applications like Remedy.
• Effectively administered and supervised the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports through CMC and Supervisor.
• Extensive experience in Migrating Business Objects 5.1 applications to 6.5.2 and 6.5 to BO XI R2, XI 3.0
• Good Understanding in Business Objects Framework (Architecture) and functionality.
• Extensive hands on experience in complete deployment (Installation, Upgrading, Configuration and Administration) of Business Objects versions: XI R2, 6.5.x, 5.1.x.
• Expertise in Installation, Configuration, Up-gradation, OLAP Universe Design, Performance Tuning/Optimization, User/Security.
• Excellent experience in writing PL/SQL Stored Procedures, Functions, packages and Triggers using Oracle 10g /9i /8i/7.3, SQL, PL/SQL, TOAD.
• Successfully managed JAD Sessions with the Business Users in Design and Development of the applications.
• Strong knowledge of complete SDLC(Software Development Life Cycle) and software quality management
• Experience in administration activities like creating and managing repositories, users, user groups, working with privileges in repository manager.
• Displays enthusiasm and willingness to develop continually evolving skills for maximizing work efficiency.

Technical Skills:
• Business Intelligence Tools – Business Objects XI R1/R2, XI 3.0 Enterprise Suite – Central Management Console, Central Configuration Manager, Auditor, Import Wizard, Publishing Wizard, Repository Migration Wizard, Universe Design, Desktop Intelligence, Web Intelligence, Crystal Reports 2008, XI R1/R2, 10, 9, Live Office, Query As A Web Service, SQL Reporting Services, Data Integrator, Business Objects 6.5.1 Suite – Supervisor, Designer, Business Objects, ZABO, Business Objects SDK, VBA.
• Performance Management Tools – Performance Manager, Dashboard Manager, Application foundation 6.5, Crystal Xcelsius 4.5 / 2008.
• ETL Tools – Informatica 6.0, 5.1, Power Mart, Power Center, MX2 and Designer
• Databases – Oracle 10g/9i/8i, SQL, PL/SQL, SQL server 2000/2005, SAP BW 3.5Access, Warehouse builder, DB2 - UDB.
• Data Modeling – Erwin 4.x, MS Visio
• GUI Tools – Crystal Reports, SQL PLUS, Developer 2000, Visual Basic 7.X/8.0/9.0, Visual SourceSafe 6.0d, TOAD
• Web Application Servers – WebLogic 7.0, Apache Tomcat 4.0, 5.5.26, IPlanet 6.0
• Operating Systems – Windows NT 4.0/2000/XP, Sun-Solaris, AIX, UNIX, Linux
• Scripting Languages – PHP, ASP, Java Script, VB Script, HTML, DHTML, CSS
• Languages – C/C++/C#, PL/SQL, Java 1.4
• Multimedia & Web Designing – MS Visual Interdev, MS Office, WINS, Adobe Photoshop, PageMaker, Macromedia Dreamweaver MX
Education:
• B. E in computer science

Professional Experience:
Spectra/Keane May’ 09 to Jun’ 09
Rockleigh, NJ
Business Objects Developer

Description:
Spectra is the leading provider of renal-specific testing services, performing more than 50 million tests each year, A wholly-owned subsidiary of Fresenius Medical Care, the world's largest vertically integrated dialysis service provider, Spectra is committed to constant innovation and quality service. Spectra use Business Objects and Data Integrator as the BI/ETL Tool. This project involves developing and analyzing reports for one of its clients. The Business Objects software was used to integrate querying, reporting, and analysis of their critical dialysis reports and customer data.

Responsibilities:

• Understood the current Architecture, databases and designed schemas.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements.
• 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
• Successfully tested all the reports and exported them to Live.
• Built static Dashboards using Crystal Xcelsius with the data in Excel files.
• Updated the static models with live data connecting via the Web Service connectors like QAAWS.
• Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008.
• Effectively communicated with off shore and development team in different locations.
• Effectively communicated with users in various locations throughout USA.
Environment: Business Objects XI R2 / XI 3.0, Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Xcelsius 4.5 / 2008, Query As A Web Services, Dashboard Manager, Performance Management, Microsoft Excel, Oracle 10g, SQL Server 2005, PL/SQL, TOAD.

3M, Minneapolis, MN Sep ’07 to Present
Business Intelligence Consultant

Description: The Company maintains a market leading position by working closely with its customers – industry-leading manufacturers and distributors. Company offers these customers the best product performance and reliability and the very latest in technology.
EDW BOBJ (Enterprise Data Warehousing – Business Objects) team is specialized in providing the reporting solutions to its customers using the Business Objects Enterprise Suite consisting of various tools like Web Intelligence, Desktop Intelligence, Crystal Reports, Crystal Xcelsius, and Dashboard Manager.

Responsibilities:

• Understood the current Architecture, databases and designed schemas.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Built universe on the designed schemas, well tested and exported them to repository using Business Objects Designer Module.
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes in Business Objects XI R2.
• Developed complex universes by using features like aggregate aware, Conditions and hierarchies to Perform linking of universes by Kernel method to optimize the universe development and performance improvement.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Used powerful business objects functionality's like @functions, Variables, user response and formulae.
• Published existing reports to corporate intranet through Web Intelligence.
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• 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
• Created “CX Drill-Down” Customer and Location Data and exported to Repository.
• Built Webi, Deski, Crystal reports on top of CX Drill-Down Universe.
• Logged and tracked the Help Desk tickets using the Remedy Application.
• Successfully performed the Remedy Dispatcher responsibilities in handling, updating and re-routing the request to the concerned Group / Individual.
• Efficiently and effectively handled the Change, Add, Delete Request in a Universe, WebI, Deski and/or Crystal Reports assigned via the Remedy tracking application.
• Successfully tested all the reports and exported them to Live.
• Built static Dashboards using Crystal Xcelsius with the data in Excel files.
• Updated the static models with live data connecting via the Web Service connectors like QAAWS, Live Office.
• Built dynamic dashboards with live data connecting to CX Drill-Down Universe using QAAWS and Live Office.
• Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008.
• Successfully completed the Go-Fast project “Sales Quota Performance Dashboard”, presented at the trade show in 3 weeks using static Data in Xcelsius 2008.
• Effectively communicated with off shore and development team in different locations.
• Effectively communicated with users in various locations through out USA.
• Involved in migrating Business Objects Enterprise from Solaris Server to AIX Server.
• Involved in SMA Performance Testing includes: Tweaking the Queries used in the Reports, Improve performance of the reports, reduce the Data retrieval times, suggest the design changes in the report like using prompts in reports in stead of Drill Filters, closing the Navigation Map while viewing the report.
• Created Business Objects WebI, Crystal Reports specifications document for monitoring performance of Business Objects using BAC Monitoring System.
• Created a Sales Quota Performance Universe, created classes, objects, measure objects, conditions, joins and exported to Enterprise repository in BO XI 3.0
• Created reports in WebI, DeskI in Business Objects XI 3.0
• Generated dashboards using Xcelsius 2008 and published the SWF files to BO Enterprise XI 3.0
• Involved in making Single-Sign On successful in XI 3.0 environment.
• Used Published Wizard, Import wizard in XI 3.o environment in publishing and migrating reports.
• Efficiently documented the differences between the BOXIR2 and BO3.0 for developers and end user reference.
• Effectively prepared and customized the training documents, White papers, Best Practices, Template documents.
• Efficiently trained both the developers and business users with limited or zero experience using Business Objects XI R2.

Environment: Business Objects XI R2 / XI 3.0, Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Infoview, Xcelsius 4.5 / 2008, Query As A Web Services, Live Office, Dashboard Manager, Performance Management, Microsoft Excel, Oracle 10g, SQL Server 2005, PL/SQL, TOAD, Apache Tomcat 5.5.26, Solaris, AIX

General Mills, Minneapolis, MN Jan ‘06 to Aug ‘07
Business Intelligence Consultant/ Analyst

Responsibilities:

• Analyzed the existing database and designed the universes using the Business Objects Designer module.
• Created the Monthly Operations and Focused Diligence Universes and created classes, objects, measure objects, conditions, joins and checked for integrity.
• Created aliases and resolved loops during the creation of the universe.
• Exported the Universes to the Central Management Server and fixed the errors caused during the export.
• Developed a Content Management Plan which shows the level of access that can be assigned to the groups and users.
• Created 25 different departmental accounts using the Central Management Console and assigned the access rights based on their profile.
• Set the Row Level Restrictions to the 25 different departmental accounts based on their profile.
• Created WebI, Crystal Reports using Specification document meeting user’s requirements.
• Integrated and extracted data into BO Crystal Reports to generate reports from SAP BW system.
• Set the User Access rights (Control & permissions) using the Central Management Console.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the BO SDK to accomplish this task.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Created Dashboards to monitor business performance, insight analytics, role based dashboards.
• Created the Xcelsius Dashboards for the Monthly Operations Review Meeting presented to the Executive Team of Managers.
• Created various reports such as Focused Diligence Tool Result, Diligence Hit Report, Reports by Department, Reports by Area, Reports by Period and comparative reports.
• Created the both thick client and thin client reports using the Business Objects functionalities such as Drill down, Cross Tab and Master Detail.
• Fixed errors such as #MULTIVALUE, #ERROR using the context operator such as In, ForEach
• Using the merge dimension feature in WebI linked appropriate dimension objects at the report level.
• Created Nested prompts and ALL object as a LOV based on the user requirements.
• Created Views to optimize the performance of the reports such as MECC Lean Statement report and Major Pricing Challenges report.
• Logged onto the Production server using the remote desktop connection to check for the event viewer in case of reported errors.
• Restarted the BOE services as per the requirement, remotely logging into the server
• Successfully interacted with the client in design and development of the reports and dashboards.
• Successfully tested all the reports with QA team before exporting to Live.
• Opened technical support cases with Business Objects and resolved those issues through Webex.
• Provided the technical support to the Production Team and fixed the errors while transferring the universe and reports from the New Development Server to the Production Server.
• Provided end user support and training for naïve users.

Environment: Business Objects 6.5/XI R2, Central Management Console, Universe Designer, Desktop Intelligence, Crystal Reports, Import Wizard, Publishing Wizard, Repository Migration Wizard, Web Intelligence, Crystal Reports Enterprise XI R2, Dashboard Builder, Performance Management, Crystal Xcelsius, SQL Reporting Services 2005, Query As A Web Service, Live Office, SQL Server 2005, DB2 – UDB, Excel, Oracle 10g/9i, PL/SQL, SAP BW 3.5, TOAD, UNIX, IIS 6.0 and Windows NT.
Ecolab, Minneapolis, MN Dec ’04 - Dec ‘05
Business Objects Consultant

Responsibilities:

• Member of the Warehouse design team, Interacted with Business and Database administrators to identify business requirements and data realities.
• Installed Business Objects XIR2 product and created Users, Groups and assigned permissions to the Users
• Used Business Objects Designer module to create the Universe on the existing data model.
• Used Import Wizard to migrate the class version of Business Objects to BO XIR2.
• Fixed the issues during the migration and after the migration (post migration) of Business Objects 6.5 to BO XIR2.
• Created predefined conditions, prompts and custom hierarchies in the process of building universes.
• Created and maintained several custom reports for the client using Business Objects. Generated reports using BO tools, querying database.
• Created DeskI and WebI reports and exported them to Central Management Server (CMS).
• Used the Report Conversion Tool to convert few Full client reports to Thin Client reports.
• Created reports like MECC Lean Statement Report, Inventory reports, Supply Disruption reports, Major Pricing Challenges, major Pricing Opportunities, Operational Metric reports, Inter Company Sales reports, Feedthrough Productivity reports, Entrust/Restore Feedthrough Performance reports, Capacitor Value Stream reports.
• Incorporated the Drill down functionality by using the custom hierarchy built at the Universe level.
• Created List Reports and Cross Tab Reports and Drill Through reports, standard and Ad hoc reports using Business Objects.
• Used the scheduling functionality in Infoview to schedule the reports based on the time basis.
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill Down.
• Created Alerter, Filters and used the Sorting functions in the business Objects reports.
• Created and presented dashboards like Region Dashboard and Plant Dashboard successfully for a Trade show among multiple competitors.
• Successfully interacted with client in managing JAD sessions in designing and developing the reports.
• Moved the development box to Production box and helped the DBA to fix issues during the process.
• Provided end user support, training and documented the development process.
Environment: Business Objects 6.5/BOXI R2 (Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Central Management Server, Central Configuration manager, Import Wizard, Report Conversion Tool), Designer 6.5 Supervisor 6.5, Web Intelligence, Dashboard Manager, Oracle 9i, PL/SQL, SQL * Loader, UNIX, Windows NT, TOAD.
At&t, Atlanta, GA Jun ‘03 to Nov ‘04
Technical Support Engineer
Description: At&t wireless is the largest American wireless company and largest wireless data provider. This project involves developing and analyzing reports for one of its clients in telecom industry, which was used by the Billing department to analyze information and generate management reports.
Responsibilities:
• Involved extensively in creation of OLAP Universes using Business Objects Designer.
• Involved in taking requirements and writing specifications for designing the Universes. Created Business Objects Universes to get the data from Data Warehouse.
• Designed Billing Star Schema and universe based on this schema.
• Designed developed, maintained and tested universes for supporting ad-hoc-queries and canned reports and export them to the Universe Domain which can be accessed by users for reporting purpose.
• Linked the Universes to share the common components between the universes.
• Created the joins strategies while designing the universes.
• Checked the integrity of the Universe for existence of loops and resolved them by using aliases and contexts. Created database connections to connect the universes to different data sources.
• Modified the Universes, added additional Dimension, Detail, and Measure Objects according to the requirements.
• Worked with Multi Cube Analysis such as pulling data from different data providers for simplifying the reports.
• Formatting the Reports to the Users requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
• Created Master Detail, Cross Tab, Summary reports to view the data in an analyzed way.
• Involved in designing and developing of complete reporting application.
• Involved in the transitioning from 5.1.2 to 6.5 version providing all ground work including upgrading.
• Exported the reports to the Broadcast Agent server
• Scheduled reports on daily/weekly/monthly basis using Broadcast agent.
• Finally prepared the Documentation of the entire project

Environment: Business Objects 6.5.2/5.1.2, Designer 6.5.2/5.1.2, Supervisor 6.5.2/5.1.2, Web Intelligence 6.5.2/2.7, Crystal Reports, BCA, Infoview, Oracle 9i/8i, SQL Server 2000, DB2, SQL, PL/SQL * Loader, UNIX, TOAD, Windows 2003 Server, IIS 6.0
MetLife of NY Mar ’02- May ‘03
Business Objects Developer
Responsibilities:

• The project is development of Business Objects universes for the Financial and Indirect Sales Identity Management Data marts for BCBS to provide them an efficient reporting system.
• Performed an Initial Study of the Current Reporting application, to finalize the data elements required for reporting.
• Interviewed the clients for the enhancements needed to the current reporting system to perform their job more efficiently.
• Involved in taking requirements and writing specifications for designing the Universes to get the data from the NDW Data Warehouse.
• Designed, developed, maintained and tested Accounts Receivable, Sales Identity Management universes utilizing the best practices in Business Objects for supporting adhoc-queries and canned reports .
• Checked the integrity of the Universes for existence of loops and resolved them by using aliases and contexts. Created database connections to connect the universes to different data sources.
• Worked with Multi Cube Analysis such as pulling data from different data providers for simplifying the reports.
• Formatting the Reports to the Users requirements using Multi-Dimensional Analysis like Slice and Dice, Drill Down.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Successfully utilized the Report Bursting feature of Business Objects by sending the reports to the BCA for scheduled processing and distribution to users based on their profiles.
• Responsible for the performance tuning of SQL queries on Oracle database by using features like creating the materialized views and function based indexes depending on the reporting requirements.
• Used Data Integrator in setting up Extraction, Transformation and Load process
• Support to ETL team in maintaining data integrity, Extraction and Loading of data from Data warehouse system using Data Integrator.
• Responsible for the administration of Business Objects and upgrade from version 5.1.8 to 6.5.
Environment: Oracle 9i, Business Objects 5i/6.5, Broadcast Agent Server (BCA), SQL Loader, PL/SQL, UNIX.

Fifth Third Bank, IL Feb’01 – Mar ’02
Business Objects Designer/Developer

Description: Fifth Third Bank is one of the largest players in the financial industry providing financial products and services, including deposits, investments, loans, insurance, and on-line banking. It Offers credit card and other cards of corporations, financial institutions, universities, sports franchises and affinity organizations to customers of different brand. The project at Fifth Third Bank involved converting huge amount of transactional and financial data into a business-intelligence engine for use by employees. The Business Objects software was used to integrate querying, reporting, and analysis of their critical financial and customer data. Created complex reports on ad-hoc basis for power users and static standard reports that are compiled once for vast majority of users

Responsibilities:

• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using BUSINESS OBJECTS 5.1.
• Developing complex universes by using advanced features like aggregate aware, Conditions and hierarchies to Perform linking of universes by Kernel method to optimize the universe development and performance improvement.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Worked on Powerful business objects functionality's like @functions, Variables, user response and formulae.
• Published existing reports to corporate intranet through Web Intelligence.
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• 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.

Environment: Business Objects 5.1.7, WEBI 2.6, Broadcast Agent, Oracle 8i, PL/SQL, Info view, Windows 2000.

Nextel, Herndon, VA Jun ‘00– Jan ‘01
Business Intelligence Developer

• Developed mock up reports from mock data for evaluation and user presentation
• Generated Complex BO reports for comparison of actual and projected cash flow using Business objects as end user Query tool
• Created complex reports by linking data from multiple data providers from different databases
• Used functionalities like Slice and Dice, Drill Down, Master Detail, Breaks, Custom Sorts
• Analyzed, designed, built and tested reports while working directly with end-users and technical team
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
• Deploying Business Objects Reports over Web and Testing of Reports.
• Developed Technical User Documentation and involved in training the End Users

Environment: Business Objects 4 (Reporter, Designer), Oracle 7i, MS Access 2000, Windows.