Engineer Sql

* - ****.**********@*****.***

J Teja ( - +**--920-***-****

(ORACLE PL-SQL DEVELOPER)

Professional Summary:-

2+ Yrs. of Experience on Oracle Database Development and Production Support.

Experience in Creation of Tables, Indexes using SQL and PL\SQL.

Involved in SDLC (Agile), Bug Life cycle starting from Requirements gathering and performed objects oriented analysis and Design to Implementation & Maintenance.

Extensively worked on Backend Programming using PL/SQL stored Procedures, Functions, Packages, Database triggers, Exception Handling.

Expertise in creating Oracle Tables, Table Partitions, Views, Joins.

Extensive experience in using Cursors and Ref-cursors for processing of data.

Implemented securities using Roles, Privileges and Grants.

Experienced in Tuning SQL Statements and Procedures for enhancing the load Performance in various schemas across databases.

Used Toad development tools to speed up the development process.

Ability and willingness to learn new technology and acclimatize to any work culture.

Strong in data base management concepts, UNIX Skills.

Excellent skills in communication, problem solving and logical methodology work well in the team environment or leading a team. .

Experience in Collections and Explain Plan.

Experience in Bulk Collection & Bulk Binding, PL/SQL Tables.

Writing Ad-hoc queries based on schema knowledge for various reporting requirements.

Due to the dynamic nature of the business, Self-motivation & the ability to learn quickly.

Effective planner and works under tight schedules.

Able to adapt quickly to the environment and willing to work in shifts.

Technical Skills:

Operating Systems : Windows XP, UNIX.

Languages : SQL, PL/SQL.

Databases : Oracle 10g/11g

Tools : TOAD, SQL Developer.

Professional Experience:

Oct 2014 –Till Date : - Tech Mahindra Ltd, Bangalore as an S.Engineer.

Education Qualification:

B.Tech from JNTU, Ananthapur.

Project summary:

Project #1:

Company Name : Tech Mahindra Ltd.

Project Name : BTW Geneva

Client : British Telecom

Role : PL/SQL Developer

Duration : Sep’15 to Till Date

Database : Oracle

Practice : SQL, PL\SQL, Oracle Toad, UNIX.

Description:

Geneva supports the standard billing functionality of Rating, Billing and Product and Tariff management .The wholesale partners /service providers will be modeled here. Rating and billing is carried out in batch mode with a bill being generated for the service providers. It provides all solutions related to postpaid end to end telecom solutions. In this Project, Postpaid Rating and Billing team handles all the billing Activities, issues related to billing and configurations related to Rating. Operations team on the other hand looks into customer complaints, payment reversals, implementing promotional activities and customer life cycle management activities, Performing additional Operational tasks like Monitoring Rating Processes, Rejection Processing, Re-rating, Generating additional reports as requested by Client. Whereas configuration team will work on adding new configuration team will work on adding new configurations like profile creation, tariff Creation and Changes, Creation of new Mobile numbers, voice or SMS short codes, Offer and Package Creation.

Responsibilities:

Involved in writing complex SQL Queries, PLSQL code to implement the business requirements.

Involved in Creating the Procedures, Functions, Triggers, Views, and Collections.

Involved in analyzing Schema’s, Tables and Indexes as part of Query optimization.

Doing the performance tuning in different areas on database.

Provides updates and status to the Managers and others, on customer issues.

Extensively Used Joins writing Views in the Database.

Worked with Sub-Queries/Co-related Sub-queries in different areas of the Database.

Project #2:

Company Name : Tech Mahindra Ltd.

Project Name : AIPBS

Client : RBS

Duration : Oct’14 to Aug’15.

Role : Application Support Engineer

Database : Oracle

Operating Systems : Windows XP.

Practice : SQL, PL\SQL, Oracle Toad, UNIX.

Description:

AIPBS is the new System being developed which stands for “Applicative Infrastructure Productive Banking System”. The proposed system is a Payment Order Processing System. The developed system will have interfaces with existing systems such as IBO-MGMT (Interactive Banking Objective-Management), EBF (Electronic Banking Facility) and ICF (Interactive Credit Facility). The developed system consists of Standard Connector, IBO-MGMT and IBO-Sluice.

The IBO-Sluice processes the payment order of other banks. The Standard Connector processes the payment orders within the Post Bank. The IBO-MGMT is the core, which involves Validation, Authorization, Booking, Reservation, and Reconciliation processes. The EBF (Electronic Banking) is an existing system, which supplies on-line transaction details (such as Credit Cards) to the IBO-MGMT for processing.

Responsibilities:

Involved in writing complex SQL Queries, PLSQL code to implement the business requirements.

Clarifying and resolving the Tickets raised by the customers.

Involved in ITIL Process-Incident, Change, and Problem Management.

Assisting L2 support team for application issues during the business operations.

Assisting L2and supporting for resolutions of Application issues.

Resolve the L2 issues within the SLA timelines.

Co-ordinate the L2 support vendor in case of product bug/enhancement requirement.

Handle Incident Tickets and take action as per the Application documentation.

Doing the initial investigations in the application on the customers’ Requests.

Writing the Joins &Sub Quires in different areas based on Business requirement.

Provide regular updates to customers on open support issues.

Environment: Oracle 10g/11g, SQL*Loader, Toad, Sql Developer, Data Pump (Import/Export).

Contact this candidate