Umesh Sathe Email & Phone Number

Oshawa, On, Ca

Toronto, Canada Area

• Led cross-functional Data Engineering projects including Teradata to Snowflake migration, Data Pipeline creation to support ML team model and Analytics teams to provide business insights. • Built new ETL/ELT and created new Datasets and Data Models using Tableau Prep and SQL, Python• Developed interactive Tableau dashboards for real time and daily KPI to report on the performance of the business, support strategic recommendations, and key business decisions.• Developed subscriber… Show more • Led cross-functional Data Engineering projects including Teradata to Snowflake migration, Data Pipeline creation to support ML team model and Analytics teams to provide business insights. • Built new ETL/ELT and created new Datasets and Data Models using Tableau Prep and SQL, Python• Developed interactive Tableau dashboards for real time and daily KPI to report on the performance of the business, support strategic recommendations, and key business decisions.• Developed subscriber loading prediction model and analysis dashboard to help marketing team to adjust campaign based on how month is trending.• Created 50+ Tableau reports to provide business insights to leadership team. Show less

Toronto, Ontario, Canada

Working on data modelling, Tableau dashbord development and maintaining existing MI reports in SSRS and SSIS and process automation.Created new Tableau and Domo reports to measure the sales and marketing performance metrics on daily/monthly.Worked on project which help to identify net MRC for new activations happened in last 3 months.

Toronto, Canada Area

Managed and delivered over 30 different small project totaled ~$400K. Performed business requirement gathering, facilitated JAD sessions, analyze design gaps in systems and database, assessed operational or functional impacts with solutions for mitigation.Translated stakeholder requirements into tangible deliverable such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.Led the development of test cases, planning and… Show more Managed and delivered over 30 different small project totaled ~$400K. Performed business requirement gathering, facilitated JAD sessions, analyze design gaps in systems and database, assessed operational or functional impacts with solutions for mitigation.Translated stakeholder requirements into tangible deliverable such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.Led the development of test cases, planning and executing test cases for unit testing, integration testing and user acceptance testingActed as the liaison and provided project directions and recommendations for brand strategies to the client. Perform project estimates, identify risks and take required measures to mitigate risks.Tracked project status and create interactive reporting Tableau dashboards by combining multiple views to provide real-time view of system performance to different stake holders Show less

Pune

Worked as functional analyst to resolve different issues in subscriber provisioning, prepaid billing issues, postpaid billing issues, invoicing, rating and charging issuesPerformed ~200K Subscriber migration from one platform to another platform and data migration activities based on business requirementsLed and managed team to test and deploy new release code for 5 releases.Worked on different finance, revenue assurance reporting and created reports using SSIS, SSRSAutomated… Show more Worked as functional analyst to resolve different issues in subscriber provisioning, prepaid billing issues, postpaid billing issues, invoicing, rating and charging issuesPerformed ~200K Subscriber migration from one platform to another platform and data migration activities based on business requirementsLed and managed team to test and deploy new release code for 5 releases.Worked on different finance, revenue assurance reporting and created reports using SSIS, SSRSAutomated environment sync process using SSIS, Unix commands in Perl scripting which reduced environment sync time from 12days to 3days and less human errors Show less