SUMMARY

• Over 8 years of extensive SAS programming experience in pharmaceutical and CRO Industries.
• Extensive experience in SAS (9.1.3, 9.1, 8.2 versions) programming and data analysis in Windows, UNIX and Mainframe environments.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Thorough understanding of Software Development Life Cycle and its various stages.
• Experience in processing large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries
• Expertise using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, MS Office tools.
• Expertise in using various SAS procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Proficient in developing procedures, functions and stored packages using PL/SQL
• Strong experience in extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries.
• Extensively used UNIX shell scripting and Windows batch files.
• Proficient in developing procedures, functions and stored packages using PL/SQL.
• Expertise in creating stored processes, information maps and web reports using SAS Enterprise Guide, SAS Information Map Studio and SAS Web Report Studio.
• Performed Data Extraction, Data Transformation and Data Loading using SAS/ETL.
• Strong communication and presentation skills. Detail oriented and able to multi - task effectively.
• Worked effectively as a team player as well as an individual to meet deadline.

TECHNICAL SKILLS

Operating Systems: Windows 7, Vista, XP, 2000, Unix, MS-DOS

Statistical Software: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/Access, SAS/Assist, SAS Enterprise Guide

Programming Languages: C, C++, JAVA, SQL, and Visual Basic 6.0

RDBMS: MS Access, Oracle Clinical

Application Software: MS Office (Word, Excel, Power Point, Access).

SAS Procedures: Sort, Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary, anova, logistic, glm, mixed, Reg, SQL, Copy, gslide, upload, download, Printto, Datasets, Format, Boxplot, freq.

Tools: MS Access, Excel, Word, PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Golden Valley, MN

Sr. SAS Developer

Responsibilities:

• Documented the Business Process and Business Functionality, and translated them to requirement specifications document via specific tool
• Extract the data from raw txt files, and different database like (Oracle, Sybase) through LIBNAME and SQL Pass through facility
• Developed stored processes, information maps and web reports using SAS Enterprise Guide, SAS Information Map Studio and SAS Web Report Studio
• Worked on existing and developing new store processes in SAS EG on SAS eHP portal in all environment severs
• Extensively used Advance Macros for developing store process in SAS portal
• Worked on java script to create a page on SAS portal to run report
• Used DB visualizer to analyze and query from the ORACLE and SYBASE
• Used SAS Data Step logics to Sort, Merge, Stack, Update, Array, Retain and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• Used Excel tag set xp to create multiple worksheet in XML version of report in MS Excel
• Used various MACRO functions such as MPRINT, SYMBOLGEN, MLOGIC to Debug store process and SAS code
• Create different types of output files in different format like PDF, EXCEL, HTML and TEXT DELIMINATED FILE
• Extensively performed Data Cleansing during the ETLs Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Having a good knowledge of other reporting tools such as SSRS.

Environment: SAS, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Burbank, CA

SAS Developer

Responsibilities:

• Did Data Analysis to understanding the data from different source system
• Analyzed various database containing sales, titles, account, region etc data of the releases of various titles
• Developed Mappings between Source and Target and loaded the data and Validated Data for missing values and based on the requirements
• Used SQL Assistant to analyze and query from the Teradata DB
• Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Teradata DB
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements
• Used Business Objects (BO) for maintaining various Databases of the Data Warehouse and for generating SQL Queries and experienced in handling Terabytes of records and manipulating them through SAS using the Data Transformation
• Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets
• Extensively used PROC SQL and MACROS with SELECT sub-queries to generate various reports by connecting to the Teradata DB
• Documentation, presentation, data reports and model results to the team/manager
• Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ROBUSTREG, PROC ANOVA, PROC GLM to analyze data and generate reports
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.

Environment: SAS, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Chicago, IL

SAS Analyst

Responsibilities:

• Identifying user requirements, functional specifications and business rules to design, develop and implement effective Management Enterprise Data Warehouse for data analysis and reporting purpose
• Planned, coordinated and managed campaign tasks with the database and data warehouse teams to build campaign management process
• Work closely with our Team to design and build dimensional data models (star schema) and OLAP cubes
• Validate data from the star schema in data warehouse to transactional database
• Analyze market, product and customer data and consistently communicate key findings campaign effectiveness.
• Designing technical specifications for Dimensional, Fact and Level tables to load the target data warehouse
• Mapping data from business source systems (ORACLE, SQL Server & raw-data-files) to target systems (Enterprise Data Warehouse / Data Marts)
• Creating SAS datasets from different databases on multiple platforms
• Designing OLAP cubes (Schema - Dimensions, Aggregates, Facts, Level Tables and Hierarchies)
• Design document and build back-end technical requirements for front-end reports
• Produce Ad-hoc reports from SAS Enterprise Guide and SAS Add-In for Microsoft Office
• Administering SAS 9 Environment using SAS Management Console for development environment
• Create table metadata for source and target tables and created jobs to populate the target tables by applying various transformations(SCD Type 2 Loader, SQL Join, Splitter, Surrogate Key Generator, Key Effective Date) by using SAS Data Integration Studio
• Created Information Maps from SAS datasets and OLAP cubes for browser clients like SAS Web Report Studio to access data
• Created SAS OLAP Cubes across multiple dimensions for front-end report development purpose. Accessed OLAP Cubes from SAS EG and SAS Add-In for Microsoft Office for creating ad-hoc reports

Environment: SAS, SAS server, SAS Cube Studio, SAS EBI/DI Studio, SAS ETL, SAS EG, SAS OLAP, SAS Information Delivery Portal, SQL Analyzer, RDBMS, and SQL server.

Confidential, Norwich, NY

SAS Consultant

Responsibilities:

• Participated in determining the criteria for International Transfer Pricing based on SAS Predictive Modeling tools.
• Worked with large customer response and sales data sets and presented results to the users. Simultaneously tested the integrity of the mails, addresses in the database.
• Experience in designing, developing, and maintaining synchronous and asynchronous internal and external interfaces and associated secure data transfer protocols and mechanisms.
• Experience with the customer leverages Enterprise Guide (EG) and used Enterprise Miner (EM) to develop predictive models which consist of decision trees, logistic and linear regressions.
• SQL experience in a SAS environment, i.e. SAS/SQL to include joining tables to extract data.
• Used proprietary statistics tool to test how the marketing campaigns fared. This included measuring the sales lift attributable to a specific marketing campaign, comparing similar campaigns across multiple tracking windows etc.
• Worked on transforming data into OLAP cubes, web reports.
• Created Stored Processes for the business to generate different ad-hoc reports
• Have experience creating information maps which would be utilized by web report studio to generate static reports.
• Hands-on experience on validating the data.
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).
• Automated the standard reporting with SAS BI and Microsoft Add-in.
• Extensively used Proc Print, Proc Report, and Proc Tabulate for reporting and communicated analysis results to the marketing team. Used other SAS functions such as Proc SQL (queries), Proc Append, Merge, Macros, and Import and Export. Used SQL Pass through Facility to create and update Teradata and Oracle tables.
• Developed and used Scripts to schedule SAS Jobs.
• Developed queries on the existing Oracle and SQL server databases to provide ad-hoc reports using SAS/SQL for marketing department use. Coordinated analyses involving customer information, campaign response data, and demographics.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, Excel, UNIX, Windows, SQL Server, SAS Enterprise Guide.

Confidential, Minnetonka, MN

SAS Analyst

Responsibilities:

• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS. Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing.
• Extensively used SQL statement functionalities for analysis of large datasets and for data manipulation
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading. Created permanent formatted SAS data sets for present and future analysis
• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informat to read these data files
• Extensive worked on detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system
• Created and modified Korn-shell scripts on UNIX to schedule the program to run on daily, weekly and monthly basis
• Wrote Korn-Shell Scripts performing various steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and SAS/MACROS
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS

Environment: SAS, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.