We provide IT Staff Augmentation Services!

Sr. Pl/sql Engineer Resume

2.00/5 (Submit Your Rating)
Hire Now

SUMMARY

  • Professional dedicated and motivated Application Developer with extensive experience in healthcare and automotive manufacturing industries.
  • Support mission critical systems while maintaining a high level of customer satisfaction.
  • Demonstrates exceptional skills in the following areas: software development, business analysis, requirements gathering, problem solving, end user training and support, strategic thinking and job completion under tight constraints

TECHNICAL SKILLS

Platforms: Microsoft Windows® operating systems. Some Unix.

Languages: Oracle PL/SQL, SQL PL for UDB, SQL, VB6, ASP, MicroFocus COBOL, MVS COBOL, JCL, DCConnect (Barcode Scanner programming language)

Databases: Oracle, DB2, IMS, UDB

Tools: TOAD, DB2 Development Center, SharePoint, Confidential Quality Center, Oracle Discoverer, Microsoft Visual Studio, Visual Interdev, Endevor, Spufi, Textpad, pcAnywhere, Borland StarTeam, Visual Studios TFS, Clarity, Erwin.

Manufacturing Systems: SCM (Supply Chain Management), INV (Inventory Control), Transportation, BOM (Bill of Materials), Barcode Scanning, Logistics.

Health Care Systems: Medical Claims, RX Claims and Membership Processing, Disease Identification, Business Rules analysis.

PROFESSIONAL EXPERIENCE

Confidential

Sr. PL/SQL Engineer

Responsibilities:

  • Use TOAD to develop and modify Oracle PL/SQL applications.
  • Extensively utilize SQL to modify the system as needed and to understand the relationship of the various normalized tables.
  • Utilize Visual Studios TFS for source control and task creation and monitoring.
  • Understand the relationship of the database layer of applications as called by the Java UI layer.
  • Follow SCRUM Agile development practices to move in changes in regular Sprints.

Confidential

QA Analyst

Responsibilities:

  • Use TOAD to develop Oracle PL/SQL anonymous blocks to setup test data and utilize sequences.
  • Continually develop SQL to validate processes and retrieve test data.
  • Analyze functional requirements to help develop proper testing strategies.
  • Oversee three offshore testing teams. Two teams in India and one team in the Philippines.
  • Check in procedures into Visual Studios 2010 TFS.

Confidential

Application Developer and Analyst

Responsibilities:

  • Created and maintained Oracle PL/SQL packages, procedures and functions. Created triggers and indexes as needed.
  • All coding and database work performed in TOAD.
  • Maintained code versioning in Starteam. Starteam was also used for Release Management.
  • Analyze the new system process, procedures and logic using knowledge and expertise acquired from years of working in the legacy system to ensure that the new process is meeting all expectations with little or no requirement documents available.
  • Create test cases in Confidential Quality Center to test new systems. Also create Oracle PL/SQL procedures and scripts to run tests and compare data.
  • Improved applications to reduce auditing time by 4 to 6 hours per week for operations analyst.
  • Improved efficiencies of legacy code and tuned systems to reduce run time by hours. This was accomplished through code improvements and tuning.

Confidential

IT Specialist

Responsibilities:

  • Nissan decided to create a complete Data Model of their Oracle systems. Used Erwin to reverse engineer existing tables. Relationships between tables were added after tables were generated in Erwin.
  • Successfully lead project to replace out - dated and unsupported barcode data collection terminals and upgrade client and server applications. Successfully assisted in application rewrite of system to covert from antiquated OS/2 based servers to windows based servers converting applications from C to VB components with ASP front end for user interface. This reduced downtime and improved accuracy and response time for company.
  • Created test plans and training documentation for users and held user training classes and presentations. This effort brought the applications and hardware up to a current status.
  • Initiated change on system applications to reduce program run time from 20 hours to 40 minutes. Continue to support system and implement enhancements to allow system to adjust to changing business goals and environment.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship