Database Analyst Data Visualization

AKANSHA SAWARKAR

PERSONAL DETAILS

Email id: ****************@*****.***, Ph no: 721-***-****

LinkedIn: linkedin.com/in/akansha-s-53721721b

SUMMARY

As a dedicated and a versatile Database analyst, I bring proficiency in data visualization and expertise in SQL, PL/SQL, Python and consistently deliver high-quality solutions tailored to meet project requirements. Staying up- to-date with emerging technologies and best practices. Ensuring efficient and effective problem-solving in diverse environments. I thrive in collaborative settings, leveraging my communication skills to foster productive teamwork and achieve project objectives. With a commitment to continuous learning and growth. I am poised to contribute positively to dynamic database teams EDUCATION

MCA (Masters of Computer Application) Jul 2021 - Dec 2024 Indira Gandhi Open University

BCA (Bachelors of Computer Application) Jun 2017 - Jun 2020 SPPU University

EMPLOYMENT

DATABASE ANALYST - I Jun 2024 - Present

BAJAJ FINSERV DIRECT LIMITED, Pune

Developed and maintained dashboards and reports using Tableau and excel. Working in different database technologies like DB2, MySQL as supporting multiple applications that has different database.

Built databases and table structures for web applications. Using advanced Excel functions (VLookUp, Pivot tables) for data analysis and creating reports. Implemented ETL process in Alteryx to extract data from multiples sources (SQL server, XML) Managed end to end complex data migration, conversion and data modeling (using Alteryx, SQL) and create visualization using tableau to develop high quality dashboard. Worked on JSM tool and Employee portal (CRM application) to resolve user query which is related to data issues, business logic related issue.

Maintained daily uptime KPI report to check and evaluate the project performance against expected results and how effectively an organization is achieving its strategic and operational goods. Monitoring the production environment services on new relic. We monitor the business service spike with help of this.

We collect data from our service and send it to platform for analyzing and finding issues when something unusual happens in an application and code.

Having a good knowledge of Kibana (ELK elastic search) creating dashboard for tracking logs and event data and analyzed and visualize potential security breaches and set up security control. Having good experience in handling SQL commands (DML and DDL). Database Analyst Nov 2021 - Nov 2022

KPMG (Assurance and consulting Services LLP), Pune Conduct Verification of Stated credentials given by clients for their Candidates and Vendor. Maintain trackers and master logs on real time basis.

Analyze data with the ability to identify all data discrepancies with the authority to make the necessary changes.

Successful completion of client engagement deliverables in line with appropriate timelines and adhering to pre-defined methodologies ensuring high quality work delivery. Demonstrate ability to assimilate new knowledge with respect to process changes Monitor progress and ensure that supervisors are kept informed about progress and expected outcomes. Verify Candidates documents given by clients and Vendors (Employment, Education, Address, Criminal Records) Least Supervision and with Good Quality Managing Clients Critical Reports and delivered as per clients expectation.

Managing, collecting and analyzing large datasets. Maintaining and coordinating reporting process. Create multiple operational reporting tools such as PL/SQL query statements to extract data to create an excel spreadsheet.

SKILLS

Microsoft Power BI

Advanced excel and Tableau

ETL Development

Visual basics and .Net

Python

Pandas

PROJECTS

Tours and travel management system

Database Management/ RDBMS

C and C++

HTML, CSS and PHP

SQL

R programming

Oracle database (PL/SQL)

TECHNOLOGIES: HTML, CSS, JavaScript, PHP, MySQL- Developed a responsive, user-friendly Tours and Travels website designed to facilitate trip planning and booking. Key features included user registration and login, dynamic tour listings, search and filter functionality, online booking system, etc ONLINE SHOPPING WEBSITE

Developed a responsive e-commerce website enabling users to browse products, manage shopping carts, and securely complete purchases. Implemented features such as user authentication, product search and filtering, order management, and payment gateway integration. CERTIFICATES

Certification in SQL and Data analytics Apr 2025

Web designing and web development Nov 2019

Contact this candidate