Satish Paduchuri ab0bj4@r.postjobfree.com

703-***-****

Summary:

Over 13 years of professional experience in software development, web

application development, involving analysis, design, coding, testing,

implementation of varied business and financial applications.

> Versatile, result-oriented Project Leader, Senior Programmer Analyst/

Business Analyst with demonstrated success in application architecture,

software development, and electronic data interchange (EDI) project

implementation. Technical expertise in practice management and health

care Projects involving ANSI X12 transactions, aligning information

systems with business goals.

> Extensive experience in EDI/HIPAA implementations, Development/ Mapping

EDI Transactions using different tools such as IBM WTX, Mercator, Gentran

and testing EDI/HIPAA applications.

> Worked on various Transaction sets like 810, 820, 824, 830, 850, 856,

860, 270, 271, 276, 277, 278, 834, 835, 837, 304, 315, 309, 310, 997

> Worked Extensively on NSF, UB92, EDIFACT and ANSI X12 conversion

projects.

> Extensively used HTTP, FTP, MQ-series, DB, email adapters for various

Mercator maps.

> Proficient in Interface Development coupled with Business Processes and

Functional Analysis.

> Developed and executed several test plans, test scenarios, test scripts,

test cases and test documents.

> Experienced in documenting EDI procedures and writing test cases using MS-

Word, MS-Excel and MS-PowerPoint.

> Excellent analytical, communication, problem-solving and interpersonal

skills.

> Excellent written and verbal communication skills have proven to be

highly effective in the interfacing of various levels of business and

technology.

Technical Skills:

EDI Tools: DataStageTX7.5(Mercator 5, 6.5, DSTX7.5,

DSTX8.0/8.1,WTX8.2/8.3), Gentran.

EAI Middleware: IBM WebSphere Message Broker 6.1.0.8/7.x/8.0,

IBM WebSphere MQSeries 6.0.

EDI Standards: ANSI X12, NSF, UCS, NCPDP, SWIFT and EDIFACT

Specialization: Electronic Data Interchange (EDI) transactions

204, 211, 214, 270, 271, 276, 277,

278, 810, 820, 824, 830, 832, 834, 835, 837, 850, 855, 856,

860, 869, 870, 997.

Languages: JSP, XML, JAVA, Servlets, JDBC, Applets, C, C++, XML,

JavaScript, HTML, PL/SQL, SWING, VB6.0, VBScript, Developer

2000, ASP, Crystal Reports, ESQL.

Servers: BEA Weblogic, Web Sphere, Tomcat 4, Apache, IIS4.0

Databases: MS Access, Oracle 7.x/8.x/9.x, SQL Server, MySQL, DB2.

Tools: JBuilder, Visual Age for Java, Front Page, Rational Rose,

Allaire Homesite, Macromedia DreamWeavier.

Education:

Masters in Computer science, Madras University, INDIA.

Bachelors in Computer science, Nagarjuna University, INDIA

Professional Experience

Client: Apria Healthcare, CA. (DELL) Aug '2011-

Present

Title: Sr. Enterprise Advisor/Consultant

Apria Healthcare is the leading provider of integrated home healthcare

products and services.

Analyzed current architecture to determine the best integration strategy

based on the client's needs. Implemented WTX Trading Manager and performed

several upgrades. Working on CMI implementation project for inbound and

outbound 837I/P, 835, 820, 823, 270, 271, 276-277 transactions processed

through different tools.

. Performed duties including the creation of project plan, status

reports, work plans and presentations to client leadership.

. Project responsibility is the conversion of multiple applications and

for varied business facilities from 4010 to 5010 namely IBM WTX 8.3

. Performed a full gap analysis of 4010 vs. 5010 against the documented

application, 5010 enhancements ensuring the upgraded application

included the required changes and additions for 5010 compliancy for

transactions 820, 834, 837 & 835 etc.,

. Analyzed and validated the key components of the implementation plan

related to Line of Business focusing on proper contract set up and

processing of membership files, claims adjudication and payment to

provider in accordance with LOB contract.

. Used Database Interface Designer in conjunction with Integration flow

designer for updating SQL 7 database, and Oracle database with mission

critical transformed data from various compound systems.

. Gained hands on experience on HIPAA 4010 to 5010 conversion from

business point and technical point.

. Post live support addressing all issues, with a focus on claim

adjudication to ensure a high percentage of "clean" claims in take to

enable complete and accurate adjudication.

. Worked on the more complex level issues associated with all modular of

the application, Identified cause and designed temporary and permanent

solutions working closely with technical programming staff and

business partners.

. Gathered business requirements by conducting detailed interviews with

business users, stake holders and Subject Matter Experts (SME's).

. Acted as project point-of-contact for project implementation for all

clients and TPA's.

. Trained teams across the organization on resolving critical EDI issues

and transferred the knowledge for better team & organizational

performance.

. Worked with several PMO's on several Project initiatives from scratch

to full implementation.

. Analyzed EDI Data to find errors in X12 EDI transaction sets such as

820, 834, 837 & 835 and debugged during various phases of software

development cycle in DEV/TEST/PRODUCTION.

. Designed robust 5010 testing, regression SIT and UAT Testing Scripts

for the 5010 Project.

. Involved in Error reporting and compliance check for HIPAA standards &

Error Resolution of Claim submissions (837 Institutional 837

Professional).

Environment: WTX v8.3, 8.2.0.4, 8.1.0.3, Trading Manager, HIPAAv4010, v5010

ANSI X12, Foresight, EDSIM, MQ SERIES, Ultra Edit v3.2, XML, Java, SQL,

Ariba Tool Kit, ACIS(AS400), Microsoft Visio 2003, Aldon, DB2, WMB7.0/8.0,

CLAREDI.

Client: Aetna, MI. Aug '2006-Aug

'2011

Title: EDI Lead/ Sr. Consultant

Aetna is one of the nation's leading diversified health care benefits

companies. Offers a broad range of health insurance products and related

services, including medical, pharmacy and dental. Working on EDI

implementation project for inbound and outbound 837I/P/D, 834,835,270,

271,276-277transactions processed through WTX 8.2

. Developed business requirements and complete set of detailed mapping

specifications and created high-level and detailed UML activity

diagrams, use cases, and decision matrices for all requirements.

. Managed EDI trading partner relationships and team workload.

. Created several Power point presentations for multiple business needs

and provided training on national basis for scenarios such as training

COB-HIPAA Trading Partners on how to transmit Eligibility files to the

client by using different means like Electronic media, Tape, CD, 837

claims testing, HIPAA errors resolution using online training WebEx.

. Worked extensively in X12 - 837 5010 & 4010 EDI Analysis, Claims

Analysis, and Eligibility analysis.

. Developed X12 837 4010 and 5010 Mapping specifications.

. Extensively involved in resolving 837 Institutional and Professional

Claims - relating to critical issues with Medicare contractors and

supplemental payers/ trading partners specifically for Loops 1000A,

1000B, 2000A, 2000B, 2010 AA, 2010BB, 2010 BC, 2300, 2330A, 2330B,

2320, 2400 etc.,

. Monitored HIPAA errors on daily basis and advised senior management

and CMS for the resolution.

. Developed 270/ 271 mapping and business guide lines.

. Coordinated between integration team, business team, financial team

and testing team.

. Transmission set up with new clients using different adapters like

File, E-Mail, FTP, HTTP, MQ, XML etc for sending and receiving files.

. Worked with Database Administration development of non-X12 EDI imports

and exports, data mapping and conversion of flat-file data from

multiple legacy systems.

. Extensively involved in 4010-5010 conversion-project from system

analysis to development, testing and implementation.

. Wrote Technical specifications Document to upload and download

Electronic files - manually from IBM Tape/ Cartridge using Tape/

Cartridge machine to meet the business requirements.

. Maintained a 'Problem Log database' for daily business issues

regarding Connect Direct, Eligibility, Claims, Contract and Financials

from Trading Partners.

. Worked with Faciledi, such as adding exclusion lists for specific

business needs for different claim crossing scenarios, monitoring

daily claim volumes, daily EDI transmission issues, resolving HIPAA

errors.

Environment: WTX v8.2.0.4, 8.1.0.3 HIPAAv4010, v5010 ANSI X12, Foresight,

EDSIM, MQ SERIES, Mainframes, Ultra Edit v3.2, VSS, XML, Java, SQL, EDI

Controller, Powerstep(AS400), Microsoft Visio 2003.

Client: GT Nexus, CA. May '2006- July

'2006

Title: Consultant

A leading provider of supply chain software. Providing the global

infrastructure and managed IT services to companies and service providers

in the world.

. Developed different Interfaces for the Customer Information System

using DataStage TX Components.

. Consult and strategize with the clients design team in using Mercator.

. Set up Trading Partner Information for different customers using

Commerce Manager 7.1

. Designed map to access Java classes and pass data to web applications.

. Developed different maps for communication using http, email adapters.

. Created Type Trees, Maps, and MDQ files based on Gap analysis. Mapped

XML data by creating Trees based on DTD's with XmlSpy.

. Developed Maps to translate XML to and from X-12 EDI/EDIFACT

transactions. Developed Type Tree scripts to automatically generate

XML type trees for X12 transactions.

. Mapped inbound and outbound to XML Formats. Effectively resolved

outstanding interface issues with Functional and Technical owners

Environment: Mercator/DataStage TX 6.5/7.5, Commerce Manager 7.1, MQ, XML,

EDI, EDIFACT, and Java.

UPS-SCS, Atlanta. Sep '2005 - Mar

'2006

Mercator/ Datastage TX consultant

Migration Project - Menlo Logistics was acquired by UPS, and all systems

were migrated from version 6.7 to 7.5. Assisted from project blueprint

stage to server migration, my cross-functional duties also involved

requirements gathering, Designing, Mapping, training and other TX-related

technical activities.

. Redesigned the Mercator/DataStage TX EDI and Flat File data flow to

fit into UPS SIP1 framework.

. Datastage resource of team that upgraded existing systems from 6.5 to

7.5.1 through project lifecycle. Facilitated Mercator initiatives in

converting Type Trees, Maps, mdq's and msd's to 7.5

. Coordinated activities related to integration of newly acquired

Mercator systems (Menlo Logistics) with existing UPS framework.

. Liaised with German customer (Bayer), Hong Kong customers (Wolverine),

Indian customer (India Customs) and China customer (China Customs) to

coordinate testing activities relating to the server move.

. Performed Gap analysis to determine TX components and identify FTP

requirements. Wrote Test cases for the outputs, and also compared

outputs from different versions to determine changes.

. Created Error Handling Maps for the Bayer, US Customs, China and

Indian Customs

. Maintained PVCS Source Control access for all team members and

documented changes through a single source.

. Worked with Middleware team to facilitate Mainframe move and

determined connectivity's that would be impacted by migration.

. Developed Technical design documents from Functional design documents.

Provided scripts and procedures to migrate modules from Test to UAT to

Production environments.

. Enabled in the seamless transition of all applications from Menlo

Worldwide Forwarding to UPS and created application-to-application

(A2A) maps to enable transactions between Menlo and UPS.

Environment: Mercator/DataStage TX 6.5/7.5, Commerce Manager 7.1, MQ, XML,

EDI, EDIFACT, UNIX, SIPI, PVCS.

Menlo World Wide, OR. Dec'2004 - Sep

'2005

Consultant

Menlo logistics specialized in cost-effective design and management of

product transportation, storage, distribution and integrated logistics

services and communicates via edi, to exchange transportation and financial

information with their clients and supply chain partners. Electronic data

interchange can be accomplished through direct communication links (such as

secure Internet, dial-up or FTP) or via third-party Value Added Networks

(VANs).

. Developed different Interfaces for the Customer Information System

using DataStage TX Components.

. Worked on different Transaction numbers like 214, 215, 856, 857, 211,

943, 944, 830, 824, 862, 850, 810 and 997.

. Designed the Mercator system in accordance with the business

requirements. Created mapping files using EDI transaction sets.

. Developed different communication maps to send / receive files, using

different connections like Transettlements, GE Information Systems

(GEIS), VAN and FTP.

. Used different versions of ANSI X12 and UN/EDIFACT transaction sets as

well as private enterprise standards.

. Used Mercator type tree features, and different adapters like email

adapters, database adapters in Integral and Burst mode to update

database.

. Designed and created several complex type trees and generated

different maps.

. Implemented test plans, restart logics, sequence maps, shell maps for

detailed error mapping and configured Mercator configuration files to

run multi-threaded.

. Designed and developed Schemas (xsd), WSDL's using XML Spy tool based

on the mapping specifications.

. Used MQ Series to send and receive files.

. Developed ANSI-X12, EDIFACT, RosettNet, CIDX, Cyclone MCD and

proprietary interfaces based on system and user requirements.

. Deploy code onto UNIX development, QA environments and monitor,

maintain Event Servers. Responsible to monitor day-to-day activities

such as any launcher failures etc.

. Written Unix Shell Scripts for Event Server mercstart.sh and

mercstop.sh.

. Involved in creating Database/Query files (.mdq) using Database

Designer, joined tables by writing co-related sub-queries and nested

queries to collect related data from more than one table.

Environment: Mercator/DataStage TX 6.5/7.5, Commerce Manager 7.1, MQ, XML,

EDI, EDIFACT (For Bayer Transactions), and UNIX.

Davis Vision, NY. Aug'2002 - Dec

'2004

EDI Specialist

Davis Vision is one of the leading eye care providers and eyeglass

manufacturers. As an EDI-Specialist for Davis Vision involved in analysis,

design, development and testing. Trading Partner documents are received in

different formats like X12, NSF, EDIFACT. Installed DataStage TX components

Design Studio6.7, Integration Broker6.7, and configured Commerce

Manager7.0. Involved in Database architecture for Commerce Manager and Hub

Repository.

. Involved in Mercator Architecture Assessment for Davis Vision.

. Developed lot of Interfaces for the Customer Information System using

DataStage TX Components.

. Worked on different Transaction numbers like 276,277,834, 835,837,810,

820,850,856, 860,997

. Developed and implemented business rules using map designer,

implemented end-to-end data transfer using DataStage TX Components and

automated the system using System editor using launcher.

. Used Mercator type tree features like tree partitioning there by

enhancing data validation, email adapters, database adapters in

Integral and Burst mode to update database.

. Implemented test plans, restart logics, sequence maps, shell maps for

detailed error mapping and configured Mercator configuration files to

run multi-threaded.

. Designed and implemented the commerce manager in configuring the

partner profiles, setting up the post offices and setting up the

applications related to each internal as well as external partner's.

. Configured and modified Mercator HUB Repository.

. Implemented map for 997 to convert into internal format and email as a

attachment to different departments within company.

. Several customized reports are generated for the business

requirements. Designed the FTP maps to handle the data transfers

automatically and several maps were designed to handle the data

integrity generating the reconciliation reports based on a data range.

. Designed the application maps to handle large volumes of data and

effectively handle different scenarios for handling the business

rules. Error handling, auditing and data validation are the part of

the design.

. Used MQSeries Application Integrator (translator) to send and receive

the OUTBOUND and INBOUND process.

. Tracking and monitoring procedures for production issues using Event

Server Monitor and Management Console.

. Built and Deployed the Mercator Systems (.msd, and .msl) by using

Mercator Integration Flow Designer (IFD) on to the AIX Unix box and

tested.

. Prepared resource name (.mrn) and resource configuration (.mrc) files

for interface maps with Mercator Resource Registry.

. Was involved in creating Database/Query files (.mdq) using Database

Designer, joined tables by writing co-related sub-queries and nested

queries to collect related data from more than one table. Used QMF to

present SQL's dynamically at execution time on DB2.

. Prepared structure charts, Program Amendment Specifications, Unit Test

Plans, Coding, Code reviews and Module testing, Subsystem testing etc.

Environment:JCL, DB2, DataStage TX, MERCATOR 6.7, XML, X12, NSF,

EDIFACT,XML, SQL Server 2000, ClarEDI.

Client: Research Directors Inc., Mar '2001 to

June '2002

Title: Software Engineer

Instant Answer Application (IAA)

Environment: Windows 2000, Visual Basic 6.0, Oracle 8.0, TestDirector and

WinRunner.

Description: Instant Answer Application (IAA) is developed for Research

Directors Inc. The project mainly developed to generate charts as per the

client requirement. RDI gets data from different sources and stores in the

server, using IAA the database is searched for the latest data and look for

client matching and generates the charts.

Responsibilities:

. Involved in Analysis, design and develop project requirements.

. Involved in Use Case Analysis, Use Case Modeling and used Presentation

Layer Framework.

. Utilized Rational Rose to create various UML design documents.

. Involved in development of GUI using Visual Basic 6.0

. Developed and integrated applications and business processes within

enterprise and across extended enterprise.

. Database schema design and analysis along with data modeling. Also

wrote SQL and stored procedures to perform transactions with Oracle

back ends using SQL

. Involved in integration and performance/load/stress testing using Load

Runner, TestDirector.

Ranklin Solutions Ltd., India

Jan '1999 to Mar '2001

Senior Software Engineer

The Web Vortal encompasses the clear-cut dimensions of Indian insurance and

Finance Business sector. It provides users the most comprehensive internet

Vortal, specific to India focused content and services, delivering a choice

of channels, facilities and features that enable the user to get the

maximum out of the internet.

Environment: Java, JSP, HTML, Java Script, Java Web Server, Oracle, Visual

Interdev, Front Page.

Ranklin Solutions Ltd, India

Mar '1998 to Jan '1999

Software Consultant

Municipality Management System (MMS)

This Project involves complete computerization of all the municipal

activities. This project has been divided into the following modules:

Revenue Module, Town Planning, Engineering, Health, Finance Module,

Inventory, payroll Management, Compliant Module.

Environment: Visual Basic, Active X, Oracle, Crystal Reports and Windows

NT.

Contact this candidate