Shikha

Career Snapshot

A mission-focussed individual with 4.5 years of experience in corporates Operations, Client/Customer Servicing, Business Development, Back-Office Operations, Liaison / Coordination as well as other allied operations.

Proficiency in devising innovative business development strategies, such as creating Business Analytics Report & Sales Performance Reports from excel, advance excel, macros and multiple sources, Customer Satisfaction Survey.

Successful in maintaining business relationship with key decision makers of target organisations for achieving the service norms and resolving critical issues.

Deftness in setting out standards for various operational areas to facilitate a high-quality customer experience, while adhering to the SLA.

Areas Of Expertise 

Advance Excel:- Complex Formulas, Pivot Table, Slicer, Chart & Graph, Complex Formula & Pivot based templates / Reports / Dashboards.

Power BI:- Dashboard / Report Creation and Maintain it, Writing DAX / Measures & Customizationof tables using DAX, Bookmarks / Slicer / Buttons, Relationship between Tables, Gateways for automatic refresh from source, RLS.

Power Query / Editor: Multiple Data Table Operation: Merge, Join, Append& Manage Table Complex Data Table Operation: Split, Adding, Remove Table Pivot/Unpivot Column, Group By & Format Table Pivot/Unpivot

SQL DDL,DML,DCL ,use of operators,SQL QUERIES like SELECT,INSERT,CREATE,GROUP BY,DROP,DELETE,JOINS.

Career Details

RBL bank . July’20 -Till date- SDA-OPS

 Usage of Lookup, Sumifs,Sum product,Pivot tables, Conditional formatting, Reports,Validation,Forms, Hyperlinks in and outof the excel workbook, sharing the excel workbook overthe networkserver, exportingand importing data from various data sources and otherfunctions of Ms Excel. ❖ Planning and controlling all ManagementInformationactivities for respectivecampaigns,in orderto meet the requirements of external clients ❖ Design reporting formats to provide accurate informationin a clear and concisemanner using MS-Excel. ❖ Extract existing data to calculate/format into presentable reports, charts, and graphs. ❖ Add insight / draw inferences from raw data. ❖ Examine and evaluate purpose and content of business reports to develop new or improve existing format. ❖ Design, build, and implement newreport formats and layouts on a customized basis as requested by the Business Leaders