Sas Analyst Resume Profile
San Jose, CA
Professional Summary:
- Over 9 years work experience with certified base programmer for SAS9 as a SAS Data Analyst/SAS Programmer in Direct marketing, credit card services, Healthcare and Retails Industries.
- Experience in SAS Visual analytics Base SAS v 8.2/9.2/9.1.3,9.3 SAS/STAT, SAS Macros, SAS/GRAPH, SAS/CONNECT, and SAS/ACCESS on Windows and UNIX platforms and competence in carrying out statistical analysis of large-scale data
- Two years experience using Unix Shell scripts, Data Flux and Oracle SQL to perform ETL, data processing, and automation tasks. Set up customized ETL programs for efficient and automated list processing routines with exception handling capability.
- Experience in using SAS Business Intelligence, SAS Financial Management FM , SAS OLAP Cube studio, SAS Management Console, Enterprise Guide EG 5.1 , Enterprise Miner, SAS DI Studio SAS/FSP, SAS/AF
- Experience in using data steps in SAS for creating, maintaining, and manipulating datasets. Experience in using various statistical procedures in SAS such as PROC SQL, PROC SORT, PROC RANK, PROC FREQ, PROC UNIVARIATE, PROC MEANS, PROC TRANSPOSE, and PROC IMPORT.
- Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results
- Created automated online reports using Oracle SQL and Discoverer to compute performance metrics from customer purchase data.
- Supported database migration by converting scripts from Oracle SQL to Teradata SQL.
- Used Oracle SQL to build data validation tools for list processing tasks.
- Seven years work experience in using MS Excel tools such as VB, Charts, Solver, Crystal Ball, Pivot tables, and lookup functions applied to quantitative, analytical, and reporting projects.
- Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA
- Using ODBC to connect SAS System with relational database management systems, such as Microsoft SQL and Oracle, to retrieve data and create SAS datasets
- Excellent experience with export SAS Results to different format, such as XML, Excel using SAS/EXPORT, SAS/ODS for reporting and presentation
- Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE, SET and
- PROC SQL.
- Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
- Self-motivated individual with strong technical analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
Skill Set:
Statistical Software : SAS Base, SAS Macros, SAS Access, SAS/GRAPH, SAS/STAT, SAS/Intranet, SAS/CONNECT, SAS/ACCESS, SAS OLAP Cube studio, SAS Management Console, Enterprise Guide EG 4.2 , Enterprise Miner, SAS/STATS, Visual analytics
Databases : Oracle 9i/10g, Teradata, MS Access, SQL Server2008, MYSQL ,DB2
Operating Systems : Windows, UNIX, Mainframe, Solaris
Programming Languages : Mat lab, C, PL/SQL
Software Packages : MS Word, Advanced MS Excel, MS PowerPoint, TOAD, SQLPlus
Professional Experience:
Confidential
SAS Analyst
Providing Business intelligence for global business services to target companies for sales. By conducting extensive data analysis and by pulling data from internal models and from external data sources, we provide market research analysis. Standardization and validation, and develop data quality metrics Mapping data using fuzzy logic to compare and standardize unformatted data. Providing on going production support by monitoring productions jobs and providing adhocs as per the requirements and presenting in pivot tables.
Responsibilities:
- Validate source data is consistent with data mappings
- Creating pivot tables for summarized adhoc reports
- Implement UNIX shell script. Extract and manipulate data from Database.
- Write SQL and build data input in SAS format or other formats for Forecasting Model and conduct data analysis.
- Analyzed the Business and User requirements and Participated in the creation, preparation, and conduct of quality assurance reviews
- Analyze the current variable generation implementation or process and apply to the new environment.
- Created macro program to create macro variables to pull data from oracle and SQL server for monthly daily data extracting
- Used extensive procedures for summarization Changing structure of data using proc transpose
- Apply model optimization to improve predictive model accuracy and control the forecast output quality. Develop combined Statistical/SAS methods to identify the output odds and automatically optimize the output.
- Implement statistical approaches to perform Statistical quality control QC on process and data input.
- Support Cisco's Global Market View Application, an internally derived opportunity sizing and forecasting tool. This tool is used in several planning activities including fiscal year planning as well as long range planning. Improve on the existing tool/process including better understanding of technology adoption and the triggers that drive greater technology penetration.
- Extracted data from different sources like Oracle and text files using SAS/Access, SAS
- Used SAS PROC SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
Environment:
SAS 9.3/9.2,SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, Oracle, MS OFFICE. UNIX
Confidential
SAS Programmer/Analyst
Working with strategy and analytics team on campaign data management for RBS citizen's financial group, providing everyday banking and product marketing analysis. Conducting daily evaluation and verification activities designed to improve customer satisfaction and business performance. Developing marketing campaigns for consumer commercial banking products, upgrades and promotional offers .Datasets are directed towards being used for segmentation and for decisions for capturing new customers through direct mail and telemarketing. Credit card representatives use it for giving specifically directed offers to various sectors of new and existing card members
Responsibilities:
- Created macro program to create macro variables to pull data from oracle and SQL server for monthly daily data extracting
- Performed daily weekly and monthly campaigns as per the deliverable schedules
- Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables
- Advanced analytics and reports created based on the criteria provided
- Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML Excel and RTF.
- Developing repetitive loops for retrieving array variables for joining of datasets for AD-Hoc reporting
- Created Dynamic Macro arrays by SQL and with data step programs
- Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
- Used SAS PROC SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
- Developed SAS Macro programs to create Ad-hoc reports
- Performed approvals for peer audit reviews on reports by analyzing data
- Automated the existing audit reviews and production
- SQL procedures and created SAS datasets.
- Extracted data from different sources like Oracle and text files using SAS/Access, SAS
- Documented the code and algorithms logically
- Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.
Environment:
SAS 9.1.3/9.2,SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, Oracle, MS OFFICE. UNIX
Confidential
SAS Analyst
Working as a Business analyst and programmer for Capital One. Extracting data from multiple sources merging cleaning creating variables from scoring cards for PD, LGD and EAD for RWA calculations .working on statistical models obtaining measures and conducting statistical tests of model performance. Work is generally performed in agile environment working on tight timelines at the client's location.
Responsibilities:
- Mapping the data from different sources performing data mining techniques for cleaning and accuracy of the data for model executions
- Developing statistical models from reading documentation from statisticians converting to sas code and gathering the requirements for data from data modelers
- Strong conceptual understanding of statistical models, model development and validation process.
- Good knowledge of consumer credit and credit bureau data from various sources
- Performed data quality checks methodically to ensure data is pre-analyzed before further use. Strongly demonstrated competencies in code documentation and. internal/external validity checks.
- Programming using SAS to meet the challenges of advanced data manipulation, complex programming logic, and extremely large datasets from 40 to 80 M records
- Interpreting, documenting, and communicating results/methodology with the project team and clients.
- Actively communicating with Quantitative Risk Analysts and Financial Engineers/ Modelers to understand and to document quantitative models for valuing complex securities simulating historical, statistical and theoretical market states/scenarios computing deterministic and stochastic security and portfolio level risk measures
- Design, develop and test software to implement the models using SAS, mathematics/statistics/financial procedures Develop high quality code that is efficient , supportable, and follows industry best practices
- Coordinating and supporting the testing of models by executing tests and providing results and supporting data
- Creating lookup tables and using in the model generation with identifying and creating primary keys from data
- Interacting directly with development and operational groups in support of software and production releases
- Provide timely and accurate support for Product Management team in their Time lines in Agile environment
Environment:
SAS 9.3, SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide 5.1, Enterprise Miner Teradata, MS OFFICE. UNIX
Confidential
SAS Programmer/Analyst
Working for Retail Financial services, Business banking Product and marketing .The project involves in developing SAS Macro programs to gathering data based on marketing campaigns for various card products. These datasets were directed towards being used for capturing new customers through direct mail and telemarketing. Credit card representatives used it for giving specifically directed offers to various sects of new and existing card members
Responsibilities:
- Developed SAS Macro programs to create Ad-hoc reports
- Restructured SAS datasets using PROC TRANSPOSE procedure.
- Documented the code and algorithms logically
- Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
- Developing repetitive loops for retrieving array variables for joining of datasets for AD-Hoc reporting
- Created Dynamic Macro arrays by SQL and with data step programs
- Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
- Used SAS PROC SQL pass through facility to connect to DB2 tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
- Done performance tuning for the programs created
- User interface for the end user
- Passing Macro variables to Unix server from windows remotely created from windows to develop good
- worked on a Unix and Windows platform in a server application environment
- SQL procedures and created SAS datasets.
- Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS
- Created macro program to create macro variables to pull data from DB2 for monthly data extracting
- Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.
Environment:
SAS 9.1.3/9.2,SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, DB2, MS OFFICE. UNIX
Confidential
SAS Analyst
Working for Market Research and Competitive Intelligence to serve as the primary support and go-to person for most of the periodic and ad hoc reporting and analyses and also removing their dependence on the IT.
Responsibilities:
- Developed SAS programs to create a customer mailing list for Direct Mailing.
- Data management, data cleaning and transformations using proc SQL, SAS ETL
- Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, and Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
- Developing and designing SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs. ETL / Extract data from warehouse /databases and created SAS statistical analysis reports.
- Extensively used ETL to load data from Oracle database and Flat files to Oracle data warehouse
- Working with Marketing and Operations, develop and run reports that provide information to help the marketing managers understand and monitor 3 different consumer groups, magazine, catalog and continuities in various marketing channels direct mail, telemarketing, email, and web.
- Involved in update and maintenance of data warehouse and generation of various sales and marketing reports.
- Analyzed financial and business results of the company and its competitors to develop an information base for future managerial action
- Experience in developing different methods of extraction, transformation and loading ETL processes for various source systems.
- Acted as liaison between various Survey / Research providers to meet specific data needs and providing quick support in the form of data appends and ad hoc reports
- Write and present ad hoc analyses to support strategic decision making and answer marketing questions.
- Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
- Worked with large customer response and sales data sets and generated graphs using SAS Report and SAS /GRAPH. .
- Maintained and enhanced existing SAS reporting programs for marketing campaigns.
- Data processing and validations were done extensively on the SAS datasets using edit check programs.
- Conducted individual account and household level analysis and conducted significance tests and study response rates for different offers.
- Analyzed response and sale results and write up monthly summary on campaign performance.
- Created Data Models for different level of Marketing based on the reports.
Environment:
SAS 9.1.3/9.2,SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, Teradata, MS OFFICE.
Confidential
SAS programmer/Analyst
SAS was used for Customer acquisition and retention, customer profitability analysis and to identify cross-sell and up-sell opportunities. This involved gathering demographics and general information of various Card members pertaining to various Card Products. Which involves in creating marketing promotions for eligible existing and non existing customers finally compared and analyzed the trends and related information to create customer SAS datasets for the modelers.
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.
- Using SAS interfaces, handled acquisition, authorization, dashboard, partner summary and various graphs and summary reports for credit card risk related reports in production using SAS.
- Developed predictive models in risk analysis. Involved in all the functions that could relate to three aspects of the portfolio i.e. origination, what's on the book already originated , and collections.
- Familiar with data and content migration using SAS migration utility for products that relay on metadata.
- Created tables and reports from Stat procedures, regression model building, Summary, Mean, Freq, , cluster analysis, Excel and also using linking with DDE.
- Was involved in different promotions program to generate data, develop model, and get the summary reports.
- Created data marts, OLAP Cubes and reports for reporting using Base SAS and SAS DI Studio.
- Designed, built and tested a series of SAS programs for the transfer and validation of reports.
- From SAS jobs, developed CSV files and reported offshore progress to management with the use of excel templates excel macros, pivot tables and functions, as well as creating daily, monthly, quarterly, yearly reports activity onsite through the creation of a SQL Server, Teradata and MS Access databases
- 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.
- Identify new trends and/or opportunities to use predictive modeling and statistics to drive business value throughout marketing
Environment:
Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/Connect, Windows XP professional, UNIX, and Teradata SQL/Assistant.
Confidential
SAS Programmer/Analyst
Confidential operates health plans, insurance companies, network rental services companies, and worker's compensation service. The project involves in migrating existing web applications, programs, and SAS datasets, and .HTML, .HSQL, .JS and .KSH files from UNIX to Windows environment. Also project focuses on providing new reporting requirements like analytical and regulatory reports to business users.
Responsibilities:
- Interact with business users to gather requirements, to prepare technical documentation specifications.
- Analyze existing UNIX based SAS/INTRNET web applications, korn shells and SAS Programs migrated them into windows applications.
- Prepare the technical documentation, including development of outcomes and process measures.
- Analyze existing system, programs, files and structure of data and develop the enhancement code in windows, co-ordinate with to Team and involved in new system set up, servers, and services.
- Migrate the SAS datasets and modify the SAS programs, Java scripts, html, shell scripts, configuration files from UNIX to Windows environment.
- Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
- Ensure to standardized report generation and application functionalities are intact after migration.
- Optimize the SAS system in windows environment for efficiency and reporting purposes.
- Perform Statistical analysis on difference kind of data and generate the reports and also analysis on patient, physician, Bill Review, audits and claims data.
- Responsible for updating warehousing, data analysis, data deliverables and report generation.
- Analyzing the existing code, develop and modify code for enhancement and better performance.
- Document the all the programs, organizing process flow, maintaining the metadata server, developing the macros, graphs and charts using Enterprise guide.
- Responsible for creating test data, test cases and unit testing. Used rational suite Clear Quest, Requisite Pro, Clear case to trace defects, requirements and test cases.
- Extensive use of SQL procedure to connect to databases Oracle, SQL server and perform ETL process
- Generate weekly and monthly reports and update the Coventry Data Warehouse on weekly basis.
- Create shell scripts and DOS scripts for running batch jobs to extract, merge, manipulate and analyze large volumes of healthcare data.
- Read flat files like ASCII, excel, csv and MS Access to create SAS datasets, load in to the warehouse.
- Key player in interacting with business team to understand issues and propose solutions.
- Ensure deliverables are met on-time.
Environment:
SAS, Enterprise guide, SAS/Macro, SAS/SQL, MS Visio, Oracle 10g/9i, SQL Server, Teradata, UNIX and Windows XP.
Confidential
SAS Programmer / Analyst
Confidential The project involved design and implementation of a pilot project for decision tree analysis using several attributes from the database of cardholder performance. The achieved aim was to reduce delinquencies and increase response rates amongst various sects of customers. The team was also responsible for acquisition modeling in the emerging markets of India. This was done as part of the bank's CRM strategy. This involved gathering demographics and general information of various card members pertaining to various card products. Finally compared and analyzed the trends and related information to create customer SAS datasets for the modelers. These datasets were directed towards being used for capturing new customers through direct mail and telemarketing. Credit card representatives used it for giving specifically directed offers to various sects of new and existing card members.
Responsibilities:
- Used Proc Import statement to convert delimited files like .CSV files into SAS data files.
- Performed categorical statistical data analysis on sales and marketing information.
- Performed consumer profiling and sales forecasting, generated customer lists for various departments to determine retention strategies.
- Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base
- Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction
- Conducted anova and regression analysis
- Generated HTML, Listings, Excel and RTF reports for presenting the findings of various statistical procedures using Proc Report and Proc Print
- Created reports from analysis as per the client's requirements.
- Developed software solutions to improve key business processes
- Involved in the entire software life cycle: requirements gathering, analysis, design, testing and implementation
- Designed and developed C and C code, for presenting the data in an HTML format.
- Developed Stored Procedures to be utilized in statements of database programming.
- Written SQL Queries to get various reports.
- Involved in client interaction and implementing quality procedures to this project.
- Involved in unit and system testing.
Environment:
SAS 9.x BASE, STAT GRAPH, STAT MACRO, SAS ETS and SAS CONNECT, Oracle 9/8.0/8i, PL/SQL, UNIX Sun Solaris , Windows NT.