Aman Mehta

Roles and Responsibility

• Recent focus on financial data analysis worked with variety of data in SQL
• Worked with different stakeholder for information gathering across a variety of departments.
• Frequently Analyze the data from SQL databases and involved in data cleaning, requirement gathering, to Support different stakeholders and different team.
• Provide the actionable insights to the business based on my analysis on the variety of data mainly (Banking & Financial, API performance data, Authorization data,Reward & Alert Notification Data etc.)
• Involved in Feature engineering, data cleansing, data transformation, data preprocessing techniques. In order to make data useful with the help of Python, Pandas.
• Used Microsoft SQL Server Management Studio for managing financial data filtering and providing the
• Required data according to the assigned Jira or requirement through different teams.
• Extracting the data from different Environments like QA, Dev, Productions databases.
• Worked on different types of environments like Production environment, QA environment, UAT environment, Dev environment, Performance environment etc.

Tech : SQL ,T-SQL,Python

Libraries : Numpy ,Pandas,Matplotlib

Data Visualizations Tools : Splunk,Prometheus, Grafana

Project - Credit Card Processing (Plat & Jazz)

Project Goal: To build a compliance rules on which customer transaction Interest,fees calculation flow logic depends on various types of transactions(Revolving,Retails,Rewards)

Roles and Responsibilities:

• Worked on Project from scratch requirement gathering, documentation and designing .
• Created various rules (Calculating the BSFC (Bank Subject to finance charge),Design change of statement PDF generation of accounts)
• Analysis of Transactional flow of Data and Modifying the pre-existing SQL Procedures.
• Enhancements of pre-existing rules of credit card processing.

Tech : Microsoft SQL Server Management, SQL, T-SQL ,JIRA, C/C++