CRMS Stand for Core Resource Management System. It is a Trademark product of Fresche solutions, Fresche is the leading provider of ERP application, application modernization and management solutions that enable digital transformation for companies that rely ERP product. Our added value products and services bring clients the best, boldest ways to modernize and better manage their business and IT. Fresche helps them fuel transformation and growth, improve their productivity and competitiveness while reducing the risks. Fresche has a wide network, with more than 400 Employees worldwide.

Headquartered in Canada, the company has offices in United States, as well as Europe.

CRMS is a time tested total ERP solution which can be used to automate all the core function of an organization like sales, Procurement Stock management, accounts management, HR management, Production and Planning Control, Engineering, Quality, Payroll, Maintenance ETC. CRMS has been successfully Customized and implemented in numerous reputed Auto and Sugar organizations.

An ERP system is an attempt to integrate all functions across a company to a single computer system that can serve all those functions’ specific needs.

CRMS is web based or Desktop based product. Which can be implemented on premise and Cloud both, due to these features it is capable to provide accessibility anywhere.

It is developed in Oracle Fusion Middle Ware and Oracle Apex. Which is provide the complete range of report to higher management according to requirement with graphical representation.

• Customer and team interaction.
• Team Handling.
• Documentation writing and presentation.
• Database structure planning and creation, triggers, Procedures, Package, Functions and SQL scripts.
• Query optimization and tuning.
• Technical support at DB Level to development team.
• Development and enhancement as per customer requirement.
• Report Development, query writing and tuning.
• Application Development in fusion Middle ware.

This Project also comprises of modernization from RPG to JAVA web application using new Java Technologies. The initial transformation is carried out by modernization tool like XDB Tool. Challenge is to write up code for CL program in DB level with the same functionality as in RPG, tweak the code to make it in runnable state and also provide implementation for unknown scenarios. Mostly involve in transformation of CL Program in Java with the same functionality as in IBMi as well as DB.

Also we deeply support to application development Team to understand the code at DB level and interaction to according.

Second part of this project was the report generation. In which RPG code, should be convert to oracle DB level code as same IBMi.

• Initially, Data Base migration through XDB tool. And then code correction and change as per requirement of client and application.
• Customer and team interaction.
• DB Team Handling.
• Documentation writing and presentation.
• Database Modelling, planning and creation, triggers, Procedures, Package, Functions and SQL scripts.
• Query optimization and tuning.
• Technical support at DB Level to development team.
• Development and enhancement as per customer requirement.
• Report Development, query writing and tuning.
• Data policy and Roadmap.

Credit Suisse Group is a Switzerland-based multinational financial services holding company; headquarter in Zurich that operates the Credit Suisse Bank and other financial services investments.

The company is organized as a stock corporation with four divisions: Investment Banking, Private Banking, Asset Management, and a Shared Services Group that provides marketing and support to the other three divisions.

BMR is basically a data mart where STAR application and other private banks acts as upstream and reporting tool such as AXIOM and OBIEE acts as downstream. BMR is used to harmonize the data from different upstream STAR and EMAR. This harmonized data is going as input to downstream.

• Customer interaction and Requirement analysis.
• Team Handling.
• Documentation writing and presentation.
• Writing Database triggers, Procedures, Package, Functions and SQL scripts.
• Query optimization and tuning
• Technical support to development team
• Creating Control-M jobs and manipulating existing one.

Development and enhancement as per customer requirement.

The Department of Excise and Taxation, Government of Punjab, looks after the activities of Excise, Value Added Tax and other commercial taxes in the state. The Project aims at improving the existing IT infrastructure for facilitating all types of department activities as part of the VAT/ Excise administration, thereby facilitating all the concerned stakeholders. By using Technology as a key element of citizen service delivery and Identification of various e-Governance initiatives that can alter the way services are delivered has been the cornerstone of all recommendations for the proposed Project.

As a lead, I have handled some critical Module of this application for Punjab government like Dealer Registration, Returns Processing, Payments, Refunds, ICC (Information Collection center) and specially Excise module.

I have implemented and run successfully excise policy, VAT, Return, ICC refund module etc.

• Customer interaction.
• Support Team Handling.
• Documentation writing and presentation.
• Writing Database triggers, Procedures, Package, Functions and SQL scripts.
• Complete Excise Module Implementation and improvement.
• Query optimization and tuning.
• Technical and functional support to development team.

Implemented and developed the application for the data migration & synchronization between old application (COVIS) and new Wipro application (COTIS) in real time. These applications communicate between two different data base and different business logic application and provide the real time data in both application as per logic and requirement. So that both applications can be run parallel.

That task was very challenging which had accepted by me, and post completion of that task I got an appreciation for this from Punjab government. I had developed and design the oracle application framework in a very less time. Which provide the mechanism to communicate both database in real time and both application user can get the real information and had work on the parallel in both application.

• Understanding database and application functionality.
• Data Migration & Synchronization framework designing.
• Writing Database triggers, Procedures, Package, Functions and SQL & advance SQL scripts.
• Maintaining Data Migration & Synchronization framework application.
• Data validation in both application.

Developing COVIS (Computerization of VAT Information System) for ETTSA, Patiala (Punjab).This application is designed for VAT System. This application covered 20 different modules: TSO, Person Management, Returns, Annual Statement, Assessment, Recovery of Arrears, Appeals to appellate authority, Refund, Treasury, ICC, Forms Inventory Management, Entertainment, Public Account Committee, Excise, Audit, Casual Traders, Revision, Rectification of mistakes, Determination of Disputed Question and Investigation. 10 (Ten) modules (Global, Front Window, Dealer Management, ICC and Treasury, Return, Assessment, Refund, Arrear and Excise) out off 20 modules are implemented and running successfully, All modules are integrated. Head Office and all District Offices and ICC’s are linked through leased-lines and V-SAT to a central RISC server. Nearly 1000 users of the system at 92 locations access central server.

A COVIS application is designed and developed in client/server architecture. Applications is deployed on application server the database (oracle 9i) lying on different database server. COVIS application runs in CITRIX environment. Each user access its own modules as per there privileges. Application is designed in D2k (Forms 6i, Reports 6i).

As a Sr. Developer, during this tenure i have participate in many application development and maintenance which were assigned to me by client. Like e-Excise, ICC, E-Filing (VAT Return) etc.

• Understanding business logic for customization.
• Writing Database triggers, Procedures, Package, Functions and SQL & advance SQL scripts.
• Designing New forms in form 6i & reports in report 6i as per enhancement
• Managing documentations as RFF, EDD etc.
• Managing & implementation of COVIS application.
• Customer interaction.
• Support Team Handling.
• Documentation writing and presentation.
• Query optimization and tuning.

TERMS as their flagship products and TERMS is a time tested total ERP solution which can be used to automate all the core function of an organization like sales, Procurement Stock management, accounts management, HR management, Production and Planning Control, Engineering, Quality, Payroll, Maintenance ETC. EMS has been successfully Customized and implemented in numerous reputed Auto and Sugar organizations, Minda Industries Maneser, Minda Industries Wazirpur, Minda HUF (Electronic City), Minda HUF Pune, Minda Industries Hosur (Bangalore),Mars Industries Ltd .Gorgon ,Elofic Filter Faridabad ,Maxop engineering (P) Ltd. are few of the corporate giants where EMS and TERMS is Running successfully.

Customized and develop an ERP system targeted for the Maxop Engineering (P) Ltd. Manesar

Conducted on-site Customization, defined client business needs, gathered requirements and delivered technical strategies/ solution for the system implemented. Designed, customized and developed Payroll, sales Module, Material, production, PPC, finance, Tool & die, maintenances, quality, security etc.

• Understanding business logic for customization.
• Writing Database triggers, Procedures, Package, Functions and SQL & advance SQL scripts.
• Designing New forms in form 6i & reports in report 6i as per enhancement
• Managing documentations as RFF, EDD etc.
• Managing & implementation of TERMS application.
• Customer interaction.
• Support Team Handling.
• Documentation writing and presentation.
• Query optimization and tuning.