Mark Stevens Email & Phone Number

United States

United States

Castle Rock, Colorado, Us

As an Integration Services Engineer at Intterra, my goal is to enhance the fire service with advanced data solutions. I handle everything from onboarding new clients to providing support for existing ones, ensuring smooth integration of systems and world class customer service. Leveraging the AWS cloud and the many services offered, we prioritize data security and accuracy, transforming information through robust data lakes and warehouses. This ensures agencies can access reliable insights for informed decision-making. Intterra is shaping the future of fire service technology, where innovation meets reliability for safer communities.

Centennial, Co, Us

Provide strategic planning and evaluation services for data and systems utilized by South Metro Fire Rescue. Design and develop reports for business operations and application development while using large data sets. Ensure data integrity by cleaning and organizing data to department standards; develop custom data models and algorithms for analytics, allowing for use with other users within the organization. Manage data gathering, queries, and report writing for various projects and procedures Leverage Azure tools, including Data Factory (ETL/ELT), Data Lake, Data Warehouse as well as Artificial Intelligence and Machine Language techniques to better examine information and provide analysis on data that was once very difficult. Migrated reports to Power BI from SSRS and continue to create new content in Power BI to provide better data interaction for the end user.Continue to foster relationships with all facets of the organization, including staffing, operations and business services. Provide internal training to help others be more successful in their position. Managed consultants developing processes to move data from a SASS solution create a new real time data warehouse. Consistently manage customer expectations to set priorities and multi-task to meet deadlines. Help others to define problems and quickly collect data to provide information for sound decisions.

Centennial, Co, Us

Support local fire departments by providing fire service reports to area municipalities. Work in conjunction with fire chiefs and fire department personnel to provide a variety of routine and complex analytical, administrative, and technical analysis of fire department programs, services, systems, and performance.Design, implement, and maintain SQL Server databases for data warehousing and create various analytical reports using SSRS, Crystal Reports, or Excel. Perform predictive analysis in support of fire department operations which includes fire prevention, suppression, emergency response, fire inspections and department management.Utilize analytics and geospatial analysis to help coordinate department growth, improve system management decisions and produce outcome studies that support agency budget and equipment needs.Support agency accreditation requirements including: Standard of Cover, Risk Assessment and various response performance and deployment analyses.

Santa Clara, Ca, Us

Oracle Database Administrator for telecommunications software development group.Identify and tune SQL statements for optimal performance. Create, edit, and delete database structures as requested by developers. Resolve locking and performance issues. Collaborate with internal IT team members to ensure cohesive and viable approaches and document requirements, analysis, and high-level design. Create SQL scripts to verify database changes in production environment.Maintain defect tracking version control system. Create patches and ensure code fixes through completion.

Accelerate and bring to fruition the varied financial and investment goals of each client through the creation and execution of strategic, customized financial plans grounded in continual research in and an understanding of the increasingly complex world of finance. Attract new clients through the implementation of creative and effective business development strategies including developing seminars, preparing PowerPoint Presentations, and creating and maintaining the company website.Maintain a close watch of the industry and market changes and recommend and submit plan changes as necessary.Research securities and trade in accordance with Investment Policy Statements.Maintain State and SEC compliance documentation and establish positive relationships with government regulatory agencies and field consultants.

(Formerly Capital Allocation and Management)Developed a custom portfolio performance tracking system using VBA and advanced functions in Microsoft Excel. The system automated the performance tracking process, reducing the amount of time to produce the performance numbers by 75%.Developed, presented, and managed customized financial plans and investment portfolios while serving as client’s first point-of-contact for inquiries and requests. Migrated client data to eMoney Advisor, a web-based wealth management software solution .

Austin, Texas, Us

Provided technical support to Oracle database customers that consistently exceeded performance benchmarks. Increased Team productivity by creating and presenting internal training classes and writing technical white papers.Subject Matter Expert (SME) in the areas of SQL*Loader, Data Pump Import and Export utilities, writing SQL and PL/SQL queries and scripts.Member of the Extended Business Critical team providing resolutions to the highest profile customers after normal business hours.

Designed and developed customized construction management business system using Visual Basic, VBA, SQL Server, Microsoft Access, and MS Excel while applying data management principles and practices.Implemented database structure design, logic, administration, and development of SQL Server and Microsoft Databases. Identified end user needs through roundtable discussions and business process mapping.Reviewed and approved system documentation and design specifications and changes. Tested code modifications to program modules to ensure proper functionality.Facilitated end-user functionality training, breaking down complex concepts and creating an accessible and positive learning environment. Generated and maintained over 100 different reports based on user requirements within MS Access and Crystal Reports, including those pertaining to sales, inventory, budget, construction schedule, prices, floor plans and elevations, and customer contacts.Maintained the company’s Microsoft Windows operating systems configuration, administration, and network.

Master Of Science, Finance

Bachelor Of Science, Business - Computer Information Systems