Oracle PLSQL developer
Resume:
[pic]
Email: **********.*@*****.**
m
Phone: +1-813-***-****
Anbarasan Shanmugam
Dedicated IT professional with exceptional database development experience
with excellent analytical, communication, interpersonal and leadership
skills
EXPERIENCE SUMMARY
Total: 9 yrs.
. More than 9 years of experience in Analysis, Design, Development &
Testing of various Applications in Healthcare, Banking and Retail
domains.
. Extensive experience of software development in PL/SQL.
. Oracle PL/SQL certified professional.
. Experience in Oracle Tools and Utilities for Extraction,
Transformation and Loading (ETL) such as Informatica, Oracle Data
Integrator.
. Proficient in writing and debugging Stored Procedures, Functions,
Database Triggers and Packages.
. Strong experience in writing complex SQL queries.
. Good experience in Database Performance Tuning.
. Strong experience in using Cursors, Ref-cursors, Bulk collect for
processing of data.
. Strong experience in Oracle 9i/10g/11g systems, SQL*Loader, Export,
Import, External tables.
. Proficient in Oracle Utilities like UTL_FILE.
. Exposure to SYBASE database. Worked in T-SQL. Sybase certified
programmer.
. Experience in data warehousing in developing best practices in ETL
development and supporting the application to enhance business
decision making and improve operational efficiencies.
. Good understanding of star schema in data warehouse design as well as
star transformations.
. Experience in designing logical and physical data models using ERWIN.
. Good experience as a Sybase developer.
. Basic knowledge in UNIX commands and shell scripts.
. Good skills in converting the functional specifications into
technical design with exposure to implementation methodologies.
. Extensive experience with onsite/offshore working model.
. A self-starter with clear understanding and systematic approach to
problem solving.
. Involved in projects implemented using Waterfall and Agile process.
. Excellent Communication and strong Interpersonal skills.
TECHNICAL SKILLS
Databases Oracle 9i/10g/11g, Sybase
Tools and PL/SQL,SQL,UNIX Shell Programming, Toad, SQL Loader,
languages Erwin 7.1, Putty, TFS, Citrix, Informatica 8, Sunopsis,
Oracle Data Integrator
Operating System Windows 7/XP/2000/98
Functional areas Banking, Retail and Healthcare
EDUCATION QUALIFICATION
Degree Master of Technology
Specialization Electronics & Communication Engineering
Institute Pondicherry Engineering College, Pondicherry
Dates Attended 07/03/2003 - 06/28/2005
Degree Bachelor of Technology
Specialization Electronics & Communication Engineering
Institute Pondicherry Engineering College, Pondicherry
Dates Attended 06/09/1999 - 05/30/2003
PROFESSION EXPERIENCE DETAILS
Organization CNSI
Duration 06/03/2013 - Present
Designation Senior Programmer
Roles & As a senior programmer of CNSI, i am responsible for
responsibilities monitoring HIPAA file loading jobs, creation of
Outbound files for 834, 271, 277 transactions. I am
also responsible for closing any defects that arise
during creation of outbound files. I also close the
service requests which are assigned to me. In
performing my duties, I involve in writing stored
procedures, functions and packages. I also involve in
writing trigger, creating tables, populating them with
data. I also do unit testing on the objects I have
created and also assist testers with providing proper
information on the created objects. I gained experience
in tools like TOAD, SQL developer and Spec Builder.
Organization Cognizant Technology Solutions
Duration 01/18/2010 - 05/28/2013
Designation Associate Projects
Roles & As associate projects of cognizant, I was responsible
responsibilities for design and development of customized tools and
applications. I was involved in setting up database,
creating tables and populating them with test data. I
was also involved in creating various oracle objects
like stored procedures, functions and packages. I
gained experience in tools like TOAD, PL/SQL Developer.
Organization Tata Consultancy Services
Duration 07/01/2005 - 12/31/2009
Designation Assistant Systems Engineer
Roles & I was involved in creating various oracle objects like
responsibilities stored procedures, functions, packages, table, etc. I
was also involved in creating test data, writing unit
test cases and executing various test
Scenarios. I gained experience in various tools like
oracle PL/SQL developer, Sybase developer, Oracle Data
integrator.
CERTIFICATION
Oracle PL/SQL Developer Certified Professional (OCP).
Sybase Certified Developer
PROJECT DETAILS
CNSI, Gaithersburg, MD
Jun '13 - Present
PROJECT TITLE: Washington MMIS
The project is to support the Medicaid program for Washington State. This
involves the loading of HIPAA inbound files for 270, 276 transactions and
also generating outbound files for 271, 834, 837 and 277 transactions. The
failures in loading is analyzed and the reason is being reported to state.
Also the outbound files are generated and posted to providers. The service
request which involves changes to the existing process are also taken care.
The defects which were opened during file loading are addressed and closed
appropriately.
RESPONSIBILITIES:
> Monitoring weekly and monthly jobs in Production and UAT
> Developed PL/SQL procedures, Functions, Triggers and Packages to
implement the changes in different modules.
> Did unit testing on my developed model.
> Interfacing with the NOC team for production issues.
> Coordinating with various teams for Change management.
> Helped QA by coordinating with testing activities
> Doing impact analysis and risk analysis before approving any change in
source DB objects related to the modules worked.
> Communicate with clients on complicated issues of the project and
resolve the issues within SLA time span and drive SLA adherence within
the team.
> Responsible for analysis of the issue, creation of Functional
Specification Document and Design Documents. After proper unit testing
of the code moving the code to Quality and after user acceptance in QA
move the code to Production environment. Thus involved in all the
stages of SDLC.
> Ensure the daily Production Batch Jobs Cycle should get complete
successfully and if any job failure occurs, immediately take the
corrective actions and ensure that the application should be available
within the SLA time span to the business users before their day start.
> Ensure error free deliverables by driving adherence to quality
assurance norms and guidelines.
> Engage in peer reviews during design, coding and testing.
> Ensure adherence to quality processes.
Environment: Oracle 11G, TOAD 9.0.1
Wellcare, Tampa, FL
Feb '11 - May '13
PROJECT TITLE: Encounters Dev
The term encounter refers to the superset of all professional and
institutional, fee-for-service claims; Wellcare receives encounter files
from various vendors and submitters via the SFTP connection. Each state
refers to a unique Line of Business (LOB). The submitters include
providers, hospitals who send the 837 IPD files for adjudication. The
project involves the addition of new LOBs. While Georgia Family Planning
(GFP) is added to the Georgia state, the Child Health Planning and Family
Health Planning (FHP) are the new LOBs added to the New York state. The new
claims are being processed for the added new LOBs.
RESPONSIBILITIES:
> Requirement analysis and preparation of Functional specification
document based on the BRD (Business requirement document).
> Preparation of technical design documents for various
requirements/tasks worked on.
> Developed PL/SQL procedures, Functions, Triggers and Packages to
implement the changes in different modules.
> Did unit testing on my developed model.
> Interfacing with the production operations team for production issues.
> Coordinating with various teams for Change management.
> Helped QA by coordinating with testing activities
> Doing impact analysis and risk analysis before approving any change in
source DB objects related to the modules worked.
> Communicate with clients on complicated issues of the project and
resolve the issues within SLA time span and drive SLA adherence within
the team.
> Responsible for analysis of the issue, creation of Functional
Specification Document and Design Documents. After proper unit testing
of the code moving the code to Quality and after user acceptance in QA
move the code to Production environment. Thus involved in all the
stages of SDLC.
> Ensure the daily Production Batch Jobs Cycle should get complete
successfully and if any job failure occurs, immediately take the
corrective actions and ensure that the application should be available
within the SLA time span to the business users before their day start.
> Ensure error free deliverables by driving adherence to quality
assurance norms and guidelines.
> Engage in peer reviews during design, coding and testing.
> Ensure adherence to quality processes.
Environment: Oracle 11G, TOAD 9.0.1
Emdeon, Nashville, TN
Feb '10 - Jan '11
PROJECT TITLE: Care Communication (CARECOMM)
Emdeon CareComm is a care communication tool for improving healthcare
decision-making. It enables health plans to engage their provider network
through pre-care messaging that leverages a real-time eligibility
connection, as well as, engage their member population post-care through
print messaging. CareComm helps convey important patient health history and
analytics at the right point in time to improve the health of your member
population. Pre-care messaging enhances care by delivering personalized
information that enriches the physician-patient interaction. In addition to
promoting healthy lifestyles within a health plan's population and provider
network, CareComm facilitates cost avoidance by promoting adherence to
evidence-based clinical best practices and encouraging preventive care over
more costly reactive care.
RESPONSIBILITIES:
> Developed PL/SQL procedures, Functions, Triggers and Packages to
implement the business rules.
> Prepared test cases for Unit testing and Integration testing and test
data for Unit testing.
> Performed Unit testing and performance testing of each business event
type worked on.
> Generated DDL statements for creation of new database objects like
tables, views, sequences, synonyms, indexes.
> Worked on improving the performance of the queries by using
partitioning the tables.
> Worked on issues related performance of the applications.
> Developed shell scripts for FTP'ing files without any user
interaction.
> Developed shell scripts for automating and scheduling using Cron tab.
> Involved in loading bulk data into oracle database use SQL loader
Environment: Oracle 11g, TOAD 9.0.1
Nielsen, Tampa, FL
Feb'09 - Jan '10
PROJECT TITLE: MCH (Media Content Hub)
The main objective of this project is to develop the control and load
packages to load the mainframe file into Netezza database. There will be
daily loads which load data from mainframe files to the Netezza database.
The project involves migration from Informatica to ODI tool. Oracle data
integrator (ODI) or Sunopsis is a data warehousing ELT tool of oracle
product.
RESPONSIBILITIES:
> Developed PL/SQL procedures, Functions and Packages to populate the
data warehouse tables related to Reservation and rental modules.
> Performed Unit testing of the business events worked on and
implemented the changes in the production.
> Monitoring the daily batch run and troubleshooting issues while data
is getting loaded into the data warehouse tables and the Data Marts.
> Created and customized UNIX shell scripts for automating regular
maintenance and batch jobs.
Environment: ODI, Informatica, DB Visualizer, Putty
JPMorgan Chase, Columbus, OH Sep
'07 - Jan '09
PROJECT TITLE: SR-Support
The main objective of this project is to provide support for the
projects PT Open, Personal Trust Convergence and Polaris Takedown. By means
of enhancing the projects as well as resolving the open issues in the
Production Environment by directly interacting with Client. This project is
extension to the support provided in the Client location. This project
involves several enhancement requests which include newly added
requirements. Also involves direct interaction with clients to solve the
production issues. Changes include analysis and development of scripts in
Oracle PLSQL Procedures and Packages. Tables also require data manipulation
changes. Also the performance of the application is improved by tuning the
stored procedures which took more time to execute. The code was deployed in
Dev as well as UAT environments and tested thoroughly before being moved
into Production.
RESPONSIBILITIES:
> Collected requirements from the client for enhancements.
> Prepared Impact Analysis Document
> Developed PL/SQL procedures, Functions, Triggers and Packages.
> Worked on improving the performance of the queries.
> Unit testing of the developed module.
> Deployment in test environment
> Coordinating with various teams for Change management.
> Involved in QA testing along with the testing team.
> Implementing the changes in the production.
> Involved in providing support for the modules after Go Live in the
production.
> Interfacing with the end users for production issues.
Environment: Oracle 9i, TOAD 8.6.1.0
JPMorgan Chase, Columbus, OH
Jul '07- Aug '07
PROJECT TITLE: Webwills
The main objective of this project is to generate reports for the
Webwills application. While the Sybase database is used to load the data,
the Crystal Report is used to generate reports.
RESPONSIBILITIES:
> Developed procedures to implement the business rules.
> Prepared test cases for Unit testing and Integration testing.
> Generated DDL statements for creation of new database objects like
tables, views, sequences, synonyms, indexes.
Environment: Sybase developer, Crystal Report.
JPMorgan Chase, Columbus, OH Oct
'05 - Apr '07
PROJECT TITLE: Personal Trust Account Opening
The main objective of this project is to develop a new consolidated
Personal Trust Application by combining and enhancing the existing
functionality in the four Personal Trust and three Portfolio Management
Group applications. PTAA Account Opening system controls the workflow of
the Trust opening process. It has following 11 different components. This
project was purely a development project. A new application was developed
for opening and managing trust accounts. The stakeholders are high net
worth clients who worth in millions. Responsibility includes setting up of
database, creating tables, adding test data. Packages which include stored
procedures and functions were created and were directly called from front
end application. Testing of packages was done in backend before being
called from the front end.
RESPONSIBILITIES:
> Preparation of technical design document for implementing the business
rules.
> Involved in Database administration activities which include setting
up of database, creating schemas, giving grants, creating database
objects like tables, views, etc
> Written complex SQL queries and PL/SQL procedures/packages/functions.
> Created the Unit test plan documents and involved in end to end
testing of the application.
Environment: Oracle 9i, Toad 8.1.7.4, PL/SQL developer
Contact this candidate