MOBIL:+ 91-9490006047
Client: X-Mart
X-Mart is having different malls in our city, where daily sales take place for various
of 3


Published on: Mar 3, 2016

Transcripts - Nagenda-resume

  • 1. K. NAGENDRA BABU EMAIL:kcpnagendra@gmaIl.com MOBIL:+ 91-9490006047 __________________________________________________________________________________ OBJECTIVE:  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 SUMMARY:  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 EDUCATION: Course Institution Board/ University Year Percentage B.TECH Sana Engineering College JNT University 2010-14 65.57% (ECE) Hyderabad Intermediate Sri Chaitanya Junior College Board of Intermediate 2008-10 80.8% (MPC) Education SSC PS High School Secondary School of 2007-08 63% Education TECHINICAL SKILLS: DATABASES DB2 ,ORACLE (11g) LANG UAGES JCL,SQL,PLSQL OPERATING SYSTEMS LINUX, UNIX, WIN 2000/XP ETL TOLLS Data stage(8.01 )
  • 2. PROJECT UNDERTAKEN Client: X-Mart 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? RESPONSIBILITIES  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 PERSONAL DETAILS  Name : K.NAGENDRA BABU  Father’s Name : Sri. K Sivaiah  Date of Birth : 08th Jun 1992  Gender : male  Nationality : Indian  Languages Known : English, Telugu  Marital Status : Single DECLARATION: I hereby declared that the information mention here is true to the best of my knowledge. Date: Signature Place: ( K.Nagendra Babu )

Related Documents