COgnos Developer

MIHIR PANDYA

Cognos BI Consultant ** Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

Over 25 years of IT experience in Analysis, Design, and Development of Data Warehousing and

Reporting Applications using Business Intelligence (BI, OLAP) Technologies

20+ Years of Business Analysis Experience

14+ Years of experience in SDLC development involving analysis, design, development,

deployment, testing, implementation, maintenance and support of large data warehouse

applications in Client/Server environment with focus on Business Intelligence Reporting

Applications by deploying ETL and OLTP tools like Informatica 8.0, Cognos 8.4 on Oracle and

SQL Server Platform

10 years’ experience in reporting tools like D2K reports, Crystal report including 8 years of solid

experience in Cognos 8.4 using framework manager, Report studio, Query studio, Analysis Studio using

Tree type of Prompt Page, Drill-thru report, and Cross-tab report and working experience in cognos 10 for

active reports and active dashboard

Used statistical Package (SAS version 4) for a study in Feasibility Study for new project implementation

for Power Distribution in the Rural Area

EDUCATION & CERTIFICATION

Post Graduate Diploma in Computer Science and Application

Bachelor of Science (Statistics)

CCNA exam no. 604-802 has been passed successfully and obtained certificate by CISCO having

CISCO ID - CSCO11880091

Classroom Training in Informatica 8 with all 17 transformations and Workflows on Oracle 9

RDBMS

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

Classroom Training in Datastage __ with all 17 transformations and Workflows on Oracle 9

RDBMS

Classroom Training in BO using elements like drill across, Ranking cross-tab etc. on Oracle 9

RDBMS.

REFERENCES

Available upon Request

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

TECHNICAL SKILLS

ETL

Used Informatica for Extracting, Transforming and Loading of Oracle tables/Flat File to

Oracle Schema/Flat file using Inner Joins according to Business rules

OLA REPORTING TOOLS

Experienced with Cognos Tools such as Cognos 8.4.1/8.3,Cognos 8.2, Cognos Connection

and Scheduling of the report IBM COGNOS 8.4 covering Framework Manager for Creating

reporting package, Query Studio, Analysis Studio and Report Studio in detail and working

Knowledge of Transformer for creating simple CUBE models for COGNOS Reporting tool as

part of Corporate knowledge upgrade training

Extensive Experience with Framework Manager Modeling for creating Relational and

Multidimensional modeling .

Good experience in Production Support and Troubleshoot/Test issues with existing reports

and cubes, in Cognos data Manager to load the data into data marts from flat Files, in

OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star

Schema and Snowflake Schema used in relational and dimensional modeling using Extract,

Transform and Loading techniques in Informatica

Experience in using Cognos Series BI 8.4/8.3/8.2 (Report Studio, Query Studio, Analysis Studio,

Event Studio), Cognos Data Manager, working knowledge of Transformer 6.5, Framework Manager,

Report Studio, Query Studio, Cognos Connection, Administration and Security

working experience in cognos 10 for active reports and active dashboard

LANGUAGES, TOOLS & DATABASES

Extensive work on Data Extraction with Oracle (8i, 9i and 10g) using PL/SQL, SQL Server

& MS-Access, SQL Query for MS-SQL, MySQL RDBMS, Forms & Report Generation using

Oracle D2K

Conducted user acceptance testing (UAT) as well as training and implementing new

processes and procedures

Developed system manuals and user guides to facilitate hassle free adoption of software

systems

Experienced in using COBOL, JCL (Job Control Language), SQL, Visual Basic, Good

knowledge in Oracle 8i/9i/10g, Oracle RDBMS, MS SQL Server 2000/2005, VBA, MS Access

97/2000,PL/SQL

APPLICATION PACKAGES & OPERATING SYSTEMS

Developer 2000, MS Office 2007, FrontPage, Crystal reports, Cognos 8.4

Windows95/98, Windows Vista, Windows NT 4.0 and 2003, Novel Netware 5.0, working

knowledge of Unix

WEB SERVERS

FrontPage, Apache. Application Packages MS Office, FrontPage, Crystal reports

OTHER SOFTWARES

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

HTML/DHTML, VB 6.0, JavaScript and in depth knowledge of FoxPro, Dbase, Windows NT, TOAD

10.5

PROFESSIONAL EXPERIENCE

PROJECT CONSULTANT Dec 2012 - Oct 2013

(Senior Cognos & SQL developer)

Consultant to Netcom Services - Edison, NJ

Duties:

Handling Base sales, marketing and Email blasts data for about 21000 pharmacist and institute of

France and Italy in 2012 for Pharmacy to be converted to the MS-SQL table and designing for

monthly update as well as for about 30000 pharmacist and institute of Spain, Belgium in 2012.

Converting, validating and cleansing the base data using basic Datastage 8 stages by creating

sequential, lookup and server stages using Hashed file, ms-sql and oracle as databases.

Developing and testing the Pharmacy Marketing data of about 51000 pharmacists for year 2011 -

2012 and designing database for monthly updating for Analysis.

Preparing Performance Analysis of sales and calls for quarter wise / month wise using SAS and

MS-SQL and cross-tab report for country/pharmacist wise detail and summary using cognos 8.4.

Creating prompts and conditional formatting in the report for validating with SAS analysis.

Preparing PowerPoint presentation using MS-office.

Environment:

Windows-7, Datastage 8, ms-sql, oracle 9.0, Toad 9 SAS 9.0, Cognos 8.4 and MS-office 10

SENIOR COGNOS DEVELOPER Feb 2012 – Aug 2012

Sanofi US - Bridgewater,NJ

Duties:

Developing and testing about 30 reports in Training Tracker in three months.

Adding business rules by incorporating different kinds of calculations and filters.

Creating multiple prompt and converting coded inputs from UI to User-friendly reporting.

Authoring reports in Report Studio according to requirement by implementing many

features like Prompts, Conditional Formatting and Conditional Variable.

Using JavaScript for sizing Search & Select Prompt in Prompt Page.

Testing the report with Oracle Dimension and View data for integrity and interacted with

Database administrator for correcting the script according to business rules.

Creating Boolean variables and String variables for converting and reporting the data

from Codes (IDs) provided by UI system.

Testing the report with Oracle 10 database views and Tables using TOAD Tool.

Creating Views in Toad 10.5 using joins between multiple tables.

Environment:

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

Cognos 8.4 (Report Studio, Query Studio, Analysis Studio, Transformer), Cognos Connection,

MS Excel, JavaScript,TOAD 10.5, PL/SQL,Windows 7,MSOffice/Excel

SENIOR COGNOS DESIGNER AND DEVELOPER Jan 2011 – Aug

2011

Molina Healthcare - Trenton, NJ

Duties:

Importing metadata from various sources such as Relational Databases, Stored

Procedures into the Framework Manager

Designing star schema and dimensional model using Framework manager.

Developing Framework Manager Model considering the underlying database schema

model and the reporting requirements.

Using Framework Manager to build models, packages and publish packages to the

COGNOS8 Server.

Building models containing query subjects, query items, and namespaces and analyzed

model with Model Advisor

Creating Calculations, Prompts and Filters for usage in various Reports,

Training users for express authoring mode.

Creating Complex Multi-Object Report Studio Reports using Prompts, Lists, Cross tabs,

charts (bar, combination, line, progressive etc), Images and Multi Page DashBoard.

Complex Reporting Requirements, Complex Drill-Through, Cross-Tabs, Summary

Reports.

Scheduling Reports and Jobs to run periodically on fixed day of Week & Month.

Deploying packages, folders and content store from a development environment to test

and then to production environments.

Designing the system testing and implementation planning activities.

Optimizing the existing reports in Production depending on the Run Time Formatting the

reports.

Developing Executive level Dashboard pages and Dashboard Objects.

Testing the reports generated with the database for correctness of data by writing SQL

Queries.

Preparing Installation Qualification Document and done QA testing of Cognos 8 reports.

Environment:

Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Cognos Framework Manager, Power

Play Transformer,MS SQL server.

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

SENIOR SYSTEM ANALYST -

COGNOS DEVELOPER AND ADMINISTRATOR May 1982 –

Nov 2010

Public Power Utility Company - Gujarat, India

Data consolidation required from multiple servers and Operating Systems ranging from

Windows to various flavors of Unix into a single cohesive CROSSTAB, LIST report with

Prompt pages report generating system using Mainly Report Studio, Query Studio and Analysis

Studio of COGNOS 8.4 Reporting tool for generating various Inventory reports, Category wise

utility consumers analysis and various financial reports since September of 2008.

Duties:

Handing on Experience to create Active Report in Cognos 10 environment using Data

and Report Deck.

Training users for express authoring mode

Delivering the test plan, specification and report document as per the Guidant system

document management system

Working on Data Analysis reports Business Objects, Oracle8i, Excel, Involved in creating

test cases

Working extensively with Business Users in gathering requirements for the Cognos

reports for conversion to Cognos reports from Oracle 9i.

Analyzing the specifications provided by the clients and Developing specification

documents for reports as per client requirements

Participating in Design review meetings for Oracle Discoverer Project,

Developing reports using direct entry SQL without using any Cognos packages,

Developing Report specification documents for Global Supplier Relationship Market

Rates for Preferred and third party vendors to determine the effective Market rate.

Writing and executing test cases to make sure that data matches with the report using

Teradata SQL Assistant.

Performing SQA Testing for ensuring the report quality and data quality, performing Unit

Testing for all kinds of reports before moving to Production, writing complex SQL in

verifying the data quality for Cognos reports in Oracle and Teradata.

Developing reports by using conditional hiding by render variables and style variables,

Usage of Multi Prompts and Cascading Prompts using predefined templates

Documenting the test results and issues in Test Summary Report document (TSR).

Strictly following the SDLC processes for approval from the BI Manager before

assigning the report for SQA testing to Business Analysts.

Handing on experience in exporting reports, specifications and packages to different

Cognos environments through Cognos Administration and then configuring by using CA

Allfusion Harvest Change Manager.

MIHIR PANDYA

Cognos BI Consultant 17 Hycinth Drive, Apt #1C, Fords, NJ, 08863

Phone: 848-***-**** I E-mail: ***********.******@*****.***

Following the strict report and template standards as defined by the business users,

modifying the existing reports based upon the IT change request by the user, Involved in

resolving Performance issues with various reports.

Developing reports for Employee Efficiency and Employee Hours report for different

reporting time periods like Fiscal Week, Month, Quarter and YTD and update client.

Planning and Monitoring system for ORACLE RDBMS using Oracle D2K. This led to

much shorter purchase times thus reducing the overall time required for completion of

large engineering projects. This resulted in a significant decrease in the overall costs

associated with Inventory Control.

Supervising the team tasked with the implementation of the Inventory Module in Oracle

Apps as part of Corporate IT upgrade process towards ERP project implementation.

Generating Management Information report from various islands of the processes for

decision making and analysis by Top management.

Developing company’s Static and Dynamic website using CMS, Adobe Dreamweaver

and MYSQL and PHP.

Using statistical Package (SAS version 4) for a study in Feasibility Study for new

project implementation for Power Distribution in the Rural Area.

Environment:

Cognos 10,Cognos 8.4 Suite (Framework Manager, Report Studio, Query Studio, Analysis

Studio), Oracle Discoverer, Oracle 8/9i/10g, DG Mainframe, Windows servers, Redhat Linux

server, SQL server, Linux Mail servers, CISCO router 7500 series.

Contact this candidate