Business Analyst

Resume of

Norman A Sizelove

SUMMARY:

I am an IT Professional with experience in the Financial Management, Health Care, and Software industries

I have held many different roles as they relate to enterprise systems including Business Analyst, Software Engineer, QA Tester, Project Leader, and Production Support Analyst

I have had the opportunity to work on a variety of platforms including Unix/Linux Servers, HP3000 mainframes, SQL Servers and PCs

SKILLS:

AMISYS, Financial Asset Mgt, Salesforce, Agile, Microsoft TFS, PL/SQL, TOAD, HTML, COBOL, Remedy, MS Office, JavaScript, SQL plus, JIRA, PVCS, Oracle, Visual Studio, ServiceNow

PROFESSIONAL EXPERIENCE:

Health New England, Springfield, MA March 2018-June 2018

Application Programmer/Analyst

Worked Remotely with a Team in different parts of the country maintaining and modifying an enhanced Health Insurance management system known as Amisys Advance

Attended daily Skype Meetings to review requirement emails from the business stakeholders and internal developers. This included using the ServiceNow incident reporting system

Designed and modified multiple SQL queries to aid in incident data collection

Dorcas International Institute of Rhode Island, Providence, RI November 2017-March 2018

Database Analyst

Worked Remotely from Massachusetts with a Team in Rhode Island gathering specifications for modifications to an enhanced case management system known as FamCare

Scheduled and ran GoTo Meeting sessions to document requirements with the business stakeholders and third-party package developers. This included using Microsoft Word and Excel while specs were being developed and documented

Designed and modified multiple SQL queries and advanced ad-hoc Microsoft T-SQL query reporting scripts

Provided instruction in Intermediate and Advanced T-SQL script writing to the other stakeholders so that they could do their own reporting scripts

Mercer Health and Benefits Administration, LLC, Norwood, MA March 2017-September 2017

Business Analyst

Worked within an agile team framework to produce software enhancements during 3 to 4 week sprints. This included staying 2 sprints ahead in requirements gathering

Scheduled and ran grooming sessions to document product requirements with the business stakeholders and developers

This included using flowcharts and Microsoft Team Foundation Server while specs were being developed and documented

Assisted and performed QA when resources were of short supply during regression testing of Client User Portal

Wrote Business Requirements Documents (BRD) for Carrier files enrollment, premium, and commissions ETL processes for upload into a Salesforce database

Performed analysis and requirements gathering for BRD documenting transition from Medicare HICN to Medicare Beneficiary Id (MBI) in all aspects of the business

Translated file layouts of csv files into functional ETL requirements

Commonwealth of Mass., Dept. of Children & Families, Boston, MA September 2011-December 2016

Business Analyst

Performed analysis and wrote business requirements for redesign of consumer financial accounting system. This included process flow diagrams, activity diagrams, proposed state, new functional requirements, SQL scripts and test scenarios

Arranged and ran meetings to discuss project requirements with stakeholders. This included requirement elicitation using prototypes while specs were being developed

Performed data analysis using PL/SQL and Excel of payment calculations for products that were being re-visioned. This included QA of all models during regression testing

Wrote impact statement and functional specs for travel accounting system upgrade

Maintained and enhanced daily financial data extracts originating from a locally accessed Oracle database that were translated into XML and transmitted to the Comptroller's office for loading into their State-wide database

Supported team efforts related to QA testing new releases of web-based products converted from Oracle Forms and Reports to Java Servlet API

Health New England, Springfield, MA November 2009-September 2011

Sr. Programmer/Analyst

Analyzed and designed application for daily Medicaid claims feed to 3M Virtual Windows Machine for processing of DRG assignments

Maintained Data Analysis spreadsheet macros in VBA for actuarial accounting

Assisted in conversion of batch extract shell scripts for Amisys Advance Rel. 1 to Rel. 5

Analyzed and Revised EDI 837 feed to third party vendor for claims pricing and update

Rewrote Data Warehouse ETL job in PL/SQL to reduce processing time by 75%

Harvard Pilgrim Health Care, Boston, MA November 2008-April 2009

Sr. Programmer/Analyst Consultant

Coordinated shutdown of legacy Amisys system jobs and reports by analyzing impact of cross system jobs and Quiz/QTP Reports and modifying them for decommission

Analyzed, designed and wrote ad-hoc Data Analysis report in Quiz specifying Claim Type codes and their concentration among employer groups

Amisys technical SME (Subject Matter Expert) for Business Requirement Documents, Technical Design Specs and code walk-thru meetings with offshore vendor

The offshore vendor was responsible for the actual coding of the reports or projects as described in the documents we assembled

Wellington Management, Boston, MA August 1998-February 2008

IT Consultant

As lead Business Analyst in a multi-year project to migrate and at the same time re-design all the Client Services reports my responsibility was to follow the AGILE style of systems development

Duties included meeting with end users to develop business requirements and to develop functional specs for offshore development team. This also included using the Mercury Test Director software

Performed data analysis and QA testing using PL/SQL on an add-in for Microsoft Excel known as Stat-Server which retrieves aggregated Fixed Asset, Equity and Trading Transaction statistics from an Oracle database and pastes them into a spreadsheet

Wrote scenario matrix test requirements documents to thoroughly test and QA new Asset Management reports and processes in a white-box test environment

Worked with development team to maintain and enhance client extranet web portal

Wrote more than a hundred SQL scripts using complex unions with sub queries and outer joins to validate data, provide quick data reporting by exporting to Excel and sending to the business user, and creating the SQL structure for future Oracle reports

Provided systems analysis on new futures activities reports for Client Services Department. These were a hybrid of holdings, transactions, and compliance reports. The reports were coded for an Oracle environment on a UNIX platform and developed offshore

Developed scores of Asset Management Reports on an HP3000 system using the Powerhouse applications Quiz and QTP. Also wrote and modified Quick screens to create more efficient data entry and control

EDUCATION:

Northeastern University, Boston, MA

BSBA in MIS, Class of 1993, Cum Laude

CERTIFICATION:

Northeastern University, Boston, MA

Certification in Internet Technologies, June 2001

International Institute of Business Analysts (IIBA)

Member

Studying for the CBAP Certification Exam

Modern Analyst.com

Member

Email: *********@***.***

Mobile: 508-***-****

Contact this candidate