EXPERIENCE SUMMARY:

• Senior Product Consultant with 13+ years of extensive experience in analysis, design, development and maintenance of projects in Manufacturing, Telecommunication and HealthCare domain.
• Experience in Client/Project Management, Waterfall/Agile software development methodology, Delivery and Risk Management.
• Managed Project/Program level deliverables, defined milestones, risks & mitigation strategies
• Well versed in Requirement Change Management, Gap/Impact Analysis, Defect Tracking, System Integration, and Scheduling.
• Expert in B2B/EAI project execution and led various high profile integration projects successfully.
• Extensively experienced in implementing B2B and EDI solutions using Informatica, EDIFECS, GXS and WebMethods tools.
• Extensively worked on Informatica Data Exchange, Power center workflow/map creation Transaction management, EAM profile creation, administration and integration for Real Time and Batch transactions processing.
• Experienced in creating EDI maps to translate IDOC’s to EDI standards and vice versa using GXS Application integrator, Specbuilder and GXS Enterprise system for external communication.
• Experience in EAI implementation using webMethods Developer, Adapter services, JMS and web services.
• Experience in Cleo Managed File Transfer administration and handled various protocol implementation.
• Experience in SQL Server Integration Services and developed ETL process for Customer Warehouse implementation.
• Experience in HIPAA Operating Rules implementation for various State Medicaid.
• Experience in Informatica/Edifecs installation, setup and administration for Medicaid EDI Program implementation
• Strong Knowledge on Amazon Cloud services, Apache Hadoop, Sqoop, Hive, Dynamo DB, Kinesis, Redshift and Kinesis
• Certified on Amazon Web Services Enterprise Architect - Associate and TOGAF Certified Enterprise Architect
• Worked in AS2, Web services, FTP, SFTP and VAN implementation for B2B interfaces.
• Expertise in handling EDI standards like ANSI X12, EDIFACT and HIPAA mandated transactions (837/835, 270/271, 276/277, 834 and 999/TA1)
• Knowledge on different databases like Oracle, SQL Server, DB2 and also writing PL/SQL procedures and views.
• Experience in migration of systems from legacy to enterprise solution and upgraded many implementation to standardize technology stack.
• Follow product architecture guidelines to deliver best product performance and scalable with ease in maintenance.
• Participated in research of new technologies or tools as necessary to evaluate product for any functional implementation purpose.
• Experienced work in a complex, multi-vendor, geographically diverse environment and offsite-onshore model.

TECHNICAL SKILLS:

B2B/EDI/EAI tools: Informatica Power Center, Data Exchange, Data Transformation, Cleo Managed File Transfer, Edifecs XEngine, XEServer, Transaction Management, GXS Application Integrator, GXS Enterprise System, webMethods Developer, webMethods JDBC/MQ Adapter, Oracle Apps XML gateway message designer, Microsoft SSIS

E-com Frameworks/Web Technologies: HIPAA X12 837,835, 850,855, 270,271, 276,277, 997,999 and TA1, EDIFACT, XML and Web Services.

Software Engineering Methodologies/Tools/Technologies: MS Visual SourceSafe, Clearcase

Databases: SQL Server 2005, Oracle

Operating System: Windows, Linux and AIX

Digital Skills: Amazon Web Services Cloud Architect & TOGAF Certified, Bigdata - Hadoop, Sqoop, Hive, DynamoDB,Redshift

Domain: Manufacturing, Telecommunications, Healthcare

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

B2B/EDI project using Informatica B2B Technical Consultant

Responsibilities:

• Reviewed Business Rule Document(BRD) and attended meetings with business team to understand the requirements
• Strategically Designed end-to-end B2B solution for Confidential B2B Gateway operations to meet Batch and Real Time processing volume, SLA and regulatory changes.
• Document and deliver sizing, high level and detail design, and other documents as required by the project.
• Collaboratively worked with Executive stakeholders including CTO, VP of EDI solutions for key business strategy decision and proposals.
• Extensively evaluated and reviewed Informatica B2B engine and shared the limitations for future software key patches.
• Reviewed infrastructure setup with security, infrastructure and network team and provided recommendations for scalable.
• Managed Onshore/Offshore team (40+) for various small/mid-scale projects.
• Reported Weekly status to stakeholders and review to ensure risks, milestones and deliverables are progressing per plan.
• Guided team with technical direction and make sure the tasks are completed with zero deliverables and adhering to compliance requirements.
• Performed Gap analysis on Informatica solution with WTX solution and addressed the gaps.
• Reviewed EDI Crosswalk and involved in X12 map development for HIPAA transactions 837(I, P, D)/835, 270/271, 276/277, 999, TA1 and 834 transactions and compliance edit configuration.
• Installed B2B Engine, Web services and MQ Module for interface integration.
• Environment Administration & Setup
• Developed Data Exchange Partner Management system module.
• Developed Power Center Map, Workflow to process inbound and outbound batch and real time files and tracking processes.
• Developed Data Transformation maps for X12 to Copybook/XML format and vice versa.
• Developed and Configured Informatica Data Transformation map to integrate with EDIFECS SNIP Validation engine.
• Developed Managed File Transfer Mailbox mechanism for external trading partner and internal interface for file submission/retrieval.
• Developed ETL solution using Informatica Power Center components and enabled automation for migrating partners from DB2 to Data Exchange solution.
• Configured Informatica and EDIFECS Disaster recovery environment and participated in Business Continuity Planning.
• Configured Data Exchange Events, Endpoints, Workflows and Applications for file based routing.
• Configured Informatica Power Center Web Service Hub, Workflow, Data Exchange and Managed file Transfer software
• Created operations maintenance shell scripts to automate services and server level monitoring alerts.
• Upgraded Informatica, EDIFECS, Guidelines and software patches.
• Reviewed Performance test results and tuned processes to meet the Volume/SLA requirements.
• Planned and Lead Go-Live activities for entire EDI solution and Production stabilization period.
• Lead 24x7 Production support and Monitoring team for day-to-day system activities.
• Coordinated with State Medicaid Stakeholders, Fiscal agents, Confidential leadership and support team.
• Provided efficient, high quality technical support services to ensure timely response to queries, resolution of problems.

Software: Informatica Power Center 9.x/10.x, Data Exchange, Data Transformation, Managed File Transfer, MQ adapter, Web service and Shell scripts, UNIX, Oracle and DB2

Confidential, Lewisville, TX

B2B EDI/ HOpR project using Edifecs B2B Technical Consultant

Responsibilities:

• Reviewed Business Rule Document(BRD) and attended meetings with business team to understand the requirements
• Strategically Designed end-to-end B2B solution for New Hampshire and North Dakota Medicaid EDI solutions to meet Batch and Real Time processing volume, tracking requirements, SLA and regulatory changes.
• Document and deliver sizing, high level and detail design, and other documents as required by the project.
• Collaboratively worked with Executive stakeholders including CTO, VP of EDI solutions for key business strategy decision and proposals.
• Reviewed infrastructure setup with security, infrastructure and network team and provided recommendations for scalable.
• Reported Weekly status to stakeholders and review to ensure risks, milestones and deliverables are progressing per plan.
• Guided team with technical direction and make sure the tasks are completed with zero deliverables and adhering to compliance requirements.
• Managed Onshore/Offshore team(12+) on various Enterprise Program implementation
• Performed Gap analysis on State Medicaid Legacy solution with Confidential enterprise solution and addressed the gaps.
• Coordinated with State Medicaid stakeholders for status reporting and users training.
• Review EDI Crosswalk and involved in X12 map development for HIPAA transactions 837(I, P, D), 835,270/271, 276/277, 999, TA1 and 834 transactions and compliance edit configuration.
• Installed EDIFECS XEngine, XEServer, EAM, and Transaction Management on a highly scalable and robust environment.
• Installed EDIFECS HIPAA Operating Rule XEConnect, Datamart and Tableau software.
• Configured Tableau workbooks for Operating Rule Dashboard.
• Configured MQ and JMS queue configuration in EDIFECS XEServer.
• Developed EAM Profile to process inbound and outbound batch and real time files and tracking processes.
• Developed supporting routes to integrate with EDIFECS HIPAA Operating Rule Product suite.
• Developed Transaction Management Partner and Relationship import process.
• Managed Transaction Management Users and XEServer developer community.
• Developed Managed File Transfer Mailbox mechanism for external trading partner and internal interface for file submission/retrieval.
• Configured EDIFECS Disaster recovery environment and defined EDI Business Continuity Plan for State of New Hampshire and North Dakota.
• Designed Proxy service for SOAP WSDL and HTTP MIME application.
• Configured Transaction Management, XEServer and XEngine SNIP Validation requirements.
• Created operations maintenance shell scripts to automate services and server level monitoring alerts.
• Upgraded regular EDIFECS guidelines, patches and ensure the version is up-to-date per HIPAA compliance and software vendor.
• Reviewed Performance test results and tuned processes to meet the Volume/SLA requirements.
• Lead Go-Live activities for 5010 implementation, HOpR implementation and Production stabilization for Medicaid states.
• Lead 24x7 Production support and Monitoring team for day-to-day system activities.
• Coordinated with State Medicaid Stakeholders, Fiscal agents, Confidential leadership and support team.
• Provided efficient, high quality technical support services to ensure timely response to queries, resolution of problems

Software: EDIFECS EAM, TM, XE, XEServer 7.x/8.x, HIPAA Operating Rules Suite, MQ, JMS, Web service, Shell Script, UNIX and Oracle, Tableau.

Confidential, Rochester, NY

B2B/EDI project using GXS Senior EDI Developer

Responsibilities:

• Established Trading Partner setup in GXS Trade Guide and communication mechanism.
• Setup AS2, SFTP, VAN Network connectivity and coordinate with external trading partners.
• Created COS, AI and ES Bridge specific tasks in Enterprise system.
• Upgraded Application Integrator and Enterprise system.
• Developed Application Integrator Map for ANSI X12 850, 855, 860, 810, 820 and 997, EDIFACT ORDERS, INVOIC and TRADACOM INVOCE transactions and translate to IDOC
• Lead and coordinated onshore/offshore support for day-to-day operations.
• Developed Operation maintenance script.
• Performed Weekly maintenance by starting and shutting down EDI applications.
• Performed deployment activities for change request/fix.
• Reviewed Functional Acknowledgement report and resubmit/repost the files to trading partners.
• Monitored and Alerted client stakeholders if we critical issues.
• Documented, reviewed, and verified testing procedures for Quality Assurance and Development standards and policies

Software: GXS Application Integrator, GXS Enterprise system, Shell scripts, Maestro, SAP systems and Oracle.

Confidential, Rochester, NY

B2B/EAI project using webMethods Senior EDI Developer

Responsibilities:

• Developed Flow service to handle web order, parse and route to ERP system.
• Developed map to parse XML and convert to IDOC.
• Configured SFTP adapter to retrieve order from Web portal.
• Configured File system adapter to post order to ERP system.
• Developed Validation service to validate order by doing lookup against master database.
• Configure MQ Services for critical data exchange for key validation.
• Repaired and enhanced additional procedures for order handling.
• Performed deployment activities for change request/fix.
• Documented, reviewed, and verified testing procedures for Quality Assurance and Development standards and policies

Software: WebMethods Developer, webMethods Adapters, Integration server, Shell script, MQ series, Maestro, SAP Systems, Legacy systems, Oracle and UNIX

Confidential, Rochester, NY

Customer Data Integration using SQL Server ETL Developer

Responsibilities:

• Reviewed customer requirements and created analysis document.
• Responsible for development and enhancement of ETL system.
• Developed interface to load source data which includes Customer, Product and Contact data from various web source.
• Developed packages to consolidate all the source data to staging data.
• Developed read and parse data from Dunn & Bradstreet.
• Retrieved Cleansed Account and Contact data and load to marketing data warehouse.
• Configured communication interfaces to send data to D&B for cleansing.
• Monitored daily operational load and notify for any errors.
• Performed deployment activities for change request/fix.

Software: Microsoft SQL Server Integration Services, SQL Server 2005 and Windows Batch

Confidential

EAI project using webMethods EDI Developer

Responsibilities:

• Reviewed customer requirements and created analysis document.
• Responsible for module development and Unit testing.
• Developed Flow service which handles web service request from customer portal.
• Developed and Configured Trading Network packages for file tracking.
• Developed routing mechanism based on publish/subscription model
• Configured Web Methods JDBC adapters to connect with Oracle database and perform SQL operation.
• Configured JMS adapters to configure queue connectivity.
• Configured web services invocation for Clarity application integration.
• Configured Publish and Subscriber model and integrate with Web methods Broker service.
• Performed deployment activities for change request/fix.
• Documented, reviewed, and verified testing procedures for Quality Assurance and Development standards and policies

Software: WebMethods Developer, webMethods Adapters, Integration server, Shell script, UNIX and Oracle.

Confidential

EDI project using XML Gateway EDI Developer

Responsibilities:

• Reviewed customer requirements and created analysis document.
• Responsible for module design, development and Unit testing.
• Map the business transactions with technical artifacts and implement the process flow for H3G and its trading partners.
• Developed inbound maps to load Order to ERP database and vice versa for invoice.
• Configured Connectivity setup for the file transfer and it is implemented using Java.
• Configured trading partner identifiers in XML Gateway Message Designer.
• Developed metadata and import Oracle ERP Order and invoice subset to Message Designer.
• Configured rules to process and defined sequence for Order processing and to generate invoice.

Software: Oracle Apps, XML Gateway Message Designer and Windows

Confidential

B2B/EDI project using GXS EDI Developer

Responsibilities:

• Developed maps using GXS Application integrator for X12 to IDOC conversion for new trading partner setup.
• Enhanced or fix any GXS Application Integrator map issues identified in production system.
• Reviewed exception on orders, correct and submit or coordinate with trading partner.
• Developed archival management using shell script based application for PO retrieval.
• Performed Weekly maintenance by starting and shutting down EDI applications.
• Reviewed Functional Acknowledgement report and resubmit/repost the files to trading partners.
• Performed Post software upgrade testing and report issues.
• Performed Peer review and changes for change request and defect fix.
• Monitored and Alerted client stakeholders if we critical issues.

Software: GXS Application Integrator, GXS Enterprise system, Shell scripts, Maestro, SAP systems and Oracle.