Manager Developer

Praveena Adari

Cell: 770-***-****

abicfq@r.postjobfree.com

Summary:

Over 8 years of IT experience and Around 7 years of WTX,WMB,WMQ, design, development of EDI,

EAI, client/server, and web based applications and HIPAA Projects.

Specific Experience:

• Extensively Worked on Mercator -2.1.1, 5.0, 6.0 & 6.5 & Data Stage TX 8.0, WTX 8.1 for

nearly 7 years.

• Extensively worked on Event Server, Integration Manager, resource registry and

Design Studio.

• Hands on experience on transaction sets 810 (invoice), 850 (PO), 214 (Transport Carrier

Shipment status message), 997 (functional Acknowledgement),

• Used various Adapters like File, sink, Database, MQ Series

• Good exposure on analysis of HIPAA Standards for ANSI X12 standards in the internal

looping structure of the segments such as HL Loops, 2010, 2200, 2300, 2400 segments

etc

• Good experience in different HIPPA Transactions (270, 271, 276, 277, 278, 837 I/P/D,

834, 835, 850, 997).

• Developed Maps and type trees using Mercator for HIPAA Projects.

• Developed Integration flow designer maps and monitored using Enterprise Manager.

• Used Event Server-Management Console to know the maps status, database and MQ

thread usage

• Expertise as Designer, Developer, Administrator, Pre-Production and Production of IBM

integration stack which includes, but not limited to: WMB 6.1/ 6.0, WMQ 7.0,

• Experience working with databases DB2, Oracle and MS SQL.

Software Skills:

Languages : C++, XML, VBScript, JavaScript, HTML and Java 1.1

GUI : Visual Basic .net/6.0/5.0/4.0, Visual Interdev 6.0,

Visual C++ 4.0, Visual Source Safe 6.0

Internet Technologies : ASP 2.0, COM/DCOM, MTS 2.0, ActiveX, ADO, RDO and ODBC

WebSphere : WebSphere Transformation Extender (WTX) (2.11 & 5.0 & 6.0 &

6.5 & 6.7& 7.0& 8.0), IBM WebSphere Message Broker v6.1,

IBM WebSphere MQ Series7.0,

IBM WebSphere Interchange Server.

EDI Standards : ANSI X12, EDIFACT, HIPAA & SWIFT among others.

RDBMS : MS SQL Server 2000/7.0/6.5, SYBASE 10, Oracle 8.i

Report Writer : Crystal Reports 6.0/5.0

Testing Tools : Manual Testing, Silk 6.5, Web Load, Win Runner, Load Runner,

Rational Suit, Clear Case

Office Products : MS Access 97/Excell/Word/ PowerPoint

Documentation : Requirements Collection, Use case Writing

Operating System : Windows XP/2000/NT/98, UNIX (HP11.0/Sun Solaris), RS/6000

Certifications:

Certified in - IBM WebSphere Transformation Extender V8.2 (Test 000-349)

Certified in - IBM WebSphere MQ V6 System Administration (Test 000-374)

Certified in - IBM WebSphere Message Broker V6.1, System Administration (Test 000-314)

Professional Experience:

Employer: - Tata Consultancy Services, USA

Client: Home Depot, Atlanta

Sr WTX Developer /Onsite offshore coordinator DEC’07– PRESENT

Home Depot is the biggest housing material retailer in North America. At Home depot worked as a

Data stage TX developer in Score Project.

Role and Responsibilities

• Technical requirement documents prepared for SCORE Project.

• Responsible for design and development for Master data management interfaces in Score

Project.

• Worked with TCS off-shore team for master data interface in score.

• Responsible for the interfaces SAP to Connect 3(Promotion manager), SAP to Legacy

• (Store/Mainframes), SAP to WMS (Warehouse management system)

• Mercator maps were developed for Idocs.

• Developed maps for transactions Invoice, Pick ticket, PO.

• Created type trees from DTD’s, database tables, queries using DTD importer tool and

Database Interface Designer.

• Deployed Maps and systems into development.

• Documented the processes of Instance creation

• Bringing up the launcher and debugging the systems and maps.

• Maintaining .mrn and .mrc files.

• Created mapping scenarios document for xml schemas.

• Maintained version controlling using PVCS.

• Prepared Technical Documents based on Functional Specifications

• Performed unit testing, integration testing and user acceptance testing.

• Production support and fixed production Map/Data problems in time.

• Configured WMQ Objects like Clustered Queues, Remote Queues

• Developed Message flows, sets and Message Definitions to transform message between

deferent formats.

• Development of various EDI maps using WTX and called the maps using the WTX node in

WMB.

• Troubleshooting and debugging WMB messages flows using Trace nodes and error handling

nodes.

Environment: WTX (6.5,7.5,8.0,8.1), WMB 6.x, WebSphere MQ series 7.0, IDOC, XML, AIX

(5.3),DB2, ODBC, MS Excel, MS Access

Client: ABN AMRO, Chicago

Mercator Developer FEB’06 – DEC’07

Worked as a DataStage TX developer at ABN AMRO Services Company. Electronic transactions as

low value domestic US transactions. These transactions include credits and debits sent to a variety of

accounts such as savings, checking, loan and general ledger accounts.

Role and Responsibilities

• Mercator maps were developed for both the outbound and inbound processes. .

• Created type trees from DTD’s, database tables, queries using DTD importer tool and

Database Interface Designer.

• Developed maps for Transaction, 850.

• Deployed Maps and systems into development.

• Documented the processes of Instance creation

• Bringing up the launcher and debugging the systems and maps.

• Maintaining .mrn and .mrc files.

• Created mapping scenarios document for xml schemas.

• Maintained version controlling using PVCS.

• Prepared Technical Documents based on Functional Specifications

• Performed unit testing, integration testing and user acceptance testing.

• Production support and fixed production Map/Data problems in time.

Environment: DataStage TX (6.7),IDOC, XML, VBScript, Window NT/2000,SQL Server 7.0/2000,

Oracle 8.i, VB (6.0), ADO, ODBC, MS Excel, MS Access

Client: ODS Companies, OR July’04 to Jan’06

Sr. EDI DatastageTX Mapper

EDI Transactions were developed on Windows XP Platform with latest Version of DataStage TX 7.5 for

ODS Companies.

Role and Responsibilities

• Developed maps for 837 I/P/D transactions.

• Created systems using Integration flow designer.

• Developed mapped, type trees Audit logs reports.

• Imported type trees from Cobol Copy Books.

• Mapped inbound 270, transaction from XML to EDI and mapped outbound 271, 997

transactions from EDI to XML format.

• Have developed the type tree for the internal application and COBOL COPYBOOKS.

Involved in several other map tree designing like Merging several tree’s into 1 tree, deleting

SUB-TREE’S, Creating INDUSTRY SUB-SET TREE, coping ANSI type tree, Creating a MULTI

VERSION SUBSET TREE, all the scenario’s are depends on OUR BUSINESS NEEDS.

Creating Basic Inbound type tree and Out bound type tree and analyzing them

• Converted IDOC to standard EDI files.

• Used Event Server to know the maps status

Environment: DataStage TX (7.5), EDI X12,IDOC, XML, Win NT/2000,Unix - Sun Solaris, DB2,

COBOL, JCL, DB2, IBM DI (data Interchange)

Client: - ACS, Tallahassee, FL Mar’03 - June’04

Sr. EDI, HIPAA, Mercator Mapper

EDI transactions were developed on UNIX (sun Solaris) platform with the version 6.7 of MERCATOR

for ACS, State Health Care Clearing House.

Role and Responsibilities

• Developed Maps for Florida, Wyoming

• Developed Maps for State of Florida, for the 837 D, 278, 270 Batch/Schools/DHACS, 271

Batch/Schools/DHACS transactions

• Developed Maps for Wyoming for transactions 837 P and 837 D.

• Create Type trees using DTD’s.

• Deployed maps onto Unix platform.

• Worked on different Transactions i.e 275 - Patient Information, 276 - Health Care Claim Status

Request, 277 - Health Care information Status Notification, 835 - Health Care Claim

Payment/advice, 837- Healthcare Claim, 271 - Eligibility, Coverage or Benefit Information, 270

- Eligibility, Coverage or Benefit Inquiry

• Basic syntactical integrity of the EDI submission includes (valid segments, segment order,

element attributes, testing for numeric values in numeric data elements).

• Have developed the type tree for the internal application and COBOL COPYBOOKS.

• Used preventive efforts to reduce failure and Preparation and Review of Analysis report.

• Worked with Claim Status Enquiry (276).

• Used database adapters in the maps to interface with databases and also used FTP and

email adapters in the maps.

• Developed Integration flow designer maps and monitored using Enterprise Manager.

Environment: Mercator (6.5), EDI X12, HIPAA, EDIFACT, XML, Win NT/2000,Unix - Sun Solaris,

DB2, COBOL

Client: SBI Regional Office, India Aug’02 - Feb’03

System Tester

Description: Worked on a banking project that processed account entries, loan information, deposits,

and generated weekly reports. The system provided account balances, loan eligibility information, and

interest calculations.

Role and Responsibilities

• Designed forms for input fields.

• Developed code for the acceptance of data in the front-end. Forms designed for generation

output display from the data retrieved from the database after processing. Modified code so

that it computed the interest on deposits and loans.

• Generated weekly reports using Crystal Reports.

• Manually tested the entire system.

• Prepared and executed test cases and test procedures.

• Tested the data entry screens.

Environment: Visual Basic 5.0, Oracle 7.x, UNIX, Test Director, Win Runner.

Contact this candidate