Stephen Roach Email & Phone Number

United States

Los Angeles Metropolitan Area

Los Angeles Metropolitan Area

Marketing Science | Analytics | MarTech

Los Angeles Metropolitan Area

Managing Data Solutions, Business Intelligence and Advanced Analytics

Fort Lauderdale, Fl, United States

Business Intelligence* Generated and automate complex BI Dashboards daily, monthly / Year over Year Y/Y analysis for our Clients and Account Executives. Manage proprietary Business Intelligence Analytics system; custom-built reports/dashboards within Tableau or Power BI platforms for clients and Account Executives. Analysis of daily KPIs for all clients and potential clients for possible suggestions and corrections.- Data Management/Warehouse* Manage data integration to Cloud… Show more Business Intelligence* Generated and automate complex BI Dashboards daily, monthly / Year over Year Y/Y analysis for our Clients and Account Executives. Manage proprietary Business Intelligence Analytics system; custom-built reports/dashboards within Tableau or Power BI platforms for clients and Account Executives. Analysis of daily KPIs for all clients and potential clients for possible suggestions and corrections.- Data Management/Warehouse* Manage data integration to Cloud Data Management/Warehouse GCP BigQuery and AWS Redshift) with Media serviced Google Ads, Google DV360, Facebook Ads, etc)and Client provided datasets. Providing ongoing data architecture, troubleshooting, and security.- ETL Management* Developed workflows for internal and external ETL processes using tools such as Informatica and Talend. Daily consultation with oversees development team to discuss enhancements and issues to our internally built systems and ETL processes.- GIS Analysis* Daily Interpreting, studying and designs geographical information, developing functional geographical plans and programs and showing the relationships between various locations that are confined to a national campaign.- New Business* Advise potential new clients on overall agency technical capabilities from either building new software from the ground up to population and behavioral analysis. Show less

Fort Lauderdale, Fl

- Data AnalysisGenerated complex Excel daily, monthly / Year over Year (Y/Y) analysis for our Account Executives. Manage Proprietary Business Intelligence Analytics system; custom built reports/dashboards within Tableau or Power BI System for clients and Account Executives. Analysis daily KPIs for all clients and potential clients for possible suggestions and corrections. Managing and loading daily ETL data from multiple sources for developer. Monitoring and analysis Google Analytics… Show more - Data AnalysisGenerated complex Excel daily, monthly / Year over Year (Y/Y) analysis for our Account Executives. Manage Proprietary Business Intelligence Analytics system; custom built reports/dashboards within Tableau or Power BI System for clients and Account Executives. Analysis daily KPIs for all clients and potential clients for possible suggestions and corrections. Managing and loading daily ETL data from multiple sources for developer. Monitoring and analysis Google Analytics for multiple clients.- Database ManagementProvides database applications by developing architecture, troubleshooting, and security.- Project ManagementDaily consultation with over sees development team about up enhancements and issues to our systems and ETL process and Power BI System.- ArcGIS Online, ArcGIS Pro, ArcGIS Business AnalysisInterpreting, studying and designs geographical information, developing functional geographical plans and programs and showing the relationships between various locations that are confined to a nation. Show less

Fort Lauderdale, Fl

Prepare monthly allocations for all major 3rd party providers. Generated complex Excel month over month (M/M) / Year over Year (Y/Y) analysis for our department Director and VP. Investigated day-to-day activities to prevent errors and malfunctions within our MS SQL servers and Qlikview reporting system. Provide QA for lead cutting and generating via algorithms to help drive traffic to our 270 AutoNation stores.

Deerfield Beach, Fl

Data Analysis- Managed systems projects and technical enhancements to our database and reporting system with overseas team. Assisted in the development of technical database development and operations. Generated complex Excel Modules and Dashboard. Investigated day-to-day activities to prevent errors and malfunctions. Generated monthly reports on miscalculations. Provided technical assistance and consultation to overseas agents. o Developed an formula for grading all Offers and… Show more Data Analysis- Managed systems projects and technical enhancements to our database and reporting system with overseas team. Assisted in the development of technical database development and operations. Generated complex Excel Modules and Dashboard. Investigated day-to-day activities to prevent errors and malfunctions. Generated monthly reports on miscalculations. Provided technical assistance and consultation to overseas agents. o Developed an formula for grading all Offers and List based on performanceo Created Model Dashboard for the CEO based on weekly and monthly revenue performance. Show less

Coral Springs, Fl

Data Analysis-Ensure SLA’s and Teams goals are met within the scope of the entire account set up process. Determines financial worthiness by contacting credit resources listed; searching databases and public records; investigating and verifying credit background information; collecting, analyzing, and summarizing financial and personal information. Investigation-Responsible for performing credit investigation activities for prospective accounts using credit evaluation… Show more Data Analysis-Ensure SLA’s and Teams goals are met within the scope of the entire account set up process. Determines financial worthiness by contacting credit resources listed; searching databases and public records; investigating and verifying credit background information; collecting, analyzing, and summarizing financial and personal information. Investigation-Responsible for performing credit investigation activities for prospective accounts using credit evaluation guidelines and credit history to access credit worthiness. Prepares underwriting documents for management review. Prepares various MIS for management. Show less

Coral Springs, Fl

Reporting- Created an innovative client tailored narrative financial summary report generating an efficiency reporting models. These reports were provided on a weekly, monthly, and annual with promotional data and statistic retrieved from valuation databases. Developed financial and valuation models to evaluate corporate and industry operating performance and efficiency. Create Business Object project and reports; all reports are analyzed before being compiled into a presentable report… Show more Reporting- Created an innovative client tailored narrative financial summary report generating an efficiency reporting models. These reports were provided on a weekly, monthly, and annual with promotional data and statistic retrieved from valuation databases. Developed financial and valuation models to evaluate corporate and industry operating performance and efficiency. Create Business Object project and reports; all reports are analyzed before being compiled into a presentable report that is provided to Clients, VP of Finance, CFO, Management, and Etc. Also reporting inventory logs with sales and distribution numbers.Development- Development of macros to speed up the process and workload to take on different projects for the VMI Finance Department and Warehouse Department. Show less

Miramar, Fl

Reporting- Provided monthly reports on data and statistics reports based on start HMMWV Program, which were reviewed by the VP of New Business Development. Communicate with clients and International Governments who are interested in HMMWV parts via telephone and email. Co-ordinate and lead the configuration and addition of new clients to the HMMWV business program.

Sunrise, Fl

Reporting- Provided weekly, monthly, and annual data and statistics reports based on Solution Center and IVR data received from back office servers. These reports are analyzed before being compiled into a presentable report that is provided to Clients, Management, and Etc.o Obtain raw data (Solution Center and IVR) from servers o Transfer files into Excel, Access or PDF format o Compile data obtained into a presentable format to present to Clients, etc.Project… Show more Reporting- Provided weekly, monthly, and annual data and statistics reports based on Solution Center and IVR data received from back office servers. These reports are analyzed before being compiled into a presentable report that is provided to Clients, Management, and Etc.o Obtain raw data (Solution Center and IVR) from servers o Transfer files into Excel, Access or PDF format o Compile data obtained into a presentable format to present to Clients, etc.Project Specialist - Assisted Project Manager/Owner & Developers to understanding functions and enchantments to be able to develop upon requirements.o Wrote documentation requirements upon the program descriptions for development, along side of the User Experience Specialist to help the work flow of the project. o Work with IT, Customer Service, and Management to help define the desired services, and ensure that these services are clearly understood by all departments and the End-User.o Provided researched data to the Project Manager/Owner & Developers o Consulted with Training Dept. on how functions would work. As well as trained Customer Service Rep’s (One-on-One).o Presented the program (CSA) to Senior VP’s within “Wildcard Systems”- Assist in the creation of procedures for bringing on new business, and for keeping existing business functioning efficiently from both IT and end-user perspectives.- Used performance improvement techniques, such as benchmarking, workflow design (with MS Visio), process analysis and design.- Troubleshooting any technical issue within call center having to do with hardware and software. Also provided quality information to the CSA Scrum Team, from a CSR’s point of view, to enhance the program and satisfy its complete goal. Show less

Mis, Information Technology

Activities and Societies: MIS

Computer Programming

Education record

Computer Programming