SUMMARY

• Experienced in Development, Administration and Support solutions for Business Objects XI 3.1(R3.1) / XIR2/R1/6.x/5.x,Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Crystal Reports, Crystal Xcelsuis and Query as a Web Service (QaaWS).
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/vista/window 7.
• Good understanding and expertise in setting up of Repository, creating, managing users and user groups. Worked on CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers
• Technical hands-on expertise using OLAP tool Business Objects 6.0 /XIR2/XIR3 (Reports, Designer, Web Intelligence, Info view)
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverables.
• Experience migrating reports from 6.x to XIR2; used migration wizard to migrate repository and its components (Universes, users, privileges) and solved migration wizard bugs related to report formatting.
• Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.
• Proficient knowledge on BO XI Architecture and new features.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Installed, configured and maintained servers in different cluster environments
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging clients need.

TECHNICAL SKILLS

OLAP Tools Business Objects XIR3/XIR2/XIR1/6.X/5.X,Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, and CMC Performance Management, Report Conversion tool and Import Wizard, Toad, Crystal Xcelsius. Understand the key aspects of ETL tools such as informatica, teradata and data stage. RDBMS Oracle8i/9i/10g, informatica, SQL/T-SQL, SAP, Toad,C++, XML, HTML, JavaScript, UNIX/Linux, VBnet, VPN, Microsoft products: Word, Visio, Excel, Access, Microsoft Project and Outlook. Knowledge in operating systems such as (Mac OS, XP, Vista, Window 7) and IP architecture protocols (TCP/IP, DNS, and WINS) and Knowledge of Active directory and windows server 2003/2008. Possess a strong technical background in key aspects of Network related IT infrastructure, including routers, switches, DNS & DHCP services, LAN/WAN circuits.

Statistical/Analytical applications/Modeling software: Rational Rose, Clementine, Crystal reports and SPSS, Erwin, Visio

Education: Degree in Business Technology Management

Professional Experience:

Confidential, Chicago, IL USA June' 2011-June'2012 Sr. Business Objects Developer CONFIDENTIAL is the 7th largest U.S commercial insurer and the 13th largest U.S property & casualty insurer, it provides insurance protection to more than one million businesses and professionals in the U.S. and internationally. CONFIDENTIAL uses SAP Business Objects as a primary reporting tool. This project focuses on upgrading existing BOXI R2 to BOXI R3 SP5 along with the entire component specific to CONFIDENTIAL such as Merlin, InfoBurst, PeopleSoft and OpenDoc links. Responsibilities:

• Actively involved in the project initiation phase with IBM (infrastructure), CONFIDENTIAL managements, Users and other vendors such as TCS, Accenture and Capgemini
• Created numerous documents such as Project Plan, Test Plan, Performance Test Pan, End point Security Test Plan, Business use case inventory, and gathered user requirements by interviewing users and business counter parts
• Actively involved with the project team to create and validate ORR and Development plan.
• Coordinated activities such as Performance test and Hailstorm test with offshore teams and produce finding during the deployment readiness phase
• Validated and fixed Webi and crystal reports, designer, universe connections and user security.
• Responsible for fixing "java codes" in crystal web elements reports
• Updated report inventory in SharePoint per application
• Involved in GUI testing, Functionality Testing, Performance Testing, Integration Testing & User Acceptance Testing (UAT) of Client/Server & Web based applications.
• Track defects and findings in "Team track": responsible for coordination and assigning defects to appropriate members and responsible coordination efforts to closing out the defects in timely manner

Environment: Business Objects XIR3/XIR2(CMC, Designer, web intelligence, import wizard, Report Conversion Tool, Schedule Manager, Info View, Performance Manager, Auditor, Crystal Reports XI), Oracle 10g/9im SQK server 2008/2010, SQL, Windows XP, MS project, VISIO, InfoBurst, WAS6/7 and PeopleSoft. Other tools such as Team Track and SharePoint.

Confidential, Vaughan, ON Canada June' 2010-Apr'2011 Sr. Business Objects Developer Confidential is a leading provider of complete IT solutions to organization such as Banking, Insurance and Health Care. This project involved studying the existing BO Environment, Installation of BO XI R3, identifying and resolving the migration issues; build new Universes and reports and also tuning the existing Reports and implementing best practices using report conversation tool and import wizard. This project involves creation of standard Full Client / WebI reports, involving both Ad-hoc and canned Reports for analysis. Trained active users how to analyze and run reports using WebI Rich Client and info view. Responsibilities:

• Gathered Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Designed and Developed Business Objects universes using Ralph Kimball methodologies
• Maintained Universes and exported them to the CMS repository
• Updated the existing Workforce Universe by adding new Tables, Classes, Objects and creating predefined conditions and prompts for the new reporting requirements.
• Resolved issues like loops, chasm traps and fan traps by creating Contexts and Aliases to remove cyclic dependencies.
• Created Database Objects such as Views, Charts, Functions, Stored Procedures with Respect to the Requirements of Universe and Reports Development
• Created the reports using Web Intelligence, WEBI Rich Client and Live Office according to the user requirements.
• Updated data for crystal Xcelsius visualizations by using export setting commands
• Developed WEBI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL at Report level.
• Applying Row level, Report level & Object level security in the universe to make the sensitive data secure.
• Worked extensively with the various chart formats including stacked bar charts and line charts that
• Used alerter to highlight critical data based on business conditions.
• Used @Functions (@select, @where) to increase the Performance and Reuse the conditions.
• Generated Ad-hoc reports using Freehand SQL and modified the existing reports based on the requirements. Testing and comparing the reports with the standard reports.
• Creation of standard Full Client / WebI reports, involving both Ad-hoc and canned Reports for analysis.
• Exporting the reports in PDF format and sending them to the users Inbox.
• Scheduled and published these reports in Business Objects Enterprise using Info View.
• Configured the Performance Management in Business Objects.

Environment: Business Objects XIR3/6.5(Supervisor, CMC, Designer, Reporter, Desktop /Web intelligence), Import Wizard, Report Conversion Tool, Schedule Manager, Info View, Performance Manager, Auditor, Crystal Reports XI ,Oracle 10g/9i, SQL Server 2005, SQL, PL/SQL, Toad , Crystal Xcelsius 2008,Windows XP.

Confidential East Hanover, NJ Apr' 09-May' 10 Sr. Business Objects Developer Confidential is leader in researches, develops and markets patent-protected prescription drugs for important health needs. The main feature in this project is that the customer can retrieve the quote in six months from the date they enter the quote. The customer chooses the lender with the best combination of rate and service Insurance Policy System allows agents and various departments to enter customer information considering business rules, and then it generates quotes. It also allows end users to generate bills and reminders to customers. Responsibility:

• Converted DeskI reports to WebI reports using Report Conversion Tool resolved the issues face and distributed then to wide range of users for daily analyses.
• Developed test cases to test the reports in positioning of data items, incorrect drills, incorrect date formats, headings, prompts etc. and formatted reports according to specs given.
• Modified Personal Accounts Universe and Webi reports after understanding user requirements.
• Implemented Aggregate Awareness and Hierarchies in the Universe.
• Extensively used Stored Procedures, Functions and Procedures for Complex reports such as Interest Payments, Account Receivable, Adjustments and Financial Reports.
• Created Drill Down Reports, On Demand Sub Reports and Chart reports for business needs and set InfoView to schedule the reports.
• Scheduled reports to run and refresh daily using InfoView and CMC.
• Developed ad-hoc reports for end users.
• Created reports using Business Objects features like Slice and Dice, Drill Down, @Functions, Cross tab etc.
• Formatted the reports as per user requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Scheduled and Monitored Reports in various formats like PDF, Excel and CSV. Wrote documentation for the reports.
• Involved in performance testing of all the reports, which helped in analyzing performance before moving into production.
• Created users and groups using Central Management Console (CMC) and assigned privileges to different groups and users.

Environment: Business Objects XI R2, Teradata 12, MS Excel, Windows XP

Confidential, Bloomington, IL Sep' 08 - Mar' 09 Sr. Business Objects Developer Confidential is the leader in providing car insurance. With emerging markets and competitors it needed on the go reporting tools such as BOXI, Crystal Xcelsius and QAAWS which is part of BOXI to analyze their business, customer and partners to provide accurate reporting in various customers platform. This project main focus is performance; and involvement in creating design tables with ETL team partake in analyzing, designing, implementation according the requirement of the clients. Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (FRD) to business/technical requirement documents.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data. Created and distributed Report Templates to Users and Main Data Providers for created these reports are - Universes.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Migrated universes and reports from SIT/UAT to production using Import wizard.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data restrictions, object level based restrictions and object based security etc in BOBJ
• Created Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data.
• Used Web Intelligence to create Reports and involved in customizing the look and feel of Web Intelligence Interface.
• Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies.
• Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Resolved the issues while converting Deski report to Webi, by direct workout
• Installed Crystal Xcelsius designer and created dashboards. Created WSDLs using query as web services and implemented WSDLs into Xcelsius dashboards.
• Created WSDLs using Query as a Web Service (Qaaws) from different Data sources.
• Created Cascading Web Services for different Dashboards.
• Created Universes and complex reports against huge Oracle database.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Created query using QAAWS and using Dynamic query's created Xcelsius Dashboards.
• Created user defined objects including dimensions and measures for complex financial calculations.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created materialized views using complex SQL script writing to increase the performance of reports.
• Developed Complex formulae and running totals for business measure calculations as per requirements.
• Published and scheduled Business Objects Reports to users using Scheduler
• Developed complex queries and sub-queries using different data providers in the same report.
• Experienced in ETL development responsibilities for the enterprise Data using informatica tool.
• Involved in GUI testing, Functionality Testing, Performance Testing & User Acceptance Testing (UAT) of Client/Server & Web based applications.
• Maintaining Universes and Reports to multiple Environments (Dev, Test etc.).
• Implemented Row Level, Object Level security for data restriction at Universe level.

Environment: BOXI 3.1 ,Web Intelligence, Webi Rich Client, Info View, Oracle 10g, Toad, Crystal Xcelsius 2008 , QAAWS, Informatica, SQLServer, DB2, Windows XP

Confidential, Atlanta Jun'05-Jul'06 Sr. Business Objects Developer Atlanta-based Confidential enjoys leading positions in some of the most attractive markets in the United States and also serves clients in selected markets nationally. The objective of this project is to provide complete historic information of Payment Statuses and SLA timelines, in form of ad hoc reports. As part of the Reporting project, there is a need to extract data from the Investment transactional database, transform and load into the Reporting database which is the data source for Business Objects reports. BO reports are mainly used for Investment division internal purposes. Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created Charts to display summary data using universe as main data provider.
• Involved Analyzing, Design, Implementation and administration of security models with row level data restrictions, object level based restrictions and object based security etc in BOBJ
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Involved in creating various reports by extracting data from Data Marts
• Created reports using Oracle Databases and Personal Data File Providers.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Exported the Universes to the Repository to make resources available to the users

Environment: Business Objects XIR2/6.5 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), MS Access, Oracle 9i, SQL, PL/SQL and Windows 2003.

Confidential, Washington, DC April'03-Oct'04 Business Objects Developer Confidential, was a savings bank holding company and the former owner of Washington Mutual Bank, which was the United States' largest savings and loan association Involved in optimizing the universe developing time and SQL Tuning to increase the query performance. Part took in the full life cycle of the projects from planning, designing, implementing, preproduction testing, production and conducted user acceptance testing to successfully complete the project. Responsibilities:

• Involved in full project life cycle (requirement gathering to implementation phase), which includes preparation of Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Followed SDLC and used Ralph Kimball`s methodologies to design to successfully complete this project
• Used Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Responsible for the Designing the universes by creating the BOBJ data model selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, subdividing into contexts and created the objects which are grouped into classes.
• Designed and Developed extensive BOBJ reports using multiple Queries, combination of chart and tables.
• Worked closely with Data warehouse architects to understand the process and design and implement the ETL.
• Imposed several Joins, Filters, and Averters to restrict the unwanted data and highlight the required data. Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Involved in Production Support for existing reports. Created and monitored user groups from Supervisor.

Environment: Business Object 5.1.6, Crystal Reports 8.5, Toad, DB2, SQL, PL/SQL, MS Excel, Oracle 9i, Windows XP