Oracle Pl/sql Developer Resume
PROFESSIONAL SUMMARY:
- Over 9+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Overall 11+ years of IT industry experience.
- Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and Support. Experience working in Water fall and Agile development methodologies.
- Expertise in client - server application development using Oracle 10g/11g/12c, PL/SQL, SQL *PLUS, SQL Developer.
- Having Extensive experience on MVC using Oracle Application Development Framework Oracle ADF and JDeveloper. Good knowledge of ADF architecture and its components.
- Extensively worked on UI pages using ADF Frontend components, page fragments.
- Experience in creating Data flow diagrams, Database normalization techniques, Entity Relationship Diagrams (ERD), Data modelling techniques.
- Developed complex database objects like Stored Procedures, Packages, Functions and Triggers using SQL and PL/SQL.
- Expertise in writing complex SQL queries and using Oracle inbuilt SQL functions in complex packages/procedures and SQL Performance tuning.
- Good knowledge on logical and physical Data modeling, created Tables, View, Indexes, Constraints, Sequences, Triggers and Synonyms.
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for Online Transactional Processing (OLTP).
- Experience in Oracle supplied packages like DBMS OUTPUT, DBMS UTILITY, DBMS STATS, DBMS METADATA, UTL FILE.
- Experience in Dynamic SQL, Exception handling, Ref Cursor concepts.
- Created PL/SQL Packages with inbuilt Procedures creating JSON outputs returning as CLOB, for passing the data back to JAVA service layer coding and moving it down to the UI environment. Created JSONs using functions like: JSON ARRAYAGG, JSON OBJECT, JSON OBJECT T, JSON ARRAY T.
- Experience in writing Unix shell scripts to execute batch processes, invoke online screens, stage codes to higher level target regions. Learning Python programming language.
- Worked for European, US and Canadian clients in developing/enhancing applications hosted on Solaris server running on Unix/ Windows OS. Coding done using Oracle SQL, PLSQL, Unix.
- Experience in Commercial / Transportation Finance domains: lease / lending and banking systems.
- Extensive experience in gathering and analyzing customer requirements, estimating effort and translating functional/non-functional requirements to system requirements and designs.
TECHNICAL SKILLS:
Databases: Oracle 10g/11g/12c, DB2
DB Tools: SQL Plus, SQL Developer
Languages: Unix Shell Scripts, SQL query, PL/SQL (procedures, packages, functions, types), XML, COBOL, JCL, Python(started learning - beginner)
Operating Systems: Windows(98/2000/XP/7/10), Unix (Solaris, LINUX)
IDE & Tools: Notepad++, ALM, Winscp, Putty, Openstudio, Appworx(Batch scheduling tool)
Version Control: Starteam, Jenkins, Git, Confluence
PROFESSIONAL EXPERIENCE:
Confidential
Oracle PL/SQL Developer
Languages : PLSQL procedures, packages, functions, types, Complex SQLs, Unix, SQL Performance tuning
Responsibilities:
- Analyzed, designed, implemented and converted batch jobs/programs into Oracle PL/SQL
- Developed PL/SQL packages, procedures, triggers, functions and Indexes to implement business logic using Oracle SQL Developer
- Used standard packages like DBMS OUTPUT, DBMS UTILITY, DBMS STATS, DBMS METADATA, UTL FILE
- Worked on delivery of Oracle ADF custom applications using full lifecycle methodologies.
- Created ADF development with best practices and coding standards. Acted as a subject matter expert with Oracle ADF.
- Creating data model both Logical and Conceptual and prepared DDL’s for all DB requirements.
- Significant contribution to DB design, Data Modeling, Coding using Oracle, PL/SQL and Informatica for data integration data between Test Delivery Systems and Scoring engines along with lead responsibilities for implementing Database object, writing PL/SQL stored procedures, SQL statements providing data for reporting and adHoc queries and ETL data pipelines.
- Created UNIX shell scripts to execute newly created PLSQL Packages / Procedures, also to move tested code to higher environments like SIT, UAT and Production
- Created PL/SQLs which created JSONS / CLOB as outputs
- Carried out data accuracy testing by comparing both instance of data (AS IS vs TO BE)
- Involved in the continuous enhancements and fixing of User Acceptance Testing issues / problems.
- Created two instances of database for loading data created by as is batch processes and output of newly created PLSQLs
- Involved with current Oracle ADF implementation including system infrastructure, code base.
- Involved in table redesigning with implementation of constraints (Primary / Foreign key) to make Database Faster and easier to maintain
- Used principles of Normalization to improve the performance like converting 3NF to 2NF normalized tables
- Coding Sort utility using Python programming language.
- Client interaction and Requirement Gathering
- Lead onsite team
- Managed and coordinated with offshore team.
Confidential
Oracle PL/SQL Developer and Support developer
Languages : Oracle SQL, PLSQL, Unix
Responsibilities:
- Client interaction and Requirement Gathering
- Created Entity Relational Diagrams representing new data structures for the enhancements
- Implemented logical representation of new business requirements into physical database tables
- Created new tables using 2NF and 3NF normalization technique, to accommodate new business' data and integrate with existing tables, supporting faster access, achieving minimal to zero performance issues
- Created Validations using ADF valuators to validate Required Field, Range, Length, Start Date less than End Date, handled various Exceptions using oracle ADF.
- Worked with ADF binding, Data Control and Databinding.cpx a wiring Framework between View and Controller Layer.
- Created new, updated or changed existing PL/SQLs to implement new enhancements requested by business users per new business needs
- Developed, updated or changed PL/SQL packages, procedures, triggers, functions and Indexes to implement new business logic using Oracle SQL Developer
- Used dynamic SQLs, cursors, array, for loop, various SQL functions while coding PLSQLs
- Updated UNIX shell scripts to execute PLSQL Packages / Procedures, also to move tested code to higher environments like SIT, UAT and Production
- Involved in the continuous enhancements and fixing of User Acceptance Testing issues / problems
- Lead onsite and offshore team
- Coordinated with offshore team.
- Developed Bash shell scripting and python scripts for IWS batch in Linux Server.
- Support application to run business as usual
- Resolve production defects
- Productionized code
- Involved in post-production testing
- Provided technical and functional solution
Confidential, Danbury, CT
Oracle PL/SQL Developer and Support
Languages : Oracle SQL, PLSQL, Unix
Responsibilities:
- Client interaction and Requirement Gathering
- Involved in business analysis tasks
- Involved in creation of design documents for new requirements and coordinated with various portfolios within the IT ecosystem to integrate with other application within the bank system.
- Created new tables using 2NF and 3NF normalization technique, to accommodate new business' data and integrate with existing tables, supporting faster access, achieving minimal to zero performance issues
- Created new PL/SQLs to implement new enhancements requested by business users per new business needs
- Part of business sell of activity, worked from a buyer’s environment.
- Involved in high level Data Modeling sessions that revolve around deciding the granularity of data for critical dimensions, Model changes and enhancements, database constraints for derived dimensions.
- Developed, updated or changed PL/SQL packages, procedures, triggers, functions and Indexes to implement new business logic using Oracle SQL Developer
- Designing ADF Task flows, Dynamic Regions, ADF Page Templates, Designing Rich user interface using ADF components.
- Created Validations using ADF valuators to validate Required Field, Range, Length, Start Date less than End Date, handled Exceptions using oracle ADF.
- Used dynamic SQLs, cursors, array, for loop, various SQL functions while coding PLSQLs
- Created UNIX shell scripts to execute newly created PLSQL Packages / Procedures, also to move tested code to higher environments like SIT, UAT and Production
- Involved in the continuous enhancements and fixing of User Acceptance Testing issues / problems
- Coordinated with offshore team
- Productionized the application and integrated it with other applications in production
- Involved in post-production testing
- Provided technical and functional solution
Confidential, Danbury, CT
Oracle PL/SQL Developer and Support
Languages : Oracle SQL, PLSQL, Unix
Responsibilities:
- Altered existing DB tables to accommodate a new column which defines the name of the buyer from the seller company.
- Updated existing PL/SQL functions to introduce edit checks based on newly introduced table column
- Created PL/SQLs which created JSONS / CLOB as outputs.
- Created new reports and changed existing monthly report generation processes to split reports based on the value in the new table column.
- Designed custom templates for other data modelling related activities documentation and presentations
- Designed conceptual and logical data model for projects
- Used dynamic SQLs, cursors, array, for loop, various SQL functions while coding PLSQLs
- Created UNIX shell scripts to execute new reporting program created using SQL / PLSQL
- Involved in creation of design documents for new reporting requirements during sell of activity
- Client interaction and Requirement Gathering
- Lead offshore team
- Created page templates, ADF Pages with master-detail tables with PPR, breadcrumbs, trains and dynamic regions.
- Coordinated with offshore team
- Productionized code
- Involved in post-production testing
- Provided technical and functional solution
Confidential
Oracle PL/SQL Developer
Languages : Oracle SQL, PLSQL, Complex SQLs, Unix, SQL Performance tuning
Responsibilities:
- Converted monthly report generating batch process into PL/SQL procedures and functions.
- Used standard packages like DBMS OUTPUT, DBMS UTILITY, DBMS STATS, DBMS METADATA, UTL FILE
- Used dynamic SQLs, cursors, array, for loop, various SQL functions while coding PLSQLs
- Created UNIX shell scripts to execute new PLSQL Procedures
- Involved in the continuous enhancements and fixing of User Acceptance Testing issues / problems.
- Lead offshore team
- Involved in Logical and Physical Data modeling, reverse engineering and enhancing physical data model for commodities module of GTR.
- Managed and coordinated with onshore team.
- Productionized code
- Provided technical and functional solution
- Communicate with onsite team
Confidential
PL/SQL Developer
Languages : Oracle SQL, PLSQL, Complex SQLs, Unix, SQL Performance tuning
Responsibilities:
- Integrated PL/SQL with Microfocus COBOL code, as part of a pilot project there was a requirement to call PL/SQL from a COBOL programs
- Coding done in PL/SQL
- Client interaction and Requirement Gathering
- Communicate with onsite team
- Productionize code
- Post production testing