Programmer Analyst Resume
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