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