Data Sql
Resume:
KARTHI PALANISAMY
**** ****** ***** **** *, Apt *034, Irving, TX - 75063 +1-972-***-**** ************@*****.*** 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-***-**** ************@*****.***
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-***-**** ************@*****.***
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