Project Engineer
Resume:
RAMYA HEGDE
#***, ******* **** **** **********
BSK 3rd Stage, Bangalore.
Phone No. +91-903**-*****
Email : *****.********@*****.***
Career objective:
To move on to the higher level of knowledge by contributing creative solutions to the advancement of organization.
Professional experience: Working with Tata Consultancy Services since July 2011.
Position held: Systems Engineer.
Scope of Work: Having 2.6 years of experience in the areas of Oracle and PL/SQL based applications using Oracle 10g/11g technologies under windows and Unix environments.
Extensive experience in developing packages, stored procedures, functions, exception handling, cursors, constraints, triggers, indexes, views, sub queries, joins and set operators, bulk collect and collections.
* Well acquainted with explain plan, hints, SQL Loader and UTL_FILE package.
* Having good knowledge of Software Development Life Cycle (SDLC).
* Good in understanding of business logic and ability to work well as a part of a team and as an individual with good communication skills. Quick learner & self-directed, consistently updating self with emerging trends in the industry.
Educational qualification and year of passing:
* Bachelor of Engineering in Information Science (2007-2011) from BMSCE Bangalore
with 78% aggregate in the year 2011.
* PUC Science (2005-2007) from MES PU College Sirsi with 85% aggregate.
* SSLC (2004-2005) from Pragati Vidyalaya with 93.28%.
Skills & Expertise:
* Languages: SQL, PL/SQL
* IDE: SQL*PLUS, SQL Developer
* Operating System: Windows XP, Window 7,Unix
* Databases: Oracle 10g, 11g, SQL server 2008
* Functional Domain: BFS, TCS Internal.
Professional Summary:
Project#3
* Title: Tarana automotive dealers
* Duration: Jan 2015 to till date
* Team size: 5
* Environment: Oracle 10g/11g, Windows
* Role: PL/SQL developer
Description: Tarana automotive is an automobile dealership and service providing company. Product management database is created to hold the product, stockiest, order, dispatch, discount on each product, offers, and other accessories details. Customer information and service details are managed by customer management system.
Responsibilities:
* Involved in understanding the customer requirements.
* Developed advance PL/SQL packages, stored procedures, triggers, functions, cursors, ref cursors, tables, views, sequences, synonyms, indexes, PL SQL tables & records, dynamic sql to implement business logic using SQL* plus and SQL developer.
* Wrote SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
* Code validation as per client requirement.
Project#2
* Title: TCS Internal
* Duration: Oct 2012 to Jan 2015
* Team size: 11
* Environment: Oracle 10g, Windows
* Role: PL/SQL developer
Description: TCS internal domain consists of varieties of projects related to TCS and Tata subsidiaries.
Tata Teleservices: Is an Indian broadband and telecommunications service provider. Product Management Information System (PMIS) is a database system used for maintaining the entire database for the products and services provided by TTSL which includes fixed line and mobile telephony, broadband and digital television etc.
Tata Consultancy Services: Employee- Project Information System gathers and manages employee data, running and base project data, domain and account information, outsourced organization details, project-wise expenditures and event management. Butterworth financial group comes under banking and financial domain. Corporate customer transaction facility is a database system which includes account creation, account processing and administration modules. The project covered the new enhancements to the application like online transfers and inter account transfers.
Responsibilities:
* Requirement gathering and worked according to the CR.
* Involved in converting the functional requirements into technical document as per the business standards under senior level guidance.
* Involved in the backend code development, altered tables to add/rename new columns, constraints, sequences and indexes as per business requirements.
* Performed DML, DDL,DCL,TCL operations as per business needs.
* Used different joins, sub queries, correlated sub queries and inline view in SQL query to retrieve the data.
* Involved in creation of sequences for automatic generation of Product ID, Account# and various other IDs on tables.
* Created database objects like tables, views, sequences, synonyms, stored procedures, functions, packages, cursors, ref cursor and triggers.
* Well aware of exception handling, binding and substitution variables, materialized views, hints and query optimization.
* Analyzed the existing code for impact analysis. Involved in modifying various existing packages, procedures, functions, triggers according to the new business needs.
* Testing of code functionality using testing environment and coordinating with various teams.
* Created views and resolved production issues by modifying backend code as and when required.
Project#1
* Title: American Express
* Duration: Sep 2011 to Sep 2012
* Team size: 53
* Environment: UNIX, SQL
* Role: Application support Engineer
Description: An American multinational financial services corporation. The company is best known for its credit card, charge card, and traveler's cheque businesses.
Responsibilities:
* Collecting the performance metrics using Tivoli, CA wily, BMC, Perfomon etc.
* Avoiding business impact by working on tickets in a timely manner, checking and finding the issues from log files.
* Automated multiple menu driven scripts to capture server and network statistics.
* Resolved backend issues with Unix commands and shell scripting knowledge.
* Supported various L1/L2/L3 applications. Resolved incidents using service now within SLA.
Personal & intellectual information:
Date of Birth: 23rd March 1989
Gender: Female
Marital Status: Unmarried.
Hobbies: Listening to music, Pencil sketching and painting, Playing Table Tennis etc.
Languages known: Kannada (Mother tongue), English and Hindi.
Permanent address: At- Kottalli, Post- Kundargi, Tq- Yellapur, Uttara Kannada, Karnataka.
I hereby declare that all the information furnished above are true to the best of my knowledge and belief.
Place: Bangalore Yours Sincerely,
Date : (Ramya Hegde)
Contact this candidate