I have 7 years of work experience across IT and financial service industry.Demonstrable experience in data analytics and reporting, business process mapping and requirement gathering. Have delivered projects such as dashboard reporting and automation using MS SQL, Advanced MS Excel, and Visual Basic Applications (VBA).
Can perform following task:
1) Any MS Excel work using functions such as Pivot Tables, Data Entry Forms, Vlookup, Hlookup, Match, Index, Conditional Formatting, Data Validation, Logical Operators & Functions – IF and Nested IF and Text Functions.
2) Visual Basic Applications (VBA) – Automation, Macros and Dashboard Reporting
3) MS Access and SQL – Designing Efficient Relational Database Models, Importing / Exporting Large Amount of Data into/from MS-Access, SQL Statements and Writing SQL Queries, Merging, joining, sorting, grouping etc.
4) Making strong and powerful presentation using MS office.