Vijay Kumar S. Email & Phone Number

Michigan, United States

Data Engineer with hands on experience in developing and executing projects on Cloud Platforms. Proficient in SQL and Python, with experience in building robust data pipelines, implementing machine learning applications, and designing user-friendly web interfaces. Led the design and implementation of complex cloud solutions on Microsoft Azure, emphasizing.

California, United States

• Collaborated with business analysts, data architects, and stakeholders to gather and analyze data requirements, ensuring clear documentation and alignment.
• Designed and developed conceptual, logical, and physical data models using Erwin Data Modeler to represent business requirements accurately.
• Optimized database schemas for performance, scalability, and maintainability, applying normalization and denormalization techniques.
• Managed and maintained metadata, documenting data definitions, relationships, and business rules in Erwin Data Modeler.
• Implemented data quality checks and validations to ensure the accuracy and consistency of data models.
• Designed data models to facilitate the integration of data from various sources into a unified data warehouse.

California, United States

• Designed and managed Logstash pipelines in the ELK stack for efficient data ingestion, transformation, and enrichment.
• Created and maintained detailed Kibana dashboards and visualizations within the ELK stack to support business intelligence and operational insights.
• Monitored and managed the health and performance of Elasticsearch clusters within the ELK stack, ensuring optimal operation.
• Conducted performance tuning and optimization for Elasticsearch queries, indices, and overall ELK stack configuration.
• Maintained detailed documentation of configurations, processes, and best practices for managing the ELK stack.
• Led projects involving the deployment and optimization of the ELK stack, ensuring alignment with business requirements and objectives.

Florida, United States

• Develop New Spark SQL ETL logics in Big Data for the migration and availability of the Facts and Dimensions used for the Analytics.
• Develop of Spark SQL application, Big Data Migration from Teradata to Hadoop and reduce Memory utilization in Teradata analytics.
• Develop the Spark SQL logics, which mimics the Teradata ETL logics, and point the output Delta back to Newly Created
• Hive Tables and as well the existing Teradata Dimensions, Facts, and Aggregated Tables.
• Involved in creating views on top of HIVE tables for analytics, and actively participated in upgrading Tableau platforms in a clustered environment, including performing content upgrades.
• Created, modified and executed DDL in table AWS Redshift and snowflake tables to load data.

India

In the project, I developed PL/SQL packages, procedures, triggers, and functions using SQL Navigator. Created reports with Parallel Queries and Java Stored Procedures. Participated in change reviews, troubleshooting, and table optimizations for better performance.Utilized Informatica Power Center Designer for ETL tasks, creating mappings with various.