PL/SQL Lead Developer Resume Charlotte - NC - Hire IT People

SUMMARY

Over 7.5 years of professional experience in Database technology, PL/SQL Development, Database design and relational modeling, Oracle reporting, Oracle EBS 11.5.10/R12(HRMS/OAB/AR).
Extensive experience and knowledge of Healthcare and HRMS domain and implementation of Annual Enrollment changes. Worked on implementation and customization of Oracle EBS Modules - HRMS/OAB using seeded configuration and coding of Reports, Extensions and fast formulas.
Good Coding Experience in Oracle SQL and PL/SQL.
Good experience in developing stored procedures, functions, packages, views, cursors, PLSQL collections, records, object types and database triggers.
Hands on experience in creating and maintaining database objects like tables, views, materialized views, indexes, sequences, synonyms and database links.
Extensively worked on Oracle RICE component for HRMS module.
Experienced in collaborating with business analysts and developers to analyze the user requirements, functional specifications and system specifications
Experienced in working in an environment with remote offshore and client team members to track and manage project deliverables
Good understanding of the Software Development Life Cycle (SDLC).
Hands on experience on writing Technical System Design (TSD) and User Manual documents.
Well-structured, self-motivated with strong work ethics and willingness to adapt and work hard to achieve employer’s goals.
A strong team player with Excellent Leadership and Interpersonal and Communication Skills and ready to take an independent challenge.

TECHNICAL SKILLS

Database: Oracle 11g, Oracle 10g, Oracle 9i

Development Tools/Technologies: SQL*Plus, SQL Navigator 5.5, ToadOracle Forms 6i, Oracle Reports 6i, PL/SQL DeveloperSQL*Loader

Operating Systems: Windows XP, Windows 95/98/NT 4.0/2000, Unix, Linux

Version Control Tools: Rational Clearcase, Visual Source Safe (VSS)

Oracle Applications: PL/SQL, Oracle Advanced Benefits (OAB)/HRMS, Data Relationship Management (DRM)

Quality Control: HP Quality Center and HP PPMC

PROFESSIONAL EXPERIENCE

Confidential, Charlotte - NC

PL/SQL Lead Developer

Responsibilities:

Worked on creation of Export, Import, Properties and Validations in the DRM application.
Worked on Data Migration from one environment to other environment without any hustle and issue.
Sucessfully involved in two of the major releases.
Involved in bug fixing into existing model.
Involved in doing any enhancement related activities which come as new requirement.
Providng dailiy support for any time critical issues and provding immediate workaround and fixing the issues in next available releases

Confidential, Merrimack, NH

PL/SQL Lead Developer

Responsibilities:

Designed and developed Universal Extract Formatter, a multi-threaded object based report generation application capable of generating output in multiple formats including ANSI5010 using PL/SQL. Designed and implemented application data model to support configurable reports.
Developed Multi Client W2 Reporting by using distributed computing approach to collate results from OAB, AP and AR systems.
Application supports creating output in multiple formats including ANSI5010, Fixed Width and Delimited, by extracting data from large tables with over 100 M records.
Led a team of developers to successfully implement over 125 ANSI files across 17 Clients on Universal Extract Formatter to ensure compliance and improve report run time and client satisfaction.
Involded in various activities as Planning, gap analysis, high level design, coding, unit testing, code-review and providing support to QA.
Worked as Onsite Coordinator with all the roles as Estimation of tasks and scheduling, Task prioritization and delegation to team members, Task monitoring and status reporting of the allocated tasks, Resolving technical queries of team members and, Providing QA and production support.

Confidential, Merrimack, NH

Software Engineer

Responsibilities:

Development of Fast formulas /Rule and Oracle Procedures on PL/SQL for Life Events, Derived Factors and Eligibility, Carrier Extracts and Communications.
Requirements analysis, Impact Analysis and Design for bug fixes, Enhancements for Annual Enrollment changes.
Configuration of Benefits Structure, Eligibility, Rates & Life Events for Bug fixes, enhancements and Annual Enrollments.
Configuration of Carrier Extracts.
Was involved with Setting up of new plans, Options, Eligibility profiles, Rates, Coverages, Electability and other configurable items as per the requirements.
Trouble shooting of Fast formulas and Oracle Procedures in Live Events & Extracts.
Development, Review and Unit Testing for changes implemented.
Creation and execution of Unit testing scenarios for business requirements.
Configuration Management
Creating test cases, performing unit testing and documenting test results.
Migrating changes to production and validating production changes.
Was involved with running open enrollment related processes and providing post open enrollment support.

We provide IT Staff Augmentation Services!

Pl/sql Lead Developer Resume

Charlotte -, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship