Mark Kenneth Lyons Email & Phone Number

Project Goals:To increase process automation, minimizing delays in release of high-quality, high-value administrative health data to internal and external partners. Created SAS working proof-of-concepts to enable: o A no/low-code table-driven unified system to perform data source validation, data dictionary generation, business process profiles, metric profiles, reporting profiles, snapshots, trending and execution.o SAS table-driven QC/QA and data management metrics for data fields, columns, rows, tables, updates, trending and alerts. o MS Power Apps interfaces to directly read SAS control tables with no data conversion or synchronization needed.o PowerShell custom scheduler to execute programs and processes while waiting for the security team to remove a security policy blocking Windows Task Scheduler Services.o SAS & VBA code to convert all legacy code into auto-documented flowcharts and data asset auto-inventories (data sources, data dictionaries, metrics, reports, snapshots & trending)o SAS EG working proof-of-concept table-driven production system for future interaction with Github.

San Francisco, California, Us

Creation of a CI/CD Pipeline (Continuous Integration / Continuous Deployment) integrating SAS Viya 3.5 with Github Enterprise & Docker

Tokyo, Jp

(Reached maximum contractor limit of 18 months)• Technical coordination of IT Infrastructure upgrades, performance analysis, optimization, for SAS Business Intelligence, Citrix, Dell Isilon, Data Migration to Amazon AWS. • Translating Leadership & Subject Matter Experts (SME's) discussions and documentation into actionable results • Extracting the critical information that define the problems at a high level, drilling down to details• Prioritizing the highest priority issues and insights to address first, achieving the greatest gains in the shortest time• Choosing the right approaches and tools to attack and solve the problems in an expedient and efficient manner• Bringing live data into a central location for analysis to identify bottlenecks and measure improvements• Assisting as a central coordinator with the technical teams to deliver improvements• Presenting the progress at an executive level• This appears to be a wide scope of skills. I have more that relate to a technical audience.• Creating real actionable solutions and communicating them in an understandable language to clients

New York, Ny, Us

SAS Platform Administrator/GRID Administrator providing:- Operational enhancements, maintenance, installation and support of the SAS Enterprise Business Intelligence (EBI) and SAS GRID Servers 9.4 platform in a GRID server farm. -Provided SAS platform security management, SAS application and underlying infrastructure support (OS, Storage, SAS 9.2/SAS9.3/SAS9.4EBI Applications, Web and Database) and ensured processes are aligned with tactical and strategic information management initiatives.- Served as liaison between the SAS Developers and enterprise infrastructure support teams to ensure appropriate delivery of technology solutions (performance tuning, data modeling, capacity and utilization, backups, disaster recovery, user support, training and documentation) in accordance with business requirements and objectives, and compliance with IT policies, standards and agreed upon service levels.- System health monitoring and diagnostics, installations, maintenance releases, upgrades and hot fixes to all GRID servers.- Executing change control and promotions activities.- Published best practices and guidelines for usage of the SAS platform. Technical Lead and global point of contact for all SAS Administrator related projects and activities.- Manage and track SAS products inventory and license updates for SAS servers and end users.- Creation of Data Dictionary, Libraries, and Connection strings for all needed data sources.- Work with the SAS user community; perform periodic code reviews to insure that SAS applications are utilizing efficient design principles and adhering to internally published best practices.- Execute change management processes surrounding new releases of SAS functionality.- Evaluate and recommend new tools and methodologies to assist with change management and perform upgrades of the SAS environment when necessary.

New York, Ny, Us

• Building and maintaining database structures for information storage and retrieval.• Building and maintaining ETL efficient processes.• Experience with a development lifecycle methodology.• Interpreting business requirements to effectively deliver requirements.• Design and creation of a production predictive analytics and model generating system using SAS• Training of staff to use predictive analytics and model generating systems• Certification as a SAS Platform Administrator (2012) / SAS System Administration & Security Administration duties• Production of business intelligence reports using Oracle OBIEE, SAS, Excel, Access, VBA and Perl• Production of Online Video Training of developed SAS and Oracle solutions• Production of automated Data Warehouse – Data Dictionaries• Development of integrated backend processing with real-time Web front-end interfaces

Basel, Baselstadt, Ch

• Design and creation of a Pharmaceutical workflow database & user interface using SQL / VBA / Excel / Access• Analysis of requirements, designing, developing and packaging of software for various deployments • Maintaining and modifying existing software • Managing projects from inception through completion • Promoted code reuse • Diagnostics of reported problems and working with operations staff to remediate production issues • Working with the QC team to ensure applications integrity including development of automated test suites • Integrated clinical regulatory data & systems from Respiratory, Cardio & 6 other divisions into 1 automated database + reports and alerts• Creation of a workflow system prototype, demonstrated to senior leadership.

Completed a database integrating pharmaceutical prescriptions, doctor information, marketing segments and deciles in addition to pooling and other sales/marketing information.

• Creation of a data text mining system to produce predictive variables for business intelligence• Creation of data presentation VBA/Excel based reports for decision support • Analysis & optimization of data and business rules for data text mining• Creation of a table driven production system for automation needs

Philadelphia, Pa, Us

• Created a metadata-driven financial data warehouse system • Created a performance benchmarking analytics system• Integrated Linux / Sun / PCs / SQL Server / SAS / PHP / Web • Created an E-learning solution compatible with all browsers

Rahway, New Jersey, Us

• Client and technical point of contact • Created additional SAS & VBA interactive marketing reports. • Redesigned over 30 product marketing reports • Integrated Wolters-Kluwer hospital-level sales data

New York, Ny, Us

• Client and technical point of contact • Enhanced data warehouse legacy code• Wrote requirement specifications, timelines & project plans • Quality control / reporting / alerts using email, SAS ODS & PDF• Created data modeling & data warehouse solutions using SAS • Writing test plans / quality control / production documentation

Basel, Baselstadt, Ch

• Developed sales and marketing analysis & reporting solutions • Integrated IMS marketing data for physician level reporting• Identification of proper data sources & analysis • Programmed Unix solutions for file management• Programmed geographic solutions for business data • Optimized prior reporting code for greater efficiency

• Programmed, tested and implemented a profitable micro-cap equities market trade signaling system using Metastock modeling language.

Monroe, La, Us

• Client and technical point of contact • Developed business intelligence & leadership key metrics• Gathered requirements and business needs of Finance & Regulatory• Developed statistical/data models of business operations & processes• Developed applications for business needs • Developed measurements to study business initiative profit / loss• Utilized multi-vendor corporate data to perform analysis • Utilized SAS,VBA,Oracle, Unix, MVS, HTML, CSS, XML and Web • Recommended strategic methods and process changes to leadership • Integrated multi-vendor systems to provide a unified business view

Masters Level Certificate Of Advanced Studies (Computer Science), Database Administration (Gpa 3.9)

A.A.S Network And Computer Systems Administration, (Computer Science) (Gpa 3.9)

(Double) Ba & Ba, Economics / Finance Minor & Music - Classical Composition