Jayasri Jayaraman

Contact: +91-934*******, +91-741*******,

E-Mail: jayasri.jayaraman@gmailcom

ANALYST PROGRAMMER/ DEVELOPER

I would like to be a part of an organization where I could use and enhance my knowledge and talent for the development of both the organization and myself.

PROFILE SUMMARY

●Overall 5+ years of professional experience in Ramco in Development and support for HCM and ERP product.

●A logical, analytical thinker with excellent problem-solving skills possesses 5+ years of experience in MS SQL server and basic knowledge in PL/SQL.

●Good understanding of RDBMS concepts and experience in writing sub queries, Cursors, CTE, views, functions and Stored Procedures using T-SQL in MS SQL Server.

●Extensive use of complex joins, sorting and transactions

●Having strong knowledge complex queries and stored procedures

●Strong knowledge performance tuning and avoiding key lookup.

●Strong knowledge on table and index partitioning to improve the table performance.

●Ability to work independently as well as work with teams having varying backgrounds on complex issues .

●Knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

●Experience in Manage, backup and restoring the database

●Having good knowledge on creation and scheduling of T-SQL jobs.

●Having experience in requirement analysis, coding and testing various modules in a software development life cycle.

●Having Knowledge on developing & deploying ETLs using SSIS.

●Experience in report development anf deployment using SSRS and report manager.

●Expertise preparing report specifications and database designs to support reporting requirements.

●Involved in all phases of the project (Documentation, Designing, Unit testing and Defect fixing)

●Exposing to using various Bug tracking tool Team Track.

●I have been a key member of various development of my team and responsible for New Development, Change Request, Customer Interaction, Project Go Live and Reports.

●Strong analytical and debugging skills.

●Experience in creating and using temporary tables, indexes.

●Basic Knowledge on reporting services.

WORK EXPERIENCE

Company: Ramco Systems Limited.

Duration: October 2015 – October 2016

Designation: Project Trainee

Responsibilities:

●I have worked for 1 + years in the Support Enterprise Business Solution division of Ramco Systems.

●Defect Fixing based on Rtrack ticket logged by the customers.

●Worked on New application screen designing using EDK and IEDK tools.

●Designing new report and worked on existing reports using Crystal Report application, DW Report tool.

●Participated in unit testing and defect fixing after the completion of CU’s

●Trained new team members regarding EDK and IEDK development, DFN, VSS.

Company: SmartMegh Solutions Private Ltd.

Duration: November 2016 – August 2019

Designation: Technical Consultant

Responsibilities:

●I worked extensively worked for 2+ year in the development project, support project of SmartMegh Solutions Pvt Ltd.

●I have been a key member of various development of my team and responsible for New Development, Change Request, Customer Interaction, Project Go Live and Reports.

●Developing new screen and worked in existing screen in both ERP and HCM using IEDK tool.

●Designing REPORT using DW report tool, iReport tool and Dcube Reports and Support HCM, ERP product and clarify the Customer issues and queries.

●Supported live customer defects in HCM and payroll Module.

TECHINCAL SKILLS

●Technology : MSSQL, T-SQL, VSS, RVW

●Reporting Tools : Crystal Reports XI, Jasper Report 5.0, iReport.

●Databases : Microsoft SQL Server 2008/2012/2014

●Enterprise Products : (Ramco – ERP Applications, HCM, Payroll Modules)

ORGANIZATIONAL EXPERIENCE

Company: Ramco systems ltd., CHENNAI

From: August 2019- Present

Designation: Analyst Programmer

Responsibilities:

●Having Good experience in Payroll modules and developed various reports in Payroll Module for India Country.

●Learning the functionality of HCM Modules (Employee Induction, Leave, Recruitment, Performance Management System, Loan, Reimbursement, Payroll and Time Management)

●Convert XML payroll input files into XLS files using SSIS package based on the customer requirements for other country payroll (China, Turkey, Mexicco, Brazil, Chile, Australia, Morocco, Ukraine, Argentina and Israel).

●Created new Schedule report for XML files automation.

●To ensure the proper workflow has been configured as per the customer requirement.

●Involving defect fixing process and ensure to provide the better quality.

●Tuning the complex queries with better performance.

●Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services.

● Payslip Automation – Created Payslip automation Package, based on this package payslip will be moved automatically into employee ESS login for Other countries.

●Maintaining the versions of the objects.

●Providing support whenever the customer needs.

●Interacting with the customers and providing the resolution on their queries.

●Reporting to the senior manager about the status and priorities of the issues.

●Guiding the functional people with sql queries.

Project Details:

Name : HCM (Human Capitalized Management System)

Database : SQL 2008/2012/2014/2017

Organization : RAMCO Systems Private Ltd

Tools : VSS (Virtual works source safe), RVW, iReport, and Git Bash

Duration : August 2019 – Till Date

Project Description

We are dealing with HCM related Products which covers all HR related modules and other modules like Loan, Leave, Reimbursement, Payroll, Travel, Attendance With the help of our Product team members can apply their leave, apply loans, download payslip, submitting performance rating, do time booking and reimburse their expenses easily by using the QSS(Quick Self Service). It has multi-payroll and tax calculation for various countries like Malaysia, Indonesia, and Thailand etc. Also it can be used in mobile app anywhere and everywhere by employees and supervisors to apply and authorize.

Project Responsibilities:

Understanding the customer requirements, designing the database, writes SQL Queries, Creating tables, Views, index, Synonyms, Stored Procedures and providing support to the live customer for their implementation process.

Key Achievements:

I have improved the working experience of writing SQL procedures functions, complex queries, and transaction. I have improved working experience in database designing.

EDUCATION

●Completed B.E (computer science and engineering) in IFET College Of Engineering with a CGPA of 81% batch 2010-2014.

●Completed HSC in Shree Subrayachettiyar girl’s .Hr. Sec School with 85.3% in the year 2010.

●Completed SSLC in Shree Subrayachettiyar girl’s. Hr .Sec School with 92.4% in the year 2008.

[Jayasri] [CHENNAI]

Contact this candidate