Ajay Kumar
Summary
BUSINESS INTELLIGENCE PROJECTS:
Business 360 – Atliq Hardwares [Power BI | SQL | Excel | Dax Studio]
Established a Power BI dashboard gathering Finance, Sales, Marketing, and Supply Chain data, optimizing with DAX Studio. Resulted in a 5% performance boost and projected 10% revenue growth and 20% data-related expense reduction.
Hospitality Analysis - Hotel Chain Business [Power BI | Excel]
Atliq Grands identified a decline in market share and revenue over several months, prompting the need for a comprehensive analysis. I developed a Power BI dashboard using three months' worth of data to provide valuable insights and regain a 20% increase in both revenue and market share.
Supply chain data analysis - [Power BI | Excel]
Developed a Power BI dashboard aimed to monitor the service levels of AtliQ Mart, an FMCG manufacturer, utilizing six months' worth of data aiming for a 20% cost savings in expansion efforts
Food and Beverage Industry analysis - [Power BI | CSV]
Investigated dynamic buying patterns in the food industry, analyzing customer data and generating actionable insights that optimized marketing campaigns, resulting in a 20% increase in customer engagement and a 15% boost in sales revenue.
Overview
14
14
years of professional experience
Work History
Data Analyst
2023.09 - Current
- Leverage 6+ years of experience as an agency owner to provide data-driven insights, empowering clients with strategic recommendations for informed decision-making and growth.
Co-Founder & Director
RAURnet Solutions Pvt Ltd
2017.06 - 2023.08
- Co-founded and directed a thriving software solutions company, orchestrating all aspects of business operations, driving development initiatives, and achieving a 200% increase in annual revenue within three years.
Team Lead
MyZeal IT Solutions
2017.01 - 2017.06
- Led a PHP development team, achieving a 15% increase in resource efficiency, resulting in a 20% reduction in development costs.
Good Health Naturally Inc
2014.04 - 2016.04
- Played a key role in software development and management at Good Health Naturally Inc
- UK, significantly improving operational efficiency and contributing to a 20% increase in company performance
- Successfully developed and managed five live stores, optimizing back-end, front-end, and Admin interfaces, while implementing vTiger 5.4-based CRMs, leading to a 20% improvement in store performance and customer satisfaction.
Senior Member Technical Staff, senior technical
Softona Technologies Pvt Ltd
Sahibabad
2013.04 - 2014.04
- Role at Softona Technologies, driving software development and providing effective technical leadership, which led to a 30% improvement in project efficiency and performance.
Sr. Software Engineer
winIND Technology Pvt Ltd
2012.04 - 2013.03
- Software engineer at winIND Technology, making significant contributions to software projects and achieving a 10% increase in project efficiency and successful project delivery.
Web Application Developer
Netcop Technologies Pvt Ltd
Ghaziabad
2011.08 - 2012.04
- Significantly contributed to web application development, and successfully developed a Web-Based CMS for a group of 10+ companies, resulting in a 20% increase in customer engagement.
Team Leader
Sologenx Corporation
Indore
2010.04 - 2011.03
- Managed a team at Sologenx Corporation, effectively overseeing projects and development efforts, resulting in a 15% improvement in project completion rates and customer satisfaction
- Disclaimer: The information provided in this resume is accurate to the best of my knowledge
- I understand that any misrepresentation may lead to disqualification from job opportunities or termination if already employed
- Thank you and best regards
- Ajay Kumar
Education
P.G.D - Information Security & Application Development
Center for Development & Advance Computing
M.Sc. - Information Technology
Sikkim Manipal University
01
B.Sc. - Information Technology
Sikkim Manipal University
01
Skills
- Analytical Tool
- Power BI, Advanced Excel
- Database
- MySQL, SQL Server
- Programming Languages
- PHP, Python
- CRM
- VTiger, Btrix24, Infusionsoft, Hubspot, RAURcrm, BrightPearl
- Project Management Tool
- WebCollab, Asana, RAURprojects, IFM Matrix
- E-Commerce
- Product and Inventory management, Pinnacle Cart, Prestashop, Magento, Shopify
- Cloud Computing Platform
- AWS
- Business intelligence
- Client Engagement, Sales and Deal Closure, Team Leadership, Strategic Planning
Accomplishments
- ISO Management System for CDAC-NOIDA
- Inventory Management System for CPWD-Presidential-House
- ERP for CRS
- Online Learning Management System
- Digital Document Management System
- Project Management System
- Company Management System
- Hospital Management System
- Recruitment Management System
- Indian Railways File Tracking System
- E-COMMERCE CORE PROJECTS:
- Https://www.mitchellusa.co.in/
- Https://www.usprobateleads.com/
- Https://goodhealthnaturally.com/
- Https://wholesalehealthltd.co.uk/
- Https://raurtea.com/
- GLOBAL CLIENT ENGAGEMENT:
- Global Client Interaction: Collaborated directly with overseas clients, including Ulaanbaatar, Mongolia, engaging with 6+ department heads to thoroughly comprehend their unique requirements
- Overcoming Currency Challenges: Managed complex currency conversion, addressing the Mongolian Tugrik and USD, ensuring seamless integration within the CRM
- Quantifiable Impact: Delivered tangible results, such as enhanced efficiency, cost savings upto 30%, and improved customer relations, positively influencing clients' businesses
- Excel: Mother of Business Intelligence
- Power BI: Data Analytics Tools For All Levels
- SQL: The Salt of Data Science.
Timeline
Data Analyst
2023.09 - Current
Co-Founder & Director
RAURnet Solutions Pvt Ltd
2017.06 - 2023.08
Team Lead
MyZeal IT Solutions
2017.01 - 2017.06
Good Health Naturally Inc
2014.04 - 2016.04
Senior Member Technical Staff, senior technical
Softona Technologies Pvt Ltd
2013.04 - 2014.04
Sr. Software Engineer
winIND Technology Pvt Ltd
2012.04 - 2013.03
Web Application Developer
Netcop Technologies Pvt Ltd
2011.08 - 2012.04
Team Leader
Sologenx Corporation
2010.04 - 2011.03
P.G.D - Information Security & Application Development
Center for Development & Advance Computing
M.Sc. - Information Technology
Sikkim Manipal University
B.Sc. - Information Technology
Sikkim Manipal University