Rani chandhira Nanda kumar

Email : ac00rt@r.postjobfree.com

Location : Ballwin,MO

Phone : 314-***-****

EXPERIENCE SUMMARY:

4.5 years of experience as EDI and Oracle resource, in HCL TECHNOLOGIES.

Excellent knowledge of transactions in ANSI X12 270, 271, 276, 277,810, 820, 831, 834, 835, 837(I, P,D), 850, 855, 860, 856, 997 and 999

Possess knowledge on EDI standards like ANSI X12, EDIFACT.

Responsible for any EDI data issues in production environments and making changes accordingly

Responsible for implementing new EDI transactions and moving into production environment

Worked on the design and development and deployment of the maps for different countries based on the requirement from the client.

Expertise in gap analysis of 4010/5010 of all transactions such as 837, 835, 999.

Thorough understanding on ICD9/10 codes

Knowledge on Edifecs specbuilder and XEngine

Oracle certified developer

Having database experience using Oracle 10g/9i/8i, SQL, PL/SQL, Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index and Views.

Involved in Development of the applications through Oracle using Pl/SQL created Tables, cursors and SQL Queries

Performed testing process using QTP and Entegration Attest for End to End Testing

Possess a good knowledge in developing Reports using XML Publisher.

Able to design and generate reports using the XML Publisher

Proficient in Microsoft Word, Excel, PowerPoint, Access

Experienced in handling production support issues

Committed team player with strong analytical and problem solving skills, Willingness to relocate and ability to quickly adapt to new environments & technologies, dedicated to successful project completion with excellent communication and interpersonal skills.

Strong analytical skills

Well Experienced in Client communication

Confident, Hard Working, Quick Learner & Ability to adapt to diverse scenarios makes me win over difficult situations.

Problem solver who quickly grasps complex situations and turns them into manageable tasks.

Produce quality work under extreme time pressure and deadlines.

Proven ability to understand and follow complex instructions to successful conclusions.

A team player with good interpersonal skills and commitment towards quality work.

TECHNICAL PROFILE:

Edi Integration Tools

Gentran Integration Suite 6.0, Edifecs Product Suite

Other tools

XML Publisher, UltraEdit, Putty, Beyond compare, MS Word, MS Excel, MS PowerPoint, MS Access, MS Project, MS Outlook, Lotus Notes, CoreFTP, Claredi

EDI Standards

ANSI ASC X12, HIPAA EDIFACT

Edi transactions

270, 271, 276, 277,810, 820, 831, 834, 835, 837(I,P,D), 850, 855, 860, 856, 997 and 999

Process/Modeling tools

MS Visio, Rational Rose, Rational Requisite Pro, Clear Case, ClearQuest

Database

MS Access, SQL Server 2000, Oracle 9i & 10g,

Protocols

FTP, SFTP, HTTP, HTTPS, VAN

Operating System

Windows Vista, NT/2000/2003/ XP/98, MS DOS

Languages

C, C#, SQL, UNIX shell script, XSLT and Java

TECHNICAL CERTIFICATIONS:

Oracle SQL Database Expert (10g)

Information Technology Service Management Associate ( ASM )

EXPERIENCE:

HCL Technologies, August 2009 to November 2013

PROJECTS:

Projects Involved (HCL)

Project #1 EDI Support and Maintenance

Type : Support and Maintenance

Platform : Gentran 6.0, UNIX

Software : Oracle 9i

Client : Teradyne, Boston, US.

Duration : Aug 2009 to Nov 2013

Teradyne is the world’s largest supplier of Automatic Test Equipment (ATE) and software for electronics and telecommunications industries, and a leading supplier of high performance backplane assemblies and connectors. Teradyne is headquartered in Boston, Massachusetts, and having manufacturing facilities in United States, Ireland, and Japan.

The goal of the project is to support and maintain the existing EDI connectivity between FedEx and Teradyne to provide forward and Reverse Logistics functionality via EDI.

Merlin is the back end of this system which is oracle9i database.

RESPONSIBILITIES:

Resolving the issues in EDI space like Data compliance errors, Encryption related errors and TP issues etc.

Worked closely with development team, played key role in data mapping.

Involved in On-Boarding of Trading Partners.

Monitoring the data consistency in the Upstream and Downstream applications of EDI

Development and deployment of Maps using Sterling Gentran Mapping Tool

Manipulated UNIX shell scripts for file manipulation and communication

Maintenance of EDI Documents, data managers, and Gentran life cycle Database

Analyzing the user requests and responses as per the severity of the ticket

Communicate with customers regarding Trading Partner setup, Testing and Go Live Proceedings

Resolving day-to-day issues occurring in the production system

Acting as the Incident commander for severity-1 issues across the Project

Project #2 TPhone

Type : Support and Maintenance

Platform : Java, UNIX

Software : Oracle 9i

Client : Teradyne, Boston, US.

Duration : Aug 2009 to Nov 2013

TPhone is the customized Application to maintain the Teradyne Employees Details, Contractors Information existing within Teradyne using Java Servlets - TPhone, with the back end of oracle9i database. TPhone has several GUI screens, providing much functionality.

RESPONSIBILITIES:

Managing the Account Information of all the employees within Teradyne like Termination, Contractors and Regular.

Issues like Missing Account Details, Email Bouncing, Distribution Lists, SMTP Forwarder are all handled.

Handled tickets based on the priority and informed the issues to the customer with in stipulated SLA’s

Inbound and Outbound feeds are done by Scheduled jobs

Custom written shell scripts for handling business needs

Involved in Disaster recovery for production Database

SQL queries are used to fetch the data for analysis, requirements

Project #3 : Entegration Attest (QTP)

Platform : Java, Apache TOMCAT

Client : Teradyne, Boston, US.

Duration : Aug 2010 to Nov 2011

Entegration Attest helps in stream-lining the testing process by breaking them in to

manageable components and automating them. It provides comprehensive framework to

capture and define the testing requirements, function, roles and responsibilities

associated with testing.

RESPONSIBILITIES:

Maintaining Tracks, Scenarios, Functions

Creating Test Suites in which multiple scenarios can be grouped and tested together

Providing the data query for all IN parameters of the function in a scenario

Preparing Datasets by which the data for multiple scenarios within a Test Suite to be

stored together and reuse against multiple test environments

Project #4

Platform : Edifecs Product Suite 6.0

Client : Biocodex Inc, US.

Duration : Aug 2009 to Aug 2010

Biocodex is an independent multinational pharmaceutical company built on high-standards science and manufacturing, with six decades of proven success. Today, Biocodex USA is leveraging its nationwide reach and the strong reputation of Florastor the #1 probiotic worldwide to expand beyond its probiotic roots. It is opening offerings in the arena of oncology supportive care with Totect as well seeking partnerships in other therapeutic areas.

Worked on HIPAA Standard Transaction Forms X12-837 for Equivalent Encounter Information, X-12-835 Claims Payment and Remittance Advice, X12-Health Care Claim status request and response, X12-270/271 Eligibility for a Health Plan and X12-820 Premium Payments.

Developed various maps like 834,835,837, 270,271,274,278 using EDIFECS

Worked on EDIFECS Transaction Management (TM) to provide a secure end-to-end view of the healthcare transaction lifecycle to internal users and trading partners to enable better business decision-making and monitor performance. Worked on Route Building to collect user-created XML files via the Internet and incorporate them in the route database.

Involved in testing EDI transactions 270 & 271 for benefit eligibility enquiry and response.

Created Test Plans/Test Scripts.

Involved in the user acceptance testing (UAT).

Tested HIPAA EDI Transaction validation using Quality Center tool. Entering defects during bugs found during UAT testing and assigning it to the appropriate developer.

Involved in testing EDI’s according to code set X12 835 Claim Payment & Remittance Advice Claims processing and 837 Claim transactions.

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

Prepared test plan and test cases for testing of the system and tool for validation / compliance.

Involved in dealing with trading Partners and conveying the implementation guidelines and specifications.

Configured Finalist software for Membership and Claims system.

Interacted with other teams and responsible for creating test scripts for unit testing, regression testing and production simulation.

EDUCATION

Academic Qualification: Bachelor of Engineering in Computer Science (B.E) from the Anna

University - 2009.

PERSONAL PROFILE

Date of Birth : 28/3/1988

Immigration Status : Green Card

Contact this candidate