Profile

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

Professional Summary

• Over all 6+ years of experience in Information Technology involved in Requirement Analysis, Design, Development, Implementation and Maintenance of various software applications including Data Warehousing using BusinessObjects, CrystalXI, Xcelsius, Oracle and Microsofttechnologies.
• More than 4 years of experience in Business Objects suite like BO reporter, Crystal Reports, Xcelsius,QAAWS (Query as a Web Service), CMC, Designer, Web Intelligence, Info View, Desktop Intelligence and Rich client.
• Specialized in Business Intelligence technologies & tools and has extensive experience on Business Objects 6.5/ XI R2 /XI 3.1, Universe Designer, Web Intelligence (WebI), Desktop Intelligence, Crystal Reports, Central Management Server, Broadcast Agent (Document Agent/Publisher), Publisher, Dashboard Manager and Crystal Xcelsius
• Expertise in analyzing, designing, developing and administration of Universes and Reports
• Developed Drill down, link Reports, sub reports used various charts and Graphs like Bar Chart (Side By Side, Stacked), Line graphs, Pie Charts.
• Performed Pre Migration Assessment, Migration&Post Migration
• Expertise in Converting the reports from Oracle Browser reports to BOE XI 3.1 (webI and Crystal reports)
• Proficient in analyzing, designing and creating crystal reports 2008.
• Experience ininstallation, administration and configurationof Business Objects product Suite (5.x, 6.x, XI-R2, XI-3.1) versions
• Knowledge in PL/SQL(SQL Queries, Stored Procedures, functions, packages, views, triggers and performance tuning), usingMS SQL Server 2005/2000(DTS).
• Knowledge of Stored Procedure (SPROC) and User Defined Functions (UDF)
• Hands on experience in realization ofcomplete software life cycleusingOO techniques, design and developmentofClient-ServerandWeb basedapplications, strongtroubleshootingand problem-solving skills.
• Proficient with MS Office Tools (MS Word, PowerPoint, Excel, Visio, Outlook, Project)
• Excellent Written and Verbalcommunication and interpersonal and analytical skills and an ability to lead a team
• Experience in all the phases of Software Development Life Cycle (SDLC) such as strategy and analyzing, designing, building (coding), testing and documentation of software products

Education

B.S. in Computer Information Systems program

Technology Summary

Reporting Tools :

Business Objects (XI 3.1/XI r2/ 6.x/5.x), Web Intelligence, InfoView, Rich Client, XI R3 (CMS, CMC, Designer, DeskI, Import Wizard,), BO 6.5.1, XCelsius 2008, Crystal Reports 2008, XIR2/10.0/9.0/8.0/7.0/6.0, Crystal Enterprise XI/10.0/9.0/8.0 Developer 2000 Forms and Reports/Oracle Reports, Oracle Browser Reports Version 2.0.11.6.0.

Databases :

Microsoft SQL Server 2008/7.0/2000/2005, Sybase 12.0, DB2, MS Access, MySQL.

Modeling Tools :

VISIO, Power designer

Languages :

C, C++, Visual Basic 6.0, Microsoft Visual Studio 2008/2010, FoxPro, CSS, PHP, HTML

IT Experience

Business Objects & Crystal Reports Developer

Responsibilities:

• Gathered Report Requirements from the Finance division.
• Scheduled and involved in the meetings with the end users in discussing the report requirements.
• Created design specification templates and Report Requirement Specification templates for the reports prior to the development of reports.
• Played a vital role in Universe creation, filters creation and resolving loops and traps.
• Created, maintained the universe using Business Objects designer.
• Modified the existing Universe by merging different classes and modified the joins in the contexts as the reports demanded.
• Documented each and every module of the project.
• Created a Report Checklist Specification template for each report and sent them to the respective users to fill in.
• Created more than 30 WebI reports for accounting division of the Department of Administration.
• Created List of values using Business View Manager.
• Analyzed and tested the WebI reports before exporting to production.
• Exported the WebI reports from development to the Production environment.
• Fixed the issues for already existing WebI reports and improved the performance of the reports.
• Analyzed and fixed the complex issues for already existing reports as per the user’s request, by checking the data in Microsoft SQL server and Data warehouse.
• Scheduled the reports on daily, weekly, monthly and quarterly basis, according to the users requirement.
• Developed more than 30 Crystal reports for the Human Resources Department on Oracle Database directly.
• Generated some Complex SQL and Crystal formulae for crystal reports, which the reports demanded.
• Created some complex Record selection formulae to make the reports run smoothly by users.
• Created some User Functions to extract the Data and to cut down the run time while extracting these data.
• Formatted the complex crystal reports which have a large number of display columns.
• Co-ordinated with more than 15 users from various departments in gathering the requirements and explaining them the functionality of the reports.
• Provided training sessions for the end users to show the usage of both the WebI and Crystal reports.
• Exported the Crystal reports to the Business objects Environment and tested them on BOE since they behave different on BOE.
• Assist in building, implementing and improving processes related with day-to-day Service Delivery Operations.
• Scheduled the crystal reports by setting default parameter values based on user’s requests.
• Converted more than 50 reports from Oracle Browser Reports to WebI and Crystal Reports according to the user’s requirement with in the assigned time line.
• Developed Report specifications and crystal reports based on existing MS Excel sheets.
• Handled solely the whole process of Converting reports from Oracle browser Reports to BOE.

Environment:Business Objects XI 3.1 (Designer, WebI, CMC, Import Wizard), Crystal reports 2008, Oracle Browser Version 2.0.11.6.0, Microsoft SQL Server 2008 R2, Informatica Power Center/Power Mart 6.0, Oracle 9i , MS Excel, MS Access 2007 and Windows XP/2002 SP 2.

Confidential,Atlanta, GA Oct 2009 – Nov 2010
BO Developer

Responsibilities:

• Providing best technical reporting solutions for Business Problems and coordinated the execution of the project with offshore.
• Provide response, restoration and resolution of the business critical tickets which will be raised by BP users on regular basis.
• Coordinating with Offshore for root cause analysis and fixing the bugs permanently.
• Suggesting best processes to client environment that enhances the Software Service Maintenance.
• Preparation of the required documentation as part of the transition activity.
• Assisting clients to provide reporting solution and develop/maintain universes against their Data Warehouse and SAP R/3 using Webi, Business Objects and Designer.
• Resolving day to day Business Objects issues/Incidents and problems as per problem management.
• Installed and ConfiguredBusinessObjects XI R2 client/server products Designer, Supervisor, Broad Cast Agent, WebIntelligence (Webi), InfoViewPortal, Application Foundation and Set Analyzer in different environment like Development, QA and Production.
• Interacted with Users and gathered Business Requirements. Mostly involved in making changes to the existing Reports and updating the reports as per the Requirements.
• Preparing presentations for Business to make them aware and having their positive comfort index with the new report.
• Based on Requirement Createdcomplex a crystalreport using the data from SQL Server and Oracle server database.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Involved in designing BO Dashboard for Intelligence tool on an existing architecture.
• Involved in Design, Development, Security, Testing and necessary updates to the existing architecture and also Cross-Enrollment Data-Mart.
• Involved in Creating store procedures in SQL server data base for extract data.
• Coordinating with Database team for the database design and Created SQL queries for extract data from oracle data base.
• Reviewed User Requirements. Created detailed Functional Design Documents and Reportdesign details documents for the reports.
• Resolved the Performance issues/Data issues within the Reports and Procedures.
• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/groups on Central Management Console (CMC) and giving Appropriate Access levels.
• Created complex report using with Sub report, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Exported Reports into PDF, Excel, Word&RTF from Enterprise and resolved formatting issues.
• Provided training to business users in WebI and Designer.

Environment: Business Objects XI R2, SAP R/3, Crystal Reports 10, BO Performance and Dashboard Manager, SQL Server, Oracle, Windows

Confidential,Minneapolis, MN Nov 2008 - Oct 2009
Business Objects Developer

Responsibilities:

• Performed an initial study on the reporting needs.
• Responsible for Identifying and Analyzing Business Requirements and performing source Data Analysis.
• Analyze the reporting requirements with the business users.
• Worked closely with the business users and Business Analysts to develop the transformation logic.
• Involved in designing and developing new universes for personal and institutional loan data.
• Created aliases and contexts to resolve the loops and traps (fan traps and chasm traps).
• Generated the standards and templates for the reports and the universes.
• Involved in analyzing the source data coming from different sources such as SAP, Oracle.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master/detail tables, formulas and etc.
• Used SQL for querying databases in order to perform data comparison as part of analysis.
• Created and maintained the universes using Business Objects designer.
• Created, maintained and modified the business critical reports using the BusinessObjectsReporting Module and Web Intelligence.
• Involved in analyzing and migrating the Business objects XI R2 applications to Business Objects XI 3.1.
• Involved in migrating the system from development to QA and to production environments.
• Designed, developed and maintained a dashboard using Excel and Xcelsius, which had the product wise results for the year and had the capability of projecting product wise sales (Used Slider, Dial and bar chart).
• Developed Dashboards for measuring KPI’s and analyzing trends using Xcelsius Dashboard Tool.
• Involved in helping business users by creating ad-hoc reports.
• Documented the entire effort. The documents generated during the process were Requirements Specifications, Design Document and Project planning documents.
• Provided user support and training in using Report Designer and Web Intelligence for creating Ad-hoc reports.
• Provided training for employees to take over support of the BO.

Environment:Business Objects XI R2/XI 3.1 (Designer, Desktop Intelligence, WebI, CMC, Import Wizard), Live Office, Crystal reports XI, MS Excel, MS Access, Oracle 10g, Crystal Xcelsius and Windows XP/2003.

Confidential,Hopewell, NJ Jan 2007 - Nov 2008
Business Objects Developer

Responsibilities:

• Created Repositories and RepositoryDomains (Universe and Document domains).
• Created various User Groups in a Repository.
• Created users in a Group and assigning each user certain privileges for the appropriate access.
• Administered user logons, Enable/Disable a user, Resetting passwords, changing a user profile among other user administration functions.
• Created various Categories for the storage and retrieval of critical documents and reports.
• Configured Broadcast Agent for the timely scheduling of critical Decision making reports.
• Configured InfoView as the portal for Business Objects WebIntelligence.
• Building of various Universes using Star Schemas.
• Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins, and Contexts. Resolving Loops, and Verifying Integrity of universes.
• Creating complex objects, aggregate navigation, @prompts, @variables, and resolving traps (chasm/fan) among others.
• Exported / Imported Universes and Documents to / from the Repository.
• Responsible in migration of the Universes to four different Environments (UAT, Development, Test, Production).
• Responsible for documenting the whole process.

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), WebI, InfoView, 3 Tier BO, BCA (BO Publisher), Oracle 9i, MS SQL Server 2005, Windows 2000 Server/XP.

Confidential,Kathmandu, Nepal Jan 2006 - Oct 2006
Business Objects Developer

Responsibilities:

• Studied the business processes and gathered the requirements from Business Analysts and Business Users.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Created several Classes, Objects, Conditions, and Measure objects.
• Created Master/Detail, Cross Tab and various Chart reports, and exported them to the Corporate Repository.
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
• Developed hierarchies to support drill down reports.
• Scheduled and monitored reports at the server level using Broadcast Agent (BCA).
• Involved in the designing and building of the Universes, Classes and objects for the client requirements.
• Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Created various standard reports and queries based on the existing classes/objects.
• Exported reports to Excel based on the user requirements.
• Validated Test Plans and Documented the Defects.
• Educated end-users and provided technical support.

Environment:Business Objects 5.x (Supervisor, Designer, Reporter), WebI, InfoView, Oracle 8i, MS SQL Server 2000, Windows 2000 Server/XP.