Jay Kishor Roy
New Delhi
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
8
8
years of professional experience
Work History
Data Analyst
Nature Bio Foods Ltd
Gurgaon
01.2022 - Current
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Researched and resolved issues regarding integrity of data flow into databases.
- Developed tables, views and materialized views using SQL.
- Articulated risks and issues to communicate concerns to various levels of management.
- Developed and improved integrated reporting and analysis capabilities.
- Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies.
- Assessed business requirements to forecast annual budgetary operational costs.
MIS Executive (Associate Payroll-TP)
RBL Bank Ltd
Gurgaon
12.2019 - 01.2022
- Planned and led administration of management information system for achieving threshold-level performance.
- Produced tables, pivot reports and charts for use in key decision-making processes.
- Generated reports each month covering sales data.
- Outlined MIS upgrade roadmap and ordered corrective actions to elevate performance.
- Determined data retention parameters based on organizational requirements.
- Tracked departmental expenditures, project schedules and team performance and progress.
- Assessed business requirements to forecast annual budgetary operational costs.
- Led agile teams to deliver products quickly and to respond to user requirements.
MIS Executive (Associate Payroll-OICS)
Bharati Airtel Ltd
Gurgaon
02.2015 - 12.2019
- Prepare Daily, Weekly, Monthly & Yearly MIS of Suspended & New Acquisition base in comparison of Last day/Last Month/ Last Year etc
- Prepare base for SMS and OBD communication of suspended & new acquisition customer’s (Millions of Base) using SQL
- Analyze retention of suspended base (Millions of Base) of different bucket
- Sharing suspended calling base to call center's & tracking their retention MIS
- Gathering user’s requirement for new reports and enhance existing reports
- Providing support to the Business Manager with ad hoc task when necessary.
Education
B. Com - Commerce
IEC University
Himachal Pradesh06.2018
10+2 - Commerce
Assam Higher Secondary Education Council
Assam05.2010
10th -
Board Of Secondary Education
Assam05.2008
Skills
- Data Modeling
- Data Analysis
- Database Management
- Reporting Tools
- BI Tool and System Design
- Database Optimization
- Database Analysis
Languages
Hindi
Bilingual or Proficient (C2)
English
Intermediate (B1)
Assamese
Upper intermediate (B2)
Software
SQL SERVER
MYSQL
POWER BI
MS OFFICE
MS ACCESS
Timeline
Data Analyst
Nature Bio Foods Ltd
01.2022 - Current
MIS Executive (Associate Payroll-TP)
RBL Bank Ltd
12.2019 - 01.2022
MIS Executive (Associate Payroll-OICS)
Bharati Airtel Ltd
02.2015 - 12.2019
B. Com - Commerce
IEC University
10+2 - Commerce
Assam Higher Secondary Education Council
10th -
Board Of Secondary Education
Similar Profiles
Sumit KumarSumit Kumar
Sr. Executive In Logistics Department at Nature Bio Foods Ltd. Part of Lt FoodsSr. Executive In Logistics Department at Nature Bio Foods Ltd. Part of Lt Foods
Jharna SaxenaJharna Saxena
Quality Executive at Nature Bio Foods LimitedQuality Executive at Nature Bio Foods Limited
Peter GithuPeter Githu
Regional Sales Manager at Bio Foods LimitedRegional Sales Manager at Bio Foods Limited