Ravindra Mallavarapu

Contact Number

708-***-****

Alternate Contact Number

708-***-****

Current location of the candidate (City/State)

Chicago/IL

Email Address

ac1toq@r.postjobfree.com

Skype ID

ravindra290

Professional Summary

To pursue a challenging career as a techno functional software professional. That allows me to utilize my skills and growing my career with innovative approaches and creative thoughts to work on cutting edge technology.

Summary:

B2B/EDI Developer/Analyst with 12+ years of experience; extensively worked on IBM Sterling B2B Integrator V5.2.5/6.3& ITXA 9.0.0.5, SFG, ECMAP,Biztalk,Extol. Domain knowledge in Health Care Retail, Manufacturing, SCM (Supply chain Management/ Logistics, Distribution). Expert in all aspects of the entire B2B and EDI life cycle.

Expert on Sterling Integrator Mapping using sterling map editor and Business Process creation using Sterling GPM & BPML.

Expertise the knowledge in Sterling Integrator (SI) Business Process (BP) Development to incorporate business flow through SI along with ITXA integration with SI.

Developed the ITXA(WTX) Maps,Type tree,Codlist and Deployments in SPE UI.

Certified AHM250 Professional (US Health plan fundamentals).

Worked on Health Insurance Exchange from Provider to State Exchanges (Inbound/Outbound Transactions).

Expert of CPT, HCPCS code sets and ICD-9, ICD10 codes AND Implemented ICD-10 Code sets in HIPAA 5010 New version.

Worked in the entire life cycle of projects: Requirements gathering, design, develop maps, business process building, testing & production roll-outs.

Designed, Developed & implemented end-to-end process of entire Inbound & Outbound process.

Proficient in creation AS2 partner setups and configurations customize services & adapters.

Proficient in creating Envelops and code lists table setups.

Exposure to sterling control centre and AFT and MFT.

Integrated SAP R/3, SAP Business connector with B2B-EDI gateway.

Integrated & Translated EDI to SAP-iDocs, XMLs, Flat files & CSV and vice versa.

Experienced in EDI Inbound & Outbound document standards such as ANSI X12, EDIFACT, XML, ebXML.

worked on FTP, FTP/S,HTTP/HTTPS, Web services,SFTP/SSH protocols, PGP encryption and mailboxes during B2B integration

Worked on EDI documents X12- 834,837,835,850, 855, 856, 810, 820, 824, 997, 990, 204, 214, 210, 315 & EDIFACT-ORDERS, ORDRSP, DESADV, INVOIC & CONTRL.

Worked on services and adapters like - HTTP/S, FTP/S, FSA, JDBC, and SAP R/3.

Prepared the Gap Analysis 4010 to 5010 for EDI Transactions and Involved in all the levels

Excellent in setting up Business Process schedules to automate the translation & transmission of documents.

Expert in on-boarding new trading partners and integration testing with end-to-end scenarios by creating test cases based on business requirements.

Strong in debugging, troubleshooting and problem solving skills.

Good programming skills in AS/400 environment by using RPG/400, RPGIV, CL/400.

Expertise in Preparing Documentation in various areas like technical & functional areas.

Can work in demanding time schedules, have good communication skills and attitude towards teamwork.

Worked in production environment resolving production issues with less resolution time

SKILLS SUMMARY:

EDI Tools

IBM Sterling Integrator V5.2,5.2.6.3 / ITXA 9.0.0.5, Sterling File Gateway2.2.6.3,EDI Notepad, Ultra edit, SAP R/3 & RFC Adapters.

Mapping & Business Process

IBM Sterling Map Editor and Sterling GPM (Graphical Process Modeller), SPE/ITXA Process Services,WTX,Gentran 6.5- AI & VI Mapping.

Protocols

VAN: Sterling, GXS, IDX, EDIINT: AS1,AS2,AS3 & ebXML Secure: FTP, SFTP, HTTPS, SSH & SSL, Sterling Direct Connect.

Domain

Windows Server 2012, Unix (HP & AIX) and IBM Mainframe, iSeries, Cluster, DMZ, Perimeter, SAP.

Languages

BPML(Business Process Modeling Language), XML,XSLT, ebXML, Java & SQL, RPG/400, RPGIV, COBOL/400, CL/400

Data Base

Oracle 10g, 11g, 9i,SQL Server 2012/2008, DB2/400

Data Formats

ANSI X12, EDIFACT, SAP iDocs, XML/ebXML, CSV & Flat files.

EDUCATION

Master of Computer Applications (MCA)from Madurai Kamaraj University in 2003

Bachelor of Commerce (B.COM)from Andhra University in 1999

PROJECTS

Project#1

Client/Location:CVS Health (Buffalo Grove/IL)

Role/Period: Sr B2B Developer / Jan 2017 – Till Date.

Environment: IBM Sterling Integrator 5.2.6.3, ITXA 9.0.0.5, Sterling FileGateway 2.2.6.3, Sterling Control Ceneter 6.1.0.1,BPML, SPE services, MapEditor, File Zilla, UNIX(AIX), Ultra Edit, SQL developer

Transactions: X12: 834,837,835,850,856,SAP-iDocs, XML, CSV & Flat files.

CVS Health IBM Sterling Integrator ITXA Upgrade

CVS Caremark provides comprehensive prescription benefit management services including mail order pharmacy services, specialty pharmacy and infusion services, plan design and administration, formulary management and claims processing. The company’s clients are primarily employers, insurance companies, unions, government employee groups, health plans, Managed Medicaid plans and other sponsors of health benefit plans and individuals throughout the United States. CVS Caremark manages the dispensing of prescription drugs for more than 75 million plan members. through five mail order pharmacies, specialty pharmacies, long-term care pharmacies and national network of more than 68,000 retail pharmacies, consisting of approximately 41,000 chain pharmacies and 27,000 independent pharmacies.

IBM Sterling Integrator is B2B hub for data translation and transmission in CVS health.This project was principally conceptualized based on requirement/s to add additional capabilities and features to the current Sterling Integrator solution. To add new capabilities and features, there is a requirement to upgrade the current Sterling Integrator to v5.2.6.3 and Control Center to v6.1.0.1.

Responsibilities:

Analysis of current business process for all the business type scenarios Like single and dual translation

Gathered all the requirements and prepared the check list document before ITXA up gradationSI 5.2.5 to 5.2.6.3.

Created the current work flow Visio diagrams for all business scenarios

Designed the future ITXA work flows and ArchitectureDesign Document.

Performed Built test for new version of SI 5.2.6.3

Created SFG partners, Channels, Templates.Implemented mailbox and SFTP/FTPS file transfers,Custom Protocols on SFG.

Configured Protocols AS2,Conect Direct,SFTP,FTP,MQ and tested for new SI 5.2.6.3

Configured all the service and Adapters like FSA,LWJDBC,SAP suite adapter.

Extensive use of SFTP, FTP, HTTP, Mailbox, File system,Web services,Command Line, JDBC, SOAP, Translation and system Adapters

Developed the ITXA business process on SI environment by using SPE

Deployed the ITXA business process in to SI environment

Developed the ITX Inbound/Outbound maps for EDI X12(834,837) and Flatfile scenarios and deployed in to SPE UI

Created type trees based on SI specs

Created Code lists and Envelops in SPE trading partner environment.

Did Unit testing for all the SI and ITXA work flows

Provided support for Performance Tuning and Volume test.

Project#2

Client/Location: Penguin Random House/Remote

Role/Period: Sr B2B Developer / Jan 2016 to Dec2016.

Environment:IBM Transformation Extender Advance (ITXA 9.0),Design studio,

Sterling Filegateway, Sterling Integrator 5.2, Windows 2012 R2 Server,

SAP.

Transactions:X12:850,856,810,810,820,997,214,210,240,309,355,315,350,990&204toSAP- iDocs,CSV& Flat files.

EDIFACT: ORDERS, ORDRSP, DESADV, INVOIC, and CONTROL to iDocs.

Penguin Random House (PRH)

Penguin Random House (PRH) is a company formed by the merger of book publishers Random House (owned by German media conglomerate Bertelsmann), and Penguin Group (owned by British publishing company Pearson PLC). Penguin Random House markets itself as "the world's first truly global trade book" publisher.

Responsibilities:

Mange ALL EDI related activities/tasks including Development, Design and requirements.

Design and development of business processes to meet business requirements - BPML code development along with SPE Transformation Services implementation in the BP in Sterling Integrator (SI) in order to perform WTX translation inside SI as a part of ITXA integration with SI.

Configured adapters, services, service configurations as per business needs.

Developed new SFTP and FTPS business process By using JDBC Adapter to retrieve credentials from the backend DB2 database and feed it into the process data.

Study and analyze existing production business processes - troubleshoot business process and make suitable changes to incorporate new business needs/requirements

Changes to existing workflow configuration to handle the new business changes without any impact to the existing process.

Establishing new AS2 setup.

Support EDI for three internal business divisions

Designing MRS and requirement documents

Developed and Integrated SAP (iDoc), XMLs, and CSV with Sterling Integrator and automated process with Sterling Business Process modeling and vice versa.

Developed EDIFACT transactions such as ORDERS, ORDRSP, DESADV, INVOIC, and CONTROL to iDocs.

Developed X12 transactions 210, 211, 810, 812, 820, 824, 830, 850, 852, 855, 856, 860, 864, 875, 880, and 997.

Involved extensively in Implementing QA, Testing, Verification and Validation to ensure compliance with business needs

Interacted with clients, Trading partners and SME’s on a daily basis to gather the product requirements.

Coordinate with Internal customers for Input and Output files for testing purpose.

Follow best practices in the form of coding while developing the map as well as while generating the specification.

Production Map changes to comply EDI document standard and company proprietary standard.

New Trading Partner On boarding By using SPE Trading Partner UI(ITXA)

Project#3

Client/Location : True Value/Chicago, IL

Role/Period : EDI Programmer Analyst / Jan 2014 – Dec 2015

Environment : Sterling B2B Integrator 5.2, Sterling Map Editor & Sterling GPM, EDISIM,

Ultra-edit, UNIX, Oracle 10g and SAP OMS, Sterling VAN.

Transactions : X12: 850,856,810,810,820,997,214,210,240,309,355,315,350,990 & 204

EDIFACT: ORDERS, ORDRSP, DESADV, INVOIC, PAYMUL, BANSTA, XML, CSV & Flat files

Responsibilities:

Gathered requirements from application systems and analysed the raw data (application format) and prepared the field specification sheet for raw data to EDI and XML conversion format.

Developed the New iDoc to EDI maps for CDW and CDI Systems.

Integrated the file transfers between Target and its business partners with SI 5.2 B2B gateways.

Integrated the internal and external trading partner systems for both Inbound and Outbound XML and Flat files transactions.

Setup AS2 trading partner setups and configurations with external vendors.

Designed the flow for A2A integration (Mapping & Business Process).

Created and Automated the business process with services and adapters such as FSA, HTTP/HTTPS, FTP/FTPS, SMTP, FSA, JDBC, ebXML, SAP, MQ etc.

Collaborated with Users and Clients, to develop standard specifications for maps.

Worked with SAP (FICO Finance, MM/SD-Manufacturing, Worked on EDI<->SAP iDocs layout changes and functional and integration testing.

Developed and worked on X12 maps 850, 856, 810, 810, 820 & 997.

Created Business Processes and automated the Translation, FTP and AS2

Reengineered SAP/EDI Inbound/Outbound via vendor exist and enhancement in mapping.

Worked on map changes for both Inbound and Outbound transactions.

Involved in mocked integration testing and partner testing.

Development maps of Outbound EDI 204, and Inbound 990, 214 to XMLs to/from 3PLs.

Developed and delivered the objects as per project time lines.

Involved in FIT-Functional Integration Testing with 3PL Logistics partners & Manugstics.

Performed data validation and worked on data defects and bug fixes.

Defects were fixed on time and reported to HP Quality Center.

Implemented the project without any issues and no defects identified in production.

Project#4

Client/Location : Jarden/Aurora,IL

Role/Period : SI-GIS EDI Consultant / Jul 2012 – Dec 2013

Environment : Sterling Integrator 5.0/ Gentran Integration Suite 4.3, Sterling Map Editor & Sterling GPM, UNIX, Oracle 10g, Oracle eBIS, VAN,JBA

Transactions : X12 : 850, 855, 810, 856, 820, 824 & 997,SAP-iDocs, CSV & Flat files.

Responsibilities:

Developed Map’s EDI: Positional to EDI: X12.

850 and 830 Outbound (Positional to X12) B2Bi Trading Partners

Coordination with application teams in case of any data changes and incorporate the changes in the Map or Business Process.

Responsible for all Latin American Jarden EDI integrations,including project planning, design

Development and testing/Deployment.

Interact with the Latin American Jarden EDI clients on daily basis for Requirements.

Designed and developed the Business Process for End – End flow (Involved many services and Adapters like FTP Client Services, HTTP Client Services, and JDBC, SMTP, and FSA)

Setup AS2 trading partner setups and configurations.

For map development purpose prepared paper map specification by integrating source and destination data layouts and fields.

Gathered Requirements for each EDI transactions and prepared application file format layout document and created the business process logic rules.

Interact with the clients on daily basis for project status.

Created Functional and Technical specifications and Mapping specifications.

Involved in preparing High Level Design Document and Low Level Design Document and the technical specifications for the Service Requests.

Involved in Unit Testing and System testing the modified code. Involved in preparing the test plans and the test results for the modified code. User Acceptance Testing and the Implementation.

Had the responsibility of delivering the problem tickets / Service Requests adhering to quality standards and with-in the estimated time. Also, has been responsible for managing and tracking the application problems.

Involved in the preparation of the application components for promotion of code into production environment.

Involved in giving the on-call production support for the application, fixing the abends occurred in the production environment.

Project#5

Client/Location : DST Heath Solution, Birmingham, AL

Role/Period : Senior Software Engineer (EDI Developer/Analyst)/ July 2010 - Jun 2012

Environment : ECMAP, EC Gateway, Foresight EDISIM, IBM InfoSphere DataStage 8.1, Visual Basic 6,SQL, X12,Flat files, XML,CSV, SQL Server 2005,Oracle9i, Windows/XP,UNIX

Transactions : Health Care (HIP)

Description:

The Electronic Commerce Module – Advanced (ECMA) is an add-on product that customers can purchase to install in their environment and will be used by DST Health Solutions Business Process Outsourcing (BPO) environment to facilitate integration with an EDI layer that accepts inbound data from outside customers/partners and translates and stores data into a simplified, product neutral and business friendly format and vice versa for outbound data.

Responsibilities

Worked on following map development using the Sybase –ECMAP, EC Gateway

HIP 5010 837P Inbound

HIP 5010 837P Outbound

HIP 5010 837D Inbound

HIP 5010 820 Inbound map

HIP 5010 837I Outbound

HIP 4010 837DI Inbound map

HIP 4010 837DO outbound map

HIP 5010 278I inbound Maps

Developing the 997 and 999 Acknowledgement maps for the 4010/5010

Translate the ANCX12 maps to XML format in Inbound scenarios

Manual testing with test files

Testing the map logic in development environment

Configuring developed maps to Trading Partners

Moving the tested maps to Production servers

Resolve issues that stop automation process

Deploying the EDI jobs across the platform – Dev, QA and PROD.

Had good touch with issue tracking tool QC(Quality Center)

Involved in daily status call with onsite and allocating the work to the team members.

Involved in Quality Process – Project Presentations to the High Level management on monthly basis.

Involved in creating the tasks on Clarity for Team Members and maintaining the same

Project#6

Client/Location : DST Heath Solution, Birmingham, AL

Role/Period : Senior Software Engineer (EDI Developer/Analyst)/ May 2009 - Jun 2010

Environment : EXTOL, EDISIM, Cobol/400, RPGIV, CL/400, OS/400, DB2/400,

I Series(AS/400)

Transactions : 5010 Migration for MHS and STEPP products

Description:

This is a migration project from HIPAA 4010 to 5010 version for all customers dealing with Health care transactions. The maps developed in 4010 are migrated to 5010, as a part of this, preparation of gap analysis documents, bringing up changes in specifications and mapping them to standards are taken up. The EDI for the products MHS and Oversteps in AS/400 environment are migrated to 5010 using Extol software EDI tool. Necessary Coding is done in RPG/400 and COBOL/400.Migration of maps for transactions 837 professional, 837 Institutional, 835 Payment/remittance advice, 270/271 for eligibility request and response, 834 for enrollment, 278 for referral certification and authorization 276/277 for Claim status enquiry, and 820 for premium payment. Both inbound and outbound transactions were taken up for migration.

Responsibilities

Involved in preparing gap analysis documents

Gathering information from client to bridge the gaps

Developed message class( maps ) using EXTOL tool

Configured the XML setup to convert XML format to X12, Flat files by using EXTOL

Involved in all the testing faces Unit, Functional and Regression testing

Prepared The 5010 X12 Test data by using EDISIM tool.

Done the Compliance checking for EDI documents.

Helped team members to resolve the technical issues

Project#7

Client/Location : DST Heath Solution, Birmingham, AL

Role/Period : Senior Software Engineer (EDI Developer/Analyst)/ Dec 2008 - Apr 2009

Environment : ECMAP, Biztalk 2002, EDISIM, Windows/XP, SQL Server 2005.

Transactions : BizTalk to ECMAP Conversion

Description:

This project involves EDI Production support, migration and maintenance of all HIPAA transactions which are developed for more than 30 customers at DST systems. Clients submit various types of files to the system and the system will take care of all EDI operations .The formats of files can be flat files and ANSI x12 files. Productions issues that may arise during processing will be controlled and alerts in the form of emails will be sent to the client for any data related corrections. The file processing is scheduled as per client needs and automated jobs run in the mentioned schedules. During the process of sending claims or receiving claims with the claim transaction 837 for professional, institutional and dental claims there occurs data/segment related issues which cause job to fail. These jobs are taken high priority and will be resolved within 4 hours of duration. For the 835 transaction the job usually fails at balancing at claim and service levels which will be corrected with customer’s advice. The Migration of maps from BizTalk to Sybase is also taken up as a part of this project. To standardize the usage of software among different products migration of all BizTalk maps to ECMAP is taken up.

Responsibilities

Preparing requirements documents and checklists for the change request or enhancement request sent by the client.

Preparing in/out file specifications as per the client file formats supporting both positional and delimited files

Developing maps using ECMAP and responsible to Document business logic using scripting fucntoids in Biz Talk Mapper and Implement rules in ECMAP where ever applicable.

Developed Schemas of EDI ANSI X12 Claims (837) and Eligibility forms in XML

Attaching functional acknowledgement maps where ever required and tracing out data or other issues if any raised.

Configuring developed maps to Trading Partners

Preparing test cases and unit testing the output files

Attending client meetings for approvals and clarifications on requirements if needed

Project#8

Client/Location : DST Heath Solution, Birmingham, AL

Role/Period : Senior Software Engineer (EDI Developer/Analyst)/ Jun 2007 to Nov 2008

Environment : ECMAP, Biztalk 2002, EDISIM, X12,Flat files, Visual Basic 6, Windows/XP,

SQL Server 2005

Transactions : 5010 Migration for AMISYS products

Description:

EDI 4010 maps for all Amisys customers are developed using ECMAP.As part of this 5010 migration project, all the 5010 maps are developed using ECMAP software. EC Gateway is used as to scheduling and, monitoring of jobs and to design customer specific business process. Migration of maps for transactions 837 professional, 837 Institutional, 835 Payment/remittance advice, 270/271 for eligibility request and response, 834 for enrollment, 278 for referral certification and authorization 276/277 for Claim status enquiry, and 820 for premium payment. Both inbound and outbound transactions were taken up for migration

Responsibilities:

Involved in 5010 Gap analysis with HIPPA Business Analyst Team

Documented the technical requirements and prepared 5010 mapping documents.

Developed EDI maps for new customers by using ECMAP tool and DATASTAGE jobs

Configured the new maps as per client requirements.

Done Unit and Component Testing.

Supported for SIT and UAT testing

Project#9

Client/Location : TATA-AIG

Role/Period : Information system Analyst/ Sep 2006 to May 2007

Environment : AS/400, COBOL/400, CL/400, DB2/400, SQL/400, Query/400

Transactions : Ordinary Life Administration System(OLAS)/ Agency Compensation System

(Module of OLAS)

Description:

AIG Inc. is one of the world's largest Insurance Company, which has its business running in over 130 countries. It has several products developed for the benefit of its customers all over the world. OLAS (Ordinary Life Administration System) is an integrated system that has been successfully deployed in China and Vietnam. OLAS comprises a central server and a suite of client applications with capabilities for policy maintenance and policy owner service, billing and collection, agent and agency compensation, premium accounting and suspense control, policy exhibit, loan, dividend and non-forfeiture processing, partial/total maturity processing and ledger with subsidiaries.

Responsibilities

Impact Analysis.

Preparation of Technical Specifications.

Developed the new programs using Cobol/400 to Calculate Agent Compensations.

Modified existing programs to support Policy features.

Involved in Error reporting, bug fixes and troubleshooting license and custom reporting for business and documenting team work request, bug fixes and enhancements issues.

Performing the peer reviews and Unit Testing

Project#10

Client/Location : Panasonic North America/Pune/India

Role/Period : Programmer Analyst / Jun 2005 to Aug 2006

Environment : AS/400, RPG IV, RPGILE, CL/400,DB2/400 SQL/400, Query/400

Description:

Charge Back Application:

PLCA (Panasonic Logistics Company America) is a company which provides services to the sales company PCEC. Panasonic Consumer Electronics Company (PCEC) deals with the sales of various electronic products such as Television, DVD player, Audio Systems, etc. Based on the information we get from the Delta-M, the services are charged to PCEC. In this system, Weekly and Monthly runs are the major programs that process charge back information and generate reports.

Account Broker Charges Application:

The inbound goods are imported from other countries to Panasonic US. These goods are brought in by carriers / vessels and offloaded on the dock. These goods need government permission to be brought in the country. A broker is the person who is responsible for doing this activity. For these goods, he prepares and compiles all the official documents for which he charges Panasonic. These charges include the custom fees, tariffs, harbor fees and broker fees.

Responsibilities

Involved in preparing High Level Design Document and Low Level Design Document and the technical specifications for the Service Requests.

Involved in review of the code modified by other resources of the team. Prepared the Review Records specifying the review defects and actions to be taken.

Involved in Unit Testing and System testing the modified code. Involved in preparing the test plans and the test results for the modified code. User Acceptance Testing and the Implementation is done by the on-site team.

Had the responsibility of delivering the problem tickets / Service Requests adhering to quality standards and with-in the estimated time. Also, has been responsible for managing and tracking the application problems.

Involved in the preparation of the application components for promotion of code into production environment.

Involved in giving the on-call production support for the application, fixing the abends occurred in the production environment.

Contact this candidate