Looking for a job

Pallavi Acharya

@pallaviacharya

Message

Database Developer at Excelra, standardizing drug discovery data and automating client deliveries with Python scripts.

India

Message

What I'm looking for

I’m seeking a challenging DB Developer position where I can use my skills in SQL Server, SSIS, PostgreSQL, Python, and Oracle to contribute to an organization’s growth.

At Excelra, I standardize weekly data in Oracle databases, combine monthly data into schemas, and prepare client delivery files and documentation for drug discovery data.

I also prepare Python scripts using PySpark, pandas, and database libraries to streamline client deliveries.

At Avya Inventrax Pvt. Ltd., I developed database components for SKUBIQ, FALCON WMS, and MERLIN WMS. My work included migrating SQL Server databases to PostgreSQL, developing stored procedures and views, and supporting warehouse application modules.

At Scalable Systems Pvt Ltd, I developed SSIS packages for the MEDITECH EDW and DATAMART project, loading dimension and fact tables from operational and other source data. I also created database objects using T-SQL.

Experience

Work history, roles, and key accomplishments

Current

Senior Software Specialist

Current

Excelra Pvt. Ltd.

Jul 2023 - Present (3 years 2 months)

Standardized weekly data in Oracle DB, merged monthly data into one schema, and prepared delivery files and documents for client deliveries. Developed Python scripts for automation of client deliveries.

Oracle PostgreSQL MySQL Python PySpark Pandas Data Validation DML ETL

Database Developer

Avya Inventrax Pvt. Ltd.

Nov 2019 - Jul 2023 (3 years 8 months)

Migrated SQL Server to PostgreSQL, created stored procedures, functions, views, and handled inbound/outbound orders and billing reports. Trained and managed database team for migration.

SQL Server PostgreSQL T SQL Stored Procedures Views Functions TFS Visual Studio pgAdmin4 SSMS (Microsoft SQL Server Management Studio)Postman Performance Optimization Backup and Restore

Database Developer/System Analyst

Scalable Systems Pvt. Ltd.

Jul 2017 - Sep 2019 (2 years 2 months)

Developed SSIS packages for ETL from OLTP to data warehouse, loaded dimension and fact tables, and created database objects like tables, stored procedures, triggers, and CTE functions using T-SQL.

SSIS T SQL SQL Server ETL Data Warehouse SSMS (Microsoft SQL Server Management Studio)Visual Studio Asana