We provide IT Staff Augmentation Services!

Senior Systems Engineer/sas Admin Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • SAS administration at Confidential and Dell, on Unix System.
  • Five years in campaign tracking, analytics and identifies appropriate customer.
  • Five years in SAS Enterprise guide(SAS EG).
  • Reporting and ETL process. Five years in BI with SAS analysis.
  • Five years in pharmaceutical companies doing Clinical Trials.
  • Ten years in Microsoft Project, Microsoft Office, Microsoft Outlook and Microsoft SQL Server 2005 and 2008.
  • SAS experience on thirteen years on Mainframe and ten years on UNIX. License in stocks, funds and bonds at World Financial Group. Manager for four years at Employer Insurance in SAS Reports, SAS Statistics and Modeling.
  • Major SAS and ETL process was to write a procedure that compile in SAS for to help Wells Fargo.
  • Major SQL to write macros for select, where and group in automation for monthly reports in CRON.
  • Major business is to win an for outstanding employee services for helping business to acquire a million dollar client. Report development using Business Objects Web Intelligence platform with OLAP. Scorecard performance reporting.
  • Experience as a BI development for five years. UNIX SAS programmer with extensive experience developing ETL scripts for building, loading, appending and updating Oracle tables in versions 10g and 11g. Experience programming in SAS on UNIX and in Oracle SQL.
  • QA Supervisor, problem solver with the ability to encourage others in collaborative problem solving. Reviews of business requirements and functional specification of the software to the test specification of desire results. Programs went through cycles, using software development methodology such as Second Edition “Managing a Programming Project” by Philip W. Metzger. Strong SAS Macro with all development.
  • Five years had experience in Data Miner and Enterprise Miner. Two years in SAS Data Integration Studio 4.2. Administrator help desk for Confidential, Wells Fargo and Dell. SAS load utility (MDI).
  • Five years in ETL process to load, and deliver data as part of the Extract - Transform-Load (ETL) process to a development data mart or data warehouse.Used SAS Keyword File with file for stating and put statements of the fields. SQL Server 2008, using SQL and SSIS.
  • Seven years in Oracle and TERADATA. Ten years in PC and UNIX with SAS.
  • Thirteen years of experience with SAS, SAS Connect and SAS MPConnect to Server and DB2 as a programmer on a Mainframe and JCL and COBOL.
  • Eight years of SAS, SAS Connect, SAS MPConnect and DB2 in an AIX UNIX environment. Campaigns and branding experience at Confidential, Confidential and Confidential .
  • Six years in Clinical Trials in Eye, Cancer, Depression medicines.
  • Two years in MetaData.
  • Additional Background includes SQL, SPSS, JAVA, HTML, BASE SAS, SAS/STAT, SAS, SAS Macros, SCL, SAS FSP, ETS, IML, ETL, EPIC/DYNAM/D, SAS Data Warehouse, Microsoft SQL Server 2000, PL/SQL, SQL, SAS9 Data Warehousing, Business Intelligence, Data Integration Studio, Information Map Studio, SAS Management Console Microsoft Office, OLAP Cubes, SAS /ODS. Two years in Crystal Enterprise.
  • Five+ years working with TERADATA, DB2, Oracle, Shell Scripts, MS Excel, VBA and MS Access.
  • Extensive background working as a liaison between customers and clients.
  • Acted as a project lead responsible for designing specifications and projecting costs.
  • Ten years in Teradata.

TECHNICAL SKILLS:

HARDWARE, SOFTWARE AND O/S: SHELL SCRIPTS VISUAL BASIC SAS SAS/MACRO SAS/SQL ETLSAS/STAT SAS/AF FSP SCL SAS/GRAPH SAS/EIS/MDDB SAS/SHAREETS ETL IML VBA SAS / WAREHOUSE SAS ODS DB2 SAS CHANGEMANUNIX DISPLAY MANAGER ORACLE ACCESS SQL, ORACLE/SQL, PL/SQL, SYNCSORT, PINNACLE CLI

MICROSOFT SERVER: 2005 MICROSOFT SERVER 2003 SAS 9 BI M204 MICROSOFT PROJECT

PROFESSIONAL EXPERIENCE:

Confidential

Senior Systems Engineer/SAS Admin

Responsibilities:

  • Developed SAS 9.2 code on UNIX and PC in Medical billing code
  • Developed COBOL on Mainframe.
  • Develop systems and enhancements for commodities market Value at Risk.
  • Microsoft SQL Server 2010 for SQL program
  • All work was done in remote. Contractor to develop systems in COBOL and SAS.
  • Maintain Production jobs and used SDM documentation.

Environment: UNIX, Mainframe, ETL, SAS, DB2, SQL Server

Confidential, Plano, TX

SR. Data/SAS Developer

Responsibilities:

  • At Confidential, developed SAS 9.2 code on UNIX and PC in Marketing Department.
  • Used SAS Enterprise Guide.
  • Develop systems and enhancements for commodities market Value at Risk.
  • Microsoft SQL Server 2010 for SQL program.
  • SAS programming and SAS EG. Use Linus OS and solid understanding data conversion.
  • Mainframe and UNIX was used for coding. Strong ETL for DB2 upload.
  • Used Control-M For WorkLoad Automation in Mainframe.
  • ISPF, JCL and File aid on Mainframe.
  • All work was done in remote.

Environment: UNIX, ETL, SAS, Java, DB2, SQL Server, Linus OS

Confidential, San Antonio, TX

App Developer Senior

Responsibilities:

  • Microsoft SQL Server 2008 for SQL programs. SAS 9.2 Macros in Java Script. Using the SAS/Internet on the server to produce web pages for twenty applications for Randolph Air Force Base. Speed of SAS 9 and learning the Air Force terms is complex.
  • Analysis, designing and implementation of large projects. System, programming and testing of solution.
  • Microsoft SQL Server 2008 for SQL programs.
  • Assist project team to resolve any kind of technical issues raised during design.

Environment: Mainframe, ETL, SAS, SQL server

Confidential, Irving, TX

SAS/SAS Admin

Responsibilities:

  • BI development for analysis, designing and implementation of large projects. System, programming and testing of solution.
  • Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
  • Microsoft SQL Server 2008 for SQL program.
  • SAS Data Integration Studio 4.21. Experience in SPD Server for table
  • Develop pro SAS/ Developed Macros, SAS/Connect, SAS/Base, SAS Enterprise 4, Microsoft Visio, MetaData, ETL, SAS Business Intelligence, Shell Scripts, SQL and Java Scripts on UNIX. SAS Enterprise on PC and connected to different Unix Server, Oracle and Teradata.
  • Upload SAS tables to DB2 tables and worked with toad with Sequel to do changing the DB2 tables.
  • Reports were done on Microsoft SQL Server for analyses. SQL Server 2008, using SQL and SSIS.
  • Automated SAS applications to CRON and used Shell Script,
  • Sequel and SAS RSUBMIT for getting files from other servers.
  • All work was done in remote.

Environment: UNIX, Mainframe, ETL, SAS, DB2, SQL Server

Confidential

SAS Lead Consultant

Responsibilities:

  • Code in SAS/ Developed Macros, SAS Enterprise Guide, SAS/Connect, SAS MP Connect, SAS/Base, SAS Enterprise 4, Microsoft Visio, Meta Data, ETL, SAS Business Intelligence, Shell Scripts, SQL and Java Scripts on UNIX. SAS Enterprise on PC and connected to different Unix Server, Oracle and Teradata.
  • Upload SAS tables to DB2 tables and worked with toad with Sequel to do changing the DB2 tables.
  • Reports were done on Microsoft SQL Server for analyses. SQL Server 2008, using SQL and SSIS.
  • Automated SAS applications to CRON and used Shell Script,
  • Sequel and SAS RSUBMIT for getting files from other servers.
  • ETL to Data Marts and Warehouse. File with put statements for ETL. Version 9.2 for SAS.
  • SAS Data Integration Studio 4.21. Importing, Exporting, and Copying Metadata. Exporting SAS package Metadata. Importing new Metadata with a SAS Metadata Bridge.
  • Administrator and help desk for SAS. Used SAS Macros in all development.

Environment: UNIX, Mainframe, ETL, SAS, DB2, SQL Server

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

  • At Confidential, developed SAS code on UNIX and PC in Marketing Department.
  • Develop systems and enhancements for commodities market Value at Risk.
  • Microsoft SQL Server 2008 for SQL program.
  • SAS Data Integration Studio 4.21. Experience in SPD Server for table
  • Used SAS Macros, Data Warehousing, Business Intelligence, and ODS, Studio and ETL.
  • Finance Company roll over smaller 401K accounts to a bigger account with active Mangers, like Fox Hall. ETL to SAS Data Warehouse. SQL Server 2008, using SQL and SSIS.
  • Reports on companies like Fox Hall and the performance.
  • ETL to Data Marts and Warehouse. SAS Data Integration Studio 4.21. Importing, Exporting, and Copying Metadata. Exporting SAS package Metadata. Importing new Metadata with a SAS Metadata Bridge. Used SAS Marcos for all development.

Confidential, Plano, TX

SAS Admin /SAS Lead Consultant

Responsibilities:

  • Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
  • Responsible for Brand Merchandising Analysis in JTEST written in SAS with SAS Macros. System was on UNIX and & LET statements produce an Excel Table by ODS.
  • FTP up to the PC and give report to the BDM clients at Confidential . SQL Server 2008, using SQL.
  • System is not perfect, so I had to produce SQL and SAS program to duplicate reports.
  • SAS Administrator for SAS/AF.
  • Wrote SAS/AF with SCL on version 9.1 for customer transactions with SAS Macros inside SCL. ODBC for regular SQL and SAS SIGNON to remote server to create a table inside SQL.
  • Used SAS ODS to export files to Excel.
  • Developed formulas in work sheets to have the results what the client expects in Microsoft Excel.
  • Administrator and help desk for SAS.
  • SAS Data Integration studio 4.21. Experience in SPD Server for table
  • Developed Icon for SAS/AF and conducted testing in PC SAS.
  • Helped People on Mainframe for DB2 questions on it.
  • Mainframe and JCL, VSAM and SAS with SAS Macros.
  • JAVA and HTML for the web.
  • Modifications on JCP.COM.
  • SAS Expert for Help Desk and Administrator functions. SAS load Utility (MDI).
  • Duties included Enterprise Miner, Data Miner on servers for SAS.
  • Installed 9.3 with Console.
  • Installed Enterprise Miner latest version in version 9.
  • Communicated with SAS institute for update core of SAS on expiration date.
  • Designed and developed extracts for BHI warehouse and wrote documents for support.
  • Used T-SQL, SQL queries and Unix Scripting in TERADATA, Oracle, JAVA and HTML for the web.
  • CITRIX Server for SAS applications.
  • Web for the Help Desk modifications.
  • ETL to Data Marts and Warehouse.
  • Sequel and SQL for Microsoft Server 2005.

Environment: UNIX, Mainframe, ETL, SAS, DB2, T-SQL, SQL Server, Enterprise Miner

Confidential, Austin, TX

SAS Lead Consultant

Responsibilities:

  • Moving files from Test to Production.
  • Designed Test system with SAS, SAS Macros, Meta Data, Oracle SQL, Oracle, AIX/Unix and Unix Shell Scripts.
  • Used Microsoft SQL Server 2000 for SQL.
  • Produced SAS Graphs for Engineers.
  • Documented the Processes of the System.
  • Downloaded SAS files to Microsoft Excel.
  • Responsible for SAS Data Warehouse from different files in Test and Production.
  • Designed and developed extracts for BHI warehouse and wrote documents for support. Installed 9.3 versions of SAS. Used SQL queries in Oracle and Unix Scripting. Java and HTML for the Engineer to changed the Data Warehouse through the Web.
  • Sequel and SQL for Microsoft Server 2005.

Confidential, Irving, TX

SAS Lead Consultant

Responsibilities:

  • Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
  • Responsible for Analytics, Microsoft Server Query Analyzer, PC SAS, and SAS Enterprise Guide 3.0. SQL Inner and Outer Joins.
  • SAS and SAS Macros to produce reports.

Environment: UNIX, ETL, Metadata, Enterprise Miner, Enterprise Guide and Data Miner

Confidential, Irving, TX

SAS/Crystal Consultant

Responsibilities:

  • Responsible for Crystal Reporting, SAS, Excel, SQL and TCL for Oracle.
  • Used SQL queries and Unix Scripting in TERADATA.
  • Large scale loan and lease in Accounting.
  • Moved Crystal reports to CITRIX Server for people in accounting to login to get reports.
  • Sequel and SQL for Microsoft Server 2003.

Environment: UNIX, SAS, ETL, Enterprise Guide and Microsoft Office.

Confidential

SAS Consultant

Responsibilities:

  • Responsible for SAS, PL/1, M204 and SQL Queries.
  • SAS in REMEDY 4 and 7, M204 and PL/1 software for reporting for Clients at Television Stations for ratings.
  • The environment is VM (CMS), TSO and MVS JCL and Microsoft VISUAL BASIC.
  • Used Remedy software for work on solving tickets.
  • Used SQL queries and Unix Scripting.
  • SQL in TERADATA and DB2.
  • SAS, COBOL, JCL on the Mainframe. de behind Frame in Version 6 and update SCL code to in a SAS/AF v.8.2 environment, macro code, OLAP Cubes, Metadata Cubes, ETL, SAS SQL and SAS/EIS/MDDB.
  • Worked FSP for data entry.
  • UNIX and PC SAS environment and used basic SAS procedures such as Means, SQL and Summary.
  • Handled large database more that ten million records.
  • Created METADATA files on UNIX with CRON to automate daily processes for the SCL code to retrieve the data and put the information on Frame by the SCL code.
  • Used SQL queries and Unix Scripting.

Environment: Metadata, UNIX, Mainframe, Microsoft Office.

Confidential, Indianapolis, IN

SAS Consultant

Responsibilities:

  • Responsible for Statistical programming from SAS/STAT PROCS and Base SAS for producing SOP.
  • Analyses, tabulations, graphics, tables and listings from Clinical Trial data.
  • Data aggregation for producing studies in a common SAS data set.
  • Data Modeling.
  • Worked SAS Clinical Trials Phase I-IV through several studies.
  • Provided analysis plans and test plans to test required code, displays, and statistical reports. Perform quality assurance procedures on work by others.
  • Experience with ICH guidelines and Electronic Submission standards for the FDA.
  • Transfer Adverse Event files on UNIX to Oracle tables.
  • Worked in SAS v8.1 on SAS PC Windows.
  • Used SQL queries and Unix Scripting.

Environment: UNIX and Microsoft Office.

Confidential, Irving, TX

SAS Consultant

Responsibilities:

  • Responsibilities include writing SAS MACRO CODE, SCL to read and create METADATA files on UNIX.
  • Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns. Additionally, pull
  • INTERNET. The development environment consists of SAS/AF, SAS/FSP, ADABAS, Natural, JCL, BETQ, GQL, Oracle, SAS/EIS, SAS/MDDB, SAS ENTERPRISE, SAS DISPLAY MANAGER, SAS MINER, and SAS/CONNECT, MS Excel, COBOL, OLAP, ETL and DB2.
  • Used SQL queries and Unix Scripting.

Environment: OLAP Cubes, ETL, Metadata, Mainframe, UNIX and Microsoft Office.

Confidential, Indianapolis, IN

SAS Consultant

Responsibilities:

  • Responsible for writing SAS programs with SAS macro code and Statistical programming for SOP. Analyses, tabulations, graphics and listings from Clinical Trials data.
  • Generate table listings for the different drugs and Adverse Events.

Confidential, Irving, TX

SAS Consultant

Responsibilities:

  • Responsible for Clinical Trials in Eye type reports.
  • Putting together patient files for a doctor in Phase I.
  • Used SQL queries.

Environment: UNIX and Microsoft Office.

We'd love your feedback!