SUMMARY OF EXPERIENCE

• Over 9 years of experience in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• 9 years experience in building Business Intelligence applications using Cognos BI tools.
• Expert in developing and implementing BI applications using Cognos BI tools include: Cognos 8, Cognos ReportNet 1.1 MR3, Impromptu, PowerPlay, Transformer, Upfront, Access Manager.
• Expert in Cognos 8, Framework Manager, Query Studio, Report Studio, Analysis Studio and Cognos Connection.
• Expert in Creating Packages, Meta Data Models using Framework Manager.
• Expert in creating Dashboards for the senior management in the organization.
• Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes.
• Strong experience with client interaction, understanding business applications, business data flow and data relations.
• Extensively worked in interacting with Business Users to collect User Requirements.
• Excellent analytical and communication skills, ability to work independently and good team player.

TECHNICAL SKILLS

Operating System: Win NT 4.0/5.0, Win XP/2000/98/95, UNIX

RDBMS: Oracle 9i 10g, Teradata, UDB DB2 and MS SQL Server.

Data Modeling: ERwin 3.5.2

Business Intelligence: Cognos Series 8, Cognos ReportNet 1.1, Cognos Impromptu Administrator, Cognos IWR, Cognos Power Play, Power Play Transformer, Cognos Visualizer, Access Manager, Cognos Server Administration

ETL: Informatica PowerCenter 7.1, Decision Stream.

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL and C.

Other Tools: TOAD, PVCS, Test Director

Networking/Telecom: TCP/IP, HTTP, SNMP.

Professional Experience

Confidential

Sr. Cognos Developer Lead

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Held meetings with business analyst to review/understand business requirements before development.
• Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.
• Documented the architecture/technical Designs and roadmaps.
• Working closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.
• Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.
• Designed, developed most efficient Reporting Solutions with improved performance and best practices.
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, PowerPlay Portable Reports, Impromptu reports and ReportNet reports.
• Created Dashboard Reports in Report Studio to present data graphically.
• Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.
• Used Transformer with a variety of sources and combines them into Multi-Dimensional Cube.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Preparation of Unit Test plans and Unit testing of COGNOS Reports.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Written Macros and Batch files for automating tasks and Job Scheduling.
• Involved in migration from ReportNet to Cognos 8 and upgraded from Cognos 8.1 to 8.3.

Environment: COGNOS 8.4 Suite Framework Manager, Report Studio, Query Studio, Analysis Studio and Cognos Connection , PowerPlay Transformer, Access Manager, Oracle 10g, MS SQL Server 2005, Windows Batch Programming and Windows XP Professional.

Confidential

Cognos Developer Administrator

Responsibilities:

Cognos Modeler

• Analyzing business and user requirements.
• Creating preliminary requirement document that explained about in brief about the scope of the project.
• Creating detail Technical design document that specify the reports, data sources and tools along with the SQLs and the logics and method of delivery.

Cognos Developer

• Responsible for evaluating Cognos Series 8 and ReportNet 8.
• Involved in Installation and Configuration of Cognos Series 8.
• Interacting with business users for their requirement.
• Developing and Customizing Impromptu Reports.
• Created standard and Ad hoc reports using Cognos Impromptu tool.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Provided Training and End User Support with my report and also knowledge transfer.
• Created Tables SQL Views in the MS SQL Sever Database for complex reporting.
• Created Multi-Dimensional reports using Power Play.
• Created power play models and cubes using Transformer Power Play .
• Drill down, slice and dice and change displays. Created Mix reports and Top ten reports.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using Power Play reports.
• Built and Designed Cognos Impromptu Catalogs and Reports.
• Built Dimension Maps based on customer requirements for different cubes.
• Designed, presented and distributed the visual representation of complex data for easy analysis.
• Automated production jobs Using Cognos Scheduler, Scripts and batch files using scripts and batch files.
• Deployed and Maintained Cognos PowerPlay cubes and reports in the PowerPlay Enterprise Server.

Access Manager Administrator

• Access Manager - Configuration
• Setting Up User Class and Security
• Create Users and setup the privileges
• User Class and access Privileges
• Access to Data Sources Server Connections
• Auto Access Sign-on for Data sources
• Setting Up the Sign-on
• Access Manager - Batch Maintenance

Cognos Server Administration

• Publish Impromptu Report sets to Impromptu WEB Reports Servers
• Manage Reports Sets, Manage Report Security
• Monitor and Optimize Server Performance
• OLAP cubes and Reports
• Manage the OLAP Environment
• Deploy cubes and reports for the PowerPlay Enterprise Server
• Control through access
• Cube Refreshing
• Cube Scheduling Updating

Upfront Server Administrations

• Manage Upfront Security
• Administer the upfront Data Store
• Installation, Upgrade and Configurations
• Cognos Client Installation through the Network
• Cognos Reports Upgrade
• Directory Server Configuration
• Setup the Name Space in the Directory Server

Environment : Cognos CRN 1.1 MR2,Cognos Impromptu 7.1, Cognos Transformer 7.3, Cognos Power Play 7.3, IWR/Cognos Administrations, Access Manager, Cognos Upfront, Decision Stream Cognos ETL tool , MS SQL Server ,Windows XP/2000/NT.

Confidential

Cognos Developer/Analyst

Responsibilities:

• Created Standard and Ad-hoc Impromptu Reports.
• Worked on gathering User Requirements, Created Cognos Impromptu Catalogs for Impromptu Reporting and Power Cube development.
• Created standard filters, calculations, prompts and conditions in catalog.
• Worked on Creating Impromptu reports using catalogs created from Data mart.
• Created and deployed multiple Transformer Models, PowerPlay Cubes.
• Designed the PowerPlay Transformer models and with/with out drill through reports and also created alternative drill down paths as per user requirements.
• Developed the Multi-Dimensional reports, and the graphical reports using PowerPlay.
• Published all Cognos cubes/reports in the Upfront Portal using PowerPlay Enterprise Server.
• Directly interacted with the User group and gathered reporting requirements.
• Extensively worked on Projects, Models, Namespaces, Folders, Query Subjects and Packages from multiple data sources in ReportNet Framework Manager.
• Extensively developing multi Report pages List, Crosstab, Chart and Section Reports using single and multiple queries in Report Studio.
• Regular interaction and daily support to User group to fix the issues on ReportNet Query Studio adhoc reports .
• Resolve any functional/ technical issues that arise in the development cycle.

Environment: Oracle 9i, TOAD, Teradata 6.0, SQL Assistant, Cognos ReportNet, Framework Manager, Query Studio, Report Studio, Impromptu, Power Play Transformer, Power Play, Upfront and Windows 2000/NT/XP.

Confidential

Responsibilities:

• Interacted with the Business users to identify the process metrics and various keys dimensions and measures
• Used Cognos Architect 7.0 to build a common set of business oriented metadata from the data mart and provided users with the Cognos Queries and Cubes
• Published Cognos Query packages to the Cognos Upfront and created several customized reports out of the packages
• Implemented Security on the reports by adding specific user class in the Impromptu Catalogs
• Created and customized various cross tab reports, drill through reports, and sub-reports
• Used different types of prompts like catalog pick list, cascading prompts etc.
• Created the reports in HTML format for easy navigation
• Created Multi-Dimensional cubes and Reports as per the User Requirements to support several process metrics
• Slicing and dicing of the cubes for better viewing perspective
• Provide Drill-Through access from the cubes to associated Cognos query
• Created different visualizations for reports using different types of charts, to include data from multiple metrics. Provided user interaction by including various navigation and filtering options
• Provided access to the PowerPlay cubes from the Visualizer to provide underlying details on the charts
• Used Server Administration tool to publish reports to Cognos Upfront.
• Interacted with Cognos Administration team for scheduling of cubes and reports to refresh on a regular basis.

Environment: Cognos Impromptu Administration 7.0, Cognos PowerPlay Transformer 7.0, Cognos Server Administration, Cognos Upfront, DB2, Oracle, SQL and Windows NT. Confidential E-Business Data Analyst and

Cognos Developer

Responsibilities:

• Involved in the cardinality analysis and data cleansing
• Interacted with the Business users to identify the process metrics and various key dimensions and measures
• Involved in the creation of logical and physical data model using Erwin.
• Design the dimensional metrics matrix prototype. This matrix would identify the Dimension, hierarchies and the granularity required for the Cognos cubes
• Created Cubes using Cognos PowerPlay to display Cycle Time Metrics at the high level with the summary information and the drill through to display the detailed information of the Medpro Application statuses.

Environment: SQL, Oracle 8i, TOAD, DB2, Windows NT, Cognos PowerPlay Transformer 6.6, Cognos Impromptu Administration 6.6.

Confidential

Cognos Developer

Responsibilities:

• Product Architecture, Project Planning, Database definitions and connectivity.
• Creating Catalogs and Retrieving tables, Database Alias and Catalog keys.
• Developing a Join strategy, Analyzing and testing.
• Creating User Classes, Catalog Prompts conditions and Calculations.
• Restricting the user access with the help of User Class Privileges.
• Created Templates for the users.
• Developed and Customized Catalog Impromptu Reports:
• Developed different kinds of reports to run and improve the business.
• Created Catalog and set User profiles to grant user permissions for querying.
• Created different joins according to requirements
• Client server Balancing to reduce impacts on the network and Database.
• Created Standard and Ad-hoc Impromptu Reports.
• Created list reports and cross tab reports and Drill through reports.
• Cognos Power Play:
• Discussed business requirement and mapped Business need using Model Capability of Cognos Transformer.
• Defined dimensions, levels and measures.
• Generated Categories and category properties.
• Created Power Cubes as per Models.

Environment: Cognos Impromptu, Power Play, SQL, Oracle.