Pradeep Sethu Ramamoorthy

Email : ac8cd6@r.postjobfree.com Mobile : +1 - 248-***-****

EXPERIENCE SUMMARY:

Duration

Organization

Role

Period of experience

Feb 2011 - present

Cognizant Technology Solutions

Senior Software Analyst

7 Years 11 Months

Over 7 and half years of .Net Development / Enhancement / Testing and Maintenance experience in Banking and Financial Services domain.

Microsoft Certified Professional (MCP) in SQL Server 2008.

Expert in developing windows application, web application and windows services in Microsoft Visual Studio .Net IDE using C#, ASP.net, MVC, Entity Framework and SQL Server.

Ability to understand and transform complex business requirements into software, ensuring applications are delivered on time, to specification, are scalable, performance optimized and maintainable.

Facilitate meetings with business clients, interacting with the stake holders and client technical team to understand and articulate their business needs.

Strong understanding of the below banking business domain processes,

oException and Incoming Returns processing using TRIPS

oCheck fraud analysis processing using Sereno

oCash Vault Order and Deposit Processing – Brinks

oLockbox Processing

oDocument image processing

oSecurity applications

Extensive working knowledge of all phases of SDLC in Onsite - Offshore delivery model.

TECHNICAL EXPERTISE:

Programming Language

C#

Asp.Net

MVC

Entity Framework

ADO.Net

VB.Net

VBA

VB6

.Net programming in SharePoint

Database

SQL Server

MS Access

Pervasive

SSIS

Scripting Languages

VB Script

Java Script

Reporting Tool

Crystal Reports

SSRS

Version Control

Harvest

VSS

Ticketing Tool

Service Desk

Service Now

Operating System

Windows Server 2008, 2012, 2016

Windows XP, Vista, 7, 10

PROFESSIONAL EXPERTISE:

Assignment 1: Website for error invoice correction

Role: Lead Developer

The main objective of this project is to create web application for correction of invoices by the account payable department. The correction will include web form validation based on the business logic. At the background the project will also include loading the error invoice feed from mainframe system into SQL database and send the corrected invoice back to mainframe.

Responsibilities:

Primary responsibilities involve analysis of the requirement, Building technical design document, Development of involved components, Unit Testing and Implementation.

Developed web application using ASP.Net with separation of business, data and presentation layer.

Website will include different web pages for correcting the error invoice, adding new vendor details to the backend, admin pages, adding/deleting new invoice or distributions etc.

Designing the SQL database with tables with constraints, triggers, stored procedure, data archiving and implementing indexing for better performance.

Creating and deploying the scripts for backend load of input feeds from mainframe into the database and upload the corrected invoice data back to the mainframe. This includes data check before uploading/downloading.

Imparted functional knowledge to the testing teams.

Created User Operation Manual and provided demo to the Business users for operating the system.

Assignment 2: ARMOR – Automated recovery tool and website for monitoring dashboard

Role: Lead Developer

The main objective of this project is to automatically recover failed services, process on a production environment. It will monitor set of events, services, process, files and CPU/Disk utilization on the server for any failure. Based on the rules defined, ARMOR agent will act by automatically recovering its corresponding process or notify the team via email. Creating web application that will showcase real time refreshing dashboard for showcasing the failed events and generating SSRS reports.

Responsibilities:

Primary responsibilities involved Analysis of the requirement, Building technical design document, Development of involved components, Unit Testing and Implementation.

End to end development of ARMOR agent, ARMOR windows service, database design and development.

Developed website for dashboard using ASP.Net for viewing the various failure and recovery done by ARMOR utility on timely basis.

Designing the XML for creating the rules for monitoring and auto-recovery.

Imparted functional knowledge to the testing teams.

Implementing the utility in the various servers and environments.

Assignment 3: Signature extraction from Pervasive database for the TRIPS daily Operations processing.

Role: Lead Developer

The primary objective of this project is to extract the signature and send it to TRIPS.

Responsibilities:

Understanding the requirements.

Developed VB script to extract the signature from Pervasive signature file database using the account numbers and send the output raw file to Trips server.

Unit testing the application.

Deployment in production and post maintenance.

Assignment 4: Optimizing the status update in SharePoint list

Role: Developer

The primary objective of this project is to optimize the time taken by the windows service to update the record status in SharePoint list

Responsibilities:

Gathering the client’s business requirement/problems, analyse and identifying the solution.

Investigating and analysing the time lagging occurring to update 10000+ records for 17 hours

Modified the .Net windows service code to involve different approach to update the records by using SharePoint in-build web service update method rather than using the traditional COM update method.

Performing unit testing and regression testing.

Implemented the modified code into production and optimized the time from 17 hours to less than an hour.

Assignment 5: Converting pervasive account database file into flat file.

Role: Developer

The primary objective of this project is to create a VB script to convert the signature account database file into text files

Responsibilities:

Understanding the requirements and creating the Technical design document.

Developed VB script to FTP the database file from the source server, perform the extraction of account details using Btrieve utility into flat files and FTP the extracted file to the destination server

Involved in Unit testing of the application.

Deploying the solution in production.

Assignment 6: Archive and purging of SharePoint list

Role: Developer

The primary objective of this project is to build windows service using .Net to enable archiving the older data in a SharePoint list into another list and delete the archive data in the current list

Responsibilities:

Understanding the requirements and creating the Technical design document.

Developed windows service that will archive the records to new SharePoint list and delete the older data using batch delete function in the .Net SharePoint library

Involved in Unit testing the application.

Deployment of the application in production environment.

Assignment 7: Lockbox Development

Role: Lead Developer

The primary objective is to develop program that will help in creating automated solution for processing of wholesale and wholetail lockboxes for new customers.

Responsibilities:

Requirement gathering from clients.

Develop the new lockbox program using C# for any new customers.

Fetch the data from database, tailoring the data based on the business rules, generating output file and sending it to the downstream application.

Creating the transmission script to securely transmit the output to end customer via Data vault and SFTP.

Created more than 200 lockboxes.

Assignment 8: Lockbox reporting using Crystal Reports.

Role: Lead Developer

The primary objective is to create transaction report using Crystal Reports tools for the end customers.

Responsibilities:

Requirement gathering from Treasury team.

Creating the SQL stored procedures in the database.

Design and data integration for the report in the crystal report tool.

Testing and deployment of reports in the Lockbox enterprise application.

Assignment 9: Report generation for Cash vault Processing.

Role: Developer

The primary objective of this project is to generate the flat file report with the cash vault orders and deposit details.

Responsibilities:

Understanding the requirements.

Create SQL job with stored procedures based on the business rules to extract the data from the database for the respective Business Day.

Created a program to email the report to business clients via SMTP.

Testing the application and deploying it in production environment.

Assignment 10: Exceptions and Incoming Returns Processing using TRIPS

Role: Lead SME

Responsibilities:

Worked on production support for Check processing and Fraud analysis system.

Understanding the business process involved within the system, work with vendor DSS and Orbograph to facilitate enhancement to the current product based on client’s requirement.

Enhancement of the following inhouse modules – Fraud File Balancing, Reformatter & Redirector process for Outgoing Returns, Fraud Feedback Balancing, Kronos.

Proactive monitoring of Morning day-build for the operation’s processing, mid-day processing and the end of day processing.

Make sure all the Day 1 On-Us checks are undergoing fraud detection and processing of the checks are done within the SLA.

Ensure to adhere to the Federal regulation for the business process and data archival following the ILM standards.

Assignment 11: Document Imaging System

Role: Lead SME

Responsibilities:

Worked on production support and enhancement for Document Imaging applications like Unisys Info Image and SQN Signature Verification.

Understanding the business process involved within the system and facilitate enhancement to the current product based on client’s requirements.

Ensuring the system or piece of components within the system are upgraded to the latest compatible version to avoid any risk associated with it.

Assignment 12: Lockbox Processing

Role: Lead SME

Responsibilities:

Worked on production support and enhancement for Lockbox processing application.

Enhancement of the existing Lockbox for new requirement from the customers.

Provide Level 2 and 3 support for the daily production support issues.

Assignment 13: Access Management, Alarm Monitoring, CCTV Surveillance System – JCI, Mastermind

Role: Lead SME

Responsibilities:

Worked on production support and enhancement for security applications.

Configuring and maintaining the following system,

oAccess Management system, Alarming system for the Operations facilities and Executive offices.

oMaster Mind is a tool from JCI for Alarm monitoring of Banking centre and their Bank Managers.

oTruvision Navigator is a tool used for video surveillance of all the CCTV cameras used in Banking Centres, Operation Facilities and ATM’s.

oEasy Lobby-Temporary access management system tool for Visitor Access Management.

Assignment 14: CLOUD Migration

Role: Lead SME

Responsibilities:

Responsible for analysing the current infrastructure and working with the cloud development team to design the new infrastructure either as Greenfield Build or Lift & Shift approach.

Work with Business and security for the approval of the proposed design.

Once the infrastructure is ready in the cloud, ensure to install the application from scratch, configure it and setting it up for UAT validation.

After the UAT validation, work on the production certification to go live in production environment.

Successfully transitioned 12 application infrastructures into cloud within the stipulated time of 4 months.

EDUCATIONAL QUALIFICATIONS:

Title of the Degree

Institute / University

Specialization

CGPA / Percentage

Master of Science

BITS, Pilani

Software Engineering

6 CGPA

Bachelor of Engineering

Anna University

Electrical and Electronics Engineering

77 %

PERSONAL DETAILS:

Date of birth

30th June 1989

Nationality

Indian

Marital status

Married

Contact #

+1-248-***-****

Contact this candidate