We provide IT Staff Augmentation Services!

Sas Programmer/ Analyst Resume

0/5 (Submit Your Rating)

Plano, TexaS

SUMMARY

  • Certified SAS Programmer with Eight plus years of experience in Market/Risk Analysis, Financial Analysis, and Health Care Data Analysis.
  • Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/Assist, SAS/Connect, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL and SAS/ODS.
  • Possess excellent skills in PROC SQL, SAS DDE, SAS Arrays, AS Base procedures, summary procedures and Data Step programming and reporting.
  • Expert in using PROC PRINT, PROC SUMMARY, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, SORT to generate Ad - hoc and customized reports.
  • Thorough hands-on experience in using SAS/ODS to generate different files including XML, RTF, MS Excel, PDF and HTML.
  • Strong background in statistical techniques such as Correlation and Regression including Multiple Regression, Logistic Regression, Multivariate Analysis, ANOVA and MANOVA, Cluster Analysis, Forecasting, Time series Analysis, Factor Analysis.
  • Experience in RDBMS development including SQL, PL/SQL.
  • Ability to execute number of projects simultaneously at ease and productive in highly stressed and fast paced environments.
  • Familiarity with statistical modeling techniques and data mining for CRM.
  • Expertise in data exploration and data mining in market research analysis.
  • Excellent experience in Internet and Intranet technologies like HTML, XML, CSS.
  • Strong UNIX and Shell Scripting skills using VI editor.
  • Highly motivated, Organized Team player with excellent analytical, communication and leadership skills.
  • Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
  • Proficient in writing JCL and running on MVS/TSO systems.
  • Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
  • Tested and debugged existing macros.
  • Used Tableau for analytics such as highlighting trends in data.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/BASE, SAS Enterprise Guide, SAS/MACRO, SAS/STAT, PC SAS, SAS/ACCESS, SAS ETL, SAS/GRAPH, SAS/InterNet

Programming Languages: C, C++, JAVA, J2EE, JSP, Servlets, PL/SQL, and SQL.

Web Technologies: XML, HTML, CSS, AJAX

Scripting Languages: JavaScript

Operating Systems: Windows 2003 Server, Windows NT/2000/XP, UNIX, Solaris.

Databases: Oracle, DB2, MS ACCESS, MS EXCEL.

PROFESSIONAL EXPERIENCE

Confidential, Plano, Texas

SAS Programmer/ Analyst

Responsibilities:

  • Project included running weekly and monthly reports using SAS, SAS/SQL, SAS MACRO and SAS GRAPH.
  • Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, and Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
  • Gathers customer data and performs back-end analysis for all marketing campaigns including direct mail, Tele marketing and other media.
  • Involved in implementing performance evaluation. This application creates the mailing list of consumers for Direct Mailing and Telemarketing offers, and measures the performance of those campaigns.
  • Analyzed response and sale results and write up monthly summary on campaign performance.
  • Programming of data listings using SAS. Converted MS-Word documents and Excel tables into SAS data sets.
  • Developed application for measuring financial performance of newly acquired accounts: Forecast Vs Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet
  • Involved in development and enhancements of SAS Programs.
  • Successfully generated permanent and temporary SAS datasets.
  • Involved in writing code using Base SAS & SAS/Macros to extract clean and validate data from oracle tables.
  • Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT.
  • Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc to develop solutions.
  • Successfully used Proc Means to calculate means, standard deviation, sum, median, etc of data
  • Generated graphs using SAS/GRAPH.
  • Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
  • Developed routine SAS macros to create tables, graphs and listings.
  • Developed SAS macros for data cleansing/Reporting and to support routing processing.
  • Created SAS MACROS and SAS GRAPHICS.
  • Used Proc REPORT to generate reports.

Environment: AS/SQL, SAS 9.0, SAS/MACROS, SAS/BASE, SAS/ODS, SAS/STAT, Oracle9i, SAS/GRAPH, SAS Access, Teradata, PROC Reports, UNIX.

Confidential, Edison, NJ

SAS Developer

Responsibilities:

  • Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs.
  • Used Proc Dbload, Proc SQL, Proc import, Proc export statements to load SAS data sets from and to DB2 and Oracle 9i.
  • Provide statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from client’s data.
  • Create Information MAPS using the Information Map Studio for Analytics and Business Forecasting Team for creating the Time Series Forecasting Models and also written SAS Stored Processes to Create Efficient Reports and delivering it in the Web Portals using the Information Delivery Portal and SAS Management Console.
  • Created edit check programs to find discrepancies in a raw dataset provided by Data Management Group.
  • Developed and scheduled SAS jobs using Shell Scripts / UNIX.
  • Used SAS Access to ORACLE feature for large data extractions (SQL-Pass thru).
  • Involved in various phases for segmentation and response analysis used for direct marketing campaigns.
  • Forecasted impact of direct market campaigns for acquiring, developing and retaining customers using SAS.
  • Developed and maintained SAS Web Reports for sales data based on the requirement.
  • Implemented data management plans designed to meet project deadlines.
  • Used SAS datasets as a source to Tableau for visualization of data.

Environment: SAS 9.1 (SAS/Access, SAS/Connect, SAS/Stat, SAS Enterprise Guide, SAS/Graph, SAS/SQL, SAS/ODS), Information Map Studio, SAS Web Report Studio, Oracle 9i, DB2, MS Excel, Solaris 8, K-Shell.

Confidential, DOVER, NH

SAS Analyst

Responsibilities:

  • Involved in Business Analysis and Systems Planning. Migration of data from text files and DB2 to SAS data sets.
  • Generated reports by submitting JCL and monitoring weekly, Daily and Monthly Jobs.
  • Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
  • Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display
  • Developed custom reports using Data Null and Dynamic Data Exchange (DDE) technique.
  • Connected to the different systems using SASNODE through FTP.
  • Developed an Automated Quality Control System for Data Validation and data integrity.
  • Used ODS statements and PROC TEMPLATE to create reports in style format.
  • Involved in various Testing phases (Unit, System and Integration).
  • Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
  • Used SAS Macros, PROC SQL to extract, sort; match test accounts and ODS to HTML, PDF and RTF.
  • Issue log maintained to track the Issues/Queries/Clarifications for each of the project.
  • Implementation of Quality System Procedures.

Environment: SAS (V8.2), SAS/BASE, SAS/SQL, MVS/TSO using JCL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, HTML, DB2, MS-Excel, UNIX.

Confidential, Strasburg, VA

SAS Data Analyst

Responsibilities:

  • Statistical Analysis of data to identify trends and relationships in data, evaluating pros and cons on different delinquent portfolios and generate MIS reports using SAS and coordinating with the Regional and National Heads on regular intervals.
  • Analyzing the data by using MS Excel, SQL, SAS. Extensively worked using Query Analyzer for querying the data base to fix the Data issue that show up on the reports.
  • Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
  • To Prepare the Receivables plan and assists collection managers, agencies and team members to achieve collections targets and control delinquency levels of the Bank.
  • Assist with the development of a behavior scoring models that will determine the delinquency probabilities and charge off potential non-performing assets.
  • Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code.
  • Provide risk management and receivables management guidance and expertise to the Risk Management Group, Retails Assets Operations Group and for Product Managers for specific lines of Bank’s business.
  • Get external market defaulters database from various sources and mapping with the Bank’s existing database and analyze the data using MS Excel, identify the potential frauds and guide team managers for prevention.
  • Assists Relationship Manager in the completion of credit packages for new and existing Commercial Lending relationships and documenting new and existing credits and Amendments using SAS software for data mapping and identifying potential customers for cross sale of Bank’s new products.
  • Responsible for gathering and analyzing in written form business, industry and financial information to assess the level and quality of credit risk and viability of sources of repayment and preparation of financial models using statistical software.
  • Monitors existing relationships and communicates any changes in risk to Relationship Managers to prevent future losses by accessing and joining multiple database files.
  • Assisting in the analysis, design, and development of tables, Excel files and ad-hoc reports.
  • Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
  • Monitoring the existing performance and to change the process for better performance.
  • Extracted data from existing data source and performed ad-hoc queries by using SQL.
  • Monitoring the existing performance of the Bank’s internal departments and to change the processes for better performance and customer satisfaction.
  • Achieving deadlines for timely submission of data analysis, reports by performing data extractions and retrievals.
  • Followed SDLC approach to move the code to Production. Performed QC routines and shared results with business to get approvals.
  • Interface with users, business analysts and other department heads to gather information and requirements. Developed databases and specifying specific data requirements.

Environment: SAS, Excel, SQL Server, Query Analyzer, Windows NT/2000, Finnone, Finnacle.

We'd love your feedback!