Software Engineer A Senior
Resume:
S. Lakshmi M.C.A.,
Phone: 998-***-****
***************@*****.***
CAREER OBJECTIVE
To get a responsible position and gain good reputation at workplace by making use of my talent and eagerness to learn, so as to be beneficial to the organization I work for, while enhancing my knowledge.
PROFESSIONAL SUMMARY
Expertise in Estimation, Design, Analyzing the problem requirements and Development of Oracle 12C SQL, PL/SQL Packages, Stored Procedures, Functions, Triggers, Forms, Libraries, Sql_Loader, Reports, Development of screen in Apex, Bug fixing and Designing, Data modeling(Creating logical model and physical model and their relationship as per the requirement), Performance Tuning, Creating DBA health Check report.
WORK EXPERIENCE
Working as a Senior Software Engineer in Tech Mahindra(from Jan - 2021 to Till date).
Worked as a Senior Oracle Developer in WIPRO Technologies(Client BNYM, Payroll: IDC Technologies) from Nov-2019 to Mar-2020.
Worked as a Senior Oracle Consultant in Dynpro India Pvt. Ltd.,(Client: Infogain India Pvt. Ltd.) from Dec-2015 to Mar-2018.
Worked as a Senior Oracle Developer in VHS Consulting India Pvt Ltd.
from Dec- 2014 to Oct-2015.
Worked as a Team Lead in Impelsys India Pvt Ltd., Bangalore
from Dec-2006 to Aug-2013.
Worked as a Software Engineer in Canbank Computer Services Ltd., Bangalore
from Jan-2001 to Feb-2005.
Worked as a Programmer in C-Square Computers Ltd., Trichy
from Jun-1998 to Aug-2000.
RESPONSIBILITIES
Estimation, design and analyzing the requirements.
Maintaining/Supporting Existing products, and process Change
Request/Enhancement.
Bug Fixing.
Developing/Modifying Existing Packages, Stored Procedures, Functions, Triggers.
Feed file processing
Developing Forms and Generating Reports.
Testing and preparing Test case Design.
Take care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
. Migration from one software to other software
Developing DBA reports.
EDUCATION
[Jun 1994 to Jun 1997]
M.C.A.
Bharathidasan University, Tiruchirappalli. (First Class)
[Jun 1991 to Jun 1994]
B.Sc.(Computer Science) (First Class)
Seetha Lakshmi Ramaswamy College(Autonomous) Bharathidasan University, Tiruchirappalli.
TECHNICAL EXPOSURE
DATABASE(RDBMS) : Oracle 21C
ORACLE TOOLS : SQL, PL/SQL, FORMS,
REPORTS, SQL LOADER.
,
OTHERS : GCP(Big query), Postgre Sql, Salesforce DB,
Amazon Redshift,
LANGUAGE : VB, C, C++.
OPERATING SYSTEM : Windows 95/NT/2007/XP/
Unix.
DBMS : Clipper 5.0., Foxpro 2.6.
Utilities : SQL*PLUS, SQL*LOADER
GUI1. : Visual Basic 6.0.
COM/DCOM, Developer
10G. Apex
Area of specialization : Oracle12 C SQL, PL/SQL
Developer 10G, Postgre Sql
Project Exposure
Training attended : Training attended for sql/pl-sql for IFS project
from 05-Jun-2024 To 19-Jun-2024.
1. Project : OSS_P&B_Dev_FP(Customer Delivery)
Organization : Tech Mahindra
Client : BRITISHTELECOMMUNICATIONSPLC
Team Size : 5
Role : Data migration is related to bring the legacy PACS(planning
activation configuration) and PERT data into the new
SRIMS(service resource inventory management system) Schema.
As per the change request, need to analyze data and creating
scripts. Resolves Bug fixes, worked on performance issues.
Duration : 20-Aug-2024– 24-Mar-2025
Environment : Oracle 21c, Neo4j DB
2. Project : Solenis-EDW migration
Organization : Tech Mahindra
Client : Solenis
Team Size : 21
Role : Migrating all objects from MS Sql server(sprinter converted) to
GCP Big query by creating scripts in Big query as per the
requirements.
Duration : 12-Dec-2023 – 17-Mar-2024
Environment : MS Sql server, Big query
Description : Migrating all DB objects tables and functions, procedures from MS Sql
Server(sprinter converted) to GCP Big query as per the requirements.
3. Project. : Ent CPS Salesforce FP.
Organization : Tech Mahindra
Client : British Telecom
Team Size : 22
Role : Migrating all objects from Salesforce DB BPS to BTB, creating
scripts in Postgre as per the requirements.
Duration : 08-Jul-2023 – 13-Nov-2023
Environment : Salesforce DB, PostgreSQL
Description :
Through salesforce DB extracting and comparing all data from Source to Destination and put in Excel sheet as per the requirements. Creating all DB objects scripts, and function, procedures, triggers as per the requirements.
4. Project. : B2C Migration
Organization : Tech Mahindra
Client : Nissan Motor company
Team Size : 5
Role : Migrating Oracle to Postgre code, Enhancement, Bug
Fixes, runtime activities.
Duration : 15-Nov-2021 –16-06-2023
Environment : Oracle, PostgreSQL
Description :
Migrating all Oracle Triggers, Functions, Procedures, Packages to Postgre code and Unit Testing. Moved all codes from Dev Environment to Stage, QA and production Live. After moving to Production Live, new development /enhancement along with product development team and supporting them with runtime activities.
5. Project : GEA_AWS_Services_Solutions
Organization : Tech Mahindra
Client : Amazon Web Services(GE)
Team Size : 7
Role : Migrating Grean Palm report to Amazon Redshift
Duration : 09-Aug 2021 –30 Oct 2021
Environment : Green Palm, Amazon RedShift
Description :
Through Spotfire tool migrating GP reports to RS reports, Unit Testing, Involved some Postgre SQL coding Resolving SQL errors.
6. Project : GEA_AWS_Services_Solutions
Organization : Tech Mahindra
Client : Amazon Web Services(GE)
Team Size : 21
Role : Estimation, Migration, Analyzing requirements,
Code changes, Unit Testing. Releases
Duration : 12-Feb 2021 –08 Jul 2021
Environment : Green Palm(PostgreSql), Amazon RedShift
Description :
As per the requirements, Migrating Green palm code to Amazon RedShift stored procedures codes making necessary code changes, Unit testing, Preparation of TCD as per the flow, Releases. After releases, moved all codes to GITHUB.
7. Project : Migration of all objects from Sybase to Oracle
Organization : Wipro, Bangalore
Client : Bank of New Yark Mellon
Team Size : 7
Role : Estimation, migration, analyzing requirements,
Code changes, Unit Testing. Releases
Duration : Nov 2019 – jan 2020
Environment : Oracle12c, PL/SQL
Description :
As per the requirements, Migrating Sybase stored procedures codes from
Sybase to Oracle, making necessary code changes, Unit testing, Preparation of
TCD as per the flow, Releases.
8. Project : Bank of New Yark Mellon
Organization : Wipro, Bangalore
Client : Bank of New Yark Mellon
Team Size : 7
Role : Estimation, Migration, analyzing requirements,
Code changes, Unit Testing. Releases
Duration : Feb-20 – Mar-20
Environment : Oracle12c, PL/SQL
Description :
As per the requirements, Migrating Sybase triggers codes from Sybase to
Oracle making necessary code changes, Unit testing, Preparation of TCD as
per the flow, Releases.
9. Project : Validation of Mobile Number.
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : 1
Role : Estimation, analyzing existing code, design,
Code changes as per CR(Modifying Packages, Stored Procedures, Functions, Triggers)
and Unit Testing, Release to the client, updating
status to the client.
Duration : Jan 2016 – Mar 2016
Environment : Oracle11G/Unix, Java.
Description :
Need to validate 10 digits mobile number from right to left.
Need to validate that mobile number should be having prefix like 9 or 7 or 8
otherwise need to discard, whatever prefixes like +91 or 0 or(only when we are linking).
10. Project : Bug fixes for disabled card.
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : 1
Role : Estimation, analyzing existing code, design,
Code changes(Modifying existing
Packages, Stored Procedures, Functions, Triggers) as
per bug and Unit Testing,
Release to client, updating status to the client.
Duration : Apr 2016 – May 2016
Environment : Oracle11G/ Unix, Java.
Description :
For Blocked/disabled card points are not uploaded through feed file/same are getting rejected. Should upload the same.
11. Project : Bug fixes for demog update
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : 1
Role : Estimation, analyzing existing code,
Code changes(Modifying existing
Packages, Stored Procedures, Functions, Triggers) as
per bug and Unit Testing.
Release to client, updating status to the client.
Duration : Jun-2016 – Jun 2016
Environment : Oracle11G/Unix, Java.
Description :
Post Demog update, card type is not getting changed in system. Through feed if dummy card is getting updating, physical card type is not getting changed to permanent from feed imint_member(should be changed only for U not for PU.
12. Project : Merging Output Files
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : 1
Role : Estimation, analyzing existing code, design,
Code changes(modification of existing SQL query) as
per BRD and Unit Testing,
Release to client, updating status to the client.
Duration : Jul-2016 – Aug 2016
Environment : Oracle11G/Unix, Java.
Description :
The current process of MSR activity file processing generates only success file post points upload in LMS. The output file does not contain reject cases and separate manual query is being run for creating rejection file. The requirement is to have a single output file with both success and rejection cases.There have been instances where customers debit card associations are de-stitched from PAYBACK account based on specific request from ICICI Bank and activity upload for these cases get rejected.
13. Project : Aggregation through feed.
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : Estimation, analyzing existing code, Design, Loading
data by making control file and
Code changes(Creating staging and production Tables,
Packages, Stored Procedures, Trigger)as per BRD
and Unit Testing, release to client, updating status to
the client.
Duration : Sep-2016 – Dec-2016
Environment : Oracle11G/Unix, Java.
Description :
This use case allows the user to perform the aggregation of PAYBACK accounts using the feed file.
●The feed must take the account details to be aggregated.
●User must provide the primary account and secondary account number
●No validation to be done by the LMS system except the following:
●No pending redemption should be present in the secondary account
●In case aggregation is successful, PAYBACK to generate success file
●Incase aggregation fails, PAYBACK to generate error file with reason of failure
●All Account aggregation validation needs to be done outside the LMS system.
14. Project : Mobile number to be linked/rejected as per the below
flow (MI Linking Flow).
Client : Payback India Pvt. Ltd.
Team Size : 1
Role : Estimation, analyzing existing code, design,
code changes(Creating staging and production Tables,
Packages, Stored Procedures, Functions, Trigger) as
per BRD and Unit Testing, Release to client,
updating status to the client.
Duration : Jan-2017 – Dec-2017
Environment : Oracle11G/Unix, Java.
Description :
LMS system to accept the mobile number update (with the MI Linking flow) through IMINT MEMBER /MEMBER PROFILE UPDATE FEED with PU flag.
ICICI Requirement/Exception:
●ICICI will be sending the Mobile no and/or Email update in the following format:
●
●LMS system should be able to process the above file for update with the MI Linking Flow. The same can be achieved by writing a pre-processor script to convert the file to a format acceptable by LMS.
●If multiple demogs. (DOB, Email Address, address etc.) are received as part of profile update along with mobile number, all the demogs to be updated first in the LMS system except the mobile number. Then the MI Linking flow to be applied on the mobile number. Accordingly, mobile number to be linked/updated or rejected by the system.
●Mobile number has been authenticated by the partner
●The demogs updated will be received for the accounts where the profile has already been created/updated in the system (Permanent/Virtual Accounts)
●All demogs are not mandatory for LMS to process the demogs update received by the partner. For e.g. If only Mobile number and Email Id are received for update the same should be updated in the system.
●Above process will not be applicable for MEMBER EXTENDED PROFILE Feed
●All Communication (SMS/Email) for Linking/Delinking generated by the LMS system should work AS IS.
●Mobile number to be updated in profile number only if it’s linked with the Card Number
●If same mobile number is present for multiple card numbers, the mobile number to get linked/delinked as per the MI Linking Flow for each account.
oE.g. For ICICI partner this scenario will not occur for Credit card customers but can occur for debit card customers. So, there can be a scenario where same Mobile number gets linked/delinked with multiple accounts.
●All partners except ICICI to share the demog/Mobile number update through IMINT MEMBER /MEMBER PROFILE UPDATE FEED.
●MI Linking flow to be applied for all partners sharing the demog update through IMINT MEMBER /MEMBER PROFILE UPDATE FEED (with PU flag) who have the process of authenticating the mobile numbers at their end.
15. Project : All Mobile related Live project support gave training to
team members
Organization : Dynpro India Pvt. Ltd.
Client : Payback India Pvt. Ltd.
Team Size : 1
Duration : Jan-2018 – Mar-2018
Environment : Oracle11G/Unix, Java.
Description : Bug fixes raised by production team, performance
tuning of all mobile related project in UAT and
Production area.
16. Project : Coverage Plan Enhancement.
Organization : VHS Consulting India Pvt Ltd, India
Client : Sterling Administration(SAM), Oakland, CA
Team Size : 3
Role : Analysing Change request, Enhancement
Coding(altering table structure and modifying
package) and Unit Testing.
Duration : Dec-2014 – Feb 2015
Environment : Oracle11G and Apex screen.
Description :
HSAs FOR INDIVIDUALS
Sterling offer a HSAs are like "medical" IRAs. They are tax-free accounts that
individuals with an HSA compatible, high deductible health insurance plan can fund
and use to pay for medical expenses.
PRODUCTS FOR GROUPS
Sterling offer a full suite of products managed through a single sales representative or
account manager, integrated online account management tools, and a team of benefits
experts and bi-lingual customer service representatives. Health Savings Accounts,
Health Reimbursement Arrangements, Flexible Benefit Plans, Premium Only Plans,
COBRA, Compliance Services, Benefit Solutions.
This is enhancement of Coverage Plan Type for Health plan upload with the existing
plan_type Single, Family for HSA/ HRA/FSA, and mass enrolment health plan upload
for HSA only. Added coverage plan types are with Codes are Code : 2 Meaning
Employee + Spouse Code: 3 Meaning :Employee + Child Code: 4 Meaning:
Employee + Children, created package and modified procedures according to the
requirement.
17. Project : Contribution type dropdown.
Organization : VHS Consulting India Pvt Ltd, India
Client : Sterling Administration(SAM), Oakland, CA
Team Size : 3
Role : Analysing Change request, Enhancement
Coding(Creating package which includes functions)
and Unit Testing.
Duration : Mar-2014 – Apr 2015
Environment : Oracle11G and Apex screen
Description : Creating a pipelined function in pc_web_utility_pkg
for the contribution type dropdown. We need to take acc_num as input and return
back the data combining the SQL's in this function. Conditions are a. Initial
contribution reason to show if income table has no records for the given account b. If
an account holder >= 55 then show catchup contribution c. If the current date is the
last day of the year until the tax day defined for the next year i.e 14 Apr 2015 then
show Prior Year contribution if not don’t show.
18. Project : Pipelined function.
Organization : VHS Consulting India Pvt Ltd, India
Client : Sterling Administration(SAM), Oakland, CA
Team Size : 1
Role : Coding(Creating pipelined functions for all the sql
queries in PHP) and Unit Testing.
Duration : Apr-2014 – Sep-2015
Environment : Oracle11G/APEX
Description : Creating a pipelined functions for all the queries in
PHP models to improve performance.
19. Project : BPS setup automation and verification
Organization : VHS Consulting India Pvt Ltd, India
Client : Sterling Administration(SAM), Oakland, CA
Team Size : 2
Role : Coding(creating new tables and packages)
and Unit Testing.
Duration : Sep-2014 – Oct-2015
Environment : Oracle11G/APEX
Description : Creating package to create .csv/.mbi file for all plans
in SAM shall propagate to BPS/Alegeus and parameter settings such as bank account
setup, employer account (Manual and POS) creation, debit card setup, reimbursement
setup, HRA tiers and deductibles rules will be automatically programmed as required
per plan specifications in SAM.
20. Project : Product Information Management
Organization : Impelsys India Pvt Ltd, India
Client : PAN MACMILLAN Ltd, London.
Team Size : 2
Role : Analysing Change request, Coding(Changing forms,
reports, function, packages, procedures,triggers) and
Unit Testing, Customer Support and Maintaining,
Performance Tuning.
Duration : Aug 2007 – Aug 2013
Environment : Oracle10G / Forms10G and Reports.
Description :
Pan Macmillan is part of the Macmillan Group. Macmillan is known for its high-quality academic and scholarly, educational, fiction and non-fiction and reference publishing. In the UK its divisions include Palgrave Macmillan, Macmillan Education, Macmillan Distribution and the Nature Publishing Group. Pan Macmillan is a trading division of Macmillan Publishers Ltd.
21. Project : Product Management
Organization : Impelsys India Pvt Ltd, India
Client : HarperCollins Publishers, UK
Team Size : 2
Role : Analysing Change request, Coding(Changing forms,
reports, function, packages, procedures,triggers) and
Unit Testing, Customer Support, Maintaining,
Performance Tuning.
Duration : Aug 2009 – Aug 2012
Environment : Oracle11G R2 / Forms10G and Reports
Description :
HarperCollins Publishers is one of the world's leading English-language publishers with headquarters in New York. The company is a subsidiary of News Corporation. HarperCollins is a broad-based publisher with strengths in literary and commercial fiction, business books, children's books, cookbooks, mystery, romance, reference, religious, and spiritual books. The company has revenues that top $1 billion annually.
22. Project : Product Management
Organization : Impelsys India Pvt Ltd, India
Client : Chronicle Books, USA.
Team Size : 3
Role : Analysing Change request, Coding(Changing forms,
reports, function, packages, procedures,triggers) and
Unit Testing, Customer Support, Maintaining,
Performance Tuning.
Duration : Aug 2009 – OCT 2011
Environment : Oracle11G R2 / Forms10G and Reports
Description :
One of the most admired and respected publishing companies in the U.S. Chronicle Books was founded in 1966 and over the years has developed a reputation for award-winning, innovative books. The company continues to challenge conventional publishing wisdom, setting trends in both subject and format, maintaining a list that includes fine art titles in design, art, architecture, and photography. The company also published books on Children’s book, Cookbooks and has also launched its Gift division to develop ancillary products such as the Griffin & Sabine address book and writing box, the best-selling 52 Deck series, and a motorcycle journal and address book based on the Harley-Davidson image archives.
23. Project : Product Information Management
Organization : Impelsys India Pvt Ltd, India
Client : American Management
Association(AMACOM), USA
Team Size : 2
Role : Analysing Change request, coding(Changing forms,
reports, function, packages, procedures,triggers) and
unit Testing, Customer Support, Maintaining,
Performance Tuning
Duration : Aug 2008 – Dec 2011.
Environment : Oracle10G / Forms10G and Reports
Description :
AMACOM is the book publishing division of the American Management Association. The publisher’s broad range of offerings spans not only the critical business topics and leadership challenges of today and tomorrow, but also the issues that affect our lives, our work, and our world. AMACOM publishes non-fiction books on business, management, leadership, HR, training, communications, career growth, personal development, marketing, sales, customer service, project management and finance. Authors are experts in their fields and unrivalled in their knowledge, experience and reputation. They are world-class educators, successful executives, business owners, trainers, consultants, and journalists all eager to share their insights and techniques with a broad audience.
24. Project : Product Information Management
Organization : Impelsys India Pvt Ltd, India
Client : Human Kinetics, USA.
Team Size : 2
Role : Analysing Change request, Coding(Changing forms,
reports, function, packages, procedures,triggers) and
Unit Testing, Customer Support, Maintaining.
Duration : Aug 2008 – Dec 2011.
Environment : Oracle10G / Forms10G and Reports
Description :
Human Kinetics is a publisher specializing in the physical activity field. Their publications include textbooks and their ancillaries, consumer books and academic journals, online courses, software and audio-visual products. They are intended for a range of audiences, including college students and professors, personal trainers, rehabilitation specialists, athletes, coaches, physical educators, and nutritionists. The company is based in Champaign, Illinois, and has subsidiaries operating in Australia, Canada, and the United Kingdom.
25. Project : Product Information Management
Organization : Impelsys India Pvt Ltd, India
Client : Kogan Page UK.
Team Size : 2
Role : Analysing Change request, Coding(Changing forms,
reports, function, packages, procedures,triggers) and
Unit Testing, Customer Support, Maintaining.
Duration : Aug 2006 – Jan 2011.
Environment : Oracle 10G/ Forms10G and Reports
Description :
Kogan Page is a leading independent global publisher of business books at all le vels encompassing the fundamentals of business, practical guidance and cutting-edge business topics. They publish some of the world’s foremost authors in business publishing from academic prize-winners to worldwide trade best-sellers. Kogan Page has built its reputation through excellence across all key areas in business publishing including: Management and Leadership, Sales Marketing and PR, Human Resource Management and Coaching, Finance and Investment, Strategy and Risk, Small Business, and Logistics and Transport. Through its well-established Education and Skills and Careers and Development products, Kogan Page offers expert advice to the consumer from their formative education to a thriving career, from successfully finding their first job to developing their professional knowledge so they can realize their career ambitions.Kogan Page is at the forefront of digital innovation, leading the way as one of the first business publishers to digitize their products, and our e-books are now available across a wide range of platforms and e-readers. Kogan Page also places great importance in digital development, having created several successful apps to accompany our products.
26. Project : Product Information Management
Organization : Impelsys India Pvt Ltd, India
Client : International Monetary Fund, USA.
Team Size : 2
Role : Analyzing Change request, Coding(creation of
procedures) and Unit
Testing, Customer Support, Maintaining.
Duration : Dec 2007 – Mar 2008
Environment : Oracle 9i / VB.net
Description :
The International Monetary Fund (IMF) is an organization of 188 countries, working to foster global monetary cooperation, secure financial stability, facilitate international trade, promote high employment and sustainable economic growth, and reduce poverty around the world. This covers the Accounts Receivable functionality and options within a2r to support the requirements of the IMF. Standard procedures are in place to handle the management of customer payments for both single items (e.g. books) and subscription items (e.g. journals). This should not be treated as a comprehensive review of functionality within the A/R routines as there are numerous reports, online cash transaction options, control features and inquiry screens that are not covered here. No current IMF processes have been found to be outside of the VISTA functionality.
27. Project : Denali Systems Remediation – Vista PM
Organization : Impelsys India Pvt Ltd, India
Client : Pearson Publications, USA
Team Size : 2
Role : Analyzing, Coding(Changing forms,
reports, function, packages, procedures,triggers),
Unit Test
Duration : Apr 2007 – Jul 2007
Environment : Oracle 10G / Forms10G and Reports
Description :
The intent of this project is to modify the Vista PM application to support a non business unit segmented K12 working environment that can be accessed by centralized service groups (Publishing Services, Finance and Product Development) and to streamline disparate data and transaction process rules in order to implement consistent business practices across the K12 disciplines.
28. Project : Pearson Production Management System.
Organization : Impelsys India Pvt Ltd, India
Client : Pearson Publications, USA
Team Size : 3
Role : Coding(Changing forms,
reports, function, packages, procedures,triggers),
Enhancements and Unit Testing,
Duration : Dec 2006 – Mar 2007
Environment : Oracle 10G / Forms10G and Reports
Description :
Pearson Education is a leading educational publisher and also the global leader in online learning with nearly 2,000 textbook companion Web sites, the Information Website for technology professionals, and the Family Education Network, the award winning on line resource for parents, teachers, and children. Pearson Education is part of Pearson (NYSE: PSO), the international media company. In addition to Pearson Education, Pearson's primary operations include the Financial Times Group and the Penguin Group. The existing system is customized to Pearson needs by redesigning the database creating new forms and creating reports. Various modules like Program, Summary, Cost Control, Product specification, Schedule, ISBN Creation, Forecast, Purchase order and invoice are implemented.
29. Title : Share Product
Client : Canbank Computer Service Ltd(R&Tdivision)
Software : Oracle 8 with Developer 2000, Reports
Role : Coding(Developing Packages, Stored Procedures,
Functions, Triggers, forms, libraries, reports). and
Unit Testing
Team Size : 4
Duration : 6 months
Abstract :
The share transfer agent maintains the record of holders of securities issued by a corporate and deals with all matters connected with transfer and redemption of securities. It includes following modules: Application Entry, Allotment of shares, Refund (Partial/full), Brokerage calculation, Transfer, Deletion of Joint holder due to his death, Transmission(Change of ownership due to death of sole holder), Transposition(Change the order of the holders), Name addition, Buy back, Folio Updation, Folio Consolidation, Demat, Remat, Daily Reconciliation, Certificate related transaction, warrant related transaction, Folio related transaction, Mail inward and outward, Book Closure, BPJR transaction, MICR updation, Billing, Legal, Bank Lien, Security of users.
30. Title : Register and Transfer
Client : Canbank Computer Services Ltd. (R&T division)
Software : ORACLE 8 with DEVELOPER 6, Reports
Role : Coding(Developing Packages, Stored Procedures,
Functions, Triggers, forms, libraries, reports). and
Unit Testing.
Team Size : 4
Duration : 6 months
Abstract :
This Software developed for R&T Agents to maintain the record of investors in Mutual Funds schemes. This covers the following modules. Application entry, Allotment, consolidation of unit certificates, Consolidation of folios, Change of units, Billing, Inwarding of mail, Repurchase, Resale, Redemption, Switchover, Change of address, Change of mandate, Change of name, Noting/Removal of bank lien, Splitting of certificates, Transfer of units, BPJR process, Adding stop marks.
31. Title : Canara Bank Statements
Client : Canara Bank, Bangalore.
Software : Oracle with VB6.
Role : Coding(Developing Packages, Stored Procedures,
Functions, Triggers, forms, libraries, reports), and
Unit Testing.
Team Size : 4
Duration : 6 months
Abstract :
This Package takes care of all the Reports related to PSR, PRR, STR, SSI, LB, MISC which is taken by Branch, RO, CO and HO. From RO to HO it generates the Reports for Branch wise, State wise, Circle wise, District wise and Activity wise.
32. Title
Client : Chinthamani Super Market Ltd., Trichy
Software : ORACLE with D2k, Reports
Role : Coding(Developing Packages, Stored Procedures,
Functions, Triggers, forms, libraries, reports) and
Unit Testing
Team Size : 2
Duration : 6 months
Abstract :
The various activities carried out by Super Market system is maintaining Customer and Vendors related details, maintaining product related details, recording all the day to day transactions which includes generation of Cash Bills, handling product receipts, updation of stock at the time of selling, updation of stock at the time of receipts of products. Its reports include Generation of reminders to customers for overdue bills, daily Sales Report, Non-moving product reports, Over Stocked products Reports, Reorder level reports, report on Credit card transactions.
33. Title :
Contact this candidate