Dinesh Allala

• Worked on the requirement gathering of the reports for our client to create proper dashboards on SFTR metrics dashboard.
• Analyzed the database tables and created views based on the columns needed.
• Used Data Blending, groups, combine fields, calculated fields and aggregated fields to compare and analyze data in different perceptive.
• Created Rich dashboards on Risk Analytics using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created SDIP dashboard Graphs like dual, bar and line etc.
• Developed complex reports using features like Drill capabilities, dynamically display the tables and charts, YTD and MTD calculations with multi sources.
• Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
• Working on Delivery Margin predictor dashboard to check the daily collateral and investment values from different banks.

• Built complex financial reports with eight data sources and worked with blending which were based on data from various data sources.
• Experienced in performing various database activities which includes writing SQL queries, Custom SQL while building the reports.
• Experience in Table Calculations and Filters (Data Source, Report, Column, Context, User and Actions).
• Experience in Dual Axis and showing the graph in New Visualization.
• Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
• Experienced in showing top 10 highest values and top 10 lowest values in same sheet.
• Experience in creating LOD Expressions.
• Experience in developing reports with Parameters, Groups, Sets, Calculated fields.
• Has involved in Quality Management activities by creating project related documents.
• Connected Tableau Server to publish dashboard to a central location for Integration.
• Created Trend Lines, Reference Lines and statistical techniques to describe the data.

• Prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Data quality testing by comparing output of dashboard with database. Functional testing by checking filters, navigation etc.
• Publishing dashboards on server and giving access to users. Getting reviews from end users and modifying the dashboards accordingly.
• Developed Tableau data visualization using Cross tabs, Heat maps, and Scatter plots, Geographic map, Pie Charts and Bar Charts.
• Creating reports using Tableau for customized and ad-hoc Queries.
• Provided Production support to Tableau end users and Wrote Custom SQL to support business requirements.

Sanctions Screening/Financial Crimes analyst:

• Perform research on transactions stopped on the firm’s sanctions screening systems to establish if any true matches to sanctioned entities.
• Assist in implementing OFAC/Sanctions initiatives including quality assurance, policy reviews and advising on establishing screening procedures within the businesses.
• Working with the Country GFCC and the Regional Sanctions Officer, performing the necessary research and query to determine the sanctions requirements in Asia and US/ EMEA
• Mitigates Operational/Transactional risk through proactive measures being aware of various cut-off times, accurate processing and verification of payments.
• Monitoring the reports and other related source documents for Suspicious/unusual patterns of activity. Follow-up with responsible area for explanations and discussions for appropriate action.
• Activities of assigned area(s) to ensure compliance with applicable internal policies and procedures and external regulations. Name screening clients, transaction monitoring using World Check and other relevant systems.
• Conducting proactive research to identify customers or counter-parties that may be engaged in high-risk activity and referring such customers to Sanctions Customer Due Diligence & Remediation Team for review and action.

AML/KYC: Global (EMEA, AMRS and ASIA)

• Monitor new patterns/techniques of money laundering & terrorist financing and ensure necessary measures are implemented by the business to deal with any emerging AML risks. Also, review the Firm’s new business initiatives, products and services and address any emerging AML risks.
• Meeting the required high-quality standard and conducted internal audit to ensure nil error finding in the final quality review
• In-depth understanding of Regulatory Risk & Compliance, Sanctions Screening, PEP screening and adverse media screening and escalating true match.
• Reviewing and analyses key elements of each KYC due diligence case with risk-based approach

(High Risk, Medium Risk, Low Risk)

• Performing the required KYC screening on existing clients by documenting and corroborating the information obtained on the client as required by the Global KYC Procedures utilizing a variety of independent research sources.
• Conducting Customer Due Diligence (CDD) and Enhanced Due Diligence (EDD) investigations to gather information using internal and external systems, databases and other resources.
• Preparing Doc Gap Analysis Checklist embedded with the Global, Jurisdictional and Entity specific requirements.
• KYC analyses include summarizing structures and control, identifying and verifying the ultimate beneficial owners of the firms and performing EDD (Enhanced Due Diligence) for High-Risk clients.