SUMMARY

• Over 7 years of extensive experience in SAS performing advanced programming and BI Development including data extraction and manipulation, writing macros and reporting, with major financial institutions.
• Extensive experience as a SAS programmer with SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ETL, SAS ODS & Enterprise Guide (EG)
• Extensive experience in using SAS Enterprise Guide in developing stored processes and performing statistical analysis.
• Strong knowledge of testing methodologies at all stages of Software Development Life Cycle (SDLC)
• Experienced in preparation of SAS datasets, Tables, Listings, Graphs, Reports, and summaries according to requirements and Standard Operating Procedures (SOPs)
• Experienced in building OLAP cubes, web reports, dashboards and Portlets using SAS BI tools.
• Expert level skills in SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/SQL and MACRO.
• Experienced in utilizing SAS Procedures, Macros and other SAS applications for data updates, data cleansing and reporting.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Experience in using SAS to read, import, and export to other data file formats, including delimited files
• Experience in generation of various periodic and ad - hoc reports for various analyses
• Thorough knowledge in SAS Programming, merging SAS Data Sets, Reading Flat File into SAS, SAS Functions, Preparing Data to generate Reports using PROC REPORT and PROC TABULATE
• Extensive experience working with different databases including Oracle, Teradata, DB2 and MS SQL Server. Highly motivated, Organized Team player with excellent analytical and communication skills.

TECHNICAL SKILLS

SAS Skills: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/ CONNECT

Database: Oracle/8x/9x/10g, Sybase, Teradata, MS-Access, MS SQL Server, DB2 and Netezza

Languages: SQL, PL/SQL, Shell Scripting, Tools SAS Enterprise Guide, Web Report Studio, Information Map Studio, OLAP Cube Studio, SAS Management Console, Information Delivery Portal, SAS Add-In for MS Office, JMP, Tableau

Operating: Windows (XP/7) and UNIX

Others: MS Office, MS Project, Power Point, Excel, Outlook and Access

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

SAS Programmer

Responsibilities:

• Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs. Modified the existing programs according to the new business rules.
• Work cross functionally with all departments of the service center to solve purchase order, invoice and inventory discrepancies (supply chain Management)
• Apply Forecasting and Analytical Methodologies, and contribute to its ongoing continuous improvement.
• Participate in application design and architecture discussions and assess the impact and applicability of forecasting to client's business problem solutions.
• Complete all levels of application testing and Q&A, and prepare all required documentation;
• Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc.
• Ran the monthly and quarterly maintenance jobs on the mainframe.
• Worked within the SAS BI Enterprise utilizing an Oracle database and Windows server environment
• Documented the run instructions for two different processes in a project.
• Participated in designing, coding, testing, debugging and documenting SAS Programs
• Created RTF, PDF, HTML, LISTING, etc. using Output Delivery System (ODS)
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes
• Converting existing Cognos reports to SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports using SAS Web Report Studio.
• Created SAS Customized Reports using the Data Null technique for FDA evaluations.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions and maintained existing ones.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining. Validated programs and databases.
• Created SAS programs using Proc Report, Proc Summary to generate reports on patients who deviate from protocol specifications.
• Served close with the statistician and make sure everything is in right place.
• Used various ODS outputs depending on the client requirements and provided with a fine framework for FDA submission

Environment: Base SAS, SAS MACRO, SAS Enterprise Guide, UNIX, SAS GRID, Visual Analytics SAS/SQL, SAS/STAT, SAS/GRAPH, and Windows

Confidential - Charlotte, NC

SAS Programmer

Responsibilities:

• Developed complex SAS macros to simplify SAS code and effectively reduce coding time
• Interacted with Risk Managers and Analysts to define targeted customer segments
• Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Extract, transform and load datasets with basic modeling variables for each segment type Using PROC IMPORT and SQL queries, imported data from Oracle database into SAS files
• Manipulated and updated the tables as per specifications
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
• Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
• Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE
• Maintain and enhance existing SAS reporting programs for marketing campaigns.
• Produce SAS Graphical reports showing Trend Analysis charts for campaign
• Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code.
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
• Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
• Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
• Used PROC/SQL and SQL -pass-through mechanisms
• Assisting in the analysis, design, and development of tables, Excel files and ad-hoc reports.
• Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
• Interface with users, business analysts and other department heads to gather information and requirements. Developed databases and specifying specific data requirements.
• Involved in writing the TDR's and FDR's for any new change or enhancement

Environment: SAS 9.0, SAS/Base, SAS/Macro, SAS/SQL, SAS/OLAP, SAS Enterprise Guide, SAS/STAT, Web Reports Studio, MS-Excel, SAS GRID, Visual Analytics and UNIX Sun Solaris.

Confidential - Memphis, TN

SAS Programmer/Analyst

Responsibilities:

• Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/Access and SAS/Connect.
• Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC REPORT, PROC COMPARE and PROC UNIVARIATE.
• Extensively used Teradata tables for SAS datasets.
• Wrote various SQL queries, PROC TRANSPOSE and PROC COMPARE procedures.
• Developed and improved the efficiency of programs through the use of SAS macros and SAS/SQL.
• Listings, derived datasets, and control checks. Program the integration of databases from multiple studies or sources.
• Writing Procedural Language SQL (PL/SQL) query for data manipulation and data analysis.
• Created new and modified existing SAS programs to load data from the source and create specific datasets, which are used as source datasets for report generating programs.
• Modified standard programs to generate data sets for statistical data analysis, generate listings, summaries.
• Wrote wrapper Unix Shell scripts for execution of SQL / PLSQL and SAS scripts from Unix.
• Slicing and dicing the data from unorganized data files. • Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.
• Formatted HTML, RTF and PDF reports, using SAS Output Delivery System (ODS).
• Worked on Ad-hoc, monthly reports on a regular basis using SAS EG 4.3.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file.

Environment: SAS EG 4.3, SAS/Base 9.2, SAS/Graph, SAS Script, SAS server Winscp, SAS/ETL, Teradata SQL Assistant, SQL, SAS Macro Coding, Teradata, RDBMS, Toad, MS Access and MS Excel.

Confidential - Washington, DC

SAS Programmer

Responsibilities:

• Working on the Troubled Debt Restructuring project for the RBS Citizens Bank of Rhode Island using SAS 9.2 environment.
• Writing advanced SAS programs involving macros, SQL joins merges, prompts and building Enterprise Guide projects.
• Translate user data and reporting requirements into SAS programming language.
• Performing Ad-hoc querying, reporting and data management.
• Working with relational databases such as DB2 and MS-Access and SAS storage server SPDS.
• Working with different kinds of financial data including credit cards, student loans, small business, and treasury, automobile.

Environment: SAS 9.2, Enterprise Guide 4.3/4.2, ODS, DB2, SAS GRID, UNIX, Visual Analytics, SPDS, MSAccess, Windows 7

Confidential

SAS programmer

Responsibilities:

• Analyzed the data based on the requirement
• Analyzed large data sets consisting of million records
• Creating a customer statistical 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 analysis for the products purchased every month.
• Conduct individual account and household level analysis.
• Conduct significance tests and study response rates for different level of Marketing based on the reports.
• Modified existing SAS programs and created new programs using SAS Macro to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Performed Data cleaning, Formatting, Cluster analysis, and regression analysis for normality using SAS.
• Created reports using analysis output and export them to the web to enable the Customers to have access through SAS Integration.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.

Environment: SAS/ Base, SAS/Macros, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, MsExcel, Oracle 8i, Unix, Pl/SQL Developer.