JAYESH
Professional Experience:
ServiceLink, PA
(Group of Fidelity National Financial)
Sr. Oracle DBA / Developer Feb 2008 Present
ServiceLink provides a closing process for mortgages. They have mainly two
systems namely CACTIS and VISION. I was involved in HUD (Housing Urban
Development) module and also in CACTIS-VISION integration project. HUD was
responsible for generating the statements for all recording fees and taxes which
needs to be paid by grantee (borrower). I was also involved in CACTIS-VISON
integration, in which biz-talk was main platform as interface.
Responsibilities:
Analyzed the tables structures and their integrity constraints for reports
creation strategies.
Customized the Packages as well as stored procedures to enhance the system.
Perform backup and restoration using RMAN and pointing time recovery using DB
Flashback.
Monitor archive log transfer at the production site and attend to the
production related issues.
Responsible for taking backups (Hot, Cold, Export) and assisted in disaster
recovery. Automate Backup using RMAN and shell scripting and implemented recovery
scenarios on test database.
Involved in Database Administration activities like creating users, granting
privileges, assigning roles to users.
Tune and improve the performance of the Oracle 10g databases using SQL Tuning
Advisor, ADDM, AWR and number of VIEWS.
Migration from 9.2 .0.5 to 10g R2 using Exp/Imp and Manually Upgradation.
Involved in adding of extra fields in VISION as per sending the response to
the CACTIS in order to complete the order.
Made the needful changes in existing stored procedure and functions in context
with implementing the new functional spec of HUD.
Coded packages for Updating, Insertion and for Audit and Trial.
Developed Stored Procedures, Triggers. Developed various applications, using
Oracle built-in packages such as DBMS_SQL, UTL_FILE
Modified existing codes and developed oracle Reports, PL/SQL packages to
perform Certain Specialized functions / enhancement on oracle Application.
Did oracle data loading into oracle database from flat files using SQL Loader
Using SQL trace facility and TKPROF accurately assessed the efficiency of the
SQL statements when application runs. Used the tools with EXPLAIN PLAN.
Involved in CACTIS VISON integration where biz-talk was main interface, used
to get data from biz talk as a XML schema and used to insert data and
extracting data from database using oracle- XML DB registration concept.
Worked closely with Java guys to validate the XML schema and Xml-Java Api.
Involved in Database Administration activities like creating users, granting
privileges, assigning roles to users.
Environment: Oracle database 10g,9i, PL/SQL, Stored procedures and triggers,
UTL_FILE, Redhat Linux, Windows 2000 professional, PL/SQL Developer, VSS, and
SQR
Fidelity Information Services, FL
Sr. Oracle Developer Oct 2007 Feb 2008
Fidelity MaxMilion Claims is a comprehensive service desktop application that
automates and streamlines the administration, preparation, filing, and
reconciliation of Conventional claims. By using work flow-enabled technology,
time lines and costs are reduced, credit risks are minimized and productivity
levels and accuracy are enhanced.
Fidelity MaxMilion Claims performs the following:
Standardizes and automates the claims preparation, filing and reconciliation
process by extracting pertinent data directly from Fidelitys MSP or non-MSP
providers.
Monitors claims to ensure that each claim is complete and filed within a
specified time frame.
Tracks the payment of claim proceeds.
During the Loss Analysis process, assesses what was paid versus what was
requested for final resolution, I am involved in enhancement of form 104SF as per
FHLMC guidelines.
Responsibilities:
Analyzed the tables structures and their integrity constraints for reports
creation strategies.
Customized the Packages as well as stored procedures to enhance the system.
Involved in coding of Hypertext Procedures and Hypertext Functions to create
dynamic HTML pages using mod_pl/sql.
Made the needful changes in a template of form 104SF.
Coded packages for Updating, Insertion and for Audit and Trial.
Developed Stored Procedures, Triggers. Developed various applications, using
Oracle built-in packages such as DBMS_SQL, UTL_FILE
Involved in a migration from 9i to 10g where used convert the code for stored
procedures, triggers, packages manually
Modified existing codes and developed oracle Reports, PL/SQL packages to
perform Certain Specialized functions / enhancement on oracle Application.
Created procedures for modifying existing EDI file as per the changes made in
form 104SF.
Did oracle data loading into oracle database from flat files using SQL Loader
Using SQL trace facility and TKPROF accurately assessed the efficiency of the
SQL statements when application runs. Used the tools with EXPLAIN PLAN.
Environment: Oracle database 9i, 10g, PL/SQL, Stored procedures and triggers,
UTL_FILE, TOAD, windows XP.
Tharaldson Enterprises, CO
Oracle Developer May 2006 Oct 2007
FIRMS, Aztec Technologies, IN
Oracle Developer Sep 2005 Feb 2006
General Electric, Fairfield, CT
Oracle Developer Jan 2005 July 2005
Explanation of Benefits (EOB), Toronto, Canada
Logic software Inc.
Oracle Developer Jan 2004 Dec 2004
Simba Technologies, Vancouver, Canada
Oracle Developer Jun 2003 Dec 2003
Slipstream Data Inc., Waterloo, Canada
Sr. Oracle Developer Jan 2003 - May 2003
Unique InfoTech, IN
Fidelity Finance Limited
Oracle Developer Oct 2001 - Nov 2002
Idea Cellular, IN
Oracle Developer
Jul 2000 Sep
2001
Technical Skills:
Operating Systems : Win2K, UNIX/AIX and MS-DOS, Redhat Linux
Languages : C, C++, VB, Java, SQL, PL/SQL, HTML, XML.
Technologies : JSP, ASP.
Tools/IDEs : Visual Basic, Developer 2000, SQLLDR, TOAD,
Designer2000, Discoverer, Forms6i/9i/10g, Reports 6i/9i/10g
Database : Oracle 7.x/8i/9i/10g, DB2, MS Access.
Education:
Bachelor of Engineering in Information Technology Sardar Patel University,
India
Certification Exam: Oracle 9i SQL
|
