SUMMARY

• SAS programmer with over 7 years of experience in applying SAS on various projects using various versions of SAS software in programming for data analysis, coding and application implementation as well as market/risk analysis, financial analysis.
• Generated and automated customized reports using SAS macros to help clients in preparing dash boards for understanding risks with ease and optimized performance and customer satisfaction.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Experience in designing SAS VA reports using data builder, VA designer.
• Provided support as primary liaison between the business line, operations, and the technical areas throughout the project cycle. Majorly concentrated on gathering, analyzing, documenting, Programming, validating data as per business requirements.
• Utilized various SAS input techniques in DATA step to create new data sets from a raw data and handled missing data using various infile options.
• Performed extensive Data Cleansing during the ETL's Extraction and Loading Phase by developing an automated SAS using complex reusable Macros analyzing the raw data and derived data.
• Extensive experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS.
• Created SAS programs on UNIX platform and automated them using shell scripts to download/transfer the data between different servers according to the specifications.
• Coordinated with vital departments to analyze customer retention, opportunities and customer segmentation.
• Stored and distributed SAS Enterprise Guide results in different formats such as HTML, PDF, WORD based on the user group requirements using SAS output delivery system.
• Used SAS Data Step logics and PROC SQL techniques to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used other BI tools to produce reports as per requirements.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically.
• Skillful in generating tables, graphs, and listings adhering to the Analysis Plan Standard Operating Procedures (SOPs), and departmental guidelines.
• Designed and created reports directly from various sources like Excel datasheets, flat files and Oracle databases.
• Producing data in various output formats including HTML, RTF, PDF, MS - EXCEL using ODS (output Delivery System).
• Used statistical procedures such as proc reg, proc freq, proc logistic, proc mixed, proc glm, proc means, proc univariate,
• 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 Software: SAS Base, SAS Macros, SAS/GRAPH, SAS/ODS, SAS/STAT, SAS/SQL, SAS/ACCESS, Enterprise Guide

Databases: Oracle, Teradata, db2

Operating Systems: UNIX, Windows 98, 2000, NT, XP

SAS Skills: SAS V8.2, V9.1, V9.1.3, V9.2 and Enterprise Guide

Development Tools: MS Office (Word, Excel, Outlook, Lync, Power Point, Access), MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

SAS Developer

Responsibilities:

• Developing code to create marketing contact lists (Primarily using SAS in UNIX and Teradata) based on technical specifications to pull and manipulate large volumes of complex account data.
• Performed daily, weekly, monthly and ad-hoc campaigns as per deliverable schedules.
• Used SQL pass through facility to connect to Oracle tables and created datasets using various SQL joins.
• Experience in data manipulations including the usage of basic standard SAS procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditional SAS data step programming in Unix Environment.
• Experience in bringing large data from SAS and non-SAS (Teradata or Oracle or DB2 database) data sources into a SAS environment and performing SAS data manipulations against the resulting sets. This includes ability to merge datasets and to write SAS Macros and generate list outputs/reports.
• Validating and testing all code for accuracy and efficiency.
• Completing necessary documentation to evidence the code matches requirements and that it meets department’s quality standards.
• Provided the Audits to BA/PM, tester and marketer’s based on the spec requirements.
• Helping explain technical details of code to a less technical business audience.
• Providing good time line estimates for coding based on functional specifications and manages expectations with business partners.
• Communicate with business contacts as necessary to help explain results.
• Used Crontab and shell scripting to start SAS process, control jobs and redirected input and output.

Environment: SAS 9.2, SAS/BASE, SAS/SQL, SAS/MACROS, UNIX, Windows XP, ORACLE, TERADATA, MS office

Confidential, Columbus, OH

Sr.SASProgrammer/Risk Analyst

Responsibilities:

• Involved in meetings and projects with business users, project managers & developers to automate, upgrade or expand applications that accomplish business operations and goals.
• Accessed multiple databases usingSASand provided ongoing reporting that supported information-based decision making and periodic CCAR submissions.
• Successfully migrated the model input process of Model Ready to pull data directly from RMI in EDW instead of pulling from an intermediate SAS repository (IDSL).
• Supported the production team by developing a Shell script that invokes different macros to produce monthly data that is used for CCAR submission.
• Developed production code for Financial Runs, like 10 year, 20 year, 30 year production runs that create the SAS datasets that are being used for further analysis and modeling purpose.
• Updated and modified the production code according to the dynamic requirements which are dependent on the scenarios like CCAR Base, CCAR Adverse, CCAR Severe.
• Updated and modified production code to generate SAS datasets for different Stress test scenarios such as S2, S3, S4 based on the macro economic variables (UER, IR, HPI etc).
• Generated NCL, UPB projections for class variables such as NCI, PCI, HFI, and HFS.
• Successfully migrated Model Ready from EDW to Teradata.
• Worked on Teradata Database environment to extract input data for various production process.
• Developed Utility Macros and extensively used existing macros for Validation, Analysis, Report generation and Integration of Data.
• Used Proc SQL extensively to merge, manipulate and summarize the data.
• Investigated missing data and the data anomalies by creating edit checks forimported SASdatasets.
• Customized the variables to user-defined Formats using PROC FORMAT.
• Documented and tested programs that were widely used for various data reporting tasks.

Environment: Base/SAS, SAS/Macro, SAS/SQL SAS/Connect, SAS/Graph, SAS/Access, Windows, Humming Bird Exceed, Teradata, DB2, UNIX & SAS/ENTERPRISE GUIDE

Confidential - Chicago, IL

SAS programmer/analyst

Responsibilities:

• Investigated missing data and the data anomalies by creating edit checks for SAS data sets imported from databases and other servers.
• Worked with business to gather requirements to create business requirement specifications for tables, reports, listings, and graphs.
• Extracted raw data from various data sources and to create datasets for all programmers in standard locations.
• Created data for dashboard, reports, analysis datasets, and graphs using SAS.
• Extensively used DATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Provided programming support to compress data from a multiple sources for each subject into a single table using Arrays and Do Loops.
• Manipulated large data sets, Increase programs efficiency and responsible for data entry and conversions, data validation and corrections.
• Extensively used SAS/CONNECT to use data from PC and Servers.
• Perform analysis of data for use in Cross-selling, created graphs using PROC GPLOT, GCHART. Created and updated permanent SAS formats for future analysis and reports,
• Created derived and analysis datasets which are one proc way for any statistical procedures to create listings or reports. Hundreds of new variables are derived using various functions and other techniques in SAS.
• Used various proc sql techniques to update datasets, combine, and join various datasets.
• Created new macros and updated existing macros in the current macro library to improve efficiency of old SAS programs.

Environment: SAS9.2, SAS/ODS, SAS Enterprise Guide 4.2, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, Db2, Teradata, MS Excel, MS Access, Windows.

Confidential

SAS BI Programmer

Responsibilities:

• Imported data from flat files, oracle database with the SQL pass-through facility and created analysis SAS data sets.
• Generated SAS batch programs and generate log files, list files and reports in desired directories by passing parameters using UNIX shell scripts.
• Performed data management functions including manipulation, validation, review and export to database, missing values were read using MISSOVER and TRUNCOVER options.
• Proficiently used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.
• Developed new SAS Macro programs to analyze the data and improve the reusability of the codes.
• Created Customized Reports using the Data Null technique created Analysis datasets, and performed validation before report generation using base SAS programming.
• Effectively utilized SAS procedures like PROC SQL, PROC FREQ, PROC MEANS and PROC REPORT for data analysis and generate reports, Ad-Hoc Reports for various business requirements.
• Responsible for accurate and timely data analysis and submissions.
• Estimated and performed feasibility analysis on every service request and accordingly negotiated and prioritized client requests after discussion with the Onsite Coordinator.

Environment: SAS 9.1.3, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, HTML, Oracle, Enterprise Guide Windows NT and UNIX, Teradata.