Oshim Mahajan
Batala
Summary
Around 8.5 years of experience in Design,Development and Delivering of Business Intelligence solutions and demonstrated history in working in the retail,finance and ecommerce industry. Work well on driving insights and analytics approach for finding the solutions. Having good experience in gathering requirements, design, development,testing and validating the data. Good experience in troubleshooting and in performance tuning.
Overview
9
9
years of professional experience
Work History
Lead Data Analyst
Peritussoft
12.2022 - Current
- Collaborated with the business to gather requirements, analyzed them, and provided insights to stakeholders to support business growth and improvement.
- Contributed to a data migration project, overseeing the transfer from SFDC to Zuora.
- Led the Quote Automation Project, with the primary responsibility of configuring data for automatic renewal, eliminating the need for manual intervention.
Data Analyst
Raena
12.2021 - 11.2022
- Gather Requirement from the business users and get the required data sources.
- Analysed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Fetching the dataset into the Power BI and leveraging charts and patterns.
- Creating custom fields wherever required.
- Interpreted business questions and build report as per the requirement.
- Publish the dashboard and subscribe it to the concerned users.
Data Analyst
Plan Source
04.2021 - 12.2021
- Working in an InsightsIQ team. Thus, participated in requirements meetings to understand business needs as we need to create dashboards for the clients who are using our application.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Researched and analyse data required for the dashboard and in any issue regarding integrity of data flow into databases, reporting it to the engineering team.
- Identified, analysed and interpreted trends or patterns in complex data sets.
- Created reports on Power BI to glean insights into trends and prospects.
Reporting Analyst
Bajaj Finserv
09.2018 - 03.2021
- Being Working in a Data Science team and supporting different sub teams like marketing, sales and cross-sell teams. Taking requests on building reports which they require daily to send their sales team or to get the conversion from their campaigns. Building reports on the new initiatives and existing utilities to track the business growth.
- Key resource for creating dynamic ppts using Power BI for the monthly or quarterly meetings which we need to create manually each month. we are just refreshing the data each time and fetching automatic ppts.
- Build various reports for festive season tracking , risk metrics tracking, customers behavioral etc using various charts like bar chart, stacked bar chart, kpi card, guage , trend line chart, pie chart, area chart etc.
- Responsible for validating, publishing and subscribing the dashboard.
Programmer Analyst
Bitwise global solutions
06.2016 - 08.2018
- Working in a forecasting team and key responsible for fetching data using sql scripts to analyze the data for the business requirement.
- Write sql scripts for the reporting using SSRS.
- Responsible for handling ETL validation and supporting adhoc requests.
- Responsible for migrating reports from SSRS to Power BI.
- Responsible for validating the data.
Education
Bachelor of Science - Computer science
Amritsar College of engg & technology
2016
Skills
- SQL
- Power BI
- Tableau
- SSRS
- Looker
- Metabase
- Postgress Sql
- Redshift Sql
- Shell scripting
- JIRA
- Confluence
Timeline
Lead Data Analyst
Peritussoft
12.2022 - Current
Data Analyst
Raena
12.2021 - 11.2022
Data Analyst
Plan Source
04.2021 - 12.2021
Reporting Analyst
Bajaj Finserv
09.2018 - 03.2021
Programmer Analyst
Bitwise global solutions
06.2016 - 08.2018
Bachelor of Science - Computer science
Amritsar College of engg & technology
Similar Profiles
Pritinder SinghPritinder Singh
Driver, Warehouse Orders at Mico Diesel ServiceDriver, Warehouse Orders at Mico Diesel Service
Supreet KaurSupreet Kaur
Student Nurse at Dayanand Medical College & Hospital, Civil LinesStudent Nurse at Dayanand Medical College & Hospital, Civil Lines
Vasu GakharVasu Gakhar
E-commerce Data Assistant , Graphic Designer at Vausm Technologies Private LimitedE-commerce Data Assistant , Graphic Designer at Vausm Technologies Private Limited