Sql Developer

*************@*****.*** +1-816-***-****

PROFESSIONAL SUMMARY:

* ***** ** ** ********** in Analysis, Design, Development, Support, Administration, and Performance tuning of applications using Oracle SQL, PL/SQL.

2+ years of experience in development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica, and Business Objects Data Services, XML.

Developed interface programs to import data from legacy systems and excellent skills in writing PL/SQL Stored Procedures, Functions, and Packages using Oracle 11g/10g/9i.

Design and generation of different Database Objects like Tables, Views, Synonyms, Sequences, Triggers, PL/SQL packages.

Worked on Data Conversion and Data Migration for Retail, Insurance, and Finance Domain.

Proficient in writing Packages, Stored Procedures, Functions, and Materialized views using Oracle PL/SQL.

Good experience in analysis, the design of the database and created ER Diagrams on Rational Rose using Normalization Techniques.

Experience in Performance Tuning, Optimization of SQL statements using Hints, Partitioning, and indexes.

Strong knowledge in Oracle Cursor management, Exception Handling and also Experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing Oracle reports.

Experience in using Automated Tool like JIRA.

Experience in creating generic informatica & BODI/BODS ETL job templates for different load strategies.

Experience in handling all Oracle XML structured, unstructured, and schema-based storage models.

Experienced with Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meeting, User Story Demos and Retro meetings working on Agile Project implementation for Delta Dental client.

Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.

Creation of database objects like tables, views, materialized views, stored procedures and packages using Oracle tools like Toad, PL/SQL Developer and SQL* plus.

Working knowledge in designing and implementation of multi-tier applications using Java, J2EE, JDBC, JSP, HTML, JavaScript, and CSS.

TECHNICAL SKILLS:

Data Base: Oracle 11g/10g/9i, MS Access, and MS SQL Server.

Operating Systems: Unix, Solaris, Red Hat Linux, Perl, Windows 95/98/2000/NT/XP/2007

Data Base Tools: SQL *Plus, Toad, Golden Gate, Oracle SQL Developer, SQL *loader.

ETL Tools: Informatica Power Center 8.6, BODI Data Integrator (ETL), BODS Xi3.2, 4.2.

Utilities: UTL_FILE, DBMS_PIPE, Exp, Imp and Data pump.

Languages: SQL, PL/SQL, C, C++, Java, J2EE, and UNIX Shell Scripting.

Web Technologies: HTML, CSS, Java Script Oracle APEX and XML.

Source Control: VSS, CVS, Subversion.

Methodology: Agile, Waterfall.

EMPLOYMENT HISTORY:

MUFG Union Bank– San Francisco, CA Oct 2016 – Current

Role: Oracle PL/SQL Developer

Responsibilities:

Writing Procedures, Functions, PL/SQL Packages and SQL Scripts using PL/SQL.

Working with developers to repair and enhance current base of PL/SQL packages to fix testing issues and build new functionality and improve processing time through code optimizations and indexes.

Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Triggers.

Creating PL/SQL triggers, sequences, and stored procedures using Toad.

Developing data model, PL/SQL Queries, SQL Query tuning process, and Schemas.

Formulating SQL queries, functions and processes as per customization requirement for APEX.

Providing APEX guidance & support to technical staff on application maintenance and SDLC process.

Designing multiple new features in consolidation application related to Bank app search and coded using HTML5, CSS3, and JavaScript.

Developing SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Working with DBMS_XMLGEN & DBMS_XMLSTORE package to generate and insert XML files in Oracle 11g.

Validating the functions and procedures inside the package using the various fields in Oracle APEX.

Environment: Oracle 11g, SQL, PL/SQL, Toad for Oracle 12.7, SQL Developer, SQL *Loader, Oracle APEX 4.2, Windows, MS- Excel 2013, notepad++, and Agile.

Delta Dental – San Francisco, CA May 2013 – Sept 2016

Oracle PL/SQL Developer

Responsibilities:

Worked on a data conversion project as a PL/SQL developer on critical Balance & Discrepancy (B&D) reports.

Involved in implementing business logic with Oracle stored procedures, functions and triggers using PL/SQL.

Involved in walk-through sessions with business users during the Analysis, Design, and development phase, written PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.

Worked with architects, Business Analysts, ETL developers, and QA testers to translate data requirements into the physical schema definitions for Oracle.

Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.

Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms, and Sequences.

Involved in Importing and exporting the Tables, Users, and Schemas.

Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.

Used Agile Scrum methodologies, performed standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.

Designed and developed ETL routines in BODS, modified or created new Data services jobs to meet project requirements.

Used subversion tools, SVN version management to manage various versions of the procedures and functions of the application.

Responsible for logging defects in Defect Manager, monitoring their status and tracking them to closure using JIRA.

Worked extensively through Agile development methodology by dividing the application into iterations

Worked with custom development of data warehouse, operational data store, and OLTP systems.

Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications.

Comparability methods of loading data into an SWIF database using PL/SQL and SQL*Loader.

Involved in implementing business logic with Oracle stored procedures, functions and triggers using PL/SQL.

Customized few forms for the Business manages to validate the data.

Involved in writing CTL files (control files) for SQL*Loader to load the data from flat files into oracle tables.

Generated XML files for data transformation to another system used XML parsers to parse XML data.

Have worked in fast paced AGILE environment & attended daily scrum meeting.

Environment: Oracle 11g/10g, Oracle SQL, PL/SQL, SQL Developer, SQL Developer, SQL Loader, T-SQL, JIRA, Agile/Scrum, Windows 2007, MS- Excel 2013, SVN tool, notepad++, SAP BODS 3.2, 4.2.

Mind Grid Technologies, Hyderabad, India Sept 2011 – Dec 2012

Software Programmer

Responsibilities:

Created and maintained tables, materialized views (Summary Tables), procedures, functions, and packages, and update, delete, and insert statements and compile them.

Work with architects, designers, developers to translate data requirements into the physical schema definitions for Oracle.

Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.

Coded PL/SQL subprograms and modified the existing PL/SQL program units.

Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.

Incomplete and full database recovery with experience of complex recovery scenarios.

Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.

Conducted code walk-through & internal/peer reviews on application code and other deliverables.

Detected and corrected bugs during system integration and user acceptance testing.

Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.

Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g, SQL*Loader, Oracle PL/SQL, SQL*Plus, TOAD, SQL Developer, waterfall.

EDUCATION: Master of Science in Information Systems – Texas, United States.

Contact this candidate