We provide IT Staff Augmentation Services!

Sr. Cognos Developer Resume

Plano, TX

PROFESSIONAL SUMMARY:

  • 11 years of experience in developing Cognos Applications with Cognos Analytics 11 BI, Cognos 10 BI, Cognos 8.4/8.2 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Transformer, and Metric Studio
  • Strong knowledge of Cognos (11.x/10.x/8.x) Report Studio, Analysis Studio, and Query Studio and extensive experience in building Reports - Drill Through, Visualization, Charts, Cross Tabs, Summary Reports, etc.
  • Experience in Performance Management initiatives through application of Balanced Scorecard methodology using Cognos Metric Studio
  • Created Dashboards and reports for Financial Reporting and Competitive Benchmarking
  • Worked in Performance Optimization of Reports and Powercubes
  • Performed Metadata Modeling in Framework Manager including developing packages
  • Experience in building Relational and Dimensional (DMR) models as per end user needs
  • Created Multidimensional MOLAP Cubes in Transformer using Relational, Dimensional (DMR)
  • OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling
  • Interacted extensively with end users for requirement gathering and user testing and provided and support
  • Strong analytical, problem solving and troubleshooting skills, excellent written and oral communication skills, strong team player and leadership capabilities

TECHNICAL SKILLS:

BI Tools: Cognos 11.7, Cognos 10 (Metric Studio, Report Studio (including Active Reports), Business Insight, Analysis Studio, Transformer, Framework Manager, Administration) Cognos 8.4/8.3/8.2 (Metric Studio, Report Studio, Query Studio, Analysis Studio, PowerPlay, Transformer, Framework Manager, Administration, Tableau, SSRS)

Databases: SQL Server 2012 R2, 2005/2008, IBM DB2

T: SQL, PL/SQL

Operating Systems: Windows 7/XP and Windows Servers 2000/2003/2008 , Windows 10 Enterprise

Microsoft Tools: MS Office Suite (Word, Excel, PowerPoint, Access)

Web Servers: Microsoft IIS 6/7/7.5, Tomcat

Testing Tools: Road Runner, QA Wizard pro, APP Loader (stress testing and web testing)

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. Cognos Developer

Responsibilities:

  • Developed Complex Reports using Cognos Analytics 11 suite.
  • Developed many interactive Dashboard using the new Dashboard feature in Cognos Analytics.
  • Gathered and analyzed business requirements.
  • Developed packages for project managers in Framework manager.
  • Created Data modules for the reports based on report requirements.
  • Migrated Tableau reports and dashboard to Cognos 11.7.
  • Created many weekly and monthly visualization reports for the client managers and business users.
  • Querying the Data warehouse using SQL and Snowflake.
  • Developed list, crosstab, drill through, master-detail, chart and complex reports and dashboards. With multiple prompts, filters, functions, conditional formatting, multiple pages and multiple queries using Cognos Analytics 11.7.

Technical Environment: Cognos Analytics 11 suite (Transformer, Report Studio, Framework Manager, Analysis Studio), Tableau, SQL Server 2012 R2, SnowFlake, Teradata, Windows 7, Windows 2008 Server. Windows 10 Enterprise.

Confidential, GRAPEVINE, TX

Sr. Cognos Developer

Responsibilities:

  • Created self serve package for business users in Framework manager.
  • Gathered requirements and created technical specifications based on interviews with business users.
  • Provided to business users on workspace advance .
  • Added more functionality and tools to workspace advance mirroring report studio.
  • Created reports and visualizations using Tableau.
  • Querying the Data Warehouse using SQL and Teradata, creating Views and Stored Procedures.
  • QA and unit testing the data in Teradata.
  • Designed reports using most of Report Studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up etc.)
  • Worked extensively with different types of prompts such as tree prompt, value prompt, interval prompt, generated prompt, date and time prompt; constructed cascading prompts.
  • Developed complex reports for different campaigns, promotions, sales and inventory.

Technical Environment: Cognos 10 (Metric Studio, Transformer, Report Studio, Framework Manager, workspace advance, Query Studio, Analysis Studio), SQL Server 2012 R2, Teradata, Windows 7, Windows 2008 Server.

Confidential, IRVING, TX

Sr. Cognos Developer

Responsibilities:

  • Developed complex Reports in Cognos Report studio.
  • Developed Dashboard in Report Studio and Cognos WorkSpace Advance.
  • Developed and distribute reporting package to clients including monthly forecasts.
  • Automated reporting functions resulting in reduction of manual reports.
  • Design and deliver end user and materials, provide technical support.
  • Developed complex Reports in SSRS.
  • Created models in FrameWork Manager.
  • Build Cubes in Transformer.
  • Built interactive active reports in Cognos 10.
  • Built and maintained Framework manager metadata models.
  • Querying the Data Warehouse using SQL, creating Views and Stored Procedures.
  • Developed list, crosstab, drill through, master-detail, chart and complex reports and dashboards. With multiple prompts, filters, functions, conditional formatting, multiple pages and multiple queries using Report Studio.
  • Build Burst Report packages - roughly about 700 packets for monthly reports.
  • Ad-hoc querying and report development using Query Studio and Analysis Studio.
  • Experience in Cognos Administration, including scheduling.

Technical Environment: Cognos 10 (Metric Studio, Transformer, Report Studio, Framework Manager, Business Insight, Query Studio, Analysis Studio), SQL Server 2012 R2, Windows 7, Windows 2008 Server.

Confidential, DALLAS, TX

Sr. Cognos Developer

Responsibilities:

  • Worked with business users from various departments to crystallize organizational objectives for the Balanced Scorecard, summary reports, detail reports and cubes.
  • Gathered requirements and created technical specifications based on interviews with business users.
  • Built complex summary reports using Cognos Report Studio
  • Designed the work flow for organization wide performance management initiative.
  • Created a Balanced Scorecard in Cognos Metric Studio using Transformer Powercubes and Flat files and relational data sources.
  • Improved Performance of Transformer Powercubes by utilizing multiple performance optimization techniques.
  • Built various Transformer Cubes and wrote/modified batch (.bat) scripts to schedule and run the cubes in daily, weekly and monthly intervals
  • Designed a new model and created Powercubes in Transformer for the Finance department by using Framework Manager Query subjects as Data Source.
  • Created Active Reports for tracking Sales Incentive and Project Implementation metrics.

Technical Environment: Cognos 10 (Metric Studio, Transformer, Report Studio, Framework Manager, Business Insight, Query Studio, Analysis Studio), SQL Server 2008 R2, Windows 7, Windows 2008 Server.

Confidential

Cognos Consultant

Responsibilities:

  • Actively gathered user requirements and prepared technical specifications.
  • Assisted in creating multiple complex Transformer Models using the Framework Manager tables as data sources.
  • Designed reports using most of Report Studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up etc.)
  • Worked extensively with different types of prompts such as tree prompt, value prompt, interval prompt, generated prompt, date and time prompt; constructed cascading prompts.
  • Extensively used several relational and dimensional databases for creating complex dashboard reports and summary reports as per user requirements.
  • Created templates for standardizing reporting formats within organization.
  • Scheduled and Burst reports to users in different departments and at various levels.
  • Involved in Performance Optimization of existing reports by utilizing various performance tuning methods.
  • Scheduled Jobs and Reports in Cognos Connection.
  • Performed Data validations, Unit testing and preparation of Unit test cases.
  • Tested reports using review checklists for Quality Assurance before delivering to the end users.

Technical Environment: Cognos 8.4 (Cognos Connection, Transformer, PowerPlay, Framework Manager, Query Studio, Report Studio, and Analysis Studio), SQL Server 2005

Confidential, STAMFORD, CT

Cognos BI Consultant

Responsibilities:

  • Gathered and analyzed business requirements received from analysts.
  • Developed Framework Manager Models by importing metadata from different relational databases.
  • Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
  • Developed Calculations and Filters in the Framework Manager Model.
  • Developed List, Cross Tab, Drill Through, Master-Detail, Chart and complex reports which involved multiple Prompts, multi-query Cubes in Report Studio.
  • Created custom prompt reports in Report Studio, Bursting reports to different user groups.
  • Created Ad-Hoc reports using Query Studio.
  • Created reports that involved multidimensional analysis and exploration of large data sources.
  • Created multiple paged professional reports with table of contents, page headers and footers, page numbers and page breaks, and bookmarks.
  • Worked on performance optimization of the reports.
  • Involved in the Testing of the reports and updating of the Bug Tracking Tool.
  • Scheduled reports to use off peak hours effectively.

Technical Environment: Cognos 8.4 (Transformer, PowerPlay, Framework Manager, Query Studio, Report Studio, and Analysis Studio), SQL Server 2005, Windows 2003 Server

Confidential, BOSTON, MA

Cognos Developer

Responsibilities:

  • Reviewed end user requirements and converted the same into technical specifications.
  • Used Framework Manager in Cognos 8.3 to model metadata from different data sources for use in Report Studio and Query Studio.
  • Troubleshooted the already existing Framework Manager Models and made changes to optimize performance.
  • Created Master-Detail and Drill-Through reports using Report Studio in Cognos 8.3.
  • Created complex reports in Report Studio with cascading prompts, drill-through, filters, relative dates and multi-measure charts on relational and OLAP Data sources.
  • Scheduled bursting of reports and distribution of Cognos 8.3 reports using portal administration.
  • Tested and improved report performance using query optimization techniques.
  • Created relationships between query subjects to better represent the logical structure of the business and the user requirements.
  • Involved in designing and building the Powerplay cubes using Transformer.
  • Implemented Security with AD and Group level security in Cognos Connection Portal.
  • Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
  • Worked on complex reports using Tabular Objects, Static Prompt conditions.
  • Worked with Stored Procedure Query Subjects in Report Studio.

Technical Environment: Cognos 8.3 BI (Report Studio, Query Studio, Framework Manager), Cognos EP Series 7.3 (PowerPlay, Transformer, Access Manager, Upfront), SQL Server 2000, Windows XP Professional

Confidential, PLEASANT PRAIRIE, WI

Cognos Developer

Responsibilities:

  • Involved in the entire project life cycle from evaluation, development, testing and production of end user reports.
  • Involved in creating high priority reports from start to requirement gathering to production.
  • Created complex reports using Report Studio and performed ad-hoc queries using Query Studio.
  • Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional formats, and grouping to generate efficient and user-friendly reports.
  • Participated in meetings with users to validate the results of the development, during various stages of report development and before deployment.
  • Performed scheduling and maintenance of reports using Cognos Connection.
  • Provided knowledge transition and created documentation.

Technical Environment: Cognos 8.2 (Query Studio, Report Studio, Analysis Studio, Framework Manager), Cognos Series 7.3 (PowerPlay, Transformer, Access Manager, Upfront), SQL Server 2000, Windows XP Professional.

Hire Now