Industry Experience
More than * years of IT Experience in development and testing.
Strong knowledge of Software Quality processes and implementing them in IT industry.
Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Testing Methodologies.
Technical skill areas include Oracle database, Oracle Forms 6i and PL/SQL.
Domain Knowledge of Insurance and Finance (Loan processing and Trade).
Proficient in requirement gathering, analysis, development and client interaction & Onsite Co-Ordination.
Strong skills in Functional testing, GUI testing, System testing, User Acceptance Testing (UAT) and Interface testing. Expert in writing, reviewing and execution of test scenarios and test cases.
Have worked on both Waterfall and Agile Software methodologies.
Education Qualification
Bachelor of Engineering in Information Technology from Mumbai University 2009.
Known Technologies
RDBMS
:
Oracle, SQL Server
Front End
:
Oracle Forms 6i
Reporting Tools
:
Oracle Reports 6i, Crystal Report
Programming Languages
:
Pro*C, Java
Tools / Utility
:
T.O.A.D., Oracle SQL Developer
Work Experience
Apr 2012- March 2015
:
Mastek Limited, Mumbai
Dec-2009 - Apr 2012
:
Nucsoft Limited, Mumbai
Project Details
Mastek Limited.
Company Profile - Mastek Limited is 30+ years old global software company providing Insurance, Government solutions and IT services.
Project # 1
Project
:
STG Billing System
Duration
:
April 2012 – March 2015 (2 Years 11 Months)
Client
:
Country Financials, USA
Selective Insurance Company, USA
Technologies
:
Unix, Oracle 11g, SQL / PLSQL, SQL Server 2012, Java.
Team Size
:
25 – 30
Role
:
Senior Software Engineer
Responsibility
:
Impact Analysis of requirements identified by Client and onsite members.
Estimation of the changes required to meet client requirements.
Preparing Design Documents, Program specifications & test cases.
Development and Code Review.
Creation and review of test cases.
Functional, GUI, Integration and Unit Testing.
Knowledge transfer Session and Training to the team members.
Client and QC Support.
Defect fixing.
Description
:
STG Billing System is Standalone billing used by Insurance Companies. It provides the user with advanced and automated billing capabilities.
Automated invoice generation and cancellation allows smooth cash flow and risk management.
Ease of use, itemized invoices and detailed inquiry screens, reduces the turnaround time for customer service inquiries.
Wide Range of billing options (Direct Billing, Account Billing, Agency Billing, Whole sale billing).
Automated invoice generation for direct and account billed policies on the basis of payment plans and the term of the policy.
Automatic generation of notices of cancellation for policies with payments due.
Suspension of billing for a policy or individual transaction.
A user-friendly interface to implement security features for the entire application and for specific business activities by the business user.
User friendly On-Line inquiry capabilities (Point and Click)
Receivables management system with automated interfaces like lockbox, Electronic Funds Transfer (EFT) and credit card payment processing.
Flexible user-defined payment plans with optional service charge and finance charge billing
Nucsoft Limited
Company Profile - Nucsoft Limited is a 20+ year’s old Financial and Banking solutions and IT service provider. It is an ISO 2000 Certified Company.
Project # 2
Project
:
Trade System – EPMS, TBMS, CFMS, SFMS
Duration
:
Dec 2009 – April 2012 (2 Years 4 Months)
Client
:
Citibank.
Technologies
:
Unix, Oracle 9i / 10g, SQL, PL/ SQL, Pro*C, VB 6.0, Crystal Reports.
Team Size
:
9
Role
:
Software Engineer
Responsibility
:
Supporting multiple Trade applications comprising EPMS, TBMS, SFMS, CFMS, TRIMS EYE. All these applications have online interaction with FLEXCUBE (core banking system of Citibank).
Preparing Program specification & test case.
Peer-to-Peer Review of Program Specifications, Test cases.
Development and Code Review.
Unit and Integration Testing.
Description
:
Export Product Management System (EPMS) - This system is developed to cater to the needs of the Trade Service Department of Citibank for its export credit product. Export credit is a financial service, which is provided to exporters at a concessional rate of interest, regulated by the Reserve Bank of India, to boost the country’s exports, which in turn would increase the foreign currency inflow in India. This application also includes various reporting modules for the customer, Internal reports, Regulatory reports for RBI defined format.
Trade Bill Management System (TBMS) - TBMS is a financial service provided to GF customers by trade services departments of Citibank. Citibank discounts Bills drawn between the Buyer and Seller of goods and services. By discounting a Bill, the Bank is able to offer short term funds to its Customers.
Both the EPMS and TBMS systems have the facility of the EOD (End OF Day) & BOD (Beginning Of Day) automated processes to take care of the part of the activities to be performed during the day.
Channel Finance Management System (CFMS) - This is a financial service provided to Emerging Local corporates by trade services departments of Citibank. The Top Tier Local Corporate has many dealers to whom they sell goods. These dealers may want credit. Hence TTLC draws a bill of exchange for the amount due from the dealers and presents it to the bank, for discounting. The money is immediately rendered to the TTLC, yet the dealer receives the credit. At maturity the dealer repays to the bank. The bills discounted by the bank at various locations are entered at a central location.
Supplier Finance Management System (SFMS) - Supplier Finance is a financial service provided to Emerging Local corporates by trade services of Citibank. The sales contract signed between the Supplier and Buyer and loan is given as per the Purchase Order. Physical handling of Securities at various stages.
Project # 3
Project
:
Trim Eye
Duration
:
7 Months.
Client
:
Citibank.
Technologies
:
Unix, Oracle 9i / 10g, SQL, PL/ SQL, Pro*C, VB 6.0, Crystal Reports.
Team Size
:
8
Role
:
Software Engineer
Responsibility
:
Development using Pro*C and PL/SQL for enhancements.
Create test plans, and responsible for conducting the testing of modules until UAT for EPMS 9.0 and EPMS 10.0.
Developed many new procedures and packages in PL SQL FOR TBMS release 4.0 and 5.0.
Resolving all EOD / BOD issues by debugging aborted PRO*C and PL-SQL codes.
Monitoring and resolving critical issues in the Beginning of Day, End of Day and End of Month processes which are very crucial and impact Business of the client.
Finding root causes for any reconciliation errors in account balances reported by users, and suggesting the effective measures to resolve them
Identify any system bugs, and carry out bug fixes.
Reporting the monthly status and statistics on the number of tickets, and their trends.
Providing effective support to users with 100% resolution within SLA.
Coordination amongst multiple teams based at different physical locations.
Escalations to peers, whenever needed at right times.
Description
:
This application includes various reporting modules for the customer, Internal reports, Regulatory reports for RBI defined format.
Mainly in Trims eye system data fetched from 3 systems that is from EPMS, TRIMS, CENTRAL IMAGE and merge all data into single report as per client requirement.
Achievements
Have taken training regarding FATS(Fully Automated Transfer system) which is useful for transferring files/any major /minor enhancements/bug fixes to the UAT environment for testing prior the files are being transferred to Production environment as a permanent fix.
Received quite a few congratulatory mails for providing effective and timely resolutions for any enhancement / bug fix issues to users.
Won captain of Cricket and throw ball team females.
(Deepika Mehra)