Thomas Kern Email & Phone Number

Minneapolis, MN, US

• Developed the Target Financial and Retail Services (FRS) Tender team’s functional and technical OKR/metrics in alignment with the goals of FRS and Target.
• In collaboration with key stakeholders and engineering partners, I managed the backlog and prioritization process to align with the current development strategy for the Tender product for sprint, quarterly and yearly.
• Led a data product agile team that included engineering managers, engineers and key SMEs. This group of resources was internal and external to Target as well as global in nature.

Minneapolis, MN, US

• Led the development of RedCard and service center dashboards and reports for FRS leaders and data analysts. This work included the requirement gathering, report design, coordination of engineering resources.
• Developed RedCard data warehouse solutions by collaborating with team members in Business Intelligence Engineering and the clients to develop data warehouse solutions for FRS Service Reinvention projects.
• Management of the Target FRS Business Intelligence suite of reporting solutions which included monitoring the daily processing, troubleshooting of any issues and implemented of any fixes if necessary.

Minneapolis, MN, US

• Designed, built and implemented reports and processes to monitor data quality within the FRS BI RedCard data warehouses and SAS datasets.
• Collaborated with peers and Target Technology Services to troubleshoot and resolve issues by assisting developers in locating the root cause, determining a resolution and testing the changes to ensure the issue was.

Minneapolis, MN, US

• Led the development of FRS BI&A reports by coordinating on and off shore developers and clients. This leadership involved meeting with the client to determine requirements and assisting developers in the development of.
• Became a subject matter expert for the Target REDcard, Client Support Center and Quality reporting data sources by partnering with clients to understand their business processes and matching those processes to the data.
• Developed and maintained new reporting data sources by locating the data needed and building the ETL process to load the data into our SQL server..

Minneapolis, MN, US

• Developed and implemented new Collections and Client Support Centers reports per the client requirements. This included developing both the backend SQL code as well as the front end.NET code.
• Maintained a high level of attention to detail and data integrity in all of the reports that I built.
• I was tasked with finding ways to improve our current reporting processes and procedures. These improvements lead to report usability and accuracy improvements.

Minneapolis, MN, US

• Responsible for maintaining FRS Reporting and Expense team reporting processes and procedures for the Collections call centers.
• Created a working relationship with Collections TDLs, Operations Managers and agency relationship coordinators to determine their operational reporting requirements. When an issue came up I was tasked to determine a.

Minneapolis, MN, US

• Support the ARS 401K recordkeeping cycle by working with a global support staff to troubleshoot production issues on a 24/7 rotating on call basis.
• Develop and execute SQL queries that are used to validate cycle groups, plan activity holds and the research of large production issues.
• Provide leadership, mentoring, and assistance to team members by directing other members of the team on processing flows, UNIX log files, SQL query questions and processing problem resolution.

Minneapolis, MN, US

• Input, process and post distributions, loans, transfers and other transactions for functionality and regression testing of the WySuite (WyStar & WyGroup) 401k recordkeeping system.
• Regression and functionality testing and verification of various internal interfaces (Web, BARD, IRA rollover etc) to the WyStar record keeping system to ensure compatibility and functionality with new releases.
• Reporting and communicating errors and inefficiencies in processing to production support, ARS technologies, the record keeping system vendor, and other areas of the business.

Minneapolis, MN, US

• Processing distributions, withdrawals, and loans within the five day processing standard for the participants in multiple defined contribution retirement (401K) plans.
• Balance the record keeping system (plan one and Wystar), tax reporting system (Omni pay), and trust accounting system (SEI) for the monthly and yearly client statements and participant tax records.

San Francisco, California, US

• Answered customer service phone calls relating to balances, individual transactions and helped resolve any transaction errors.
• Processed commercial loan advances, fund transfers and account maintenance requests.
• Reviewed a customer’s account and tailored the sale of banking products and services to their specific business and personal needs.