Business Analyst

Extraction of data, transformation, analysis and delivery of business reports using Alteryx, Toad for Oracle, TERADATA, Oracle SQL Scripts, MS SQL Server, MS Access, VBScripts and MS Office tools
Retrieval of data from applications and other reporting platform, consolidation to consumable reporting view and delivery to business users.
Supports business functions under Home Lending Originations.
Knowledge of Alteryx, Toad, SSIS, SSRS, Tableau and MS SQL Server to create, modify and re-execute SQL Scripts manually based on the requirements
Monitoring of completed reports executed via different report delivery tools such as Toad or Alteryx and updates the template aligned to the report if needed.
Conversion of Manual Reports (MS Access and Excel Manual reports like dashboards) to Alteryx workflows then be consumed in a reporting system like Tableau
Intermediate knowledge of VBA and/or Python programming to create/modify report and schedule/execute and monitor using Task Scheduler
Modification of existing Manual, Toad, MS Access and SSIS packages to accommodate business change requests by understanding business requirements, applying TERADATA ICDW, Oracle and SQL Server Script logic change, engaging business users during report validation and full production implementation and support