Shubham Gupta
Business Analyst - BA4
Pune
Summary
- Driven by a passion for data analysis and business optimization, I've successfully leveraged SQL, Hive, and Agile methodologies to enhance operational efficiencies by up to 25% at FIS Global;
- Collaborative skills and expertise in Tableau and Python have driven impactful decisions and innovative solutions across diverse teams;
- Also, have experience working on tools like Ab Initio ETL tool, Tableau etc for Data preparation/blending and visualization.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
4
4
Certificates
Work History
Business Analyst - BA4
Barclays Global Services Bank PLC
Pune
02.2023 - Current
- Implemented 3 new requirements which helped in maximizing business need on new trade platform;
- Redesigned finance related platform with newly integrated solution;
- Collaborated with business stakeholders from requirement gathering till implementing requirement;
- Managed to updated DB mappings based on requirements;
- Prepared LLR, HLR, Target Operating Model (TOM), Data Mapping document for project;
- Conducted interviews with key business users to collect information on business processes and user requirements;
- Used Tableau to create interactive reports/dashboards by connecting to various data sources;
- Used Ab Initio to manage complex data workflows, transforming large volumes of data, and ensuring data quality across diverse systems;
Senior Lead Analyst
FIS Global
Bengaluru
07.2021 - 02.2023
- Implemented 4 products (Retail Deposit, Credit Cards, Statements, Notices) on MBP platform, driving increased service offerings;
- Handled CAPE RAS (Analytical Tool) application for accessing data and reports from Hive, Impala and Data Lake Database and its configuration, Reports/Statement implementation, framework designs etc;
- Worked on data science models like linear and logistic regression for calculating banking and financial risks on Bank;
- Enhanced RAS DB performance by 25% through issue resolution using JAVA, Python scripts, and SQL;
- Monitored RAS server to check if it's capturing daily entries on different reports and establishing process to expedite activity, for performance improvement of RAS server;
- Delivered MBP implementation using Agile methodology and Jira to track activities and manage timelines within project;
- Worked WinSCP for Hive connection and using putty for SQL execution in UAT and production;
Team Leader, Business Analyst
Concentrix Daksh Services India Private Limited
Hyderabad
01.2021 - 07.2021
- Collaborated with cross-functional data science teams to develop solutions, deriving business insights and solving operational problems for clients;
- Scheduled trigger jobs in production using Google plx-trix scheduler, enhancing operational efficiency;
- Implemented Agile Scrum methodology, leading 17-member team to analyze operational impacts and guide effective technology changes;
- Used SQL and joins to arbitrate data as per individual business logic. Also expertise in SQL performance tuning;
- Data sources are extracted, transformed and loaded (ETL) to generate CSV data files and Google sheets with SQL queries;
- Building dashboards on Tableau, Google Plx and Data Studio and collating data as per clients request;
Senior Business Planning Analyst
Micro Focus India Pvt Ltd
Bengaluru
03.2018 - 01.2021
- Identified data sources, gathered and analyzed data, improving development responses, resulting in more informed decision-making processes;
- Mentored employees to enhance task completion, resulting in a 20% increase in efficiency. Drafted financial reports to assess team metrics;
- Guided cross-functional teams of 10 members to analyze operational impacts of technology changes, identifying enterprise-wide opportunities;
- Worked closely with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance;
- Conducted workshops with stakeholders to establish favorable business relationships and support mutually beneficial interests, advise/consult with accountable stakeholders in HP Software business unit, as needed;
Database Administrator / Business Analyst
IBM India Private Limited
Bengaluru
07.2015 - 03.2018
- Maintained technical and functional specifications to document database intentions and requirements;
- Managed project management operations for Core Banking Platform migrations;
- Established user profiles and access levels for each database segment to protect important data;
- Maintained existing Databases, Tablespaces, tables etc, to meet unique needs and goals determined during initial evaluation and planning process;
- Writing JCL and SQL Queries for accessing Database and to run health checkup jobs with help of utilities;
- Has been part of DB2 database migrations from v9.1 to v10 for one of Insurance company of UK;
Education
Bachelor of Technology - Information And Telecommunication Engineering
SRM Institute of Science & Technology
Chennai 08.2011 - 05.2015
Skills
SQL and Hive Databases
Certification
CERTIFIED DATABASES AND SQL
Timeline
CERTIFIED DATABASES AND SQL
08-2024
Business Analyst - BA4
Barclays Global Services Bank PLC
02.2023 - Current
Senior Lead Analyst
FIS Global
07.2021 - 02.2023
Team Leader, Business Analyst
Concentrix Daksh Services India Private Limited
01.2021 - 07.2021
CERTIFIED TABLEAU PROFESSIONAL
11-2020
CBAP - CERTIFIED BUSINESS ANALYSIS PROFESSIONAL
10-2020
CERTIFIED DATA ANALYST USING SQL
10-2020
Senior Business Planning Analyst
Micro Focus India Pvt Ltd
03.2018 - 01.2021
Database Administrator / Business Analyst
IBM India Private Limited
07.2015 - 03.2018
Bachelor of Technology - Information And Telecommunication Engineering
SRM Institute of Science & Technology
08.2011 - 05.2015
Similar Profiles
Chinukwe ChandaChinukwe Chanda
Manager: Forensic Investigations at Absa Bank Zambia Plc (formerly Barclays Bank Zambia Plc)Manager: Forensic Investigations at Absa Bank Zambia Plc (formerly Barclays Bank Zambia Plc)
V. MohanrajV. Mohanraj
Assistant Manager of Operations at Barclays Global Service Centre PLCAssistant Manager of Operations at Barclays Global Service Centre PLC
Aayushi ShahAayushi Shah
Client Vulnerability Specialist at BARCLAYS BANK PLC, United KingdomClient Vulnerability Specialist at BARCLAYS BANK PLC, United Kingdom
Sagar ChandrawarSagar Chandrawar
Sales Operation Specialist at Veritas Technologies Ltd (now Part of Cohesity)Sales Operation Specialist at Veritas Technologies Ltd (now Part of Cohesity)
Yad SinhaYad Sinha
Mainframe Sen. Consultant at ADPMainframe Sen. Consultant at ADP