Profile

Alka Gupta

Associate Vice President at RBS

15.8

Years of Experience

Education

guru gobind singh indraprasha university

Companies

rbs, rbs, hsbc hdpi, barclays, actiknow consulting, standard chartered bank singapore, sas singapore, dunnhumby, absolutdata

Reach out to Alka Gupta via Email, InMail and SMS drip

by installing Chrome extension

Alka's contact details

Experience

  • img

    2019 - Present

    rbs

    Associate Vice President

     Working directly with Technology and multiple Stakeholders to brainstorm, discuss strategy and mitigate issues during the migration of existing system/environment to Cloud Technologies (Amazon Web Services) which led to delivering business strategy; developed systems and procedures to improve operational quality and team efficiency.  Devised, deployed and monitored processes to boost long-term business success and increase profit levels through various techniques STOP/MOVE/AUTOMATE.  Subject Matter Expert for Retail Credit Risk products not limited to Mortgages, Loans, Cards, Personal Loans and Business Banking data.  Embracing new tools and technologies which integrates with latest Cloud Technologies (Amazon Web Services) not limited to - Python, Tableau and SAS Viya, Dashboarding  Managing/Observing 4 employee's strengths and initiated mentoring program to improve areas of weakness. Applying DTL (Determined To Lead) techniques on day to day activities to develop the require skills using coaching and Mentoring. Delegating daily tasks to employees, streamlining daily progress and efficiency.  Managing end to end projects and actively involved in each of the phases not limited to Planning, Execution, Monitoring and Control and Closing.  Contributing in various Program and Project boards where costing and prioritization is discussed. Participating in various Focus groups, brainstorming sessions and work stack prioritization meetings to ensure all the issues are prioritized as per the severity.  Managed, trained and motivated; continuously improving knowledge and abilities in various fields and tools like SAS EG, SAS DI, Tableau, Python, SAS Viya, Business Objects. Hands-on experience in the development of reports on various tools as mentioned.  Interviewed and hired strong candidates for team openings, using newspapers, job boards and social media to find applicants. Trained new employees in specific job requirements.

  • img

    2017 - 2019

    rbs

    Senior Associate

  • img

    2014 - 2016

    hsbc hdpi

    Manager - Finance Systems at HSBC HDPI

     Subject Matter Expert for Credit Risk regulatory reporting not limited to FSA, Pillar 3, COREP (Common Reporting), AXIOM adhering to PRA guidelines like Basel II and Basel III norms.  Working directly with Technology and multiple Stakeholders to brainstorm, discuss strategy and mitigate issues during the migration of existing system/environment to another like HNAH RAY which led to delivering business strategy; developed systems and procedures to improve operational quality and team efficiency.  Devised, deployed and monitored processes to boost long-term business success and increase profit levels through various techniques STOP/MOVE/AUTOMATE.  Supported, trained and guided team members to maintain high productivity and performance metrics.  Improved operational planning and business frameworks to enhance resource utilization and reduce waste.  Managing end to end projects and actively involved in each of the phases not limited to Planning (Requirement Gathering, Technical Design Document, Functional Design Document), Execution (System Testing, Functional Testing, UAT, Regression Testing), Monitoring and Control and Closing (Go Live and Handover).  Expertise in all 3 products Wholesale, Retail and Treasury Risk. This includes EAD, RWA and Risk Weight calculations.  Executed regular process updates to reduce discrepancies and enhance scheduling across calendars and programs.  Cross-trained existing employees in order to maximize team performance.

  • img

    2012 - 2014

    barclays

    Assistant Manager

     Subject Matter Expert for Credit Risk regulatory reporting not limited to FSA, Pillar 3, Regulatory Capital attestation, Economic Capital Attestation, COREP (Common Reporting), AXIOM adhering to PRA guidelines like Basel II and Basel III norms.  Devised, deployed and monitored processes to boost long-term business success and increase profit levels through various techniques STOP/MOVE/AUTOMATE.  Enhancement and New developments.  Execution of UAT and managing Production Issues.  Improving the performance of the jobs and codes by using efficient SAS options.  Ensure all the BAU’s are on TRACK.  Supported, trained and guided team members to maintain high productivity and performance metrics.  Submitted reports to senior management to aid in business decision-making and planning.  Generated repeat business through exceptional customer service and responded to customer concerns with friendly and knowledgeable service.  Attained expert level of product knowledge, becoming go-to person.

  • img

    2012 - 2012

    actiknow consulting

    SAS Consultant

    Job Profile ➢ Developing Reports on ACCOUNT Level, CASE Level, PERSON Level and REPORT Level. ➢ Improving the performance of the jobs and codes by using efficient SAS options. ➢ These reports have been developed using BASE SAS, Macros, SAS EG, Oracle and SQL commands. ➢ Deploying the scripts on FIU (Financial Investigation Unit) servers.

  • img

    2011 - 2011

    standard chartered bank singapore

    SAS Consultant

    Description: Customer Scoring and Reporting to do: ➢ Customer scoring using PROBE scoring engine. Send back the data for Analysis and Reporting. Job Profile ➢ Developing and modifying the existing ETL and SAS scripts for different type of customers. ➢ Improving the performance of the jobs and codes by using efficient SAS options.

  • img

    2010 - 2011

    sas singapore

    SAS Consultant

    Description (SAS Singapore): Enterprise Risk Management (ERM) solution to: Calculate Economic Capital (ECAP) for integrated risk for credit risk (CR) and market risk (MR) / trading and banking book. Allocate Economic Capital by business units, product lines and transactions. Develop models to perform portfolio optimization (e.g. to minimize risk for a defined level of expected return, or to maximize expected return for a defined level of risk. Job Profile (SAS Singapore):  Developing and modifying the existing SAS based Models for different instruments to identify different Market Risks.  Handling UAT and managing all the production issues.  Improving the performance of the jobs and codes by using efficient SAS options.  Helping to modify the existing model to create simulated market states for the Market Risk and Credit Risk to improve the curves structure of future interest rates.  Model used were the Forecasting and Predictive models using Vasicek, GBM and CR models.  Helping to modify the existing pricing functions to generate the prices of the deals to generate the ECAP numbers.  Improved quality processes for increased efficiency and effectiveness.  Monitored and supported production order progress through statistical models.  Adhered to established policies, procedures and compliance for satisfactory audit rating.

  • img

    2007 - 2010

    dunnhumby

    Data Solution Developer

     Subject Matter Expert to build the ETL solution (development and automation) for 3 Tesco Internationals (Czech Republic, Slovakia & Poland)  Managing/Observing 4 employee's strengths and initiated mentoring program to improve areas of weakness. Applying DTL (Determined To Lead) techniques on day to day activities to develop the require skills using coaching and Mentoring. Delegating daily tasks to employees, streamlining daily progress and efficiency.  Working directly with Stakeholders to brainstorm, discuss strategy and mitigate issues which led to delivering business strategy; developed systems and procedures to improve operational quality and team efficiency.  Technical Lead on these solutions & ensuring project executions in accordance with planned methodology and available resources and that deliverables, quality norms and schedules are adhered to.  Subject Matter Expert in the deployment of standard Marketplace products in all 3 Tesco solutions.  Supported, trained and guided team members to maintain high productivity and performance metrics.  Interviewed and hired strong candidates for team openings, using newspapers, job boards and social media to find applicants. Trained new employees in specific job requirements.  Co-ordinated with other teams to develop an in-house tool which enabled End users to track the performance of the products.  Supported Basket and customer segmentations e.g. Price Sensitivity, Shopping Mission, Shopping Habits, and Customer Price Sensitivity etc.  Identified and resolved process issues to encourage smoother procedures, more efficient workflow and overall business growth.  Improved quality processes for increased efficiency and effectiveness.  Established and maintained productive working relationships with staff to resolve operational difficulties and to promote interdisciplinary, collaborative approach to customer service provision.

  • img

    2006 - 2007

    absolutdata

    Sr Data Analyst

    A San Francisco based data processing and marketing services firm primarily engaged in Market Research and analytics, consulting to America's leading Market research companies.  Managing/Observing 4 employee's strengths and initiated mentoring program to improve areas of weakness. Applying DTL (Determined To Lead) techniques on day to day activities to develop the require skills using coaching and Mentoring. Delegating daily tasks to employees, streamlining daily progress and efficiency.  Ensure project execution in accordance with planned methodology and available resources and that deliverables, quality norms and schedules are adhered to.  Working directly with Stakeholders to brainstorm, discuss strategy and mitigate issues which led to delivering business strategy; developed systems and procedures to improve operational quality and team efficiency.  Did Pilot and PPT Studies for Monster which involved up coding part, tabulation, explanatory analysis and presenting those numbers on PPT.  Data Tabulation projects for leading Market Research companies in US like Hall and Partners, utilizing SPSS and Quantum.  Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes.  Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.

Experience

49 Skills

Amazon Web Services (AWS)

analytics

Automation

banking

business development

Coaching

Data Analysis

Data Integration

Data Processing

Data Visualization

Design

finance

forecasting

Functional Testing

Integration

Jira

Kanban

Leadership

market research

Market Risk

Operational Planning

optimization

Prioritization

Problem solving

Python

quality center

Recruiting

regression testing

Research

Research Scientist

Resource Management

Retail

Risk Management

sas

Scrum

Senior Software Engineer

social media

SPSS

SQL

Stakeholder Management

strategy

System Testing

Tableau

Technical Design

test

testing

Unix

Web

Web Services

Education

  • img

    2001 - 2005

    guru gobind singh indraprasha university

    B.Tech

    Information Technology

Colleagues at rbs

Archit Anand

Production Management

imgPhoneimgEmail

Arthur D'silva

Data and Analytics

imgPhoneimgEmail

Bhoomika Mishra

Software Engineer

imgPhoneimgEmail

Bibin Mathew

Senior Software Designer

imgPhoneimgEmail

Show more

Others named Alka

Alka Simon (She/Her)

Software Engineer

 at rbs

Alka S

Entrepreneurship - Co-Founder

 at rbs

Alka R.

Senior Software Development Engineer

 at rbs

Alka Judge

Software Engineer

 at rbs

ALKA BHARTI

SDE

 at rbs

Show more

Colleagues at rbs

Akanksha Rao

Senior Software Engineer

imgPhoneimgEmail

Alka Gupta

Associate Vice President

imgPhoneimgEmail

Alok Agarwal

Release Manager

imgPhoneimgEmail

alpa sharma

Frontend Engineer (Angular, Javascript)

imgPhoneimgEmail

Ankit Sabharwal

Analytics Manager

imgPhoneimgEmail

Show more