SUMMARY:

• 7 years of experience as a SAS programmer working in banking and insurance sectors. My work focused on analysis, developing, design, testing and implementation of various projects.
• Extensive experience in BASE SAS, SAS/EG, SAS/DI Studio, Web Report Studio, SAS/MACROS, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/CONNECT, SAS/SQL, SAS ODS on Windows and UNIX environments.
• Successfully handled responsibilities for extracting internal/external data, data cleansing, and validation, data migration, analysis, and report generation.
• Experienced working on databases such as MS Access, SQL Server, Oracle, DB2, Teradata.
• Strong knowledge in data warehousing and modeling concepts.
• Experienced in UNIX shell scripts for back up and running batch files.
• Experienced in loading flat files to RDBMS by writing fast load scripts.
• Experienced in writing JCL programs for batch submissions.
• Excellent knowledge in SAS Programming like creating SAS data sets, utilizing macro facility for recurring code, various procedures, SAS Formats and Informats, SAS functions, data warehousing and OLAP applications, storing and managing data in SAS Files.
• Extensive experience with concatenating, interleaving, and merging SAS datasets.
• Excellent command in producing reports using various SAS procedures like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Means, Proc Transpose, Proc SQL, etc.
• Developed OLAP cubesthrough OLAP cube designer for further analysis.
• Experienced with using Add-In for MS Office to gather data for analysis and generate the reports.
• Connected to metadata server using Data Integration Studio which facilitated in cleansing, migration and synchronization of data for various applications.
• Created, organized and distributed reports using Web Report Studio.
• Accessed reports, charts and documents using Information delivery portal.
• Created and maintained an integrated environment using SAS management console across multiple platforms.
• Created stored processes and scheduled them using SAS EG.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Knowledge in regression analysis, linear models, data reduction models, cluster analysis, sampling theory.
• Excellent skills in diagnosing and avoiding errors, understanding and enhancing output to furnish reports.
• Knowledge and experience of Microsoft tools like SharePoint, Word, PowerPoint, Excel.
• Good analytical skills, understanding a business domain coupled with excellent teamwork and communication skills.

SKILLS:
Software: Base SAS, SAS/EG, SAS/DI Studio, Web Report Studio, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL.
Languages: C, SQL, HTML, XML.
Databases: SQL Server, Oracle, MS Access, Teradata.
Scripting: JavaScript,Shell Scripting
Tools: MS SharePoint, Excel, Word, PowerPoint.
Operating systems: UNIX, Windows, Mainframes.

Client: Confidential, CA Aug 10 Mar 12
Position: Marketing Database Analyst
I was responsible for developing campaign lists for direct marketing programs which support Home Equity line and loan products.
Responsibilities:

• Worked closely with the direct mail Program Managers, Statistical Modeling team, Risk team and the Print Production team to develop and translate list criteria into marketing lists (e.g. mail, email and dialer files).
• Modified existing SAS code to extract data from internal databases according to the criteria document provided by Program managers using SQL and SAS/Enterprise Guide.
• Performed data analysis using SAS and generated waterfall report, mail files, email files and telemarketing files which have a list of customers targeted for specific campaigns.
• Provided prompt and accurate back-end support to ensure output files (mail file, email file, telemarketing files, etc.) are shipped to mail shops/end users in a timely manner.
• Maintained proper documentation of campaign coding and design logic.
• Modified and generated standard auditing reports to clients and audit team using SAS or SQL.
• Performed auditing of the audit reports generated by team members.
• Worked with modeling team in stratification of data, created treatment and control groups which were later helpful for modeling team in tracking responders.
• Generated adhoc reports for program managers and other team members.
• DevelopedShellscripts for recurring SAS jobs and scheduled them on Crontab.
• Updated my tasks and uploaded files to Campaign management tool called Aprimo.
• Updated campaign history table with the campaign data.

Environment: Windows, UNIX, Shell scripting, DB2, SQL Server, Teradata, SAS/Enterprise Guide, SAS/Macros, SQL.

Client: Confidential, NC Aug 09 Jul 10
Position: Business System Analyst
As a Business System Analyst, I was responsible for designing workflow on extracting, transformation and loading of the data from internal databases into SAS environment for risk management team.
Responsibilities:

• Designed and documented workflow by translating business requirements into technical specification for developers.
• Extracted raw data from internal and external data sources.
• Supported modeling and analytic programs through the creation of SAS datasets.
• UsedSAS Data Integration Studioto perform ETL functions, build process flows, and created business rules in metadata.
• Advanced querying usingSAS Enterprise Guide to manipulate and prepare data for summarization, reporting, and statistical analysis.
• Extensively used SQL for accessing databases, creating ad-hoc reports and graphs as per the requirements.
• Automated and validated the workflow design, documented the whole work, presented results and reports as requested by project management team.
• Created and maintained the documents in specific libraries on team site and granted user access using SharePoint.

Environment: Windows, UNIX, Shell scripting, Oracle, Teradata, SAS/Enterprise Guide, SAS DI Studio, SAS/Macros, SQL, SharePoint.

Client: Confidential, KY Oct 08- Aug 09
Position: SAS/Data Analyst
Involved with the update and maintenance of the data warehouse and generation of various health insurance reports by extensive use of Base SAS, SAS/Access, SAS/Macros, SAS/ODS and SAS/Reports.
Responsibilities:

• Worked with regulatory reports in PL/SQL and SAS.
• Experience working with medical claims domain, datasets, and coding techniques.
• Produced technical specification by analyzing the business and functional requirements.
• Modified and delivered existing code that meets functional requirements within agreed specifications and timescales.
• Ensured delivered code is maintainable and supportable.
• Accessed flat files using SAS/ACCESS as well as performed other SQL operations.
• Performed SAS programming using SAS Base and SAS Macros for loading data from ORACLE tables to SAS datasets and for generating reports on daily and fortnight basis.
• Used SAS extensively for match merge, append data validation, and data correction and cleansing.
• Generated reports based on requirements using Proc Report, Proc Tabulate, Proc Print and Data _Null_ and outputs presented in PDF files.
• Produced weekly and monthly-customized reports by using PROC TABULATE, PROC REPORT.

Environment: Windows, UNIX, Shell scripting, SQL server, Base SAS, SAS/Macro, SAS/Stat, SAS/Graph, SAS/Connect, SAS/Access, SAS Enterprise guide.

Confidential, India Aug 06 - Sep 08
Position: SAS Programmer
Compared and analyzed trend and related information to create customer SAS datasets and flat file for modelers. These datasets were used for capturing new customers through direct mail and telemarketing.
Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Identified and selected the best functions that can be applied to specific business problems.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
• Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical procedures using PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS.

Environment: UNIX, Shell script, Base SAS, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, Oracle.

EDUCATION: Bachelors in Computer Science