Respected Recruiter,
I am writing in response to the above mentioned job requirement. I have read your job details and I can assure you that I can complete the work before the mentioned time
Please find below the brief description about my Education and Technical Expertise:
I have done Bachelor of Engineering in Computer from the top most reputed university in India. I was university topper. My work experience during the last 24 months in Data Analytics Firm includes supporting world largest Retail Giant in improving performance and optimizing processes all-round the globe.
I have worked hands on on Microsoft Excel, VBA, Web Scraping using VBA, Tableau and SQL. I have advanced level knowledge of Excel which comprises of:
• All basic Excel formulae
• Array Formulae, Conditional Formatting
• Creating dashboards and charts in excel
• Pivot Tables and Pivot Charts
• Using Excel VBA for automation of the repeated process
• Linear Regression Analysis, Time Series-Moving Average Analysis, t-Test, z-Test, ANOVA Analysis etc using Excel
Also, I have created many different Macros in Excel to automate the entire process of Raw Data transformation to user understandable form.
The macros that I have created, works as follows:
The macro normally starts with pasting the raw data in Excel sheet from Data Server, like SQL, ACCESS etc. After getting the raw data from the server, macro performs the data transformation such as rolling up of data to higher level etc