We provide IT Staff Augmentation Services!

Oracle Sql Programmer Analyst Resume

0/5 (Submit Your Rating)

Coppell, TX

SUMMARY

  • Over seven years of experience in software development using Oracle technologies with various operating systems: UNIX, WINDOWS '95/98/00/03 and WINDOWS NT
  • Expert in Oracle 11g/10g/9i/8i, SQL, PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views, Materialized Views and PL/SQL Collections (VArrays, Nested Tables and Associative Arrays), Global Temporary Tables.
  • Significant experience designing, developing, reengineering, deploying and fine - tuning Oracle stored procedures. Extensive experience designing, developing, and implementing Extraction, Transformation, and Load (ETL) techniques on multiple database platforms.
  • Proficient at performance tuning using Explain Plan and TKPROF.
  • Excellent skills in Oracle migration, data conversion, development of database triggers, procedures, functions and packages using PL/SQL. Extensive work experience on Legacy systems
  • Substantial experience with Oracle 11g, which includes Flashback Query, Flashback Table, Bulk Collect and Bulk Bind.
  • Expertise in development of data warehousing solutions using Informatica Power Center 8.6 and 9.1.
  • Expert in analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
  • Trained in Oracle Applications HR, PAYROLL, Oracle Advanced Benefits (OAB), Self Service HR, Oracle Time and Labor (OTL), Accounts Receivable (AR), Accounts Payable (AP) and General Ledger (GL). Customized and developed Forms and reports using Forms9i/6i, Reports10g/9i, Discoverer and Crystal reports.
  • Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity while forming cohesive team environments. Excellent verbal, written and presentation skills with outstanding communication, time management and interpersonal skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Developer 2000, C, C++, Java

Database: ORACLE 10g/9i/8.x, Oracle stack environment, SQL*PLUS, SQL*LOADER, MS SQL Server, MS Access, MS Visio, MS SQL, DB2

Operating Systems: WINDOWS '95/98/00/03; WINDOWS NT; UNIX, LINUX

Development Tools: PLSQL Developer, SQL Navigator, TOAD, SQL Loader, TKPROF, EXPLAIN PLAN (for Performance tuning), ETL Tools Informatica Power Center 8.6.1, Crystal Reports 10, Discoverer 9i, Oracle Forms 9i/6i and Reports 9i/10g

Web Technologies: HTML, XML, SOAPUI 3.6.1

Methodologies: E-R Modeling, Dimensional Modeling

Others: MS Office, StarTeam (tool for source code control), IBM Rational ClearCase, ClearQuest, Quality Center, SVN, CVS (Concurrent Versions System), PVCS

PROFESSIONAL EXPERIENCE

Oracle SQL Programmer Analyst

Confidential, Coppell, TX

Responsibilities:

  • Developed Oracle SQL and PL/SQL database objects. Development and integration efforts required with SQL Server and MySQL database structures and objects as well.
  • Provide maintenance and support and perform development activities as well that are classified as Change Requests to enhance the system functionality.
  • Developed stored procedures, SQL scripts, SSIS, and transactional-SQL calls along with working with ETL, Java and .Net teams. Lead or contribute to query and module optimization efforts.
  • Collaborate with data management staff and architects to facilitate data modeling, DDL generation and versioning.
  • Experience working in Oracle database components including database enterprise, lifecycle management pack, diagnostics pack, advanced compression, advanced security and vault.
  • Collaborate with architecture and application development staff to establish and adhere to industry and enterprise best practices for development and optimization of database integration.
  • Write and review technical specifications based on database requirements and functional specifications. Approve database technical specifications written by analysts and other developers.
  • Contribute to development and publication of release documentation and the development of code to facilitate the migration and conversion of data.
  • Assist with select quality assurance tasks, including test data preparation, defect root cause analysis and production support.
  • Performed DML operations using Utility Man to support production environment for user/developer generated issues.
  • Work within multiple software development life cycle (SDLC) models Waterfall and Agile.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, ERP, SQL Navigator, Windows XP, MS-Excel, SVN for source control, Utility Man

Oracle PL/SQL Programmer Analyst

Confidential, Omaha, NE

Responsibilities:

  • Working with team DOIT (Division Of Information Technology) of more TEMPthan 20. And reporting to my lead of every task assigned to me.
  • Involved in providing technical support throughout university Banner that includes several modules, General, Student, Financial Aid, Accounts Receivable, Advancement, Finance and Human Resources. Worked on web-based applications, based on HTML and Java scripts.
  • Experience working in Oracle stack environment including business intelligence enterprise edition, Oracle Linux, enterprise repository, web logic suite and management pack.
  • Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
  • Collaborating with programmers and advancement services group on application specifications and system enhancements to ensure appropriateness of design.
  • Involved in analyzing PL/SQL Program units like Packages, Procedures and functions to provide answers to the questions of testing teams. Used database objects within ERP (Enterprise Resource Planning) system to maintain consistency.
  • Developed several discoverer reports based on the requirements from Clients/Users from different departments in the university.
  • Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and proposed IT solutions.
  • Involved in re-writing several PL/SQL coding for existing web based and windows based.
  • Wrote SQL Queries and developed PL/SQL Packages for data loading. Wrote SQL code to create JOINS, VIEWS on various tables. Worked on external tables and global temporary tables.
  • Involved in designing the PL/SQL procedures for obtaining the data from all systems to Data Warehousing system.
  • Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, VArrays, Records, Types, MV’s, Dynamic SQL, DBMS UTIL, DBMS PROFILE and UTL RAW.
  • Developed Error-Handling package using PL/SQL tables to handle user defined errors.
  • Developed a routine to use autonomous transaction and capture output into logging tables and log files. Worked on enterprise application creating new outbound and inbound packages to import data into Banner and export data from Banner
  • Highly skilled in using Bulk processing, REF cursors, collections PL/SQL development.
  • Performed the uploading and downloading flat files from UNIX server using FTP, SFTP and Amazon S3.
  • Involved in designing Oracle Forms and Reports related to Banner by interacting directly with End Users and Business Analyst.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Business Objects, ERP, SQL Navigator, Windows XP, MS-Excel, Microsoft VSS, Amazon S3, Oracle Forms 9i and reports 10g.

Sr. Oracle Programmer Analyst

Confidential, Plymouth Meeting, PA

Responsibilities:

  • Provide maintenance and support and perform development activities as well that are classified as Change Requests to enhance the system functionality.
  • TEMPHas handled severity one issues and managed user service incidents.
  • TEMPHas functioned as an onshore support for the Customer Orders; Inbound/Outbound and handled change requests that are related to making data available for the store through the DT (Delivery terminal) or a CDC (Common Delivery Center).
  • Performed development activities in the IDRS ( Confidential Data Routing System) as well, which determines the method and ways that the data is flowing in and out of various systems in the architectural framework. Gemini uses the data sent from IDRS to be loaded into its system using SQL Loader.
  • Responsible for working on logging database call timings in for built-in application GEMINI.
  • Generated AWR reports and constantly monitored the reports to check the DBtime for DB usage performance and SQL statistics. Developed complex queries to retrieve the data
  • Writing PL/SQL code using the technical and functional specifications.
  • Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers. Used Bulk Collect feature to improve performance.
  • Identified and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Performed Tuning using Explain Plan, Tkprof, Hints and Indexes. Used TOAD, PL/SQL developer tools for faster application development.
  • Provided migration assistance for the Gemini application migration from VB toVB.NETplatform. Responsible for maintaining VOB database including backups.
  • Evaluated the impact and changed the Gemini system to include an error logging framework mechanism and replaced the already existing logging mechanism that used UTL files to generate log files. This was performed to create the SCAD logs that can be monitored to create an event/incident in iDesk and thus proactively avoid a Severity one issue.
  • TEMPHas performed the role of a deployer and execution in the “COP” and “Gemini” schemas.
  • Read data from flat files and uploading that data into oracle tables using SQL*loader and toad.
  • Developed Informatica mappings, sessions and workflows.
  • Ensured timely delivery of required ETL tasks, used workflow manager to schedule different tasks. Scheduled different workflows on daily, weekly and monthly basis.
  • Writing test cases in Quality Center for unit testing, performance testing and user acceptance testing. Developed PL/SQL batch processing jobs using UNIX Shell scripting.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, Toad, Microsoft office Visio 2007, ClearCaseClearQuest, Quality Center, UNIX, iDesk, Built-in applications in Confidential (GEMINI), Informatica Power Center 8.6.1, Crystal Reports 10

Sr. Oracle PL/SQL Developer

Confidential, Albany, NY

Responsibilities:

  • Worked as part of BHAE team in development and design for doing migration from Sybase to Oracle.
  • Worked on mapping database tables in Sybase to be converted to Oracle.
  • Was assigned to work on DBA tasks like creating E-R diagrams, database objects
  • Dealing with health related data coming and creating data models of objects in Oracle.
  • As a team I was involved in modifying existing code to be used in Oracle.
  • Involved in building the synchronization process between thelegacy databases and new Oracle design. Support developmentfor retrieving and submitting data to tanew Oracle design
  • Experienced in using Oracle Utility programs like SQL*Loader and External Tables.
  • Extensively involved in performance tuning for various oracle based application using various methods like EXPLAIN PLAN, TKPROF etc.
  • Experienced in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.
  • Proficiency in understanding clients needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
  • Worked on Oracle APEX to generate real time benchmark reports based on health safety data.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, Microsoft Visual SourceSafe 6.0, Microsoft office Visio 2007, SQL Developer, Crystal Reports 10, Oracle APEX

Sr. Oracle Programmer Analyst

Confidential, Tacoma, WA

Responsibilities:

  • As a team I was involved in application delivery for all the Provider data from provider information management system (PIMS) to facets.
  • Involved in Provider data extraction from PIMS and data is mapped via data stage to XP/F input format, which is, further batch loaded to facets database.
  • Worked on oracle packages and UNIX shell scripts used to send extract files from PIMS every night to TriWest of providers and addresses.
  • Written several SQL scripts for views as a part of data extraction from provider information management system to Facets.
  • Worked on projects at Regence for which front-end is developed in .net and backend being Oracle. Used SOAPUI to unit test PL/SQL code and service
  • Involved in writing several PL/SQL blocks for several other projects like Network and Agreement translations, Search service for Provider and Provider languages
  • Interacted with other team members Iteration testing team for testing support, DBA for deployment support and Web application development team
  • Worked on Impact analysis and Estimation documentation for the changes in database objects.
  • Created Indexes, Records, Tables, and Objects, Collections (Nested Tables and Varrays), Error Handling and data model for database objects as per the requirements.
  • Worked on performance tuning issues of existing complex database scripts. Used explain plan and auto trace to verify missing indexes on tables
  • Expertise in developing of data warehousing solutions using Informatica Power Center 9.1
  • Extraction, transformation and loading data from heterogeneous sources systems like Flat files, Oracle, SQL Server.
  • Hands on experience on various transformations like Unconnected & Connected lookups, Router, Filter, Sequence, Aggregator, Joiner and Reusable transformations.
  • Wrote control files (CTL) and scripts to load data from ASCII/flat files into Oracle Database.
  • Installed utPLSQL in development, system testing and user acceptance testing databases and created test cases to ensure quality and correctness of production code prior to production release.
  • Involved in creating user friendly Oracle Forms for Data Entry, search criteria and other Utilities called PIMS at Regence.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, Toad, PIMS system, Microsoft Visual SourceSafe 6.0, SOAPUI 3.6.1, Microsoft office Visio 2007, Informatica Power Center 9.1, Oracle Forms and reports

Sr. Oracle Programmer Analyst

Confidential, Lake Oswego, OR

Responsibilities:

  • Involved in analyzing business requirements, design and code programming solutions.
  • Working with several organizations within Kaiser to coordinate the delivery of program changes within a planned release schedule.
  • Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
  • Interacting with PROD team, Data Base Administration, Release Management, Enterprise Testing, User Acceptance testing.
  • Monitoring progress of assigned work, resolving development issues and providing project status information.
  • Involved in writing complex queries and performed tuning using hints, Indexes and Explain plan.
  • UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
  • Used SQL* Loader to upload bulk data from flat files by writing scripts for the Control file.
  • Responsible for the Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
  • Worked extensively with Aggregator, Lookup, Sequence Generator, Stored Procedure, Router and Expression Transformations.
  • Using Informatica Designer to create or modify mappings, Mapplet, Reusable Transformations.
  • Using Informatica Workflow Manager to create or modify different types of tasks like session, email, timer, event wait, event raise etc. Scheduling and running the Workflows
  • Developed several UNIX shell scripts to automate data extraction using VI editor, SQL scripts and PL/SQL scripts.
  • Involved in FTP scripts to send extracted files within the same organization and SFTP shell scripts to send extracted files to (UNIX, WINDOWS and IBM environments) several other organizations within Kaiser.
  • Writing validation scripts for the ease of production team to validate the code in PROD environment. Involved in Production support and Maintenance.
  • Worked in Oracle BI Tools like Oracle Reports 9i /Forms 6i / BI Publisher
  • Involved in the design and development of User Interface using Oracle Forms, which was integrated with menus, tabbed canvas and reports.

Environment: Oracle 9i, UNIX Korn Shell Programming, PowerBuilder, SQL, PL/SQL, SQL*Plus, Toad, SQL Navigator 4.5, SQL Loader, Windows NT, Starteam, Oracle Forms 6i and Reports 9i

Trainee - Oracle Apps Developer

Confidential, Houston, TX

Responsibilities:

  • Trained in RICE (REPORTS, INTERFACES, CONVERSIONS, and Enhancements) methodologies including Implementation and Data Migration, experience in up gradation of Oracle Apps 11i and Implementation of Oracle Apps11i.
  • Trained to troubleshoot issues related to functional or technical bugs.
  • Design and development of associated INTERFACES using PL/SQL Packages and data conversion from Legacy to Oracle HRMS.
  • As a team we have accomplished Employee Conversion that include person information, address, SIT, assignment information (GRE, time card info, position, job, grade, organization and location), salary, taxes, payment methods and Element entries using Oracle HR/PAYROLL APIs.
  • Running PAYROLL, Pre-Payments, and Costing, Quick Pay and Enhanced Retro Pay.
  • Populated 401K and service data through API’s in HRMS system. Worked on 401K outbound INTERFACES.
  • Developed brand new OAB fast formulas for Enrollment Coverage Start Date, Person Change Cause Life event and Rate Start Date formula types.
  • Involved in defining Derived factors, Eligibility profiles, defining Plans, Plan types, Options and Programs. Created custom REPORTS using XML publisher and DISCOVERER.
  • Created and worked on TAR with Oracle Corp. in solving production issues.
  • Wrote UNIX Korn SHELL scripts for automation of jobs.

Environment: Oracle Apps 11i, Oracle 9i, UNIX Korn Shell Programming, SQL Navigator, PLSQL Developer, TOAD, SQL Developer, SQL Loader, XML Publisher, Oracle Developer REPORTS and FORMS 6i, Crystal Reports 10, BI Publisher

Trainee - Oracle Apps Developer

Confidential, Sugarland, TX

Responsibilities:

  • Trained in developing Oracle database. Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers.
  • Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10g database.
  • Conducted performance tuning of applications through tuning pack and SQL*Navigator, SQL*TRACE, TKPROF utilities.
  • Customization of Forms, Reports, XML Reports and Interfaces related with AR.
  • Extensively used AR, AP and GL interfacing tables for customizing the reports.
  • Auto Lockbox customization for loading receipt data into AR.
  • Developed SQL * Loader Scripts for importing legacy systems data into AR interface tables.
  • Registered all the programs as concurrent programs, DFF flex fields and table registration under client custom application. Ability to create Service Requests and RFCs using Oracle Metalink.

Environment: Oracle Apps 11i, Oracle 9i, SQL Navigator, PLSQL Developer, TOAD, SQL Developer, SQL Loader, XML Publisher, Oracle Developer REPORTS and FORMS 6i.

We'd love your feedback!