We provide IT Staff Augmentation Services!

Sas Programmer Resume

SUMMARY

  • SAS programmer with over 7 years of professional experience in working with SAS with strong emphasis on SAS programming for reporting, modeling, data analysis, and data manipulation for BI, Risk management, Marketing, and Financial departments of large enterprises
  • Experience in modeling for risk rating, and performing various business analyses like Product performance, Customer behavior, and Market performance
  • Worked closely with management like Marketing managers, Product managers, Data delivery managers, and Vice Presidents
  • Experience in generation of various canned periodic and ad-hoc reports for various analyses
  • Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, and SAS/GRAPH in UNIX, Windows, and Mainframe environment
  • Experience in UNIX Korn Shell scripting for process automation
  • Experience in working with multiple databases like Oracle Server, DB2, MS SQL Server, and MS Access
  • Experience in development of documentation like FRD, Technical Specifications from BRD and Process/Program flow
  • Experience in using SAS to import/export data to external file formats like flat, Excel, XML files
  • Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports
  • Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules
  • Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel
  • Extremely energetic, detail oriented, organized, team player with strong analytical abilities, communication skills, interpersonal skills, and problem solving skills
  • Highly persistent and motivated with willingness to assume responsibility

TECHNICAL SKILLS

SAS Tools: SAS V9.x /8.x, Base SAS, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/
GRAPH, SAS/ODS, ETL, SAS BI Server and SAS Data Integration Platform 4.2, SAS Forecast Studio, SAS Enterprise Guide, SPSS, SAS EBI
Databases: Oracle 9i/10g/11i, DB2, MS SQL Server, and MS Access
Operating Systems: UNIX (VI EDITOR), MS-Windows XP/2003/2000, and MVS mainframe
Database Tools: TOAD 9.7.2, PL/SQL Developer 7.1.5
Programming Languages: SQL, UNIX Korn Shell Scripting, and Visual Basic 5.0

EDUCATION
Bachelors in Engineering in Biotechnology

WORK EXPERIENCE

Confidential, CA July’11- Present
SAS Programmer
PepsiCo is a world leader in convenient snacks, foods and beverages.. The scope of the project is to implement marketing strategy, evaluate performance and to validate initial program assumptions, analyze time – trended data to improve performance forecasting of future programs.

Responsibilities:

  • Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
  • Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
  • Experienced in handling Terabytes of records and manipulating them through SAS.
  • Analyzed Interactive Marketing / eCRM System data and produced ad-hoc report details.
  • Analysis included Behavioral model, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling, Lift modeling and Validation, Optimizing open-ended offers, etc.
  • Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.
  • Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
  • Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
  • Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence (BI) to produce required Reports.
  • Created various summary reports of POS, Total Sales, Regional Sales and Account Sales of various titles, regions and also presented the various sales reports using the Information Delivery Portal and the Dash Board Portlets.
  • Used Enterprise Miner for taking data and converting them into required SAS datasets. Also used the SAS Forecast Studio for appropriate analysis of data for different Forecasting models like Time Series Forecasting.
  • Documentation, presentation, data reports and model results to the team/manager.
  • Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ANOVA and PROC GLM to analyze data and generate reports.
  • Used SAS EBI suite for creating, managing reports.
  • Implemented OLAP cubes, OLAP tools and other report tools like Web Report Studio.
  • Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.
  • Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.

Environment: SAS/Base, SAS/STAT, Teradata, SAS/SQL, SAS 9.1.3, Windows XP Professional, SAS/Macro, SAS/Access, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS/ ETL, SAS BI, Oracle 10g, Teradata, SAS V9.1.3, SAS Views, SAS Enterprise Guide, SAS/DI studio 4.2, Management console, SAS/information mapping, Excel, Windows XP, UNIX.

Confidential, TX Aug’10- June’11
Sr SAS Consultant
PepsiCo is a world leader in convenient snacks, foods and beverages.. The scope of the project is to implement marketing strategy, evaluate performance and to validate initial program assumptions, analyze time – trended data to improve performance forecasting of future programs.

Responsibilities:

  • Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
  • Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
  • Experienced in handling Terabytes of records and manipulating them through SAS.
  • Analyzed Interactive Marketing / eCRM System data and produced ad-hoc report details.
  • Analysis included Behavioral model, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling, Lift modeling and Validation, Optimizing open-ended offers, etc.
  • Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.
  • Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
  • Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
  • Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence (BI) to produce required Reports.
  • Created various summary reports of POS, Total Sales, Regional Sales and Account Sales of various titles, regions and also presented the various sales reports using the Information Delivery Portal and the Dash Board Portlets.
  • Used Enterprise Miner for taking data and converting them into required SAS datasets. Also used the SAS Forecast Studio for appropriate analysis of data for different Forecasting models like Time Series Forecasting.
  • Documentation, presentation, data reports and model results to the team/manager.
  • Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ANOVA and PROC GLM to analyze data and generate reports.
  • Used SAS EBI suite for creating, managing reports.
  • Implemented OLAP cubes, OLAP tools and other report tools like Web Report Studio.
  • Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.
  • Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.

Environment: SAS/Base, SAS/STAT, Teradata, SAS/SQL, SAS 9.1.3, Windows XP Professional, SAS/Macro, SAS/Access, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS/ ETL, SAS BI, Oracle 10g, Teradata, SAS V9.1.3, SAS Views, SAS Enterprise Guide, SAS/DI studio 4.2, Management console, SAS/information mapping, Excel, Windows XP, UNIX.

Confidential, Baltimore, MD Jun’09 – Aug’10
Sr. Programmer/Analyst
CareFirst is the largest health care insurer in the Mid-Atlantic region, serving nearly 3.4 million members. The project was to complete ad hoc and production analyses in support of major corporate initiatives related to Primary Care Medical Homes, quality of care, provider performance, and clinical outcomes.
Responsibilities:

  • Create and implement robust database applications and reporting solutions for the Healthcare Analytics department.
  • Contribute to the continual improvement of the department by developing efficient methods for extracting data from source systems, automating processes, developing neat and accurate end-user reports, and expanding the use of new technologies.
  • Generate clear and concise documentation for all projects.
  • Expand technical and business knowledge through individual research and on-the-job training.
  • Participate in meetings and facilitate information exchange with people in other departments and/or external customers.
  • Assist colleagues with assignments.
  • Run reporting programs and downloaded the results into EXCEL.
  • Carried out profiling analysis for customer data. Used PROC TABULATE and PROC REPORT. Standardized those reporting programs into macros.
  • Created Reports using analysis output and export them to the web to enable the customers to have access through Internet.
  • Moved data set across platforms.

Environment: Windows2000, Unix, MS Excel, VBA, SAS 9.1, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS E-Miner, SAS BI, SAS DI Studio 4.2, SAS Web Report Studio, PROC Reports, ORACLE.

Confidential, Plano, TX Jun’08 – May’09
SAS Programmer/ Analyst
The project uses SAS and Teradata database to conduct statistical analysis and to create data mining solution that allowed the bank to develop advanced models for better consumer loan providing and recoverability and to determine marketing strategy. Running modeling programs using SAS, SAS/Stat, SAS/Access, SAS/SQL, SAS/Macro, and SAS/Graph for the Consumer Lines & Loans Processing.

Responsibilities:

  • Generated statistical reports. Technologies like Teradata and SAS are used for creating reports.
  • Working on checking Data quality by comparing current month data and previous month data or going back up to 3 years to check the same month’s data to reveal the similarities and variances in the data. The determination is usually based on checking differences in missing, mean, standard deviation, minimum and maximum values of the range of data.
  • Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
  • Created complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
  • Created SAS Customized Reports using the Data _Null_ technique.
  • Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
  • Developed routine SAS macros to create tables, graphs and listings.
  • Developed SAS macros for data cleaning and reporting and to support routing processing.
  • Used Proc REPORT to generate reports. Developed annual reports based on existing data.
  • Imported data from excel sheet for analysis in SAS.
  • Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros.
  • Maintained large data sets, combined data from various sources in varying formats to create SAS data sets and/or ASCII files.
  • Converted Teradata data tables into SAS data files using SAS SQL 'Pass Through Facility,' and uploaded SAS data files into Teradata tables using SAS 'Dbload' procedure.
  • Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/Connect, Windows XP professional, UNIX, Teradata SQL/Assistant, SAS BI, SAS Web Report studio.

Confidential, New Orleans May’07- Jun’08
Sr SAS Programmer/ Risk Analyst

Entergy Corporation is an integrated energy company engaged primarily in electric power production and retail distribution operations. Entergy owns and operates power plants with approximately 30,000 megawatts of electric generating capacity, and it is the second-largest nuclear generator in the United States. The purpose of the project is to design and develop different processes for publishing daily, weekly, monthly and ad-hoc reports on gas, power, NGE positions and P&L. And automation of Excel/manual processes to SAS and VBA.

Responsibilities

  • Involved in designing processes in SAS and VBA for new business units.
  • Designed risk metrics and examined a variety of different data sources to determine ways of increasing profitability, managing risk, and lowering transaction costs.
  • Develop time series analysis and models using Matlab, Excel and SAS.
  • Developed and analyzed periodic forecasting reports using various MS Excel and SAS tools.
  • Developed and maintained planning models and reporting tools for the reports.
  • Prepared financial models of projects and reported findings of investment analysis, payment studies, profitability, measurements, and variances from forecasts to upper management.
  • Successfully used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
  • Analyzed and build Risk-Metrics using SAS/IML and SAS/ETS and Base SAS.
  • Implemented Monte-Carlo simulation techniques for Risk-Metrics using SAS/IML.
  • Integration / synchronization of daily P&L reports with financial forecasts.
  • Reviewed existing reporting outputs to validate current deliverables prior to publication.
  • Ensured the accuracy and timeliness of daily P&L and position reports using SAS reporting procedures and VBA tools.
  • Automation of Data Extraction, Transformation and Loading the results to final datasets using SAS and SQL.
  • Streamlined the data mining process from data extraction to model deployment for using Enterprise Miner and SAS/ETL.
  • Generated Reports, Summary tables, Charts and Graphs for different users using SAS/ASSIST.
  • Used advanced techniques to reduce the execution of processes times in SAS and MP-Connect, SAS/Access.
  • Conducted data validation using SAS Enterprise Guide.
  • Summarized the results and data with PROCs FREQ and MEANS.
  • Performed Statistical Analysis with statistical procedures and univariate procedures from Base SAS, SAS/STAT and SAS/IML and created Reports with PROC REPORT and ODS.
  • Developed Unix Kern shell scripts to automate recurring processes and routine administration tasks.

Environment:Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, SAS/IML, ORACLE, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, SAS DI Studio, SAS OLAP, SAS Enterprise Guide, Enterprise Miner, BI/Query, Teradata, Excel, UNIX.

Confidential, Louis, MO May’06-Apr’07
SAS programmer
MasterCard operates one of the world's largest retail electronic payments network and is one of the most recognized global financial services brands. Responsibilities included providing subject matter expertise to the VAS team while developing more statistically advanced analyses using the SAS software. Manage large datasets and capture specialized technical knowledge reducing costs on external providers. Develop methodologies and analytical models in order to identify business opportunities and optimize the profitability of the payment system.

Responsibilities:

  • Perform 'Invest' level bank-specific analysis on large data sets including proprietary information, such as customer demographics, activity, spend levels and financial information.
  • Develop analytic production and ad hoc requests/reports to be used in credit card activation and usage decision making.
  • Evaluate analytical findings to ensure accurate interpretation of data and development of meaningful data mining results.
  • Interpret business and statistical analysis to the team of consultants for use in decision-making
  • Defining ways to organize several sources of information in order to support the business opportunity identification process for client banks in Latin America.
  • Responsible for client-specific transactional data analysis, such as point-of-sales and ATM transactions, sales volume and profitability and performance indicators for debit and credit card programs.
  • Identify relevant market trends by country, based on a deeply analysis of payment industry information in Latin America.
  • Analyze and mine multiple client data to select statistically valid data samples, build, test, and implement predictive models by investigating appropriate methods and algorithms.
  • Engage in quantitative analysis on many non-standard and unique business problems using computer-intensive data mining techniques (decision trees, neural networks, clustering, etc.) to deliver actionable output.
  • Identify the most relevant criterion to segment individual customer bases for client banks in Latin America. Develop statistical modeling including: Chaid, Discriminant Analysis, Cluster Analysis
  • Logistic Regression to capitalize business opportunities of activation, usage and retention for strategic clients.
  • Responsible for internal development of new consulting services in coordination with team consultants based on needs basis.
  • Enhancement of the current consulting offering through the development of more statistically advanced analyses using specific data-mining tools such as SPSS, SAS software.
  • Responsible for providing the consulting team with data preparation, data analysis and statistical modeling using SAS as a primary tool.
  • Execute data crunching, write codes, merge/purge/ and split data, and do ad hoc queries/cut data programming in SAS
  • Create and consolidate reports using several internal and external sources through the development of standard macros.
  • Generate codes in order to develop and deliver current business solutions through the automation of consulting processes, providing ideas to create more efficiency within the team.
  • Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Conduct extensive data checks to ensure data quality.
  • Develop, update, and maintain current SAS programs using SAS tools for Windows in a user support environment.
  • Work with team members to understand market and client specific needs for development of new consulting solutions or refinement of existing services.
  • Present and communicate results of data mining efforts in a manner consistent with the target audience and business needs.
  • Document all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics.
  • Responsible for transfer of technical knowledge to facilitate implementation of the business solution provided.
  • Contribute ideas within the team in order to identify profitable opportunities for the Key banks and key Markets.

Environment: UNIX, SAS, SAS/BASE, SAS/ODS, SAS/Connect, SAS/ETL, SAS/MACRO, SAS/STAT, SAS/SQL, PROCEDURES, ORACLE, Access, Excel, DB2.

Confidential, India Jun’04-Mar’06
SAS Programmer
HDFC Bank is the leading bank company in India. Responsible for acquisition modeling in the emerging markets of India. As it was not easy to buy geographical and demographic data In India, customer data was built internally by gathering demographics and general information of card members pertaining to diverse products to extract information about solicited and non-solicited responders over a period of time. Compared and analyzed trend and related information from this data to create customer SAS datasets and flat file for modelers. These datasets were used for capturing new customers through direct mail and telemarketing

Responsibilities:

  • Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros
  • Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE
  • Analyzed data using various statistical PROCEDURES like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
  • Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction
  • Proposed a set of action plans to mitigate the risks identified with the sourcing decision
  • Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical PROCEDURES using PROCEDURES like PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS

Environment:SAS/BASE 8.2, SAS/ACCESS, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SQL, ORACLE

Hire Now