Dipen Deori

 Dipen Deori Mobile: -/- E-mail--Professional Synopsis More than 6 years’ experience in Analysis, Development and Design out of which more than 4 years in SAS Programmer and 2 year’s into Advanced Analytics. More than 6 year experience in Ms Excel and Advaned Excel and Macro and 1 year in VBA. Proficient in Writing Maintainable Supportable and Well Documented SAS Code. Possess extensive knowledge of developing, modifying and maintaining SAS program suites. Extensive programming experience with PROC TABULATE, PROC REPORT, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC FREQ, PROC MEANS and PROC SQL, PROC SORT. Knowledge on Data Modeling like Linear Regression, Multilinear Regression, Logistic Regression, Arima Modeling and Factor Analysis. Exposure in validation and understanding of Modeling. Possess excellent communication and coding skills In-depth knowledge of SAS programming, data processing, data collection, quantitative and qualitative data analysis Excellent organizational and time management skills Possess excellent knowledge of statistical software like SAS. Possess good analytical and problem-solving skills Excellent team player with high level of personal initiatives Ability to handle multiple tasks simultaneously Superior skills in analyzing and coordinating data, generating tables, listings, graphs and reports. Using Descriptive Statistics like Proc Univariate, Proc GLM,Proc Anova,Proc TTest, Proc Corr,Proc Reg, Proc Rank. Providing training on SAS Base, SAS Advanced, R, VBA, Advanced Excel, and Data Science training in SAS, R and Phython in Basant Technologies and Ni Analytics. Career Path SAS DeveloperGenpact 14th Dec 2015-till Date Responsibilities: Performing the tasks of designing and developing project-specific SAS programs like producing analysis datasets, graphics and reports Analyzing datasets and generating statistical reports using SAS. Testing and implementing cross-project SAS programs and developing utilities for QC/QA Assigning the tasks of serving internal CBAR committee Assisting biostatisticians and epidemiologists in creating database infrastructure, analyzing datasets and reports Modifying incoming data using SAS code by reformatting, importing, sorting, merging and restructuring. Preparing Adhoc Report. Using various SAS tools like SAS/BASE, SAS/GRAPH, and SAS/ODS, SAS/ACCESS SAS/CONNECT, SAS/SQL in Windows Environment.Using the various SAS Procedures like Proc Sql, Proc Sort, Proc Print, Proc Means, Proc Datasets, Proc Contents, Proc Freq, Proc Format, Proc Report, Proc Tabulate. Using Descriptive Statistics like Proc Univariate, Proc GLM,Proc Anova,Proc TTest, Proc Corr,Proc Reg, Proc Rank. Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation & Scenarios). Environment: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros, SAS/ Access, MS-Excel, Citrix. SAS Programmer 1st Dec 2014-19th Jun 2015 Global Logic India Ltd Responsibilities: Manipulated, transferred and managed data in SAS Developed and implemented innovative SAS strategies of the organization Provided statistical analysis and support Designed data collection methods for specific project Repaired syntax errors in the code Fetched data from the connected systems Handled the responsibilities of reviewing statistical methodologies Recommended innovative methodologies in implementing statistical analysis solutions Planned and directed work of SAS developers Attended client and team meetings as required Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation & Scenarios). 12th March 2012 to Till Date to 31st May 2014 BCD India Pvt. LTD. SAS Developer Responsibilities: Created, modified/Updates SAS code to incorporate changes in new releases of the product. Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis. Data manipulation by merging, appending and sorting datasets. Extensive use of PROC SQL to create subsets of data for further analysis. Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, DATA _NULL_, PROC MEANS, PROC SUMMARY, RETAIN. Used SAS - output delivery system ODS to format reports in HTML, PDF, CSV and RTF reports. Optimized SAS code to reduce run time and make the process more efficient. Generated output files in various formats like text, MS Excel. Analyzed demographic data to identify outliers. Participated in code reviews. Developed SAS code using Macros to run recurring jobs and optimized code. Troubleshoot process failures and implemented process improvements. Designed and executed data quality and system tests. Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation & Scenarios). 3rd July 2011 to 3rd January 2012 Accenture India Pvt. Ltd. (CSR Non – Voice) February 2010 to December 2010 TCL BCPL (Dibrugarh) (MIS Executive/Analyst) August 2009 to January 2010 BRC BCPL (Dibrugarh) (MIS Executive/Analyst) Areas of Interest: To develop more advanced SAS Programming suites To generate and implement SAS programming for various projects Education Qualifications 2007 Bachelor of Science Guwahati University Personal details: Father’s Name : Digonta kr. Deori Marital Status : Single Nationality : Indian Hobbies : Travelling Languages : English, Hindi and Assamese