PROFESSIONAL OVERVIEW

• Over ten years of experience in IT includes extensive Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), and Customer OLAP, ETL tools, application development and Reports Generation.
• Strong experience with Cognos EP Series & Tools such as Cognos 8.4/8.3/8.2, Cognos Reportnet 1.1/1.02, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, and Analysis Tools such as Analysis Studio ,Cognos Transformer, PowerPlay Studio & PowerPlay 7.x/6.x, Cognos Visualizer 7.0, Cognos Query 7.x and Access Manager.
• Over seven years of experience in working with Cognos.
• Extensive experience in Data modeling using Framework Manager including applying data level, and query subject level and package level security.
• Strong Experience in developing reports using Query Studio & Report Studio.
• Extensive experience on Transformer Models for corporate data for building Multidimensional Cubes.
• Designed dashboards based on power cubes, Relational and Dimensional Modeling.
• Experience in Migration from Cognos 8.2 to 8.4 version
• Experience in extracting data for the report development from flat files and other relational databases.
• Experience in creating the Catalogs and implementing the Security using User Classes in Impromptu Administrator.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Knowledge of extracting data from different data sources using Informatica.
• Extensive experience in working on Oracle, SQL Server, Teradata & MS-Access databases.
• Knowledge of building TM1 cubes using Turbo Integrator
• Expertise in problem analysis and problem solving.
• Excellent communication and writing skills. Ability to get along with the team well and proven leadership qualities.

TECHNICAL SKILLS

BI Tools

All Cognos 8 versions, CognosReportNet 1.1(MR1/MR2):Cognos Connection, ReportStudio, Query Studio, FrameworkManager, Cognos Migration Utility, Cognos DRU Utility, Metamanager, Cognos EP BI Series 7.0/6.1:Cognos Impromptu, Cognos PowerPlay, Cognos Transformer, Impromptu Web Reports (IWR), PPES,Access Manager, Upfront, Cognos Architect, Cognos Query

RDBMS/DBMS

Oracle,SQL Server 2005,Teradata and MS-Access

Database Tools

TOAD, SQL*Plus, Query Analyzer

Languages

SQL, HTML

Operating Systems

Windows XP, Windows NT/95/98/2000, UNIX, MS-DOS

EDUCATION

Bachelor of Engineering - Specialization - Electronics
Masters of Business Administration - Specialization - Information Technology

PROFESSIONAL EXPERIENCE

Confidential, Mar 10 - Present
Project 1: NASA
Current NASA reports were written in Microsoft ASP. The project involved converting existing 17 NASA reports to Cognos reports.
Role: Senior Cognos / BI Consultant
Responsibilities:

• Involved in creating FM Models based on user requirements and existing NASA ASP model.
• Use the existing SQL Server Stored procedures and made changes accordingly to use for Cognos Reporting.
• Publish the packages and develop reports in Report Studio in DEV and migrated to UAT and Prod.

Project 2: NON-NSFOD Refund Reporting
With the launch of e-banking across the franchise, the Banking Center and the customer Service must begin to actively report, manage and control pricing behavious.This application was designed to help management track down the refunds done for customers at the Channel Level drill down all the way to the associate level for different Product and Fee Types.
Role: Senior Cognos / BI Consultant
Responsibilities:

• Involved in gathering business requirements from various users in the Bank.
• Primary tasks included designing, developing and implementing Data Mart Model
• Built Relational and Dimensional models using Framework Manager, created and publish packages to the Cognos Server
• Developed the packages and reports in Dev and migrated to UAT and Prod.
• Involved in creation of reports using Report studio, Query studio and Analysis studio.
• Used Dimensional functions for Tree Prompts
• Created Drill-Thru, Sub-reports and Chart reports
• Designed complex SQL queries to support the Data Mart.
• Used Access Manager for creating users, groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users

Project 3: Merrill Lynch Migration from Cognos 8.2 to 8.4
Recently Bank of America acquired Merrill Lynch, one of the leading investment bank for a whopping $50Billion.One of the projects involved all the Cognos ML Applications to be migrated over to BOA
Role: Cognos / BI Consultant
Responsibilities:

• Involved in migrating more than 17 ML applications to Bank of America
• Migrated packages, models, reports, events and schedules from Cognos 8.2 to 8.4
• Tested and fixed various bugs in the reports, drill through reports and charts during migration
• Analysis of cubes in Powerplay studio
• Created and tested Data sources for various databases to be used in reports
• Used Cognos Migration Utility to migrate the objects
• Used DRU Utility tool to search and replace the xml content
• Involved in creation of reports using Report studio, Query studio and Analysis studio.
• Responsible for creating users, groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users in Access Manager
• Involved in Performance Tuning of the Reports

Technical Environment: Cognos 8.4/8.2, Framework Manager, Cognos Connection, ReportStudio, QueryStudio, Event Studio, Analysis Studio, Powerplay Studio, Transformer, Oracle, Teradata, SQL Server2005,DB2,Sybase,Configuration Manager, Content Manger, DRU Utility Tool, Cognos Migration Utility Tool, MetaManager

Confidential, May 09-Feb 10

Project: It is one of Canada's largest telecommunications companies, particularly in the field of wireless and cable television. The Project Interaction Management dealt with agent reporting on customer's Interaction and Case Management. Role: SeniorBI Analyst Responsibilities:

• Involved in gathering business requirements from various users.
• Dimensional and Relational Data modeling using Framework Manager.
• Developed List Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio
• Involved in training end users in Cognos Connection and Cognos Report and Query Studio.
• Designed complex SQL queries to support the Data Mart.
• Documented the whole reporting process.

Technical Environment: Cognos 8.3, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Oracle, TOAD, MS Access

Project: It is a leading Telecommunications company with multi million dollar business in the field of Satellite TV. They have customers all over Canada. It is a part of Bell brand.
The project DEEP involves creation and implementation of a reporting application and improving of reporting operations for revenue, agent performance management, and vendor management using Cognos 8 for Bell TV. The specific role involved understanding the Call Centre Operations and in creation of metadata layer in Framework Manager, publishing packages to Cognos 8 Server and creating reports using Report Studio.
Role: BI Analyst
Responsibilities:

• Involved in gathering business requirements from various users in Call Centre department.
• Involved in Strategic Planning for Cognos Framework Model.
• Involved in Creating Content store, installation and Configurations of Cognos 8
• Dimensional and Relational Data modeling using Framework Manager.
• Created and published Packages using FrameWork Manager.
• Designed complex SQL queries to support the Data Mart.
• Build some cubes on cognos TM1
• Use of SQL interface effectively in creating queries in Cognos to link the different tables.
• Created database connections to different data sources in Framework Manager.
• Developed Templates List Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio on Cognos8.4/8.3
• Extensive use of Analysis Studio for Analyzing Data
• Creating and Managing Jobs and Schedules.
• Introduced Highlight exceptions, and drill-down reports to expedite analysis.
• Involved in training end users in Cognos Connection and Cognos Query Studio.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Worked on various issues on existing Informatica Mappings to produce correct output.
• Done Informatica performance tuning and query tuning
• Created User Acceptance Test (UAT) plan documents for both managed and ad-hoc reports.
• Attended Functional Testing and User Acceptance sessions, and worked on the feedback from the business users.
• Deployed the packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal.
• Provided support for managed reports and users.
• Documented the whole reporting process.

Technical Environment: Cognos 8.3, FrameWork Manager, Transformer, Cognos Connection, ReportStudio, QueryStudio, Analysis Studio, Cognos Scheduler, Configuration Manager, Content Manger, IIS Web Server, ETL Tools Informatica (PowerMart & PowerCenter), Oracle, TOAD, MS Access, Cognos TM1

Confidential, Sep 03 - Feb 05
Project: It is a call centre based in Toronto which caters to the needs of the customers both Inbound and Outbound.
Role: Data and Support Analyst
Responsibilities:

• Map business requirements to enterprise data and recommend analytical reporting strategies.
• Imported metadata from various sources such as Relational Databases, ReportNet models, Impromptu Catalogs into the Framework Manager. Constantly interacted with the business users, attended several meetings in understanding the requirements.
• Developed the Cognos Impromptu query (.iqd) files that will feed Cognos cubes
• Built models containing query subjects, query items and namespaces from scratch as well as from imported metadata. Creation of Calculations, Prompts and Filters for usage in various Reports.
• Planned and Created professional reports. Developed business test conditions, test cases and scripts.
• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos ReportNet. Creating the Catalogs & analyzing the Joins and creating Calculations at the Catalog Level.
• Designing Impromptu reports and optimizing the existing reports depending upon the requirement.

Technical Environment: Windows NT/2000, UNIX Server, ReportNet 1.1, Cognos EP Series 7 (Impromptu, Power Play, Access Manager), Crystal Reports, SQL, Oracle 9i, SQL Server 2000

Confidential, Jul 00 - Jul 03
Project: It is a multi million dollar textile firm based In India. They deal with starting from Sewing Thread all the way up to manufacturing Garments.
Role: IT Executive
Responsibilities:

• Part of IT Core team involved in Implementation of ERP(TIM and BPCS) on AS/400
• User Profile management on AS/400
• Authorities allocation to user\'s (Specific functions to specific user profiles)
• Daily/Weekly/Monthly scheduling of backups.
• Recovery of Data from Partial Damaged Objects Like PF's , LFs, Other objects.
• Application Migration from 720e to 820e Server.
• Fine tune & optimize performance on DB2/400 on V4R5 OS/400
• Trouble shoot AS/400 production problems, including oncall support
• Responding to console messages
• Generating reports on a timely basis (daily, weekly, monthly, and annual)
• Recognize trends through report analysis and present recommendations management team
• Extract data from the AS400 server and make reports for the upper management useful in
• taking decisions regarding company targets and strategy.
• Analyzing data using Board software (DSS tool) for the Top Management which helped them taking decisions.

Technical Environment: ILE RPG, RPG III, CL, SQL, DB2, Board, Access