SUMMARY

• Have over 13 years of experience using RPG from RPG 3 through and including RPG4 and RPGILE. I was noted as one of the most accomplished and valuable RPG developers by multiple employers, receiving awards and bonuses based on the work that I performed (architecture, design and development).
• Performed complex architecture, design and implementation of both individual and integrated relational databases multiple times for multiple companies over the past 20+ years.
• Over the course of 20+ years, I have executed complex data analysis, defining data points and mapping those data points in the design of:
• Experienced working through every step of the SDLC, both individually and as part of a team.
• Experienced creating command procedures, triggers and automation of batch processes.
• Experienced in system and software maintenance upgrades.
• Experienced in working with the Business to gather requirements, perform gap analysis and create detailed process analysis of their needs.
• Experienced in architecture, design, coding and implementation of complex software systems and interfaces to interact with external sources as well as the creation of wireframes and mock - ups of screen designs utilizing SDA and RPG.
• Experienced in performing presentations to all levels of stakeholders and management within the organization.
• Experienced in providing troubleshooting and support of existing software and system problems.
• Experience working in both Agile and Waterfall environments.
• Experienced with various SQL Query tools (Showcase Query, Toad, AS400 Query, etc.).
• Proficient in Microsoft Office Suite (Outlook, Word, Excel, PowerPoint, Project, Visio, Access).
• Experienced using Blueprint requirements software.
• Over 28 years of experience in document creation and organization. Includes creation of detailed and extensive Technical Specifications, Functional Requirements Documents, as well as Business Requirements Documents.
• Experienced as a part-time Adult Education Teacher for the City of Lynchburg Adult Education Program Teaching Computer Basics.
• Mapped, designed and created multiple EDI processes for numerous companies by analysing the incoming data points, identifying the definition of those data points, aligning them to in-house data points from within the internal database, then constructing the mapping from the external source into the local database. Coded programming to manipulate the data as defined in my design.
• Performed architecture, design and coding of an extremely complex process to meet HIPAA requirements by analysing the HIPAA-formatted record layout coming in from the Data Clearing House, identifying their purpose, aligning them to the internal data points within the in-house database, then designing the mapping of the data into the corresponding data points within an extremely complex internal database.
• Performed architecture, design, coding and implementation of numerous IVR systems for several companies by analysing the incoming call data and identifying the related data points within the existing database. Followed the data throughout the length of the call y identifying data points required to perform data calls to execute the functions requested by the caller, and, if required, wrote updates back to the database under pre-defined conditions.
• Created multiple processes used by both banking and insurance institutions to ensure that customers coming into the system were not included on any government watch lists. Involved identification and analysis of data points and their values, mapping into a pre-defined data structure for transfer and receipt of results from the search. Took the returned data and mapped into existing data points and updated/wrote results into the dataset. Positive results were mapped into a data structure then send to the government.
• Created an ID verification process that identified, mapped existing data into an outgoing formatted record structure, sent to LexisNexis for live interaction with the customer, then received the results from LexisNexis and mapped back into the database, determining further action by analysing the values of the data.
• Performed architecture, design, coding and implementation of complex systems and interfaces to interact with external sources and the mapping to create or update data points, files and databases as required.
• Performed architecture, design, coding and implementation of a vast set of programs that allowed an insurance institution to sell Dental policies when it was not supported by the core system.
• Proficient with various SQL Query as well as various SQL tools such as Showcase Query, Toad, AS400 Query, etc.
• Have worked in both Agile and Waterfall environments.
• Veteran of Microsoft Office Suite (Outlook, Word, Excel, PowerPoint, Project, Visio, Access).
• Expert with over 28 years of experience in document creation and organization and updates. Includes creation of Data Dictionaries, detailed and extensive Technical Specifications, Functional Requirements Documents, as well as Business Requirements Documents.
• Qualified and performed as a part-time Adult Education Teacher for the City of Lynchburg Adult Education Program teaching Computer Basics.

PROFESSIONAL EXPERIENCE

Technical Relationship Manager

Confidential

Responsibilities:

• Contractor at Wells Fargo Home Lending, for the Loss Control & Liquidation Technology Partners (LCLTP) as part of the Enterprise Information Technology’s Servicing Technology Group. Supported the Foreclosure and Pre-Foreclosure Areas located in Ft. Mill, SC.
• Technical Relationship Manager and
• Business Systems Consultant.
• As a Technical Relationship Manager
• Liaison between Business and EIT (Enterprise Information Technology).
• Partnered with the Delivery Manager for Foreclosure and Pre-Foreclosure on the scheduling, solutioning and all-around support of all Foreclosure and Pre-Foreclosure projects.
• Created sizings for projects - CREST high-level sizings, Mid-Level sizings based on approved BRD, and Final Sizings based on approved FSD.
• Worked with the POM alongside the business and with the Technology Developers to see projects through the SDLC process.
• Continued from original Ideation and Initialization of the Project all the way through to Deployment and Post-Deployment support monitoring progress, gathering updates and continuing in the responsibility of being the liaison between EIT and the Business.
• As a Business Systems Consultant
• Worked with the Business Analyst from the POM to create the Solution and Design based on an approved BRD.
• Used BluePrint to enter Design Artifacts thereby creating the FSD.
• Followed the project through supporting Development, Testing and Deployment.

Software Utilized: Microsoft Office (Outlook, Excel, Word, PowerPoint, Visio); Blueprint; ALM / Quality Center; Skype

Lead Business Systems Analyst

Confidential Charlotte, NC

Responsibilities:

• Highly proprietary project that separated the existing Direct and Retail business lines into two new entities.
• Design of a new IVR process for the call center. Specifically worked on the Data and Reporting requirements to align the proposed Verizon IVR data into the MetLife call center tables. Designed detailed Data Flow of the process from entry of the customer into the IVR system, through the IVR until customer hang-up.
• New Product preparation to go to market. Followed it through into Production.
• Started Day 1.1 requirements for this New Product and followed through until end of my contract.
• Worked on an ID Check project utilizing LexisNexis and a series of questions to validate customer identification. Mapped existing data into an outgoing formatted record structure, sent to LexisNexis for live interaction with the customer, then received the results from LexisNexis and mapped them back into the database, determining further action by analysing the values of the data points.
• Created a Weekly Portfolio Status Report in PowerPoint. Compiled OMMs from all PMs from the previous week and pulled them together to create a report that was used within the PMO and on up through the layers of management.

Software Utilized: Microsoft Office (Outlook, Excel, Word, PowerPoint, Visio); Blueprint; BOX; Workfront; Quality Center

Senior Business Systems Analyst

Confidential

Responsibilities:

• Designed expansion of Provider Relations system, Accounting systems, Claims Processing systems, as well as multiple other Dental Insurance Related solutions. Required analysis and creation of new tables and fields in existing tables within the database. Mapped incoming and entry fields into corresponding fields in tables of the existing database.
• Created data flow diagrams, workflows, system configuration diagrams, storyboards, business flow diagrams, business process diagrams, system flow diagrams, requirements definition, programming specifications, procedures, instructions and test scripts.
• Supported system and database implementations, testing and documentation.
• Worked with the business at all levels to gather, analyze and evaluate business data and requirements.
• Developed complex written materials and design specifications for automated systems intended to fulfil corporate business requirements. Displayed excellent communication skills with an emphasis on clear and easily understood conversational and written communication.
• Documented information systems; business process diagrams, data and system flow diagrams, requirements definition, programming specifications including data definitions and mapping.
• Final project was the creation of a new Individual Dental Sales process that was web-based, working from existing SQL Tables. Involved database architecture, table and screen design, data and process flow design, and creation of prototype to present to multiple large audiences.
• Participated in every phase of the SDLC. Considered to be a top-level specialist.

Software Utilized: SQL/Toad on Oracle database; Microsoft Office (Project, Word, Excel, Outlook, Visio, PowerPoint); JIRA Change Management System; BluePrint

Business Analyst Contractor

Confidential

Responsibilities:

• Combined call center data as part of the Wells Fargo/Wachovia merger. Analysed the Wells Fargo record layout and its data point values to properly align them to the parallel data points in the Wachovia call center database. Identified data tables that had to be modified to accept new data points from Wells Fargo tables that were not previously retained in the Wachovia database.
• Performed mapping of data requirements from Wells Fargo database(s) to the Wachovia databases on an Oracle platform utilizing SQL.
• Utilized SQL for mapping call center fields throughout the tables.
• Created Functional System Documents from Project Definition Documents and Business Requirements Documents to specifically show how the deliverable would meet requirements while maintaining business rules.
• Acted as Project Manager for inter-departmental projects holding regular status meetings, handling issues, researching technical questions, and acting as Point of Contact.

Software Utilized: Microsoft Office 2008 (Outlook, Project, Access, Word, Excel); Hyperion Reporting System; Sequel Server 2005, 2008; SQL on Oracle database

Senior Systems Analyst

Confidential

Responsibilities:

• Created data and process flows and performed gap analysis on requirements against existing database(s) and software.
• Performed architecture and design of database files and the software solutions for extremely complex issues.
• Designed and built interactive screens and data process flow for data entry and maintenance and/or batch processing while ensuring and maintaining compliance with all business rules and legal compliance rules and mapping entry data into existing relational database. Mapped data from screens into data points in the database.
• Wrote intricate, detailed Technical Specifications illustrating proposed solution.
• Designed data flows, interfaces and business processes to work flawlessly with existing purchased software package (Group+, a Genelco product).
• Multiple interactive entry and file maintenance processes for new insurance products (LTD, STD, Life, Dental, Vision, etc.) to interface with existing software and database. This very complex system involved design of hierarchical, relational files to tie to existing core database files, controlled by a modular set of programs that performed data entry, validation, formatting and maintenance on a number of variables. These modules were designed to be accessed from multiple processes.
• Designed an extremely complex process to meet HIPAA requirements by analysing the HIPAA-formatted record layout data points coming in from the Data Clearing House, identifying their purpose, aligning them to internal data points within the in-house database, then creating the mapping of those data points into the corresponding data points within an extremely complex internal relational database.
• Designed an abbreviated Claims Data Entry system which condensed 14 data entry screens down to 3 and expedited the entry process from 15 minutes down to 2 minutes. Accomplishing this required a detailed analysis of initial data entered and matching to hierarchical data at detail levels across multiple files to automate population of claim fields thereby saving time by limiting actual data entry.
• Designed a batch process to execute customized claims adjudication requirements within existing software. This required intricate maneuvering of data to automate previously manual processes resulting in increased throughput and reduction of personnel interaction.
• Designed a new interactive process to allow personnel to work with suspended EDI claims prior to entering the existing system. Designed processing to reconcile erroneous data with valid system data or reject claims and route them automatically to a printing process to generate denial letters.
• Project Management of all projects from Concept through Implementation (complete SDLC).

Software Utilized: Query 400; SQL (Showcase Query); RPG IV and ILE; COBOL; IBM CL; DBU (DataBase Update tool); SDA; Microsoft Office Suite; JWalk to design and create GUI screens over existing green screens; Turnover Change Management System; Received intensive on-site Java, XML and HTML training

Lead Systems Analyst/Developer

Confidential

Responsibilities:

• Worked with users to enhance existing and develop new systems as needed. This included analysis of new data and creating new files that were tied to existing files within the database.
• Performed gap analysis on the data to determine new data points that needed to be added.
• Performed architecture and design of files in the database to produce a desired solution.
• Created detailed Technical Specifications and Models illustrating the proposed system including screens, files and data/process flows.
• Created screen designs, printer files, logical and physical files and window designs for both development and maintenance issues.
• Provided technical and user documentation on all projects.
• Completed analysis and design for the Marketing Department towards the development of a new Marketing and Sales Analysis System.
• Created detailed technical specifications and models illustrating the proposed system including screens and data flow to perform file maintenance and order tracking systems.
• Performed Infinium Financial and HR Package file and program updates and integrations.
• Provided analysis, architecture and design of necessary files and program modifications to incorporate an automatic e-mail process within the existing manufacturing and order processing systems.
• Developed and supported various reports on a multitude of systems.
• Provided both maintenance and development of data and files within the database.

Software Utilized: SQL; Query 400; Microsoft Office Suite; RPG III, IV, ILE; IBM CL; DBU (DataBase Update tool); SDA; RLU; APlus

Information Systems Consultant

Confidential

Responsibilities:

• Contractor at various locations:
• InService America, Lynchburg, Virginia
• Krispy Kreme Doughnut, Winston-Salem, North Carolina
• Roanoke Steel, Roanoke, Virginia
• Advance Auto Parts, Roanoke, Virginia
• Performed analysis, design, and development of new and existing files and systems.
• Technical Lead and Designer/Architect
• Provided detailed Technical and User-Oriented documentation on all programs and Data Dictionaries at time of rollout.
• Project Manager throughout the SDLC as well as technical support and troubleshooting for users at remote locations.
• Designed and developed an interactive system used to control job assignments for telemarketers.
• Krispy Kreme Doughnut:
• Analysis, design and development of a new Accounts Receivable system. Included a HELP system which could be used throughout as well as a new interactive process to create and modify existing tickets in this system.
• Developed screen and process for hand-held scanning device.
• Worked on the maintenance team for the Accounting GL and Warehouse systems.

Software Utilized: SQL; Query 400; DBU (DataBase Update tool); Microsoft Office Suite; RPG III, IV and ILE; IBM’s CL; SDA; Debug; DFU programs such as PASSPORT and FEU

Computer Programmer/Systems Analyst

Confidential

Responsibilities:

• Full Time Employee for Confidential -Terry Shoe Company in Lynchburg, Virginia.
• Programmer/Analyst performing maintenance and new development of programs for both manufacturing and telemarketing software systems.
• Troubleshooting system and programming problems.
• Assisted in higher-level system jobs such as Operating System Upgrades, Setup of PC-Mainframe Communications, Setup/Modification of User Profiles, etc.
• Final 3 months, held position of acting IS Manager.
• Performed complete redesign, architecture, programming and implementation of UPC coding process including analysis, development and population of new files and programs.
• Developed bar-coding programs using Data Harvester, PC Support Software and Symbol LDT Scanners to interface with the system. Created programs to handle daily inventory adjustments as well as the bi-annual physical inventory processing. Developed a secure menu system using CL programming to process and track inventory by storing current status, User IDs and other pertinent information.
• Performed complete redesign, redevelopment, reprogramming and implementation of two inventory systems for different software packages.
• Developed programming to upload data files from the Internet to the system then map into existing files.

Software Utilized: SQL; Query 400; DBU (DataBase Update tool); Microsoft Office Suite; RPG III and IV; IBM’s CL; SDA; Debug; Data Harvester; PC Support; Hawkeye; Novell Server