OBJECTIVE:

• Seeking a Senior Programmer/Analyst, Project Leader/Technical Services position utilizing my skills on the iSeries and non
• iSeries platforms to provide analysis, design, and performance improvements in applications. I also document databases, find data sources and find revenue leaks in applications.

TECHNICAL SKILLS

AS/400 - iSeries: i5/OS; RPG2,3,IV,Free plus ILE; SQL, SEQUEL, MQSeries; DBMON; Turnover; Synon; Aldon

Non-iSeries: Microsoft Office suite; C programming; C#; .Net4.0,4.5; TFS; ODBC; Visio Visual Studio 2008/2012; SQL Server 12;

APPLICATIONS Summary: Retail Banking, Mortgage Lending (including participation), Electronic Banking, Point-of-Sale (POS), Insurance, Distribution, Manufacturing, Mailing systems, Construction Accounts Receivable, Accounts Payable, General Ledger, Property Management, Sales Analysis, Order Entry, Transportation, Medical Insurance, Document Management, Gaming analysis and verification of new Gaming equipment, Student Lending.

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

Software Engineer

Responsibilities:

• Resolve issues in COBOL LE programs that current staff had no idea how to resolve.
• Create new tables, indices or program services to improve DB performance.
• Retrofit existing COBOL programs, Build new programs in RPG ‘totally’ free.
• Wrote C# program to send data requests to iSeries using REST process, due to lack of resources.
• Enhance XML parser for lending information received from FSA.
• Teach best practices (e.g. Common Table Entries) for iSeries DB2 to staff with less experience.
• Document database issues for architects to resolve. Document program/application changes.

Confidential, Sacramento, CA

To Contract Systems Analyst

Responsibilities:

• Created data mappings from RouteSmart data(GIS) to iSeries custom billing files. Create and present functional specifications for current/business user approval. Used SQL to mock-up results and find the fastest path to joining the data. Built an ERD to show the relationships.
• Create custom explode of Route backup for Disaster Recovery documentation.Part of the specification necessitated a data map to show where the data came from in RouteSmart, and how that data resided in the final output to RouteSmart maps. Many SQL scripts used to create proof of concept and/or test results.
• Review conversion of custom code to Profound Logic (web usage). Verify no data loss from ‘green’ screen to web user interface.

Confidential - Simi Valley, CA

To Contract Systems Analyst

Responsibilities:

• As Systems Analyst for Loss Mitigation team on Compliance Letter Rewrite project had to support September release changes due to problems in testing which traced back to original HLD. Rewrote high level specifications to correct data and operational problems. Created a number of SQL scripts to prove data was correct for user community.
• Started High Level Design on Compliance Letter Rewrite Phase2 project by transferring BRD requirements to HLD. Demonstrated data change impact using new SQL views for proof of concept. Data was housed in iSeries, SQL Server and 3rd party vendor databases.

Confidential, Agoura Hills, CA

Systems Analyst

Responsibilities:

• Coordinate change of document tracking application, Carousel and EIP, from .Net 1.1 to .Net 4.0.Work with development resources necessitated rewrite of specifications due to incomplete/missing success/fail criteria. Prepare test scripts; verify end user validation of production version of changed applications using SQL retrievals to prove success.
• Design and coordinate change of document tracking application,Carousel, to allow temporary storage ofdocuments in vault prior-to shipping to external storage vendor. Prepare and execute test scripts and verifyend user validation of production version of changed applications. Wrote functional specs and use cases from BRD as well as detailed review of Low Level Design. Specify and monitor user acceptance test due to insufficient test personnel availability.
• Update documentation for data flow changes, new data elements provided, corrected and enhanced Entity-Relationship diagrams, and procedure changes, as well as disaster recovery plan for the Carousel application.
• Started requirements gathering and high level design specifications to application, Carousel. Projectcancelled during requirements gathering.

Confidential, Simi Valley, Ca

To Performance Analyst

Responsibilities:

• Analyze execution of production jobs looking for ways to improve overall job, CPU and IOperformance using SQL tool DBMON, job logs and program source code review. After review of statisticalresults, write specifications for development team to correct performance issues
• Use DBMON performance tool to review SQL usage in programs and recommend ways to utilize SQLstatements more effectively in production jobs. Re-mapped data in applications since some applicationsused too many data elements to achieve their goals.
• Prepare analysis document and make program changes in RPGLE or CL to support recommendations when development team had insufficient resources.

Confidential, Agoura Hills, CA

To Contract Programmer/Analyst

Responsibilities:

• Correct lending programs, RPGLE and CL modifications, per specifications.
• Resolve design issues & document specification changes (HLD & LLD) made during design phase of projects.
• Perform data analysis using SQL on existing loans to support design decisions.
• Develop timelines for testing Components, System and User acceptance.
• Resolve errors in upstream loan data parsing, which prevented correct fees from being received.
• Prepare, review and load test scripts to Test Director/Quality Center (HP) test tool.
• Support test effort by downloading data in lieu of FTP(SQL, Teradata, ODBC, Client Access)

Confidential - Brea, CA

To Contract Programmer/Analyst

Responsibilities:

• Complete Functional Requirements from older design working with user community to verify business environment of Mechanical Breakdown Process. Acquired user signoff on Functional Design saves 2 FTE positions for reconciliation of credit cards used to pay for vehicle service work.
• Created Technical Design from the functional specification working within Mercury documentation standards.
• Coded and tested routines per the design. Created service programs to re-use routines and save time.
• Assisted test team with development of scripts and use with Test Director since team had little/noexperience with iSeries.
• Arranged with outside vendor for XML processing and SFTP transmission of reconciliation files. Datamapping of Mercury data to outside vendor’s transmission formats.

Confidential,Simi Valley, CA

To Contract Programmer/Analyst

Responsibilities:

• Wrote high and low level specifications for transferring iSeries customer information to Bank of Americamainframes (“conversion”). Significant amount of data mapping effort to create minimum transfer data set.
• Developed test programs to validate communications setup, web services and security for “conversion”tests. Typically using SQL, RPGLE, MQ interaction and SOAP.
• Resolve non-standard source code and recommend best practices for new environments(RPG, DB2/400, SQL, CL, DDS when DDL not acceptable).
• Develop timelines for testing (Microsoft Project, Microsoft Office).
• Prepare, review, and load test scripts to Test Director/Quality Center (HP) test tool.

Confidential - San Francisco, CA

To Contract Programmer/Analyst

Responsibilities:

• Analyze and document existing MC400 software per Blue Shield Standards including ERDs.
• Research and map iSeries data for data warehouse (SQL - DB2 & Oracle).
• Design, develop and install data transfer capability for iSeries data to be loaded to
• Map Managed Care data to Commercial Insurance data (Data Dictionary build).

Confidential - Woodland Hills, CA

To Contract Programmer/Analyst

Responsibilities:

• Repair information sharing between Healthnet’s Member Repository and Atlantes package (EDS).
• Analyze, document and design corrections for missing data and data quality issues from Healthnet systems to Atlantes (DB2/400, Informatica, RPG 3 IV Free, CL, SQL, DDS).
• Resolve issues between source system and Member Repository (SQL, RPGFree, CL, DB2/400).
• Design new extracts from Member Repository based on 3rd Party vendor requests
• Design and develop software for Medicare Part D data sharing between Healthnet and vendors
• Guide user community through reporting responsibilities for Medicare Part D(Business Analyst).

Confidential - Canoga Park, CA

To Contract Programmer/Analyst

Responsibilities:

• Correct urgent program failures on iSeries. Re-write existing code (RPG 2.xx) to exploit newerfeatures of the iSeries( SQL, RPGFree,etc).
• Create re-usable routines and service programs for ‘green screen’ or Web.
• Analyze, design and develop new application for allocating customer discounts for marketing staff.
• Re-design, with key users, programs to enable Department of Financial Regulation compliance.
• Create new programs to support Department of Financial Regulations on iSeries
• Designed and developed generic FTP tool to transfer iSeries data to network for transmission to client.
• Analyze and correct problems in Microsoft Access database for Loss Draft department.
• Rewrote portions of RPG 2.7x programs to enable new clients in software not designed for enhancement.