Michael Dubin
Lino Lakes, MN *5014
********@*****.***
Mobile: (651) 245 - 2266
SUMMARY:
Michael is a SQL developer technically skilled in MS Access, Excel, VBA, Sharepoint lists and views, Oracle Forms / Reports and SQL. He has 15 years of experience helping businesses to identify, analyze and execute strategies. He has experience working with people from all levels of management, business users and technical teams. He is looking for a Software Developer opportunity that utilizes his business and technical skill sets to grow within an organization.
TECHNICAL SKILLS:
Access 97 / 2000 / 2003, VBA, VB 5 / 6, ADO, DAO, Jira, JSON, Cloud, SAS, RDBMS, Python, Hadoop, Spark, BI Publisher, Crystal Reports, Teradata, SQL Developer, QMF, T-SQL, SQL Server 2000, 2005, 2008, 2012, 2017, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Modelling, Tableau, Power BI, Data Mapping, Data Governance, Data Warehouse, Data Lake, Data Lakehouse, Data Lineage, Star and Snowflake Schemas, Oracle Essbase, Data Risk Management, Asset Management Domain, Inner and Outer joins, Windows 98 / 2000 / XP, Visio, MS Project, Excel 98 / 2000 / 2003 (with macros), Word 98 / 2000 / 2003, SharePoint, Powerpoint, MS, Oracle 9i / 11i, Oracle Forms / Reports, Power BI Query, Medicare, Medicaid, Medical Claims Management, Order Management, MS PROJECT, HTML, ASP, Visio, Agile (waterfall), COBOL, C#, UNIX.
EXPERIENCE:
Wells Fargo Bank, Minneapolis, MN (hybrid contract) July 2024 – Mar 2025
Business Data Analyst / Technical Writer
Worked as a senior data architect for the software engineering group on Teradata and SQL Server databases.
Wrote and executed UAT test cases for mortgage financial tables and reports.
Performed data discovery on Teradata and SQL Server databases to find patterns, trends, and understand how data is structured.
Wrote and enhanced SQL queries and stored procedures for asset management reports and to compare asset management data between Bronze, Silver and Gold databases.
Responsible for writing data quality rules and implementing them with SQL as data is moved from Bronze to Silver to Gold databases.
Responsible for order management tracking and reporting.
Responsible for data lineage between bronze, silver, and gold databases.
Created and work on business process mapping documents for migration between Bronze and Silver databases.
Attended meetings to convert business requirements into technical requirements.
Worked with a data lake and a data lakehouse for financial data analysis and processing.
Attended daily meetings to discuss Jira tasks and data mapping.
Resolved Jira tasks for server and database decommission and migration and other issues.
Performed data risk management to ensure data accuracy and timely reporting.
Acted as a data steward to ensure data can be used by appropriate departments.
Shimmick Construction, Oakland, CA (remote contract) October 2023 – July 2024
SQL Engineer / Business Analyst / Technical Writer
Worked as a business analyst for the technical migration group.
Created business process mapping documents for migration between two Oracle systems.
Attended daily meetings to convert business requirements into technical requirements and PL/SQL queries.
Wrote and executed UAT test cases for financial and construction tables and reports.
Responsible for order management tracking and reporting.
Performed data discovery in new and old Oracle databases to find patterns, trends, and understand how data is structured.
Responsible for writing data quality rules and implementing them with SQL and Excel for data migration between Oracle systems.
Used PL/SQL Developer and Teradata to write PL/SQL queries to create Excel files that are uploaded into the Oracle Wholesale Data Mart.
Worked with DBAs to ensure data governance across all platforms on star and snowflake schemas.
Used Oracle Essbase for data analytics and reporting on construction projects.
Performed data risk management to ensure data accuracy and timely reporting.
Acted as a data steward to ensure data can be used by appropriate departments.
Used Python to connect to SQL Server and perform financial analysis.
Created and modified Access tables and relationships in repository database.
Used Access to develop macros and queries for daily financial reports.
Wrote VBA code in Access to execute users’ queries for forms and reports.
Created financial reports in Access.
Managed ETL-based data warehouse.
Developed pivot tables in Excel to display data.
Wrote VLOOKUPS and other formulas in Excel to insert and format data.
Created Tableau dashboards for financial project progress data.
Used Visio to create data modelling documents.
Wells Fargo Bank, Saint Louis Park, MN (contract) September 2022 – September 2023
SQL Engineer / Business Analyst / Technical Writer
Worked as a technical analyst for DSOD (developer segregation of duties) group for the Asset Management, Commercial Lending and Accounting departments.
Created new tables and table relationships in SQL Server database.
Performed data discovery in SQL Server to find patterns, trends, and understand how data is structured.
Served as DBA on a SQL Server and Oracle databases to oversee data security and governance.
Responsible for data lineage between SQL Server databases.
Wrote queries in SQL and T-SQL for SSIS packages to format and move data from Excel into SQL Server databases.
Attended meetings to convert business requirements into technical requirements.
Worked with developers and managers to ensure there are no gaps or overlaps in development, and to ensure that only managers apply code to production.
Worked to ensure data governance across SQL Server platforms on star schemas.
Tasks included complaint handling on ad hoc and larger projects.
Attended meetings to convert business requirements into technical requirements.
Wrote SQL to expand and optimize data warehouse.
Prepared documentation for validation testing.
Developed pivot tables in Excel to display data.
Wrote VLOOKUPS and other formulas in Excel to insert and format data.
Data modeling on tables in SQL Server databases in RDBMS.
Met with users to gather requirements.
Wrote business requirements documents, use and test cases.
Performed quality assurance for small and large size projects.
Used TOAD and Teradata to write T-SQL queries for reports.
Used TOAD and Teradata to write T-SQL queries for mortgage data/text mining and analysis.
Used TOAD and Teradata to write T-SQL queries for mortgage data profiling of financial data.
Wrote and tested user stories in Jira.
Wrote documentation for data migration process from SQL Server to Excel.
Worked with different teams to communicate, document and develop throughout the SDLC.
Used Python to connect to SQL Server and perform mathematical analysis.
Performed data migration from SQL Server to Excel.
Designed Sharepoint Online lists and views to store and display HR data.
Used Power BI to design pivot tables and graphs in dashboards to show HR data and perform data analytics.
Helped debug Visual Basic.net code in Visual Studio 2022.
Attended daily meetings to gather requirements and discuss progress.
Used SAS DATA steps for data mining, retrieval, and manipulation and PROC (procedures) for financial data analysis.
Used SAS predictive modeling to determine lines of credit and interest rates for new and current customers.
Worked on entire SDLC lifecycle.
Deluxe Corporation, Minneapolis, MN (contract) March 2022 – July 2022
SQL Engineer / Business Analyst / Technical Writer
Attended meetings to gather requirements on new project.
Wrote a Business Requirements Document (BRD) detailing project details.
Attended meeting to convert business requirements into technical requirements.
Tasks included complaint handling on ad hoc and larger projects.
Worked with different teams to communicate, document and develop throughout the SDLC.
Developed an Access database to view and export financial data to Excel.
Wrote VBA and SQL code using inner and outer joins for creation and formatting of Excel workbooks.
Performed data risk management to ensure data accuracy and timely reporting.
Acted as a data steward to ensure data can be used by appropriate departments.
Prepared documentation for validation testing.
Used Teradata to write T-SQL and SQL queries for data/text mining and analysis in the Wholesale Data Mart.
Attended meetings to convert business requirements into technical requirements.
Used Teradata to write T-SQL and SQL queries for data profiling of revenue and order data.
Gathered requirements and wrote business requirements documents and help files.
Attended weekly meetings to gather requirements and discuss progress.
Used SAS DATA steps for data mining, retrieval, and manipulation and PROC (procedures) for medical data analysis.
Used SAS predictive modeling to determine future financial projections.
Worked on entire SDLC lifecycle.
Used Visio to create data modelling documents.
Wells Fargo Bank, Minneapolis, MN (contract) June 2021 – February 2022
SQL Engineer
Attended Skype meetings to gather information on data migration from SQL Server to Excel and Powerpoint, and Excel automation for the Commercial Lending department.
Created business process mapping documents for migration from Oracle to SQL Server systems (Wholesale Data Mart).
Wrote T-SQL queries for SSIS packages to format and move data from Excel and Access into SQL Server databases on star and snowflake schemas.
Worked with DBAs to ensure data governance across SQL Server and Oracle platforms.
Tasks included complaint handling on smaller and larger projects through a ticketing system.
Wrote a Business Requirements Document (BRD) detailing project details.
Attended meeting to convert business requirements into technical requirements.
Wrote VBA code for Excel automation for asset management data.
Gathered requirements and wrote business requirements documents.
Designed process flows in Visio and wrote documentation for the migration process.
Wrote T-SQL and SQL 2017 queries in RDBMS using inner and outer joins for data migration to Excel and Powerpoint.
Design Tableau dashboards to display mortgage financial data for the US and abroad.
Wrote T-SQL queries for data/text mining and analysis.
Wrote and executed UAT test cases for mortgage financial user interfaces and reports.
Prepared documentation for validation testing.
Wrote and tested user stories in Jira.
Validated acceptance criteria for financial user interfaces and reports.
Data mapping between SQL tables and Excel spreadsheets.
Use Power BI queries for dashboards to display financial data and future projections.
Performed data mitigation from SQL 2017 to Excel.
Used Hadoop and Python (PySpark) to process and analyze large data sets.
Worked on asset management domain.
Used Excel and Word to create data modelling documents.
National Dentex, Falcon Heights, MN (contract) November 2020 – May 2021
Database Developer / SQL Developer / IT Business Analyst / Tableau Developer
Attended Zoom meetings to gather information on migration from Great Plains to Magic Touch billing systems (Wholesale Data Mart).
Created business process mapping documents for migration from Great Plains to Magic Touch billing systems.
Responsible for order management tracking and reporting.
Worked with different teams to communicate, document and develop throughout the SDLC.
Wrote a Business Requirements Document (BRD) detailing project details.
Worked on entire SDLC lifecycle.
Wrote T-SQL queries for data profiling of revenue and dental orders.
Gathered requirements and wrote a business requirements document.
Wrote PL/SQL queries to analyze data and run reports.
Used Oracle Essbase for data analytics and reporting on medical data.
Designed process flows in Visio and write documentation on this process.
Wrote T-SQL and SQL 2017 queries in RDBMS to perform data/text mining and analysis.
Wrote T-SQL and SQL 2017 queries to get data on billing process.
Data mapping between old and new SQL Server tables and Excel spreadsheets.
Used Python to connect to SQL Server and perform mathematical analysis.
Performed data risk management to ensure data accuracy and timely reporting for dashboards.
Use MS Project to manage tasks.
Prepared documentation for validation testing.
Data mitigation from SQL 2017 using inner and outer joins to Excel 8.
Wrote and tested user stories in Jira.
Wrote and executed UAT test cases for financial data, user interfaces and reports.
Validated acceptance criteria for financial data, user interfaces and reports.
Used SAS DATA steps for data retrieval, and manipulation and PROC (procedures) for orders data analysis.
Develop data quality rules and control processes.
Use Tableau to design dashboards for doctors’ orders and perform data analytics.
Use Power BI queries for dashboards to display revenue and orders over different time periods.
Worked with Agile (waterfall) project team on a weekly basis to discuss work progress.
Used Visio to create data modelling documents.
Wells Fargo Bank, Minneapolis, MN (contract) January 2020 – November 2020
SQL Engineer / Project Manager / Business and Data Analyst / VBA developer
Wrote VLOOKUPs and other formulas to query and manipulate data for a digital marketing campaign for the Commercial Lending Department.
Gathered requirements and wrote a business requirements document. Also wrote use cases and test cases.
Wrote queries and stored procedures in SQL Server and Oracle RDBMS to perform data mining and data analysis on an application that dealt with money movement and process flows for wires, and client fund transfers. The results were copied into Excel and turned into pivot tables that were sent to end users. The pivot tables tracked monthly and quarterly data changes and updates for new banking regulations.
Used MS Project to manage tasks.
Wrote queries with PL/SQL to analyze data and run reports.
Created new tables and relationships in Oracle database.
Wrote VBA code for Excel macros to find and highlight data and to move data between workbooks and spreadsheets.
Acted as a liaison between different groups to resolve issues related to web applications database errors. The results were copied into Excel and turned into pivot tables that were sent to end users. The pivot tables tracked monthly error resolutions and updates changes for each group.
Created reports from templates.
Developed and ensured data quality rules and manual control processes.
Found overlaps in data for report financial and budget deliverables.
Worked as a project manager of group from different departments to find and resolve errors in SQL Server and Oracle databases, user interfaces, and spreadsheets.
Use Power BI to create dashboards displaying open and closed errors and groups’ progress in resolving them.
Used T-SQL and SQL for data mitigation from SQL Server 2012 to Access and Excel.
Use Power Query to import data into Excel.
Worked in an Agile (waterfall) project environment.
Worked on asset management domain.
IHC Group, Saint Louis Park, MN (full time) March 2019 – December 2019
SQL Engineer / Data and Reporting Analyst / VBA and SQL Developer / Tableau Developer
Ran monthly, weekly and daily financial and budget reports dealing with commissions and agent sales for internal, Medicare, Medicaid and web applications.
Used MS Project to manage tasks.
Responsible for claims management tracking and reporting.
Wrote SQL Server 2012 queries in RDBMS to perform data mining and analysis on sales, commissions, and claims.
Served as DBA on a SQL Server database to oversee data security and governance.
Created data mapping between SQLServer on star schemas and Access tables.
Used Python to create web applications for healthcare data.
Performed data risk management to ensure data accuracy and timely reporting.
Created queries in T-SQL Server 2012 for reports containing health insurance financial data.
Created Access queries for ad-hoc reports for health insurance vendors.
Developed Sharepoint lists and views to store and filter data.
Used Python to connect to SQL Server and perform complex data analysis.
Wrote a Business Requirements Document (BRD) detailing project details and process flows.
Attend weekly meetings as a project manager dealing with Access integration into SQL and gathering requirements from internal users and health insurance vendors.
Create Tableau reports to display commissions and agent sales and perform data analytics.
Developed data quality rules and manual and system control processes.
Used Power BI to create dashboards on commissions and agent sales and perform data analytics.
Used Power BI queries for dashboards and to import data into Excel.
Worked in an Agile (waterfall) project environment and team.
Data mitigation from SQL 2012 to Access and Excel.
Worked on entire SDLC lifecycle.
Prime Therapeutics, Bloomington, MN (contract) October 2018 – February 2019
Business and Data Analyst / SQL Developer
Attend weekly meetings as a Business Analyst on three projects.
Developing business requirements documentation and process flows.
Write SQL 2012 queries to perform data mining and analysis.
Work in an Agile project environment.
Wells Fargo Bank, Minneapolis, MN (contract) August 2018 – October 2018
SQL Engineer / Business and Data Analyst
Write SQL 2012 code for Excel reports that contain financial data.
Develop Excel pivot tables.
Write SQL 2012 queries to perform data mining and analysis.
Serve as a technical analyst on an application that dealt with money movement and client fund transfers.
Developed data quality rules and manual control processes.
Xcel Energy, Minneapolis, MN (contract) November 2017 – July 2018
SQL Engineer / Business and Data Analyst / Tableau Developer
Write VBA code for Excel macros to process current and past due work orders.
Worked on entire SDLC lifecycle.
Design Sharepoint 2016 lists and views to store and display work orders.
Write SQL 2012 queries in RDBMS to perform data mining and analysis.
Creating VLookups to combine data from different workbooks and worksheets.
Data mitigation from SQL to Access and Excel
Develop Excel pivot tables.
Develop testing workbooks for different Sharepoint lists.
Use MS Project to manage tasks.
Create Tableau reports to display current and past due work orders.
Use Power Query to import data into Excel.
Tasks included complaint handling on smaller and larger projects through a ticketing system.
Worked in an Agile (waterfall) project environment.
Ekster & Associates, Fremont, CA (remote part time) February 2016 – October 2017
SQL Engineer / Project Manager / Business Analyst / VBA and SQL developer
Work as a project manager to enhance project previously worked on.
Work on enhancements to access forms and reports.
Worked with to ensure data governance across all platforms.
Wrote SQL queries for data profiling of different stages of the filtration process.
Maintained ETL-based data warehouse.
Write stored procedures in SQL Server 2012 to process usernames and passwords for new users.
Tasks included complaint handling on smaller and larger projects through a ticketing system.
Use MS Project to manage tasks.
Performed data risk management to ensure data accuracy and timely reporting.
Acted as a data steward to ensure data can be used by appropriate departments.
Write SQL 2012 queries in RDBMS to enhance existing functionality for reports.
Develop use cases, test cases, process flows.
Enhance ETL process between Excel, Access, and SQL Server 2012.
Data mining and data analysis.
Work in an Agile project environment and team.
Optum, Golden Valley, MN (contract) June 2015 – October 2015
Business Analyst
Worked as a technical analyst developing use cases, test cases, process flows and creating and running reports for GPS Medicare and Medicare systems.
Worked in an Agile (waterfall) project environment.
Responsible for claims management tracking and reporting.
I was responsible for attending and leading Rally meetings every morning where the use cases, test cases and process flows are discussed and presented after completing.
Performed quality assurance for web application functionality.
Use MS Project to manage tasks.
I worked as a Reporting Analyst on several reports to ensure that the data was correct and that the reports were delivered on time.
I used inner and outer joins between multiple tables to create reports.
Wrote PL/SQL queries and stored procedures to analyze data and run reports.
Worked with Oracle Forms / Reports to test data and run reports.
The process flows are created from Visio.
Used Power Query to import data into Excel.
Express Scripts, Bloomington, MN (contract) January 2013 – June 2015
Database Developer / Business Analyst / VBA and SQL Developer
Worked as a business analyst developing and running reports on rebated and non-rebated claims.
I worked as a Reporting Analyst on reports in Teradata and QMF to ensure that the data was correct and that the reports were delivered on time.
Maintained ETL-based data warehouse.
Responsible for claims managementt racking and reporting.
Worked as a technical analyst on Medicare and Medicaid systems to map fields and test forms and reporting functionality.
I used inner and outer joins between multiple tables and subqueries to create reports.
I was responsible for using an online tool to resolve claims that have errors on a weekly basis. Responsible for working with IT to resolve all errors. Also responsible for leading meetings to discuss the statuses of errors..
The reports are created from SQL Server 2012 tables in RDBMS with querying tools Teradata and QMF. The data is modified in Access and Excel. They are sent to clients in Rebates, Finance, and Accounting.
Gather user, business, and technical requirements, and performed UAT, creating test cases and executing test plan for new databases implemented in January 2014, and for reports I currently run.
Wrote PL/SQL queries and stored procedures to analyze data and run ad hoc, weekly and monthly reports.
Develop Excel macros using VBA to link data between spreadsheets and import data into Access.
Used SQL Server Reporting Services (SSRS) to run weekly reports.
Responsible for leading meetings to discuss drugs that are excluded from rebates. The drugs are then entered into Access where calculations are performed and the results are sent as a text file into Triad.
Created process flows for different reports that I developed.
Worked in an Agile project environment.
Used Power Query to import data into Excel.
Put COBOL and C# code into Visio flowcharts.
Ekster & Associates, Fremont, CA (contract) July 2008 – October 2012
Database Developer / Business Analyst / SSIS Developer
Worked as a Data and Technical Analyst on SQL Server 2008 database and Access user interface.
Gathered user, business, and technical requirements, and performed UAT, creating test cases and executing test plan.
Worked on entire SDLC lifecycle.
Developed SQL Server 2008 database to store information previously kept in Excel, Word, Notepad, and Access.
Developed and maintained ETL-based data warehouse to perform extraction, load, and transform functionality. Data mapping between SQL and Access tables.
Data mapping between SQL and Access tables and Excel spreadsheets.
Created ETL process between Excel, Access, and SQL Server 2012.
I used inner and outer joins between multiple tables to create reports.
Served as DBA on a SQL Server database to oversee data security and governance.
Used Business Intelligence Development Studio (BIDS) and SQL Server Integration Services (SSIS) to design packages that would extract, transfer, and load data into SQL Server 2008. Packages ran weekly and daily from SQL Server.
Designed flowcharts and wrote technical documentation for Access 2003 conversion into SQL Server.
Used SQL Server Reporting Services (SSRS) to run weekly reports.
Built an application with Access as the processing engine and Excel as the presentation tier. Access application is using read only SQL Server data though linked SQL tables. Results were transferred to Excel spreadsheets.
Responsibilities included designing SQL tables, function, triggers, pivot tables, and views, designing Access forms and dashboard reports, writing VB 6, VBA code for query execution, designing Excel macros, customizing menus and toolbars in Access and Excel, da2tabase security, flowcharts, documentation, giving presentations, user training, designing help files, user training, and quality assurance.
Used PowerPoint, HTML and ASP to design templates to be used for marketing campaign.
VM Ware, Palo Alto, CA (contract) April 2007 – April 2008
Business Analyst / VBA and SQL developer
Served as a technical analyst on Oracle E-Business Suite.
Gathered user, business, and technical requirements, and performed UAT, creating test cases and executing test plans.
Designed flowcharts and wrote technical documentation for SQL Server conversion into Oracle 11i.
Migrated critical reports into Oracle BI Publisher. Used XML Publisher to migrate Oracle11i data into Word reports.
I used inner and outer joins between multiple tables to create reports.
Designed an Access 2003 application to store information on orders and contracts for the quote renewals team.
Built an application with Access as the processing engine and Excel as the presentation tier. Access application is using read only SQL Server 2008 data though linked SQL tables. The results were transferred to Excel spreadsheets.
Responsibilities include designing Access forms and dashboard reports, building pivot tables, writing VB 6, VBA code for query execution, designing Excel macros, customizing menus and toolbars in Access and Excel, creating new Access tables to allow users the ability to edit data, creating select, delete, append, and update queries, database security, flowcharts and documentation, and quality assurance.
Washington Mutual, San Francisco, CA (contract) June 2006 – Feb 2007
Analyst / SQL developer
Worked as an Analyst on Oracle 11i Financials application for a digital marketing campaign on an application that dealt with money movement and process flows for wires, and client fund transfers.
Checked and modified PL/SQL packages, which included stored procedures, cursors, and triggers to make sure the application was querying data correctly.
Designed Access database to transfer the queried data into Access sales reports.
1-800-Flowers, Napa, CA (contract) February 2006 – May 2006
Programmer Analyst
Served as a SQL Server 2000 developer and analyst.
Oversaw SQL databases on several servers to make sure that Access applications, sales reports built using Crystal Reports, and Excel spreadsheets using their data were providing the proper results.
Also created reports with SQL Server Reporting Services (SSRS) Responsibilities included redesigning Access forms, writing VBA code for query execution, documentation, designing pivot tables, graphs, charts, and quality assurance.
Hispanic Unity Council, Oakland, CA (contract) December 2005 – January 2006
Programmer Analyst
Designed an Access 2003 database with a VB 6 front end to store information on the sponsors for the Hispanic Unity Council. Database resides on a Citrix Server.
Converted Excel Spreadsheets and Word documents into Access tables, then combined them into one table, using an append query.
Responsibilities included redesigning Visual Basic forms and reports, writing Visual Basic code for query execution, combo and text boxes, customizing menus and toolbars, splitting database into front and back end, creating new tables and queries, database security, documentation, and quality assurance.
Ekster & Associates Fremont, CA (contract) July 2004– November 2005 Programmer Analyst (7/2005 – 11/2005)
Designed an Access 2002 database with a VB 6 front end and reports to store information on the Financial Electronic Office (FEO).
Database resided on a Citrix Server.
Responsibilities included redesigning forms and reports, writing Visual Basic code for search criteria execution, combo and text boxes, customizing menus and toolbars, splitting database into front and back end, creating new tables and queries, database security, documentation, and quality assurance.
Met weekly with users to determine requirements for database and Excel reports.
Also responsible for designing Excel 2000 reports and writing VBA code in modules to import and export data from Access database and execute users’ criteria when opening the reports.
Wells Fargo Bank, San Francisco, CA (contract) April 2004 – July 2004
Programmer Analyst
Designed an Access 2000 database to store information on the Central Electronic Office (CEO).
Responsibilities include redesigning forms and reports, writing code for combo and text boxes, customizing menus and toolbars, splitting database into front and back end, creating new tables and queries, and database security.
Responsible for documentation and quality assurance. .
L3 Corporation Arlington, VA (full time) April 1999 – Sept 2003
Programmer Analyst
Designed databases for the Navy and L3 employees. Worked on the Rapid Response Team, which resolved database problems for end users within the company and Navy personnel.
Responsibilities included creating new Oracle and Access databases and redesigning existing databases to fit the clients’ needs.
Tasks included creating tables and table relationships, designing and coding queries for reports, building macros and writing code for modules, writing code for search options for records and reports, redesigning appearance of