University Northridge Computer Operator

STEVEN DUARTE

*** ******** ******, # ***, *********, CA 93010 C: 805-***-**** ********@*****.*** PROFESSIONAL SUMMARY

I started in Information Technology in 1982 and have been employed in this field ever since. I've have worked for Fidelity National Financial and related companies for almost 33 years as a computer programmer and analyst. Most of the time was spent working on the IBM mainframe overseeing updates to title plant databases. SKILLS

Large computer networks Microsoft Excel, Word

Interpersonal skills Microsoft SQL Server management Studio Team player Microsoft Visual Studio

Documentation TSQL

WORK HISTORY

March 1983 to December 1983

Security Pacific National Bank – Glendale, California Computer Operator

• Ran tasks from run sheets to update application files and update databases with those files.. Worked in print room printing banking statements.

April 1984 to September 2014

Fidelity National Financial and its Predecessor Companies - Chatsworth, California and Glendale, California Programmer/Analyst

• Maintained Security Union plant (SOL) system batch processes.

• Provided 24 hour on-call support for the mainframe title plant systems.

• Developed numerous batch processes for data sales and marketing purposes.

• Modified and tested programs in the SOL title plant system for the Y2K project.

• Developed mainframe programs for marketing of title plant information.

• Maintained tables and batch programs when users/customers were added, changed or deleted.

• Moved fallout and other report printing from central location (Chatsworth, CA) to user locations.

• Assisted with Menu 13 conversions for PI customers.

• Performed periodic database reorganizations.

• Participated various projects to upgrade mainframe operating systems, IDMS databases and CICS.

• Performed initial data comparison and testing for cutover to offshore data entry for Central Valley counties. September 2014 to March 2018

Black Knight Financial Services – Glendale, California

• Designed and developed data conversion processes using Microsoft SQL Server Integration Services (SSIS).

• For the conversion of the Los Angeles title plant system from SOL to TitlePoint, converted master files from CSYS mainframe to flat files. Imported the files into SQL Server using SSIS. This included analysis, design, development and testing.

• For the conversion of Oregon Tri-Plant TIMS data to TitlePoint, imported files from TIMS into SQL Server source tables using SSIS. These tables were the starting point for the conversion. This included working out technical details with the vendor, analysis, design, development and testing.

• Designed, developed and tested approximately 60 title plant integrity reports using SSIS.

• Executed Access database queries to import and append daily and weekly data to Tracker tables. These files contain summary records used for billing purposes by Vendor management team. An important part of Tracker table updates is identifying invalids, duplicates and fix\replacement records. I’ve set up processes to convert spreadsheets given to me by vendor management team into files to delete existing duplicates on production trackers and replacing them with fix\replacement records. Processes for all tracker table updates have been meticulously documented in Word documents.

• Converted all BKFS codes in SiteX 1-66 databases to a new database schema. Was assigned the task of being the “gatekeeper” of all code types to be converted. Thousands of codes required translation. Worked with the Recorder group to make the translations and then populated them into SQL Server tables for the conversion.

• Was responsible for execution of daily and weekly scripts that were used for tracking fabrication of public records data. It was essential that these scripts executed in a timely and accurate manner, and that all issues were addressed and resolved immediately. Part of these processes involved remediation of discrepancies introduced by data entry vendors and updating of Tracker tables used for billing purposes.

• Supported the NPI redaction of title plant data by producing a report for the Legal Department profiling existing NPI data and developing an SSIS package to report NPI data on an ongoing basis. February 12, 2019 to November 20, 2021

Caregiver – Ventura County In Home Supportive Services – Simi Valley, California Served as a full-time caregiver for my mother in her home. EDUCATION

High School Diploma: San Fernando High School – San Fernando, CA California State University Northridge - Northridge, CA

Contact this candidate