Program Manager Project Management

Reginald Macrone Jones, Ph.D.

***B Peachtree Street NE Unit 483 Atlanta, GA 30309 +1-240-***-**** *********@*****.***

Summary

Experienced Senior SAS Consultant with a strong background in data integration and cloud solutions, including AWS and SAS Viya. Proven track record in developing and maintaining data models and algorithms to address business needs, and generating reports to communicate key findings. Eager to leverage extensive expertise in data engineering to drive impactful solutions in a Data Engineer role.

Technical Expertise

•Technical Expertise: Amazon Web Service (AWS), SAS Base, SAS Macro, SAS Statistics, SAS Unix, SAS MVS, SAS Graph, Proc, SQL, SAS Enterprise Miner, SAS Forecast Server, SAS JMP, SAS Data Integration Studio, SAS BI Dashboard, SAS Enterprise Guide, SAS Connect, SAS Add-In for Microsoft Office, SAS API Connection, SAS GRID Environment, SAS on AWS, SAS Viya, SPSS, MS Excel, MS Access, MS PowerPoint, MS SharePoint, MS Visio, MS Outlook, MS FrontPage, MS Pivot Tables, Business Objects, Crystal Ball, Teradata, Zycus, SAP, Oracle, Sybase, Output Delivery System (ODS), SAS/Intranet, Data Warehousing, HTML IBM Data Studio, SOAP, Python, Qlikview

•Clearance: Top Security Clearance - Homeland Security, Top Security Clearance/SCI - Department of Defense

Certification

• SAS Advance Certification for SAS9: SAS Advance Certification for SAS9

• SAS Platform Administration for SAS9: SAS Platform Administration for SAS9

• SAS Business Intelligence Content Developer for SAS9: SAS Business Intelligence Content Developer for SAS9

• SAS Base Certification for SAS9: SAS Base Certification for SAS9

EMPLOYMENT HISTORY

Macrone Consulting, LLC (Entellimetrix) Aug 2021 - Dec 2023

Senior SAS Data Engineer

•Installed, configured, and customized SAS Viya 3.5 software and related components, ensuring seamless integration and enhanced system functionality

•Administered and maintained SAS Viya servers, including Linux and UNIX environments, leading to improved system reliability and uptime

•Monitored SAS Viya server performance, identified and resolved issues, and optimized system performance, resulting in faster processing times and reduced downtime

•Implemented and maintained backup and recovery procedures for SAS Viya data and systems, ensuring data integrity and quick recovery in case of failures

•Managed user access, permissions, and roles within the SAS Viya environment, enhancing security and user experience

•Collaborated with other IT teams, including storage, network, and security, to ensure seamless operation of the SAS Viya platform, resulting in improved system reliability

•Develop and maintain Unix scripts for automating tasks and managing the SAS Viya environment.

•Established and maintained SAS/Access connectivity to various databases (Oracle, SQL, Redshift, Databricks, etc.), ensuring consistent data access and integration

•Developed and maintained SAS Viya programs and scripts to analyze large datasets.

•Created and implemented data models and algorithms to address business needs.

•Generated reports and visualizations using SAS Enterprise Miner to communicate key findings to stakeholders, leading to informed decision-making

Macrone Consulting, LLC (DHS-USCIS) Mar 2016 - Present

Senior SAS Platform Administrator/Engineer (Consultant)

•Installed, configured, and managed SAS 9.4 Business Intelligence environment on Windows and T-5 Spark Solaris Servers, including upgrades to SAS software for DHS-USCIS, enhancing system reliability and performance

•Supported administration of USCIS-DHS SAS environments, services, and tools, facilitating data integration, storage, and reporting for various business units, improving data accessibility

•Provided SAS system design, monitoring, performance tuning, and troubleshooting, achieving and maintaining optimum SAS platform performance, reliability, and availability

•Interfaced with business points of contact to set up applications and provided support and operational management of the SAS environment, ensuring seamless application functionality

•Interfaced with SAS developers and provided consulting services on SAS software capabilities, enhancing developer understanding and software utilization

•Interfaced with SAS Institute support personnel for USCIS-DHS projects, rapidly recovered from problems using SAS API Connection, and implemented countermeasures to prevent recurrence

•Managed metadata security configuration, licensing, and physical installation of servers, ensuring robust SAS environment security and operational efficiency

•Utilized AWS for deploying scalable solutions, enhancing system performance and reliability

•Built production data solutions using AWS services like Redshift, Databricks, Delta Lake, and Apache Spark, optimizing data processing and storage capabilities

•Leveraged AWS cloud native services, including Amazon RedShift and RDS, to enhance data management and streamline operations

•Utilized cloud concepts and data architecture principles, including data modeling, data movement, and data security, to enhance system efficiency and reliability

•Provided architectural guidance, installation, advocacy, and support for SAS Viya (3.4 and 3.5) in AWS, enhancing productivity for analysts, statistical modelers, and data scientists

•Supported the migration of users from SAS 9 to SAS Viya, ensuring a smooth transition and minimizing downtime

•Collaborated with users, clients, trainers, and product developers to establish development standards, create engaging training experiences, and produce helpful reference materials, improving user satisfaction and knowledge retention

•Trained and led the team and projects from a technical aspect, contributing to successful project outcomes and assisting in interviewing potential team members

Macrone Consulting, LLC (Manheim/Cox Communication) Sep 2014 - Feb 2016

Program Manager/SAS Platform Administrator/Developer (Consultant)

•Managed and developed the group infrastructure, achieving all IT service level agreements for the user community within the organization

•Collaborated with decision makers in global departments to identify and implement cost-effective technology solutions, enhancing organizational efficiency

•Worked with the SAS Team to successfully upgrade SAS 9.4 Cloud to SAS GRID, improving system performance and scalability

•Migrated legacy Base SAS code for use within Enterprise Guide, ensuring compatibility and enhancing data processing capabilities

•Converted SAS Code within SAS Base and SAS EG to create stored processes, streamlining data management and reporting

•Set up statistical models in SAS EM and built time-series models in SAS FS, improving forecasting accuracy for business operations

•Collaborated with end users, business analysts, and technical staff to plan, design, and develop enhanced business analytics capabilities using SAS software, leading to improved decision-making processes

•Drove SAS Product patching and release upgrade activities, acting as liaison to SAS for support issues, which ensured system stability and up-to-date software functionality

•Provided maintenance and support for SAS products during deployment and upgrades, ensuring seamless integration and minimal downtime for enterprise activities

•Managed and tracked SAS products inventory and license updates for servers and end users, ensuring compliance and uninterrupted access to necessary software tools

•Managed the configuration support and maintenance of the SAS platform, ensuring optimal performance and reliability

•Created API connections with SAS and tested them using Fiddler, SoapUI, and Python, enhancing system integration and functionality

•Assisted project teams with architecture design, developed documentation, and created project deliverables, contributing to successful project outcomes

•Used SAS programming to independently create, test, execute, maintain, validate, and archive programs, generating input files for critical processes and ensuring data accuracy

•Documented all work clearly, managed assignments to meet timelines, and produced high-quality deliverables, supporting project efficiency and success

•Provided expertise, direction, and training to staff on SAS programs, enhancing team proficiency and program efficiency

•Managed the mid-tier infrastructure, ensuring seamless integration and operation, which improved system reliability and user satis- faction

•Managed the SAS Security framework using Group and Role management in the SAS Management Console, enhancing data security and compliance

•Applied univariate and multivariate statistical techniques, including Multiple-Regression and Factor Analysis, to assess risks like loss and gain in the automotive industry, leading to more informed decision-making

Macrone Consulting, LLC (Department of Defense) May 2011 - Sep 2014

Program Manager/SAS Platform Administrator (Consultant)

•Supported operational Requests for Support (RFSs) for the Department of Defense, ensuring timely and efficient resolution of issues

•Provided support for tracking by extracting and analyzing data, updating ESRI/ArcGIS shape files for mapping, maintaining the metrics dashboard, and delivering quantitative organizational assessments to aid leadership in functional evaluations

•Led technical initiatives for SAS application and technology products, enhancing the capabilities of the enterprise Business Intelligence team

•Assisted project teams with architecture design, developed documentation, and created project deliverables, contributing to successful project completions

•Translated business requirements using complex methods and models to determine system solutions, improving alignment with organizational goals

•Migrated legacy Base SAS code to Enterprise Guide, improving code accessibility and integration with modern tools

•Converted SAS Code within SAS Base and SAS EG to create stored processes, enhancing automation and efficiency in data processing

•Collaborated with end users, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities using SAS software, resulting in improved data-driven decision-making

•Drove SAS Product patching and release upgrade activity, acting as liaison to SAS for support issues, ensuring system stability and up-to-date functionality

•Provided maintenance and support for SAS products during deployment, upgrade, and changes, ensuring seamless operation and minimizing downtime during enterprise activities impacting SAS infrastructure

•Managed and tracked SAS products inventory and license updates for SAS servers and end users, ensuring compliance and operational efficiency

•Managed the configuration support and maintenance of the SAS platform, enhancing system reliability and user satisfaction

•Presented findings to US Intelligence Community (IC) members, facilitating informed decision-making and strategic planning

•Generated SAS code using ODS outputs to present data in HTML, PDF, Excel, and RTF formats, improving data accessibility and presentation quality

•Used SAS for extracting and transforming data from Oracle, Sybase, Mainframe, and Teradata for data analysis, supporting marketing and credit card analysis to drive business insights

Delex Systems, Inc. (Department of Defense and Homeland Security) Sep 2009 - May 2011

Program Manager (EUCOM AOR)

•Produced a structured framework for centralizing defense demographic data, analytic reports, and tools for Europe, Eurasia, and Levant regions, enhancing data accessibility and analysis

•Performed programming and analysis tasks using SPSS, SAS Enterprise Miner, and Excel to conduct research projects and produce analytic studies, improving the accuracy of statistical analyses

•Developed strategies for collecting unavailable defense demographic data, leading to more comprehensive data sets for analysis

•Formulated alternative scenarios and hypotheses, relating demographic data and analysis to future developments, aiding strategic planning

•Collaborated with JAC analysts, JIOCEUR elements, and USEUCOM staff to enhance interdepartmental communication and data sharing

•Collaborated with US Intelligence Community (IC) members and government agencies to enhance USECOM polling efforts, improving data accuracy and inter-agency communication

•Collaborated with geospatial analysts and graphic specialists to develop complex demographic products, enhancing visualization tools for better data interpretation

•Created and maintained demographic profiles for over 15 countries in Europe, Eurasia, and Levant, supporting strategic planning and decision-making

•Made collected demographic information accessible to the USEUCOM Enterprise, enhancing data availability and operational efficiency

•Developed, produced, and disseminated population pyramids for all countries in Europe, Eurasia, and Levant, aiding demographic analysis and policy formulation

•Provided expert advice on selecting statistical methodologies for specific applications, leading to successful implementation and improved decision-making processes

•Built a descriptive database of Data Mining models using SAS Enterprise Miner, enhancing the accuracy of modeling characteristics and supporting data-driven decisions

•Used SAS Base to create predictive models based illegal activities using logistic regression modeling techniques.

•Performed meta-analysis of historical Data Mining programs, leading to improved future models and providing actionable modeling recommendations

•Used programming techniques to conduct data profiling with SAS Data Flux and other analytical tools, resulting in enhanced data quality and more reliable analysis outcomes

•Assisted in designing and installing data quality controls and scorecards for each master data entity using SAS Data Flux with SAS Dashboard, enhancing data accuracy and reporting efficiency

Education

Howard University

Aug 1995 - May 1999

Ph.D., Criminology

• GPA: 3.8

District of Columbia

North Carolina Central University

Aug 1993 - 1995

MA, Sociology and Data Analysis

• GPA: 3.7

Durham,NC

North Carolina State University

Aug 1986 - 1991

B.A., Criminology and Statistics

Raleigh, NC

• GPA: 3.2

Contact this candidate