Megarubanathan Ravichandran Email & Phone Number

London, England, Gb

London Area, United Kingdom

Hyderabad, Telangana, India

- Created/modified SSIS packages, showcasing expertise in orchestrating seamless data flow within complex ETL processes.- Authored over 40 SQL scripts, demonstrating a deep understanding of database, data modelling and employing best practices to enhance query performance.- Responsively addressed and fulfilled ad-hoc requests from report users. by promptly writing SQL.- Showcased advanced T-SQL skills by developing and fine-tuned stored procedures, playing a pivotal role in improving data processing efficiency while maintaining data integrity.- Hands-on involvement in testing SQL queries and reports in Cognos/SSRS, ensuring precision and reliability before each deployment, contributing to a robust and error-free data environment.- Implemented performance tuning techniques, optimizing SQL queries to improve response times and overall system efficiency, with a focus on delivering high-performance data solutions.- Maintained detailed documentation for SSIS packages, SQL Queries, ensuring transparency and facilitating knowledge sharing for seamless future maintenance and updates.- Implemented rigorous quality assurance measures for SSIS packages and SQL scripts within Data Factory, ensuring data accuracy and reliability in a cloud environment.- Skillfully utilized IBM DataStage as the ETL tool to manage daily data feeds received through FTP, showcasing expertise in seamless integration of data from external sources to populate raw tables within the organization's data.

Bengaluru, Karnataka, India

In response to recent business transformations, I actively engaged in adapting the data model to align with evolving requirements. This involved meticulous adjustments to existing structures and the creation of new elements. Employing agile methodologies, I collaborated with offshore teams, ensuring swift and effective solutions to meet dynamic business demands.- Successfully adapted the existing data models to accommodate recent business changes, demonstrating flexibility and agility.-Developed new queries, procedures, functions, and triggers to align the data model with the updated business needs, showcasing advanced SQL and T-SQL proficiency.- Collaborated efficiently with internal and external stakeholders, adopting an agile methodology to provide timely and effective solutions.- Created over 40 complex reports in IBM Cognos 11, showcasing a high level of expertise in leveraging the platform for comprehensive and insightful data reporting.- Developed robust ETL pipelines using SSIS and IBM DataStage, ensuring the seamless extraction, transformation, and loading of data to meet the organization's evolving requirements.- Managed the end-to-end process of creating and scheduling jobs for loading raw tables from daily data feeds.- Implemented automated job processes to load data marts from raw tables on a daily basis, ensuring the availability of up-to-date information for analytical purposes, and leveraging SSIS for streamlined ETL.- Leveraged Power BI to craft interactive and insightful visualizations. This integration enhanced data comprehension, providing stakeholders with dynamic reports and dashboards.

Bengaluru, Karnataka, India

- Accumulated significant experience in data-related operations within the Supply Chain domain, specifically for Adidas, during my tenure at Zensar Technologies.- Independently managed the migration of over 70 complex SQL and PL/SQL queries, showcasing proficiency in database migration and ensuring a seamless transition.- Independently migrated more than 80 Cognos reports, meticulously testing each feature individually to guarantee functionality and reliability.- Authored new SQL and PL/SQL queries from scratch, addressing diverse needs such as reporting, ETL processes, and quality assurance, underscoring a versatile skill set.- Utilized Cognos Framework Manager to create Cognos packages, enhancing the efficiency of data utilization in reports and ensuring streamlined reporting.- Created reports with advanced features like drill-down, rendering and prompts in IBM Cognos Analytics and SSRS, elevating the quality and functionality of the reports.- Played a pivotal role in designing and implementing Data Flow and Control Flow, crafting SSIS packages for efficient ETL processes, highlighting proficiency in SSIS.- Integrated data seamlessly with Tableau, leveraging its visualization capabilities to enhance data representation and analysis in reports.- Incorporated Power BI for enhanced visualizations, contributing to more interactive and insightful reporting solutions.- Contributed to the holistic reporting ecosystem by combining expertise in SQL, PL/SQL, Cognos, SSIS, Tableau, and Power BI, ensuring a comprehensive and technologically diverse approach to data management and reporting.

Master Of Science - Msc, Big Data Technologies, Distinction

Bachelor Of Technology - Btech, Information Technology, First Class