We provide IT Staff Augmentation Services!

Business Intelligence Engineer Resume

Minneapolis, MN

SUMMARY:

  • Senior Cognos Developer with 8 years of strong knowledge in design, development and support of Data Warehousing/BI Applications using Cognos BI.
  • Well - versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Event Studio, IBM Cognos Workspace, IBM Cognos Workspace Advanced and Cognos Connection.
  • Profound knowledge of Transformer model design and Power play cube building.
  • Strong experience in writing SQL Queries.
  • Developed graphical reports extensively in report studio creating various Drill-Through, Cross-Tabs and Summary Reports.
  • Strong knowledge in Framework manager for creating models, folders, filters, developing DMR models and publishing packages
  • Data visualization in Cognos Framework Manager.
  • Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
  • Developed complex layouts using List, cross tabs and Chart reports.
  • Created and published packages in Framework Manager from various data sources.
  • Experienced with Multiple Relational Databases including Oracle and MS SQL Server.
  • Developed Highly Interactive Reports for various Business groups using Cognos Active reports.
  • Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
  • Strong knowledge on Internet based reporting and strong Analytical skills and attention to detail.
  • Mid-level knowledge of Cognos administrative and security tasks.
  • Good team player with excellent Inter-personal skills and a quick learner.
  • Excellent understanding of SDLC and dimensional modeling techniques.
  • Experience in Functional Testing, well versed with Test processes and methodologies.
  • Experience in working with business users to provide expertise in problem definition, requirement analysis and the general design of BI system while providing support to multiple concurrent projects.
  • Knowledge of Cognos 11

TECHNICAL SKILLS:

  • Cognos BI Suite 11/10.1/8.x (Report Studio
  • Query Studio
  • Analysis Studio
  • Framework Manager
  • Transformer
  • Cognos Connection)
  • Windows Vista/ 2008
  • Windows 7
  • MS- Office
  • Microsoft Project
  • Visio
  • Access
  • Word
  • Excel Power Point.MS SQL Server 2000, 2005, 2008
  • Oracle 11g
  • 10g/9i
  • MS Access
  • DB2
  • SQL*Plus 3.3/8.0
  • Physical and logical
  • Star schema
  • Normalization.

PROFESSIONAL EXPERIENCE:

Business Intelligence Engineer

Confidential, Minneapolis, MN

Responsibilities:

  • Gathered Business Requirements to develop reports using IBM Cognos 10.2.
  • Worked on existing Cognos 10.2 Framework Manager model, star schema was implemented.
  • Created Cognos 10.2 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, and have successfully published the packages.
  • Created Relationships, filters, aggregations merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer.
  • Train the whole team with Framework Manager, Report Studio, Cognos Workspace Advanced, Event Studio and Query Studio.
  • Worked extensively on conditional variables utilizing conditional explorer in report studio.
  • Developed complex multi-page KPI reports with multiple prompts for Retail department.

Environment: IBM Cognos 10.2, IBM Cognos Analysis, Framework Manager, Report Studio, Query Studio, Cognos Connection, Event Studio, Oracle SQL, SQL Developer.

Senior Cognos Developer

Confidential, Loveland, CO

Responsibilities:

  • Gathered Business Requirements to develop reports using IBM Cognos 10.2.
  • Worked on existing Cognos 10.2 Framework Manager model, star schema was implemented.
  • Created Cognos 10.2 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, and have successfully published the packages.
  • Created Relationships, filters, aggregations merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer
  • Worked as an administrator to perform migrations and schedule maintenances.
  • Trained Business users in Business Insight Advanced and helped them leverage the tool to do self-service Analytics within Cognos
  • Created joins with queries in Report Studio to generate the required Report queries.
  • Worked extensively on conditional variables utilizing conditional explorer in report studio.
  • Worked on Cognos for MS Office and Cognos Café for Excel based reporting.
  • Worked on Installation and Configuration of Café cubes and Cognos Insight in distributed environments on windows.
  • Administered Cognos daily to maintain Data source configurations and various other parameters
  • Created events using Event Studio and trigger the reports to be sent to users directly.
  • Created Jobs for Auto-delivery of the reports to the user group.
  • Giving Access to users and setting up them in Cognos environment.
  • Trained End Users on usage of Syntax cubes and Reports.

Environment: IBM Cognos 10.1/10.2, Cognos 10 Business Insight, IBM Cognos Analysis, Framework Manager, Report Studio, Query Studio, Cognos Connection, Event Studio, MS SQL, Netezza, IBM Http Servers.

Senior Cognos Developer

Confidential, Houston, TX

Responsibilities:

  • Gathered Business Requirements to develop reports using IBM Cognos 10.1
  • Analyzed, designed, built and tested reporting solutions based on business requirements.
  • Worked on Cognos 10.2 Framework Manager model to build model using snowflake schema.
  • Created Cognos 10.2 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, and have successfully published the packages.
  • Created Relationships, filters, aggregations merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer
  • Created different reports using Query Studio and Report Studio.
  • Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
  • Worked extensively on conditional variables utilizing conditional explorer in report studio.
  • Created, organized and formatted reports, folders and other contents on Cognos
  • Created joins with queries in Report Studio to generate the required Report queries.
  • Extensively worked on Dashboards using report studio including render variables, singletons, prompts, filters, Conditional variables, layout component reference and formatting the objects within report design.
  • Involved in upgrading existing reports in Cognos 8.4 to Cognos 10.1and 10.1 to 10.2.
  • Installation of Cognos 10.1 Framework manager and transformers.
  • Worked on migration of 8.4 to 10.1 and 10.1 to 10.2 using Life Cycle Manager
  • Worked on Installation and Configuration of cognos 10 in distributed environments on windows.
  • Applied Security and User Authentication to the various User Groups.

Environment: IBM Cognos 10.1/10.2, Cognos 10 Business Insight, Cognos Work space, Framework Manager, Report Studio, Query Studio, Cognos Connection, SQL, IBM Http Servers, Cognos 11.

Senior Cognos Developer

Confidential, Redwood City, CA

Responsibilities:

  • Gathered Business Requirements to develop reports using IBM Cognos 10.1
  • Analyzed, designed, built and tested reporting solutions based on business requirements.
  • Created Cognos 8.4 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
  • Created Star Schema Models in Frame work manager.
  • Created different reports using Query Studio and Report Studio.
  • Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.
  • Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
  • Worked extensively on conditional variables utilizing conditional explorer in report studio.
  • Created, organized and formatted reports, folders and other contents on Cognos
  • Created joins with queries in Report Studio to generate the required Report queries.
  • Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.
  • Involved in upgrading existing reports in Cognos 8.4 to Cognos 10.1and 10.1 to 10.2.
  • Installation of Cognos 10.1 Framework manager and transformers.
  • Worked on migration of 8.4 to 10.1 and 10.1 to 10.2 using Life Cycle Manager
  • Worked on Installation and Configuration of cognos 10 in distributed environments on windows.
  • Applied Security and User Authentication to the various User Groups.

Environment: IBM Cognos 10.1/10.2, Cognos 10 Business Insight, Cognos Work space, Framework Manager, Report Studio, Query Studio, Cognos Connection, SQL, IBM Http Servers

Senior BI/Cognos Developer

Confidential, NJ

Responsibilities:

  • Analyzed the specifications and Designed Requirement specification documents for reports as per client requirements
  • Developed Relational and DMR Models using Framework Manager.
  • Created jobs, schedules and report views for the business processes.
  • Developed complex multi-page financial reports with multiple prompts for sales and finance departments.
  • Created different types of reports using prompts like Value, Search and Select Date, Time and Text box prompt.
  • Generated reports using SQL.
  • Customized Cognos Connection Portal based on user specifications.
  • Developed and Designed standard templates for future reporting needs of the project.
  • Built relational and dimensional packages using Framework Manager.
  • Customized Cognos Connection Portal based on user specifications.
  • Created context filters for particular view of data.
  • Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
  • Implemented Security for Data level access, Object level access and Package level access.
  • Worked on Ad-hoc reports Query Studio Analysis Studio to develop and demonstrate Relational reporting.
  • Created complex Dashboards using Business Insight in Report Studio.
  • Developed Active Reports for the power users.
  • Design and Developed the Framework Manager models using, Relational tables and published in to server.
  • Performed Unit testing and System Regression Testing for Report Studio reports.
  • Trained End Users on Ad-hoc Reporting.

Environment: Cognos10/8, Framework Manager 10/8, MS Excel 2010, MS Power Point 2010, MS Access 2010, Sharepoint, Oracle 10/11, Solaris 10

Senior Cognos Developer

Confidential, Minneapolis, MN

Responsibilities:

  • Extensively interacted with business users in understanding business application, business data flow and data relations
  • Worked with the business partners to gather detail business requirements and translate business requirements into potentially complex technical solutions that meet or exceed their business needs.
  • Participated in Developing and implementing an enterprise wide Reporting system using Cognos 10.1/8 Business Intelligence.
  • Participated in Interactions with the business users in requirements gathering and understanding the various logistics processes.
  • Designed, developed and supported complex Framework Manager Models for standard report studio on Cognos 10.
  • Created advanced joins in queries for complex reports.
  • Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down reports.
  • Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
  • Creation of Calculations, Prompts and Filters for usage in various Reports.
  • Designing Drill Up, Drill down & Drill through Reports depending upon the requirement.
  • Involved in extensive use of conditional formatting while developing reports in Report Studio.
  • Developed Active Reports, Lists and Crosstabs, Charts, Drill Through, and bursting reports in Report Studio; developed complex reports using prompts, conditional formatting, filters, drill-through features, multi pages, sub queries and multi queries.
  • Involved in the design development and implementation of Multidimensional Cubes for various purposes using Cognos Transformer
  • Develop business test conditions, test cases and scripts and coordinate user acceptance testing.
  • Deployed packages, folders and content store from a development environment to test environment.
  • Optimizing the existing reports in Production depending on the run time and acceptance from the business.
  • Tested and validated the report output against the database to measure performance of reports and implemented performance tuning (both at framework manager level and reports level).

Environment: Cognos 10.1/8.4/8.3 BI Series, Transformer, PLSQL, TOAD, Oracle 10g, MS SQL Server 2008, UNIX

Cognos Developer

Confidential, Pittsburgh, PA

Responsibilities:

  • Analyzed defects and fixed them.
  • Requirements Analysis. Perform analysis, design, and document report requirements
  • Modified Existing Reports as per User Requests and Developing Reports using Report Studio and Analysis Studio.
  • Report Development using both report studio and Query Studio.
  • Data Modeling and Framework Modeling.
  • Worked extensively with Relational and Dimensional Models.
  • Developed Weekly, Monthly, Yearly, MTD, QTD, YTD charts using Pareto Charts.
  • Scheduled and Run Reports using Schedule Management in Cognos Connection.
  • Designed Time based partition cubes using FM package as a data source.
  • Worked with various kinds of reports using List, Crosstabs and drill through reports. Also created various prompts for user interaction, cascading prompts and prototyping bursting of reports to respective departments.
  • Developed Templates, standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio.
  • Automated job scheduling and monitoring done through the Event Studio.
  • Support UAT testing for the deployments.
  • Extensively used ETL to load data from Oracle DB2, MS Access databases and Flat Files to Oracle databases.
  • Verified the data pulled by the reports through querying the data with SQL and PLSQL queries.
  • Generated reports using SQL.
  • Built models containing query subject, query items and namespace from scratch as well as from imported metadata.
  • Created conditional blocks, prompts for dynamic selection by users.
  • Developed reports with Union and relationship (joiner) queries.

Environment: Cognos 8.4/8.3 BI Series, Transformer, PLSQL, TOAD, Oracle 10g, MS SQL Server 2008, UNIX

BI Cognos Reports Developer

Confidential, VA

Responsibilities:

  • Business Requirement Gathering and Planning.
  • Extensive use of master - detail reports using repeaters and repeater tables.
  • Customized reports by adding filters, prompts, calculation, summaries and functions.
  • Created reports using stored procedures, packages, personal data files and free hand SQL.
  • Created drill through, Drill Down report charts and formatted the reports.
  • Developed standard templates, which were used in all reporting needs.
  • Used Cognos Connection for organizing, security, scheduling and distributing reports.
  • Data Modeling and Framework Modeling to build Meta data model, which could be used by other groups for reporting purposes.
  • Administered user access protocols and created user accounts and access privileges.
  • Provided support in different environments (development, testing and production).
  • Development and maintenance of cubes in Cognos Transformer.
  • Analyzed cubes by creating cube views using Analysis studio.
  • Bursting reports to different report groups.
  • Participated in JAD sessions.
  • Worked on resolving performance issues with Cognos reports by tuning the SQL.
  • Unit testing and shadow support for reports until the project is live.
  • Provided training to end users, prepared user documentation to train users for each and every report.

Environment: Cognos 8.4/8.3 BI Series, Transformer, PLSQL, TOAD, Oracle 10g, MS SQL Server 2008, UNIX

Cognos Developer

Confidential

Responsibilities:

  • Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
  • Creation of Calculations, Prompts and Filters for usage in various Reports.
  • Reports in Report Studio.
  • Developed Complex Reports by using Drill Through, Master detailed, Cascading Prompts and calculated fields in Report Studio.
  • Developed Standard Templates, which laid a foundation for all reporting needs.
  • Formulation of Joins, resolving relationship, cardinality in Framework Manager.
  • Created Conditional Blocks, Filters and other prompts for dynamic selection for users.
  • Distributed reports by bursting them while keeping the authentication to various data intact.
  • Extensively used Cognos 8 Query Studio, Report Studio.
  • Created Multidimensional reports, drilling down, slicing and dicing using Analysis Studio.
  • Created segments for cross tab reports.

Environment: Cognos 8.4/8.3 BI Series, Transformer, PLSQL, TOAD, Oracle 10g

Hire Now