Bharatkumar Salian
Edison,NJ
Summary
Over 20 years of expertise ihands-on Data Engineering Leader with 20+ years of experience in Data Warehousing, ETL Architecture, and Product Development, GenAI
Proven track record on Snowflake Data Warehouse design , Transformation and AWS integration.Proven ability in spearheading advanced analytics projects, including the implementation of AWS QuickSight for real-time data analysis.Led the revolutionized migration of legacy Oracle systems to AWS Aurora using GenAI &Langchain, greatly reducing timelines.Proficient in designing high-speed search modules using AWS OpenSearch, Ensuring real-time syncingPerformance and optimiantion
Overview
16
16
years of professional experience
Work History
Associate Director
Vitech Systems Group
07.2012 - Current
- Data Warehouse & ETL Architecture: Designed and implemented a high-performance Snowflake Data Warehouse, establishing robust ETL pipelines from core PostgreSQL systems using AWS DMS and S3. Developed a custom Python-based ETL engine driven by a metadata store to automate complex transformation logic.
- Enterprise Data Analysis & Insights: Spearheaded a new line of analytical products (Insight Now), leveraging Snowflake and AWS QuickSight to provide clients with valuable data analysis for strategic decision-making.
- GenAI-Powered Modernization: Led the migration of legacy code from Oracle to AWS Aurora (PostgreSQL). Utilized GenAI and APIs to automate the conversion of complex PL/SQL to PostgreSQL, drastically reducing migration timelines.
- Data Lakehouse Implementation: Architected a scalable Data Lake using AWS S3 and Athena, enabling cost-effective, serverless analysis of massive unstructured datasets.
- Advanced AI Search Innovation: Engineered a Natural Language to SQL (NL2SQL) interface using AWS Bedrock and implemented Semantic Search via pgvector, bridging the gap between raw data and user intent.
- High-Speed Search Modules: Designed the architecture for "lightning-fast" search functionality using AWS OpenSearch and Solr, ensuring real-time data sync via Python-based microservices.
- Performance Engineering: Provided expert-level SQL, PL/SQL, and pg/SQL tuning for production environments, resolving critical bugs and optimizing database performance for high-traffic V3 applications.
- Led teams of up to 10 personnel, supervising daily performance as well as training and improvement plans.
Sr Oracle Developer (PL/SQL)
Ait Global
12.2009 - 06.2012
- As a Senior Oracle Consultant at AIT Global Inc., I spent nearly three years delivering high-impact database solutions for premier financial institutions, including Barclays Capital and Merrill Lynch. My expertise focused on building and optimizing large-scale systems for fixed-income settlements and document management. I specialized in PL/SQL development.
- Pro-C batch processing, and performance tuning within Oracle 9i/10g/11g environments, consistently improving system efficiency and data accuracy for front-office operations.
- Developed Oracle complex API and SQL to meet functional business requirements.
Education
Bachelor of Science -
University of Mumbai
India07.2000
Skills
Data Warehousing & ETL, Snowflake Metadata-driven ETL FrameworksPythonAWS DMS (CDC)Data Analysis & BIAWS QuickSight (Embedded)Data VisualizationInsight-driven Product DesignCloud & Data LakeAWS (S3, Athena, EC2, RDS, Aurora)Serverless ArchitecturesGenAI & AIAWS Bedrock & Langchain (NL2SQL)LLM-based Code ConversionVector DB (pgvector)Legacy Modernization
Websites
Core Technical Competencies
Snowflake, Metadata-driven ETL Frameworks, Python, AWS DMS (CDC), AWS QuickSight (Embedded), Data Visualization, Insight-driven Product Design, AWS (S3, Athena, EC2, RDS, Aurora), Serverless Architectures, AWS Bedrock & Langchain (NL2SQL), LLM-based Code Conversion, Vector DB (pgvector), Oracle to PostgreSQL Migrations, Expert SQL/PL-SQL Development and Performance tuning, SQL Server, AWS OpenSearch, Apache Solr
Timeline
Associate Director
Vitech Systems Group
07.2012 - Current
Sr Oracle Developer (PL/SQL)
Ait Global
12.2009 - 06.2012
Bachelor of Science -
University of Mumbai