Business System Analyst Resume Profile
NC
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
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
Confidential
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.
