## BIO
Profile: Senior Systems Analyst - ten years of Analysis and programming experience · Competent in research, design, project organizing, programming and analysing · Ability to work under pressure and manage multiple projects · Excellent leadership, mentoring and customer service skills; strong communication skills IT Experience · In-depth knowledge and experience in relational databases with emphasis on Oracle Applications including Designer and Developer / 2000 toolkit · Functional and technical expertise in Oracle Financials \[9.4, 10.5, 10.7, 11i\] (GL, AP, AR, PO, FA, OE, INV, Service, Alerts) · In-depth knowledge of Oracle; Oracle Forms (4.5, 5.0, 6i); Oracle Reports (2.0, 2.5, 3.0, 6i); Proficient in PL/SQL, PVCS Version Manager, Clarify [7.0, 10.1], Pro*C · Crystal Info & Reports and Oracle Designer (1.6, 2.1, 6i) Skill Matrix Skill Name Skill Level Last Used Experience Oracle Expert Currently Used 9 years Oracle Forms (4.5, 5.0, 6i) Expert Currently Used 7 years Oracle Reports (2.0, 2.5, 3.0, 6i) Expert Currently Used 7 years PL/SQL Expert Currently Used 6 years Oracle Financials (9.4, 10.5, 10.7, 11i) Expert Currently Used 5 years Oracle Designer (1.6, 2.1, 6i) Expert Currently Used 4 years PVCS Tracker & Version Manager Expert Currently Used 2 years Pro*C Intermediate Currently Used 2 years Crystal info & Reports Intermediate 2 years ago 1 years Career History Senior Application Developer Dec 02 – Mar 03 IBM CANADA, Burnay, BC Environment: AIX, Windows 2000, Oracle (8i), Designer 6i, Developer 6i, Oracle Financials 11i [Modules GL, AP, AR, PO, FA, OM, OF, INV] Senior Systems Analyst / Team Lead 1999 – 2002 FUTURE SHOP LTD., Burnay, BC Environment: Sun-Solaris, Windows (NT), Oracle (8i), Designer 6i, Developer 6i, Oracle Financials 10.7 (GUI) [Modules GL, AP, AR, PO, FA], PVCS Version Manager, Tracker · Developed and implemented various customizations of reports / forms for Oracle Financials · GL module: Developed GL interface for journal import of sales revenue, costs of sale from legacy systems and provided valid accounts information; defined and set up key and flex field structures and data validations; defined rules for accounts code combination and consolidations; modified fiscal calendar · PO module: Set up and configured PO sub-ledger; configured vendors, items and terms; developed interfaces for vendors, POs, Receipts and Return interfaces; configured workflow for PO approval process; provided training / guidance to end users · Developed a Labor Scheduling System project using Oracle 8i, forms 6i and reports 6i · Setup ERS (Evaluated Receipt Settlement), EFT (Electronic Funds Transfer), DFI (Discount from Invoices) and Reverse Invoicing for AR and Invoice Matching process · Designed and developed PL/SQL based interface between Oracle Financial and other systems (RMS, Clarify, STAR, SPARC, BBX) · Systems Administration and Support of Oracle Financials (10.7); team leader for a group of three Senior Application Developer 2001 REAL NETWORKS, Seattle, WA Environment: Sun-Solaris, Windows (NT), Oracle (8.0), Developer 6i, Oracle Financials 11i with modules GL, AP, AR, PO, INV, FA, OE, Sales, Service, Incentive compensation · Post - upgrade Customizations and Extensions · Performed customizations of AR Statement, Open Purchase Orders by Buyers report, 1099 Supplier Listing report and Invoice Register report · Analyzed and applied patch to Overdue Vendor Shipment report · Developed and implemented Custom Tables purging program, designed Inventory Transaction interface; analyzed and troubleshot problem with Service form Systems Analyst 1997 - 1999 VANCOUVER INTERNATIONAL AIRPORT AUTHORITY, Richmond, BC Environment: HP-UNIX, Windows (95, NT), Oracle (7.3), Designer 2000, Developer 2000 (Forms 4.5 & 5.0, Reports 2.5 & 3.0), Crystal Info Reports & Cubes, Discoverer, Oracle Financials 10.7 [Modules GL, AP, AR, PO, FA] · Designed, developed and implemented various customization projects for Oracle Financials and Airport Reporting System · Upgraded Oracle Financials from 10.5 character to 10.7 character · Responsible for Systems Administration of Oracle Financials (10.5 & 10.7) System Development Analyst 1997 DMR CONSULTING GROUP INC., Victoria, BC Environment: AIX, Windows NT, Oracle 7.3, Developer 2000 (Forms 4.5, 5.0, Reports 2.5, 3.0) · Important Projects: Integrated Pension Administration System (IPAS) · Conversion of SQL Server Application to Oracle · Service Tracking System for Photo Radar Systems Lecturer / Software Developer / IT Support Manager 1995 - 1997 COMPUTER SCIENCE & ENGINEERING DEPARTMENT, GURU NANAK UNIVERSITY, Punjab, India Environment: DOS (6.22), UNIX, Windows (3.1, 3.11, 95, NT), Novell NetWare (4.0), Oracle (7.1), Developer 2000 (Forms 4.5, Reports 2.5), Visual Basics · Taught post-graduate / under-graduate courses and supervised student projects · Systems administration of LAN and UNIX; installed and maintained PCs / software · Projects: Automation of Pay slip Generation and Electricity Billing / Collection System System Analyst / Programmer 1992-1995 EXEL SOFTWARES LTD., Chandigarh, India · Major Projects - Payroll System, Inventory Control System, Financial Accounting System Education Bachelor of Engineering - Computer Science 1992 KARNATAK UNIVERSITY, Belgaum, India · Credentials evaluated and certified by ICES, Burnaby, BC MBA Program - Currently enrolled with four modules completed 2002 PHOENIX UNIVERSITY, Burnaby, BC
## Area of Expertise
Oracle Application, Oracle forms, Oracle Reports, PL/SQL, Crystal Reports, Pro*C, Systems Analysis, Requirments gathering and Analysis, Testing, Documentation, Feasiablity Study.
