Resume

Sign in

Oracle Developer Analyst

Location:
Toronto, ON, Canada
Posted:
October 20, 2022

Contact this candidate

Resume:

HAMID GIVETASH, M.SC.

**A Emmett Ave. Apt #****

Toronto, Ontario, Canada

M6M 2E5

416-***-**** ads30t@r.postjobfree.com

October 20, 2022

Contact:

Re:

Dear Sir,

I am very interested in the position of Sr. Oracle Developer. I believe that my background and experience make me a strong candidate for the role.

My key qualifications include:

8 years of experience with UniVerse/Pick Basic from 1987 to 1995 and from 2019 to 2022.

22 years of experience in Oracle environments, which included Oracle 11g, Developer 2000 tools (Forms v.6i, Reports v.3.0), SQL, SQL*Plus, PL/SQL, SQL*Loader and Tuning.

Advanced experience programming using PL/SQL, Oracle 10g, 11g and in-depth knowledge of System Development Life Cycle, product development methodologies and database methodologies.

6 years of experience with Unix Shell Script Bourne/Ksh to process backend jobs for ADP at BMO.

3 years of experience with Pro*C.

4 years of experience with Forms and Reports (Developer 2000).

Experience in using versioning tools, TOAD, SQL Developer and to code stored procedures, views, functions and scripts.

Demonstrated ability to deliver programs based on accepted standards, free of bugs and according to user requirements.

Full understanding of application systems through creation and enhancement of various new and existing programs.

Ability to deal with a broad spectrum of personality types.

Good problem-solving skills and knowledge of database design, development and file management techniques.

Experience with Java, HTML and XML.

My salary expectation is flexible.

I am Canadian citizen and used to work in USA by getting TN Visa.

I would appreciate the opportunity to discuss details in a personal interview at your convenience.

Yours truly,

Hamid Givetash

Cell phone: 416-***-****

E-mail: ads30t@r.postjobfree.com

HAMID GIVETASH, M.SC. 2/5

PROFILE

A senior UniVerse and Oracle Developer/Analyst with extensive experience in providing data analysis and functional requirements modeling to various organizations in a number of full-time employee and consulting roles. Developed expertise at identifying and documenting all aspects of business requirements and translating them into system requirements. A track record of success in assigning project objectives according to approved project plans and collaborating with other disciplines within IT departments.

TECHNICAL SKILLS

ENVIRONMENT:

Oracle

SQL

PL/SQL

Developer 2000 v.6 (Forms & Reports)

Pro*C

C

Oracle Database Design

Unix Shell Scripts

Unix

Java, XML, HTML

Pick Basic

Window

TOAD

Visual Source Safe, CVS, PVCS

DATABASE:

Rocket Software UniVerse

Oracle 7.3 to Oracle 11g

CONSULTING EXPERIENCE

Lawyers' Professional Indemnity Company (LAWPRO). (TORONTO, ONTARIO, CANADA) 04/2021 – 09/2022

Sr. Programmer/Analyst

UniVerse/Pick Developer

In this consulting role I provided support in documents the tables and write uploading programs to generate flat files for loading files in Sql Server (OMS Company).

I Analyzed the programs in order to define the logic and definition of fields on tables.

I designed, developed, uploading programs

EOS CANADA INC. (TORONTO, ONTARIO, CANADA) 03/2019 – 02/2020

Sr. Programmer/Analyst

UniVerse/Pick Developer Excel-Macro Developer

In this consulting role I provided support in enhancing Debtor information and Total collected amount

by creating new files/tables and programs (Pick) and Excel-Macro.

I designed, developed, modified and tested Excel-Macro for downloading flat files from Rocket Software UniVerse to Microsoft Excel workbook documents.

I designed, developed, modified and tested new UniVerse/Pick Basic programs to process Debtor information and calculate Total collected amount per week and per month.

HAMID GIVETASH, M.SC. 3/5

MATRIX (WELLS FARGO USA, MINNEAPOLIS, MINNESOTA, USA) 09/2016 – 05/2017

Sr. Oracle Developer/Analyst

In this consulting role I provided support in enhancing Incentive Compensation Application Suite delivering complex solutions where accuracy is imperative by modifying and Developing Oracle PL/SQL packages, creating tables and indexes. I also developed Unit Test procedures.

I designed, developed, modified and tested procedures to process Incentive Compensation. I created new tables including PL/SQL, Procedures, Views and Materialized View using Agile methodology.

I modified the Target Loading package in order to make the total loading time less than one hour using SQL coding and tuning.

TCS (BANK OF MONTREAL, TORONTO, ONTARIO, CANADA) 10/2015 – 04/2016

Sr. Oracle Developer/Analyst

In this consulting role provided support in enhancing new Rule for Data Quality for Asset Management (Basel III) by modifying and Developing IBM InfoSphere Information Analyzer for the IBM DB2 database

I designed and developed new scripts for the Asset Management system, including PL/SQL, View, tuning, Shell script to download data to main database. Using Agile methodology.

I created data rules in Infosphare Information Analyzer. Using database views or virtual tables pushed record filtering to database.

S2TECH (XEROX CO USA, JACKSON, MISSISSIPPI, USA) 02/2015 – 08/2015

Sr. Oracle Developer/Analyst

In this consulting role provided support in enhancing Medicaid Eligibility Determination Systems by modifying and Developing Oracle PL/SQL packages, creating tables, indexes and Unit test.

I designed and developed a new PL/SQL package to process Whole Beneficiary Changes at the end of each year, including PL/SQL, tuning and Unit testing.

I defined and developed the requirements for complex enhancements involving multiple Functions/Procedures for changes to Medicaid Eligibility Determination Systems, including PL/SQL, XML types and tuning using Agile methodology.

Participated in internal training course for Oracle Data Integrity (ODI / ETL).

EXPRESS SCRIPTS CANADA (TORONTO, ONTARIO, CANADA) 11/2013 – 09/2014

Unix, Pro*C and Oracle Developer/Analyst

In this consulting role provided support in enhancing NIHB Adjudication System (in house development) by modifying Pro*C programs or Oracle Packages. I developed test case documents and release documents for each release in line with technical solutions defined Business Analysts.

I analyzed and designed new prices for dental procedures. I developed four independent systems to update price table based on old prices and new criteria. I defined testing data, and deployed documents for User Acceptance Testing. Using Agile methodology, Shell Script and PL/SQL.

I analyzed and modified the Adjudication System to accept decimal number for patient drug consumption, creating Pro*C code, Test Case and Design Documents.

I analyzed and modified the Adjudication System to evaluate new roles for denture payment procedures, creating Pro*C code, Test Case and Design Documents.

HAMID GIVETASH, M.SC. 4/5

I analyzed and modified the Adjudication System to evaluate new roles for Medical Supplies Equipments payment procedure, creating Pro*C code, Test Case and Design Documents.

I defined missing teeth for Patients based on archive information and updated all current related tables, creating PL/SQL package.

SOFTCHOICE COMPUTER CO (TORONTO, ONTARIO, CANADA) 04/2013 – 08/2013

Oracle Developer/Analyst

I enhanced the Purchase Order Process (in-house development) by designing and developing a referral booking package which provided for an online referral purchase order creation. This package utilized PL/SQL, XMLdom, XMLparser and XMLprocessor using Agile methodology.

BANK OF MONTREAL (TORONTO, ONTARIO, CANADA) 07/2007 – 04/2013

Unix & Oracle Developer/Analyst

Developed error free code that complied with coding standards and methodologies. Developed unit test plans and functional test cases and executed test scripts. Worked with release team to implement codes and provide post-implementation support and with Business Analyst and Users to ensure requirements were captured correctly. Using Agile methodology

As member of the Retail System team played an active role modifying the Broadridge Booking Records programs. Developed or modified National Survey, Tax Report and various ad hoc reports to collect data and transfer them to data warehouse or different servers “ETL” (Unix Shell Script, PL/SQL, Triggers, Pro*C). Used Toad for performance tuning SQL and SFTP for transferring files.

Developed code for the Margin Equity project which modified the Margin Rate and had a significant impact on Credit Risk Management. (Unix Shell Script, PL/SQL, Test Case, Data Modeling, Design Documents, Database Tables, Triggers, and Indexes).

Developed code for a new Margin System required for the PCG PO Credit Risk Department margin (Unix Shell Script, PL/SQL, Test Case, Design Documents, Data Modeling, Database Tables and Indexed, Oracle Forms). The new system provided an online margin report that included but was not limited to guarantor/guarantee relationships and eliminated the need to manually calculate the required margin amount (Unix Shell Script, PL/SQL, Test Case, Data Modeling, Design Documents, Tables, Triggers, sql*loader Constraints and Indexes and ETL).

Created detailed test cases and participated in system design data Modeling specification based on ability to read and comprehend business requirements and high level design deliverables.

CNC GLOBAL (BBM, TORONTO, ONTARIO, CANADA) 10/2006 – 07/2007

Oracle Developer/Analyst

Contributed to the requirements gathering and the analysis steps of the software development lifecycle of projects. Analyzed, designed and created high-level functional and low-level technical specifications of the design solution. Modifying and documenting an Extract, Transformation and Load (in-house development utilized PL/SQL); Developed new reports (Forms, Reports); Spearheaded the migration of the MySQL database to Oracle 9i (Data clean up, mapping and extraction programs).

TEK SYSTEMS (MONTANA ENVIRONMENT, HELENA, MONTANA, USA) 02/2004 – 10/2006

Sr. Oracle Developer/Analyst

Member of the Enterprise Permitting and Compliance System for the Department of Environmental Quality. Consulted with users to gathered information about program needs, objectives, functions, features and input and output requirements. Extracted and integrated data from multiple data sources (Oracle & Access. Data modeling ) to a new Oracle database (Pl/SQL, Forms, Reports and Database Tables, tuning, Triggers and Indexes).

HAMID GIVETASH, M.SC. 5/5

PERFORMANCE RETAIL INC. (TEXAS, USA) 03/2003 – 05/2003

Oracle Developer/Analyst

Completed Retek Software Change Requests (SCR) for the convenience store industry (e.g. Hess and British Petroleum). Modified and developed new packages (PL/SQL), forms and database Tables.

GAP INC. (CALIFORNIA, USA) 10/2002 – 12-2002

Oracle Developer/Analyst

Determined the mapping of Label and Ticket logic from Legacy System to Retek package. Defined Business Process, Ranking Interface in terms of priority, Conversion process (both manual and automated), Data Cleansing, and Transformation and Validation Report. Defined the instructions for how to create a program or script for conversion, which includes the unit test and, execution.

ACTIVE INTELLIGENCE INC. (MINNNESOTA, USA) 03/2000 – 04/2002

Unix, Pro*C and Oracle Developer/Analyst

As member of the Retek Customer Care team assisted in resolving client technical issues for all modules (Forms, Reports, PL/SQL, Pro*C). Analyzed and tuned RMS base development code for all modules, including Modification to Packages, Functions, Forms, Reports & Pro*C; Contributed in the planning, designing and development of a Data Generator, a tool used to Automatically generate any number of rows of data for any specific Retek tables (Unix Shell Script (ETL), Forms, Data Modeling & Triggers).

AJILON (XEROX CORP. USA, NK) & KEANE (NORTEL, TORONTO) 06/1996 – 12/1999

Oracle Programmer Analyst

Developed Oracle database, Data Modeling and PL/SQL Packages; Analyzed and Developed solution for client request forms; Converted System for year 2000; Developed new forms and reports (Developer 2000)

PRIOR EXPERIENCE

ACCOUNTING/MANUFACTURING/ADVERTISING/MINING COMPANIES 1987 - 1995

Programmer/Analyst Toronto, Ontario, Canada – Pick Basic

Provided programming and business analysis services and worked on various projects in different areas including Customer Sale Order, A/R, A/P, General Ledger, Material Management, and Processing systems. (InfoBasic, Pick Basic)

EDUCATION

GEORGIA INSTITUTE OF TECHNOLOGY, ATLANTA, GEORGIA, USA

Master of Science in Operations Research

NATIONAL UNIVERSITY OF IRAN, TEHRAN, IRAN

Bachelor of Science in Economics

BMO: HP Quality Center v10, Oracle Database 11g: SQL and PL/SQL New Features

ADVANTECH

HTML, Flash, DreamWeaver, Firework

Retek: Processing (Pro*C), Retek Advance Training, Retek Batch

XEROX

Object Oriented Analysis and Design Using C++, Capability Maturity Model for Software (CMM)

UNIVERSITY OF TORONTO (DEEDS PROJECTS)

ORACLE, SQL, SQL*Plus, PL/SQL, Pro*C, Developer 2000 tools(Forms v.4.5. Reports v.2.5)

HUMBER COLLEGE

C Programming, UNIX, Data Communications, Java Programming, Java Applets



Contact this candidate