Experience Summary

• Having 3+ years of experience in Analysis, Design and Development of Business Intelligence Projects and Software Development Life Cycle (SDLC).
• Strong knowledge and experience in OLAP tools such as Cognos 8.x, Cognos ReportNet 1.1 and

Experience with ETL tool like Informatica 7x/8x.

• Designed and developed Cognos Framework Manager Models and packages.
• Worked on various tools of Cognos like Report Studio, Query Studio, Cognos Connection and Impromptu.
• Participated in complete implementation process and strategies.
• Experience working with databases including Oracle, MS SQL Server.
• Experience working in Migration Projects.
• Can play a vital role in the team and able to absorb technical knowledge quickly.

Employment History

• Currently working as a Software Engineer Confidential,, from March 2011 to till date.
• Worked as a Cognos Developer Confidential, from Feb 2008 to March 2011.

Academic Qualifications

Master of Computer Applications.

Technical Skills

OLAP Tools : Cognos 10.x/8.x Suite (Framework manager, Query Studio, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Metric Studio),
Cognos ReportNet 1.1 (Framework Manager, Report Studio, Query Studio),
Cognos EP 7 series (Impromptu, Power play, Transformer)
ETL Tool : Informatica PowerCenter 7.x/8.x
Databases : Oracle 9i, 10g, Microsoft SQL Server 7.0/2000/2005
Languages Known : C, C++, Java (Jsp, Servlet), PL/SQL
Operating Systems : Windows XP, 2000, 2003 / NT, Linux
Web / Scripting : HTML, XML, Java Script
GUI Tools : Visual Basic 6.0
Tools/Utilities : TOAD, Putty, WinSCP

Title : Sales Order Processing System
Confidential,USA
Duration : Mar’11 to till date
Environment : Cognos 8.4.1 Suite, Oracle 10g, Windows XP.

Description:

System monitors and handles daily sales-related business transactions: inquiries, quotations, contracts and schedules agreements. It calculates various pricing components, schedules periodic and milestone billings, performs credit limit checks, creates sales and orders documents with confirmed proposed delivery dates. It also gives online status of sales activities and generates various reports for sales analysis.

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various types of prompts in the prompt page.
• Created reports using Cascading Prompts.
• Creating various Kinds of reports like List, Cross tab, Chart in Report Studio.
• Involved in creation of drill through reporting.
• Used filters for efficient data retrieval.
• Resolving the Performance issues of the Reports.
• Scheduling the Reports in Cognos connection.
• Doing unit testing of reports based on the Report requirement specification.

Title : PSA IPC Migration Project
Confidential,Duration : Aug’10 to Mar’11
Environment : Informatica PowerCenter 8.6.1, Oracle 10g, UNIX.

Description:

PSA Corporation Limited is one of the leading global port groups and PSA provides comprehensive range of ocean and harbour marine services, terminal-related logistics services and port IT services. Each of these services consists of smaller business units that are supported by various operational systems.

Many of these systems were part of an acquisition or remain as a legacy of past operations. PSA Corporation currently has a project underway called the “IPC Migration Project”.

Responsibilities:

• Involved in migrating various scripts like (C, C++, pro-C, Pearl) into Informatica.
• Created Analysis, Source to Target Mapping (STM) Documents.
• Prepared HLD & LLD Documents.
• Also Involved in Unit Test Cases (UTC).
• Involved in extraction, transformation and loading of data into Oracle database from sources like flat files, Rdbms.
• Created mappings and mapplets using mapping designer.
• Created different target definitions using warehouse designer of Informatica Power Centre.
• Created different reusable transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator.
• Responsible for choosing proper partitioning methods for performance enhancements.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Successfully loaded initial and incremental loads with best performance.

Title : Provimi Systems
Confidential,Duration : Feb’09 to Aug‘10
Environment : Cognos 8.4.1 Suite, SQL Server 2005, Windows XP.

Description:

The Client is a large CPG (Consumer Packaged Goods) Company. Their product portfolio spans across the entire spectrum of domestic consumption including Soaps, Detergents, Cleaning Liquids, Toothpastes, Talcum powders etc. The company has a massive distribution network of warehouses, distributors and retail stockiest.

The main objective of this project is to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities.

Responsibilities:

• Going thru’ Report Specification Documents and Understanding the User Requirements.
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for reports.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Developed Reports using Conditional Formatting, Cascading Prompts.
• Creating various types of prompts in the prompt page.
• Creating various Kinds of reports like List, Cross tab, Chart in Report Studio.
• Used Drill through operation done for different aspects of client business.

Title : Assets and Liability Management
Confidential,Duration : Feb’08 to Jan‘09
Environment : Cognos ReportNet 1.1, Oracle 9i, Windows 2000.

Description:

Cater Allen Bank U K has been a leading Bank in UK. The company is looking for new business avenues, wanted to increase the customer base and attract more investments. The system has been developed to provide clear picture of the strengths of the Bank in order to take effective decisions and build good customer relationship. To give them intelligent information regarding its current business situation and thus help it to understand the trends, performance and customer Analysis of the Bank.

Responsibilities:

• Analysis of the requirements for the creation of CRN reports.
• Created various types of calculated query items.
• Created Reports using with Cross tab, Section wise Reports.
• Created Master-Detailed query reports using Report Studio.
• Developed Prompt pages, used Conditional Variables for Conditional Formatting.
• Created various types of prompt reports using values prompts, searching and select.
• Doing Unit testing of Reports based on the Report requirement specification.