logo

Powered by
Codebasics DA Bootcamp

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.

Awards & Certificate

Project Challenge

Project Challenge

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.