Mark Simon Email & Phone Number

Remote

• Develop and optimize SQL queries for Microsoft SQL Server and Microsoft Access• Create and modify stored procedures, triggers, functions, and other database objects such as tables, views, and indexes• Debug stored procedures using SQL profiler• Manage running SQL services and installed/configured/upgraded SQL Server 2000/2005/2008/2012/2014/2016 instances as well as user databases and analysis cubes• Script automated alerts and notifications for SQL Server jobs on an… Show more • Develop and optimize SQL queries for Microsoft SQL Server and Microsoft Access• Create and modify stored procedures, triggers, functions, and other database objects such as tables, views, and indexes• Debug stored procedures using SQL profiler• Manage running SQL services and installed/configured/upgraded SQL Server 2000/2005/2008/2012/2014/2016 instances as well as user databases and analysis cubes• Script automated alerts and notifications for SQL Server jobs on an enterprise system• Monitor Enterprise Server Disk Space, CPU/Memory Utilization, Performance, Windows Events, User Activity, Replication, and Error Logs in addition to Troubleshooting System/Database Performance Issues• Perform backups and restores, schedule jobs and maintenance plans, create replication publications and subscriptions, and performance-tune databases including create/update statistics and rebuild/reorganize/defragment indexes• Administer server login security and database user permissions• Provide ad hoc and management reporting on veterinary/medical data• Interpret source data from reports and tables, and integrate it into output files• Compile veterinary/medical information and configured schemas using data warehousing• Perform data validation, verification, and integrity checks; locate and quantify invalid and null data• Conduct import/export of data using DTS (Data Transformation Services), SSIS (SQL Server Integration Services), BCP (Bulk Copy), and data extraction tools (ETL)• Convert Access databases, MySQL databases, and flat files to SQL Server databases• Provide system administration, PC maintenance, technical support, and technology training Show less

Atlanta, Ga

• Provided sound support to Engineering and Technical Operations by developing complex end-user reports and dashboards. • Collaborated with cross-functional teams members in order to analyze and troubleshoot complex issues, including working closely with Data Architecture Team regarding data issues and with Business Unit regarding business issues.• Applied advanced SQL development, troubleshooting, and data analysis skills in order to quickly acclimate to new environment and work… Show more • Provided sound support to Engineering and Technical Operations by developing complex end-user reports and dashboards. • Collaborated with cross-functional teams members in order to analyze and troubleshoot complex issues, including working closely with Data Architecture Team regarding data issues and with Business Unit regarding business issues.• Applied advanced SQL development, troubleshooting, and data analysis skills in order to quickly acclimate to new environment and work independently to support varied needs of team members.• Created ad hoc and prototype queries using Microsoft SQL Server and Teradata Database• Created prototype reports and dashboards using SSRS and Tableau• Develop Powerpoint presentations that give background information, examples, and visual references such as charts and histograms• Presented Powerpoint slide shows to team members and decision makers in-person and via Skype Show less

• Performed data validation, verification, and integrity checks• Provided ad hoc and management reporting on commercial data, for business directories and industries• Developed SQL queries for Oracle database systems using Windows and Unix interfaces• Created and modified stored procedures and other database objects and transferred these between databases and server instances

verted Microsoft Access databases to SQL Server 2000 and managed running SQL services• Resolved latency, performance, and security issues within SQL Server 2000. • Performed SQL data and statistical analysis• Completed quality assurance testing of ASP sites based on SQL Server 2000 databases and validated data• Analyzed telecommunications radio frequency and wireline performance statistics using intranet sites. These included Loss of Transmission, Handover, Carrier, and… Show more verted Microsoft Access databases to SQL Server 2000 and managed running SQL services• Resolved latency, performance, and security issues within SQL Server 2000. • Performed SQL data and statistical analysis• Completed quality assurance testing of ASP sites based on SQL Server 2000 databases and validated data• Analyzed telecommunications radio frequency and wireline performance statistics using intranet sites. These included Loss of Transmission, Handover, Carrier, and Non-Radio Frequency Drops; Origination, Subrate, and Dedicated Channel Blocking and Averages; and Packet Data Performance• Analyzed statistics using Realtime Top 10 Reporting System and Trender Performance Statistics over spans of hours, days, weeks, months, and years Show less

• In SQL Server 2005 environment, monitored server disk space, CPU utilization, Event Viewer, Performance Monitor, SQL Error Logs, Job Activity Monitor, Activity Monitor, and Replication Monitor on enterprise system• Managed running services and agents and resolved SQL Server issues on multiple systems.• Performed backups and restores, scheduled jobs and maintenance plans, and created replication subscriptions• Created reports in SQL Server Business Intelligence Development Studio,… Show more • In SQL Server 2005 environment, monitored server disk space, CPU utilization, Event Viewer, Performance Monitor, SQL Error Logs, Job Activity Monitor, Activity Monitor, and Replication Monitor on enterprise system• Managed running services and agents and resolved SQL Server issues on multiple systems.• Performed backups and restores, scheduled jobs and maintenance plans, and created replication subscriptions• Created reports in SQL Server Business Intelligence Development Studio, Microsoft Excel, and Microsoft Dynamics – Great Plains on demand. Reporting projects included Cash Variance reports & Accounts Payable/Receivable Historical Aged Trial Balances• Built report customizations and executed system admin and tech support functions in Microsoft Great Plains• Analyzed and validated SQL data for referential integrity and to extract report information Show less

• In charge of overseeing entire internet sales process, which included the following steps: 1) Vehicle research/acquisition – used websites such as ebay.com, edmunds.com, carfax.com, and kbb.com to determine market value of vehicles for trade and purchase 2) Vehicle preparation – assessed needs of individual vehicles and dispatched office employees to mechanical shops, body shops, and detailing sites as necessary; ordered parts through new car dealerships… Show more • In charge of overseeing entire internet sales process, which included the following steps: 1) Vehicle research/acquisition – used websites such as ebay.com, edmunds.com, carfax.com, and kbb.com to determine market value of vehicles for trade and purchase 2) Vehicle preparation – assessed needs of individual vehicles and dispatched office employees to mechanical shops, body shops, and detailing sites as necessary; ordered parts through new car dealerships, wholesale auto parts companies, ebay.com, and car-part.com 3) Marketing and Advertising - Advertised vehicles on internet sites such as ebay.com and autotrader.com 4) Sales Appointments - administered direct sales, financing, vehicle warranties, and trade-ins• Supervised sales and office employees to accomplish the referenced processes• Responsible for management of office, lot, accounting, and company network and database• Strategized with management - budget, sales goals, personnel decisions, operations, and business development• Analyzed internet market data and vehicle data to improve purchasing decisions and sales processes Show less

• Provided training, technical support, and system administration to clients using company's Customer Relationship Management System for automotive dealerships• Provided server, PC, and connectivity support to clients in a call center environment using PC Anywhere, Remote Administrator, and Ping and Tracert functions• Used SQL Server 2000 features such as Enterprise, Manager, Query Analyzer and SQL Profiler to query database, resolve data issues, run/analyze stored procedures, and… Show more • Provided training, technical support, and system administration to clients using company's Customer Relationship Management System for automotive dealerships• Provided server, PC, and connectivity support to clients in a call center environment using PC Anywhere, Remote Administrator, and Ping and Tracert functions• Used SQL Server 2000 features such as Enterprise, Manager, Query Analyzer and SQL Profiler to query database, resolve data issues, run/analyze stored procedures, and examine system activity• Performed data analysis to verify data integrity and accuracy• Used Customer Relationship Management to assist clients in creating and managing reports, deals, inventory, customers, tasks, templates, Internet leads, sales goals, surveys, campaigns • Used Unix-based Dealership management system to track customers, inventory, and deals, and create reports Show less