EXPERIENCE SUMMARY:

• Total 17 years of extensive IT industry experience in all phases of the System Development Life Cycle (SDLC).
• More than two years experience with various Cognos 11.2, Cognos 10.2.2 BI tools and also have s.
• Five years hands on experience with Cognos 8x BI tools which include Cognos 8.4, Cognos 8.2 and Cognos8.1.
• 4 Yrs of experience in Cognos Ver 7.4 - CognosImpromptu, CognosPowerplay, Cognos Impromptu Web, Cognos Powerplay OLAP Transformer, Access Manager, Report net1.1, Oracle 10g,11g, PL/SQL, SQL, DB2.
• Expertise in designing the Models and Packages using Framework manager in Cognos BI.
• Experience of working with Active Reports & Dynamic Cubes Modeling.
• Excellent skills in open web based architecture reporting tools Report studio, Query studio, Event studio 8.4 BI.
• Experience of Analyzing the corporate data and creating the complex reports according to specific needs by using Report Studio 8.4
• Experience developing queries against normalized as well as dimensional data sources.
• Experience on Conditional Formatting, Complex Filters, Report Bursting, Scheduling, Event Conditions.
• Creating and managing agents that monitor data and perform tasks when the data meets predefined thresholds using Event Studio 8.4 and sending the email report output to the User community in a daily basis.
• Developed Multi-Dimensional Cubes by Exploring, analyzing and comparing dimensional data in Analysis Studio 8.4.
• Experience on developing Dashboard and Scorecards reports such as department dashboard, staff head count dashboard, IFC operational Dashboard, Country Dashboard, GTLP At A Glance Dashboard.
• Excellent skills in Cognos 7 Server Administration.
• Experience on solving the user Trouble ticketing system.
• Experience on Password reset, providing access to user to the specific application.
• Experience on creating Catalog, developing Reports using Impromptu.
• Experience on creating User Classes and Security with the help of Access Manager.
• Expertise in creation and maintenance of News Boxes, Publishing the reports and cubes to Upfront.
• Expertise in creation and maintenance of Impromptu Web reports.
• Involved in Extraction, Transformation and Loading (ETL) Process using Ab Initio.
• Retrieving Tables, Database Alias and Catalog keys using Impromptu.
• Designed Dimension levels and Hierarchies.
• Created Excel macros using Cognos Script Editor.
• Experience on Cognos Impromptu Web Reports and Cognos PowerPlay Web Reports.
• Exposure on Transformer Models for building Multidimensional Cubes.
• Knowledge about Extraction, Transformation and Loading Using Ab Initio Tool.
• Solid understanding in OLAP/ Warehouse Concepts and Standards.
• Experience of creating BI reports by using iReporting Tool.
• One (1) year of Web Development and Business Applications in Java ( Java Servlets, Java Applets), HTML.
• Extensively worked in UNIX, Mainframe and Windows NT/ 2000 Platforms.
• Exceptional Analytical and Problem solving skills.
• In-Depth industry experience in Banking, Retail/Manufacturing, Financial Services, Insurance, Healthcare and Human Resource Industries.

TECHNICAL SUMMARY:

OPERATING SYSTEMS: Windows 7, Windows Vista, Windows 2000 Professional, Windows NT 4.0, Windows 95, Unix, Mainframe.

DSS/OLAP/BI/OLTP: Cognos 11.2, Cognos 10.2.2, Cognos 8.4, 8.2, 8.1 BI - IBM Cognos Connection, Report Studio, Query Studio, Event Studio, Analysis Studio, Work Space, Work Space Advanced, Cube Designer, Cognos 7.3, 7.4- Cognos Impromptu, Cognos Powerplay, Cognos Impromptu Web, Cognos Powerplay OLAP Transformer, Report net 1.1 - Cognos Connections, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Framework Manager HP ALM11.

ETL: AbInitio, Informatica.

INTERNET/INTRANET: JavaServlets, Java Applets, JavaScript, IIS 5.0

GUI: Java2, Visual Basic 6.0, MS Office 2007

RDBMS/CONNECTIVITY: Oracle10g, Oracle 11g, Oracle 9i, PL/SQL, Ms Access, ADO, JDBC, ODBC, Sql Server 2008, Toad.

LANGUAGES: C, C++, Pascal, COBOL

PROFESSIONAL EXPERIENCE:

Confidential, NY

Cognos Developer

Responsibilities:

• Understand the various system and the reporting requirements.
• Created Cognos FM model based on the user requirement.
• Migrated Cognos 10 reports to Cognos 11 version.
• Resolved report migration and validation issues
• Created Position extract, Cost basis report, transaction reports etc.
• Worked on CQM and DQM query modes and resolved the issues when migrated to DQM.

Environment: Cognos 11.2, Cognos 10.2.2, Oracle 11g, Informatica, Sharepoint, JIRA, Collibra

Confidential, Purchase, NY

Cognos Developer

Responsibilities:

• Developed Visit Framework Manager Model for the Clinical reporting.
• Responsible for creating weekly and monthly healthcare reports.
• Worked closely with departmental managers to develop Cognos reports that added value to their daily operations.
• Developed reports interactive dashboards and reports.
• Developed Provider performance, Client Details, Generic Prescribing Rate reports.

Environment: Cognos 11.2- Framework Manager, Report Studio, Dashboard, MySQL, Sharepoint, Redmine, Jasper Report.

Confidential, Pennington, NJ

Cognos Developer / Consultant

Responsibilities:

• Designed and Implemented new dashboards using Portlets pages and cognos workspace.
• Cognos 10 reports have been migrated to Cognos 11 version.
• Designed and Implemented metadata models in Framework Manager
• Designed and implemented security on different levels including object and row level security
• Developed reports in Report Studio using dimensional and relational models
• Developed various Compliance Risk reports including Compliance Risk assessments Statistics, CRA Action Item List & CRA Heat map etc.

Environment: Cognos 10.2.2 - Framwork Manager, Report Studio, Work Space, Work Space Advanced, Event Studio, Analysis Studio Query Studio, Oracle 11g,Toad, Sharepoint, HP ALM11.

Confidential, Columbus, OH

Senior Developer / Consultant

Responsibilities:

• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process.
• Designed and Implemented new dashboards using Portets pages and cognos workspace
• Developed Active reports for users to use offline and on mobile devices.
• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
• Authored various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Successfully designed and implemented security on different levels including object and row level security.
• Provided to different business users to develop dashboards in workspace and workspace advanced.
• Experience of creating Test cases and also involved in Manual Testing by using ALM11.
• Experience of creating advanced Excel pivot reporting.
• Created Javascript functionality for various prompt functionality and validation purpose.
• Created New Technology scorecard risk reporting by using report studio tool.

Environment: Cognos 10.2.1 - Framwork Manager, Report Studio, Work Space, Work Space Advanced, Event Studio, Analysis Studio Query Studio, Oracle 11g, SQL Server 2008 R2,Toad, Sharepoint, JIRA, HP ALM11.

Confidential, Dublin, OH

Senior Developer / Consultant

Responsibilities:

• Created World share file and defined report attributes properties for common reusability purpose across the reporting system.
• Created Circulation reports, Acquisition Reports, Patron Details reports etc.
• Created financial report such as Daily payments report, Billing Summary report.
• Worked on Agile Methodology which is described as Iterative and Incremental process throughout the development life cycle.
• Experience of working with the team and continually revisited in every aspect of development requirements, design, etc

Environment: Jasper report 5.4.0, MySQL, JIRA.

Confidential, Dublin, OH

Senior Developer / Consultant

Responsibilities:

• Perform analysis, design, and document report requirements.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements
• Created IQD’S by Externalizing Query Subjects using Framework Manager.
• Migrated Mainframe reports to Cognos environment by redesigning the models.
• Experience of creating Image report from the source data.
• Experience of working with Active Reports and Dynamic Cubes.
• Experience of creating Tab reports with complex selection criteria for different levels.
• Worked on several projects such as MSDS Archive Reporting, HRDS Archive Reporting, AIM Reports, Contract Manufacturing, VIOC POS, VIOC DW Reports, eCustomer Reports, HR ISP Integration, Mainframe Replacement, Tempora & Valvoline DataSync Product Catalogue.

Environment: Cognos 10.2 - Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Workspace, Workspace advanced. Cube Designer, Cognos 8.4 BI - IBM Congnos Connection, Query Studio, Report Studio, Event Studio, Analysis Studio, Business Insight Advanced. Cognos 7.4-Impromptu, Powerplay Transformer, SQL Server 2008 R2, Oracle 11g.

Confidential, Roseland, NJ

Senior Developer / Consultant

Responsibilities:

• Migrated Activity and Service request reports from Crystal reports to Cognos 10 BI based on the existing functionality
• Migrated Cognos Service catalog to Framework manager model and publish to Cognos connection for reporting.
• Created various SQL for the test cases and also used some User-Defined SQL’s In Framework Manager.
• Developed Dashboards, Complex Reports having many calculations, sub reports, HTML items etc.
• Created Service request dashboard which includes at a glance level of Closed cases, Open cases, cases created within the time period etc.
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio.
• Created package for ad-hoc reporting purpose by using Cognos Query Studio
• Extensive experience in scheduling and Administering using Schedule Management in Cognos Connection.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Capable of troubleshooting report performance and query optimization issues.
• Worked extensively with the team members and demonstrated teamwork leading to results, effective communication, and sense of urgency.

Environment: Cognos 10.1 - Framework Manager, Report Studio, Query Studio, Business Insight Advanced, Analysis Studio, Cognos 8.4 BI - IBM Congnos Connection, Query Studio, Report Studio, Event Studio, Analysis Studio, Cognos 7.4-Impromptu, Powerplay Transformer, SQL Server 2005, Crystal Reports, Panorama, SQL Server Analysis Services.