Shikha

AM
placeholder
Location Gurgaon
view-icon
Total Views15
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 4 Year
  • Cost
    Hourly Rate$8
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnDecember 08, 2022
Key Skills
AnalyticsExcelPivotSumifConditional formattingVlookupPower BI
Education
2016-2017

(Commerce)
Ignou

Summary

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

Copyright : 2022 – OnBenchMark All Right Reserved.