SUMMARY

• Over 8+ years of experience in SAS programming / SAS DI/ SAS BI Content Development in areas including design, development and implementation and administration of business applications and analysis using SAS BI tools.
• Expertise Using SAS/BASE, SAS/ODS, SAS Enterprise Guide 7.1, SAS Data Integration Studio 4.2, SAS Information Map Studio 4.2, SAS Management Console 9.2, SAS BI Dashboard 4.2, SAS OLAP Cube Studio 4.2.
• Experience in Extraction, Transformation & Loading of data from multiple sources into Data Warehouse. Worked on various sources like SQL, Oracle, Excel, and Flat Files.
• Expertise in processing large datasets with millions of records for data transformation and data modeling including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Strong experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.
• Strong skills in Developing SAS Programs for Data Analysis & Data Requirement Analysis.
• Experience in generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Expertise with PROC SQL, SAS arrays and SAS Macros.
• Thorough experience in extracting data from various disparate data sources like (XLS, CSV, TXT) files, Oracle, SQL Server, MS - Access, etc. Ability to analyze & process data using various SAS procedures such as utility procedures, report procedures, statistical procedures.
• Experience in data transfer between servers and third party vendors using FTPs and SFTPs through SAS program.
• Designing jobs, creating the functional test plans, source to target table mapping, deployment and scheduling of jobs.
• Excellent programming skills in extracting and loading the data into various RDMS like Teradata, Oracle, SQL Server, DB2 with specific bulk load techniques.
• Hands on experience and thorough understanding of SAS Enterprise Business Intelligence toolset and its configuration on windows platform.
• Able to work independently as well as good team player and interact with all levels of management.
• Possess good communication skills, self-motivated, proactive, task oriented and quickly adapt to new technologies/ processes/ methodologies.

TECHNICAL SKILLS

Operating Systems: Windows 7, Vista, Unix.

Software: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH,SAS /ODS, SAS/Access, SAS Enterprise Guide, SAS Business Intelligence, SAS DI Studio, SAS Management Console, SAS Information Map Studio, SAS OLAP Cube Studio.

Programming Languages: SAS, SQL.

RDBMS: Teradata, DB2, Oracle, MS Access, SQL server

Application Software: MS Office (Word, Excel, Power Point, Access), JIRA, Agile, Waterfall, SQL Assistant, Teradata Viewpoint, Toad Data Point, SFTP, FTP

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SAS BI Developer / DI ETL Developer

Responsibilities:

• Daily activities include data preparation, extraction, manipulation and data analysis using SAS.
• Used SAS Data Integration Studio to develop various job processes for ETL (Extract, transform and load) data warehouse database.
• Creating Data Marts by using SAS Data Integration Studio.
• Unit testing the SAS ETL jobs by using SAS Enterprise guide and Base SAS.
• Worked on various database platforms including ORACLE, MS SQL server and DB2.
• Developed, implemented and maintained Enterprise Business Intelligence (EBI) strategy that incorporates both reporting and distribution processes.
• Identified evaluated and implemented Business Intelligence (BI) tools that support the current business needs as well as allowing for future growth and expansion.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI Dashboards and Web-based reporting.
• Developed ad-hoc reports using Base SAS and Enterprise Guide.
• Provided guidance and technical expertise to business power users who are responsible for developing reports and conducting ad-hoc data analysis.
• Applied core expertise in SAS BI suites of product including Enterprise guide, Information map studio, Web report studio and Information delivery portal for efficient use of SAS applications.
• Creating the OLAP Cubes using the OLAP Cube Studio and refreshing the cubes on a weekly basis and later make these cubes available on the Information Delivery Portals for use by the business end-users.
• Created well-structured documentation on the enhancement and modification done to the SAS Stored Procedure.
• Used check points in job to debug a job while developing jobs.
• Provided feedback and design changes that are necessary to lead architecture.
• Created and maintained SAS datasets using Set, Merge, Sort, Formats and Functions to create tables, listings, PDF and excel reports, also, extensively using PROC SQL for data manipulations.

Environment: SAS/BASE, SAS EG 6.1, SAS Data Integration Studio, SAS Management Console, SAS Information Map Studio, SAS BI Suite, SAS/ Macros, SAS SQL, SAS CONNECT,UNIX, SAS Add- in for Microsoft Office.

Confidential, Louisville, KY

SAS BI Developer

Responsibilities:

• Reviewing business requirements for standard reportingand Using SAS Business Intelligence (BI) to drive the automation of standardized analytics
• Using SAS Enterprise Guide to build advanced queries, calculating computed columns, sorting, manipulate and prepare data for reporting, graphing, summarization, statistical analysis and finally generates Summarization SAS datasets.
• Generating SAS EG stored processes for product-specific analysesand using SAS Stored Process Web application to build Selection Screens and Dash Boards.
• Used Information Map Studio Stores instructions on how to access and combine relationalData tables, calculate new data items and create multiple pre-defined filters.
• Created and used multiple SAS stored processes to generate high level summaries with conditional highlighting through SAS code by using call define statements for data modeling and data mining.
• Used SAS OLAP cube in SAS Web Report Studio from SAS IMS.
• Effectively created and applied SAS Macro and SQL Querying using either core SAS or Enterprise Guide platform.
• Data Handling through various Databases such as Oracle, MySQL, Teradata.
• SAS Management Console used to create the metadata libraries and also for password administration.
• Building Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.
• Produced various reports based on frequency - On-Demand, Daily, Weekly, Monthly, Annually etc. Extensively used SAS ODS to create the PDF and EXCEL reports.

Environment: SAS/BASE, SAS EG 6.1, SAS Stored Process web Application, SAS OLAP Cube Studio 4.2, SAS Management Console 9.2, SAS Information Map Studio 4.2, SAS BI Suite, SAS Web Report Studio, SAS/ Macros, SAS SQL, SAS CONNECT, SAS Add- in for Microsoft Office.

Confidential, Mount Laurel, NJ

SAS DI / ETL Developer

Responsibilities:

• Importing & Exporting Metadata, Managing & Deploying Jobs, Working with Tables, creating ETL jobs in Data Integration Studio using different transformations like SQL Join, Data Validation, Splitter, Table Loader, Extract, User Written Code, custom Transformations etc.
• Used table look-up to improve performance as it uses hash, used indexes, filter conditions, excluded un-necessary columns from mapping to improve performance
• Computed project cost estimates, time duration and resource requirements based on business requirements.
• Utilized Slowly Change Dimensions (SCD) to track changes over time.
• Designed and developed Extract, Transform, Load (ETL) processes using Base SAS, Data Integration Studio, and DataFlux Data Management Studio to populate Data Warehouses and Reporting Data Marts.
• Apply and demonstrate expertise with efficient DATA step, SQL programming, SAS Macro programming, ODS, Reporting and Summary procedures and SAS Array processing.
• Developing sophisticated data flows in Data Integration (DI) Studio.
• Worked on various database platforms including ORACLE, MS SQL server and DB2.
• Managed data integration development tasks in collaboration with other technical teams.

Environment: SAS 6.1, 6.3, SAS DI Studio, SAS BI Suite, SAS Management Console, SAS EG 7.1, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SQL, Teradata, UNIX.

Confidential, Boston, MA

SAS / DATA Analyst

Responsibilities:

• Used SAS Data Integration Studio for Extracting, transferring and Loading and generating master datasets from various databases, as well as loading into different complex databases like Oracle, Teradata.
• Involved in complete validation of all the SAS programs used, accessed and manipulated libraries using SAS Management Console.
• Retrieving the customer's data from the Oracle database in to SAS environment using SAS/Access 'SQL Pass through facility.
• Used FTP and SFTP to download SAS Formatted Data into EXCEL AND CSV format.
• Extracted, transformed and Loaded (ETL) operational data into a data warehouses and data marts
• Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting
• Continuously gaining a deeper understanding of relevant data, design and processes to build Analytic solutions to meet business needs.
• Using SAS Enterprise Guide for manipulating and modifying the data and for creating the datasets showing the customers data.
• Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values and prepare tables summarizing descriptive statistics and analysis.

Environment: SAS/BASE, SAS Macro, SAS/SQL, Teradata, SQL Assistant, SAS DI Studio 4.2, SAS Enterprise Guide 4.3, SAS Management Console 9.1, SAS ACCESS, SAS ODS, UNIX.

Confidential

SAS DI / ETL Consultant

Responsibilities:

• Designed and developed Extract, Transform, Load (ETL) processes using Base SAS and Data Integration Studio to populate Data Warehouses and Reporting Data Marts.
• Used different types of transformations like SQL join, data validation, splitter, table loader, extract, user written code, custom transformations etc.
• Utilized Slowly Change Dimensions (SCD) to track changes over time.
• Schedule and deploy jobs, used custom transformations for data validations.
• Used change management (check in check out concept) for tracking changes, created project repositories for users.
• Developed star schemas for effective reporting on high volumes of data.
• Extensively used SAS Enterprise Guide for data validation and performing Data Investigation.
• Also used it for producing various analyses like Regression, Correlation and Analysis of Variance.
• Designed statistical summary tables and graphs using base SAS procedures like PROC summary, PROC Tabulate and SAS/Graph.
• Created cubes using SAS OLAP Cube Studio from data warehouse tables.

Confidential

SAS Developer

Responsibilities:

• Used SAS and SAS Tools for pre-processing data, data analysis, statistical analysis, and created permanent formatted SAS data sets.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code using SAS tools.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in reports and maintained existing ones.
• Prepared data listings and summaries for statistical analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures like PROC summary, PROC Tabulate and SAS/Graph.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance (ANOVA) using PROC REG, PROC CORR, PROC GLM, PROC ANOVA.
• Performed data extraction from MS-Excel tables into SAS data sets.
• Analyzed data through problem solving. Performed data archival, Ad-hoc reporting, and coding utilizing SAS on WINDOWS and SAS/UNIX.
• Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS DBLOAD procedure.
• Build reports from the processed data, generated several reports from analyzed data and converted the data into dbf format and sent to the client.
• Also the reports were sent to web, creating Universes using web intelligence.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS output to RTF and HTML files.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.

Environment: SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, Window NT