Software Engineer Microsoft Office

RYAN FRINK

952-***-**** ****.*****@*******.***

SOFTWARE ENGINEER

PROFESSIONAL SUMMARY

Savvy and analytical IT professional with 16 years of experience including more than 10 years hands-on AS/400 and iSeries development. Very adaptable to change as demonstrated by working in varying technical environments using both Agile and Waterfall methodologies. Extremely dedicated – willing to work extra hours to restore service or ensure on-time project delivery.

Quick to learn and apply new platforms, programming languages and applications as required.

Work well with others – can be counted on to produce accurate and timely results.

High energy level, trustworthy, proactive and strong work ethic.

TECHNICAL SKILLS

Languages:

iSeries: COBOL400, RPG/400, RPGIV and CL (all expert); Exposure to RPG Free and Lansa

Microsoft: Visual Basic and SQL (both advanced), C# (both basic)

Operating Systems:

OS/400 for AS/400 and iSeries (all expert); Microsoft Windows

Tools Programs:

Robot Scheduler and Aldon CMS (both advanced)

Visio, Client Access, Jira, Confluence, Pac 2000 and NDM (all basic)

Databases:

DB2/400 (expert), SQL Server (advanced to expert), Oracle and Sybase (both basic)

Application Software:

SalesLogix LAN (expert), Cognos (advanced), Toad, Saleslogix Web and .NET (all basic)

Development Models:

Agile and Waterfall (both expert)

General Software:

Microsoft Outlook (expert) and Microsoft Office (advanced)

PROFESSIONAL EXPERIENCE

HOM FURNITURE, COON RAPIDS MN November, 2015 – June, 2017

Software Engineer

Developed a dynamic pop-up menu screen with user options, utilizing mouse button click and radio button functionality, for use in all interactive screens.

Converted approximately 50 screen programs to fully incorporate mouse button click functionality.

Created a global update program allowing users the ability to update a variety of fields for multiple SKU's.

Fully developed an interactive application for labor costs review and approval.

Experience with cross reference tool ABSTRACT.

Became proficient in RPG Free and RDi (Rational Developer for i).

WELLS FARGO SECURITIES, MINNEAPOLIS MN 2000 – 2015

Software Engineer

AS/400 & iSeries:

The vast majority of my time (95%) was spent performing full SDLC software development on multiple new and maintenance projects. Additionally responsible for providing 24/7 application support, training co-workers, conducting data and business analysis, and troubleshooting concept designs and functionality requirements.

Projects:

Wrote a referral credit application in RPG lV and Cobol/400 that credited sales staff with "soft dollar" compensation for referrals. The application made use of an interactive screen to make "manual adjustments" as desired, and a menu that would send extracts, via NDM, of specific referral data to different groups within Wells.

Wrote an interactive application using RPG ILE and CL that exported trade data for a specified time period from DB2 to the IFS (Integrated File System) for user reporting.

Created a Call Bond Messaging application. The application was written in RPG ILE, COBOL and CL, and sent notifications to sales rep's printers regarding their upcoming Bonds that were being called.

Wrote an automated screen application (CL, RPG IV) for tracking customer agreements (from mailing, to delivery, to return receipt). This application saved the operations team time and money by reducing the hands on data entry and manual tracking that each agreement previously required.

Created an NDM logging screen (RPG ILE) for overnight operators to show them the status of all of incoming and outgoing NDM transmissions.

Wrote numerous maintenance and upgrade applications (written in COBOL400, RPG IV, RPG ILE, CL, Query/400, Lansa). These included applications for data warehousing (for increased performance), report changes, screen alterations, and logic changes.

Played a key role in the migration of the AS/400 to iSeries server. Conducted extensive analysis, documented and trained new night shift operators on procedures/policies for monitoring the nightly batch processing.

Experience with Aldon CMS (Change Management System).

Advanced exposure to Query/400 and SQL/400. Query/400 was used for querying DB2 data - both AdHoc and for use in production applications. Used SQL/400 embedded in RPG for querying data as required.

Helped to restore system data and functionality after server crash including restoring data from Phase3 (system of record), running batch processes in order of criticality, and assisting users with ad-hoc data recovery and reporting.

Miscellaneous:

Solely developed and supported the department’s in-house customizations and enhancements for a third-party SalesLogix application. Conducted all internal development and assisted in application upgrades.

Significantly reduced the execution time of a .NET application accessing a database more than eight-fold (4-4 hrs. to hr.) by completely rewriting an Extract, Transform and Load (ETL) process.

Served as the technology contact/lead for SalesLogix upgrades. Collaborated with Sage (developers of SalesLogix) to ensure a seamless software-upgrade transition for the users, including all internal code customizations.

Functioned as the technical analyst/architect for implementing Anti-Money Laundering and Know Your Customer processes, providing important customer information gathering and automating the manual/time-consuming procedure for identifying suspicious customer activity based on trends and activities.

EDUCATION AND TRAINING

BROWN COLLEGE, Mendota Heights, MN – Programming Certificate

Training: Actuate (reporting tool), ASP .NET 2.0, C# 2005, PATHFINDER for AS/400 (tool from Hawkeye Information Systems), Cognos, SalesLogix LAN and Web development (earned Sage certification in Web development)

Contact this candidate