Summary:

• Over 7 years of IT experience involved in analysis and design, development and testing, implementation, maintenance production support and knowledge transfer with good analytical skill and problem solving.
• Extensive experience providing Business Intelligence solutions using Business Objects XI R2/6.5, Desktop Intelligence, Central Management Server, Central Management Console, Auditor, Supervisor, Universe Designer, Dashboard Manager, Web Intelligence (Webi), Crystal Reports, Broadcast Agent (BCA) and Info View.
• Extensive Experience in migrating Business Objects 6.x to XIR2 and administering, managing CMC servers and creation of groups and users and granting permissions.
• Extensive experience with Universe Design, Web Intelligence, InfoView, administration, creating Ad-hoc reports and archiving the reports.
• Involved in installing & configuration, administering, implementing and maintaining Business Objects modules for both full-client modules (Business Objects, Reporting Tool, Designer) and server-side modules (Central Management Server – CMS, FRS).
• Good experience with Xcelsius dynamic data presentation, Query as a Web Service (QAAWS) and Live Office tools.
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Strong experience in Oracle7.x/8.x/9i/10g, PL/SQL, SQL*Plus for OLTP and OLAP applications.
• A Sun Certified Programmer for the Java 2 Platform
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Ability to communicate requirements effectively to team members and manage application development.
• Proactive, pragmatic and task oriented achiever with proven skill set.

Technical Skills:

Languages:

C, Java, SQL, PL/SQL, C++.

Operating Systems:

UNIX, Windows NT/2000/2003.

Databases:

Oracle 10g/9i/8i/8.x/7.x, SQL Server 2000, MS Access.

Tools & Utilities:

SQL*Plus, SQL*Loader, TOAD, Oracle*Forms 4.5, Oracle*Reports 2.5, Developer 2000, VISUAL BASIC 5.0.

Web:

JavaScript, HTML, DHTML, VBScript, Live Office Tools.

BI Tools:

Business Objects XIR3/R2/6.5/5.x, Web Intelligence, Desktop Intelligence, InfoView, CMC, Supervisor, Xcelsius, QAAWS.

Work Experience:

Nov 08 – present

Business Objects Consultant, Confidential, PA.

Title: Sales Data Warehouse

Shire DW system consists of data related to Sales Calls, Samples, Non Territory Activities, Sales Force alignments, Prescriptions and Outlet Sales. The main objective of this project is to create multiple Dashboards and Reports for Business Operations & Sales Effectiveness Team on Key Performance Measures and Indicators that drive company measurement, reporting and analytics across business units and business functions and will understand how these metrics and measures align and track against overall business strategies, goals and objectives.

Responsibilities:

• Involved in various activities of the project like business requirements gathering, designing, documenting, developing, testing and deploying the Reports & Dashboards.
• Participated in project planning sessions with project manager and team members to analyze business requirements and outline the proposed solution.
• Created multiple dashboards by using Xcelsius and Live Office.
• Developed multiple ad-hoc Reports to support end users.
• Created various reports using Free Hand SQL and Stored Procedure as data providers.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Published and scheduled Business Objects Reports using CMC.
• Involved in the administration of end users. Created new users, user groups, roles and assigning privileges.
• Involved in Testing and Documentation

Environment: Business Objects XIR2/R3, CMC, BO Designer, InfoView, Xcelsius, Live Office Tools, Oracle 9i/10g, TOAD, UNIX, Windows 2003

Dec 05 – Sep 08 Business Objects Consultant, Confidential,HIP, NY.

Title: HIP Corporate Data Warehouse

The HIP Corporate Data Warehouse consists of operational information organized so that business people can access the data in ways not easily available to them in the operational system. The Data Warehouse has Membership (Demographics, Eligibility, Medicare), Medical Services (Claims, Pre-Authorizations), Sales, Provider (PCP, Ancillary, Eligibility) and Contract (Rates, Billing, Base Plan) data.

Responsibilities:

• Studied the existing business rules and understood the client’s new reporting requirements by interacting with the Business managers and users
• Modified the existing Business Objects universe.
• Create monthly and weekly dashboard metrics for components like Claims, Membership, Financials etc., for executives
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Aggregate Functions, Cross Tab, Master Detail and Formulae’s.
• Involved in the design and build of Universes, Classes and objects and resolved loops using contexts and aliases.
• Scheduled and monitored reports using Broadcast Agent server.
• Upgraded Business Objects Universes, Users and user groups, and reports from Version 5.x to Version BO XIR2 using the Import Wizard.
• Created reports using the Universes and Free Hand SQL as data providers.
• Implemented security through Central Management Console (CMC) in BO XIR2.
• Developed multiple ad-hoc reports to support end users.
• Involved in preparing test cases, unit testing and system testing with functional team.
• Developed project requirements in collaboration with the functional team.

Environment: Business Objects XI R2/6.5, Designer, Supervisor, Web Intelligence, CMC, Desktop Intelligence, EPM Dashboards, Broadcast Agent, Oracle 9i, PL/SQL, TOAD, Windows 2003/2000

Feb 03 – Dec 05 Programmer Analyst, Confidential, NJ. Title: Learning Management Data warehouse

LMS is an integrated, comprehensive web based system for planning and tracking training at both corporate and individual levels worldwide. LMS offers a variety of features for managing a wide range of training and learning opportunities, performing training needs analysis, scheduling and managing events, tracking event expenses, implementing job qualifications, monitoring course certification, monitoring individual career development, Online and downloadable courses linking to third party content sites and tracking learner transcripts.
Learning Management Data warehouse is implemented to analyze the trends over time and build forecasts on like what new courses needs to be offered, how much revenue got generated and how much expenses incurred in addition to generate various reports for business users.

Responsibilities:

• Involved in data analysis and prepared system design based on the business specifications
• Created PL/SQL procedures, functions, triggers and packages for processing business logic in the database.
• Involved in developing front-end screens using HTML, JavaScript and VB Script.
• Studied the existing business rules and understood the client’s new reporting requirements by interacting with the Business managers and users
• Analyzed the specifications and identify the source data needs to be moved to data warehouse. Design and develop ETL process.
• Collaborated with team members on application development and participate in peer code reviews.
• Implemented and enhanced SQL queries.
• Improved and optimized codes in PL/SQL.
• Designed and developed various reports using Crystal Reports.
• Involved in preparing test cases, unit testing and system testing with functional team.

Environment: Oracle 8i, PL/SQL, UNIX (Sun Solaris), ASP, VBScript, JavaScript, HTML, DHTML, Windows 2000, IIS 5.0 and Crystal Reports/ BO 5.x

Education:

• Masters in Management Information Systems and Computer Applications.