SUMMARY

• Around 6 years of professional experience of SAS programming and statistical analysis in various domains like Management, Utility, and Financial industries.
• Extensive experience in developing reports for portfolio analysis, delinquency forecasting, originations strategy (integrating loan originations platforms from acquired companies), collections strategy, and repossessions strategy and performance analysis.
• Experience in providing business insights in customer segmentation, market analysis, forecasting, competitor analysis, product development & customer operations.
• Expertise in Base SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/DATASETS, SAS/ODS.
• Extensive experience in data manipulation and generating customized reports with SAS data steps and procedures including Data NULL, Proc Datasets, Proc Format, Proc Contents, Proc Freq, Proc Means, Proc Univariate, Proc Transpose, Proc Tabulate, Proc Print, Proc SQL, Proc Summary, Proc Report.
• Expertise in generating Graphs by employing SAS procedures Proc Gplot,and Gchart.
• Extensive experiences in applying SAS procedures such as import, export, read and/or write data from raw / delimited files and MS Excel Spreadsheets.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze data, and to generate statistical analysis outputs including tables, listings, graphs and reports.
• Proven ability in gathering customer behavior data from a wide variety of data sources utilizing statistical modeling tools to identify actionable insights for improvement.
• Expertise in Data Manipulations using SAS data step, procedures such as SAS Formats/Informats, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Extracting data from different sources (e.g. Oracle, Teradata) using SAS/ACCESS and Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Extensive experience and proficiency in using SAS ODS to create output files in a variety of formats including RTF, HTML and PDF.
• Quick learner with ability to understand job requirements employs new idea, concepts, methods, and technologies.
• Effective team player with excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels. Hard working, ethical and highly result oriented.

TECHNICAL SKILLS

Base SAS: Data Step, SAS procedures, Formats, Informats, Macros, Data Null Reports, SAS Functions, Descriptive Statistics, SAS ODS, Arrays.

SAS Procedures: Means, Summary, Freq, Sort, Print, Append, Import, Export, Format Tabulate, Chart, Compare, Content, SQL, Univariate.

Databases: Teradata, MS - SQL, Oracle, MS-Access and SQL Server.

SAS Products: Base SAS, SAS/Access, SAS/Connect, SAS/Share, SAS/IntrNet SAS/Graph, SAS-ODS SAS Add-in for MS-office, SAS Enterprise Guide, SAS Enterprise Business Intelligence, SAS Management Console, SAS Forecast Server, SAS Enterprise Miner.

Operating Systems: Windows 95/98/XP, 2000, 2003, Unix

Languages: C, SAS, HTML, SQL, PLSQL

PROFESSIONAL EXPERIENCE

Confidential, MN

SAS Data Analyst

Responsibilities:

• Extracted the BBY customer data, Marketing data related to customers from sources like Oracle, Teradata using SAS/ACCESS ‘SQL pass through facility’ and libname statements.
• Modified and manipulated the data using Data step Programming, SAS functions and Proc sql statements.
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Participated in marketing campaign-planning meetings with Marketing managers, Managers in order to develop and document campaigns specifications.
• Gathered Business Requirement specification, Table Specs and Functional specification documents and communicated with the marketing manager to know the type of reports to be developed.
• Participated in the Team review meetings with the project manager, Lead and business users.
• Used different SAS Procedures, SAS functions, Formats… in SAS programming code and used Data Null, Proc Freq, Proc Tabulate, Proc Report, Proc Means, Proc Macros, Proc Summary, Proc Contents, Proc Compare, and Proc Univariate to produce the reports.
• In order to avoid repetitive writing of sas statements used SAS Macro facility wherever necessary in the programs.
• Used SAS/ODS to produce the reports in different formatted files.
• Created ad-hoc reports using various SAS Procedures, SAS/Graph and SAS/Stat.
• Performed data validation on the BBY customer data tables, Unit testing and Integration testing on sas programs before and after generating the reports.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL .
• Analyzed the data using PROC FREQ, PROC MEANS, and PROC SUMMARY.
• Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, NODUPKEY, and PROC TABULATE procedures.

Environment: SASV9.1.3, 9.2, Oracle, Teradata, Excel, and SAS Enterprise guide, SAS/SQL, Unix OS, SAS/ODS, SAS/Graph, SAS/Macro, and SAS/ACCESS

Confidential, CA

SAS Business Analyst / Operations Research

Responsibilities:

• Conducted thorough analysis on historical data to generate seasonality of demand index profiles.
• Analyzed past data to generate granular price elasticity of demand values and associated reports to aid business decisions regarding promotions and investment therein.
• Spearheaded the requirement gathering, development and testing phases of the YMR Project.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, Proc ANOVA.
• Developed an application “Connection Builder” using SAS which allows some areas to achieve their objectives, it creates all possible flight connections between different airlines according to the market rules. This application is used to analyze and create alliances with other airlines, identify and convert losers markets into winners markets.
• Performed extraction, transformation and loading from / to large Teradata tables.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on the data.
• Optimized, automated and productionalized daily / weekly / monthly scripts for increased efficiency and intelligence.
• Generated web based reports via Web Report Studio to enable users and decision makers across the enterprise with self-sufficient access to consistent, accurate data and the predictive power of SAS analytics.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Developed reporting procedures using PROC REPORT and PROC TABULATE.

Environment: Windows, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS Maps, SAS/Enterprise Guide.

Confidential, Raleigh, NC

SAS Programmer

Responsibilities:

• Used SAS/ACCESS to extract data from different relational database management (ORACLE and SQL SERVER) systems using SAS.
• Read the missing values by using MISSOVER and TRUNCOVER.
• SET, UPDATE and MERGE statements are used for creating, updating and merging various SAS data sets
• Collaborated with marketing and related departments to develop required applications using SAS/STAT and SAS/MACRO; Tested and debugged existing macros.
• Executed complicated analysis along with customer retention analysis and portfolio performance tracking;
• Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Performed Consumer profiling, Sales forecasting, testing and statistical analysis of financial and operational data.
• Performed complicated analysis including customer retention analysis and portfolio performance tracking;
• Involved in various marketing programs including customer loyalty, attrition, and promotion offer structure;

Environment: . Windows, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS Maps, SAS/Enterprise Guide.

Confidential, Hartford, CT

SAS Programmer

Responsibilities:

• Produce SAS datasets, flat files, and reports for various departments.
• Create SAS data sets from Oracle database.
• Extensively program for statistical analysis of data.
• Develop and execute controlled tests to determine the impact of new programs and strategy changes on existing customers.
• Implement advanced statistical approaches to develop predictive models and profiles.
• Data mining to identify significant relationships among customer behaviors and descriptive characteristics.
• Perform complex ad-hoc programming, analysis, and reporting.
• Design, document, implement, and maintain monthly and ad-hoc financial and marketing analyses.
• Develop and produce monthly reports summarizing business activity, delinquency & loss.
• Maintain and enhance loss-forecasting models and delinquency roll rates.
• Modified/developed korn shell scripts to generate periodic reports.

Environment: Windows, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS Maps, SAS/Enterprise Guide.