Alan Donati

ad1syj@r.postjobfree.com * 508-***-****

** ******* ** **** ******

Whitinsville, MA 01588 (will support 100% remote in EST hours)

https://www.linkedin.com/in/alandonati

Education:

Bachelor of Arts – Management - Organizational Behaviour - Lesley University, Cambridge, MA – 1984

MCP - MCSA/MCSE (Win 2000) - MCDBA (Win 2000/.net) ID # 2909553 (July 2003)

Technical Skills:

SQL (Toad, PL/SQL, Visual Studio, SSMS)

SAS Enterprise Guide (v8.5)

Monarch / Greenplum / IBM Showcase

Enterprise Data Warehouse

PeopleSoft SA ver. 8x & 9

PSCS Student Records & Financials

P&C – Personal/Commercial Lines

SharePoint/Confluence/Wiki

CRM/Salesforce

Guidewire/e-CLAS/Various PAS

Process & Workflows

MS-SQL Server Mgmt. Studio

MS Project / Visio / Access

MS DevOpts/Jira/Spira

SDLC, SCRUM & Agile

Cognos/Einstein Analytics/Tableau

MS Word / Excel / PowerPoint

MS SQL Server / ORACLE RDMS

Area of Expertise:

Broad Business Analysis and Testing experience that includes fully integrated ERP Systems that crosses; P & C Personal and Commercial Lines, Health Insurance, Manufacturing, Finance, CRM, Student Information and Management Systems, E-Commerce, E-Learning, AML/Fraud Case Mgmt. Systems & Wealth Management

Responsible for "Balance and Control Data Verification" process across Legacy and new Policy Administration Systems and the Enterprise Data Warehouse (EDW) covering Premium (Written and Earned), Claims, Incurred Losses, Cash and Fees (Direct and Indirect), Agencies and management and regulatory reporting.

Responsible for providing support as a Finance Department SME to two major Guidewire Software implementation projects with my focus being data integrity at all levels within Guidewire's Policy, Claims, Billing, and Info Center and thru to MAPFRE’s Enterprise Data Warehouse (EDW)

Provided direct functional lead support to the Student Financials and Financial Aid Departments at UMMS, which included a major upgrade of PeopleSoft Campus Solutions from 8.2 to 9.0, implementation of a custom 1098T reporting modules.

Demonstrated skill at RDBMS data analysis, data mapping of legacy data sets to centralized data marts and data warehouses, data profiling, and investigation to determine the integrity of data being captured at the UI Level and to support data integration with external business systems, using data analysis tools; SAS, Showcase, P/L SQL, Excel, Cognos, and Einstein Analytics.

Responsible for providing training, consulting, and ad hoc report generation for various members of the Finance Department using various querying and report generations tools, such as SAS Enterprise Guide, GreenPlum, Showcase Query (IBM), PL/SQL, Toad for Oracle, Toad Data Point, Cognos, Excel and Monarch.

Successfully implemented a Web Based (Dot Net) “Conflict of Interest” application for the UMMS HR Dept. that provided “Online” Training and Certification that would allow UMMS Employees to fulfil the State’s mandated requirement which include the integration with the PS HR application.

Proven expertise with all phases of the software development life cycle (SDLC) and Agile. Including business requirements discovery and analysis, process and workflow analysis, Use Case Modelling, User Interface design, systems integration, system and user acceptance testing, documentation, production support and user training.

Professional Experience:

Cincinnati Financial Corp (Remote) (Planet Technology Group - Contract)

Business Systems and Process Analyst APR 2023 – PRESENT

As part of the e-CLAS Enterprise System Agile Team, I provide on-going BA support to all team members covering system infrastructure enhancements, major projects, Epics/Stories, Spikes, Incidents for all Cincinnati Insurance Company’s (CIC) Commercial Lines of Business across 48 States.

My BA role covers, new and modifications to requirements functional and technical, Process Flow and Process Improvements, all phases of testing (Unit, System, UAT and Prod Verification) and Stakeholder Demos.

Bank of America (Remote) (NTT DATA - Contract)

Data Systems Analyst Oct 2022 – Mar 2023

As part of the Finance Solutions Group (Data Mgmt & Tech Strategies) providing on-going support covering BAU issues for Cash, Treasury and Investment Securities related to SEC Regulatory Report for all BOA entities worldwide.

Extensive experience in SQL querying, including creating complex queries and managing large datasets.

Work extensively with SQL queries for database integrity and data validation.

Supported roles cover, break-fix analysis, modifications to requirements (Jira), all phases of testing (Unit, System, UAT and Prod Verification).

Arrowhead General Insurance Agency (contract) (Remote) San Diego, CA

Business Systems Analyst Apr 2022 – Sep 2022

As part of the Core Commercial/Manufactured Housing team working on AIG’s transition to a new Policy Admin System.

Responsible for the gathering and documenting all business requirements, translating them into detailed technical requirements, data analysis and system testing relating to the ISO reporting.

Performed data analytics by extracting data using SQL and other tools such as Oracle to improve functionality and efficiency of the system.

Responsible for the requirements and design of a detail Premium reconciliation process between the new PAS and Arrowhead’s Billing system.

Utilized SQL language in creating, editing the database and in performing queries.

Fidelity Corporation (Eliasson Group - Contract) (Remote) Smithfield, RI

Principle Data Analyst at No. Sep 2021 – Feb 2022

As part of the Live Channel Reporting (LCR) Agile Squad, responsible for the analysis and validation of all Performance Insight KPI dashboards related data in support of Fidelity's enterprise-wide salesforce performance and opportunities tracking and reporting initiative.

Designed development and deployment is done using well defined Agile based procedures and practices.

Participated in all Agile related activities and provide data related test case design and execution.

Execution of SQL queries using SELECT statements to gather data as needed.

Aipso Johnston, RI -

System Analyst Dec 2020 – Jul 2021

As a member of the Stingray Project team, responsible for the documentation of System Level Process Flow diagrams.

The development and tracking of Business Requirements Documents (BRD) in an Agile project framework.

Supported the month end corporate reporting reconciliation process for the finance group using MS-SQL Server Mgmt. Studio.

MAPFRE USA - Data Integrity Group (Finance), Webster, MA

Financial Systems Analyst Feb 2014 – Nov 2020

Worked in Data Governance and Integrity Dept, responsible to provide ongoing support as a Finance SME on various types of projects crossing all areas with P&C, with most of my efforts focusing on insuring that the integrity of MAPFRE's source data is maintained using SAS Enterprise Guide as the main data analysis and reporting tool.

As part of the Guidewire implementation team, I Provided Financial SME support, data analysis and conformance and testing for MAPFRE’s centralized data warehouse (EDW) and provided enterprise-wide on-going support for the PC, CC, BC and Info Center.

Responsible for the daily reporting of Incurred Losses (Actuals and Trends) to MAPFRE Senior Management.

Responsible for building and maintain Finance related Cognos dashboards and queries for various individuals against MAPFRE's Enterprise Data Warehouse (EDW).

Responsible for the oversite of open problem tickets (Incidents) by coordinating with various Tech Teams by managing Priorities, SMEs, Integration Testing resources.

Worked included gathering business and system requirements, creating user stories, writing complex SQL queries, and using APIs. Additional duties are, support, regression testing, implementing new feature requests, data mapping.

Citizen Bank (CFG) (NCS Technologies, NJ - Contract)

Sr. Business Systems Analyst Feb 2012 – Jan 2014

Worked in RDP supporting the enterprise-wide replacement of Citizen’s legacy Commercial Loan Origination applications.

Responsible to provide detail defect and issues resolution tracking to all internal downstream clients.

This includes Issues tracking, initial verification and triage, multi-platform data analysis and reconciliation, internal resource coordination, progress, and resolution tracking, testing and all status reporting communications to both internal and downstream customers.

Citizen Bank (CFG) (NCS East Greenwich, RI - Contract)

Sr. Business Systems Analyst Jul 2011- Dec 2011

Created both “Current and Future State” Process Maps.

Was directly responsible for the gathering, detailing, cataloguing, and documenting of 500+ business requirements that covered all functional areas, from across CFG’s US domestic enterprise footprint, that oversee/manage all types of financial crime and fraud.

Created a (30+) external business systems integration profile maps that detailed their functional relationships and the type of data traffic that transverse the integration points.

Proved analysis support in the vetting and selection of a replacement of their “AML/Fraud Case Management System”.

University of Mass Medical School, Worcester, MA

Sr. Business Systems Analyst Jun 2006 – May 2011

Provided direct production support (P1 and Non-P1) and end user documentation and training.

Identified areas were delivered PSCS functionality that could be used to solve a business requirement.

Analysed, tested, and implemented PSCS configuration enhancements and changes.

Utilized Toad, PL/SQL, Access and Excel for data analysis and validation.

Analysed and defined end user requirements and translated them into business requirements.

DentaQuest Ventures (Parent Company of Delta Dental of MA), Charlestown, MA

SR. Business Systems Analyst Mar 2004 – Jun 2006

Provided business systems support to a broad-based user community by developing business requirements and specifications; designed and executed testing and end user training on both small and large complex projects.

Performed troubleshooting and analysis to identify and assess root cause of application and data issues.

Analysed and defined end user requirements and translate them into business system requirements for their Policy Administration System (PAS) and the CRM application.

Verizon Corporation – (Corpus Inc.), Boston, MA

Project Manager May 2003 – Nov 2003

Established and implemented PMO project level performance measurement criteria, Established weekly reporting methods requirements for all project teams.

Provided timely and accurate project performance and status reporting via the “PMO Scorecard” to senior level management and project level mentoring metrics to delivery team management and key team members.

Wilson Language Training Corp., Oxford, MA

ERP & E-Learning Systems Manager / Project Manager / DBA Apr 1999 – Apr 2003

Conducted a complete enterprise-wide Business Systems needs assessment, managed the “Best of Breed” ERP/CRM/LMS solution selection process, and managed (full life cycle responsibility) the design, development and implementation of a fully integrated CRM, ERP & Student Information Management System.

Database Technologies, Inc., Wellesley, MA

Pre-Sales Consultant/Oracle Developer Jul 1998 – Apr 1999

Created RFP and RFI proposals and project estimates provided extensive involvement in project planning and requirements analysis, participated in the creation of “Rules of Engagement” and the establishment of multilevel reporting requirements, member of the “TQM” team, provided technical sales support and training and post-engagement assessments.

Contact this candidate