We provide IT Staff Augmentation Services!

Senior Cognos Consultant/administrator Resume

NY

SUMMARY

  • 8 Years of experience in reporting, dash boarding, analysis, design, testing, debugging, documenting and supporting efficient and effective Cognos web applications, Data warehouses, Data Marts, and tools consistent with established specifications and business requirements.
  • Well versed with techniques in Cognos 10.2.2, 10.2.1, 10.1.1, 8.1, 8.3, 8.4.1 suite Report Studio, Query Studio, Analysis studio, Metric Studio, Active reports using RAVE visualization, Business Insight and Business insight advanced.
  • Experience in building multidimensional models and creating Transformer Power Cubes
  • Experience in creating the custom views and implementing the data security at power cube level.
  • Experience in scheduling the cubes for daily refresh by writing the batch files using windows commands.
  • Hands on experience in building the Transformer Power Cubes, and defining the data securities, scheduling the power cubes by writing the batch files.
  • Extensive experience in creating interactive dash boards using Active reports, pages and portlets and good experience in Framework manager modelling and reporting.
  • Customized RAVE charts JSON scripts using visualization customer to nested line and area charts.
  • Expertise in OLTP/OLAP system study, analysis, E - R modelling and developing Database schemas like Star Schema and Snowflake Schema
  • Good experience in building the Cognos Dynamic cubes in 10.2.2 and in using MDX functions.
  • Extensive experience in building Microsoft SSAS Cubes, and writing the effective MDX script queries, scheduling the cubes in SQL server Agent.
  • Extensive experience in Installation, Configuration & Migration of the Cognos 8.4/8.3 BI Environment to higher versions Cognos 10.2.2, 10.1.1 and 10.2.1 which is the latest version
  • Hands-on experience in writing the unit test cases and in performing the unit testing.
  • Active Participant of the Data warehouse Development Team, Interpret business requirements related to a significant element of a system application, assist with design or enhancements of straightforward aspects of less complex systems.
  • Good knowledge in Data warehousing concepts.
  • Involved in performance tuning of reports.
  • Experience in creating tables, views, basic stored procedures in SQL server database.
  • Involved in Production/Customer Support, Deployment, Development and Integration.
  • Having strong communication and analytical skills with a desire to learn advancements in the IT industry.
  • Guides, trains, instruct and assist others at lower levels on straightforward technical issues.
  • Good interpersonal skills, problem solving skills and an attitude to learn the new cutting edge technologies & an energetic team player with demonstrated proficiency for learning new tools and business environment.

TECHNICAL SKILLS

BI/ OLAP Tools: Cognos 10.2.2/10.2.1/10.2/8.4/8.3 Cognos Query, Cognos Connection Administration, Transformer power cubes, Dynamic Cube Designer, Microsoft Analysis Services (2005)

Servers: Application server (Tomcat), Web server (IIS)

Databases: SQLServer 2012/2008/2005 , Oracle 10g & DB2

Operating Systems: Windows XP, Windows2003, Windows NT

Languages: C, SQL, PL/SQL, T-SQL, JavaScript, HTML.

Others: SQL Query Analyzer, Office2000, Excel, Toad, IIS.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Cognos Consultant/Administrator

Responsibilities:

  • Involved inRequirements gathering and specificationwriting after interfacing with Business Users, Line of Business Requirements and Other Stake Holders.
  • Worked with project managers,Business Analystand end users to understand business requirements and translated them in tothe technical specifications.
  • Responsible for installing and configuring various components of Cognos 10.2.2, such as the Framework Manager and Content Manager, Audit database, security.
  • Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
  • Deployed packages, folders and Reports from a development environment to Testing and Production environment.
  • Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
  • Develop and maintain dashboards and apply data visualization best practices from Stephen few guide. designing and developing dashboards using RAVE technology for iPads and other mobile devices
  • Customized RAVE charts JSON scripts using visualization customer to nested line and area charts.
  • DesignedCognos Framework Manager Modelwith different views (Database View, Business View, Presentation View) using SQL server as per Business Users Requirements.
  • Involved indata modellingby creating/updating LogicalEntity Relational Model (ERM)and publishedPackages.
  • Worked on Cognos 10.2.2Framework Managerto importmetadatafrom multiple data sources and to create subject oriented business models, create and publish packages.
  • Implemented Framework managersecurity for Data access, Object level access and Package access.
  • Implementedstored procedure query subjectin Cognos Framework Manager.
  • Using Cognos 10.2.2 Report studio,created various complexList Reports, Grouped Reports, Cross tab Reports, Chart ReportsandDrill-Through Reports for Mobile and iPad Applications.
  • Developed Reports withMultiple Cognos Viewersand with multiple Cognos Reports developedComplex Reports, DashboardsforMobile and iPad Report Applications
  • Deployed Reports, PackagesandFoldersfromDEVtoUATand fromUATtoPRODEnvironments. Implemented security for reports and packages
  • Trained and assisted power users in created adhoc reports using query studio and workspace advanced.

Environment: Cognos 10.2.2, Framework Manager, Report Studio, Active Reports, Visualization customizer, IBM Cognos Mobile, Powerplay studio, Event studio, Powerplay transformer, Dynamic query analyzer, Dynamic cubes, SQL server, SSAS.

Confidential, NY

Senior Cognos Developer/Administrator

Responsibilities:

  • Responsible for Installation, Configuration & up gradation of Cognos 8.4.1 to 10.2 & 10.2.1 at the client location and successful implementation of the whole project.
  • Developing a logical model that conforms to star schema concepts, different views (data/physical, business, and Presentation layers) as per Business requirement
  • Interaction & Req. Gathering from the client. Handled different meeting like POC, demos etc. with stake holders.
  • Upgraded all Cognos 8.4.1 Packages, Reports and Folders to 10.1.1 and then to 10.2.1
  • Developed dynamic cubes in Cognos 10.2 environment, created calculated measures and dimensions using MDX query, define roles and access privileges at data level
  • Developed data models in Framework Manager & Transformer, designed & published relational and multi-dimensional packages.
  • Created Complex Dashboards using Cognos connection like displaying Cognos navigator, Cognos search & Cognos viewer in a single page using portlets.
  • Designed and developed OLAP cubes using SSAS, created calculated measures and dimensions using MDX query, define roles and access privileges at data level.
  • Developed reports and dashboards using Active reports RAVE visualization, Report studio, query studio, business insight & analysis studio in Cognos 8.4.1/10.1.
  • Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
  • Performance tuning the by analysing and comparing the turnaround times between SQL and Cognos.
  • Deploying the reports and packages from Development to testing, Testing to Production environments.
  • Developed Unit test case document and understanding document as well as based on the specification.
  • Providing application management support to Cognos in the Development and UAT environment and Publishing the package to Development environment as per user requirement reports.
  • Scheduled and Distributed Reports in Cognos Connection
  • Cognos server maintenance on periodical basis

Environment: Cognos 10.2.1, 10.1.1, 8.4.1, Framework Manager, Power play Transformer, Query Studio, Report Studio, Active reports using RAVE visualization, Analysis Studio, Metric Studio and Event Studio, Business Insight & Advanced, Dynamic Cubes, SSAS cubes, SQL server 2012

Confidential, Seattle

Senior Cognos Developer

Responsibilities:

  • Involved in the requirement study, design document, mapping document and development
  • Responsible for estimation, planning and execution - with specific focus on requirement analysis and design for framework manager model and reports.
  • Import Views to the Framework manager model and set the cardinality between them as per the business requirements.
  • Created Business layer and Presentation Layer query subjects as per reporting requirements in Framework Manager.
  • Setting up cardinality (minimum, maximum & optional), Determents to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
  • Involved in estimating the efforts in converting actuate reports into Cognos.
  • Created customized reports using calculations, slicing and dicing, filters and conditional formatting in Report studio using the multi-dimensional (MDX) functionality.
  • Developed Standard Reports, Charts, Drill up/drill down and Drill-Through Reports.
  • Created Chart, List, Cross tab, and Repeater Reports.
  • Scheduled and Distributed Reports in Cognos Connection.
  • Guides, trains, instruct and assist others at lower levels on straightforward technical issues.
  • Involved in the installation of Cognos BI server.
  • Involved in the requirement study, design and development
  • Responsible for estimation, planning and execution - with specific focus on requirement analysis and design
  • Guides, trains, instructs and assists others at lower levels on straightforward technical issues
  • Created customized reports using calculations, filters and conditional formatting in Report studio.
  • Developed Unit test cases and in performing the unit testing.

Environment: Cognos 8.4.1, 10.1.1, Framework Manager, Power play Transformer, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio, Oracle 10g

Confidential - Remedy, NJ

Senior Cognos Developer

Responsibilities:

  • Involved in the requirement study, design document, mapping document and development
  • Responsible for estimation, planning and execution - with specific focus on requirement analysis and design for framework manager model and reports.
  • Preparing the Entity Definition Sheet for Reporting tables.
  • Designed models using Framework Manager and published packages to the Cognos connection
  • Implemented Framework manager security for Data access, Object level access and Package access.
  • Implemented Star Schema Grouping and Dimension Hierarchy in Framework manager model.
  • Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
  • Developing Dash Board reports in Report Studio using MDX Functions.
  • Creating the Report Studio reports using the Cube as a data source.
  • Creating the Report Studio reports using the MDX functions.
  • Creating the cube using power play transformer.
  • Created customized reports using calculations, slicing and dicing, filters and conditional formatting in Report studio using the multi-dimensional (MDX) functionality.
  • Developed Standard Reports, Charts, Drill up/drill down and Drill-Through Reports.
  • Created Chart, List, Cross tab, and Repeater Reports.
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports.
  • Adding business rules by defining different kinds of calculations and filter.
  • Scheduled and Distributed Reports in Cognos Connection.
  • Guides, trains, instruct and assist others at lower levels on straightforward technical issues.
  • Developed Unit test case document and understanding document as well as based on the specification.
  • Providing application management support to Cognos in the Development and UAT environment and Publishing the package to Development environment as per user requirement reports.

Environment: Cognos 8.4.1, 10.1.1, Framework Manager, Power play Transformer, Query Studio, Report Studio, SQL Server 2008

Confidential, Seattle

Cognos Developer

Responsibilities:

  • Involved in the requirement study, design and development
  • Design and testing the reports and validating them during the implementation phase.
  • Responsible for estimation, planning and execution - with specific focus on requirement analysis and design
  • Guides, trains, instruct and assist others at lower levels on straightforward technical issues.
  • Involved in creating Transformer Model and Cube.
  • Developing Advanced reports using Report studio like Cascading prompts
  • Creating complex reports with the functionalities like prompts, conditional blocks, conditional variables, drill through, render variables, master-detail relationships.
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports.
  • Created custom templates for the use of reporting.
  • Extensively worked on Analysis Studio to develop multi dimensional reporting
  • Involved in designing data model and report design.
  • Understanding functional specification and preparing technical specification
  • Creating various types of prompts in the prompt page.
  • Proficient in writing multidimensional (MDX) reports, creating various Kinds of reports like list, cross tab and Chart in Report Studio.
  • Created the user roles in Cognos connection.
  • Created the Dashboard reports using Report Studio.
  • Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.
  • Performed Unit testing of Reports based on the Report requirement specification.

Environment: Cognos 8.3, 8.4.1, Framework Manager, report studio, transformer, oracle 10 g

Confidential

Cognos Developer

Responsibilities:

  • Responsible for gathering/refining requirements from the customer/BUSINESS Team for developing reports.
  • Developed Active report, Statistics report and Dash board Reports.
  • Created customized reports using calculations, filters and conditional formatting in Report studio.
  • Created the user roles in Cognos connection.
  • Created the Dashboard reports using Report Studio.
  • Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.
  • Developed Standard Reports, Charts, Drill-Through Reports.
  • Created custom templates for the use of reporting.
  • Extensively worked on Analysis Studio to develop multi dimensional reporting
  • Involved in designing data model and report design.
  • Understanding functional specification and preparing technical specification
  • Creating various types of prompts in the prompt page.
  • Scheduled and Distributed Reports in Cognos Connection
  • Involved in designing data model and report design.
  • Understanding functional specification and preparing technical spec

Environment: Cognos 8 BI, Cognos 10 Beta, Oracle 10g

Hire Now