Sayantan Guha

• Leading development and testing efforts for the conversion of Prime Brokerage Infrastructure scripts from Perl to Python.
• Analyzed and interpreted business logic in Prime Brokerage reporting scripts for seamless migration to Python.
• Utilized Python modules, Sybase, and DB2 database stored procedures for report development and maintenance.
• Conducted comprehensive end-to-end testing, designing unit and integration tests for each new Python module.
• Categorized scripts based on criticality and functionality, enhancing efficiency.
• Assisted in training an AI-based tool to enhance error handling suggestions.

Environment: Python 11.1, Perl, Sybase 15.x, TSQL, Unix, DB2, Excel, Autosys, jira, GIT, co-pilot

• Lead the development, testing, and maintenance of Prime Brokerage reporting applications used by end clients.
• Led infrastructure team in planning, architecting, and developing reports.
• Used Perl modules, Sybase, and DB2 database stored procedures to develop and maintain reports, and created Autosys jobs for their scheduled delivery to end clients.
• Developed ticketing system on Morgan Stanley PB Infrastructure platform using Jira, Rally and ServiceNow.
• Enhanced perl scripts with perl 5.21, shell and autosys jobs to upkeep server health.
• Provided continuous level 3 production support, collaborating with the infrastructure team.

Environment: Sybase 15.x, TSQL, Python, Perl, Unix, DB2, Excel, Autosys, jira, GIT

• Used Perl extensively to build the Risk Data Warehouse and store the risk feeds.
• Used UNIX and shell scripting extensively to enhance the PERL scripts, and develop Control M jobs to schedule the PERL and shell scripts.
• Used XML stylesheet documents to filter and convert the incoming XML feeds and XSD schemas to validate them.
• Established Oracle connection from PERL scripts using DBI/DBD module for data acquisition from XML feeds.
• Wrote extensive queries in Oracle to extract specific data from the XML feeds.
• Developed tables, packages, and stored procedures in Oracle for data warehouse creation and risk data storage.
• Documented the entire data flow from each of the GALAXY modules to the Risk Data Warehouse.
  Environment: Perl, Oracle, Unix, MS Excel.
  
  
  

• Developed automation framework using PERL for validating source data quality.
• Used UNIX and shell scripting extensively to enhance the PERL scripts, and develop Autosys jobs to schedule the checks periodically. These checks are incorporated before the ETL jobs are triggered through Informatica.
• Used the DBI/DBD module for DB2 connection from Perl scripts to fire queries against the reference data tables, and generate them in the form of a report in MS Excel.
• I wrote extensive queries in DB2 to validate data against the reference data tables for verifying the field-level business logic and whether the data has been populated correctly in them.
  
  
  Environment: Perl, Unix, DB2, MS Excel.

• Extensively used Sybase (T-SQL) 15.x for creating, modifying, and maintaining the stored procedures for processing the business logic for the different system modules, and modifying them according to customer needs and expectations.
• Maintaining the backend with Sybase 15.x, I was involved in extensively tuning the performance of the stored procedures and queries in Sybase.
• Resolved the back-end production issues in stored procedures on a real-time, day-to-day basis.
• Engaged in comprehensive user meetings to apprehend needs and expectations.
• Worked extensively on third-party Borland StarTeam for version control.

Environment: TSQL, Sybase 15.x, Rapid SQL 7.5.1, Borland Star Team.

• Created front-end PERL scripts with HTML for e-statements, text statements, and regular exporters.
• Used PERL file-handling and regular expressions extensively to parse extremely sensitive bank account information of the customers to generate e-statements.
• Developed PERL scripts with HTML to add new overdraft sections to the bank statements to make them Regulation DD (UDAP) compliant.
• Communicated directly with end users, banks, and product implementation engineers on statement exporter format.
• Employed DBI/DBD module for Sybase integration from PERL scripts to manage trading information data into the database.
• Recorded all data transfers for change requests from external financial institutions to address issues in real time.

Environment: PERL, DBI/DBD, TSQL, Crontab, HP UNIX, KornShell.

• Created PERL scripts with SQL*LOADER to load ADP, ESS, and Imagine systems data into reconciliation tables in an Oracle database.
• Created numerous PERL scripts to dynamically generate table-driven reports from Oracle tables.
• Utilized Spreadsheet module in PERL for generating detailed integrity reports.
• Developed multiple stored procedures and views in Oracle.
• Performed backend maintenance using Oracle.
• Developed front-end GUI screens using VB.NET.
• Used Crontab for scheduling of reports.
• Documented the entire data flow from the external systems into the reconciliation system.
• Participated in extensive user meetings.

Environment
PERL, DBI/DBD, PL-SQL, Oracle 8i, Component One Reports, VB.NET, Crontab, SQL*LOADER, Apache, Windows 2k, HP UNIX.

• Maintained backend systems in Noah using Sybase.
• Created tables and developed stored procedures on Sybase and Oracle.
• Designed stored procedures in Sybase and Oracle for generating MS Excel reports.
• Involved in tuning the performance of the stored procedures and queries.
• Provided extensive support to existing applications.
• Resolved production issues by identifying and implementing bug fixes.
• Designed numerous PERL scripts using extensive JavaScript for Message Parser and Message Converter.
• Engaged in comprehensive QA testing.
• Managed trade reconciliations by running Autosys web method jobs.

Environment
TSQL, Oracle 9i/10g, PERL, DBI/DBD, JavaScript, AUTOSYS, Sybase 11.x/12.x, BCP, Html, Apache, Windows 2k, HP UNIX.