SUMMARY

• Having 15+ Years of experience which Include Over 7 years of experience in creating Ad - hoc reports using IBM Cognos and over 8 years of experience in creating Ad-hoc reports using Business Objects.
• Strong Cognos / Business Objects developer with Strong experience in developing Business Objects Full client (REP) and WEBI (WID) reports based on User requirements.
• Extensive knowledge of Microsoft Excel functionality and design techniques, including pivot tables, Vlookup and other advanced spreadsheet functions, formatting and presentation techniques, and familiarity with VBA coding.
• Excellent data analysis skills.
• Knowledge of data warehousing concepts and techniques.
• Knowledge of tax and financial systems.
• Experienced in developing back end applications using Oracle and MS Access.
• Experienced in writing complicated queries using SQL and SQL Plus.
• Strong programming experience in Client / Server environment.
• Enthusiastic and project-oriented team player with good written and oral communication skills.
• Skilled in interacting with end-users to gather and document Business requirements.

TECHNICAL SKILLS

Reporting Tools: Cognos 8.3/8.4/10.1.1/10.2.1 , Business Objects 5.0/5.1/5.1.3/6.1 a / 6.1b / 6.5.1

Web Reporting: Web Intelligence 2.5, 2.7, 6.1, 6.5.1

RDBMS: Oracle 8.0/7.3, MS Access, SQL Server

Operating Systems: Windows

Hardware: IBM PC

PROFESSIONAL EXPERIENCE:

Confidential - MD

Cognos Developer

Environment: Cognos 10.2.1, Oracle 11, Gamma Systems, MS Office

Responsibilities:

• Designed & developed reports for their Supply-chain user group using Report Studio & Cognos Workspace Advanced.
• Designed Sales and Inventory reports to track the performance of duty free stores on North American airports.
• Designed reports against Dimensional and non-dimensional packages.
• Involved in End user using Cognos Workspace Advanced.

Confidential - New York, NY

Cognos / Business Objects Developer

Environment: Cognos 10.2.1, Business Objects 6.1a, 6.5.1, Web Intelligence, Crystal Reports 8.0, SQL Server, Virtual Premise, MS Office

Responsibilities:

• Designed & developed reporting application for their Real Estate & accounting Division using misc. Cognos studios (mainly Report Studio, Query Studio & Cognos Workspace Advanced) & Business Objects Web Intelligence.
• Developed numerous complex List & Crosstab Reports using Report Studio against 2008 SQL Server relational data source.
• Developed and modified reports using external data sources like MS Excel and published Framework Manager Models.
• Design, Develop and test Cognos reports using features such as Conditional formatting, Sections, Master Detail Relationships & Drill Through Etc.
• Added query items / Cubes & exported packages using Cognos Framework Manager.
• Involved in information gathering from end users to develop the reporting system.
• Involved in generating prototype reports for end user demos.
• Involved in designing different types of complex Cross tab, Master detail and Charts reports using Cognos and Business Objects functionalities.
• Designed reports using complex user defined variables to populate data on the report columns.
• Worked as liaison between 3rd party application developers and in-house end users.

Confidential, Bridgewater, NJ

Business Objects Developer

Environment: Business Objects 6.1a, Web Intelligence, Oracle 9i, MS Office 2003

Responsibilities:

• Involved in design & development of a reporting application (Sales Watch) using Web Intelligence.
• Designed standard and drillable reports using Sales Watch universe.
• Designed ad-hoc and prototype reports for demonstration to the end users.
• Developed Full client and thin client reports in Web Intelligence 6.1a environment.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.

Confidential - Hoboken, NJ

Business Objects Developer / Data Analyst

Environment: Business Objects 6.1b, Web Intelligence, Toad 7.6, SQL, MS Visual Source Safe, Lotus Notes 6.5, MS Office 2003

Responsibilities:

• Involved in design & development of a reporting application for Global Broking Tracking System (GBTS) using Business Objects.
• Worked with MRD team to develop the data marts and create reports against it.
• Worked on designing, developing, implementing and testing the data marts and creating the existing Actuate reports in Business Objects and publishing them on to the portal.
• Created ad-hoc reports and prototype reports for demonstration from the existing database to the business Users.
• Involved in Quality Assurance and Testing of Business Objects reports.

Confidential, Old Tappan, NJ

Business Objects Developer / Royalty Systems Support

Environment: Business Objects 5.1.3, Web Intelligence 2.5, Royalty Accounting System (IBM Mainframe), Q+E Database Editor, RMM, RMS, SQL, MS Excel 97/2000

Responsibilities:

• Worked with Business Objects designer 5.1.3 to design and modify universes to map database objects in SQL Server, DB2 and Oracle.
• Worked on different Universes to add new Tables, Joins, defining new objects in the universe.
• Designed Detailed Sales reports in Business Objects 5.1.3 to provide Royalty information to Royalty Users.
• Designed reports in Business Objects 5.1.3 to support rights Marketing & International Finance groups in Upper Saddle River, NJ and Indianapolis, IN.
• Involved in and Support of Business Objects to Business Objects end users.
• Extracted information from Royalty database using SQL queries in QMF in Royalty Accounting System.
• Worked on old and designed new reports and constantly worked with the end users.
• Interaction with the users to gather information for creating and modifying reports.
• Created number of standard reports and drillable reports in RDSR production & Rights Marketing Universe using Slice and Dice and other Business Objects functionalities.
• Involved in preparation of weekly suspense spreadsheets as and when required.
• Support in Daily and Month End royalty operations and Systems Support.
• Installation and configuration of Business Objects for users.
• Desktop PC support to End users as and when required.

Confidential - Eden Prairie, MN

Business Objects Consultant

Environment: Business Objects 5.0, Web Intelligence 2.5, Oracle 7.3/8.0, MS Excel 97/2000

Responsibilities:

• Worked with Business Objects designer 5.0 to design and modify universes, to map database objects in SAP R/3 and Oracle.
• Worked with the old reports and constantly worked with the end users.
• Interacted with the users to gather information for creating and modifying reports.
• Created number of standard reports and drillable reports in Sales and Distribution using Slice and Dice and Drill modes, using their standard templates.
• Worked with Web Intelligence to create reports and publish them on the web.