SUMMARY

• Over 7 years of experience in design, development and implementation of analytical solutions and data analysis with profound expertise in banking/finance.
• Excellent oral, written organization and multitasking skills with proven ability to learn, program and use new technologies.
• Over 7 years work experience as a SAS Data Analyst/SAS Programmer in Finance, Direct marketing, Credit card services and Retails Industries.
• Experience in BASE SAS v 8.2/9.1/9.2/9.3, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 4.0, SAS/ACCESS and SAS/CONNECT in UNIX and Windows environments.
• SAS certified Base Programmer with 93% passing Grade.
• Solid understanding and experience in Database marketing, Data Mining, Advanced data mining SQL and SAS Programming in Windows, UNIX environments.
• Experience with OLAP applications.
• Experience with relational database concepts such as Oracle, SQL, MS Access, DB2 and reporting using SAS.
• Experience with database manipulation (ETL) in Data Analysis and Data Mapping.
• Practical knowledge of and expertise in the SAS programming language, especially Data step programming, report generation(ODS) and writing reusable standardized code.
• Comprehensive programming experience with SAS procedures such as SORT, SUMMARY, MEANS, FREQ, IMPORT, EXPORT, CONTENTS, PRINT, TABULATE, REPORT, SQL, TRANSPOSE, FORMAT, PLOT, CHART, DATASETS, ACCESS, DBLOAD and UNIVARIATE.
• Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE and SET.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleaning, loading and reporting.
• 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.
• Knowledge in areas of statistics, including LINEAR AND NONLINEAR REGRESSIONS, CATEGORICAL DATA ANALYSIS, MULTIVARIATE ANALYSIS AND DATA MODELING.
• Extensive knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS, REGRESSION, ANOVA, GRAPH AND PLOT.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables.
• Skilled in writing automated SAS tasks and conversion of SAS datasets into various file types (including HTML, Excel, PDF, Word, XML) as well as converting various file types to SAS datasets.
• Excellent understanding of data management principles, advanced data management principles, database design, data analysis and data manipulation.
• Good Knowledge on advanced database concepts like query optimization, data mining etc.
• Excellent report writing, communication, presentation and interpersonal skills.
• Strong ability to adapt and learn new technologies.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows, MVS.

Statistical Software: SAS/ BASE, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect, SAS/IML, SAS/ETL, SAS Enterprise Miner.

Programming Languages: SQL, PL/SQL, C, C++, HTML.

Databases: Oracle, MySQL, MS Access, DB2, SQL SERVER.

Application Software: MS Office, Microsoft Visual Studio, UML, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Riverwood, IL

SAS programmer/Analyst

Responsibilities:

• Developed and designed different SAS programs to analyze financial data.
• Created one - way frequency reports, list report and also done summary statistics, table analysis by using SAS.
• Performed Data Cleaning for data attributes by backfilling the historical period data with current existing data.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Created Pivot tables in Microsoft excel for the SAS DATASETS for further calculations
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Generated high quality reports in the form of listing, HTML, XML, RTF and PDF formats using SAS ODS.
• Performed extraction, transformation and loading from large Oracle tables.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Testing on large raw data file using FIRSTOBS and OBS option, use of Datalines to enter data internally.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Use of PROC IMPORT procedure to import excel file into SAS.
• Loop iteration in data step using Do-End statement.

Environment: SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, and Windows XP.

Confidential, Fort Worth, TX

Risk Analyst/SAS Programmer

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT in order to understand and prepare the data
• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports.
• 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.
• Wrote programs in SAS, generated reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Implemented credit risk analysis reporting system based on FICO scores and data management principles, such as joining dataset, indexing, data aggregation, record selection, sub-setting, and multiple records per case, creation and modification of views, accessing multiple databases.

Environment: SAS/Base, SAS Enterprise Guide, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS, Oracle 9i, MS EXCEL, MS ACCESS.

Confidential, San Bruno, CA

SAS Programmer / Analyst

Responsibilities:

• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing. Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Involved in update and maintenance of data warehouse and generation of various sales and marketing reports.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Coding and development of direct marketing initiatives through tasks such as, database design, generating campaign files, performing detailed data analysis, ad-hoc reports through DB2 UDB and Microsoft Excel
• Used PL/SQL and PROC SQL Pass through Facility to work with ORACLE and DB2.
• Created new programs and modified existing programs.
• Generated graphs using SAS Report and SAS /GRAPH.
• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF
• Worked with large customer response and sales data sets.
• Worked on creating SAS Data sets from flat files and merging data
• 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.
• 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.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Restructured SAS datasets using PROC TRANSPOSE procedure.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS /STAT, SAS/SQL, ORACLE, Excel, DB2, HTML, Windows NT 4.0.

Confidential, Los Angeles, CA

SAS Programmer/Analyst

Responsibilities:

• Extracted the data from database using SQL queries and created SAS data sets.
• 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
• Finding the Weighted Average of the quantity of stocks using proc type, proc freq which are bought and sold at a particular time.
• Created reports from analysis as per the client’s requirements.

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

Confidential, Sacramento, CA

SAS Programmer/Analyst

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, hsql files, 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, NYC, NY

SAS Analyst/Credit Risk Analyst

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Implemented Credit Risk Analysis reporting system based on Fico Scores and data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple database.
• 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.
• 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.
• 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.
• Used Enterprise Miner to conduct predictive analytics like logistic regression, cluster analysis for household level analysis.
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.

Environment: SAS/BASE 9.1.3, SAS/Macro, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS Enterprise Guide 4.0,SAS Enterprise Miner 5.1,Oracle 9i, PL/SQL, DB2, UNIX, MS EXCEL, MS ACCESS.

Confidential, Richardson, TX

Data Analyst

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools - SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Responsible for locating appropriate databases for projects and performing relevant analysis.
• Processed data collection to ensure proper quality of data.
• Maintained the daily error log for cleaning the data.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.
• Presented numerical information in various formats. Created SAS customized reports using the Data null technique.
• Generated graphs using SAS/GRAPH. Used PROC REPORT to generate reports.
• Prolifically generated SQL queries for the reports.
• Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.

Environment: SAS 9, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, UNIX, Windows.

Confidential

SAS Programmer

Responsibilities:

• Developed SAS Macro programs to create Ad-hoc reports
• Created macro program to create macro variables to pull data from Oracle for monthly data extracting
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Worked on a Unix and Windows platform
• Done performance tuning for the programs created
• 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.
• Used SAS Macros and SAS SQL to query data and to obtain results, which were generally stored as delimited text.
• Created Dynamic Macro arrays by SQL and with data step programs
• Developing repetitive loops for retrieving array variables for joining of datasets for AD-Hoc reporting
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Documented the code and algorithms logically
• Restructured SAS datasets using PROC TRANSPOSE procedure.
• 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 8, SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, Oracle 9/8.0/8i, PL/SQL, MS OFFICE, UNIX, Windows NT.