BOBBIE SHETRONE VAILS

*** ********* ****

Rock Hill, SC 29730

Mobile: 803-***-****

Home: 803-***-****

Email: q87yky@r.postjobfree.com

Web Resume: http://www.jobserve.us/Bobbie.Vails.vails.edi.mainframe.resume.jscv

PROFESSIONAL SUMMARY:

I have over 25 years of solid Information Technology background in the Insurance, Pharmaceutical, Manufacturing, Textile, and Financial industries …with specific knowledge of Benefit Enrollment and Maintenance, Order Entry, Product Information, Inventory, Data Warehouse, Marketing Data Mart, Marketing Customer Information File, Consumer / Commercial Loan, Retail Lending, Application Handling, Service Level / Partnerships, Service Management, Collection, Card Products, Operational Credit Exposure / Global Portfolio Credit Risk Solutions, Portfolio Management, Treasury Finance Balance Sheet Management / Corporate and Investment Banking, General Banking, and Account Reconciliation Plan applications. Strong developer experienced in full cycle of researching, analysis, designing, creating specifications, coding, debugging, unit / system / quality assurance / user acceptance testing, scheduling job flows, documentation, implementation, as well as providing production support. Expertise in VISUAL BASIC, T-SQL, SQL SERVER, PL/SQL, ORACLE, UNIX, SHELL SCRIPTS, SQL, DB2, IMS, CICS, VSAM, FILE-AID, QMF, XPEDITER, COBOL, APS, AMB, MFEEE, EASYTRIEVE, JCL/PROC, CA-7, CA-PANVALET, ENDEVOR, CHANGEMAN, MVS TSO/ISPF, JAVA, CSS, HTML, XML, ETL, NDM, SFTP, AS2, EDI, and DEVELOPING CUSTOMIZED REPORTS.

CORE COMPETENCIES (in number of year’s experience):

. Hardware: IBM …370 / 30XX / 43XX (25), PC (18)

. Operating Systems: OS / MVS / XA (25), WINDOWS…XP / 2000 / ME / 98 / 95 / 3.1 / NT (18), CISCO (10), NOVELL NETWARE (10), UNIX (6), MS SQL SERVER (4), DOS (2), OS/400 (1)

. Languages: JCL / PROC (25); IMS DB / DC / BMP (20); PSB / PCB (20); SQL (16); COBOL II/370/390 (13); COBOL (12); EASYTRIEVE (11); MFS (10); ANSI X12 / EDIFACT (10); ASC X12N (10); JDBC (8); XML (7); APS (6); JAVA / JSP / JAVASCRIPT (6); SHELL SCRIPTS (6); PL/SQL (6); T-SQL (4); BPML (4); SAP IDOC (4); XSLT (4); DHTML (4); CSS (4); VISUAL BASIC (4); APPMASTER BUILDER (3); COMMON INTERFACE MESSAGES (3); ACTIVE SERVER PAGES (2); EDI STANDARD VERSION 30xx / 40xx / 5010 DOCUMENTS: 214-Transportation Carrier Shipment Status Message, 304-Shipping Instructions, 404-Rail Carrier Shipment Information, 410-Rail Carrier Freight Details and Invoice, 417-Rail Carrier Waybill Interchange, 418-Rail Advance Interchange Consist, 753-Transportation Routing Request, 754-Transportation Routing Response, 810-Invoice, 812-Debit/Credit Memo, 820-Payment Remittance Advice, 821-Financial Information Reporting, 824-Application Advice, 826-Debt Authorization, 830-Planning Schedule with Release Capability, 832-Price/Sales Catalog, 834 HIPAA-Benefit Enrollment and Maintenance, 835-Electronic Remittance Advice, 840-Request for Quotation, 843-Response to Request for Quotation, 846-Inventory Inquiry/Advice, 850-Purchase Order, 852-Product Activity, 855-Purchase Order Acknowledgement, 856-Ship Notice/Manifest, 860-Purchase Order Change Request, 861-Receiving Advice / Acceptance Certificate, 862-Shipping Schedule, 864-Text Message, 865-Purchase Order Change Acknowledgement/Request, 997-Functional Acknowledgement

. Utilities: FILE-AID (11), NDM / FTP (9), EVT (9), BTS (7), XPEDITER (6), FTPS / SFTP (6), QMF (5), IBM ADVANTIS (5), GEIS (5), AS2 (4), MOBIUS HASP (3), BORF/ CIPRS/ RCOS/ PICCT (3), BMC (2), OMEGAMON (2)

. Development Tools: TSO/ISPF (25), CA-7 (25), INFOMAN (11), PRODMAN (9), ENDEVOR (7), PANVALET (7), GENTRAN STERLING COMMERCE (7), CHANGEMAN (6), ORACLE JDEVELOPER / SQL DEVELOPER (6), INFORMATICA (5), TRUSTEDLINK ENTERPRISE (4), GPM (4), BP TEXT EDITOR (4), BIDS …SSIS / SSRS / SSAS-OLAP (4), SQL SERVER MANAGEMENT STUDIO (4), MS VISUAL STUDIO (4), J2EE (4), MQ SERIES EAI (4), RUMBA/TPX (3), APACHE TOMCAT SERVER (3), ECLIPSE (3), MICRO FOCUS MFEEE (3), PRISM WAREHOUSE MANAGER (3), COGNOS - IMPROMPTU (3), CRYSTAL REPORTS (3), ACTUATE E.REPORTING (2), MICRO FOCUS SOFT FACTORY - 2000 REVOLVE + 2000 SMARTFIND (2), MOBILE ACCESS SERVICES (2), APACHE STRUTS / SPRING / HIBERNATE (2), WEBSPHERE APPLICATION SERVER (2), SELERIX (2), MAPMATE (1), ROSCOE (1)

. Design Tools: ADOBE …ACROBAT / ILLUSTRATOR / PHOTOSHOP / PAGEMAKER / GOLIVE (18), MS …FRONTPAGE / PUBLISHER (14), VCOM WEB EASY (14), PIXELA IMAGE (9), VISIO PROFESSIONAL (7), CHAMI / COFFEECUP / WEBSTORM HTML / XHTML / CSS EDITOR (4)

. Office Tools: MS…ACCESS / EXCEL / POWERPOINT / WORKS / WORD (18), COREL WORD PERFECT (18), WINZIP (18), MS …OUTLOOK / OFFICE COMMUNICATOR / SCHEDULE+ (14), TEXTPAD (12), NOTEPAD (12), LOTUS …NOTES / SAMETIME CONNECT (12), MS SHAREPOINT (6), FREELANCE GRAPHICS (3), AMIPRO (3)

. Databases/File Types: VSAM (25), IMS (20), DB2 (16), CICS (11), UDB (6), ORACLE (6), SQL SERVER (4)

PROFESSIONAL EXPERIENCE:

05/2010 - Present: iData Corporation, Florham Park, NJ

Position Title: Risk Technical Application Support

Provided consultant services for Bank of America in Charlotte, NC:

. Managed the Operational Credit Exposure application portion of the Check Transformation Infrastructure / Remote Deposits system project, to support the Check Conversion ACH Limit for the Global Portfolio Credit Risk Solutions by …ensuring defined scope is aligned with overall business strategy, creating Business Requirements and Business Process Flow, developing High Level / Low Level Design to enhance affected programs, defining test cases as well as expected results, coding COBOL programs to update the DB2 tables needed via JDBC for the backend Core Java with Spring framework, deploying J2EE applications to Websphere application server. The front end web pages are created in CSS/HTML/JSP/JavaScript with Struts framework.

. For the Portfolio Management applications under the Customer Relationship and Performance department, I have …Extracting IMS data with PowerExchange, sending captured data to PowerCenter for Transformation, Loading the results into MS SQL Server; also designing, generating, and distributing the online as well as the traditional Actuate e.Reports in XML, DHTML, PDF and custom format based on SQL Server database.

Skills: ACTUATE, BMC, OMEGAMON, QMF, SQL, DB2, CICS, IMS, VSAM, XPEDITER, FILE-AID, COBOL 390, EASYTRIEVE PLUS, JCL, PROC, CHANGEMAN, CA-7, NDM, FTP, TSO/ISPF, T-SQL, SQL SERVER 2008, BIDS, SSIS, INFORMATICA 8.6, JDBC, J2EE, JAVA, JAVASCRIPT, JSP, ASP, WEBSPHERE APPLICATION SERVER, STRUTS, SPRING, HIBERNATE, XML, XSLT, CSS, XHTML, MQ SERIES EAI, LOTUS NOTES 8, VB.NET, MS …VISUAL STUDIO / EXCEL / WORD / OUTLOOK / OFFICE COMMUNICATOR, VISIO PROFESSIONAL, MOBILE ACCESS SERVICES, WINDOWS XP

05/2008 - 04/2010: Vector Consulting, Inc. - Duluth, GA

Position Title: EDI Support

Provided consultant services for Aflac in Columbus, GA:

. Creating, mapping, and modifying Case Setup templates … included gapping in JavaScript …to produce Health Insurance Portability and Accountability Act (HIPAA) data in EDI format, XML, Text, CSV files.

. With DB2OLEDB provider, maintained DB2 tables on SQL Server via link connecting to Z/OS.

. Building SSIS packages …to import and integrate DB2/SQL Server database/Access databases/Excel worksheets/Flat files into packages, to perform ETL operations with written custom T-SQL stored procedures.

. Exported SQL Server databases into physical files; converted flat files into 80/132 character files; loaded results in TLE to translate into Benefit Enrollment and Maintenance file in EDI/XML format, via versa.

. Generated ASC X12N version 5010 documents, validated data, and encrypted sensitive information.

. Setting up, scheduling, and transferring files via FTPS / SFTP; as well as sending files via secure mail.

. Researched, presented to the vendors, and implemented …solutions to production / test issues.

. Defining data Cubes using the Unified Dimensional Model (UDM); deploying to process structured Cubes to Analysis Services server for Online Analytical Processing (OLAP) and data mining.

. Created SQL views via SQL Server Management Studio; designed reports via BIDS / MS Visual Studio using data from SQL views and from stored procedures; published reports to Reporting Services server.

Skills: ASC X12N; XML; XSLT; SELERIX; JAVASCRIPT; MQ SERIES EAI; SQL SERVER 2008; BIDS PROJECT - INTEGRATION SERVICES, REPORT SERVER, ANALYSIS SERVICES; T-SQL; DB2; CICS; VB.NET; MS …VISUAL STUDIO, ACCESS, EXCEL, WORD, SHAREPOINT, OUTLOOK, OFFICE COMMUNICATOR; PDF; TEXTPAD; TLE; FTPS / SFTP; WINDOWS XP

11/2004 - 04/2008: CDI Corporation, Charlotte, NC

Position Title: EDI Coordinator Lead

Provided consultant services for Westvaco in Charleston, SC:

. Produced for / acquired from the customers …EDI Implementation Guidelines and Specifications Document.

. Setting up, testing, as well as maintaining …Partnership Profiles, Maps, Tables, Constants, Conditional Codes …in standard version 3010, 3040, 3050, 3060, 3061, 3070, 4010, 4020, and 4030.

. Creating / modifying parameters as needed for Service configurations, Adapters and BPML activities to validate / check in / test / run Business Process.

. Configured JDBC Adapter to select data from as well as modify to DB2 tables.

. Developed COBOL DB2 Stored Procedures to supports the Map to File application area.

. Designed, coded, and tested JCL / COBOL programs; to convert inbound and outbound customer data, to and from standard EDI formats.

. Setting up / executing jobs …to obtain test data then pass to TrustedLink Enterprise by Inovis, and receive data from TLE to Mainframe. This included XML format.

. Monitored download of SAP transactions included translation of EDI data to SAP iDocs and via versa. Unix based system interfaces directly to System/Application/Product via iDocs and STARTRFC (Remote Function Call).

. Reaching out to customers …to test EDI transmissions and to ensure problems as well as inquiries is resolved.

Skills: ANSI X12, EDIFACT, GENTRAN 6.5, STERLING INTEGRATOR (GIS 4.3), FTPS / SFTP, AS2, BPML, GPM, BP TEXT EDITOR, IDOC, XML, INFORMATICA POWERCENTER 8, TLE, TSO/ISPF, ENDEVOR, PANVALET, JCL, PROC, VSAM, IMS, CICS, QMF, DB2, SQL, COBOL 390, JDBC, MS …SHAREPOINT / WORD / EXCEL, LOTUS NOTES 7, WINDOWS XP

02/2002 - 10/2004: First Place / Wachovia, Charlotte, NC

Position Title: Technical Analyst

. Produced the Custodian and Portfolio System’s trade reports for the Corporate and Investment Banking / Treasury Finance BSM Technology Division by …gathering, analyzing, defining Business / Functional requirements, writing Technical specifications, developing Java PL/SQL Stored Procedures with Tomcat servlets to support the back-end J2EE using JDBC for Oracle database connections, creating Crystal Reports. Coded Shell scripts for various build, testing, troubleshoot processes, and system management purposes.

. Enhanced the IMS screens for the Application Handling System of the Retail Lending Technology Division, requested on the Small Business requirements and declining reasons. This included modifying, adding, and unit / system / quality assurance / user acceptance testing in different regions / LPAR …IMS/DB2/CICS programs, copybooks, MFS, IMS control tables, JCL, PROC. I also maintained daily / monthly jobs and CA-7 schedules; plus making sure the users are informed and received the appropriate data.

. Converting APS application to MFEEE for the Service Level/Partnerships Sys of the Share Services department by …identified APS/DB2 components as well as affecting JCL and data sets; altered APS’ data structures, generated COBOL programs, debugged, tested, and verified results in AppMaster Builder PC language using Micro Focus’ Mainframe Express Enterprise Edition tool; implemented; removed obsolete components.

Skills: CRYSTAL REPORTS 10, BORF, CIPRS, RCOS, PICCT, CIM, RUMBA/TPX, TSO/ISPF, NDM, FTP, MOBIUS HASP, CA-7, CHANGEMAN, EASYTRIEVE PLUS, MICRO FOCUS MFEEE, AMB, APS, COBOL 390, JCL, PROC, XPEDITER, FILE-AID, VSAM, IMS, PSB, PCB, MFS, CICS, UDB, DB2, SQL, PL/SQL, ORACLE JDEVELOPER / SQL DEVELOPER, ORACLE 10g, UNIX, SHELL SCRIPTS, JDBC, JSP, JAVA, J2EE, TOMCAT, ECLIPSE, MS …ACCESS / EXCEL / WORD / OUTLOOK, LOTUS …NOTES 6 / SAMETIME CONNECT, NOVELL NETWARE SERVICE, WINDOWS 2000

02/2000 - 01/2002: Maximgroup, Charlotte, NC

Position Title: EDI Technical Lead

Provided consultant services for IBM in Charlotte, NC:

. Lead the interfaces project between Retek Enterprise’s EDI system and EDI transactions to / from JC Penney. This consisted detail analysis of Eckerd’s existing EDI system; gathering and developing Business along with Functional descriptions; creating …External / Internal Design Documents and Functional Test with Validation Approach, Job Flows, File Level / Record Level / Field Level Mapping, as well as programming specifications; pseudo coding copybooks, control cards, data sets, PROC, JCL.

Skills: ANSI X12, EDIFACT, STERLING SOFTWARE - GENTRAN 6.2, GEIS, IBM ADVANTIS, TSO/ISPF, ENDEVOR, CA PANVALET, JCL, PROC, VSAM, IMS, DB2, SQL, COBOL 370, VISIO, HTML, CSS, NOTEPAD, MS WORD / EXCEL, LOTUS NOTES 5, WINDOWS NT

05/1998 - 01/2000: Comprehensive Computer Consulting, Charlotte, NC

Position Title: Senior Mainframe Programmer

Provided consultant services for NationsBank in Charlotte, NC:

. Validated system component operation in a Y2K environment for the Marketing Customer Information File and the Marketing Data Mart applications of the Information Management department by…detail analysis of all product / systems; designing, creating Test Script and Test Plan; testing; ensuring all Y2K dates process properly, result in no unexpected processing impacts, and produce no functionality loses; documenting.

. Maintain the Service Management System / Account Reconciliation Plan applications of the General Banking Support System department by …general analysis; composed Technical Processing Description along with program specifications; coded; tested; scheduled as well as researched on CA-7; provided daily and monthly production support, including fulfilled the user’s requesting tasks.

Skills: MICRO FOCUS SOFT FACTORY - 2000 REVOLVE + 2000 SMARTFIND, XPEDITER, COBOL 370, COBOL II, EASYTRIEVE, SQL, DB2, CICS, VSAM, FILE-AID, JCL, PROC, CHANGEMAN, INFOMAN, CA-7, NDM, FTP, TSO/ISPF, LOTUS NOTES 5, MS EXCEL, MS POWERPOINT, MS WORD, WINDOWS 98

11/1996 - 04/1998: Crown Home Fashions - Charlotte, NC

Position Title: Senior EDI Developer

. Coordinate all EDI transmissions to and from customer sites by …setting up as well as maintained Maps, Partnership Profiles, Envelop Records, and Document records on all CHF customers.

. Converted inbound and outbound customer data, to and from standard EDI formats. This involved designing, coding, setting up, and testing programs as well as JCL job streams.

. Collaborated with the customers to establish Trading Partner Profiles and EDI documents, test EDI transmissions, fix any inbound or outbound problems.

Skills: ANSIX12, EDIFACT, MAPMATE, GEIS, IBM ADVANTIS, SQL, DB2, FILE-AID, VSAM, JCL, PROC, COBOL II, EASYTRIEVE, CA PANVALET, ENDEVOR, CA-7, TSO/ISPF, WINDOWS 95

11/1993 - 10/1996: Contract Data Services, Charlotte, NC

Position Title: Business System Analyst

Provided consultant services for First Union Bank in Charlotte, NC:

. Utilized Prism Warehouse Manager - ETL software for the Finance Re-engineering project: Extract data from the IMS Legacy Systems; Transform IMS Logical File into Oracle; Load Oracle tables to Data Warehouse Unix platform. Shell scripting to set up the system. I also accessed information in the Oracle Data Warehouse Server to create / view reports as well as manipulated report format / actual query on Cognos Impromptu.

. Created interfaces between the EDS card products system and other FUNB applications on the Einstein project. This consisted heavy analysis of existing systems, creating Business along with Functional requirements and specifications, coding, testing, scheduling on CA-7 job flows, documentations.

. Develop enhancements to existing software to improve management visibility of consumer credit status for the Consumer Loan and Collection systems by …designed, coded, tested and implementation.

Skills: PRISM WAREHOUSE MANAGER, COGNOS - IMPROMPTU, SHELL SCRIPTS, UNIX, ORACLE 7, PL/SQL, SQL, DB2, IMS, VSAM, FILE-AID, EASYTRIEVE, COBOL, APS, JCL, PROC, CA-7, NDM, FTP, TSO/ISPF, QUIC, VISIO, FREELANCE GRAPHICS, AMIPRO, WORD PERFECT, MS ACCESS, WINDOWS 3.1

07/1984 - 10/1993: Springs Industries, Inc. - Lancaster, SC

Position Title: Senior Programmer / EDI System Analyst

. Assisted in launching the EDI system by …installing, implementing, and interfacing EDI with the in-house information system; establishing EDI trading relationships with the customers; gathering Business and Functional requirements; setting up Partnership Profiles, Maps, and Tables to identify specific EDI requirements for each customer; designing; coding; testing COBOL programs to convert inbound and outbound customer data, to and from standard EDI formats; creating Job Flows and setting up JCL job streams for EDI transmissions; researching and resolving problems along with inquiries related to transmissions.

. Lead the development of the Product Information system. This was a very large effort that involved analyzing, designing, coding, testing, documentation, implementation of an IMS DB/DC and COBOL based system that housed multiple manufacturing applications. The system had extensive online processing and incorporated BMP as well as batch processing. I also created BTS and call charts for database reviews with the DBA staff.

. Work on enhancements / modifications for the Inventory, the Order Entry, and other manufacturing systems by …coded, tested, implemented affecting components. I developed, maintained, and provided day to day support for various internal applications.

Skills: ANSI X12, EDIFACT, STERLING SOFTWARE - GENTRAN 6.0, GEIS, IBM ADVANTIS, IMS, PSB, PCB, MFS, BTS, BMP, VSAM, JCL, PROC, COBOL, PRODMAN, INFOMAN, CA-7, EVT, TSO/ISPF, ROSCOE, OS / MVS / XA, DOS

EDUCATION:

09/1979 - 05/1982: York Technical College, Rock Hill, SC

. Associate degrees in Business Technology …major in Data Processing, Accounting, and General Business.

Contact this candidate