Mohammed Suhail Bagban [pic]

acggby@r.postjobfree.com

760-***-****

Professional Summary:

Certified Cognos 8 BI Developer with 8+ years of experience and expertise

in providing business

Solutions for IT Industry in areas such as Health, Financial Services, HR

and Networking with a Functional and a Technical approach in Business

Intelligence (BI) and Report Generation.

Technical Expertise

. Expertise in Full life cycle system development: Requirement

gathering, Administration, Designing, Development, Testing and

deployment of Data Warehousing and Business Intelligence applications

using COGNOS Suite 8/10.

. Experience of Cognos suite Cognos 10.2.1 (Framework Manager, Cognos

connection, Report Studio, Metric Studio, Event Studio and Transformer

Cubes).

. Expertise in Framework Manager Modeling (DMR and Relational Models)

and Complex Report building with Report Studio.

. Expertise in creating Dashboard reports and using Java Script in

Report studio.

. Organized and accessed several data sources into transformer models,

Dimension maps, Dimensional data marts and developed Power Cubes,

which can be changed in many ways to Slice and Dice and Drill Through

data for further Multi Dimensional Analysis using Cognos (Framework

Manager and PowerPlay Transformer).

. Very good experience in customizing the Cognos connection portal.

. Implemented Security in Cognos using Windows Active Directory and

LDAP.

. Utilized Best Practices and Proven Methodology in data modeling, ETL

and other BI development process.

. Proficient in designing multidimensional Model in Framework Manager

in Cognos BI version 8 and as well as Strong knowledge and

understanding of Snow Flake and Star Schemas.

. Developed OLAP applications using Cognos suite of tools.

. Experienced with multiple relational databases including Oracle

10g/9i/8i, MS SQL Server and DB2.

. Trained on Informatica tools.

. Efficient in Optimizing, Debugging and testing SQL queries and stored

procedures written in Oracle and SQL Server 2000, 2005 & 2008 and MS

Access.

. Deploying models and reports from Development to Production and

administering users/groups/roles.

. Excellent communication and interpersonal skills. Strong experience in

client interaction and understanding business application, data flow

and data relations.

. Ability to meet deadlines and handle multiple tasks, flexible in work

schedules and possess good communication skills.

. Ability to write and maintain technical documentation to describe

Reports development, logic, coding, testing, changes, and corrections.

. Experience with ticketing tools like Siebel, Remedy and Maestro.

. Experience in working with Onsite - Offshore model.

. Led a team of 8 resources and handle first level of escalation from

Onsite.

. Internal & External ITIL Certified.

Technical Skills:

BI Tools Cognos 10.2/10.1.1, Cognos 8.4/8.3 (Framework

manager, Data Manager, Report Studio, Analysis

Studio, Query Studio, Metric Studio and Event

studio), Power Play Transformer

6.x/7.x,UpFront,Cognos 8 SDK, Report Net

1.1/1.0x, Business Objects XI, Microsoft

Reporting Services (MS SQL Server 2005), Crystal

Reports

Databases Oracle 9i,10g, SQL Server 2005,2008, DB2

ETL: Informatica 7.2, 8.6

Web HTML, XML, Java Script

Languages Java, SQL, PL/SQL, C, C++

Servers Application Servers (WAS, Tomcat), Web Servers

(IIS, IHS)

Operating System Windows NT/XP/VISTA/2000, UNIX

Other Tools Modeling(Erwin 4.0), Toad, QTP

Applications MS Office, MS Word, Excel, Visio, PowerPoint

Experience Summary:

Thermo Fisher Scientific (Life Technologies), Carlsbad, CA

Jun 10 - Till Date

Sr. Cognos Consultant

Life Technologies is a global biotechnology tools company providing premier

systems, consumables, and services for scientific researchers around the

world. With more than 50,000 products used by more than 75,000 customers

around the globe, Life Technologies is advancing scientific research in

areas like academic research, drug discovery and development, toxicology

and forensics, disease diagnostics, clinical cell therapy and regenerative

medicine, and biologics manufacturing.

The project involves managing the clients EDW (Enterprise Data Warehouse)

and EDM (Enterprise Data Management). The EDW is loaded on a daily basis

with data from APAC (Asia Pacific), Europe and North America regions. The

loads are scheduled through tools such as Control M and Maestro with ETL

loads running on Informatica PowerCenter and BO Data Integrator. Finally

the data is made presentable to the users through Cognos reports and Cubes.

Data quality is maintained with Informatica Data Quality application.

Enhancements and issues tracked are resolved and tracked through Remedy

tool. Overall the applications are managed to provide the business users

critical decision making data available at the right time.

Responsibilities:

. Gathered & analyzed the end-user business requirements.

. Performing Report Rationalization during requirement gathering.

. Communicate to the business analyst, Data Modeler on a regular basis

to be informed on changing requirements or data model design

alterations.

. Worked with Framework Manager to create Projects, Models and Packages

and publish them to the Cognos connection.

. Created Database Layer, Intermediate layer and Presentation Layer,

defining appropriate relationship between query subjects and Fact

Table in Framework Manager.

. Implemented Third Party Security with LDAP and use those in creating

Data Level, Object level, Package Level Security in Framework Manager

Models.

. Developed detailed and summary reports using Cognos Report Studio.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts, Conditional

formatting, Conditional blocks in Report Studio.

. Involved in setting up Hierarchies, performing Drill UP and Drill Down

reports and Slice & Dice operations and creating Cross Tab Reports.

. Developed reports using different Joins, Unions, complex display

logics using different variables and customized the reports by

applying filters, calculations, conditions, prompts (text box, tree,

value, date) and Cascading Prompts in Report Studio.

. Experience in creating Active reports by using active report controls

to build highly interactive reports.

. Created several Dashboards based on the requirements and implemented

drill through to dashboards.

. Deployed reports from one environment to another environment.

. Design and creation of Multi Dimensional Cubes using Transformer, so

that all key performance indicators can be analyzed.

. Developing Analysis Studio views of analysis from dimensional modeled

packages and made the reports using them in Analysis studio.

. Deployed packages, folders and Reports from a development environment

to Testing and Production environment.

. Created Technical design document for Report studio reports based on

Functional specifications.

. Used Cognos Connection for scheduling and bursting reports across the

Business segments and providing additional security to published cubes

as well as reports.

. Experience in trouble shooting Report and Cubes Problems.

. Trained the end users to effectively use the reporting tool to build

and customize their ad-hoc reports.

. Managed performance and tuning of SQL queries and fixed the slow

running queries in production by applying best practices

. Create RFC documents for migrating code from lower environment to

production.

. Participate in Smoke testing after production release.

. Actively participate in Leadership meeting.

. Participate in taking interviews for the team.

Environment: Cognos BI Suite (10.1, 8.4), Cognos Transformer, oracle10g

(SQL, PL/SQL), Toad, SQL Developer, LDAP, Quality Center 10, Splunk, BSP,

Control M

Marriott International, Inc. NC,

Jul 06 to Jun 10

Cognos Developer

Marriott International, Inc. is a worldwide operator and franchisor of a

broad portfolio of hotels and related lodging facilities. Founded by J.

Willard Marriott, the company is now led by son J.W. (Bill) Marriott, Jr.

Today, Marriott International has about 3,150 lodging properties located in

the United States and 67 other countries and territories.

Marriot Recruiting as domain deals with the Recruiting and Hiring is a web-

based strategic workforce management system that streamlines and automates

all phases of the company's recruiting, hiring and retention processes.

Marriott LMS (Learning Management System) is a software application for the

administration, documentation, tracking, and reporting of training

programs, classroom and online events, e-learning programs, and training

content.

Responsibilities:

. Analyzing the specifications provided by the clients and Developing

specification documents for reports as per client requirements.

. Involved in complete Software Development project life cycle.

. Configured the content manager, Framework manager, and application

server.

. Customizing Cognos Connection Portal based on user specifications.

. Responsible for creating User groups and roles to manage security in

Cognos Connection and Access Rights of the Reports for the end users.

. Created models in Framework Manager and cubes in Transformer using

various data sources.

. Developed and Published Packages in Frame Work Manager-Connecting and

testing the Data Source, created database layer, physical layer and

presentation layer, defining appropriate relationship between query

subjects and fact tables.

. Developed FM Model against STAR, SNOWFLAKE and Fact Constellation Data

Models.

. Created metadata models, Joins, filters and calculations in packages,

organized Folders according to the Business view and published the

packages using Framework Manager onto Cognos Connection and created

the store procedure.

. Created Lists, Grouped Crosstab, and Reports with calculated fields

and Conditional Formatting, Conditional Page layout, Sections, page

Breaks, sorting, summaries, grouping, Drill Down, Drill Up).

. Writing of stored procedure in Oracle PL/SQL to import and use that as

Query Subjects in Framework Manager Model to fulfill specific purpose.

. Working experience with different date functions like YTD,QTD,MTD in

Report Studio

. Customized Reports using HTML and JAVA SCRIPTS for complex validation,

navigation and format customization.

. Used Dashboard/Scorecard to monitor the execution of corporate

strategic objectives at each level of the organization.

. Developed Ad-hoc reports using Query studio.

. Experience in configuring the File location and printers in the Cognos

. Created highly Complex Reports using OLAP Cubes as Data Source for

Multi Dimensional Analysis.

. Addressing the Performance tuning and other Production issues with

the Cognos 8 reports and Powerplay cubes.

. Scheduled to trigger dashboards based on an event using Event Studio.

. Assisted Quality Assurance Team in documenting and analyzing their

current process and then make recommendations for improvements in

their functional areas.

. Created documentation for the complete project life cycle and mentored

the End Users and Provided the Technical Support.

Environment:

Cognos 8.4.1 Suite- Framework Manager, Report Studio, Analysis studio,

Event studio, Metric Studio, MS-Excel, Windows 2003, Oracle10g, Quality

Center 10.

PepsiCo International, NC

Sept 08 to Apr 09

Cognos Developer

PepsiCo, Incorporated is a Fortune 500, American multinational corporation

headquartered in Purchase, NY with interests in manufacturing and marketing

a wide variety of carbonated and non-carbonated beverages, as well as

salty, sweet and grain-based snacks, and other foods. Besides the Pepsi-

Cola brands, the company owns the brands Quaker Oats, Gatorade, Frito-Lay,

SoBe, Naked, Tropicana, Copella, Mountain Dew, Mirinda and 7-Up (outside

the USA).

Pepsi Recruiting as domain deals with the Recruiting and Hiring is a web-

based strategic workforce management system that streamlines and automates

all phases of the company's recruiting, hiring and retention processes.

Responsibilities:

. Set up database connectivity in Cognos Connection.

. Built Framework Manager Model, and established the cardinalities to

suit the business needs. Implemented security for Data access, Object

level access and Package access.

. Was responsible for Application Reporting and supported all users from

different organizations in the company.

. Developed List, crosstab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts, Filters, multi-page,

multi-query reports against multiple databases.

. Applied grouping and associated the data with group functionality to

get the required report.

. Performed aggregate functions on calculations in report studio.

. Developed prompts with report pick list and generated the current

information by applying proper filter condition.

. Fixed issues with reports and successfully deployed

the reporting application for production.

. Enhance and maintain cubes within project.

. Created User Groups, Roles to implement the Cognos Security, using

LDAP.

Environment:

Cognos8 (Framework Manager, Report Studio and Query Studio), Cognos Power

Play 7.3, Cognos Transformer 7.3, Windows NT, Oracle 9i, Toad, PL/SQL, MS

Access.

Sun Microsystems, CA

Nov 07 to Aug 08

Cognos Developer

Sun is known as the developer of technologies such as the Java platform and

NFS, and as a key promoter of open systems in general and UNIX in

particular.

Sun Recruiting as domain deals with the Recruiting and Hiring is a web-

based strategic workforce management system that streamlines and automates

all phases of the company's recruiting, hiring and retention processes.

Responsibilities:

. Understanding the Change request given by client, analyze the changes,

and estimate the time.

. Enhancement of existing reports as per the requirement.

. Unit testing the reports on Dev as well as QA environment, also cross

check by firing query on database.

. Migrating of reports from Dev to QA and from QA to UAT environment.

. Working closely with QA testers and explain them the changes done in

existing reports.

. Working with Migration team to migrate the reports from UAT to

Production environment by submitting artifacts required by them.

. Working on the issues coming from Production and solving them with

limited time.

. Need to address the Research and question arising from client.

Environment:

Cognos Report Net 1.1, Cognos Framework Manager, Report studio, Query

studio and Advance Query Tool.

Wachovia, NC

Nov 06 to Oct 07

Cognos & SQL Server Developer

Wachovia Corporation based in Charlotte, North Carolina is one of the

Largest banking chains in the United States. Wachovia is a diversified

financial services Company that provides a broad range of banking asset

management, wealth management, and corporate and investment banking

products and services.

Responsibilities:

. Interacted with the Business users and documented their query,

business analysis and reporting needs. Understood data and business

logic underlying the requirements.

. Created Powerplay cubes using Transformer (Powerplay).

. Data retrieval, Multidimensional analysis, PowerPlay structure.

. Reporter Operations such as Sum and Average.

. Changing filters, layers and measures.

. Created Multi-Dimensional reports using PowerPlay.

. Designed and developed multi dimensional cubes, Visualizations.

. Queried data from different database tables as per the requirement.

. Joined the different table as per the requirements.

. Created reports in HTML format for easy navigating of data from web

browser.

. Customized data by adding calculations, summaries and functions.

. Created List Reports, Cross Tab Reports and Drill Through reports.

. Created Report and prompts.

. Created summary and detailed filters.

Environment: Cognos ReportNet 1.1 (Framework Manager, Report Studio and

Query Studio), Cognos PowerPlay 7.3, Cognos Transformer 6.6b, Oracle

10g/9i, Windows 2003, RH Linux 9.

BP US & BP UK

Jul 06 to Oct 06

Developer

British Petroleum is one of the largest producers of oil and gas in United

States. Today, natural gas makes up more than 40 percent of U.S. energy

product, and BP is the largest producer and supplier in the United

States.

Responsibilities:

. Develop and analysis Standard and Ad hoc reports requests using

various tables & different panels and to ensure data is accurate as

per as Client requirement.

. Run Standard reports using People Soft (Using N-Visions Module)

. Develop and execute SQL Queries from various people soft Tables.

Environment: People Soft 7.2 (HRMS Module) Toad.

Education and Qualifications:

Bachelor of Commerce (B.com) Mumbai University.

Graduation from Nation Institute of Information Technology (GNIIT)

Contact this candidate