We provide IT Staff Augmentation Services!

Dw Developer Resume Profile

Professional Summary

  • A Certified Cognos Professional over 11 years of Techno-Functional IT experience in Business Intelligence, Cognos Administration, Design Development of Data warehousing front end Applications
  • Proficient in acting as a Technical liaison between the Technology Business Users
  • Excellent knowledge on overall Cognos Architecture and Environment
  • In-Depth Expertise in using Cognos 7.x, 8.x, 10.1 10.2 comprising Report Studio, Query Studio Analysis Studio, Report Net and Impromptu
  • Strong Hands on experience in Cognos Framework Manager Meta Data Modeling Publish Packages
  • Good Exposure in Relational Dimensional Modeling using Frame work Manager
  • Experience in creating Cognos multidimensional Power Cubes using Transformer
  • Proficient in creating High Performance Cognos 10.2 Dynamic Cubes with Cube Designer
  • Implemented Advanced Cube modelling capabilities of creating Virtual cubes, Base Historic cubes.
  • Solid knowledge of latest technologies Applications such as Mobile BI, Cognos Active Reports, Dashboard Reporting, Cognos RAVE visualization, Business Insight Cognos TM1
  • Expert in creating offline Cognos Active Reports and integrate with Ipad, Android Devices
  • Outstanding track record of transforming business concepts into state-of-art Cognos Dashboard
  • Strong knowledge on Business Intelligence Software Development life cycle
  • Expertise in Cognos Administration supporting Cognos Web servers, Dispatchers, Content Managers
  • Implement Security on Cognos User Roles and Groups
  • Expert in Cognos Environment root causes analysis for any system outages with various log messages
  • Install, Configure Tune Cognos Distributed environment
  • Provide 24 7 Production System Support
  • Expertise in Requirement Gathering, writing Functional Specifications Converting the same to Technical Specifications for the Reporting needs.
  • Proficient in Data warehousing / ETL Concepts with hands on experience in Informatica 8.x
  • Proficiency on using Oracle OBIEE 11g BI Publisher Reporting tool
  • Domain Expert in Manufacturing, Insurance Banking

Technical Forte

  • BI Application : Cognos 8.2, 8.3, 8.4, 10.1, 10.2
  • Meta data Tool : Cognos Framework Manager, Power Play Transformer, Cube Designer
  • Web Based Interfaces : Cognos Administration, Cognos Connection, Report Query Studio
  • Business Insight, Cognos Workspace
  • Mobile Interface Tool : Cognos Active Reports
  • Database : Oracle, DB2, Teradata, SQL Server
  • ETL Tool : Informatica 8.6
  • Scripting : Windows Power Shell, Java Scripting

Management Business Analyst Skills

  • Collaborate with Business and IT partners to understand the requirements
  • Provide Analytics and Reporting Solutions and expertise
  • Match Business requirements to IT Solutions
  • Serve as a Cognos Subject Matter Expert SME
  • Collaborate and Mentor other Team members to share knowledge and best practices
  • Responsible for identifying risks along with the respective resolution and risk mitigation
  • Experienced in Team management, Effective co-ordination with Business users
  • Excellent track record for interacting with the Business for requirement gathering
  • Assist Team members and users in utilizing the tools to best of their abilities
  • Co-coordinating in preparing Project Proposal Estimation
  • Excellent Process Documentation skills
  • Proactively communicate and collaborate with users and stakeholders to analyze the current and future requirements of the project and deliver the needed artifacts
  • Manage on going support adhoc requests and create training materials and presentation

Project

Confidential

Cognos Administrator

Responsibilities

  • Support for Production Non-Prod Cognos environments Servers
  • Trouble shooting for the environment outage issues
  • Resolving the issue related to Cognos Dispatcher Content managers
  • Ensure the availability of Cognos environment for the Business groups
  • Regularly monitor performance and availability of the Cognos environments
  • Recycle Cognos servers as needed
  • Design, Develop and test custom code to automate routine administrative and monitoring tasks
  • Install and configure various Cognos 10 hotfixes Fix packs
  • Weekly vendor meeting with IBM on service request issues
  • Lead guide the Maintenance service patch installation
  • Provide guidance and consulting and administrative support for Developers, Report Authors and Report Consumers
  • Create detailed process and procedural documentation for environmental specifications and user guide etc.,

Project

Confidential

Business Analyst, Cognos Project Lead

Responsibilities

  • Active Participation in Requirements gathering
  • Provides guidance on best methods for interface architecture design
  • Provides the technical perspective in day-to-day project decisions
  • Works with users to ensure the project meets business needs
  • Defines requirements for reporting and interfacing
  • Communicates with other key business representatives
  • Ensures business and functional decisions are made to ensure technical development progress and completion
  • Develop, review and refine technical spec
  • Initiate any Short / Long term enhancements for the Project
  • Ensures functional specifications meeting technical needs for development
  • Participate in user sessions throughout the project lifecycle to ensure user issues are addressed in all
  • Deliver training and information sessions
  • Communicates on behalf of the project or defers to Project Manager
  • Supports the project manager and offers mentoring, and coaching when dealing with business
  • Acts as vocal project champion
  • Actively manages and communicates project risks and issues
  • May deliver key project communications
  • Provides guidance on overall project direction
  • Responsible for any Project Deliverables on behalf of the Project Manager
  • Provides the technical perspective in day-to-day project decisions
  • Monitors issues and change requests
  • Provide the project status to Project Manager for the stakeholders to be aware of
  • Report on project status to key groups and individuals Sponsor, Steering Committee etc.
  • Gain buy-in from key Business Users and keep their interest and level involvement right throughout the project

Project

Confidential

Informatica Lead

Responsibilities

  • Analyzing the AS IS architecture of Datastage jobs which runs on Mainframe Systems
  • Develop the POC to rewrite the existing interface FIRST feed Data Stage v 4.2 / Mainframe using Informatica 8.6.1
  • Understanding the existing system design
  • Creating the enterprise file based on business rules and derivations
  • Validation of policies bypassed at the enterprise level
  • Splitting the enterprise file into 17 different format files Merging with previous version files
  • Develop the Informatica Design Document
  • Create Mapping design on Informatica tool
  • Executing the Design Logic and generate the outputs.
  • Support for Volumetric and Time Bound Execution Analysis

Project

Confidential

Sr. DW Developer

Responsibilities

  • Interacted with the Business Users to understand the reporting requirements, prepared the report specifications to suit the requirements.
  • Used Framework Manager Modeling Tool to create and manage business-related metadata for the report authoring using Cognos 8 Report Studio.
  • Developed Models and Packages using Framework Manager and published to Cognos Server.
  • Developed complex Dashboards and reports to accomplish various business logics.
  • Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level
  • Introducing the Java Scripts to derive various business requirements
  • Expertise on Reporting Metadata Modeling Estimations

Project

Confidential

Sr. DW Developer

Responsibilities

  • Analyzing the Business Requirements
  • Developed very complex reports to accomplish various business logics.
  • Involved in Metadata Development Report generations for RTBA and provided technical support to the team.
  • Introducing the Java Scripts to derive various business requirements
  • Expertise in Quality Process
  • Consolidating the Project Metrics

Project

Confidential

Offshore Cognos Team Lead

Responsibilities

  • Preparing project estimation
  • Involved in Preparing Project Proposals
  • Determining the resource requirements
  • Developing appropriate strategies for the implementation of the project
  • Assigning the work from functional technical perspectives
  • Interacting with clients and all stakeholders.
  • Providing strategic and tactical direction to the project team
  • Reviewing the status of the project and taking corrective measures as required
  • Analysis of Functional Specification document
  • Create and publish the Model in Framework Manager
  • Design ,Development deployment of RDD Reports

Project

Confidential

Project Lead Onsite Coordinator

Responsibilities

  • Analyzing Business requirement directly with Client
  • Coordinating with Clients for requirement integration
  • Involved in all Project Management AQM Methodology sessions
  • Interacting with clients and all stakeholders
  • Onsite Coordinator for the project
  • Create and publish the Model in Framework Manager
  • Assigning the work from functional technical perspectives
  • Preparing project estimation
  • Developing appropriate strategies for the implementation of the project
  • Design ,Development deployment of DCC Reports
  • Design of High level Documents, Detailed Design Documents

Project

Confidential

Team Leader

Responsibilities

  • Assigning the work from functional technical perspectives
  • Determining the resource requirements
  • Preparing project estimation
  • Providing strategic and tactical direction to the project team
  • Prepare Functional Technical Specification document
  • Prepare Unit Test Case documents
  • Design and development of EPO PCI EPO SAI reports
  • Migration of reports from CRNDEV to QA / PROD
  • Performance tuning and load balancing of complex reports

Project

Confidential

Team Leader

Responsibilities

  • Determining the resource requirements
  • Preparing project estimation
  • Interacting with clients and all stakeholders
  • Reviewing the status of the project and taking corrective measures as required
  • Prepare Unit Test Case documents
  • Design and development of Dashboard detail reports
  • Migration of reports from CRNDEV to QA / PROD
  • Security implementation if framework manager based on the user roles

Project

Confidential

Team member

Responsibilities

  • Analyzing Business requirement directly with onsite coordinator
  • Prepare Functional Specification document
  • Prepare Technical Specification document
  • Design and development of Reports
  • Performance tuning and load balancing of complex reports
  • Design of High level documents, Detailed design documents, Unit test plans and UTC
  • Create a Job in report net and scheduling of reports

Hire Now