We provide IT Staff Augmentation Services!

Technical Data Analyst Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

Skills: EDI X12– GIS 4.2,GIS 4.3, Inovis Trusted Link, Gentran Server for Iseries, Contivo 3.9.2.3, Webmethods Developer 6.1, TIE eVison, Visual Basic 5, SILVERRUN(Data Modeling), Turnover, Infinium, Kronos, FTP, E3 AWR/ASR(Store and Warehouse Replenishment) (E3 CRISP(Vendor Managed Inventory), DB2/400, Microsoft Access, TOAD, WinScape, Unix, Ultra- Edit, EDIFECS, SAP IDOCS, XML, DB2/400, SQL, SQL Server, Oracle Developer.

EDI/EAI Technical Training: Sterling Commerce: Fundamentals to GIS, Data Mapping and EDI Processing, Beginning and Advanced EDI for Gentran Server for Iseries, Inovis Trusted Link 2.0, Trailblazers AS2, Liaison: Contivo Mapping.

Industries: CPG, Retail, Vendor Managed Inventory, Home Entertainment, HR, Payroll, Paper Companies, Steel Manufacturing.

Technical Training: IBM: System Administration/Security, Tuning the Iseries, Systems Performance and LPAR for i5. SQL Training Microsoft SQL Server.

Experience:

07/09- Confidential
Technical Data Analyst – Contract

  • Analyze/review standard Wells Fargo customer electronic payments for data validation.(FF, XML, x12 820, Payment IDOC)
  • Validation testing through many tools including manually checking against file specs, file validation tool, webMethods Unix testing running ksh shell script. Log what changes customer must make to correct file and re-test until all rules for all data elements for the payment types are valid. Navigate on Unix to different directories to copy, move and run scripts.
  • Invoke Webmethods Developer packages to deliver file acknowledgements, back end files inUAT, to update flags in different testing scenarios based on electronic payment types.
  • Monitor payment testing and customer setups in Webmethods TN.
  • Researching production support issues for ECS Payment Manager issues.
  • Prepare specifications for custom maps. These are for customer formats that are not the WellsFargo standard types.
  • Review Design Specifications for Standard customers that includes outbound folder, acknowledgment, ACH confirmation naming conventions, Protocol of transmission, If VAN is used,, etc

4/08-2/09 Confidential

  • Migrating Gentran/400 to GIS Windows. Homegrown system to SAP ECC 6.0
  • Support Current Gentran/400 System(X12, EDIFACT maps) and gathering requirements from company end users and outside trading partners.(856,810,830,870,867,855,820,824)
  • Support GIS 4.3 System, troubleshoot Business Processes Models and map issues. Working on GIS Dashboard
  • Make GIS map changes (X12, EDIFACT, XML) Make simple BP changes.
  • Export/Import Business Processes and Maps to production
  • Enable and disable schedules and service configurations.
  • Ensure that invoices are processing through from X12 to SAP IDOCS in GIS. Maintain the invoice code lists in the map.
  • Worked on project that converted COMPORD to X12 EDI for steel manufacturers.
  • Test map changes in development and UAT. Ensure application and EDI data meets the specifications. (GIS and Gentran)
  • Developed and supported AS/400 RPG and CL programs for custom systems.

1/08-4/08 Confidential
EDI Analyst - Contract

  • Worked on contract with GXS. Create specifications in Contivo.
  • Creating map specifications and design documents for offshore team that creates GXS AI maps.
  • Projects worked on are RR Donnelley, Valeo and Qimonda.
  • Interface types: IDOCS, EDI X12, EDIFACT, ODETTE, XML, cXML, xCBL, proprietary flat files, etc.

1/07-12/07 Confidential
Sr. EDI Analyst

  • Design, develop, test new integration maps in Contivo Analyst. Contivo maps run in the Java runtime environment on Webmethods Integration platform on Unix. Run Unix scripts to move maps and other objects between Unix systems on Sun Solaris.
  • Unit Test maps and data in Webmethods Developer, once data is analyzed move to UAT environment. Testing maps through use cases. QA the X12 output data through EDIFECS against the standards.
  • Use TOAD to update Oracle tables for TP relationships and connectivity.
  • Creating maps to convert partners transactions formats to other partners formats(i.e. 850 X12 4010 to IDOC, EMBARC file to X12, XML to papinet, XML to X12 document, etc) Working mostly with paper companies like International Paper, Weyerhaeuser, Georgia Pacific
  • Maps created include(810, 850,852,864, 856,812,816,214,417,301,401,210), Flat file formats(EMBARC, proprietary flat files, SAP IDOC, XML,NAXML, PAPINET, cXML, Involved major product with International Paper SAP(Order to Cash) implementation that involves new map development, QA and modifications of EDI to SAP IDOCS maps(both inbound and outbound). Participate in specification review with IP analysts. Transactions include(ORDERS05,SHIPMENT05, INVOIC02.

4/06-1/07 Confidential, Atlanta, GA
Sr. EDI Analyst

  • RPG and CL development for custom code flow on top of JD Edwards Sales Order.
  • Create EDI maps (810,850,820,856,870,864) in Inovis Trusted Link to process Sales order transactions to JD Edwards(Order to Cash ). Create and Modify Dreamwiter versions.
  • Set up EDI trading partner’s relationships in Inovis Trusted Link. Implement Trailblazers AS2 solution for Home Depot, Lowes to name a few.

10/00-4/06 Confidential, Atlanta, GA
Sr. AS/400 EDI Programmer Analyst

  • Created new custom applications for a Home Entertainment client utilizing RPG IV and CL programming languages. Developed new software for client that was outside of the base package E3 VMR: Cycle count management, trait maintenance, and more sophisticated industry reporting.(Business Warehouse, Top 10 Retailer Sales, etc) Such projects helped MGM with their VMI program.(We Managed the EDI Services for MGM)
  • Implemented and maintained EDI trading partner relationships. Monitored daily transaction flow to make sure any errors, acknowledgments, control number exceptions, etc are corrected in Gentran Server. Utilized the IBM VAN website to resolve any issues with MGM and JDA transactions.
  • Create and updated maps for changes to existing trading partner requirements, these transactions include: 852, 850, 855,861,830 and 856 in Gentran. Set up new trading partners and application definitions and wrote programs to handle to the distribution of orders and flow of On Order, In Transit and On Hand of product.
  • Developed EDI/Supply Chain applications that integrated between the Gentran Server for AS/400 and the E3 VMR, ASR system: Inbound 856 Advance Ship Notice transaction to meet one of our trading partners needs. This transaction included bar coding, which worked in conjunction with the Inbound 861.
  • Lead and implemented many program designs for MGM Europe and Australia EDI expansion. This EDI project included multiple modifications and some new custom programming.(EDIFACT maps in Gentran/400)
  • Designed and written a cross reference system for retailer store change outs for sticker locations for product. Redesigned and coded the Purchase Order Creation (850) process to be more automated for 50 retailers using Gentran.
  • Developed AS/400 applications that automated processes for E3 and MGM Home Entertainment buyers. Applications include: Automation of Business Review Reporting from the manual task of data extraction from different data sources which took 2 or 3 days of work. Automated file loads using a FTP site where users could launch from their desktop without involvement from technical staff. Multiple programs were created for each type of FTP load.

5/99-10/00 Confidential, Atlanta, GA
Sr. AS/400 programmer Analyst

  • Developed, enhanced and fixed programs for Kronos Timekeeping System 8.0 version and Infinium 9.1 HR/Payroll system. Programming done in RPG III, IV/ILE and CL.
  • Development efforts include writing Kronos interfaces to AS/CORE business system and interfaces that receive data from AS/CORE system. Wrote a remote time punch system that uploaded employee master data, pulled time punches and created a punch activity report from UNIX box to AS/400 via FTP.
  • Developed applications that are used for supporting fixes. Such activities in the past were manual became automated process with creation of new programs. Created queries for ad-hoc reporting and problem analysis.
  • Implemented Kronos 7.4 Timekeeper software to Kronos 8.0 version. This project entailed making custom changes, extensive user testing, Y2K changes and data conversion.
  • Re-wrote Query program used by Canadian users in RPGIV and embedded dynamic SQL. In the past 300 + queries were updated with a date when they needed to be ran manually. Wrote a simple front end where the user could submit the queries with minimal effort and with more automation.
  • Maintained and fixed application code per user request or production problem resolution. Tested and debugged changes and documented them for supporting the payroll system. Tools used for change management Turnover and Remedy.
  • Participated in the weekly 24 x 7 support

1/95-5/99 Confidential, St. Louis, MO
AS/400 Programmer Analyst

  • Developed and maintained subfile /menu interactive and various batch applications for Rental Car operations using RPG IV and CL.
  • Converted IBM AS/400 sysout print applications to Xerox multi-logical page formats with various fonts using Xerox DJDE control written RPG IV and CL. Utilized the XDPE/400 proprietary package by Xerox in conjunction with AS/400 spool files to set up environment for different form overlays.
  • Analyzed support desk tickets, wrote specifications for programmers for fixes. Involved in medium scale projects such as: modifications to all programs that needed removal of a de-normalized ERAC reservation file to be replaced by new normalized child files. ERAC employee number that was required to be alpha instead of numeric resulted in many modifications / testing of many applications. Creating use case tests for all new programs and changes for RPG programs.
  • Participated in full life cycle development on various projects using the Navigator Customer Development Route Map Methodology. Analyzed and designed a new logical/physical database model for the large scale Rental Re-write Project.
  • Projects involving analysis of Rental database subject areas, Print Distribution System and UK & Ireland forms conversions.
  • Created Microsoft Access Tool for Rental Redesign that captured current state and future state data and process objects for reconciliation and gap analysis. This tool was created using Visual Basic, SQL and DAO.

Printer Operator

  • Print reports and forms for Enterprise Rent-A-Car. Maintain output queues and spool files on different machines to ensure proper distribution.
  • Performed file restores per programmer requests. Copy files to a tape for outsource clients. Created simple CL programs for automating operations tasks.
  • Utilized Broderick Spool Organizer/400 for sending reports to users on other machines and setting up exceptions for distributed printing for EOM.

Education:

Intro to Computer Science: Programming Logic, C, CL/400, Visual Basic 5

We'd love your feedback!