Krishnendu SinghDeo

Deutsche Bank

(Project: U.S. Regulatory Reporting)

• Liaising in the end-to-end SDLC. (Requirement Gathering, Planning, Development, SIT/UAT, Release Management.)
• Part of the Axiom CV10 migration team on groups, roles, sign-off, and permissions-related setup activity.
• Worked on Axiom Components like Data Source, Data Models, Aggregation, Portfolios etc.
• Experience in creating Project Hierarchy, Projects and Branches with Project Dependencies in Axiom CV.
• Provide technical analysis and solutions on any production issues for BRR reports (FRY-9C, FFIEC-041, FFIEC-002, FRY-9LP, FR-2590, FRY-11), CCAR reports (FRY 14M/Q/A and related schedules), and TIC reports for US Regulatory Reporting from BD1 to BD15 label processing until report submission.
• Worked with business users to resolve edit checks, variance, drill-down reports, and fix failed edit checks.
• Assisted end users in the submission of XML files to FED through the Axiom tool.
• Extensive experience in managing production processes from planning to completion, ensuring quality standards and production goals are consistently met.Recognized for effectively overseeing resource allocation and production schedules, and implementing strategic cost-saving initiatives that optimize efficiency.Skilled in analyzing production data to drive continuous improvement and enhance operational performance.
• Developer L3 support on a micro-service based architecture project for US regulatory reporting data close process, which covers data ingestion, processing, publishing, validation, exception, adjustment, and attestation processes.
• Worked extensively with geographically distributed and culturally diverse teams, involving interaction with clients and other team member.

Deutsche Bank

(Project: U.S. Regulatory Reporting)

• Working exposure from an enhanced and regulatory changes perspective in various schedules and sub-schedules of BRR reports like FFIEC-041, FFIEC-002, and FFIEC-2590, etc.
• Aggregation and portfolio component creation and modification to obtain results with respect to each submission, MDRM, and each line item to summarize into the final report. And automation through creating workflows.
• Created favorites for users to quickly focus on the main components in the dashboard.
• Assisting with pre-production rehearsal, release preparation and instruction, post-production check, and validation of code repository/documents.
• Establishing and upholding a unit testing document for each change and submitting it to Agile Central and a shared location for auditing purposes.
• To work closely with the project team to prioritize bug fixes based on the number and/or severity of defects.
• Developed SQL script to check DataSource dependencies on any other component that is not available at Axiom front end.
• Created a script to generate statistics on the execution time taken for any schedule and reports.
• Developed Unix scripts to SFTP files from other business environments to the local Axiom environment server.
• Participated in sprint reviews, defect triage, and daily scrum meetings to touch base with the whole team and ensure that all members were performing satisfactorily. Participated in QBR planning.

Citigroup

(Project: Citi Risk Credit Analysis Tool)

• Leading the project from all development aspects to stay on track and deliver the output as per expectations.
• Interacting with business users for requirement understanding, issues, and solution discussion.
• Involved in functional/technical specifications, design documents, estimation, coding, code review, test plans, and actively involved in DEV, SIT, UAT, integration, and regression testing.
• Identifying risks proactively, and proposing solutions to resolve them.
• Enhancement of existing database objects to modify the logic as per business requirements.
• Provide technical analysis and solutions to any production issues, and track to closure using a defect management tool by providing technical direction for better performance and stability.
• Mentoring and guiding the team for the end-to-end implementation cycle.
• Conducting training for the Internal Auditing team and business users on CCAR reports and the process we follow.
• SIT/UAT handling, code migration to different environments, and regular CCAR report verification.
• Automation of report generation via the Autosys scheduler and monitoring of batch jobs.

Manulife

(Project: Client Administration System)

• Involved in preparing functional and technical design documents to generate new business, going through all CAS modules, and providing a demonstration to stakeholders and business users of Manulife to migrate the front end in Java technology, along with Oracle as the backend.
• Interacting with business users and architects for requirement understanding for all CAS modules.
• Ceaselessly improving the code quality and performance improvements.

Credit Suisse

(Project: Personal Account Trade)

• Involved in the design, development, coding, and implementation of new business changes for an existing PA Trade application.
• Involved in development effort estimation, high-level and low-level design diagrams.
• Interacting with business users for requirement understanding, SIT/UAT verification, production deployment, and regularly verifying production reports.
• Oracle Database design and development of various database objects as per TDN (Technical Design Note).
• Tuning the existing SQL queries using Oracle Indexes, hints, and table partitioning to reduce the response time, which takes a longer time to process any request in the production environment.
• Proper unit, integration, and system testing have been done before deploying those scripts in production.
• Providing support and fixing defects found during QA, UAT, and PROD.
• Automatic creation of client profiles in the bank's system.
• Preparing test specifications and test data.
• Perform unit testing of components and prepare test logs.

Central Coalfields Limited

(Project: Online Integrated Coalnet System)

• Involved in the implementation of the Coal Net software, along with a team.
• This includes first deploying the Coal Net software in the Oracle9i Application Server, second interacting with clients to understand their data, asking for the data in the format required by Coal Net, verifying that data, formatting the data, and then loading it into our database.
• Third is writing packages, procedures, functions, triggers (SQL, PL/SQL), etc.
• To customize the software and satisfy business needs.
• Part of the payroll system development team, which will produce salaries for about 3,000 employees.
• This includes understanding the whole process of salary computation rules followed in Coal India, and incorporating them into our system.
• Also, this includes developing the tax functionalities.
• Developed Oracle Report for the user interface (Attendance, Salary-Related Checklist & Check Sheet, Pay Slip, Classification (PF), Monthly Tax, Professional Tax, Recurring, LIC, etc.). In the Payroll Management System.
• Enhancement of different reports and modification in business logic, such as promotion, transfer, transfer with a promotion within and between subsidiaries, unit transfer, basic change, and VDA rules, related changes, employee grade, designation, and department-oriented reports for the Personal Information System.
• Data loading in the production database using SQL Loader.

Maharaj Microtech Private Ltd.

• Involved in application development, creating different types of stored procedures (applying business logic), functions, etc. using PL/SQL Developer.
• Design, modify, and update database tables, setting up indexes, data constraints, database views, and referential integrity.
• Loaded master table data using SQL Loader.
• Providing support and fixing defects found during QA, UAT, and PROD.
• Reading nightly feeds from the FTP source and translating the feeds into customer information, including their preferences.
• Database Server Monitoring.

NDTV Convergence

• Created SQL scripts and loaded Top Stories data for the web using SQL Loader whenever required.
• News, sports, and other data files are transferred from one server to another using the SFTP tool and uploaded to the web portal from the front end.
• Unix Server Monitoring.
• Encode NDTV news like Top Stories, Sports, Entertainment, etc. For the NDTV websites.