Ratan Singh
Data Analyst
Bengaluru
Summary
Adept at transforming data into actionable insights, leveraged SQL and Python for advanced data analysis at Talent Sketchers PVT LTD, enhancing decision-making and operational efficiency. Collaborative approach and expertise in Tableau and Power BI drove strategic improvements, demonstrating a strong blend of technical proficiency and teamwork.
Overview
5
5
years of professional experience
2
2
Languages
Work History
Data Analyst Consultant
Talent Sketchers PVT LTD
Pune
12.2023 - Current
- Developed custom data models to provide actionable insights for business decision making.
- Identified trends and patterns in complex datasets, driving strategic recommendations for process improvements.
- Create compelling visualizations using Tableau and Power BI to present data insights.
- Automated routine reporting tasks, saving time and resources while minimizing human error.
- Conducted detailed data analysis using SQL and Python, identifying key trends and patterns.
- Automated generation of risk assessment reports, reducing time required for reporting by 40% and improving report accuracy.
- Gather data from various sources such as databases, spreadsheets, and APIs.
- Use SQL to query and extract data from relational databases.
- Clean and preprocess raw data to ensure accuracy and consistency.
Data Analyst
Wipro Limited
12.2022 - 07.2023
- Produced monthly reports using advanced Excel spreadsheet functions.
- Developed predictive models in Python that increased sales forecast accuracy by 20%.
- Automated weekly reports using SQL and Python, reducing reporting time by 40%.
- Utilized data visualization tools to effectively communicate business insights.
- Collaborate with cross-functional teams including marketing, finance, and operations to understand data needs.
- Prepare detailed reports summarizing key insights, trends, and actionable recommendations.
- Stay updated with latest data analytics tools, techniques, and best practices.
- Perform data transformation using Python and R for advanced processing tasks.
Data Analyst
Concentrix
07.2021 - 08.2022
- Produced monthly reports using advanced Excel spreadsheet functions.
- Used statistical methods to analyze data and generate useful business reports.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Utilized data visualization tools to effectively communicate business insights.
- Participated in requirements meetings to understand business needs.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Documented effective and replicable methods for extracting data and organizing data sources.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
Transaction & Risk Analyst
Aegis PVT LTD
10.2019 - 04.2021
- Reduced financial losses by identifying suspicious patterns in transactional data and escalating cases to appropriate teams.
- Evaluated third-party relationships from risk perspective, recommending necessary actions to mitigate potential threats or vulnerabilities.
- Developed comprehensive reports highlighting trends, risks, and recommendations for senior management review and action planning.
- Conduct detailed analysis of transactional data to identify potential fraud.
- Generate daily, weekly, and monthly reports on transaction risks, trends, and key metrics using Excel.
- Provide insights and recommendations to senior management based on data analysis and risk assessments.
- Conduct thorough investigations into flagged transactions, gathering evidence and documentation.
- Enhanced the accuracy of risk scoring models by incorporating machine learning techniques, resulting in a 20% improvement in fraud detection rates.
Education
Bachelor of Computer Applications - Computer Application
Magadh University
Patna, India 04.2001 -
Skills
SQL: Advanced querying, data extraction, and database management
Python: Data manipulation, statistical analysis, and machine learning
R: Data analysis, statistical modeling, and visualization
Tableau: Interactive dashboards and data visualization
Excel: Data organization, pivot tables, and advanced formulas
Power BI: Business intelligence and data visualization
Data Cleaning: Ensuring data accuracy and consistency
Statistical Analysis: Identifying patterns and relationships
Playing Cricket & Net Surfing
Teamwork and Collaboration: Playing cricket involves working closely with teammates to achieve common goals, fostering strong communication and cooperation skills.
Strategic Thinking: Cricket requires strategic planning and quick decision-making, helping to develop critical thinking and problem-solving abilities.
Physical Fitness: Regularly playing cricket helps maintain physical health and stamina, contributing to overall well-being.
Leadership Skills: Leading or managing a cricket team can enhance leadership and organizational skills, useful in professional and personal life.
Research and Information Gathering: Net surfing involves exploring various online resources to gather information, enhancing research skills and knowledge across diverse topics.
Tech Savviness: Regular use of the internet helps in staying updated with the latest technology trends and digital tools.
Learning Opportunities: The internet offers endless learning opportunities through online courses, tutorials, and articles, promoting continuous education and skill development.
Timeline
Data Analyst Consultant
Talent Sketchers PVT LTD
12.2023 - Current
Data Analyst
Wipro Limited
12.2022 - 07.2023
Data Analyst
Concentrix
07.2021 - 08.2022
Transaction & Risk Analyst
Aegis PVT LTD
10.2019 - 04.2021
Bachelor of Computer Applications - Computer Application
Magadh University
04.2001 -
Similar Profiles
SOURABH SINGLASOURABH SINGLA
Sr Linux Cloud Engineer at Talent SketchersSr Linux Cloud Engineer at Talent Sketchers
Jyoti Jyoti null
Sr. Software Engineer at Talent SketchersSr. Software Engineer at Talent Sketchers
Gunjeet KaurGunjeet Kaur
Full-time Writer, Career Counselor at Bridge Talent Pvt. Ltd. (Careerio/Talent Inc.)Full-time Writer, Career Counselor at Bridge Talent Pvt. Ltd. (Careerio/Talent Inc.)
Madhuri KonduruMadhuri Konduru
Assistant Manager at VodafoneAssistant Manager at Vodafone
Sandhya CSandhya C
Assistant Manager – People Advisory Services at Ernst and YoungAssistant Manager – People Advisory Services at Ernst and Young