We provide IT Staff Augmentation Services!

Sr Sas Programmer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Over 6 years of extensive experience in SAS programming on different platforms - Windows and UNIX.
  • Strong experience in Base SAS, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/CDI and SAS/SQL in Windows.
  • Experience in working with SAS on different platforms like UNIX (AIX, HP/UX, SunOS), and Windows 9x/2K/NT/XP.
  • Experience in BI Suite in SAS including SAS Enterprise guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
  • Have strong working knowledge on Anti money laundering.
  • Well experienced in claims loading process into data warehouse and solving the issues with accuracy .
  • Have experience in different databases like Oracle, SQL Server, DB2, MySql and Teradata.
  • Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse
  • Used BAS SAS procedures like FREQ, SQL, PROC SORT and MEANS to validate current results with expected results.
  • Good at migrating SAS datasets and SAS applications from Unix
  • In Depth Knowledge of SAS programming, data Processing, data collection, quantitative and qualitative data analysis. Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results.
  • Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
  • Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank.
  • Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
  • Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
  • Experience with database manipulation (ETL) and SQL programming and reporting.
  • Strong skills in requirements gathering, analysis and ETL design, coding, debugging
  • Experience with predictive modeling, business analysis, statistical modeling, multi-variate statistics and logistic regression.
  • Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Resourceful, able to find solutions when faced with challenges.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9.3/9.2/9.1.3 /8.2/8.1/6 (mainframe), SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS GraphSAS Enterprise, SAS Business Intelligence (BI) platform and SAS EBI, dash boarding using SAS Visual Analytics.

Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise, SAS GRAPH, AXUM, MS-EXCEL, SAS BI Platform, SAS OLAP

Cube Studio, SAS Web Report Studio, MS-Visio, MS-PowerPoint

RDBMS: SAS/SQL,SAS/Enterprise, SAS BI Platform, DB2, MS-Access, Microsoft SQL Server, MySQL, Teradata, Oracle.

Languages: SAS, SQL, HTML.

Operating System: Windows 95/98/XP/Vista/Win 7/8, UNIX, MAC OS, DOS.

Batch Server: UNIX, Putty, SSH, SAS scripting.

Web Server: MS-FrontPage, HTML, Linux, Apache Server.

PROFESSIONAL EXPERIENCE:

Confidential

Sr SAS Programmer

Responsibilities:

  • Performed ETL on Oracle databases to extract and prepare data for analysis and reporting.
  • Data processing and validations were done on the SAS datasets using edit check programs.
  • Worked in SAS PC for design, development and operations.
  • Perform data analysis, datamigration, data preparation, graphical presentation, Statistical analysis, reporting, validation and documentation.
  • Developed and maintained the SAS code for Predictive Models.
  • Involved in standardizing reporting procedures for graphical and tabular reports.
  • Used advanced SAS tools to automate the reporting systems to generate daily and monthly reports.
  • Used SAS Procedures to generate Ad-hoc reports such as renewal policy count reports by state, agent commission report by agent type based on clients requirements
  • Involved in migration process from PC SAS to SAS grid in my team and implemented and created up grading plans.
  • Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the Web.
  • Analyzed Data, Created new Datasets and Prepared Reports.
  • Developed and maintained the SAS code for other predictive models.
  • Used procedures like PROC FREQ, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report.

Environment: Windows XP, SAS 9.3, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, Oracle, DB2, Web, SAS/GRAPH, SAS/CONNECT, SAS/SQL, SAS/Enterprise Guide, UNIX, Autosys.

Confidential, Westlake, TX

Sr. SAS Programmer

Responsibilities:

  • Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
  • Developed, modified and generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.
  • Customizing and enhancing the existing ETL process.
  • Created financial mortgage data sets using Data steps and DATA NULL .
  • Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the existing source tables containing millions of records.
  • Executed the SAS jobs in batch mode through UNIX shell scripts.
  • Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
  • Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
  • Modifying existing datasets using techniques is done using SAS/Base and SQL.
  • Making the data ready for analysis using SAS/Stat procedures like Proc means, Proc freq, Proc univariate, proc report etc. Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
  • Created and delivered reports and presentations with key findings and recommendations.
  • Provided technical support on SAS programming related to data manipulation and analysis.
  • Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops.
  • Extracted data from different sources like Teradata, Excel files and text files using SAS/Access, SAS SQL procedures and Proc import functions.
  • Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/Excel XP to get the output in multisheets.
  • Developed and used scripts to schedule SAS Jobs.
  • Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.

Environment: SAS 9.3/4, SAS/Connect, SAS Macros, SAS/Access, Oracle 10g, SAS Web report Studio, SAS OLAP & EBI Server, HTML, SAS Enterprise Guide, Unix, SAS Stored Processes Web Application, SQL, DB2, Windows 7, MS Office and Teradata

Confidential

Sr. SAS Programmer/Analyst

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Created new or modify SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
  • Extensively used ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
  • Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
  • Was involved in benchmarked the effectiveness of AML data. Identified the potentials for performance improvement.
  • Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
  • Wrote SAS reports to Excel, the SAS content server, HTML, and PDF.
  • Wrote stored processes to be used through the SAS Information Delivery Portal
  • Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
  • Experience in converting programs from one version of SAS to another version. (Process of moving from SAS Version 8 to SAS Version 9).
  • Extensively used Proc SQL for highly advanced matching and merging between large datasets.
  • Frequent Use of functions and Proc Format.
  • Created reports in the style format using ODS statements and PROC Template.
  • Design SQL query to select, create, append, and update database tables and views.
  • Developed numerous ad-hoc SAS programs to create summaries and listings.
  • Created SAS Macros and SAS Graphics. Customize the existing programs using macros as per the statistician’s requirements
  • Generated SAS Customized reports using the DATA NULL and PROC Report techniques.
  • Coordinated transition of new reports to production from SIT and UAT
  • Identified and implemented process improvement and automation initiatives

Environment: SAS 9/9.2, SAS/Base, SAS/Graph, SAS/Stat, SAS/SQL, SAS/ODS, SAS Visual Analytics 6.2, Excel, Oracle 10g, Windows NT, SAS Enterprise Guide, SAS Web report Studio, SAS Information Portal, SAS Information Map Studio, OLAP and EBI Servers.

Confidential, Dorchester, MA

SAS Programmer

Responsibilities:

  • Created new macros and implemented them in SAS programs to produce the reports.
  • Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS Dbload procedure.
  • Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
  • Performed quality check and validation of data as well as Report.
  • Produced RTF, MS Word and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
  • Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
  • Managed the migration of the existing DW databases from DB2 and Sql Server to Greenplum (Big Data/Data appliance) by EMC Vendor
  • Developed SAS Macros for reduction of program length and for faster execution.
  • Combined and grouped datasets using concatenation and merging.
  • Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
  • Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
  • Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes.

Environment: SAS/ Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, DB2, MS Excel, SAS BI, Teradata and UNIX.

Confidential, St. Louis, MO

SAS Developer

Responsibilities:

  • Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
  • Wrote various queries using SAS/Base, SAS/SQL and SAS/MACRO for creating reports according to the Users requirement.
  • Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS Dbload procedure.
  • Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.
  • Transformations using Base SAS Procedures and Functions.
  • Migrated Main Frame JCL jobs into Unix Shell Scripting for running SAS nightly jobs.
  • Extensively used ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
  • Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup (Connected and Unconnected) to load the data.
  • Extensively involved in designing and developing of Star Schema Model for Data Store.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
  • Have knowledge about Informatica Sever tools - Informatica Repository Manager and Informatica Server Manager.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Informatica 6.1, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, Fast Export, BTEQ), XML, IBM AIX 5.3, Unix, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, SQL Server 2000, Mainframe, SunOS 5.8, DTS, Erwin, and Windows XP.

We'd love your feedback!