We provide IT Staff Augmentation Services!

Lead Pl/sql Developer Resume

Chicago, IL

SUMMARY

  • 10+ years experience Software Development and Programming, Operational Management, Credit Risk Management
  • Complete understanding of Oracle advance features.
  • Full SDLC (Software Development Life Cycle) experience; Business Analysis, data requirements gathering, Database design.
  • Extensive team leadership skills, project management, strong written and inter - personal skills, organizational skills, work ethic and drive and continually striving for process improvements make me a valuable addition to any project team.
  • Strong record for delivering high quality, robust and easily supportable solutions that on time and on budget.
  • Extensive talent for troubleshooting and providing root cause analysis as well as thinking outside the box for solutions.
  • Experience of Data modeling (both transactional -OLTP/ and dimensional -OLAP).
  • Actively involved in data profiling, cleansing and data analysis.
  • Experience in handling multiple roles - Software Requirements Analyst, Software Architect, Software Developer
  • Experience in handling off-shore teams.
  • Good communication skills, customer interaction skills, interpersonal skills, self-motivated, quick learner, team player.
  • Involved in conducting Technical Interviews in the areas of Banking and Oracle development.
  • Experience with the Software Development Life Cycle (SDLC) Process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system testing.
  • Extensive experience in Performance Tuning using various techniques like Explain Plan, generating statistics. Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries, collections, Cursors, SQL Loader and Normalization techniques .
  • Excellent analytical and problem solving skills and can work independently.
  • Strong communication and interpersonal skills, with demonstrated team dynamics.
  • Used dynamic SQL and Collections also used BULK COLLECT to load the bulk data and used PL/SQL RECORDS.
  • Worked in debugging and Tuning the PL/SQL code, Explain plan, tuning queries, optimization for the Oracle database.
  • Proficient in Oracle Forms Extensive experience with analysis, design, development, customizations and implementation of software applications.
  • Complete understanding of Oracle advance features.

TECHNICAL SKILLS

Operating Platforms: MS-DOS, Windows NT/2000

Languages: PL/SQL, SQL, SAS, Oracle forms and Reports

Tools: TOAD, PL/SQL Developer, Base SAS 9.1

DBMS: Oracle 10G, Ms Access

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Lead PL/SQL Developer

Responsibilities:

  • Worked closely with business analysts to understand the requirements, needs and use cases for Synchronization of data.
  • Gather requirements and write specification and functional design documents for software development Coordinate and communicate tasks with developers.
  • Gathered and translated business requirements into analytical applications
  • Created tables, views, indexes, synonyms, sequences in development and test environment. DBA activities also included altering tables, dropping tables, checking database space and performance tuning.
  • Scheduled jobs. Unit tested the Code.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements.
  • Worked on Advance PL SQL (Collections, Partition tables, Temporary tables)
  • Used SQL Loader to load data from flat files to the Database tables.
  • Responsible for managing scope, planning, tracking, change control, aspects of the project.
  • Responsible for effective communication with the customer and to provide project status to the customer.
  • Establish Quality Procedures and continuously monitor and audit to ensure the deliverable meets quality goals
  • Delivered the requirement to off-shore teams.

Confidential

Lead Oracle consultant

Responsibilities:

  • Joined and participated in handling planning processes
  • Documented processes and took note of gray areas that need improvement.
  • Architecture, design and implemented ETL mappings for near real time data warehouses for India credit card. Target Database is Oracle 10g.
  • Gathered and translated business requirements into analytical applications
  • Wrote PL/SQL, SQL scripts for Daily LD Process.
  • Collaborated with other project members and drive the development of BI initiatives
  • Analysis & SAS Coding for B Score generation, TTD Tracking MIS, Line Decrease MIS, Portfolio (STPL and CARDS ) MIS
  • Statistical and Analytical Report Generation for BI using SAS
  • Worked on Advance PL SQL(Collections, Partition tables, Temporary tables)
  • ETL architecture design for Data Mart Updation
  • Portfolio Risk management for ENR build-up programs - Personal loan on Credit Cards, Balance Transfer, Limit enhancement and Easy Cash (monetization of credit limit).
  • Strategic Initiatives/Projects - Good book/Bad book segmentation, Negative amortization impact, Minimum Amount Due logic change, Overlimit strategy design.

Confidential

Senior PL/SQL Developer

Responsibilities:

  • Client interaction for requirement gathering, system analysis and finalization of technical/functional
  • Executed diverse technical applications based on Trade Union
  • Data conversion and data take on using Procedures and Functions SQL Script
  • Understanding new requirements of users and adding new features the system
  • Responsible for deploying code in production environment.
  • Create and maintain indexes, constraints, tables, PL/SQL stored procedures & packages and produce queries to answer business questions.
  • Implementation and testing in UAT & LIVE environment.

Confidential

Senior Software Developer

Responsibilities:

  • Client interaction for requirement gathering, system analysis and finalization of technical/functional
  • Create tables, indexes, sequences, constraints.
  • Customization and development of forms & Reports and CSV generation using forms
  • Implementation and testing in UAT & LIVE environment.

Confidential

Senior Software Developer

Responsibilities:

  • Client interaction for requirement gathering, system analysis and finalization of technical/functional
  • Executed diverse technical applications based on Trade Union
  • Create tables, indexes, sequences, constraints.
  • Customization and development of forms & Reports and CSV generation using forms
  • Implementation and testing in UAT & LIVE environment.

Confidential

Senior Software Developer

Responsibilities:

  • Client interaction for requirement gathering, system analysis and finalization of technical/functional
  • Executed diverse technical applications based on Trade Union
  • Create and maintain indexes, constraints, tables, PL/SQL stored procedures & packages and produce queries to answer business questions.
  • Create tables, indexes, sequences, constraints.
  • Customization and development of forms & Reports and CSV generation using forms
  • Implementation and testing in UAT & LIVE environment.

Confidential

Software Developer

Responsibilities:

  • Client interaction for requirement gathering, system analysis and finalization of technical/functional
  • Executed diverse technical applications based on Trade Union
  • Create tables, indexes, sequences, constraints.
  • Customization and development of forms & Reports and CSV generation using forms
  • Implementation and testing in UAT & LIVE environment.

Hire Now