Ben Martin Email & Phone Number

Greater Minneapolis-St. Paul Area

Minnetonka, Mn, Us

* Contact Center reporting and dashboards design and development highlighting KPI trends over time. * Converted entire Contact Center suite of reports from OAS to Qlik Sense.* Billing reporting requirements gathering, design and development for both Commercial and Small Business market segments.* Oracle Analytics Services (OAS) administration and release management.* Led process documentation effort for the BI Reporting Team by leveraging SharePoint,, MSFT Teams, and Confluence tools.

Chanhassen, Mn, Us

• Implementation and integration of new Exerp Enterprise Member Management SaaS system to manage all member registration and scheduling. • Led data migration of member and product information to the Exerp platform, and responsible for integrating Exerp AWS BI Warehouse (Amazon Redshift) with LIFE TIME Azure data warehouse used for internal data analysis and reporting.• Used Informatica (IICS) and Transact-SQL to audit daily data integration between Azure & AWS Redshift data warehouses, and submit data repair events to MuleSoft API listener.• Azure DW | SQL Server | Transact-SQL | Amazon Redshift | SSMS | Informatica (PowerCenter & IICS) | Jira

San Francisco, California, Us

• Profiled disparate marketing data sources to consolidate and model that data into an enterprise data warehouse (Teradata).• Established best practices and analysis processes to improve the productivity of a constantly changing pool of contract resources. • Streamlined data source analysis process and reduced manual analysis effort from days to hours.• Teradata | Oracle | SQL | Data Modeling | Data Profiling | Data Analysis

Minnetonka, Mn, Us

• Designed and developed business intelligence dashboards, data warehouse components and related sub-systems. • Applied extensive data analysis and data visualization techniques to identify numerous operational and forecasting data trends. • Led mid-sized projects involving both business and technical resources from concept through implementation. • Mentored colleagues on various business intelligence and data warehousing techniques.• Facilitated technical / business delivery walk-throughs and information share sessions.• Designed and implemented Hyperion Essbase (OLAP) usage tracking reporting system to create metrics for identifying highly used cubes and super users to improve overall usability, and to deprecate aging systems.• Worked closely with Director of Data Science on creating/optimizing predictive sales models via large-scale data mining efforts and applying machine learning techniques (R, Python, Spark).• Reduced Hyperion contractor spending by $250K over two years by automating numerous manual ETL and maintenance processes.• Implemented and upgraded OBIEE 10 & 11 systems and dashboard environments, providing better self-service data insights and localized currency reporting to global clients.• Developed complex OBIEE security solution, allowing multiple global clients access to their respective ecommerce sales and web analytics dashboards.• Implemented MDM processes for client and product data hierarchies and client data security for more timely data accuracy and accessibility.• Evaluated data quality, systems, and business processes, identified inefficiencies, and areas of improvement.

Minnetonka, Mn, Us

• Developed Brazilian Boleto tax data feed, facilitating Latin American sales expansion effort.• Designed hourly sales alert system across multiple operational databases, providing clients with real time sales successes or possible issues.• Converted AP Finance database to enterprise Actuate reporting solution, and reduced the month-end close process by 10 days.

Houston, Texas, Us

• Implemented bar-code driven Kanban parts procurement system (logistics) for aerospace manufacturer (Goodrich, Burnsville, MN).• Automated mobile communications sales reporting daily data load process (AT&T Wireless).• Customized price modeling retail system stored procedures (Kooperativa Förbundet, Sweden).• Reverse engineered “Bill of Material” (BOM) reporting system for GM do Brasil (Portuguese).• Applied SDLC (Software Development Life Cycle) methodology on all projects.

Bachelor’S Degree, Economics, Mathematics, Spanish

Exchange Student, International Business, Photography