SUMMARY

• Certified Base SAS programmer with over 7 years of experience in analysis, design, development, and validating the applications.
• Extensive experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS.
• Expertise in analyzing and coordinating clinical trial data, generating reports, tables, listings and graphs
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows
• Experience in using various MS office tools for analyzing, arranging and presenting data
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS MACRO to improve ease and speed of modifications as well as consistency of results.
• Proven ability to support multiple projects under deadlines often with competing priorities and complexities.
• Excellent organizational, teamwork, presentation, problem solving, decision making and interpersonal skills.

TECHNICAL SKILLS

Statistical Packages: SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide.

Databases: Oracle, DB2, Teradata, Sybase, Mainframes.

Languages: SAS, SQL, C, C++, Core JAVA.

Platforms: Windows and UNIX.

Others: MS office, MS Visio, MS Project Management, Ultra Editor Studio, VBA macros.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SAS Analyst/ Programmer

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales groups.
• Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Interfacing with clients and vendors on ETL processes and maps data from disparate sources into data warehouse formats
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Analyze and interpret significant results based on data summaries.
• Work closely with different Marketing Groups in designing and analyzing the data.
• Responsible for providing statistical research analyses and reports in support for mortgage product.
• Analyzing credit report to determine credit worthiness and performing risk evaluations.
• Ensuring loans are structured and priced consistently with bank policy and commensurate with risk.
• Analyzing and calculating debt to income ratio for evaluating mortgagor’s financial risk and provide recommendation to mortgagor to lower debt to income.
• Evaluating and recommending affordable options to mortgagor to help reduce financial loss.
• Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Perform statistical analyses and QC statistical output.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Present statistical results using the appropriate graphs, charts, tables and written reports.

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Oracle 10g, Teradata, Project Management, UE Studio, Windows XP, UNIX.

Confidential, Tampa, FL

SAS Analyst/ Programmer

Responsibilities:

• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making, measured the execution of bank strategy, and identified opportunities for improving existing processes.
• Served as data custodian and point of contact for operational data warehouse issues. Prepared data views for RBSS authors, analyzers and viewers.
• Converted existing business information report packages to data warehouse platform where feasible.
• Developed and designed SAS Programs / Macros to access and analyze financial.
• Conducting individual and group level analysis.
• Conduct significance tests and study response rates for different logical and non-logical exams separately data.Generated Statistical analysis files, tables, listings, and graphs.
• Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress toward the Retail Banking Division’s strategic objectives.
• Met regularly with Retail Bank Support Services management and analysts to determine, interpret and program solutions to the information needs of the branches and Contact Center.
• Investigated and defined system capabilities, evaluated current and potential system technology needs for performance.
• UsingSAS/SQL for extract, transfer and load ("ETL") methodology and processes
• Developed reports according to SOP’s by using PROC TABULATE, Proc REPORT, Proc SUMMARY, Proc SQL and also provided descriptive statistics using PROC Means, Proc Freq.
• Documented policies and procedures required for supporting system enhancements.
• Train and manage junior programming staff.
• Quality control and assurance including running datasets/files through programs.

Environment: Base SAS, SAS/Macro, SAS/SQL, SAS/Connect, SAS/AF, SAS/Graph, SAS/Access, SAS/Stat, Oracle 9i,Teradata Windows NT and UNIX.

Confidential, Washington D.C.

SAS Programmer/Analyst (Data Acquisition and Retrieval)

Responsibilities:

• Used SAS v8.2 on Sun UNIX environment and Programming in SAS base and Macros.
• Extracted required data from IBM mainframe to local SAS Environment by SAS FTP and sync sort.
• I have used SAS BI to generate complex reports in less time.
• Developed and modified programs in SAS under UNIX environment using SAS/BASE.
• Developed Queries using PROC/SQL to retrieve the data based on the matching columns.
• Developed JCL’s to execute the SAS programs under mainframe environment (OS390).
• Used SAS procedures and preparing daily, monthly, yearly reports.
• Worked with SAS/ODS, HTML to produce dynamic web interfaces from SAS programs
• Used SAS import and Access to import external files. Worked with SAS/Graph to produce graphical reports.
• Involved in risk and portfolio analysis
• Prepared ad-hoc reports and convergence curves of different parameters
• Analyzed data using different procs like ANOVA,GLM and LOGISTIC
• Involved in coding for GUI with SAS/AF, SAS App Dev studio. and SCL.
• Created SAS datasets in local SAS directory.
• Involved in writing code using Base SAS & SAS/Macros to extract data from oracle tables.
• Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.

Environment: BASE SAS, SAS/AF, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ CONNECT, SAS/ACCESS, Ms-Excel, SAS/ODS, Oracle 8i, UNIX,MVS, and Windows NT, IBM Mainframes

Confidential, Philadelphia, PA

SAS Programmer

Responsibilities:

• Created a customer mailing list for Direct Mailing and Telemarketing.
• Worked with large customer response and sales data sets.
• Maintain and enhance existing SAS reporting programs for marketing campaigns.
• Maintain SAS statistical analysis for the products purchased every month.
• Conduct individual account and household level analysis. Conduct significance tests and study response rates for different offers.
• Created SAS datasets in local SAS directory. Involved in writing code using Base SAS & SAS/Macros to extract data from oracle tables.
• Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.
• Took part in creating Data Models for different level of Marketing based on the reports.
• Run reporting programs and download the results into EXCEL.
• Presented the results and statistical reports in PowerPoint for marketing staff.
• Used SQL and PROC SQL to work with Oracle.
• Work with Enterprise Miner for marketing campaigns doing statistical analysis.
• Move data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT, SAS/ACCESS, SAS/ENTERPRISE MINER, DB2, RDBMS: ORACLE, MVS, UNIX and Windows NT

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Developed SAS programs for statistical analyses and data displays.
• Took raw data, built input data sets used sorting and merging techniques to get the required output and then wrote code using SAS/Base, Proc SQL and SAS Macro facility.
• Raw data was processed to create datasets in the required format and tabulated so as to easily analyze data. Extensively used Proc Tabulate procedure for the purpose.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Report generation using many SAS proc statements, SAS/MACROS, and data null steps.
• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Extracted raw data from excel spreadsheets and MS Access. Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.
• Extensively used data export techniques. The data after being analyzed was directed to different output files such as Excel Spreadsheets and DBF files
• Extensively used Proc SQL procedure for working with oracle database for creating and updating the data as and when processed.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, MS Excel, Access 2000, Window NT/2000

Confidential

Data Analyst

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000