Dhanya

Rajan

adlhmn@r.postjobfree.com

+968********

Summary Resourceful software engineer with experience of 14 years in Oracle ERP, Java and PLSQL. Served clients for different parts of the globe as a technical consultant with positive results. Good team building & leadership skills. Good command over communication & interpersonal skills. Extensive troubleshooting skills. Worked with many large team of ERP and software developers to maintain and improve company projects. Assisted with disaster recovery environments for critical business applications.

Employment History

Senior Techno Functional Consultant

Tata Consultancy Services - Nielsen India • Vadodara, Gujarat 01/2014 - 10/2018

Database design, Data migration, Data transformation, data backup using using Microsoft Visual Studio, .NET, SQL Server 2008, Stored Procedures, MS Access. Strong problem solving, perfomance tuning and debugging skills. Collaborated effectively with project managers to ensure project deliverables, remained on track and aligned with business goals and expectations. Requirements engineering, development, user interface design, prototyping, coding, test and maintenance.

Oracle Techno Functional Consultant

Tata Consultancy Services - Allianz Global

01/2013 - 11/2013

Proficient in Oracle Forms and Reports building (Oracle 6i Report builder). Working with database administrators to implement design changes and new packages. Created database objects like tables, views,functions, stored procedures, sequences, synonyms, indexes using Oracle tools like Oracle Jdeveloper, and toad. Experience with performance tuning for Oracle RDBMS using explain plan and hints. Solution architecture and Preparation of Gap -Fit document and client syndication. Worked on SQL loader to load data from flat files obtained from various facilities every day.

Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.

Preparation of user manual and training documents, end user training. Post Implementation Support and execution of change requests Oracle APPS Lead Techno Functional consultant

Tata Consultancy Services - Gujarat Electricity Board • Vadodara, Gujarat 06/2009 - 10/2012

Oracle ERP Suite Implementation and maintenance of Project, Inventory and Purchase modules.

Extensive experience in Oracle HRMS, General Ledger, Fixed Assets, Account Payables . Technical expertise in implementation,Form customization, Form Personalization, support and maintenance .

Experience in Design, Development and Testing of Oracle Reports/Oracle Forms and oracle workflows.

Ability to effectively gather and refine report requirement from Users and Management and give appropriate attention to details.

Proficient in troubleshooting and debugging.

HRMS and Payroll Module Developer

Tata Consultancy Services - Maharashtra State Electricity Board • Mumbai, Maharashtra 03/2007 - 06/2009

Developed the Payroll and CPF System of MSEDCL using J2EE Struts Framework and PLSQL.

Set up and maintenance of Oracle HRMS module .

Developed Stored Procedures and Batch Process n Oracle 9i in different modules to interface the HRMS and Payroll systems.

Offshore and Onsite co-ordination done successfully during the Development & Testing Phase.

Trained new joiners to the project.

Developer

Cognizant Technology Solutions - AFCO USA • Chennai, Tamil Nadu 10/2004 - 02/2007

Developed Reports for various modules using Actuate Reporting Tool. Developed Stored Procedures and Batch Process n Oracle 9i in different modules Offshore and Onsite co-ordination done successfully during the Development & Testing Phase

Professional Skills

Education

Bachelor of Technology- Computer Science and Engineering MG University • Kerala

Graduated - 06/2004

Graduated with 75%

PreDegree

MG University

Graduated - 05/1999

Pre University: Graduated with 77%

Languages

STORED PROCEDURES MAINTENANCE

DATA MIGRATION CODING

Oracle Forms Oracle E-Business Suite

Malayalam Hindi

English

Contact this candidate