Senior Business Analyst
Current1. Build a complete ETL process by designing and interacting with businesses across geographies to leverage expertise and contribute to the tech community.2. Developed and implemented new ERP systems which involves merging of systems from various geographical locations to a one defined ERP system.3. Generate Tableau Dashboards with Quick filters, Parameters, context filters, and data source filters while handling huge amounts of data to visualize various sales KPIs such as forecasting of sales of different products based on closed date, order/order products of various products with the forecast, trend line, drill-downs and calculated fields, conditional formatting to perform YTD, QTD, and MTD type of analysis.4. Led a team to profile, cleanse, consolidate legacy ERP Customers by developing the model for a Global Customer Hub in Hadoop Datawarehouse system for various legacy systems like Oracle ERP Cloud, SAP S/3 system and legacy servers like SQL server using various ETL tools into a centralized repository. This is used to serve as the source of truth after enrichment is done based on various user defined rules by the business.5. Performed data mining and manipulation over large relational data sets using SQL; Developed statistical analysis and predictive models to analyze internal business performance6. Developed various governance rules for maintaining and enriching the centralized repository.