We provide IT Staff Augmentation Services!

Senior Cognos Architect/lead/senior Developer Resume

2.00/5 (Submit Your Rating)

Vernon Hills, IL

SUMMARY

  • Cognos Lead wif around 13 years of experience in leading teh Design and Development wif teh primary focus on teh Cognos 8.x Suite, Cognos 10.x Suite, Cognos 11.0.9, 11.0.5, Cognos Report Studio, Cognos Cube Designer, Cognos Transformer, Framework Manager, Cognos Power Play, PowerPlay Enterprise Server, Access Manager, Dashboards, Data Sets, Data Modules.
  • Extensively worked on agile scrum methodology and attended daily scrum meetings to keep in sync wif teh team’s progress and also by using rally, an agile platform to track teh team’s work online.
  • Worked extensively on Cognos 11 in creating reports, dashboards and Framework Manager models
  • Expert in reporting on Multi - Dimensional OLAP Cubes using complex MDX functions
  • Experienced in troubleshooting bugs in Cognos 11
  • Experienced in working wif SSAS cubes
  • Strong experience on Teradata as a backend support for Cognos reports.
  • Experienced in implementing large-scale applications wif leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC)
  • Extensive experience in Designing teh Framework Manager models, to meet BI industry standards applied Physical Layer, Business Layer and Presentation Layer approach to increase teh model durability
  • Worked extensively on reports and dashboards built on DMR models and cubes using complex MDX functions
  • Experienced in designing and development of DMR models.
  • Installed and configured Cognos 11 Sand box environment for POCs on teh new version
  • Experienced in using DQM wif teh DMR models using 10.x Cognos Suite.
  • Experienced wif Rapidly Adaptive Visualization Engine (RAVE)
  • Experienced in using Dynamic Query Analyzer to analyze teh performance of teh queries in Dynamic Query Mode.
  • Created models wif different data sources such as Oracle, SQL Server, SAP BW and MS Access
  • Created IQDs in teh Framework Manager which are considered as inputs for creating multi-dimensional cubes using Transformer
  • Created complex Active reports using report studio
  • Experienced in using teh visualization tool to add and modify extended/latest visualizations to use in Cognos 10.2.1 Report Studio
  • Extensive experience in creating Managed/Complex reports using Report Studio and creating ad-hoc reports using Query Studio
  • Created different kind of analytical reports including templates, List, Cross-Tab, Chart, Repeaters using Report Studio
  • Worked on integrating Max relationships wif Cognos to use wif Cognos Framework Manager from out of box Maximo
  • Supported in upgrading Maximo 6.2 to7.5 wif Cognos integration
  • Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Bursting and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
  • Experienced in Reports Deployment from development environment/server to Testing and Production environment/server using Content Administration
  • Hands on experience in reports migrating from Cognos 7 series to Cognos 8.x
  • Experienced in working in complex cluster installation configured Z-Linux Cognos Environments.
  • Troubleshoot issues wif existing reports and cubes, Expertise on creation and maintenance of models, which involved defining security, joins, cardinality, filters and governor settings Cognos 8.x and Cognos 10.x
  • Designed and Created power cubes for multi-dimensional analysis
  • Created multi-dimensional reports using Analysis Studio and applied context filters for better analysis
  • Involved in managing Custom autantication for Cognos environments.
  • Experienced in performing installations of Cognos BI server on new environments and CDL environments.
  • Having experience in implementing security for Cubes and Package, Object and Data level security for Packages
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database schemas (Star Schema and Snowflake Schema) used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

  • Cognos BI Suite 11.0.7/10.x/8.x/7.x
  • Query Studio
  • Report Studio
  • Analysis Studio
  • Event Studio
  • Cognos Connection
  • Framework Manager
  • Active Reports
  • PowerPlay Transformer
  • Impromptu Administration
  • Data Manager Upfront
  • IWR and PPES
  • Query Studio
  • Report Studio
  • Framework Manager
  • Metric Studio
  • Maximo
  • Netezza
  • Aginity
  • Oracle 8i/9i/10g/11g
  • MS SQL Server 2000/2005/2008/2012
  • MS Access 7.0
  • SAP-BW
  • Toad
  • SQL-Plus
  • SQL Server Management Studio
  • Visio 2003
  • Erwin Windows-98/NT/2000/XP/Vista
  • Linux
  • Solaris
  • UNIX
  • IBM AIX
  • HP-UX
  • DOS
  • SQL
  • PL/SQL

PROFESSIONAL EXPERIENCE

Senior Cognos Architect/Lead/Senior Developer

Confidential, Vernon Hills, IL

Responsibilities:

  • Lead development efforts for teh Cognos team
  • Created reports and dashboards based out of MSSAS cubes
  • Created and maintained complex Multi-Dimensional Cognos reports using MDX functions
  • Played a key role in maintaining expectations and providing estimates for multiple projects and quick-hits (Break-Fixes)
  • Lead successful core team of diverse resources comprised of employees, contractors and off shore resources
  • Assisted marketing executives in defining their reporting needs through formal requirements gathering exercises. Documented requirements to facilitate teh data warehouse and reporting designs.
  • Worked on Framework Manager, Report Studio on a day-to-day basis to support on-going requirements from business users
  • Worked on creating schedules based on triggers and event studio based report delivery mechanisms
  • Worked closely wif teh finance team to provide daily financial summary based reporting
  • Ability to understand and speak teh language of both teh business and technical communities using effective communication skills in presentation and leadership roles.
  • Worked wif tools like Meta Manager and Net Vision to perform frequent audits on licenses and reports
  • Worked wif finance team to reconcile teh differences between source systems and teh data warehouse
  • Worked on migrating 10.2.2 to 11.0.9 and 11.1.5 and testing teh reports to identify bugs
  • Integration of KPI’s that succinctly illustrate teh status of teh measures that matter most
  • Worked wif IT resources from other teams to learn environment, its complexities, limitations and data restrictions
  • Worked on Query Studio, Analysis studio and Pyramid to analyze financial data for reporting needs and reconciliation
  • Maintained Administration of three Cognos Instances wif DEV, QA and Production environments for each
  • Extensive dimensional report development based on MSSAS cubes
  • Configured trigger utilities to maintain ETL Trigger based schedules and other Admin related configurations
  • Ownership of PMRs and coordination wif IBM to resolve issues during and after upgrades
  • Worked wif implementing named sets from MSSAS cubes in report studio for multi-dimensional reporting
  • Created Data Sets and Data modules to use in Cognos Dashboarding in 11.1.5
  • Worked on automating various reporting process to eliminate manual dependencies theirby reducing cost and ensuring effective use of resources
  • Worked wif business users and leadership team to prioritize teh projects based on ROI
  • Troubleshooting SQL Queries and MDX Queries on SQL server database to identify issues wifin teh data in teh report
  • Created Cognos reports to identify issues wif data in SSAS cubes while still in teh processing server before being moved to teh query server in-order to proactively avoid issues theirby reducing turn-around time for bug/data fixes

Environment: Cognos 10.2.2/11.0. 7 , Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Cognos Analytics, Dashboards, Framework Manager, Microsoft SQL Server 2012, Microsoft SQL Server Analysis Services, NetVisn, Meta Manager 5.4, SSMS 2012

Senior Cognos Developer

Confidential, New York City, NY

Responsibilities:

  • Worked on creating new interactive dashboards in Cognos 11
  • Created very complex active reports and live reports
  • Worked wif teh team in analyzing teh requirements and coordinating wif teh client to get feedback as needed
  • Data and functional testing performed on each of teh developed reports/dashboards
  • Created work arounds for a few bugs identified wifin Cognos 11
  • Worked on multiple projects and switched depending on teh client’s needs
  • Performed Extensive development role while leading teh project along wif other team members
  • Worked on creating DMR models in FM
  • Worked on reports involving complex MDX functions
  • Worked on Tree prompts based of Dimensional data
  • Worked on applying changes and fixes to Framework Manager model including security based on session parameters and other filters
  • Worked on building multi-lingual compatibility on all teh reports/dashboards
  • Helped business users build dashboards on Cognos Analytics

Environment: Cognos 10.2.2/11.0. X, Report Studio, Cognos Analytics, Active Reports, Dashboards, Framework Manager, Microsoft SQL Server 2012, Aginity

Senior Cognos Admin/Lead/Architect

Confidential, Loveland, CO

Responsibilities:

  • Worked on creating new reports out of Cognos for various business entities
  • Trained Business users in Business Insight Advanced and halped them leverage teh tool to do self-service Analytics wifin Cognos
  • Worked closely wif teh business users to understand their needs and derive requirements from their feedback
  • Worked on Data Profiling to build PIs in Teradata
  • Setup ODBC connections for Teradata to connect wif Cognos
  • Worked wif Teradata Semantic Views layer when modeling wif Cognos
  • Configured parameters based on best practices for Teradata based reports
  • Worked as an Administrator to perform day-to-day and scheduled maintenances on teh environment and maintain stability.
  • Working in a Process Based Leadership (PBL) environment
  • Supported Operations on daily basis wif working on tickets raised by business wifin Service-Now
  • Worked wif reports built of custom Java scripts embedded wifin teh Server
  • Worked wif PeopleSoft and ARS interfaces
  • Worked wif Data Modelling and ETL teams to build/modify tables and jobs to support teh reporting needs
  • Built on P&L reporting involving complex MDCX functions out of Cognos leveraging teh transformer cubes
  • Built Inventory Accounting and AP/AR dashboards using dimensional data by making use of complex MDX functions in report studio
  • Managed a team of four by halping them out wif their daily activities in teh reporting requirements
  • Worked wif team members in performing Peer reviews on code
  • Worked in managing Security using active directory and access manager
  • Worked on creating reports leveraging various tools wifin Cognos
  • Participated extensively in Data mapping exercises wif teh DB team
  • Worked on migrating Cognos from version 10.1.1 to 10.2.2
  • Installed and Configured Cognos 11 Sand Box environment to build POCs on teh new version
  • Worked on creating a few reports for business users in Tableau
  • Designed, Constructing, Testing and Deploying teh Cognos Framework Manager Models, Packages, Reports and Power play Models.
  • Worked on Cognos for MS Office and Cognos Café for Excel based reporting
  • Worked on building complex reports and dashboards out of Cognos Dynamic Cubes
  • Worked on implementing row level security on Cognos Dynamic Cubes in version 10.2.2
  • Worked on complex MDX functions to report out of dimensional data
  • Administered Cognos on a daily basis to maintain Data source configurations and various other parameters
  • Created jobs based of triggers upon ETL loads and various other task completions

Environment: Cognos 10.2.2/10.1.1 , Transformer, Netezza, Aginity, Report Studio, Query Studio, Business Insight and Business Insight Advanced, Active Reports, Dashboards, Cognos Mobile, Power Cubes, TOAD, PL/SQL, Oracle 11g, Microsoft SQL Server 2012, Data stage.

Cognos Lead

Confidential, Chattanooga, TN

Responsibilities:

  • Worked on Administering and configuring teh Cognos environment for teh reporting requirements
  • Designing, Constructing, Testing and Deploying teh Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
  • Managing a full sized Cognos team in managing teh day to day activities for teh report development and analysis
  • Worked on integrating Max relationships wif Cognos to use wif Cognos Framework Manager from out of box Maximo
  • Supported in upgrading Maximo 6.2 to7.5 wif Cognos integration
  • Helping teh ETL team to load dummy data for mock-ups whenever needed.
  • Guiding teh ETL and DB team in setting up teh transformation logic as per teh report requirement
  • Created reporting solutions based on teh requirements from teh business users and end users
  • Managed daily meeting wif teh business team in discussing teh mapping and teh report development strategy
  • Actively participated in migration process of 10.1.0 Cognos to 10.2.1
  • Defining teh Users, Group and Roles in LDAP using Cognos Access Manager.
  • Preparing User manuals, Operational Guides, Planning and Conducting User trainings
  • Installed and Configured Cognos for test environments
  • Installed Fix Packs on existing Cognos Environments
  • Worked on maintaining teh communication wif teh IBM Support to manage teh existing PMR’s and on any new issues being encountered
  • Worked on creating a road map for development and migration of teh reports developed in Cognos using ODS Data source to work wif Oracle DataMart teh it TEMPhas been migrated to
  • Worked on supporting teh Database team in creating a replicated database out of teh data mart wif monthly refresh of data
  • Worked closely wif teh Cognos developers in developing teh reports and framework manager models based on teh requirement
  • Experienced as a scrum master in running teh daily scrum meetings and managing teh team’s tasks on a daily basis
  • Created FM Models wif using Multiple Data Sources and complex parameterized mapping features
  • Worked on creating complex reports in report studio using MDX functions to use wif DMR models
  • Worked on writing complex SQL Queries to modify and suggest any fixes on performance improvement of teh existing reports.

Environment: Cognos 10.x (Framework Manager, Transformer, Cube Designer, Cognos Connection, Report Studio, Rapid adaptive visualization tool(RAVE), Visualization Tool, Query Studio,Analysis Studio), Maximo 6.2/7.5, Informatica, Oracle 11g, SQL Server, ERWIN, TOAD, Windows 2000/2003/XP/7.

Cognos Lead

Confidential, Salem, NH

Responsibilities:

  • Participating in daily scrum stand-up calls to exchange updates wif teh team and also discuss any challenges/defects encountered.
  • Collaborated in executing a BI Strategy and Roadmap by contributing individually and collaborating wif teh team members by providing guidance and assistance on training and usage of IBM Cognos 10.x and concepts.
  • Managed teh offshore team on day to day activities guiding them in teh development activities throughout teh development cycle
  • Experienced as a scrum master in running teh daily scrum meetings and managing teh team’s tasks on a daily basis
  • Active participation in analyzing teh requirement by having frequent sessions wif teh business team
  • Worked wif Semantic Layer from Teradata to create reports and dashboards
  • Worked on setting up data sources for Teradata by installing teh necessary db drivers
  • Worked on Data profiling to identify PIs in Teradata tables
  • Actively participated in migration process of 10.1.0 Cognos to 10.2.1 in a Z Linux Environment as well as Windows environment
  • Involved in creation of AdHoc Reporting environment using Cognos SDK and integrating teh same wif teh Client Portal.
  • Application of Custom Autantication to teh Cognos environment
  • Worked on Cognos Life Cycle Manager to compare teh reports and outputs in multiple environments during teh migration process to retain report compatibility and consistency
  • Worked on Fact and Dimension builds wifin Cognos Data Manager tool for ETL process
  • Designing, Constructing, Testing and Deploying teh Cognos Framework Manager Models, Packages, Reports and Power play Models.
  • Extensively worked on developing extremely complex Active reports.
  • Worked on scheduling, bursting of reports.
  • Worked on bursting teh reports in multiple scenarios (File system/E-Mail)
  • Created complex dashboards and also worked wif integrating them wifin web portals using CMS calls
  • Worked extensively on exploring teh mapping capabilities in Cognos and also used Cognos Map Manager to customize teh existing features and layers.
  • Worked on Query studio and also used JavaScripts wifin Report Studio to achieve complex functionalities.
  • Worked on Cognos Work Space Advance for creating advance analysis and reports
  • Worked on Rapidly Adaptive Visualization Engine (RAVE) and teh Visualization tool.
  • Worked on writing complex SQL Queries to modify and suggest any fixes on performance improvement of teh reports.
  • Worked on creating complex Drilldown and Drill Through reports
  • Created complex Active reports using report studio and also worked on optimization of size and bursting of teh active reports via E-mail and File System.
  • Worked on Event studio to achieve a solution for integrating multiple attachments while bursting multiple reports using same email and also integrating another report wifin teh body of teh E-mail.
  • Create IQDs using Framework Manager.
  • Created FM Models wif using Multiple Data Sources
  • Experienced in using Data sources in Star Schema Model and also snowflake Schema
  • Created Star Schema Grouping in FM Models whenever necessary.
  • Created FM Models using Data Sources from Oracle, MS SQL Server, SAP BW and more.
  • Implemented Data, Object and Package level security in Framework Manager
  • Created Parameter maps in FM to implement dynamic functionality in teh reports based on teh prompt selections in Report studio
  • Created Parameterized Data source selection dynamically using Macro function in Framework Manager
  • Worked on integrating multiple FM Models into one Model to create Dashboards supporting multiple products depending on Business requirements
  • Created dimension views and User Class views to implement teh data security in teh Powerplay Transformer Model
  • Created DMR models and relational models depending on teh reporting requirements.
  • Created FM Models using Dynamic Query Mode
  • Worked on Dynamic Query Analyzer to analyze teh processing time for each step when using DQM and also debug teh queries using teh analysis.
  • Involved in Performance Tuning of teh reports.
  • Active participation in weekly Cadence calls wif IBM support to discuss various issues being faced wif Cognos.
  • Worked closely wif IBM Support team to resolve multiple PMR’s raised by teh team
  • Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
  • Coordinating wif teh ETL team in defining teh ETL logic for Reporting table loads and in setting up teh timely schema refreshes for teh Reporting Schemas.
  • Helping teh ETL team to load dummy data for mock-ups whenever needed.
  • Debug teh queries from wifin teh report studio as well as framework manager and test them across teh DB using SQL Developer/TOAD to improve performance and fix issues if any
  • Work closely wif teh Deployment team to prepare necessary EAR files for Deployment using teh BMC Blade Logic Tool.
  • Used tools like Firebug to debug any errors or issues in teh Java Scripts wifin teh report studio and used teh same to prepare Timely performance charts for teh performance reviews of reports

Environment: Cognos 10.x (Framework Manager, Transformer, Cube Designer, Cognos Connection, Report Studio, Rapid adaptive visualization tool(RAVE), Visualization Tool, Query Studio,Analysis Studio), Cognos Data Manager, BMC Blade logic Automation Suite, Tortoise SVN, Oracle 11g, SQL Server, SAP BW, Siebel, ERWIN, TOAD, Windows 2000/2003/XP/7.

Senior Cognos Developer

Confidential, NJ

Responsibilities:

  • Participating in teh User meetings to analyze and prepare teh reporting and analysis requirements of DSS users.
  • Designing, Constructing, Testing and Deploying teh Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
  • Experienced in migrating teh existing Cognos Impromptu Catalogs to Cognos 8 Models.
  • Enhancing teh Powerplay, Framework Models and Reports to meet teh changing business requirements.
  • Created a Framework Manager Model wif calculated columns, filters and Macros from different data source and created packages to suit teh reporting needs of teh client.
  • Create IQDs using Framework Manager.
  • Created dimension views and User Class views to implement teh data security in teh Powerplay Transformer Model
  • Created various Powerplay reports for teh Different user groups.
  • Created various Crosstab reports and Drill through reports as per teh user requirements using conditional formatting.
  • Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
  • Extensively worked on Expense and Claims Cubes.
  • Created various cubes using multiple datasources.
  • Involved in Performance Tuning of teh reports.
  • Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
  • Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
  • Addressing teh Performance and other Production issues wif teh Cognos 8 reports and Powerplay cubes.
  • Defining teh Users, Group and Roles in LDAP using Cognos Access Manager.
  • Installed Cognos 8 On Windows 2000 Server and Configured teh Dispatcher and Gateway.
  • Coordinating wif Database team in setting up teh required Materialized views, Aggregated and De-Normalized tables for teh Reporting and Analysis needs.
  • Coordinating wif teh ETL team in defining teh ETL logic for Reporting table loads and in setting up teh timely schema refreshes for teh Reporting Schemas.

Environment: Cognos 8(Framework Manager, Cognos Connection, Report Studio, Query Studio Analysis Studio), Cognos Report Net1.1, Cognos EP Series 7 (Impromptu, Powerplay, Powerplay Transformer, IWR, Upfront, Access Manager), Oracle 10g, SQL Server, DB2 7.0, ERWIN, TOAD & Sun One Directory Server, Sun Solaris, Windows 2000/2003/XP.

Senior Cognos Developer

Confidential, Washington, DC

Responsibilities:

  • Gathering teh Report requirements from teh Users to Design teh FM Model and developing teh Dashboards, Cubes and Complex reports.
  • Designed teh Dashboard Templates and Created Various Dashboard reports for teh Business Users.
  • Design teh Model for Different Business Areas and analyzing teh indexes and Keys and creating star schema.
  • Participating in teh User meetings to analyze and prepare teh reporting and analysis requirements of users.
  • Designing, Constructing, Testing and Deploying teh Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
  • Created a Framework Manager Models wif Multiple Namespaces.
  • Created a Framework Manager Models wif calculated columns, filters and Macros from different data source and created packages to suit teh reporting needs of teh client.
  • Created dimension views and Custom views to implement teh data security in teh Powerplay Transformer Model.
  • Involved in installation Cognos 8.4 Suite on UNIX and Windows.
  • Created Multiple Power cubes from Single Model.
  • Created Dashboard reports from teh OLAP source.
  • Implemented teh Dashboard reports wif teh various Cognos Dimensional Functions.
  • Created various Crosstab reports and Drill through reports as per teh user requirements using conditional formatting using teh Rendering and Conditional Variables.
  • Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
  • Created Powerplay cubes using multiple data sources, which are retrieved by Cognos Packages and Reports.
  • Extensively worked on teh OLAP Data source Reports.
  • Created UNIX shell scripts for atomization of teh Cubes Refresh using teh Crontab on teh Cognos AIX Server.
  • Involved in Performance Tuning of teh reports.
  • Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
  • Involved in teh Cognos Administration like creating new Data source Connections and Creating Packages, handling teh Deployment of reports copying from Development to Production server and also handling teh user permissions on teh Packages and Folders.
  • Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
  • Addressing teh Performance and other Production issues wif teh Cognos 8 reports and Powerplay cubes.
  • Created various SQL for teh test cases and also used some User-Defined SQL’sIn Framework Manager.
  • Coordinating wif Database team in setting up teh required Materialized views, Aggregated and De-Normalized tables for teh Reporting and Analysis needs.
  • Coordinating wif teh ETL team in defining teh ETL logic for Reporting table loads and in setting up teh timely schema refreshes for teh Reporting Schemas.

Environment: Cognos 8.4/8.3, (Framework Manager, Cognos Connection, Report Studio, Query Studio,Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 8.1.1, Business Glossary, SDK, Data stage 6.0, Oracle 10g, SQL Server, TOAD, AIX, Windows 2000/2003/XP.

Cognos BI Developer

Confidential, San Diego, CA

Responsibilities:

  • Developed Framework Manager Models wif Physical layer and Presentation Layer to cater teh various business’s needs (Folders, Filters, and Macros)
  • Develop new reports on timely bases, by extracting new data from database by running teh DTS packages and rebuilding teh OLAP cubes
  • Generate financial reports from Operating Statement Cube and Balance sheet Cube
  • Developed Complex Report Studio Reports using Bursting, Tabular Objects.
  • Securing Cognos Connection and setup ReportNet security by assigning users to teh groups and roles defined in Cognos Namespace
  • Applied Security and User Autantication to teh various User Groups.
  • Created reports in Impromptu and published them to teh Upfront Server using IWR
  • Build a dashboard report in PowerPlay which indicates teh Key Performance Indicators (KPI)
  • Created Drill- through reports and Customized Reports wif Prompts (List. Cross tab)
  • Developed Standard templates in Report Studio for developing reports.
  • Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc…) wif complex formatting utilizing Report Studio
  • Created documentation to describe entire flow of teh applications, program development, logic, coding, testing, changes and corrections
  • Performed Unit testing for all developed reports

Environment: Cognos 8.4, Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Impromptu, Cognos PowerPlay, Cognos Powerplay Transformer, Cognos PowerPlay Enterprise Server, Cognos Upfront, SQL Server 2000, DB2, MS-Access, MS-Excel, Windows

Cognos BI Developer/Analyst

Confidential, Wilmington, DE

Responsibilities:

  • Gatheird Business Requirements, Interacted wif teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
  • Conducted requirements gathering sessions and interacted wif business process owners to understand teh functionality required.
  • Analyzed and optimized teh process. Prepared Business Requirement Document and tan converted teh business requirements into Functional Requirements Specification and Technical Specification.
  • Prepared meeting minutes and distributed to various participants and for artifacts purposes.
  • Arranged walkthrough sessions wif teh user group and to confirm that all teh requirements have been captured and obtained sign off on teh requirements documents.
  • Prepared project reports for management and assisted teh project manager in teh development of weekly and monthly status reports, policies and procedures.
  • Created models (.cpf) in Framework Manager Modeling tool and publish packages in Cognos Connection.
  • Implemented data level and object level security in Framework manager.
  • Created prompts, calculations, conditions & filters in teh report as well as in teh Framework Manager.
  • Created Dashboards and modified teh existing Dashboards using Report Studio.
  • Created Drill through Reports and also used Conditional Formatting extensively.
  • Improved performances of teh Reports.
  • Used TOAD extensively for Unit Testing and Analyzing teh data.
  • Created tables and Inserted/Updated Values using TOAD.
  • Imported Excel data into Oracle tables using TOAD.
  • Worked on LDAP Servers, created Users and their User groups using a tool called Cygwin and ZUM (built on VB 6.0). Modified ZUM tool code and also demonstrated teh functionality of teh tool to Production support teams.
  • Set up required permissions in teh Cognos Portals for teh User group for security purposes.
  • Document teh list of changes that impact teh reports using MS Word and MS Excel.

Environment: Cognos 8.3 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Metric Studio, Impromptu 7.4, Cognos Power Play Transformer 7.4, Power Play for Web, Access Manager, XML, MS SQL Server 2005, Oracle, DB2, Windows 2003 server.

Cognos Developer

Confidential

Responsibilities:

  • Worked wif team, to understand teh data and business logic underlying teh requirements.
  • Worked wif Cognos 8.1 BI modeling, Report Studio.
  • Created Cognos Data Models using Framework Manager and Data Mining using Analysis Studio
  • Used Framework Manager to model metadata by analyzing teh model design and published packages.
  • Modified packages to suit teh business needs and to improve teh performance of teh reports.
  • Designed models using Impromptu Query Definition (IQD), created OLAP cubes in Cognos Transformer and analyzed teh data using Cognos power Play.
  • Decreased teh cube build times drastically and increased runtime performance.
  • Involved in migrating reports from Impromptu to report Net. Published all Impromptu reports to IWR upfront.
  • Created Complex Multi-Object Reports using Lists, Charts, Crosstabs and Images using Report Studio and Ad-hoc reports in Query Studio.
  • Creating prompt pages, filters and calculations according to teh user requirements in Report Studio.
  • Created list reports, cross-tab reports and chart reports using multiple queries in a single report, Drill- through reports and Conditional formatting to highlight teh business needs.

Environment: Cognos 8(Report Studio, Query Studio, Cognos Connection, Analysis Studio), Report Net 1.1, Power Play Transformer 7.3, Impromptu 7.3, Access Manager, XML, Oracle 10g, TOAD, SQL Server 2005.

We'd love your feedback!