adcn0t@r.postjobfree.com

***** ******* **, *********, ** 20152

+1-571-***-****

www.linkedin.com/in/sukruaras

Legally authorized to work in the United States for any employer, no visa sponsorship required. SUKRU ARAS

PROFESSIONAL

SUMMARY

Statistician, Biostatistician, Data Scientist and Analyst, SPSS Developer, Power BI Analyst. Over 20 years experience in statistics and biostatistics especially in medical field and performed statistical analysis of over 1000 scientific studies during this period. Strong personal background and experiences in the public health and epidemiology fields. SUMMARY

• 20 years of experience in Statistics, Biostatistics and Data Analytics.

• Created analysis datasets and decided analysis methods based on data structures and analysis objectives. Assembles, merges, and transforms data from multiple sources and prepares it for statistical analysis. Cleaned and analyzed clinical data in excel with various procedures.

• Created SQL queries to extract data from the database to fulfill internal and external data report requests.

• Provided assistance in statistical analysis to medical professionals. Advises data collectors and providers on techniques for recording data that best facilitates statistical analysis.

• Coordinated with the investigators to understand the specific analysis task and to help them with the interpretation of the analysis results. Perform sample size calculations and write statistical methodology sections for inclusion in study protocols. Involved in writing statistical results section of publications and presentations.

• Review and provide input to a Statistical Analysis Plan (SAP) and Statistical Programming Plan (SPP).

• Evaluated research concepts to develop appropriate statistical methods of analysis. Determined methods of statistical analysis and applied statistical techniques to analyze measures of central tendency, correlation, sample size, significance of difference, etc.

• Analyzed and examined complex data and evaluated the statistical methods and procedures used to obtain data in order to ensure validity, applicability, efficiency, and accuracy.

• Prepared analysis results in SPSS and presented statistical results of the research datasets.

• Conducted statistical power analyses and sample size calculation using SPSS, Systat, Minitab, MedCalc, SAS.

• Performed ANOVA, MANOVA, POSTHOC’s, t-tests, linear and logistic regression in SPSS, SAS and R.

• Performed the statistical analyses including ANOVA/MANOVA, survival analysis, linear regression analysis, longitudinal analysis and logistic regression analysis, and statistical modeling (GLM, Logistic model, Cox model, GEE and Mixed Model) of clinical trials and observational studies using SPSS, SAS and R.

• Performs analyses on large, complex datasets and documents analyses using SPSS, SAS, R, STATA and other commercial statistical packages.

• Performed the statistical analyses including Chi-square tests, Fisher’s exact test, t-tests, Wilcoxon rank sum tests, paired tests, linear & logistic regression, Cox proportional hazards regression, Kaplan Meier survival plots using SPSS, Systat, Minitab, MedCalc, SAS and R.

• Performs specialized statistical analysis involving correlation equations for multi-factorial variances and regression equations.

• Reported results of the statistical analyses in the form of graphs, charts, and tables. Prepared tables, charts, and graphs showing the results of statistical analysis.

• Responded to the reviewers' comments for statistics session. Produce publication quality statistical graphics and tables. Write statistical methods and results into manuscripts for peer- reviewed publication.

• Reviews and contributes towards completion of abstracts, posters, presentations, and manuscripts by writing the statistical sections, checking results and reviewing content.

• 5 years of experience in building Data Analytics, Data Science and Business Intelligence infrastructure and solutions.

• Expertise in designing and developing filter driven interactive Dashboards with live tiles reporting real-time streaming data, trend-based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc. in Power BI and Tableau.

• Proficient in design and development of various dashboards, reports utilizing Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.

• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc.

• Performed on validation, Harmonization, Data-Cleansing on disparate data sources.

• Well-knowledge of performing dynamic aggregation in DAX formula, creating multiple Datetime columns in M-Code along with cleaning and transforming tables in Power Query Editor using Excel and Power BI.

• Expertise in Power Query Editor, Conditional Formatting, filtering and slicing data, data modeling, creating multiple charts, building summary and detail reports and designing dashboards with MS Excel and Power BI.

• Well experienced in writing complex T-SQL queries: stored procedures, user defined functions (UDF), derived tables, CTEs, views, sub-queries, and multiple joins etc.

• Well-knowledge of Database System Architecture involving OLTP, Staging Layers, OLAP and ETL Process from Transactional Database to Enterprise Data Warehouse (EDW).

• Performed on Extract, Transfer and Load (ETL) process using MSBI(SSIS) for Data Migration and Data Mapping for Data Warehousing projects along with good project management skills.

• Experience with Star Schema modeling and Snowflake dimensional modeling.

• Well-knowledge of data structures such as list, tuple, set, dictionary in Python

• Created codes including For-Loops, While-Loops, Methods, User-Defined Functions and Object-Oriented Programming (OOP) in Python.

• Well-knowledge of cleansing and transforming data by using Python, working on arrays by NumPy and Pandas, also creating visuals by Matplotlib libraries.

• Good Understanding of basics of multiple Regression Models, Scikit-Learn and Machine Learning Concept in Python.

• Knowledge of System Development Life Cycle (SDLC) and Business Intelligence Solutions and also Data Analytics Life Cycle Management.

• Closely worked with different management levels to understand business rules and analysis needs in Agile environment.

SKILLS &

ABILITIES

• Advanced self-learner.

• Strong problem-solving abilities and Strong analytical skills.

• Data Analytics, Data Cleansing, Data Visualization, Normalization & Denormalization.

• Descriptive Statistics, Probability Distribution, Hypothesis Testing, Correlation Analysis, Regression Analysis, Operations Research Analysis, Mathematical Modeling, Machine Learning.

• Biostatistician, expert in biostatistics, statistical analysis abilities and expert users of programs such as SPSS, MedCalc.

• Familiar with Statistica, Minitab, Systat, Stata, The R and SAS JMP.

• Clinical data management and statistical analysis. Performed over 1000 clinical and experimental scientific studies databases mining and statistics (Over 20 years).

• Data analytics and Data Science: SQL, Phyton, Power BI Developer, The R, SAS.

• Academic experience.

• Reporting Tools: SPSS, SAS, R, MedCalc, STATA, Minitab, Power BI, MSBI.

• ETL: Power BI, Tableau, MSBI, Microsoft – SQL Server Integrated Services (SSIS).

• Languages: SQL, T-SQL, SAS, Python.

• IDE: SAS University Edition (VirtualBox) and WPS Workbench, R Studio, DAX Studio, Visual Studio 2017(SSDT), SQL Server, SQL Developer, Anaconda Jupyter, Spyder, PyCharm.

• Databases: MySQL, SQL Server, Oracle.

• Data Warehouse Concept: Star Schema, Snowflake Schema.

• Operating Systems: MS Windows.

• Desktop Software: Microsoft Word, Excel, and PowerPoint.

• Repository System: GitHub.

PROFESSIONAL

EXPERIENCE

Statistician, Data Scientist and Analyst, SPSS Developer, Power BI Developer SJ Dynamic Solutions Inc (www.sjdynamicsolutions.com) Jan 2018– Present Chantilly, VA

Responsibilities:

●Supported management team with reports generation and analysis using reporting and visualization tools of Power BI.

●Created dynamic dashboards, scorecards and some analysis related to Customer Deep Dive, Sales Trends, Revenue-based Metric Reports by using visualization tools.

● Well-knowledge of performing dynamic aggregation in DAX formula, creating multiple Datetime columns in M-Code along with cleaning and transforming tables in Power Query.

●Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI and Tableau.

●Used Power BI and Tableau features to build and configure Hierarchical dimensions, Measure, Calculated Columns, Filter and Aggregations.

●Created and developed Power BI and Tableau visualizations for the Key Performance Indicator (KPIs) and trend analysis.

●Imported data in Enterprise Gateway, set up scheduled refresh to dashboards and authorized end-users to access reports along with applying Role Level Security to end-users.

●Generated multiple tables and fields using Direct Query to SQL Server in Power BI.

●Established Logical and Physical database models to design source to target process.

●Created Logical/physical Data Model in Power designer and have worked on loading the tables in the Oracle based Data Warehouse.

●Used Common Table Expressions (CTE’s), Constraints, and Complex queries to fetch the data from different servers.

• Performed the statistical analyses including ANOVA/MANOVA, survival analysis, linear regression analysis, longitudinal analysis and logistic regression analysis, and statistical modeling (GLM, Logistic model, Cox model, GEE and Mixed Model) of clinical trials and observational studies using SPSS, SAS and R.

• Performed the statistical analyses including Chi-square tests, Fisher’s exact test, t-tests, Wilcoxon rank sum tests, paired tests, linear & logistic regression, Cox proportional hazards regression, Kaplan Meier survival plots using SPSS, STATA, Minitab, MedCalc, SAS and R.

• Gave statistical analysis and methodology lectures using SPSS to Data Science students. Physician (MD), Statistician, Biostatistician, Data Analyst Istanbul University, Medical Park Hospital, Sifa University, Istinye University July 1999 – May 2017 Turkey

• Coordinated with the investigators to understand the specific analysis task and to help them with the interpretation of the analysis results. Perform sample size calculations and write statistical methodology sections for inclusion in study protocols. Involved in writing statistical results section of publications and presentations.

• Evaluated research concepts to develop appropriate statistical methods of analysis. Determined methods of statistical analysis and applied statistical techniques to analyze measures of central tendency, correlation, sample size, significance of difference, etc.

• Analyzed and examined complex data and evaluated the statistical methods and procedures used to obtain data in order to ensure validity, applicability, efficiency, and accuracy.

• Prepared analysis results in SPSS and presented statistical results of the research datasets.

• Conducted statistical power analyses and sample size calculation using SPSS, STATA, Minitab, MedCalc, SAS.

• Performed ANOVA, MANOVA, POSTHOC’s, t-tests, linear and logistic regression in SPSS, SAS and R.

• Performed the statistical analyses including ANOVA/MANOVA, survival analysis, linear regression analysis, longitudinal analysis and logistic regression analysis, and statistical modeling (GLM, Logistic model, Cox model, GEE and Mixed Model) of clinical trials and observational studies using SPSS, SAS and R.

• Performs analyses on large, complex datasets and documents analyses using SPSS, SAS, R, STATA and other commercial statistical packages.

• Performed the statistical analyses including Chi-square tests, Fisher’s exact test, t-tests, Wilcoxon rank sum tests, paired tests, linear & logistic regression, Cox proportional hazards regression, Kaplan Meier survival plots using SPSS, STATA, Minitab, MedCalc, SAS and R.

• I took Biostatistics lectures and courses during my doctoral studies. I participated in the statistical training organized by MedCalc and got a certificate.

• During this time, I gave over 10 different groups of doctors, statistical analysis and SPSS training. The duration of these courses would be 10 weeks and 4 hours per week.

• Since 1999, I have performed statistical analysis of over 1000 scientific studies and theses

(mainly medical doctors, dentists, nurses and biologists). Most of these studies are available in the SPSS.sav files.

Physician (MD), Biostatistician

Bezmialem Foundation University

Laboratory Management, Quality Control, Statistics and Biostatistics education and work. Dec 1994– Jun 1999 Turkey

General Practitioner, Physician (MD)

Public Health Clinic

Nov 1993– Dec 1994 Turkey

• First step human health services.

• Provide care, treatment, and advice for acute health conditions for patients in the work place practice.

EDUCATION • Medical Doctor, Istanbul University Istanbul School of Medicine, Istanbul, Turkey, 1993.

• All of my degrees are be evaluated for U.S. equivalency. CERTIFICATES • Certificate in Statistical Training organized by MedCalc.

• Licensed user of SPSS v17, v18, v19 and v26.

• MedCalc statistical software lifetime licensed user.

• SQL fundamentals track data science certificate, Datacamp.

• Certificate in Standardization and Quality Control in Medical Laboratories.

• First Aid CPR AED Program.

PUBLICATIONS • Published 30 articles in international and national peer-reviewed journals with 346 citations.

• All publications statistical analysis and reports are performed by me.

• “Blood stream infections due to OXA-48-like carbapenemase-producing Enterobacteriaceae: treatment and survival.” International Journal of Infectious Diseases 26, 51-56. Cited 67 times.

• “Metabolic, biochemical and psychiatric alterations in healthy subjects during Rama- dan.” Pak J Nutr 6 (3), 209-11. Cited 63 times.

• Serum levels of tumor necrosis factor-α, interleukin-6 and interleukin-8 are not increased in dyspeptic patients with Helicobacter pylori-associated gastritis. Mediators of inflammation 13 (1), 25-28. Cited 56 times.

• “Colistin nephrotoxicity increases with age.” Scandinavian journal of infectious diseases 46 (10), 678-685. Cited 38 times.

• “Sensitivity of iodine deficiency indicators and iodine status in Turkey.” Journal of Pediatric Endocrinology and Metabolism 16 (2), 197-202. Cited by 24 times.

• “Iron deficiency and iron deficiency anemia in infants and young children at different socioeconomic groups in Istanbul.” Turkish Journal of Hematology 18 (1), 19-25. Cited 22 times.

Contact this candidate