Summary:

• Over 6 years of professional experience in Design, Development and Implementation of Business Objects Suite (XI3.1/XIR2/6.x/5.x), Life Cycle Manager.
• Involved in full life cycle of the Business Objects BI Solution.
• Administered and Supervised the Business Objects environment using CMC.
• Strong experience in designing and building Universes from scratch.
• Designed and Developed complex Desktop and Web Intelligence reports in Business Objects.
• Proficient in Migration, Installation, Administration and Upgrading versions of Business Objects on both Windows and UNIX environments.
• Extensive experience in dealing with various data sources like Oracle 10g/9i/8i, DB2, Teradata, SQL Server, MS Access.
• Expert in database development skills using SQL, PL/SQL, Stored Procedures, Functions and Triggers.
• Proficient in Performance tuning of Database, BO reports, ETL mappings in Production environment.
• Ability to comprehend complex technical and logical concepts and adapt quickly to changes.
• Excellent communication skills, analytical skills, documentation skills and team problem solving skill in high speed, quality conscious, multitasked environment.

Technical Skills:
Software/Tools/Languages:

Business Intelligence Products: Business Objects (XI 3.1/R2/6.5/5.x) Designer, Desktop Intelligence, Web Rich Client, CMC, Supervisor, Web
Intelligence2.X/6.X.
ETL Tools: Data Integrator, SAP BW, Informatica 7.x, Data Stage.
Data Modeling/Tools: Erwin, MS Visio Case Studio.
Databases: Oracle 10g/9i/8i, Teradata, SQL Server 2005/00, MS Access, Flat Files, DB2, Sybase 12.5.7, Mainframe.
Programming Languages: SQL, PL/SQL, Java, C, C++, HTML, and XML
Operating Systems: Windows XP/NT 4.0, Windows 95/98, Windows 2000Serve, UNIX, HP UX, SUN Solaris.

Professional Experience:

Confidential, LA June 2010 – Present
Business Objects Developer
Qwest Communications is a global leader in Broadband Internet based communication; with one of the largest, most technologically advance networks in the world. The company’s data come from different operational source and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports.

Responsibilities:

• Working on several different Projects with Different Databases.
• Developed and Designed Universes, Created classes and Sub-Classes, Objects, Conditions, Join, Alias, Contexts using the Designer.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Developed Ad-Hoc Universe where in the users will build their reports.
• Developing new universe with minimal requirements.
• Test/Debug Business Objects Universe, enhancements/modifications in Designer to include new objects, updated tables, and joins.
• Created Reports using Multiple Data Providers, Free Hand SQL, Flat files and Stored Procedure Data Providers.
• Developed various canned reports using Business Objects Universes as the main Data Provider.
• Developed reports with complex Calculations, Variables, Breaks, Sorting, Drill down and Alerts.
• Helping the users in creating new reports.
• Tested the report manually and involved in trouble shooting.
• Participated in User Acceptance Testing for the reports and fixing bugs. Involved in Testing the developed Universes and Reports for final deployment.
• Managed the Users, Security and scheduling of reports using BCA
• Coordinated with Business Objects Deployment team and documented the entire project.

Environment: Business Objects XI 3.1, Oracle 9i, Toad 8.6.1, Teradata SQL Assistant 7.1, Windows XP, Win 2003/2000 Server.

Confidential, GA Mar 2009 – Apr 2010
Business Objects Developer
The Sales Compensation System collects information about the Sales Department. It provides information about the sales person’s details like their sales regions and organizations, quotas and compensation details. Compensation will be calculated on quota basis. Most of the data is in the hierarchical format. The data comes through various Data Marts. The Business Users use the Business Objects Reporting tool.

Responsibilities:

• Installed and configured Business Objects XI (R2) Business Intelligence module for migration from 5.1.5 to XI R2.
• Upgraded BO version from 5.1.5 to XI R2.
• Migrated Universes & Reports from BO 5.1.5 to BO XI R2 Environment using Import Wizard.
• Analyze and document the existing 5.1.5 reports and Universes.
• Prepare the Checklist/Test Plans for testing the migrated Universes, reports.
• Troubleshoot the Issues and Problems encountered during the migration of reports & universes from Business Objects 5.1.5 to Business Objects XI R2.
• Work on the Designer, to test the universes on BO 5.1.5 and BOXI R2.
• Test the Desktop Intelligence reports on BO 5.1.5 and BO XI R2.
• Validate theUniverse and reports by comparing the Sqls.
• Managed the Users and Security using the CMC.
• Configured Development, Test and Production environments and synchronize user accounts on all three environments.
• Maintain the three server boxes, dev, test & Production for the migration activities.
• Migrated and Promoted reports from Training to Development and from development to QA and from QA to Production.
• Interact with the users to gather requirements and work with them to ensure that the reports work well after the migration.
• Scheduled and tested the reports using CMC.
• Document the installation process.
• Train and educate end users about the features of Business Objects and generation of reports.

Environment: Business Objects 5.1.5/XI R2, Web Intelligence XI R2,Oracle 9i,SQL Plus, Windows XP, Win 2003/2000 Server, Unix, Clear Case.

Confidential, MN Mar 2008 - Feb 2009
Business Objects Analyst
The phase I system involves in analyzing and gathering of user requirement, discovery and identification of user requirements, establishing business rules in order to build enterprise Data warehouse to improve overall quality and productivity of existing processes and deploying reliable and accurate information that identifies the source in ftp staging area and creating mapplets, mappings and sessions through Informatica Power Center ETL tool in order to create and populate the target database schema.

Responsibilities:

• Designed and implemented Star-Schema in creation of data warehouse.
• Created complex mappings using SAP BW.
• Written Stored Procedures for data transformation and normalization.
• Tuned the transformations and sessions to perform better.
• Documented the complete SAP BW repository objects like mappings and transformations.
• Involved in full life cycle and automation of whole reporting application.
• Installed and configured Business Objects and Web Intelligence.
• Interacted with users to collect the user requirement.
• Created functions using oracle PL/SQL.
• Minimized the Skew factor in Teradata.
• Created stored procedures, cursors and several queries in Oracle.
• Designed and created the Universe as per client requirement.
• Created Crystal, WEBI and Desk I reports as per the requirements.
• Tested the reports in Web Intelligence.
• Conducted user training for Richfood Employees for their future use.

Confidential, CT Jan 2007 to Feb 2008
Business Objects Developer
Westvaco is a Major Manufacturer of papers and specialty chemicals and also the largest producers of envelopes in the world. The system involves in building Data warehouse to improve overall quality and productivity of existing processes and deploying reliable and accurate information. This information is delivered in various data marts like production, sales and that are used to formulate analytical information and generating reports.

Responsibilities:

• Installed and configured Business Objects XI (R2), Upgraded and migrated BO version (6.5.1/XI R2).
• Migrated reports from business objects 6.5 to business objects XI
• Migrated corporate documents and the Universes using the Import Wizard.
• Validate theUniverse and reports by comparing the Sqls.
• Resolved the issues on the universes and reports after the migration.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL, Universe
• Configured Development and Test environments and synchronize user accounts with LDAP server on all three environments.
• Created SQL for Ad-hoc reporting.
• Configured Publisher with BCA and to test the implementation on Development and Test environments and map the same to the existing production environment.
• Responsible for system architecture, to maintain 3 server boxes. (Production, Test and Development environments)
• Document the installation process and co-ordinate with product support to resolve certain product related bugs.
• Partner with team members to gather requirements to formulate business specifications and assist the technical team in analyzing and translating business requirements to ensure accurate interpretation and application architecture.

Environment: Business Objects 6.5/XI R2,Informatica 7.0, Web Intelligence 6.X, BCA 6.5, Publisher 6.5, Auditor 6.5,Oracle 9i, Windows XP, Win 2003/2000 Server, Unix, LDAP, Test Director.

Confidential, Kathmandu, Nepal Feb, 2006-Dec, 2006

• Nabil Bank Limited, the first foreign joint venture bank of Nepal, started operations in July 1984. Nabil was incorporated with the objective of extending international standard modern banking services to various sectors of the society. Pursuing its objective, Nabil provides a full range of commercial banking services through its 47 points of representation across the kingdom and over 170 reputed correspondent banks across the globe. Operations of the bank including day-to-day operations and risk management are managed by highly qualified and experienced management team.
• Responsibilities:
• Participated in database analysis and design.
• Writing Oracle stored procedures/triggers/PL/SQL
• Done the object oriented analysis design
• Done extensive testing using sampling methods and simulations.
• Spotted out some performance issue and sorted out the same.

Environment: Java J2EE with Oracle, XML

Bachelors of Science