SUMMARY

• Sr. Developer / Programmer Analyst with over 15 years of experience.
• Responsible for providing support to large Mortgage applications such as REO, Bankruptcy, Foreclosure, Home Retention, and Tax Support, as well as Claims and Customer Correspondence Relations Systems. Open, resolve and close trouble tickets with Remedy.
• Experienced in documenting requirements, process flows, and creating design specs/documentation and data flows. Also, have a very strong knowledge of user banking applications, Transportation applications and ERP applications as well as WMS systems - Have worked extensively with banking business Unit Managers while serving as a technical/BA.
• Created Support Documentation for Confidential for Banking Correspondence Applications and Imaging systems. Also, provided support for tax applications and business groups in the Country Wide applications area, and other home retention applications.
• Analyzed and resolved numerous support calls using analytical skills for various tax applications such as TXDLQ - TAX DELINQUENCY SYSTEMS QUEUE.
• Worked with MQ Series Data Queues which were used for transporting of data to various servers for responding to customer messages, and email / mail correspondences.
• Worked closely with Business Users and managers to identify key issues, and requirements while interfacing with the proper development groups during coding phases. Have followed through to resolution on very large projects, and have had this experience as well on SOX compliant projects.
• Used Clear Quest, SNAGIT, and Visio. Is an expert with Excel, and has created summaries on large Data sheets, pivot tables, and flowcharts. Have also worked with large data sets, pivot tables, V lookups and macros.

TECHNICAL SKILLS

Design Tools: Have Utilized MS Visio, for the creation of DFD (Data flow Diagrams), and ERD (Entity Relationships Diagrams), which were used in the design of applications and tables for various projects.

Management Tools: MS Project, MS Visio, MS Word, MS Power Point, MS Excel Tools IBM Rational WDSC 400/tools, RDI/RDP, REMEDY and Maximo software support applications for MS Office Suite GAP Analysis, CICS, IMS, OS/400, Vision/400, Adobe Acrobat Reader

PLATFORMS: IBM OS/390-MVS Operating System, IBM DB2, AS/400, iSeries, Power I systems

DATABASES: System I database development, DB2, Data-Warehousing, Oracle

Language: JAVA, SQL (Oracle PL SQL & DB2 SQL), RPG4/RPG3/ILE, Free-from coding, CL programming, HTML, XML, .CSS, DDS

Databases: RDBMS Concepts and have performed Database design and creation for Enterprise databases for transportation, banking and ERP systems, using MS SQL Server, Oracle, DB2, MS Access, ETL, DIM, Fact tables, and Data Cubes for EDW (Enterprise Data Warehouse).

Application Servers: WebSphere, Web logic for IBM I-series, SharePoint

Scripting Languages: Have created scripts to run on Linux, UNIX, and Mainframe Machines/Platforms, as well as have created many CL scripts to run on the AS400/I-series machines.

Testing Tools: Crystal Reports, HP-ALM quality center, and corresponding Excel templates for manual test cases, designed for upload to ALM, with all appropriate elements needed for Test Case and Test script upload to ALM QA application.Web Technologies: CSS, XML, HTML, Java. Mid-Range Systems - CLP, Office Vision/400, HTML, XML, SQL, UML, Java,Data Warehouses /ERP Systems/WMS /Transportation applications/ Insurance Applications and Systems, Trailblazer Communications FTP, ERP & WMS

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Programmer Analyst

Responsibilities:

• Utilized SQL to analyze data, for designing fixes and Fixes/PTF’S for the shipping, RF, and Order entry processes/departments (customer service).
• Coded changes/Enhancements to the monthly Account statements, and invoice processes, to include email and fax options.
• Facilitated/coded the automation of Order entry edits, for the Auto-Allocation of inventory s.
• Created documentation for end users on all enhancements and system changes designed by the I.T. staff.
• Provided incident support analysis and documentations within INC/REMEDY support tickets, including root cause analysis (RCA) and resolution analysis (resolutions documented in REMEDY), for Equator applications and processes, including handling the closing or re-triggering of certain Equator Tasks, and triggers.
• Created SQL scripts for reporting over User Roles / Titles, authorities and permissions, (and authorized modules with in Equator), which changed on a weekly basis. Also, Documented, and analyzed data integration errors between the (Legacy AS400) TRAX mortgage system, and the Equator REO Home Auction and Sales/foreclosure systems, and facilitated in finding the solution for these data integration and XML errors.
• Provided Equator business support to various departments including REAM, Sales, Auctions, REO, and Title departments. • Handled inbound XML exceptions, between outside vendors for repairs and the Equator Repairs and expense modules.
• Analyzed issues / incidents between the legacy FALCON AS400 Accounting system, and the Equator repairs module updates • Utilized REMEDY - Incident and problem MGT. modules, for assisting in making enhancements to Equator applications releases.
• Provided Mgt. with reporting in REMEDY for tracking volumes of Incident tickets, and tracking problem management tickets on a weekly basis. Skills: SQL, XML, AS400, ALM, HP Life Mgt, Test Case / Test Scripts (templates) MS Excel, SQL, XML, Equator Modules/Applications, Remedy

Confidential

ISeries Systems Analyst

Responsibilities:

• Created Pass/fail case responses, in ALM-in order to communicate and make visible the tests to other departments (including upper MGT, and Dev. Teams) these tests that were being prepared for various unit, integration, and systems testing, and created cases via Excel spreadsheet templates as well for upload.
• Pass/fail responses were then given for each test script, and statuses for defects and fixes were sent out via ALM messaging, for gathering reporting on when fixes would be complete, and outstanding remaining tasks/completions.
• Defect Tracking was also used within ALM, for communicating fixes that were needed, and how to reproduce errors, for batch and interactive test cases, for tracking which fixes had a higher priority, so programs could then be re-verified and re-run, looking for further defects or efficiency opportunities.

Technologies: SQL, ILE, RPG-Free form/RPG4, HP-ALM-Application Life cycle MGT (testing I-series).

Confidential, Fort Worth, TX

ISeries Systems Analyst - Insurance and claims systems

Responsibilities:

• Created agent policy transfers application, for updating Agent and Policy Master Data, and for emailing standard documents and transfer approval forms and a listing of all policies being transferred to the new Agent using email API’s and PDF attachments.
• Created Claims Replacement Cost reports for accounting Dept. For tracking adjustor expenses and Status reporting in order to transfer claims to various depts. Also, utilized Excel API, for creating Excel spreadsheets of open/closed claims transactions and statuses for revenue reporting and outstanding yearly claims totals.
• Analyzed batch processing programs which processed inbound claims data, and processed customer invoices, which were used during cycle runs, while looking for efficiency and performance tuning opportunities.

Technologies used: SQL, ILE, RPGLE, form/RPG4, CL, CLLE, DDS, Hawkeye, WDSC, AL-policy administration System, SQL/400, Query/400 and AS/400 (Iseries).

Confidential, Lewisville, TX

ISeries / AS400 Onsite Tech. Lead Developer/Business Analyst

Responsibilities:

• Managed the design and coding of a critical strategic project, using ILE/free form for maintaining foreclosure and bankruptcy records. Managed and coded the decommission of the FORETRACS foreclosure tracking system. Created a new case tracking system and proof of claims (POC) applications and tables to be able to house the new data elements needed for tracking bankruptcies within the LSAMS Loan Servicing system. Created POC and petition payment detail windows and sub-file applications for this project, to assist in tracking revenue loss via the POC applications and bankruptcies.
• Created New DOKTRAK document tracking system, interface and user documentation. Exported DB2 loan servicing data using SQL and RPGLE, which was used to upload document Metadata to SQL Server DOKTRAK databases and applications. This system addressed challenges and issues in keeping track of client documents needed at various stages of the Loan lifecycle.
• Assisted in documenting workflows for borrower events, and created an interface that assisted tremendously in keeping track of which documents were needed by borrowers as they opened, closed, and paid off loans. Worked with various loan types and certain loan events as loans arrived at specific statuses.
• Created a 1098 Interest Amounts Actualization process; used *WRKQRY definitions and SQL to create reports on the 1098 amounts paid by other servicers, and on the 1098 amounts on acquisitions that had to be reported to the IRS; also created a reporting process for other servicers 1098 amounts for reporting loan acquisitions in the previous (tax) year.
• Created / designed innovative solutions (while working with offshore teams for development) for in- house customizations of TPS WMS distribution and sales systems. These included enhancements to invoicing, order confirmations and packing slip documents.

Technologies used: SQL, ILE, RPG-Free form/RPG4, CL, DDS, MKS Implementer, TURNOVER, WDSC, TPS (turning point) Distribution Systems, SQL/400, Query/400 and AS/400 (iSeries).

Confidential, Richardson, TX

ISeries Systems Analyst

Responsibilities:

• Analyzed and increased the efficiency of the Rx Claims batch processing programs, which processed inbound claims data, using LANSA and SQL tables, views, and indexes. Searched for optimization opportunities and improvements on SYNON READ/READE logic and code and SETLL code, to utilize more efficient indexes.
• Monitored and analyzed (for implementation purposes) before / after installation programs to ensure that the most efficient RPG4 and CLP/SQL coding techniques were used during QA process.
• Created new programming for the Excel reporting of file health for the auditing of core databases for claims, and to verify file size limits were not exceeded and transactions were under the SLA-2 minute intervals to avoid compliance and risk issues.
• Assisted in the creation of application development techniques and systems documentation for new hires and/or off-shore team documents to standardize new coding practices and coding / rules on new projects.

Technologies: AS400, SQL, RPGLE, Free Form RPG / RPG4, CL, CLP, ALDON, SYNON, MIMIX, SQL/400, Query/400 and AS/400 (Iseries).

Confidential, Addison, TX

Mortgage Onsite Lead and Business Analyst - for Tax Services Support/Correspondence Systems

Responsibilities:

• Managed a team of offshore developers (AS400) and a team of .Net developers (onshore) in an effort master and maintain support tickets for all Mortgage type applications. Identified and provided root cause analysis, and problem resolutions, as well as patches for needed PTFs and security flaws in the system.
• Created support documentation for BOA banking correspondence systems and tax applications. Created Workflows and data flow diagrams for AS400 backend databases, and charts for the Support group offshore. Created all documentation for the customer's document and imaging systems, for the imaging and work integration applications and for the property tax applications written in RPGLE, / FREE Form, and ILE Modules, as well as SQL stored procedures, Java classes and .Net packages.
• Provided ticket tracking using REMEDY, and Problem support of large Mortgage web application and customer relations system application (CRS), which were using AS400 back-end mortgage database systems that interfaced to the customer web applications.
• Analyzed and resolved numerous support calls for various tax applications, such as the Tax Delinquency System and the Tax Vendor Integration application for setting up tax lines, and the Tax disbursement applications, as well as supporting the NDR national tax repository database.
• Supported and provided documentation for mortgage applications as issues arose daily, including application failure points and transmission failures (FTP). Performed regular scheduled maintenance. Provided documentation for the property tax applications and customer contact departments to assist them in responding to customer needs quickly and efficiently.
• For Property Tax Applications, created technical manuals and support documentation for training on how to handle late night tax and mortgage support calls.
• Utilized MQ Series and APIs to send and retrieve XML for the Customer Correspondence and Document Integration System (which processed faxes and online banking messages); for the transmission of updates and service request creation; for Customer Service comment creation and for status updates of service requests.
• Monitored inbound and outbound XML messages that stored customer messages and inquiries from the MQ processing queues. This processing was initiated from front-end web applications.
• Created stored procedures which were also used as part of the Customer Correspondence System's calls to update the AS400 backend customer service correspondence database, via requests by front end applications.
• Analyzed / modified existing COBOL Mortgage (Legacy) system code for capturing logic and retro-fitting customizations into the AS400 CTSC (Country Wide) Tax and Mortgage systems (for secure transmissions and utilization of web front-end applications).
• Used Maximo for tracking all mortgage software incidents for problem management and troubleshooting records, and root cause analysis.
• Used Remedy ticketing application- for troubleshooting systems and recording support activities and events in a history log. And used Remedy for assigning primary ticket, and for escalations to various levels of support and documentation and root cause analysis, for posting final resolutions.
• AS400, DDS, ZMOD-FTP, Sub-files, SQL/400, ILE stored procedures, Free Form RPG, RPG3/4, CLP, Hawkeye, Trailblazer Communications, Query/400 and AS/400 (I-series) REMEDY & MAXIMO.
• Designed / coded new Quote to Order data interface between a web-based quoting system and the AS400-TMS (Work Order Entry Module) and DB2 Order Management. Utilized RPG-ILE, BNDDIR, free form and XML on the AS400 to design and code the transfer of data from the Quote system to the IFS and to DB2 on the backend.
• Created a customer service notifications sub-file screen for quote integration. This used multiple windows for commodity details, alerts for notifying users, and for processing accepted and approved quotes into work orders for truck dispatch. Utilized RPG4 free form, XML, ILE sub-procedures and service programs for creating a custom ILE service program to deal with XML strings and for storing and parsing the quote data into DB2 and converting the data to RPG data types.
• Enhanced the Permit Email Warning Notification System. This assisting in the control of permitted load costs and allocations, escort costs and permit accounting costs in the Permit System. Utilized the help/systems, API and E-SEND API, for the transmission of messages and used DB2 databases to store email addresses and issue emails when permit cost allocations superseded load revenue and certain trips.
• Enhanced an insurance notification system that relayed insurance policy notifications, cancellations and renewal process information to American Bankers customer base within certain time periods. This was accomplished utilizing ISeries RPG-ILE FREE-FORM and embedded free-form, and SQL/400.
• Utilized code analysis and indentation tools in IBM WDSC in order to enhance the reports that went to third-party account handlers (such as Assurant-American Bankers).

Confidential, Scottsdale, AZ

ISeries Systems Analyst / Insurance Developer / Quality Control

Responsibilities:

• Performed modifications and created new insurance reporting for the Auditing and Compliance Department and for the Confidential Dept. of Insurance, for various insurance products (including term life and annuities) for compliance tracking and the reporting of revenues, mortality rates and paid outs.
• Enhanced customer insurance service modules in the Insurance Claims System, and debugged various issues to create fixes for logic and messaging errors in the claims department.
• Designed and implemented these new insurance system modifications using Word and Visio, and performed coding changes using WDSC, Free Form/RPG, SQL, and RPG ILE.
• Used ILE FREE-FORM, SQL, RPGLE, CL, embedded SQL, and data warehouse methodologies for Transforming, Loading and Reporting ERP sales data and WMS transaction records and events as data was passed into the data warehouse from the transactional ERP system.
• Enhanced data warehousing systems and utilized IBM Data-mirror on Iseries and AS400 DB2 database systems for replication, transformation, and loading of data into the EDW.
• Designed and implemented standard maintenance sub-file screens, and window-based sub-file screens for the Owner Operator Department and for the fuel and dispatch applications.
• Utilized RPG4/ILE, DB2 SQL programming and Satellite Communications Packages/API (Sensor tracks, QTRACS APIs, and Trailer Sensor Tracks APIs) to make enhancements to the positioning and truck messaging applications for the Qualcomm Tractor and Trailer Tracks Systems.

Confidential, Phoenix, AZ

I-series / AS-400 ERP and WMS Systems Analyst

Responsibilities:

• Designed, coded and implemented system ERP changes for customer-specific enhancements of ERP and WMS applications using Word, Excel, Visio and ERD/DFD diagrams.
• Provided application remote support for warehouse applications by using interactive SQL for correcting bad data. Implemented program fixes and patches when needed.
• Designed, coded and implemented system WMS and ERP changes for customer-specific enhancements of ERP and WMS applications using Word, Excel, Visio and ERD/DFD diagrams.
• Assisted in QA and assisted application consultants with on-line support issues during go-lives.
• Provided 24/7 Support of ERP and Confidential WMS systems, also provided support during go lives as well.
• Recommended and designed PTF'S and small to mid-size application enhancements based on customer needs and business requirements.
• Assisted in creation of writing/creating technical support documentation and technical documentation for end users in the warehouse distribution centers.
• (Technologies Used: AS400 DDS, Display Screens, Sub-files, SQL, ILE Modules, Service Programs, RPG4 / freeform, CL, CLLE, ERP/WMS distribution systems/applications), administration, WRKQRY/400, SQL/400).
• Enhanced and converted data in billing and accounting systems for digital voice products and Internet services using AS/400, ISeries RPG/400, ILE Modules, Service Programs and SQL/400 to accommodate and move new data elements and flags to new billing invoices and reports and new voice accounts.
• Created RPG4 and ILE Service Program modules, used as conversion programs to modify and enhance core DB2 database formats and date formats.
• Modified DB2 Payroll Applications to handle four different pay methods for line haul drivers (hourly, commission based, mileage-based, compensation based, and load-size based compensation, base pay, also modified payroll apps. to calculate bonuses, overtime, and other incentive pay based on mileage.
• Created Sub-file programs for the transportation system, truck detention, and JIT loads.
• Modified satellite communication systems programs by utilizing API interfaces from the QUALCOMM/400 truck satellite communications software for logistics, and positional reporting and location updates, and communications with tractors, and drivers and statuses.