Visakh Balakrishna Pillai

• Built Python data pipeline to pull third-party SaaS exports (baseline and daily incremental loads) driven by JSON load plan with on-server scheduling and logging.
• Implemented resilient downloads: OAuth 2.0 token persistence and auto-refresh, signed-URL renewal, and retry with exponential back-off, streamed ZIPs to temp files to avoid file locks.
• Bulk loaded to SQL Server and merged via using T-SQL MERGE (upsert) and handled type parsing (normalised ISO timestamps/boolean/ scientific notation), added soft-delete flags, and optional hard-delete on full refreshes.
• Ingested 133k rows in 3.3 seconds using BCP and SQL indexing; added reconciliation checks to validate completeness against source extracts.
• Led demo for stakeholders and analysts, explaining incremental logic, delete semantics, failure handling and recovery steps.

• Automated data extraction, import, export, and BI reporting workflows from Oracle CRM using Python, reducing manual efforts and enhancing data visualization.
• Developed and optimized high-performance SQL procedures, views, indexes, and queries to improve reporting services, data management, and retrieval efficiency.
• Improved code execution by implementing Python multithreading, reducing processing time by 40% and enhancing application performance.
• Secured credentials with advanced encryption mechanisms and optimized Python scripts to improve performance and data integrity.
• Automated and scheduled SQL Server jobs using Task Scheduler and batch scripts for seamless and consistent task execution.
• Automated integration services for Oracle ERP (SaaS) and Oracle Cloud (PaaS) using Python REST and SOAP APIs, enabling seamless connectivity and data exchange.
• Designed RESTful APIs and large-scale data cleansing workflows using web scraping and HTTP requests, impacting over 1 million records.
• Defined data validation requirements and provided technical guidance to business users, ensuring data accuracy, platform integrity, and efficient utilization.

• Managed lifecycle elements of ETL development, from robust testing to final deployment
• Designed and implemented various strategies for Oracle to Azure data migration activities
• Designed and implemented ETL processes using Azure Data Factory, SQL Views, and Stored Procedures, resulting in 50% reduction in processing time
• Developed and maintained data pipelines using Microsoft Azure services resulting in 40% increase in data processing speed
• Demonstrated outstanding technical skills, including comprehensive working knowledge of SSIS, Python, Power BI and Azure Data Factory
• Worked alongside team members and leaders to identify analytical requirements and collect information to meet customer and project demands

PROJECT - Carestack: A leading cloud-based Dental Practice Management Software.

• Managed client calls to gather requirements, maintain project scope, and meet deadlines, ensuring successful project delivery.
• Developed C# automation tools to transform and validate data formats (Binary, JSON, XML, CSV) into business SQL database schema.
• Proposed and implemented JavaScript solutions to extract hidden documents from URLs, completing critical client tasks.
• Introduced and integrated Bulk Copy Program Utility (BCP) method, increasing data transfer speed for migrations by over 80%.
• Trained and mentored junior team members in Agile development for optimal progress.
• Designed and developed ETL solutions using Microsoft SSIS and reporting services using SSRS based on client specifications.
• Rewrote SQL queries, optimized performance, and improved SSIS task execution and data migration productivity by 60%.
• Extracted and transformed multi-source data into unified databases using SSIS, while monitoring integration and replication performance.
• Designed SQL tables, complex stored procedures, indexes, triggers, and functions using T-SQL.
• Developed Python tools for web scraping, reducing database and Excel data cleansing time from 10 to 4 working days.
• Reverse-engineered client legacy systems to create Business Requirements Documents (BRD) for solution development.

PROJECT - Proact: An interoperable platform for Chronic Disease Management (Obstructive Sleep Apnea) was developed in partnership with Proact Health Solutions.

• Developed and integrated API functionality on web applications, enabling end-users to add signatures using Signature-Pad devices.
• Delivered C#.NET application features aligned with product roadmap.
• Utilized Azure for IIS Web Deploy and configuration management.
• Conducted load tests on over 2 million records, enhancing web application performance by 60%.
• Used MS SQL Profiler to trace and debug SQL queries requiring performance tuning.
• Fixed bugs, troubleshot code issues, and documented tasks.