Balasundaresan Dhakshnamoorthy

*** ****** ****

Apex NC– 27502

ac46nl@r.postjobfree.com

773-***-****

SAS Programmer/Data analyst, statistician, research data scientist experienced and trained in recording, extracting, interpreting and analyzing data using SAS & SAS Visual Analytics Software. Detail oriented and excellent proficiency in advanced level excel and preparing detailed documents and reports.

Professional Skills

Hands on SAS programming experience and trained as a data analyst with certification in SAS Certified Base Programmer for SAS 9 and SAS Certified Visual Business Analyst: Exploration and Design using SAS Visual Anlaytics. Skills in Extracting/Transforming/Loading(ETL), informatica, data import and export of SAS, SAS/Base, SAS Macros, SAS/SQL,SAS/STAT, SAS DI Studio and Data Management. Statistical Analysis using SAS Procedures, forecasting Accessing SAS data sets using PROC/SQL, SAS Visual Analytics. Experience in scheduling the autoload processes in Autosys tool and JIL scripting using UNIX shell scripts

Expertise in SAS Data modeling including regression analysis, forecasting, time series analysis, hypothesis testing

Hands on experience in proteomics, genomics and structural bioinformatics using Bioinformatics tools. Proficient in Balst/PSI-Blast, Pymol, Swiss-PDB Viewer, UniProt/SwissProt protein sequence database analysis, identifying protein domain analysis using PROSITE, Protein structure Homology modelling

Efficient in handling multiple large projects, well trained and equipped in NIH funded project management, project documentation, and data management skills in compliance to NIH policy standards

Authored several peer review scientific publications and precisely saved time in designing experimental protocols and specifications. Analyzed several sequence database and helped in generating NIH sponsor funds by designing highly innovative projects

Highly talented, motivated, well organized, creative, passionate and precise in decision making with good verbal communication skills, written communication skills and presentation skills

Hands-on experience in Vector-NTI Software for sequence analysis, cloning strategy, designing primers for PCR

TECHNICAL SKILLS

Computer Skills

Operating Systems : Windows NT/2000/XP/7/8/10, LINUX/UNIX OS, MS-DOS.

Languages : SAS, SQL, FOXPRO,

Software skills : MS Access, Excel, MS-SQL, Power Point, MATLAB, SAS/BASE 9.2, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ASSIST, SAS Visual Analytics 7.3, SAS Enterprise guide 7.1, SAS DI Studio, knowledge in Tableau, PhotoShop, Illustrator, CCP4i, Pymol, Coot

PROC(SAS) : PROC PRINT, PROC IMPORT, PORC CONTENTS, PROC SORT, PROC FORMAT, PROC MEANS, PORC FREQ, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC UNIVARIATE, PROC FORECAST, PROC CORR, PROC REG, PROC ANOVA, PROC GLM, PROC EXPORT.

In-depth subject knowledge in Sql programming, Python programming, Statistics and data modeling (Regression Analysis, ANOVA, forecasting, predictive analytics etc.), Mathematics, Biostatistics, Matrix Manipulation, Relational database design and database management.

EDUCATION

DOCTOR OF PHILOSOPHY - NOV 2005

MAJOR – BIOPHYSICS AND STRUCTURAL BIOLOGY

UNIVERSITY OF MADRAS, INDIA

MASTER OF PHILOSOPHY – MAY 1998

MAJOR- BIOPHYSICS AND STRUCTURAL BIOLOGY

FIRST CLASS WITH DISTINCTION UNIVERSITY OF MADRAS, INDIA

MASTER OF SCIENCE – MAY 1996

MAJOR – COMPUTER SCIENCE AND ELECTRONICS ENGINEERING

FIRST CLASS WITH DISTINCTION

BHARATHIDASAN UNIVERSITY, INDIA

SAS CERTIFIED BASE PROGRAMMER FOR SAS 9 & SAS VISUAL ANALYTICS –SPRING & SUMMER 2016

WAKE TECHNICAL COMMUNITY COLLEGE, CARY,NC 27603

CERTIFICATION

SAS Certified Base Programmer for SAS 9 – MAY 2016

SAS Certified Visual Business Analyst: Exploration and Design using SAS Visual Anlaytics – October 2016

Programming Experience

Bank of America, 130 N College Street, Charlotte, NC 28202 Application Architect/Specialist SAS Jan’17 – Jul’17

Designed and developed SAS and SAS VA application tool that enables the Analytics and Capacity Planning Management (Capplan) department to quickly compute and provide valuable information related to global and local staffing scenarios.

Implementation of SAS-Grid environment by supporting the end-uesr client access to metadata server

Efficiently worked on SAS grid windows based and linux based environment

Expertise in SAS BI tools such as SAS EG, SAS VA, Tableau, Informatica and SAS DI Studio

Experience working with Data exported from RDBMS (SQL Server,ARDB) or other formats into SAS and ETL tools(SAS DI Studio and Informatica)

Implemented the SAS VA LASR Analytical server at Bank of America and designed reports, analytical models using SAS Visual Analytics, SAS operational research, SAS Management Console and SAS Visual Statistical tools.

Handled maintenance/ enhancement requests for various operational SAS programs related to automation of capacity planning management and Enterprise Independent Testing groups

Completed all requests on time and accurately, following SME’s LOB rules and procedures

Assisted fellow analysts/programmers by quality-testing their programs, often finding and fixing errors

Wrote clear and concise documentation for all requests

Well experienced in time series analysis, forecasting and scenario (predictive) analytics using SAS stored processes (STP) and SAS Visual Analytics tools

Designed and developed a SAS tool to analyze large datasets of responses in order to optimize the efficiency of the questionnaire design.

Automated several daily/weekly/monthly reports using SAS and SAS VA tools, providing significant time savings for Analytics dept.

Designed, developed, and automated the monthly summary report using SAS Base, Stored process(STP) and SAS VA that visually shows the performance metrics of over/under staffing ratio among various line of business(LOB)

Served as go-to person for ad hoc and crisis tasks requiring sophisticated, creative analysis methods to produce reports and graphic displays of complex data for performance evaluation and problem detection, particularly using SAS and SAS VA

Used SAS Base, SAS Macros, SAS/SQL, and MS Excel on a daily basis

Validation and Review of SAS Programs

Assisted in configuration, development and testing of AutoSys JIL and other scripts.

Provided technical assistance for development and maintenance of AutoSys and related scheduling solutions and creating report using Tableau to compare it with SAS VA.

Generated reporting of issues and resolution of all incoming request and problems.

Participated in scheduling development lifecycle stages such as requirements gathering, implementation and relevant maintenance.

Conducted workflow analysis and suggestion of modifications through WCC GUI applications.

Designed AutoSys based solutions for communication of issues to technical teams.

Performed Autosys jobs and JIL scripting using Unix Shell Scripting

Completed intensive training by participating in Agile workshop and worked in a highly successful Agile project supporting the LOB needs and automation systems.

The University of Chicago, Chicago, IL 60637 Role: Staff Scientist Jan’12 –Jan ‘16

Writing SAS code to Produce Tables, Listings, Figures, Datasets, pre-processing data, Data Analysis, generating reports, Statistical Analysis, and Graph

support reviewing and editing existing SAS coding to document the programs, trouble shoots the programs.

Performing statistical data modeling and bio statistical analysis and hypothesis testing using PROC MEANS, REG, TTEST, UNIVARIATE SIGPLOT, GENMOD.

Linear and non-linear Regression Modeling, Cost-Benefit Analyses through Statistical Simulation.

Writing reports directing Statistical Analysis Software output to RTF and HTML files.

Using PROC GLM for Unbalanced Designs.

Writing ODS SAS procedures to publish reports as HTML pages to Web.

Programming continuous and categorical endpoints using PROC GPLOT, GCHART, GSLIDE, GREPLAY, and ANNOTATE datasets.

Developing, Editing and maintaining SAS programming macros.

Writing SAS programs for analysis in UNIX and PC environment.

Validation and review of SAS Programs.

Sampling and Testing Categorical Data with PROC FREQ, Producing Statistics with PROC MEANS.

Writing Delimited and HTML files using ODS.

Using PROC TTEST, PROC UNIVARIATE, PROC CHART, PROC GLM, PROC ANOVA for Relationship with Continuous dependent variables.

Converting SAS datasets to Export format.

Perform quality control and verification of SAS-generated output.

Assisting in designing data collection forms, converted ASCII, Access and Excel datasets to SAS format, data cleaning and validation.

Developing Macros to create tables as RTF files using Percent Macros, ODS, PROC Tabulate and PROC Report.

Complex Data processing and data manipulation using several SAS procedures including FORMAT, FREQ, ANOVA and TRANSPOSE.

Concatenating, interleaving, and merging datasets.

Using SAS/SQL for data analyses and Statistical Reporting and to create, Populate and Delete tables.

Duties included SAS Programming on Windows environments. Testing a series of SAS programs to

generate PDF, HTML, RTF and ASCII Listings using SAS.

Using SAS 9.2 (BASE, Macros, PROC REPORT, PROC SQL, PROC GLM), SAS Visual analytics 7.3 and SAS Enterprise guide

Transferred data between databases using import/export facility in SAS and FTP.

Excellent training in creating SAS Macros and Data processing to consolidate and streamline table writing routines .

Converting Excel applications to HTML, utilizing ODS.

Good knowledge in CDISC, SDTM and ADAM clinical trial dataset creation and management

Good knowledge in clinical trial research and development

Expertise in data exploration, design reports and business analytics using SAS Visual Analytics software

Expertise in preparing reports in SAS Visual Analytics using VA Data Builder, VA Explorer, VA Designer, VA Viewer, creating custom reports, dashboards in SAS Visual Analytics, forecasting and demand time series analysis using High-Performing forecasting.

PROFESSIONAL EXPERIENCE

The University of Chicago, Chicago, IL 60637 Role: Research Associate Apr ’08 –Dec‘11

Writing SAS code to Produce Tables, Listings, Figures (TLF), Datasets, pre-processing data, Data Analysis, generating reports, Statistical Analysis, and Graph

Reviewed and edited existing SAS code to document the programs and troubleshoot the programs.

Extracted, compiled and tracked the bacterial genomic database and analyzed the genomic sequence using statistical approach to identify suitable drug candidates targeting ion channels

Expertise in data mining using bacterial genomic and proteomic database field of study

Extract, survey and track the protein data bank (PDB) sequences and analyzed the structure and function

Developed and optimized data collection procedures at synchrotron beamlines

Very innovative in designing novel neuroscience (ion channel membrane protein) projects and ideas, ability to adapt while working independently and also as team player in several projects.

Expertise in writing proposals and experimental design protocols

Ability to work independently, provide guidance and work collaboratively as a team within the alloted time constraints to meet up the project deadlines

Ability to prioritize the projects, documentation of protocols, energetic, and finalizing it with attention to detail

Worked with other team members to follow-up and interpret the function of several bacterial proteins.

AIST – Tsukuba, Japan Role: AIST – Postdoc Fellow Jan ’07 –Feb ‘08

Extracted, compiled and tracked the influenza protein sequence database using Blast, PSI-Blast and analyzed the sequence using bio statistical approach

Extracted and tracked the protein data bank (PDB) sequences and analyzed the structure and function associated with influenza genomic and proteomic data base.

Developed and optimized data collection procedures at synchrotron beamlines

NEC Soft Ltd., Tsukuba, Japan Role:Research Scientist Jun’05–Dec ‘06

Extracted, compiled and tracked the Coagulation factor protein sequence database using Blast, PSI-Blast and analyzed the sequence using statistical approach

(REFERENCES available upon request)

Contact this candidate