Ramakrishnan Pandi
Chicago,IL
Summary
Manager with 17+ Years of IT experience. Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review and enhancements.
https://www.linkedin.com/in/ramakrishnan-pandi-4b09ba55
Overview
19
19
years of professional experience
1
1
Certification
Work History
Manager Application Engineering
Discover Financial Services
07.2023 - Current
- Hire, retain and lead high-functioning, diverse group of engineering professionals,
establishing clear objectives and key results, developing consistent set of practices
and process across the team and driving towards resolution of challenging problems. - This includes all performance management aspects of leading the engineers including
acquiring and providing 360 feedback and administering reviews. - Manages software ownership and development from initial concept through continuous improvement.
Mentor staff of engineers in both technical and soft skills to craft a team of highly technically competent,
consistent, thoughtful and customer-centric technology experts. - This includes ensuring the group is adhering to principles of engineering excellence within their technical domain, applying consistency of technical execution, sharing common practices and challenges within the team and fostering a culture of excellence a
nd continuous learning within the team. - Lead and shape the technical vision within their domain and be an essential member of leadership team including acting as a leader in the Discover engineering community affecting and advancing the architecture across the company and ensuring adherence to all regulatory, compliance and audit requirements. This includes defining how technical work should be done, selecting appropriate tools, defining technology, quality, experience and implementation standards and practices within own technical domain.
- Work with key stakeholders to efficiently and effectively allocate team members to product teams to meet business and Product area objectives.
Engage with internal and external communities of practice to share experiences, contribute knowledge, learn and advocate for the Discover Technology brand. Promotes team innovation and collaboration of ideas across teams. - Contribute as an engineer within a product team designing, developing and maintaining quality technology solutions for a product or set of products including developing own subject matter expertise.
Associate Manager
Virtusa Corporation
11.2022 - 07.2023
- Develop and implement REST standard APIs as per IFX and BIAN Guidelines.
- Modernization of APIs in legacy as per industry standard
- Design architecture to leverage AWS API gateway and lambda as interface layer between REST API and core banking system.
- Identifying list of APIs for conversion into REST standard. Testing APIs in SOAP environment and understanding current functionalities for various business scenarios.
- Prepare business message specification document with changes needed in API objects based on guidelines provided by IFX-Interactive Financial Exchange
- Preparing REST API payload mapping document, Swaggers and endpoints based on IFX and BIAN standards.
- Discuss with business team and technical team about changes needed for standardization
- Create user stories in JIRA for API development and tracking delivery.
Technology Lead
EdgeVerve Systems, Infosys Technology Limited
01.2007 - 10.2022
- Implementation of Finacle core banking application to support servicing requirements for student loans
- Current system study and working with stakeholders for requirement gathering and analysis Translating business requirements into Functional requirements and creating RTM document and User stories
- Preparing solution document to meet functional requirements and impact analysis
- Preparing and develop solution to support servicing of all features of Student loan product like Loan origination, disbursement, scheduling payments, payment apportioning, billing statements, collection programs and recovery after charge-off.
- Developing batches to generating Disclosure letter as per Truth in lending act (TILA) and designed batch for APR calculation with actuarial method as per Reg-Z requirements.
- Solution design for generating 1099C and 1098E regulatory reporting as per IRS guidelines.
- API design for Loan account general inquiry, payment and overdue inquiry, billing history inquiry.
- Requirement gathering and solution for Interest calculation, Fee assessments, payment apportioning, backdating adjustments for value dated transactions, types of bill amount calculation, due date calculation and delinquency calculation.
- Requirement gathering and solution for repayment amount calculation and Amortization during in school/grace period and repayment period
- Requirement gathering and solution for loan interest capitalization and re-amortization during events like loan tenor/rate changes, deferment or forbearance
- Requirement gathering and solution for regulatory compliance requirements like TILA, SCRA, FDCPA and Bankruptcy Act.
- Preparing chart of accounts for financial transactions during events like Loan funding/disbursement, Fee assessment and capitalization, Interest booking and capitalization, Loan payments, Interest and fee adjustments, waiver, refund, loan charge off, NPA classification, Loan recovery after charge-off, loan write off, payoff and settlement.
- Preparing chart of accounts for financial transactions during correction events like Disbursement reversal/cancellation, Fee reversal, Interest reversal, capitalization reversal, Loan payment reversal, charge off/write off/pay off reversal.
- Requirement gathering and solution FAS91 amortization of Origination Fee and Cost and OID accretion for tax reporting.
- Analyzing daily GL reports and finding any mismatches/account out of balance issues and resolving those issues.
- Working on Change in requirements (CRs) post implementation and providing solution approach and design to address change.
- Effort estimation for new CRs, prioritizing based on complexity/impact and deriving delivery timelines
- Preparing test case document for unit testing and validating test results.
- Incident management through online incident management portal and providing clarification/fixes within SLA.
- Review of Detailed design documents and review of code written by team members and providing valuable comments.
- Discussing with technical team in Legacy system and understand tables and fields for migrating legacy data into Finacle core banking Database.
- Identification of fields, which are required as per new system requirements and preparation of migration strategy document.
- Created stored procedures and Functions to calculate/derive relevant fields for migration.
- Developed complex queries by joining multiple tables and view to derive data for customer/account level inquiries as per business requirements.
- Preparing test cases to perform testing in migrated DB and execution of test cases.
- Analysis of defect raised in migration environment and providing data fixes wherever applicable.
- Creating PL SQL packages and procedures for generating financial reports and data extracts as per business requirements.
- Developing batch jobs using PL/SQL programming. Creating stored procedures and functions using cursors and collections
- Developed batch jobs for loan payments, extracts, disbursements, Letters, GL transactions, charge off, bankruptcy, recovery and collections.
- Created sql functions to calculate and populate fields required in Loan account inquiry APIs and for generating letters.
- Incident management through online incident management portal and providing clarification/fixes within SLA.
- Installation of Finacle core banking application to create migration environment.
- Preparation for HLD and DLD document for migration activity and Effort estimation for PL/SQL procedures.
- Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
- Extensively worked with collections to reduce overhead and improve performance using bulk collect and bulk bind.
- Experienced with DBA activities like granting and revoking privileges on database objects, creating synonyms and database links.
- Worked with Explicit Cursors, Inline cursors and REF Cursors and performed data manipulations.
- Worked on user defined exceptions, WITH clause, pipelined functions, Analytic functions and retrieval of bulk data from collections using table () function.
- Experience in creating shell scripting for automation and analysis of debug logs.
- Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS_SQL.
- Expertise on writing UNIX shelling scripting to develop batches and analyzing debug logs.
- Proficient in using many UNIX commands and utilities.
- Implementing SWIFT message processing system for processing MT103 and MT202 swift messages.
- Creating cron jobs for automated transfer of swift messages, files, logs from swift system to Finacle core banking server.
- Developed batch process to read, validate and upload messages and create necessary transactions to customer accounts and Nostro/Vostro accounts.
- Played role of SPOC to contact in case of any issues when using Finacle application.
- Worked on writing UNIX shelling scripting to develop batches and analyzing debug logs.
Graduate Engineer Trainee
Sterlite Industries India Limited
10.2005 - 01.2007
- As maintenance engineer, Ensuring 100% equipment availability and maintenance support for trouble free production.
- Preparing 3D equipment modelling in AUTOCAD/Pro E applications.
- Lead and supervise team of maintenance technicians and contractors.
- Preventive maintenance Planning for yearly, monthly shutdowns and Breakdowns.
- Corrective maintenance and root cause analysis during Breakdowns.
- 5S and TPM involvement.
- Ensure maintenance and repair procedures and packages exist to control this work.
- Spare parts ordering and inventory management in SAP
- Preparation of checks like Job Safety Analysis etc.
Education
Bachelor of Engineering -
Madurai Kamarajar University
Tamil Nadu, India.04.2004
Skills
- Requirement Gathering and Analysis, translating the business requirements to User Stories
- Expert knowledge in functionalities of Student lending, Personal lending and Line of Credit products
- AWS Certified solutions architect – Associate
- Expert knowledge in core Banking and Financial Domain
- Knowledge in US regulatory requirements in Lending domain
- Create and execute queries focused on extracting and evaluating data
- PL/SQL programming for developing custom batches and reports
- Programming skills in C and Unix commands and shell scripting
- Business system Documentation, work-flow analysis, preparing RTM, HLD and DLD documents
- Project management tools like Rally, Jira
- Data analysis, data mapping and migration
- API Field Mapping and testing using Soap UI, REST Assured
- Continuous Integration and Continuous deployment (CI/CD) using GitHub
- Design specification, test plans and User Acceptance Testing
- Problem solving, Agile Methodology & SCRUM
Certification
AWS Certified Solutions Architect - Associate
Technology
Languages: Oracle PL/SQL, C/C++, Unix Shell scripting, Java script and Finacle scripting.
Databases: Oracle and Snowflake
Operating Systems: Windows and Linux.
Tools: SQL Developer, TOAD, WinSCP, SOAP UI, Postman, SecureCRT, Git, IntelliJ, Microsoft Visio, Excel, Putty, Rally and JIRA.
Timeline
Manager Application Engineering
Discover Financial Services
07.2023 - Current
Associate Manager
Virtusa Corporation
11.2022 - 07.2023
Technology Lead
EdgeVerve Systems, Infosys Technology Limited
01.2007 - 10.2022
Graduate Engineer Trainee
Sterlite Industries India Limited
10.2005 - 01.2007
Bachelor of Engineering -
Madurai Kamarajar University
Similar Profiles
Latasha PalmerLatasha Palmer
Home Loans Document Specialist at Discover Bank/Discover Financial ServicesHome Loans Document Specialist at Discover Bank/Discover Financial Services
Justin SicienskiJustin Sicienski
Principal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial ServicesPrincipal Product Manager (Commercial Payments) at Discover Global Network - Discover Financial Services
Camille HolmesCamille Holmes
Quality Control Specialist at Discover Financial Services, DFSQuality Control Specialist at Discover Financial Services, DFS
HAZZEL MARTINEZHAZZEL MARTINEZ
Senior Operation Strategy Analyst at Discover Financial ServicesSenior Operation Strategy Analyst at Discover Financial Services
Tsvetelin PenevTsvetelin Penev
Back Server at The Peninsula HotelBack Server at The Peninsula Hotel