Contract Analyst Sas Institute

Kirk F. Doxtader

*** ******* ****, *****, ** ****1

(Mobile) 484-***-****

E-Mail: *******@*****.***

https://www.linkedin.com/in/sasguru

SUMMARY: Highly focused, innovative SAS Programmer Analyst and VBA Programmer / Project Leader / System Integrator with a win/win attitude who uses the best programming practices to make fully automated integrated process-oriented systems. Many years of experience in a wide variety of businesses and technical platforms, able to see the big picture and apply solutions which improve the corporate vision and position.

Skill Areas: SAS: Base, Enterprise Guide, MP Connect, Macros, ODS, Access, Connect, SQL, BI, DI, ODS Graphics, Proc Report, Statistical Procs, Graph. / Script Languages and Job Control: UNIX and Linux Shell Scripting, REXX, REXX Pipes, CLIST, POWERSHELL, VBSCRIPT, JSCRIPT, AWK, JCL. / Other Programming Languages: VBA (Excel, Access, Word, Outlook), Frontpage, Sharepoint Designer, Focus, ASP, BASIC, FORTRAN, COBOL, Python, JAVA, HTML, IDMS, IDMS/DC, IDS, Business Objects, BTEQ. / Software Library and QA/Defect Control Systems: GIT, BITBUCKET, SVN, ALM. / File Structures: Flat files, XML, SAS Datasets, Focus DB, VSAM, ISAM, RDMS-(DB2, TERADATA, ORACLE, DBASE, RBASE, INGRES, MS SQLSERVER, IDMS, IDS, DBASE, RBASE, MS Access). / Operating Systems: UNIX, LINUX, MVS, Z/OS, VM/CMS, VMS, GCOS, MULTICS, SUN/OS, WINDOWS, DOS. / Excel: VBA, Pivot tables, Power Query. / Sectors: Government, Pharma, Chemical, Food, Aerospace, Banking, Finance. / Disciplines: Manufacturing and Engineering, Logistics, Material Requirements Planning, Nutritional Science, Clinical, Census, Marketing, Banking, Finance, Auditing.

EXPERIENCE:

DHG/Dixon Hughes Goodman (now FORVIS as merger of BKD and DHG completed on 06/01/2022), Charlotte, NC – 05/02/2022 – 06/06/2022, Excel VBA Programmer, remote

-Programmed in Excel VBA to automate build out of SOC1 and SOC2 (System and Organization Control) Client Audit Control Workbooks.

oProgrammed on Windows 11 platform in MS Excel 365 VBA

oForm Inputs – MS Dialogs – Named Ranges - Buildouts of Workbooks, Worksheets, and Worksheet Details dependent upon selections - Standard Statements - Conditional formatting – Client Activity and Consolidation of all Client Activity reports – Conforms with AICPA's SSAE 18 Attest Standard.

oDaily standup meetings in MS Teams

Data-Axle/Freeman Leonard, Dallas TX – 02/2022 – 03/2022, Statistical Analyst, remote

-Market research and campaign reporting of various segmentations using SAS and Excel.

-Development of SAS 9.4 code and Excel VBA programs on a Windows platform.

-Office 365 Stream and Canva Video editing

-Atlassian Jira Kanban Board

United States Census, Suitland, MD Contract Senior SAS Developer. 12/2019 – 12/2021, remote 03/2020-12/2021

-2020 US Island Areas Census. Senior SAS Developer.

-Worked within a group of 5 supporting Island Area Census file creation, pre and post editing processes, and reporting, per specifications and the writing of specifications. Supporting over 12 separate departments and over 25 Subject Matter Experts (SME) statisticians and management.

-Linux BASH, KSH and AWK scripting, SSH, VIM, Base SAS, Macros, SQL, ODS, Enterprise Guide. VBA programming in Excel and Word.

-Performed ETL functions utilizing SAS Data Step and SQL.

-Use of statistical procs during processing and testing.

-Updating of support files; SAS, Excel, flat files.

-Creation of an audit trail of testing results when corrections were made to identified defects.

-SVN version control release manager

-Full life cycle participation; requirements, development, testing, rollout.

-Excel VBA, Pivot Tables, Power Query

-Sharepoint, One Drive. Microsoft Teams

-Microsoft Powershell

JP Morgan Chase, Wilmington, DE Contract Analyst/Programmer. 01/2019 – 07/2019

-Community Banking Credit Card Corrections. Responsible for case corrections having customer impact.

-Teradata SQL, SAS Connection and Access, Enterprise Guide, TSYS, some Oracle. Unix Ksh environment.

-Advocated and installed Git for version control.

-Development of training documents.

DePuy Synthes, West Chester, PA Contract Analyst/Programmer. 04/2017- 03/2018

-Software developer at Depuy Synthes, a company of Johnson & Johnson, maker of orthopedic medical devices, in Post Market Surveillance Reporting department.

-Developed, enhanced, debugged, corrected, and streamlined reporting processes. Transformed code to utilize Oracle Data Warehouse for origin of most of data. Implemented new changes and normalized old data necessary for the adaptation. My ideas and critical decisions regarding the mission critical Post Marketing Surveillance Reporting System derived from my wide range of experience were successfully developed and implemented quickly.

-Base SAS 9.4, Macros, Proc SQL, Proc Report, and ODS Graphics in a Windows environment utilized to produce reports regarding Complaints/Shipments, and Patient Harms. Achieved publish ready output. Reporting done monthly according to scheduled planned reviews of selected parts. Output used in scheduled reviews by QA and Staff Engineers, and FDA auditors. Documents stored in Windchill indexed repository per FDA requirements.

-Inaugurated and implemented use of local BASH Git, and remote BitBucket for version control and source code management instilling discipline in the development and a providing a documentation trail of changes. Overcame initial reluctance of management and staff toward the implementation.

-Utilized macro programming to move from a break fix to data aware software. Data aware programs use code to derive necessary parameter settings dynamically from data occurrences and min/max values.

-Developed Outlook VBA program which read attached Excel Spreadsheet requests initiated by users daily around the world regarding part Complaint and Shipment data. Validated input Excel sheets for correctness. Checked if user had been granted access via LDAP inquiry. Automatically fired off batch SAS program to fulfill request. Provided audit trail. Sent Email Message formed in HTML to user automatically upon successful completion using Outlook’s own Email interface.

-Inaugurated Change Request system in Access to record changes required in the software to accomplish objectives.

-Created development environment for the program testing.

-Interfaced with and directed offshore team.

-Pressed IT network and disk storage support, and management with dogged determination regarding network slowness. This attention to a critical problem led to uncovering what was supposed to be temporary situation which had lingered for many years. When discovered there was a ready solution which when implemented benefited the entire group.

United States Census, Suitland, MD Contract Analyst/Programmer. 06/2012 – 04/2017, remote 3 days/week

- Worked for American Community Surveys department. Information that ACS collects used to give communities the information they need to plan investments and services.

-Updated Data Collection Facility for 2013 – 2017 requirements.

-Programmed in Base SAS 9.2, Macros, MP Connect, KSH scripting, AWK, Python, Excel and ACCESS VBA, SAS BI, Sharepoint Designer. Operating systems; Red Hat Linux and Windows. Used SVN library and ALM (HP Quality Center).

- Counseled department, and demonstrated by successes the importance of consolidation, streamlining, and removal of hard coding. Accomplished process improvements by utilizing passed parameters, macros, lookup tables, dynamic programming, automated audits, and reusable modules.

- United programmatically SVN library, Master Program List, and ALM thereby producing marriage of coding activity and with ALM open jobs. Accumulated SVN XML, ALM records via VBA TDApiOle80.TDConnection object connection to ALM MSSQL database, and script search of Activation Packages for registered releases married together with a SAS program to get a concise profile of what is in pipeline.

- Access database created showing total department program recursive calls, from scripts through programs as well as data contents with links that enable opening program listings and logs with all detail elements and stats (ie line numbers, record counts, variable names, etc).

- BI Census Matrix project included Data Integration job with approximately 70 nodes, Map with a dozen lookup tables and filters, several defined elements, capped with Web Reporting.

-Built Sharepoint form for Weekly Status Reports.

Bank of America, Wilmington, DE Contract Analyst/Programmer. 1/2011 – 06/2012

-Extracted Market Analysis data for direct marketing campaigns from BoA databases and ported to Epsilon for creation of Analytical Data Mart. Data retrieved from Teradata in Unix and DB2 in z/OS, using SAS Proc SQL. Additional tools KSH, BTEQ, Teradata SQL Assistant, Business Objects. Additional programming for subcontractor (Epsilon) Unix platform using SAS on Netezza database.

Dollar Financial Group, Berwyn, PA Contract Analyst/Programmer. 8/2010–12/2010

-Developed SAS datamart containing application, loan, and customer data for a short-term small loans company. Worked in their Credit Risk Analysis department.

Proc SQL, and Base datasteps used against a MSSQL Server database.

Highlights included coding to identify new customers based on whether they had not been active for over a year, or customer's initial loans. The logic to handle 43 different transaction codes, some against original face balances and others against services and interest, and more. All properly bucketed within several balances, such as Total, Face, Service and Interest, Profit, Collections, etc. as well as many more fields, rolled forward progressively in a monthly fashion. This included the appropriate allocations even against unallocated payments. Those that could not be identified at the time of the transaction (ie. Prior to proper sequenced loan events).

Bank of America, Wilmington, DE Contract Analyst/Programmer. 11/2009–8/2010

-Validation, testing, and consolidation work in Credit Card Pricing. Using SAS, SQL, SAS Connect, and SAS Access in a z/OS environment with DB2.

JP Morgan Chase, Ft Washington, PA Contract Analyst/Programmer. 01/2009 – 02/2009

-Worked with IT Group at JPMC Utilizing SAS 9, Base, Macro, ODS, RTF, on Unix platform to maintain and update, existing mortgage refinancing system for the Household Finance arm of the bank. System utilizes embedded PROC SQL and uses both SAS ACCESS and CONNECT to collect and update data in Oracle DBMS. Refi system interfaces with several external agencies as well as queries internal files to pre-qualify individuals for refinancing.

Astra Zeneca, Wilmington, DE Contract Analyst/Programmer. 09/2008 – 10/2008

-Worked in Corporate Marketing Analytics group. Assisted Statistician in structuring data related to Marketing Rep sales presentations to physicians for use in modeling to form predictive outcomes. Developed tools to quickly analyze datasets for omission patterns and key counts of dataset variables (number of missing, non-missing, max, min, mean, positives, negatives, zeros). Utilized SAS 9.1 on Windows 2003 Server.

Bank of America, Newark, DE, Contract Analyst/Programmer. 04/2007 – 03/2008

-SAS 9, Unix, IBM Mainframe, PC, SAS EG, SQL, DB2, Scripting, Focus, Sharepoint Business Unit Site Admin, Frontpage, Sharepoint Designer, HTML. Conversion of Focus to SAS. Trainer, technical advisor, coordinator, conversion programming, Sharepoint web site design and maintenance.

-Conversion of programs from Focus VSAM and DB2 old database structure, to SAS Access DB2 for Risk Strategies department. Risk Strategies effort in support of analysis of business risk vs reward associated with BOA credit cards with regards to such elements as credit ratings, interest rates, affinity groups, demographics, promotions, number of applicants, number of approvals, etc.

MERCK, West Point, PA, Contract Analyst/Programmer. 5/2005 – 03/2007

-Principally writing SAS version 9 code on an IBM Mainframe MVS and PC environment. Some minor work in Unix as well. Utilized my experience in Base, Macro, DDE, ODS, Connect. Additionally, REXX, JCL, ACCESS, Outlook and Excel VBA, and SQL programming. All used in support of retrieval and analysis of Pharmaceutical Marketing and Sales data, much related to IMS data. Very large 100M+ record data files. Supporting statistical group, management, marketing, and sales teams.

-Business purpose was for the analysis of promotions, and for the analysis of performance of Merck drugs vs the competition.

-Used expertise to consolidate, productionalize/automate, and streamline processes. Automated initiation of processes across multiple platforms via email triggers.

-Moved department relying on tape-based delivery to VPN delivery. Reducing the manual handling of tapes, the time to process the data, while also improving the security of the data.

MBNA America, Wilmington, DE, Contract Business Analyst/Programmer. 11/2004 – 5/2005

-Focus and REXX with Pipelines programming in TSO/MVS environment with data related to APR and fee changes and special projects in this credit card banking Corporate Operations and Fulfillment Department. Strict system development, testing, and documentation methodologies. Rigid deadlines based on banking cycles. Multimillion record databases in DB2, VSAM, and Flat files. Access and Excel VBA programming focused around generation of planning, testing, and documentation for projects. Developed prototype auto-coding system for credit card pricing.

Rohm and Haas Company, Philadelphia, PA, Contract Analyst/Programmer. 11/1997 – 5/2004

-Assigned to rework existing interface systems of Rohm and Haas’ Supply Chain Management System called Manugistics LogsPlus. SAS (Basic, Procs, Macros), FOCUS, VM/CMS, MVS/TSO, JCL, REXX with PIPES, Access, VB, VBA, SQL, FrontPage, ASP, HTML, used in 24/7 support. Original interface programs were patchwork of quick fixes accumulated over several years. Remolded processes into a solid system by employing best analytical and programming practices. Used parameter driven routines, macro code modules, and table lookups to limit number of hard coding changes and simplify overall system. Reworked system continually until accurate, efficient, and stable. System was centerpiece for Production Planning and Scheduling, Order Management, Sales Forecasting, Distribution Requirements, and Logistical Planning. Shortened the time for daily, weekly, and monthly updates to the system by optimizing SAS and REXX code. SAS and REXX code was efficiently designed to read large customer order files and manipulate the data into transactions for the LogsPlus System. Stabilizing system as well as shortening update times added immensely to the company’s ability to satisfy customer demand while reducing costs. Supported EDI interface. Transition logistical system to SAP. Learned Data Warehouse for inquiries during transition.

Centeon, King of Prussia, PA, Contract Analyst/Programmer. 5/1996 –11/1997

-Modified and developed SAS(Basic, Procs, Access, Macro, Graph)/INGRES/SQL/DEC-VMS-UNIX based Clinical Trial system for RPR's LLC Centeon Clinical Data Analysis Department. Performed NDA, Phase II, and III clinical programming requirements. Generated listing and tables related to Demographics, Medical History, ECG, EKG, Adverse Events, Serious Adverse Events, Concomitant Medications, Laboratory Results, Drug Efficacies or Response under different regimens, et al. Repeated analysis of variance and their significances were performed on patient response to regimen over time and as well as dose levels. Reports submitted to FDA for the plasma derived drugs Albuminar and Gammar P. I. V. Submissions made per ICH & CDER Guidelines. Performed and created edit checks and developed and ran efficacy and safety reports. Created ancillary systems in Excel VBA for Investigator Patient Tracking and CRO Evaluation Survey.

Campbell Soup Company, Camden, NJ, Contract Analyst/Programmer ((Part Time) See original contract of 6/1991 for further information). 3/1995 – 9/1998, remote and hybrid

-Expanded capabilities of the system, using SAS, Fortran, and FOCUS, extending link from the Nutritional Department processes to the Label Submissions department. This was contract follow-on to the successful completion of a previous contract at Campbell’s. System was left unchanged from 1993 to 1995, a testament to its ability and stability. Upgraded with the aid of another person who was an employee of my company, DoxData Consulting.

Lockheed Martin Astro Space, Hightstown, NJ, Contract Analyst/Programmer. 8/1994 - 5/1996

-SAS and Cobol IDMS used in the conversion to and implementation of the large-scale Aerospace Strategic Material Requirements Planning II (MRPII) system. Improved business competitive edge in the marketplace. Improved overall efficiency of plant and supply chain control.

-Enabled enhanced schedule control with Production Planning Report, major element in promoting system from MRP to MRPII Class A status.

-Migration of SAS programs to Unix system

Bio-Pharm, Blue Bell, PA, Contract Analyst/Programmer. 1/1994 – 5/1994

-Designed and developed FOCUS and REXX system in IBM VM/CMS environment that validated/edit checked clinical trial data. Completion of this project enabled manpower to be reduced or redirected into other vital areas of clinical research support.

-Startup CRO had no edit checking software prior to my arrival.

Martin Marietta, Lawrenceville, NJ, Contract Analyst/Programmer. 8/1993 – 1/1994

-Consolidated existing MVS/SAS code, in this TSO/MVS environment, in over 50 programs to 2 programs by parameterizing processes used in MRP System. Greatly enhanced manageability, accuracy, and response to modifications required by users.

-Produced Material Shortage report that mortgaged replenishments against the requirements in MRP system.

-Hired on contract because of my hands on experience with the PIOS MRP system when I worked for GE.

Campbell Soup Company, Camden, NJ, Contract Analyst/Programmer. 6/1991–4/1993

-Designed and developed Nutritional Labeling System to comply with statistical requirements of the FDA. Written in FOCUS, SAS, and Fortran in VM/CMS environment. System included large data files consisting of laboratory data for all Campbell Soup products accumulated over many years. Statistical analysis of the data included T-Test, determination of outliers, standard deviation, and variance. Information regarding to analysis was logged with tags back to the original data. These referenced data are used by the company to support their claims to the FDA about their products nutritional content. Supplemental product claims of low or non-fat, low sugar and non-sugar, low carb etc. are supported by the database. These claims and results and are submitted as well to the FDA for authorization of product labeling.

-Previous contractor left only a database and a way to load it from the old system. Almost useless. I developed a complete Focus system integrating it with the labs, validating the data, presenting screens for inquiry and editing, and producing reports. A full fledge system.

General Electric, King of Prussia, PA, Columbia, MD, Various. 6/1973 – 6/1991

-Program Schedule Analyst/Cost Manager, SAS, FOCUS, RBASE, ARTEMIS, Sun-Unix Interleaf

-Decision Support Site Manager and Programmer Analyst, SAS, FOCUS, RBASE, DBASE

-Programmer, Cobol IDMS, Fortran

-Manufacturing Systems Specialist, Cobol IDS, Fortran

-Production Control Specialist

-Time Standards Specialist

EDUCATION:

West Chester University US-PA-West Chester, Bachelor's Degree (Honors), BA Psychology

Skillsoft Training in Oracle 7/2004

HOBBIES AND INTERESTS:

Golf, skiing, swimming, stamp collecting, history, bible study

Contact this candidate