Oracle Developer Analyst
Resume:
HAMID GIVETASH, M.SC.
Toronto, Ontario, Canada
M6M 2E5
416-***-**** *********@*******.***
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: *********@*******.***
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