Amit M.

Spearheaded the development of a robust ETL pipeline utilizing Alteryx, designed to support both full-load and incremental data workflows. The process involved extracting structured data from PostgreSQL databases, performing comprehensive data preparation and transformation tasks, and subsequently migrating the refined datasets to Amazon Redshift data warehouse. This solution enhanced data accessibility and reliability across the organization, streamlining analytics and reporting functions.

Crucial role in Alteryx Server management, user access, and collection creation. Proficient in Alteryx Designer/Server, Jira Scrum, Azure DevOps, Postman, Python, SQL, Snowflake, Oracle, SDLC, and project management. Worked on a workflow to create email drafts for outstanding breaks to corresponding client and broker with summary of the respective breaks. Created a workflow for booking money market trades on T0 for NT Custody accounts for Northern Trust market funds in Point in time PIT release. Worked on reconciliation of current face of amortizing bond positions against Bloomberg, to ensure that MV calculations are correct for EOM reporting. Worked on a daily comparison of valuation changes for Ascension funds on NT Custody platform for previous 2 business days.

SBI Capital Securities : Worked on creating data pipelines and managing database using data warehousing concepts. Extracted data from varied sources (Excel, JSON, Oracle, MS SQL, PostgreSQL, MariaDB, APIs with authentication). Skilled in crafting macros (iterative, batch, standard), utilizing uncommon tools (run command, Google Sheet input, block until done, detour, dynamic input/output, download, JSON parse). Proficient in SQL Server Management Studio (SSMS) for schema/table management. Created reports for the management, which signifies the important KPIs and assist them make the best business decisions

Data annotation is an indispensable stage of data preprocessing because supervised machine learning models learn to recognize recurring patterns in annotated data. After an algorithm has processed enough annotated data, it can start to recognize the same patterns when presented with new, unannotated data.

Taught Mathematics to Classes XI and XII and guide them in the preparation of school board exams CBSE, ICSE & competitive exams for engineering college admissions like JEE Mains & Advanced, BITSAT, IPUSET etc. Also assisting them in the preparation of RMO (Regional Mathematics Olympiad), KVPY scholarships (Kishore Vaigyanik Protsahan Yojana) and NTSE (National Talent Search Examination) exam.