Sql Developer

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

PROFESSIONAL SUMMARY:

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

Experienced in all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance against aggressive deadlines.

Designed and generated different Oracle Database Objects like Tables, Views (B Tree, Bit Map, and function based), Synonyms, Sequences, PL/SQL packages, and Database Triggers.

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

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

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

Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning, indexes, and materialized views.

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.

Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.

Experience in using Automated Tool like Atlassian JIRA.

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.

Experienced with oracle programming in Toad for Oracle, SQL Developer, SQL *plus and Golden gate tools.

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

Well-being with Oracle DBA tasks Database Backups RMAN, and in traditional hot/cold backups.

Experienced in using ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

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), SAP BODS 3.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 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.

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 on enhancements & defects as per the business requirements.

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

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 Database Triggers.

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

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

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

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 Jan 2015 – 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 used DML 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

Tracked defects using JIRA and generated defect summary reports.

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.

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 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 status and tracking them to closure using JIRA.

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

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

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

Elavon - Atlanta, GA Feb 2013 – Dec 2014

Oracle PL/SQL Developer

Responsibilities:

Involved in requirement analysis, preparing functional specifications, system design, development and database administration.

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

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.

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

Involved in migrating from mainframes to Oracle 11g.

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.

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

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

Create Subscriptions in Data Mirror with different Mapping Types.

Wrote SQL and PL/SQL programming code for ODI and oracle.

Developed extraction mappings to load data from Source systems to Data Warehouse.

Loaded data in Staging and Production databases.

Used Unix Shell Scripts for Code optimization and Performance tuning of the application.

Environment: Oracle 11g (SQL, PL/SQL), SQL Loader, T-SQL, Golden Gate, Erwin, TOAD, Rational Rose, Informatica Power center, Agile, Windows 2007/XP.

Mind Grid Technologies, Hyderabad, India Jan 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