We provide IT Staff Augmentation Services!

Ibm Sterling Analyst Resume

5.00/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • Over Six plus Years of experience in the analysis, design, development, Client/Server and maintenance of Sterling B2B Integrator and Gentran EDI Applications.
  • Highly experienced in various Business Applications like Automobile, Manufacturing, Healthcare, Retail, Distribution and Shipping & Logistics industry.
  • Good Experience working on Graphical Process Modeler.
  • Expertise in New Trading Partner On - boarding.
  • Highly experience in mapping discussion & implementation of inbound & outbound interfaces of OMS
  • Experienced in custom code in OMS to calculate the charges to enable flat rate charges by category-wise with the option to override the category rate for specific SKUs.
  • Experienced in DOM, Supply Collaboration, Catalog Management and Reverse Logistics platforms.
  • Experienced in designing and implementing IVR (Intelligent Voice Response ) to pull order status by exposing OOB getOrderList API and build custom code for billing zip-code validation.
  • Created & configured of Agent and Integration servers and generated MQ JNDI bindings for Sterling clients to configure with MQ.
  • Expertise in installation of Sterling OMS 9.1, WAS 7, Oracle 11g & MQ servers and applied fix packs.
  • Highly Experienced in handling EDI Production Support on 24/7 basis.
  • Strong Experience in analytical and problem-solving skills for the reported EDI Issues.
  • Experienced in Data Mapping and Data Conversion using Gentran, GIS and SterlingIntegrator tools.
  • Trading partner assessment as well as corporate readiness for EDI production. Industry knowledge sharing to assist in long-term goals.
  • Very proficient with translation tool SI Map editor.
  • Worked with Graphical Process Modeler for designing Business Processes in GIS & SI.
  • Experienced in working with AS2, SFTP, FTP, FTPS, MQ, VAN and Email Services communication protocols.
  • Experienced in integrating SAP IBM SI/GIS.
  • Experienced in various testing phases like Functional, Assembly, Regression and Partner Testing.
  • Worked with Business Process Monitoring in GIS, SI
  • Worked with Scheduling and Performance Tuning of Business processes in GIS/SI.
  • Ability to write complex SQL queries in Oracle, MySQL andIBMDB2.
  • Worked with SAP-ALE Extensions in Gentran Server 6.1.
  • Worked with SAP transactions like WE02, WE05, WE19, WE20, BD87, VD53, ZMNU, VL03N,VF03 and ME23N.
  • Created Partner Profiles in SAP.
  • Worked in Mainframes, for Trading Partner data extraction.
  • Experienced working with File Formats like ANSI X12, EDIFACT, IDOC, CSV, XML, and legacy specified application file formats.
  • Worked with Database mapping in GIS, SI
  • Worked on ANSI X12 EDI transactions like 834, 835, … 855, 856, 810, 820, 816, 860, 865, 945, and 940, 204, 210, 404, 410 among others.
  • Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC, and REMADV among others.
  • Worked with IDOC Structures like ZORDERS, ZORDRSP, ZNVOICE, and ZORDCHG among others.
  • Manages and multi-tasks with little or no direction, while providing technical direction and mentoring to others.
  • Coordinate work for and with other Business Analysts, coordinate Unit Testing tasks, work with Trading Partners for connectivity issues; liaison between customers and corporate staff or between IT and Business Units; perform system matrix testing.
  • Involved in various activities present in project life cycle such as Field usage Analysis, FD walk-through, Map group analysis, Map specification preparation, Map build, Unit testing, AT, FAT, Coordination with Business teams about defects fixing.
  • Experience in Business Analysis to Translate EDI Requirements into Functional Specifications and Develop Logical Mapping for Gentran/GIS - SAP Idocs / Mainframe.
  • Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing. Well versed with EDI and HIPAA transactions.

TECHNICAL SKILLS

EDI Standard: EDI X12(ANSI), EDIFACT, HIPAA, HL-7.

Mapping Tools: Sterling Integrator 5.0/5.2, Gentran 5.1/5.3/6.0/GIS, Sybase EC Map, TLE Server 4.2, and GXS AI Mapper

Operating Systems: Linux UNIX, Windows family.

Databases: Oracle, SQL Server, DB2, MS Access

Application Servers: Gentran Server 5.1/5.3/6.0/6.1 , GIS 4.3, EC Work Bench 5.1, Bizlink 3.2, Sterling Connect Enterprise, EDIFECS, Sterling Integrator 5.0, MoveIt.

Encryption tools: PKI, SSH, PGP, RSA.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

IBM Sterling Analyst

Responsibilities:

  • Gathered all the technical specks for creating the trading partner setup, maps, ftp, As2 connections and verifying with the business.
  • Involved in setting up the SAP Routes and Configuring the PCM for the Inbound and Outbound flow of Data.
  • Developing Data migration services and configurations to migrate existing orders from OMS 9.1 to 9.3 version.
  • Involved in mapping discussion & implementation of inbound & outbound interfaces of OMS
  • Worked with Business analysts, Enterprise architect to understand inventory availability issues in the E-commerce landscape and based on end-to-end analysis presented the Multi-Channel inventory Use Case Document addressing solution for key issues
  • Experience in Sterling OMS 9.3 installation, configuration and setup the product for lifecycle management of orders, inventory and other business dataPerformed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator.
  • Periodic Maintenance of SI Servers - production patching, data back-up, & disk storage clean-up.
  • Created new maps based on the customer’s requirements and setting up the trading partnership configuring sterling commerce AS2 setup.
  • Created maps for transactions like 210,214,810,850,856,860,940,945.
  • Configured adapters, services, service configurations as per business needs.
  • Created and Modified various SQL DB Tables for new Trading Partner set-up, New file movement - modifications to DB table entries.
  • Migrating maps from Gentran unix to S.I. Testing maps with different test data and post production.
  • I have worked on FTP, FTP/S, HTTP/HTTPS, Web services, SFTP/SSH protocols, PGP encryption and mailboxes during B2B integration.
  • Configured new Command Line Adapter to extend business process functionality beyond Sterling B2B Integrator.
  • Required Changes done in existing workflow configuration to handle the new business changes without any impact to the existing process.
  • Have worked with various requirements gathering & analysis.
  • As per business requirements, configured different adapters respective to the requirements.
  • Experience in developing Business process markup language and mapping.
  • Setting up new Trading partner with the company business process.
  • Experienced in Business Process development.
  • Created a different utilities for support team.
  • Experienced in Manage file transfer (MFT).
  • Designed MRS and requirement documents.
  • Developed Mapping & Migration.
  • Upgraded GIS to Sterling Integrator.
  • Participated in partners meetings for understanding the business requirements
  • Create partner using sterling file gateway (SFG).
  • Monitored various processes which include pull and push of files to remote servers. Followed Best practices and suggested improvements in the existing processes.
  • Responsible for Logical implementation, Validation and Verification.
  • Unit testing of maps, BPs.

Environment: IBM Sterling B2B Integrator, Sterling File Gateway, SQL, BPML, XML, XPATH, XSLT, PGP encryption, Protocols (AS2, http, ftp),IBM OMS 9.0.

Confidential, Burlington, NJ

EDI / IT Developer

Responsibilities:

  • Responsible for analyzing, designing, implementing, testing, and maintaining all EDI processes and relationships in the environment.
  • Created new maps based on the customer’s requirements and setting up the trading partnership configuring sterling commerce AS2 setup.
  • Gathered the requirements form GSX about the mapping specs and created the required BDD’s for Inovis maps. Created the as-is trading partner setups in Inovis from GSX.
  • Did the necessary required setup for the partner to partner Van connection in setting up the FTP links. Checking all the process flow from the inbound data received till the load to oracle.
  • Configuring the Data base schema required for the Inovis setup. Setting up the as-is Transformation Profiles in Bizlink from GSX.
  • Setting up the document transformations, endpoints, rule, and start-points in bizlink for all the existing and new partners. Monitoring the failed operation periodically and resolving the issues.
  • Participated in project meetings, provided inputs to project plans and provided status updates.
  • Provided status updates on all assigned tasks using the department's service request tracking tool.
  • Performed analysis, implementation, testing and deployment of all customer integrations.
  • Collected detailed requirements as needed.
  • Utilized various technologies to map and transform transactions in order to be consumed by the client Operation System or electronically communicated back to partners.
  • Worked on Protocols and Technologies utilized by the client includes SQL Scripting, Stored Procedures, Web Services, XML, BizTalk, and FTP
  • Implemented and monitored EDI systems, including data mapping, translation and interfaces.
  • Coordinated relations with and served as a liaison to internal users, vendors and external partners with respect to data interchange standards.
  • Performed EDI system testing and quality control checks.
  • Developed and maintaining EDI documentation.
  • Performed EDI daily support and projects, prototype data transfers using various methods including, but not limited to EDI, SAP IDOCS, XML, AS/2, FTP, SFTP, and general network file transfers.
  • Handled processes, monitored, and exceptions of EDI transactions.
  • Provided resolution, resubmitted and analyzed root cause of EDI rejections.
  • Reviewed and analyzed internal transaction processing information for each transaction.
  • Performed software configuration, tuning, and EDI partner prototyping, setup, development, configured and processed for File transports and format mapping.
  • Analyzed EDI and data integration/transformation requirements from trading partners and developing processes to fulfill these requirements utilizing existing applications, utilities and tool sets
  • Project management/lead of setup and integration with retailers, vendors and other trading partners, including coordinating and meeting with both internal and external resources
  • Working with End Users and other team members to provide production support and issue resolution.
  • Participated in Development of policies and procedures for the EDI department.

Environment: Inovis Bizlink 3.2, SQL, SAP IDOCS, XML, AS/2, FTP, SFTP, UNIX, Biztalk.

Confidential, Hartford, CT

IBM Sterling Analyst

Responsibilities:

  • Gathering all the technical specks for creating the trading partner setup, maps, ftp, As2 connections and verifying with the business.
  • Creating BPML’s in Sterling Integrator 5.0 and monitoring all the jobs and schedules.
  • Setting up trading partners in Sterling file gateway and monitoring the file flow and checking for any ftp, AS2 failures.
  • Managing the file transfer in MyFileGateway.
  • Validating EDI data for compliance failure and notifying the business for any data issues. Setting up the Business Process and configuring the BPML’s. Creating new maps for S.I from scratch.
  • Provided support solution for transaction and connectivity failure, new integration, EDI analysis, investigation and technical documentation of flows.
  • Migrating the AS2 connections from Axway Cyclone to Sterling Integrator 5.0.
  • Migrating all the trading partner setup from EC Gateway to Sterling Integrator 5.0 and checking for the validity of correct setup and trading partner information.
  • Improved existing old maps as per customer requirements and doing a version upgrade.
  • End to end testing and Trading Partner Testing.
  • Performed various troubleshooting whenever defects encounter during OnBoarding.

Environment: SQL, JDBC, SAX, EJB, Gentran on UNIX 5.1/5.3, Solaris, Windows NT, XML, XSLT.

Confidential, Pittsburgh, PA

EDI / IT Developer

Responsibilities:

  • Interviewed users to generate and review business requirements, functional and technical specifications, test plans, test cases, and consolidated project plans.
  • Responsible for analyzing, designing, implementing, testing, and maintaining all EDI processes and relationships in the environment.
  • Created new maps based on the customer’s requirements on the AI and VI mapper and setting up the trading partnership and configuring the data managers.
  • Creating business processes using BPML as per the customer requirements.
  • Created maps for transactions like 180, 278,812, 824,834,937, 844, 845, 846, 849, 850, 852, 856, 864, 867,940,943,944,945 and HIPPA transactions 270,271,834,835,837
  • Created Application’s and Implementation Guides for all transactions and trading partners. Setting up the SAP Routes and Configuring the RFC connections in SAP and testing each connection for connectivity.
  • Configuring the Gentran EC Workbench for Trading Partner Melding process for the Inbound and Outbound flow of data.Setting up the Business Process and configuring the BPML’s.
  • Triggering Idocs using SAP Transactions and testing the flow form SAP to Gentran and then to VAN.Warehouse transactions like 940,943,944 and 945 for UPS.

Environment: UNIX, GIS, SAP 6.0, Gentran, HIPPA transactions, SQL.

Confidential

EDI / IT Developer

Responsibilities:

  • Created and maintained customized mapping specs and provided technical support for all inbound / Outbound B2B transactions / Message Types.
  • Provide L0 Estimates for Trading Partner Setup.
  • Technical Assessment and various Risk factors.
  • Details Design for Map Development and Communication Link Setup.
  • Developed EDI mapping as per specifications of customers and carriers.
  • Developed end-to-end communication link setup.
  • Developed business processes using Gentran Integration Suite 4.3.
  • Performed Unit and Regression Testing.
  • Incident management and Production Support.
  • Guided / trained team on tools and processes.

Environment: Gentran Integration Suite 4.2, GXS AI, MYSQL, Foresight EDISIM, Graphical Process Modular (GPM), NYK internal tools like Pegasus, OSCAR, Gem Stone, QPASA for checking Networks MQ’s and IP’s, MQC (Defect Monitoring), Ultra Edit, Clear Case for creating repository and UNIX

Confidential

IBM Sterling Analyst

Responsibilities:

  • Worked on Project planning and estimation.
  • Planning of migration architecture.
  • Created and performed testing of work flow.
  • Developed and performed testing maps.
  • Acquired good business knowledge, and packaged solution expertise to effectivelyintegrate packaged technology into the client’s business environment in order toachieve client expected business results.
  • Facilitated Integration testing with other modules of the Application to verify the behavior of the entire Application.
  • Performed Regular meetings with business partners, project managers, and vendor partners to determine project scope and vision, set system goals, identified and resolved system issues, and lead prioritization of build items.
  • Assisted in the definition of project objectives, scope, processes, organization, timelines, and overall approaches.
  • Experienced in implementation and integration alternatives.
  • Acted as a contact for the system functionality advice and provide coaching to the client business process team users.
  • Provided general business expertise in OMS processes and workflows incorporating e-commerce and multi channel commerce strategy.
  • Defined system configuration requirements, identify gaps and recommend system modifications and process changes to optimally satisfy business vendors.
  • Documented functional requirements for modifications and support design process for the client
  • Worked with internal development teams to write customer-based functional requirements and support development of new products and technologies.
  • Assisted with driving test plan definition, creation and execution, as well as go-live assessments as needed.
  • Performed Unit Testing and Regression Testing.
  • Handled Sterling B2B Integrator Admin on B2B Framework like creating users and profiles.
  • Worked on EDI - ANSI X12 mapping development/support.

Environment: Gentran Integration Suit SI 5.0, Visual Source Safe (VSS) 6.0, Remedy 7, Sterling Integrator Map Editor 6.1 and 6.2, Windows XP and Unix Sun Solaris 5.9.IBM Sterling Order Management System.

We'd love your feedback!