SUMMARY:

• Over 5 years of total IT industry experience as Cognos Certified Professional in analysis, design, testing, development and implementation of client/server applications.
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 8/10.
• Good understanding with Cognos architecture.
• Sound skills in Cognos 10 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Having experience on dashboard reports building using report studio.
• Developed database schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in DMR model designing using Framework manager.
• Good experience in Report building using Report Studio.
• Work Experience in Transformer model design and Power play cube building
• Experience in Installation and configuring the Cognos 10/8.
• Experience in OLTP/OLAP system study, analysis, E - R modeling and developing database schemas like star schema and snowflake schema.
• Working Knowledge on Work Space Advanced.
• Experience in Migrating reports from Cognos 8 to Cognos 10 Environment.
• Monitoring different environments in Cognos like Dev, UAT and Production.
• Having knowledge on ETL tools like Informatica, Data Stage.
• Skills in developing SQL programming.
• Experience in interacting with end users to gather requirements for reporting.
• Involved in Performance Tuning of Reports to reduce report execution time.
• Having knowledge in Tableau.
• Having Work Experience in Cognos Life Cycle Manger while migrating from Cognos 10.1 to Cognos 10.2.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS:

Reporting Tools: Cognos 10.2/10.1/8.2/8.3/8.4/8.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio)

ETL: Informatica, Data Stage.

Databases: Oracle 8i/9i/10g, SQL Server 2000/5.0, DB2, Teradata, IBM Neteeza

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, and Linux

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the end users.
• Involved in Designing models using Framework Manager and published packages to the Cognos Reporting Servers.
• Analyzed the PeopleSoft tables in campus solutions and constructed the queries and did operational reporting according to the requirements.
• Involved in upgrading the Cognos application from Cognos 10.2.1 to IBM Cognos Analytics 11.0.
• Worked in using Cognos10 Administration tool in the areas of Directory, Drill-through Definitions, Portal Administration, Capabilities, Schedule Management, Server Administration, Content Administration, My Preferences and User management & administration.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Used PeopleSoft Transaction tables as data sources for Cognos reporting.
• Resolved issues with production reports and trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Performed thorough Unit testing of the reports and making sure the data matches with the source system.
• Deployment of reporting application from one environment to other environment.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Technical Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, People Soft, Oracle, SQL Server 2008, Windows 2008, SQL.

Confidential

Senior Cognos Developer

Responsibilities:

• Work closely with business stakeholders to understand business needs, and design and develop analytics.
• Support, administration and development of business reports using Cognos.
• Developed Framework Manager Models by following best practices and also modified to in corporate the new data elements as per the business needs.
• Developed Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports using Report Studio and Query Studio.
• Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users.
• Developed Balanced queries to verify report output against database queries and also to see the data variance between source environment WMS and target EDW.
• Deployment of packages from WMS to EDW environment.
• Used Cognos Event Studio to report runs and notifications and also migrated large set of events from Cognos 10.1 to Cognos 10.2.1.
• Performed post migration testing of cognos reports by querying database directly.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Involved in Unit testing and deployment to UAT and Production.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Technical Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, Oracle 11g, SQL Server 2008, Windows 2008, SQL, PL/SQL.

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the business and end users.
• Converted good deal of reports that are written in Crystal Reports to Cognos Reports and few of them include Class Enrollment Summary, Combined Sections, Dean Grad List, Incomplete Grades by Program, Degrees Awarded by Plan, Student Withdrawals and Undergrad Double Plan List etc.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Used people soft Transaction tables as data sources for Cognos reporting.
• Running General Reports and Queries in People Soft Report Database.
• Performed thorough Unit testing of the reports and making sure the data matches with the source system crystal reports.
• Deployment of reporting application from one environment to other environment.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Technical Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, People Soft, Oracle, SQL Server 2008, Windows 2008, SQL, PL/SQL.

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the business and end users.
• Used Framework Manager to build models, packages and publish packages to Cognos Connection.
• Resolved issues with RxTrack production reports, working with the ticket distribution raised by users through service now and pulse, and working with the off-shore production team to drive issues to closure.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Analyzed reports and fixed bugs in stored procedures.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Involved in Unit testing and deployment to UAT and Production.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.
• Created reports using cognos workspace and cognos workspace advanced.
• Worked on Cognos Administration in assigning User groups, User roles with access permissions.
• Extracted data from databases using ETL tools like data stage and also involved in monitoring ETL jobs that run every day to load the data from source environment RxClaim to the downstream applications RxTrack.

Technical Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, Netezza, DB2 v8.0, SQL Server 2008, Windows 2008, SQL, PL/SQL.

Confidential

Cognos Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed efficient Stored Procedures to support SSIS Packages and Business Intelligence Reporting.
• Improved the performance of long running views and stored procedures.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed Pharma Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Extracted data from databases using ETL tools like data manager and data stage.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Technical Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), JavaScript and HTML, SQL Server 2008, Windows 2008, SQL, PL/SQL.

Confidential

Programmer Analyst

Responsibilities:

• Involved in developing reports, modifying filters, creating adhoc reports and format changing reports
• Managed performance and tuning of SQL queries and traced the slow running queries using SQL Server Profiler in order to improve performance.
• Worked on relationship database models, schemas and entity-relationship diagrams to create technical / system design documents.
• Exported data from SQL Server to load the data into the target application using SSIS for managing data.
• Created and maintained Cognos packages in Framework Manager.

Technical Environment: Cognos 10.1/8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer and Event Studio), SQL Server.