Summary:

• 7 years of experience in SAS Programming with Financial, Healthcare, Banking, Pharmaceuticals and Clinical industries.
• Experience working in SAS Business Intelligence BI platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes, DI Studio and Web Report Studio.
• Experience in Base SAS, SAS/Stat, SAS Macros, SAS/Graph, SAS/Connect, and SAS/Access on Windows and UNIX platforms and competence in carrying out statistical analysis of large-scale data.
• Experience in using data steps in SAS for creating, maintaining and manipulating datasets.
• Experience in using various statistical procedures in SAS such as Proc SQL, Proc Sort, Proc Freq, Proc Univariate, Proc Means, Proc Transpose, Proc TTEST and Proc Import.
• 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.
• Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA.
• Using ODBC to connect SAS System with relational database management systems, such as Microsoft SQL and Oracle, to retrieve data and create SAS datasets.
• Excellent experience with export SAS Results to different format, such as XML, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Proficient in creating and maintaining many datasets using Array, Merge, Update, Set and Proc SQL.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
• Self-motivated individual with strong technical analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Experience in analyzing the claims data, future trends and summarized results to generate recommendations for management.
• Have experience in different databases like Oracle, SQL Server, DB2, MySql and Teradata.
• Leverage technology and business process skills to generate innovative solutions to address client business problems.
• Extracting, transforming and loading data into data warehouse using SAS DI Studio for further analysis and reporting.
• Experienced in business terms like Basel compliance, equities, fixed income, and risk management.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Experience in Quality Center - design test steps, requirement mapping to tests, executing tests manually, defect logging, and defect reporting.
• Excellent communication, analytical and interpersonal skills.

Technical Skills:

• SAS skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide, Enterprise Miner, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Forecast studio, SAS DI Studio and Management Console.
• SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats
• Databases: MS Access, SQL Server, MySQL, Teradata, Oracle
• Operating Systems: Windows, Unix, Linux and Mac
• Software packages: MS Word, Advanced MS Excel, MS PowerPoint, SQL Plus
• Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, SAS Graph, MS-Excel, SAS BI Platform, MS-Visio, and MS-PowerPoint.

Professional Experience:

Confidential

Sr.SAS Programmer / Analyst

Responsibilities:

• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment
• Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.
• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables.
• Advanced analytics and reports created based on the criteria provided.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Automated the existing audit reviews and production.
• Performed approvals for peer audit reviews on reports by analyzing data.
• Developed SAS Macro programs to create ad-hoc reports.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• 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 Excel and RTF.
• Documented the code and algorithms logically.
• 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 9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SAS BI, SAS web reporting studio, SAS DI Studio, Oracle, MS Office, and Unix

Confidential

SAS Programmer/Analyst

Responsibilities:

• Created new and modified existing SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/ACCESS and SAS/CONNECT.
• Developed several ad hoc SAS programs to create summaries and listings.
• Customize the existing programs using SAS Macros as per the statistician's requirements
• Analyzed different drugs sales activity metrics and generated reports and graphical representation of these sales for comparison of different drugs using SAS/GRAPH and SAS/STAT. Used PROC GPLOT to create graphs in SAS.
• Experience in Clinical Data Analysis, Generating Statistical Analysis Files, Lists, Tables, Graphs, Validations, Documentation, FDA Electronic Submissions. Good Experience in Phase I, II, III Clinical Drug Trials studies.
• Understanding of drug development process conducting clinical trials, collection paper CRF, eCRF EDC, RDC , analyses and presentation of data
• Generated SAS Customized reports using the DATA NULL and PROC REPORT techniques.
• Involved in pooling of data from multiple studies and generating Tables/Listings/Graphs for Summary of Clinical Safety SCS for FDA Submission.
• Understanding of Bio-statistical work flow: Starting from Raw Datasets to creation of submission package i.e., CRT packages.
• Thorough knowledge and understanding of Code of Federal Regulations 21CFR Part 11, GCP, ICH, FDA and other regulatory guidelines.
• Excellent experience in Parallel and Cross-Over esp. Phase I study designs.
• Developed SDTM data mapping and created SDTM datasets per CDISC standards.
• Created TEMPLATES to modify the appearance of the displayed ODS tables using PROC TEMPLATE.
• Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC MACROS, PROC SUMMARY, PROC CONTENTS, PROC COMPARE and PROC UNIVARIATE.
• Performed data analysis on the data sets using PROC MEANS, PROC FREQ, and PROC UNIVARIATE etc.
• Developed summary reports using SAS PROCEDURES like PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE etc.
• Developed custom reports using Data Null
• Gave significant contribution in modifying or rewriting an entire report section using SAS MACRO, SAS/FUNCTIONS, PROC CONTENT, PROC MEANS, PROC FREQ, PROC TABULATE, PROC REPORT, etc. according to Oracle database format.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Used SAS extensively to create ad hoc reports.
• Used SAS Macros, PROC SQL to extract, sort, match test accounts and ODS to HTML, PDF and RTF.

Environment: SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/SQL ,SAS/STATS, SAS/GRAPH, MS-Excel, MS-Access, ORACLE , HTML, CDISC ,Java, Windows XP

Confidential

SAS Developer

Responsibilities:

• Extracted data from Oracle database warehouse .
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.
• Also created and maintained SAS datasets that are extracted from an Oracle Database using SAS/ACCESS for ORACLE and extensively used Proc SQL to manipulate the data.
• Used Proc SQL Pass-Through method and Proc Append methods to write statistical analysis results to the ORACLE database.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• Converted Excel tables and flat text files into SAS datasets for Ad-Hoc analysis.
• Data analysis, reports using SAS procedures and SAS/Macros.
• Used SAS/STAT to create different statistical reports as required.
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes.
• Forecasted monthly, quarterly and annually customers flow and revenue for Direct Mail Marketing and Tele-Marketing campaigns using SAS and Excel.
• Performed market research and segmentation analysis using SAS, SQL and Excel to get the potential target customers and identify the market trend and opportunities.
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• SAS Management console used to create metadata libraries.
• Developing SAS Stored Processes that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Information Delivery Portal.

Environment: SAS/ Base, SAS/ Macros, SAS/ Stat, Oracle, SAS/SQL, SAS/ ODS, SAS Enterprise Guide, MS office, Windows, Mainframes Z/OS, Unix

Confidential

SAS Developer / Analyst

Responsibilities:

• Extracted, transformed, and loaded data using SAS
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment
• Tested and automated SAS jobs running on a daily, weekly and monthly basis using Unix Shell Scripting
• Ensured the validity and accuracy of the analyzed data
• Created Unix scripts for file transfer and file manipulation
• Created stored processes that would generate ad-hoc reports based on parameters passed
• Coordinated with the other teams to deliver the data to the clients on time
• Extensively used Proc Print, Proc Report, and Proc Tabulate for reporting
• Used SAS/ODS to produce RTF and HTML reports
• Submitted SAS/SQL queries in Unix shell to validate data
• Presented process flow diagrams in MS word
• Raised queries on the existing Oracle and SQL Server databases to provide ad-hoc reports using SAS/SQL
• Involved in the development of different datasets according to the user specifications for various applications
• Analyzed the data for future trends and summarized results to generate meaningful recommendations to management
• Written Macros to develop a concise and reusable code.

Environment: SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, MS-Excel

Confidential

SAS Programmer

Responsibilities:

• Created reports of various types which include sales, consumption and usage all fuel types and services offered by the company to the fleet core.
• Monthly transaction data and annual balances of the credit accounts for all types of credit cards are reported in the month-end reports.
• Used SAS ODS and Proc Export steps to create all the reports as user interface was completely based on the Windows environment
• SAS Macros was used in generating reports with large but repetitive programs ,which only require variable changes were run in loops to save time and effort.
• Raw data files in Excel and RTF formats in SAS for invariably short or unrelated data requested for a report was used to append or merge in SAS to obtain desired reports.
• Experienced in handling Terabytes of records and manipulating them through SAS.
• Analysis included Fleet Size Analysis, Segmentation, Predictive Modeling, etc.
• Cleaned existing data and converted them into useful SAS datasets, merged datasets and created reports based on ad-hoc requirements.
• Extensively used Proc SQL and Select sub-queries to generate various reports by connecting to the Oracle DB.
• Used SAS data step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data to produce required reports.
• Created various summary reports of total dales, regional sales and account sales of various partners.
• Documentation, presentation, data reports and model results to the team/manager.
• Used various statistical procedures like Proc Freq, Proc Reg to analyze data and generate reports.
• Communicated with various personnel in the sales group and the statistical group for specific reports and presentations to new and existing clients.
• Reports with fuel data on the average price per gallon in their zip area, which would show the annual dollars they save and rewards received were developed to make clients understand the cards in an easier and better way.

Environment: SAS/Base, SAS Macros, SAS ODS, SAS/Graph, SAS Enterprise Guide, UNIX, SQL, MS Access, Excel, and Windows