Profile

• Over 5 years of IT Experience
• Over 5 years of BI Business Objects Experience
• 2 years of Data Integration Experience
• 5 years of Database Experience

Summary

• SDLC: 5 years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies
• Business Intelligence: 5years of Business Intelligence experience with complete life cycle Implementations using Business Objects XIR3.1/XIR3/XIR2/6.5/6.1/6.0/5.1 (CMC, Supervisor, Designer, Infoview, Business Objects Reporting, Business Objects SDK, Xcelsius, Web-Intelligence 6.0/2.7/2.6/2.5, Web-I SDK, Desktop Intelligence, Broadcast Agent, Publisher, BO Set Analyzer, Data Integrator, Application Foundation 6.0/2.5 & Dashboard Manager)
• Business Objects: 5 years of Extensive experience in Business Objects full client & thin client environment. Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Used Stored Procedure Data Provider for frequently running tasks. Trained Users in report development and running ad-hoc queries in business objects. Tested business objects reports for data validation and compared results with TOAD. Set up Broad Cast Agent and Configured the Broad Cast Agent.
• Experience in Creating, Testing and Executing Data Integrator jobs using Data Integrator Designerto transfer data from source to target.
• Data Warehousing: 2 years of experience in Data Warehousing using Informatica ETL, Informatica Power Mart/Center 6.2/5.1/4.7/1.7, Informatica Power Connect, FACT Tables, Dimension Tables, Star Schema Modeling, OLTP, OLAP, MS SQL Server 2005, MS Access 2000/97, Erwin 4/3.x, Windows NT/2000, Windows 2000/98/95.
• Databases: 5 years of solid database experience in Oracle 10g/9i/8i/8.0/7.x, Teradata V2R5/V2R4, DB2 8.0/7.0/6.0, MS SQL Server 2000/7.0, (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL.

Education & Certifications

• Bachelors in Electrical and Electronics
• Certified in BI concepts

Technical Skills

Business Intelligence

Business Objects XI R2/XI/6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business Objects Reporting Business Objects SDK, Web-Intelligence 6.0/2.7/2.6/2.5, Data Integrator XI, Xcelsius, Web-I SDK, Broadcast Agent, Publisher, Designer, Supervisor, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Application Foundation 6.0/2.5 & Dashboard Manager), Informatica Data Analyzer (PA 8) & PowerAnalyzer 5.X/4.X

Business Analysis

Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

Informatica Power Center 8.1/8.0/7.1.2, Power Mart 6.2/5.1.1, Workflow Manager, Work flow Monitor, ETL, ETI, Datamart, OLAP, OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader

Databases

Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming

Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++

Environment

Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

Professional Experience:

CONFIDENTIAL, Nashville,TN Jul’09 – Still Working. Business Objects Developer

CONFIDENTIAL is one of the largest health care companies in the United States, delivering its products and services all over the United states and other countries.Data model was created for the development of interactive Dashboards and BO reporting is used for testing the dashboards and warehouses were developed using the ETL Tool and Teradata TPUMP. Project deals with modifying existing data mart, Designing Universe, canned reports and adhoc purpose
Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 Webi and DeskI tools
• Troubleshooting BO XI installation and migration issues.
• Performance tuned Business Objects Data Integrator XI jobs to ensure optimal performance.
• Extensively used Data Integrator to cleanse and populate target database.
• Used Unix Commands and Scripts for running ETL workflows and jobs.
• Creation of reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using WEBI, DESKI, full client.
• Developed more than 25 Full client and thin client (WebI) reports for all modules and update to version 6. Exporting universe to the repositories to make resources available to the users.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Scheduled and monitored reports using BOSS.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Deployed the development and QA domains to reduce the server loads and to increase the performance.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting

Environment: Business Objects XIR3.1/XIR2, Informatica Power Center 8.1/8.0,Arc Plan Dashboard tool, Xcelsius, Web Intelligence, Desktop Intelligence, Windows 2000/NT, Teradata 12.0, SQL Server 2005, Oracle 10g, T-SQL scripts, Teradata SQL Assistant 12.0

Confidential, CA. Sep’08 – Jan’09.
Sr.Business Objects Developer/Admin

Responsibilities:

• Requirements Gathering and Business analysis
• Familiarized the business, its strategy and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Migrated reports from BO 6.5 to BO XI2.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Created Sets, Metrics, Rules, using Set Analyzer and Dashboard Manager.
• Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers.
• Designed and developed Data Integrator (DI) XI scripts for data transformation.
• Experience in cleansing data in DI using proper data types and mappings and to create Workflows using object library and tool palette to execute data flows.
• Linked two universes sales and customer using kernel approach.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Exported the Business Objects reports to Web I to be viewed by all users on the Intranet using Web I; SDK with JSP plug-in.
• Created reports using WEBI, DESKI, full client.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Knowledge of Crystal Reports reporting system including Crystal Server reports distribution infrastructure.
• Experience with Crystal Xcelsius dynamic data presentation software.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created Users and user groups and given rights to them.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Extensively trained users on Business Objects suite
• Designed Functional Specification for report creation.
• Analyzed the warehouse tables, to design Universes by creating Classes and Objects.
• Conducted Performance tuning of Universes for time management purpose by creating Aggregate tables, alternate views and indexes.
• Created Universe Design Document (UDD) and Report Validation Documents (RVD) to define the scope of the Universe design and Report creation.
• Created and duplicated reports which already exist in internal Genentech’s Applications.
• Developed around 50 Webi Reports.
• Extensively created hyperlinked reports with more than two levels.
• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Cascading Prompts, @Functions, Cross Tabs, Master/Detail, Slice and Dice, Drill Down, and Formulas.
• Created Tables, Forms, 3D bar charts, Stacked Area charts, Pie charts and 3D surface charts using WEBI.
• Created multiple catalogs and resolved loops by creating table aliases and contexts. 
  Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts
• Worked on Import Wizard to move from DEV to TST environments.
• Responsible for writing SQL queries.
• Comprehensively Unit Tested and Documented the results for each report.
• Responsible for Reports and Universe Design Specifications.
• Developed reports in Crystal Reports where highly complex SQL was used with calculations.
• Written Stored Procedures to be applied as a command (SQL Code) to run the crystal reports, involving calculations based on the reporting requirements
• Administered Crystal Reports (along with their copies in different folders) in CMC and scheduled them as required by the user wherever required.
• Worked extensively on Star and Snowflakes Schemas.

Environment: Business Objects XIR2, Informatica Power Center 8.1/8.0, Web Intelligence, Desktop Intelligence, Windows 2000/NT, Unix Shell Scripting, SQL Server 2005, Oracle 10g, Crystal Reports XI, TOAD, SQL Server Management Studio.

Confidential., Indianapolis Sep’07 – Aug’08
Business Objects Developer/Admin

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects
• Worked on Master and Component approach during the linking of universes.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Experience in universe migration across repositories
• Set up Universe level conditions to restrict data based on report requirements.
• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Desktop Intelligence(DESKI)
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Migrated reports from Development/Testing environment to Production Environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures.
• Created dynamic LOV’s based on report requirements.
• Worked extensively on Sybase.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Coordinating with DBA and general supervisor for resolving technical issues
• Upgraded Business Objects Universes, Users and user groups, and reports from Version 6x to Version XIR1 using the Import Wizard.
• Administered Business Objects suite using CMC.

Environment: Business Objects XIR2/6.x, Performance Management, Business Objects Designer, Web Intelligence, Desktop Intelligence, Broadcast Agent, Sybase, Windows 2000 Server.

Confidential, New York Feb\'06 – Jun’07 
Business Objects Developer/Admin
Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Designed, developed and maintained Universes for supporting Adhoc and canned reports.
• Coordinated with ETL, Data warehouse team to implement the Star Schema modeling.
• Created various classes and objects in the Universe.
• Created user objects to enhance the reporting needs.
• Measure objects and User objects were created keeping in view of the end-user requirement.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Created Context, Alias to resolve the Loops in the universe.
• Modifying the existing universes, Adding new objects editing joins mapping the existing objects with renamed tables.
• Creating new Connections and editing existing to run the report in different database test, development.
• Created the Derived and Aggregate Tables.
• Resolved the fan and chasm traps.
• Detected cardinalities and checked the Integrity of Universes.
• Created variables, @prompt (Interactive objects), formulas and etc.
• Created the stores procedures and functions at the back end.
• Fine-tune the existing universes to enhance their performance.
• Exported the universes to the Repository making resources available to the users.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.

Environment: Business Objects 6.0, Oracle9i, PL/SQL, WebI, DESKI, Broadcast Agent & Windows 2000.

Confidential, NY April’04– Dec’05
Business Object Developer/Admin

Responsibilities:

• Installed and configured hardware for the entire Business Objects suite of products.
• Managed over 400 users and 30 groups in the entire Business Objects suite
• Trouble Shooting In Business Objects Enterprise
• Maintained the whole environment (TEST, DEV and PROD) along with 8 main servers.
• Updated and maintained Universes to meet new reporting requirements
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Clustered Central Management Server (CMS) machines
• Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
• Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch.
• Requirement Collection, Documentation & high-level design.
• Developed Functional (Business terms) and Technical Design documents
• Imported data from Business Objects 6.x & Crystal Enterprise 10 to Business Objects Enterprise XIR1
• Configured BO Server Products like WebI and BCA Publisher & Auditor on different nodes in Distributed Environment
• Implemented procurement applications to cut down the supply management cost.
• Designed architecture & set up for development, production & test repositories
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• Tested Reports and deploy them over web
• Deployed reports to Repository through Broadcast Agent Server
• Scheduled Business Objects Reports using Broad cast Agent and scheduler
• Business Objects Installing the Repository.

Environment: Windows XP, server 2003, Oracle9i, Business Objects 6.0, ,Crystal Enterprise 10, Designer, WebI, Publication Wizard, Broad cast Agent , Import Wizard, Crystal Enterprise, 10.0/9.0, Business Objects 6.5, Reporter, Designer, Supervisor, Business Query, BO SDK, Web Intelligence 2.x/6 and InfoView. Oracle 7.x/8.x/9/10g, MS SQL Server 6.5/7.0/2000,Teradata 

Confidential Aug‘03–Jan’04.
Database/Datawarehouse Developer.

Responsibilities:

• Prepared documentation including requirement specification.
• Designed the Data Mart model with Erwin using Star Schema methodology.
• Installed and configured Power centre Client and Server Tools.
• Creating Dimensions and Facts in the physical data model.
• Documented the metadata to capture from the sources
• Created Sessions and batches to extract the data.
• Involved in the creation of jobs using work flow manager to validate schedule run and monitor the jobs.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Information is stored in table definitions in the repository and is entered using the Repository Manager.
• Used the Power centre Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Assisted warehouse designer while designing the models.
• Wrote Unix Shell Scripts to automate the process.

Environment: Informatica Power center 1.7, Windows NT, Oracle 8i, SQL, PL/SQL, SQL*Loader, Erwin 3.5, SQL Server 7.0, DB2, Erwin 3.5, IBM AIX 4.2