Manager Data

Resume Madhuri Nallala

Madhuri Nallala

Mobile Number: +1-248-***-****

Location: Detroit, MI.

EMail: ***************@*****.***

Profile

Working for Mphasis with over 7 years of experience in the B2B/EDI, retail and health care domain.

Good working knowledge on Sterling Commerce products like SI (Sterling Integrator which works similar as Axway), Sterling File Gateway, B2B Framework (Developed by Oxford consultancy), FACETS, IKA Systems, IBM Cognos, Tibco.

Possessing good functional knowledge on EDI standards such as ANSI X12 and UN/ EDIFACT. (850, 856, 810, 860, 855, 997, 834, 837, 270, 271)

Worked on different versions of Map Editors of Sterling Integrator, which are used to develop production maps for the various Trading Partners belonging to various regions.

Worked on SI Application map editor tool 7.0 to 8.0.3.

Developed SAP IDOC to EDI maps.

Good Knowledge on Sterling File gateway.

Good Knowledge on File transfer protocols FTP, SFTP, AS2.

Worked in L1/L2 Support and developed Maps, Envelops, TP Setups, in Sterling Integrator.

Good programming experience as SQL Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).

Experience in Client-Server application development using Oracle 10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Extensively used Functions, Indexes, Collections, Analytical functions, Views, Query Re-Write and Transportable table spaces.

Good knowledge on logical and physical Data Modelling using normalizing techniques.

Created Tables, Views, Constraints, Indexes.

Developed complex database objects like Stored Procedures, Functions, Packages, Views and Triggers using SQL and PL/SQL.

Loaded data into tables using SQL Loader.

Experience in Exception handling.

EDUCATION:

Bachelor of Technology degree in Computer Science Engineering from JNT university www.jntu.ac.in, India.

Trainings Undertaken

Course

Company

Sterling Integrator (GIS)

Cognizant

FLC Training

Cognizant

Skills Summary

Databases: Oracle 8i/9i/10g, PL/SQL.

Operating Systems: UNIX, Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL.

Tools: TOAD, SQL Loader, Sterling Integrator, SI- Map editor, Sterling File gateway.

Functional Domains : Retail, Logistics, Insurance.

Project experience:

1.Ahold Delhaize EDI Implementation: -

Client : Ahold Delhaize

Role : EDI Developer

Duration of project : July 2019 – Till Date.

Relevant Products : Sterling Integrator, Map Editor of SI, Framework.

Relevant Technologies : EDI, B2B, ANSI ASC X12, EDIFACT, AS2, FTP.

EDI Transactions : 850,856,810,860,855,844...ect

Description:

Ahold Delhaize is a Dutch Belgian retail company, operating supermarkets and ecommerce businesses. Ahold Delhaize's international headquarters is in Zaandam, Netherlands.

Its brands are active in the Netherlands, Belgium, the Czech Republic, Greece, Luxembourg, Romania, Serbia, and the United States. It also participates in joint ventures in Indonesia and Portugal.

Responsibilities:

Analyze and understand requirements of the project.

Create/review requirement spec/documentation for technical viability.

Identify technical risks, probable solutions and escalate to stakeholders in a timely manner

Need to estimate and plan efforts for the project – I have to prioritize tasks and proactively communicate roadblocks.

Develop the SI maps (TP specific) which translate EDI data to Application Files.

Create INBOUND and OUTBOUND flows for each TP. This includes creating envelopes, deploy the maps and BP’s for the end to end flow.

Share a wide knowledge on EDI, X12, EDIFACT.

Working on Sterling file gateway to route the files.

Contribution in building new technical templates, enhancing documentation.

Ensure weekly/monthly/phase summary reporting to stakeholders...

Weekly status reports are sent to the manager to demonstrate the progress being made on the each TP

Trouble shooting and reporting the root cause analysis to the customers as per the SLA.

Demonstrates accurate knowledge of Sterling Commerce software and services to the customers in the discovery phase.

To participate in the flow design and discussion with the customer and create a Business requirements document (BRD) and a communication design document.

To provide feedback to Sales, Product Development and Customer Support to improve quality of software and service solutions, consulting proposals and customer satisfaction.

To represent Sterling Commerce to customer with professionalism at all times.

2.Assa Abloy Sterling Integrator Implementation :-

Client : Assa Abloy.

Role : EDI Business Analyst

Duration of project : Sept 2018 – July 2019.

Relevant SCI Products : Framework, SI, Map Editor of SI.

Relevant Technologies : EDI, B2B, ANSI ASC X12, EDIFACT, AS2, FTP.

EDI Transactions : 850,856,810,860,855,997.

Description:

The Assa Abloy Group is a Swedish lock manufacturer and is the world's largest lock manufacturer by sales volume. Assa Abloy was formed in 1994 when ASSA AB was detached from Swedish security firm Securitas AB. Shortly thereafter, the Finnish high-security lock manufacturer Abloy Oy (a subsidiary of the Finnish company Wärtsilä) was acquired.

Responsibilities:

Have to understand the business needs and provide the solution that best fits into the business of the customer and overall roadmap for Assa Abloy.

Create/review requirement spec/documentation for technical viability.

Developing SAP IDOC to EDI maps.

Monitoring the whole EDI application (full O2C cycle), UNIX servers and ensuring that the whole Business Cycle runs smoothly without any interruption.

In case of error scenario, analyze error and we will fix it.

Preparing Sterling Integrator maps according to business requirements.

Modification of existing maps according to Trading Partner Requirement.

Developed & tested EDI maps X12 standards

Monitoring and verifying whether EDI transactions are on time and resending file in case of any outbound interruption, requesting the Trading partner to resend the file if we haven’t received it on time.

Test translation and mapping functionality of all new maps.

Update documentation of all new maps with changes made.

3.Medical Mutual of Ohio (MMOH) (Cleveland, OH):-

Client : Medical Mutual Commercial /government enrollment.

Role : EDI Analyst.

Duration of project : April 2014 – Sept 2018

Relevant SCI Products : SI, Map Editor of SI.

Relevant Technologies : EDI, IKA Systems, IBM Cognos, Microsoft Access, Excel, Word, and Visio flowchart.

EDI Transactions : 834, 837, 835, 270, 271, 997.

Description:

Medical Mutual of Ohio (MMOH) is an American mutual health insurance company. It is the oldest and largest health insurance company based in Cleveland, Ohio, and serves more than 1.6 million customers.

Responsibilities:

Analyze and understand requirements of the project.

Create/review requirement spec/documentation for technical viability.

Identify technical risks, probable solutions and escalate to stakeholders in a timely manner.

Need to estimate and plan efforts for the project – I have to prioritize tasks and proactively communicate roadblocks.

Develop the GIS maps (TP specific) which translate EDI data to Application Files.

Loading the data to IKA Systems.

Sending the members data to Centers for Medicaid and Medicare (CMS) for data review.

Responsible for the development, analysis, and trending of membership information.

Serves as liaison between information systems/technology, finance, marketing and other operational departments.

Coordinate departmental projects, formulate needed process enhancements, and work with internal and external customers to maintain the integrity of membership data.

Enroll commercial group members in selected plans for medical, dental, and pharmacy coverage.

Process enrollment transactions, including resolving incomplete elections, Transaction reply reports from CMS and investigating enrollment Discrepancies.

Review/resolve demographic, enrollment and financial discrepancies and report errors to CMS for resolution.

Identify data integrity issues, system and programming problems and implement solutions.

Create INBOUND and OUTBOUND flows for each TP. This includes creating envelopes, deploy the maps and BP’s for the end to end flow.

Share a wide knowledge on EDI, X12, EDIFACT.

Understanding the EDI file and translating EDI files to FACETS DATA. (EE10 format)

Weekly status reports are sent to the manager to demonstrate the progress being made on each TP.

Participate in cross functional work groups to resolve process failures, created process improvement and share with team.

Trouble shooting and reporting the root cause analysis to the customers as per the SLA.

To participate in the flow design and discussion with the customer and create a Business requirements document (BRD) and a communication design document.

To provide feedback to Sales, Product Development and Customer Support to improve quality of software and service solutions, consulting proposals and customer satisfaction.

To represent Sterling Commerce, IKA systems, Cognos reporting tool to customer with professionalism always.

Personal Details:

Date of Birth: 3rd July, 1993.

Marital Status: Married

Nationality: Indian

Languages known: English, Hindi, Telugu.

Madhuri Nallala

Mobile Number: +1-248-***-****

Location: Detroit, MI.

EMail: ***************@*****.***

Contact this candidate