Summary

• Over 5 years experience in analysis, design, development and implementation of business intelligence solutions using COGNOS.
• Hands on experience in Cognos8 Query Studio, Report Studio, Analysis Studio, Metric Studio Score-carding , Framework Manager, Cognos Connection and Cognos Series 7.x Cognos ReportNet 1.1, Cognos Impromptu, PowerPlay Transformer, Cognos PowerPlay .
• Strong experience in creating and publishing packages in Framework Manager.
• Strong complex reporting skills complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• Experienced in developing Dashboards Reports in Cognos 8
• Expertise in Oracle 10G, 9i and MS SQL Server 2000 2005
• Experience in migrating Impromptu/IWR reports to ReportNet 1.1 and Cognos Series 7 to Cognos8.
• Experienced in configuration administration of Access Manager.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modeling using Star Schema and Snow-flake Schemas.
• Knowledge in Planning, Designing, developing and deploying data warehouses / Data Marts with experience of both relational multidimensional database design using Data Modeling tool ERwin Physical and Logical data models
• Excellent communication and interpersonal skills.
• Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

Technical Skills:

OLAP tools:

• Reporting Analysis: Cognos 8i 8.1-8.4 , Cognos ReportNet 1.x, Cognos Framework Manager, Report Studio, Query Studio, PowerPlay, PowerPlay transformer, Impromptu web reports, Cognos Query, Upfront, Crystal Reports, and Jasper Reports.
• Security: Access Manager
• Methodologies: Star, Snowflake Schema
• RDBMS databases : MS SQL Server, Oracle 10G PL/SQL , MS Access
• Scripting Languages: Java script, VB script, Dhtml, Html
• Server Side Scripting: ASP, Java Servlet
• Operating Systems: Windows NT/2000/98/95, MS DOS, UNIX

Project Experience

BI Developer

Orbitz is a leading online travel company offering leisure and business travelers a wide selection of low airfares, as well as deals on lodging, car rentals, cruises, vacation packages and other travel. The site was created to address consumers' need for a comprehensive display of fares and rates in a single location.

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the cognos 8 Server.
• Upgrading of reports from series 8.1 to series 8.4
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments development,testing and production
• Deployed the reports from development to testing and from q/a to prod through deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 portlets.
• Administer user access protocols and created user accounts and access privileges

Environment:- Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler ,XML and Windows NT/4.0

Confidential

Cognos Consultant Worked

Responsibilities:

Analyzed the existing Oracle Form based Client server System. Analyzed the Datamart. Created the Design Specifications for the Requirement Specification Worked on Data Mapping for the models. Created the Framework Manager Models. Provided the prompts in Query Studio Created predefined Filters for the Adhoc users. Applied three levels of security to the model Data, Object and Package Published the models in Development Environment and applied the Folder security and access capabilities for the users Migrated the reports to Test Environment. Ensured that it works fine when migrated to Test and good to go for Production. Working on the migration of reports to test to Production Environment. Converted Complex Power-Prompt Reports into Cognos 8 Reports. Implemented Prompt skipping in Cognos 8 Reports. Worked on Access Manager for administration purpose.

Environment: Cognos 8.4 Framework Manager, Report Studio, Query Studio , Oracle 10 and Windows Server 2003.

Confidential

Cognos Developer

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated Complex reports in Cognos 8.1 8.3 report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Created list reports cross tab reports using cognos 8.1 8.3
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Environment: Cognos 8.3 Framework Manager, Report Studio, Query Studio, SDK , Decision Stream 7.1, Cognos 7.x, Oracle 9i and Windows 2003.

Confidential

BI Consultant

As a BI consultant, created Online and Data warehouse Reports for DSS. Spider focuses on providing a web based system, enhancing timeliness and availability of information regarding the children under the care of Department of Social Services, MA. Created User interface for entering the data about the Foster Care children under DSS care.

Responsibilities:

Analyzed the existing Oracle Form based Client server System. Created a Reporting requirement Document which contains information about the Reporting structure. Created Framework Manager Models and Published packages. Created Model Filters and Calculated columns in the model level. Designed the Report for Log of Consumers Served which provides the information about the resources and the kids under the DSS care. Tuned the performance of the report. Hands on experience in Cognos 8. Migrated Impromptu Catalogs to Framework Models. Worked on migrating reports to Cognos 8 in the test environment. Formatted the migrated reports with the help of Cognos 8 BI tools. Designed and published OLAP data in Analysis Studio for Analysis. Created Dashboards using Metrics Designer and Metrics Manager. Designed a cube for their warehouse data. Created the IQD's using Framework Manager. Published the cube on PPES. Created a drill through from the cube to the report where the Analytical data can be drill through to get the detailed report. This cube displayed the Recurrence Percentage of Maltreatment of the kids. Created the calculated categories and measures for the cube. Facilitated the users to work on the cube and reports.

Environment: Cognos 8, ReportNet 1.x Framework Manager, Report Studio, Query Studio, SDK , Cognos 7.3, J2EE Framework, Oracle 9i and UNIX.