SANJAY RATHI
Business Analyst
New Delhi
Summary
Business Analyst successful at responding to shifting business needs and priorities. Well-versed in operational assessment strategies and functional analysis methodologies for businesses of different sizes. Quantitative expert with comprehensive approach to analytical projects, business reporting and process improvements.
Overview
10
10
years of professional experience
1
1
Language
Work History
Data Analyst
THOMSON DIGITAL
- Worked with Chief Executive Officers Thomson Digital for
- Managing timely delivery of journals articles to client Coordination with department heads for better workflow
- Allocation of jobs to departments by the means of file management system
- Analyzing better quality assurance in every department
- Responsible for generating different departmental MIS reports and data presentation in data in charts, graphs, tables like
- Open status
- Inflow and outflow of articles
- Reconciliation report
- Delivery report of articles
- Production report
Business Analyst, Other Financial Products
The Muthoot Group
04.2020 - Current
- The Muthoot Group is a financial conglomerate and also have 20 diversified business divisions working under various domains other than gold loans like
- Money transfer (Domestic, International & Indo Nepal Remittance)
- Forex services (Outward Remittance, Currency purchase & travel cards)
- Gold Coins & Jewelry sales
- Insurance broker (Life, Health, Vehicle, OTC & other customized insurance policies customized for the muthoot customers)
- Securities (Offers PAN & Demat)
- Wealth services......and many more divisions
- My role in coordination with the product heads / stakeholders (#Other Financial Products)
- Target allocation across NEW MFIN branches as per their demographic, footfalls & business opportunities in catchment area and branch business portfolio
- Marketing budget allocations / recommendations for growing the OFPs
- Over all MIS / fact sheets presentations for each OFPs
- Providing Research/Methodological/Statistical & Analytical support
- Develop actionable roadmaps for improving workflows and processes, and establish and organize KPIs in line with directives
- To provide every Business Intelligence support for every regional / zonal / corporate office
- Acting SPOC to resolve all escalations related to business operations
- Assisting DGM, for every possible support in driving business across all OFPs
- Other responsibilities - coordination with marketing department for designing online & offline campaigns
- Analyzed open orders, backlog and sales data to provide sales team with insights.
- Researched competitors to build report of rising trends in the markets.
Business Analyst, Sales & Operaations
The Muthoot Group
02.2015 - 03.2020
- Working in coordination with “operation, sales & marketing” for Gold Loan report generation and the complete analysis over the financial market to prepare the fact-sheet and Data Analysis, MIS reporting and segregated reports within the deadline
- Ad-hoc report designing for MIS
- Fact-sheet Reports preparation using Business Intelligence tools (MICROSOFT POWER BI) & publishing over the intranet of the company
- Preparation of new datasets from raw sets files using Import techniques and modified existing data sets using set, merge, update, formats, data conversion, validation, cleaning, options and functions
- Moving data sets across platforms from PC
- Imported and converted data files from Text based data files into Excel data sets for analysis
- Data analysis and manipulation of data by using advanced excel and access tools
- Involved in the Production of MIS Reports with frequency of - Weekly, Monthly, Quarterly and yearly to know the business flow
- Muthoot Finance Branch Staff interaction with understanding of the whole report design and Ad-hoc reports generation
- Presenting financial data in charts, graphs, tables, designing and developing for company’s board of director’s meetings presentations
- Responsibilities capturing data from multiple sources (internal/external client, databases etc.) into a centralized dataset
- Analyzing the dataset and keeping it updated with regular maintenance
- Reporting relevant information to senior manager
- Data analysis and manipulation of data by using advanced excel and access tools
- Business forecasting whether it’s positive or negative and give recommendation to the managers
- Organizing and managing monthly sales contests
- Quarterly incentive preparations and distributions as per the achievements
- Tracking of leads captured through :
- Company’s customer relationship management software’s
- Muthoot Finance white label ATM’s across, the NEW 23 regions
- Marketing campaigns like SMS, Missed call, email and social networking sites and transferring to the respective regions call center for conversion.
Education
Information Technology
National Institude of Information Technology
New DelhiB.A. -
Delhi University
12th, High School -
Kendriya
New Delhi10th, Secondary School -
CRPF Public School)
New DelhiSkills
Good knowledge of computer applications
Analytical tools like MS Power BI, Tableau, Qlik
Database software’s, SQL, MSSQL, MySQLCore banking software (CBS) and Customer relationship management (CRM) applicationsMicrosoft Office (word, excel, power point etc)Timeline
Business Analyst, Other Financial Products
The Muthoot Group
04.2020 - Current
Business Analyst, Sales & Operaations
The Muthoot Group
02.2015 - 03.2020
Data Analyst
THOMSON DIGITAL
Information Technology
National Institude of Information Technology
B.A. -
Delhi University
12th, High School -
Kendriya
10th, Secondary School -
CRPF Public School)