Now you can Instantly Chat with RANJIT!
About Me
Over last SIX years as DB developer/Technical Manager (Total 14 years plus as Business Application Developer) having Hands on experience in developing, Testing, maintaining and Enhancement of the database application. Detailed understanding of Mainte..., Testing, maintaining and Enhancement of the database application. Detailed understanding of Maintenance activities, QMS processes and Good knowledge of SDLC lifecycle (analysis, design, development, implementation, integration and testing) and Methodologies preferably Agile Eight years as Client /Server (PowerBuilder and various DB as back end) developer. Responsible for development, support, maintenance and implementation of a complex project module Experience to perform all cycles of the development (analysis, design, coding and unit testing) projects Five Years, as ORACLE PL/SQL and MS SQL Server T-SQL developer/production Support. Knowledge of Data warehousing concepts (ETL/ CUBE/DIMENSION/ SCHEMA) Basic UNIX shell scripting Good expertise in software development in client/server technologies, Using Leading RDBMS and PowerBuilder (PFC based Framework), Developer/ 2000 and Oracle PL/SQL. Orchestrated complex systems and business rules. Demonstrated a deep understanding of PB/DB technology Provide technical expertise in identifying, evaluating, and developing effective procedures and systems requirements that meet business requirements. An innate ability to bring people together Exposer to Logistics Solutions & Supply Chain Management Experience in developing and implementing Enterprise resource Planning (ERP- Order Management, Material Management, HRMS, Supply chain Management, Inventory Management, Logistic Management) solutions. Knowledge of Oracle EBS-Purchasing process. Knowledge of SAP-SD(Trained) Modules process/Flow (Inquiry/Quotation/Order Acceptance/Delivery/ Billing/ Invoice doc etc). Worked for SEI CMM Level 5 Company in overseas and INDIA. Good domain knowledge of business processes in manufacturing Industries, SCM ,HRMS, US HealthCare(Patients, payers, providers ) Domain and General Retails. Energy & Utility (Upstream, Downstream), Asset Managements and Benefits Fund Managements Involved in the development of test cases and executing the test cases. Strong comprehension, analytical and problem-solving Programming skills Good in Data Analysis for decision making by the business. Extensive technical experience and strong programming knowledge in Oracle 12c using SQL Developer, PL/SQL Developer and Toad Experienced in writing back end interfaces using PL/SQL , Packages, Stored Procedures, Functions, Indexes, Views, Exceptions and Advanced Features Bulk Collect, Forall, CTE ,Merge, Materialized View etc. Expertise in use of Cursors, Ref cursors and Collections. Knowledge in Logical Database Backup and Recovery using Export/Import Utility Ability to understand Functional Requirements and Design Documents. Understand relationship across multiple applications Good experience with CRUD (Create, Read. Update & Delete) data cycles. Scheduling various automated JOB. Monitoring various JOBS Ability to work in Offshore/Onsite model and Offshore co-ordination skill Provided training on PowerBuilder V12.5 Data Migration Exposed: Requirement analysis with Client. Analysis the source data from legacy system dump. Migration Process analysis and define the migration strategy. Analysis output table details and define the validation rule. Implementation of business logic. Generate script and output data.
Show MorePortfolio Projects
Description
SWELOG is a business system most suited for companies of production in the manufacturing industry. One System for Your Entire Company. It includes the Complete ERP Modules as Order Management, Real-time Inventory Visibility. Complete Procure-to-Pay Purchasing, HCM &, Manufacturing Operations including Quality and Plat Maintenance. Automatic Order Generation depending upon Manufacturing Order, Waste Calculation. Finance module includes all financial functions incl. Accounts Payable, Accounts Receivable, Payments, Voucher Generation, Cash Management, Financial Accounting, Financial Budgeting etc.
Show More Show LessDescription
Enterprise System for Projects and Fixed Assets Modules include Budgeting, Funding Projects,Assets management (Fixed Assets and Capital Assets), Tax (Power Tax), work order Management, Depreciation. The System also has Datawarehouse like Charge Repository Module. This system also has inbound and outbound interface with ORACLE ERP, PEOPLESOFT HRMS and IBM Maximo Enterprise System.
Show More Show LessDescription
The Lomis applicstion is an in-house developed system for SIDF (Saudi Industrial development fund). SIDF is one of the reputed government bank in Saudi Arabia. Lomis application is help to maintain and keep track of industrial sector to see the growth of industrialization in Saudi Arabia. Application helps to maintain details about investors and their follow up fees. Help to find Progress in Number of Factories, Investment and Number of employees, industrial production, and industrial exports. Easy to generate relative report.
Show More Show LessDescription
It keeps and maintains record of all employees and their history. Its easy for HR to operate and process salary. Flexible to maintain overtime salary, housing allowance, transportation allowance, increment etc. Linked with attendance system and calculate overtime and penalties.
Show More Show LessDescription
InfoCare serves as the pre-enrollment, annual fulfillment and reconciliation system for Government Programs Medicare Advantage Plans (Keystone 65, Personal Choice 65 and Amerihealth 65). Additionally, InfoCare supports the Medicare Discount Drug program for these plans and will also support Amerihealth 65 PA. An interface has been built with SMS (Systems Management Specialists), a vendor for CMS (Center for Medicaid and Medicare Services, formerly HCFA), to submit enrollment, plan change, and disenrollment transactions. Based upon the CMS response, letters are created for the members and where appropriate, the members are sent to MHS via EDI. Every year, the annual fulfillment sub-system is used to track and update benefit changes for groups and to notify benefit administrators and members of the changes to their benefits. Finally, Info Care is used to reconcile membership, status and demographic factors between CMS and our enrollment systems.
Show More Show LessDescription
XCELYS is the Health Plan Core Administration Software for Healthcare Payers market. Xcelys is a powerful enterprise-wide core administrative technology that enables major insurance organizations to collect, process, exchange, organize, and retrieve important member, provided, authorization, capitation, billing, and claims data, ranging from member eligibility to provider contract demographics and claims experience. Identifies member eligibility for claims processing, prices claims based on prior arrangements (group or provider), controls payment based on authorization and benefits and administers complex payer arrangements. Xcelys is implemented at over 50 Healthcare accounts in USA and also in other countries.
Show More Show LessDescription
General Retail, a part of the GERS Electronic Retail Enterprise, accurately and effectively manages, directs, records, and optimizes, in real time, the vast number of merchandizing, distribution, and financial transactions that are essential for success in todays retail marketplace. General Retail is used extensively for Cash and Carry Products in the Retail Marketplace. GERS Electronic Retail Enterprise includes mission-critical transaction management applications for multi-channel retailing, and provides fully integrated corporate office applications for merchandise replenishment and allocation, distribution center management, and financial control. Integral to the GERS solution set Merchandise Planning and Allocation tools for increasing returns on inventory investments, and Supply Chain solutions for streamlining communications and maximizing productivity across the enterprise.
Show More Show LessDescription
SCMI is collection of web-based services used to managed GE Supply chain information and procedures. A key component is a wizard based approached to asset Management. This project provides the user with access point into SCM activities and present the activities in a logical manner that guide the user to perform a task.
Show More Show LessDescription
- Systems environment : Windows 7, Power Builder V12.5, PFC,, Oracle11g (PL/SQL). UNIX, Toad.
- Synopsis:
- Enterprise System for Projects and Fixed Assets Modules include Budgeting, Funding Projects,Assets management (Fixed Assets and Capital Assets), Tax (Power Tax), work order Management, Depreciation. The System also has Datawarehouse like Charge Repository Module.
- This system also has inbound and outbound interface with ORACLE ERP, PEOPLESOFT HRMS and IBM Maximo Enterprise System.
Description
Project #3
- Industrial License DB Management System.
Add new License Record.
Amendment /Modify the License Record.
Purge License Record.
Enhance user Data entry experience.
Role:
· Programming & Development and Unit test
Tools:
· PowerBuilder 12.5, MS-SQL 2008
- Lomis Application(Banking Domain) -
Role:
· Programming & Development
Tools:
· PowerBuilder 12.5, MS-SQL 2008
Details:
· The Lomis applicstion is an in-house developed system for SIDF (Saudi Industrial development fund). SIDF is one of the reputed government bank in Saudi Arabia.
· Lomis application is help to maintain and keep track of industrial sector to see the growth of industrialization in Saudi Arabia.
· Application helps to maintain details about investors and their follow up fees.
· Help to find Progress in Number of Factories, Investment and Number of employees, industrial production, and industrial exports.
· Easy to generate relative report.
- Payroll System (HR Domain) –
Role:
· Programming & Development
Tools:
· PowerBuilder 12.5, MS-SQL 2008
Payroll System:
· It keeps and maintains record of all employees and their history.
· It’s easy for HR to operate and process salary.
· Flexible to maintain overtime salary, housing allowance, transportation allowance, increment etc.
· Linked with attendance system and calculate overtime and penalties
Show More Show LessDescription
InfoCare serves as the pre-enrollment, annual fulfillment and reconciliation system for Government Programs’ Medicare Advantage Plans (Keystone 65, Personal Choice 65 and Amerihealth 65). Additionally, InfoCare supports the Medicare Discount Drug program for these plans and will also support Amerihealth 65 PA. An interface has been built with SMS (Systems Management Specialists), a vendor for CMS (Center for Medicaid and Medicare Services, formerly HCFA), to submit enrollment, plan change, and disenrollment transactions. Based upon the CMS response, letters are created for the members and where appropriate, the members are sent to MHS via EDI. Every year, the annual fulfillment sub-system is used to track and update benefit changes for groups and to notify benefit administrators and members of the changes to their benefits. Finally, Info Care is used to reconcile membership, status and demographic factors between CMS and our enrollment systems.
Show More Show LessDescription
InfoCare serves as the pre-enrollment, annual fulfillment and reconciliation system for Government Programs’ Medicare Advantage Plans (Keystone 65, Personal Choice 65 and Amerihealth 65). Additionally, InfoCare supports the Medicare Discount Drug program for these plans and will also support Amerihealth 65 PA. An interface has been built with SMS (Systems Management Specialists), a vendor for CMS (Center for Medicaid and Medicare Services, formerly HCFA), to submit enrollment, plan change, and disenrollment transactions. Based upon the CMS response, letters are created for the members and where appropriate, the members are sent to MHS via EDI. Every year, the annual fulfillment sub-system is used to track and update benefit changes for groups and to notify benefit administrators and members of the changes to their benefits. Finally, Info Care is used to reconcile membership, status and demographic factors between CMS and our enrollment systems.
Show More Show LessDescription
Redefining Retirement Administration. V3 Supports Defined Benefit, Defined Contribution and Tax Deferred Annuity Processing. V3 for Retirement is a fully integrated, highly scalable solution suitable for use by public pension funds. Address a full spectrum of requirements including enrollment, payroll reporting, contributions processing, benefits calculations and benefits payroll. It maintains all transaction details such as pension application, Contribution, Agreements and Disbursements for Trust members.
Show More Show LessDescription
The GAC Group is a privately-owned company, specializing in the delivery of high quality shipping, logistics and marine services to customers worldwide. GAC has got your freight forwarding needs covered with our comprehensive freight and logistics services by sea, by air and by land. GML wants to deploy an order management and tracking system portal which should helps its user to place order on the portal and keep track of the same while the transactions are in progress.
Show More Show LessDescription
The EMPAC System helps manage and maintain your companys asset Care activities. This is a complete Asset Management System. EMPAC systems not only include traditional maintenance of machine Activities but also resource, inventory and procurement operations. You can access information from all these process whether the data is related to cost, personnel, asset or inventory.
Show More Show LessDescription
Portal Service is an Intelligent Network (IN) in telecom Service. This is an access window of Different intelligent Network services. The Telecom Operator inputs all the necessary data, which are required by the portal service logic to execute .It also maintains a database for the all the telecom services provided by a telecom operator like China telecom and China Unicom. It gives the detail of cash IN Services. List of Module 1. Configure Portal service 2. Configure IN services 3. Configure Subscriber Details 4. Configure Multi language support 5. Call statistical log maintenance
Show More Show LessDescription
MRP system is aimed at assisting the planner to order for the right Quantity at the right time to ensure that the production process is smooth and efficient with the minimum inventory and minimum delay in Procurement and maximum efficiency. This system has features for multi level BOM creation, purchase order scheduling, substitute item issue, sub assembly ordering, supplier wise, schedule wise pending orders etc.
Show More Show LessDescription
This software is a comprehensive material management software package addresses the need of Automation of complete material handling Process- Material and information flow mapping. Improving organizational responsiveness and speed by managing capacity constraints and reducing work-in-process. It maintains all business information that is essential in a Manufacturing organization for all materials management functions such as purchase ordering, inventory control, stock transfers, GRN, ISSUE, QC etc.
Show More Show LessDescription
This is a Very important Tool for the HR department of the company. It brings the benefits of automation of Information Management system for HR team in a company. It builds a Database about the Companys most valuable asset- the employees. It is a integral part of payroll Processing system.
Show More Show LessDescription
This module of ERP is simple yet powerful software, which takes care of the complete cycle of Fixed Assets management of an organization. It encompasses depreciation calculations, location, additions, deletions and transfer of assets. The software generates comprehensive reports Required for preparing schedule of assets, depreciation reports, capital work in progress etc.
Show More Show LessDescription
Part Disposition Order is an Inspection Document raised by Inspection Department for giving disposition or decision for necessary repair /servicing/ scraping as stipulated in the servicing schedule. Whenever defect or a deviation is observed in any system of an aircraft a snag sheet is issued to shop and production engineering for rectification of the snag and refers the system to inspection. In case this involves a component change, a part disposition order (P.D.C) is raised for Carrying out necessary Repair/Rework/Servicing or for Rejection.
Show More Show LessDescription
S.F.M. is one of the modules for MRP-II solution. The main objective of this module is effective utilization of machine and labour. It prepares Job Schedules for the technicians and set the priority of his jobs. It captures the updated information on shop activity on site. SFM is responsible for keeping records of actual standard man-hours taken on each operation and machine breakdown details. SFM generates typical reports and enquiries on different work Center and workers.
Show More Show LessDescription
The work in progress Monitoring system is an integrated part in Manufacturing company. This system helps to assess the current status of any Routable Parts under service in a shop (work centre). It monitors the different tasks under progress in three agencies-the Airframe Methods, Airframe Progress, Accessories Shop floor. Input is taken from Parts disposition order (P.D.O), Advice Job cards. Parts Requisition Sheet, progress card. This module maintains data regarding the different activities in the above three agencies and give reports of different categories of jobs carried out at different levels.
Show More Show LessDescription
It is sub-module of Order Processing System (ORP). Product support and Sales Dept primarily do Marketing and Sales support. The Sales Department releases a Sales Order based on which the production Engineering releases a Work Order. Based on which the following tasks had been accomplished using Oracle 7.0 as RDBMS Packages. This module assumes special significance as this is a basic unit to various departments like material planning of adequacy exercises shop floor and methods engineering for carrying out jobs and withdrawal o materials based on the work order. This also gains a special significance as it helps the Accounts Dept. in billing by giving the job card numbers assigned for each of the parts which has come for the overhauling through which no. Of man hours used on that part can be calculated a hence the chargeability.
Show More Show LessDescription
It is sub-module of Order Processing System (ORP). The Sales Department releases a Sales Order based on which the production engineering releases a Work order. Based on which the following tasks had been accomplished using Oracle 7.0 as RDBMS Packages. This module assumes special significance, as this is a basic unit to various departments like material planning of adequacy excises shop floor and methods engineering for carrying out jobs and withdrawal of materials based on the Work Order.
Show More Show Less