PROFESSIONAL SUMMARY:

• Overall 7+ years of experience in IT Industry in Cognos Business Intelligence reporting and a wide range of experience in providing product specifications, design, analysis,development, documentation and implementation of the Business Technology solutions.
• Well versed in developing reporting applications using Cognos BusinessIntelligence(10.2/8.4) components like Report Studio, Query Studio, Analysis Studio, Metric Studio and Cognos Connection and Powerplay Transformer.
• Hands on experience with Framework Manger Modelling (Physical Layer, Business layer, packages) and complex report building with Report Studio.
• Experience in creating and publishing packages in Framework Manager.
• Worked on Dimensional data modelling, Star/Snowflake schema modelling, Fact and Dimensional tables, Physical and Logical data modelling.
• Good experience in developing dashboards using Cognos Workspace and Cognos Workspace Advanced.
• Strong complex Reporting skills - Complex Drill-Through, Discontinuous Crosstabs, Summary Reports and Burst Reports.
• Proficiency in Report Authoring using cascading prompts and conditional formatting.
• Experience on Installation, Configuring & Troubleshooting of Cognos BI Environment series (7/8/10). Involved in migrating reports from Cognos BI 8.4.1 to Cognos 10.2 series.
• Expertise in developing reports using Active Reports, Report Studio, Query Studio, Analysis Studio.
• Involved in Performance tuning, Developed Stored procedures, Functions and Packages.
• Knowledge on Cognos Transformer in developing Powerplay Cubes for Analysis Studio.
• Experience in working with multiple relational databases like SQL and ORACLE.
• Very strong analytical and problem solving skills.
• Self-motivated, able to work with minimal supervision.
• Result oriented software developer with excellent track record of successful completion of projects, project milestones and quality standards.
• Worked in health care and banking domain projects.
• Exceptional ability as a quick-learner about new concepts and technologies.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos BI Tools (Report studio, Query Studio, Analysis Studio, Metric Studio and Framework Manager and Transformer), Cognos workspace and cognos workspace advanced:

Languages: C, C++, SQL, PL/SQL

Databases: Oracle, SQL Server

Operating System: Microsoft Windows (XP, Vista, 8&10)

Web Technologies: Knowledge on HTML, CSS, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Mechanicsburg, PA

Sr.cognos Developer

Responsibilities:

• Involved in discussion with the clients to better understand the business requirements
• Created different kinds of business reports as per the client’s requirements.
• Developed different packages like Drug Package, Drug adhoc Package, and Pharmacy claim using IBM cognos Framework manager.
• Worked closely on cognos framework manager model adjustments to accommodate new and existing requirements based on business needs.
• Good knowledge on drugs, drug categories and pharmacy claims.
• Actively involved with Business analysts and end users to analyze the business process and user requirements to gather their needs for generating reports in Query and Report Studio.
• Worked on performance tuning of the complex reports for better performance after migrating them to 10.2.2 series.
• CognosIncentive Compensation Management (ICM) Implementation.
• Worked with Solution Architect to buildICMworkflow calculations.
• Used features like Conditional Blocks, HTML, Rendering Variables, Prompts, Conditional Formatting, master-detail etc.
• Involved in development, testing, deployment and scheduling of cognos reports.
• Created sql queries to test the cognos reports and their performance.
• Trained Business users on creating and viewing reports using Query Studio, Report studio and Cognos workspace.
• Incorporated Report Studio, Query Studio to develop reports to be used by the end users for viewing the day to day affairs of the business.

Environment: Cognos 10/10.2.2 suite (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos office Connection), Data studio with DB2.

Confidential, PA

Cognos Developer

Responsibilities:

• Worked closely with Business analysts and end users to analyze the business process and user requirements to gather their needs for generating reports.
• Communicated with a wide variety of cross-functional users to gather and analyze information to develop actionable plans for improving information quality.
• Created nested SQL queries for retrieving data from multiple data sources.
• Worked on Report Studio and Analysis Studio to develop reports having multiple dimensions like Time Dimension, Cost center, revenue, locations, etc., for analysis purpose to be used by the top level management.
• Metadata modeling usingIBMCognosFramework Manager and OLAP modeling with Transformer.
• Developed stored procedures and functions to manipulate data for generating various reports.
• Incorporated Report Studio, Query Studio to develop reports to be used by the end users for viewing the day to day affairs of the business in Cognos 8.4/10.1 suite.
• Developed complex reports - Conditional Block Reports, Drill-Through Reports, Advance Sorting Reports, Active Reports, Dashboard Reports, Master-Detail Reports and Burst Reports using cognos Report Studio.
• Worked on performance tuning of the complex reports for better performance after migrating them to 10 series.
• Used features like Conditional Blocks, HTML, Rendering Variables, Prompts, Conditional Formatting etc.
• Spearheaded Query and Report Studio training to ensure complete understanding ofIBMCognos8 and metadata, resulting in a significant reduction of thousands of dollars in training expenses.
• Involved in development, testing, deployment and scheduling of cognos reports.
• Worked on resolving the performance issues of the cognos reports and increased the performance of the reports by tuning SQL.

Environment:Cognos 8.4/10.1 suite (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos office Connection), Cognos TM1, XML, HTML, DB2, SQL Server 2014.

Confidential, Wilmington, DE

Sr. Cognos Developer

Responsibilities:

• Involved in gathering business requirements from Business Analysts and Users.
• Interacted with the Development and Management teams, provided technical assistance to developers.
• Used Framework Manager to build metadata model, which could be used by the Report Developers in the group.
• Generated various List Reports, Grouped Reports, Crosstab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated complex reports in cognos 8.3 report studio including Drill-Down Reports from DMR modelled Framework Model.
• Created dashboards to present critical company data into a single report.
• Created List Reports and Crosstab reports using cognos 8.3.
• Worked on relational and dimensional reporting styles in Report studio.
• Created, published and modified several packages in Framework manager according to the business needs.
• Developed standard Templates which laid foundation for all reporting needs.
• Developed Standard Reports, Dashboard Reports, Charts, Drill-Through Reports, Master detail reports, Bursting Reports using Report Studio and Query Studio.
• Created reports using Query prompts, Calculations, Conditions and Filters.
• Scheduling and Distributing Reports through schedule management in cognos connection Query Optimization, Performance Tuning of Reports and Model.
• Created user classes and profiles in Cognos Connection.
• Worked on improving report performance.
• Provided training to users on Query Studio for Adhoc-Reporting.
• Involved in documentation for user training.

Environment: Cognos 8.3, CognosReportNet 1.1MR3 (framework Manager, Cognos Connection, Query Studio, Report Studio), Impromptu v7.3, Powerplay v7.3, PowerplayTransformer, Upfront, Access Manager and SQL server.

Confidential, Nashville, TN

Cognos Developer

Responsibilities:

• Collecting and analyzing information requirements from users and translate those needs into requirements documentation.
• Worked with Data warehouse team as needed to define new data warehouse tables needed for reporting.
• Developed List, Crosstab. Drill-Through, Master-Detail, Chart and Complex Reports which involved multiple prompts, Multi query and Burst reports against database.
• Worked on the Dashboards using Business Insight and Business Insight Advanced.
• Involved in Installation, Configuring and troubleshooting of Cognos 8.2.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Developed various reports using conditional Blocks and drill-through.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.
• Coordinate/assist/develop cognos framework manager model adjustments to accommodate new and existing requirements.
• Scheduled and distributed reports using Schedule management in Cognos Connection.
• Trained end users to use the reporting tool to build and customize their BI and BIA reports effectively.
• Writing Client documents like Technical Design documents, Unit test execution plan and test cases.
• Fine-tuned the performance of the reports by creating appropriate indexes and using performance parameters.

Environment: Cognos 10.1(Cognos Connection, Framework manger, Report Studio, Analysis Studio, Business Insight, Business Insight Advanced), cognos Go office,cognos TM1(contributor, Architect, Perspectives and Turbo Integrator), Teradata, Java Scripts(HTML)

Confidential

Cognos Developer

Responsibilities:

• Meeting with the business users to understand their needs and gather requirements.
• Documented the specifications, Constraints, workarounds of the business needs.
• Analyzed the data definition and understanding data integrity.
• Evaluated the technical requirements and interacted with the business users for reporting needs.
• Requesting data mart tables and designing the requirements/needs for ETL processes.
• Request indexes, fine tune queries to optimize report processing.
• Participated with other teams of technical staff (Oracle and Informatica) for design, development and deployment.
• Developed various Mapping, Mapplets, sessions and workflow in cognos.
• Modelled query subjects in Framework Manager for business logic to achieve business process & improved query performance andresponse time.
• Worked on role based security of Adhoc reporting.
• Developed catalogs in cognos Impromptu.
• Designed models and also involved in creating dimensions.
• Created various reports such as List reports, Crosstab reports, Drill-Through reports, Chart reports, Dashboards and reports with conditional formatting using different tools.
• Worked on role based security in Framework manger using security filters.
• Involved in upgrading cognos series 7.x reports to cognos Reportnet and then to cognos 8.
• Worked on production issues, errors, anomalies and emergencies.
• Assessed the complexity of change requests during production.
• Assisted users in troubleshooting their reports.

Environment: Cognos BI 8(Framework Manager, Report Studio, Query Studio, Analysis Studio, ReportNet), Oracle, SQL Server, windows 2003/XP.