Recruiters Blog: Cognos Developer

I am Venu working as Cognos Developer. My project is just completed at CA and looking for another project anywhere in the US. I am furnishing the summary of my professional details below. Please let me know if you have any good requirements for my skill set.

My total experience is 8 years with the following skills:
Skill Data warehousing (8+ years)

Skill Oracle (7+ years)

Skill Cognos API, (3+ years)

Domains:
Pharmaceutical, Energy, Production support, Health care and Insurance

8+ Years of experience in Business intelligence reporting, development, analysis, design, testing, implementation and maintenance of Web applications, Database, Data warehouses and Data Marts.
Strong experience in using BI Tools Cognos 8 BI, Report Net 1.02/1.1 including Framework Manager, Impromptu Administrator & Impromptu Web Reports (IWR), Analysis tools such as, Analysis Studio, Metric Studio, Power play Transformer, Power Play Enterprise Server, Cognos Go Office, Cognos Enterprise Planning
Strong experience in using ETL (Extraction, Transformation, and Loading) utilizing Informatica5.x/6.x/7.x (Power Mart/Power Center) and Cognos Data manager.
Involved in Installation, Configuration, and Administration of Cognos 8 BI, Report Net Suites
Extensively worked on Report Studio to build various types of complex reports.

· Applied conditional formatting, conditional blocks, and different kinds of prompt for different functionalities in the reports.

· Written Java Scripts for additional functionality for Reports using Cognos 8 BI and Report Net Report Studio.

· Created Scorecards in Metrics studio.

Experienced in Cognos 8 bursting.
Good Knowledge in Cognos SDK

· Expert at creating Multi-dimensional Cubes for corporate data using Power play Transformer.

· Solid understanding of data warehousing OLTP and OLAP concepts.

· Migrated reports from development environment to production environment.

Experienced in Upgrade/Migration from Cognos 7 to Cognos 8 versions.
Experience in Security Implementation in Cognos 8 BI, Report Net, on various levels using third-party security providers like LDAP, Active Directory.
Experienced in Auditing, monitoring, troubleshooting and production support for Reporting Applications and infrastructure.
Experienced in BI server administration, Portal administration and schedule management
Experienced in administrative tasks such as managing Standby Server, Load Balancing, Single sign-on and customization of Cognos Report Net portal.
Experienced in data warehousing lifecycle, concepts, architecture, design methodologies, in creating enterprise wide Data warehouses and Data Marts, Data Models
Good experience in dimension modeling (star/ snowflake schema),
Strong Exposure to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, Teradata and SQL Server2k/7.0 databases.
Experience in developing applications using Oracle 10g/9.x/8.x/7.x, Forms, Reports, SQL * Loader, SQL, PL/SQL, SQL Server 2000/7.0/6.5, DB2, Teradata and MS Access
Extensive experience in creation of ETL mappings and transformations using Informatica Power Mart / Power Center to move data from multiple sources into target area
Presented proof of concept demos on Cognos 8 features to the business

Technical Skills:

BI Tools: Cognos 8 BI 8,8.1,8.3, Report Net 1.0/1.1 (Framework Manager, Report Studio, Query Studio, Cognos configurations), OLAP Modeling, Metrics Server, Metrics Modeling, Cognos Impromptu Administrator 6.x/7.x, Power Play 6.x/7.x, Upfront, Power play Transformer, Access Manager, Decision Stream, Impromptu Web Report Server (IWR), Power play Enterprise Server, Metrics Manager, Scheduler, Visualizer, Macros, Crystal Reports.

ETL Tools: Informatica5.x/6.x/7.x, Cognos Decision Stream 7.1

Languages: Java, Java Script, HTML, VB 5/6, VB Script, SQL, PL/SQL C, C++.

Operating System: UNIX (Sun Solaris, HP US), Windows 95/98/NT/2000/XP

GUI: Developer/2000 (Forms 4.5/5.0, Reports 3.0/2.5)

Web Servers: IIS, iPlanet Application Server, Netscape Directory Server and FTP

Databases: Oracle 7.x/8.x/9.x/10g, SQL Server 2000/2005, DB2, MS Access

Education & Certifications: