Shivam Kumar Email & Phone Number

Bangalore Urban, Karnataka, India

Business and Data Analytics1. Working as a Lead Control Management Specialist for Wells Fargo Bank Central Controls Organization (CCO) RAD Team.2. Current Role divides into 4 parts (Leading a team of Associates, Business Requirement gathering, ETL & Data Analysis, Data Science Solutions integrated with Data Visualization & Storytelling, POC and proposing new solutions).3. The bank is enhancing its control functionality and optimising and enhancing its RCSA Process. We as a CCO team work with different Business Owners, understand their regulatory problem statements and propose a sustainable data-driven solution.4. Proposition includes a small POC, planning a project with resource management and then delivering a sustainable automated solution, which not only saves Man hours but also enhances easily in future for further requirement addition.5. Creating Business and Data Analytics algorithms based on deep-dive statistical analysis & predictive data modelling to resolve the current Bank’s Risk and Compliance regulatory problems.6. Analysing bank's regulatory Issues in different lending businesses and creating Analytical reports and solutions using data Analytics to save their man hours.7. Deploying quantitative analysis & data mining/visualization to present data on user interaction with the product.8. Working on additional enhancements and Automation projects to increase team productivity.Data Processing & Transformation1. Organizing huge data sets effectively via advanced querying, visualization and analytics tools2. Performing data analysis & creating dashboards to boost flagship business initiatives across the retail banking ecosystem.3. Creating different ETL and Pipeline solutions into DB & no-DB tools using Databases, Alteryx ETL and SharePoint.4. Playing a pivotal role in saving several man hours of BCMs in Control Organization by identifying several manual activities into systematic Automated solution.

Bengaluru, Karnataka, India

1. Working as a Lead Analyst for US Leading Banking client for their Retail Transformation Analytics Team.2. Role divides into 3 parts(Business Requirement gathering, ETL & Data Analysis, Data Visualization & Story telling).3. Creating algorithms based on deep-dive statistical analysis & predictive data modeling to personalize customer interactions. Analyzing bankers daily retail activities of each branch in each region and creating Analytical reports using data manipulation to boost their monthly activities by 12%4. Deploying quantitative analysis & data mining/visualization to present data on user interaction with the product.5. Identifying and analyzing the impact of COVID 19 and their new product on customer acquisition, behaviors and retention.6. Working as an Internal Project Manager in Acuity KP.7. Organizing huge data sets effectively via advanced querying, visualization, and analytics tools8. Performing data analysis & creating dashboards to boost flagship business initiatives across retail banking ecosystem.9. Playing a pivotal role in generating huge revenue for bank by identifying performing and non performing branches for each market/region by preparing data sets & creating dashboards to boost sales.

Bengaluru, Karnataka, India

Citi Bank, Bangalore, KA(Aug 2020 - Dec 2020) -Created ThoughtSpot Sales Analysis BI Report for Retail Banking Sales Analysis Project where data from Data Lake.Analyzed data for these new reports by crunching the raw information into meaningful data over months and then moved it to Teradata database which was the current source of ThoughtSpot.Microfocus, Bangalore, KA (Sept 2019 - Aug 2020)-1. It was an Merger Program management by Wipro and Microfocus Ltd which has acquired HP Inc. business.2. Worked as a Lead Data Analyst and spearheaded a team of 15 Database and Tableau developers to understand the current HP's Financial reporting structure. Analyze and understand the data.3. Converted these raw data into a finished View point for Tableau Reports.4. Converted old HP reports from Qlik Sense into Tableau.Acxiom Ltd, Leeds, United Kingdom (Sept 2016 - Nov 2019) -1. Partnered with Acxiom to their Data Analytics team of their various clients.2. Worked as a Lead Data Analyst. The role was to manage a team of 7 members to analyze, design and implement new data warehouses for various clients of Acxiom.Citi Bank, Karnataka, KA (Nov 2014 - Sept 2015) - It was a holistic Credit risk management Application using the MetricStream EGRCP Internal tool Project. Worked as a Business Analyst, the role was to understand the Credit Risk team requirement from the Application and sync all the stake holders to work and complete the requirement, provide training to the business team and provide the business team a complete solution for the business.

Bengaluru Area, India

As a Database Technology Specialist, role was to maintain the Wholesale Banking Transaction Risk Management Application for the bank.

Bangalore

As a Database Technical staff of an Internal Audit, Risk and Compliance Product team, my role was to sit in Product design, develop and implement a new Risk and Compliance Product for various clients of Company and then hand it over to over Services & Support team. I was part of Audit, Compliance, Issue Management, Risk modules of MetricStream EGRCP 6.0 Product development.

Pgdds, Post Graduate Diploma In Data Science

Activities and Societies: Data Science, Data Analysis, Python for Data Science, Tableau, AWSData Science, Data Analysis, Python for Data.

Bachelor Of Engineering (B.E.), Computer Science

B.E. Computer Science

Post Graduation Diploma, Diploma In Data Science And Machine Learning, 3.8/5

Education record

Pgdds, Post Graduate Diploma In Data Science

Master Of Science - Ms, Data Science

Master'S Degree, Data Science