![Making sure tracking data changes in the core business tables by having audit tables to
have the change history using insert and update triggers.
Coordinating with Data modeler for the tables and its columns naming.
Prepare the design document and reviewing with architect and team.
Prepared the unit test cases, tested each scenario and captured the results.
Writing oracle Packages, procedures, functions, cursors and triggers to build core
repository.
Wring required validations in the UNIX shell scripts to make sure we received right set of
files to trigger the process. And responsible for doing business validations in Oracle
package and raising application errors and handling oracle exceptions.
Writing UNIX Shell script for loading SSNs from different source system using SQL Loader
to the staging temp tables.
Using oracle hints like PARALLEL, APPEND, INDEX, FULL, and USE_HASH as required.
Using oracle Pseudo columns like SYSDATE, SYSTIMESTAMP, ROWID, ROWNUM, USER,
LEVEL, CURRVAL, and NEXTVAL as needed.
Loading and processing more than 12 million rows of records and generating request
files to DMDC.
Identified and created partition tables with list portioning with its local indexes. Created
a package called ****_MANAGE_PARTITION which can be used for truncate or drop
partitions.
Revived the code and get the review comments addressed from team, sent for external
review and coordinated with the team.
Involved in tuning queries in Oracle SQL and PL/SQL.
Coordinating with testers to test the system and giving fixes if needed.
Have also been involved extensively in Support Activities which included Debugging
activities and Bug Fixing.
Preparing implementation plan, creating change order, planning application outage
timing, coordinating with different teams for approval and coordinating with DBAs, SOM
(Software Object Management) and information security teams for migration.
Project Title : Webstats Stats Collection and Reporting System
LexisNexis-NES-RTU (New Editorial system Real-time updates)
Client Name : LexisNexis,NJ,US. (Cognizant India, Software development center)
Duration : Aug 2010 Nov 2013
PROJECT DESCRIPTION
LexisNexis Web Stats capture the usage behavior of customers i.e. searches, profile
visits, website visits etc. Web Stats tracks the account level/product level activities happening
across different sites like Lawyers.com [LDC], Martindale.com [MDC] & Custom websites.
5 | P a g e](https://image.slidesharecdn.com/5b0b4588-6f14-4048-9264-887db72ccb6f-160924002249/85/Kanakaraj_Periasamy-5-320.jpg)
More Related Content
What's hot (20)
Similar to Kanakaraj_Periasamy (20)
Kanakaraj_Periasamy
- 1. Kanakaraj Periasamy 331-625-5425 Sr. Oracle PL/SQL Developer and Lead kanakaraj08@gmail.com Lansing, MI. Current Status: H1B Oracle PL/SQL Professional with 9+ Years of strong experience in requirement gathering, analysis, design, development, testing, implementation, support and maintenance of client/server applications using Oracle PL/SQL. Good in Oracle Back-End Programming and Relational Database Management System concepts. Developed complex business logic using Oracle PL/SQL (Functions, Procedures, Packages, Cursors and Triggers) and good in UNIX Shell Scripting. Strong interpersonal skills in interacting with End-Users, Excellent work ethics, self-motivated, quick learner, team player and team oriented. SUMMARY Over 9 years of experience in Application and Product development using Oracle PL/SQL as Oracle Database Developer More than 3 years of experience in leading the team which includes assigning the task, assist the team technically and functionally. Expertise in RDBMS Concepts, Oracle SQL, PL/SQL, Procedures, Functions, Packages and Triggers Expertise in Data modeling by identifying tables needed for the project based on the requirement and creating related tables with required relationship. Expertise in Oracle Materialized Views Expertise in Oracle Bulk operations and Collections Expertise in Oracle table indexing by analyzing various fields will be used to query the table and creating unique, non-unique, function based indexes as required Expertise in table partitioning, sub-partitioning, creating local index for the partition and managing the partition like drop, truncate, move Expertise in using Oracle DBMS_* package which includes File handling, Hash total calculation, Compile schema and Building XML from table data and others Expertise in Explain Plan, Performance tuning, Query Optimization, and using various hints and building the table itself with performance as main consideration Good experience in using SQL Loader for loading millions of records Experience in Oracle advanced queues Experience in handling more than 12 million rows of records Experience in working Database of size more than 5 terabytes Expertise in writing procedure for web services Experience in Schema preparation Expertise in UNIX Shell Scripting Good experience working with various FTP protocols like FTP, SFTP, LFTP and SCP Good experience managing files in UNIX server using Shell Script Good experience batch processing Proficient in One Automation Job scheduling 1 | P a g e
- 2. Experience in Production on call 24/7 Support and working CA Service Desk Manager. Over 5 years of experience in banking domain and more than 6 months experience in Healthcare domain. Experience in Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools Thorough experience on software development methodology, worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation TECHNICAL SKILLS Operating System : Windows Programming Languages : PL/SQL, Core Java, JavaScript, HTML, XML Databases : Oracle 10g, 11g, 12c Scripting : UNIX Shell Scripting Tools : Toad, PLSQL Developer, SQL Navigator, SQL Developer, Oracle Forms, PUTTY, WinSCP, Visio, Pvcs, CA Software Change Manager, CA Service Desk Manager, Clear Case EMPLOYMENT HISTORY CNSI, US (Michigan State Project) : Feb 2016 to Till date LnTInfotech, US : Nov 2015 to Feb 2016 Cognizant Technologies Solutions, US : Nov 2013 to Nov 2015 Cognizant Technologies Solutions, India : July 2010 to Nov 2013 Oracle Financial Service Software Limited, India : July 2007 to Jul 2010 EDUCATION - Master of Computer Application, India, 2007. EXPERIENCE SUMMARY Project Title : Medicaid Managed Care System Operation Support Client Name : State of Michigan, Lansing, Michigan. Duration : Feb 2016 Till date Programming Languages : Oracle SQL, PL/SQL Tools : SQL Plus, Toad Version Management : Clear Case PROJECT DESCRIPTION Medicaid Managed Care is the subsystem in Community Health Automated Medicaid processing System known as CHAMPS, The Managed care system pays the monthly payments 2 | P a g e
- 3. to the providers for the members in state of Michigan those who eligible for Medicaid which helps the members to get health benefits from the list of providers. RESPONSIBILITIES: Involving in requirement analysis with business for the issue reported. Analyzing the application PL/SQL code and table data for identifying the issue, converting the issue into defect or enhancement based on the system functionality and preparing the design document. Identifying the table relationship and build accordingly. Creating new oracle Package, Procedure, Function or modifying the existing oracle objects as needed. Involved in performance tuning of the queries and PL/SQL code reengineering. Coordinating with testing team for the system test and state staff for UAT testing for the changes being tested. Have also been involved extensively in Support Activities which included Debugging activities and Bug Fixing. Coordinate with Data modeler for the all the DDL changes. Monitoring the productions jobs. Project Title : Data Privacy Client Name : Citi Bank, Edison, New Jersey. Duration : Nov 2015 Feb 2016 Programming Languages : Oracle SQL, PL/SQL, UNIX Shell Scripts Tools : SQL Plus, Toad, PLSQL Developer, PUTTY, WinSCP, Visio, CA Service Desk Manager Version Management : CA Software Change Manager PROJECT DESCRIPTION Data privacy application is for when every new initiative created in the system makes sure the initiative gets approval based on the data privacy act. RESPONSIBILITIES: Involved in requirement analysis with business. Managed Oracle development and production support team. Prepared the Design specifications for the Business processes, Validations based on the gathered requirements. Identifying the tables needed and Data modeling. Identifying the table relationship and build accordingly. Writing oracle Packages for building complains data. 3 | P a g e
- 4. Revived the code and get the review comments addressed from team, sent for external review and coordinated with the team. Involved in tuning queries in Oracle SQL and PL/SQL. Review of code changes, test procedure, test plans and other deliverables using Clear case. Was responsible for formulating test strategy. Have also been involved extensively in Support Activities which included Debugging activities and Bug Fixing. Project Title : Customer Information System (SCRA, BanBox) Client Name : Navient, Fishers, Indiana, US. Duration : Nov 2013 Nov 2015 Programming Languages : Oracle SQL, PL/SQL, UNIX Shell Scripts Tools : SQL Plus, Toad, PLSQL Developer, PUTTY, WinSCP, Visio, CA Service Desk Manager Version Management : CA Software Change Manager PROJECT DESCRIPTION Customer Information System (CIS), the project is for implementing the Service Member Civil Relief Act (SCRA) to the customers having loan. Customer Information System (CIS), the project is for splitting the company, private loans and its customer data has been divided and separated as CIO. ROLES AND RESPONSIBILITIES IN THE PROJECT Managed team of around 10 members at onsite and offshore very effectively. As a team lead responsible for preparing requirement document and design document. Involved in requirement gathering with business. Preparing the understanding documents based on the requirement discussion. Identifying the tables needed, relationship and Data modeling. Identifying the Primary key, foreign key and other constraints in order to maintain data integrity and maintainability. Identifying the temporary tables and business permanent tables to achieve the required business functionality. Prepared the Design specifications for the Business processes, Validations based on the gathered requirements. Identifying the default values for the columns and make sure the value populated always by using constraints and triggers. 4 | P a g e
- 5. Making sure tracking data changes in the core business tables by having audit tables to have the change history using insert and update triggers. Coordinating with Data modeler for the tables and its columns naming. Prepare the design document and reviewing with architect and team. Prepared the unit test cases, tested each scenario and captured the results. Writing oracle Packages, procedures, functions, cursors and triggers to build core repository. Wring required validations in the UNIX shell scripts to make sure we received right set of files to trigger the process. And responsible for doing business validations in Oracle package and raising application errors and handling oracle exceptions. Writing UNIX Shell script for loading SSNs from different source system using SQL Loader to the staging temp tables. Using oracle hints like PARALLEL, APPEND, INDEX, FULL, and USE_HASH as required. Using oracle Pseudo columns like SYSDATE, SYSTIMESTAMP, ROWID, ROWNUM, USER, LEVEL, CURRVAL, and NEXTVAL as needed. Loading and processing more than 12 million rows of records and generating request files to DMDC. Identified and created partition tables with list portioning with its local indexes. Created a package called ****_MANAGE_PARTITION which can be used for truncate or drop partitions. Revived the code and get the review comments addressed from team, sent for external review and coordinated with the team. Involved in tuning queries in Oracle SQL and PL/SQL. Coordinating with testers to test the system and giving fixes if needed. Have also been involved extensively in Support Activities which included Debugging activities and Bug Fixing. Preparing implementation plan, creating change order, planning application outage timing, coordinating with different teams for approval and coordinating with DBAs, SOM (Software Object Management) and information security teams for migration. Project Title : Webstats Stats Collection and Reporting System LexisNexis-NES-RTU (New Editorial system Real-time updates) Client Name : LexisNexis,NJ,US. (Cognizant India, Software development center) Duration : Aug 2010 Nov 2013 PROJECT DESCRIPTION LexisNexis Web Stats capture the usage behavior of customers i.e. searches, profile visits, website visits etc. Web Stats tracks the account level/product level activities happening across different sites like Lawyers.com [LDC], Martindale.com [MDC] & Custom websites. 5 | P a g e
- 6. The lawyer information reflects into Lawyers.com portal its taking around 10 days. By Real time updates the changes made in CSC can be reflected at the same time. Its achieved by getting the XML from CSC and immediately reflects the same in NES. KEY ROLES AND RESPONSIBILITIES IN THE PROJECT Responsible for attending the onsite coordinator and client by daily and weekly basic for project status and requirements. Involved in developing and testing Oracle Stored Procedures, Functions and Packages. Involved in tuning queries in Oracle SQL and PL/SQL. Prepared the Design specifications for the Business processes, Validations based on the gathered requirements. ------------------------------------------------------------------------------------------------------------------------------- Project Title : FLEXCUBE Enhancements and customization Client Name : JFAM, China Trust Bank and Barclays Bank Duration : Dec 2007 July 2010 PROJECT DESCRIPTION FLEXCUBE is the one of the top product in banking, its core banking product there were enhancements and customization on this product for various banks like JFAM, China Trust Bank and Barclays Bank. KEY ROLES AND RESPONSIBILITIES IN THE PROJECT Worked on various modules like Bills and collections, customer loans, customer. Involved in developing and testing Oracle Stored Procedures, Functions and Packages. Responsible in using Oracle Collection in the code for handling large collection of data. Responsible for using Bulk operation for Insert, Update, Delete and Select operations. Responsible for using NOCOPY when every passing large amount data to the subprograms. Involved in DBA activities like schema preparation. Involved in frontend screen development using internal tool RAD. 6 | P a g e
- 7. The lawyer information reflects into Lawyers.com portal its taking around 10 days. By Real time updates the changes made in CSC can be reflected at the same time. Its achieved by getting the XML from CSC and immediately reflects the same in NES. KEY ROLES AND RESPONSIBILITIES IN THE PROJECT Responsible for attending the onsite coordinator and client by daily and weekly basic for project status and requirements. Involved in developing and testing Oracle Stored Procedures, Functions and Packages. Involved in tuning queries in Oracle SQL and PL/SQL. Prepared the Design specifications for the Business processes, Validations based on the gathered requirements. ------------------------------------------------------------------------------------------------------------------------------- Project Title : FLEXCUBE Enhancements and customization Client Name : JFAM, China Trust Bank and Barclays Bank Duration : Dec 2007 July 2010 PROJECT DESCRIPTION FLEXCUBE is the one of the top product in banking, its core banking product there were enhancements and customization on this product for various banks like JFAM, China Trust Bank and Barclays Bank. KEY ROLES AND RESPONSIBILITIES IN THE PROJECT Worked on various modules like Bills and collections, customer loans, customer. Involved in developing and testing Oracle Stored Procedures, Functions and Packages. Responsible in using Oracle Collection in the code for handling large collection of data. Responsible for using Bulk operation for Insert, Update, Delete and Select operations. Responsible for using NOCOPY when every passing large amount data to the subprograms. Involved in DBA activities like schema preparation. Involved in frontend screen development using internal tool RAD. 6 | P a g e