IT Analyst

Responsibilities:

  • Involve in system study, analyze the requirements by meeting the client and designing the complete system.

  • Interact with all the stakeholders to understand and the existing business process and gather business requirements.

  • Responsible for implementation of SOLIX EDMS tool on the Oracle Applications package.

  • Involve in various Oracle Application modules data archiving by using SOLIX EDMS tool.

  • Analyze Software Requirement Specification, Design documents as per Rational Unified Process.

  • Performance tuning of customized complex queries, in SOLIX MERGE schema, by tracing the related JOBS.

  • Create & define the relationships (SOLIX MINIME) among the tables to purge the data in a proper manner.

  • Responsible for creation of various reports to publish the data after archival process and also fine-tuned various OBIEE Performance issues with SQL’s.

  • Perform Critical path analysis and analyzing ER diagrams.

  • Develop the various PL/SQL packages/procedures as part of Customized modules data archiving.

  • Responsible for validating the archived data using SOLIX ARCHIVE responsibility after ERP data archival and also responsible for writing Technical design/requirement Documents.

  • Fine tuning of various Oracle & customized reports with the help of explain plan, TKPROF, hints & indexes.

  • Create and customize necessary PL/SQL triggers to validate data before starting the archival process.

  • Responsible for writing the Technical Design Documents, Preparation of data reports.

  • Development of various customized flows and data validations of Oracle CRM modules include Service Contracts, Install Base before archival process.

  • Perform unit testing, integrated system testing and user acceptance testing.

 

Skills /Tools

SQL, Oracle PLSQL, Java, XML, Oracle Apps 11i / R12, SOAP UI, Load UI., HP Quality center & TOAD, Windows, Linux, Unix.

Minimum Qualifications

Education: Bachelors in Technology/Engineering, or Master of Computer Applications in a related field of study (will accept equivalent foreign degree);

Employer Contact

Forsys, Inc.
Human Resources Department
6036 Stevenson Blvd.
Fremont, CA 94538

Attn: ITA 17-13