Jayesh Patel

Cell :647-***-****

Email - ad1mef@r.postjobfree.com

SUMMARY

Over 13 years of IT software experience in analysis, design, development, testing and

Implementation of business application, technical support in client/server environment

using Oracle 19c, Oracle 12c, Oracle 11g, Oracle 10g, SQL, PL/SQL, Pro*C.

Strong communication & relationship management skills, ability to perform under

pressure, result oriented, team player, enthusiastic & self-driven, with a high degree of

commitment. Configuring Shell scripts in CRON to perform various routine functions,

Batch Processing with highly complex data model and Bitbucket.

Writing complex SQL Queries, stored procedures, Normalization & Database Design.

Oracle backend development in Production, Development and QA database.

Experience working with RDBMS databases such as Oracle 19c,12c,10g,11g database,

performance tuning and Unix korn shell scripts.

More than 5 years experience Oracle in PL/SQL developing Stored Procedures, Packages,

Functions, Triggers, Indexes, materialized views, SQL *Loader, SQL *Plus and TOAD.

Knowledge on J2EE Platform for developing Web and Distributed Applications by using

JDBC, JSP, and Servlets, Hibernate with MVC architecture.

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

Exception Handling, Ref Cursor, External Tables, and Collections to implement business

logic.

Worked in developing Designed and developed various mappings and mapplets in mapping

designer and sessions and workflows in Workflow manager to extract data and load to

oracle database using Informatica PowerCenter 10.4.

Expert knowledge in dimensional modeling, Star Schema modeling, fact and dimension

table design, physical and logical Data modeling using data modeler 4.1.1, ERWIN 3.x/4.x

Created Materialized Views for enhancement of performance.

Strong communication & relationship management skills, ability to perform under pressure

result oriented, a team player, enthusiastic & self-driven, with a high degree of commitment.

EDUCATION

Master of Computer Application (M.C.A.) Gujarat University, India

B.Sc. (Mathematics) M.S. University, Baroda, India

Certification:

Oracle Certified Associate Java.

Oracle Certified Professional SE Java 11.

TECHNICAL SKILLS

OS Desktop OS - UNIX SCO, SUN Solaris, Windows XP/NT, Linux Red Hat.

Languages Unix Sun solaris, Unix korn shell, HTML 5, PRO*C

Database Oracle 19c,12c, Oracle 11g, 10g/9i, SQL Server.

GUIs/Tools Oracle Developer suite, Forms 10g, Report 10g, Autosys scheduler, ER

studio, Visio, RAD,8.0 WebSphere, DevOps Tools, Jenkins, SQL SERVER

Familiarity REST SOAP APIs, JSON Web services, Maven, Eclipse, HTML, JAVA,

, XML, JavaScript, Hibernate, Hadoop, AWS, Snowflake

PROFESSIONAL EXPERIENCE

Manulife Feb. 2019- Present

Backend Software Engineer/Oracle Developer

Worked on Claim System Transformation GBNow for legacy Claims, Demographics

, Certificate, Enrollment, Eligibility Coverage, Disbursements to migrate, conversion

Integration the Manuconnect and Client II data to Vitech Oracle 19c database to process

adjudicate claims and eBusiness applications, Involved in Snowflakes for large

data and Oracle ERP modules.

The files are copied from the mainframe to HDFS then converted to UTF-8.

Developed SQL queries, PL/SQL packages, stored procedures, and triggers in Oracle

custom development environment, involved in maintaining and updating the procedure for

ETL process, involved in logical and physical modeling using ERWIN data modeler.

Developed and maintained the batch scripts in LINUX shell scripts using VI editor to

automate the daily tasks and batch processing by setting the jobs using crontab at the fixed

hour to eliminate the dependency and load on the database at peak usage.

Working in Bank Submit application, Origination Services using REST WS, send main

App. details to HO systems, it generates App.reference no., App. Id return to Bank

Services, including, HO System invoke pplus package for data retrieval, Status will be

Submitted, Update App. Object to error if app. Ref. no is not generated. error type code

and update Application table.App. Status are Success, Waiting to Approve, Pending

Cancel, NS (not submitted), MR (Manual Review), Application status in table

APPLICATION_DETAILS changed automatically by Schedulers once in a day, if

Current_date - App. Date > 35, scheduler set status Pending Cancel.Call Equifax for EID

Question and Response, Execute Client Business rule.

Working on Jenkins pipeline on release code deployment.

Tata Consultancy Services, Toronto April 2017 - July. 2018

Bank of America Developer

Worked on FIX protocol multi-threaded & real-time trading applications, real-time high-

volume messaging systems for OBO, Sender compid Client profile, Client connectivity

Routing configuration using CICE, CCx rules to different destinations like CC, FAST, EOM,

LD

Queue manager has inbounded, outbound message in NY, tokyo, japan, mexico region.

• FTP the records to the FTP server in the gzip format on the Linux server using putty and

FileZilla.

Involved in writing procedures, functions, triggers, and packages in Oracle 12c for new

requirements, data sets and data analysis.

Environment Linux, SQL, CEA Global Solution, Tango, Slingshot, Ming, Deatls2Prod, T-SQL

Production FIX search, SVN

Veritaaq, Toronto Aug 2016- Mar 2017

Client-Scotiabank Application Developer

The Credit Request module in the Riskorigins product captures the information to facilitate.

Wealth management decision in CDWF and the data element required for scotiabank to

produce a credit application and adjudication reporting. Risk origins are used to automate

banks non-retail credit adjudication process, capture data at source and create the ability to

monitor and aggregate exposure across all products and geographies.

Worked on Credit risk management application for enterprise management system using

Oracle 11g, SQL, PL/SQL JavaScript, apache tomcat application server, BIRT Report.

Worked on analysis, design, SDLC (System Development Life Cycle) development and

implement technical enhancement.

Involved in delivering high performance code using advance concepts like Bulk Collect,

Collections and Partition, Dynamic SQL.

Worked on logical and physical modeling of database using ER studio data modeler.

Involved in Linux korn shell scripts to automate the load processes, process nightly data

feeds and load the data into oracle backend tables.

Environment - Oracle11g, PL/SQL, SQL Navigator, Sun Solaris UNIX.

GPL Inc., Toronto Sept. 2015- June 2016

Appication Developer

Worked Billing and purchasing applications using Oracle, Unix and Oracle ERP.

Experience in developing front end user design with HTML 5, CSS, Bootstrap, JavaScript,

jQuery, XML, DOM, SAX, Server-side NodeJS.

Worked on Web application using Eclipse Framework that leverages Model View Controller

(MVC) design and Java, spring framework, JSON, REST Web services API, Tomcat

application server and AWS Services.

Responsible for developing the technical specifications from business requirements, follow

(SDLC) Software Development Life Cycle.

Developed back-end interfaces using PL/SQL packages, stored procedures and triggers

for Batch processing, database schema design, used ERWIN Data modeler.

Environment - Oracle11g, PL/SQL, SQL Navigator, Hadoop Sun Solaris UNIX, Java,

HTML5, CSS, AWS, Bootstrap, JavaScript.

NTT DATA August. 2013- July 2015

Client-TD Bank, Toronto Application developer

Worked on support of Compliance surveillance project, equities for loading data in the form

of flat files into oracle tables using SQL loader and batch jobs, reports using PL/SQL in

Oracle 11g,12c.

Worked testing scripts, test cases for data quality to resolve the issues, troubleshoot, fix the

defects on HPQC defect tracking systems.

Utilized SQL*Loader to load data from variable length and fixed length flat text files into

tables in database in Unique Customer Identifier System.

Participate in working sessions and status meetings.

Extracting cleansing, aggregating, ensure transforming and validating the data.

Worked on Data emulation to combine several accounts using PL/SQL packages, stored

procedures and triggers, extensively used TOAD to create/modify procedures, tables, views,

triggers.

Worked on Data migration from third party file to tables and ETL (EXTRACT, TRANSPORT,

LOAD) in OLAP database to transfer data from source tables in PL/SQL.

Designed and developed database objects like sequence, index, views and schemas.

Worked on Dimensional Data Modeling, Relational Model using ER studio data modeler.

Environment - Oracle11g, PL/SQL, SQL Navigator and Sun Solaris UNIX, CVS, HPQC.

PARSONS, Toronto June 2012- Mar. 2013

Application developer

E-Safety application and Emission program for the Pennsylvania Department of transportation

(PennDOT) with 8000 private inspection stations and 10,000 test units.

Application used to register the inspected vehicle, stations and sticker issued information.

Worked on report like current mileage by model year, inspection and repair cost, mileage

between inspections, repair by mileage, result by model year, station enrolled by county,

testing summary, program comparison worksheet report for the Pennsylvania drives clean

program.

Worked on Billing application, invoice, payment on forms 10g.

Experience in writing test plans, defined test cases, developed and maintained test script.

Created the PL/SQL Pipelined functions for the report.

Developed back-end interfaces using PL/SQL packages, stored procedures and triggers,

REF cursors in Oracle database, Performance tuning.

Tuning of the SQL to avoid the performance issues using creating indexes, EXPLAIN PLAN,

TKPROF.

Worked on Data migration from third party file to tables and ETL

(EXTRACT, TRANSPORT, LOAD) in OLAP database to transfer data from source tables

into the data warehouse tables in PL/SQL.

Worked on Unix korn shell script for migrating purposes and automated load process.

Worked on developing, deploying Web application on Web Sphere with Java, J2EE in

eclipse, Maven,

Environment - Oracle11g, PL/SQL, SQL Navigator and Sun Solaris UNIX, Tortoise SVN,

JIRA, AWS,Snowflake

PROCOM, Toronto Feb. 2011 –April 2012

Bank of Montreal (BMO) Application Software developer

Retail Information System (RIS) is marketing and sales tool for BMO Nesbitt burns to

organize, manage and store wide range of information about each of BMO client and them

respective holding.

All investment advisor to manage clients and their entire portfolio permit online trading and

processing of equities, mutual funds and fixed income securities.

Produce reports that can used to track activity, inform clients, official and unofficial of

securities, portfolio, performance, Realized Gain/Loss report.

Managed various production support modules, incident, Problem and change management.

Worked on Unix korn shell script to format files, data extract and run the batch report.

Developed batch programs, data manipulation in Pro*C and wrote scripts to run them on Unix Cron Scheduler.

Worked on GUI interfaces on forms 10g, report 10g on Web sphere server in the modules.

Developed Triggers for enforcing constraints by which business users have limited access

in modifying data in the tables.

Environment - Oracle10g, PL/SQL, Forms 10g, Reports 10g, Pro*C, Sql Plus, TOAD,

Remedy, Visio, CVS, Windows XP, Web sphere, Unix

AET Solutions

Client- Cognizant Technology Solutions (CTS), IL

Oracle Developer Mar. 10 - Oct. 10

Worked on 90-Day Prescription at Retail system to register the drug insurance plan for

the patients for the Rx prescriptions at Walgreens.

Involved in batch processing, error handling, PL/SQL blocks and SQL data manipulation

using Pro*C, Sqlca, and PL/SQL.

Involved in the Design, Analysis, Development, Testing and Implementation of the system.

Developed Triggers for enforcing constraints by which business users have limited access

in modifying data in the tables.

Expertise in UNIX shell scripting using K-shell for the automation of processes and

scheduling the jobs and used VI editor.

Account Receivable System May 09 – Dec. 09

Worked in application support for Pharmaceutical company and eBusiness solution:

General Ledger, Accounts Payable, Accounts Receivable, Cash

Management, Fixed Assets, Procurement, Contracts, Order Management,

Inventory, Mobile Supply Chain, Warehouse Management.

Responsible for developing the technical specifications from business requirements.

Developed back-end interfaces using PL/SQL packages, stored procedures, and triggers.

Created Database objects like materialized views, views, tables, indexes in process of

developing new customizations.

Developed Unix shell scripting to automate the load processes, process nightly data

feeds and load the data into oracle backend tables also responsible for unit testing and

documentation of the interface.

Involved in programming, debugging, and performing unit testing and system testing

of modules developed and responsible for deploying in to Prod environment

Worked on Defect Analysis and bug fixes, complex enhancement requests and provided

support to the users.

Environment - PL/SQL, Pro*C, SQL, SQL*Loader, Oracle 8i, HP-UNIX, Java.

Client- South Florida Water Management District, FL

Oracle Developer Feb. 08-Mar. 09

Worked on WEEDDAR (Weed Data and Report) system which include daily activity

, treatment performed by contractors and work order entered into the system.

Vegetation, Herbicide/Chemical treatment, vehicles hours information of work order

entered into the system.

Worked on report like summary report, asset report, and Dep report (treated acreage,

chemical used), plant treated report detail by contractor, performance report, organization

summary report, org. asset location.

Worked on GUI interfaces on Oracle 11g,forms 11g,Reports 11g,Oracle Fusion

middleware 11g, Apache tomcat application server.

AUTOSYS job scheduling- created the JIL scripts and UNIX shell scripts, using CRONTAB to

automate the jobs scheduling.

Worked on Data analysis, erwin for creating the ERD and tables, procedures and triggers.

Worked on DBHYDRO is the South Florida Water Management District’s corporate

environmental database which stores hydrologic, meteorologic, hydrogeologic and water

quality data. This database is the source of historical and up-to-date environmental data for

the 16-county region covered by the district.

The DBHYDRO Browser allows you to search DBHYDRO using one or more criteria and to

Generate a summary of the data from the available period of record. You can then select

data sets of interest and have the time series data dynamically displayed on your screen in

tables.

Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to

implement the business logic and error handling using exceptions.

Environment - Oracle10g, SQL PLUS, PL/SQL, Forms 10g, Reports 10g, Oracle designer,

VI Editor, Sun Solaris UNIX, TOAD, Windows XP

Client- Nike, OR

PL/SQL Developer Aug. 07- Dec. 07

Work with Business Analysts in requirement gathering.

Design and developed data validation, load processes using PL/SQL, Stored procedures,

functions and triggers using Oracle 9i.

Worked on Autosys scheduling system job using COACH AutoSys for Datamart ETL

environment.

Worked in unix korn shell scrpting to test and migrate PL/SQL and wrote Scripts to run.

them on Unix Cron Scheduler.

Involved in logical and physical modeling of database using ERWIN data modeler.

Done Performance tuning of the SQL using creating indexes, EXPLAIN PLAN, TKPROF.

Environment - Oracle 9i, PL/SQL, ERWIN, TOAD, Oracle Designer, SQL PLUS, Pro*C,

Windows XP, LINUX, Unix HP 11

Client- LPL Financials, San digeo, CA Jan. 07-July 07

Oracle Developer

Worked on Commission system of the Project burgundy, fixed income, developed.

Modules like Commission, Registration, Product, Advisory, Compliance, mutual fund,

marketing, Branch development, job control to create, identifiy data and reports for

Corresponding broker dealer AXA and LPL.

Worked on libraries pll, olb and Deployed forms on the web using Oracle application

server 10gAS.

Worked in fixed income, securities, Order Management and Trading system.

Extensively involved in writing and managing PL/SQL stored procedures, functions,

triggers and packages to meet business requirements and updated the existing objects

based on change requests, developed database triggers for audit and validation purpose.

Worked on Unix korn shell script to format files, data extract and run the process.

Involved in the logical and physical database design and developed the logical dimensional

models using Erwin 4.0.

Worked on the reports for job control modules and scheduled jobs.

Done Performance tuning of the SQL using EXPLAIN PLAN, TKPROF in 1 Terabyte size.

Involved in processing of data and reports using Pro*C, error handling, PL/SQL blocks and

SQL data manipulation.

Environment - Oracle10g, PL/SQL, Forms 6i, Reports 6i, Pro*C, Sql plus, Linux

SQL Navigator 4.5, Windows XP

AIZ CONSULTING, VIRGINIA Developer Jan’ 06 – Dec. '06

Client- Virigina Dept. of Health (VDH)

Worked on WICNET (Womens, Infants and Children) application to register family, clients,

Vendors and issuing checks.

The application has modules like Vendor Management, Certification and enrollment, Food

Instruments, Appointment scheduler, Nution eligibility, financial management.

Involved in gathering requirements and preparing technical documentation.

Wrote and managed PL/SQL stored procedures, functions, triggers and packages to

meet the business requirements

Worked in design and developing various reports using Oracle reports 6i, interfaces on

forms 6i and created libraries for standard functions applied across all forms.

Prepared test plans and conducted unit and module testing.

Involved in logical and physical modeling of database using ERWIN data modeler.

Tested and debugged the application for accuracy and optimum performance and worked

closely with users to ensure accuracy of the results.

Generated custom oracle reports according to user group’s requirement.

Worked on Retail store management system (RSMS) for the corporate and retail stores by

state, district and sitewise and create prices and food items and reports like store details,

new applications.

Involved in Writing UNIX Shell Scripts to run batch control jobs in OLTP.

The system was developed using web toolkit, HTML, JAVASCRIPTS and Pro*C, PL/SQL.

Used packages like UTL_FILE for read and write to operating system files, delete or rename

a file.

Environment - Oracle 8i, 9i, PL/SQL, Developer 2000, Forms 10 g, Reports 10 g, TOAD, UNIX shell script, Windows XP.

Contact this candidate