AYAN BERA
Sector 3, Salt Lake
Kolkata - 700097
Contact No.: +919*********/ 033********
E-mail id: *********@*****.*** / ************@**********.***
CAREER OBJECTIVE:
Seeking the position of a SAS Analyst where my proficiency in applying analytical concepts on SAS can be fruitfully utilized to enhance the efficacy of the organization
TRAINING:
Succesfully completed Base SAS,Advance SAS and Analytics from Orange Tree global
SUMMER INTERNSHIP:
Standard Chartered - STCI Capital Markets Limited, Kolkata April2009 - June2009
Purpose: Online sales through branch network
Methods: Visited customers to guide them to trade through the trading portal in various parts of Kolkata
Collected data on various pre-determined parameters provided by the company,convinced
customers to open 3 in 1 account.
Visited markets extensively to guide existing customers.
Utility: Gained knowledge about the equity markets.
Enhanced Sale and distribution networks related to 3 in 1 account and was able to open fifteen
3 in 1 accounts.
ACADEMIC QUALIFICATION:
YEAR COURSE SPECIALIZATION INSTITUTION BOARD AGGRE-GATE (%)
2011 M.B.A. Financial Management Bengal Institute Of Business Studies Punjab Technical University 1st
2008 B.TECH. Information Technology Siliguri Institute of Technology W.B.U.T. 1st
2004 12th Science Kendriya Vidyalaya
No. 1, Salt Lake,Kolkata A.I.S.S.CE. 1st
2002 10th General Kendriya Vidyalaya
No. 1, Salt Lake,Kolkata C.B.S.E. 1st
SKILL SET:
Extensive use of PROC SQL to perform queries, join tables.
Optimized performance using Data Validation and Data cleaning using Statistical procedures like PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, PROC SORT, PROC TABULATE, PROC APPEND etc.
Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
Ability to use analytic tools such as PROC GCHART, PROC GPLOT, PROC BOXPLOT. Also analyse various Normal, Binomial, Poissons distributions, using PROC STANDARD, PROC TTEST.
Perform cluster and factor analysis to arrive at a meaningful data using procedures such as PROC CLUSTER, PROC FACTOR, PROC TREE.
Ability to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM and mixed models.
Ability to conduct tests of Correlation,Multicollinearity, Multiple regression, Logistic regression using tools such as PROC CORR, PROC REG, PROC LOGISTIC.
Familiar with concepts of Time Series Analysis such as stationarity of a series,AR,MA,ARMA and ARIMA models,components of a time series and use of various simple and exponential smoothing techniques to smooth out disturbances in a time series
Generate reports either in HTML & PDF formats.
Conduct analysis and generate tables, listings and graphs using SAS.
Ability to use PROC PRINT, PROC REPORT to generate the outputs.
OS PLATFORM : Windows 98 & windows XP,DOS
SOFTWARE TOOLS KNOWN : Ms Office 2003,2007,2010
KEY PROJECTS:
Environmental project on pollution control: Collected data which helped me acquire knowledge on the
causes of pollution and the ways and means of preventing it.
‘Coca Cola versus Pepsi’: Found out the relevance using SWOT analysis, PORTER’S FIVE FORCES
model, BCG matrix.
IPL (Indian Premier League): An analysis on the various teams played in the 1st IPL,using SWOT
analysis.
ADDITIONAL QUALIFICATION:
Two-Year Post Graduate Programme in Business Management from Bengal Institute Of Business Management (specialized in Marketing Management).
ACHIEVEMENTS:
Participated in under 14 and under 16 cricket tournament conducted by kendriya vidyalaya sangatan
Awarded as the Best player of the football tournament conducted by central committee, salt lake city
Selected as the executive member of PSCA Club.
EXTRA-CURRICULAR ACTIVITIES:
Keen interest in chess, table tennis, badminton, cricket, football.
Enjoy travelling and exploring new places.
Participated in various inter-school and college quiz competition.
LANGUAGE PROFICIENCY : English, Hindi, Bengali.