Published on: Mar 3, 2016
Transcripts - Nagenda-resume
K. NAGENDRA BABU
To Work in Challenging Environment that provides generous opportunities for learning
,Which upgrades my knowledge ,improve my skill and provides a room to give out my best
to the origination
Knowledge on SQL/PLSQL Programing in Oracle 11g
Written SQL queries for DDL, DML operations
Good knowledge on database objects like TABLES, VIEWS,INDEXES And SYNONYAMS
Having quite good knowledge on SQL FUNCTIONS And CONSTRAINTS
Having quite good knowledge on SQL JOINS And SUB QUERYS
Creating simple Views and retrieving data from Views
Having good knowledge on PL/SQL Blocks
Good knowledge on CURSORS And EXCEPTIONS
Knowledge on PROCEDURES and FUNCTIONS
Having good knowledge on data warehousing concepts
Course Institution Board/ University Year Percentage
B.TECH Sana Engineering College JNT University 2010-14 65.57%
Intermediate Sri Chaitanya Junior College Board of Intermediate 2008-10 80.8%
SSC PS High School Secondary School of 2007-08 63%
DATABASES DB2 ,ORACLE (11g)
LANG UAGES JCL,SQL,PLSQL
OPERATING SYSTEMS LINUX, UNIX, WIN 2000/XP
ETL TOLLS Data stage(8.01 )
X-Mart is having different malls in our city, where daily sales take place for various
products. Higher management is facing an issue while decision making due to non-availability of
integrated data they can’t do study on their data as per their requirement. So they asked us to design a
system which can help them quickly in decision making and provide Return on Investment (ROI).This
system is developed using technologies like Data ware house,Data Stage,SQL.
The purpose of this project is to build a global data warehouse of Customers, Products, Stores and other
dimensions to provide the following requirements.
1. To see daily, weekly, monthly, quarterly profit of each store
2. Comparison of sales and profit on various time periods
3. Comparison of sales in various time bands of the day
4. To know which product has more demand on which location?
5. To study trend of sales by time period of the day over the week, month, and year?
6. On what day sales is higher?
7. On every Sunday of this month, what is a sale and what is profit?
8. What is trend of sales on weekday and weekend?
Worked extensively on different stages like Transformer, Join, Sort, Lookup, Modify,
Filter, and Aggregator for Data Transformation
Very good knowledge on when to use which stage
Very good at Debugging by looking at warning and errors present in Data stage job log from
Data Stage Director
CO CURRICULAR ACTIVITIES:
Presented TechnicalPapers at Colleges
Participate in NCC Activities in schooling
Name : K.NAGENDRA BABU
Father’s Name : Sri. K Sivaiah
Date of Birth : 08th
Gender : male
Nationality : Indian
Languages Known : English, Telugu
Marital Status : Single
I hereby declared that the information mention here is true to the best of my knowledge.
Place: ( K.Nagendra Babu )