We provide IT Staff Augmentation Services!

Software Engineer Resume

SUMMARY

  • More than 11 years of software engineering experience as an Oracle Certified Professional. Committed to quality and excellence.
  • Expertise in Oracle platform migrations. Worked extensively in migrations from 10g to 11g and 11g to 12c.
  • Expertise in writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
  • Good experience with the usage of Collections, Bulk Insert, Nested tables, External tables, Advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors.
  • Highly skilled in Performance Tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, and SQLTRACE.
  • Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).
  • Involved in developing various inbound and outbound interfaces to integrate legacy systems, mid-range applications to Oracle applications using ETL, XML, and web services, PL/SQL, SQL Loader, FTP and UTL Files.
  • Extensively worked on Data Migration using Flat files and Data Mapping through SQL* Loader Imp/Exp utilities, UTL-File Package on Oracle 9i /10g/11g/12C Databases.
  • Experience in Performance tuning, Application tuning and Query Optimization using Hints, Explain plan
  • Hands on experience with tools like SQL Navigator, Toad, Sql * Plus, Oracle Enterprise Manager (OEM)
  • Expertise in writing Wrapper/Scheduler jobs and UNIX Cron Jobs
  • Expertise in Oracle Forms, Oracle Reports, Oracle Fusion Middleware, Oracle WebLogic Server, Synergy DE Proficient in working and conceptual knowledge of Oracle Forms 9i/10g/11g/12C, Reports 9i/10g/11g/12c.
  • Hands-on experience with source control tools like Visual Source Safe (VSS)
  • Diverse domain knowledge of industry includes Finance, Collections and General Ledger, Merchant processing, Credit Card processing, Mortgage, Commodity, Healthcare, Pharmacy and Claims processing.
  • A team player who is adept at prioritizing, multitasking to achieve individual and team goals.
  • Proficient in Installation and Configuration set up of Oracle Web Logic, Oracle Forms 11g/12c and Reports 11g/12c using Oracle Console and Oracle Enterprise Manager (OEM)
  • Experienced with Full Project life cycle and well versed with scrum, Agile and standard SDLC methodologies.
  • Extensive experience in Implementation, Customization, Production and Support.

TECHNICAL SKILLS

Database : Oracle 9i/10g/11g/12c, DB2 10, SQL Server, MySQL

Front-E nd A pplication T ools: Oracle Developer Suite - Forms 9i/10g/11g and Reports 9i/10g/11g/12c

Fusion Middleware : Oracle WebLogic Server 11g, Oracle Application Server OC4J

Language : Oracle PL/SQL, PRO*C, JAVA, C++, Snergy/DE, UNIX Shell scripting,HTML

Tools: /Utilities: SQL Developer, PL/SQL Developer, TOAD, Informatica , SmartTerm, ClearCase, Microsoft Visual SourceSafe, JIRA, Visual studio, Visio, RAD, Putty

Operating Systems : Windows NT, MS-DOS, UNIX, LINUX, AIX

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Responsibilities:

  • Support for Oracle and Java applications for Food and Confidential Administration ( Confidential ).
  • Wrote SQL scripts, created PL/SQL Packages, database triggers, and stored procedures to support Web-enabled applications.
  • Participated in system analysis, design, and implementation of the 11G to 12C Conversion project and was involved in database design and modeling.
  • Experience with effective debugging and performance tuning
  • Build and maintain Database PL/SQL Stored procedures, packages, triggers and views.
  • Created Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statement.
  • Involved in SQL Query tuning and provided tuning recommendations to scheduler jobs, time/CPU consuming queries
  • Full life cycle experience Oracle Form and Report Development.
  • Development of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with effective debugging; and performance tuning
  • Worked on Report layout design, Data models which used Placeholder, Summary, Formula Columns
  • Worked with designing the front-end screen multiple Canvases, Windows, Object items and Form Triggers
  • Troubleshoot bugs and determine the root cause of problems.
  • Using SVN as a version control system. Used JIRA as a software development control system.
  • Apply appropriate standards, processes, procedures, and tools throughout the development life cycle
  • Analyze system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques and controls
  • Develop unit and functional/integration tests.

Confidential

Software Engineer

Responsibilities:

  • Understanding the application flow and process. Participate in the development and implementation of software version and change control processes, policies, and procedures across multiple development teams.
  • Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Wrote PL/SQL Database triggers to implement the business rules in the application.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Installation and configuration setup of Oracle Fusion Middleware - WebLogic server, Oracle Forms 11g, Oracle Reports(11g)
  • Upgrade Oracle Forms and Reports application from web based 10g to 11g
  • Expertise in server setup and configuration in various regions. Participate in defining and documenting CM tools and processes.
  • Hands on experience in working with Oracle admin console and Oracle Enterprise manager
  • Setting up the Forms and Reports Services on 11g standalone Server/In-process Server
  • Worked with Crontab jobs calling UNIX scripts to download and manipulate files.
  • Creation of firewall requests to have proper link with the interface applications
  • Working with UNIX shell scripts
  • Trouble shoot performance issues and bugs within packages, forms, and reports using Forms debugger, Plan Explain, DBMS Output.
  • Perform file transfer via NDM Connect Direct, SFTP.

Environment: : Oracle Fusion Middleware - Oracle WebLogic Server (10.3.6), Oracle Forms (11g), Oracle Reports(11g), PL/SQL, SQL, SQL * PLUS, UNIX Shell Scripting, Toad, SQL Developer, Putty, VSS, Confidential, UNIX, AIX, SFTP, Connect Direct, CA service desk manager.

Confidential

Senior Oracle Developer

Responsibilities:

  • Developing of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with effective debugging; and performance tuning
  • Understanding dependencies and relationships between Oracle Forms, Oracle Reports and Oracle Databases
  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Involved in Unit Testing Stored Procedures and Functions.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data
  • Involved development of Synergy code, Unit testing and implementations and Code review.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
  • Used UTL JOB to automate the PL/SQL procedures and packages.
  • Develop UNIX shell scripts to administer the system.
  • Perform knowledge transfer in the areas of Oracle SQL and PL/SQL programming, Oracle Developer suite (Forms and Reports) to Cognizant employees.
  • Better Health care domain Knowledge

Environment: PL/SQL, SQL, Oracle forms (10G), Oracle Reports, Synergy DE, UNIX, TOAD, SmartTerm, SQL * PLUS, JAVA, ETL, Oracle Warehouse Builder, SQL Navigator, Microsoft Project Planner

Confidential

Software Engineer

Responsibilities:

  • Constructions/Coding of PLSQL and PRO*C programs.
  • Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
  • Expertise in requirement gathering and preparing low-level & high-level design document and traceability matrix. Reviewing unit, integration and system test case.
  • Preparation of PS, UT and IUT documents.
  • Working with the main modules like Booking, Disbursals, closure.
  • Generated SQL and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonym
  • Working with UNIX shell scripts
  • Worked with Crontab jobs calling UNIX scripts to download and manipulate files.
  • Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

Environment: Oracle 9i, PL/SQL, PR0*C, TOAD, UNIX, SQL * PLUS, SQL developer, VSS, ASP, HTML, Java Script, VB Script, XML, UNIX Shell scripting, ClearCase.

Hire Now