Now you can Instantly Chat with Kotresha!
About Me
Balanced Information Technology professional is having over 15+ years of diverse experience across several projects. I have excellent knowledge and skills in the delivery and implementation of quality business systems. I am customer focused, result o...
Show MoreSkills
Portfolio Projects
Description
Managing Team of size 6 to handle production support , Resolving Incident Tickets. Enhancement of Application, optimization
Responsibility: Working as a Senior Solution Analyst / Team Lead for Prudential BSN Life Insurance Malaysia.
- Preparation of System Design Specifications, Technical Design Specification, unit test cases, system test cases, user acceptance test cases etc.
- Conducting reviews for design, coding QC / test cases for team members.
- Coding , debugging, version control Tracking.
- Analysis , Resolving of Incident Ticket (P1 to P5), Data Patching and Enhancement.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- Handling , creating stored procedures, triggers
- Involved in DBA activities like optimization, Installing Informix Environment for Test / UAT / Year End Activities.
- Family Takaful System (FTS) – Life Insurance Module
Description
Project Name: IBS+ (International Billing System)
Client: DHL – IT Services Asia-Pacific. Malaysia, Cyberjaya
Description: As part of the project, I had been assigned to enhance into Outbound Maintenance modules where new payer account and payer country code is introduced in billing system. The effected modules for Outbound are Maintain Outbound Shipment, Invoice/Cash Adjustment, Logistic Service Charge, Outbound Periodic Fee (Non Shipment Fee).
Introducing new Global Mail house zone product and allow only mail zone destination for outbound shipments.
Responsibility: Working as a Senior Solution Analyst for DHL-IT Services Asia-Pacific Malaysia.
- Preparation of System Design Specifications, Technical Design Specification, unit test cases, system test cases, user acceptance test cases etc.
- Conducting reviews for design, coding, test cases for team members.
- Coding and Error debugging, version control Tracking.
- Analysis of production trouble tickets.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- Handling , creating stored procedures, triggers
- Preparing scripts to create , alter tables and upload master records into tables which are implemented in our projects so that the same scripts can be run on production system after it passes through UAT environment.
Description
The Data patching project is to correct and enhance the existing module and its supporting functions. Based on the user feedback, finding out the bug, fixing security issues and improving the usability or performance. It also includes redesigning poorly designed application, New Development, enhancements, maintenance of Informix Database applications
Responsibility: Working as a Senior Solution Analyst for Tokio Marine Life Insurance Malaysia.
- Preparation of System Design Specifications, Technical Design Specification, unit test cases, system test cases, user acceptance test cases etc.
- Conducting reviews for design, coding, test cases for team members.
- Coding and Error debugging, version control Tracking.
- Analysis of production trouble tickets.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- Handling , creating stored procedures, triggers
- Preparing scripts to create , alter tables and upload master records into tables which are implemented in our projects so that the same scripts can be run on production system after it passes through UAT environment.
- Elixer system
Description
Working as a “Head of Professional Service – India Region” for I2sbs-Bangalore.
- Involved in getting projects/module of projects from different clients across Bangalore.
- Preparation of System Design Specifications, Technical Design Specification for development team and coding if required.
- Assisting project management team for strategic planning, team building, Talent acquisition.
- Getting the report for unit test cases, system test cases, user acceptance test cases for individual projects from development team.
- SDLC (Software Development Life Cycle) i.,e from the process of getting the user requirement to till the process of installation at UAT environment.
- Coordinating with clients on their escalations / requirements.
- Allocation and prioritization of jobs among team members. Responsible for team daily time and task sheet, Project Status Report to the Management.
Description
Project Name: New Payment Gateways to Customer Phase 2
Client: Prudential Life Assurance – Hong Kong
Description: The Phase 2 project will provide automatic refund on outstanding PPS/JETCO payment received over 3 months. Some new reports are also designed to help PA and FIN departments to handle the refund process effectively and efficiently. The Project involved New Development, enhancements, maintenance of Informix Database applications, VB front applications and Database
Responsibility: Worked as a Team Lead / Senior Consultant for Prudential life assurance Hong Kong. Handling 2 member team.
- Preparation of System Design Specifications, Technical Design Specification, unit test cases, system test cases, user acceptance test cases etc.
- Conducting reviews for design, coding, test cases for team members.
- Coding (4GL and VB) and Error debugging, version control using ‘MS visual studio 2008-Souce Control Explorer’.
- Analysis of production trouble tickets.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- Handling , creating stored procedures, triggers
- Preparing scripts to create , alter tables and upload master records into tables which are implemented in our projects so that the same scripts can be run on production system after it passes through UAT environment.
Description
Project Name: Debt Collection Module - In House Development
Client: Byond Global / Repcol India
Description: The Project involved New Development, maintenance of Informix
Database applications and Database
Responsibility:
- I was Working as a Manager of IT (Support & Development and Network dept since 2007) department. Handling 3 development staff and 8 Network staff.
- The REPCOL was an Australian company and DEBT collection is part of their business which was outsourced the entire in-house application development activity along with the part of the production to Bangalore on Aug2003. I was responsible for setting up the environment for Source code, compilation process, Installation of Informix SE Database, Creditwise Module, procedure for Backup, defining the user security policies.
- Responsible for installation, database development / maintenance of Informix SE for Production, Development, Training and test environment of Production for all the Repcol offices as and when required.
- Responsible for all the Application Development and Support jobs done since Oct 2003
- Involved in analysis, design, coding, testing, fixing the performance issues
- Conducting reviews for design, coding, test cases.
- Coding and Error debugging.
- Maintaining the existing applications and carrying out the necessary changes as and when required.
- Handling support & development team for all Repcol offices (India & Australia)
- Responsible for Developing and Maintaining CW (Creditwise) Systems.
- Version control of source codes.
- Working closely with production managers / BA team to understand the business needs. Supporting, coordinating with them in terms of developing MIS reports.
- Also a member of steering committee formed by the management.
- Coordinating with GE Capital, Transpacific and STG Australia during the upload process for our purchased Debt in terms of format/data integrity.
- Coordinating with our business partners Carvell and Credit Corp Group (CCG) in terms of application / data requirement like dbexport, setting up Creditwise Mirror System, various reports.
- Documented whole application modules so that may be used to Training and helpful to understand the flow of process to a common user.
- Apart from Technical role, As I department head, I was involved in Managing IT staff, Coordinating with Internal departments like finance, administration, HR and outside vendors to fulfill the IT requirements.
Description
Organization: Datacons
Project Name: TCOP - Total Customer Order Processing
Client: Motorola
Description: The Project involved New Development, maintenance of Informix
Database applications and Database
Responsibility:
- Joined as Analyst Programmer and done lots of enhancements, developed new programs and troubleshooting the issues as per the client tickets.
- Involved in database design, analysis, coding, unit testing and peer testing.
- Preparation of documents for requirements, design, unit test cases, system test
- .
- Part of Production Support for Motorola Europe
- Maintaining TCOPS Systems
- Coordinating with cases, user acceptance test cases etc.
- Conducting reviews for design, coding, test cases for team members.
- Coding and Error debugging.
- Analysis of production trouble tickets.
- Maintaining the existing system and carrying out the necessary changes as and when requiredour team representative in Europe by conducting conference calls, MSN messenger or mails bases on the urgency.
Description
Organization: Accolade systems
Project Name: GEMS–Global Enterprises Management System
Client: Al-Ghurair Unisys Dubai
Description: The Project involved New Development, maintenance of Informix
Database applications and Database.
Responsibility:
- Al-Gurair in software consultancy business as a part of their group of business. They provide the support for their own developed ERP called GEMS (Global Access Management System) for more than 25 clients around UAE.
- Joined as Analyst Programmer mainly to work on New projects “Migration / Conversion of source application from 4GL to D4GL. Apart from the above project, I was also involved in upgrading software modules and reports. User Support, maintenance for the modules like Inventory, Purchase & Maintenance, Payroll, Admin-Training, Production, Marketing & Sales.
- I have been involved in attending the customer tickets and done lots of enhancements and developed new programs as per the client tickets.
- Involved in database design, analysis, coding, unit testing and peer testing.
- Preparation of documents for requirements, design, unit test cases, system test cases, user acceptance test cases etc.
- Conducting reviews for design, coding, test cases.
- Coding and Error debugging.
- Analysis of production trouble tickets.
- Installing the enhanced or new application at client site.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- conference calls, MSN messenger or mails bases on the urgency.
Description
Organization: Kirloskar Ferrous Industries Limited
Project Name: Total ERP - In House Development
Client: Kirloskar Ferrous Industries Limited
Description: The Project involved New Development, maintenance of Informix Database applications.
Responsibility: KFIL is an Iron/Foundry production company.
- Joined as Graduate Trainee. The In-house ERP (IIS – Integrated Information System) was being implemented during my joining time. Initially I was a team member for Inventory and Payroll module and later I was involved in Purchase, Production and marketing modules.
- Involved in database design, analysis, coding, Error debugging, testing or complete implementation of various applications on the entire above module.
- Installing the enhanced or new application at client site and educate the user about their respected applications or modules.
- Maintaining the existing system and carrying out the necessary changes as and when required.
- One of the major role was on implementation of “Recording the Attendance of employees” which was a new module and it was not part of the existing ERP. The each and every swap will be recorded and being used to calculate the employees salary and deducting the wages of the employees based up on management reports which calculates the “Late Come and Early Go”
- Involved in routine DBA activities like Taking Logs, Backup, update statistics, analyzing the queries and few of the times associated with senior DBA while restoring the Database when it was crashed.
- Material Management System involved the following Modules:
# Purchase module
# Process Receipt
# Process Issues
Purchase Module contains Masters like item master, Vendor Master, Parameter Master where discount, tax etc., Parameters Handling, Purchase Department Requisitions and Indents Master. Transactions like Creation of Requisition, Creation of Purchase orders & Corresponding Reports.
Process Receipt module contains transactions as Goods received receipt, Physical Inspections, Quality inspection & after Confirmation of the receipt the Stock is updated for the concerned Store, bin & Corresponding Reports
Process of Issue module contains transactions like Indents from Dept, Indent made on issue, Stock Transfer. Stores Entry Cancellation, Discrepancy note printing, Department-wise Issues, Stock Valuation Reports, Inventory card printing system, Indent printing (ISO format), Returnable Gate pass, Non-returnable Gate Pass, Work order etc.
- Attendance, Payroll, HRD Training :
Creation of Master, Transactions & Reports related to Attendance Recording System (Punch card), Various Statements (wages days, incentive days, OT Days, late & early punching) for calculation of monthly payment of the employees.
Training Programs Schedule & completion for Management Staff & Worker Staff. Payroll Activity (Pay calculation, Income tax calculation, short recovery), Monthly Various Statements (Absentism, Strength). Payroll Activity (yearly activity like form 16, Form 23, form-3a, form-6a, Super Annuation) etc.
- Foundry Production:
It involves Master, Transactions & Reports related to Foundry Production Casting, Core Master, Machine Utilization, Production, Rejections at various stages like prod, fettler, QA etc, Foundry stock reconciliation, Foundry Variable Cost, Employees’ efficiency as per the user requirements, etc
- Marketing & Sales
It involves Master, Transactions & Reports related to Quotation from Customers, Order Acceptance, Dispatch Instruction, Invoice Creation Transaction, Sub-Contractor dispatches and billing, Sales plan and reports like, Daily dispatch report, Sales report etc.
Apart From the above projects, I was also involved in Upgrading Software Modules User Support, maintenance for the modules like Inventory, Purchase , Payroll, Admin-Training, Production, Marketing & Sales & Furnishing Confidential Reports to the top-level Management as well as MIS reports.
Show More Show LessDescription
As part of the project, I had been assigned to enhance into Outbound Maintenance modules where new payer account and payer country code is introduced in billing system. The effected modules for Outbound are Maintain Outbound Shipment, Invoice/Cash Adjustment, Logistic Service Charge, Outbound Periodic Fee (Non Shipment Fee). Introducing new Global Mail house zone product and allow only mail zone destination for outbound shipments.
Show More Show LessDescription
The Data patching project is to correct and enhance the existing module and its supporting functions. Based on the user feedback, finding out the bug, fixing security issues and improving the usability or performance. It also includes redesigning poorly designed application, New Development, enhancements, maintenance of Informix Database applications
Show More Show LessDescription
Involved in getting projects/module of projects from different clients across Bangalore. Preparation of System Design Specifications, Technical Design Specification for development team and coding if required. Assisting project management team for strategic planning, team building, Talent acquisition. Getting the report for unit test cases, system test cases, user acceptance test cases for individual projects from development team. SDLC (Software Development Life Cycle) i.,e from the process of getting the user requirement to till the process of installation at UAT environment. Coordinating with clients on their escalations / requirements. Allocation and prioritization of jobs among team members. Responsible for team daily time and task sheet, Project Status Report to the Management.
Show More Show LessDescription
The Phase 2 project will provide automatic refund on outstanding PPS/JETCO payment received over 3 months. Some new reports are also designed to help PA and FIN departments to handle the refund process effectively and efficiently. The Project involved New Development, enhancements, maintenance of Informix Database applications, VB front applications and Database
Show More Show LessDescription
The Project involved New Development, maintenance of Informix Database applications and Database. Al-Gurair in software consultancy business as a part of their group of business. They provide the support for their own developed ERP called GEMS (Global Access Management System) for more than 25 clients around UAE. Joined as Analyst Programmer mainly to work on New projects Migration / Conversion of source application from 4GL to D4GL. Apart from the above project, I was also involved in upgrading software modules and reports. User Support, maintenance for the modules like Inventory, Purchase & Maintenance, Payroll, Admin-Training, Production, Marketing & Sales.
Show More Show LessDescription
The Project involved New Development, maintenance of Informix Database applications. KFIL is an Iron/Foundry production company. Joined as Graduate Trainee. The In-house ERP (IIS – Integrated Information System) was being implemented during my joining time. Initially I was a team member for Inventory and Payroll module and later I was involved in Purchase, Production and marketing modules. Involved in database design, analysis, coding, Error debugging, testing or complete implementation of various applications on the entire above module. Installing the enhanced or new application at client site and educate the user about their respected applications or modules. Maintaining the existing system and carrying out the necessary changes as and when required. One of the major role was on implementation of Recording the Attendance of employees which was a new module and it was not part of the existing ERP. The each and every swap will be recorded and being used to calculate the employees salary and deducting the wages of the employees based up on management reports which calculates the Late Come and Early Go Involved in routine DBA activities like Taking Logs, Backup, update statistics, analyzing the queries and few of the times associated with senior DBA while restoring the Database when it was crashed. Material Management System involved the following Modules: # Purchase module # Process Receipt # Process Issues Purchase Module contains Masters like item master, Vendor Master, Parameter Master where discount, tax etc., Parameters Handling, Purchase Department Requisitions and Indents Master. Transactions like Creation of Requisition, Creation of Purchase orders & Corresponding Reports. Process Receipt module contains transactions as Goods received receipt, Physical Inspections, Quality inspection & after Confirmation of the receipt the Stock is updated for the concerned Store, bin & Corresponding Reports Process of Issue module contains transactions like Indents from Dept, Indent made on issue, Stock Transfer. Stores Entry Cancellation, Discrepancy note printing, Department-wise Issues, Stock Valuation Reports, Inventory card printing system, Indent printing (ISO format), Returnable Gate pass, Non-returnable Gate Pass, Work order etc. Attendance, Payroll, HRD Training : Creation of Master, Transactions & Reports related to Attendance Recording System (Punch card), Various Statements (wages days, incentive days, OT Days, late & early punching) for calculation of monthly payment of the employees. Training Programs Schedule & completion for Management Staff & Worker Staff. Payroll Activity (Pay calculation, Income tax calculation, short recovery), Monthly Various Statements (Absentism, Strength). Payroll Activity (yearly activity like form 16, Form 23, form-3a, form-6a, Super Annuation) etc. Foundry Production: It involves Master, Transactions & Reports related to Foundry Production Casting, Core Master, Machine Utilization, Production, Rejections at various stages like prod, fettler, QA etc, Foundry stock reconciliation, Foundry Variable Cost, Employees efficiency as per the user requirements, etc Marketing & Sales It involves Master, Transactions & Reports related to Quotation from Customers, Order Acceptance, Dispatch Instruction, Invoice Creation Transaction, Sub-Contractor dispatches and billing, Sales plan and reports like, Daily dispatch report, Sales report etc. Apart From the above projects, I was also involved in Upgrading Software Modules User Support, maintenance for the modules like Inventory, Purchase , Payroll, Admin-Training, Production, Marketing & Sales & Furnishing Confidential Reports to the top-level Management as well as MIS reports.
Show More Show Less