Jairo Portillo Email & Phone Number

United States

White Oak, Maryland, United States

• Provide client support on a federal contract
• Establish new data entry processes for reporting purposes
• Automate manual tasks using macro-enabled Excel tools
• Analyze client project data to generate statistics on program’s overall effectiveness
• Provide support on web development calls

Linthicum, MD

• Provided client support on the Maryland Medicaid Behavioral Health contract
• Served as a liaison between IT developer staff and internal clinical team/client regarding health IT web applications and file extracts (claims, authorizations, reviews, etc)
• Gathered and analyzed requirements from stakeholders
• Created and maintained documents such as data mappings, specifications, test plans, and standard operating procedures
• Coordinated user acceptance testing for application enhancements and conducted unit testing for file extracts
• Developed SQL queries to perform data analysis and regression testing on data extracts/file interfaces

Hunt Valley, MD

• Served as a data interface lead providing expertise across multiple clients, colleagues, and developers
• Gathered requirements from clients for data exchanges such as payroll and HRIS and translated them into technical requirements and specifications for development
• Conducted unit testing and regression testing for file extracts
• Created SQL queries for client reporting purposes and data extract validation
• Managed and provided guidance to junior members with requirements, specifications, data mappings, and testing for vendor interface projects (EDI 834, delimited, fixed width)
• Facilitated team discussions with vendors to track project status and provide updates

Hunt Valley, MD

• Created and maintained documents specific to vendor interfaces (data mappings, specifications, test plans, standard operating procedures)
• Managed and processed vendor files in various formats such as EDI 834, delimited, and fixed width
• Unit tested and regression tested changes to file interfaces
• Reviewed XML and output files to resolve any file errors and escalated to appropriate teams as needed
• Familiarized new team members with client specific processes through trainings and SOPs

Hunt Valley, MD

• Managed daily manual processes for multiple clients
• Monitored inbound and outbound file transmissions to ensure they were received and sent successfully
• Reviewed vendor file processing reports and corrected/escalated issues as needed

Rockville, MD

• Provided user support by troubleshooting software and hardware related issues
• Coordinated desktop replacements and migrations with end users
• Conducted IT asset inventory (workstations, printers, etc.)

Bachelor Of Science (B.S.), Management Information Systems, General

Activities and Societies: Hispanic Latino Student Union, Golden Key International Honor Society Concentration in Network Administration

Associate Of Arts (Aa), Management Information Systems, General