Amanda Ho Email and Phone Number

• Graduated from Front-End Web Development Liberty Mutual GoForCode Program with The Iron Yard. • Developed applications using Agile SCRUM software development processes.• Implemented stories using Java, JavaScript, and HTML that supported the atWork Center of Excellence Application reducing underwriting assistants’ manual work.• Implemented tasks using Java, JavaScript, and HTML for iUnderwrite Hazards Assessment and Quality Assessment Applications helping underwriting experts.• Participated in end of sprint demos with the business to elicit feedback and make any necessary changes.• Ability to trouble shoot and debug tasks and production issues.• Created and demonstrated proof of concept for the AWS Serverless Application Model and Serverless Framework to determine which one should be used for the event notification service.• Worked on developing a serverless event notification service using AWS Resources (API Gateway, Lambda, S3, SQS Queue, DynamoDB) using typescript and the AWS Cloud Development Kit Framework.

Business System Analyst II - Information Management Business Intelligence 05/2015 – 06/2016• Responsible for leading business requirements elicitation sessions with internal and external business stakeholders to document project systems requirements for the Loss and Active Data Warehouse.• Managed 24 different internal and external business stakeholders’ data impacts for the Workers Compensation Bill Review system transition.• Managed competing priorities from multiple stakeholders making decisions and compromises to benefit all.• Supported change management procedures for assigned projects by facilitating research and analysis needed to determine impacts to stakeholders. • Authored source-to-target mapping documents for the Loss Data Warehouse to its internal and external downstream deliveries.• Conducted and designed User Acceptance Testing to ensure new system behaviors align with business requirements and data mapping documents.• Developed and defined all new data elements for the Data Standards and Definitions to support data quality between systems.• Partnered with IT developers to design and document system specification for new IBM Cognos Workspace Advanced Reports to support reporting requirements for business stakeholders.• Supported business stakeholder transition from legacy information warehouse reporting tool to IBM Cognos Workspace Advanced. Authored detailed user guide and provided training sessions to new users.

• Led Medicare and System Payment Ledger Reporting projects. Gathered and evaluated business requirements and maintained comprehensive documentation on SharePoint. • Developed managerial training on reporting infrastructure and IBM Cognos Query Studio. • Researched and built 1042S Foreign Payments and Claims Entry reports using Excel and SQL. • Resolved problems in the Loss Prevention enhancement project to ensure data integrity. • Conducted testing to ensure that requirements for IBM Congos releases and major data conversions are met.• Coordinated application upgrade to WrExpert Pro. Researched integration functionality and data process flows.

Business Systems Analyst II - Claims Technology Reporting Team 03/2013 – 06/2014Business Systems Analyst I 12/2011 – 02/2013 • Identified reporting defects and production issues by using SAS and SQL to query problematic claims.• Served as liaison between the business community and software developers. Translated business requirements into functional and technical specifications for the development team.• Documented rules, requirements, process flows, test cases, and use cases in HP Quality Center. Developed automated tests for monthly regression testing.• Resolved million dollar reporting out of balance issues between the claims system and the financial system by querying, researching, and compiling data errors. • Provided mentorship and training to new Business Systems Analysts by covering the Claims Reporting structure and processes.

Bodily Injury Claim Specialist II - Claims Rotational Program 02/2011 – 11/2011Auto Physical Damage Claim Specialist I - Claims Rotational Program 06/2010 – 02/2011 • Investigated, researched, and evaluated auto and bodily injury claims. Interacted with customers, lawyers, insurance companies, and auto body shops to determine appropriate course of action. Applied sound judgment to negotiate fair claim settlements.• Provided on the job training for new employees. Participated in university recruiting event. Presented department functions and responsibilities to job candidates.

Managed the Unix Server inventory and resolved discrepancies in preparation for the Data Center migration project. Updated client cost allocations for newly deployed servers.

Compiled and validated customer data for a class action law suit. Conducted teleconference to review customer information for a settlement. Researched emerging risks, wrote a summary paper, and recommended next steps on Mobile Social Technologies, Financial Social Technologies, and Air Powered Cars.

Authored and published employee communications on behalf of the Claims senior management team. Researched and created a PowerPoint presentation and wrote speaking points for the senior vice president. Coordinated the Allstate Brickyard 400 recognition event, which included a recognition dinner and ceremony.