Jeff Serna Email & Phone Number

Los Angeles, California

Supports multiple .net web applications utilized by a line of business, ensuring proper user access and application compliance.Maintains numerous scheduled jobs to ensure continued uninterrupted production.Develops reports around data entered and processed through the front end GUI together with other data elements to provide more visibility to the business metrics and employee efficiency, these would then aid in several business related decisions.Technologies used: ASP.net; C#.net; T-SQL; SSIS (ETL); SSRS Data sources: iSeries; SQL Server; Oracle; Teradata; MS Access; flat file; MS ExcelEmploys SDLC (Software Development Life Cycle) with the use of Agile methodology (Scrum, Kanban).Averages 2 software releases/ deployments per month.Ensures environment (DEV, SIT/ UAT, PROD, CONT) readiness after system patches, OS updates and server migrations by regularly performing tests and updating software configurations when necessary.Developed a C#.net desktop application to assist in project analysis by allowing users to run reports, search database objects [i.e., SQL Server (user/ internal tables, stored procedures, scalar/ table functions, views, triggers, fields/ columns, etc.); iSeries (alias, logical/ physical files, procedure, views, triggers, functions, fields/ columns etc.), parse xml files and monitor SQL Agent jobs. Currently, the application has the ability to establish connection to SQL Server and iSeries/ DB2 database.

Data reporting and analytics. Responsible for performing complex analysis and modeling. Utilizes a variety of systems including, but not limited to Visual Basic, T-SQL, SSRS, SSIS, Excel and Access. Provides analytical support on various strategies to ensure company goals are met. Coordinates the production of performance reports and updates for senior management. Utilizes established databases to provide statistical and financial modeling.Utilized T-SQL, VB (Access, Excel, Word, VBS, VBA), SSRS and SSIS.Created reports using SQL queries, with the use of Stored procedures; Functions; Tiggers and Views for data conditioning and to pull desired data (record level; aggregate) by supported Line of Business.

Performed an examination of legal documents posted on a chain of title against residential properties essential to creating and preparing a Trustee sale guarantee.Developed an application to generate multiple variations of Title Reports using MS Visual Basic programming language, integrated with MS Word for the user GUI client-side and with MS Access as a database server-side.Provided immediate desktop support and provides brief training in system and computer use.Developed, tested and debugged applications for departments use for data entry to create reports; provided support and training on said applications.Developed several program utilities to improve department’s procedure.

Los Angeles, California

• Examined and analyzed recorded legal documents posted against the legal description of a parcel of land• Plotted out properties/ easements on a plat map from the legal description.• Determined ownership, and how interest is held on title. Examine surveys and other environmental land use concerns.• Researched and examined court opinions, case abstracts disclosed through a search of the federal, state or county database for underwriting consideration.• Conducted complex search i.e. Lot book search, Street Search, Alley Search, Highway Search, Easement Search, and 1st/Senior Cut Deed Search; Abstracted documents for recording.• Dealt with and assisted City Engineers/ Private Company Engineers, Attorneys, Developers and Clients regarding Search/ Exam, Subdivision (Condominiums) and mapping Projects with the addition of checking Tentative Tract/ Parcel Map and/ or Condominium plan if said plan adheres to the dimensions of recorded Maps and if it adheres to the Map Act to ensure the absence of land encroachments.