Summary
Overview
Work History
Education
Skills
Timeline
Generic

Mohammad Abdul Aala Siddiqui

Chicago,IL

Summary

  • Having overall 7+ years of Capital Markets/Investment Banking and Supply and Retail experience as an IT engineer in developing, Designing, Client onboarding, Infrastructure setups, Release Management, Production Support activities and Technical Business Analyst with various clients as Arab Suppliers LLC, Wells Fargo Bank, Bank of America INC.
  • Excellent communication and Team leader skills and a very well-versed coordinator with Business and Technical teams in understanding the process flows and deliver a fast and reliable solution. Good understanding and knowledge on various financial products as Securities, Holdings, NAV, Performance in designing and setting them up in EDM for creating Functional specifications.
  • Proficiency in developing SQL, PL/SQL with various relational databases like Oracle, Teradata and SQL Server.
  • Good Understanding and hands on experience in Centralized Data Repository like Markit EDM, Eagle PACE and various EDM architectures.
  • Experience in all the phases of Data warehouse life cycle involving requirements gathering/analysis, design, development, coordinating, validation testing of Data warehouses using ETL, Data Modelling, Reporting tools.
  • Acquiring knowledge on SNOWFLAKE and cloud platforms (AWS and Azure) to implement in upcoming projects.
  • Experience in Supply and Retail industry in maintaining repositories in EDM (Enterprise Data Management) for raw materials and maintain supplier data.
  • Coordinate with Sales team for managing relational databases for Sales and Supplies.
  • Hands on experience in CRM module.
  • Experience in creating projects and issue tracking and bug tracking using tool like Atlassian JIRA for project management and conduct scrum meetings for sprint planning and bug tracking.
  • Hands on experience on Atlassian Confluence tool for creating, organizing, and sharing documentation and content among teams on functional and technical aspects of data flow and architecture for project references.
  • Exposure and experience in different methodologies like Agile and Waterfall.
  • Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, RTC and Confluence to track the progress of projects.
  • Good Knowledge on Scheduling tools like Autosys, Tidal Scheduler, Dollar Univiewer, Control M, ESP scheduling for configuring and scheduling jobs.

Overview

6
6
years of professional experience

Work History

Technical Business Analyst

Tech Mahindra
08.2020 - 07.2022
  • Company Overview: Client - Bank of America/ Merrill lynch
  • Work with Business partner for gathering requirements for different financial data points and translate them into technical design for developers to create workflows.
  • Analyze data coming from different sources like Aladdin, PACE, FactSet and create a business specification document to feed the data in financial services EDM platform.
  • Worked with various platform team in Integrating Bank of America/Merrill lynch investment data and designing the architecture for various data points like Securities, Holdings, Performance, NAV, People's data and coordinating with developers for creating workflows.
  • Create Issue tracking and projects using Atlassian Jira and conduct sprint planning and projects assignments.
  • Create functional specifications for business requirements and documents data flows for each financial data flow using tool Atlassian Confluence.
  • Create data feeds according to business requirement for different investment portfolios as stocks, bonds, cash in relational data warehouse.
  • Conduct end-to-end analysis of business process from a strategic perspective and provided advice on the functions within the applications addressing inefficiencies/possible enhancements.
  • Provided post-implementation support, analysis and management before transitioning management to support division. In addition, I conducted training when necessary for transitions to support division.
  • Create Report in Tableau and support data feeding into Tableau.
  • Client - Bank of America/ Merrill lynch

Program Analyst/ EDM Support

Tech Mahindra
10.2018 - 08.2020
  • Company Overview: Client - Wells Fargo
  • Supporting Eagle Pace Application for End-to-End Business integration as part of EAI.
  • As per client requirements, worked on enhancements and development of Database oracle SQL commands.
  • As per Client's ad-hoc request, used to write SQL queries to send the reports.
  • Created stored procedures and triggers in the database based on the requirement from end users.
  • Was responsible for writing T-SQL stored procedures (SQL Server), functions, complex queries, Triggers etc.
  • Improving performance of stored procedures and functions.
  • Redesigned the components in favor to improved code readability, performance, maintainability and extensibility.
  • Debugged predefined procedures and Functions.
  • Have hands on experience on Eagle pace modules like Data Mart, Entity, Data Management, Codes, General Reporting, uploaders and exporters.
  • Maintain events, run an Event, Eagle portal, and few other modules.
  • Prioritizing of issues [as per SLA] and communication with various teams to resolve issues/clarifications as per the request from end users.
  • Understanding of Capital Markets like concepts of funds, position, securities, trade, cash, price and their co-relation in between.
  • Supporting Scheduling tools Tidal Scheduler and Dollar Univiewer.
  • Creating jobs in Scheduling Tools for picking up the files from different FTP servers.
  • Migrating jobs from Tidal Scheduler to Dollar Univiewer as part of Implementation plan.
  • Have worked on Serena Business Manager (SBM) tool for Deployment of jobs in various environments.
  • Must keep track on end-to-end module of Jobs to load the data into Data warehouse and then to the Data Mart.
  • Client - Wells Fargo

Data Analyst/IT Operations

Arab Supplier LLC
02.2016 - 09.2018
  • Collaborate with business for understanding retail requirements and create functional Specifications for relational database.
  • Responsible to work closely with BA's to understand the Dev requirement to execute retail transactions.
  • Responsible to develop/Modify SQL DB objects in Teradata platform as per requirements from BA.
  • Responsible to work on JIRA's being assigned by scrum master on EDM platform for supplier and retail materials.
  • Responsible to perform check in via GITHUB for promoting code to higher environments.
  • Responsible to Monitor and support Production deployments.
  • Support WCDIR Production support cycle and provide the root cause with SLA.
  • Support DBA activities as part of Teradata WDM team.
  • Provide user assistance for human/non-human account issues.
  • Support Automation tool for execution and resolve high priority tickets.
  • Debug Unix scripts/logs and provide support to WDM Teradata team.
  • Responsible to generate role report as per requirements from Business.
  • Support Service Now tickets assigned to WDM Teradata DBA team.

Education

Master's - Business Analytics

Trine University
Detroit, Michigan
10.2024

Master's - Engineering

Osmania University, College of Engineering
06-2015

Bachelor of Technology -

JNT University
07-2011

Skills

  • SQL
  • Tableau
  • Power BI
  • Enterprise Servicing Platform
  • SuiteP360
  • Informatica
  • Oracle 11g
  • Oracle 10g
  • Oracle 9i
  • Microsoft SQL
  • Kanban
  • Jira
  • MS office tools
  • Outlook
  • Word
  • Excel
  • Python
  • Power point

Timeline

Technical Business Analyst

Tech Mahindra
08.2020 - 07.2022

Program Analyst/ EDM Support

Tech Mahindra
10.2018 - 08.2020

Data Analyst/IT Operations

Arab Supplier LLC
02.2016 - 09.2018

Master's - Business Analytics

Trine University

Master's - Engineering

Osmania University, College of Engineering

Bachelor of Technology -

JNT University

Similar Profiles

CREATE PROFILE
Mohammad Abdul Aala Siddiqui