We provide IT Staff Augmentation Services!

Programmer Analyst Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Over 8 years experience as Oracle PL/SQL Developer, Database Maintenance, Coding, Design, testing Methodologies and Production Support using Oracle 8i, 9i, 10g & 11g in production, Staging environments.
  • Experience in SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, cursors and Indexes.
  • Strong in Designing, Development (coding), Testing, Implementation and Documentation as per standards.
  • Proficient in requirements gathering and analysis, validation, Business Requirements Specifications and Functional Specifications for schema creations and table creations
  • Proficient in using advance features for PL/SQL programming like Using cursor variables, Ref. cursors, System Ref. cursor and Dynamic SQL.
  • Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
  • Exposure & knowledge of designing logical &physical Data Model in Relational Database Management System (RDBMS) by using ER (Entity Relationship) diagram.
  • Knowledge in data migration activities like Export and Import utilities, Bulk copy processing (BCP), data scrubbing using Oracle data pump and SQL *Loader
  • Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Test, Implementation and Support.
  • Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization and de-normalization.
  • Hand on experience in Performance tuning, gathering table statistics for Query optimization, troubleshooting and monitored the daily running scripts to maintain and increase the performance of database.
  • Knowledge of Autonomous Transactions Materialized Views, Bulk Collects and Collections.
  • Involved in Migrating Data to Oracle database from different data source such as SQL, Flat files, Excel
  • Experience in preparing technical documentation & user manuals.
  • Provided support for RDBMS in Development, Test and Production environments using Oracle Tools.

TECHNICAL SKILLS

RDBMS: Oracle 9i, 10g/11g

Database Applications: Microsoft Access

Programming Languages: SQL, PL/SQL, Unix shell scripting, HTML, Struts,Spring Core Java, JDBC

Operating System: Windows Vista, XP, 2003, 7, 8 and Unix

Tools: SQL developer, TOAD,Data Loader, Import/Export Wizard, SQL * Loader, SQL*Plus,Oracle Forms and Reports 10g/9i/6i.

PROFESSIONAL EXPERIENCE

Confidential, San Jose CA

Programmer Analyst

Responsibilities:

  • Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
  • Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
  • Optimized SQL used in reports to improve performance dramatically.
  • Tuned and optimized the complex SQL queries.
  • Had to design database model risk management application.
  • Worked with Business users to gather requirements for developing new Reports or changes in the Reports.
  • Generated fully functional Microsoft Excel Spreadsheets using PL/SQL directly from the database.
  • Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
  • Created Cursors, Collections and DB Triggers.
  • Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  • Built process to write CSV files to load in third party applications and Parse CSV files using EXTERNAL TABLES and load them
  • Develop on demand refreshed materialized views to reduce network latency in distributed SQL queries
  • Created INDEX BY Table Method to Fetch Records in Random Selection.
  • Fine-Tuned and optimized number of SQL queries and performed code debugging using TOAD.
  • Set up batch and production jobs through Tidal.
  • Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
  • Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
  • Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
  • Tuned SQL queries, performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
  • Developed stored procedures, functions and packages for updating, inserting and deleting data from tables.

Environment: Oracle 11g, SQL, PL/SQL, SQL*LOADER, Oracle 10g RAC.

Confidential, Oakland, CA

Oracle Consultant

Responsibilities:

  • Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
  • Developed SQL scripts to create database objects like tables, views and sequences.
  • Worked on uploading the data from flat files into Databases using SQL*Loader and UNIX and validated the data with PL/SQL procedures.
  • Extracted data from legacy systems and performed transformations.
  • Prepared required documents while doing stage migrations and provided all the required data.
  • Applied validations and transformations on staging tables before finally loading them into target tables.
  • Developed SQL and PL/ SQL scripts for transfer of data between databases.
  • Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
  • Wrote shell scripts for calling SQL scripts to automate the loading and extraction process from legacy system.
  • Developed complex triggers in reports before/after for validation of user input.
  • Performed unit testing and supported system testing and end user testing.
  • Extensively worked on production issues with effective defect management.
  • Performed Tranche’s (data loads) on monthly basis.
  • Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
  • Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 11g, TOAD, SQL Loader, SQL, PL/SQL, UNIX, Putty and Windows.

Confidential, Wilmington, Delaware

PL/SQL Developer

Responsibilities:

  • Involved in SDLC gathering requirements from end users.
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Wrote Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose.
  • Used pipelined functions for faster data accessibility.
  • Writing validation packages using PL/SQL package.
  • Used PL/SQL to validate data and to populate billing tables.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Developed Installation scripts for all the deliverables.
  • Performed functional testing for the procedures and packages.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in migrating database from oracle 9i to 10g database.

Environment: Oracle 9i/10g, Oracle 10gR2, SQL, PL/SQL, Toad, SQL*Loader, SQL Navigator, Caliber, CVS, Eclipse, Quality Center, Dimensions, Windows 2000 server.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
  • Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
  • Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions
  • Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
  • Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Optimized critical queries to eliminate Full Table scans.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Involved in Gathering and Analyzing Business requirements with product management for new release cycles
  • Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
  • Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: SQL, SQL*Plus, PL/SQL, SQL*Loader, Export/ Import, Oracle Web Application Server, CVS, Toad, Oracle, Sun Solaris with Windows, XML

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
  • Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
  • Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions
  • Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
  • Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Optimized critical queries to eliminate Full Table scans.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Involved in Gathering and Analyzing Business requirements with product management for new release cycles
  • Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
  • Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: SQL, SQL*Plus, PL/SQL, SQL*Loader, Export/ Import, Oracle Web Application Server, CVS, Toad, Oracle, Sun Solaris with Windows, XML

We'd love your feedback!