SUMMARY

• Over 8 years of working experience with Cognos 10.2/10.1/8. x BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio).
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
• Experienced of Cognos 10 TM1 Insight and Performance Modeler for building Applications, Cubes, Dimensions, Replications, Processes and models
• Experienced in Cognos TM1 Turbo Integrator mapping and Rules Editor, Worked on Creating Dimensions and Cubes in Cognos TM1
• Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management.
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail, and Cascading) and Dashboards using Report studio.
• Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2
• Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development.
• Involved in training end users and providing technical support and documentation.
• Ability to adapt and learn new technologies and to get proficient very quickly with them.

TECHNICAL SKILLS

BI tools: Cognos10.2, 10.1,8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer

ETL Tools: Informatica 8.6, Data stage 7.5

Databases: Oracle 9i/10g/11g, Netezza, SQL Server 2008, Teradata, DB2

Languages: C, C++, Java, VB.net

Scripting: VB Script, Java Script, HTML, CSS

DB Tools: SQL *Plus, SQL *Loader, TOAD 8.3, IBM Data Studio

Web Servers: IIS, Apache

PROFESSIONAL EXPERIENCE

Confidential, NYC NY

Sr. Cognos Developer/TM1 Developer

Responsibilities:

• Created Business Requirement Specification in collaboration with the Business analysts as per user requirements.
• Created several cubes,dimensions and TI processes implementing best practices
• Created a dynamic excel templates by creating temporary view,export data to excel and destroy the view
• Expert in writing TM1 rules
• Designed workflow in TM1 application with manager dimension allowing managers to approve or reject forecasted values using picklists
• Extensively used TM1 Perspectives for Excel to slice the cube and also worked with spread sheets to Create TM1 applications and made available through TM1 web
• Design metadata models, create and publish packages using Cognos Framework Manager - Identify data sources, import query subjects, organize into layers, define appropriate relationship between query subjects.
• Designed and developed dashboard style reports (Outpatient Analytics, IDTF Analytics, Case Management Analytics) using Cognos Report studio
• Created List, Cross tab, Chart, Master Detail reports, drill through and custom prompting reports, worked with HTML items/Java Script in Cognos Report Studio to customize reports.
• Implemented filters, calculations, conditional formatting and prompts in various reports created using Cognos Report Studio.
• Created reports using Query Unions to merge multiple Query Items into one for reporting purpose.
• Created reports using Native SQL in Cognos Report Studio.
• Created Jobs in Cognos Connection with multiple reports and scheduled these jobs to run on recurring basis.
• Deployed Packages and Reports from Dev Environment to UAT and Production Environments.
• Setup and monitor schedules, setup burst options in Cognos as per user requirements.
• Performance tuning by analyzing and comparing the turnaround times between database queries and Cognos reports.
• Trained the end users in effectively using the reporting tool to build and customize their ad-hoc reports.
• Coordinated with functional users during User Acceptance Testing prior to deploying reports to production.
• Created documentation for the complete project life cycle and mentored the End Users and Provided Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Transformer, Report Studio, Query Studio, Cognos Connection, Cognos Administration), Netezza, TOAD, Java Script, Data Stage.

Confidential, Virginia Beach VA

Sr. Cognos Developer

Responsibilities:

• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.2.1
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Deploying models and reports from Development to Production and administering users/groups/roles.

Environment: Cognos 8.4/10.2 (Framework Manager, Transformer, Report Studio, Query Studio), Oracle 11g, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Data Stage, zLinux.

Confidential, Denver CO

Sr. Cognos Developer / Administrator

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Created metadata models using Framework Manager with relational data and deployed packages to the Cognos Reporting Servers
• Designed and Developed DMR models using regular & fact dimensions in Framework Manager
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Implemented Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting
• Developed dimensional models in Transformer, built cubes and published cubes to Cognos Portal
• Involved in Upgrading Cognos reporting application from Cognos Version 8.4 to 10
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator, PL/SQL, Java Script, Informatica 9, AIX.

Confidential, Jacksonville FL

Sr. Cognos Consultant

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.
• Created Metadata Modeling importing query subjects from multiple databases in Cognos Framework Manager.
• Created and published packages from Cognos Framework Manager.
• Created Complex Reports in Report Studio, PowerPlay Reports using Analysis Studio.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Developed List, cross tab, drill through and complex reports which involved multi-queries.
• Extensively used Power play Transformer to create powercubes loading data from datamarts.
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.
• Did Unit Testing for all reports and packages.
• Creating report views with saved prompts and schedule according to the business requirement.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Personalized Cognos Connection, Specified display options, regional options and personal information.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL, Informatica 8, UNIX (Sun Solaris).

Confidential

Cognos Developer

Responsibilities:

• Designed metadata models creating Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and Prompts depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of ad-hoc queries and for improving various performance issues.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Involved in monitoring Data stage jobs/processes and generating reports after successful job scheduling.
• Tuned performance of Data stage sessions for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval.

Environment: Cognos 8, Transformer 8, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 SDK.