Vishal Kumar

Designed and optimized complex ETL pipelines using native and cloud-based SQL to efficiently process large-scale datasets, ensuring high performance.

Built and deployed high-performance data processing workflows leveraging Python and Apache Spark for advanced analytics.

Managed cloud-based infrastructure on AWS and Azure, including data lake creation, warehouse integration, and robust security configurations.

Designed and implemented dimensional data models (star and snowflake schemas) within Oracle (12c) and Microsoft SQL Server 2019 to support efficient reporting and business intelligence.

Developed and maintained enterprise data warehouses using Oracle (12c) and SQL Server 2019, integrating diverse data sources and optimizing storage, indexing, and retrieval for high performance.

Automated manual data processing tasks using Python, achieving a ~60-hour daily reduction in operational effort and significantly improving efficiency.

Led data modeling and data mapping initiatives from the ground up to support new data flows and system integrations across multiple platforms.

Implemented complex Directed Acyclic Graphs (DAGs) and workflow orchestration using Apache Airflow, alongside enterprise schedulers like UC4 and Control-M.

Established comprehensive data governance frameworks using Informatica IDQ, enforcing data quality and compliance standards across large-scale, complex datasets.

Automated manual processes and recurring user requests using Python, saving approximately 20 weekly hours and 10 daily processing hours.

Developed Python scripts for bulk schema changes and automated deployments to databases, enhancing efficiency and reliability.

Built analytical dashboards using Tableau and Power BI, providing critical insights for material planning, fill rate, inventory, and production.

Led and mentored junior team members, ensuring timely and quality delivery of data solutions.

Designed and implemented dimensional data models (star and snowflake schemas) within Microsoft SQL Server 2019 to support efficient reporting and business intelligence.

Created SQL Loader scripts and External Tables for efficient loading of source files in flat file formats (txt and csv).

Developed optimized Oracle PL/SQL Procedures, Triggers, Packages, and Functions, alongside other database objects, to model and map data.

Performance tuned complex SQL queries and investigated data quality issues to maintain high availability for UAT environments.

Managed task allocation and ensured successful delivery by team members, optimizing workflow efficiency.

Prepared data models and data mapping from scratch for new data flows and system integrations.

Created PL/SQL packages, stored procedures, and functions for extracting, transforming, and loading data from diverse files into the corporate warehouse.

Developed new and enhanced existing BOXI reports on top of the Trade repository for Client reporting, improving data accessibility and insights.

Created UC4/One Automation workflows to schedule new PL/SQL and Unix Jobs, streamlining operational processes.

Prepared Technical Requirement Documents and executed Unit Test Cases post-coding, ensuring solution quality.

Developed PL/SQL and UNIX Shell scripts, performing SQL tuning to enhance application performance.

Automated manual processes and reports using UNIX Shell scripting, saving approximately 40 hours of weekly manual effort.

Administered IBM B2B Sterling, troubleshooting business process failures and maintaining high availability of the ETL tool.

Provided critical support for the SUMMIT Tool, ensuring operational continuity.

Developed PL/SQL Packages and scripts in Oracle to meet specific business requirements.

Prepared Business Requirement Documents and Technical Requirement Documents, ensuring clear project scope and execution.

Developed PL/SQL Programs and performed SQL Tuning to optimize application performance.

Provided extensive bug fixing and UAT support for various modules, including SIT and ORT phases.

Acted as the single point of contact between client and offshore teams while onsite in Sweden, facilitating seamless communication and project delivery.