Rajan Kumar
Summary
Detail-oriented MIS Executive with over 1 year of experience in MIS reporting, data validation, and dashboard development. Proficient in Excel, SQL, Power BI, Tableau, Power Query, Google BigQuery, and Snowflake. Delivered accurate data insights that enhanced decision-making for global publishing clients.
Overview
1
1
Certification
1
1
year of professional experience
Work History
MIS Executive / Data Operations
MPS Limited
Noida
02.2025 - Current
- Utilized Google BigQuery and SQL for data extraction, validation, and reporting, enhancing data accessibility.
- Perform data validation and quality assurance activities to ensure data accuracy and consistency.
- Prepare daily, weekly, and monthly MIS reports to track operational performance and project progress.
- Improved reporting efficiency by streamlining manual processes and implementing automation, reducing time spent on repetitive tasks.
- Develop automated reporting solutions using Excel, Power Query, and Google Sheets.
- Collaborated with internal stakeholders to identify and resolve data discrepancies, ensuring data integrity across projects.
- Support business operations through accurate reporting and data-driven insights.
- Execute journal migration projects for international publishing clients including Springer Nature and Macmillan.
- Successfully supported large-scale journal migration projects while maintaining high data quality standards.
Education
Bachelor of Business Administration -
University of Lucknow
01-2022
Intermediate -
U.P. Board
01-2019
High School -
U.P. Board
01-2017
Skills
- SQL and Google BigQuery
- Data cleaning and migration
- Business and MIS reporting
- Data analysis and visualization
- Microsoft Excel (advanced) and Power Query
- Google Sheets and Microsoft Office Suite
- Power BI and Tableau
- Snowflake
Certification
- Advanced Power Query for Data Analysis
- Microsoft Office Specialist
- Tableau for Data Analytics
- Snowflake Fundamentals
- SQL & Power BI From Udemy
Accomplishments
- First team member to receive direct client appreciation for contribution to Springer Nature project.
- Recognized for maintaining data integrity and delivering high-quality project outputs.
- Demonstrated strong ownership and accountability in client-facing data operations projects.
Projects
- Sales Performance Dashboard, Power BI, Developed an interactive dashboard to analyze sales, profit, customer performance, and regional trends. Created KPI cards, drill-through reports, and business performance visualizations. Utilized Power Query and DAX for data transformation and analysis.
- Business Analytics Using SQL, Solved real-world business problems using Joins, CTEs, Window Functions, Subseries, Views, and Stored Procedures. Performed customer, sales, and product performance analysis using SQL.
- Tableau Sales Analytics Dashboard, Designed an interactive Tableau dashboard with filters, calculated fields, KPIs, and trend analysis. Implemented data modeling concepts and visual storytelling techniques.
- Snowflake Data Warehouse Project, Created and managed database objects including tables, views, and warehouses. Performed data loading, querying, and analytical reporting using Snowflake SQL.
Timeline
MIS Executive / Data Operations
MPS Limited
02.2025 - Current
Bachelor of Business Administration -
University of Lucknow
Intermediate -
U.P. Board
High School -
U.P. Board