Alka Gupta
Associate Vice President at RBS
16.9
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
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.
2017 - 2019
rbs
Senior Associate
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.
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.
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.
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.
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.
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.
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
2001 - 2005
guru gobind singh indraprasha university
B.Tech
Information Technology
