Analyst

Michael R. Amrine

Independently performed project management and business analyst responsibilities for information systems,

development and support efforts. Focused on projects of extremely high risk, complexity and visibility. Included

resource allocation, all phases of a development life cycle, i.e., feasibility study, requirements, analysis, design,

programming, testing, and implementation planning. Managed the IS relationship with all levels of customer

management. Frequent contact with all levels of customer management is expected. Ensured system quality and

conformance to standards.

Coordinated and directed the activities of all levels of consultants on a project team which performed the traditional

functions of systems analysis, design and program development in the implementation of business-information

systems. Exchanged ideas, information and opinions with Business and Technical Analysts to arrive at decisions,

conclusions, solutions, or solve disputes.

Expertise in: HR Business Processes, Payroll Systems, Retail Sales, Database Management and

Design, Project/Program Management, IS Management, UAT Testing, Helpdesk

support, Rational rose methodology, Agile SCRUM methodology

Software: Oracle, SAP-R3, MS Office, Access and Project, Quicken, QuickBooks, MS Visio,

Lotus Notes, ADP Payroll, IBM Rational Rose,

Language: SQL, PL/SQL, HTML

Operating Systems: Windows 9x/ME/2000/XP/7, Solaris, Linux

Education:

• Masters of Arts, Anthropology, California State University, Hayward June 1994

Certifications and Post-Graduate Studies:

•Business Administration, Post-graduate Certification, University of California, Santa Cruz Junee 1999

•Information Systems Management, Post-graduate Certification, University of California, Santa Cruz August

1998

•Program and Project Management, Post-graduate Certification, San Jose State University, May 1997

SELECTED ACHIEVEMENTS

• Over the last several projects I have collected data used in the complying of, and wrote Use Care Scenarios

and Business Rule Documents (BRD). Using such tools as Visio I have co-authored Functional Design

Documents (FDD), and Technical Design Document (TDD) following the methodologies such as IBM's

Rational Rose, Sun Microsystems' Sunway, and other Software Development Life Cycle (SDLC)

methodologies. Using project documents, I have created Test Scripts and them in final acceptance Quality

Testing of various client internal software projects. Furthermore employing project documents, and testing

scripts, I have written End User manuals and webinars.

• An online ASP needed a library database of retail consumer food and drug products built and ready to use

within seven months. Due to project scope, lead a team of various disciplines in the development and

implementation of database to support the companies’ needs and clients. Using standards developed for Data

Stewards the team mapped out Logical/Physical models to be used in the development a methodology for

defining Specification and Size Estimates for incoming requests. Completed the project within the allotted

time and 13% under the budget.

• Processed backlogged State of Maine overpayments to Healthcare providers for collection. Completely

cleared six months of backlogged overpayments, then forward them to collections teams returning to the

State several million dollars of spent revenue back to the Maine State Treasury. Ran several data queries, then

used the data to map and balance several receivable accounts across multiple accounting software

environments.

PROFESSIONAL EXPERIENCE

Boston Financial Data Services – Augusta, ME

May 2013 – Present

Analyst

• Conferred with customers by telephone to provide information about products or services, cancel accounts, or

obtain details of complaints.

• Checked to ensure that appropriate changes were made to resolve customers' problems.

• Kept records of customer interactions or transactions, recording details of inquiries, complaints, or

comments, as well as actions taken.

• Resolve customers' complaints by performing activities such as exchanging merchandise, refunding money,

or adjusting bills.

• Completed contract forms, prepared change of address records, or issued service discontinuance orders, using

computers.

• Referred unresolved customer grievances to designated departments for further investigation.

• Contacted customers to respond to inquiries or to notify them of claim investigation results or any planned

adjustments.

State Of Maine DHHS – Augusta, ME

May 2010 – April 2013

Business Intelligence Analyst

• Provided system analysis, design, development and deployment of BI applications

• Worked directly with customers, analysts and vendors to develop, articulate, and document a project

approach

• Provided thorough documentation of all BI applications and processes to be used in the event of equipment or

system failure.

• Daily use of SQL and PL/SQL for scripting and database analysis needs

• Assisted in the integration efforts for merging BI platforms with enterprise systems and applications.

• Ensured compatibility and interoperability of BI systems.

• Debugged program logic in a structured and organized manner.

Idexx Laboratories – Portland, ME

October 2008 – February 2009

Data Analyst

• Monitored and performed data transmission and proper operation of sensors

• Validated data for periodic summary reports and for use by other groups.

• Designed, developed, deployed and maintained desktop and web applications and databases using PL/SQL

and SQL server

• Followed and applied best practices for code development and storage and participated in code reviews.

• Ensured and performed testing of all major feature releases.

State of Maine DHHS – Scarborough, ME

December 2007 – March 2008

Sr. Business System Analyst

• Gathered and analyzed reporting requirements using SQL Server and Microsoft Excel

• Delivered actionable output

• Tuned techniques to speed-up performance

• Designed data structures in SQL environment

• Integrated the reporting applications with vendor platform, and communicated with business and vendors for

correct platform performance

• Troubleshot operational production problems

State Street Bank - Milton, MA

February 2007 – August 2007

Project Management/Business System Analyst (State Street Bank)

• Daily use of Business Intelligence tools, particularly Crystal Reports for financial reporting

• Administered project activities and milestones

• Recognized changes in scope and ensured apt planning measures

• Coordinated with company and corporate partners

• Corresponded with stakeholders and outlined problems

• Imparted aid in resolving program challenges

Cardinal Health, Woburn, MA

March 2004 – February 2007

Business Analyst

• Managed business objectives and needs into system deliverables.

• Assisted management team on business analysis.

• Coordinated with business, marketing and finance.

• Established aspects of deployment effort.

• Corresponded with and established technical resources.

Sicklebrook Systems, Inc. – Lexington, MA

January 2003 – February 2004

Business Analyst

• Designed and developed SQL Server Integration packages.

• Generated reports using SQL Server Reporting Services.

• Conceptualized solutions by analyzing user requirements.

• Performed Unit Testing and QA and participated in monthly release cycle.

• Participated in code and peer reviews.

• Ensured to adhere to firm standards and policies.

ShopEaze Systems Inc, Sunnyvale, CA

December 1999 – June 2001

Database Content Development Manager

• Monitored and performed data transmission and proper operation of sensors.

• Validated data for periodic summary reports and for use by other groups.

• Designed, developed, deployed and maintained desktop and web applications and databases.

• Followed and applied best practices for code development and storage and participated in code reviews.

• Ensured and performed testing of all major feature releases.

Sun Microsystems, Palo Alto, CA

March 1995 – December 1999

Business Analyst

• Served as Business Analyst for the Global rollout of Oracle 10.7 to Sun Microsystems’ other three

Accounting Centers.

• Responsible for the initial planning migration from Oracle 10.7 to Oracle 11i, after the decision had been

made to pass Oracle 11 in favor of Oracle 11i.

• Authored Business Rule Documents (BRD) and Functional Design Documents (FDD) using Sun

Microsystems’ Sunway SDLC methodology to map out processes used in developing tools for various in-

house programs and projects. The initial modules used were Accounts Receivable, Accounts Payable and

General Ledger.

USDA National Resource Conservation Service, Anchorage, AK

June 1991 – December 1994

Senior Field Archaeologist

• Authored training material for NRCS staff in the identification, classification and proper care of Cultural

resource as governed by Federal Legislation.

• Monitored various federally funded projects for the detection and identification of Cultural Resource Sites

throughout the eleven western states and Pacific territories.

• Conducted field surveys on public and private land for the purpose of identifying, recording Pre-historic and

Historic Cultural Resource sites for the preservation and protection as governed by Federal Legislation, prior

to the commencement of construction or changes in the landscape.

• Built a MS Access database used in the tracking the storage of cultural resources recovered from NRCS

projects.

• Authored and internal published field reports and papers

San Jose State University Foundation, San Jose, CA

January 1990 – June 1991

Field Archaeologist

• Participated in the excavation of Native remains, and the collection of various grave goods for study and final

disposition as governed by federal legislation.

• Contributed in the laboratory analysis and cataloging of non-human remains and artifacts recovered from

field excavations.

• Conducted initial site surveys

Ohlone Families Consulting Service, San Jose, CA

September 1989 – January 1990

Field Archaeologist

• Participated in the excavation of Native remains, and the collection of various grave goods for study and final

disposition as governed by federal legislation.

• Contributed in the laboratory analysis and cataloging of non-human remains and artifacts recovered from

field excavations.

• Conducted initial site surveys

Contact this candidate