Rahul Kumar Meher
Bargarh,Odisha
Summary
Highly motivated and detail-oriented data analyst offering 6 years of industry success. Expertise in data analysis, visualization, and reporting. Skilled in designing and implementing data collection systems to address business requirements. A collaborative team player with a track record of delivering actionable insights that boost revenue growth and operational efficiency.
Overview
6
6
years of professional experience
Work History
Business analyst
Genpact India Private limited
08.2021 - Current
- Developed and maintained Hive scripts to extract data from the data lake and generate comprehensive reports
- These scripts are used for efficient data retrieval and report generation, ensuring timely delivery of insights and analysis
- Providing data analysis and accuracy on a continuous basis
- Actively leading and part to the batch monitoring team, ensuring accurate data extraction
- Focused on analyzing batch operations to guarantee flawless data retrieval and verify the data trend
- Proficient in script adjustment to resolve discrepancies and ensure data retrieval
- Implemented data lineage to track flow of scripts, batches and reports
- Managing number of daily/weekly/monthly reports (Power bi) for the different business of the process
- Implemented reference data solution for ingest flat file data into datalake
- End to end project management including day-to-day delivery, reporting, and escalations
- Communicate and co-ordinate with different teams and act as a point of contact for end user for any data related request or service issues
- Interacted with business users, collected the requirements, analyze the requirements, design and recommend the solutions.
- Worked on Automating, Optimizing, setting up new process in campaign management using PL/SQL, Stored Procedure, packages. Involved in modifying various existing procedures, packages according to business needs.
- Data validation error mitigation and exception handling for multiple accounts.
- Ensure to complete deliverables and maintain 100% TAT.
- Designing and leading execution of process to validate performance and identify new area of opportunity.
Project 1: One & All (18th August 2021-July 2022)
Associate Consultant Technical
Wipro limited
10.2019 - 08.2021
- Requirement gathering from the Business Team
- Debugging existing issues and working on new enhancement
- Created Database Objects like Tables, Views, Sequences, Synonyms, Stored procedures, functions, packages, cursors, ref cursors
- Involved in modifying various existing Procedures, Functions, Views and packages according to the new business needs
- Wrote SQL Queries using Joins, Sub Queries and Correlated Sub Queries to retrieve data from the database
- Trouble shooting of database live issue, providing data patches in production environment
- Improved the performance of the application by rewriting the SQL queries
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries
- Helped team of 5 lead consultants optimize efficiency of current systems by conducting training sessions.
Software engineer
Vara Infotech
10.2018 - 09.2019
- Involved in modifying various existing Procedures, Functions, and Triggers according to the new business needs
- Responsible for implementing FILESECURE to different internal teams by understanding their business process and assisting them in UAT phase and played a key role for Go-Live
- Wrote SQL Queries using Joins, Sub Queries and view to retrieve data from the database
- Send status of no of file protected on daily, weekly, monthly to business
- Preparing maintenance plans and upgrading schedules for the organization's systems
- Working with application issue and analyze the root cause analysis from server logs through arcos
- Applying Database patches as per the Bank's Policy
Education
Bachelor of Technology - Computer Science and Engineering
Vivekananda Institute of Technology
Bhubaneswar01.2014
Skills
- SQL
- Power BI
- Excel
- Hive
- Oracle Database
- PL/SQL
- Hadoop
Languages
English
Odia
Hindi
Disclaimer
I do hereby declare that the above written particulars are true to the best of my knowledge and belief.
Personal Information
- Father's Name: Parikshit Meher
- Date of Birth: 11/14/92
- Gender: Male
- Nationality: Indian
- Religion: Hindu
Timeline
Business analyst
Genpact India Private limited
08.2021 - Current
Associate Consultant Technical
Wipro limited
10.2019 - 08.2021
Software engineer
Vara Infotech
10.2018 - 09.2019
Bachelor of Technology - Computer Science and Engineering
Vivekananda Institute of Technology
Similar Profiles
Ashwini DAshwini D
Process Associate at Genpact India Private LimitedProcess Associate at Genpact India Private Limited
HRUSHITHA MANEPALLIHRUSHITHA MANEPALLI
Content Moderator at Genpact India Private LimitedContent Moderator at Genpact India Private Limited
SHILPA SINGHSHILPA SINGH
Management Trainee - Finance RTR at GENPACT INDIA PRIVATE LIMITEDManagement Trainee - Finance RTR at GENPACT INDIA PRIVATE LIMITED