Rakesh Kumar Email & Phone Number

Gurugram, Hr, In

Gurugram, Hr, In

Gurugram, Haryana, India

 Identify Liquidity Ratio and Liquidity Capital Ratio by preparing liquidity reports on daily basis measuring all inflows and outflows Evaluate the Assets and Liability position on daily basis by preparing daily reports Calculate daily funding requirement based on inflows and outflows to maintain sufficient cash in the bank Timely review of any regulatory change and implementation Coordinate with various teams to gather prerequisite data for reporting and analysis Work… Show more  Identify Liquidity Ratio and Liquidity Capital Ratio by preparing liquidity reports on daily basis measuring all inflows and outflows Evaluate the Assets and Liability position on daily basis by preparing daily reports Calculate daily funding requirement based on inflows and outflows to maintain sufficient cash in the bank Timely review of any regulatory change and implementation Coordinate with various teams to gather prerequisite data for reporting and analysis Work with related teams to resolve data quality issues Coordinate with Operations, Risk, Compliance, Finance, IT and other teams to ensure accuracy Comparison of data prepared by other teams, discuss the variances, and inform the management for any difference Perform data reconciliation, validation, cross validation at various levels prior to report submission Provide trend analysis, change impact, prior period comparison with commentary for next level review before submission Ensure adequate check and controls in place Ensure data mapping tables are updated for any new product and reporting category to ensure completeness of data Decision making statistical and granular reporting metrics for ILAAP, ICAAP and ALCo meetings Reviewing and challenging data inputs /outputs ensuring financial regulatory information is prepared and disclosed in consistent manner Analyze new regulatory requirement and design end-to-end workflow for reports generation Preparing FSA, PRA, BoE, EBA reports based on the regulatory requirement Calculation of regulatory key metrics and production of financial disclosures Identify and analyze threats to the assets, liabilities and earning capacity Develop tools for Credit, Operational and Regulatory risk reporting with regular updates and ensure accuracy Analyze reports to identify process improvement areas and simplify the workings Build ad-hoc reports through Power BI and in-house portal for various level of data analysis Show less

Gurgaon, India

Profile: Tools and utilities development using VBA/ Macro and SQL for automation process standardization and efficiency improvement Act as SPOC for implementation and Identification of capital saving opportunities and support Large financial datasets handling (SQL Server, Big Data) for different information distribution purposes Hands on experience with querying tool (i.e. Hive and Platfora)  Data Interface Management/Data Reconciliation, support financial databases… Show more Profile: Tools and utilities development using VBA/ Macro and SQL for automation process standardization and efficiency improvement Act as SPOC for implementation and Identification of capital saving opportunities and support Large financial datasets handling (SQL Server, Big Data) for different information distribution purposes Hands on experience with querying tool (i.e. Hive and Platfora)  Data Interface Management/Data Reconciliation, support financial databases, reporting and testing Engage in processes re-engineering resulting in Cost, FTE and men-hour saves Gather required data from respective teams for global / local improvement projects & update stakeholders  Manage the existing set of internally developed VBA based automation toolkit and make continuous enhancements to improve their efficiency Build new Excel template based on COREP (Common Reporting), Basel rules and adhoc financial requests Ensure adherence to Compliance, key controls and assist in the testing of the agreed controls Extensively analyze complex multi-dimensional issues and significantly improve, change or adapt existing methods and techniques Creation of FSA, Pillar 1, Pillar 2, Pillar 3, Customer group & sub-group and Sector Industry Code reports Key member in testing and implementation of COREP and Financial Transformation Platform projects Project SPOC for handling SharePoint access rights, reports uploading, information & notification releasesNotable Milestones: Successfully migrated reporting process (reporting and technical support for Excel, Access, SharePoint) from Hong Kong in Q3’2013 End to end transition of underlying data (PRA RWA) reports creation and distribution process Telephonic transition of multiple additional reports/activities Approximately 94% men hour data processing time saving thorough automation projects Approximately 65% of storage space saving (on shared and local drive) project initiated and implemented successfully Show less

Gurgaon, India

Profile: Transitioned reports documented in SOP and user guides and ensures that documentation are updated and regularly maintained Build and execute plans towards standardization and improvements Analyze the data, propose quality improvement and communicate corrective action and support execution for reporting Create VBA programs to automatically update reports Extract data from SQL Server, analyze and reconcile as per business requirements Extensively use Excel… Show more Profile: Transitioned reports documented in SOP and user guides and ensures that documentation are updated and regularly maintained Build and execute plans towards standardization and improvements Analyze the data, propose quality improvement and communicate corrective action and support execution for reporting Create VBA programs to automatically update reports Extract data from SQL Server, analyze and reconcile as per business requirements Extensively use Excel functions to develop reports by integration to databases Partner with Operations leadership to maintain high levels of automation efficiency Communicate and present analytical findings to the management Responsible for designing and creating tools on Excel and Access through VBA and SQL Automation of manual reports and enhance existing macros Find out corrective-actions, improvement areas, tools trainings/issues for automation Automation of PowerPoint presentation dashboardsNotable Milestones: Successfully migrated 55 reports telephonically from US in two months Highly critical and complex weekly dynamic seating arrangement plan automated for full strength utilization of calling FTEs Star performer appreciation received from department head for two consecutive quarters Show less

 Responsible for designing and creating tools on VBA, Access, Excel and SQL for the client as well as automating existing tool Responsible to manage newly migrated projects reports for loan services Handle all confidential data reporting through Citirx platform Design and develop ad hoc reports using standard database tools Work on various projects to improve accuracy and productivity Evaluate, interpret and analyze data, configuration options, and/or business… Show more  Responsible for designing and creating tools on VBA, Access, Excel and SQL for the client as well as automating existing tool Responsible to manage newly migrated projects reports for loan services Handle all confidential data reporting through Citirx platform Design and develop ad hoc reports using standard database tools Work on various projects to improve accuracy and productivity Evaluate, interpret and analyze data, configuration options, and/or business processes Collect, analyze and document business requirements for cross functional projects Formats and presents data graphically through charts / tables Completed a project for project management with different User and Manager access with animated Charts/Graphs Built a project for FTE’s time management Build tools on Excel/VBA/Access for other team of the organization Show less

Profile: Team management, monitoring, performance, mentoring, training and development of staff Approve expenses and maintaining accuracy reports Training Need Analysis & Identification of Process gaps through regular floor support/data monitoring/Quality data Business analysis on a periodic as well as ad-hoc basis Interact with client on daily basis to seek out the clarifications and updates Extract, control and analyze data so that training/quality requirements… Show more Profile: Team management, monitoring, performance, mentoring, training and development of staff Approve expenses and maintaining accuracy reports Training Need Analysis & Identification of Process gaps through regular floor support/data monitoring/Quality data Business analysis on a periodic as well as ad-hoc basis Interact with client on daily basis to seek out the clarifications and updates Extract, control and analyze data so that training/quality requirements for the process can be assessed Identifies areas of concerns and opportunities for performance improvements Create macros (VBA) to automate the data extraction and reports preparation Undertake Trend Analysis of Data and Automation of reports Prepare dashboards of process performance for periodical review, quality/audit team and client review Generate reports on the basis of TAT, SLA, accuracy, volume, funds, production, staffing, incentives etc. Assistance on Relocation, Career Assistance, Shipment, Real Estate, Billing and other related services to relocating employees Audit and process expense reports, direct bill invoices submitted by transferees and vendors Review processed expenses on the basis of policy, client specifications, latest updates & taxationNotable milestones: Awarded as Star Performer in Quarterly R & R Appreciation from client on various analytical reports and dashboards Star Performer Award in monthly R & R for contribution in continuous process improvement activities Show less

 Responsible for preparing different kinds of repots as per the business requirement Completion of Task within the timelines Creating and maintaining reports in Excel that allows the company to get information on daily business activities.  Handling all types of retail and corporate post paid acquisition provisioning data Creating MIS/ Dashboard report and presentation Making process performance reports and analyzing them from company prospect Design reporting… Show more  Responsible for preparing different kinds of repots as per the business requirement Completion of Task within the timelines Creating and maintaining reports in Excel that allows the company to get information on daily business activities.  Handling all types of retail and corporate post paid acquisition provisioning data Creating MIS/ Dashboard report and presentation Making process performance reports and analyzing them from company prospect Design reporting formats to provide accurate information in a clear and concise manner Review history of current reporting used analyze for time utilization, consistency and accuracy Generating daily/weekly/monthly reports on the basis of TAT, volume, activation, discrepancy, agent etc.  Preparing various MIS/reports meeting and exceeding activation of no. on defined service level metrics on timeliness and accuracy Handling bulk activations through utility High priority and exception processing Input validation of Subscriber Enrolment Form (it includes all documentation process) Involved in yellow belt six sigma project reducing provisioning errors from 8% to 0.34% Responsible for Corporate & SME activation within TAT of 4 Hrs for all CSA’s Handling SEF screening data for checking SEF & documents as per DOT guidelines so as to ensure of correct documentation and 100% SEF compliance Bulk activation data through Utility and Manual Show less

Master Of Business Administration (M.B.A.), Operations Management And Supervision, A

Postgraduate Diploma, Artificial Intelligence And Machine Learning, A

Bachelor’S Degree, Accounts