SUMMARY

• Expertise in mapping of EDI standards ANSI X12, UN/EDIFACT, fixed - width flat files and delimited flat files with different kinds of documents.
• Thorough knowledge and hands on experience in designing process models (BPM), Tempo application with SAILs, CDTs, data store, records, tasks, feeds, actions, rules, documents, templates, smart services, functions.
• Good experience with sail code developing queries, expression rules and interfaces.
• Worked with Business to understand their requirement and design and develop them into to process flows and models within Appian.
• Involved in validations, Flows and Process Modular design using Appian.
• Strong knowledge on Healthcare, Retail and supply chain of EDI transactions.
• Hands-on experience in Healthcare domain and handled different healthcare claims.
• Highly skilled in creating maps in inbound and outbound EDI interfaces for 277/276, 277CA, 837 I/P/D, 835 etc.
• Experience in writing SQL queries in SQL Server and Oracle.
• Experienced in integrating different File formats on Integration Server.
• Hands-on experience in handling different data formats - ANSI X12 EDI, EDIFACTS, XML.
• Worked on 4010 and 5010 versions of EDI
• Worked on different EDI Products like EDIFECS, Sterling B2B Integrator, and Sterling File Gateway.
• Worked on developing new EDI UN/EDIFACT and ANSI X12 maps
• Expertise in creating EDI guidelines for Trading Partners
• Expertise in using various text editors like notepad, notepad++, text pad, WordPad in the process of analyzing the EDI text. Hands on experience with networking protocols like TCP/IP, SMTP, HTTP, FTP and AS2.
• Proficient experience in map reviews, integration and end-user support.
• Good knowledge in agile methodology and project life cycle.
• Expertise in handling Healthcare EDI claims 837I and 837P and 835 ERA
• Excellent written, presentation and verbal communication skills.
• Worked on Tableau version 10.2 to develop Interactive Dashboards on EDI data.

TECHNICAL SKILLS

EDI Platform: Sterling B2b Integrator, Sybase translator (ECMap), EDIFECS

BPM Tools: Appian 17.X and 18.1

Operating System: Windows, UNIX.

Application Software: Microsoft Office, Microsoft Visio.

Data Formats: ANSI X12 EDI, EDIFACT, XML, IDOC.

Languages: SQL, PL/SQL, Shell Scripting, JavaScript, Appian SAIL.

Transaction sets: 850, 855, 810, 856, 834, 835, 837I/P/D, 277.

Databases: SQL Server, Oracle DB, MS-Access, IBM DB2, MS-Excel.

IDE: Eclipse, Microsoft Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

EDI Developer

Responsibilities:

• Good knowledge of Software development life cycle and application design.
• Worked on 5010 and 4010versions of X12 Transactions.
• Worked on data base programming including development of views, functions and strong experience in writing SQL queries in oracle database.
• Data analysis for reporting data layouts of all mapped transactions.
• Participated as a member of development team and lead a small development team.
• Worked on creating EDI mapping guidelines and worked onboarding the new trading partners
• Independently Developed maps on Sybase Translator
• Worked on EDI Transactions (837 I/P/D, 834, 835, 276/277, 277CA).
• Provide EDI analysis/development support to post production support team
• Participated in code reviews and lead code reviews.
• Testing the input files and rules for data transformation for all EDI related data rules.
• Involved in Designing, preparing and executing the unit tests.
• Write, analyse, review, and rewrite programs, using workflow chart and diagram, by applying the knowledge of computer capabilities, subject matter, and symbolic logic.
• Write code using Batch (C/UNIX/SQL) and queries in SQL RDBMS and SQL batch.
• Monitor job cycles and make appropriate changes to the jobs if needed.
• Confirm program operation by conducting tests; modifying program sequence and/or codes.
• Tableau site and server administrator
• Implementation of multiple VMs for the Tableau server
• Creation of new sites with multiple dashboards/Metrics connected to the database
• Database Support for Oracle Financials Applications
• Support Backend and Frontend of Oracle E-Business Suite Application
• Kronos implementation support
• Responsible for Metrics and business intelligence reports for higher management
• Created BPM workflows in Appian using the process modeler.
• Understanding the Business requirements and converting the functional requirement to specifications and design.
• Participated in code reviews and Functional review of the application. unit tested each part of my code and provided release notes and unit test document before deployment
• Worked with the team to maintain and support existing Appian applications.
• Handled the Approval from workflow and notifications.
• Defect Fixing & issue resolution for the application developed.
• With the help of SAIL coding created interfaces & expression rules and created CDT's as per the process requirements.
• Created process models for the work flows and worked on the record types to display multiple record views for the users to review up-to-date status of the designated candidates.
• Involved in development of Appian sites as needed for the users.
• Worked on different smart services.
• Managed end-to- end application support for all Appian applications deployed.
• Involved in requirements gathering with stake holders.
• Modified existing interfaces adding multiple validations allowing them to use new Constants and query rules created.
• Ensured that the risks are mitigated appropriately, and Technical Debt is addressed as soon as technically and organizationally feasible.

Confidential, Moline, IL

EDI Analyst/ Developer

Responsibilities:

• Partnered with business stakeholders to translate high level business requirements into detailed business/process functional specification in order to implement a technological solution for projects or process.
• Collaborated with cross functional teams (ISG, JDIS Dealer Solutions, MKC, and IKC) to ensure alignment on project timelines, requirements, application dependencies, integration testing.
• Analyzed, Designed, developed, tested and implemented EDI transactions with new and existing trading partners using the Sterling Gentran translator
• Perform all EDI administrative and development work including communications setup (FTP,AS2), mapping, and relationship setup for the clients SAP system using Gentran Server for windows
• Implemented Gentran Server for windows.
• Worked on EDI X12 transactions like 850,855,810,856 and also EDIFACTS formats like ORDERS, ORDERSP, ORDCHG, INVOIC.
• Wrote complex SQL queries for validating the data against different kinds of reports.
• Worked with Excel Pivot tables.
• Monitoring and troubleshooting the operations of all EDI transactions as they flow through Gentran and SAP, including AS2, VAN communications.
• Apply project management standards ensuring issues are identified, tracked, reported on and resolved in a timely manner; communicates status and escalates open/unresolved issues when necessary.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Confidential

Jr. EDI Developer

Responsibilities:

• Requirement Assessment
• On-boarding partners
• Understanding scope of B2B and implementing
• Used Sql and Xl data transformation for data mapping by implementing Excel macro VLOOKUP for data verification and transformation as per business rules.
• Understanding the mapping documents. Enhanced map as per business requirement.
• Testing the input files and rules for data transformation for all EDI related data rules.
• Developed reports involved in Regression and Functional Testing cycles.
• Have experience on both the X12 & EDIFACT Standards and XML & IDOC's.
• Analysis of defects in existing systems.
• Involved in modification of Existing Maps in Visual Mapper, Application Integrator & Map Editor.
• Documents and UTP (Unit Test Plan).
• Analysing & debugging the existing code.
• Involved in Component and Unit Test
• Communication of project status effectively to the management and client.
• Implemented data transformation as per provided business rules.
• Involved in production support.