Technical Business Analyst/Project Manager

Bobbie Shetrone Vails

PROFESSIONAL SUMMARY

I have over 20 years of solid Information Technology background in the

Retail, Manufacturing, Textile, Insurance, Pharmaceutical, and Financial

industries ...with specific knowledge of Benefit Enrollment & Maintenance,

Workforce Management, Order Entry, Product Information, Merchandising,

Promotion, Deals, Forecast, Allocation, Inventory, Supply-Chain, Import

Distribution, Data Warehouse, Marketing Data Mart / Customer Information

File, Consumer / Commercial Loan, Retail Lending, Application Handling,

Service Level / Partnerships, Collection, Card Products, Credit Exposure /

Global Portfolio Credit Risk Solutions, Portfolio / Finance Balance Sheet

Management, Corporate & Investment / General Banking, Account

Reconciliation Plan applications. Strong development experienced in full

cycle of researching, analysis, designing, creating BRD/specifications,

coding, debugging, unit/system/QA/UA testing, documentation,

implementation, as well as providing production support. Expertise in EDI;

multiple file transfer protocols of AS2, HTTPS, FTP with PGP Encryption,

FTP over SSL, SSH FTP; integration services of IBM Portfolio, AppWorx,

Informatica, SOA; ORACLE; DB2; IMS; CICS; VSAM; JCL/PROC; COBOL; APS/AMB;

EASYTRIEVE; XML; JAVA; SQL; CRYSTAL REPORTS; SHAREPOINT.

CORE COMPETENCIES (in number of year's experience)

Operating Sys OS / MVS / XA (26), WINDOWS ...7 / XP / 2000 / ME / 98 /

95 / 3.1 / NT (20), CISCO (10), NOVELL NETWARE (10), UNIX (8),

LINUX (3), DOS (2), OS/400 (2)

Languages VSAM (26); JCL/PROC (26); COBOL (26); SQL (20); IMS DB/DC/BMP

(18); PSB/PCB/MFS (18); EASYTRIEVE (13); ANSI X12 / EDIFACT /

ASC X12N (11); SHELL SCRIPTS (8); PL/SQL (8); XML(7); JDBC(6);

BPML(6); APS(6); JAVASCRIPT / JSP / JAVA(5); HTML/CSS(4);

CIM/AMB(3); XSLT (3); SAP IDOC (2); ACTIVE SERVER PAGES (2);

VISUAL BASIC (1); T-SQL (1); EDI VERSION

30xx/40xx/5010 DOCUMENTS: 204, 214, 216, 304, 315, 404, 410,

417, 418, 753, 754, 810, 812, 820, 821, 824, 826, 830, 832, 834

HIPAA, 835, 840, 843, 846, 850, 852, 855, 856, 860, 861, 862,

864, 865, 940, 944, 945, 947, 990, 997

Utilities FTP/FILE-AID(16), VAN/NDM(11), BTS/XPEDITER(8),

GEIS/ADVANTIS(6), FTPS/SFTPS(5), AS2/HTTPS(4), FSA/SQL

*PLUS/QMF/BORF/CIPRS/RCOS/PICCT(3), BMC/OMEGAMON(2)

Dev Tools TSO/ISPF(26), CA7(26), INFOMAN/PRODMAN(13), GENTRAN/STERLING

COMMERCE(11), CHANGEMAN(8), TLE/INFORMATICA(6),

ENDEVOR/PANVALET(6), BP TEXT EDITOR(6), GPM(6), MS SQL

SERVER(6), CRYSTAL REPORTS(5), J2EE(4), MQ SERIES EAI(3),

PRISM(3), ORACLE SERVICE BUS/ JDEVELOPER/ WEBLOGIC SERVER -

OEPE/ SOA COMPOSER(3), SQL DEVELOPER/ECLIPSE/TOMCAT(3), FILE

GATEWAY/APPWORX(3), RUMBA/TPX(3), COGNOS/MFEEE/REVOLVE(3),

ACTUATE/MAPMATE(2), MOBILE ACCESS SERVICES(2), WEBSPHERE

APPLICATION SERVER(2), STRUTS / SPRING / HIBERNATE(2),

ROSCOE(2), BIDS ...SSIS / SSRS / SSAS-OLAP(1), SQL SERVER MGMT

STUDIO / MS VISUAL STUDIO(1)

Office Tools ACCESS/EXCEL/POWERPIVOT/POWERPOINT/WORD(20), WEBSTRM HTML

EDITOR(12) WINZIP(12),

ADOBE..ACROBAT/ILLUSTRATOR/PHOTOSHOP/PAGEMAKER/GOLIVE(12)

PROJECT/SHAREPOINT/INFOPATH/VISIO/ONENOTE(10),

LOTUSNOTES/SAMETIME(9) MS ...OUTLOOK/OFFICE

COMMUNICATOR/SCHEDULE+/FRONTPAGE/PUBLISHER(8)

Databases IMS (18), DB2 (15), CICS (10), ORACLE (8), UDB (7)

PM Courses TSE015- PMP &CAPM Exam Preparation Workshop, Project Risk

Management, TSE037- Project Cost Management Workshop, TSE007-

Using MS Project, TSE001- Project Planning and Control, TSE0036-

Managing Agile Projects Workshop, TSE011- Determining Business

Requirements Workshop

PROFESSIONAL EXPERIENCE

Company Family Dollar - Matthews, NC

12/2011 - Present

Position Title Technical Business Analyst/Project Manager

Skills PGP; FTP; FTPS; SFTP; FSA; HTTPS; AS2; VAN; GENTRAN INTEGRATION

SUITE 4.3; STERLING ...INTEGRATOR 5.1, GRAPHIC PROCESS

MODELER, BUSINESS PROCESS, COMMERCE MAP EDITOR, COMMERCE

QUEUE WATCHER, CONTROL CENTER, FILE GATEWAY 1.1/MY FILE

GATEWAY; ORACLE ...11i, R12, APPLICATION DEVELOPMENT

FRAMEWORK, ENTERPRISE PACK FOR ECLIPSE, SERVICE BUS,

COHERENCE; SOA SUITE; SOA COMPOSER; WEBLOGIC SERVER WITH

OEPE 10.3.6; JDEVELOPER; INFORMATICA POWERCENTER 9.5.1;

APPWORX APPLICATIONS MANAGER; SQL SERVER 2008; SQL *PLUS;

PL/SQL SCRIPTS; LINUX; UNIX; UNIX COMMANDS; SHELL SCRIPTS;

XML; KRONOS V7; CRYSTAL REPORTS 2008; ULTRAEDIT; FILEZILLA

FTP CLIENT; NUANCE PDF CONVERTER ENTERPRISE; ADOBE ACROBAT

X; GLOCK; BOX; HIGHTAIL(YOU SEND IT); MS 2010 ...PROJECT,

SHAREPOINT, VISIO, ACCESS, INFOPATH, EXCEL, POWERPIVOT,

POWERPOINT, ONENOTE, WORD, OUTLOOK; WINDOWS 7

> Managed all development on Sterling, including EDI as well as file

transferring for major projects such as ...FTP to SFTP, Automation and

Cloud Hosting - Kronos Private Cloud, Integrated Purchasing and Order

Management with Inventory Receipts and Accounts Payable for non-

Merchandise Goods, Re-implementing Oracle E-Business Suite application

from version 11i to R12, Unix to Linux Conversion, Automate and

Visibility of Global Sourcing shipments utilizing Oracle

Transportation Management and Warehouse Management System - store

Goods from an overseas supplier to Import Distribution Center /

transfer to Distribution Center / sent to Stores, Enhancements to

Vendor Managed Inventory to accommodate the 11th Distribution Center,

Onboarding 3rd Party Logistics Partner, Transitioning Gentran

Integration Suite for Unix to Sterling Integrator for Windows, and

Forecasting/Promotions/Deals/Allocations/New Stores on Retek

Merchandising Systems.

> Served as subject-matter expert letting the stakeholders know what

Sterling could do to contribute to meet the organization's business

needs; collected requirements related to the product scope; defined

Sterling's project scope and deliverables; identified, analyzed,

planned (response), monitored, and controlled risks.

> Determined resources and hours needed to meet Sterling's deliverables;

defined, created, and submitted the estimated resources as well as

hours needed for approval.

> Assisted with the Business Requirement Documents and ensured

appropriate forms were completed; reviewed high level requirements and

collaborated on the data integration process design which included

Informatica, Concurrent Manager or ONE automation (AppWorx), SOA, as

well as Sterling; exchanged credentials for connection set up to

transmit and pick up data utilizing IBM Sterling Application Portfolio

with secure transfer protocols of AS2, HTTPS, FTP with PGP Encryption,

FTPS (FTP over SSL), SFTP (SSH FTP), FSA (File System Adapters);

created and provided detailed requirements, specifications,

implementation guidelines as needed; assigned tasks to the appropriate

Sterling team members with instructions and scope as well as project

objectives; planned; coordinated communication, construction, test,

implementation, and transition.

> Created and published, as a B2B/ICC SharePoint site owner...Key

Performance Indicator Metrics and Trend pages for tracking performance

on EDI as well as file transfers utilizing PowerPivot workbooks;

Knowledge Base library to share SOA/Informatica/Automation

(AppWorx)/Sterling's architecture, governance documents, process

documentation, training, and related historical information; Managed

File Transfer pages for non-EDI data movement with links to libraries

of existing inbound/outbound/internal mailboxes and online InfoPath

forms to be completed for new file transfer requests; Mapping Guides

library containing implementation guidelines, specifications, and

their corresponding Field Level mappings, as well as links to Family

Dollar's EDI web page; Projects library with links to MS

Project/Requirement Traceability Matrix list and sub-project libraries

to communicate the status of ongoing projects development, deployment,

go-live, stabilization, and transition; Sub-project libraries to

provide documentation for knowledge transfer, to inform the cutover

plan and transition support checklist, and to track issues for Risk

assessment.

> Point of contact for account requests to send large files or emails

with large distribution list ...Hightail (You Send It), Box, and

Glock.

Company Vector Consulting, Inc. - Duluth, GA

12/2010 - 11/2011

Client Aflac in Columbus, GA

Position Title Business Analyst

Skills ASC X12N; XML; XSLT; SELERIX; JAVASCRIPT; MQ SERIES EAI; SQL

SERVER 2008; BIDS PROJECT - INTEGRATION SERVICES, REPORT

SERVER, ANALYSIS SERVICES; T-SQL; DB2; UDB; CICS; VB.NET;

VISUAL STUDIO; TLE; HTTPS; FTPS; SFTP; MS

...SHAREPOINT, EXCEL, WORD, ACCESS, OUTLOOK, OFFICE

COMMUNICATOR; ADOBE ACROBAT; TEXTPAD; WINDOWS XP

> 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.

Company iData Corporation - Florham Park, NJ

05/2009 - 10/2010

Client Bank of America in Charlotte, NC

Position Title Risk Technical Application Support

Skills ACTUATE, BMC, OMEGAMON, QMF, SQL, DB2, UDB, CICS, IMS, VSAM,

XPEDITER, FILE-AID, COBOL 390, EASYTRIEVE PLUS, JCL, PROC,

CHANGEMAN, CA-7, NDM, FTP, TSO/ISPF, INFORMATICA PWX 8.6,

JDBC, J2EE, JAVA, JAVASCRIPT, JSP, ASP, WEBSPHERE

APPLICATION SERVER, STRUTS, SPRING, HIBERNATE, XML, XSLT,

CSS, XHTML, MQ SERIES EAI, LOTUS NOTES 8, MS ...EXCEL / WORD

/ OUTLOOK / OFFICE COMMUNICATOR, VISIO PRO, MOBILE ACCESS

SERVICES, WINDOWS XP

> 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.

> Migrating hierarchical IMS DB to relational DB2 as well as from IMS DC

to CICS for the Telephone Banking project, of the Portfolio Management

applications under the Customer Relationship and Performance

department by ...analyzed; documented; coded; unit / system / Quality

Assurance / User Acceptance tested; and implemented the affecting

components. Designing, generating, and distributing the online as

well as the traditional Actuate e.Reports in XML, DHTML, PDF and

custom format based on DB2.

Company JLS Technical Staffing, Raleigh, NC

08/2007 - 04/2009

Client Westvaco in Charleston, SC

Position Title EDI Coordinator Lead

Skills ANSI X12, EDIFACT, GENTRAN 6.5, STERLING INTEGRATOR (GIS 5.1),

FTPS/SFTP, AS2, BPML, GPM, BP TEXT EDITOR, IDOC, XML,

INFORMATICA POWERCENTER 8.5 TLE, TSO/ISPF, ENDEVOR,

PANVALET, JCL, PROC, VSAM, IMS, CICS, QMF, DB2, SQL COBOL

390, JDBC, SHAREPOINT, WORD, EXCEL, LOTUS NOTES 8, WINDOWS

XP

> Produced for / acquired from the customers ...EDI Implementation

Guidelines and Specifications Document.

> Upgraded EDI transaction sets from version 4010 to compliance 5010

standards.

> 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.

> Reaching out to customers ...to test EDI transmissions and to ensure

problems as well as inquiries is resolved.

Company First Place - Charlotte, NC

10/2004 - 07/2007

Client Wachovia in Charlotte, NC

Position Title Technical Analyst

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

> 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.

Company Maximgroup - Charlotte, NC

10/2002 - 09/2004

Client IBM in Charlotte, NC

Position Title EDI Technical Lead

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

> 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.

Company Crown Home Fashions

07/2000 - 07/2002

Position Title Senior EDI Developer

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 98

> 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.

Company Comprehensive Computer Consulting - Charlotte, NC

03/1997 - 06/2000

Client NationsBank in Charlotte, NC

Position Title Senior Mainframe Programmer

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 95

> 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.

Company Contract Data Services - Charlotte, NC

05/1994 - 02/1997

Client First Union Bank in Charlotte, NC

Position Title Business System Analyst

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

> 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.

Company Springs Industries, Inc. - Lancaster, SC

10/1984 - 04/1994

Position Title Senior Programmer / EDI System Analyst

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

> 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.

EDUCATION

Winthrop University - Rock Hill, SC

09/1981 - 05/1984

Bachelor of Business Administration (BBA) ...major in Accounting and

Business/Management.

York Technical College - Rock Hill, SC

09/1979 - 05/1981

Associate degrees in Business Technology ...major in Data Processing,

Accounting, and General Business.

Contact this candidate