Systems Analyst Software Engineer

Lyna L. Abughanem

• Career Summary

o I have the unique experience and skill of a seasoned Business Systems Analyst, Software Engineer & Team Manager rolled into one. My more than 20 years of experience with SDLC has honed my skills to effectively communicate with business, development and QA teams, and effortlessly translate business requirements into quality functional and technical requirements no matter the industry or system. I make sure to add value to any project I participate in. o Being a self-taught software engineer has enhanced my creativity and passion for excellence. o Having developed most of the in-house systems for a bank, I have been exposed to different systems, e.g., Loan Origination, appraisal, credit scoring, underwriting, CRM, Accounting systems, inventory systems, HR systems, Payroll systems, pension, insurance, and so many others.

• Qualifications/ Areas of Expertise

o Certified Scrum Master (CSM)

o Six Sigma Greenbelt candidate; Certified Six Sigma Orange Belt; recipient of performance awards o Full-stack senior IT professional with more than 20 years hands-on IT experience leading all stages of System Development Life Cycle including requirements definition, design, programming, testing, documentation & support. o Expert in business systems analysis, SDLC (Waterfall/Agile) & Team Leadership o Several years of experience preparing Business Reqt Document (BRD), and Functional Specs including Process Flow Diagrams, Data Dictionary, Reports Specs, Entity-Relationship Diagram, Use Cases, wireframes, and other artifacts o Experienced in writing User Stories and acceptance criteria o Several years of experience writing User Guides and Technical Integration Guides o Member - ISO 27001:2005 preparation team for Union Bank; Head- Security Education Team o Outstanding project leader while managing and guiding 6 programmer/analysts o Resource speaker/instructor for in-house training such as System Analysis & Design & VB o Windows Form & web-based programming using Visual Basic 6 & Visual Studio 2010 (.net) o Web-site design (aka wireframe), development, and content management o Create relational database/file design & normalization including database admin, e.g. MS SQL, MySQL, MS Access o Some knowledge of ITIL (Change Management, Incident Management, SLA, Service Continuity, etc.)

• Education: B.S. Industrial Engineering, University of the Philippines, Diliman, Quezon City, Philippines

• Work Experience

o Senior Business Analyst (Oct 18, 2021 – present Wipro Limited USA - Remote)

Interface with clients and gain understanding of requirements/processes through meetings and discussions

Responsible across areas like requirement definition, execution and evaluation of functional tests, review, and analysis

Prepare Functional Specifications Document for client's business requirements related to NetOxygen (Wipro's Loan Origination System (LOS)).

Create Process Flow Diagrams, mockup screens, response XML elements analysis, etc. depending on business requirements.

Prepare scope document for NetOxygen releases

Perform Data Mapping for third party reporting (WKFS) o Business Systems Analyst (Feb 29, 2016 – October 15, 2021 Veros Real Estate Solutions Santa Ana, CA 92706 USA)

Gather and write requirements specifications including screen mock-ups, Process Flow Diagrams and Entity Relationship Diagrams

Write User Stories and Acceptance Criteria for new products and product enhancements

Write Functional Requirements Specs (FRS) for products that interface with Fannie Mae and Freddie Mac (GSEs), Federal Housing Administration

(FHA) and Veterans Affairs (VA) systems such as UCDP, EAD, UCD, and AMS

Prepare Business Requirements Document (BRD) for in-house systems: Sapphire-Encompass Integration, VeroSELECT Direct Integration and Portal (for AVM, BPO, HPT, PCR, etc.), VeroVALUE, Pathway Direct Integration, VeroSCORE (including report data mapping), and VeroDATAFI

Write requirements for creating APIs / web services for direct integration using XML and/or JSON request/response payloads.

Prepare/Update Technical Integration Guide for the following client services: Pathway, VeroSELECT, VeroSCORE, VeroVALUE and AMS

Prepare JIRA Issue Management Guidelines for the company

Collaborate with Agile development team during scrum meetings, poker planning and sprint planning.

Perform unit testing on development team's output including use of tools like Postman and SoapUI for running APIs.

Triage bug tickets and recommend solution.

Learn and master 3rd party software such as Logi Report Designer to implement ad-hoc reporting.

Prepare User Guides for various products

Other special assignments

Prepare and present product overview and demo for the following products: UCDP, EAD, Pathway, VeroSCORE and VeroDATAFI.

Work Achievements

Conducted thorough analysis of issues with VeroSCORE that resulted in fixing priority issues, making VeroSCORE a more reliable product

Created the Data Mapping spreadsheet for VeroSCORE when no one else wanted to do it because it is very tedious. This document is now a very valuable reference for all members of the team.

Wrote functional requirements to capture click metrics (using MS Azure Application Insights) as well as direct integration usage to provide the client with analytics on customer usage and trends.

Wrote requirements to migrate on prem authorization service to the AWS cloud environment.

Improved documentation by adding relevant artifacts that improved clarity of requirements, e.g. diagrams, decision table, data dictionary, etc.

Completed deliverables ahead of time thus ensuring that project timelines of Waterfall projects are met.

Revamped VeroSELECT User Guides resulting in well-written and complete guides for different user roles, thus improving user understanding of system. http://www.linkedin.com/pub/lyna-abughanem/45/574/768 Mobile Phone No.: 818-***-****

Address: Anaheim, CA 92805 USA

Email: *******@*****.***

o Business Analyst - Contract (Feb 20, 2015 – Feb 28, 2016 Endeavour Software Technologies Aliso Viejo, CA 92656 USA) For client Real Estate Digital (RED)

Elicit business/product requirements and create user stories/wireframes for the following new products: Customer for Life (Portfolio Retention), Enhanced Business Experience, rDocs (Real Estate Document management and Forms eSign system), rDesk (CRM), etc. (web and mobile apps)

Create storyboards for new product “Agent-centric CRM mobile app” (appCRM); Customer Web Page; Vendor Management System

Create deck for email campaign ideas that are out-of-the-box, and work on redesigning widgets for email campaigns

Create wireframes for Bank of America Home Watch program; Mortgage Calculator for Nationstar Mortgage website

Perform QA on completed user stories

Use rDesk (CRM) system to create email campaigns, upload agent & customer records, and define system users

Research on how in-house developed systems can interface with 3rd party software

Collaborate with Agile development team during scrum meetings

Modify the format and content of rDocs User Guide for agents and broker/admin o Sr. Business Analyst - Contract (November 11, 2014 – January 7, 2015 Cashcall, Inc. Anaheim, CA 92816 USA)

Gather and analyze data in support of business requirements from a functional and technical perspective

Document current (as-is) Personal Loan Servicing System based on interviews with SMEs and existing procedures manual o Sr. Business Systems Analyst – Contract (July 7, 2014–November 7, 2014 Carrington Mortgage Holdings, LLC Santa Ana, CA 92705 USA)

Prepare BRD/functional specs for Carrington’s Residential Rental business, and the new Accounts Receivable Subsidiary Ledger System including DFDs, Data Dictionary, data mapping & mock-up screens

Design Report Field Specifications Matrix and Test Script Template

Responsible for user acceptance testing, management and completion of quality assurance testing

Collaborate with Agile development team during scrum meetings o Business Systems Analyst – Contract (May 5, 2014 – June 2, 2014 Time Warner Cable El Segundo, CA 90245 USA

Elicit business requirements from key stakeholders

Prepare Business Requirements Document (BRD) and perform data mapping

Analyze ad-hoc requests from users and recommend solution o Sr. Business Systems Analyst / Sr Software Engineer / Team Manager (Application Development & Support Unit) (March 1995–Jan 2014 Union Bank of the Philippines Pasig City, Philippines) Union Bank of the Philippines is one of the top ten universal banks in the Philippines with more than 200 branches nationwide. My team serves the requirements for system development of all units of the bank plus 2 subsidiaries.

I wear multiple hats as a Team Manager, Sr Business Systems Analyst and Sr Software Engineer.

Elicit business requirements, analyze gap between current and desired system, and recommend solutions

Assess, document and communicate impact of change to business and individuals, formulate functional specs, estimate cost, schedule timeline and evaluate interfaces/interdependencies with other systems

Lead JAD and JAR sessions with business and other stakeholders

Prepare Business Reqt Document (BRD), and Functional Specifications

Create database/file design in MS SQL or MySQL or other relational database, write SQL queries, stored procedures, create reports and perform various ETL methods

Develop or assign development of software based on the BRD using applicable technology

Prepare test plan/test script and monitor User Acceptance Testing (UAT)

Use Mantis as project management tool for SDLC in both Waterfall and Agile environments

Prepare User’s Manual and conduct user training

Prepare implementation/deployment guide

Provide user support and system maintenance of systems in production

Identify and implement continuous improvement projects that will improve efficiency and reduce cost

Manage multiple projects including but not limited to Revolving Credit Line, Loan Documents Management, Customer Relationship Management (CRM), Pension Plan, Property (non-life) Insurance, etc.

Prepare Standard Operating Procedures Manual and Coding Standards document for my department upon appointment as Department Head

Manage, train, guide and assign tasks to my team of systems analyst/programmers

Below are some major systems I developed:

1) Human Resource Intranet Site

** Formulate specs with client which include the content and look and feel of the website

** Used Joomla to create the website and manage system enhancements

** Develop web-based applications, e.g. Employee Time-off, Employee Data Updating, etc. and incorporate in the website 2) Web-based Employee Loan Application System

** Collaborate with client and formulate requirement specs

** Perform systems analysis and design

** Develop the program using .net technology; perform module testing as programmer before user testing

** Create test plan and test scripts, & execute plan with users; Validate test results with Internal Audit to ensure accuracy

** Prepare Online Help Guide for users

3) Mortgage/Auto/Salary Loan Origination System

** Gather business requirements & prepare BRD

** Develop Windows-based system & maintain it, i.e. modify per user requirements

Work Achievements

Developed complex systems such as redevelopment of an off-the-shelf Financial Analysis System that had no more Vendor support and with only a User’s Manual as documentation resulting in tremendous savings for the company since they don’t have to purchase a new system.

Extensive experience in interfacing PC with mainframe applications, including online transaction programming

Developed a generic file maintenance system (with combined data grid and data entry screen), with built-in validation, to enable rapid development of data entry screens in 3-5 minutes.

Developed single-handedly from scratch approx. 70 systems, e.g. Retail Loans System (housing, auto, salary), Human Resource Info. System, Non-life Insurance System, Stockroom Inventory System, etc., resulting in millions of Pesos in acquisition & maintenance cost savings for the company.

Responsible for automating the process of systems development request up to implementation, saving time and money and enabling our team to pass audit.

Developed a project/performance monitoring system for the Application Development & Support Division that enabled all IT managers to monitor their staff performance and generate employee evaluation reports in an instant,

Implemented new technology recommended by R&D Dept., e.g. website using Joomla; workflow, etc.

Performed hands-on configuration and installation especially for new technology being implemented

Member of team that developed the COBIT (Control Objectives for Information & Related Technology) in preparation for ISO certification

Consistent excellent rating in performance evaluation by supervisor; Won the Search for Service Excellence for the last quarter of Year 2000

Received the prestigious Union Bank Chairman Award for developing a computerized Credit Scoring System to automatically compute the credit worthiness of a loan applicant

o Information Analyst (August 1989–March 1995 Union Bank of the Philippines Makati City, Philippines)

Meet with users to define their information requirements

Perform Systems Analysis/Design

Develop and maintain PC-based programs for the different units of the bank using VB6

Prepare test data, test the system, and prepare the User's Manual

Install/deploy the System in UAT environment (including IIS configuration if applicable), and conduct user training

Maintain the Account Profitability Analysis System for the bank. o Systems Analyst - Project-based (September 1988-August 1989 ACAPCOI Philippines Makati City, Philippines)

Perform systems analysis/design for various client systems specifically the Human Resource Management System o Systems Analyst (July 1988-September 1988 Sierrasoft Inc. Quezon City, Philippines)

Perform systems analysis/design for various client systems o Systems Engineering Manager (March 1987-June 1988 Systemantics Info. Systems Consultants Pasig City, Philippines)

Estimate design effort per project; Manage & train systems analysts o Systems Analyst (May 1986-March 1987 Systemantics Info. Systems Consultants Pasig City, Philippines)

Meet with clients to discuss their system requirements

Prepare a System Assessment Report that includes the company background, system overview, scope, objectives, man-hours and resource requirement estimate of the system.

Perform detailed data gathering and Systems Analysis/Design; prepare BRD & functional specs including Context Diagram, Data Flow Diagrams, Data Dictionary, ERD, Data Structure, prototype, etc.

Prepare test data, tests the system, and prepare the User's Manual.

Install the System and conduct user training.

Make a presentation of the system to company management.

Received the Best Performer award in 1987

• Major Systems Developed

1. Mortgage Loan Origination System (LOS) (includes auto- creation of accounting entries)

2. Mortgage Loans Amortization System

3. Retail Loans (Auto/Mortgage) Collection System

4. Property/Casualty Insurance System

5. Collateral Appraisal Information System

6. Online Collateral Appraisal

7. Loan Document Management System

8. Documentary Deficiency Monitoring

9. Foreclosed Property (ROPA) Subsidiary System

10. Property Rental Management (BRDs)

11. Auto Loan Origination System (LOS) (includes auto- creation of accounting entries)

12. Auto Loan CRM System

13. Auto Insurance System

14. Auto Loans History Inquiry System

15. Auto Loans Credit Scoring System

16. Salary Loan Origination System (LOS) (includes auto- creation of accounting entries)

17. Personal Loans Servicing System (BRD)

18. Employee Loan Application Processing (WinForm)

(includes auto-creation of accounting entries)

19. Web-based Employee Loan Application System

20. Web-based Employee Promotion Recommendation

21. Web-based Employee Data Updating System

22. Personnel Records System (HRIS)

23. Employee Payroll System (includes auto-creation of accounting entries)

24. Recruitment & Selection System

25. Human Resource Intranet Site

26. Online Job Application System (Internet/ Intranet) 27. Credit Scoring System (for corporate loan borrowers) - includes auto-creation of accounting entries and generation of accounting reports

28. Systems Development Project Monitoring Sys.

29. Library Records Maintenance System

30. Procurement Monitoring (Purchasing System)

31. Stockroom Inventory Management (includes auto-creation of accounting entries)

32. Fixed Asset Inventory Reconciliation

33. Fixed Asset Inventory Management System

34. Document Retrieval Management

35. Job Request Monitoring System

36. Credit Card Application Evaluation Maintenance 37. Credit Evaluation System

38. Networking Sales Commission Processing System

39. Several web-based online Bills Payment modules 40. Web-based password generation system

41. Veros Sapphire-Encompass Integration (BRD)

42. Legal Work Monitoring System

43. Export Declaration Tracking

44. Auto Loans Monitoring System

45. Agent-centric mobile CRM application for real estate (storyboard) 46. ACCOUNTNG SYSTEMS:

a. Accounts Receivable Subsidiary Ledger (BRD)

b. Term Products Subsidiary Ledger (incl Multi Branch Accounting) c. Web-based account debit/credit for online Stock Market Trading d. Auto Loans Accrual System

e. Due From Banks Reconciliation Statement System

f. Auto Loans Accounts Receivable

g. Financial Analysis Measure System

h. Consolidated Statement of Condition

• Technical Proficiencies

OPERATING SYSTEMS

Windows

DOS 3.0 higher

UNIX (SCO)

DATABASE

MS SQL / MySQL

Oracle/Toad

ADABAS

MS Access

VB 6.0 Data Manager

XBASE

COMPUTER LANGUAGES

Visual Studio.Net

ASP.Net

VB.Net

Webmatrix

Java/JSP

Visual Basic 6.0 / VB-Script

ASP/HTML

ActiveCICX

PHP 5

XBASE, e.g. Clipper, dBase, Foxbase

Informix-SQL/Informix-4GL

C-language

COBOL

SOFTWARE TOOLS/OTHERS

Postman and SoapUI

SugarCRM

IIS Configuration

EDI (FTP, auto-email scheduled task, DB update)

SQL queries, stored procedures

CMS, e.g. Joomla / Sharepoint / Microstrategy

Process Maker / Mantis / JIRA / Team Foundation

Logi Reporting Tool/ Active Reports/Crystal Reports / Tableau/ Pentaho (BI) / Relational Report Writer (R&R) Dreamweaver

Teamware / Biztalk

MS Office (Access, Excel, Word, Powerpoint), Open Office MS Project/ MS Chart / MS Visio

AutoCAD/ AutoSketch

Flow/ EasyCase

• Higher Technical Training

o Certified Scrum Master (CSM) training –6/28/2021 – 6/29/2021 by Scrum Alliance Certified on 6/30/2021: Certification URL: https://certification.scrumalliance.org/accounts/1218644-lyna-abughanem/certifications/1408044- csm

o Six Sigma Greenbelt Training – April 5-12, 2010 & May3-7, 2010 o COBIT Training – Dec. 15-16, 2009 (in-house)

o ISO 27001 Training- Nov. 13 & 27, 2009 (Sath)

o Six Sigma (Orange Belt) Training: Thinking Continuous Improvement- Aug. 20-21, 2008 (in-house) o PHP 5 Programming – June 23-25, 2008 (In-house training) o Joomla Web-design – July 26, 2007 (In-house training) o PHP Programming – Nov. 23-25, 2006- conducted by freelance programmer Mr. Ricky Bahague o Net Database Access Technology/Security, Cryptography and PKI –August 29, 2005 –by ITS o ASP.net Basics/Building Server Components –August 22, 2005 –by I.T. Consulting Services o Object-oriented Concepts and VB.net – August 19, 2005 –by I.T. Consulting Services (ITS) o Finacle Technical Training – June 18-25, 2004 - conducted by Infosys Technologies Ltd., India o Java Programming Workshop (SL-285)- June 14-18, 2004-conducted by Sun o Object-Oriented Analysis & Design (OO-226)- June 7-11, 2004-conducted by Sun o Web Component Dev't. W/ Servlet & JSP Technologies (SL-314)- May 31-June 4, 2004-by Sun o Java Programming (SL-275)- May 24-28, 2004-conducted by Sun Microsystems Phils. (Sun) o Oracle 9i – May 18-21, 2004 - conducted by UBP (in-house) o Webmatrix & .Net Framework – Feb. 2-3, 2003 - conducted by I.T. Consulting Services o Biztalk – Nov. 13-15, 2002 and Nov. 22, 2002 - conducted by I.T. Consulting Services

Contact this candidate