Freelancers
freelancer
Email Verified Jay K
0.0/5 (0 Feedback)
Member since May 10, 2021

A result-oriented professional having 10+ years of experience in performing software analysis, desig...

A result-oriented professional having 10+ years of experience in performing software analysis, design, development, support and performance tuning of the applications in Utility, Finance, Healthcare, Insurance and Manufacturing domains. Strong Experience in Oracle Forms and Reports Upgrade from 10g to 11g and 11g to 12c. Expert in application development using Oracle 9i, 10g/11g/12c (SQL, PL/SQL), SQL*loader, Oracle Forms and Reports 6i, 10g, 11g & 12c. Expertise in Form and Report personalization and customization. Worked on complex multi-forms which includes CALL_FORM, OPEN_FORM, NEW_FORM Strong Working Experience in creating new forms based on REF Cursor, Views and Packages. Expertise in designing & creating databases in Oracle 9i/10g/11g/12c for OLTP and OLAP applications. Having extensive experience in creation of oracle objects like: Database Triggers, Stored Procedures, Functions, collections, record types, views, materialized views and Packages and other objects. Strong working experience in Oracle Advanced SQL, PL/SQL and RDBMS concepts. Experience with Data flow diagrams, Database normalization theory techniques, Entity relation modelling and design techniques. Strong working experience in Collections, Ref Cursor and Bulk-Collect. Adroit in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, TKPROF, DBMS Profiler and AWR Reports. Strong knowledge in 3PL Interfaces and Conversions. Experience in EDI Interfaces. Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX SHELL scripting, SQL, PL/SQL and SQL Loader. Expertise in generating daily and weekly Flat files using the UTL packages as per business requirements. Have good Oracle Apps Techno Functional knowledge in ERP Modules (Purchase, Stores, Material Management, Sales, Production, Warehouse, Planning and Accounts). Good at data dictionary tables and DBA skills An energetic with hands on experience in programming skills, client-server infrastructure, requirements gathering, application integration and customization. Exceptional communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilising the same in a productive manner. Well versed with AGILE and SCRUM process. Worked on Forms Libraries, Visual Attributes and Property Class changes. Proficient at ITIL compliance and standards. Experience in standard source control (PVCS) Experience in PPM(Kintana), BMC Remedy, JIRA tools Strong work ethic and the ability to work well within a team environment. Highly motivated and enthusiastic, capable of working on own initiative. Best Performer Award from 3i-Infotech In 2013 TECHNICAL BACKGROUND ERP Applications : Customized ERP applications, Oracle applications R12 Databases : Oracle 9i / 10g / 11g / 12c Reporting Tools : Oracle Reports 2.5 / 6i / 9i / 10g 11g / 12c Languages : SQL, PL/SQL Operating Systems : UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows 2008/12/14 Other Tools : Toad, SQL developer, PL/SQL developer, Visio, SQL* Loader, SVN

0

Ongoing projects

0

Completed projects

0

Cancelled projects

0

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer