Experience in Years: 10 years

Role: Senior Business Objects Consultant

Languages/Tools:

• Business Objects XI R 3.1/XI R2 / 6.x / 5.x, BO supervisor, BO designer, BO User, Web Intelligence 6.x, WebI SDK, ZABO, BCA, BCA Publisher, Auditor
• PL/SQL, Oracle JDeveloper, Java 2.0, J2EE, Crystal Report, Ejb, jsp, javascript,Unix Shell Scripts

Operating Systems

• Windows XP/2000
• Solaris 2.8(Unix)

Application Servers

• Apache/Tomcat 4.1.2, Web Logic 6.1, Websphere, , JRUN

ETL:

Informatica 5.x/7.x/8.x

Databases:

• MS-Access, Oracle 8i, Oracle 9i
• SQL Server 2000/7.x

• Confidential

• Over Ten Years of IT experience in Analysis, design, development, test and implementing Data Warehouse, Business Intelligence and Client Server applications.
• Highly proficient at creating Business Object universes using Business Objects Designer Module.
• Experience in creating Customized, Ad hoc and canned complex reports using Business Objects.
• Experience in Customizing the Full Client Interface using BO SDK and Thin Client Interface using WEBI SDK.
• Expertise in Installing Desktop and Enterprise Server Products of Business Objects in Single and Distributed Environments on Windows and Sun Solaris Platforms.
• Experience in Installation and Deployment of Business Objects 5i and Migration from Business Objects 5.1.6 to Business Objects 6.x
• Experienced in developing applications using Oracle 9i/8i/7.x, MS Access.
• Experience in working with different RDBMS like Oracle 8i/9i, Sybase, and SQL Server7.
• Involved in production support and tested the reports.
• Proficiently developed use-cases and project documentation (user guides, standard report instructions, demos)
• Excellent Analytical, problem solving, oral communication and team Lead skills, willing to work in both independent and team environment.

Detailed Profile

Period from: Feb'2007
To: Present
Present Client: Confidential
Project: Confidential
Role: Sr. Business Objects Developer/Administrator

Description:
Currently working on multiple projects as a Sr. Business Objects Developer/Administrator for entire Capital Markets/Home Finance group and also production support as well. Please see the below achievements at Chase:

2009:

• Working on WaMu LLDM/SMART Integration Project and need to migrate all BO reports and universe from WaMu server to Chase server. Expecting to go live in 4th Quarter.
• Working on WaMu LLDM/CMDM Data Mart Integration project, developed ETL Mappings in informatica – Development in progress and expected to go live in 3rd quarter
• Worked on Asset Liability universe and also built accounting cash flow reports for SOP/Accounting group users and successfully implmented in production.
• Worked on Voyager Prime project and Succesfully implemented on July 1st 09
• Worked on IDRL project (Intra Day Rate Lock) and built Business Objects reports and successfully promoted to production.
• Worked on Alphanumeric Branch project, did impact analysis to identify the reports that were impacted and did enhancements to the reports and implemented in production.

2008:

• Worked on CLAS Phase 2 Project and brand new reports were developed for Risk group- Successfully went to production.
• Worked on brand new Repurchase Universe for RATS and implemented in production.
• Worked on RATS project (Repurchase Analysis Tracking System take down/RATS retirement reports originally built in actuate) and implemented in production.
• Worked on voyager sub-prime project and built brand new reports and successfully promoted to production.
• Worked on Asset Management system (AMS) and built few new reports to structured Finance group and went to production successfully.
• Built customized API using Java SDK.
• Integrated BO XI R2 with other SMART portals using Trusted Authentication functionality.
• Externally invoked business objects reports in Asset management System web application.
• Created Dashboards and Scorecards using Crystal Xcelsius 2008.
• Exported coding of dashboards using Crystal Xcelsius for complex user requirement.

2007:

• Built LOAN universe from scratch and successfully went to production
• Built Trade Management System universe and successfully implemented into production
• Worked on CLAS Phase 1 Project and brand new reports were developed for (CLAS Take down/Legacy retirement)- Successfully went to production.
• Worked on Non- Prime project and built brand new reports and went to production successfully
• Worked on Non-Prime Margins project and built brand new reports and went to production successfully
• Worked on Structured Finance project and helped to integrate to setup Trusted Authentication for BO.
• Worked on SMART Legacy reports take down (originally built in Actuate) converted all reports to BO and went to production successfully.

Administrator Responsibilities:

• As BO Admin needs to monitor all scheduled daily, weekly and monthly jobs.
• Trade Management System - Production Support
• As BO Administrator responsible in creating users and creating security profile access to the business groups.
• Addressing all BAU request & production issues for Trade Management System/AMS/RI$$K/SOP etc…
• Provided BO user training.
• Extensive experience in CMC.

Technology Used: Business Objects XI R3.1/R2, Universe Designer, Informatica 8.6.1, Web Intelligence XI, Java SDK, BO SDK, Oracle 10i, SQL Server, Sun Solaris and Windows 2000

Period from: Oct' 2005
To: Feb '07
Client: Confidential
Project: Promotion Evaluation and Professional Sales.
Role: Sr. Business Objects Administrator/Developer

Description:
This project is to design the Promotional Evaluation for POS group and Professional Sales for PDW groups at Confidential using Business Objects 6.5/XI reporting system. As a developer involved in building Universes for POS and PDW groups. Builded queries for Price trending, Promotional ROI, Latest 52 weeks price trending and Zero scan reports and charts for POS groups and these reports will show past 16 weeks data from the date selected by user except latest 52 weeks report. The Zero scan report will run at on demand depending on the user selection criteria either for promotional period or past 16 weeks from the selected date. And also build Calls, Samples, details, AWR and Brand Share, Bonus Year to Date AWR Performance, AWR and Brand Share, Trend Analysis, BYTD AWR LNL Received, Average frequency for dentists and LNL Analysis reports and charts for PDW groups. All these reports have published into web portal and few of them are schedule on weekly basis.

• Involved in Ongoing maintenance of developed applications, and handling the change requests. Developed design and Hierarchy Building for Data Analysis and apply conditions in Objects. Resolved reporting issues as well as data issues
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks
• Installed and tested Business objects 6.5 with Oracle as the standard database.
• Involved in creating complicated Queries, Document Centricity, Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts, and Formatting Presentation Styles
• Multilevel hierarchies are set up enabling the drill down functionality
• Row level security is implemented in the supervisor to restrict the data to the respective Business Units
• Developed Interface screens to capture user selections and generate the conditions and passes to the respective report. The Interface report saves the selections and can be retrieved upon next execution.
• The Report is enabling to save in PDF and Excel retaining the format and allowing the user to select the mode, to save in single file or Split the file to multiple files based on the group in the report. Create Template reports, which can be dynamically changed, based on the selection of the Objects to be used in the report.
• Reports are generated by Dynamically Linking the Universes.
• The users are given the flexibility to select any template, Objects, Conditions and Options from the VBA input Form. Created Web based reports using Web Intelligence and Scheduling and timely refresh of documents through Broadcast agent Server
• Involved in Training the Users in using this robust system.
• Customized few reports using JSP and ASP
• The result reports are categorized and placed under dynamically created folders.

Technology Used: Business Objects 6.5/XI, Informatica 6.2, BCA Publisher, Auditor, Web Intelligence 6.x, Webi SDK, BO SDK, Oracle 10i, Sun Solaris and Windows 2000.

Period from: Aug 2003
To: Sep' 2005
Client: Confidential, PA
Project: Telephony Revenue Assurance for ICOMS and VOIP
Role: Sr. Business Objects Consultant

This project is to design to develop Business Objects reporting system and dashboard for Revenue Assurance at Comcast. As a Business Objects developer created Universes and full client reports using Business Objects. Created ICOMS queries to retrieve data for reports from SQL Server. Most of the reports have drill down functionality from Top to bottom (Summary level to Transaction level like ICOMS Revenue summary for Fiscal/Calendar month. Some of the reports have integrated into dashboard for user-friendly purpose. ICOMS as different market name and bill cycle. The user can select market name and bill cycle according to that result will be shown in dashboard. Some report scheduled weekly, nightly and monthly using Broadcast server.

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Developed Alpha reports which were solely for those working in the hedge fund industry and focuses solely on those people and the sector they work in.
• Developed premium reports for various industries like ICOMS Usage reports, Adjustment reports, MRC reports, One-Time charge reports, Pro-Rate Reports, and Taxes & surcharges reports.
• Involved in creating the ranking criteria for the top CEO and CFO for various firms by sector and location.
• Created standard Business Objects templates to be used for various surveys, which help project managers to take effective decisions in choosing the breakouts for revenue and regions.
• Each type of reports contains 3 to 4 levels drill down functionality like Adjustment Summary - Adjustment code Analysis – Adjustment detail reports.
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks
• Installed and tested Business objects 6.5 with SQL server as the standard database.
• Created Repository for Business objects development and distributed Domains
• Involved in Ongoing maintenance of developed applications, and handling the change requests.
• Developed design and Hierarchy Building for Data Analysis and apply conditions in Objects.
• Resolved reporting issues as well as data issues
• Involved in creating complicated Queries, Document Centricity, Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts, and Formatting Presentation Styles (Graphical).
• Created Web based reports using Web Intelligence and Scheduling and timely refresh of documents through Broadcast agent
• Providing user support and training in using Report Designer for creating Adhoc reports.

Technology Used: Business Objects 5.x / 6.5, Business Objects Designer, BCA Publisher, Auditor, Web Intelligence 6.x, SQL scripts, SQL Server, IIS, Sun Solaris and Windows 2000.

This project is to design to develop Business Objects reporting system for Credit Policy department in Confidential. This reporting was done from scratch planning, analysis, designing and conducting meetings with users and taking specification from them and analyzing the reporting fields in data marts. We have 4 data marts 1. Summary MI monthly, Summary MI Cert Risk, Summary MI Historical, and Summary MI current details. Using these four data marts created 4 Universes according to end users needs. There are 27 reports in credit policy out of those 10 reports are complex reports. For ex monthly summary reports contains Current month, previous month, Prior Quarter, Year to Date and Ever to Date data into one report.

• Performing an initial study on the reporting needs by meeting the Finance Users.
• Analyze the reporting requirements with the business users and come up with the technical specifications. This includes the documents for getting the data from the SAP and also the technical specifications for the Business Objects Reports
• Generating the Standards and templates for the reports, interfaces and the universes.
• Involved in analyzing the source data coming from the different sources such as SAP, flat files and other systems along with business users.
• Involved in creating the Credit Policy Universes
• Involved in identifying the scanned reports for each of the universes and creating the specifications for the same.
• Involved in creating the business critical reports for Credit Policy users
• Creating, maintaining and modifying the business critical reports using the Business Objects Reporting Module.
• Constructed simple to complex reports which involved the usage of sub queries and correlated sub queries in conjunction with @ functions and functions that would generate complex calculations, as well as format the report.
• Created multi master-detailed reports together with the usage of slice-and-dice and drill modes for multi-dimensional analysis of the data retrieved.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during implementation.
• Resolved most of the issues within universes that had loops embedded among the tables using aliases and contexts.

Technology Used: Business Objects 5.x/ 6.1, Business Objects Designer, BCA Publisher, Auditor, Web Intelligence 2.x, PL/SQL, TOAD, Oracle 8i, Apache 2.1, TOMCAT 4.1, Windows 2000, HP Unix

Period from: Oct 02
To: Jan '03
Client: Confidential, TX
Project: Mailing Rebates Processing
Role: Business Objects Developer

This project is to design & setup Business Objects to develop Complex reports and for mailing rebate processing in Confidential. As a lead planning, analysis, designing, implementing and maintaining of Business Objects server. This involves designing and implementing Business Objects, Web Intelligence Server, BCA and ZABO on Sun Solaris as Cluster manager. Through BCA schedule jobs nightly, weekly and monthly basis to Web Intelligence. Few reports are schedule on report busting.

Responsibilities

• Identified the requirement specifications by meeting with the end users and analyzing their current reporting environment.
• Reports were formatted to the users according to the user requirements using slice and dice, drill down, @function and formulas etc.
• Created master detail and cross tab reports to view the data in an analyzed way.
• Interacted with end users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used alerter and filters in the reports.
• Designed and developed extensive business objects reports using multiple queries, combination of charts and tables.
• Created queries to extract data from oracle database for multidimensional analysis using slice and dice and drill up/down functionality.
• Created and published reports through infoview.
• Used free hand SQL for creating complex reports, which were not possible to produce using available universes.
• Exported business object reports to WEBI 2.7.2 to be viewed by all users on the internet.
• Created reports involving multiple Data providers extensively.
• Documented the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
• Providing user support and training in using Report Designer for creating Adhoc reports.

Technology Used: Business Objects 5.1.6, Web Intelligence 2.7.2, WEBI SDK, and Oracle 9i, DB2, PL/SQL, Apache/Tomcat 4.0, Windows 2000, and Sun Solaris 2.8

Period from: Feb. '01
To: Oct. '02
Client: Confidential, Irvine, Texas
Project: EIS Reporting Management for Business Objects
Role: Business Objects Developer

The main objective of the project is to build an Executive Information System (EIS). The EIS would cover the Subject Areas such as Sales and Finance. The project is to build data marts and develop reports covering the key measures relating to the above mentioned subject areas and publish them on the company's Intranet. The Top Management using browser will access the reports.

Responsibilities:

• Used Informatica to design, code and test data extraction from multiple databases Oracle and SQL Server and loaded it in target database Oracle.
• Involved in the development of mappings. Most of the transformations were used like Source Qualifier, Aggregators, connected and unconnected Lookups, Filters and Sequence Generator.
• Developed BO Universes using Designer and Business Objects for the reporting solution for reporting System.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created multi-dimensional reports and ad-hoc reports.
• Created reports in cross tab, master detail format and transformed them in 2-D, 3-D Column, Line, Area, 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 in Web Intelligence.
• Designed and developed mappings for REMEDY data mart using Informatica Power Center
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, look up, Sequence Generator, Router, Sorter and Stored Procedures.
• Worked on creating reports using REMEDY systems.
• Design, development, implementation, and maintenance of systems, reports and databases Scripts to schedule reports at proper intervals.
• Security module that restricts access to company's data to the individuals allowed.
• Writing Stored Procedures in SQL to be used in the reports.

Environment: Business Objects Designer 5.1.4, Supervisor, Reporter, Info View, Web Intelligence 2.6, Crystal reports 9,Oracle 8.1.2, SQL Server ,UNIX, Windows NT

Period from: March '00
To: Jan. '01
Client: Confidential, CT
Project: Customer Information Environment
Role: Business Objects Developer

Confidential is employing several systems to initiate, originate, Service and report on their lending activities. Is involved in two of the major phases: entry of the customers and deals, and servicing the deals. Output from DLS-E will feed into several "reporting" systems.

Responsibilities:

• Data Modeling and development of the reporting database in Oracle.
• Setting up the security for creating user groups and assigning Privileges.
• Modification of the universe by adding the objects.
• Involvement in resolving table linking problems like \'Chasm Trap\' and \'Fan Trap.
• Creation of many contexts to resolve the loops.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Created Reports from GL and Fixed Asset Universe: Account Analysis, Journal Entry Enquiry, General Ledger, Account Analysis with Payable Details, Asset retirement by SBU
• Created reports from AP Universe: Expense Distribution Detail Report, Vendor Paid Invoice History, and Payables Approval
• Created universe and reports for Equity reporting about the Bid price and Ask price, transaction close periods and periodical statements
• Creation of VBA Macros and Add-Inns using BO Object Model in order to customize the reports as per the user requests.
• Design and documentation of the validation rules, error handling, and test strategy of the mappings.

Environment: Oracle 8i, Business Objects 5.1/4.1, Web Intelligence 2.5.

Period from: July 98
To: Feb 00
Client: Confidential, NY
Project: CIG Reporting
Role: Objects/Crystal Reports Developer

The goal of Confidential is to provide USP products with the best positioning possible in the pharmaceutical marketplace consistent with USP product revenue and operating profit goals.

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.
• Created simple, master-detail, sub reports using Crystal reports 9.
• Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing
• Performed Server administrative tasks, including Manage Services - Starting - Stopping Server Services, Publishing, Migrating, Importing etc.
• Designed workflow and dataflow to load the fact table using the source and dimension tables.
• Wrote script to initialize global variable used in the dimension and fact tables.
• Part of report development created reports by extensively using multiple data provider's @functions and inner query concepts to generate full client reports.
• As a part of Universe development, created Classes, different kinds of objects, cardinalities, Strategies, resolving loops using Aliases and Contexts.
• Migrated universes and reports to PROD and DEV environments from BO 6x to BOXIR2 version to their respective folders using Repository Migration Wizard.
• Responsible for User Support and Training for Full Client and Webi and resolving Trouble Tickets/Cases reported by user.

Environment: Oracle 9i, BO 6.5/6.1.b, DB2, Windows XP Pro/2003 Server, Performance management, Web Intelligence 6.5,Crystal reports 9 and Apache TOMCAT 4.1/5.0.27