PROFESSIONAL SUMMARY:

• Over 6 years of Professional Experience in Software Development in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, JMP, OLAP Cubes and Web Report Studio.
• Experience in working with SAS on different platforms like UNIX and Windows.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/EG, SAS/Share, SAS Enterprise BI Server, SAS Management Console.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Have strong working knowledge on Anti money laundering Act.
• Extensive programming experience with Proc SQL, Proc Report, Proc Tabulate, Proc Datasets, Proc Format, Proc Print, SAS/STAT procedures such as Proc Freq, Proc Means, and Proc Univariate.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Experience with retail data, banking data and credit card.
• Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in data manipulation procedures such as formats/informats, merge, proc datasets, proc sort, proc transpose and proc rank.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Experience with predictive modeling, business analysis, statistical modeling, multi-variate statistics and logistic regression.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Resourceful, able to find solutions when faced with challenges.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9.3/9.2/9.1.3 /8.2/8.1/6 (mainframe), SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS Graph, SAS Enterprise, SAS Business Intelligence (BI) platform and SAS EBI.

Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise, SAS GRAPH, AXUM, MS-EXCEL, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-Visio, MS-PowerPoint

RDBMS: SAS/SQL, SAS/Enterprise, SAS BI Platform, DB2, MS-Access, Microsoft SQL Server, MySQL.

Languages: SAS, SQL, HTML.

Operating System: Windows, UNIX, MAC OS, DOS.

Batch Server: UNIX, Putty, SSH, SAS scripting.

Web Server: MS-FrontPage, HTML, Linux, Apache Server

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. SAS Programmer/Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Created new or modify SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
• Was involved in benchmarked the effectiveness of AML data. Identified the potentials for performance improvement.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Wrote SAS reports to Excel, the SAS content server, HTML, and PDF.
• Wrote stored processes to be used through the SAS Information Delivery Portal
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Frequent Use of functions and Proc Format.
• Created reports in the style format using ODS statements and PROC Template.
• Design SQL query to select, create, append, and update database tables and views.
• Developed numerous ad-hoc SAS programs to create summaries and listings.
• Created SAS Macros and SAS Graphics. Customize the existing programs using macros as per the statistician’s requirements
• Generated SAS Customized reports using the DATA NULL and PROC Report techniques.
• Coordinated transition of new reports to production from SIT and UAT
• Identified and implemented process improvement and automation initiatives
• Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.
• Scheduled SAS jobs in UNIX environment.

Environment: SAS 9.3, SAS/Base, SAS/Graph, SAS/Stat, SAS/SQL, SAS/ODS, Excel, Oracle 11g, Windows, SAS Enterprise Guide, SAS Web Report Studio, SAS Information Portal, SAS Information Map Studio, OLAP and EBI Servers.

Confidential, Boston, MA

SAS Programmer/ Analyst

Responsibilities:

• Developed and designed SAS programs/macros to analyze data and creating files, tables, listings, and graphs.
• Used SAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions.
• Create detailed business and technical documentation for individual projects.
• Maintain and contribute to the modulated software development environment for loss prevention.
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Followed CDISC standards to clinical trial data through converting raw datasets to SDTM datasets with reference of mapping documents prepared by following SDTMIG.
• Involved in creating specifications documents for SDTM and ADAM using annotated CRFs, SAP, mock-shells and Implementation guide.
• Performed quality checks and created analysis datasets in SAS.
• Analyzed and summarized safety and Efficacy data associated with Phase I, II and III of clinical trials for the different therapeutic area.
• Carried out SAS/Base Coding along with use of SAS/MACRO to produce the standardized dataset for Clinical Data.
• Used different SAS/STAT procedure such as Proc Sort, Transpose, Freq, Mean, Report, Summary, Univariate, etc. to manipulate, analyze and report the data.
• Worked on Integrated Summaries of Efficacy (ISE) and Safety (ISS) reports.
• Created and modified analysis datasets according to the specifications and requirements mentioned in the SAP.
• Good working knowledge on data like Demographic (DM), Adverse Events (AE), Serious Adverse Events (SAE), Laboratory Data (LAB Data), PK parameters.
• Generated various TLGs in the domains of demographics and baseline characteristics, treatment exposure, adverse events, vital signs, laboratories, patient disposition.
• Performed validation of SAS programs producing analysis datasets, tables, listings, graphs for clinical trial reports.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on requirements.
• Experience in using SAS report generating procedures like PROC REPORT, PROC SQL, PROC TABULATE, PROC TRANSPOSE, PROC SUMMARY
• Optimized performance using data validation and cleaning on clinical trial data using statistical procedures like PROC FREQ, PROC ANOVA, PROC MEANS, and PROC UNIVARIATE.
• Automated the existing audit reviews and production.
• 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.
• Created dynamic Macro arrays by SQL and with data step programs.
• Delivery of customized information to users within and beyond the enterprise using SAS portal.
• Modeling of data using SAS/STAT using Logistic Regression.
• Performed data preparation, graphical presentation, Statistical Analysis, Testing, Validation, reporting, and documentation using SAS tools and SAS Portal.
• Extracted data from different sources like Teradata, Excel files and text files using SAS/Access, SAS SQL procedures and Proc import functions.

Environment: SAS 9.2/9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, Oracle, MS Office, and Unix

Confidential, Jersey city, NJ

SAS Programmer

Responsibilities:

• Extraction of data from Oracle, created into datasets.
• Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures and Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Produced RTF, MS Word and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
• Managed the migration of the existing DW databases from DB2 and Sql Server to Greenplum (Big Data/Data appliance) by EMC Vendor
• Developed SAS Macros for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes.

Environment: Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, DB2, MS Excel, SAS BI, Teradata and UNIX.

Confidential, SLC, UT

SAS Developer

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Done Enhancements for the existing business reports like incorporating new business variables.
• Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
• Uploading data into the warehouse application on monthly basis.
• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables and listings.
• Worked extensively in sorting, merging, concatenating and Dynamic Formatting as optimized technique for SAS data sets.
• Cleaning of data using SAS Procedures like Proc Freq /Proc Univariate.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.
• Transformations using Base SAS Procedures and Functions.
• Migrated Main Frame JCL jobs into Unix Shell Scripting for running SAS nightly jobs.
• Extensively used ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup (Connected and Unconnected) to load the data.
• Extensively involved in designing and developing of Star Schema Model for Data Store.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, DB2, Java, Cognos, SQL, Teradata, XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, and Oracle 8i/9i, SQL Server 2000, Mainframe, SunOS 5.8, DTS, Erwin, and Windows XP.