Hello, I am
kumari akanksha.

1
Excel Project

4
PowerBI Projects

1
SQL Project

1
Python Project
About Me
Software Engineer with 6 years in system development and analysis, transitioning into a Data Analyst role. Skilled in extracting insights from complex datasets, optimizing queries, and building interactive dashboards to improve operational efficiency.
Key Skills
mysql
python
pandas
stakeholder management
problem solving
effective communication
power bi
unix
splunk
business intelligence
jira
service now
data modelling
My Experience
IIM Bangalore | Data Analyst | Jun 2024 - Aug 2024
Analyzed 5 yrs of placement data for over 1000 companies using Advanced Excel to identify industries that had not participated in campus recruitment, enabling outreach to 300 untapped companies.
Developed power BI interactive reports to track key placement KPIs across 5+ parameters using DAX, including new companies, avg salary trends, offer acceptance rate and placement percentage department wise.
Executed personalized email marketing campaign targeting potential recruiters, resulting in 20 new companies participating in campus placements.
HCL Tech | Software Engineer | Jan 2022 - Nov 2023
Extracted and analyzed datasets having over 1 million record using advanced SQL queries, identifying trends, resolving data discrepancies, and providing insights to business and analytic teams.
Automated daily cloud server health checks with Unix shell scripting, reducing manual efforts by 70%
Led incident management and RCA call, collaborating with cross-functional teams to reduce the incident resolution time by 2 hours through monitoring.
Automated monitoring alerts in splunk using SQL functions, reducing false alarms by 90% and improving issue detection.
Led annual disaster recovery activities, documenting all processes and coordinating with 5+ teams.
Mentored Junior team member on data, log analysis and worked with business teams to improve data integrity.
Wipro Technologies | Resource Manager | Dec 2020 - Dec 2021
Managed project demand fulfillment, placing 95% of bench employees in active projects, reducing idle workforce costs.
Worked with Talent Acquisition team, sourcing and screening 100+ profiles monthly, leading to a 20% faster hiring cycle.
Utilized HR analytic to assess skill gaps, attrition trends, supporting data driven decision making in resource management.
Leveraged HRIS tools and Excel pivot table to prepare KPI based resource utilization reports for business heads, optimized billed count and optimizing project allocation by 10%.
Wipro Technologies | Project Engineer | Jan 2017 - Nov 2020
Handled Major incident resolutions following ITIL framework, coordinating with cross-functional teams to provide timely updates and reduce resolution time by 30%.
Prepared SOP’s for recurring issues, reducing knowledge gaps and deduction in monthly ticket volume by 20%.
Monitored daily data processing for 12+ priority clients ensuring 99% on-time file delivery minimize processing delays.
Let's Connect
Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.