Summary
Overview
Work History
Education
Skills
External Certifications
Timeline
Generic

Ranjith Krishnamoorthy

Oakville,ON

Summary

  • Over 17 years of IT experience in the Banking and Insurance industries, embarked on diverse roles and responsibilities ranging from Sr. Technology Architect, Technical Project Manager, Techno-Functional Consultant, Technical Lead, Sr. Developer, and System Analyst. Proven ability to develop and manage win-win partnerships with Customers to deliver the best results and business value. Extremely strong at building solid and cross-organizational relationships and credibility amongst IT and business stakeholders. Worked on multiple RFI/POV/RFPs for large customers in the Insurance and Banking domains and helped architect technical solutions for various IT/business problems. Extensive experience in software development using Oracle SQL/PLSQL and Pro
  • C with excellent Analytical and Problem-Solving skills. Strong knowledge in debugging Stored Procedures, Functions, and Packages and solid experience in writing complex SQL queries and PLSQL code using Oracle's advanced features and concepts. Solid experience in identifying performance issues, debugging, and performance tuning in large Oracle Databases using SQL Trace, explain plan, Indexing, AWR, ADDM, tkprof, Auto trace, Hints, and partitioning of tables. Good understanding of Oracle Database features such as Golden date replication, Oracle Streams, DB physical structures/components, RAC, Storage Allocation, DB roles/privileges, and DB backup and recovery mechanisms. Experience in creating complex Python/Unix scripts for data processing and scheduling the batch jobs using the crontab/Autosys/stone branch schedulers. Good knowledge of data collection, analysis, and management. Works well under pressure and consistently meets deadlines and targets while delivering high-quality work. Familiar with Data Warehousing concepts and Experience in ETL using Oracle external tables, SQL Loader, and export/import for data loading. Experience in creating High- and Low-Level design documents, Test Plan Preparations, Unit Testing and documentation, Data Flow Diagrams, and Process Flows. Worked in development projects as a technical lead/architect and as an individual contributor (Sr. developer) and specialized in the payments domain (Banking) and Group Benefits (Insurance). Familiar with all the critical areas of Maintenance such as Incident Management, Problem Management, Adaptive Maintenance, Preventative Maintenance, Perfective Maintenance, Corrective Maintenance, Change Management, and work product review. Excellent troubleshooting, debugging, and error-trapping skills. AWS Certified solution architect with good knowledge of AWS cloud services such as Amazon – EC2, RDS, S3, CloudFront, VPC, SNS, Beanstalk, Autoscaling, CloudWatch, ElastiCache, and AWS Lambda. Highly skilled and shown eminence in all phases of a Software Lifecycle – Requirement Analysis, Documentation, Design, Build, and Testing; Certified Scrum Master with Good understanding of Scrum and SAFe agile frameworks. In addition to the technical expertise, worked as a Techno functional Consultant in Commercial Banking practice.

Overview

17
17
years of professional experience

Work History

Senior Technology Architect/Manager (LOB Lead)

Cognizant Technology Solutions
07.2023 - Current
  • Responsible for the end-to-end technical delivery of a Managed Services engagement for the Customer's Group Protection Line of business
  • Guides the team on technical challenges, manages technical delivery, and acts as an escalation point for delivery and operational issues
  • Formulates action plans to analyze and resolve recurring problems, provide fault isolation, and guide the team to perform root cause analysis for highly complex technical issues
  • With a more extended stint with Lincoln Account, I got to understand and develop/enhance complex modules related to critical business processes such as monthly billing, ACH premium processing, commissions, financial & YE tax processing, and reporting (customer correspondence)
  • Act as an SME for Customer's Group Policy Maintenance system and work closely with business & IT stakeholders to improve customer experience and to ensure the proper functioning of related business processes
  • Performs architecture design review; Identifies opportunities for optimization of cost/time/asset utilization in complex projects and advises relevant teams accordingly wherever needed
  • Collaborate with the application architects, solution architects, customer end IT architecture teams, and infrastructure groups to enhance the existing application/data architecture, focusing on application rationalization & resource optimization
  • Liaise with Cognizant management and review solution proposals to determine goals, time frame, funding limitations, procedures for accomplishing solutions, staffing requirements, and allotment of resources
  • Identifies strategic growth opportunities within client engagement areas and collaborates with the cognizant consulting/sales team to expand the services
  • Research, analyze, and develop legacy platform modernization strategies to present them to customers and maintain win-win partnerships
  • Prepares POV/RFP responses, works with the Product consultants and Account leadership, and contributes to identifying opportunities related to the Portfolio or adjacent to the current scope of work.

Project Lead

Cognizant Technology Solutions
01.2015 - 07.2017
  • Collaborate with business partners/analysts/client SMEs to define/refine requirements and translate technical specifications
  • Worked as a Project Technical Lead/Senior PLSQL developer in this OSP owned project and was responsible for developing code, creating design documents, unit testing of the code artifacts, providing support for the User Acceptance testing, packaging the code artifacts for deployment, and resolving the issues raised in JIRA for production issues
  • Guide an offshore team of 6 members on their daily work assignment, technical design understanding, development, and testing
  • Drive status meetings with client managers and handle escalations
  • Identify risks and issues in the project and devise risk prevention, corrective, and mitigation strategies
  • Monitor and track projects to ensure adherence to budget/schedule/time
  • Manage delivery and act as an escalation point for delivery at offshore and operational issues
  • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of complex modules
  • Along with technical delivery, played the role of ESA PM and was responsible for planning, budget management, billing, invoicing, maintaining project health, audits, (PMR) Project management Reviews, CSI (Continual Service Improvement), innovation, automation, adherence to quality standards, project
  • In addition to project deliverables, I acted as a POC for 4 Insurance accounts from OSP practice perspective.

Technical Lead

Infosys Limited
03.2012 - 12.2014
  • Involved in project estimations, planning, creation of detailed project plan, execution, stakeholder management, and end-to-end delivery for developing wrapper components around RBS bank's back-office system named MTS (ACI Money Transfer System)
  • In addition to technical deliverables, as a project technical lead, guided the team to provide complete lifecycle support to customers from initial interaction with Business analysts through design, coding, testing, debugging, implementation, and integration
  • Created High-Level design of the existing application functionality and proposed design changes for the application enhancements
  • Along with writing complex PLSQL procedures and C programs, I was the internal performance DBA for the project
  • Review deployment plans/runbooks and guide the team on complex technical challenges and support the development and software quality assurance to ensure faultless delivery
  • Played the role of SME for financial industry products named Incentage Middleware Suite (IMS) and Incentage Rules Studio (IRS) and delivered multiple time-sensitive changes
  • Formulated action plans to analyze and resolve recurring problems, provide fault isolation, and guide the team to perform root cause analysis for highly complex technical issues, review impact analysis done by a team, prioritize problems and ensure SLA (Service Level Agreement) adherence, work with other groups including vendors to find a complete and long-term solution
  • I was part of the commercial banking practice group and was involved in RFPs and other initiatives related to Infosys’s top banking customers.

Lead Developer

Infosys Limited
10.2010 - 02.2012
  • Technical Lead of an offshore team for the design and development of new modules and new versions of existing ones written in Oracle PLSQL, C, and Java
  • Played a vital role in Requirement analysis & gathering, Capacity planning, Estimation, Client Approvals, Design, Reviews, Testing, and development for enhancements & bug fixes
  • Carried out defect analysis and fixed bugs raised by the QAs
  • Responsible for identifying pain areas and proposing new optimized solutions by developing and modifying PL/SQL packages, procedures, and Functions and using Oracle's advanced features such as collections
  • Played the role of SME for two of the critical and strategic applications named TRIP (Transaction Related Information Provision) and GHCI (Global Hub Clearing Interface)
  • Played the role of internal performance DBA for the project and helped the team develop and deliver optimized PLSQL code and SQLs
  • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of critical modules
  • As a value add to customer, made a notable contribution to PPM (Proactive problem Management) and WPR (Work product Review).

Senior Developer/Application SME at Client Site

Infosys Limited
01.2009 - 09.2010
  • Responsible for providing full life cycle support to applications for handling international payments
  • Perform data analysis using advanced oracle technology features and report discrepancies to stakeholders
  • Participate in required business requirements and functional requirements gathering, which involves a review of existing systems configurations and operating methodologies as well as understanding evolving business needs
  • Deliver enhancements and time-sensitive defect fixes based on the business requirement
  • Provide support for business and functional acceptance testing which involves ensuring technical specifications considering business requirements
  • Had the opportunity to work in the client site: RBS Development center, Amsterdam-Netherlands and contributed to the end-to-end ABN-RBS Bank separation called CB & P [Core Banking & Payments (Wonder-wall Release)] which is one of the Milestone for RBS in acquiring ABN AMRO
  • More Familiarized with Banking Fundamentals, Terminologies, and various Systems/Flow of Payments/IDDs
  • Analyze issues, suggest / implement workaround, communicate to all the stakeholders and close issues as per the agreed SLAs
  • Participated in estimating the effort needed to implement the changes and fixes.

PLSQL Developer

Infosys Limited
01.2007 - 01.2009
  • Developed Unix shell scripts based on the requirements and for application automated monitoring
  • Performed enhancement of various PL/SQL stored procedures, Functions, Packages, Triggers and DB objects
  • In addition to PLSQL enhancements/defect fixes, worked on enhancement requests on Java-based applications and complex Mid-Office applications developed in C programming
  • Provided support for business and functional acceptance testing, which involves ensuring technical specifications considering business requirements
  • Worked on incident management, problem management, change management processes and work product reviews
  • Involved in analysis (Business and technical) of the existing system to improve & optimize the system performance
  • Involved in the analysis and solving of several Production issues
  • Scaled up as the SME for GHCI (Global Hub Clearing Interface), which is one of the critical applications in the bank's mid-office platform
  • Worked closely with Oracle DBAs and got good exposure to Oracle DB Performance tuning.

Education

B. Tech - Information Technology

Anna University
05.2006

Skills

  • Oracle DB related Technologies and related expertise
  • Oracle DB performance tuning, Data modeling, Oracle SQL, PL/SQL, and Oracle Forms
  • Languages
  • C, Pro
  • C, Oracle PL/SQL, Python, and Java
  • Web Server
  • Oracle web logic server (11G & 12C)
  • Database
  • Oracle (10G, 11G and 12C)
  • Cloud Technologies
  • AWS Cloud Services
  • Operating System
  • Windows, Unix, and Linux
  • Tools/Utilities
  • Informatica Power center, TOAD, SQL Developer, SQL
  • Loader, FTP, SFTP and Connect Direct
  • Scheduling Tool
  • AutoSys and Stone branch
  • Version Control System
  • Clear Case, SVN and GitLab
  • Products
  • Incentage Middleware Suite (IMS), Incentage Rules Studio (IRS), Fineos and BRM-Docsnet
  • C, PRO C, Oracle PL/SQL and core Java
  • Windows, Unix and Linux
  • Incentage Middleware Suite and Incentage Rules Studio

External Certifications

  • 1Z0-047 : Oracle Database SQL Expert
  • 1Z0-147 : Oracle PL/SQL Developer Certified Associate (OCA)
  • 1Z0-146 : Oracle Advanced PL/SQL Developer Certified Professional (OCP)
  • ITIL V3 Foundation Certified
  • Certified Agile Scrum Master (ASM)
  • SAFe Certified Advanced Scrum Master (SASM 6.0)
  • CLF-C01 : AWS Certified Cloud Practitioner
  • SAA-C02 : AWS Certified Solution Architect Associate
  • DVA-C02 : AWS Certified Developer Associate
  • Got hands-on training from Incentage-AG on Incentage Middleware suite (IMS)/Incentage Rules studio (IRS) and acquired 8 credit points (certification) post assessment.
  • Trained by Stone branch vendor on the Stone branch UAC - basic & advanced features for developers.

Timeline

Senior Technology Architect/Manager (LOB Lead)

Cognizant Technology Solutions
07.2023 - Current

Project Lead

Cognizant Technology Solutions
01.2015 - 07.2017

Technical Lead

Infosys Limited
03.2012 - 12.2014

Lead Developer

Infosys Limited
10.2010 - 02.2012

Senior Developer/Application SME at Client Site

Infosys Limited
01.2009 - 09.2010

PLSQL Developer

Infosys Limited
01.2007 - 01.2009

B. Tech - Information Technology

Anna University

Similar Profiles

CREATE PROFILE
Ranjith Krishnamoorthy