Chetan Ramaswamy

As a senior datawarehouse lead my roles and responsibilities typically encompassed a wide range of tasks related to designing, implementing and optimizing datawarehouse solutions on Azure platform.

Key responsibilities include

• Designing scalable and efficient data warehouse architectures on Azure synapse considering factors such as volume, velocity, variety, and latency requirements.
• Facilitating data migration activities from multiple different sources such as Oracle HCM, SQL Server, MySQL, Sharepoint etc to Azure Synapse using data factory and SSIS technologies.
• Defining data ingestion strategies, data storage formats, data partitioning schemes, and data lifecycle management policies to optimize performance and cost-effectiveness.
• Defining project milestones, tasks, and deliverables, and ensuring adherence to project management best practices and methodologies.
• Developing and implementing data models, including conceptual, logical, and physical models, to support analytical reporting, ad-hoc querying, and data visualization requirements.
• Implementing data security measures and access controls to protect sensitive information stored in Azure data warehouses, adhering to industry standards by using dynamic data masking technologies and apply row level security using security predicates and policies.

As a Data Migration Consultant, I was tasked to ensure the smooth and efficient transfer of data from legacy systems to SQL server 2018 environments while minimizing disruption to business operations. Key responsibilities includes

• Conducting a thorough assessment of existing data sources, systems, and processes to understand data structures, dependencies, and quality issues.
• Collaborating with stakeholders to define migration objectives, scope, and success criteria.
• Developing a comprehensive migration strategy, including data mapping, transformation requirements, validation procedures, and contingency plans.
• Mapping source data fields to target data structures, ensuring alignment with business requirements and data modeling standards.
• Designing and implementing data transformation logic to convert data formats, standardize values, and reconcile discrepancies between source and target systems.
• Loading data into the target environment using batch processing, real-time replication, or other data loading techniques.
• Monitoring data migration jobs for errors, failures, and performance issues, and implementing corrective actions as needed to ensure data completeness and accuracy.

LBM Fleet Solutions provide advanced GPS tracking and fleet management software to monitor the location, status, and performance of vehicles in real-time. They also provide vehicle maintenance, telemetric solutions through their products.

As a senior datawarehouse lead,

• Led the design and development of a new data warehouse system for LBM Fleet Solutions, utilizing OLTP system data to centralize and optimize data storage and retrieval processes.
• Collaborated closely with stakeholders to gather requirements and define data warehouse architecture that aligned with business objectives and data governance standards.
• Implemented best practices for data modeling, ETL processes, and data quality assurance to ensure accuracy, consistency, and reliability of the data warehouse.
• Implemented monitoring and alerting mechanisms to proactively identify and address issues, ensuring high availability and uptime of the data warehouse environment.
• Worked closely with business users to understand reporting and analytics requirements, and developed tailored solutions to meet their needs.

• Skilled at working independently and collaboratively in a team environment.
• Delivered services to customer locations within specific timeframes.
• Used critical thinking to break down problems, evaluate solutions and make decisions.
• Gained extensive knowledge in data entry, analysis and reporting.