• Held strategic planning sessions within stakeholder groups to gather 1K+ operational issues for use case analysis and configure the potential solutions, transformed customer issues to digital solutions under the strategic framework, define the work scopes and ETA for the delivery patterns under Agile framework.• Designed Data Mapping and Data Governance strategies to track data relationships across SAP Entities (Transactions, Usages, Invoices, Customers etc.) to explain and incorporate data to target containers.• Automated the data transformation pipelines for different views within SSIS to extract 10M+ historical data from external resources, ingest and test data within OLAP database by using stored procedures for analytics purposes, and incorporate back-end systems to ensure cost-effective in one-day lag updates.• Collaborated with business teams to design the visualization frameworks, and worked with developers’ team to develop appropriate views, added calculating fields, and implemented 10+ Tableau dashboards to help clients finding operational opportunity volumes and transactional abnormal activities.• Created the root cause analysis across database to identify the data dis-matched and used electricity systems to validate the abnormal activities reflected in daily usage and transactions dashboards.• Developed Feature Engineering to fill in the missing values of time series and developed Time Series Model to monitor and forecast the seasonality data to track the customer behaviors regarding electricity utilizations, this forecasting model helped leadership teams to prevent the tampering activities.

• Collaborated with business and technology teams to design the process workflow to track and analyze customer payments behaviors to identify potential business opportunities and to further advance analytics and modeling patterns.• Conducted use case and fit-gap analysis to identify business user interactions and the expectations of prototyping systems in Current State and regulated Development Design and Module in Future State• Developed data integration to incorporate data from online payment nodes, extracted streaming data using Python, and designed ETL pipeline in AWS environment and data cleansing functions in Databricks to develop cost-effective updates.• Collaborated with Visual Analytics teams to develop Tableau Executive and Detailed views to track daily transactions and customer volumes within the selected nodes to determine effective distribution channels.• Generated go-to-market strategy based on model results with business summary to deliver customized Ads and new distribution strategies within new market channels and segmentations, increasing revenue by 4.5%