SUMMARY

• Experience in SAS programming / Tableau Visualization / SAS DI/ SAS BI/ SAS Visual Analytics with strong emphasis on analysis, development, design, testing and implementation of various projects.
• Expertise Using SAS 9.4, SAS/BASE, SAS/ADVANCED, SAS/SQL, SAS/ODS, SAS Enterprise Guide 7.1, SAS 9,1, SAS 9.2, 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.
• Experienced in Tableau Data Analytics. Visualizing data, building complex views and dashboard for reporting.
• 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.
• Hands on experience in SAS Programming, SASFormats,SASFunctions,SASInformats, Storing, MergingSAS Data Sets, DevelopingSASprocedures, Macros, Preparing Data, Producing Reports, supporting the reporting functions and Managing Data inSASFiles.
• 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.
• Experienced in using SAS ODS facility to produce RTF, EXCEL, PDF, HTML formatted files
• 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 IMPORT/EXPORT, PROC TRANSPOSE and Data null .
• Extensive programming using the PROC SQL procedure, SAS Arrays and SAS Macros statements.
• UsedSASMacros extensively in the creation of new programs as well as the modification of existing programs to improve ease and consistency of results.
• Thorough experience in extracting data from various disparate data sources like (TXT, XLS, CSV) files, Oracle, MS - Access, SQL Server etc. Used various SAS procedures such as utility procedures, statistical procedures, and report procedures to analyze & process the data.
• Excellent programming skills in extracting and loading the data into various RDBMS like SQL Server, DB2, Teradata and Oracle.
• Good understanding of CDISC SDTM models and experience in converting legacy data to CDISC
• SDTM (Study Data Tabulation Model) Standards.
• Hands on experience and thorough understanding of SAS Enterprise Business Intelligence, SSRS SSIS, Qlikvier toolset and its configuration on windows platform.
• Good at using MS Excel to create a Pivot Table, Vlookup and other conditional formatting in a report.
• Intermediate level of expertise in using Tableau, VISUAL BASIC, Excel VBA and Macros.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Strong Knowledge of different phases of clinical trials, study protocols and analysis plans of pharmaceutical data.
• 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.
• Work assignment among the team and coordinate with study statistician and team to get work done with in timelines with quality deliverables.
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

Languages: SAS, SAS Enterprise Guide, SAS Visual Analytics, Tableau Analytics, SQL, R.

Applications: Mainframe, Client/Server, JIRA & Data Warehouse Applications.

Databases: Oracle 10g/9i, Sysbase, Netezza, SQL Server 2012/2008/2005 , DB2 UDB.

Tools: MS Project, MS Office, MS Visio, MS SharePoint 2010/2007.

ETL: SAS Data Integration Studio, Informatica

Specialties: SAS 9.4, SAS/Base, SAS/Macros, SAS/Access, SAS Visual Analytics, SAS/Connect, SAS/Stat, SAS/GraphSAS/SQL, SAS/ODS, SAS/ETL, SAS BI 9.2, SAS Enterprise Guide.

Reporting Tools: SAS 9.4/ 9.2/9.1.3/ SAS Visual Analytics and Tableau Visualization.

PROFESSIONAL EXPERIENCE

Confidential, DC

Sr SAS Programmer/Tableau Developer

Responsibilities:

• Work with clients BL back-end team to write SAS code for tables/data used by front end team.
• Write SAS code, export tables created in SAS for other team members to visualize.
• Store SAS code as daily process for reporting needs.
• Review/Validate team members SAS code to ensure it meets the client specified requirement.
• Create views, data sources, joins and tables in Tableau for reporting purposes.
• Validate and publish views and dashboards in the required environment for reporting.
• Create Dash board visualization in Tableau for upper management and other team members.
• Attend daily Scrum meetings to discuss progress with sprint task assigned in JIRA.
• Collaborate with other team members and clients to understand business requirements.

Confidential, Washington, DC

SAS Programmer/ Data Analyst IV

Responsibilities:

• Assign public data request to team members as they come into the system.
• Review teams SAS code to ensure every ticket meets the needs on the client and customers.
• Attend daily, weekly and biweekly meeting to update on data requests.
• Coach/ train team on how to improve SAS Codes/Programs for efficiency.
• Write SAS Codes using various Proc Steps on SAS 9.4, SAS Studio, SAS VA etc to meet Data request specifications.
• Data manipulation using various SAS products and Tableau technology to meet reporting requirements of client's customer needs.

Confidential, Wilmington DE

SAS Programmer/ Data Analytics

Responsibilities:

• Extensively use different SAS tools for data analysis and reporting.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets
• Converted the financial data retrieved from clients into SAS readable format and executed the datasets to produce necessary financial reports using SAS/STAT procedures such as PROC FREQ, PROC REPORT, PROC UNIVARIATE and PROC ANOVA.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, and PROC ANOVA.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE. Used DBLOAD procedure to load data into the database effectively prepared and published various performance reports and presentations
• Produced weekly and monthly-customized reports by using PROC REPORT, DATA NULL and PROC REPORT.

Confidential, Newcastle DE

SAS Programmer/ Analyst

Responsibilities:

• Extensively use different SAS tools for data analysis and reporting.
• Expertly create Macro programs to generalize various reporting needs, thus eliminating the need for creating multiple programs with prefixed values.
• Use SAS/ACCESS to extract, insert, delete, and update large datasets from ORACLE database
• SAS DI Studio to load and transform tables from excel files
• Develop OLAP Cubes for hierarchy drilling down in SAS OLAP Cube Studio
• Generate and maintain reports using SAS Datasets and OLAP Cubes as sources in WRS
• SAS Visual Analytics for generating graphs such as pie charts, histograms, bar graphs, scatter plots from processed data
• Create data set views and indexes to enhance the storage space requirements and CPU system resources
• Eliminate duplicate observations in the data set using NODUPKEY and NODUPRECS options in PROCSORT
• Experience in utilizing Web Report Studio and its usefulness to make web reports, use channels and prompts made inside of data maps, give report connecting, adjust report formats
• Develop SAS data set views, indexes to optimize the storage space and CPU resources
• Perform extraction, transformation and loading (ETL) of large tables from Teradata.

Confidential, Memphis TN

SAS Programmer/ DI Developer

Environment: SAS/BASE, SAS EG 7.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, Hyperion.

Responsibilities:

• Converted Legacy Hyperion models to the SAS Platform using the SAS Enterprise Guide.
• Utilized SAS Data Integration Studio to schedule Jobs within the SAS EG.
• Reviewed business requirements documentation with technical project manager and programmers to ensure clarity in implementation of technical design
• Participated in business requirement and joint application development sessions to inform report options
• Implemented systems and program design to meet complex business needs and author technical design document. Created appropriate documentation in work assignments such as program code and technical documentation.
• Assisted technical project manager in development of report time estimates and completes assigned tasks
• Participated in development as data expert, with specialization in report development. Ensured top notch report development through coding, testing, debugging, implementing, and documenting programs, and developing test plans to verify logic programs and output.
• Troubleshoot end user technical issues, identifying report problems and leading solutions
• Implemented release management process including technical steps to promote, test and release through the development environment, coordinating with infrastructure staff.
• Used iterative and agile software development life cycle methodologies.
• Designed and developed enterprise-wide SAS Enterprise Business Intelligence solutions and web applications.
• Developed SAS EBI contents (Stored process, Dashboard, OLAP cubes, web reports, information maps.)
• Performed data management using ETL method, and perform knowledge transfer to IT’S and DOH programmers.