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.

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

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

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.