Data Sql

EDUCATION

Master of Computer Applications :Madras University, Chennai, India(2004)

Bachelor of Mathematics :Madras University, Chennai, India(2001)

SUMMARY

Around six years of experience in Pro*C, PL/SQL, Oracle 9i/10i and UNIX shell scripting.

Well versed in Banking and Telecom domains.

Good knowledge of System Development Life Cycle (SDLC)

Experience in coding Optimized SQL Queries.

Experience in PL/SQL packages

Knowledge in DML, DDL, DCL, Transactions, Stored Procedures, Triggers and Functions.

Strong numerical, interpretative, analytical and diagnostic skills.

Hands on experience in troubleshooting database issues, debugging Oracle stored procedure/triggers.

Worked in Performance Tuning, Query Optimization.

Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures.

Good understanding of creating indexes, Views, complex Stored Procedures, user defined functions, cursors, triggers to facilitate efficient data manipulation and data consistency.

Knowledge in tuning SQL queries and improving the performance of the database.

Experience in creating Clustered and Non Clustered indexes on tables.

Experience in creating Jobs, Sending Alerts using DB Mail.

Experience in using Oracle utilities like SQL*Loader and TOAD.

Experience in Production Support, Monitoring Jobs.

Strong inclination for finishing job within project deadline and good time management skills.

Extremely attentive, strong team player with ability to take new roles and work in high pressure environments.

Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Databases

Oracle 9i/10i

Languages

Pro*C, PL/SQL

Operating Systems

UNIX

PROFESSIONAL EXPERIENCE

Tata Consultancy Services (TCS) July 2010- February-2011

IT Analyst

Module: Data Billing

Telecom Billing is a process of collecting usage, aggregating it, applying required charges and finally generating invoices for the customers. Telecom billing process also includes receiving and recording payments from the customers. It is

an enterprise application software designed to support the telecommunications billing processes. This module provides various types of portfolio about the calls made by the customer.

Responsibilities

Involved in production support.

Involved in impact analysis, coding, performance testing and production deployment.

Involved in gathering Development Specifications (DS).

Identified problematic and long running queries in production environment for optimization.

Developed complex stored procedures for data billing modules.

Involved in tuning SQL queries using Automatic SQL Tuning Task.

Worked closely with the team in finding solutions to arising problems.

Followed a priority-based methodology to address client’s issues on stipulated time window.

Environment: Pro*C, PLSQL, UNIX, Oracle 9i

Polaris Software Labs (Client- Citibank) June 2005- June 2010

Developer, Support

Citibank is an Indian private sector bank headquartered in Mumbai, Maharashtra. It is a subsidiary of Citigroup, a multinational financial services corporation headquartered in Manhattan, US. CACS (Computer Aided Collection System) is a Credit Card/Loan – Recovery System which extracts tera data transaction about the Citibank Customers and calculates delinquent information based on the payment information. System in turn assigns a telecaller based on the delinquency which helps in the recovery process.

Responsibilities

Requirement Gathering and Analysis

Requirement scoping & prioritization

Preparation of Functional Specification Document

Use Case Analysis

Presentation of detailed requirements to the testing teams.

Creating Process Flow

Functional Test Case Review

SIT/UAT Support

Maintaining Traceability Matrices

Participate in appropriate support team training activities.

Worked on PLSQL – DBMS OBFUSCATION to Encrypt the data

Implementation of METHOD4 in PRO*C

Modified the database structure as per the client requirements

Developed packages, stored functions, procedures and database triggers

Used materialized view for reporting purpose

Used Ref cursors to retrieve data from database

Modified the database structure as per the client requirements

Developed numerous programs using PL/SQL packages to do the validations

Performed data analysis and created conceptual, logical and physical data model

Extensively worked on Performance Tuning Project to bring down the execution time of BATCH/EOD Processors

Designed and developed different database objects containing functions, triggers, store procedures to manipulate database of the application

Implemented stored procedures to populate data in ORACLE collection by using PIPELINE concepts

Created Explicit Cursors in Packages

Created tables, indexes, packages, stored procedures, triggers and views in Oracle

Developed PL/SQL scripts for batch processes and scheduled it DBMS JOB & DBMS SCHEDULER

Responsible for SQL tuning, Bug fixes and Testing

Used TOAD to query Oracle database and to get information needed about the Oracle tables to create staging tables

Used Explain Plan for Optimizing / Tuning for better performance and efficiency

Implemented stored procedures to populate data in ORACLE collection by using PIPELINE concepts

Created tables, indexes, packages, stored procedures, triggers and views in Oracle

Developed PL/SQL scripts for batch processes and scheduled it DBMS JOB & DBMS SCHEDULER

Prepared KORN shell scripts and used UNIX CRON utility for scheduling

Used Explain Plan for Optimizing / Tuning for better performance and efficiency

Worked on ORACLE 10G feature – DBMS SQL Tuning Advisor for Performance Tuning

Embedded HTML Tag functionality in ORACLE using DBMS UTL SMTP Package.

Prepared Explicit & Implicit Cursors

Worked on Oracle CDC ( Change Data Capture ) Concepts

Extensively involved in preparation of pseudo-code for all complex releases

Worked on ORACLE 10G feature – DBMS SQL Tuning Advisor for Performance Tuning

Assisted in Process consultancy including designing, optimizing, implementing and maintaining process

Evaluated algorithms and methods for their fitness for a particular task, as well as developing and implementing new numerical algorithms.

Developed complex parameterized reports, which used for making current and future research decisions.

Worked closely with the team members in other Universities in finding solutions to arising problems.

Followed a priority based methodology to address issues on stipulated time window.

Involved in job scheduling and alerts.

Environment: Pro*C, UNIX, SQL & PL/SQL, SQL*Loader, Toad

Technical support was also given to Citibank users for production related queries in collections systems for loans and cards.

Responsibilities:

Involved in developing the application for functional areas like Citi Alerts, CACS, Settlement, Rewrite

Involved in preparation of control environment, a replication of production

Involved in preparation of impact analysis for the system

Involved in coding for Pro*C related activities

Involved in Unit, System and UAT Testing

Environment: Pro*C, UNIX, SQL & PL/SQL, SQL*Loader, Toad

Personal Summary

Address : 2617 – DeKalb Pike, Apt# 203, Norristown, Pennsylvania 19401, USA

Mobile : 215-***-****/240-***-****

E-mail : ******.*****@*****.***

Visa Status : EAD (H4)

Contact this candidate