SUMMARY

• 8+ years of experience in Business Intelligence with Cognos 10, 8 series, Report Net 1.1 and Cognos 7 series
• Experience in full life cycle of Software Development such as Analysis, Design, Development, Customization, Testing and Deployment
• Worked in different projects which are implemented using Agile Methodology.
• Extensive experience on Framework Manager, Report Studio, Analysis studio, Query Studio, Event studio, Transformer, and Metric Studio
• Expertise in creating complex reports in Cognos Report Studio such as List reports, Cross - tab reports, Drill through reports, Master-Detail Reports and Cascading Reports and involved in reports performance tuning
• Experience in Metadata Modeling both Relational and Multi Dimensional model
• Created Projects, Models using Cognos Framework Manager and published packages to Cognos Server for reporting authoring
• Created Dimensionally Modeled Relational in Framework Manager and created analytical reports using Analysis Studio
• Experience in Reports Migration such as from one environment to another and from Cognos 7 to Cognos 8
• Experience in developing dynamic Dashboards and Scorecards
• Involved in teh Design, Development and Implementation of teh Cognos Multi Dimensional Power Cubes using Transformer
• Experience in optimizing cube performance
• Developed several reports using Cube’s as data source, OLAP reports.
• Implemented Data Security, Object Security, Package Security in Framework Manager and created user classes, roles or groups as per teh requirement
• Experience in Using Cognos connection
• Experience in analyzing teh data using different querying tools.
• Experience in understanding teh existing database with teh halp of ERD’s or any other available documentation.
• Experience and noledge of Data warehouse and RDBMS concepts, dimensional modeling using Star Schema and Snow-Flake Schema
• Enhanced reports to improve efficiency.
• Strong systems analysis, problem solving, and design skills
• Knowledge of Crystal reports.
• Experience in translating users reporting requirements into technical models by developing requirements specification document.
• Strong experience in client interaction and understanding business applications
• Experience in prioritizing teh work as per teh deadlines or deliverable dates.
• Experience in training users on how to use teh reports.
• Experience in performing Cognos Administrative Jobs.
• Excellent analytical and communication skills, technically competent and has strong problem solving skills
• Experience in performing team lead activities and coordinating between onshore and offshore team.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10.2, Cognos 8 (8.1,8.2,8.3,8.4), ReportNet 1.1(MR3,MR4), Cognos 7.x, Report Studio, Query Studio, Framework Manager, Analysis Studio, Metric Studio, Event Studio, Data Manager, Access Manager, Transformer, PowerPlay, PowerPlay Web, Upfront, Impromptu Administration, IWR and PPES, Crystal Reports 11.5

Databases: Oracle (10g,8i,9i), MS SQL Server(2005, 2008), DB2, Teradata, MS Access

Querying Tools: SQL*Plus, TOAD, PLSQL Developer, SQL Assistant

Data Modeling: Logical and Physical Data Modeling, Star Schema, Snow-Flake Schema Data Modeling(Relational, Dimensional), Erwin 4.0/3.5, Visio

Operating Systems: Windows(98,NT,2000,XP,Vista,7), UNIX( Confidential AIX, HP-UX), DOS

Directory Servers: LDAP server, Active Directory Server

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, NC

Cognos Lead / Architect

Responsibilities:

• Gathering requirements from users and writing requirement specifications document.
• Managed team of 4 members in assigning them tasks and planned efficiently to meet various deadlines.
• Building Framework Model/Metadata Model based on teh reporting requirements.
• Provided estimates of work effort and status updates on work completion
• Escalating issues to teh respective roles.
• Designing and developing teh reports using Cognos Report Studio
• Created several complex reports having numerous prompts and joins using java scripts and SQL Queries.
• Scheduling Reports and Jobs to run periodically.
• Working with Drill- through definitions to drill through from summary reports to detailed reports.
• Used different types of Aggregate and Rollup Aggregate functions to display detail and summarized values at different grouped levels
• Wrote Java Scripts and macros for some complex report’s.
• Performing reports Deployment to UAT and Production
• Developed Dashboards using Business Insight Advanced.
• Worked closely with DBA and ETL team, in order to optimize teh table’s and views for teh reporting needs.
• Wrote several SQL queries to analyze teh data for reporting needs and if any issues exist.
• Interacting with teh End users on a regular basis for resolving issues pertaining to teh reports as a part of User Acceptance Testing
• Created separate instance of Framework model with easy to use tables & simplified table names for users to use in Query studio.
• Trained users in Query studio to develop their own ad-hoc report using teh Framework model.
• Implementing Data Security, Object Security, Package Security in Framework Manager
• Implementing report level security and folder level security in Cognos Connection
• Creating User groups, roles to implement teh Cognos Security using LDAP

Environment: Cognos 10.2 (Report Studio, Query Studio, Framework Manger, Business Insight Advanced), DB2 9.7

Confidential, WI

Sr. Cognos Developer/Administrator

Responsibilities:

• Gathering requirements from users located at different DC’s and writing requirement specifications document.
• Building Framework Model based on teh reporting requirements.
• Build cubes using Cognos transformer based on teh needs.
• Assigning teh work of developing reports to offshore developers, monitoring their work status and updating it in teh daily meeting.
• TEMPEffective communication with onshore technical leads, offshore team of Cognos requirements and design
• Provided estimates of work effort and status updates on work completion
• Escalating issues to teh respective roles.
• Designing and developing teh reports using Cognos 8 Report Studio, Analysis Studio
• Scheduling Reports and Jobs to run periodically and provided option of Bursting
• Working with Analysis Studio to develop multi dimensional reporting
• Created Dashboards with different data sources.
• Working with Drill- through definitions to drill through from analysis studio reports to report studio reports
• Implementing Data Security, Object Security, Package Security in Framework Manager
• Implementing report level security and folder level security in Cognos Connection
• Creating User groups, roles to implement teh Cognos Security using LDAP
• Performing reports Deployment to UAT and Production
• Scheduled reports to run in certain time intervals as well trigged teh report’s from event studo by creating tasks and agents.
• Interacting with teh End users on a regular basis for resolving issues pertaining to teh reports as a part of User Acceptance Testing

Environment: Cognos 8.4 (Report Studio, Query Studio, Framework Manger, Analysis Studio, Power Play Transformer, Event Studio), Oracle 9i, PLSQL Developer, UNIX

Confidential, FL

Sr. Cognos Developer

Responsibilities:

• Gathering requirements from Business Process Analyst and Functional leads in teh form of requirement specification documents.
• Created several new reports and resolved teh defects with existing reports.
• Created several ad-hoc reports using Query Studio
• Wrote report specification document as per teh needs of teh requirement by discussing with users and by analyzing teh existing data mart and Frame work package.
• Deployed reports from one environment to other (Dev environment to QA and UAT)
• Created jobs and scheduled burst reports
• Developed a package from scratch and modified several existing packages according to changing reporting needs.
• Implemented security in Framework manager at Data, Object and Package levels
• Created cubes in Transformer using Framework Manager’s IQD’s, packages as a source
• Created special categories for better analysis
• Created several complex reports using java scripts and SQL Queries.
• Worked with Analysis Studio to develop multi dimensional reporting
• Wrote several test cases or test scripts to test teh performance of reports and to ensure successful integration of reports into production environment.
• Wrote several SQL queries in toad to analyze teh data.

Environment: Cognos 8.3 (Report Studio, Query Studio, Framework Manger, Analysis Studio, PowerPlay Transformer), DB2, Toad

Confidential, VA

Sr. Cognos Developer

Responsibilities:

• Gathering requirements from Business Analysts in teh form of Functional specification documents or Functional Requirement documents
• Created models for reporting and published packages to Cognos Server using Framework Manager.
• Created cubes in Transformer using Framework Manager’s IQD’s, packages as a source
• Created Complex reports by extensively using Prompts, Drill-through, master-detail query relationships, Page Breaks, conditional formatting, grouping and sorting features of Report Studio to generate efficient and user-friendly reports
• Converted some of teh existing reports from SSRS to Cognos reports.
• Rebuild some of teh cubes currently existing in SSAS using Cognos Transformer and DMR when needed.
• Created several ad-hoc reports using Query Studio
• Deployed reports from one environment to other (Dev environment to QA and UAT)
• Created jobs and scheduled burst reports
• Implemented report level security and folder level security in Cognos Connection
• Created Reports using Cognos Report Studio and Cognos Query Studio
• Used SQL Server including stored procedures, subroutines and T-SQL
• Interacted with teh End users on a regular basis for resolving issues as a part of User

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio, Power play Transformer), SQL Server 2008 (SSRS, SSAS)

Confidential, NY

Sr. Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users
• Analyzing teh specifications provided by teh clients and developing Technical design specification documents for reports as per client requirements
• Created layered model in Framework Manager which contains Database Layer, Logical Layer and Business Layer
• Created cubes in Transformer using Framework Manager’s IQD’s, packages as a source
• Created special categories for better analysis
• Designed and developed teh reports using Cognos 8 Report Studio, Analysis Studio
• Built some complex reports in Report Studio with Teradata as datasource.
• Scheduled Reports and Jobs to run periodically and provided option of Bursting
• Worked with Analysis Studio to develop multi dimensional reporting
• Involved in reports Deployment to UAT and Production
• Interacted with teh End users on a regular basis for resolving issues pertaining to teh reports as a part of User Acceptance Testing

Environment: Cognos 8.2 (Report Studio, Query Studio, Framework Manger, Analysis Studio, PowerPlay Transformer), Oracle 10g, Teradata, SQL Assistant, MS Access 2007

Confidential, CA

Cognos Developer

Responsibilities:

• Analyzed and understood teh complexity of Cognos 7 Impromptu reports
• Designed HYBRID approach for migrating reports from Cognos 7 to Cognos 8
• Using Migration utilities migrated Cognos 7 Catalog file to XML version and using Framework Manager published dis converted XML file to Cognos Server
• Recreated all reports in Cognos 8 using Report Studio as migration utilities were not migrating reports in better way so we came up with Hybrid approach such as Migration utilities were used for converting Catalog to Package and recreated reports using report studio
• Provided security at Cognos 8 as implemented in Cognos 7 reports
• Involved in validating teh migrated model as verifying teh joins, cardinality and folder structures
• Involved in validating/testing teh migrated reports
• Prepared Testing cases for reports testing
• Prepared documentation for migration process
• Involved in pilot project before going implementing dis Hybrid approach

Environment: Cognos 8 (Framework Manager, Report Studio, Impromptu Administrator, PowerPlay Transformer)

Confidential

Cognos Developer

Responsibilities:

• Interacted with teh users for understanding and gathering business requirements.
• Used Cognos Impromptu Administrator to create Catalog
• Created standard reports using Cognos Impromptu
• Created IQD’s in Impromptu and used these IQD’s as data source for creating cube in Transformer
• Designed models by mapping business needs using PowerPlay Transformer and created multi dimensional cubes
• Designed and Developed dash boards using Visualizer
• Impromptu reports were published to Upfront using IWR
• Used SQL Server including stored procedures, subroutines and T-SQL

Environment: Cognos 7.1(Impromptu, Impromptu Web Reports (IWR), PowerPlay Transformer, PPES, Visualizer, Upfront), Oracle8i