Data And Business Analyst In Banking

ADITYA MOHATA

Jersey City, NJ ***** 919-***-****

adhupv@r.postjobfree.com linkedin.com/in/mohataaditya

DATA AND BUSINESS ANALYST CORPORATE AND INVESTMENT BANKING

Innovative and driven professional with domain expertise and deep understanding in Fraud, Financial Crimes, and Sanctions Screening. Demonstrated analytical problem-solving skills while using large data sets from a broad range of sources. Working knowledge of business rules, collaborate with stakeholders and prepare Technical Requirement, Data Mappings and Data Transformation document. Skilled at leading meetings and / or presenting to various size audiences. Above average communication and interpersonal skills with high attention to detail. Areas of Expertise:

Requirements gathering, solution design and testing. Data warehousing concepts and ETL processes.

Data-related solutions (program design, data feed design, Data analysis experience using advanced SQL in

data aggregation, data visualization). Teradata, Oracle, Hive and Impala.

Reporting and BI tools: Spotfire and Tableau. Enterprise Customer and Accounts data; various Wholesale Fraud, Sanctions screening, AML, and KYC Policies. Transaction types.

ADVANCED SKILLS

Languages / Scripts: UNIX Shell Scripting, XML, SQL

Reporting / BI Tools: Tableau, Spotfire

Databases: Teradata, Oracle, Hive, Impala

Tools and Products: Informatica, Oracle Data Quality, Actimize, Autosys, JIRA, Confluence, Microsoft: Word, Excel, PowerPoint, Project, SharePoint

PROFESSIONAL EXPERIENCE

JPMorgan Chase, Jersey City November 2017 – Present

Business Analyst / Product Specialist for Wholesale Payments Fraud Program

Working on application to screen users, devices, and transactions for suspicious characteristics with a goal to prevent fraudulent activities using control rules, patterns, and behavior profiling.

•Defined JIRA best practices and helped improve process for requirements management and execution, thereby improving efficiency and productivity for all team members.

•Developed reports and dashboards in Tableau to visualize fraud data.

•Performed analysis and presented results using SQL, Impala, and Excel.

•Instrumental in onboarding backend payments and internet channels to fraud platform for screening.

•Evaluated, inspected, and improved rule-based controls, resulting in reduced false positives and increase in detection rates.

•Collaborated with diverse stakeholders to gather requirements, create technical specification guide for User Interface.

•Designed and tested profiles based on historical client, beneficiary, and transaction data.

•Designed and enhanced controls for Business Email Compromise, Lookalike domains, Malware, and detection.

•Strategized and tested solutions for migrating payments data and business controls resulting in successfully replacing legacy systems.

Bank of America, Charlotte, NC January 2011 – November 2017

Data Analyst for Financial Intelligence Unit, February 2016 – November 2017

Collaborated with Risk Data Analysts within Financial Intelligence Unit on various projects to detect emerging risks and trends in Money Laundering, Terrorist Financing, and Corruption.

•Helped detect compliance risk to the bank by working on several projects:

•Banks’ exposure to Money Service Business (MSB) by analyzing International Wire Transfer activity.

•Geographic Study to detect unusual activity at high-risk financial centers.

•Indicators for potential Foreign Terrorist Fighter (FTF) activity.

•Corruption risk related to Non-Profit Organization.

•Wrote and executed complex SQL to correlate customer, accounts, and transaction data across all lines of business.

•Developed reports and dashboards in Tableau for senior management.

•Provided analytical details and narrative of findings to leadership.

Aditya Mohata 919-***-**** Page Two

Lead Tech Analyst for Enterprise View of Client, December 2015 – November 2017

Created application for Financial Crimes by providing a 360-degree View of Customer across lines of business. With ability to rapidly search amongst multiple data streams to analyze customer, account, and transaction data for risk and suspicious activity.

•Researched and Identified data sources for use cases (i.e., Terrorist Financing, and Panama Papers.)

•Created technical specification design document, Data Lineage, and Data transformation document.

•Designed and created data model to correlate customer, account, transactions, customer risk rating, and Sanctions data.

•Extracted data from multiple Teradata platforms into HDFS staging layer.

•Created varied Tableau visualizations and dashboards for 360-degree view of customer.

•Instrumental in reducing operational expenses by over 30% for our business users.

Big Data Analyst for AML data Analytics, July 2014 - December 2015

Facilitated design data model and created a centralized repository for all AML compliance data (Alert, Event, Case, SAR, Customer, Account, and contributing Transactions. Provisioned for reporting, ad-hoc analysis and analytics purposes. Data sourced from multiple SOR’s into a single platform and assisted investigation teams to analyze data for operational and regulatory reporting needs and minimize risk.

•Created metadata driven framework to ingest, process, and store data into HDFS.

•Used SQOOP to extract huge volume of data from Teradata, Oracle, and ingest into HDFS.

•Designed and created Managed and External tables in Hive to optimize performance using Partitions and Bucketing.

•Created workflow automation using Autosys and Unix Scripting.

•Built semantic layer data model in Impala on top of target layer for business user interaction.

•Performed POC for Link analysis, Behavioral Analysis, and Trend Analysis using Impala and BI tools like Tableau 9.2.

Technical Analyst for Entity Scanning Solution, June 2011 - July 2014

Launched new Sanctions Screening tool to screen customer records on daily basis against global sanctions watch-lists that helped the Global Economic Sanctions team to minimize exposure to the risk of financial crimes and enabled compliance with increasingly complex regulations.

•Integrated data from several upstream source systems into single data warehouse using Informatica and Oracle.

•Performed data profiling and standardization on any data types using Oracle Data Quality.

•Utilized clustering and fuzzy matching algorithms, such as SOUNDEX to validate models.

•Utilized Oracle Watchlist Screening to define and create workflows.

•Routinely worked on minimizing false positives by tuning Busines Rules and ETL process.

•Developed process and data flow diagrams in Microsoft Visio, created and maintained Project Plans.

•Wrote, debugged, and maintained UNIX shell scripts to run ELT jobs in Informatica.

•Wrote Oracle procedures and complex SQL to cleanse, transform, and standardize data.

Analyst for Case Management Application, January 2011 – July 2014

Worked on Sanctions Case and Alert management tool implemented using Actimize RCM to capture, manage, and process Sanctions alerts.

•Prepared high-level and low-level designs documentation for integrating data feeds from upstream scanning systems to automate alert generation process in Actimize.

•Created and maintained SLA documents for all downstream systems.

EDUCATION

•Master of Science in Computer Science, University of North Carolina, Charlotte, NC, USA

•Bachelor of Science in Computer Engineering, Pune University, India

ACHIEVEMENTS

•Recognized by Bank of America senior management with 2 Platinum, 4 Silver and 4 Bronze Awards for Outstanding work in project delivery.

LEGAL STATUS

•Approved H1B until Oct 2023 and approved I140.

Contact this candidate