Kavya P

Data Scientist

Bengaluru, Karnataka, India10 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in SQL and Business Intelligence reporting.
Proven track record in performance tuning and troubleshooting.
Strong ability to translate data into actionable insights.

Stackforce AI infers this person is a Data Analyst with a focus on Business Intelligence in the Healthcare and E-commerce sectors.

Contact

Skills

Core Skills

Data AnalyticsSqlBusiness Intelligence (bi)

Other Skills

TroubleshootingPerformance TuningMicrosoft ExcelHTMLMySQLSAP BICustomer ServiceRequirements AnalysisOracleCC++JavaJavaScriptPython (Programming Language)

About

With a solid foundation in data analytics and a specialty in SQL and SAP BI, my role at Intel Corporation involves transforming complex datasets into actionable insights. My expertise lies in designing and managing business intelligence reports and dashboards, ensuring data accuracy and effectiveness for strategic decision-making. At Cerner Corporation, I honed my abilities in software engineering, where I developed a keen eye for performance tuning and troubleshooting complex SQL code. This experience has been instrumental in my current position, where I facilitate the intersection of IT capabilities and business objectives, driving improvements in data conversion processes and reporting efficiency.

Experience

10 yrs 8 mos

Total Experience

2 yrs 4 mos

Average Tenure

4 yrs 1 mo

Current Experience

Intel corporation

Data Analyst

Mar 2022 – Present · 4 yrs 1 mo

Data Analytics

Cerner corporation

Software Engineer II

Jan 2021 – Mar 2022 · 1 yr 2 mos · Bengaluru, Karnataka, India

Data Analytics

Cerner healthcare solutions private limited

Software Engineer

Oct 2016 – Mar 2022 · 5 yrs 5 mos · Bengaluru Area, India

Design, develop, test, and manage business intelligence SQL code, views, reports, dashboards and data quality processes.Interface with business and IT contacts to elicit, analyze, and document business requirements for business intelligence reports and dashboards.Good knowledge of BI reporting and SQL concepts, methodologies, and techniques.Worked on performance tuning of the SQL queries to improve data conversion process.Strong troubleshooting and performance tuning skills - should be able to identify and resolve performance issues involving complex SQL code.

Data AnalyticsSQLBusiness Intelligence (BI)TroubleshootingPerformance Tuning

Flipkart

Analyst

Oct 2015 – Jul 2016 · 9 mos · Bengaluru Area, India

Managed performance and tuning of SQL queries
Load the data from MS Excel to database.
Loaded the data using the SQL loader, Imports based on file formats.
Increased productivity through
o Built a web portal for Business intelligence which provides data at one place & restricts the use of email & also avoids dependency of email.
o Built a web portal for agent performance - a tool which allows the agent to look at their performance on regular updates & restricting the email attachments sent.
o Automated repeat callers list from real time dumps
Created databases
o To improve the access of data.
o To have history of data stored in system through MYSQL.
Automated various reports to reduce the manual power & error.
Created forms for client teams to easy load of data to database & easy preparation of reports from database using query & Html.
Have also worked using bootstrap in web portal.
Worked in many batch files to automate process & schedule it.
Worked on macros in Ms Excel to reduce the calculation manually.
Extraction of data from Database on demand using SQL queries.