PROFESSIONAL SUMMARY:

• 8+ years of experience in Business Intelligence with Cognos 8 series, Report Net 1.1 and Cognos 7 series
• 1+ years of experience in Cognos TM1 9.4.1
• Experience in full life cycle of Software Development such as Analysis, Design, Development, Customization, Testing and Deployment
• Extensive experience on Framework Manager, Report Studio ,Analysis studio, Query Studio, Event studio, Transformer, Metric Studio and Cognos TM1
• 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 Dimensional model
• Created Projects, Models using Cognos Framework Manager and published packages to Cognos Server for reporting authoring
• Experience in creating different layers in Framework Manager Models based on the business requirements
• Created Dimensionally Modeled Relational in Framework Manager and created analytical reports using Analysis Studio
• Experience in Reports Migration such as migrating from Cognos 7 to Cognos 8
• Experience in developing dynamic Dashboards and Scorecards
• Involved in the Design, Development and Implementation of the Cognos Multi Dimensional Power Cubes using Transformer
• Experience in optimizing cube performance
• Developed several reports using Cube's as data source
• Implemented Data Security ,Object Security ,Package Security in Framework Manager and created user classes, roles or groups as per the requirement
• Experience in Using Cognos connection
• Experience and knowledge of Data warehousing and RDBMS concepts, dimensional modeling using Star Schema and Snow-Flake Schema
• Involved in integrating Cognos TM1 with Cognos 8 BI
• Created dimensions, Cubes using Turbo Integrator in TM1 and loaded data into cubes from different data sources
• Created several TM1 applications and deployed them to the web
• Installed Executive viewer and created different views of cubes using it
• Increased performance of cubes by using skip checkers and feeders
• Strong experience in client interaction, understanding business applications and requirement gathering
• Excellent analytical and communication skills, technically competent and has strong problem solving skills

TECHNICAL SKILLS

• Business Intelligence Tools: Cognos TM1 9.4.1, 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
• Databases: Oracle (10g,8i,9i), MS SQL Server(2000,2005), DB2, MS Access
• Querying Tools: SQL*Plus, TOAD
• Data Modeling: Logical and Physical Data Modeling, Star Schema, Snow-Flake Schema Data Modeling, Erwin 4.0/3.5, Visio
• Operating Systems: Windows(98,NT,2000,XP,Vista,7), UNIX(IBM AIX, HP-UX), DOS
• Directory Servers: LDAP server, Active Directory Server
• Languages: SQL, PL/SQL

EDUCATIONAL DETAILS

Bachelor of Engineering

Professional Certifications

Confidential Certified Developer: IBM Cognos TM1 Developer

Confidential, VA February 2009 - Present
Sr. Cognos Developer

Confidential holds specialization in credit cards, home loans, auto loans, small business loans, banking and savings products. It is one of the top 10 largest banks based on deposits. It follows Information Based Strategy, a strategy it pioneered to use customer data to help tailor its products to customers, particularly subprime consumers. It has largest database of consumers.

Responsibilities:

• Gathering requirements from Business Analysts in the form of Functional specification documents or Functional Requirement documents
• Created models for reporting and published packages to Cognos Server using Framework Manager
• 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
• 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
• Involved in integrating Cognos TM1 with Cognos 8 BI
• Created dimensions manually as well as by using Turbo Integrator
• Created cubes and different views for the cubes
• Added different Business rules to the cube and created formulas to perform calculations as per the requirement
• Generated cubes by importing data into cubes from transactional systems and other data sources
• Created cubes and loaded data into the cubes using Turbo Integrator
• Transferred data between cubes where ever needed
• Creating and Scheduling Chores
• Creating TM1 Application by adding TM1 objects and External files to an application
• Deploying the application to Web
• Involved in application maintenance and support activities
• Increased performance of cubes by using skip checkers and feeders
• Installing Cognos TM1 Executive Viewer and Set UP Executive Viewer Client
• Integrating Executive Viewer with PowerPoint to make presentations
• Creating the Data Source and Data base connections for TM1 cube in Executive viewer
• Involved in designing excel standard reports for TM1 clients, input sheets for budgeting and Involved in technical discussions, suggesting solutions in developing new process and other enhancement work
• Applied Security in element, dimension and cube levels
• Configured and installed TM1 work flow process and involved in assigning tasks to users
• Installed and Configured TM1 Servers as Windows application and windows service

Environment: Cognos TM1 9.4.1, Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 10g

Confidential, NY December 2007 - Jan 2009
Sr. Cognos Developer

Confidential is an insurance company which provides unparalleled level of service with focus on superior solutions. It provides good commitment to maintain financial strength. Confidential has grown to become a leading specialty insurance company around the world.

Responsibilities:

• Involved in Requirement gathering from Business Users
• Analyzing the specifications provided by the 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 packages in Framework Manager and published to Cognos Server
• Implemented security in Framework manager at Data, Object and Package levels
• Created cubes in Transformer using Framework Manager's IQDs, packages as a source
• Created special categories for better analysis
• Implemented security at cubes using apex, Cloak exclude and suppress
• Designed and developed the reports using Cognos 8 Report Studio, Analysis Studio
• Designed and developed multiple reports using various templates like list reports, cross-tab reports and chart reports
• Created reports with Filters, multiple Prompts
• Developed master-detail, chart and Conditional Formatting Reports
• Scheduled Reports and Jobs to run periodically and provided option of Bursting
• Worked with Analysis Studio to develop multi dimensional reporting
• Worked with Drill- through definitions to drill through from analysis studio reports to report studio reports
• Involved in reports Deployment to UAT and Production
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports as a part of User Acceptance Testing

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

Confidential, CA November 2006- November 2007
Cognos Developer

Confidential is the global leader in cloud infrastructure, which delivers virtualization solutions that significantly reduces IT complexity. It provides virtualization software for computers and servers. Confidential desktop software runs on Microsoft Windows, Linux and Mac OS. It also provides enterprise software's whichruns directly onserver.

Responsibilities:

• Extensive interaction with Business Users and prepared reports functional requirements
• Designed and developed Framework Manager Model, and established the cardinalities to suit the business needs
• Created Projects, Models, and Packages using Cognos Framework Manager and published packages to Cognos Server for reporting
• Implemented security for the developed Model and created user roles according to their requirement
• Created DMR model with Dimension and Hierarchies for providing drill downs and drill ups in Analysis studio and Report Studio
• Implemented Data Security ,Object Security ,Package Security in Framework Manager
• Implemented report level security and folder level security in Cognos Connection
• Created User groups, roles to implement the Cognos Security using LDAP
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multiple queries
• Created reports with bursting
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Created Reports using Cognos Report Studio and Cognos Query Studio
• Implemented Conditional formatting for highlighting rows and columns, and hiding based on conditions
• Created Scorecards and Metrics using Metric Studio

Environment:
Cognos8.1, (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Metric Studio), SQL Server, Toad

Confidential, OH March 2006 - October 2006
Cognos developer

Progressive insurance offers insurance for different segments such a personal auto, commercial auto, home owners, renters and banks. It is the first insurance company to introduce reduced rates for low-risk drivers, and then changed the insurance shopping experience by offering comparison rates on the Web. Progressive always continues to find better ways to serve its customers.

Responsibilities:

• Analyzed and understood the 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 this 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 the migrated model as verifying the joins, cardinality and folder structures
• Involved in validating/testing the migrated reports
• Prepared Testing cases for reports testing
• Prepared documentation for migration process
• Involved in pilot project before going implementing this Hybrid approach

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

Confidential, CA February 2005-February 2006
Cognos Developer

Confidential is a HealthCare Services Company, which offers services such as traditional health maintenance organizations, point-of-service plans, third-party administration of employer-funded benefits plans and Medicare.

Responsibilities:

• Involved in design of base model in Framework Manager and created several medium to complex reports
• Understood Business Requirements by interacting with users, Business Analysts and other Developers as well as understood data and business logic for reports development
• Created different layers in Framework Manger such as Database Layer which resembles mostly Star Schema and Business Layer which includes user understandable Tables
• Extensively worked on relationships, cardinality between query subjects to better represent the logical structure of the business and the user requirements
• Created complex reports using various templates such as List, Cross-tab, Chart and Repeater
• Used Conditional block sections for creating Multiple Queries in a single Repor
• Validated report results with the source data and authorized to production environment
• Scheduled Reports and Jobs to run periodically
• Involved in creating different types of ad hoc reports using ReportNet Query Studio
• Used SQL Server including stored procedures, subroutines and T-SQL

Environment:
Cognos ReportNet 1.1 MR2 (Report Studio, Framework Manager, Query studio), DB2

Confidential, Hyderabad, India May 2002 - January 2005
Cognos Developer

Confidential is India\'s second-largest bank in India. Confidential offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Used Cognos Impromptu Administrator to create Catalog
• Created Catalog and assigned joins as per the requirements
• Created standard reports using Cognos Impromptu
• Formatted the reports extensively based on the requirement
• Implemented filters, calculations, graphs and prompts
• Set up drill through functionality between reports
• Created IQDs in Impromptu and used these IQDs 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
• Multi dimensional cubes were published to Upfront using PPES

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