OBJECTIVE:
To secure a challenging position where I can effectively contribute my
Skills as Software Professional, possessing competent technical skills.
PROFESSIONAL SUMMARY:
4+ years of work experience in IT Industry
3+ yrs in Data Warehousing Tools, Such as Cognos Report Studio, Query Studio and
Framework Manager modeler .
Knowledge in designing Star Schema, Dimension and Fact tables
Strong Knowledge in Data Warehousing concepts
Excellent communication, interpersonal skills and highly motivated.
Good logical ability and systematic approach to problem solving analysis
Good knowledge in SQL, DataStage (PX & Server)
EXPERIENCE:
Currently Working as Software Engineer for Satyam Computers Pvt. Ltd., Hyderabad
from Jan-2007 to till date.
Worked as Junior Software Engineer for Axentis Pvt. Ltd., Bangalore from April-
2005 to Dec-2006.
ACADEMIC:
Bachelor Of Computer Science(B.sc), Acharya Nagarjuna University, Narasaraopet
TECHNICAL SKILLS:
Reporting Tools :Cognos 8X, Cognos 10.1
ETL Tools : Ascential Data Stage 7.5
Database : Oracle 9i, RDBMS Concepts and MS-SQL
Languages : C, C++, .Net, SQL.
Operating System : Windows NT/XP/2003 Server, UNIX
PROJECT DETAILS:
Project #4
Title : Retail Business System.
Client : TYCO International, CA Dec-07 to till date
Description:
This project is aimed at evaluation of sales performance of the Business
covering the consumer products especially, TYCO products. Data warehouse designed
for the purpose of Sales Analysis that basically helps the decision makers to analyze the
sales patterns. The main achievement of this project is to reduce the manufacturing cost
and improved the sales forecasting by identifying key factors like the total sales revenue
on the monthly and quarterly basis on the region and the sale amount. Performed ETL
Operations using Ascetical data stage to load data into Data warehouse.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Windows 2003 Server, Oracle, Cognos10.1.
Project #3
Title : Financial Services for Crown Bank
Client : Crown Bank, USA Jan-07 to Nov-07
Description:
Crown Bank is one of the leading banking systems in United States of
America. They would like to maintain the centralized Information in multi dimensions
for all transactions. Financial Services for Crown Bank is a system being designed to
integrate major financial processes at Crown Bank and deliver fast and easy access to
financial information. Client wants the ability to slice and dice individual accounts as well
as the household groupings to which they belong. They want to see 5 years of historical
monthly snapshot data on every account. They want to group different types of accounts
and compare balances. Based on the business requirements, we start with a core fact
table that records the balances of every account at the end of each month. Clearly the
grain of the fact table is one row for each account at the end of each month.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Project #2
Title : Healthcare Sales analysis
Client : Kmart International Inc. NJ April-06 to Dec-06
Windows 2003 Server, Oracle,Cognos
Description:
My client maintains a large chain of stores dealing in the various products such
as dairy, healthcare and beauty care. They basically use so-called point of sales for all of
their dealings. Their major points of analysis were concerned with the several promotion
schemes being rendered upon to the customers in the different region/states. The time-
to- time variant promotion schemes were what exactly the important point of analysis
for our client. Apart from this, they were also interested to go in for analysis of the
different sorts of products whose demand keeps on fluctuating being reliant upon the
reduction in price as well as several promotion schemes underlying that.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Windows 2003 Server, Oracle Sql Server2005, Cognos8.4.1
Project #1
Title : Travel Agency Reservation
Client : Expedia Inc, USA. May-05 to Jan-06
Description:
Classic Custom Vacations markets individual vacations tailored to a
traveler’s specific needs and desires. Classic offers a full line of vacation components –
hotels, car rentals, flight options, activities and private transfers – to create customized
vacations in the Hawaii, the Caribbean, America and Europe. A classic Custom vacation
is an Expedia company.
TA-Res is a Travel Agency Reservation system. Travel Agencies, who
want to access this application, can get registered with Login Id and Password will be
allocated to each Travel Agent Staff and/or Travel Agency Manager. The agents at each
agency make reservation for different parties who plan to go on vacations. Details such
as the party name, the hotel in which they want to stay during their vacations, the
airline in which they want to travel are collected by the agents and are entered in TA-
Res. Once this information is gathered, they are placed in the Itinerary. The Itinerary is
a travel planner, where the party can view all the details he/she had opted for.
Responsibilities:
Prepared Test Cases for responsible module
Executed Test Cases manually to verify the system functionality as per user
requirement.
Involved in Bug tracking and bug reporting.
Environment:
Windows XP, ASP.Net, VB.Net, MS-SQL
visit us at :http://www.onlinetrainingsexpert.com/cognos-online-training.html
To secure a challenging position where I can effectively contribute my
Skills as Software Professional, possessing competent technical skills.
PROFESSIONAL SUMMARY:
4+ years of work experience in IT Industry
3+ yrs in Data Warehousing Tools, Such as Cognos Report Studio, Query Studio and
Framework Manager modeler .
Knowledge in designing Star Schema, Dimension and Fact tables
Strong Knowledge in Data Warehousing concepts
Excellent communication, interpersonal skills and highly motivated.
Good logical ability and systematic approach to problem solving analysis
Good knowledge in SQL, DataStage (PX & Server)
EXPERIENCE:
Currently Working as Software Engineer for Satyam Computers Pvt. Ltd., Hyderabad
from Jan-2007 to till date.
Worked as Junior Software Engineer for Axentis Pvt. Ltd., Bangalore from April-
2005 to Dec-2006.
ACADEMIC:
Bachelor Of Computer Science(B.sc), Acharya Nagarjuna University, Narasaraopet
TECHNICAL SKILLS:
Reporting Tools :Cognos 8X, Cognos 10.1
ETL Tools : Ascential Data Stage 7.5
Database : Oracle 9i, RDBMS Concepts and MS-SQL
Languages : C, C++, .Net, SQL.
Operating System : Windows NT/XP/2003 Server, UNIX
PROJECT DETAILS:
Project #4
Title : Retail Business System.
Client : TYCO International, CA Dec-07 to till date
Description:
This project is aimed at evaluation of sales performance of the Business
covering the consumer products especially, TYCO products. Data warehouse designed
for the purpose of Sales Analysis that basically helps the decision makers to analyze the
sales patterns. The main achievement of this project is to reduce the manufacturing cost
and improved the sales forecasting by identifying key factors like the total sales revenue
on the monthly and quarterly basis on the region and the sale amount. Performed ETL
Operations using Ascetical data stage to load data into Data warehouse.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Windows 2003 Server, Oracle, Cognos10.1.
Project #3
Title : Financial Services for Crown Bank
Client : Crown Bank, USA Jan-07 to Nov-07
Description:
Crown Bank is one of the leading banking systems in United States of
America. They would like to maintain the centralized Information in multi dimensions
for all transactions. Financial Services for Crown Bank is a system being designed to
integrate major financial processes at Crown Bank and deliver fast and easy access to
financial information. Client wants the ability to slice and dice individual accounts as well
as the household groupings to which they belong. They want to see 5 years of historical
monthly snapshot data on every account. They want to group different types of accounts
and compare balances. Based on the business requirements, we start with a core fact
table that records the balances of every account at the end of each month. Clearly the
grain of the fact table is one row for each account at the end of each month.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Project #2
Title : Healthcare Sales analysis
Client : Kmart International Inc. NJ April-06 to Dec-06
Windows 2003 Server, Oracle,Cognos
Description:
My client maintains a large chain of stores dealing in the various products such
as dairy, healthcare and beauty care. They basically use so-called point of sales for all of
their dealings. Their major points of analysis were concerned with the several promotion
schemes being rendered upon to the customers in the different region/states. The time-
to- time variant promotion schemes were what exactly the important point of analysis
for our client. Apart from this, they were also interested to go in for analysis of the
different sorts of products whose demand keeps on fluctuating being reliant upon the
reduction in price as well as several promotion schemes underlying that.
Responsibilities:
Responsibilities:
Involved in the Analysis of the Report Design documents and
prepared TDD’s.
Involved in creation of model in framework manager and publish
package
Created conditional formatting repots by using various variables
Created master detail relationship , drill through reports
Created reports by using various types prompts, filters
Created reports by using cascading prompts
Created reports section and page break
Created reports by using query calculation and layout calculation
To Created defect log which is maintained what are the issues
faced in a report
Involved in unit testing
Participated in client interactions on status
Environment:
Windows 2003 Server, Oracle Sql Server2005, Cognos8.4.1
Project #1
Title : Travel Agency Reservation
Client : Expedia Inc, USA. May-05 to Jan-06
Description:
Classic Custom Vacations markets individual vacations tailored to a
traveler’s specific needs and desires. Classic offers a full line of vacation components –
hotels, car rentals, flight options, activities and private transfers – to create customized
vacations in the Hawaii, the Caribbean, America and Europe. A classic Custom vacation
is an Expedia company.
TA-Res is a Travel Agency Reservation system. Travel Agencies, who
want to access this application, can get registered with Login Id and Password will be
allocated to each Travel Agent Staff and/or Travel Agency Manager. The agents at each
agency make reservation for different parties who plan to go on vacations. Details such
as the party name, the hotel in which they want to stay during their vacations, the
airline in which they want to travel are collected by the agents and are entered in TA-
Res. Once this information is gathered, they are placed in the Itinerary. The Itinerary is
a travel planner, where the party can view all the details he/she had opted for.
Responsibilities:
Prepared Test Cases for responsible module
Executed Test Cases manually to verify the system functionality as per user
requirement.
Involved in Bug tracking and bug reporting.
Environment:
Windows XP, ASP.Net, VB.Net, MS-SQL
visit us at :http://www.onlinetrainingsexpert.com/cognos-online-training.html
No comments:
Post a Comment