Balaji Achuthan Rajam

Vulcan Materials Company, one of the largest producers of construction aggregates in North America, operates over 400 facilities across the U.S., Mexico, and the Caribbean, driving large-scale infrastructure and industrial development.

• Designing and implementing Snowflake architecture best practices, including multi-cluster warehouse management, role-based access control, and data sharing capabilities.
• Developing advanced SQL queries, stored procedures, UDFs (user-defined functions), and views in Snowflake to support complex data transformations and business logic execution.
• Writing optimized SQL queries for data extraction, aggregation, and reporting, ensuring performance efficiency across large datasets.
• Designing reusable stored procedures and functions to automate recurring data processes and enforce business rules within the Snowflake environment.
• Utilizing Matillion ETL to orchestrate data pipelines, configure job components, and manage dependencies across diverse data sources and targets.
• Implementing scalable ELT pipelines on Snowflake using Matillion and Python scripts to support batch and near real-time data ingestion.
• Creating and optimizing database objects (schemas, tables, views, materialized views, sequences, stages, file formats) in Snowflake to support enterprise-wide data usage.
• Applying advanced data modeling techniques such as star and snowflake schemas, normalization/denormalization, partitioning strategies, and slowly changing dimensions (SCD) to support robust warehouse design.
• Performing SQL query optimization using clustering keys, pruning, caching, and partitioning strategies to reduce execution time and improve system performance.
• Writing reusable Python scripts for data validation, API integrations, and dynamic parameterization within ETL pipelines.
• Developing and managing CI/CD pipelines using GitHub Actions, Jenkins, or AWS CodeBuild to automate deployment, testing, and release of data workflows.
• Leading the strategic migration of legacy Oracle ODI workloads to Snowflake, leveraging Matillion ETL, Apache Airflow, AWS, GitHub, and Python to architect a scalable, cloud-native data platform.
• Designing and developing modular, reusable workflows to improve performance, reduce operational overhead, and support CI/CD automation using GitHub and AWS CodePipeline.
• Aligning ETL/ELT modernization initiatives with enterprise data strategy to drive faster business insights, strengthen data governance, and enhance long-term cost efficiency.
• Building and optimizing Snowflake data warehouses, implementing performance tuning techniques including clustering keys, result caching, and query optimization.
• Developing advanced SQL-based reporting queries, including CTEs, window functions, and pivot/unpivot transformations, for analytics and dashboard consumption.
• Collaborating with DevOps teams to maintain infrastructure as code (IaC) and ensure secure, scalable cloud deployments.
• Integrating data assets into Power BI dashboards to provide actionable insights and visual analytics for business stakeholders.
• Participating in Agile-based development cycles, including sprint planning, daily standups, and retrospectives to ensure timely delivery of data solutions.
• Conducting unit testing, system integration testing, and performance testing for data pipelines and queries to ensure reliability and scalability.
• Documenting SQL code standards, data pipelines, architecture diagrams, and business logic for effective knowledge sharing and maintainability.
• Coordinating with cross-functional teams including data analysts, business users, and platform engineers to ensure alignment on data architecture and delivery goals.

NOV Inc is a global leader in the Oil & Gas industry, specializing in cutting-edge technology solutions for energy and industrial operations. The scope of this project involves designing scalable enterprise data architectures, integrating cloud-based platforms, and optimizing data-driven decision-making through Snowflake, AWS Redshift, Matillion, and Azure.

• Designed and implemented scalable data warehousing solutions using Snowflake, leveraging advanced SQL features and Snowflake architecture best practices.
• Engineered reusable Snowflake stored procedures and user-defined functions (UDFs) to automate data cleansing, business rule enforcement, and exception handling across pipelines.
• Designed and deployed materialized views, CTEs, and advanced SQL queries to improve analytical query performance and enable faster business reporting.
• Implemented data partitioning, clustering keys, and micro-partitioning strategies in Snowflake to optimize storage usage and query response times.
• Created parameterized SQL scripts to dynamically handle multi-environment deployments and variable-driven transformations within Snowflake.
• Built and maintained hierarchical data models with surrogate keys, slowly changing dimensions (SCD Types 1, 2, and 3), and conformed dimensions for enterprise-wide consistency.
• Authored dynamic SQL-based metadata-driven frameworks for automating table creation, schema evolution, and data lineage tracking.
• Conducted query performance tuning and workload analysis using Snowflake’s Query Profile, caching mechanisms, and cost-optimization techniques.
• Designed and documented logical and physical data models to standardize schema structures and support enterprise analytics initiatives.
• Established SQL coding standards, version-controlled scripts, and peer code reviews to maintain quality, reusability, and governance across teams.
• Delivered ad-hoc SQL solutions for data exploration, anomaly detection, reconciliation, and impact analysis to support business stakeholders.

Genmab Inc is the leader in Life Science product manufacturing in USA. The scope of the project is to develop and manage common data platform tool to promote their product. Health care professional and organization data are mastered and creating golden record using Reltio MDM tool.

• Implemented and maintained Snowflake data warehouse solutions, including schema design, role-based access control, and performance tuning of large-scale SQL queries.
• Developed complex SQL scripts for data transformation, validation, and aggregation across multiple Snowflake environments.
• Integrated Snowflake with AWS services such as S3, Lambda, and Glue for data ingestion and ETL orchestration.
• Created and maintained data models using dimensional and normalized modeling techniques for analytical and operational reporting.
• Supported data pipeline development, migration, and testing in hybrid cloud environments.
• Participated in Agile-based development processes including sprint planning, daily stand-ups, and code reviews.
• Designed and executed data quality and validation checks to ensure data integrity across systems.
• Designed and developed Master Data Management (MDM) processes using Reltio MDM, including configuration of base objects, hierarchies, foreign-key relationships, lookups, and cleanse functions.
• Optimized existing MDM batch groups and landing/staging workflows to improve data quality and system performance.
• Collaborated with cross-functional teams to define data architecture standards, document metadata, and enhance data governance.
• Performed capacity planning and resource optimization for Snowflake workloads to manage cost and performance.

• Led the migration of sales and commercial reporting from legacy systems to Power BI Cloud, enhancing data reliability and report accessibility.
• Designed and deployed interactive dashboards tailored to business units, enabling data-driven decision-making through intuitive visualizations.
• Created complex DAX queries to support advanced business logic and KPI calculations, ensuring accurate and dynamic reporting.
• Implemented row-level security (RLS) to restrict data access based on user roles, ensuring compliance with organizational data governance policies.
• Collaborated with cross-functional teams to gather reporting requirements and translate them into scalable BI solutions.
• Integrated multiple data sources (e.g., Excel, SQL Server, and cloud services) into Power BI, streamlining data consolidation and improving refresh performance.
• Performed data validation and reconciliation to ensure accuracy and consistency between source systems and Power BI reports.

• Executed the end-to-end migration of sales and commercial reports from on-premises systems to the Power BI Cloud environment, improving data accessibility and accuracy.
• Built optimized DAX measures and calculated columns to support dynamic KPIs, time intelligence, and advanced data analysis across business segments.
• Scheduled and managed automatic data refresh cycles and report subscriptions through Power BI Service, ensuring timely data availability for end users.
• Optimized data models and query performance to enhance dashboard responsiveness and reduce report load times.
• Collaborated with business analysts and stakeholders to gather reporting requirements and translate them into scalable and user-friendly BI solutions.
• Conducted knowledge transfer sessions and created documentation to support users in navigating and utilizing the new Power BI reports effectively.

• Managed the end-to-end development of ETL processes using SSIS to support enterprise data integration and migration projects.
• Delivered reporting and dashboard solutions through SSRS, meeting stakeholder and business intelligence requirements.
• Designed and implemented multidimensional and tabular models using SSAS to enhance analytics capabilities across departments.
• Built and optimized complex SQL queries and stored procedures to improve data processing efficiency and performance.
• Developed and maintained conceptual, logical, and physical data models using Erwin Data Modeler to support system design and documentation standards.
• Collaborated with data architects and analysts to translate business requirements into scalable data models and reporting structures.
• Conducted performance tuning of SSIS packages and SQL queries to reduce runtime and improve resource utilization.

• Designed and implemented complex stored procedures to support business logic and optimize data retrieval performance for payroll processing.
• Developed and deployed SSRS reports for operational and management use, ensuring real-time visibility into payroll and employee compensation data.
• Automated payroll calculation processes by integrating SQL-based logic with time-tracking and HR systems, significantly reducing manual intervention and processing time.
• Collaborated with HR and finance stakeholders to gather requirements and translate them into scalable reporting and automation solutions.
• Created data validation routines and exception handling mechanisms within stored procedures to ensure accuracy and compliance in payroll operations.
• Conducted performance tuning of existing queries and procedures to enhance execution speed and reduce system load.
• Developed parameterized SSRS reports for custom payroll summaries, audit trails, and statutory reporting.
• Participated in end-to-end system testing and UAT support to ensure smooth rollout of payroll automation features.
• Maintained detailed documentation of procedures, report specifications, and business logic for audit and support purposes.
• Provided post-deployment support and enhancements based on user feedback and legislative changes.

• Developed and optimized SQL database objects including stored procedures, views, functions, and triggers based on defined business requirements.
• Translated complex business logic into scalable, maintainable database solutions to support application functionality.
• Collaborated with business analysts and stakeholders to understand requirements and converted them into technical specifications for database design.
• Created and maintained data models and entity-relationship diagrams to ensure proper alignment with business workflows.
• Implemented data validation, transformation, and cleansing processes to ensure accuracy and integrity of data across systems.
• Conducted performance tuning of SQL queries and database structures to enhance system responsiveness and reduce load times.

• Developed and implemented .NET application modules based on client-specific business requirements, ensuring scalable and maintainable architecture.
• Designed and optimized SQL Server database objects including tables, views, stored procedures, and functions to support application features.
• Translated complex business logic into efficient technical solutions through collaborative analysis with business analysts and stakeholders.
• Participated in system design sessions and contributed to architectural decisions to align with best practices and project goals.