EXECUTIVE SUMMARY:

• Around 6 years of experience in Software Design, Development, Analysis, Testing, Data and Business Intelligence tools such as Cognos and Tableau.
• Strong SQL and Oracle Knowledge, Oracle Certificated SQL developer and Associate Oracle Database SQL Developer
• Around 6 years of strong experience in development and testing Cognos BI tools..
• Strong knowledge in Cognos 11 (Analytics), 10 & 8 Series including Report Studio, Analysis Studio, Framework Manager, Business Insight, Business Insight advance, Metrics Studio, Event Studio, ReportNet Series tools and Cognos Connection.
• Expert in designing and developing Dash Boards and SQL tuning. good analytical and communication skills, ability to work independently and good team player

SOFTWARE SKILLS:

Databases: Oracle 11c, 8i, 9i, MS SQL Server, MS SQL 2000, MS Access, Netezza

Micro Soft Suite: Excel, word, Access

Reporting Tools: Cognos 11 (Analytics) Series, 10, 8, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer, Newark, NJ

Responsibilities:

• Worked on Agile and waterfall methodologies
• Developed Standalone and adhoc reports for business users
• Developing Active disconnected reports to end users
• Successfully migrated Cognos 8 Series reports to Cognos 10 Series
• Migrating the reports from Cognos 10.2 to Cognos 11 (Analytics) and testing the deployed reports using Cognos LifeCycle Manager.
• Dashboard design, development, Sql tuning for reports and cubes.
• Developing Active disconnected reports to end users. low level and high level documentation preparation for Cognos report development design document preparation for Cognos reports
• Framework Manager design and development
• Communicating with IBM Cognos support to fix the Cognos issues.
• Providing POC’s for business users.
• Triggering Cognos reports and events based on custom based Events.
• Successfully tested SSRS and SSAS report migration to Cognos
• Running smoke tests in congos production environment.
• Work with cross - functional teams effectively to deliver project work on time

Cognos Tester

Confidential

Responsibilities:

• Created manual and automated test plans and procedures
• Work with cross-functional teams effectively to deliver project work on time
• Testing Cognos reports on desktop and mobile platforms.
• Successfully tested and completed Cognos 8 to 10 migration
• Developed, managed and monitored TEST, CERT and PROD environment
• Monitored the testing units periodically and reported the defects to the manager followed by adoption of remedial measures
• Wrote advanced SQL to test and compare Cognos reports manually
• Testing Cognos report sequence using jobs and schedule
• Wrote testing codes and applied them to the relevant software
• Maintained test scripts, codes, ad-hoc testing in proper format
• Ensured completion of target work on time
• Automated testing using Cognos Lifecycle Manager.

Products and tools: Cognos 8.4 / 10.1 / 11, Cognos 7.x series, Framework Manager, Report studio, Oracle 12c, Toad, winSQL SSRS, SSAS, DB2, Teradata, SQL Server

Confidential

Cognos Developer, Secaucus, NJ

Responsibilities:

• Analyzing the system to design and implement the marts suitable for Cognos reporting and cubes.
• Communicating with business users, business analysts to analyze, design, develop the Cognos reports, dashboards and DMRs
• Converted existing Actuate reports to cognos 8 Report Studio reports.
• Developed several new POC (proof of concepts) to show the new reporting concepts to Business.
• Extensively worked on implementing dimensionally modeled relational data (DMR) and Excel, PDF, HTML formatting issues.
• Reports created from Oracle PeopleSoft module data.
• Worked on developing Dashboards and Tuning Reports for greater performance.
• Designed Best practices for Cognos FM, Report Studio, and Analysis Studio.
• Detailed design documentation for developed Reports, Cubes, Framework manager, Cognos best practices and server side architecture as per company policies and standards.
• Sql Tuning to enhance the performance of the reports. report migration from Cognos 8.x series to Cognos 8.4 series.
• Communicating with Cognos support to fix the unknown problems.
• Scheduling and Administering Cognos Reportstudio reports in Cognos Connection.

Products and Tools: Cognos 8.1 MR1, MR2, 8.2, 8.3, 8.4, Framework Manager, Query Studio, Report Studio, Oracle 9i, 10G, 11

Confidential

Cognos Developer, New York

Responsibilities:

• Developed Standalone and adhoc reports for business users design document preparation for Cognos reports
• Developing Active disconnected reports to end users
• Analyzing the system to design and implement the marts suitable for Cognos reporting.
• Communicating with business users, business analysts to analyze, design, develop the Cognos reports, dashboards and DMRs
• Running smoke tests in congos production environment.
• Work with cross-functional teams effectively to deliver project work on time
• Worked on developing Dashboards and Tuning Reports for greater performance
• Developing Active disconnected reports to end users.
• Low level and high level documentation preparation for Cognos report development

Products and Tools: Cognos 8.1 MR1, MR2, 8.2, 8.3, 8.4, Query Studio, Report Studio, Oracle 9i, 10G