Role: Technical Support

1. ERP support engineer for customers like The Saturday Club Ltd, Out ram Club, Punjab Club Limited

2. An efficient single point contact for all customers and responsible for providing solution on behalf of Clubman ERP

3. Providing & executing solutions for new requirements

4. Post implementation support for some customers

5. Supporting clients during annual audit, reconciliation of audit reports like aging, ledgers & statements

6. Given the responsibility of supporting The Saturday Club post implementation. It was a multi server architecture which was stabilized with timely & effective support

7. Accountable for handling daily issues reported by customers and providing solutions

8. Development of MIS reports, statutory reports using MS SQL 6.5/7 and ClubmanERP report writer tool

Role: Party Module Development /Software technical Consultant – Projects & Support

Project: The Bengal Club Ltd

Clubman  an  ERP  Systems  is  wholly  owned  subsidiary  of  CHS  Solution  Pvt.  Ltd,  India  having  business  in  ERP development,   implementation,   personalized   software   development,   business   intelligence,   systems   integration   and networking

1.  Playing  role  of  functional/technical  resource  in  ERP  implementations  for  ERP  modules  - Project  activities  include: Scope study, preparation of Project charter, Project Plan, documents in the areas of Requirement specification, Test plan, Training, Project status reports. Managed the deployment through User acceptance testing, User training, data migration, live server setup, post live support

2  Reviewed  project  status  reports  during  each  operational  phase  and  prepared  weekly  project  status  reports  for management

3. The development was done with VB.NET and MS SQL 2008

4. Product Appreciation & Hands on training to users for installed modules

5. Technical activities involved upload of master data using MS SQL Server, development of MIS reports

6. Live Run and post live support

MS SQL Server & Devexpress dashboard –Software Developer. Industry Construction &Textile ERP– Software

Professional Experience

The iRent ERP & Apparel Connect ERP program is developed for Construction &Textile Industry.

* Database Objects like Tables, Stored Procedures, Views, Defaults, user defined    data types and      functions for this project.

* Implemented database standards and naming convention for the database objects.

* Developed DTS packages to extract, transform and load Begin with SSIS.

* Working with T-SQL programming and using SQL Profiler.

* Working on Devexpress & Crystal report and using MSSQL Server 2008/R2.

Environment : Data Transformation Services (DTS), SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2017, Windows Server 2012 R2

Role & Responsibilities:

· Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.

· Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.

· Creating jobs for scheduling the SSIS packages.

· Getting data from different data sources.

· Loading these data into data warehouse like sql server.

· By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.

· Identifying of performance bottlenecks, Performance tuning of packages.