Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

VIJAYASABAPATHI PARASURAMAN

Pflugerville,TX

Summary

  • Sixteen years of experience in Oracle SQL and developing PL/SQL database objects.
  • Currently working as a Senior Oracle PL/SQL Developer.
  • Experienced in creating and implementing relational database models to align with business requirements.
  • Knowledge of Oracle Query Performance Analysis and Tuning the SQLs.
  • Experienced in Client-Server application development using Oracle 12c, 11g, 10g, and 9i, PL/SQL, and TOAD.
  • Four years of experience in UNIX and Informatica.
  • Experienced in data modeling.
  • Expertise in the different phases of the Software Development Life Cycle (SDLC), like Requirements Analysis, Design, Development, Unit Testing, Implementation, Software Management, and Enhancement of various Applications on Client-Server Technologies.
  • Involved in Database Production Fixes, Production Support activities, and resolving Support Tickets.
  • Expertise in developing RDBMS.
  • Have worked on Oracle 9i to Oracle 10g migration and Oracle 10g to Oracle 11g migration activities.
  • Exposure to Banking and Insurance domains.
  • Have an understanding of Core Banking and Property & Casualty Insurance, Medicare Insurance Concepts.
  • Experienced working in a Cloud environment (Amazon Web Services).
  • Very good communication skills, good interpersonal skills, and a desire to excel. Fast learner, hardworking, and a versatile team player.
  • Mentored associates on PL/SQL by handling several training sessions on SQL and PL/SQL.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Senior Oracle PL/SQL Developer

Acentra Health
Austin, TX
09.2015 - Current
  • Arizona-Hawaii Provider Enrollment process to enroll different types of providers into the system.
  • The CHAMPS application handles various processes, such as provider enrollment into the system, member eligibility enrollment, claims processing, and making payments for Michigan MMIS.
  • Developed and implemented complex SQL queries to extract data from multiple databases.
  • Optimized existing queries by analyzing query plans and execution times.
  • Performed database tuning activities such as indexing, partitioning and performance monitoring.
  • Provided technical support to users in resolving database related issues and errors.
  • Analyzed existing schema structures and modified them as per changing requirements.
  • Identified gaps in existing processes and provided recommendations on improving overall efficiency.
  • Provided technical support and training to end-users on database querying and reporting tools.
  • Participated in data modeling sessions, contributing to the development of logical and physical database designs.
  • Optimized SQL queries and stored procedures, reducing execution time by significant percentages.

I.T. Analyst

Tata Consultancy Services
Hartford, CT
12.2010 - 09.2015
  • Enterprise Risk Management involves estimation and projection of risk in writing policies.
  • Implemented complex SQL queries to efficiently retrieve information from multiple databases.
  • Constructed optimized queries using stored procedures, functions and views for seamless data handling
  • Analyzed query plans and execution times to optimize existing queries.
  • Executed database optimization tasks including indexing, partitioning and performance supervision.
  • Resolved database related issues and errors by providing technical support to users.
  • Engaged in a collaborative effort with Business Analysts to gain insight into functional requirements and convert them into technical specifications.
  • Established replication to synchronize information between distinct systems.
  • Test data management, ensuring data quality, and data assurance process.

Systems Engineer

Polaris Software Lab
Chennai, India
02.2007 - 12.2010
  • Core Banking - Relationship Query and End of Day Transaction Processing.
  • Developed stored procedures, functions and packages using PLSQL to support the application development needs.
  • Designed complex database objects like tables, views, triggers and indexes as per business requirements.
  • Created test cases for unit testing of new or existing PL and SQL code.
  • Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.
  • Performed debugging of existing PLSQL code as part of bug fixing activities.
  • Involved in migrating the old version of Oracle database to newer versions with minimal downtime.
  • Participated in Database Design Discussions with Business Analysts and Application Teams.
  • Collaborated with other teams such as DBA's, Data Architects and System Administrators for resolving any issues related to Oracle databases.

Education

BE. - Bachelor of Engineering

PMR Institute of Technology
Chennai, Tamilnadu, India
01.2006

Higher Secondary Certificate - H.S.C

National Higher Secondary School
Mannargudi, Tamilnadu, India
01.2002

Secondary School Certificate - S.S.C

Devi Matriculation School
Mannargudi, Tamilnadu, India
01.2000

Skills

  • Oracle Database SQL
  • PL/SQL
  • TOAD
  • PL/SQL Developer
  • Informatica
  • AWS
  • Putty
  • Citrix
  • Edit Plus
  • Ultra Edit
  • SQL Loader
  • Autosys
  • Remedy
  • Jira
  • Windows 7
  • Oracle 9i Database
  • Oracle 10g Database
  • Oracle 11g Database
  • Oracle 12c Database
  • SVN
  • PVCS
  • Clear Case Explorer
  • Python Basics

Accomplishments

  • Certificate of Appreciation - Contributions to Test Data Management project
  • Quarterly Excellence Award - Dedication and Commitment to the project delivery

Certification

  • Oracle Certified Professional
  • Oracle Certified Associate

Timeline

Senior Oracle PL/SQL Developer

Acentra Health
09.2015 - Current

I.T. Analyst

Tata Consultancy Services
12.2010 - 09.2015

Systems Engineer

Polaris Software Lab
02.2007 - 12.2010

BE. - Bachelor of Engineering

PMR Institute of Technology

Higher Secondary Certificate - H.S.C

National Higher Secondary School

Secondary School Certificate - S.S.C

Devi Matriculation School

Similar Profiles

CREATE PROFILE
VIJAYASABAPATHI PARASURAMAN