Josmy Jose

Email: adn7fz@r.postjobfree.com

Kuwait:+965-********

Professional Summary

A passionate software developer with thirteen years’ experience in coding & development (.Net Framework), with diverse knowledge in multiple modules (purchase, Sales, HR, Finance & Inventory) and a good understanding of Databases & BI, (SQL, MYSQL, Jasper-BI, Tableau, Power BI with R, Excel VBA. ) help me to make a new tool & decision-making reports for the business.

Highlights

Work Experience

External Activity

• Closely working with the Clients to understand their requirements and current business model for each

department

• Understand their current issues and the expectations from each department

• With excellent analytical skill, developing a model which the client needs

• Once the model approved, developing the project or tool in the required platform

Internal Activity

• Closely working with the Project Manager related to the cost & delivery time factor.

• Closely working with the Bidding & PCS department on factors related to project cost and on the previous records of data sets.

• Closely working with the across internal department

(Operation, Finance, Sales, HR and other Depts.) to identify the new data sets and to link a bridge among all department for generating a new report for taking decision.

• Working closely with the team to develop the product as per the requirement.

Skills

• Strong work Ethics

• Organized

• Passionate

• Technical

• Client relation.

Training

• Training on Advanced Excel with VBA

• Training on Power BI, Tableau, Jasper BI, R

• Training on Dynamics 365 CRM with Power Apps

• Training on SQL server & .Net (C#, ASP .NET)

IT Skill Set

• Languages: Visual Studio 2019, 2017, 2013, 2010, 2008

.NET (C#.NET, ASP.NET, MVC, VB.NET, XML), R

Language, JavaScript, jQuery, HTML, Excel VBA

• Database: SQL Server 2019, SQL Server 2016, SQL 2014, SQL Server 2012, 2008-R2, SQL 2005, SQL 2000, MY

SQL, Oracle

• Reports: Crystal Reports, i-report (TIBCO Jasper-BI), Power BI, Tableau, & MS Excel with VBA

• Tools: Ajax, Bootstrap, CSS, PowerApps, Data

Warehousing with Erwin Tool, Java Script, jQuery, Json

• Knowledge in CRM & ERP: Microsoft dynamics 365,

Quadra Lite, Pinnacle, Fish Bowl.

Academic Qualification

• Master’s in Computer Application (MCA)

ST. Berchuman’s College, Changanacherry (India)

Graduate: 2004

• PGDCA

S D College, Alleppey (India)

Graduate: 2001

• Bachelor of Science

ST. Aloysius College, Alleppey (India)

Graduate: 2000

Personal Details

• Kuwait Residency Visa – 18 Transferable

References

• Available on Request

Job Role in Visual studio.Net

• Experience with the full software development life cycle (SDLC)

• Developing and customization of Web-based ERP

solution based upon cases and client request form.

• ERP product I was involved in development and

customization

a) Al-Morooj: In house inventory & pricing tool

development.

b) Quadra Lite: For Construction Industry

c) Pinnacle financial & HR Software: For Banking

& HR Industry

• Apart from ERP, involved in Multiple e-commerce

projects, and inhouse tools.

Job Role in Database & Reports

• Domain expertise in multiple departments like (Sales, Purchase, Finance, Inventory, Logistic & HR) which help different departments, people, to synchronize the work and to further analyzing their work to get

maximum output for the company.

• Creating Customized Reports for business evaluation. Like paginated reports with drill-down, drill-through and cascaded parameters for analyzing the past

performance in specified business regions or for the specified department

• Hands-on experience in creating, scheduling, and rendering visually rich and intuitive Data Insights using SSRS and Tableau, Power BI, I-reports (Jasper Reports).

• Experience in software configuration management

using tools like VSS.

• Creating Tables and sub tables based on the use cases and project needs.

• Creating SQL stored procedures, table, valued

functions, triggers, and views using base tables with indexes, constraints, joins, grouping sets, window functions, set and pivot operators, SQL queries, XML procedures w.r.to the need of requirements.

• Exceptional SQL scripting and debugging skills

including DDL, DML, DCL, and TCL in SSMS

• Experience in installing, configuring, and upgrading SQL Server versions.

• Extensively used DDL, DML & TCL statements for

defining, accessing, and manipulating transactional systems.

• Configured Linked Servers to access multiple SQL Server.

• Developed SSRS canned reports for customer

segmentation based on the size of the organization, gross income, and other parameters with filters, drill down, drill through and table calculations.

Current Responsibilities

• Closely working with the Operation team and understand their concerns on the existing setup for the same we are developing inhouse Intranet Module for handling online business tracking system in ASP.net. & MS SQL.

Project Worked

• Closely working with the Operation team and other department heads and understand their concerns on the existing setup and to overcome we are developing inhouse tools in Excel VBA and ASP.net.

• Developing & Customizing new reports in Fish Bowl and BI reports for each department and linking from multiple databases to take correct decision. (Existing ERP is Fishbowl for Inventory, Purchase, Sales, & CRM, database is on My SQL and similarly for HR System & payroll using sperate software, database is on MS SQL.)

• Online Sales with local Search Engine: This portal helps in searching the needs like services and products. That shows the nearly available services based on the locality. Online sales show the product list with details.

• Matrimony Site: This portal handles searching of bride and grooms and they can see their details. Users can specify their favorites one’s list, already visited person list, rejected list, etc.

• Property Site: The property portal helps to search user property in details as per their requirement. User can register put their requirements in the website and local agents can contact them

• Construction Engineering Statistical Record: A Web Portal which helps to search user to identify top architect, builder,

& consultants or their city, with online News Publication related with Construction, Project database for each country.

• Pinnacle ERP, Financial & HR Module, a product of Olive: A module dealing with Human Resource Management like capturing Applicant details, Shortlisting applicants, Interview scheduling, offer letter, and Convert to an employee, Appraisal, HR Activities, Employee Portal etc. Through the employee portal an employee can view Policies of companies, Notifications, circulars, and applicable standing orders, and he can apply for leave, and also, he can check his leave balance, can request for salary certificate and other utility tools which normally employees require.

• Quadra ERP, Product of Quadra: A module dealing with Production, Purchase, and Inventory.

Purchase, Inventory & Vendor Management Module:

preparing quote, taking multiple level of approvals from authority, send approved quote to vendor, receiving confirmation from vendor, PO processing, getting estimated delivery time, payment, receiving packing list, receiving product on the warehouse, Reconciliation of Receipts, products added to inventory.

Production module: Includes Job assignment, Man hour spent in each project, Current employees who are free & busy, and when they will be free, providing real-time reports.

.Net Application Developer

Jan 2021 – Till Date

Joined new company five month back, It an Online Shopping company, it has across branches in GCC region.

• Languages: Visual Studio 2019

• Database: MS SQL 2019 (Using Linked servers)

• Tools : Ajax, jQuery, Json

SQL - BI Report & .Net Application Developer

May 2018 – Dec 2020

AMJ (Al – Morooj) is a distributor and installation of kitchen equipment, for across the GCC region.

• Languages: Visual Studio 2019, and Excel VBA.

• Database: MS SQL 2016, MySQL Server (Data Base of Fishbowl inventory.

• Reporting Tools: Jasper Reports (i-report), Power BI, Excel Data Analyst & BI Reports Developer

03 /2012 to 06/2017 (Bangalore & Mumbai)

Olive is a Software consultancy company mainly focused on HR, Financial, Sales and Purchase module for Construction Industry

• Database: SQL 2014, 2012.

• Reporting Tools: SSRS, Crystal Reports, Tableau, Power BI, Excel Senior Programmer

03 /2009 to 02/2012 (Bangalore)

• Languages: Visual Studio 2010, 2008 .NET (C#.NET, ASP.NET, VB.NET, XML), JavaScript, jQuery, HTML, Excel VBA

• Database: SQL 2008R2, SQL 2005 server

• Tools: Ajax Control Toolkit, Bootstrap, CSS

Software Engineer

02/06 to 12/08

Quadra is a cloud-based, ERP solution provider for medium to large real estate developers and construction & contracting company.

• Languages: Visual Studio 2010, 2008 .NET (C#.NET, ASP.NET, VB.NET, XML), JavaScript, jQuery, HTML, Excel VBA

• Database: SQL 2008R2, SQL 2005 server

• Tools: Ajax Control Toolkit, Bootstrap, CSS

Contact this candidate