Khalid Amar

Khalid Amar Email--Mobile No: (+91)- Passport No: L- New Delhi (India) PROFILE SNAPSHOT • Worked with statisticians and clinical data managers to provide SAS programming in analyzing the data, generated reports, tables, listings and graphs. • Rich background in categorical data analysis, survival analysis, randomized trial designs and analysis, as well as creating SAS datasets, macro definitions, debugging programs, and documentation. • Extensive experience in developing analytics tools with dashboards designing using Excel and VBA. Expert in Advanced Excel/VBA and its features like Pivot Tables, Charts, Functions, Scenarios, Macro creation etc. • Excellent knowledge of SQL Server with expert query writing/optimization and troubleshooting skills. • Developed model for Survival Analysis with KM cure using R programming language • Possess solid ability in integrating programming skills, conducting analysis, adapting to new applications and platforms, and converting data from complex clinical systems. Working effectively with team members in different time zones TECHNOLOGY SKILLS • Statistical Software: SAS/BASE, SAS/GRAPH, Excel/VBA, R Programming Language and MATLAB • Statistical Techniques: Survival Analysis, Categorical Analysis, Descriptive Statistics, Inferential Statistics, graphical reporting etc. • Database Management: SQL and Ms Access • Additional Software: Ms Office WORK EXPERIENCE Organization : Smart Analyst India Pvt. Ltd Designation : Senior Analyst Duration : Feb 2015 – till date…. Domain SAS EXCEL/VBA Key Responsibility • Strong experience in various SAS modules like SAS/BASE, SAS/ADVACED, SAS/SQL, SAS/MACROS, SAS/GRAPHS • Performed statistical analyses including survival analysis and statistical modeling of real world data and clinical trials data • Wrote, implemented, and tested programs for populating reports and automated client reports using SAS Macro programs integrated with a variety of other programming languages • Led the development of SAS code for modeling data and directed the implementation of SAS procedures such as PROC LIFETEST (Survival Analysis), PROC MEANS, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC SQL...etc • Meticulously analyzed and validated data sets and SAS outputs with other programmers’ outputs and mockups in Statistical Analysis Plan (SAP) using PROC COMPARE, PROC CONTENTS, and PROC FREQ. • Effective manage and track all studies/analyses to ensure timelines are met and all stakeholders aware of project status • • Analyzed qualitative and quantitative data quickly and accurately by employing statistical concept Worked independently on ‘Immuno-Oncology Analytics Tool’ for Immuno-Oncology database for Bristol Myers Squibb (BMS). • R MATLAB • • • • • • • • Have been part of developing various internal analytics tool (Data Management Tool, Data Insight Tool, Survival Analysis Tool) for fetching data from different source in to a master file and thus analysis of those data in graphical format. Generating code for automation of report/exporting data to excel and deployment. Conduct excel trainings for other teams and new joiners Developed model for Survival Analysis with KM cure Developed several app using Shiny Portfolio optimization using simulations in MATLAB Dynamic revenue forecast models (including NPV and P&L) for marketed and pipeline products, with an option to add market events and analyze their impact Extensively involved in Data Optimization & GUI development and its implications using M Conducted training sessions for user-group for report. Organization : EMF Pvt. Ltd Designation : Research Engineer Duration : May 2013 - Jan 2015 Key Responsibility • Working with core team and invented methods for users for interacting with MATLAB code • Creating advanced interactive evaluation chain Writing, and tested modular code • Leading the projects from initial design stages to delivery • Evaluating new code and implemented them into the UI • Reviewing processed data and developed metrics; Programmed applications for complex mathematical solutions • • • • • Integrating MATLAB with various applications Wrote a multitude of Excel VBA scripts and queries to compile and standardize raw data into clean entry format. Utilizing VBA to Extract data, perform Analysis & develop Reports. Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trend analysis to the department Created User Manual, Technical Documentation and trained Users with the application. PROFESSIONAL ABRIDGEMENT • • • B.Tech, Electronics & Communication Rajasthan Technical University, Kota, Rajasthan; 2007 – 2011 AISSCE in 2006 from P.M.H. School, Patna, Bihar AISSE in 2004 from St. Xavier’s School, Muzaffarpur, Bihar