Jayachandran Pitchamani

Email Id : adc1b9@r.postjobfree.com

Mobile : 470-***-****

SUMMARY

Experienced IT professional with abundant experience in Oracle database products, Oracle PL/SQL, Unix Shell Scripting,Proc*C, administration, and ETL operations .

Over 13 years of IT Experience of large teams and extensive industry experience as Oracle PL/SQL, Developer/DBA and Unix Shell Scripting, DB programming, administration, production support/Technical support and data warehousing using Oracle, Oracle Golden Gate, PL/SQL Pro C, and Shell scripting.

Worked with Data Modeling tools like ERWIN, Oracle development tools like PL/SQL Developer and TOAD. Scripting Language like Unix Shell Scripting.

Proficient in performance tuning using through execution plan, Hints, Bulk Binding, Pipelined Functions, Partitions, index etc.

Having experience of UNIX Shell programming using KSH, AWK.

Expertise System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, Development environments.

Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.

Significant experience in Oracle Db administration

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

Over five years of experience in ETL process, Extraction, transformation and loading in data warehousing environment.

Significant Hands on experience in Oracle ETL suite Golden Gate to enforce integrity, Transformation and for ETL jobs.

Extensive experience in Analysis and Design of Database, Data Migration, Performance Tuning and Shell Scripting

Having Experience in using Sqoop,HIVE and MySql for extract data and store it in Hadoop.

Possess diverse experience in different domains such as Telecom, Manufacturing, Automotive, Insurance and Banking domains, Extensive experience in creating complex reports using PL/SQL.

Green Belt Certified for Completing the Six Sigma Project and Presented with new Automation ideas and advanced topics like Elastic Search.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Strong interpersonal and communication skills in dealing with customers and teams.

TECHNICAL SKILLS

DATABASES : Oracle 12c, Oracle 11g,Oracle 10g,Oracle 9i, Oracle 8i,Mysql

OPERATING SYSTEM : Unix, Linux, Windows

ETL TOOLS : Oracle Golden Gate -11.2

DATA MODELLING TOOL : Erwin

SCRIPTING LANGUAGES : Unix Shell Scripting

PROGRAMMING LANGUAGES : C, Pro*C,Sql,PL/SQL,Python

TOOLS : Toad, Oracle SQL Developer, SQL loader,

BIG DATA TOOLS : Hive,Pig,Sqoop,Flume

SCHEDULING TOOLS : Autosys, TWS

PROFESSIONAL EXPERIENCE

PROJECT NAME: PFDS & CWIS Application Dec 2018 – Till Date

Client: Department of Human Services-DHS (City of Philadelphia)

Role: Sr Oracle Developer and Production Support Analyst

Responsibilities:

Design and Develop for procedures using the PL/SQL Procedures/functions for frequent issues.

Running the PL/SQL extract process to pull the data from Database and share to Dataware house Team for Cognos Report.

Monthly Jobs using PL/SQL procedure and extract the data from Mainframe and move the files to SharePoint for Finance Team.

Involved in project planning and providing work estimates.

To understand requirement, identify database changes and create/modify database objects as per requirement.

Create /Modify Data Model as per requirement using ERWIN.

Involved in data migration project. understand old data model and application and migrating data into new application, which involve creating new objects in oracle like table, views, stored procedures, function etc. .

Involved in SIT and UAT and fixing the bugs.

Responsible for best practice and data quality.

Performance tuning of DB objects using execution plan, various hint, temporary tables etc.

Responsible for L3 production support for supporting more than 20 applications.

To prepare database deployment scripts and providing support during deployment.

Tools: Sql Developer,Toad,Erwin

Environment : Oracle 12c,Oracle 11g,Windows

Project Technologies: PL/SQL, Unix Shell Scripting,Cognos,

PROJECT NAME: RTB Support Apr 2018 – Nov 2018

Client: PNC (Pittsburgh-Pennsylvania)

Role: Development and Support

Responsibilities:

Design and Develop the automate process to send Proactive alerts to the RTB Support Team for Long Running Queries/Tablespace Alerts/Blocked Session using the PL/SQL Procedures/functions.

To create/Modify Oracle procedure, Function, Packages. Refcursors, Views etc.

Used BULK_BINDING,Hints, INDEXs etc. for performance improvement.

Design and Develop the Application Health Check Monitoring for RTB Applications .

Worked on the SQL Query tuning and Performance Monitoring of the RTB Application and provide the recommendations to the RTB Support Team.

Working with DBA for Production Issue to Resolve the Issues.

Developed Top 20 SQL Queries for Proactive Monitoring the Database and shared with Support Teams.

Tools:Toad

Environment : Oracle 12c,Oracle 11g,Windows

Project Technologies: PL/SQL, Unix Shell Scripting

PROJECT NAME: HCA Application Nov 2017 – Mar 2018

Client: PNC (Pittsburgh-Pennsylvania)

Role: Development and Support

Responsibilities:

Design and Develop the automate process to gather statistics for Tables/Index/Partitions using the PL/SQL Procedures/functions.

Using PL/SQL procedure created batch jobs for daily/weekly and monthly processing.

Importing and exporting data through SQL loader and Catalog Data analysis

Include best programming practices to avoid future performance issues.

Worked on the SQL Query tuning and Performance Monitoring of the HCA queries which is time consuming and blocking the daily uploads of the incoming and outgoing files.

Working with DBA for Production Issue to Resolve the Issues.

Tools: Toad

Environment : Oracle 12c,Oracle 11g,Windows

Project Technologies: PL/SQL, Unix Shell Scripting

PROJECT NAME: Retail Commander Application Jun 2015 – Oct 2017

Client: AT & T (Alpharetta- Georgia)

Role: ADBA (Application DBA) and Technical Support

Responsibilities:

Design and Develop in writing and tuning Unix Shell scripts including Oracle tables, views, indexes, and complex PL/SQL objects including: procedures, packages functions, triggers, and also Connect Direct to transfer files between two networked systems.

During Database Migration need to replicate the data from Source to Target Server so created Extract/Replicate/Pump Process using Oracle Golden Gate and Data Replicated. Responsible for DB administration

Responsible for Developing the new PL/SQL Procedures/functions to convert Time zone Conversion to EST in all DB's.

Automation for Monitoring Script Using Shell Script for the Table space and Checking the Object Valid or not in Production table and will give an alert/warning to all users.

Setup Complete End to End Setup for ETL process in Production using

Oracle Golden Gate.

Resolve extract/replication issues in Oracle Golden gate during day to day and Migration, ETL process.

Tools: TOAD, ERWIN, UNIX, Golden Gate

Environment : Oracle 11g,Windows

Project Technologies: UNIX Shell Scripting, Connect Direct,PL/SQL, Golden Gate

PROJECT NAME: P2E-Group Implementation for Database Mar 2015 – Jun 2015 Date

Client: Delta Dental of California (SFO-CA)

Role: PL/SQL Lead

Responsibilities:

Responsible for Developing the new PL/SQL Procedures and Database objects for the Business Functional Specifications.

Responsible for testing the packages and modify the existing procedures based on the Business specifications.

Working on Transfer Automation tool to move the data to Production to Test environment for User Testing and Staging to Production.

Need to replicate the data from Source to Target Server so created Extract/Replicate/Pump Process using Oracle Golden Gate and Data Replicated to Downstream Application

Tools: TOAD, GOLDEN GATE

Environment : Oracle 11g,Windows

Project Technologies: UNIX Shell Scripting, PL/SQL

PROJECT NAME: TE Connectivity DWH (TED) Jun 2012 – Feb 2015

Client: TE Connectivity (Harrisburg- Pennsylvania)

Role: Sr. PL/SQL Lead

Responsibilities:

Worked on Development Area in UNIX Shell Scripting and PL/SQL Programming for the Application Development.

Responsible for Implementing Change Request and providing production fixes for the TED application

Responsible for loading the data from different source system into TED database using scripts and oracle procedures

Tools: PL/SQL DEVELOPER, UNIX, UNIX Shell Scripting

Environment : Oracle 11g,Windows

Project Technologies: UNIX Shell Scripting, PL/SQL

PROJECT NAME: Hyperion Planning & OBIEE Services Nov 2011 – Apr 2012

Client: INDORAMA VENTURES LIMITED (Bangkok- Thailand)

Role: Developer

Responsibilities:

Worked on Development Area in UNIX Shell Scripting and PL/SQL Programming for the Application Development.

Worked with External Team in Integration with OBIEE Reporting and testing the Reports.

Involved in the ETL process and generated reports using PL/SQL and OBIEE

Tools: PL/SQL DEVELOPER, UNIX, Shell Scripting,

Environment : Oracle 11g,Windows

Project Technologies: UNIX Shell Scripting, PL/SQL

PROJECT NAME: TER, TRECS, UPCS May 2007 – Sep 2011

Client: FORD MOTOR COMPANY (Chennai - India)

Role: Sr. PL/SQL developer

Responsibilities:

Worked as a Senior Developer for the Design and Development Coding Using Unix Shell Scripting, PL/SQL (Procedure, Functions, Package, and Cursors).

Testing - Unit testing & Integration testing responsible for overseeing the Quality procedures related to the project

Responsible for overseeing the Quality procedures related to the project Implementation

Tools: PL/SQL Developer, FTSI Ticketing tool,

Environment : Oracle 11g,Windows

Project Technologies: Unix, Oracle,Autosys,PL/SQL

PROJECT NAME: Online Credit Facility to EEFC and to NRI Jun 2003 – Mar 2007

Client: CITIBANK (Chennai - India)

Role: Software Consultant

Responsibilities:

oDesign and Development Coding Using C,Pro*C,Unix,Sql,PL-Sql

oWriting Stored Procedures,Functions,Packages,Cursors,Triggers and Queries

oTesting - Unit testing & Integration testing

Tools: PL/SQL Developer, Autosys

Environment : Oracle 11g,Windows

Project Technologies: Unix, Oracle, Shell Scripting, PRO*C

PROJECT NAME: Automation for MVDSC

Dec 2002 – May 2003

Client: Cyber Korp(India) Private Ltd

Role: Software Engineer

Responsibilities:

Design and Development coding Using PL/SQL and Shell Scripting

Writing Stored Procedures,Functions,Packages,Cursors,Triggers and Queries

Testing - Unit testing & Integration testing

Tools: PL/SQL Developer

Environment : Oracle,Windows

Project Technologies: UNIX, Oracle, Autosys

EDUCATION:

Title of the Degree

Name of the Degree

College/University

MASTER DEGREE

MCA (Master of Computer Application)

University of Madras

MASTER DEGREE

MBA

Bharathiar University

BACHELOR DEGREE

B.Sc (Bachelor of Science) Mathematics

University of Madras

Contact this candidate