Mallesh Gangadhar

• SQL Data restoration, SQL Data taking Back up
• Worked with HSBC Client , Successfully extracted SQL Table data from 35 regions databases, each containing 9 tables, using Python programming language.
• One SQL Table contains data with 32 GB we handled successfully read and write it csv using Python.
• Compiled extracted data into CSV format with a pipe delimiter for efficient organization and analysis. .
• Employed compression techniques to package the data into a gzip file,
• facilitating seamless transfer to the AWS cloud infrastructure.
• Monitored and visualized the progress of the extraction and transfer process using Grafana dashboard ensuring transparency and accountability.
• Contributed to risk management efforts by providing data for verification against existing datasets, aiding in decision-making processes. Key Technologies Utilized: Python, SQL, CSV, AWS, Grafana, VBA Userform, Control M, Bash script, SQL Stored Procedure, etc.
• REST API Development** - Data extracted by logging to webisite and downloading reports from it. and performing Transformation and loading into SQLite and linking to Grafana dashboards
• Python with SharePoint Automations** - Developed automation scripts to read data from Microsoft SharePoint azure , Read Data , transformed and written to SQLite and linked to Grafana dashboards

Python with Outlook Automations** - Automated email processing, scheduling, and reporting using Python and Outlook. Data integration with SQLite and Grafana.

Code Run via Scheduler - Automated ETL processes using Windows Task Scheduler, integrated with SQLite, and Grafana dashboards.

Created Excel macro user form, user-friendly applications.

• Automated many weekly , monthly report automations using VBA and Python
• Created userforms , outlook automation, vba with sql data extraction etc

• Automated Citi Bank client reports using VBA macros.
• Consolidated daily, weekly, and monthly reports.
• Web scraping using VBA macros.
• Outlook automation via VBA.
• SQL table extraction into Excel using VBA.
• Developed automation solutions for GOLDMAN Client, including:
  Equity Daily Tracking
  Rates Macro (Daily SOD, EOD, RU updates)
  FX Broker Macro Outlook
  CFTC Macro
  OMVM Macro for Outlook
• Automated various financial product reports, including OTC, swaps, IRS caps, FRAs, options, FX spots, forwards, and NDFs.
• Implemented automation across Excel, PowerPoint, Access, Outlook, SQL Server, and web scraping techniques.
• Provided training and support on automated tools and processes.
• Key Technologies: VBA, Microsoft Excel, PowerPoint, Access, Outlook, SQL Server, Web Scraping.

• Worked for Trade settlement process , Treasury Services of Assets service managements.
• Worked in finance fields
• given more kaizen waive ideas for process improvements

• Worked for British Telecommunication Services Semi voice process
• picking call from end user and taking their query on PSTN/Broadband fault
• Finding Fault in Cables using trouble shooting remotely
• booking engineers to repair the task.
• following with engineer for updates
• creating reports weekly , monthly etcs
• helping teams and juniors in the team.