Sql developer

Velmurugan M Mobile : +91-790*******

Analyst Programmer Email : **********.******@*****.***

Chennai, Tamilnadu, India

Experience Summary

* + years of experience as MS SQL DEVELOPER.

Developing Web and Mobile Application using Angular JS 7 with ionic 4.5 as a freelancer. (past 8 months)

Expertise in writing T-SQL Queries, Stored Procedures, User Defined Functions, schedulers, Cursors, View, Triggers, file generation and performance tuning.

Integrating workday data (XML) to Ramco platform using NiFi interface tool.

Have good understanding of Functional and Technical aspects of various modules in Ramco ERP – Supplier chain management, Receivable & Payable Managements and workflow configuration.

Also Have good understanding of Functional and Technical aspects of modules in Ramco HCM – Payroll Process, Leave Administration, reimbursement and Time Sheet Billing and Administration.

Expertise in Developing Screens using Ramco iEDK Tool and reports using iReport, DCUBE, Ramco decision works (RDW) and ASPX Code for Report bulk generation and mail sending using RAMCO API.

Experience in On Site support for the client “Omega Healthcare Management Services, Bangalore”, duration of 6 months.

Developed a Chatbot Application for my own interest. This chatbot will reply the corresponding Ramco Data as per the user input. This will avoid the time consuming of opening multiple pages to view the data in Ramco Application .

Work History

Working as “Analyst Programmer” in RAMCO SYSTEMS from JUN-2019 to Present

Worked as “Associate Technical Consultant” in SmartMegh Solutions Pvt. LTD from SEP-2016 to JUN-2019

Worked as “Project Trainee” in RAMCO SYSTEMS from Dec-2015 to AUG-2016 Educational Qualification

B.E [CSE] (71%) from James college of Engineering and Technology, Nagercoil (2011-2015)

H.S.C (74%) from Tucker Higher Secondary School, Tuticorin (2010-2011)

S.S.L.C (76%) from Tucker Higher Secondary School, Tuticorin (2008-2009) Technical Skills

Languages : T-SQL, NiFi

Web Framework : Angular JS 7, Ionic 4.5, Node JS

Web : HTML5, CSS, Javascript, Typescript, AJAX

Reporting Tools : SSRS, iReport 5.6, Ramco API, Ramco DW

Tools : SQL Server 2012,2014, iEDK, Visual Studio Code Project Experience:

1.General Electric Company (GE).

General Electric Company (GE) is an American multinational conglomerate incorporated in New York City and headquartered in Boston. As of 2018, the company operates through the following segments: aviation, healthcare, power, renewable energy, digital industry, additive manufacturing, venture capital and finance and lighting.

I am working with NiFi tool to integrate the Employee data from Workday (XML) to Ramco HCM Application for multiple regions (ASEAN, MENAT and ANZ).

Technical consultant responsible for creating the interface using SQL Stored Procedures, Functions, tables, exception handling and Error log Reports Development for HCM migration.

Currently testing the payroll process using the testing data and writing the payroll rules for different regions and the different pay elements.

And meanwhile working the existing interface for payroll processing and bank file generation. 2.Omega Healthcare Pvt. Ltd.

Omega is the premier offshore provider of healthcare outsourcing services. They are specialized in medical billing, coding, accounts receivable management, and other healthcare related services.

I have worked with SSIS packages to integrate the biometric data to our Ramco HCM Application .

Technical consultant responsible for New screen development, Screen customization and Reports Development in ERP and SRP Implementation.

And also created mail alert, Triggers, and workflow for invoice creatio, Authorization in ERP and Project Creation, updation and deletion in SRP. Configured workflows for all transactions like invoice, PO authorization.

Developed a new screen for supplier payment using bank upload file in ERP. When user clicks the generate file button file the system will generate the encrypted file and directly upload it to the bank server.

3.Prodapt Solutions

Prodapt Solutions Private Limited is an Indian multinational software services, products, and operations company headquartered in Chennai, India. The company focuses on the telecommunication vertical and delivers products and services in O/BSS, business process services, infrastructure management, network operations, IT service management, product lifecycle services

Technical consultant responsible for Requirement gathering, Developing screens, Report customization, Screen customization, Validations in base screen, Performance turning, and trigger mail alert for invoice creation and authorization in ERP Implementation.

Also I have implemented the Ramco SRP and responsible for Requirement gathering, developed the new screens for Revenue accrual,Reversal and have customized the flow of invoice generation from timesheet .

4. Experian (Malaysia) Sdn Bhd.

Experian is a leading global information services company, providing data and analytical tools to our clients around the world. In a complex, ever changing world, the use of data is now driving significant advancements and new ways of thinking

Technical consultant responsible for Report development for Statutory reports of multiple countries

(Hong Kong,Australia,Malaysia,Singapore). Reports bulk generation and sending mail to each employee in a single button click using ASPX and RAMCO API in HCM Support. 5.iSmartcafe (Mobile App)

iSmartcafe is the private social feed for your organization. Entry is restricted to employees of companies that have been provisioned. Validation of your company email ID and mobile number may be required to start using smartcafe.

Technical consultant responsible for User Authentication, developing mobile screens and adding validations using Ionic 3.5 and Angular 5 Storing and retrieving the data from node js .

Working with the GOOGLE Firebase for mobile OTP verification and Realtime database. PERSONAL TALENTS

Freelancing

Quick leaning

Own Application development

Adaptable with any platform

Efficient and capable of multi-tasking.

Team Management

PERSONAL DETAILS

Name : Velmurugan M

Father’s Name : Muthuraj S

Date of Birth : 03-06-1994

Marital Status : Single

Residential Address : #4/2,East street, Kannanadivilai, Pannaivilai(PO),Thoothukudi – 628751.

I hereby declare that the particulars of information and facts stated above are true and complete to the best of my knowledge and belief and assure you that I will work in the right earnest and fulfill the expectations of my superiors.

PLACE: Chennai [VELMURUGAN M]

DATE : 10/04/2020

Contact this candidate