KARTHI PALANISAMY

**** ****** ***** **** *, Apt *034, Irving, TX - 75063 +1-972-***-**** ac5lgg@r.postjobfree.com Senior Application Programmer/Oracle PL/SQL /Data Analysis/Business Analyst Professional Profile

Highly skilled and motivated IT professional with a track record of managing on-time projects that delivers substantial business benefits. Solid business background and innate understanding of how data can improve various aspects of business processes. Exceptional p Core Skills

Requirement Analysis and Design Development, Implementation and Testing Extract, Transform and Load

Relational Database and Data Analysis Innovative solutions Scrum Master on Agile Project

Performance Tuning Cross-Functional Team Interaction Functional/Design Documentation Strengths

Senior Application Programmer with 5+ years of experience in the field of Database and Business Analyst

Experience in Oracle database development/ maintenance including database design, writing PL/SQL scripts, data import/export process, creating batch scripts, analyzing the data

Hands on experience with databases including Oracle, PL/SQL involving stored procedures, triggers, functions, and packages

Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views

Created Tables, Views, Constraints, Index

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables

Worked extensively on Ref Cursor, External Tables and Collections

Proficient in using Explain Plans, oracle hints, creation of new indexes to improve response time of SQL queries

Experience in creating archival/purge scripts to remove old data based on the business data retention policy

Experience in SQL * Loader utility for moving data between external files and Oracle database and vice versa

Experienced in partitioning strategies for very large tables

Performance tuning the database by using SQL plan management, gathering statistics, and using wait events

Worked closely with clients on requirements discussion and provided valuable inputs for business growth

Programming experience in UNIX Shell Scripts and Batch scripts

Experience in Mongo DB

Hands on experience on Python and Angular (Type script)

Played as Scrum Master for critical Agile projects

Gathered knowledge on the data flow and analyzed the volume of data and provided reports to users

Extensive knowledge on testing and hands on experience on Automation test tools

Strong analytical skills with ability to quickly understand client’s business needs

Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills Technical Inventory

Languages: SQL, PL/SQL, Python, Unix Shell Script, Batch Script Database: Oracle 8i, 9i, SQL Server 2000 to 2012, Mongo DB Tools & Utilities: TOAD, SQL Developer, SQL * PLUS, SONAR, JUNIT, HP QC, SOAP UI, IIS Operating Systems: Windows 2000/2008/2012, XP, UNIX Experience

IBM, Dallas, TX Feb '14 - Till Date

Senior Application Programmer

Project: CLARIFY & SR Tracker, AT&T

Clarify is a client-server based application consisting of a Clarify GUI front-end and a Clarify Database back-end server separated by a communications layer. Clarify is used by the AT&T Customer Care Agents (CCAs), who support the post-sales processes of the Business IP (BIP) Services widely used for Provisioning.

KARTHI PALANISAMY

+1-972-***-**** ac5lgg@r.postjobfree.com

Responsibilities:

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data

Played as a Scrum master for critical projects.

Generated PL/SQL scripts for data manipulation and validation and materialized views for remote instances

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to processing layer

Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer

Created indexes on the tables for faster retrieval of the data to enhance database performance

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines

Extensively used bulk collection in PL/SQL objects for improving the performing

Created records, tables, collections (nested tables and associative arrays) for improving Query performance by reducing context switching

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Explain plan analysis on low performing SQL queries and providing recommendations to improve response time

Work with data migration/development/testing teams for successful completion of performance tests

Monitor the system resources during performance testing using OEM/AppDynamics tools and identify the bottlenecks

Automated the functionalities using scripts and automation tool.

Analysis of deadlocks and providing solutions to eliminate deadlocks

Created archival/purge scripts to remove old data based on the business data retention policy

Review of code changes, test procedure, test plans and other deliverables

Data analysis report generation and provide to Clients on the business growth

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD

Debugging the Production issues and provide innovative solutions to Client Environment: Oracle 8i, SQL Server 2000/2008/2012, TOAD, UNIX, Web Logic, Windows 2000/2008/2012 CMA CGM, France Jul '13 – Jan '14

Application Programmer

Project: CMA CGM

The CMA CGM Group is the third-largest cargo shipping company worldwide and number 1 in France. CMA CGM can transport bulk materials, as well as industrial, manufactured or food products, including those needing refrigerated transport solutions from one Line to other. The CARGO shipping from one line to other is monitored by C Voyages application. C Voyages provides the data regarding number of containers, port details, cargo details, ship details and connectivity line. It also provides the capacity details for shipping cargo. Responsibilities:

Developed complex PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic

Generated PL/SQL scripts for data manipulation and validation and materialized views for remote instances

Performance review/signoff of all DB deliverables (Indexes, Stored Procedures, Tables, Etc.,)

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan

Profile DB queries to identify performance bottlenecks

Compare baseline test results with the release test results and come with the recommendations

Prepare coding standards document and PL/SQL performance checklist and distributed to the development team Environment: Oracle 10g

KARTHI PALANISAMY

+1-972-***-**** ac5lgg@r.postjobfree.com

Allied Systems Holdings, GA Jan '13 – Jul '13

Application Programmer

Project: Allied Systems Holdings

Allied Systems Holdings Inc., through its subsidiaries, provides car hauling, transportation, and logistics services for the automotive industry in North America. It transports new and used vehicles, and light trucks to dealers from manufacturing plants, rail ramps, ports, and auctions. The company also provides vehicle rail-car loading and unloading, yard/inventory management, online vehicle tracking, haul away, pickup and delivery of lease return vehicles, and third-party management services, as well as support services for customer, employee, maintenance, and safety operations.

Responsibilities:

Create SQL Server Jobs to schedule nightly jobs to process every day technician work data

Create stored procedures to process data from staging to summary/reporting tables

Involved in the design, coding, deployment and maintenance of the project

Involved in test procedure, test plans and other deliverables

Prepared artifacts like Test Strategy, UAT Release Notes, SCM document etc. Environment: Oracle 8i

Education

Bachelor of Technology – Information Technology (Anna University, Chennai, India) Trainings and Certifications:

• Oracle at IBM India

• Agile training at IBM India

• API Training at IBM India

• Java Trainings at IBM India

• Quality Boot Camp Training at IBM India

• Cloud training

• Scrum training

• Oracle 11g certified professional

• IBM Cloud Application Developer

• Certified Scrum Master

Awards and Recognition:

• Recognized by Client for providing innovative solutions for critical Production issues.

• Received "The Best of IBM" awards for successful delivery of the project

• Received “Manager Choice award” for delivering a complex project

• Recognized by Test Manager for preparing and executing critical test cases on immediate request

Contact this candidate