PROFESSIONAL PROFILE:

• Seeking challenging assignments in BI&DW with a reputed organization
• Around 9 years and 6 months of experience in Business Intelligence in Life Science, banking, insurance and Sales domain. Currently working as a Technology Specialist.
• Strong abilities and Hands on experience in Information Technology Industry, which includes experience in the field of Information Technology in data warehousing and Business Intelligence applications (Cognos 10, Cognos 8, Report studio, Query studio, and exposure to Framework manager, Composite 5.2 & 6.1 Infrastructure Support & Development), also experienced in Cognos EP Series 7 and also worked in US & UK for the period of 36 months as a part of DWH development, implementation, deployment and support team.
• I am having an in - depth knowledge of data-warehouse design and development, tools, languages and have good professional experience at different positions in a project execution hierarchy, having participated in roles as a Team Leader.
• I was involved in Requirements Analysis, Design and Development of DW projects. I have worked in various domains like banking, Automotive, insurance and Sales domain in implementing DW solutions using Cognos and Oracle and have sound knowledge and understanding of Quality processes to be followed specially for Compliance projects.

TECHNICAL STACK:

BI & DW: COGNOS 10BI COGNOS 8BI, Framework Manger, Cognos Report Studio, Cognos 10, cognos 8 & cognos7 Powerplay, Transformer, Access Manager and Cognos 8 Administrator, Administrator, Cognos Upfront, Cognos Server Administrator, Cognos Impromptu 7.3 & 7.4, Cognos ReportNet 1.1, Composite5.2 & Composite 6.1 (Data Virtualization) Toad

RDBMS: ORACLE 9i / SQL Server

Operating System: Windows 9x, Windows XP & Windows7, Linux, Unix

Languages: C, C++, HTML

OTHERS: Confidential WEBSPHERE 6.2, IIS

EMPLOYMENT HISTORY:

Confidential, NJ

Technology Specialist

Responsibilities:

• Facilitating and coordinating work with client, various application teams, shared services team and offshore team.
• Develop, maintain and update standard operating procedures for BI Infrastructure support.
• Ensure ITIL compliance - Incident management, Problem management, Change and release management.
• Responsible for the requirements study, by interacting with the business, to gather the requirement for the Migration process/Enhancements/New Development
• Involved in Cognos Installation, Upgrade, patch fixes and Migration activities.
• Report enhancements and bug fixing for existing reports.
• Account and Administration management, user management for all the BI applications.
• Formulate Reporting strategy for the Upgrade/Migration requirements
• As a part of Production support maintenance activity, responsible for resolving
• BI failures, providing quick fixes for critical issues, Data Quality issues (raised in the form of tickets by the users) within the SLA.
• Monitoring workflows, resolving session failures which would be notified through Email alerts.
• Responsible for Outage management, communicating business about the Outage, Scheduling/Un - scheduling Workflows per the Outage schedule.
• Analysing root cause of repeated failures, raising change request to avoid such issues in future responsible for the maintaining service level SLA's.
• Providing periodic status reports as required by the client
• Participating in Client meetings on Integration projects Design and Development projects
• Developed and implemented Error Handling strategies
• Performing BI Integration/System Testing activities for the Change request developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives. A keen communicator with honed problem solving & analytical abilities.

Confidential

Platform: Composite Studio, Composite Manager, Composite Server 5.2Composite Server 6.1, Oracle 11g/10g & Linux

Team Leader

Responsibilities:

• As a part of support activity, responsible for resolving EII failures, providing quick fixes for Critical issues, Data Quality issues (raised in the form of tickets by the customer) within the SLA.
• Monitoring workflows, resolving session failures which would be notified through email alerts.
• Responsible for the requirements study, by interacting with the business, to gather the requirement for the Migration process/Enhancements/New Development
• Involved in Composite client/server Installations, configurations Upgrade, patch fixes and Migration activities.
• Enhancements and bug fixing for existing EII layer.
• Account and Administration management, user management for all the EII applications.
• Responsible for Outage management, communicating business about the Outage Scheduling/Un - scheduling Workflows per the Outage schedule.
• Analysing root cause of repeated failures, raising change request to avoid such issues in future
• Providing periodic status reports as required by the client
• Participating in Client meetings on Integration project Design and Development
• Performing EII Integration/System Testing activities for the Change request

Confidential

Platform: Cognos 8.3 BI, Framework Manager

Team Leader

Responsibilities:

• Metadata Modelling Complex Report Design & Development Performance tuning Prepare Functional Specifications review document
• Prepare Technical specification documents
• Designing Meta Data Modell s - Packages in Framework Manager
• Performance Tuning and load Balancing of complex reports
• Export and Import of Packages and Reports for Deployment
• Developing Cognos 8.3 Reports in Report Studio Developing Cognos 8.3 Reports in Report Studio

Confidential

Platform: Cognos 8.3 BI, Framework Manager

Team Leader

Responsibilities:

• Prepare Functional Specifications review document
• Prepare Technical specification documents
• Performance Tuning and load Balancing of complex reports
• Export and Import of Packages and Reports for Deployment
• Developing Cognos 8.3 Reports in Report Studio

Confidential

Platform: Cognos 8.3 BI, Framework Manager, Oracle, DB2

Team Leader

Responsibilities:

• Installed Cognos 8.3 in Windows and as well as in Linux Platforms
• Prepare Technical specification documents
• Designing Meta Data Model s - Packages in Framework Manager
• Performance Tuning and load Balancing of complex reports
• Export and Import of Packages and Reports for Deployment
• Developing Cognos 8.3 Reports in Report Studio
• Handling business queries/issues
• Maintaining test cases and test results.

Confidential

Platform: Cognos Impromptu 7.3, Power-Play / Transformer, Oracle

Team Leader

Responsibilities:

• Preparing Effort estimation for Impromptu Reports as well as Power - play cubes.
• Creation of Catalog.
• Creation of Model in Transformer using IQD.
• Responsibilities:
• Creation of Power-play Cubes

Confidential

Platform: Cognos Impromptu 7.3, Power-Play / Transformer, Oracle

Team Member

Responsibilities:

• Involved in Functional Specifications review document
• Involved in Technical specification documents
• Creation of Impromptu Catalog and IMR(Impromptu Reports)
• Creating IWR(Impromptu Web Reports) in Impromptu Web - server

Confidential

Platform: Cognos Impromptu 7.3, Power-Play / Transformer, Oracle

Team Member

Responsibilities:

• Involved in Functional Specifications review document
• Involved in Technical specification documents
• Creation of IMR(Impromptu Reports)
• Creating IWR(Impromptu Web Reports) in Impromptu Web - server