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.