SUMMARY

• Cognos Certified Professional wif 8+ years of total IT industry experience in analysis, design, testing, development and implementation of client/server applications.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS 10 /8 /7 Suite and CognosReportNet.
• Experience and expertise in Cognos 10 / 8 BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric Studio,Event Studio and Query Studio)
• Experience and expertise in CognosReportNet 1.1, Cognos Impromptu 7.x, Cognos IWR 7.x, and Analysis Tools such as Cognos Transformer & Power Play 7.x
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building wif Report Studio.
• Expertise in relational and dimensional (DMR) modeling.
• Expertise in Report building using Report Studio and Analysis Studio.
• Expertise in creating Dash board reports and using HTML,Java Script in Report studio.
• Experience in Transformer model design and Power play cube building.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Experience in databases such as Oracle8i/9i/10g,SQL SERVER 2000/2005/2008,DB2 and Teradata.
• Has demonstrable experience working wif Dimensional modelling including understanding Facts and Dimensions, star and snowflake schemas, and OLAP tools and techniques.
• Has technical knowledge regarding best practices of Cognos configuration and customizations including teh Cognos SDK.
• Experience in writingSQL, T - Sql,PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per teh business needs.
• Lead all phases of projects from design to implementation including specifications, development, testing, implementation, rollout, and support.
• Used Informatica 8.x (Source Analyzer and Warehouse Designer) to import teh source and target database schemas and teh mapping designer to map teh sources to teh targets.
• Experience in Installation and configuring teh Cognos 10/8 and CRN environment, implementing third security tools Tivoli directory Server and Sun One wif Single Signon.
• Strong understanding of data warehouse concepts & proficiency wif advanced SQL.
• Excellent interpersonal and communicationskills, technically competent and result-oriented wif strong problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Cognos 10.1/8.2/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio), Cognos Impromptu 7x, Power Play 7x, IWR, Upfront, Cognos 8 SDK, MS Excel,Access

ETL: Informatica 8x

Databases: Oracle 8i/9i/10g, Nateeza, SQL Server 2000/2005/2008, DB2,Teradata V2R6

Operating Systems: Windows 2003 Enterprise Server, XP, Windows 2000, UNIX

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

PROFESSIONAL EXPERIENCE:

Confidential, WISCONSIN

SrCognos Consultant

Environment:Cognos 10/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Powerplay Transformer, Nateeza, Oracle 10g,Cognos Access Manger, Windows 2003 Server,Informatica.

Responsibilities:

• Participate in requirements gathering meetings and be teh BI subject matter expert.
• Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements.
• Design and Developed teh Framework Manager models and Published into server.
• Created DMR package in Framework Manager for use by Analysis Studio Users.
• Created packages in Framework Manager to publish cubes to AnalysisStudio
• Created cubes in Transformer using Framework Manager IQD’s, packages and reportstudio reports as a source.
• Design & development of teh reports using Cognos 10/8 Report Studio, Analysis Studio reports.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Troubleshooting all Cognos Series 8 environment issues, Power play cube performance issues.
• Implemented Star Schema Grouping and Dimensional Hierarchy in Framework Manager Model.
• Developed models in Cognos 8.4 Framework manager and 8.4 Transformer.
• Created Dashboard reports.
• Created Dash board reports to get all teh information from other reports.
• Developed Cognos Portal integration &Cognosportal design.
• Implemented XML and HTML coding in Report Studio.
• Designed models by mapping business needs using Power Play Transformer and created multi-dimensional cubes, cube groups, Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Worked wif Analysis Studio to develop multi-dimensional reporting.
• Worked wif Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP).
• Extensively worked wif Stored Procedure Query Subjects in Framework Manager and Reports.
• Developed various Mappings and Workflows in Informatica as required by teh Design specifications.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality.
• Involved into move to Deployment to UAT and Production.
• Testing reports using review checklists for Quality Assurance before delivering to teh end users.

Confidential, PHOENIX

Cognos Architect

Environment:Cognos8.4/8.2,Transformer,Powerplay Windows/web and upfront), MS Excel,Oracle 10g,SQLServer 2005/2008, Informatica 8.x

Responsibilities

• Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements.
• Installed & configured teh Cognos 8.4 BI Environment, Administering teh Servers, Troubleshooting, and Performance Tuning.
• Developed and Published Packages in Framework Manager - Connecting and testing teh data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and Developed teh Framework Manager models using Stored procedures,Relational tables and published in to server .
• Created cubes in Transformer using Framework Manager IQD’s, packages and reportstudio reports as a source.
• Upgraded reports from Cognos 8.2 to Cognos 8.4 using Upgrade Manager.
• Used Dimensional modeling (DMR) and Snow flake Schema modelingtechnique to develop models.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Customizing Cognos Connection Portal based on user specifications.
• Designed Reports using most of teh Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through,Drill Down, Drill Up).
• Experience in writing wif HTML/Java Script in Cognos report studio reports as per teh requirements.
• Developing teh Dashboard reports using Cognos Report Studio and Metric Studio.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Worked wif Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports wif Prompts (List, Cross tab).
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Oracle PL/SQL Stored Procedures, Functions, Cursors for use by Framework Manager Packages and Report Studio reports.
• Worked wif Analysis Studio to develop multi-dimensional reporting.
• Java Script for complex validation, navigation, communication and format customization.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.

Confidential, MI

Sr. Cognos Developer

Environment: Cognos8.2 Suite (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Office Connection),Java script, XML, HTML, Transformer 8.4, Oracle 10g, SQL server 2005.

Responsibilities:

• Developed Cognos8.2Reportsusing active reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Worked wif Data modeling tool Framework Manager Using Different Data Sources like Oracle, SQL Server 2005 Data Sources.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• CreatedPackages wif various security settings and published them ontoCognosConnection.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports wif custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Created roles in Cognos connection and Access permissions were given to users.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move teh Cognos Framework Manager model from development, test environment to production environment.
• Testing teh developed reports for final deployment.
• Teh work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 8 BI v8.4.
• Created simple and ad-hoc reports using Query studio.
• Scheduled teh reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Create SQL queries using Oracle, SQL Developer to verify accuracy of Cognos reports.
• Trained teh end users to effectively use teh reporting tool to build and customize their ad-hoc reports
• Involved in performance tuning of teh reports in Report Studio.
• Coordinated wif functional users for User Acceptance Testing prior to releasing system changes in production.

Confidential, NJ

Cognos Developer

Environment:Cognos 8.0/8.1 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Event Studio),Reportnet 1.1 MR2, Oracle 9i, Impromptu 7.4, HTML.

Responsibilities:

• Developed Data models in Framework Manager.
• Implemented different types of securities in Framework Manager.
• Developed parameter map in Framework Manager for dynamic date selection in Cognos report level.
• Developed advanced reports using Report Studio and ad hoc reports using Query Studio.
• Created various reports like List, Cross tab, Drill Through, Summary Details, link, Charts etc.
• Migrated from Cognos 7 series to Cognos 8.
• Migrated CognosPowerPlay series 7cubes using Migration Utlity and imported in to Framework manager Cognos8, created teh packages for publishing.
• Scheduled various reports using teh Schedule Management feature wifin Cognos Connection.
• Data validation of reports using query studio, framework manager and report studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Designed models &OLAP cubes in Cognos 7.2 Transformer using existing IQD’s from Framework Manager.
• Created Multi-Dimensional reports using Power Play.
• Worked on Drill down, slice and dice and change displays.
• Portal page development wif HTML references to report views.
• Performance tuning of Cognos Reports and FM model.
• Worked on saving reports to external file system.
• Implemented numerous Cognos report view to display as single report using java script.
• UsedDDL, DMLscripts for modifying database objects required for reporting.
• Documented teh process of for deployment from development to production.

Confidential

Cognos Developer

Environment::SQL Loader, SQL, PL/SQL, DB2, Oracle 8.x, Cognos Impromptu 7.0, Impromptu Web reports (IWR), Power Play, Transformer, Toad, Windows 2000/ UNIX

Responsibilities:

• Created Multiple Reports wif Cognos Impromptu and Power Play.
• Created LIST, Group and Cross tab reports wif Drill Through functionality
• Created business Mix and Reports for Comparison
• Created Multi-Dimensional Cubes using Power play Transformer for multidimensional (IQD) reports.
• Drill Down and Drill Through functionalities were used in teh cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Developed solution models for Ad-hoc reports.
• Used Cognos Transformer to build Multidimensional cubes and used it in Cognos Power Play to build graphs and charts of sales data.
• Involved in optimizing power Cubes.
• Developed Impromptu Web Reports and published them into Upfront.
• Provided outstanding Onsite support.

Confidential

Jr. SQL Developer

Responsibilities

• Used SQL* LOADER to load data into table space.
• Connected to Remote Data Bases using Data Links and pulled required data.
• Designed and developed front-end application using CGI/C++ programming. Insert, update and deletion were done using these forms.
• Handled Complex queries wif TRANSLATE & DECODE.
• Granting access to different users for teh system
• Modifying teh profiles of different users
• Development and report generation.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality

Environment: Oracle 7x, PL/SQL, SQL*PLUS, SQL*LOADER, SQL Scripts, Develope