Solution-focused IT Team lead/Scrum Lead with 15+ years of experience in leading and managing technology projects from design through to implementation. Instrumental in dissecting complex problems, devising iterative processes, and leading end-to-end change management. Transitioned teams from Water Fall based development model to Agile based model to improve efficiency and speed. Worked on various roles during my IT career: Data engineer : Designed and implemented ETL solutions for Retail and banking clients using data workflow orchestration tools like Airflow, Control-M, Autosys.Data modeling for databases like Oracle/PostgreSQL and Data warehouses like SnowflakeDesigned and implemented consumers for Data Streaming platforms like Kafka. Power BI engineer : Designed and implemented Operational reports and Analytical reports for Retail clients.PBI Data modeling using star schema methodology. Modeled dimension tables and fact tables. Worked on DAX expressions and M- Language to bring in complex calculations.Java developer front end, back end: Designed and developed software web applications using Java/J2EE/Struts. Designed and developed core java batch applications. Configured a purchase order management system using IBM ODM in java. Retail Consultant: Merchandise Financial Planning (MFP): Enhanced and implemented Oracle MFP solution for a department store chain. Designed and Configured RPAS workbooks like pre-season, in-season, and demand planning. Designed and implemented RPAS batch interfaces with source systems like RMS, RDW. Specification for hierarchies and fact data. Item Planning (IP): Enhanced and implemented Oracle Item Planning solution for a department store chain. Designed and Configured RPAS workbooks like pre-season and in-season workbooks. Designed and implemented RPAS batch interfaces with source systems like RMS, RDW. Specification for hierarchies and fact data. Oracle Retail (RMS): Created Oracle Stored Procedures and functions to create purchase orders in RMS. Implemented batch interfaces to get data out of RMS like On Order, Sales, Receipts, Stock Ledger etc.Tradestone/Bamboo Rose (SOX compliant system) : Configured and maintained IBM ODM rule-based purchase order management system. Enhanced the system by automatically approving PRs based on In-Store week and shipping criteria. Implemented event-based grouping and prioritization of the purchase orders. Technologies: JAVA, SQL, PL-SQL, UNIX Shell Scripting, Tradestone, RMS9, PowerBI, Snowflake, Oracle RPAS, Airflow, PostGreSQL, kafka.