Scott Schuler Email & Phone Number

United States

• Research and identify backend technologies for data warehouse• Research and identify middleware for ETL• Research and identify front-end visualization tool to provide reporting to the business• Conduct interviews and hire employees for the Business Intelligence team• Mentor and train BI Data Analyst on SQL and API connections to systems• Train and manage the commission team• Gathered and documented requirements to identify new commission system• Performed analysis and documents business needs in order to streamline commission plans• Performed PM and BA tasks in order to create analytical reporting for business use• Documented formulas used in current system reporting and Excel for use in new BI Visualization• Work with business entities and project management team to identify User Interface processes and procedures for new ERP system

Southfield, Mi

• Trained Business Analysts on gathering and documenting requirements for business units• Trained Business Analysts and Systems Analysts on documenting business requirements into technical requirements• Conduct data analysis for operational and financial savings• Manage and train employees on requirements gathering, data analysis, and business and financial reporting• Assumed the PM and BA positions for the enhancements to the Xactly commission system• Created and conducted QA test plans for updates to commission plans and Xactly commission system• Assumed the lead for the technical portions of the Xactly commission system• Manage commissions for the company in excess of $4 million per year.• Obtained requirements and developed reports in the Xactly commission system using SQL• Implement and manage Fleet Management with local team members and vendors• Manage multiple projects with vendors for strategic sourcing • Created multiple workflows and diagrams for business processes in Visio• Work with business entities to identify, document, and streamline business processes• Work with business entities to identify needs and translate to technical specifications• Conduct Business Analysis to gather and document requirements• Created project budgets, schedules, timelines, and weekly status reports• Conducted weekly and bi-weekly stakeholder meetings depending on the project• Conduct meetings with Executive Team members• Researched, implemented, and coded in GoCanvas for gathering of data with use of mobile device• Extracted data from GoCavas with use of API’s into an on premise database• Managed and worked with vendors to implement shipping software• Conducted data analysis using SQL, MS Excel and MS Access• Managed, mentored, and trained other employees on data analysis• Create documentation for current and future business processes• Train employees on advanced Excel functionality

Southfield, Michigan, United States

• Managed the upgrade of the Yardi property management software saving $600K of the implementation budget• Managed the transition of data and training to a new reservation software • Helped to create SDLC process for the company• Created Database and Network Diagrams using Visio• Conducted data analysis using SQL Server and MS Excel• Implemented SCRUM process for core system enhancements• Managed projects using Waterfall, Agile, and Hybrid techniques• Conducted Business Analysis to gather and document requirements form multiple projects and enhancements• Worked with business entities to identify and streamline business processes• Created project budgets, schedules, timelines, and weekly status reports• Identified and document project scope, risks/issues, deliverables, and change requests• Conducted weekly and bi-weekly stakeholder meetings depending on the project• Conducted meetings with Executive Team members• Created and managed QA test plans and processes for multiple updates, enhancements, and system implementations• Managed the creation and implementation Business Continuity and Disaster Recovery• Managed and collaborated with vendors and internal IT Network and Security teams to build a new offsite backup data center• Managed the implementation, configuration, and administration of Salesforce CRM• Managed the company IT portions of the acquisitions and dispositions of properties

• Created custom functionality in the Yardi property management application • Worked with business users to identify and document requirements• Converted and documented business requirements into technical requirements• Documented and conducted development QA testing prior to handoff for UAT• Managed SQL Server and Databases• Created SQL Server Functions, Stored procedures, Tables, Queries, and other scripts • Developed database driven web pages using HTML, DHTML, ASP, JavaScript, VBScript, and AJAX• Created database and web-based interface for management of code deployment process• Created application with MS Access front end and SQL Server Database backend• Used Crystal Reports to create non-web reporting from SQL Server• Created reports in Yardi property management using Yardi Reporting Scripts• Worked with business entities to identify needs and functionality• Created documentation on business needs and functionality• Created database diagrams and other coding specific documentation

• Technical liaison between Financial Aid department and University IT department• Liaison with IT Departments from other Universities and Community Colleges• Create Access Databases to help staff perform their job functions.• Query information from Banner Database to create operational reports• Provide statistical data for the Financial Aid Office to the President of the University• Documented requirements and tested updates to applications before they are implemented into the Production Environment and provide updated information to Financial Aid Staff• Created, updated, and optimize SQL queries for Financial Aid processes • Research possible options to improve or automate Financial Aid processes• Order, track, setup, and troubleshoot staff Computers• Support and train staff on computer application• Track security request for Financial Aid staff and database tables related to Financial Aid

Southfield, Michigan, United States

Started on Helpdesk in August 2003Promoted to Application Security Administrator September 2004Application Security AdministratorDuties:• Managed security in Yardi Property Management • Setup, Configured and Administer programming development environment consisting of Windows 2003 Server, MS SQL 2000 Server, IIS Server, and Terminal Server• Managed Windows 2003 Server, MS SQL 2000 Server, and Lotus Notes user ID’s• Created SQL Server Functions, Stored procedures, and Queries • Developed database driven web pages using HTML, DHTML, ASP, JavaScript, VBScript• Created database and web-based user interface for code development tracking• Researched, implemented, and administer code tracking software for development Helpdesk TechnicianDuties:• Configured and setup new computer systems for users• Troubleshot network and Internet connectivity issues• Setup wired and wireless LAN’s at remote offices• Work with users to resolve software, hardware, and printing issues• Created development to implementation process to follow for developers

Southfield, Michigan, United States

• Setup and configure new copiers at customer locations• Network copiers at customer and main office locations• Repair copiers at customer locations• Provide demonstration and training to customers at customer locations

West Bloomfield, Michigan, United States

• Membership Sales• Training of new sales team members• Maintained professional relationship with club members• Recorded and tracked maintenance issues and repairs• Conducted personal training sessions

Flint, Michigan, United States

• Prepared employee evaluations• Supervised and trained technicians in repairing cellular phones• Supervised and trained warehouse personnel on shipping, receiving, and inventory control• Configured daily work schedule for employees• Oversaw purchases of products and supplies stayed within budget• Provided liaison between repair center and retail stores

United States

• 4 Years in the Infantry• 5 Years in Supply Chain Management• Supervised and trained warehouse personnel on shipping, receiving, and inventory control• Managed warehouse account in excess of $3,000,000• Ensured all documentation and warehousing of items was done in a timely manner• Oversaw purchases of products and supplies stayed within budget• Performed liaison between U.S. Marine Corp and U.S. Army Supply units in Kuwait• Held positions 2 ranks above mine• Ensured troops and equipment were prepared for deployment• Managed and lead infantry troops

Masters, Enterprise Information Systems

Bachelors, Software Engineering

Associates, General

Education record