We provide IT Staff Augmentation Services!

Technical Consultant Resume

5.00/5 (Submit Your Rating)

Irvine, CA

SUMMARY

  • Around 8 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports .
  • Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
  • Excellent conceptual knowledge of Oracle 11g, PL/SQL and SQL.
  • Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, Packages, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
  • Experience in developing External Tables, Joins, Indexes and sequences.
  • Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
  • Good in creating users and maintaining their roles and responsibilities.
  • Experience in the full System Development Life Cycle (SDLC) with understanding of a variety of technologies and platforms such as web, client/server, entity - relationship diagrams (ERDs), relational database concepts and object-oriented programming.
  • Strong interpersonal skills, ability to interact with people Confidential all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Databases and Tools: Oracle 11g, TOAD, SQL*PLUS, SQL*Loader, Discoverer 4i, Workflow, Forms 10g/11g, Form Builder 10g/11g, Reports 10g/11g, Form Builder 10g/11g, UNIX Shell Scripting, Toad, ER-Win

Application Tools: XML publisher, ALM, HPQC, Agile

Operating Systems: Windows XP/2000/98, UNIX.

Languages: SQL, PL/SQL, JAVA, C, C++

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Responsibilities:

  • Analyzed, designed, modeled, and implemented new database schemas.
  • Responsible for creation of Data Clean-up procedures, transformations, Scripts, Stored Procedures and execution of test plan for loading the data successfully into the targets
  • Involved in designing database architecture and technical documents for better understanding the relations, associations and dependencies within the application.
  • Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements
  • Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
  • Performed Unit Testing and Integration testing for the ETL's.
  • Oracle Back-end SQL, PL/SQL Development i.e. Complex SQL Queries containing hundreds of LOC, Views, Packages, Stored Procedures, Functions & Triggers.
  • Developed and customized several Oracle Forms and Reports using Forms/Reports builder, Crystal Reports, XML publisher and Discoverer as per client specifications.
  • Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
  • Good knowledge on Upgrading Oracle Forms Reports.
  • Coordinated and collaborated with the solution delivery teams in onsite/offshore to ensure project deliverables and timeliness are met
  • Periodically appraised client and internal management about the health of the project

Environment: Oracle 11g,12 c Oracle, PL/SQL, TOAD, SQL Developer, Oracle Applications R12, PUTTY, Forms 11g and Reports10g, WINSCP, Shell Scripting, XML Publisher, Kintana, SQL*loader, Stored Procedures/Triggers, Windows 10,Perforce.

Confidential

Oracle Developer

Responsibilities:

  • Worked with the Business analysts and the Oracle Developer for requirements gathering, business analysis, testing metrics and project coordination.
  • Involved in logical modeling and physical modeling of application.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Involved in creation of Conceptual Modeling covering all the business requirements.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Queries, SQL Query tuning process and Schemas.
  • Created SQL*plus reports as per client's various needs and developed business objects.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed Procedures for efficient error handling process by capturing errors into user managed tables.
  • 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.
  • Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE .

Environment: PL/SQL; SQL; SQL*Plus; Oracle 11g; Oracle Forms 10g; Sun Solaris Unix; Windows 7; TOAD; Oracle Portal, HTMLDB; Oracle Reports 10g, 6i;

Confidential, Irvine, CA

Oracle Developer and Analyst

Responsibilities:

  • Built custom reports using Report 6i to solve the client’s reporting needs.
  • Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
  • Developed interface programs to import parts information to inventory base tables.
  • Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
  • Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
  • Developed in development of shell scripts to send invoices to customer through mailing.
  • Developed procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
  • Designed and developed various custom packages triggers and forms.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE
  • Developed performance Tuning to enhance the quality for all current and future code development using hints for SQL for determining instance and I/O efficiency and using TKPROF.
  • Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 11g; Oracle Forms 10g; Sun Solaris Unix; Windows 7; TOAD; Oracle Portal, HTMLDB; Oracle Reports 10g, 6i;

We'd love your feedback!