Cognos PowerPlay Infrastructure Resume , NJ - Hire IT People

SUMMARY

7+ years experience in OLAP architecture design, multi dimensional data modeling, data mart design, data security, ETL processes and process modeling.
7+ years experience with developing structured systems specifications, including logical and physical data modeling/design.
Experience with Oracle9i, SQL Server 97, 2000 and 2005 skills
Extensive experience with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
Expertise in PL\SQL, Informatica and SSIS/DTS programming.
Experience in Cognos 7 and 8 tools, installation, administration, security, data modeling and report authoring.

TECHNICAL SKILLS:

Data Modeling: Architect, Erwin
ETL: Informatica, SSIS, DTS, Talend
RDBMS: Oracle 9i (TOAD), PL/SQL, MS - SQL Server 7/2000/2005 and DB2 stored procedures DBMS: Dbase, MS-ACCESS
Cognos Tools: Cognos 8.x, ReportNet 1.x, Impromptu 7.x, Transformer 7.x, PowerPlay 7.x, Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, IWR (Impromptu Web Reports), PPES (PowerPlay Enterprise Server), Upfront
Security: Access Manager 7.x
Business Objects Tools: Desktop Intelligence, Supervisor, Designer, Broadcast Agent
Business Intelligence: Billing, G/L, A/P, Bill of Materials and Production, Order Entry and Fulfillment, Shipping, Oracle Financial Foundations and Trade Management.
Internet Technology: VBScript, Java Script, ASP, HTML, XML and DHTML
Programming: C, C++, ASP, Visual BASIC, JAVA

PROFESSIONAL EXPERIENCE

Confidential, NJ

Cognos PowerPlay Infrastructure

Responsibilities:

Installed and configured PowerPlay infrastructure for development, integration and production environments.
Prepared documentation for end users
Prepared installation and configuration guides for knowledge transfer.
Provide expert knowledge on building and automating cubes.

Confidential, PA

Cognos 8, PowerPlay, Business Objects, Informatica, SQL Server, Oracle - Data warehouse

Responsibilities:

Lead administration and full life cycle reporting environment.
Lead project to developed, administer and maintain multiple data marts in reporting environments.
Developed ETL programs using DTS, SSIS and Informatica for daily data mart updates in SQL server and Oracle.
Lead projects to performed Cognos upgrades as they became available in a multi server environment from 7.1 thru Cognos 8.2 including tools Access manager, Impromptu, Framework Manager, Report Studio, Query Studio, Analysis Studio and PowerPlay.
Lead projects for upgrades and administration of SQL Server from 7 thru 2005.
Installed and trained users on the use of Business Objects tools.
Installed multi server Bi environment, customized and administered the Cognos Tools.
Developing Framework Manager abstract and business models for reporting.
Developed and automated creation of PowerPlay models and cubes using Transformer.
Setup and administered security for the Business Intelligence environment.

Confidential, NJ

ReportNet on DB2 production database

Responsibilities:

Created business models for reports and queries. These models were based on DB2 production database.
Published business models to the ReportNet Portal.
Created report studio reports and queries using the business models.
Determined feasibility of R eportNet to develop reports using stored procedures.
Tested new ReportNet summaries and details reports against production focus reports.

Confidential, NJ

Impromptu and Power Play on Oracle 9i Data Warehouse

Responsibilities:

Automated Power Play cube creation and publishing to the WEB.
Developed report studio reports and power play cubes.
Performed data mart for the validation and ETL process validity.
Created and maintained catalogs using Cognos Impromptu.
Created complex BI reports using Cognos Impromptu and PowerPlay.
Performed validation to analyse Source and Data warehouse data using TOAD and PL/SQL.
Created Impromptu query definitions to be used in Transformer model as data sources.
Created Drill through and prompts reports in impromptu and Power Play.
Created new models for OLAP cubes in Cognos Transformer for use in Power play.
Tested report summaries and details against data warehouse data.