Remigio Malig
Lodi,WI
Summary
Business technology professional with over 20 years experience in providing business workflow solutions and 12 years in the Mortgage Banking Industry.
Overview
27
27
years of professional experience
Work History
Custom Data Solution Analyst
Interlinq Software Corporation (Bellevue, Washington)
12.1998
- Implementation and Data Conversions
- Developed data interfaces to SQL Server and MS Access database platforms
- Provided Technical support for SQL Server and MS Access
- Created custom reports with Crystal Reports
National Product Trainer
Interlinq Software Corporation (Bellevue, Washington)
12.1998
- Trained clients on mortgage servicing system from install to production
- Assisted as a software support and technical support
- Trained clients on Crystal Reports
- Instructed at company’s annual MortgageWare Users Group (MUG)
BI Analyst II
Subzero Wolf Cove Group
07.2023 - Current
- Provided data analysis on Data Migration and Temporary Integration between legacy and future state systems
- Collaborated with SME and Stakeholders on issues and address resolution.
Sr. Metrics Analyst
American Family Insurance
09.2017 - 07.2023
- Led Google Cloud Platform/Looker Studio Conversion from Green Plum/Tableau
- Setup meetings to discuss project plan and timelines, created new datasets/report visualization using Big Query/Looker Studio, reached out to Business Partners for additional requirements and UAT Approval, and provide status updates to leadership
- Other Projects provide requirements gathering, data analysis, and report visualization
- Data Analysis on trending business production like; submissions, quotes, bind counts, bound premiums, and agent comp programs using GCP BigQuery, Looker Studio, Trifacta, WinSQL, SAS, and Tableau
- Ad-hoc Report Request as business areas continue to grow/change provide new reports to support department/company goals with the use of Looker Studio and Tableau
- Additional Role Responsibilities Engage SME on reporting requirements Create Datasets/Data Wrangling Maintain Monthly Report Distribution Data Governance Steward
Analytics Consultant
UW Medical Foundation
06.2011 - 09.2017
- Led Radiology Imaging by Location
- Collaborated with the Head of Radiology to create a dataset and report visualization that would be utilized across the Enterprise by departments and doctors
- Other Projects provide requirements gathering, data analysis, and report visualization
- Developed clinical reports with BO Crystal Reports or Web Intelligence
- Primary focus on Radiology and Ambulatory for ad-hoc report requests
Business Analyst
Pomeroy IT
09.2008 - 04.2009
- Create databases for various company sites for the purpose of reporting company wide computer re-image and replacement project
- This included the inventory and monitoring of hardware and software (Tier1, Tier2 and Tier3) install for each user
- Assist the Project Manager with data confirmation
- Facilitate the new asset schedule between the user and engineer and provide daily management reports on the progress.
Business Analyst Consultant
Teamsoft Inc.
03.2008 - 09.2008
- On enterprise level projects, serve as the primary business analyst in scoping out the project with business managers and project sponsors and in identifying subject matter experts (SME) during the discovery meeting
- Deliver business and functional requirements gathered from SME elicitation meetings
- This includes use case scenarios for each event, sub-functional requirements, data mapping, system interface requirements and appendices
- Conduct the business specification review with the business and technology departments
- Participate in UAT deployment that includes data validation and regression testing
- Provide business reports through Business Objects and Crystal Reports 10 tools.
Business Analyst / MS Access Developer
MortgageIT, Inc. (Middleton, WI)
12.2005 - 03.2008
- Developed, Trained Business Community and Provided User Support for Client Server applications (MS Access platform)
- Managed multiple workflow applications
- Provided Data Analysis and Reports Company Wide
- 2006 Employee of the year
Data Conversion Analyst - Transfer and Conversion
Dovenmuehle Mortgage, Inc. (Schaumburg, IL)
11.2004 - 12.2005
- Perform Data Mapping and Data Analysis on Mortgage Servicing and Mortgage Origination Systems
- Balance and reconcile conversion data to company standards
- Provide conversion support to Core Team Members
- Provide conversion reports
New Loan Boarding Manager
CUNA Mutual Mortgage Corporation (Madison, Wisconsin)
03.2003 - 07.2004
- Managed 12 Full Time Employees
- Met department production goals
- Resolved loan information discrepancies
- Reviewed overall department workflow process
- Special Projects Passport Report Manager
- Trained staff on the usage of Passport Reports
- Provided requested reports on a timely manner
- Worked with Section Managers in identifying report options
- Applications Developed and Deployed into Mortgage Servicing Management Operations Report (MOR)
- Loan Tracking System Application Administrator
- Provided Technical Support for Loan Origination System
- Provided support on loan product setup
- Created Business Rules
- Crystal Reports Writer
- Created and updated VMP mortgage forms
- Developed and Deployed Access Database
- Variable Compensation Program that tracks the Account Executive production
- Broker Incentive Program that tracks Broker production
Assistant Mortgage Servicing Manager
CUNA Credit Union (Madison, Wisconsin)
12.1996 - 12.1998
- Setup/maintained Mortgage Servicing Database and applications
- Managed escrow accounts/payment processing/bank reconciliation/payoffs
- Fulfilled Investor reporting requirements
- Trained staff on the servicing system
- Provided customer service for members, lenders and title companies
Education
Programmer Analyst -
Madison College
05.2011
North Central University
05.1989
Skills
- Looker Studio
- SAS
- Tableau
- Crystal Reports
- Business Objects
- Visio
- MS Project
- SharePoint
- Teams
- Google Cloud Platform (GCP)
- Green Plum
- MYSQL
- SQL Server
- Oracle
- MS Access
- Data Warehousing
- Agile Methodology
- Power BI
- Snowflake
Timeline
BI Analyst II
Subzero Wolf Cove Group
07.2023 - Current
Sr. Metrics Analyst
American Family Insurance
09.2017 - 07.2023
Analytics Consultant
UW Medical Foundation
06.2011 - 09.2017
Business Analyst
Pomeroy IT
09.2008 - 04.2009
Business Analyst Consultant
Teamsoft Inc.
03.2008 - 09.2008
Business Analyst / MS Access Developer
MortgageIT, Inc. (Middleton, WI)
12.2005 - 03.2008
Data Conversion Analyst - Transfer and Conversion
Dovenmuehle Mortgage, Inc. (Schaumburg, IL)
11.2004 - 12.2005
New Loan Boarding Manager
CUNA Mutual Mortgage Corporation (Madison, Wisconsin)
03.2003 - 07.2004
Custom Data Solution Analyst
Interlinq Software Corporation (Bellevue, Washington)
12.1998
National Product Trainer
Interlinq Software Corporation (Bellevue, Washington)
12.1998
Assistant Mortgage Servicing Manager
CUNA Credit Union (Madison, Wisconsin)
12.1996 - 12.1998
Programmer Analyst -
Madison College
North Central University
Similar Profiles
null null
Soccer Referee, Tutor at Washington Youth, Bellevue High SchoolSoccer Referee, Tutor at Washington Youth, Bellevue High School
Robin BatsonRobin Batson
Coordinating Manager LV A at Health and Hospitals Corporation / BellevueCoordinating Manager LV A at Health and Hospitals Corporation / Bellevue
Dadren GoodrichDadren Goodrich
IT Coordinator at Shawn Washington Accountancy CorporationIT Coordinator at Shawn Washington Accountancy Corporation
Bethany GricusBethany Gricus
Registered Nurse at SSM Health, St. Mary's HospitalRegistered Nurse at SSM Health, St. Mary's Hospital
Ryan SordahlRyan Sordahl
Steel Cutter at Endres ManufacturingSteel Cutter at Endres Manufacturing