Business Objects Developer

Reji Sebastian

E-mail: ****.*****@*****.***

Contact: 409-***-****

Professional Summary:

Over 7 years of experience in of experience in software analysis, Business Intelligence, Reporting, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and testing Data Warehousing Applications.

Expertise in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects architecture, software deployment, Business Objects administration, BOE Security, Universe/Report/Dashboard development, documentation, Production Support and user training.

Strong Development knowledge in SQL Server 2000 and SQL Server 2005 and SQL Server 2008.

Experience in providing Business Intelligence solutions using Business Objects XI R3.1/XI R2/6.5/6.1a/5.x

Expertise in Designing and building universes by analyzing the Business Requirement, Conversing with Business Analysis and System analysis Teams on the technical aspects of the requirement, Data Modeling, Universe creation, Universe promotion and implementation.

Expertise in designing Simple, Complex Ad hoc Reports and fine-tuning the reports using Calculations, User Variables, multilevel Breaks, Sorting, Drill, Slice and Dice and Alerts for creating Business Objects reports.

Experience in complete Business Objects migration from XI R2 to XI R3, which included, Universes, reports, users, user groups and Security.

Expertise in Business Objects Security implementation, worked on a large BO Security implementation, setting up Universe security, Application Security, Content security, Folder Security, Row level Security and Object Level Security.

Expertise in Business Objects Designer, universe designing, adding objects to universe, joins, aliases, contexts, setting up incompatibilities and aggregate navigation, managing row level security and object level security.

Expertise in Import Wizard, moving Universes, reports, Users and Security using Import Wizard across environments.

Expertise in Business Objects Life Cycle Management ( LCM), moving Universes, reports, Users ,Security using LCM jobs and LCM Version management of Reports and Universes.

Experience in BO Query Builder.

Expertise in creation, scheduling, publishing ,fine tuning and maintenance of complex webi reports, assist power users and Reporting team members on various issues like query performance and creating efficient reports on complex Business requirements.

Experience in Web Intelligence Rich Client and Desktop Intelligence reporting, assist power users and Reporting team members on various issues like query performance and creating efficient reports on complex Business requirements.

Expertise in CMC, Organizing and Defining Managing activities.

Experience in Crystal Reports XI/2008 and SSRS Reporting.

Experience in BO Auditing Database and creation of Auditing Reports.

Experience in Xcelsius 2008, Live Office and QaaWS and creation of Dashboards.

Expertise in Business Objects tools InfoBurst and 360

Experienced in writing the stored procedures, functions and views and tuning them for production systems.

Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements and implementation process.

Expertise in documenting various implementation procedures for the software promotion.

Experience in BO development promotion activities to QA, UAT and Production Systems.

Expertise in writing user manuals for the software implementation.

Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance of Projects.

Experience in recovery, restoration and Business Continuation procedure and process.

Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.

Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.

Closely works with Business Analysts, System Analysts and testers and Implementation Team

Excellent Communication and inter personal Skills when working with developers, project managers and application end-users.

Excellent communicator with strong interpersonal skills; able to convey complex technical concepts to administrative/non-technical users.

Microsoft Certified in SQL 2005 Maintenance and Implementation.

Education Qualifications:

Master in Computer Application (MCA)

Skill set:

BI Tools: Business Objects XI R 3.1, R1/R2 6.5.x/5.x, CMC,LCM, Crystal Reports 2008/XI ,Crystal Xcelsius 2008, Live Office, InfoBurst, Query Builder,360,SSRS 2008/2005

ETL Tools: DTS/SSIS 2008/2005

Platforms: Windows (all flavors), LINUX

Databases: Oracle 9i/ 8i, MS SQL Server 2008/2005/2000, Access, DB2.

Languages: C++, C#, VBScript, SQL, PL/SQL

Impl Tools: Remedy, TFS, Quality Center, and PVCS.

Web Servers: Apache v2/Tomcat 4.1, IIS

Projects Summary:

Prudential Real Estate and Relocation Services, Scottsdale, AZ September 2008 – Till Date

Sr. Business Objects Developer

Prudential Real Estate and Relocation Services (PRERS) is a Real Estate and Relocation Company owned by Prudential Financials. It boasts a true global presence, having relocation operations in more than 50 counties. The Client base includes Fortune 500 companies, Small Scale industries and Government agencies.

Hardware/Software:

Business Objects XI 3.1/R2, LCM, Report Conversion tool, Publishing Wizard, Universe Designer, Desktop Intelligence Infoview and Rich Client,InfoBurst,360, MS SQL Server 2008/2005, T-SQL, SSRS, SSIS, Windows Server 2003, Windows NT , MS Access, Quality Center, PVCS , Remedy.

Responsibilities:

Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Create logical and physical model for new universes.

Create new universes, objects and classes, contexts and set up aggregate awareness and incompatibilities, apply row level and objects level security.

Work with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Work on Queries, views, stored procedures, functions and jobs.

Update the existing universe on Various Change requests and System Requests.

Promote the universe changes to QA, UAT and Production using Import Wizard or LCM Jobs.

Provide defect fixing and continuous support after production implementation.

Analyze production defects and fix and promote them.

Creation, Schedule, Publish, Fine tune and Maintain complex webi reports.

Assist Power users and Reporting Team members on Reporting Questions; provide them assistance in complex webi, Rich Client and Deski reports.

Identify slow Running Reports and Fine tune them.

Design and develop Crystal Reports to be used in the system. Reports developed included Summary, Charts, Graphs, Drill-down, TOP N reports, Labels with formulas, SQL Expressions, Grouping, Sorting, sub reports, Parameters etc.

Design and develop Crystal Reports to be used in the system. Reports developed included Summary, Charts, Graphs, Drill-down, TOP N reports, Labels with formulas, SQL Expressions, Grouping, Sorting, sub reports, Parameters etc.

Create Xcelsius Dashboards on Business requirements.

Address various BO issues experienced by the Reporting Users, like security issues, report time out issues.

Document various steps required for development promotion.

Participate in recovery, restoration and Business Continuation procedure and process.

Write user manuals for the software implementation.

Give training to users on the products developed.

Burst Reports using InfoBurst and troubleshoot issues of InfoBurst users.

Create various Auditing Reports on Demand from Senior Management.

Closely works with Business Analysts, System Analysts and testers and Implementation Team

Just Completed an Enterprise level Security Remodeling, which addressed Universe security, Application Security, Content security, Folder Security, Row level Security and Object Level Security.

Performed complete Business Objects migration from XI R2 to XI R3, which included Universes, reports, users, user groups and Security.

Assisted QA team on QA and UAT Test cases and assisted users in post XI R3 migration testing.

Addressed various issues while migrating from XI R2 to XI R3, such as formula changes, object rights, issues on the existing reports etc.

Maintains SSRS Reports.

Worked extensively on SSIS for a Legacy archival Project.

Prudential Financials, Roseland, NJ February 2005- August 2008

Business Objects Developer

Prudential Financial, a financial services leader with approximately $542Billion of assets under management and have operations in United States, Asia, Europe and Latin America. It capitalizes on unique combination of life insurance and investment management expertise to provide compelling asset growth and protection solutions for the ever-increasing retirement needs of individuals and businesses in the U.S. and abroad.

Hardware/Software:

Business Objects XI R2/6.5, Universe Designer, Desktop Intelligence and Infoview MS SQL Server 2005/2000, T-SQL, SSRS, SSIS, DTS, Windows Server 2003,Windows NT , MS Access, Quality Center, PVCS , Remedy

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Designed logical and physical model for new universes.

Designed, developed and modified Universes by Objects data model selecting/joining tables, Indicating cardinalities, creating Aliases to resolve the Loops, subdividing into Contexts and creating the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom Lists of Values. Used @Aggregate_Aware, @Where, @Select, @Variable, @Prompt and @script functions when required. Created derived tables, and objects with index awareness for optimized performance

Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Worked on Queries, views, stored procedures, functions and jobs.

Promoted the universe changes to QA, UAT and Production using Import Wizard.

Provided defect fixing and continuous support after production implementation.

Analyzed production defects and fixed and promoted them.

Created, Scheduled, Published ,Fine tuned and Maintained complex webi reports

Assisted Power users and Reporting Team members on Reporting Questions, provide them assistance in complex webi reports and Deski Reports

Worked on slow Running Reports and Fine tuned them.

Designed and developed Crystal Reports to be used in the system. Reports developed included Summary, Charts, Graphs, Drill-down, TOP N reports, Labels with formulas, SQL Expressions, Grouping, Sorting, sub reports, Parameters etc.

Addressed various BO issues experienced by the Reporting Users, like security issues, report time out issues

Documented various steps required for development promotion.

Participated in recovery, restoration and Business Continuation procedure and process.

Write user manuals for the software implementation.

Give training to users on the products developed.

Created various Auditing Reports on Demand from Senior Management.

Closely worked with Business Analysts, System Analysts and testers and Implementation Team

Worked on Security models which addressed Universe security, Application Security, Content security, Folder Security, Row level Security and Object Level Security.

Took part in Business Objects XI Upgrade involved Understanding complete migration process, part of team in creating POC, Migration Assessment, planning, Importing to the destination environment, Post-import checking and tuning the test environment.

Addressed various issues while migrating from XI R2 to XI R3, such as formula changes, object rights, issues on the existing reports etc.

State Bank of India, Mumbai, India July 2004 – January 2005

Import & Export Software Department

Business Intelligence Developer

State Bank of India (SBI) is the largest bank in India, having wide network of over 16000 Branches. Through its large network of authorized branches, the bank facilitates foreign exchange needs of its clientele engaged in export and import trade and the SITB provides rates for conversion of all major world currencies like U S Dollar, Sterling Pounds, Euro, Swiss Francs, Japanese Yen and other exotic currencies. The services to the customers of the Bank include hedging of foreign currency risks by providing forward covers and various derivatives product.

Hardware/Software:

Business Objects XI 6.5, Universe Designer, Broadcast Agent ,Desktop Intelligence and Infoview MS SQL Server 2000, T-SQL, SSRS, DTS, Oracle 8i/9i, Windows Server 2000,Windows NT , MS Access.

Responsibilities:

Drafted the business requirements of the management and other business users.

Analyzed the transaction systems and design the required star schema according to business needs for the data mart

Designed the Universes incorporating all the Business requirements.

Created Aliases, Multiple contexts for catering different functional areas in a single user query and solved the loops problems.

Aggregate awareness Functions of Business Objects were used to route the query objects through most appropriate path while selecting from multiple contexts

Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements and also developed the analysis reports

Business Objects Reports development using SQL and functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc. Involved in production Support and gave training to the users.

Designing Business Objects Universes and in the report level created variables, formulae and detail objects.

Automated the scheduling the reports using Broadcast Agent Server and designed documentation for future reference.

Created Database Objects - tables, indexes, views, and roles.

Created of customized stored procedures functions and jobs

Converted data from miscellaneous sources using Data Transformation Services Package (DTS).

Responsible for performing Recovery and Restoration.

Optimization of SQL statements for customer summary reports.

My Key Strengths:

Strong interpersonal and oral communication skills.

Adept at reading, writing, and interpreting technical documentation and procedure manuals.

Ability to conduct research into software issues and products as required.

Ability to present ideas and solutions in user-friendly language.

Highly self motivated and directed.

Keen attention to detail.

Proven analytical and problem-solving abilities.

Ability to effectively prioritize and execute tasks in a high-pressure environment.

Strong customer service orientation.

Experience working in a team-oriented, collaborative environment.

References: Available upon on request

Contact this candidate