Edouard Koucherian
adzphc@r.postjobfree.com
Cell: 323-***-****
EDUCATION
Polytechnic Institute of Yerevan, Armenia
Master in Technical Systems Engineering/Computer Programming
Certificates
Salesforce Advanced Administrator Certificate
Salesforce Administrator Certificate
Salesforce Platform App Builder Certificate
Salesforce Platform Developer I Certificate
Salesforce Platform Developer II Certificate
Salesforce JavaScript Developer I Certificate
ITIL 4 Foundation (by Capgemini)
SOFTWARE EXPERIENCE
Databases: Oracle, Sybase (ASE), MS SQL
Languages: PowerBuilder 2017R, SQL, T-SQL, PL/SQL, APEX, JavaScript, VisualForce
Case Tools: Rational® ClearQuest® and Rational® ClearCase®, SoupUI 5, BitBucket, GIT Bush, Splunk, Jenkins, HP Service Manager, JIRA
PROFESSIONAL EXPERIENCE
Computer Consultant Dec 2019 – Present
Capgemini America Inc
In the group of Application Production Support team working on MUFG projects:
Salesforce UBIS/Skience, FSC for Commercial and Retail banking
Salesforce GCRM, the Global Customer Relationship Management (GCRM) system
Salesforce SFR, includes - Salesforce Commercial, Service Cloud, Commercial Loan Origination (CLOS) and Wealth
Managed and participating in development and modification of Enterprise Solutions for Bankers (ESB), which is a comprehensive relationship management system (CRM), including KYC, CIP/CDD. ESB interacts with MUFG Union Bank’s other applications to provide customers with integrated contact management tool
APEX, VisualForce, Javascript, Flow, Powerbuilder 2017 R3, ORACLE 11gi, PL/SQL, JBOSS 7.2
Sr. Software Engineer, AVP Aug. 2016 – Dec 2019
MUFG Union Bank, N.A.
Specific projects included:
Salesforce CRM, Salesforce FSC for Commercial and Retail banking
Created batch Apex Classes including Custom Metadata Types and Records to initiate processes/jobs, considering platform limits, to retrieve and export customer accounts and annual reviews
Created Apex Classes and Apex Triggers to maintain data integrity, tuning SOQL, SOSL queries with consideration to Governor Limits to implement various functionalities required by the application
Created global action and relevant layouts to emphasize special deals in Log a Call activities and to create tasks based on that processes
Implemented Visualforce Pages, Complex Workflow rules, Flows, Process builder, Validation rules for business process automation
Created Custom report types in order to include required custom objects with complex relationships to build reports & Dashboards based on those reports
Created and managed Campaigns using data loader, created validation rules, duplicate rules, matching rules for data import to maintain data integrity
Managed and participated in development and modification of Enterprise Solutions for Bankers (ESB), which is a comprehensive relationship management system (CRM), including KYC, CIP/CDD. ESB interacts with MUFG Union Bank’s other applications to provide customers with integrated contact management tool
APEX, VisualForce, Powerbuilder 2017 R3, ORACLE 11gi, PL/SQL, JBOSS 7.2
Computer Consultant May 2008 – Aug. 2016
Clients: Pinnacle Group, UNISYS
Specific projects included:
Developed and modified of a LEADER application (Los Angeles Eligibility Automated Determination Evaluation Reporting System), using UNISYS-2200 and RDMS database.
Projects includes: CalHEERS (California Healthcare Eligibility, Enrollment and Retention System), Threshold Language Notices of Action (NOA), Medi-Cal Deemed Eligibility (DE), Refugee Employment Program (REP) using PowerBuilder and MF COBOL
POWERBUILDER 12.5, MF COBOL, (Sybase) ASE/12.5.1, ORACLE 9i, PL/SQL, MS
SQL/2008
Computer Consultant: Feb. 2002 – Apr. 2008
Clients: (LACBAR, Technicolor, LA DWP, All American Prod Co., MAYO Clinic, LightBridge Inc., Hawthorne Savings, F.S.B)
Specific projects included:
Developed and enhanced Respiratory Care Business Components and REBA (Remote Exchange of Billing Activities).
The Reba queue billing interface design is intended to simplify the interaction between source user systems using H7 protocol.
Client PB 7.3 and Sybase ASE/11.9/12.5 on Unix, IBM mainframe CICS/VSAM.
Developed and enhanced LightBridge’s telecommunications application using PowerBuilder 7.3, CORBA and Oracle 8i to track calls and assign customer service packages and features (including toll free, call waiting, virtual network, image transferring services and voicemail).
Responsible for the design, development and implementation an application includes, creating tables, views, writhing PL/SQL triggers and stored procedures, integrating programming interfaces (APIs) to PB and Oracle.
POWERBUILDER 12.5, MF COBOL, (Sybase) ASE/12.5.1, ORACLE 9i, PL/SQL, MS SQL/2008, ColdFusion MX, Java, JavaScript
Computer Applications Developments, Inc. Nov. 1993 – May 2002
Sr. Programmer/Warner Bros. Int'l Division
Specific projects included:
Developed systems resulting in the creation of three major applications including “Pay Television” systems, “Film Rating”, “Film Telecast” and multiple other applications on a smaller scale.
Database design and analysis of logical data model using S-Designer, Star Designer. System engineering (Creating functional and business classes for system applications); Designing software system; Network administration and troubleshooting (Hardware & Software). Programming using PowerBuilder 3.0/6.5, PFC, SQL, PL/SQL, T-SQL, SQLPlus, SQR, VB 3.0/5.0, Oracle 7.3/8.0, MS SQL Server 6.5/7.0,, MTS 2.0, COM/DCOM. .
Created prototype system for billing and accounts receivable system.
Designed a customized prototype system to include 3-teer architecture using Visual FoxPro, MTS 2.0, MS SQL Server 7.0, COM/DCOM.
Mathematics & Computer Science Research, Institute of Yerevan Nov. 1985 – May 1992
Computer Programmer