MCA,Having 3+yr of exp., in cognos
Resume:
Pradeep Kumar .D Mobile: +91-988*******
Mail: rewu7m@r.postjobfree.com
Professional Summary
Having 3.5 Years of experience in IT industry and 3.3 Years of experience in the field of Business Intelligence and Data Warehousing.
Well Versed with various OLAP Tools such as Cognos 8.3 BI, Cognos Report net 1.1 MR2 and Cognos EP7 Series.
Extensively worked on Cognos Tools like–Cognos (8.3/8.1), Cognos Report net 1.1, involving in Developing Reports using Report Studio and Query Studio as per the business requirements.
Created different kinds of reports including List, Cross-tab, Charts, Conditional Block, Prompts, and Bookmarks, Dash Boards and Master Detailed Reports in Report Studio.
Good Knowledge on Data warehousing Concepts.
Experience in writing SQL Queries.
Knowledge in the Framework Manager Creating Models and Packages.
Knowledge in Installing and Configuring Cognos Software.
Have good problem solving and analytical skills. Highly motivated, quick learner and extremely versatile.
Educational Summary
Masters of Computer Applications, Sri Venkatesvara University, Tirupathi.
Bachelor of Commerce from Sri Venkatesvara University, Tirupathi.
Professional Experience
Working for MphasiS, Bangalore as a software engineer from March 2009 to till date.
Worked for Ness Technology, Bangalore as a software engineer from Sept 2007 to Feb 2009.
Technical Summary
Reporting Tools : Cognos 8.3/8.1,Cognos Report net 1.1, Cognos EP7 Service.
ETL Tools : Informatica.
Databases : Oracle 10g.
Operating Systems : Windows 2000 server, Windows XP.
Project Summary
Project#1
Title : Rise Information System
Client : Charles Schwab, USA
Position : Cognos Developer
Technologies : Cognos 8.2 BI, Oracle 10g and Windows XP
Project Description:
This project is involved in the development of data warehouse for Charles Schwab Bank. The data will be organized in terms of Types of accounts, customers, services, Location, credit cards, and insurance.
The main task that is performed is Extraction, Transformation and Loading. It does periodic processing of data. The reporting tools provide reports to users for studying market patterns, gap analysis, revenue estimation and design more cost effective and competitive policies by using Cognos.
Roles and Responsibilities:
Understanding the functional requirement documents.
Interacting with the OSC to discuses the status of the project, clarify any queries regarding the functionalities.
Involved in the developed the Reports and creation the unit test cases.
Developed the Reports using the Prompts, Filters, Drill Through and Calculations in the Reports,
Applied the Conditional Formatting using the conditional variables to high late the data and rendering the objects.
Developed the complex reports using Query Calculation and Layout Calculation
Validated the Reports with database and review the Reports and test cases.
Project#2
Title : NAO (RSTS IW)
Client : GMAC
Position : Cognos Developer
Technologies : Cognos 8.2 BI, Oracle 10g and Windows XP
Project Description:
GMAC (General Motors Acceptance Corporation) RSTS: RSTS stands for Retail Sales for Tools Standardization and it is exist in North America. This project provides common set of Web based reports in Cognos.
All reports are based on a Centralized data source the Information Warehouse (IW).RSTS project follows the iterative development approach. The scope of each release will be determined and approved by the customers.
Roles and Responsibilities:
Designed various types of reports according to end user requirements.
Applied advanced formatting features to the reports using Query Studio and Report Studio.
Understanding the functional requirement documents.
Interacting with the OSC to discuses the status of the project, clarify any queries regarding the functionalities.
Involved in the developed the Reports and creation the unit test cases.
Developed the Reports using the Prompts, Filters, Drill Through and Calculations in the Reports.
Validated the Reports with database and review the Reports and test cases.
Project#3
Title : Farmers Insurance.
Client : Insurance Corporation, Florida, USA
Position : Cognos Developer.
Technologies : Cognos Report Net 1.1, Oracle 8i, and Windows 2000
Project Description:
Farmer Insurance is a nation wide auto and life insurance company. The project required developing a robust a flexible data warehouse of the customer database taking into consideration the key policy decisions of auto insurance. I was involved in transforming the data from data source and loading into the target databases using Cognos generating reports.
Roles and Responsibilities:
Developed ad-hoc reports using query studio.
Developed List, Cross tab, and Chart reports using Report Studio.
Created customized reports using calculations, filters, and conditional formatting in Report Studio.
Worked with complex reports like master-detail and drill through reports.
Designed reports with various formatting features in eliminating the duplicates using Level span, Sectional, and grouping.
Developed a report which involve in creation of single select and multi select cascading prompts.
Project#4
Title : Sales system inventory.
Client : Grady Ltd,.
Position : Report Developer.
Technologies : Cognos Report Net 1.1, Oracle 8i, and Windows 2000
Project Description:
The Client Grady Pharmaceuticals is one of the organization that sells various numbers of products. Grady have various branches, which maintains Database has lot of historical data. That project was creating sales Data warehouse and generate reports. The aim of sales Data warehouse is to analyze sales of major brands varying with different promotional schemes.
Roles and Responsibilities:
Creating ad hoc reports using query studio.
Developed various types of reports like List reports, Cross tab reports and Master detail reports.
Developed a report which involve in creation of single select and multi select cascading prompts.
Creating Drill through reports to the data.
Validated the Reports with database and review the Reports and test cases.
Contact this candidate