Experience

• 

  Kranion technologies pvt ltd

  Nov 2012 - Jul 2018

  Data engineer

  • Gathering report Requirements, Building and Publishing Tableau Reports, Creating Views, Tables, Stored Procedures in SQL Server, MySQL.• Designed, developed, and maintained interactive dashboards and reports using Tableau.• Developed and managed ETL pipelines to extract data from various sources, transform it as needed, and load it into data warehouses.• Optimized Tableau workbooks and data sources for better performance.• Applied extensive knowledge of sales and procurement contract life cycle management to enhance business processes and guide project objectives.• Engineered a robust data pipeline using Python and SQL, facilitating the migration of contract-related data from disparate systems to Emptoris CLM. Ensured a seamless transition and maintained data integrity throughout the process.• Transformed and migrated data between various business platforms, leveraging SQL and Python to ensure accurate and consistent data transfer.• Developed comprehensive reports using Tableau to support and enhance business operations, providing actionable insights and enabling data-driven decision-making.• Implemented Snowflake for data warehousing, integrating cloud-based data storage solutions to support scalable and efficient data retrieval.• Utilized big data technologies to manage and process large volumes of data, ensuring optimal performance and scalability for data-driven applications.• Worked on complex SNOW SQL and Python Queries in Snowflake.• Recreated existing SQL Server objects in snowflake.• Performed data validation and transformation using Python and Hadoop streaming.• Import data from AWS S3 into snowflake Staging are Show less