We provide IT Staff Augmentation Services!

Sr. Business Objects Report Design Resume

Hanover, MD

Objective:

  • Over 7 years of IT experience in Analysis, Design, Development and Implementation of Business Intelligence (BI) solutions using Data Warehouse/ Data Mart, ETL, OLAP, Client Server Technologies and Web-based Applications.
  • Over 5+ years of experience in using Business Objects Enterprise products (Business Objects Designer, Business Objects Reporting, Business Objects Enterprise XI 3.1/3.0/R2, Business Objects Supervisor, Web Intelligence, Info View, Business Objects Data Integrator and scheduling the reports using Broadcast Agent Publisher (BCA).
  • Good knowledge in Business Objects XI 3.1/3.0/R2 and Business Objects Enterprise Administration.
  • Extensive experience as a Crystal Reports Developer creating reports in Crystal Reports XI/10/9/8.5/8/7/6, Crystal Enterprise XI/10/9/8.
  • Installed & Configuration of Business Objects XI 3.1/3.0/R2 with CMS on Windows and AIX Platform
  • Experienced in creating Complex reports in DeskI and WebI using multiple data providers, complex query filters, Combined Queries and Sub Queries.
  • Created Canned Reports, Complex Ad-hoc Reports using Business Objects and Web Intelligence tools.
  • Experienced in Creating Crosstab, Chart and Master Detail BO reports having sorts ,breaks

Report filters, Nested filters and Drill Options.

  • Created complex views to overcome loops and contexts.
  • Expertise in Designing/Developing the User-Interface (Universe), distributing and maintaining the Universes.
  • Exported the reports to Broadcast Agent Server (BCA) for scheduling the reports.
  • Good experience in developing queries on different types of Data Providers like Universes, Personal data files, Stored Procedures and Free-hand SQL.
  • Technical analysis of the requirements and the source data availability, BO development, testing (preparation of test cases and execution of the test cases) and report related communication.
  • Working experience with Data Migration Applications, responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
  • Creating Projects, Jobs, Workflows, Transformations and Data flows in Data Integrator.
  • Creating Data Store and Target table in Data flows using Data Integrator.
  • Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts. Knowledge on Data modeling using Dimensional Data modeling - Star Schema Modeling, Snowflake Modeling.
  • Extensive experience in SQL & PL/SQL Programming.
  • Maintain/document business rules, Provide communication and planning for implementing customers as necessary.
  • Experience in Performance Tuning, Backups, Restores, Indexing and Monitoring experience.
  • Experience in deployment of Business Objects & Web Intelligence from Various Data Sources such as Oracle, MS SQL Server and MS Access.
  • Maintain/Implementing/Document Business Rules, Provide Communication and Planning for customers as per the requirements.

Education: Master of Computer Applications

Technical Proficiency:

Business Intelligence : Business Objects XI 3.1/3.0/R2/R1//6.x/5.x (Supervisor, Designer, Crystal Reports XI, Xcelsius, Web Intelligence XI/6.x/2.x,Info View), Data Integrator 11.7
ETL Tools : Informatica7.1
Databases : Oracle 10g/9i/8.x/7.x, SQL Server 2005/2003, MS Access.
GUI : Visual Basic 6.0.
Languages : C, C++, SQL, PL/SQL.
Operating Systems : Windows NT/XP/00, MS-DOS, UNIX, AIX.
Packages : MS Office.
Confidential,Redmond, WA Nov’08- Till Date
Sr. Business Objects Report Developer

Confidential,is a communications holding company. Its subsidiaries and affiliates, AT&T operating companies, are the providers of AT&T services in the United States and around the world. Their offerings include Internet protocol (IP)-based business communications services, third generation (3G) network and wireless coverage worldwide, and Internet access and voice services. I do handling 3 applications. CSSNG, CASPR, CTS. CSSNG has Location, Radio Base Station, Cell Site, Sector and Market Information. CASPR has Project details and Milestone Information and CTS (Centralized Ticketing System) is Used for resolving problems and communicating network activities & events between CTS user groups. The CTS Netcool interface provides a bidirectional interface between CTS and Netcool. Force is designed and implemented a new interface to CTS to allow the Force to assign and Dispatch tickets to wireless field technicians.

  • Participated in business requirements analysis, report designing and modeling, development of technical specifications, testing and Implementation.
  • Created mock -up reports for initial user presentation in the process of designing Functional Specifications.
  • Installed and configured BO XI R2/ 3.1 on WIN 2003 Server, configured each of Business Objects Enterprise server components and involved in migration to BO XI 3.1.
  • Migrated users, groups, reports, repository objects BO XI R2 to BO XI 3.1 and tested the reports and resolved issues during migration.
  • Created new Classes, Sub-classes and Objects as per the standards that were put in place during the Strategy process and identified Objects as Dimensions, Details or Measures.
  • Developed Universes by defining joins, cardinality between tables, creating prompts, applying contexts and alias to resolve loops/traps and checked the integrity of the Universe using Business objects Universe Designer.
  • Created complex Linked Universes to reduce development and maintenance time.
  • Defined security filters to implement Row level and Column level security
  • Created derived tables at the Universe level to reduce the complexity of the Universes.
  • Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
  • Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
  • Created complex reports using WebI from multiple data providers and merged the data from different providers using merged dimensions concept.
  • Created complex Cross Tab, Master Detail reports with Slice and Dice, Drill Down functionalities using WebI.
  • Extensively used Calculations contexts, Variable, Breaks, Sorts and Alerters les for creating WebI reports.
  • Generated WebI reports involving complex queries, sub queries, Unions and Intersection.
  • Created reports by retrieving data from Stored Procedures, Free- Hand SQL using T-SQL.
  • Created Business Views to implement the feature of dynamic cascading prompts.
  • Customized business objects Web Intelligence, Universe, Desktop Intelligence with .NET SDK, WebI SDK, Universe SDK and Desktop Intelligence SDK.
  • Exported the Business Objects reports to WebI to be viewed by all users on the Intranet using WebI SDK
  • Moved content from dev-test-prod environments using import wizard and BIAR files
  • Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, scheduled reports for different file based / schedule based events, distributed in email, PDF and HTML format.
  • Published Reports in Business Objects Enterprise via Publishing Wizard and Business Objects Management Console.
  • Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
  • Experience in Scheduling the Reports using Business Objects Enterprise.
  • Installed and set the Central Management Server, Processing Servers & Report Application Server.
  • Creating Projects, Jobs, Workflows, Transformations and Data flows in Data Integrator.
  • Check the Job Server Trace, Job Server Monitoring and Job Server Error.
  • Creating Repositories and Central Repositories in Data Integrator.
  • Involved in creating Program specifications to write, test, debug, document, and implement complex Batch jobs and Real time jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Integrator XI (ETL).
  • Configured database Data Stores and File Formats to allow Data Integrator XI to connect to the source or target database and files.
  • Created High level ETL design using data integrator to meet the data requirements for analyzing and designed mappings & mapplets to load data into target table / staging area from various sources using different transformations.
  • Develop processes using ETL tools (Data Integrator 11), PL/SQL and SQL to support business reporting requirements.
  • Design and develop ETL processes, data flows, and Data Marts based on business requirement specifications.
  • Action Reports are used for activities related to the network equipment and facilities.
  • Worked on Trouble Shooting of different database connectivity, performance tuning.
  • Involved in day to day Business Objects Data Integrator Management Console maintenance.
  • Involved in day to day Business Objects Server maintenance.
  • Created Tables & Views and referential integrity constraints using SQL.
  • Identifying and creating Oracle database objects (Tables, Views, Synonyms, Indexes, Constraints, Procedures, Functions, Database Triggers).
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Excellent analytical and logical programming skills with a good understanding at the conceptual level

and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals

  • Environment: Business Objects Enterprise XI 3.1/3.0/R2, Web Intelligence, Data Integrator 11.7.2, Oracle 10g, Toad 8.6.1, PL/SQL, Xcelsius, Sql Server 2005/2003, Win 2000.

Confidential,Hanover, MD Jul’ 07 – Oct’08
Sr. Business Objects Report Developer

Confidential,is Maryland’s version of the federal Statewide Automated Child Welfare Information System (SACWIS) model. It is implemented as 3 tier client server architecture with Business Objects Enterprise and Crystal Reports and db2 as the back end.

Responsibilities:

  • Worked on Trouble Shooting of different database connectivity, performance tuning.
  • Participated in business requirements Analysis, Report Designing and Modeling, development of Technical Specifications, Testing and Implementation.
  • Implemented Best Practices for Using Business Objects Enterprise Suite of Products.
  • Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
  • Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
  • Analyzed the reports using the Drill Through, Slice and Dice.
  • Migrated Business Objects XIR1 & Crystal 10 to Business Objects XI R2.
  • Defined Users, Groups, Categories & Connections with CMC.
  • Installed & Configuration of Business Objects XI R2 with CMS on Windows and AIX Platform
  • Involved in day to day maintenance of Business Objects Servers.
  • Installed and set the Central Management Server, Processing Servers & Report Application Server.
  • Applied Microsoft Patches for Business Objects XI R2 for registered bugs.
  • Experience in Scheduling the Reports using Business Objects Enterprise.
  • Facilitated meetings across Departments for implementing a standard Architecture for deploying Business Objects XI R2 across the entire Organization.
  • Implemented 3-Tier Business Objects with Cluster environment.
  • Involved in day to day Business Objects Server maintenance.
  • Developed Functional (Business terms) and Technical Design documents.
  • Upgraded the BO&WEB Intelligence from XIR1 to XI R2.
  • Involving in Account, Content and Server managements managed by Business Objects Enterprise server with Business Objects Management Console and Business Objects Configuration Manager by using Business Objects Enterprise.
  • Published Reports in Business Objects Enterprise via Publishing Wizard and Business Objects Management Console.
  • Major responsibilities include getting requirements from the user and developing Business Objects Reports.
  • Implemented Import Wizard & Publisher for migrating reports & universes.
  • Created Universes based on the dimensions, detail and measures required for the analysis.
  • Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
  • Implemented Security with CMC for single sign for end user activity.
  • Created the Logical and Physical Model using classic Star-Schema.
  • Implemented Single Sing-on & Security Layer with Row Level Restrictions.
  • Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
  • Working with DI Central Repository to maintain the changes in versioned process.
  • Creating Projects, Jobs, Workflows, Transformations and Data flows in Data Integrator.
  • Creating Repositories and Central Repositories in Data Integrator.
  • Check the Job Server Trace, Job Server Monitoring and Job Server Error.
  • Writing database packages, store procedures, functions, triggers for the complex business logics.
  • Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
  • Created Tables, Views and referential integrity constraints using SQL.
  • Wrote Database Triggers, Procedure and Functions using PL/SQL.
  • Created many Procedures, Triggers, and Functions in PL/SQL for server side coding.
  • Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Environment: Business Objects Enterprise XI R2/R1, Data Integrator XIR2., Web Intelligence, Crystal Reports XI, Crystal Enterprise XI, Xcelsius, DB2 UDB, Oracle 10g, Toad 7.4, PCVS, Win 2000 and AIX.

Confidential,MO Apr’06–June’07
Sr. Business Objects Report Developer

Confidential,which is a financial brokerage company has merged with Wachovia Securities LLC (WSI). As part of the Wachovia (WSI) and A.G.Edwards (AGE) merger, I was involved on multiple projects like PCG management Interim Reports, PCG Management Final Reports-Integration, Supervision, Legacy AGE BETA Function ALLY-HAST, AGE Merger Scalability Program and Repartitioning Identity DQ Fixes.

Responsibilities:

  • System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
  • Defined server statistics & load balancing test across enterprise environment.
  • Instrumental in fitting the Business Objects Architecture into the System.
  • Implemented Best Practices for Using Business Objects Suite of Products.
  • Installed & Configuration of Business Objects XI R2 with CMS on AIX Platform
  • Actively involved in gathering server sizing requirements for software/hardware.
  • Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.
  • Implemented Single Sign-On & Security Layer with Row Level Restrictions.
  • Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
  • Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the
  • Facilitated meetings across Departments for implementing a standard Architecture for deploying
  • Implemented Security with CMC for single sign for end user activity.
  • Defined Users, Groups, Categories & Connections with CMC.
  • Created Universes based on the dimensions, detail and measures required for the analysis.
  • Problems with database when integrating with Business Objects.
  • Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
  • Implemented Import wizard & Publisher for migrating reports & universes
  • Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
  • Designed architecture & set up for development, production & test repositories.
  • Involved in Gathering user requirements.
  • Created the Logical and Physical Model using classic Star-Schema.
  • Created Universes based on the dimensions, detail and measures required for the analysis.
  • Migrated Business Objects XI R1 & Crystal 10 to Business Objects XI R2.
  • Prepared user documentation for hand on training for end user community.
  • Designed Production System support and handling opened user cases.
  • Implemented web intelligence in distributed (clustered) Environment.
  • Customized Webi with Webi SDK and integrated with java portal.
  • Implemented Application Foundation with Dash Board Manager.
  • Business Objects XI R2 across the entire Organization.
  • Designed Dashboard reports and Scorecard formats with process analytics & predictive analytics.
  • Created many Procedures, Triggers, and Functions in PL/SQL for server side coding.
  • Worked for the Release D backend activities using PLSQL extensively for the Enhancement of Accounts and Customer Module.
  • Analyzed the reports using the Drill Through, Slice and Dice.
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Created Tables & Views and referential integrity constraints using SQL.
  • Wrote Database Triggers, Procedure & Functions using PL/SQL.
  • Writing database packages, store procedures, functions, triggers for the complex business logics.
  • Involved 24X7 production support

Environment: Business Objects XI R2/R1, Crystal Reports XI, Web Intelligence, AIX, TOAD, Oracle 9.2/10g and PL/SQL.

Confidential,MI May’05-Mar’06
Business Objects Report Developer/Administrator

Confidential,is one of the nation\'s leading diversified health care benefits companies, serving approximately 34.9 million people with information and resources to help them make better informed decisions about their health care. Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life, long-term care and disability plans, and medical management capabilities. Our customers include employer groups, individuals, college students, part-time and hourly workers, health plans and government-sponsored plans

Responsibilities:

  • Involved in system analysis and design of the Data warehouse.

Installed & Configured Business Objects Suite of Products XI R1 on AIX Server and Windows.

  • Involved in day to day maintenance of Business Objects Servers.
  • Implemented 3-Tier Business Objects with Cluster environment.

Installed and set the Central Management Server, Processing Servers & Report Application Server.

  • Involved in day to day Business Objects Server maintenance.

Good exposure in developing reports with data in data warehouse and data marts.
Clear understanding of business procedures and ability to work as an individual and as a part of a team.
Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
Created Universes based on the dimensions, detail and measures required for the analysis.
Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
Analyzed the reports using the Drill Through, Slice and Dice.

  • Applied patches for Business Objects XI R1 for registered bugs.
  • Developed Functional (Business terms) and Technical Design documents.
  • Upgraded the BO&WEB Intelligence from 6.51 to XI R1.
  • Involved in rollout of new version Business Objects deployment.
  • Responsibilities include Prompting / Migrating Repository from Development, to QA to Production.
  • Back up the BO 6.51 repository & disconnect all the clusters & disable access to users.
  • Upgraded the repository to 6.51 and connected all clusters & users to new XI R1 repository.
  • Designed Business Objects Architecture and set up for enterprise wide.
  • Migrated Universes, Full Client Reports & Webi Reports.
  • Designed migration strategies from development to test & Production.
  • Defined Users and their profiles with appropriate access privileges.
  • Maintenance of Testing, Development & Production repositories.
  • Scheduled reports with Broadcast agent and implemented report bursting.
  • Tuned Business Objects system at OS Level, Network level & Application Level.
  • Prepared user documentation for hand on training for end user community.
  • Designed Production System support and handling opened user cases.
  • Implemented dash board reports with Performance Management.
  • Scheduled full client reports and Webi reports.

Created Tables & Views and referential integrity constraints using SQL.
Wrote Database Triggers, Procedure & Functions using PL/SQL.
Created many Procedures, Triggers, and Functions in PL/SQL for server side coding.
Writing database packages, store procedures, functions, triggers for the complex business logics.

  • Prepared system document for required Software and Hardware & network resources.
  • Optimized system with load balancing with distributing components on different servers.
  • Design and development of requirement definition documentation, based upon previous interview sessions with business users.
  • Responsible for designing Data warehouse schemas for Oracle Warehouse.

Environment: Business Objects XI R1/6.51, Oracle 9.2/8.1.7, SQL, PL/SQL, Web Intelligence, AIX, Windows.

Confidential,NJ May’04-Apr’05

Business Objepcts Report Developer/ Administrator

Confidential, is the world\'s leading provider of private banking services, which has a diverse client base that includes individuals, corporations, institutions and governments. UBS offers products and services designed to provide appropriate solutions to its clients, regardless of where they are located.
UBS has a huge Financial Data warehouse, which extracts data from various databases. The bank’s goal is to build the capability to better analyze the banks accounts. Users want the ability to slice and dice individual accounts as well as the residential household groupings to which they belong. The main objective is to market more effectively by offering additional products to households that already have one or more accounts with the bank. In addition to the household identification, users are interested in demographic information as it pertains to both individual customers and households. UBS Bank uses web based Intranet and full client access for distributing their reports across users and departments.

Responsibilities:

  • Created other reports with respect to Branch information, Account types, Available products and services, Geographical area of the house holds of customers, House hold type, House hold income, number of dependents etc.
  • Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
  • Created Universes based on the dimensions, detail and measures required for the analysis.
  • Configured Broadcast Agent, Initialized and Configured Supervisor in Business Objects.
  • Instrumental in migration of Repositories.
  • Created complex formulas in crystal reports.
  • Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes.
  • Linked the Universes to share the common objects between them.
  • Created Objects using different Business Objects functionalities like @ prompt, @variable, @select in the process of designing the universes.
  • Created reports in cross tab, master detail format and transformed them in 2-D, 3-D Column, Line, Area, and Pie charts for graphical analysis. Created reports with conditions and organized data in regions using slice and dice mode and created thin client reports with Ranking, Sorting and Filter objects.
  • Created Alerts in various reports according to user requirement.
  • Scheduled and monitored reports using Broadcast Agent.

Environment: Business Objects 6.5, Broadcast Agent, Web Intelligence, Info View, Oracle 8.1.7, SQL Server 2000, Windows 2000, UNIX

Confidential,Hyderabad Feb ‘03 – Apr’04
Programmer/Analyst
The project was to design and develop a customer database. This system helps the customer service representatives to perform all their duties helping customers in assisting their problems and questions. This project also helps the representatives in update/delete/modify customer profile and also arrange for bill Payments.

Responsibilities:

  • Extensively involved in requirements gathering and data gathering to support developers.
  • Involved in designing and of functional specifications for the development of user interfaces.
  • Involved in designing of Entity Relationship Diagrams.
  • Created tables, indexes, sequences, constraints and snapshots.
  • Developed packages, procedures, functions and PL/SQL blocks for data validation.
  • Developed PL/SQL scripts to validate and load data into interface tables.
  • Fixed software bugs and interacted with developers to resolve technical issues.
  • Helped in writing proposals, documentation and training.
  • Designed and developed a Generic Billing system for a Telecommunication company.

Environment: Oracle 7.3.2, SQL, PL/SQL, Shell Scripts, Oracle Forms 4.5/Reports 2.5, MS Access, MS Excel.

Confidential,Hyderabad, India May‘02-Jan’03
Database /Application Developer
Confidential,is a software product developed for the State Co-Operative Banks all over India. The product mainly involves in Loans Monitoring, Loans Recovery, Financial Accounting, and Managerial Information Systems. The system is divided into 7 main Modules – Long Term Loans (LT), Medium Term Loans (MT), Short Term Loans (ST), Cash Credit Loans (CC), Financial Accounting System (FAS), Managerial Information System (MIS), and Establishment Module. This system provides the basic online operations and MIS information needed for the smooth operation of District Co-Operative Central Banks (DCCB) and many more Branch Offices under the DCCB’s.
Long Term Loans involves the disbursement of long-term loans to borrowers and to Primary Agricultural Co-operative Societies (PACS). Sending Advices to the Financial Accounting system. It maintains of share capital of borrowers. It maintains details regarding borrowers and their loans, right from application to disbursement. The module involves in recovering the amount disbursed to borrowers by raising the demands as and when due. It takes care of collections and advances received from borrowers. It mainly deals with remittance part of loans.

Responsibilities:

  • Designed the Interface of the Loans System with other modules at Branch Office Level.
  • Finalized the table scripts of Long term, Medium term and Financial Accounting System
  • Developed the entire Recovery part of banking and loaning system of Long term module
  • Integrated the Long Term Loans Module with Financial Accounting System.
  • Developed various MIS Reports using Crystal Reports.
  • Involved in the testing of long Term Loans, Medium Term Loans, and Financial System.
  • Involved in the Integrated Testing of the Project.

Environment : Windows 98, Visual Basic 5.0, and Oracle 7.3.

Hire Now