Application Architect, SAS Specialist. SAS Base, SAS EG, SAS VA
Resume:
Balasundaresan Dhakshnamoorthy
Apex NC– 27502
**********@*****.***
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