PowerBuilder Developer with 15+ Years Experience

Curriculum Vitae

*

J.Hemalatha

Professional Summary

Having 15+ Years of experience in Power builder, in System Analysis/Design, Coding, and Unit Testing, Implementation, Maintenance and enhancement of Software applications.

Strong Business Software design and development experience in Finance, Insurance and Medical industry using PowerBuilder, Sybase, Oracle, Visual Basic, MS SQL Server.

Thorough experience on software development methodology and Quality processes. Worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation

Expertise in design and development of application in relational database and client server environment using PowerBuilder 6.0/7.0/8.0/9.0/10/11/12 / 2022, Oracle 7.x/8.x/9i/10g, PL/SQL, Sybase

Created numerous SQL reports for users and familiar with various types of stored procedures, views, joins, union, intersect, sub queries, alias, formatting etc.

SQL development with skills in creating tables/views/stored procedures on SQL Server and Oracle databases.

Am a Certified Scrum Master from Scrum Alliance, 2023.

Enthusiastic team player with Team leading capabilities. Experience in customer interaction skills. Good communication and interpersonal skills

Having 2 years of experience in web development tools like Angular. Technical Skills

Operating System Windows 10/11, Unix, MS-DOS

Technology Power Builder 2019 / 2022, Data Science, Artificial Intelligence Programming Languages Python, Angular, Visual Basic Databases and Tools Oracle 9i/10g/11g, MS-SQL Server-2000/2005/2008, T-SQL, Sybase Web Tools HTML 5.0, JavaScript, CSS, Bootstrap

Version Control System MS Visual Source Safe (VSS) Educational Qualification

Title of the Degree with Branch College/University Bachelor Of Engineering (B.E) in Computer

Science

Kumaraguru College of Technology,

Bharathiar University

Certification: Certified Scrum Master Certification, 2023 from Scrum Alliance. Curriculum Vitae

2

Professional Experience

Name of the Company Designation Address of

the employer

From To

Capgemini

[NR Consulting, Noida]

Senior Software

Engineer

Coimbatore Mar 2025 Till date

NTT Data

[Anlage infotech p ltd, Pune]

Senior Software

Engineer

Coimbatore Nov 2023 Oct 2024

Marlabs Innovations Pvt. Ltd Senior Software

Engineer

Bangalore Oct 2020 Feb 2023

Wipro (Contractor)

[eCentric Solutions – Hyd]

Senior Software

Engineer

Coimbatore Aug 2018 Feb 2019

Capgemini (Contractor)

[Happy Minds, Hyd]

Senior Software

Engineer

Chennai May 2018 Aug 2018

ISG Novasoft Technologies Senior Software

Engineer

Chennai Aug 2016 Dec 2017

IBM(Contractor)

[Growel infotech, Pune]

Team Leader Bangalore Jun 2015 Nov 2015

Kumaran Systems

Consultant Chennai Feb 2015 May 2015

Ellucian Technologies Senior Software

Engineer

Bangalore

Nov 2013 Feb 2014

Cognizant Technology

Solutions

Associate Cognizant,

Coimbatore

Mar 2010 May 2013

HCL Technologies Senior Software

Engineer

HCL,

Bangalore

Aug 2008 Jun 2009

I-Flex Solutions Limited Associate

Consultant

Bangalore Apr 2006 Jul 2008

Envision Financial(CMMI

Level IV Company)

Software

Engineer

Bangalore Mar 2004 Apr 2006

Project Profile

Project #1

Title Health Care Plan System

Languages PowerBuilder 2022

Database Oracle PL/SQL

Team Size 7

Project Description

CHPW – Community Health Plan of Washington provides health plan solutions to customers. Maintain customers health records with high security and information about important health care agencies in Washington. Enhancing the frontend screens based on new GUI standards, production support and new development.

Responsibilities

Responsible for the maintenance of the software programming in PowerBuilder 2022.

Expertise in User objects of PowerBuilder.

Curriculum Vitae

3

Created Stored Procedures responsible for generating Reports using Oracle.

Created/Modified Data Windows, Windows, User Objects, Menus in PowerBuilder Project #2

Title Security Finance System

Languages PowerBuilder 2019

Database SQL Anywhere

Team Size 10

Project Description

Security Finance Application is to do with offering personal loan to the customers. In short it is called SFC(Security Finance Corporation) with nearly 1000 branches in US. A maximum of 2000 dollars is given as loan. Initially when the customer asks for a personal loan, the details of the customer is created in Application screen. These details include basic details, budget, account, collateral, collection, reference, credit report(from credit bureaus like Equifax, TransUnion and Circulo de) and military status report. Then the application is converted to account state in the Customer Maintenance screen based on some criteria like residence and income verification got through credit report. There are 2 types of computation – Pre-Computed Loan(fixed EMI) and Interest Bearing Interest Loan Type(floating interest rate). There is option for payment reversal and payment renewal. At the There could be many charges like NSF(Non Sufficient Fund), legal, late charges and miscellaneous charges. At the end of the day daily closing happens after which the transactions cannot be done. There is also monthly processing. There is option for online payment and online leads where the customer can enquire from the company’s website.

Webform Project:

Worked on Webforms Reporting where RTF Template will hold the placeholder to get data from Database. Our task is to develop the RTF Template and also to create Stored Procedure that will populate data to the placeholders in RTF Template. Also, need to do the mapping for RTF Template and Result Set of Stored Procedure in RTF Uploader. Other than this we also handled Production Issues in WebForms.

Roles and Responsibilities

Responsible for the maintenance of the software programming in PowerBuilder 2019.

Involved in enhancement of the application

Involved in production support of the application Project #3

Title Reinsurance System

Languages PowerBuilder 11.5

Database Oracle

Team Size 4

Project Description

Reinsurance is insurance that is purchased by an insurance company. There are 2 types of reinsurance - facultative reinsurance and Treaty Reinsurance. Facultative reinsurance is negotiated separately for each insurance policy that is reinsured. Treaty Reinsurance means that the ceding company and the reinsurer negotiate and execute a reinsurance contract under which the reinsurer covers the specified share of all the insurance policies issued by the ceding company which come Curriculum Vitae

4

within the scope of that contract. There is a classification of the reinsurance - Proportional and Non- Proportional. Under proportional reinsurance, one or more reinsurers take a stated percentage share of each policy that an insurer issues. The reinsurer will then receive that stated percentage of the premiums and will pay the stated percentage of claims. In addition, the reinsurer will allow a "ceding commission" to the insurer to cover the costs incurred by the insurer. Under non-proportional reinsurance the reinsurer only pays out if the total claims suffered by the insurer in a given period exceed a stated amount, which is called the "retention" or "priority". A subscription is made when the customer approaches the reinsurance company. When the subscription is bound, it is converted into a policy. In case of a catastrophy, the customer can make a claim. There is also accounting module which takes care of the accounting of the business. The ceding insurer pays reinsurance premium to the reinsurer in exchange for the reinsurance provided. The insurer transfers some of the risk to the re- insurer for which it pays premium to reinsurer.

Project #4

Title Mortgage System

Languages PowerBuilder 11.5, Visual Basic

Database SQL Server

Team Size 4

Project Description

This software has 6 modules - appraisal, recording, info products, property reports, title and closing. Appraisal is the process of estimating the value of personal property prepared by a qualified appraiser. Mortgage lenders require a property appraisal before approving a home loan. Recording is the act of putting a real estate document into the official records at the County Recorders or Recorder of Deeds Office. A title company makes sure that the title to a piece of real estate is legitimate and then issues title insurance for that property. Property reports provide property and current owner information, and include Legal and Vesting, Mortgage Information, Ownership & Encumbrance and Tax Information reports. The “closing” is the last step in buying and financing a home. The "closing,” also called “settlement,” is when you and all the other parties in a mortgage loan transaction sign the necessary documents.

The application is received, credit reviewed and the loan is pre-qualified by the loan officer. He sends the disclosures and requests the required documents from the borrower. The appraisal, title is checked and sent for processing to the underwriter. Underwriting is a process a lender uses to determine if the risk of offering a mortgage loan to a particular borrower under certain parameters is acceptable. The underwriter analyses the credit report to approve the loan.The underwriter evaluates the risk by the three C's - Credit, Capacity and Collateral. A Credit Score is done which ranges from 350 and 850. If the loan is approved then the documents are sent for closing. The documents are sent to title company and the loan is closed. The documents are sent to lender, the deed is recorded and the fund is distributed.

Roles and Responsibilities

Involved in the support of the application

Involved in the enhancement of the application

Monitoring of batch jobs

Providing agile status to the team

Project #5

Title Customer Services System

Client Metlife

Languages ASP, Javascript

Database SQL Server

Team Size 3

Curriculum Vitae

5

Project Description

Customer Service System (CSS) application deals with the creation and maintenance of cases, actions and reporting. This application serves as a means of providing input for its counterpart DocMan. The Customer Service System (CSS) provides five major functions - Case Tracking, Tracking of customer service transactions (calls, mailings, processing actions), Work flow management, Reporting, Mailing CSS is broken down into following hierarchical components: 1. Customer (Client) Information which is housed by CSS 2. Employee (Enrollee – SSN) which is housed by CSS 3. Employee (Enrollee) demographics which may be housed by CSS or the originating system 4. Case – Request made by Employee, which is housed by CSS 5. Actions – Steps taken to complete the case, which is housed by CSS CSS is a case tracking application for the MetLife Institutional Business group. MetLife customers also known as clients have employees. Employees have cases that are used to maintain customer requests. A Case is an external request from a client employee through Phone calls and mails. Requests are made to the MetLife Help desk where a CSR (Customer Service Representative) maintains the Client employee's demographic information. The CSR uses the CSS application to support calls from the Client’s employees and to manage cases for them. CSS also helps to generate letters and reports. Roles and Responsibilities

Involved in the maintenance and support of the application

Involved in the automation of the SQL Scripts

Project #6

Title Umberella Application

Client 3M

Languages Powerbuilder 11.2

Database Sybase

Team Size 4

Role Team Lead

Project Description

These applications fit in the sales and marketing portfolio. This application consists of other 32 applications. These applications include Umbrella application menu, AAD Pricing maintenance, Accessories Maintenance, Bristle Maintenance, Contract Maintenance, Item Master, Order Inquiry, Cyber-sale Maintenance, Non-stock Maintenance, Sample Maintenance, Ship and debit tactical, SPID Maintenance, Spare parts Maintenance, Tape Pricing Maintenance etc. These applications are copied from the server to the local system and executed. Some functionality is written in C++ and deployed as dll and used by the PB application. Certain amount of visual basic is also used. Roles and Responsibilities

Involved in the support of the application

Involved in the enhancement of the application

Involved in monthly audits

Co-ordinated with onsite counterparts

Curriculum Vitae

6

Project #7

Title Global Incident Management Systems

Languages ASP

Database SQL Server

Team Size 5

Role Team Member

Project Description

GIMS is a web-based system, originally developed within Deutsche Bank, is an incident tracking system. Extending its scope, GIMS is used to manage the entire lifecycle of all defects, enhancements, new requirements, issues, test problems, release issues, user Feedback, support calls and risks. There are eight applications which are being handled which have been customized for the user’s requirements.

Roles and Responsibilities

Involved in the support of the Software

Involved in testing of the application

Project #8

Title Registrars and Transfers

Languages PowerBuilder

Database Oracle

Team Size 4

Role Team Member

Project Description

This system computerizes the registrars and transfer of the company shares. This incorporates the various processes of the scheme like the application entry, allotment of shares, refunding, certificate and folio consolidation and splitting, certificate and folio stop mark, bank-lien replacement and duplication of certificate, transfer of shares etc and the associated reports. Roles and Responsibilities

Involved in enhancement of the application

Involved in support of the application

Involved in unit testing of the application

Project #9

Title Mutual Fund Investor Services

Languages PowerBuilder

Database Oracle

Team Size 5

Role Team Member

Project Description

Curriculum Vitae

7

MFIS systemizes the investor services of the Asset Management Company. Fund is set up in the sytem. Details of the unitholder is stored in the system. The transactions entered are subscription, redemption, transfer, consolidation, split, reissue, reinvestments etc. The units are allocated to the unitholders. Dividends could be Cash and Stock - are distributed to them based on the returns. The dividends could be again reinvested in the funds or could be paid out. There is no broker in the system as the AMC deals with the customer directly. There is standing instruction facility where the investor can invest in SIP(Systematic Investment Plan). Roles and Responsibilities

Involved in the enhancements of the application

Involved in unit testing

Involved in developing and testing stored procedures, functions and triggers Project #10

Title Mutual Funds Management System

Languages PowerBuilder

Database Oracle

Team Size 4

Role Team Member

Project Description

This system computerizes the Mutual Fund system of Transfer Agent Company.This system has masters like Maintain Account types, Check book Styles, Maintain share classes, Maintain Bank Accounts, Maintain funds, Maintain Fund Prices, Maintain Holidays, Maintain Price Cycle Groups, Maintain Special Business Days, Maintain Trading cut off times, Maintain Document /letter types, Maintain Countries/Currencies, Maintain Form Categories, Maintain Fee Types, Set Fund Group Options. The Transaction Screens are the Maintain Account Registration which contains the details of the share holders, Maintain Transactions, Process Systematic Withdrawal Plan, Process Automatic Investment Plan, Process Fund Transactions, Process Money Transactions, Process Money Movements, Process Trailer Fee Payments, Process Dealer Commission Rejects, Clear Pending Transactions. Also there are view screens, which are used to view Account Holdings or Activities, view tax info, view fund prices, view fund info, view load tables, view countries and tax treaty rates. Roles and Responsibilities

Involved in enhancement of the application

Involved in support of the application

Involved in unit testing of the application

Involved in developing stored procedures, functions and triggers Curriculum Vitae

8

Contact Details

Email Id – ***********@*****.***

Mobile No. +91-995*******

Address

#38, Raja Annamalai Road,

Saibaba Colony,

Coimbatore – 641011.

Contact this candidate