Skill

• Crystal Reports XI Including previous versions
• PL/SQL
• Oracle 11g Database
• Visual Studio Team Foundation Developer's Suite
• Microsoft.NET 3.0
• ASP.Net
• C
• VB.Net
• Business Objects Platform
• Business Intelligence Cloud Base
• Ability to engage with client
• Quality Assurance
• Project Management Skills
• Mobile Technologies

Confidential

Business Objects Designer/Crystal Reports

Responsibilities:

• Worked with the business team to capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes .
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Design and maintain Universe, Developed physical data models and created DDL scripts to create schema and database objects.
• Ability to engage with client and handling client requirements
• Created Objects, Predefined Conditions, Joins in the Universe. Applied aggregate awareness to speed up query time. Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe.
• Worked on Visual studio Team Foundation Developer's Suite
• Developed reports using Business Objects using functionalities like slice and dice, drill down, functions, cross tab, master/detail tables, formulas and etc.
• Developed Microsoft.NET 3.0, Asp.Net, C , VB.Net
• Designed reports with complex variables, multiple breaks, and sorts to meet the user requirements. Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Developed complex Crystal, Web Intelligence and Desktop Intelligence Reports.
• Created complex reports using cascading prompts, decode objects etc. Extensively used breaks and sections for better navigability.
• Knowledge of project management methods.
• Used WebI info view to open and display documents, traverse a category hierarchy, create, rename and delete categories, get the details of a category, add and remove documents to and from a category.
• Efficient in Optimizing, Debuggingandtesting SQL queries, views and Stored procedures written in Oracle and SQL Server.
• Created DeskI documents and published them via Corporate folders.
• Performed user acceptance test UAT for universe, reports and security management.

Environment: Business Objects XI3.2 Suite Designer, Desktop Intelligence, Central Management Server, CMC , Web Intelligence 6i, Crystal Reports XI, Oracle 11g, SQL, TOAD 9.2.

Confidential

Business Objects Designer/Crystal Report Developer/Administrator

Responsibilities:

• Controlled resources like Universes, Documents Stored Procedures being a Supervisor Designer
• Created Users/Groups/Sub-Groups assigned profiles thereby restricting un-authenticated access to resources.
• Created initial Classes Objects, qualification for the Universes in both on/off line modes. Handled Strategies.
• Developed Microsoft.NET 3.0, Asp.Net, C , VB.Net
• Worked on Visual studio Team Foundation Developer's Suite
• Linked Universes to share common objects.
• Handled Embedded Functions like Prompt, Select, and Where in the Designer to handle User requests for report generators.
• Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Ability to engage with client and handling client requirements
• Pulled Data from .LOV Files for objects that generated values based on these files.
• Aided in setting up Multi-Dimensional Analysis, the Slice/Dice Drill using the Hierarchies Editor.
• Created Concatenated Objects using Simple Objects.
• Designed Complex Queries with Wildcards in the Business Objects Reporter for retrieval of financial data.
• Used Free-Hand SQL Data Providers to import Tables not present in the Universe.
• Distributed Data Provider Statistics to obtain feedback for optimization.
• Purged Data Providers not playing pivotal role.
• Formulated Data to appear in Master-Detail, Cross-Tab Reports.
• Published Documents on the World Wide Web for access to authenticated users via Infoview.
• Categorized Documents based on the Departments Users.
• Participated in troubleshooting errors in Published Documents in Infoview.

Environment: .Businessobjects XI3.2 Reporter, Designer, Central Management Console , Web Intelligence XI, WebI SDK, Oracle 11g, PL/SQL, Windows Professional.

Confidential

Crystal Reports / BO Designer

Responsibilities:

• Analyzed which universes and reports have to be modified.
• Involved in the administration of end users. Created new users, user groups, roles and assigning privileges.
• Created monthly and daily basis reports using universe and freehand SQL.
• Designed and developed new universes according to the department requirements and specifications.
• Created Contexts, Aliases to resolve the Loops in the universe.
• Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
• Ability to engage with client and handling client requirements
• Worked with the IT team to bring in the data required into Business Objects Universe.
• Involved in creating Document steps for BO up-gradation process from 5.1 to 6.0
• Test Universe for Functionality Analysis.
• Generated reports for web users using Web Intelligence and Info View.
• Created Web Intelligence documents and published them to corporate documents.
• Plan, Coordinate and execute Business Objects deployment for End users.

Environment: Business objects 3.1, Central Management Console, Designer, Info view, Crystal Reports XI, Oracle 10g. , PL/SQL, SQL Server 2000

Confidential

Business Objects Designer/Crystal ReportDeveloper

Responsibilities:

• Gathering requirements from Business Users.
• Designing and Creating Universe, Classes and Objects for management systems.
• Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
• Worked extensively with select, aggregate aware, where, and prompt to overcome the problems with database when integrating with Business Objects.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Created Report level variables. Used Variable Editor.
• Secured the data by using Report Bursting.
• 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.
• Involved in Design of Star Schema
• Developed data Mappings between multiple source systems and warehouse components
• Used Aggregator, Sequence Generator, Update strategy, Lookup, Stored procedure, Filter and Expression transformations
• Trained end users in the functionality of the software

Environment: Business Objects XI3.1, Web Intelligence 2.6, Broadcast Agent 2.7, Info View, TOAD, Oracle 9g , Windows XP professional.

Confidential

Crystal Reports / SQL Developer

Responsibilities:

• Major responsibilities included gathering requirements from users, designing, developing and maintaining Crystal Reports using SQL Server 2000 as the relational database and Visual Basic 6.0 as the front end.
• Developed Standard, Cross-Tab and Mail Label Crystal Reports.
• Implemented Record Selection, Grouping, Sorting, Summarizing, Formulas and Drill-down features.
• Worked with Subtotaling, Percentages, and Running Totals using Formulas.
• Inserted OLE Objects into Reports.
• Extensively worked on Sub reports.
• Developed various Charts and Graphs like Bar chart, Line graphs, Pie charts, etc. by using Chart Expert in Crystal Reports.
• Designed Optimized Web Report.
• Worked in debugging, design, development, testing and implementation of applications with Visual Basic, ASP, SQL, in a Windows NT environment.

Environment: Crystal Reports 9, Oracle 9i, Visual Basic 6, ASP and Windows XP professional

Confidential

Software Engineer Crystal Reports / SQL Developer

Responsibilities:

• Created reports in Visual Basic 6.0 for various Portfolios using SQL Server 2000 as the main Data Provider.
• Organized data in reports using Filters, Sorting, Ranking, Drill-down and Alerts.
• Incorporated parameter fields into record selection formulas, used Parameter Field Prompts.
• Used SQL Expressions for groups, sorts, and totals and for Case Logic.
• Developed reports with formulas and running totals.
• Created Charts and Cross Tab reports.
• Worked with Sections, Splitting and Resizing Sections used Multiple Sections, hiding Report Section.
• Inserted OLE Objects into Reports.
• Created Main Procedures in Visual Basic, References and Imports Statement, Coding conventions, Conditional Compilation, Inheritance Basics.
• Created Reports from Excel and Access.
• Experience in working with reports where data has been shared across Sub reports.
• Created complex reports using Triggers, Stored Procedures and Views for SQL enhancement.
• Built VB Applications, worked with VB Controls, Functions and Variables.
• Worked with ASP objects using ASP Response, Request, Session, and Server.
• Tested reports thoroughly created by other developers, as per the report specifications.

Environment: Server 2000, PL/SQL, Crystal Reports 9.0, Visual Basic 6.0, ASP.

.