Summary
Overview
Work History
Education
Skills
Accomplishments
Work Preference
Timeline
CustomerServiceRepresentative
Shivam Shukla

Shivam Shukla

Analyst @HSBC
Prayagraj,UP

Summary

Analyst in Financial Crime Detection with 6+ years of experience in designing and implementing data-driven solutions in the Banking and Financial Services sector. Proficient in building scalable ETL pipelines, optimizing data workflows, and managing large-scale datasets. Skilled in Python, SQL, and cloud platforms, with a strong background in process automation and data warehousing. Adept at collaborating with cross-functional teams to deliver actionable insights and enhance decision-making processes.

Overview

6
6
years of professional experience

Work History

Analyst

HSBC Electronic Data Processing India Private Limited
Kolkata
12.2021 - Current
  • Crime Detection | Control Framework, Built and optimized ETL pipelines to process and analyze trade data using Python and SQL
  • Automated trade surveillance reporting, leveraging Python-based Machine Learning models for detecting suspicious activities like Insider Trading, Ramping, and Spoofing
  • Designed a centralized repository for structured data storage, enabling seamless retrieval and reporting for market abuse surveillance
  • Developed and implemented robust data normalization and validation processes, improving the accuracy of name screening systems
  • Automated regression testing workflows, achieving a 1.25 FTE reduction in manual effort
  • Integrated AML systems with enhanced transaction monitoring features, ensuring compliance with regulatory standards.

Senior Programmer Analyst

Wipro Limited
10.2020 - 12.2021
  • Engineered data processing pipelines using SAS/SQL to handle complex, large-scale datasets
  • Automated validation and reporting processes, producing outputs in PDF, HTML, and RTF formats using SAS ODS
  • Designed reusable SAS macros to streamline data extraction and transformation tasks, reducing turnaround time
  • Ensured data integrity by performing advanced troubleshooting and optimization of SAS/SQL scripts.

Programmer Analyst

Wipro Limited
06.2019 - 10.2020
  • Developed and maintained SQL-based solutions for efficient data integration and transformation
  • Enhanced SAS-based data workflows, implementing advanced optimization techniques
  • Conducted unit testing, ensuring the accuracy and reliability of large-scale data systems.

Education

B.Tech - Information Technology

Arya College of Engineering & IT

Skills

  • Programming & Scripting:
  • Python, SQL, SAS Data Engineering Tools: ETL, Data Pipelines, Data Warehousing
  • Libraries & Frameworks: Pandas, NumPy, PySpark Data Visualization: Matplotlib, Tableau
  • Cloud & Platforms: AWS, GCP, Jupyter, Spyder Automation Tools: MAST, Excel VBA

Accomplishments

  • Data Science Courses and projects with Python, Datacamp https://app.datacamp.com/profile/develo pershivamshukla

Work Preference

Work Type

Full Time

Work Location

Hybrid

Important To Me

Work-life balanceCareer advancementCompany CultureFlexible work hoursPersonal development programsHealthcare benefitsWork from home optionStock Options / Equity / Profit Sharing

Timeline

Analyst

HSBC Electronic Data Processing India Private Limited
12.2021 - Current

Senior Programmer Analyst

Wipro Limited
10.2020 - 12.2021

Programmer Analyst

Wipro Limited
06.2019 - 10.2020

B.Tech - Information Technology

Arya College of Engineering & IT

Similar Profiles

CREATE PROFILE
Shivam ShuklaAnalyst @HSBC