Andrew T. Hussey

adgct1@r.postjobfree.com

978-***-****

Background Summary:

Experienced Business Analyst that works well independently or in groups while maintaining a team player mentality. Strong history of interacting in a positive manner with outside groups to achieve team goals. Thrives in a learning atmosphere and has a willingness to share attained knowledge. Able to prioritize multiple projects with strict deadlines to achieve desired results. Well versed in multiple software methodologies. Very comfortable interfacing with Product Managers, Developers, or other team members to assist in creating and clarifying business requirements for software enhancements and new applications. Seasoned test case writer, regression tester and UAT verifier for end-to-end software development. Technical Skills:

Software Methodology: Software Development Life Cycle, Waterfall, Scrum, Agile Operating Systems: Windows XP, Linux/Unix

Database: Oracle, Sybase, Rapid SQL, PL/SQL Developer, MySQL, SQL Developer, Microsoft SQL Server Management, Toad, Informatica, Salesforce

Web Browsers: Chrome, Firefox, Internet Explorer, Safari, Netscape Source Control: SVN, MKS Integrity, Confluence, ClearQuest, Sharepoint Office Productivity: Microsoft Office: Word, Excel, Access, Lync, Visio & PowerPoint; NotePad++, UltraEdit, Altova XML Spy, CISCO Jabber & Webex

Defect Tracking: JIRA, Rational Team Concert, NetCRM, Internal Bug Trackers Automation: QTP (Test Automation), AppWorx 8 & 9 (Production Automation), Selenium IDE Networking Tools: Remote Desktop Connection, VPN, Samba Server, puTTY, FTP Spider Languages: Proficient: HTML, SQL

Comprehend: XML, XSLT, CSS, JavaScript, Visual Basic

\\

Working Experience:

State Street Global Advisors, Greater Boston Area (April 2016 – March 2020) System Analyst – Contractor, Data Systems Development

• ClearQuest duties constitute project management responsibilities includes creating records, advancing records through the build process (i.e. DEV & UAT) and the authority to modify records. Only managers can approve the advancement from UAT to PROD.

• Defining business requirements while also providing clarifications between business users and developers.

• RTC duties constitute project management responsibilities such as creating Sprints & work items, monitoring & maintenance of work items within Sprints, working with Developers to drive their tasks to completion and reporting queried metric-based information.

• Host scrum meetings with our Boston and Bengaluru NSRD Teams to keep team on same page and Sprints on track.

• Provide quality assurance support for Non-Securities Reference Data web application, as well as Client Master, Salesforce and Product Master; testing efforts address enhancements, defects, ensure data integration between applications and service issue requests.

• Testing methods include functional, SQL analysis, regression, user acceptance tests and performance measures.

• Use SQL to fulfill support requests and extracting data for various reporting needs.

• Developer responsibilities include implementing and Salesforce requirements that includes configuring new functionality to be captured by Informatica mapping to flow downstream to other applications and in some cases back to Salesforce. Liberty Mutual Insurance Group, Portsmouth, NH (August 2015 – December 2015) IT Business Analyst – Contractor, HS-End User Technology – IT Video Solutions

Populated existing reports by analyzing pulled data from Remedy’s application “Analytics - Remedy Reports” (e.g. Incidents, Service Request Management, etc…) and teams’ SharePoint site that has been exported to Excel spreadsheets (e.g. ‘Team Stats’).

Redesign reports while ensuring accuracy, minimizing maintenance and enhancing metrics using available data.

Used IT Metrics Report Server to replicate existing reports (e.g. ‘Actuals vs. Allocations’, ‘Incident Detail’, etc…) to identify pros and cons.

Based off of own report and spreadsheets from Clarity worked with team to ensure their allocated hours reflected reality.

Performed work on the Video Solutions SharePoint site (i.e. Webcast Metrics Export, Calendar Views) to cleanse data by editing or removing items; thus ensuring accuracy of data and increasing efficiency of data being selected for reporting.

Familiarized myself with BuySmart in order to create reports on what Video Solutions spent in capital, in maintenance and other expenses types.

Liberty Mutual Insurance Group, Dover, NH (September 2014 – May 2015) Business Analyst – Contractor, CI-Group Benefits: Business Support Services

Conducts production-oriented activities by entering and extracting information from various applications and systems

(e.g. SystemOne, RTC, SPELL Admin, Contact Manager, etc…).

Point person to address immediate needs; an example of this would be to provide fix to enable claims to process or update customer contact details.

Used SQL to proactively identify and eliminate potential immediate needs; this not only cleans customer accounts, but eliminates work for other departments.

Work with other departments to coordinate activities and project work in order to ensure that Liberty meets customer expectations.

QC and monitor my own testing efforts and provide support until completed.

Assist others by providing QC to their own testing efforts and oversee them to completion.

Assists in problem resolution to ensure that customers receive prompt, efficient service in accordance with company policies. EBSCO Information Services, Ipswich, MA – August 2001 to December 2013 Quality Assurance Engineer (December 2006 – December 2013)

• Responsibility is to the stakeholders and project team testing both relational databases and internal software.

• Responsibility to the QA team was not only to use best practices, but to improve upon them.

• Interfaced with project team and stakeholders to translate requirements into a test scope and an executable test plan that includes user acceptance tests.

• For Designers & Developers we ensure the integrity of setup and design specifications for both presence and functional development; respectively.

• Methods of testing regularly included specification-based, regression, smoke, black box, white box and UAT. We were not limited to these testing methods; when called for we were versed in other strategies (e.g. gray box, positive/negative, boundary, performance, etc…); when part of test scope we would validate the data transformation.

• For Production Operators we ensure the integrity of the end-to-end work flow build process of a product from installation to Live.

• We constantly assess the tools we use and seek improvements in those tools and/or practices in which those tools are used.

• Part of company's automation initiative in both contributions to the process (wrote use case scenarios for the automation team) and maintenance (key contact for problem solving).

• Used SQL when possible to aid in the QA/QC process and maintain accuracy within the Production Automation tables.

• Key contact for handling service issues; created a reporting dashboard in JIRA to track various points of interest.

• Project Lead for several high visibility products & projects. E-Content Team Leader (May 2004 – December 2006)

Key administrative duties included incorporating Serial methods with existing procedures and implement new techniques designed to improve work flow and increase efficiency.

Provide support and perform maintenance of database queries used to assist in processing, tracking and reporting activities within e- Content.Establish and keep a good business rapport with the company's top publishers and key aggregators to maintain a solid contact in the acquisition of electronic data.

Responsible for the accuracy of the information on the publications within our records as it relates to e-Content.

Ability to identify multiple means in which to process a publication and the knowledge to use the varying techniques to accomplish our goal...process electronic content.

Authorized to execute changes to processing procedures out of necessity and/or best interest of company (cost effectiveness).Oversee production in which unique specialized processing is used on content. Serials Team Leader (April 2002 – May 2004)

Revamped procedures to improve work flow; enhancing communications and augmenting accountability within the group.

Key administrative duties included providing support and perform maintenance of database queries used to assist in processing, tracking and reporting activities within Serials.

Establish and create a good business rapport with my assigned publishers to maintain solid contacts for the acquisition of hard copies.

Instilled an environment for learning and encouraged cross-training.

Internal liaison for incoming and outgoing departmental correspondence.

Responsible for assigning/amending appropriate processes to all new or existing publications; includes what/where to be processed. Content Expansion Team Leader (August 2001 – April 2002)

Key administrative duties were to resolve the team's processing problems and setup publications for processing.

Group was responsible for sourcing, receiving and tracking publications.

When required scanned publications for processing &/or inputted table of contents information.

** More job experience available upon request.

Education: Fitchburg State College, Fitchburg, MA (September 1994 – May 1999)

Majored in Business with a concentration in Marketing.

Contact this candidate