PROFESSIONAL SUMMARY: -

• Over 8 years of IT experience in Cognos software development, designing implementing and administered high quality business solutions, with more than 8 years of major focus on Business Intelligence. Worked on Guidewire tools.
• Expertise in Cognos Analytics / Cognos BI 11x, 11.0, 10.x, 10.1, 10.1.2, 10.2, 10.2.1 (Report Studio, Framework Manager, Business Insight, Business Insight Advanced), Cognos 8 BI suite (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Guidewire tools, ReportNet 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront) and PowerPlay Enterprise Server.
• Extensive experience working with Cognos 10.x/8.x, Business Intelligence Reporting Suite (Framework Manager, Event Studio, Report Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced).
• Implemented ETL processed reports and queries in support of business analytics and interactive reports and dashboards.
• Provided technical and business knowledge support to the team while compiling ad-hoc data and report requests.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Experience in working on developing various kinds of reports in Cognos 8.x/10x Report Studio, Analysis Studio and Query Studio.
• Extensively worked on publishing of (IWR) Impromptu Web Reports and PowerPlay Web Reports.
• In-depth experience of Cognos Report Net 1.1, 1.02, Report Studio, Framework Manager and Query Studio, Guidewire tools
• Strong hands-on experience in developing Framework Manager models both Relational and Dimensional (DMR modelling)
• Good Hands on experience of Cognos 8 SDK.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Experience in creating Data marts, Data warehouses using Microsoft SSIS, SSRS and other ETL tools.
• Strong experience with Cognos Analytics 11, Guidewire tools (Report, Dashboard, Data Module and Stories).
• Experience on OLAP cubes, relational and multi-dimensional Data models.
• Strong experience with Cognos Controller Software.
• Strong hands-on experience working on migration from Cognos 8.4 to 10.x/11.x
• Hands-on experience in testing and validating the data in the reports with the Controller manually.
• Experience with complete Life Cycle Development process includes analyzing business needs, documenting business information requirements, implementing and production support using Cognos as a BI tools.
• Hands-on experience in implementing Data warehousing methodologies including STAR SCHEMAS and SNOW-FLAKE SCHEMAS for huge data warehouses.
• Hands on experience in Cognos Administration like creating user, Deployments, Creating data sources, Managing Configuration settings etc.,
• Highly proficient and experience in the use of IBM Cognos/OpenPages reporting, understanding business requirements, designing and developing visually appealing solutions that meet customer requirements.
• Exposure to client interaction and user-requirement analysis.
• Experienced with migration of Cognos code (reports/models/frameworks) from one environment to another.
• Experience in using Manhattan Warehouse Supply Chain Intelligence (SCI) to build and adjust Reports to meet business needs.
• Created new and enhanced canned reports packaged with Manhattan SCI.
• Hands-on experience with relational databases like MS SQL Server, Teradata and Oracle.
• Experience in installing of fix packs and hotfixes for Cognos BI products.
• Extensive experience using PowerPlay Transformer to move relative data, billing and accounting into Transformer PowerCubes v7, 8.
• Good experience in designing complex dashboards and reports using Active Reports.
• Progressive hands-on experience in Data warehousing and ETL processes using Informatica.
• Specific expertise in BI development, Cognos analytics architecture, server platforms as an application administrator, data integration and ETL.
• Experience in creating Multi-dimensional Dynamic Cubes for corporate data using Power Play Transformer 10.x
• Performed Java Development and Performance Tuning.
• Performed Java Multithreading, Spring frameworks.
• Strong experience and good understanding of business process especially in the Financial, Insurance and Health care domains.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.
• Excellent analytical, problem solving, communication with ability to interact with individuals at all levels.

TECHNICAL SKILLS:-

Reporting Tools: Cognos 11x, 10.x, 10.2.2 10.2.1, 10.1.2 and 8x (Report Studio, Framework Manager, Guidewire tools, Dmr, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection), Cognos ReportNet 1.1 MR2 (Cognos, Cognos Impromptu 7.0/7.1/6.1, Cognos PowerPlay, Transformer 7.0/7.1/10.x, Cognos Query 7.0/7.1, Metrics Manager. Cognos 8.3, Cognos 8.4.Cognos 10) Java Script

Operating Systems: Windows95/98/2000, Windows NT 4.0, and Linux/Unix

Languages: SQL, PL/SQL and DB2

Data Modeling Tools: Cognos Framework Manager 10.2, 10.1.1, PowerPlay Transformer

Databases: Oracle, MS-SQL Server, DB2 and MS-Access.

ETL Tool: Cognos Data Manager 10/8.4/8, Microsoft SSIS

PROFESSIONAL EXPERIENCE:-

Confidential - Uniondale, NY

Sr. Cognos BI Report Developer

Responsibilities:

• Gathering and analyzing business requirements from users and business community.
• Worked on Guidewire tools which helped the partner that specializes services to clients in the property and casualty insurance arena for NY Schools.
• Creating Claims, Billing and Policy Reports in Guidewire .
• Tracking the process of work done and has to be done by using Rally ticketing .
• Prioritizing work depending on the urgency of the reports required.
• Developing Framework Manager Models and analyzed those models in analysis studio.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Designing and developing Cognos Reports using IBM Cognos Analytics 11 and Cross comparing output data with the available Guidewire tools. (Claim, Billing and Policy )
• Developing very complex reports using Report Studio and Query Studio.
• Working with ETL team and BI Team to ensure deliverables are achieved within expected timeframes.
• Implemented ETL processes in reports and queries for support of business analytics and interactive reports and dashboards.
• Provided technical and business knowledge support to the team while compiling ad-hoc data and report requests.
• Generating Complex reports in Cognos 10.2 & 10.x Report Studio including Drill Down reports from DMR modeled Frame work model.
• Developing Framework Models against DB2 and advanced SQL Server with filters.
• Creating list Reports & cross tab Reports using Cognos 10.1 & 10.2, 10.x and upgrading Reports from 8.4 to 10.x/10.2.2.
• Developing, building and maintaining Cognos Multi-Dimensional PowerCubes using Transformer PowerCubes v8.
• Manually modifying the SQL Server in Report Studio to tune and/or to write complicated reports.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Creating Sophisticated Reports using Report Studio.
• Using some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Designing star schema and dimensional model using Framework manager.
• Creating Reports for IBM Open Pages and implementing them into the GRC Platform.
• Testing the reports generated with the database for correctness of data by writing SQL Queries.
• Working with Business Intelligence tools such as Cognos to develop reports material/technical docs and provide data to prepared Installation Qualification Document.

Environment: Cognos 11x, 11, 10.x, 10.2.2, 10.2.1, 10.1.1 and 8 BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Cognos 8.3, Cognos SME, Frame Work Manager, PowerPlay Transformer 10.x, DB2, MS SQL Server, Oracle SQL,XML and Windows NT/4.0.

Confidential - Jersey City, NJ

Sr. Cognos Developer

Responsibilities:

• Created dashboards for users using Business Insight, Business Insight Advanced, Workspace, Workspace Advanced and also trained users.
• Designed and developed Framework model to better suit complex report development using Oracle as backend.
• Migrated impromptu administrator to latest version Cognos 8.4 and Cognos 10.1.2/10.x.
• Created and published various packages to meet different requirements.
• Involved in creating Documentation for moving and installation/config of Cognos BI server, SQL Server, and Cognos Controller Software.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Created Data modules in IBM Cognos Analytics 11.
• Created Transformer PowerCubes on v7, 8 from SQL Server database for billing, records, staffing, payroll and cost accounting.
• Developed Dashboard Reports, Standard Reports and Chart Reports by using Report Studio and Query Studio in Cognos 8.3 and Cognos 10.1./ 10.2.
• Developed implemented ETL processes in reports and queries in support of business analytics and analytic reports and dashboards.
• Provided technical and business knowledge support to the team while compiling ad-hoc data and report requests.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Involved in coding/debugging complex SQL queries in Teradata for data analysis, ad hoc requests for data extracts and report development.
• Provided support in developing design and program specifications using Java.
• Developed program specifications and validated program accuracy by preparing unit test plans/scenarios and evaluating results against plans with Java.
• Using an IBM Cognos reporting engine the application generates a series of complex reports and makes available to the clients via a portal application which provides clients with transparency into the process, the reports as well as analysis and insight.
• Performed Java Development and Performance Tuning.
• Performed Java Multithreading, Spring frameworks.
• The Role is to develop and support the solution and architect future developments for the project assigned.
• Wrote advanced SQL to test and compare Cognos Reports manually.
• Worked as administrator to carrying out data and Cognos 10.x product verification activities.
• Resolved complex problems by performing root cause analysis.
• Extracted the SQL from crystal and create the report in Cognos report studio.
• Created models, architecture and set up a variety of reporting environments in a variety of environments including Oracle data for the Cognos reports.
• Developed Tableau dashboards according to user specifications.
• Created and published the Packages to the Cognos connection.

Environment: Cognos 10.x/ 10.2/10.2.1, 8 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Oracle,Java, Power Play Transformer, MS SQL Server, Windows NT, Linux/Unix.

Confidential - Hartford, CT

Cognos Developer/Admin.

Responsibilities:

• Gathered and documented requirements from end users in JAD sessions to develop ad - hoc reports.
• Created and developed FM model for report studio developers.
• Migrated of series 7 reports to Cognos 8.4 and Cognos 10.
• Migrating of reports and catalogs from Cognos series 8.4 to Cognos series 10.x
• Installed, Designing and Implementing BI Solutions with IBM Cognos with Linux and Unix OS including its configuration and performance tuning.
• Created Cash Product Dashboard reports to present critical company data in a single report using Cognos 8 metric studios.
• Used Cognos 8 Framework Manager to supports high performance analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables.
• Experience in creating Data warehouses using Microsoft SSIS.
• SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
• Migrated Cognos deliverables across various OpenPages versions.
• Created joins, unions and calculated query items in the model to meet the requirements.
• Created Ad-Hoc Reports using Query Studio based on user requirements.
• Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.
• Developed and wrote simple reports using Report Studio and Analysis Studio.
• Provided support during the User Acceptance Testing (UAT) and created test cases on SQL Server and Reports.
• Performed BI Content Administration tasks including scheduling and content management
• Administered user access protocols and managed user accounts and access privileges.
• Created Sophisticated Reports using Cognos 8 BI Report Studio.
• Worked on Star Schema Database Design.

Environment: Cognos 8.1, 8.2, 10, 10.x (Framework Manager, Report Studio, Analysis Studio Query Studio), MS SQL Server, Oracle9, Windows, Java, Unix/Linux

Confidential - Chicago, IL

Cognos Developer

Responsibilities:

• Gathered and analyzed business requirements from users and business community.
• Generated Complex reports in Cognos 8.1 report studio including Drill through reports.
• Migrated reports and catalogs from Cognos series 7.1 to Cognos series 8.1 to 10.x.
• Created Cash Product Dashboard reports to present critical company data in a single report using cognos 8 metric studios.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Involved in designing of Relational and Multidimensional databases (RMD).
• Involved with team in designing star schema and dimensional model using Framework manager.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified the SQL in ReportStudio to tune and/or to write reports.
• Analyzed existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Designed and developed reports in Cognos Report Studio and Query Studio.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Created Sophisticated Reports using Report Studio.

Environment: Cognos 8 BI, Cognos 10, 10.x Report Studio, Query Studio, Analysis studio, Metric studio, Framework Manager, Oracle

Confidential - Rapid City, IA

Junior Cognos Developer

Responsibilities:

• Converted business requirements into product documentation.
• Interacted with Development and Management Teams.
• Involved in Testing and Explore New Tools ReportStudio and QueryStudio.
• Developed standard Templates, standard Reports, Charts, and Drill through Reports, Master Detail Reports, Bursted Reports and Multilingual Reports using ReportStudio, QueryStudio and Query Optimization.
• Experience in creating Data warehouses using Microsoft SSIS ETL tools.
• Manually modified the SQL in Report Studio to tune and/or to write reports using Report Studio.
• Created Query Prompts, calculations, Conditions & Filters.
• Developed Prompt pages and Conditional Variables
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection

Environment: Cognos ReportNet 1.02, Framework Manager, PowerPlay, Impromptu, PowerPlay Transformer, Windows 2000, SQL Server 2000.