We provide IT Staff Augmentation Services!

Bi Senior Administrator/developer Resume

OBJECTIVE:

A result driven Cognos Certified Professional with 10+ years of experience in Information Technology,proficient in Business Intelligence, Install/Configure and Administration of Cognos Tool Set, Design & Development of data models including data warehousing and dimensional Models,BI Dashboards and reports for Management. Heavily involved in the designinig and deploying Dashboard reports for industries such as Telecom, Insurance, Retail and Banking domains and engaged in project management with a team - based work style.

SUMMARY:

  • Having 10+ years of IT experience in Implementation of Data Warehousing projects with Cognos as both Developer and Administrator.
  • Having experience in Cognos Administration (Installations, configurations, environment set up, supporting various application issues, system upgrade etc...).
  • Excellent knowledge on overall Cognos Architecture and Environment.
  • Installed and Configured the Cognos 8.4,Cognos 10.1 and Cognos 11 Analytics BI application with its complete suite of tools in windows environment.
  • Configured the LDAP namespace for the Active Directory Server to be used as the 3rd party authentication tool for Cognos 8.3 and Cognos 10 application.
  • Content Manager Failover mechanism and Load Balancing setup in dispatcher and Audit store configuration
  • Administered by setting up the Cognos Security settings at package, report level using Cognos Connection administration portal with restricted features depending on the class of the user.
  • Created various Dashboard Reports for different Business Units based on Relational Package using Framework Manager.
  • Involved in Migration of FM models and reports from Cognos 8.4 to Cognos 10.
  • Extensively worked on Cognos 8.3, Cognos 8.4, Cognos 10((Cognos Admin) versions.
  • Extensively interacted with business partners to identify information needs and requirements for Cognos report design and development
  • Database level testing against report data.
  • Experienced in Team management, Effective co-ordination with Business users.
  • Conducting sessions for team members and for business users to use the tool.
  • Co-ordinating in preparing Project Proposal & Estimation and Provide strategic and tactical direction to the project team.
  • Manage ongoing support & ad-hoc requests and create materials and presentations.
  • Experience in requirement analysis and delivering functional and technical design documents.
  • Possess adequate exposure in the database usage on Oracle 9i / 10g.
  • Capable of learning new technologies very quickly.
  • Commitment and dedication towards timeliness and quality in finishing tasks has earned me a good professional reputation.
  • Experience working with both team and individual work.
  • Exposure on Banking and Retail business domains.
  • Good knowledge of Software Development Life Cycle (SDLC).
  • Received client appreciations and for providing extended support to the customer beyond expectations.

TECHNICAL SKILLS:

BI Tools: Cognos 8.2,8.3,8.4,10.1&10.2,11

Language: SQL

Operating Systems: Windows

Metadata Tool: Cognos Framework Manager

Web Based Interfaces: Cognos Administration, Cognos Connection, Report & Query studio

Databases: Oracle

SQL Editors: TOAD

Oracle: Certified Associate (OCA) Developer

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Cognos 11 Analytics and Cognos BI 10.2 Report Studio, Framework Manager

BI Senior Administrator/Developer

Responsibilities:

  • Analyze and check the feasibility of new requirements.
  • Analyzing functional requirement documents with Business analyst to confirm the business logic.
  • Requirement analysis and Project estimations.
  • Design and development of Cognos Dash boards and reports.
  • Updating the Cognos FM models as and when required.
  • Administered by setting up the Cognos security settings at package, report level with restricted features depending on the class of user.
  • Worked on Performance tuning of dispatchers to handle requests better and optimize the performance of application.
  • Troubleshooting the environment in case the BI server goes down or contact the DBA in case of the down time of the content store database.
  • Managing the Project Team and Deliverables.
  • Managing customer discussions, issues and escalations.
  • Make sure that Cognos Servers are always running and available for users.

Confidential

Environment: Cognos BI 10.2, Oracle 10g Database

BI Administrator

Responsibilities:

  • Deploying Reports and other necessary files between environments as requested by Developers / Deployment co-coordinators for Business Units using Motio.
  • Cognos Licensing documentation as required by the customer.
  • Creation of data sources (DSNs) and Add or Modify a Data Source Connection in Cognos Portal.
  • Sharing the model with the developers for the Audit reports development.
  • Schedule maintenance.
  • Adding users, user sign on, user, user’s data source access.
  • Resolving the application issues raised by the business users and coordinating with the report developers.
  • Planned / Unplanned environment restart.
  • Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, date prompt and cascading prompt using conditional formatting as well.
  • Worked on performance issues as and when requested by the users.
  • Providing the deployment archive files to the developers.
  • Verifying and fixing Data Source connections issues.

Confidential

Environment: Cognos BI 8.2 Report Studio, FM& Transformer, Oracle 10g Database

Cognos Senior Developer&Administrator

Responsibilities:

  • Deploying Reports and other necessary files between environments as requested by Developers / Deployment co-coordinators for Business Units.
  • Creating and supporting the Reports.
  • Using Filters and Sections to customize the reports.
  • Created Prompts, Cascading Prompts and Filters.
  • Creating list reports, cross-tab reports and chart reports in a single report.
  • Creating Conditional formatting to highlight the business needs.
  • Created reports using Drill Through on List
  • Involved in enhancements of existing FM models.
  • Handling incident requests and resolving issues as per SLA and follow procedures recommended for incident closure.
  • Fixing Data source connection issues. Creation of data sources (DSNs) and Add or Modify a Data Source Connection in Cognos Portal
  • Verifying and fixing the issues in various application environments to see that the applications are up and running or to fix unknown issues which occurs in DEV/PRD at times
  • Create & Manage users in LDAP server. I.e. Access Permissions (Add/remove) for Users, Add or Remove Groups and Roles.
  • Application deployment or Reports & Package deployments from development environment to production environment.
  • Make sure to document all the activities performed in the Cognos environment including administrator and development level activities.
  • Involved in Cognos Power play cube refresh activities and enhancements of it as and when required.
  • Working on some enhancements of Report Studio reports for Taiwan.
  • Active participation at the time of business handover of Australia Nutri to ASPEN.
  • Decommission of Indonesia Nutri, Malaysia Nutri, Australia Nutri & Vietnam Animal Health.
  • Enhancements of Cognos report studio reports for few markets as and when required.
  • Prepared standard documents required for the project like- Implementation Plan, KT document, and Cognos 10 Go-Live and Cube refresh Support document.

Confidential, Cincinnati

Environment: Cognos 8.4 with Oracle DB.

Cognos Administrator

Responsibilities:

  • Verifying all the Cognos URLs (Prod, Dev, and QA) are up and running on daily basis.
  • Check the content Store is available for all 3 environments.
  • Periodically assess the new upgrades/patches released from Cognos, apply patches as needed.
  • Create & Manage users in LDAP server, i.e. Access Permissions (Add/remove) for Users, Add or Remove Groups and Roles.
  • Creation of data sources (DSNs) and Add or Modify a Data Source Connection in Cognos Portal.
  • Scheduling Report Studio reports.
  • Space availability checks on all Servers.
  • Plan and carry out backup & restore.
  • Application deployment, deployment of application from development environment to production environment.
  • Periodically monitor application usage/system usage using Audits.
  • Make sure to document all the activities performed in the Cognos environment including administrator and development level activities.

Confidential, San Ramon, CA

Environment: Cognos 8.4 & Cognos 10.1 with Oracle

Cognos Administrator/Tech Lead

Responsibilities:

  • Participated in the Migration activities as requested by Developers / Deployment co-coordinators for Business Units.
  • Resolving issues relating to IBM Cognos, Where these are causing the application to operate incorrectly.
  • Monitor and maintain optimal performance in all Cognos environments performance and open PMR with IBM support if necessary in order to fix issues.
  • Upgrading Cognos software and other necessaries with latest hotfix and patches from IBM.
  • Involved in migration of Cognos 8.4.1 application to Cognos 10.1(32bit)
  • Perform weekly maintenance on all Cognos servers including restarting servers and ensure all schedules are running successfully.
  • Handling incident requests and resolving issues as per SLA and follow procedures recommended for incident closure.
  • Auditing, Logging and monitoring all Cognos environments in order to ensure this product remains complaint.

Confidential, San Diego, CA

Environment: Cognos BI 8.2, 8.3, 8.4, 10.1,Cognos 8.x Framework ManagerCognos7AccessManager,CognosEP,TM1,HFM,Control-M,QlikviewWithOracle10g database

Cognos Technical Architect

Responsibilities:

  • On-Call support for varied BI applications (COGNOS 8-BI, EP, TM1, BO,HFM &Qlikview).
  • Ensuring that the project adheres to the conventions and standards mentioned in the BRS.
  • Install, configure and review of Cognos 8.4.1 & Cognos 10.1 BI on Windows Server 2003 platform.
  • Involved in complete C10.1 sandbox setup on 32 bit windows OS server which includes installation and configuration of C10.1. Performed some post install customizations as well.
  • Installations and configurations in a distributed environment.
  • Audit store Database Migration and testing.
  • Scheduled and unscheduled application maintenance activities.
  • Direct customer support while at on-site based on the internal ticketing system.
  • Control-M license support activity.
  • Case resolutions with the help of Cognos Support team using Cognos Support secondary ID.
  • Monitoring tools and setup.
  • Managing all ITG requests that are opened by the India BU Development teams and all US based ITG tickets as assigned by US support group.
  • Setting up security for new hosts.
  • Fixing Data source connection issues.
  • Involved in the preparation of Visio diagrams.
  • Verifying and fixing the issues in various application environments after monthly patching, to see that the applications are up and running.
  • Extend an extra hand work with onsite on-call to fix the alerts.
  • Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
  • Collecting and sharing best practices and tips in Cognos Administration tasks such as security setup and Report Authoring, Stress testing and Performance tuning.

Confidential

Environment: Cognos 8 Report Studio, Framework Manager with Toad.

Module Lead

Responsibilities:

  • Collecting the Reporting requirements from Business Analyst.
  • Analyzing the Business Requirements.
  • Involved in the preparation of Analysis documents and Technical requirement documents.
  • Enhancements on FWM Model and publishing the package.
  • Developed Standard Reports, Charts, Drill-through Reports, Master Detail Reports and Bursting Reports using Report Studio.
  • Involved in the creation of various List reports with Prompts.
  • Created Filters and sections in the report as per business requirement.
  • Interacted with business analyst to gather reporting requirements and designed functional and technical reporting requirements documentation.
  • Complete analysis and development of Reports as per client requirement.
  • Troubleshooting reports to resolve the poor performance and data validation.
  • Testing the Reports against database in all the environments (Dev, Test & Prod).
  • Checking the quality of software and determining its degree of compliance to standards.

Confidential, Cincinnati

Environment: Cognos 8.3 & 8.4, (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, SQL Server, TOAD.

Cognos Developer

Responsibilities:

  • Reports development and Unit Testing of Reports.
  • Preparation of technical design document.
  • Framework Manager Package Design and Development.
  • Preparation of Unit Test Case (UTC) documents and other quality related documents.
  • Interacted with business analyst to gather reporting requirements and designed functional and technical reporting requirements documentation.
  • Complete analysis and development of Reports as per client requirement.
  • Modified Framework Manager Model, and established to suit the business needs.
  • Developed and published packages on Cognos connection using Framework Manager - Connecting and testing the data source, created physical layer and presentation layer, defining appropriate relationship between query subjects.
  • Troubleshooting reports to resolve the poor performance and data validation.
  • Analyzed existing reports and provided solution for enhancing reports for better performance.
  • Developed Standard Reports, Charts, Drill-through Reports, Master Detail Reports and Bursting Reports using Report Studio.
  • Involved in the creation of knowledge base/reusable documents based on the tasks completed in the Project level.

Confidential, Indianapolis, Indiana

Environment: Cognos 8.2&Cognos7.3 Powerplay with Oracle 10g.

Module Lead

Responsibilities:

  • Gain the Pharma domain knowledge to effectively propose and implement solutions.
  • Involved in the preparation of the design documents and report validation documents.
  • Developed Adhoc reports as and when required.
  • Prepared Test Cases and did Testing using Toad.
  • Involved in user interaction and .
  • Understanding the system and come up with the strategy for code modification using BIDS methodology.
  • Testing software against its requirements during Software development/enhancements.

Hire Now