Syed Mahammed

Experienced Application Engineer with expertise in CRM application products. Proficient in a range of technologies, including Oracle SQL Database, API development, C#, and deployment on OCP platforms.

• Oracle SQL Database: Proficient in writing complex queries, stored procedures, views, reports, and dashboards.
• API Technologies: Proficient in creating RESTful and SOAP APIs in XML and JSON formats. Skilled in writing XSLTs for applying transformations on request-response of APIs.
• Deployment: Having good knowledge in Builds-Patches deployments on OCP platforms like OpenShift.
• Moderate knowledge and implementation of C# functions, classes, and variables.
• Development for the new Creation of Tabular, Charts, Graph, Composite Graph, Pie-Charts, Sub Reports, on Instances as per end-user requirements
• Creation of Scheduler Jobs to perform various tasks like fetching details, validating data, moving data from one source to another source.
• Configuring External Data Sources (WebServices, RestfulAPI, and Database) and consuming corresponding services.

Projects:

Project1: Credit Card Module

Client: Kotak Mahindra Bank

Term: July 2022 to Mar 2023

Databases: Oracle SQL Developer (19c)

API: Restful APIs

Role: Developer

Description:

The project aims to enhance the existing banking system by implementing a robust and secure credit card management module. As an Oracle SQL Developer, My role involved designing and optimizing the database schema, writing efficient SQL queries, creating scheduler jobs, writing stored procedures, and ensuring seamless integration with other banking modules for a seamless user experience using Restful APIs, ETL Tools to fetch, manipulate and analyze the data across the platforms.

Project2: Customer360, Leads and Campaign Management

Client: Indian Overseas Bank

Term: Mar 2023 to till date

Databases: Oracle SQL Developer

Role: Developer

Description:

The project aims to enhance the existing banking system by implementing a robust and secure credit card management module. As a Developer, My role involved designing and optimizing the database schema, writing efficient SQL queries, working on Web Services RESTFUL API, writing stored procedures, working on Developer Reports and Dashboards, and ensuring seamless integration with other banking modules for a seamless user experience.

Technical Skills:

• Databases: MS SQL Server 2012 and 2014, Oracle Database 12c, 18c and 19c.
• MSBI Tools: SSIS, SSRS
• ETL Tools: SSIS, ODI
• API: Restful APIs.

Project1: E-healthcare system

Client: Emblem Health

Term: Sep 2018 to June 2019

Databases: SQL Server 2008 R2, 2012

Role: SQL SERVER DEVELOPER, MSBI DEVELOPER

Description:

The main feature of E-Knowledge in the health care system is to provide the browser to get appointments with a doctor through the Internet instead of going there and fixing an appointment. On the Doctor’s side, they can view their appointments and prescribe medicine for their patients.

E-Knowledge in the health care system maintains patient’s prescriptions so that their medical details are always available on the Internet, which will be more convenient for the patients. This will be more comfortable for the patient. Patient details and prescriptions are maintained confidentially.

There are four modules in E-knowledge in the Health care system they are

· Patient module

· Doctor module

· Administrator module

· General user module

Project2: Human Resource Software

Client: Internal

Term: July 2019-Jan 2022

Databases: Oracle SQL Developer (19c)

Role: Oracle SQL Developer

Description:

Human Resource Software is an online human resource management software solution that automates and accelerates the personnel management, payroll, talent management, time, and attendance tracking processes from a unified platform. It helps organizations retain, manage, and reward valuable talent. This powerful online HR management software streamlines the complete HR cycle from employee recruitment to retirement. With built-in dashboards and advanced analytics, Human Resource Software makes the HR decision making process simple and intuitive. Online document management system, to allow management of documents from the same interface.