Joel Sam Thomas Email & Phone Number

 Good Experience in Oracle SQL, PLSQL,Forms and Report(11g/10g/9i/6i). Good Experiecne in Microsoft Sql Server, Visual Basic, Crystal Report. Wrote generic PL/SQL code modules (PL/SQL libraries) for reports to handle data manipulations on client. Proactively tuned SQL queries leading to significant improvement in system response time and efficiency. Designed and implemented client-server application using oracle forms builder. Created logical and physical Database Design, Data Modeling, and Schema design. Applied Database Tuning and Optimization, Normalization in the new database design. Created Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, Anonymous Blocks, Directories, Sequences, Synonyms. Granted resources, Privileges and Roles to Users. Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization. Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking. Developed data model, SQL coding, SQL query tuning process and schemas. Wrote Audit programs for data consistency check and validation. Writing SQL Server stored procedures using T-SQL. Writing updating and supporting reports using T-SQL. Experience in performance tuning using Explain Plan and Indexing. Having a good knowledge on Database Import and Export. Good knowledge of bulk data transfer from Excel to Oracle Database. Good experience in agile software development. Knowledge of Jasper Report Implementation in the Linux platform. Knowledge of .Net framework, HTML, CSS and VB Script.  Thorough knowledge of Object Oriented Programming concept. Strong interpersonal and communication skills in dealing with customers. Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies

Listed skills include Oracle Pl/Sql Development, Oracle Reports, Oracle Forms, Jasper Reports, and 8 others.