SUMMARY

• Over 10 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 Accounting, tax and financial systems.
• Experienced in developing back-end applications using Oracle and MS Access.
• Experienced in writing SQL queries.
• 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/Stakeholders to gather and document Business requirements.

TECHNICAL SKILLS

Reporting Tools: IBM Cognos Analytics 11.1 R5, Tableau, Business Objects 6.5.1

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

RDBMS: Oracle, SQL Developer, MS Access, SQL Server, Teradata

Operating Systems: Windows

Hardware: IBM PC

PROFESSIONAL EXPERIENCE

Confidential

Cognos Developer / Data Analyst

Responsibilities:

• Worked on Missouri Enterprise Data warehouse/BI Reporting Project.
• Utilized Cognos reporting tool for data intelligence and analysis.
• Involved in Data mining and data QA to maintain data quality & data integrity.
• Designed Key Performance Indicator reports & Dashboards.
• Involved in fixing data errors with the DBAs & data warehouse team.
• Involved in generating MIS reports based on Claims, Drug Rebate, Participant’s eligibility, Providers, Third Party Liability & Financial reports for MHD.
• Created dashboards & reports with drill through functionality using Missouri Enterprise Data warehouse package.
• Tested and validated reports against the back-end oracle database.
• Created Business Requirement Documents (BRDs) & Report Specification Documents (RSDs)
• Created Report mapping documents.
• Performed regression testing based on the test cases before moving the reports to production.
• Worked in data migration with the DBAs to create the migration document for a source to target mapping for implementation.
• Assisted project teams during UAT and worked closely with the pm and QA team to make sure all the requirements are covered and tested.

Confidential - Wilmington, DE

Cognos Developer/Business Systems Analyst II

Responsibilities:

• Worked on Integrated Dispute Management System (IDMS) Project.
• Utilized Cognos & Tableau reporting/Visualization tools for data intelligence and analysis.
• Involved in generating prototype reports for end user demos.
• Tested and verified reports data against the back-end database.
• Performed QA & User Acceptance testing before moving the reports to production.
• Designed & developed reporting application using misc. Cognos studios (mainly Report Studio, Query Studio & Cognos Workspace Advanced)
• Developed numerous complex List & Crosstab Reports using Report Studio against Teradata relational data source.
• Design, Develop and test Cognos reports using features such as Conditional formatting, Sections, Master Detail Relationships & Drill Through Etc.
• Involved in designing different types of complex Cross tab, Master detail and Charts reports using Cognos.
• Designed reports using complex user defined variables to populate data on the report columns.
• Attended technical review & JAD meetings with architects.
• Performed data analysis to create reporting requirements by specifying inclusion & exclusion criteria, conditions,businessrules and data elements to be included into the report.
• Reviewed thebusinessrequirements document with thebusinessand development team to understand the architecture and functionality of the application.
• Actively participated in meetings with the SMEs and other stakeholders to gain a thorough understanding of the business operation that will be impacted by the project.

Confidential - Bethesda, MD

Cognos Developer

Responsibilities:

• Involved in information gathering process with end-users to design / develop the BI Reports.
• 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 training using Cognos Workspace Advanced.

Confidential - New York, NY

Cognos / Business Objects Developer / Data Analyst

Responsibilities:

• Involved in information gathering from end users to develop the reporting system.
• Involved in generating prototype reports for end user demos.
• Worked as liaison between 3rd party application developers and in-house end users.
• Created Business and Functional Requirement Documents.
• Worked with 3rd party application providers to implement new web-based application (SaaS).
• Tested and verified reports data against the back-end database.
• Performed QA testing before moving the reports to production.
• 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 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.

Confidential, Bridgewater, NJ

Business Objects Developer

Responsibilities:

• Created Business & Functional Request documents to design the reports.
• 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

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

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 Training 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

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 reporting tool to create reports and publish them on the web.