Akshay Kumar Dubey

My Career Objective is To pursue a challenging career and be a part of a progressive organization that gives scope to enhance my knowledge, skills and to reach the pinnacle in the field with sheer determination, dedication and hard work.

 

Project 1: Building Data Quality Tool for Operational Risk Analysis:
Require to build a tool to check the Quality of the Data with respect to the Generic and Business Rules.

• Identifying the Data Elements for Data Quality Matrices, and mapping these Data Elements to the Data Quality principles
• Writing the SAS code for all the Generic and Business Rules
• Implementing the Tool to generate the input for Tableau visualization

Project 2: Migration of Cognos RiskInsite to SAS:
Understanding the Cognos Business Rules which contain the Cognos Code & Filters and writing the same code in SAS and automating complete project.

• Pulling the required data sets and the reports from Cognos and importing them to SAS
• Writing the SAS code for all the Business Rules and Filters which are present in Cognos
• Optimizing and Automating the SAS code as per the requirement

Project 3: Analyzing Retail and Online Customer Engagement:
Require to analyzing the sales and customer browsing history with Adobe analytics and also analyzing the retail data (Clients: Adidas UK, Croma, Marks & Spencer UK, Jio, YellowPages US).

• Extracting the captured data from Adobe Analytics
• Analyzing and Evaluating the browsing and purchase history
• Visualizing the sales and customer behavioral reports and dashboards in Tableau

Project 4: Portfolio Management:
The goal of this model is to extract data from various sources to analyze and build model for monthly and Quarterly cash flow within GFIR and GCAR for securitisation.

• Analyzing the customer data into mortgage portfolio
• Building and modifying the CDS from mortgage portfolio in SAS EG
• Deploying the model for securitisation

Project 5: Customer and NBC Analysis:
Analyzing and evaluating the business outcomes post-delivery of NBC (Next Best Conversation).

• Ideation and implementation of the NBC in the system from end to end (B2C, C2B and B2B)
• Analyzing the customer historical transaction and pipelining the NBCs to the customer
• Analyzing the business outcome from NBC and generating the reports to provide business improvements