PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience in Data Warehousing environment with Cognos Report Net suite and Cognos 10.1.1,8.x/7.x BI series with sound knowledge in different phases of Software Development Life cycle (SDLC) including requirement, analysis, design, development, testing and production support.
• Good experience on Cognos BI series Tools such as Cognos Report Net/Cognos 8.x, Cognos Impromptu 7.x/6.x, Cognos Impromptu Web Reports (IWR) 7.x/6.x, Cognos Transformer & Power Play 7.x/6.x, Power Play Enterprise Server (PPES) 7.x/6.x, Access Manager 7.0, Upfront 7.3.
• Expert in Cognos Report Net/Cognos 8 - Framework Manager, Cognos connection, Report Studio, Query Studio and Analysis Studio.
• Thorough knowledge in developing frameworks and dashboards using Cognos,
• Strong understanding of Business Intelligence (BI, OLAP, ROLAP) tools.
• Excellent one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
• Thorough knowledge of Star-Schema design methodology, dimensional modeling (Kimball) and Multi-Dimensional Database Architecture.
• Involved in migration of Impromptu Reports (including designing the catalog, identifying the table structure) as well as migration of Report Net 1.x reports to Cognos8, Cognos8 to cognos10.1.1
• Excellent skills with expertise in Data design, analysis using Oracle 7x/8i/9i, 10g, SQL Server, DB2, SQL, PL/SQL and ran SQL queries and validate the data in Data warehouse and Data Marts.
• Expert in developing and testing of reports and cubes using Cognos 7.x, 6.x tools in Windows.
• Knowledge in Agriculture (Farming), Banking, Insurance, Electric utility, Health care, Manufacturing, Pharmaceutical Domians.
• Excellent skills in advanced Report Authoring.
• Original and forward thinking, ability to lead, organize and work in a team.
• Strong experience in client interaction, understanding business applications, business data.
• Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.
• Excellent communication, presentation documentation very good team player.

TECHNICAL SKILLS:

BI Tools: Cognos10.1.1, 8.x(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Report Net (Report studio, Query Studio and Framework Manager), Cognos EP BI series (Cognos Impromptu, Power Play, Transformer) and Access Manager.OBIEE11.

Data Modeling Tools: Transformer & Framework Manager.

ETL Tools: Abinitio V1.13 GDE, I nformatica 7.1/6.1.

RDBMS: Oracle Database 10g/9i/8i, MS Access, Sql Server 2005/2008/2010.

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

Web Technologies: Microsoft IIS, HTML.

Operating Systems: Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr Cognos Developer.

Responsibilities:

• I am involved in requirement gathering and design, developing the cognos reports.
• Provided Production support through problem analysis and resolution to correct deficiencies.
• Developed effective SQL queries using Teradata, DB2, SQLServer, oracle and performed Unit Testing to ensure the accuracy of data displayed in the cognos report.
• Responsible for various tasks including user communication, follow ups, reports and developing the reports using cognos 10.2.1.
• Used to run SQL queries and validate the data against the Cognos reports.
• Analyze and fix any bugs raised during UAT and Enhanced the existing reports.

Environment: Cognos 10.2.1, - Framework Manager10.2.1, Cognos Connection, Report Studio, Query Studio, DB2, Teradata, oracle, SQLserver Windows 10.

Confidential, CA

Lead Cognos Developer / Admin

Responsibilities:

• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Created several multi pages reports based on multiple queries using Prompts and Parameters as per the requirements and adhoc-requests.
• Developed user acceptance documentation and placing Screen shots of actual Report and tested report in documentation.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Provided Production support through problem analysis and resolution to correct deficiencies.
• Involved in review sessions and demos with business users and draft design and solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
• Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).
• Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Extensively worked on Validating and testing report in Query Studio and Analysis Studio.
• Trained power users to use Query Studio for Ad-Hoc reporting and Analysis Studio.

Environment: Cognos 10.1.1 BI series - Framework Manager10.1.1, Cognos Connection, Report Studio, Query Studio, SQL SERVER2008, Windows 8.

Confidential, Chicago IL.

Sr Cognos Developer.

Responsibilities:

• Designed and Implemented metadata models in Framework Manager, preparing business logic
• Created complex reports using Cognos 8 BI Report Studio and Ad-hoc reports using Query Studio .
• Used DB2 to run SQL queries and validate the data against the Cognos reports.
• Involved in upgrading and testing the reports from cognos 8.4 to cognos 10.1.
• Created technical documentation for the Reports.

Environment: Cognos 8.4.1,cognos 10.1 BI series - Framework Manager8.4.1, Cognos Connection, Report Studio, Query Studio, DB2, Windows XP .

Confidential, Nashville TN.

Sr Cognos Developer.

Responsibilities:

• Involved in writing the technical specifications for the Reports and assisting the developers understand the technical requirement and help them build the reports.
• Provided Production Support and resolved maintenance issues.
• Upgraded cognos 8.3 to cognos 10 and tested and validated the Reports.

Environment: Cognos 8.3, Cognos 10.1 BI series - Framework Manager10.1, Cognos Connection, Report Studio, Query Studio, Oracle 10 g, Windows XP.

Confidential, Phoenix AZ.

Sr Cognos Developer

Responsibilities:

• Designed a Standardized Business models in Framework manager and published it for building reports in cognos 10.1.1 Report studio.
• Involved in writing the technical specifications for the Reports and assisting the developers understand the technical requirement and help them build the reports.
• Mentoring the junior developers in developing professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, drill through and have extensively used the new features in Cognos 10.1.
• Used oracle 10 g to run SQL queries and validate the data against the micro strategy reports.

Environment: Cognos 10.1 BI series - Framework Manager10.1, Cognos Connection, Report Studio, Query Studio, Oracle 10 g, Windows XP.

Confidential, Dallas TX.

Cognos Developer

Responsibilities:

• Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, multiple drill through and have extensively used the new features in Cognos 8.4.
• Used SQL Server to run SQL queries and validate the data in Data warehouse and Data Marts.
• Created cubes using Power play Transformer and implemented security into the cube model.
• Created IQDs’ in the framework manager packages and used them as data sources for Power Play Transformer models.
• Developed effective SQL queries and performed Unit Testing to ensure the accuracy of data displayed in the report.
• Also created documentation for all the processes involved like applying security for reports.

Environment: Cognos 8.4,cognos 10.1 BI series - Framework Manager, Cognos Connection, Report Studio, Query Studio, SQL Server 2008, Windows vista .

Confidential, Camp hill, PA

Sr cognos consultant.

Responsibilities:

• Created cubes using Power play Transformer and implemented security into the cube model.
• Created Dashboard Reports with the county Maps for the Trend analysis of funds spend by DPW on consumers across different counties of PA for each fiscal year.
• Designed a Standardized Business models in Framework manager and published it for building reports in cognos8 Report studio.
• Created complex custom queries to optimize the Report Studio report Performance in the model.
• Provided Production Support and resolved maintenance issues.
• Performed quality check for accuracy of data and performance of existing reports and Cubes
• Migrated reports from 8.4 to cognos 10.

Environment: Cognos8.4 BI series - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio cognos 10,Oracle10g windows xp.

Confidential, Fairhaven, Ma

Sr cognos consultant.

Responsibilities:

• Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, multiple drill through and have extensively used the new features in Cognos 8.4.
• Good understanding of the data and making some recommendations to change the data structure to suit the business requirements of reports. Transformed several Business Requirements into Report Specifications from business analysts.
• Developed effective SQL queries and performed Unit Testing to ensure the accuracy of data displayed in the report.

Environment: Cognos 8.4 BI series - Framework Manager, Cognos Connection, Report Studio, Query Studio, Report Net 1.1, BPW, M3 SQL Server 2005, Windows XP.