Sas Developer/programmer Analyst/technical Lead Resume
Pittsburgh, PA
SUMMARY
- Hardware: CPU - IBM S/36, S370, 3081, 3083, 4381, 3090, ES9000, HPTS, 9672, Z900/103, DASD - IBM 3350, 3380, 3390, 3490, 3880, 3990, 2105, RVA, Hitachi, EMC, TAPE - IBM 3420, 3480, 3490, 3590, STK SILOS, IBM ATL, VTS, VTL - IBM 3720, 3725, 3745, 3746, 3274, 3174, 3172, 3191, CISCO Routers, MIDRANGE - RS6000, AS/400, pSeries, Sun
- Software: MVS/OS, MVS/370, MVS/XA, MVS/ESA, OS390, z/OS, UNIX, JES2, TSO/E, ISPF, JCL, ODE, DFDSS, DFSMS(HSM, RMM,DSF etc), Integrated Catalog Facility, Storage Area Network, DFP, RACF, RPG/RPGII, TMS, SDSF, VTAM, Virtual Access Methods(VAM), CA1, 7 and 11, REXX, CLIST, CICS, DB2, IMS, HSC, HMC, MIMGR, OMEGAMON, SQL, C+, OMEGAVIEW, SPACEFINDER, SRDF, TIMEFINDER, TCAM, SAS, SAS/STAT, SAS/GRAPH, SAS Enterprise Miner, SAS Enterprise Guide, shell scripting, Connect: Direct, MS Office, Excel, Lotus Notes, Project Management, Change Management, PowerPoint, Remedy, AIX, IBM Utilities, Tivoli Storage Manager, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, ESP Scheduler Package, BMC Control Products, SAP, Sunrise, Innovation (FDR/ABR, etc), CA-DISKSummary:
- I’ve been in the IT field for more than 40 years. I’ve done everything technical there is. I believe I’m very well rounded and an ideal fit for this opportunity. Things I’m proficient at are:
- Identifying, designing, developing, validating, documenting and training where new processes are concerned.
- Managing SAS Metadata, and Configuration, installation and administration of SAS environments, using the SAS Management Console.
- Participating in infrastructure support activities, promoting products and identifying security opportunities.
- Most of the SAS software, in regards to Finance, marketing and Healthcare.
- Excellent communicator.
- Very good at time management.
- Started in Operations, which I learned then later was designated a SME.
- Ramp up time is minimal. I prefer to hit the ground running.
PROFESSIONAL EXPERIENCE
Confidential - Pittsburgh, PA
SAS Developer/Programmer Analyst/Technical Lead
Responsibilities:
- Provide expertise to Decision Analytics Infrastructure team on creating a Data Mart for the RCMR.
- Act as a lead SAS programmer for conversion of RCMR process.
- Create adhoc report requests for validation of ETL process.
- Work with client users to resolve issues with RCMR data mart problems.
- Use ETS to model risk factors and predict economic outcomes.
- Act as SME for SAS queries and problems.
Environment: MS Project, SAS Base, SAS EG 9.4, SAS GRAPH, SAS BI, SAS DI Studio, SAS Enterprise Miner, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Bloomfield, CT
SAS Developer/Programmer Analyst
Responsibilities:
- Provide expertise to Decision Analytics Infrastructure team on creating a healthcare reports for Confidential clients.
- Provide graphical and analytical exploration capabilities for time-series data.
- Experience inreviewing case report forms CRF’s/SDTM/ADaMto ensure that the protocol objectives are met and the project standards are maintained.
- Exposure toCDISC Standards,21 CFR Part 11, GxP guidelines,Bioethics, IRB guidelines,HIPAA guidelinesand Regulatory Submissions(CSR, BLA, NDA, including ISE and ISS).
- Manage SAS Metadata, and Configuration, installation and administration of SAS environments.
- Participated in infrastructure support activities, promoting products and identifying opportunities in re-using information and data.
- Work with client users to resolve issues with problems relating to scheduled reports.
- Act as SME for SAS 9.3 problems.
- Collaborated line of business technology and vendor partners for analytics concepts, best practices and to establish analytic application development.
Environment: MS Project, SAS Base, SAS GRAPH, SAS Enterprise Miner, SAS BI, SAS DI Studio, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Wilmington, DE
SAS Developer/Programmer Analyst
Responsibilities:
- Provide expertise to Decision Analytics Infrastructure team on creating a Data Mart for the credit card division.
- Act as a lead SAS programmer for install of new process to populate Data Mart.
- Create adhoc report requests.
- Work with client users to resolve issues with credit card data mart problems.
- Act as SME for SAS Data Integration problems.
Environment: MS Project, SAS Base, SAS GRAPH, SAS BI, SAS DI Studio, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Milwaukee, WI
SAS Programmer Analyst
Responsibilities:
- Provide expertise to Analytic team on SAS EG 9.2
- Act as a SME for install of new version of SAS EG.
- Provide graphical and analytical exploration capabilities for time-series reports.
- Provided guidance to client using Information Delivery Portal.
- Reviewed advantages of Web Report Studio for client.
- Provided consultation to client analysts for use of SAS EG in HR process flow.
- Manage SAS Metadata, and Configuration, installation and administration of SAS environments.
- Collaborated line of business technology and vendor partners for analytics concepts, best practices and to establish analytic application development.
- Participated in infrastructure support activities, promoting products and identifying opportunities in re-using information and data.
Confidential - Chattanooga, TN
Senior SAS Programmer
Responsibilities:
- Provided SAS BI knowledge for BSBCTenn in support of VSHP and Choices Book of Business project for the Tennessee Dept of Insurance.
- Provided clients data coding ability in support of VSHP and CHOICES book of businesses that was requested for front end validation.
- Created Macros in anticipation of production installation on the Mainframe.
- Working knowledge ofmedical terminology in clinical trials, clinical trial methodologies, and software systems development.
- Wrote program specifications for new code create in support of VSHP and CHOICES project.
- Created unit acceptance testing documentation in support of the VSHP and CHOICES project.
- Worked claims process which cleansed data in preparing for input into analysis.
- Regulatory submission to the TDOI.
- Worked with SAS EG on the UNIX platform.
- Used VB to add missing data to state insurance templates..
Environment: MS Project, SAS Base, SAS GRAPH, SAS BI, SAS Enterprise Miner, SAS DI Studio, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Okemos, MI
SAS Programmer/Developer
Responsibilities:
- Provided SAS BI knowledge for RCSG in support of project for Data Warehouse for the MDOE
- Provided clients data analysis from customer databases that was requested for front end validation.
- Worked with project team to create output needed at checkpoints throughout project.
- Verified data to be loaded is accurate.
- Used raw data as input to the SAS Data Integration system to populate Data Warehouse.
- Extracted data from source systems, then transformed it, by validating, cleansing and filtering it using SAS code as the principle process.
- Provided with design of SOA architecture for the SAS Information Delivery Portal and SAS Metadata Server. Also, set up process for SAS users to utilize SAS Stored Processes within dashboards using SAS Data Integration Studio as the tool.
- Reviewed Technical documents and verified accuracy.
- Collected data from DB2, IMS, Oracle, SQL and Teradata.
- Used VB to create table for client to validate source data.
- Streamlined technical solutions, which included writing script, to provide test data that conforms to oversite agencies auditing standards.
- Lead SAS admin for the project team. Was responsible for creating and maintaining access to SAS development server on the UNIX platform.
- Worked with client SAS administrator to build out SAS platform. Worked with client to trouble shoot bottlenecks and performance issues.
- Provided daily SAS administration role for the client on the SAS 9.2 EBI AIX Platform
Environment: MS Project, SAS Base, SAS GRAPH, SAS BI, SAS DI Studio, SAS Enterprise Miner, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Columbus, OH
SAS Programmer/Developer
Responsibilities:
- Provided SAS Analytics for the Corporate Internet Group
- Provided clients data from various databases that was requested for back end validation.
- Collected source data from DB2, IMS, Oracle, Teradata and SQL data bases.
- Worked with project team to create output needed to complete tasks.
- Verified data sent from business group is accurate.
- Used raw data as input to the reporting system to populate Report databases.
- Extracted data from source systems, then transformed it, by validating, cleansing and filtering it using SAS code as the principle process.
- Reviewed Technical documents and verified accuracy.
- Streamlined technical solutions, which included writing script, to provide test data that conforms to oversite agencies auditing standards.
Environment: MS Project, SAS Base, SAS GRAPH, SAS BI, SAS DI Studio, SAS Web Report Studio, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential, Chandler, AZ
SAS Programmer/Developer
Responsibilities:
- Provided SAS expertise for the integration of various business systems
- Provided clients technical guidance in delivering raw data to security group for integration of business system into the ACT system.
- Developed process for identifying, gathering, testing and finally implementing security data for inclusion into new certification process, which was implemented Enterprise wide.
- Verified data sent from business group is clean and is acceptable to the ACT system.
- Used raw data as input to the ACT system to populate ACT databases.
- Reviewed business system data once it has been loaded to test platform and communicate changes needed to raw data to business partners.
- Implemented several new data sources into the ACT system by partnering with business units to analyze current data structures, define data elements required for ACT, identify and communicate data structure conversion/enhancement opportunities, assist business units with data conversion techniques, and assist and educate business units on data delivery method requirements.
- Extracted data from source systems, then transformed it, by validating, cleansing and filtering it using SAS code as the principle process. Load transformed data to the Access Certification Tool (ACT) Project database.
- Reviewed Technical documents and verified accuracy.
- Streamlined technical solutions, which included writing script, to provide test data that conforms to oversite agencies auditing standards.
- Granted or terminated access to clients data from properly documented users.
- Assisted with live load of changes to ACT system.
- Provided clients performance tuning analysis, to ensure optimal utilization for architecture.
- Responsible for system analysis of the DC of the California DTS.
- Provided inventory by attaining information, through data gathering techniques.
Environment: MS Project, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptingVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA 1, 7, and 11, REXX, CLIST, CICS, SQL, C+
Confidential, Charlotte, NC
Applications Programmer
Responsibilities:
- Took over lead analyst/manager duties of the Credit Card Analyst and assumed all responsibilities.
- Lead tech of the Credit Card Division for the merger of MBNA credit card customers.
- Responsibilities included identifying requirements, training and support for a seamless conversion.
- Establish process to gather requirements and develop procedures to maximize resources, at hand.
- Worked with Data Processing to make changes to data flow, which streamlined update process.
- Extracted data from diverse files(RDBMS), transformed data using SAS Enterprise, UNIX scripts and SQL then loaded 'cleansed' data to dashboard (COGNOS) and other files(DB2 and Oracle).
- Lead programmer for upgrade of STRATA decision engine from 3.0 to 4.0 on the server.
- Gathered, cleansed and analyzed raw data using SAS Enterprise Miner Guide.
- Worked with designated collection of fraud and risk management peers to create, design, test and implement score models to reduce or eliminate losses in those areas.
- Ran raw data thru SAS Forecast and SAS/STAT, produced graphs and charts, which were forwarded to forecasters and modelers to help them create strategies to reach the company business objectives.
- Worked in early stage development of IT CAM for Confidential .
- Used SAS Base, SAS Graph, SAS Report and MS Access to determine validity of decisions made by STRATA and the data that was gathered using SAS and MXG
- Backfilled SAS Administrator position for the Credit Card Group.
- Installed SAS components of the Management Console, Data Integration, Data Mining, Forecasting, Statistics and Data Model Management. Also installed Web Studio Report.
- Responsible for user access, File/Data security, performance analysis and tuning, SAS ds management and applying patches and upgrades.
- Continued to use the ITIL methodology when implementing process changes to the credit card group.
Environment: MS Project, SAS Base, SAS GRAPH, SAS Enterprise Miner, SAS Macros, MS Access, SAS Procs, Oracle, Cognos, STRATA, MXG, Six Sigma, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, IMS, shell scripts, VTS, MS Office, SQL, C+, SAS/STAT, SAS/GRAPH, SAS Enterprise Miner, SAS Enterprise Guide, Management Console, Data Integration, Web Report Studio, Forecasting, Data Model Manager
Confidential - Charlotte, NC
Applications Programmer
Responsibilities:
- Lead programmer for upgrade of STRATA decision engine from 3.0 to 4.0 on the server.
- Served as SAS Administrator for the Credit Card Group. Was responsible for security, maintenance and tuning.
- Ran raw data thru SAS Forecast and SAS/STAT, produced graphs and charts, which were forwarded to forecasters and modelers to help them create strategies to reach the company business objectives.
- Documented STRATA 4.0 using software company supplied template.
- Used SAS Base, SAS Graph, SAS Report, UNIX scripts and MS Access to determine validity of decisions made by STRATA and the data that was gathered using SAS and MXG
- Worked with the IT department to bring ITIL philosophy to Confidential credit card group.
Environment: MS Project, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs, Oracle, Cognos, STRATA, MXG, Six Sigma, ITIL, SDLC, JCL, JES2, TMS, z/OS, TSO, DFSMShsm, DB2, IBM Utilities, VTS, MS Office, SQL, C+, UNIX scripts, SAS/STAT, SAS/GRAPH, SAS Enterprise Minor, SAS Enterprise Guide
Confidential - Orlando, FL
TSM Administrator
Responsibilities:
- Determined if backups are being utilized effectively, and are there any functions that will improve the overall process that are not being utilized now
- Determined if there are any reporting methods of the product that will report on the utilization or processing that will aid customer.
- Reviewed the current Oracle, SQL and DB2 backups in Tivoli and determine if there are adequate backup processes in place, to meet the objectives of the customer.
Environment: MS Project, SAS, Oracle, UNIX, ITIL, SDLC, JCL, AIX, TMS, Tivoli Storage Manager, DB2, IBM Utilities, SQL, C+, shell scripts
Confidential - Memphis, TN
System/Storage Manager
Responsibilities:
- Responsible for determining criteria for the Storage Management System
- Provided Level 2 support for storage problem tickets for z/900 production and system using BMC problem reporting software (Patrol).
- Participated in Disaster Recovery tests, by providing hands on knowledge of SNAPSHOT and PPRC.
- Provided support for the systems environments, using SAS Proc Tabulate, SAS Proc Print, SAS Macros, UNIX shell scripts and SAS Graph to gather information and create listings. Worked with Systems Support Division (SSD) programmers in systems monitoring, tuning, analysis and problem determination as required.
Environment: MS Project, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs Oracle, MXG, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scriptsVTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+
Confidential - Phoenix, AZ
System/Storage Manager
Responsibilities:
- Supervised the Tape Management group, which consisted of the tape librarians and tape operators that had the responsibility of combining TLMS into TMS.
- Responsible for putting in Tape management guidelines system wide.
- Assisted with the installation and configuration for the TSM servers in the Data Center environment.
- Participated in DR tests using PPRC and SDRF.
- Attended planning sessions with other team members, which was facilitated by the Project Manager.
- Responsible for the documentation to be used by the technical staff.
Environment: MS Project, Oracle, ITIL, SDLC, JCL, AIX, TMS, Tivoli Storage Manager, DB2, IBM Utilities, SQL, C+, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs, MXG
Confidential - Memphis, TN
Storage Manager Specialist
Responsibilities:
- Determined file organization, indexing methods and security procedures for the system databases.
- Maintained SAS Procs developed by client and created or updated those SAS Macros, where needed.
- Responsible for determining criteria for the Storage Management System.
- Provided information, using shell scripts, needed to determine Disaster Recovery needs and procedures.
- Trained the technical staff in operational and workflow procedures.
Environment: MS Project, Oracle, Cognos, ITIL, SDLC, JCL, JES2, TMS, z/OS, UNIX, TSO, DFSMShsm, DB2, IBM Utilities, shell scripts, VTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, CAM, Novell, Windows NT, SNAPSHOT, PPRC, Virtual Tape, TDMF, Integrated Catalog Facility, Storage Area Network, DFP, RACF, CA-DISK, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs
Confidential, Charlotte, NC
Offshift Senior Staff Specialist
Responsibilities:
- Responsible for ensuring backups, applied updates to production data, and system tuning issues, were completed/resolved in a timely manner.
- Also functioned as a DBA for Oracle and DB2 during the off shift hours. Those duties included troubleshooting and installation.
- Develop reports for use by HR department.
- Continued to develop and maintain SAS programs, which included SAS Macros, SAS Reports shell scripts and MS Access for internal and external users.
- Primarily corrected errors that were encountered, possibly because of bad raw data.
- Provided support for PC and LAN projects in the area of connectivity to the mainframe.
Environment: MS Project, Oracle, SDLC, JCL, JES2, TMS, TSO, ESP, DFSMShsm, DB2, shell scripts, IBM Utilities, VTS, Connect: Direct, MS Office, Excel, Lotus Notes, Change Management, PowerPoint, Remedy, AIX, IXFP, Novell, Windows NT, Virtual Tape, Integrated Catalog Facility, Storage Area Network, DFP, RACF, BMC Control Products, CA1, 7 and 11, REXX, CLIST, CICS, SQL, C+, SAS Base, SAS GRAPH, SAS Macros, MS Access, SAS Procs