PROFESSIONAL SUMMARY:

• Over 8+ years of extensive experience in SAS programming, Data analysis and Management Generating Reports, Tables, Listings and Graphs and Database Design, Development and Implementation and Reporting and Modeling.
• Expertise in SAS/BASE, SAS/MACRO, and SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Strong working knowledge in SAS and base SAS, SAS/Graph, SAS/Macro, SAS/ODS, SAS/Access, and SAS/SQL under Windows environment.
• Hands on experience in creating extremely interactive reports using SAS Visual Analytics.
• Skilled in working with relational databases (SAS Access to Oracle, MS - SQL Server, Teradata) and their integrations with SAS and R for analytics.
• Extensive use of open source tools such as R and python for statistical data analysis.
• Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Proficient with Importing Various External Data Files into SAS Dataset / SAS Library by using SAS/Access, SAS/In file, SAS/Import, and SAS/SQL.
• Experience in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Good exposure on SAS Data warehousing (ETL-Extraction, Transformation and Loading) tool- SAS Data Integration Studio.
• Ability to write SQL queries using PROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
• Customize the variables to user-defined formats using PROC FORMAT in printing reports.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
• Intermediate knowledge of advanced procedures including UNIVARIATE ANALYSIS, REGRESSION, GRAPH AND PLOT.
• Perform ad hoc analyses as per user guidelines and reports and transform data into various formats like CSV, EXECL, and ASCII.
• In depth knowledge of Iterative Software Development Life Cycle (SDLC) process, Agile Software Development and Waterfall models.
• Experienced in creating Data Mart using different transformation in Data Integration Studio (ETL).
• Excellent working experience in manipulating datasets: Cleansing, Merging, Sub-setting by using SAS data steps and procedures.
• Experience in developing, validating and implementing SAS programs and produce derived datasets for analysis and generating & documenting tables, listings and graphs for clinical study reports.
• Skilled in creating programs to validate dataset’s compliance to CDISC, SDTM and ADAM standards.
• Strong ability to manage and manipulate databases, program and generate reports according to user needs. Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel.
• Accustomed to working in challenging environments under deadlines, excellent analytical and problem-solving skills.
• Excellent Organizational, Teamwork, Presentation and Interpersonal Skills.
• Applying Critical Thinking, Problem Solving, and Decision-Making Skills, to Dismantle Complex Problems and Optimize Solutions.
• Extensive Experience using SAS Business Intelligence tools such as SAS Enterprise Guide, SAS Stored Processes, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS BI Dashboard and SAS Information Delivery Portal.

TECHNICAL SKILLS:

SAS: SAS v8, v9.1, 9.2, 9.3, 9.4, Base SAS, SAS/Macro, SAS/Access, SAS/SQL, SAS/STAT, SAS/Connect, SAS/GRAPH.

Languages: C, C++, MS Visual Basic5.0/6.0, SQL

Database Platforms: Oracle 8/9/10g, PL/SQL, MS SQL Server, DB2, DB2/400 and MS Access.

OS: UNIX, LINUX, IBM AS/400, MS Windows 95/98/NT/2000, SCO UNIX, Sun Solaris.

Others: MS Office, UNIX shell scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia Beach, VA

SAS Programmer

Responsibilities:

• Prepared new Datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/Base and SAS/ Macro facility.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Automating several SAS Reports by using Base SAS, Unix Shell Script, which will drop the reports in designated location at the scheduled date and time without any human effort.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS datasets by using Set and Merge for generating Reports and Graphs.
• Used SAS and SQL to perform ETL from Oracle database and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Prepared new Datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/Base and SAS/ Macro facility.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Automating several SAS Reports by using Base SAS, Unix Shell Script, which will drop the reports in designated location at the scheduled date and time without any human effort.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS datasets by using Set and Merge for generating Reports and Graphs.
• Used SAS and SQL to perform ETL from Oracle database and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Extracting data from the database using SAS/Access procedures and create SAS data sets.
• Developed SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS datasets.
• Performed QC (Quality Check) extensively on tasks performed by other team members.
• Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.
• Involved in establishing connections to different data sources (SQL Server, Teradata, Azure Cloud, and website data) and pulling relevant data from these source systems for data modelling.
• Created Data Mart's in SAS and loaded to Oracle.
• Wrote SQL Loader code in SAS using SAS as an interface to load the tables into the Oracle database.
• Developed Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROCFREQ and PROC CONTENTS to generate different reports and run metrics on different data sets.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
• Participate in statistical program validation and quality control activities.
• Performed data analysis, statistical analysis, generated dashboards, reports, charts, and graphs using SASVA.
• Developed SDTM domain specifications along with ADAM analysis specifications for standardized databases.
• Worked on advance querying the database using SAS Enterprise guide in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization
• Involved in creating ETL jobs in SAS Data Integration (DI) based on Technical Solution Document.
• Extracted data from Teradata and oracle and extensively used PROC SQL to manipulate data and per-formed joins on datasets.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Created and delivered recurring as well as Ad Hoc marketing campaign programming within stipulated time-lines.

Environment: SAS 9.4/9.3, SAS/BASE, SAS/REPORTS, SQL, SAS/MACROS, EXCEL, SAS/GRAPH, SAS/ STAT, SAS/ACCESS, SAS/CONNECT, Oracle, Windows, SAS Visual Analytics.

Confidential, Concord, CA

SAS Programmer/ Analyst

Responsibilities:

• Involved in design and development of entire life cycle of Revenue Attribution project.
• Prepared Functional Solution Document as part of Revenue Attribution based on the Business requirement document provided.
• Worked on Technical Solution Document, which included ETL designs for the SAS DI development.
• Design job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
• Perform Source system analysis on the available source data, which was needed as part of RTE Data Model design.
• Use SAS/BRM to integrate all the business rules and then invoke them back into SAS DI jobs.
• Design base tables structure, which will also be used for reporting purpose as well as in RTE.
• Created ETL jobs in SAS DI based on Technical Solution Document. These jobs included coded algorithm and rules created in SAS BRM.
• Working extensively in sorting, merging, concatenating and modifying SAS data sets in different environments Windows and Unix.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Solid understanding and proficient use of various procedures like proc SQL, proc summary, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc print, proc sort.
• Responsible for Programming in SAS using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Extracted, performed validation and generated SAS data sets from Teradata applied SQL Pass through
• Facility.
• Develop new macros for report generation using SAS/Macros as per the customer's requirements.
• Retrieving Millions of Records Using Different Procedures.
• Job scheduling using SAS Management Console and monitoring jobs using Process Flow Manager and using commands on Unix.
• Involved in code migration across multiple environments. Maintenance of all the Table scripts needed during Migration.
• Done code and data validations while moving across multiple environments

Environment: SAS/Base 9.3, SAS/Access, SAS/SQL, SAS/Data Sets, SAS/ETL, SAS DI Studio, SAS/ Enterprise Guide, MS office, SAS/ODS, Teradata, Oracle and Unix.

Confidential, Cleveland, OH

SR SAS DEVELOPER

Responsibilities:

• Involved in merging and summarizing data using SAS to acquire tables, reports and results on account/household unit values and client profiles.
• Created SAS data sets by extracting data from Oracle tables using SAS/SQL and SAS/ACCESS and prepared them for Statistical Analysis.
• Implemented enhancements to the current ETL programs based on the new requirements using SAS DI Studio.
• Creating SAS data sets from flat files, excel files and updated datasets using LENTH, SUBSTR, SCAN, FIND, INDEX, TRANWRD, INPUT, PUT and COUNT functions.
• Participated in optimizing the code to reduce the processing times.
• Developed and Updated Macro programs code using SAS Enterprise Guide stored processes.
• Performed QC Checks for variables and Automated the QC validation by creating macros.
• Extensively used SAS/Graph to create graphical reports for sales analysis.
• Created reports using SAS /ODS and SAS /Views from oracle database tables into different formats like HTML and RTF.
• Designing, developing and implementing the DI Studio job flows to load the data into Oracle.
• Uses SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data.
• Created customized report using PROC TEMPLATE in spreadsheet with footnotes, titles and page numbers.
• Maintenance and upgradation by incremental code delivery on existing software programs to increase operating efficiency or adapt to new requirements.
• Work with client business partners and business analysts to review and vet mapping specification documents.
• Interact with architects to assist in high level design as per SAS best practices.
• Create low level design documents that adhere to the client standards as well as SAS performance recommendations.
• Data cleansing- Created SAS pre-processor programs to receive and cleanse files received from external sources for data load and control sum checks.

Environment: SAS/BASE, SAS BI, SAS Web Report Studio, SAS BI, SAS/SQL, SAS/MACROS, SAS/ STAT, SAS/GRAPH, SAS Enterprise Guide, SAS/Access, SAS VA, SAS MANAGEMENT CONSOLE, Map Information Studio, SAS Web Report Studio, SAS/DI, SAS INFORMATION DELIVERY PORTAL, CONTROLM, ETL Microsoft Access, Oracle 8i, UNIX

Confidential, Reston, VA

SAS Administrator

Responsibilities:

• Generated statistical reports. Technologies like Oracle and SAS were used for creating reports.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Used concepts, practices, and procedures within the BI reporting field.
• Used Web client applications of the SAS Enterprise Business Intelligence Server provide the means to create, share, and personalize SAS BI content while providing a secure framework to aggregate content with custom dashboards and alerting.
• Created reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Created SAS Customized Reports using the Data Null technique.
• Developed routine SAS macros to create tables, graphs and listings.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Used Proc REPORT to generate reports. Developed annual reports based on existing data.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets and/or ASCII files.
• Converted ORACLE data tables into SAS data files using SAS SQL 'Pass Through Facility,' and uploaded SAS data files into ORACLE tables using SAS 'dB load' procedure.
• Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Created and implemented statistical analysis plans and specification documents, participated in database design, data collection guidelines, and logic checks.

Environment: SAS 9.2/9.3, SAS/base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, MS-Excel.

Confidential

SAS Programmer

Responsibilities:

• The responsibilities involve providing support for develop, maintenance and enhancement of CAO applications from offshore. Changing the business logic depending upon the client requirements. The responsibilities involve the following.
• Developed SAS programs to create SAS datasets from
• Different Sources like SQL server, Oracle, Excel, text, CSV files.
• Responsible for Checking The completeness, accuracy and consistency of the data.
• Performed Data Validation, Data cleansing and Integrity checks using SAS MACROS and DATA steps.
• Performed QA on SAS programs.
• Conduct and Present Multivariate Statistical Analyses and Market Segmentation/Optimization Studies to Support Product Marketing/Sales, Structuring Analyses.
• Designed and Implemented Analytic and Statistical Multivariate Modeling Solutions for Market Research.
• Successfully used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Perform the integration testing.
• Conducting code review.
• Developing test plans with user input.
• Extensive experience on Documenting process steps to support future process development and product offering.

Environment: Base SAS, SAS/SQL, SAS/ACCESS, SAS/MACROS, SAS/ODS, MS Excel, MS Access, MS Visio Enterprise guide, Knowledge Studio, MSSQL Server.