SUMMARY:

• Confidential is a seasoned Systems Analyst with more than 18 years of experience in healthcare, finance, and manufacturing. He has expertise in analysis, design, development, testing, and implementation of software applications—with a strong focus in Electronic Data Interchange (EDI) and electronic B2B commerce systems.
• His strengths include excellent verbal and written customer service. Identifying file format and layout issues and inaccuracies, project management, and resolving production issues.
• He has been instrumental in document development, communications, and interaction with internal and external clients.
• He is recognized by management and peers as an effective problem solver and collaborative team player and ability to work across functions, locations, businesses and countries.

TECHNICAL SKILLS:

Databases: SAP, EPIC, MSAccess, MS Outlook, Informatica, Windows, Outlook, SQL, CITRIX, TSOC, TSOA, Hogan, PEP++, MTEC Financial, TPRP, COBC, EDIFECTS, ERMA, COGNOS, EPIC, CRA, EDISOFT

GUI/Tools: Mercator, MS Project, Visio, Curam eligibility system, Access, Word, Excel, Crystal Reports, APM, Power Point, Worldship, Wealthcare, EV1 BR6, BR7, Dashboard, Hogan, CLEO VL TRADER, Sterling B2B Integrator, Informatica, Cosbach, IPSwitch, Automic, Putty, Service Now

Industry Standards: HIPAA, ANSI X - 12, XML, HTML, ICD-9, ICD-10.

Platforms: UNIX, Mainframe, AS400, RS6000, SAP, Agile, JAVA Scripts

Testing Tools: EPIC, SAP, Playground, Mercator, Sterling Commerce, Gentran, TPRQ, COBAL, Remedy 7.1, ECPROD, TSOC, TSOA, VLTrader, Black-box

PROFESSIONAL EXPERIENCE:

Confidential

Managed File Transfer Specialist

Responsibilities:

• Screen and Migrate from Control Enterprise to Sterling File Gateway - ARP, ACH, EDI, ATM, Credit Card, Cash Letter file transmissions for new and existing clients.
• Screen Account IDs, Transmit IDs, and Dataset Names (DSNs) to ensure all active transmissions are included in migration and report to Project Managers and department/product leadership of any discrepancies.
• Create Accounts (Partners) and Routing Channels (Contracts) in SFG.
• Create Login IDs and Passwords in Unbound ID, Decommissioned aged files in SFG.
• Work as Liaison between Client and Confidential IC’s and Project Managers.
• Developed and install protocol for implementations using operating systems UNIX, Windows, Windows Server and Sterling Integrator. VMWARE used in windows server for Security controls.
• Communication Protocols: AS2, HTTPS, SFTP, FTP, SSH, SSL, FTPS, and X12 Mainframe and SI communication setup. LAN/WAN used to confirm file transmissions were accurate prior to production. Key and Password Authentication, Cert Manager.
• Working in conjunction with compliance department, conduct security incident investigations and complete security incident reports. SSRS process
• Install and test PGP keys for Data encryption in and out and create Matrix for correct transmission.
• Extensive use of TSOA, TSOB, TSOC and mainframe CA7 operations for production installation. UNIX, GXS/Webmethods
• Perform QA analysis for production implementation.
• Extensive use of HOGAN, ITS, ITSM, AS2, and B2B, Putty, UNIX, WINDOWS, Sterling Integrator processing.

Confidential

Production Operations Analyst

• Set up of all new vendors on MFT tool VLTrader - installing PGP Keys for SFTP testing and test for direct file transfers. Encrypted transmissions before and/or after delivery before the move to production.
• SSRS as a building reporting tool to create reports of lesser complexity .
• Proficient knowledge of HIPPA transaction code set.
• X12 and communication Protocols SSH, SRTP. FTP HTTPS.
• Performed QA and implementation into production.
• Monitored for successful results. Performed new file and connectivity changes and development using Informatica.
• Provided 24 hour on-call support. Created tasks, processed, and completed tasks and production tickets using ServiceNow tool.
• Managed deployments from DEV to QA and Prod. Responsible for accurate workflow processes using Informatica.
• Consulted with client and organized daily stand-up Scrum meetings.
• Served as liaison between level two and three support - for production failures. Successfully troubleshot all errors. Set up requested FTP/SFTP sites.
• Installed public and private keys for encryption and decryption of data files. Verified connectivity and communications of testing with vendors and headed up kick-off meetings.
• Used Informatica to schedule, stop, start, and install workflows and worklets per DBA specs and ServiceNow process. Automic scheduler to schedule workflows and migrations.
• Used COSBATCH for production failures to locate error and restart production workflows.
• Provided 24-hour pager support.
• Completed project successfully.

Confidential

EDI Systems Analyst

• Implemented Migrated and processed new clients into system for open enrollment. Produced, developed, maintained, and troubleshot EDI files. Used Vlookup and pivot tables process to locate and match and migrate clients.
• Health care 270/271 and IBM-Curam eligibility system.
• Worked and assisted MN.IT vendors to complete the build out of EDI files to include automated 820s. Effectuation files, audit files, a federal 834 file and any changes needed to support renewal of current enrollees during the Fall 2014 open enrollment period.
• Responded to questions and issues from carriers about EDI files, reporting of anomalies within the testing period.
• Produced and transmitted enrollment files to carriers twice per week. Extensive use of pivot tables to automatically sort, count total or give the average of the data stored in one table or spreadsheet.
• Worked with IT vendors to review and finalize 834 EDI companion guides.

Confidential

Systems Migration Analyst

• Responsible for the migration of existing file transfers TRAFIC to a new managed file transfer (MFT) tool VL Trader and testing and implementation into production.
• Installed and updated PGP Keys for connectivity and encrypted transmissions.
• Installed public and private keys for encryption and decryption of data files. Verified connectivity and communications of testing with vendors and headed up kick-off meetings.
• Used Agile with documentation in weekly Scrum meetings.
• Coordinated and communicated with external and internal customers processing test files for accuracy.
• Set up and tested file transfers in MFT and document and manage the list of file transfers to migrate.
• Decommissioned old file transfers using Java and JavaScript, APIs and XML UNIX, vi editor and transfer protocols FTP, FTPS, SSH, SFTP, FTP, AS2, AS3, and MQ

Confidential

New Implementation/EDI Business Analyst

• Developed and implemented production shell for new clients and trading partner open enrollment.
• Managed integration projects of multiple client products and services.
• Managed use case interactions between a role (known in unified modeling language (UML) as an "actor") and a system, to achieve a set goal.
• Designed technical spreadsheet with active macros for production processing.
• Implemented and processed 834 file for all new clients and troubleshoot production failures.
• Used problem solving skills to resolve complex technical issues with internal and external clients.
• Created functional macros.
• Assisted in automating a business report to help ensure uniformity, reduce errors, and increase time available for the manager - so she could devote time to other areas. Extensive use of SharePoint, Excel and SAP.

Confidential

System Analyst/EDI Coordinator

• Worked with business units and created and documented file requirements and worked with a team to set-up and support interfacing with clients and partners directly to answer questions and walkthrough Confidential file requirements and reporting capabilities.
• Held project management responsibilities including planning, tracking, and reporting on project statuses.
• Responsible for kickoff meetings with multiple carriers to include pharmacy, COBRA, medical and dental enrollment. Worked with internal business and technical teams to set and coordinate dates and requests relating to EDI development for both benefit open enrollments and new client implementations.
• Collaborated with business and technical teams, clients and partners to define written technical file requirements.
• Worked with technical team to create/update projects and tasks using project management software.
• Provided project stakeholders regular project updates via conferences and emails.
• Mastered EDI transfer methods and file compression and encryption methods (SFTP, FTP, PGP, Zip, etc.) evaluating and scrutinizing data files for their completeness and conformance to specifications
• Administered benefits including COBRA, medical, dental, Medicare Advantage, vision, EAP, life, FSA related reimbursement accounts). Developed and worked test plans.
• Created and updated instructional manuals, process documents, and other EDI related files and forms.
• Troubleshot EDI related questions and issues with 834 file processing.

Confidential

Systems/Business Analyst

• Gathered requirements and wrote specifications for Canada merger.
• Designed technical spreadsheet for new store openings. Collaborated with business and technical teams, clients and partners to define written technical file requirements.
• Implemented on-line global documents to be used ordering products to implement into new Canadian stores. Instrumental in creating functional macros.
• Used SharePoint and SAP.

Confidential

Business Analyst

• Worked with end users to configure, design, and build the application or master file to meet business requirements. Responsible for pricing analysis billing and supplies. Performed daily production on mainframe and eliminated errors in transmission.
• Performed weekly Lawson Software product implementations. Developed import spreadsheet and successfully implemented for production. Served as a liaison with IS and outside vendors to maintain, enhance, and upgrade current technology tools.
• Worked with Epic and other vendors as necessary on procedure master file and charge router capabilities. Processed weekly new item add and product re-mapping using Lawson Software. QA Tester in test and production.
• Activated and tested new transactions and maps prior to production; monitored completion of production transactions.
• Responsible for ICD09 and ICD10 mapping - quality assurance and supply chain.
• Created department wide technical documentation for processes.
• Used Excel and Access for extensive report budget mapping and reporting.

Confidential

EDI Business Process Analyst

• Performed requirement gathering and writing of specifications for new conversion.
• Health care 270/271 and IBM-Curam eligibility system.
• Wrote use case scenario for project plan. Created specs for developers to implement system upgrades and changes.
• Worked directly with the customer to understand, assess and interpret business needs, understand current and future product offerings and be an active participant in the development of a solution
• Upgraded software system to enhance reporting.
• Created documentation for project planning upgrade.

Confidential

Business Analyst

• Directed and participated in the creation of business requirements documents (BRDs) and functional specification reports (FSR) by working closing with the business users and determining the business needs for developing new or enhancing existing applications.
• Used Microsoft Outlook and SharePoint for discussion, project management and scheduling.
• Responsibilities included requirement gathering and writing specifications and wireframes for new conversion for front end business.
• Upgraded Target software system from Rockport to IMS and MIB 8.1 and 8.2.
• Created documentation for project planning.

Confidential

Business Systems EDI Analyst

• Used Microsoft Outlook and SharePoint for discussion and project management.
• Performed user acceptance and regression testing for all divisions.
• Rans daily and weekly reports production reports.
• Created RACI and project plan for daily processes.
• Created hyperlinks keeping global research current.
• Reformatted special projects using Access and excel to allow global project for accuracy.
• Provided production support and problem resolution; kept errors below 10%.
• Worked project to convert 4010 to 5010 translation.

Confidential

EDI Business Analyst

• Provided registration, testing and production support to outside providers, billing services and clearing houses; tested, approved and implemented new providers, billing services and clearinghouses into production for live transmission of electronic 834 files, claims increasing departmental revenue 25%.
• Created documentation for production support to assist with correcting errors and file failures; documentation used as learning tool for new employees and to assist current employees to resolve issue quicker and more efficiently eliminating down time.
• Set up new trading partners; reviewed and approved registration surveys from new providers, billing services and clearinghouses and set up for electronic transmission of claims.
• Analyzed and manually corrected time sensitive file failures; re-tested and reprocessed edited files in order to meet production deadlines, decreasing production downtime by 25%. Gathered all the specifications and requirements to ensure HIPAA/CMS compliance.
• Initiated new documentation program to assist in training new employees; drastically improved learning curve and improved departmental quality.
• Volunteered to take on additional production responsibilities due to low staffing.
• Chosen as top customer service performer within department due to willingness to oversee high priority weekend calls; resolved all issues within 24-hour period.

Confidential

EDI Business Analyst/Vendor Manager

• Ensured timely EDI activities involving QA and E-commerce; led daily EDI and UCC-128 label development.
• Worked with vendors and solved on going issues and partner with SDF product managers to provide feedback input and problem resolution.
• Provided analysis and solutions across all ANSI X-12 versions 3060 and above.
• Tested and provided initial data validations around key data elements for various EDI documents (204, 990, 212, 214, 210, 810, 820, 850, 855, 860, 823, 855, 856, 834, 835,837).
• Performed month end journal entries, including all AP releases and accruals.
• Set up and maintained all new and existing trading partners and setup communication protocols.
• Decreased retail charge backs by 90% in the first year; suggested new software which allowed for all specifications, gathered requirements, tested and implemented software.
• Utilized analyzing tools to troubleshoot failed production files and resolve inbound and outbound shipping delays.
• Verified website specification changes for retail clients; created parallel procedures and deactivated/activated on deadline dates. Allowed for zero delay into production with new formats.
• Saved significant dollars and increased productivity by bringing barcode creation in-house.
• Oversaw file schedules and reviewing load reports.

Confidential

Customer Service/Technical Support

• Provided phone support for National Hearing Aid products; troubleshot and assisted diagnosis of products, services and delivered quality customer service.
• Turned around negative customer relationships by supplying requested deliverables within 24 hours.
• Led daily support of hearing aid dispensaries on West Coast.
• Ranked consistently in the top 10% of representatives; supervisors received multiple phone calls and letters from customers complimenting customer service skills.
• Discovered faster way to navigate through computer system; presented management with solution which was approved and implemented.

Confidential

EDI Computer Analyst

• Coordinated and managed implementation of electronic data interchange with vendors and customers.
• Conducted new mapping, testing and implementation into production; utilized Mercator 1.4.1-2.1 for mapping.
• Managed EDI projects, internal and external training and developed 850, 810, 820 and 855 maps in ANSI X-12 formats.
• Set up communication on IBM Global VAN and documentation development.
• Set up new customers for retail banking increasing customer base by 10%.