ABHISHEK RANJAN
Hyderabad
Summary
Analytical and detail-oriented Data Analyst with 3+ years of experience in collecting, analyzing, and interpreting complex data sets to drive business decision-making. Proficient in statistical analysis and data visualization tools such as Python, SQL, and Tableau. Strong problem-solving skills and ability to communicate data insights effectively to stakeholders. Looking to leverage my skills to contribute to a dynamic organization.
Overview
4
4
years of professional experience
Work History
Data Analyst
INDIUM SOFTWARE INDIA PRIVATE LIMITED
Hyderabad
05.2024 - Current
- Recently Joined
- Going through knowledge Transfer.
Data Analyst
LIFEBYTE SYSTEMS PVT LTD
02.2023 - Current
- Applied comprehensive knowledge to handle large trading datasets, covering diverse markets such as forex, crypto, oil, bullion, etc
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Collaborated with stakeholders across the organization to understand their needs from a data perspective.
- Maintained documentation of all the processes related to Data Analysis.
- Performed quality assurance testing on newly developed reporting solutions.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Developed dashboards with Tableau to monitor key performance indicators.
- Designed and implemented Python-based lambdas, showcasing expertise in seamlessly integrating diverse trading data
- Developed custom features using Python to enhance data processing and analysis capabilities
- Formulated and executed Snowflake queries to extract valuable insights and generate targeted reports
- Leveraged AWS services, including Athena, S3, and Lambda, for effective management and integration of trading data
- Implemented Step Functions and Workflow Studio in AWS, enhancing automation and orchestration of complex data processes for optimized workflow efficiency
- Demonstrated proficiency in SQL by writing queries exceeding 500 lines, showcasing the ability to handle complex data manipulations and extractions.
Data Analyst
KOSI DUGDH UTPADAK SAHKARI SANGH LTD
06.2021 - 02.2023
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Provided data-driven solutions to support decision making.
- Leveraged SQL queries to extract, transform and load data into databases.
- Generated tabular and visualization reports to effectively communicate data insights.
- Conducted exploratory analysis of complex datasets using Python libraries such as NumPy and Pandas.
- Communicated with customers, competitors and suppliers to stay abreast of industry or business trends.
Mechanical Engineer (In-Charge Engineer)
KOSI DUGDH UTPADAK SAHKARI SANGH LTD
01.2020 - 06.2021
- Provided oversight for the installation process, ensuring the successful setup of the curd/buttermilk plant
- Contributed to improvements in the existing milk plant infrastructure
- Led a team responsible for the daily maintenance of machineries
- Oversaw routine upkeep activities to ensure optimal performance and longevity of equipment
- Supported leaders in decision-making processes and provided guidance to management on project bids for on-site improvements
- Monitored employee work tasks during the installation, alignment, and balancing of new equipment for projects.
Education
Data Analyst - Data Analysis
Masai School
Bengaluru01.2023
Mechanical Engineering
National Institute of Technology Patna
Patna05-2019
Skills
- SQL
- Snowflake
- Pandas
- MS Advance Excel
- AWS
- Python
- Tableau
- Power BI
Projects
Job Analytics
Utilized Selenium and Beautiful Soup for data scraping from LinkedIn.
Conducted data cleaning and pre-processing tasks. Analyzed data, extracted insights using SQL, and developed a dashboard.
Developed a web page using Flask and HTML.
Air-New Zealand Entering in Indian Domestic Market
Conducted research on Air New Zealand's company size, stakeholders, market position, and investors.
Implemented data cleaning and pre-processing techniques.
Studied profitability and failure frameworks, utilizing guesstimates to determine the break-even period.
Developed strategies for Air New Zealand to enter the Indian domestic market, providing recommendations based on the analysis.
Investor Advisor
Conducted analysis of stocks listed in BSE 500.
Established connection between Google Spreadsheet and Python.
Performed data cleaning and created interactive dashboards.
Languages
Hindi
First Language
English
Proficient (C2)
C2
Accomplishments
Received the prestigious Bhaichung Bhutia Special Scholarship Award from Masai in recognition of outstanding academic performance. The award was personally presented by Bhaichung Bhutia, adding a distinctive honor to the acknowledgment.
Timeline
Data Analyst
INDIUM SOFTWARE INDIA PRIVATE LIMITED
05.2024 - Current
Data Analyst
LIFEBYTE SYSTEMS PVT LTD
02.2023 - Current
Data Analyst
KOSI DUGDH UTPADAK SAHKARI SANGH LTD
06.2021 - 02.2023
Mechanical Engineer (In-Charge Engineer)
KOSI DUGDH UTPADAK SAHKARI SANGH LTD
01.2020 - 06.2021
Data Analyst - Data Analysis
Masai School
Mechanical Engineering
National Institute of Technology Patna
Similar Profiles
Kishore NarasapuramKishore Narasapuram
Test Engineer at INDIUM SOFTWARE(INDIA) PRIVATE LIMITEDTest Engineer at INDIUM SOFTWARE(INDIA) PRIVATE LIMITED
Lakshminarasimman SLakshminarasimman S
Senior Tech Lead at Indium Software Private LimitedSenior Tech Lead at Indium Software Private Limited
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited