We provide IT Staff Augmentation Services!

Sr Oracle Developer Resume

Mountain View, CA

SUMMARY:

  • 8+ years of IT experience as application developer, Database design, Data ware house using Oracle 12c/11g, SQL, PL/SQL, Oracle Data Integration.
  • Experience as Oracle Developer (application design, development, performance tuning and problem troubleshooting) in OLTP and OLAP environments.
  • Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
  • Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors, etc.)
  • Knowledge of overall search architecture, load balancing and high availability for Endeca servers.
  • Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL Developer, and PL/SQL Developer
  • Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers, views, Join for Oracle Relational Databases.
  • Experience in integration of various data sources like SQL Server, Oracle, DB2 and Flat File, Excel File.
  • Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
  • Experience in Stored procedure optimization and Performance tuning.
  • Hands on experience with client - side technologies that include Java Script, HTML, CSS, jQuery and Bootstrap.
  • Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
  • Good Knowledge in data extraction, transmission and loading.
  • Expertise in Linux and shell scripting.
  • Experience in Endeca migration to latest versions and patch updates.
  • Skilled in scripting languages such as shell, perl& python.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Manage Endeca Assembler configurations and java programs for the same.
  • Extensively worked in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
  • Good experience with Ecommerce domains using technologies on Oracle ATG Commerce and Oracle Endeca Commerce.
  • Good Experience in working with debugging tool such as Firebug for Mozilla, IE Developer Toolbar for Internet Explorer, Web Inspector for Safari, and Developer Toolbar for Chrome.
  • Proficient at quickly adapting to new environments, new technologies and facing new challenges.

TECHNICAL SKILLS:

Web Technologies: HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, XSLT,Java, JavaScript, AJAX, jQuery, JSON, Apache, PHP, Responsive Design

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming Java

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Development Tools: Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing (spring tool suite)

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Databases: Oracle 12c/11g/10g, PL/SQL (oracle), MySQL, MSSQL2008/2012

Operating Systems: Windows XP/Vista/7/8, MAC OS X, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Mountain view, CA

Sr Oracle Developer

Responsibilities:

  • Designed and developed Oracle PL/SQL Procedures, Functions and Database Triggers and involved in creating and updating Packages to meet business requirements.
  • Proficient in handling Endeca search issues, extensive experience in handling production issues, ability to quickly resolve & reduce time for e-commerce & store applications.
  • Possess expertise in Object-oriented Analysis/Design and Java Development skilled at progressing from problem statement to well-documented designs.
  • Experience on Demandware Cartridges with developing Pipelines, Controllers, ISMLs and Scripts.
  • Experience in Java, Spark and Hadoop Tools
  • Developed data insertion forms and validated them using JavaScript, Angular JS Used Grunt for Minifying Java Script Code
  • Analyze and test rule triggers and future dated rules, updating rule validation scripts & executing unit test cases.
  • Expertise in using Endeca performance monitoring tools such as imperf & request log analyzer.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
  • Implement changes on Endeca pipeline for Forge.
  • Endeca Migration projects for migrating Endeca to newer versions.
  • Writing shell scripts as a wrapper script and for automating reports & mailer notifications.
  • Hands on experience with client-side technologies that include Java Script, HTML, CSS, jQuery and Bootstrap.
  • Developed a module in google app script for automatize class schedule, monitoring of objectives and notifications of the Preacademic platform users.
  • Developed website using technologies HTML5, and CSSS3 with JavaScript frameworks, jQuery to enable optimal user
  • Collaborate with cross-functional teams to identify requirements to create new layouts for webpages and blog using PHP, HTML,
  • Created PL/SQL stored procedures, functions and packages.
  • Developed Unix shell scripts for automating many tasks and for monitoring the database.

Confidential, Denver, CO

Sr Oracle Developer

Responsibilities:

  • Worked with the project stakeholders and Users in understanding the business requirements for the project.
  • Participated in day to day agile processes like scrums and sprints using Rally.
  • Participated in the analysis phase, preparing the technical specification, development and testing documents.
  • Extensive experience in working with Endeca Search, Experience Manager, CAS & Assembler. Have been managing online & store applications for the customer across channels.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
  • Design and development of the Endeca Page Builder Templates and Cartridges
  • Created database objects like tables, views, procedures, packages, and cursor.
  • Used Ref cursors and Collections for accessing complex data through joining many tables.
  • Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
  • Demonstrated understanding of Java Technologies potential, recognized as person to mentor other colleagues on Java Technologies.
  • Involved in system study and preparing the System Requirement Specification.
  • Interacted with Business Users in creating Unit and System Test cases for enhancements in the existing application.
  • Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
  • Development of applications using Asp.Net, HTML, CSS, JavaScript.Used unit testing method to fix front end bugs in HTML, CSS, JavaScript errors (JQUERY).
  • Delivered tasks accurately in time provided.
  • Experience to create JIL file to create job in Autosys environment.
  • Extensive use of Autosys in windows environment for scheduling routine tasks.
  • Experience modify and support job by using Autosys tools
  • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules and for moving the data from staging area to data mart.
  • Experience in creating ETL transformations and jobs using Oracle using dynamic packages and procedures using oracle code.

Confidential, Brunswick, NJ

Oracle Developer

Responsibilities:

  • Created POC, & actual app for Front-end ATG-Endeca integration with Assembler API.
  • Designed and implemented the frontend ATG to Endeca Integration, including cartridges, querying and query processing and rendering of navigation, facets, pages and searches. Performed performance
  • Created SQL*plus reports as per client's various needs and developed business objects.
  • Developed various PL/SQL stored procedures and functions.
  • Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
  • Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object, Types, Triggers.
  • Modified several SQL*Loader scripts to handle new feeds from different sources and load data into the database from several sources. tuning of backend integration (deployment and indexing) and frontend search queries and processing. Implemented and configured all the cartridges and renderers.
  • Created Linux Virtual Machine development Sandbox with ATG-Endeca Integration.
  • Experience with industry standard methodologies such as Agile in various software development project.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Creating and enhancing daily, monthly, yearly jobs using Perl and UNIX shell Scripting.
  • Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS JOB, and UTL FILE.
  • Experience with RDF, formal logic, or other advanced modeling tools.
  • Extensively used Cursors, Ref Cursors, Exceptions and Anonymous blocks for generating reports.
  • Identified and defined Fact relationships. Maintained and employed OLAP Cubes in SSAS.
  • Design, Install, configure, and monitor Golden Gate Replication 12c.
  • Implementing with J2EE/ATG/Endeca/Angular JS.
  • Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  • Experience with merging data files coming from different geographical customer into the existing data warehouse.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Extensive experience in defining and implementing Enterprise Metadata Architecture & Standards, guidelines and data/integration architectures for a large project, illustrating mastery of design patterns and best practices.

Confidential, Austin, TX

Oracle Developer

Responsibilities:

  • Created and managed users, roles and profiles, audited and monitored databases and user access
  • Involved in all phases of SDLC as active participant.
  • Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, cursors and other database objects.
  • Used various Indexing and partition techniques to improve the query performance.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Improved the performance of the application by rewriting the SQL queries.
  • Created Materialized Views, tables, complex SQL queries, correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development, database objects, managed partitioned tables, managed table spaces.
  • Created Custom tables and new custom objects were designed as per business requirements and Responsible for Partitions on tables and Indexes for managing large tables.
  • Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
  • Tuned Report performance by exploiting the Oracle's new built-in functions and rewriting SQL statements.
  • Used Dynamic SQL to implement DDL statements in PL/SQL programs.
  • Created scripts to create new tables, views and queries for new enhancement in the application using TOAD.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
  • Worked with Development team to fulfill the requirements of applications with Database design
  • Maintaining data integrity and tune database for optimum performance and availability.

Confidential

Oracle Developer

Responsibilities:

  • Analyzed business requirements of the project by studying the Business Requirement Specification Document.
  • Creation of database objects like tables, views, procedures, packages using Oracle utilities like SQL Plus, SQL Loader and Exception handling.
  • Designed the front-end interface for the users using oracle Forms, Reports using 8i
  • Timely monitoring of database and system backups developed Oracle stored procedures, functions, packages and triggers that pull data for reports.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
  • Participated in Performance Tuning for query optimization and program performance.
  • Involved in Technical Documentation, Unit testing, Integration testing and writing the Test plan.
  • Use joins on various tables and display data from multiple tables. Automated Quality Check tasks by creating PL/SQL cursors, functions and dynamic SQL

Confidential

SQL Developer

Responsibilities:

  • Involved in design and development of the database design.
  • Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
  • Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
  • Developed Shell and SQL scripting for regular maintenance and production support to load the data in regular intervals.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Involved in the design, development, testing and maintenance.
  • Troubleshot production problems and worked effectively with other team members to identify and address problems.
  • Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
  • Responsible writing UNIX Shell scripts.

Hire Now