Sas Programmer Resume
Germantown, MD
SUMMARY
- SAS Certified Professional wif more TEMPthan 20 years experience in the Research & Analysis/SAS arena, and 2.5 years administering the SAS environment. Specifically has served as senior SAS programmer and has acquired proficiency in SAS programming, IBM Mainframe MVS/TSO, JCL,programming wif FORTRAN
- SAS certified: SAS Intitutes courses in SAS base, SAS/AF, SAS/FSP, SAS/Macro, SAS/Graph
- Currently leaning SPSS
- Ability to perform and deliver under very demanding situations, experience in translating complex business requirements into technical specifications. Attention to detail and a sense of ownership for deliverables
- Lead IT - team + SAS user groups as administrator, instructor, supporter etc.
- Latest Tools for Office Automation, Communication and business analysis: Access, Excel, Internet, e-mail, Outlook Express, Power Point, Windows, etc SAS, SAS/AF, SAS/ASSIST, SAS/CONNECT, SAS/ETS, SAS/FSP, SAS/GRAPH, SAS/Macro SAS/Genetics, SAS BI, SAS Architect, SAS Forecast Server, SAS/STAT products, SAS/OR, SAS/QC, SAS/STAT, DB2, SQL, VSAM, COBOL, Info One
- Strong BASE SAS programming experience
- Experience in ODS (to Excel)
- UNIX Platform
- Data Manipulation experience
- Excellent communication skills and the ability come up to speed on the project quickly
- Provided first line helpdesk support assisting wif hardware and software problems via phone, email, fax or visit
- Responsible from for maintaining a high degree of Customer Service
- Conducted a one-month-long SAS Workshop via United Nations at a top University
- Resulted afterwards in implimentation of SAS software to save time and millions of dollars for the University annually
- Trained personnel and customers of a big Swedish company wif SAS software
- Helped them to integrate their all system wif SAS
- The company saved millions of dollars every year
TECHNICAL SKILLS
Languages/Software: FORTRAN, SAS, SAS/Graph, SAS/QC, BASIC, PL/I, ASSEMBLER, COBOL, DL/I, ECDL (European
Computer Driving Licence: a microsoft office package), HTML, C + + Experience in IBM mainframe architecture TSO, JCL in an MVS environment, and UNIX / LINUX, AIX and Java
Hardware used: IBM 309x, IBM 303x, IBM 43xx. IBM 370, IBM 360, IBM-PC, PS/2, Apple, Macintosh, Dell, HP and Siemens
Applications: MS-Word, Word Perfect, Access, Excel, Power Point, e-mail, Internet
Operating Systems: MVS/ISPF, TSO, VM/CMS, ISPF, WINDOWS, MS-DOS, JCL, OS, Main Frame, PC and network
Other Experience: Purchase and installation of PC's hardware and software
PROFESSIONAL EXPERIENCE
Confidential, Germantown, MD
SAS ProgrammerResponsibilities:
- Involved on monthly production release work
- Extensive usage of Base/ SAS, SAS/ Macros and SAS/ Graph
- Generate Graphs and Charts using SAS/Graph and Reports using SAS/SQL
- Used PROC Tabulate and PROC Report to standardize the reporting programs into macros
- Analyzing the data based on the requirement
- Process data collection to ensure proper quality of data
- To extract the data from data warehouse and create SAS data sets
- Generate Ad-hoc listings, reports & Graphs
- Creating Summary Reports and Tabular Reports using Proc Report
- Automation of Weekly Flash Report and Monthly Report
- Generate Graphs and Charts using SAS/Graph and Reports using SAS/SQL
- Code review and modified as of requirement
- Created and maintained SAS Datasets dat are extracted from Oracle Database
- Tracked and documented problems/bugs and fixed. Retested as required
- Prepare thorough Technical Documentation for each SAS program
- Responsible in preparing monthly release documents like peer code review, unit test case documents, release tracker
- Coordinate wif the offshore team on regular basis, and used to check the status of the work
- Monitor the logs regularly in production if any data issues
Environment: Hardware: IBM 3090, IBM PC’s, Client Server DEC Alpha, UNIX Databases: SAS 9.2, Oracle 7.3 & 8i, DB2, IMS, Oracle Data Warehouse, Oracle Clinical
Confidential
SAS Programmer (Consultant)
Responsibilities:
- Developed appropriate data in collaboration wif resident statistician and field experts and perform preliminaryanalyses toward an algorithm for targeting newly-arrived shipments of goods fortheir potential to violate: Intellectual Property Right Law
- Maintained the SAS programming central to thecustom system to evaluate the performance of importers in complying wiftheimport laws
- By integrating data from across the corporate, I delivered self-service reporting and analysis
- This was easily achieved by SAS BI, EG, EBI, as it gave all the pertinent data. My customers needed it in the format as required
- Helped users wif SAS Business Intelligence as it is integrated, robust and flexible to presentation of Analytics capabilities, including: Statistics, predictive analytics, data and text mining, forecasting, and optimization - all integration wifin the business for better, faster decision making
- This resulted in saving lot of time and money for the corporation. SAS v9, SAS BI, SAS Forecast Server, Web Report Studio (WRS), InfoOne - CHL data depository systems other IT tools used
- Prepared, processed and analyzed clinical data required for analysis of clinical trials for phase 1 studies wif SAS programming
- Data was collected in CRF and sent us to raw data
- Software upgrades, patches and maintenance for improving performance
- Assumed Administrator role by providing help-desk support
- Did SAS Applications issues troubleshooting and provided solutions to all technical issues
- Performed/insured proper backups of metadata and business data
- Designed, implementing and maintaining security on SAS metadata
- Designed, implementing and executing the change control and promotions tasks in SAS
- Developed and implement information delivery solutions in SAS to support Business Intelligence
- Interacted wif data management team to understand the data and clarified the queries
- Extracted and maintained SAS data sets from the raw data created by the data management group
- PROC SUMMARY, PROC MEANS, PROC TABULATE is used for report generation
- Used PROC SQL for querying and reporting
- Provided SAS programming and statistical support to the clinical studies
- Assisted in validation, edit checks and data review listing
- Created summary reports and tabular reports using proc report
- Generated SAS graphs and listings as per the SAP
- Used LO INC (logical identifier names and codes) and SNOMEO (systemized nomenclature of human Veterinarian medicine) coding schemes to standardize test names and results wif HL7 standards
- Prepared safety reports according to the protocol
Confidential
SAS and IT Admin
Responsibilities:
- Performed installations on PC and on Solaris server
- Troubleshoot users’ issues using SAS
- Lead the Users’ Technical Committee
- Advise SAS Managers on technical and contractissues
- Lead testing of new SAS products and of SAS’s interactions wif othernew products such as: Operating System versions
- Assist LAN Support in equippingtraining rooms wif appropriate SAS software
- Lead the in-house SAS Users Group
- As a Contracting SAS Programmer to a medical-care research firm, developed analytical files from databanks about health-insuranceclaims
- SAS Admin and Support was part of it
- Worked wif investigators to perform studies of economicimpact/burden of several illnesses and types of medications
- Databanks reside onRe-mote UNIX server accessed via SAS Connect v8.SAS v9
- In addition: Health care problems in close coordination wif the clients to solve the problems for their complete satisfaction by SAS on mainframe computers for large datasets and PC-SAS for small datasets
- Experienced using Mainframe toolsets and utilities (i.e., ISPF, JCL, CAJobtrac)
- Developed appropriate data in collaboration wif resident statistician and field experts and perform preliminaryanalysis toward an algorithm for targeting newly-arrived shipments of goods fortheir potential to violate: Intellectual Property RightsLaw
- Maintain the SAS programming central to theCustoms system to evaluate the performance of importers in complying wiftheimport laws. (SAS v6 and v8)
Confidential
SAS Programmer
Responsibilities:
- Radically reconstructed a Mainframe SASapplication to allow Import Specialists wif the Customs Service to targetincoming shipments of goods for further scrutiny based on an unusual declaredunit price of the goods
- Worked closely wif the resident statistician, design the selection algorithmtaking into account the varying and complex shapes of the distributions of themany types of imported goods
- Redesigned user screens and programming wif SAS/AFand SAS/FSP
- Rebuilt daily, weekly, quarterly, and occasional batch routinesfor ease of subsequent maintenance (SAS v6)