Shaila N.N.

Current Team Responsibilities-IOO

• Created 30+ checklists in sharepoint
• Around 12+ flows using Power automate, 5 nintex workflows
• Attrition Analysis
• CIBS metrics
• Monthly deck for Anthony
• Leave tracker
• OT comments
• SnP data modeling
• Various PPTs for meetings
• Open position Analysis
• IOO India Resource planning
• Promotions deck
• Key projects in IOO- Part of NT India Hiring Tool(Power BI) project, FEE Invoice Tracker, Daily Log, New Account setup, New broker setups, Multiple Setup checklist, Int. Claims checklist, FX checklist, Market charges setup, Transfer Agent setup etc

Previous Team Responsibilities-HFS BAS

• Handling Macro and SharePoint projects along with below mentioned reports
• SST Administration
• HFS Scorecard
• SST Scheduled Report
• Finance Dashboard
• SST data analysis
• Ad hoc requests
• VB.net forms for Error Log
• Sharepoint forms for NA Error Log
• SQL data handling
• WFH IT Issues (PowerBI)
• VBA-Key projects worked in BAS, Best Practices Dashboard, BOX Report macro, GTX Report macro, Hydra Check preparation macro, Headcount Report, Daily Reports Macro, Management Reports, Out of Town report, Emails draft macro, Poseidon dashboard, Presettlement macro etc.

• Regular Reports: INDIA IT MIS (Monthly) - Includes WAN, server, IT support availability, capacity, financial, quality and efficiency metrics
• Receiving the Inputs from various teams, Analyzing & Comparing the data, preparation of Reports and presenting same in the Dashboard, publishing in the internal website
• Report includes following parameters Technical Helpdesk tickets, Chicago offshore support tickets, EMEA offshore Support tickets, Telecommunication Support tickets, Server Support tickets, Financial Data(IT Expense Report) Departmental METRICS (monthly) - The Objective of this report is to bestow a clear & complete regulation to compile, merge and generate the Chicago Data Centre Technical Service Reports for several functionalities
• This report includes Analysis on Incidents by Manager, Change requests, Expedited Change requests (SLA Metrics)
• Divisional Dashboard & Team Dashboard Percentage of CTASK's completed on time
• Percentage of Resolved INC's which are not breached
• Percentage of Emergency & Latent CRQ's INC's percentage not Assignment & Resolved breached
• INDIA IT METRICS(monthly) - A series of reports created and generated to obtain the information which is populated into an Excel spreadsheet
• A one-time setup of reports is necessary before the data is gathered and reported
• SRQ's with SLA, Incident data, Task survey EMEA Technology Operation Review Reports (Monthly) - Complete regulation to compile, merge and generate the (EMEA) Technology Service Reports
• This report includes Analysis on Incidents by Manager, Change requests, Expedited Change requests GEM - Risk Score Card Report (Monthly)- Contains Planned(Budgeted)/Used IT Parameters(File Accounts, Lotus Notes/Outlook accounts, Printer accounts, domain controller accounts) Daily color call Reports(Quarterly)-(APAC, NA & EMEA)- Report depicts Charts of INC & Critical issues handled as per the data provided on INC & Critical issues handled
• This report depicts the Issues Handled Region wise & Category wise Headcount report(monthly)- Includes tracking of FTE, Contractors Details(Desk location, Emp ID, LAN ID, Dept
• Name, Cost center & Team name) TECHNICAL SUPPORT (as and when required): Handling INCs/SRQ, related to Excel macro and application macro issues (Applications as Fundmaster, AS400 etc ), MS Access etc
• IT Automation: IT process Automation, focuses on streamlining, optimizing and automating the key Processes that drive value for an organization and its customers
• Developed a SharePoint site for CEO (EMT Members) Corporate senior management, using SharePoint designer (J query, script and HTML) Mainly contains: Home, EMT, Executive Reporting, Calendar, Resource Council, Photos/Images, Help pages
• Web pages depicts updates related to different units, Meeting agendas for EMT members, EMT initiatives, Clients & visitors details, NOS Metrics, EMT members profiles & vacation details, shared folders, Resource council's event details, Photos and video uploading provision
• Went live and responsible for maintenance of the site Created the complex macro for GFS India IOO Team
• A) The macro should pick up the below asset classes only and there should be some symmetry on the dates for each of the Clients b) The macro should pick up the data from the respective Client folders and create the pivot
• Completed Online Travel tool project for Travel Help desk team (Lotus Designer using Lotus script & Formula language)
• Worked with NOS Productivity Team to Automate & migrate the IT Application workflow from Excel to MS access (VBA Script, Designing, Coding & Creating reports)
• Automated the Whole IT Asset Management Database (IT Inventory Control) online workflow tool using SharePoint & SharePoint designer (java script etc.) Fixed/Troubleshoot Macro Issues in Excel (Fundmaster) & Access for Business process teams while migrating from XP to WIN 7
• (Includes writing new code which is compatible to WIN 7)
• Created Excel templates for various reports by using the macro and Excel formulas/conditions for IT as well as business units
• Created Excel template with macro for ILD applications, updated on weekly basis etc.

• Monitoring an overall MIS portfolio reporting processes, identifying improvement areas and implementing adequate measures to maximize Management/client satisfaction level
• Handled a team of 5 staffs
• Guiding & training the newly joined staff, allotment of the work, among the team
• Verifying and analyzing the data updated in software (used to track financial & non-financial information of Clients) on weekly bases with supported documents & with Tally (Reconciliation of MIS data with Accounts)
• Provide Weekly, Monthly, Quarterly & Yearly MIS Reports
• Preparation of presentation on quarterly performance of the company for key decision making to the top management
• To consolidate the final data and send the Project report to the top officials of the company
• Identifying and implementing strategies for building team effectiveness by promoting a spirit of co-operation between team members
• Identifying and solving the errors of the client data at branch office through Remote Assistance
• Preparation of new reports (other than regular) asked by Funders and Government banks (RBI) by creating new formats
• Co-coordinating with other units and providing MIS reports to them to work smoothly
• Worked in Multitasking (HR unit, Accounts unit, Finance unit MIS unit)
• In HRUnit - involved in conducting interviews, Preparing HR Reports
• In Accounts unit-arrangement of funds for branches, account opening procedures
• And in Finance unit- Preparing reports & Coordinating with bank about terms & conditions while taking loan to the company.