Niraj t8i026@r.postjobfree.com

Developer: Oracle / Business Objects/ Crystal Reports/ Xcelsius

SUMMARY.

 Around 10 years of IT experience in software analysis, design and development for various software applications in client-server environment including 4 years of Experience in Business Objects XI3.1/XIR2/XIR1/6.5/5.1 (Designer, Info view, DeskI/WebI, Business Objects Reporting, Broadcast Agent/ Scheduler, CMC, CCM, and Crystal Reports, Xcelsius).

 Over 5+ years of Strong work experience in Oracle Database (10g/9i/8i/8.0/7.3). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export

 Over 2 years of experience in working with Data warehouse using ETL tools and Strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-Dimensional Models for query and analysis.

 Proven track record of successful implementation of Full Lifecycle (Requirement gathering through implementation and enhancement) of Business Objects reporting.

 Extensive experience in building and managing Universes, creating Complex, Ad-hoc Reports and/ or Charts using Business Objects.

 Expertise in using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports.

 Proficiency in Scheduling, Publishing and Distribution of Business Objects reports using Broadcast Agent server/ Scheduler.

 Experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository.

 Experience in providing Administrative Support for Business Objects products including monitoring of WebI and Broadcast Agent servers.

 Managing internal database, from planning and testing stages through implementation and support.

 Extensively worked Oracle supplied Packages, Stored Procedures, Triggers and Functions.

 Experience in creating Analytics and Dashboard using Xcelsius 2008.

 Skilled in designing, analysis, programming, testing, debugging and implementing complete life cycle client servers and database applications with various development and languages.

 Experience in working with UNIX Shell Scripting particularly in C- Shell, K-Shell and Broune Shell.

 Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.

 Superior communication, presentation, analytical and problem solving skill. Worked well with all levels of business.

TECHNICAL SKILLS AND CERTIFICATION.

Tools Business Objects (Xi3.1/Xir2/Xir1/6.5/5.1), Designer, Deski/Webi, CMC, CCM, Supervisor, Crystal Reports, Xcelsius, Informatica.

Internet Technologies: Web Intelligence, Info view, Broadcast Agent, Scheduler.

B.O. Functionalities Master/Detail, Slice and Dice, Drill up/down, Conditions, Filters, Charts, Alerts, LOV, Context, Aliases, Universes, Reports, UDO, @Functions, Formulas, Scheduling, Cross tab, Joins.

Database Oracle10g/ 9i/ 8i, MS SQL Server 2000/2005, DB2,MS Access

Languages COBOL, SQL, PLSQL, UNIX Shell scripting.

Operating Systems Windows 95/98/2000/XP/NT, MS DOS and Unix.

Utilities MS Word, MS Excel, MS PowerPoint, MS Front Page

Certification. Oracle 9i Database Administrator Associate(OCA)

Programming in COBOL (CMC India Limited)

Data Warehousing Informatica PowerCenter 7.1/6.2/6.1/5.2/5.1/4.7(Source Analyzer, Data Warehouse designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica PowerMart 6.2/6.1/5.2/5.1/4.7, Informatica PowerAnalyzer, Data cleansing, Data Profiling, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader

Data Modeling Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin 4.0/3.5.2/3.x, Oracle Designer, PL/SQL, Developer 5.1.4

PROFESSIONAL EXPERIENCE:

Office Depot. Boca Raton, FL Sep.05 to Mar.09.

Developer: Oracle / Business Objects.

Office Depot is one of the leading Office supplies in United States. It provides variety of Office supplies products including furniture and technology items. The project involved designing and maintaining of universe, generating webi/ deski reports and scheduling the reports. The project provided users with the ability to make intelligent business decisions, so as to assist in comprehending and predicting the organization growth based on the available historical data. Various reports were developed to analyze consumer behavior of customers.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.

• Created several Universes using Designer according to the Requirement.

• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.

• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).

• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.

• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.

• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

• Exported the universe to the Repository to make resources available to the users.

• Scheduled the universes on daily wise, monthly wise and weekly by using Scheduler in B.O.XI R2.

• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.

• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins

• Documented all the changes made to the Universes and Reports for future references.

• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

• Trained end users to use various functionalities of Business Objects and provided technical support.

• Created different types of reports such as Master/detail, Cross Tab and Charts.

• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.

• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.

• Used Alerts to draw attention to a particular block of data by highlighting it.

• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.

• Used multi dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.

• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Generated several Templates in both DeskI/WebI.

• Generated complex reports like Inventory, Buyers, Excess Materials, Products sales, revenues, regions wise demand and exported them to the corporate repository.

• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.

• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.

• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.

• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using xcelsius 2008.

• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using xcelsius 2008.

• Used Xcelsius for presenting dashboards to End users.

• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.

• Migrated Business Objects 6.5 content (users/user groups, Universes, reports) in to Business Objects XI R2 environment using the Import Wizard.

• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

• Understand the business needs and implement the same into a functional database design.

• Worked closely with business analysts to understand the business needs for decision support data

• Worked on source Analyzer, Designer, Mapping and Mapplet Designer and Transformations.

• Used Transformations like Router, Sequence Generator, Expression and Filter Transformations in Mappings.

• Used Joiner, Aggregator, Expression Update Strategy and Lookup Transformation to manipulate data related to Customers.

• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.

• Imported various heterogeneous and homogenous sources using Informatica PowerCenter6.2 Source Analyzer

• Designed and developed mappings using the features of Informatica PowerCenter and executed sessions using Workflow Manager

• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations

• 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

• Developed sq/plsql queries for data manipulation and report generation.

Environment: Business Objects XI3.1/XIR2/XIR1 (DeskI, WebI), Import Wizard, Publishing Wizard, Repository Migration Wizard, Xcelcius, Crystal Reports XI, Xcelsius 2008, Informatica PowerCenter 7.1/6.2, Oracle 10g/9i, Sybase, SQL server 2005.

Providian Financials, San Francisco, CA Jan’05 – May’05.

Business Objects Consultant.

The Group's principal activity is to provide credit card and deposit products throughout the United States. Providian Group markets consumer loans and deposits using distribution channels such as mail, telephone, and the Internet. The present project included development and deployment of a Business Intelligence System for Global E-commerce division. Business Objects was used to support the middle management and executives for their planning activities.

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.

• Created Universes by defining connections and retrieving data from database.

• Used Built-in and External strategies for creating components of a universe.

• Created Aliases and Contexts for solving the Join Problems in Business Objects.

• Created New Classes and User Objects in designing the universes.

• Exported the universes to the Repository to make resources available to the users.

• Generated various reports on Daily, Weekly, Monthly and Yearly basis.

• Created and modified the WEBi Reports for various financial groups using the Universe as a main data provider.

• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources

• Created Charts to display summary data using universe as main data provider.

• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.

• Planned, coordinated and executed Business Objects Deployment for end-users.

• Published reports using Info View, and trained users for ad-hoc reporting.

• Examined and transformed the business logic behind the existing Crystal Reports into Business Objects environment.

Environment: Business Objects 6.1/ 5.1 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), MS Access, Oracle 9i, Sybase, SQL, PL/SQL and Windows 2000.

Life Insurance Corporation of India. Ahmedabad, INDIA

Programmer Analyst. May.2001 to June 2004.

 Created Oracle 9i database for Pension and Group department from planning and testing through production.

 Designed and created Database objects, tables, Indices, Views, Procedures, Packages and Triggers.

 Wrote several stored procedures for recycling and other accounting extraction purposes.

 Fine-tuned PL/SQL Procedures for better performance. Fine-tuned the stored procedures, queries by changing the join orders and giving all combinations of joins and fixed them with the help of explain facility tools

 Gathered User requirements from end users. Performed Business Analysis and developed detail requirements in the areas of financial instruments, Asset management for corporations, public funds, asset management for corporations and foundations.

 Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.

 Translated requirements into business rules & made recommendations for innovative IT solutions.

 Plan, design, and implement application database code object, such as stored procedures and view.

 Build and maintain SQL script, indexes, and complex queries for data analysis and extraction.

 Created Sessions and batch management and Performance Tuning and initial testing followed by the volume testing Resolve technical issues with software consultants and vendors.

 Developed ad-hoc reports for New Business pertain to branch, Dev officers, Agents, maturity claim, Death claim, Loans, lapse policies.

 Work with department managers, application developers, and production team and across functional units to identify business needs and discuss solution options.

 Created users, allocated privileges and Roles, Set up Daily, weekly & Monthly back up.

 Implemented backup and recovery procedures of database in UNIX environment.

 Developed sq/plsql queries for data manipulation and report generation.

 Executed daily operation of pension and insurance programs.

 Worked as part of project team to coordinate database development and determine project scope and limitations.

 Specified users and user access for each segment of database.

 Developed and implemented COBOL programs for departments like new business, Policy servicing, Claims, Sales and marketing, CRM and DATA Processing.

 Tested and designed software packages and worked with software designers to establish a user-friendly environment.

 Successfully managed the whole switching process of operating system from UNIX to LINUX in all 30 different locations.

 Conducted 100 training sessions for end users of different modules like new Business, policy servicing, Legal & Mortgage, Finance & Account, I.T and Claims.

 Managed flow and prioritization of daily/weekly bug fixes and product enhancement.

Life Insurance Corporation of India. Gandhinagar, INDIA

Programmer. June1995 to April 2001.

 Developed a program in MF COBOL for maturity intimation to customer / Agents/ Broker, weekly / monthly status report for death / Maturity Claims.

 Generating reports for management using oracle sql for Pension & Group Scheme.

 Design, tested and implemented a database system of Front End Operation(FEO) which include Cash, New business, Sales & Marketing, Policy servicing, Finance & Account and Claim Modules in Divisional Office and different 30 locations.

 Implemented Wide Area Network (WAN) in 25 different locations for premium paying facility and insurance policy related services.

 Developed menu driven system for operators to perform Data creation, Data Manipulation and printing related task. The application is developed with bourn Shell on UNIX environment.

 Written communication including many user manuals and guides.

EDUCATION.

 Bachelor of Arts with Major Economics, Statistical Methods.

Gujarat University, India.

 Bachelor of Law with major Taxation.

Gujarat University, India.

PROFESSIONAL DEVELOPMENT.

Insurance Academy, Pune, INDIA

 Management Development Program.

 Middle level executive.

Reference available on request.

Contact this candidate