Objective

Highly motivated creative and organized IT Professional seeking a challenging position as an Oracle PL/SQL Developer.

Summery

• 6+ years of diversified experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.
• Proficient working experience in SQL, PL/SQL,StoredProcedures, Functions, Packages, DB Triggers and Indexes.
• Experienced in Tuning SQLStatements and PL/SQLProcedures for enhancing performance across databases.
• Worked on Table Partitioning, Bulk Binds, Bulk Collects, and PL/SQL Collections.
• Utilization of advance futures of Oracle 10g for PL/SQL programming (like Using cursor variables, Ref. cursors, varrays, hints, Dynamic SQL, ORA_HASH(), and PRAGME EXCEPTION_INIT.
• Good knowledge of using DBMS Oracle supplied package
• Designed Unix Shell Scripts and set the Cron jobs
• Good expertise using PRAGMA AUTONOMOUS_TRANSACTION
• Used TOAD to make database application development faster and easier also to simplify day to day administration tasks.
• Good knowledge of working with materialized views, Global Temporary Tables, and SYS_CONTEXT global/session variables.
• Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementation and maintenance.
• Work closely with application architect, DBA to define requirements and interfaces and to implement business logic.
• Worked as system analyst/module lead/Sr. Oracle Developer to analyze and gather the business requirements, create the Functional, Technical and Unit Testing documents, implement and review the requirements, perform unit testing, supportSIT and production release and help creating Operations/users manual.
• Provided 24X7 production/on-call support.
• Participated in QA processes like maintaining the Approval Records and, Traceability matrix document to map the business requirements to the functional, technical and testing document in order to ensure each requirement is implemented.
• Experience working with the document and code version management tools like VSS, PVCS and Share Point.
• Experience working with scheduling tools like JCI and Tidal.
• Efficiently worked as onsite coordinator in the onsite offshore working model.
• Awarded for hard work, commitment, fast problem solving skills and maintaining positive attitude through out the SDLC of the project.

Skills set

OS: Solaris5.9, Windows XP/2000, MS-Dos, HP-UX 11.00
Database: Oracle 10g, Oracle 9i, Oracle8i
Tools: SQL*Plus, iSQL*Plus, Toad Professional, SQL Developer 1.2, PL/SQL
Developer 6.0, Oracle forms9i and reports9i, Visual Studio, Crystal Reports
Scheduling Tools: Tidal, JCI, DBMS_SCHEDULER, UNIX Cron
Version
Management Tools: PVCS, VSS, Share Point
File Transfer: FTP, Smart FTP, Hummingbird, WinSCP
Languages: SQL, PL/SQL, Shell Scripting, C

Certificate Of Excellence

• Oracle Certified Associate. SQL certification (Exam iZ0 007)
• Oracle Certified Associate PL/SQL Developer Certification (Exam iZ0 147)
• Brainbench Certified in Oracle Developer

PROFESSIONAL EXPERIENCE

Confidential
Houston, TX Feb 2009 - Present
Role: Sr Oracle Developer

Litton Loan Servicing LP is one of the premier residential mortgage servicers in the industry as it works to cure problem loans and prevent foreclosures by providing delinquent customers with a full range of structured counseling and support services. Some of the Support services at Litton include collections, payoff, bankruptcy, short sale, deed in lieu, and foreclosure.

Responsibility

• Worked as lead developer on the projects like HAMP (Home Affordable Modification Program) and HAFA (Home Affordable Foreclosure Alternatives Program) and met hard deadline provided by treasury.
• Designed the specifications by co-coordinating with business users to successfully implement the government directives like HAMP and HAFA.
• Designed, developed, released and supported systems like MODTrack to track loan modifications and ALTrack to track asset liquidation.
• Designed and developed EWM (Enterprise Workflow Manager) to automate and evenly balance the work load among agents.
• Created Design, testing and release documents and scheduled reviews with business teams.
• Coordinate with business team to receive feedbacks and system enhancement requirements.
• Wrote PL/SQL Packages, Procedures, and Functions and utilized advance oracle features like: Defer Transaction, Session/transaction variables, HTML and File Extract packages.
• Performed performance tuning to make the online transactions work faster for business users.
• Used Materialized views, Global Temporary Tables, DBMS_SCHEDULER, Oracle hints, and Pipelined functions to implement and enhance performance of different systems.
• Scheduled jobs to provide automating boarding of loans into the MODTrack and ALTrack systems.
• Worked on the developing EWM (Enterprise Workflow Manager) to automatically manage work for Loss Mit, Payoff, and Collections teams.
• Provided 24X7 on-call support.

Environment: Oracle 10g, Windows XP/2000, HP UNIX, TOAD Professional, Putty, Visual Studio

Supply Chain Release 521 and 522
Confidential, Downers Grove, IL Nov 2007 - Jan 2009
Data Management and Integration Module
Role: System Analyst/ Module lead/ Onsite-offshore coordinator/ Oracle pl/sql developer

SCR (supply chain release) is the supply chain planning software solution designed to support the replenishment process of restaurant order proposals (ROP) for McDonald's restaurants. The goal of the SCR/ROP initiative is to improve restaurant operations by removing ordering from the restaurant and creating a more accurate 'automatic' order for the Top 8 McDonald's markets and beyond (Australia, Canada, China, France, Germany, Japan, UK, and US). Data Management and Integration module receives and processes data in and out of SCR using standard interfaces. This module manages Master, Transactional, Semi-transactional and Historical data.

Responsibility
SCR521 - Functional Release

• Analyze and review Business Requirement and Specification documents.
• Coordinate with business team to provide and receive feedbacks on the business requirements.
• Analyze existing 4 - level BOM structure and build 5 - level BOM (Bill Of Material) structure for master data management.
• Create Process Flow Diagrams, and End2End Data Flow diagrams using Visual Studio.
• Create Functional Design documents, and hold the reviews with business and IT team.
• Create Technical Design documents, and hold the reviews with IT team.
• Create Unit Test Script and define Test Data.
• Provide input to create logical data model.
• Develop PL/SQL Packages, Procedures, Functions, SQLLDR control files, and UNIX shell scripts as required to load and transform master, transactional, semi-transactional and historical data into database.
• Developed Unix Cron and Daemon scripts, configured job chins to automate the data load and transformation.
• Hold code reviews with the DBA team.
• Perform Unit testing and document Unit Test Results.
• Coordinate with offshore team, provide work guide lines and participate in resource management.
• Coordinate with SP (Supply Planning) and DP (Demand Planning) modules to understand their data requirements.
• Review and resolve the code defects as part of supporting SIT (System Integration Testing).

SCR522 - Scalability Release

• Analyze and review BRS and TRS documents.
• Create Functional and Technical Design documents.
• SQL and PL/SQL Performance Tuning.
• Utilize bulk bind, bulk collect, GTT, materialized view and pipelined functions to improve performance of the existing code and develop new program components as required.
• Utilize character based array and ORA_HASH() function to improve performance and/or pattern matching.
• Write Dynamic SQL to improve performance and to build complex queries at runtime.
• Used explain plan utility to analyze the SQL queries.
• Coordinate with offshore team, provide work guide lines, review and provide feedbacks on the design documents and code.
• Coordinate with SP (Supply Planning) and DP (Demand Planning) modules to understand their performance requirements.
• Perform Unit Testing and support SIT.

Environment: Oracle 10g, HP UNIX, SQL*Plus, TOAD Professional, Putty, WinSCP, Visual Studio

Confidential, Jan 2007 - Oct 2007
IL Secretary of State, Springfield, IL
PL/SQL Developer

The project was developed for the Illinois Secretary of State's vehicle services division. Titles entry system and Registration Entry system are the two different applications have separate instances. From all over Illinois State the vehicle title applications submitted by the customers will be keyed through the Titles Entry System, in the same way the new vehicle Registration and Registration Renewal applications keyed through the Registration entry system. Coming to the technical aspects of the application, it is developed using the Oracle web tool kit (HTML, DHML, embedded Java Script and CSS) and deployed the application using the Oracle Application Server 9i.

Responsibility

• Involved in application tuning of database by defining the suitable indexes.
• Optimized and enhanced the existing procedures and SQL statements for the better performance
• Maintained the data integrity and security using integrity constraints and database triggers
• Created Stored Program Units in the Form of Packages, Functions, Triggers, Triggers and Procedures for implementing the database intensive business rules.
• Well versed with Explain Plan, TKProf and Statspack
• Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the code portable to any platform.
• Used Pragma AUTONOMUOS_TRANSACTION to avoid mutating problem in database triggers
• Used PL/SQL%TYPE and PL/SQL%ROWTYPE declaration attributes to make PL/SQL codes easier to maintain.
• Used different parameter modes like IN, OUT and INOUT with the stored procedures.
• Implemented overloading feature of packages to make your package-based features as accessible as possible.
• Used Raise_application_error, procedure of package DBMS_STANDARD, to issue an user defined error messages from stored sub-program or database trigger
• Using SQL Loader for populating static tables and fact tables from CSV files.
• Performed Unit testing.

Environment: Oracle 10g, Windows XP, SQL*Plus, TOAD 9.1, Oracle Forms6i and Reports6i

INDUSTRY EXPERIENCE:

• Mortgage/Loan Servicing
• Supply chain
• Retail

EDUCATION

• MS with Electrical and computer science New York Institute of Technology
• BE with Electrical Engineering