Programmer Analyst

Study and document there As Is and To Be planning processes and reporting requirements. Functional specification creation for reports, forms, enhancement, and conversions Testing (Integration, User acceptance, Unit Testing). Interacting with clients and understanding the business requirement and their expectation from ERP. Conduct functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervise the development of User Manuals for business users. Develops SQL Scripts to create datasets to perform reporting and includes interactive drill down reports, report models and reports. Involve in Software Development Life Cycle (SDLC). Actively participate in scrum meetings and reviews. Perform modification on some Oracle Stored Procedures to integrate the different tasks of Oracle Developers. During analysis, he will be involving in tuning SQL and PL/SQL for better performance of the database. Coordinate with DBA for database tuning during Cleansing execution. Maintain application monitoring, performance tuning and testing. Provides the automation for copying of production database and restoring the data to a non- production development system using shell scripting. Involve in creating the backup database to track the tape usage and ensure all the environments were backed up consistently. Required Minimum Qualifications: Bachelor’s degree (or equivalent). Technologies: Unit Testing, PL/SQL scripting for interaction with database. Oracle 11g for data migration.PL/SQL for tuning and performance increase for database. Oracle 11g for modifying stored procedure. Production support and data cleansing. Tools & Utilites: PL/SQL, Oracle 11g, Windows OS, UNIX/LINUX, Shell scripting, MS Office and UAT and Visual Basic

Do you have experience in Windows?, Do you have a Bachelor’s degree?