D Chaithanyaa Email and Phone Number

Manage Automation of ETL across ABF, NHCDC Public and PrivateManage health data from different states across AustraliaProvide meaningful insights Data preparation for National Benchmark Portal Data analysis and adhoc reportingQA the work of analysts assigned to me

Managed Automation of ETL using HIVEDesigned dashboards for senior executives Incharge of daily stand up meetings with internal and external stakeholders Developed and Manage the ETL Process using SAS and HIVE across all Activity data streamsPrepared the Activity Data Report across 3 years of data Create reports for trend analysis over 5 years of data Data preparation for National Benchmarking Portal for Costing and Activity data using 3 years of data and developed test cases Perform Data Investigation and adhoc reporting Developed the data validation report for QA enhancementsCreate and deploy packages as per requirements and also upload data to drop box

Updated and ran the SAS DI jobs through Autosys and Batch modePerform defect fixing of various scenario codes and make code changes where necessary.Rerun SAS code for fault Alerts for both customer screening and transaction monitoring.Validate the data sent by the testing team and analyze the defects.Validate the prep datasets from ABT.Cross check the data flow from Core to KC. Check that the alerts have correctly synced in the SAS UI.Create packages and deploy them in various environments.Perform backwash and daily cycle runs in different environments.Perform Alert Generation Process run. Update the oracle tables where necessary.Make changes in ECM UI where necessary.Liaise with the testing team regarding various defects and provide a daily update.

Run the daily delinquency report and email the report for decision making.Generate DP Fraud Report for monthly fraud.Populated the PRMI Data tables from NRMS and other source data tables.Generated the DP statistics report.Generated the delinquency summary report.Run the customer exposure report for finding the various exposures of individuals and groups to the bank.Used the LLAS software for finding the account level details of the customers.Merged the CFAL data with the Sovereign data to build the POP table.Generated the BAD Debt forecast model.Generated the CFAL Operational Dashboard.Generated the Westpac Roll Rates report.Generated the Write-off and Vintage report.Generated the small ticket low doc report.Generated the Westpac Auto finance Report.Perform adhoc change requests for the client.

• Created all types of dashboards using SAS Table, Info Map and Stored Process as a source and KPIs (Gauges), Interactive Dashboards, Report Linking etc. in SAS BI Dashboard.• Generated, Scheduled and Maintained reports in SAS Web Report Studio using SAS Datasets, OLAP Cubes and Information Maps as sources.• Developed OLAP cubes to report large volumes of data, provide hierarchical drill downs, and slice and dice capabilities. Developed custom MDX measures, members, and sets to provide dynamic result sets which enables flexible reporting in SAS OLAP Cube Studio. • Created Information Maps in various types of prompts and filters and implemented BI Row-Level Security in SAS Information Maps.• Distributed the generated reports at different levels of data accessibility by choosing different Portal pages with a mixed combination of Portlets in SAS Information Delivery Portal. • Interacted with Clients and Business Users for requirements gathering.

• Interact with business users and gather requirements.• Assisted in developing design documents with the functional consultant.• Generated SAS EG stored processes with static and dynamic prompts for product-specific analysis.• Designed multidimensional cubes for Balance Sheet, Profit and Loss.• Developed Risk adjusted performance reports for measuring performance across various lines of Business.• Developed an internal model to calculate the provision to be created for the expected impairment of unimpaired loans as on date based on the trend of downgrading of the previous year.• Developed Portal pages for Business\​End Users for data exploration and saving their reports.• Developed Information maps for WRS reports and dashboards and provided dashboard linking.• Performed unit testing on developed reports.