For past 5 years, I am working as a Business Intelligence (BI) consultant in an Germany based firm operating on the financial sector. My responsibilities include client data analysis, using excel, R and SAS, to identify KPIs, creation of data models (in excel/MS Access/MS SQL). The whole process is again summarized in a user friendly format (in SSRS, Power View or Excel Dashboards.) I am an expert in Econometrics and Statistical analysis. I have pursued my masters in Finance and Marketing. After that I decided to focus more on analytics and obtained professional training Analytics and Advance Excel. With on-hand experience of more than 10 projects domestic, I can bring sizeable changes and substantial values to your business by means of applying advanced statistical methodologies to analyze your business and market presence. Besides, I can provide you with a stunning representation of your business data which will guide you towards a strong and robust business planning. With more than four years of experience in Business Intelligence, I can design efficient solutions to make your daily business data talk to you in form of key performance indicator (KPI) dashboards and interactive graphing and charting. use excel formulas like- index, pivot, offset, counta, vlookup, hlookup, match, macros, len, if, countif, sumif, iferror, hyperlink, trans, transpose, address, rand, trim etc. I make macros coding. I have delivered quality material that stood up to clients' expectation throughout and If hired I promise to serve with best of my knowledge and accuracy.