Cognos Project Lead Resume

SUMMARY

Cognos and IBM Certified with having 10 years of Experience in the Analysis, Design, Development, Administrating, Testing, Maintaining and Implementation of Business application systems for Insurance, Banking, Financial and Retail Sectors.
Extensive experience on DB2, ORACLE 11g, SQL SERVER2000/2005 & Teradata databases
Technical expertise in Design and Development of Data Warehouse modeling with a good understanding of star schemas, fact tables, and dimension tables.
Experience in Installation, Configuration, Monitoring and Managing of Cognos & Oracle on Windows platforms.
Involved in the Cognos 8.4 /10/10.2 Administration like Creating Datasource Connections, Publishing Transformer cubes to the server as a Package and Publishing FM Packages and Assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers
Experiences in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.
Experience in Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations.
Expertise in Cognos Transformer, Framework Manager using dimensional modeling, SDK, Report Studio, Analysis Studio, TM1, Active Reports, Dashboards, Event Studio and Query Studio.
Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
Excellent in problem solving, logical and analytical abilities.
Good Exposure of interaction with client, clear understanding of business requirements with excellent interpersonal, communication and organizational skills.
Have expertise in posting and executing test cases in HP Quality Center and defect handling.
Lead GM Development team of 5 members with outstanding client admirations and provided maintenance for several months.
Created and deployed Work orders and resolved problem request tickets on Remedy incident management (OMAR) tool and Peregrine or using ITSM.
Expertise in utilizing Secured Shell Client tool for interacting with UNIX operating system, Citrix Client and VPN for remote server connectivity.

TECHNICAL SKILLS

BI Tools: Cognos 10.2 BI, Actuate, Crystal reports.

Databases: Oracle 11g/10g/9i/8.x, SQL Server 2005, DB2, Teradata

Modeling: Erwin, TOAD, SQL*PLUS, SQL Developer

Data Masking Tools: File - Aid 5.3, DMSuite

Languages: SQL, PL/SQL, VB, HTML, XML, Java, J2EE

OS: AIX, Windows 2000/XP/NT, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Cognos Project Lead

Responsibilities:

Involved in Designing of complex Dynamic sorting reports.
Lead the Onshore Teams of 6 Cognos developers.
Implementing the complex solutions using java programs.
Meeting various Application owners and understanding their requirements
Worked on Cognos scheduler password reset issue under single sign on environment .
Written Java & Java Script Code whenever it is necessary and integrated with the Cognos reports.
Involved in Cognos & Dmitri E79 reports integration.
Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations
Designing the Reports, Dashboards and Framework Model using Dimensional Modeling based on the client requirement.
Monitoring Report performance, troubleshooting and system configuration
Providing technical direction required to resolve complex issues to ensure the on-time delivery of solutions that meet customer expectations.

Environment: Cognos 10.2, Oracle11g, DB2, PLSQL Developer, Toad, Dmitri E79, Advanced Java, Windows/Linux.

Confidential, Atlanta

Senior Cognos Consultant / Architect

Responsibilities:

Involved in Design and Development of Data Warehousing model/schema.
Lead the Offshore Team of 6 Cognos developers.
Meeting various Application owners in Newyork Life and understanding their current Problems and providing them a dynamic solution using different procedures.
Installation and Configuring of servers in client environment.
Performance tuning of oracle queries and procedures to run the Reports faster.
Involved in administration of granting and revoking privileges to the customers.
Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations
Designing the Reports, Dashboards and Framework Model using Dimensional Modeling based on the client requirement.
Integration of Cognos TM1 cube with Cognos BI
Building TM1 Cubes as per the client requirement.
Involved in applying security, promotion and support for cognos environment.
Monitoring Report performance, troubleshooting, diagnostics and system configuration
Providing technical direction required to resolve complex issues to ensure the on-time delivery of solutions that meet customer expectations.

Environment: Cognos 10.2, TM1, Oracle11g, DB2, Toad, Irwin, shell Scripting, windows/Linux, MS Visio, File-Aid, DM Suite, Java.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship