Lavanya Kotian

Aspiring Data Analyst

Mangalore, Karnataka 3+ yrs exp 87 · Excellent

About

Aspiring Data Analyst with 3.6 years of experience in operations and process coordination at Capgemini. Skilled in SQL, PostgreSQL, Power BI, Python, and Microsoft Excel, with hands-on experience developing interactive dashboards, analyzing business data, and generating actionable business insights through real-world projects. Strong analytical, problem-solving, and reporting skills with a passion for data visualization and business intelligence.

Skills & Expertise (30)

SQL Intermediate

7.4/10

3.6

Years Exp

Python Intermediate

7.2/10

3.6

Years Exp

Data Analysis Intermediate

7.0/10

3.6

Years Exp

Power BI Intermediate

7.0/10

3.6

Years Exp

Data Visualization Intermediate

6.8/10

3.6

Years Exp

Data Cleaning Intermediate

6.5/10

3.6

Years Exp

Git Intermediate

6.0/10

3.6

Years Exp

Jupyter Notebook Matplotlib NumPy Pandas ETL Basics KPI Reporting Business Metrics Dashboard Development Postgresql Oracle Database RDBMS Microsoft Office Suite Power Query VS Code GitHub DAX Data Validation Charts Conditional Formatting XLOOKUP VLOOKUP Pivot Tables Microsoft Excel

Work Experience

Software Associate

Capgemini India Pvt. Ltd.

Dec 2022 - Present

Coordinated end-to-end onboarding by tracking employee records, asset requests, and issue resolution across cross-functional teams. Monitored onboarding progress, SLA compliance, and operational metrics using Excel reports and internal dashboards. Investigated and resolved onboarding issues, including profile mismatches, inactive accounts, manager assignment errors, and credential delays. Maintained operational trackers, ensuring data accuracy and timely reporting to support business operations. Collaborated with HR, IT, and Asset Management teams to improve onboarding efficiency and streamline operational processes.