SANDEEP RAJAPPA

**** **** ** ? Dublin, OH ***** ? Phone: 404-***-**** ?

acfu79@r.postjobfree.com

[pic]

* *** ********* / *-******** Lead

E-commerce(EDI) Developer & Lead offering 10 years' experience with a

demonstrated record of developing, coaching and leading teams that surpass

expectations and improve technical and business processes. Excellent

customer service skills and the ability to build strong relationships with

co-workers, vendors, and customers. Superior knowledge of EDI and a solid

technical background.

2 AREAS OF EXPERTISE

Project Management X12, EDIFACT, HIPAA Supply Chain Certified

Business Analyst XML, XPath, XSLT Agile Methodology

EDI,XML,JDBC,IDoc Maps FTP, SFTP, HTTP/s, AS2 Techno-Functional role

Business Process Flow PGP encryption/decryption Oracle EDI gateway

Setting up Trading Performance Tuning AS400 TrustedLink(TLE)

partners EDI System Administration SAP IDocs

IBM/SI B2B Integrator

PROFESSIONAL EXPERIENCE

IBM Sterling Commerce, Dublin, OH

12/2013-8/2014

Senior Implementation Specialist

Responsible for onboarding the new clients into Hosted Managed services.

. On-boarded the clients from the scratch with Requirements call till

Post Production into Hosted solutions.

. Coordinated with Clients and internal team on weekly basis to track

the progress and stick with the goals

. Worked on IBM Sterling Customer Center, Inflight Data management, BPN

Support Tool, Rules setup in BPN

. Coordinated & worked along with Mapping team to develop and update the

Sterling EDI X12 & WTX maps into the IBM Sterling Integrator

. Established communication protocols like outbound and inbound

communications, including FTP, SFTP, FTP with PGP & Web Services

. Learnt and implemented the best practices from IBM Sterling Commerce.

HUB GROUP, Chicago, IL 9/2013-

12/2013

Senior EDI Consultant

Responsible for Onboarding of customers and Carriers in Transportation

industry. Developed EDI and Flatfile maps. Worked on ANSI X12 maps,

including 204, 210, 211, 214 and 990.

. Configured and onboarded trading partners in AS400 iSeries

environment.

. Setup Mailbox configurations, routing rules and virtual roots

. Develop BPs for outbound and inbound communications including AS2,

FTP, SFTP, and FTP with PGP.

IGS ENERGY, Dublin, OH

1/2012-9/2013

Senior E-commerce / EDI Consultant

Responsible for upgrading/converting energy utility firms from Old Choice

system to New Choice system. Developed EDI, XML, CSV, and database maps;

worked on ANSI X12 maps, including 810, 814, 820, 824 and 867.

. Fulfill energy firm-related transactions, including enrollment,

account requests/responses, charge requests, consumption, rate change

response, usage, invoice, customer list, and do not solicit.

. Designed and developed business process workflows through Mailbox

concept.

. Designed and developed BPs and maps to track transactions at various

points in the workflow and store in database for reporting purposes.

. Develop BPs for outbound and inbound communications, including FTP,

SFTP, and FTP with PGP.

. Pioneered Agile EDI development environment in conjunction with BA,

QA, and testers. Actively involved in daily standup and sprint

planning and delivered the projects within the iteration periods.

. Architected and Implemented many custom e-commerce solutions to help

the business.

CDW, Vernon Hills, IL

4/2008-1/2012

Senior E-commerce Application Developer & Team Lead

Responsible for organizing, scheduling, coordinating, and tracking to plan

the requirements, coding, testing, and implementation of projects with

customers, vendors, banks and internal parties. Built an offshore team from

two to 20 employees over two years.

. Managed 13 employees at onsite and offshore locations through complete

life cycle of implementation to coordinate requirement gathering,

development, testing and go live efforts. Delivered projects on time.

Duties included onboarding new customers GIS 4.3.

. Lead seven employees responsible for the conversion of EDI 850, 810,

820, 855, 856, 832, 846 and XML maps from AS400 TrustedLink(TLE) to

GIS 4.1 & GIS 4.3.

. Actively involved in the migration of GIS 4.1 to 4.3 in 2008 and 4.3

to SI 5.1 in 2011. Migration activity included project management

between different teams (networking, security, database, system

engineering), designing system architecture, application and perimeter

server installation, certificate creation and installation, java

services installation, configuring different adapters, coordinating,

and testing.

. Worked as project manager and architect for various internal projects.

Responsibilities included initiating, planning, scheduling,

estimating, coordinating, reporting, change control boards and

associated processes, issue and risk reporting and other PMO related

tasks.

. Development of ANSI X12 customer and vendor maps for 820, 824, 850,

855, 856, 810, 832, 834, 846 and 867 messages in GIS Application

Integrator. Also worked as Business Analyst for many projects.

. Worked as team lead on XML, cXML, CSV and JDBC maps and Business

processes development work.

. Performed complete end-to-end testing, which included AS400

involvement to send and receive documents from customers and vendors.

. Worked on demo products: Sterling File Gateway (SFG) and Sterling

Control Center (SCC).

. BP development for outbound and inbound communications like HTTP/S,

FTP, SFTP, FTP with PGP, AS2, webservice and SOAP

. Involved in Six Sigma project, which included Fish bone methodology

and Full Life Cycle Development methodology to identify the key areas

total timeline of customer implementation projects can be reduced.

. Worked with Financial, Retail, Manufacturing, Healthcare, K12

partners.

CAPGEMINI, Atlanta, GA

10/2007-3/2008

EDI/E-commerce Business Analyst & Developer

. Gathered and documented business requirements for project stakeholders

and business users.

. Contributed to the project plan, Work Breakdown Structure, using MS

Project. Maintained RIAD logs (Risks, Issues, Actions and Decisions).

Worked closely with the project manager, and assisted in budget

planning and execution. Also wrote the project charter.

. Worked as Business analyst and was responsible for writing Functional

Requirement Specifications (FRS) and Technical Requirement

Specification (TRS).

. Worked as architect and designed the project from the scratch,

including installation, configuration and tuning of GIS 4.2 and

Perimeter servers. Developed Use Case diagrams using MS Visio.

. Performed Oracle E-commerce gateway configurations, including setting

profile options, code conversions, defining interface file data,

trading partner setups, and import and export. Configured the GIS

environment and created and maintained user account and permissions.

Developed maps for the transactions 834,835, 837, 820, 850, 856, 270.

276, 278 and 997 in GIS.

. Created the outbound and inbound business process to send outbound 850

and inbound 856, including 997 transactions from Oracle E-commerce

gateway to the trading partners.

. Worked with Healthcare clients on EDI HIPAA transactions like 834,

835, 837, 276, 278 and 820.

. Created and migrated the AS2 trading partner profiles and trading

partner envelopes.

. Tested the completed business processes using various certificates

with wide range of encryption and by creating PO in Oracle Purchasing

and receiving ASN into Oracle Receiving and creating receipts.

. Conducted project risk analysis to identify high-risk project

components and prioritized requirements.

. Performed functional requirement analysis, gap analysis, test script

generation, and documentation.

HOME DEPOT, Atlanta, GA

11/2006 - 9/2007

EDI Consultant

. Performed EDI mapping from/to both SAP/R3 IDOCs and other Flat File

Formats. Developed maps for the transactions 210, 214, 315, 810, 850,

852, 856, 860, 864 and 997 in GIS and development of XML to

application and application to XML maps.

. Worked on both outbound and inbound IDoc maps like ORDERS, ORDRSP,

INVOIC, SHPADV, ORDCHG etc.

. Process owner for trading partner setup, migration of trading partner

using the codelist in GIS. Developed CSV to XML map to generate the

trading partner codelists. Setup communication codelist to load all

800 trading partners in one go.

. Developed process for 997 message reconciliation in GIS.

. Streamlined EDI operations for different line of business via a Single

Point of Sale (PoS) system. Configured system-wide settings for

inbound and outbound transactions. Documented business process

belonging to different line of businesses. Monitored and supported day-

to-day production issues.

CUMMINS, Stockton-on-Tees, UK

9/2005 - 11/2006

EDI Consultant

Responsible for set up and configuration of Oracle EDI Gateway, release

management, order management, and oracle purchasing. Involved in planning,

development, configuration, tuning, troubleshooting, and support for EDI

processes.

. Developed and Upgraded the maps for the EDIFACT and ANXI X12

transactions like ORDERS, DELFOR, INVOIC, DESADV, DELJIT, ORDCHG,

ORDRSP, RECADV, CONTRL in GIS4.1 for inbound and outbound transactions

for Oracle 11i Application.

. Wrote the Unix Shell Scripts to FTP, SFTP and SCP the data from the

Cummins to third party servers and VAN.

. Migrated EDI maps from Mainframes to Oracle system.

TATA CONSULTANCY SERVICES, Chennai, India

9/2004 - 8/2005

EDI Developer

. Developed EDIFACT messages, including DESADV, INVOIC, DELFOR, DELJIT,

APERAK and RECADV. ANSI messages included 830, 850, 864, 810, 855,

856, 834, 835, 837 and 820.

. Wrote Shell Scripts to automate all transactions using UNIX Korn shell

and GENTRAN.

. Designed and developed EDI data flows using data managers/scripts

within EC Workbench to create patterns.

. Designed a detail test plan for testing the entire EDI data flow for

both inbound and outbound flows; sent/received data, performed

translation and verification of loops and data.

. Worked on PL/SQL Stored Procedures, Functions, Stored packages,

Recursive PL/SQL routines, database triggers. Knowledge of various

PL/SQL packages.

Education And certifications

. Bachelor of Engineering, Visveswaraiah Technical University, Belgaum,

India

. Basics of Supply Chain Management (CPIM certification from APICS)

. Master Planning of resources (CPIM certification from APICS)

Skill SEt

. EDI, XML, Flatfile,Database, IDocs, Oracle Mapping

. Business Process Flows

. X12, EDIFACT, TRADCOMS

. XML, XPath, XSLT

. Communication protocols like FTP, FTPS, SFTP, HTTP, HTTPS and AS2

. PGP encryption/decryption

. Performance Tuning

. AS400 TrustedLink(TLE) mapping

. VANs- Sterling, Nubridge, GXS

. Oracle - Release Mgmt, Oracle XML/Ecommerce gateway, OE Modules

. SAP IDOCs

. SQL Server-2005, 2008, Oracle 9, 10i

. Java

. Unix Shell scripting

. PL/SQL Stored Procedures

. Agile Methodology

. IBM B2B integrator Sterling Integrator 5.1, 5.2

. Gentran Integration Suite 4.1, 4.2, 4.3 Gentran NT, Gentran server for

Unix 5.3, 6.0

. GXS TrustedLink

. IBM Specific tools - IBM Sterling Customer Center, Inflight Data

management, BPN Support Tool

Contact this candidate