SQL DBA with 4.5 years of experience specializing in data management, database administration, and analytics. Skilled in SQL Server, Azure Data Factory, Power BI, and Azure Databricks for building efficient data solutions. Experienced in designing, tuning, and maintaining databases to ensure high availability and performance. Proficient in developing ETL workflows and automation processes for seamless data integration. Strong in creating interactive dashboards and reports that support data-driven decision-making. Hands-on expertise in monitoring, troubleshooting, and optimizing database environments. A results-oriented professional with strong analytical and problem-solving skills. Focused on delivering reliable, scalable solutions aligned with business needs.
Valet Living, a US-based waste management company, required seamless integration between Salesforce and Oracle Financial Applications (OFA) to process community and vendor invoices. The project involved extracting invoice and customer data
Roles and Responsibilities
Designed and optimized stored procedures, functions, and triggers for financial data processing. Built scalable ETL workflows using Azure Data Factory and Databricks to automate invoice data integration.
Technologies: SQL Server, PL/SQL, Power BI, Azure Data Factory, Databricks, PostgreSQL
Industry: Financial
SG Event Driven Integration
November-2020 to February-2022
Description
It required a robust SQL/PLSQL solution for revenue, compliance, and contract management. The system processed millions of transactions for invoices, claims, rebates, and chargebacks from wholesalers, manufacturers, and pharmacies. The solution ensured smooth data migration, reporting, and analytics for compliance and revenue insights.
Roles and Responsibilities
Developed complex PL/SQL procedures, triggers, and packages for business logic automation. Optimized long-running SQL queries, reducing execution time by 70%.
Description: With 4.5 years in IT, you've excelled in SQL Server by creating essential database objects, managed data flow and automation with Azure Data Factory, transformed data into insights using Power BI, and leveraged Azure Databricks for big data processing. Your expertise lies in data engineering, analytics, and business intelligence solutions.