SUMMARY:

• PL/SQL & APEX Developer/Lead - having 9 years of development experience in Oracle database & working for renowned organizations in Finance, Healthcare & Telecommunication domains along with lead level experience of handling multiple team members and multiple projects.
• Extensively worked on various aspects of SDLC (Software Development Lifecycle) from requirement gathering to design & development of code & unit testing.
• Handled different software development methodologies - Agile and Waterfall.
• Involved in the design of interfaces that facilitate mortgage loan processing and developed various healthcare related web applications.
• Worked on creating various object types in Oracle PL/SQL including packages, stored procedures, functions, triggers and database links.
• Responsible for using different data structures like Collections and implementing the same in projects.
• Developed PL/SQL programs to update interface tables and execute along with loader programs.
• Extensively worked on creating web applications using Oracle APEX.
• Worked extensively on forward and reverse engineering processes.
• Worked closely with the team to convert the technical specification to business logic layer.
• Six Sigma Certified - Yellow Belt for automation of Total Call Detail Records of Postpaid GSM and CDMA products.
• Excellent skills in Performance Management to support strategic planning, goal setting, strengthen accountability, enhance decision making, and improve customer service.
• Considerable experience in working with Business users, SMEs, development team as well as the senior management.
• A great team player with strong interpersonal and communication skills with a strong desire to do excellent for my employer

TECHNICAL SKILLS:

Operating Systems: Windows XP

Programming Languages: PL/SQL, VC++, Java Scripting, Unix

Tools: TIBCO IM, Microsoft Studio Developer, Oracle Application Express (APEX), Toad, PL/SQL Developer, Informatica, Microsoft Excel, Microsoft PowerPoint & Microsoft Word

Databases: Oracle 9i/11g, Sybase, MS Access 2003

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL-APEX Lead

Responsibilities:

• Develop PL/SQL code to support mortgage systems to handle data received from MSP (Mortgage Servicing Package) systems which have different data format when compared to VLS (Vendor Loan System) systems. Both VLS & MSP are source systems that send out data to the downstream processing systems & other mortgage applications.
• Enhance the existing application code to support data from the new source system - MSP.
• Modify the existing ETL transformations to support data from the new source system so that the data loaded into the mortgage processing systems are as per the attributes from the new source.
• Perform unit testing to validate the newly added & modified PL/SQL packages, procedures & functions.
• Creation of different front-end web applications using Oracle Apex.
• Worked on creation of computations, validations & processes at the time of web page rendering & processing in Oracle Apex.
• Created page items, drop-downs, tabs, breadcrumbs on web pages using Oracle Apex.
• Used color style sheets (CSS) to provide various color schemes on the web pages.
• Work on resolution for defects raised by business users.
• Prepare detailed functional specification document for each of the systems identified for VLS to MSP conversion.
• Involved in code migration from VLS to MSP systems.
• Involved in building the lower environments for various business maintained schemas which included metadata import of various database objects, creation of appropriate roles & providing entitlements to the same. The main objective of building the lower environments was to follow the SDLC process as no lower environments existed prior to this activity.
• Load data into the lower environments based on various data cycles so that downstream systems can use this data for development as well as testing.
• Interact with various source system owners to get the required test/data files into the lower environments.
• Identify, log & fix the data issues related to each of the downstream schemas which use various attributes for their internal & external reporting.
• Account managements for all the different schemas related to the conversion & functional ID’s in the lower environments of Development & Test - included maintaining the credentials and account unlock process.
• Practiced Agile methodology with sprint cycle of 2 weeks & each of the user stories were captured in JIRA (tool used to track user stories, issues and logs from application development perspective).

Environment: Used: Intel Pentium O/s: Windows, Oracle 11g, TOAD, Informatica 9.1, Unix, Oracle APEX 4.2, ALM (Defect Tracking).

Confidential, Mount Laurel, NJ

PL/SQL Lead

Responsibilities:

• Prepare complex work flows and system design architecture for handling data related to Mortgage loans
• Add enhancements to the existing interfaces supported by Confidential . Enhancements mainly include adding new functionality and modifying the existing process flows as per the business requirements for transfer of data between the originating and the processing systems that deal with loan data.
• Provide automated solutions for printing customer details for loan processing to improve efficiency and reduce the time and effort required to manually complete, validate and print customer details.
• Support interfaces that provide information to the client for their yearly validations of loan data as well as data related to title and property appraisal. Develop modules to send out alerts/notifications to customers regarding their loan status and also modules to deal with processing and other fee charges that are associated with mortgage loans.
• Attend client meetings and interact with clients, business analysts, database administrators and testers to understand and obtain project requirements and also coordinate Onsite and Offshore work effectively.
• Developed packages, procedures & functions in PL/SQL that were used for the data load as well as validations prior to the data load.
• Worked on various transformations in Informatica that were used to load the data from flat files into databases as well validate the data in the files.
• Worked on various publisher & subscriber processes that are used for data loads using TIBCO-IM.

Environment: Used: Intel Pentium O/s: Windows, Oracle 9i/11g, Rapid SQL, VC++ (Microsoft Studio Developer), TIBCO-IM, Informatica, Unix.

Confidential, Boston, MA

Oracle PL/SQL Lead

Responsibilities:

• Interact with business stakeholders to get business requirements for new development activities.
• Prepare high level design document and system specification documents for the new functionalities to be developed.
• Develop sample web applications and demonstrate the same to clients for easy customization of the web pages.
• Enhancements to front-end applications based on the need.
• Develop new web based applications.
• Support the existing web applications & provide timely resolutions to issues encountered.
• Created packages, procedures, functions, cursors in PL/SQL that can be used for backend validations for web applications.
• Worked on data insert scripts, correlated queries, triggers, sequence creation & alterations, database links in PL/SQL to support various functional requirements.
• Worked on different data utilities in Oracle Apex that helps load data from text files & spreadsheets into databases.
• Worked on performance tuning of PL/SQL queries.
• Developed various reports (Interactive Report & Classic Report) and different forms in Oracle Apex.
• Worked on creation of computations, validations & processes at the time of web page rendering & processing in Oracle Apex.
• Created page items, drop-downs, tabs, breadcrumbs on web pages using Oracle Apex.
• Used color style sheets (CSS) to provide various color schemes on the web pages.

Environment: Used: Windows, PL/SQL, Oracle APEX & Java Scripting

Confidential, Reston, VA

Oracle PL/SQL Development Lead

Responsibilities:

• Interact with clients to get business requirements for new development activities.
• Prepare high level design document and system specification documents for new functionalities to be added to the Confidential front end application.
• Develop front end applications for commission settlements to travel agents.
• Develop various forms using PowerBuilder.
• Support backend job runs that load data into databases & provide necessary resolutions/fixes in case of failures.

Environment: Used: Windows, SQL plus & PowerBuilder

Confidential, Mount Laurel, NJ

PL/SQL Developer

Responsibilities:

• Prepare complex work flows and detailed system design architecture for handling data related to mortgage loans.
• Add enhancements to the existing interfaces supported by Confidential . Enhancements mainly include adding new functionality and modifying the existing process flows as per the business requirements for transfer of data between the originating and the processing systems that deal with loan data.
• Develop front end applications for secure funding of mortgage loans & improve functionalities to provide flexibility for the client to add new vendors without any hindrance.
• Design enhancements to the systems so that new vendors on a joint tie up with the client can effectively insure the amount lent on a mortgage loan.

Environment: Used: Intel Pentium O/s: Windows, Oracle 9i/11g, Rapid SQL, VC++ (Microsoft Studio Developer), TIBCO-IM, Informatica & Unix.

Confidential

Senior Executive

Responsibilities:

• Maintained dashboards to monitor the revenue trend for various products and services offered by Confidential .
• Handled revenue assurance for products such as fixedline, walkies & mobiles and for services related to Voice such as Missed Call Alerts (MCA), VoiceMail and Data services such as SMS, BREW,WAP,Internet,CRBT,HSIA,Blackberry .
• Monitored revenue for Enterprise Customers who are configured for bulk messaging to ensure correct billing of their accounts.
• Maintained trend analysis of call detail records of subscribers for fraud management.

Environment: Used: Windows, Cognos frontend, KenanFX, Microsoft Excel & Microsoft PowerPoint.