Kishore Raghavendran Shanmugam

• Developed and optimized ETL workflows using Alteryx to extract, transform, and load data from CSV files and SQL databases, deploying it into both local storage and Google Big Query for scalable analytics.
• Built and automated data pipelines to process, clean, and transform large datasets, improving data quality and reducing manual efforts.
• Designed and developed interactive dashboards in Qlik Sense to visualize Ford indirect purchasing data, integrating multiple data sources for real-time reporting and decision-making.
• Implemented Python-based backend solutions to extract data from the ARIBA Sync API, applying dynamic retrieval logic via Postman calls and storing processed data in Google Cloud Platform (GCP) buckets.
• Optimized SQL queries, data models, and API request handling to improve performance, reduce processing time, and ensure efficient data retrieval across multiple platforms.
• Collaborated with cross-functional teams and business stakeholders to understand data requirements, troubleshoot issues, and enhance
• Implemented Tekton pipelines to automate data transmission from APIs to Google Cloud Platform (GCP), ensuring efficient, reliable, and scalable data integration. data accessibility for analytics and reporting.

AXON (Metadata Management & Data Governance) OpenText Content Server (Enterprise Content Management) Google Cloud Platform (BigQuery & Infrastructure Management)

• Managed metadata repositories, ensuring data assets were well-documented, structured, and metadata remained up-to-date for improved data discoverability.
• Established and maintained data quality monitoring frameworks, tracking key data quality metrics and collaborating with data owners to resolve inconsistencies.
• Served as a Data Steward for Loblaw business units, ensuring data accuracy, consistency, and compliance with enterprise data governance policies.
• Performed system updates and security patches for Citrix Workspace environments, ensuring optimal performance, stability, and security compliance.
• Developed and maintained OpenText environments, ensuring seamless enterprise content management across business units.
• Automated testing and monitoring by creating and maintaining test scripts in Postman, enabling efficient regression testing and real-time API performance tracking.
• Engineered and optimized ETL workflows in Google BigQuery, extracting, transforming, and loading large datasets while ensuring high data integrity and performance.
• Designed and deployed cloud infrastructure on GCP, including virtual machines, Kubernetes clusters, and networking components, optimizing for security, scalability, and availability.
• Developed Python-based API integrations to ensure seamless data transmission between APIs and databases, proactively identifying and resolving anomalies.

Project: Shipments on CITI Logistics Data Processing

• Utilized TSQL expertise to manipulate and query data, facilitating data analysis and modeling tasks.
• Employed data preparation techniques to clean, transform, and structure raw data into a format suitable for visualization, ensuring data accuracy and consistency using TIBCO SPOTFIRE.
• Executed data strategies and developed physical data models, optimizing data architecture for performance and scalability.
• Raw data's will be collected and ensured and aligned as Part Cost Excellence Gen-2 using advanced excel Proficient in both relational and PostgreSQL data stores, with expertise in Dimensional Modelling (Star and Snowflake schemas), ETL design, and performance tuning to cleanse the raw data
• After the raw data has been cleansed with ETL transmissions Designed and developed interactive dashboards and reports using Power BI to convey complex data in a visually compelling and understandable manner
• Implemented agile methodology, to identify the individual task difficulties in order to consume less time. On the other-hand used water fall methodology for certain IHS materials to determine the final outcome of the product.