Beth Schmit Email & Phone Number

Greater Minneapolis-St. Paul Area

Performing data analytics and application development tasks using SAS Enterprise Guide and SAS Enterprise BI (EBI) for Financial Fraud and Abuse Investigations unit | Office of Inspector General | Dept of Human Services.

Greater Minneapolis-St. Paul Area

Performed various tasks of application development of new business requirements for Financial Data Management Group within UHC Controllership using SAS Enterprise Guide.• Performed development work to create automated processes, reporting and analyses from multiple systems with new financial feeds from an incoming vendor. • Created processes to transform vendor test data into a format that enabled accountant business partners to conduct analysis of the new data feeds.

Greater Minneapolis-St. Paul Area

Data Analytics/Business Intelligence• Member of a self-directed team to complete ad hoc requests, extract and transform data for business partners for their many business requests, reports and analyses that have been handled quickly and with care to provide quality results.• Ancillary Products – performed development work and testing to source data for new ancillary products data warehouse.Revenue Management / Network Route Schedules and Planning / Pricing Systems• Designed, coded, tested and implemented many enhancements and new business requirements with good attention to detail enabling quality deliverables in short turnaround time.• SAS expert and resource for various project teams. • Key contributor for many SAS upgrades and conversions including project management, coding, testing and implementation.

Greater Minneapolis-St. Paul Area

Revenue Management / Network Route Schedules and Planning / Pricing Systems• Designed, coded, tested and implemented many enhancements and new business requirements with good attention to detail enabling quality deliverables in short turnaround time. • Revenue Management Booking Class Alignment project – help team with testing set up and validation scripts during critical phase of project. • Integration design, development, testing and implementation for Delta/Northwest Airlines merger.• SAS expert and resource for various project teams. • Key contributor for many SAS upgrades and conversions including project management, coding, testing and implementation.• Worked across several project teams to help out where more resources were needed.

Greater Minneapolis-St. Paul Area

Payroll, W-2, Purchasing and Material Systems• Performed various tasks including analysis, design, coding, testing, implementation and documentation of Automatic Receipt of Material project, Fuel Management System, Material Systems, Central Payment and Miscellaneous Vouchers System. Responded 24/7 for system support.• Designed and delivered redesigned W-2 system which reduced processing time by 80 percent. Tasks included analysis, design, coding, testing and implementation to use new IMS databases. Provided work direction for 1-2 staff. Business Partner interaction.• Enhancements and maintenance to various Payroll applications including IMS online and batch programs.