Skills

Achievements

  • Optimized Data Pipelines: Redesigned ETL workflows to improve maintainability, reduce architectural complexity, and accelerate data ingestion and processing.

  • Cloud Migration Expertise: Led the migration of legacy on-premise SQL Server and Oracle systems, including ETL workflows built in PowerCenter and SSIS, to modern cloud platforms such as Azure Data Factory, Databricks, and Snowflake.

  • Azure Platform Integration: Designed and implemented end-to-end data solutions on the Azure Data Platform, including Data Factory, Databricks, and Data Lake.

  • Cross-System Integration: Integrated enterprise systems such as SAP, Salesforce, and custom applications with OLTP databases (Oracle, SQL Server), enabling unified analytics and reporting.

  • Performance & Cost Optimization: Implemented scalable architectures and optimized ETL and storage processes to improve system performance while reducing cloud costs.

  • ETL & BI Excellence: Delivered high-quality ETL, data modeling, and BI solutions for clients across insurance, banking, healthcare, e-commerce, tech startups, retail, and manufacturing.

  • BI Modernization: Successfully migrated complex reports and dashboards from Microsoft Excel to Power BI, improving data accessibility, visualization quality, and decision-making efficiency.

  • Leadership & Mentoring: Guided junior engineers and cross-functional teams on best practices in data engineering, cloud architecture, and pipeline design, improving team efficiency and onboarding.

  • Rapid Adaptation & Learning: Quickly self-trained on new tools and technologies to meet client-specific project requirements, enabling immediate contribution post-onboarding.

  • Complex Problem Solving: Resolved challenging technical and architectural issues in data engineering projects, finding practical solutions for any data engineering requirement.

Data Engineering & Architecture

  • Extensive experience with Data Warehouse, Data Mart, Data Lake, Lakehouse, Data Mesh, and Medallion Architecture.

  • Skilled in Data Analytics, Data Governance, and Data Quality initiatives.

  • Proficient in Master Data Management (MDM) and Data Catalogs.

  • Strong knowledge of Data Security, including masking, regulatory compliance, access management, and auditing.

  • Hands-on expertise in ETL/ELT processes: extraction, staging, transformation, and loading across multiple source and target systems with diverse technologies.

  • Deep understanding of data modeling: dimensions, fact tables, OLAP cubes, aggregate tables, and database optimization for storage and query performance.

  • Familiar with leading methodologies: Top-down, Bottom-up, Inmon, Kimball, On-premise, Cloud, and Big Data approaches.

  • Full lifecycle experience: analysis, design, implementation, maintenance, administration, optimization, testing, and quality assurance with a focus on best practices.

ETL/ELT & Data Integration

  • Proficient with ETL tools including Azure Data Factory, Databricks, Informatica PowerCenter, Informatica Cloud, SSIS, and Pentaho Kettle.

  • Skilled in building ETL pipelines using PL/SQL, T-SQL, shell scripts, C++, Java, and Python.

  • Expertise in data extraction, transformation, and loading across multiple platforms and technologies.

Databases

  • Extensive experience with Oracle, Microsoft SQL Server, Snowflake, Redshift, MySQL, PostgreSQL, Teradata, DB2, and InterSystems Caché.

  • Data modeling and architecture, including physical and logical database design and administration.

  • Proficient in SQL programming, query optimization, indexes, partitioning, and performance tuning.

  • Management of grants, roles, and permissions to ensure security and compliance.

  • Experience with backup and recovery strategies, replication, and high availability solutions.

  • Familiar with database monitoring tools, automation scripts, and best practices for reliability and scalability.

Cloud & Big Data

  • Azure, Databricks, AWS, Spark, Redshift, Snowflake, Data Factory.

Microsoft Azure

  • Azure SQL Database, Azure Data Factory, Azure Databricks, Azure Blob Storage, Azure DevOps, RBAC, Power BI.

Snowflake

  • SQL, warehouses, roles and grants, time travel, stored procedures, tasks, temporary and transient tables, external tables and semi-structured data formats, cost management, integration with Data Factory, integration with cloud storage, integration with BI and analytics tools.

Reporting & Visualization Tools

  • Power BI, QlikView, Tableau, Looker, Birst, SAP BO, MicroStrategy, Cognos.

System & Infrastructure Architecture

  • Cloud, On-Premise, and Distributed Systems, including Virtual Servers and Containerized Environments.

  • Design and management of high availability architectures, load balancing, failover strategies, and backup solutions.

  • Implementation of real-time, on-demand, and scheduled processing solutions.

  • Sizing, scaling, benchmarking, and procurement of infrastructure to meet performance and capacity requirements.

  • Migration of existing solutions to modern technologies and infrastructures, including cloud adoption and hybrid deployments.

  • Monitoring, optimization, and performance tuning of infrastructure to ensure reliability, efficiency, and cost-effectiveness.

Programming Languages

  • C/C++, Java, JavaScript, Visual Basic, PHP, Perl, Python, AWK, Bash, PowerShell, SQL programming.

  • Experienced in object-oriented programming (OOP), compiled and interpreted languages, and modular coding practices.

  • Skilled in API development, scripting for automation, and building custom ETL solutions using code.

  • Code review and release management.

  • Capable of writing efficient, maintainable, and scalable code.

Unix & Linux Systems

  • Experienced with macOS, RedHat, Oracle Linux, Fedora, CentOS, SUSE, Debian, Ubuntu, Solaris, and IBM AIX.

  • Skilled in managing packages, dependencies, users, permissions, and networking.

  • Proficient in Bash and shell scripting for automation, system administration, and process optimization.

  • Knowledgeable in system configuration, monitoring, and troubleshooting.

Project & People Management

  • Marketing & Sales, Business Development, Account Management, RFI/RFP, Proofs of Concept.

  • Bridging technical, functional, and business areas by analyzing and translating user and business requirements.

  • Estimation and planning for short, medium, and long-term initiatives.

  • Stakeholder, Budget, Resource, Risk, and Change Management, tracking deliverables, scope, and timelines.

  • Experience leading local, remote, and hybrid teams, including internal staff, external vendors, and freelance contractors.

  • Provider selection, collaborator interviews, and talent recruitment.

  • Mentoring or guiding engineering teams, sharing knowledge, establishing standards, improving team efficiency, and enabling high-quality delivery.

  • Managing both new developments and legacy systems at varying service levels, with expertise in ITSM and SDLC.

  • Proficient in Agile and Waterfall methodologies (Scrum, Kanban, DevOps).

  • Full documentation across all project phases.

  • Tools: Jira, Confluence, Azure DevOps, ServiceNow, CyberArk, Control-M, Git, CI/CD pipelines, and more.

  • Industry experience across Insurance, Banking, Healthcare, Telecommunications, E-commerce, Tech Startups, Retail, Manufacturing, Education, Government Administration, Sports, Logistics, and Print Media.

Soft Skills

  • I apply critical and analytical thinking, solve problems creatively and strategically, stay resourceful and resilient, reliable and professional, remain self-disciplined and conscientious, manage my time excellently, make sound decisions, adapt easily, stay open-minded and self-motivated, take accountability and ownership, uphold a strong work ethic, act with integrity, and deliver efficiently and effectively.