SUMMARY

• Over 12 years’ of experience in Software Development Lifecycle - Application Software Design, Development, Testing and Implementation.
• Excellent team player with problem solving and troubleshooting capabilities.
• Commitment to excellence proven by an outstanding career track.
• Extensive experience in Oracle 8i/9i/10g/11g, Reports Builder 4.5/6i and Forms Builder 5/6i/9i.
• Proficient in use of programming languages - C, C++, XML, JAVA, COBOL, HTML and Oracle PL/SQL.
• Proficient in use of Windows 9x/2000 and UNIX platforms.
• Worked on Oracle Financials (AP, AR, and GL), AOL and System Administrator modules.
• Experience in Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments.
• Well experienced on various data design models includes Oracle Data Modeler for Entity Relationship(ER) diagrams.
• Proficient in working with RAC, Tables, Table Partition, and Collection objects, Nested table, Record type, Cursor, Ref Cursor, View, Materialized view, Triggers, Instead of triggers, Temporary Tables, XMLTABLE.
• Extensive Experience in Oracle tools like SQL*Plus, SQL * Loader, Toad, SQL Navigator, SQL Developer, PL/SQL Developer and Data Loader, and Data Modeler.
• Wrote complex queries using Sub query, Inline views, Correlated sub query and Dynamic SQL.
• Involved in Tuning the PL/SQL code using Explain plan to improve the performance of the reports created using reports builder.
• Proficient in handling various predefined as well as user defined Exceptions for Oracle and user error.
• Expertise in Master Detail forms, Multi tab paged forms, Sub forms using Forms Builder.
• Involved in developing PL/SQL Libraries, Object libraries, Menus, LOV using Forms Builder.
• Designed and Developed Tabular, Form and Matrix reports using Reports Builder.
• Experience in Data Conversion with SQL Loader, PL/SQL UTL FILE.
• Analyzing issues and Interacting with managers and users in resolving the issues on time.
• Proficient in use of PVCS, VSS, Tortoise SVN, FTP, MS-Office (Word, Excel, PowerPoint, Visio and Access).
• Worked on migrating data from legacy to Oracle and Oracle Financials.
• Worked on schedulers like JCI and TIDAL to run the various batch processes and also real time sync processing.

TECHNICAL SKILLS

Data Base: Oracle 8.i/9i/10g/11g/11i, MS-ACCESS

Language: PL/SQL, C, ASP, C++, JAVA, XML, COBOL, HTML

Web: IBM WebSphere 5.x/4.x, ASP

GUI: Forms and Reports 4.5/6i/9i and 4.5/6i, VB 6.0

Operating Systems: Windows NT/XP/98/2000, UNIX

Other Tools: TOAD, PL/SQL Developer SQL* Loader, FTP, Discoverer 4i, Tally 5.4/6.3,ExceedTIDAL, JCI, VSS, Tortoise SVN, IBM Rational Clear Quest, HP Service ManagerApplication Manager (AppWorx), WinSCP, SIMTO Scheduling Blending Systems.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle Consultant

Responsibilities:

• Handle a variety of development tasks including design, coding, developing and implementing detailed code to department standards and unit testing.
• Loaded million rows of data from SQL Server or Excel file or Text files to Oracle database using SQL* Loader, External Tables and TOAD Import wizard.
• Provided extensive production support on Meter Data Management System (MDMS) for Reliant Customers.
• Solely supported and maintained the Northeast Warehouse Systems (NEWS) system on their account related, billing related, correspondence (Enrollment, CEN and SWAP) related inquiries and manual requests on change in their accounts.
• Solely supported Airline Award program with Southwest, United Airlines and American Airlines on their awards and bonuses related inquiries or requests.
• Automated the process to send the Demand Response process file to ERCOT on yearly basis.
• Worked independently with web team in providing various Web Personalized Offers to Reliant customers based on the Outage, Auto pay and Renewals.
• Solely developed and maintained loading weather, interval and billing cycle data and generated subscriber file for sending out Weekly Summary Email based on usages for Northeast team.
• Proficient in working with Collection objects, Table Partition, Record type, Cursor, Refcursor, View, Materialized view, Triggers, Partition, FORALL, Bulk Collect, Autonomous Transactions and Analytical Functions.
• Maintain Partitions by adding Daily/Weekly/Monthly partitions and dropping aged partitions.
• Created UNIX shell scripts to run the batch process and to send Hourly/Daily/Monthly email statistics reports using ControlM.
• Generated Test cases to help UAT users understand the data flow and functionality.
• Monitor, Validate and Report the data anomalies based on the statistics report generated on daily basis.
• Proficient in tuning the complex queries using Explain Plan, Hints, Indexes, and Partitions etc. to improve the performance of the application.
• Maintain Database, UNIX scripts, Documents and Process flow in Tortoise SVN to maintain the versions of the development and enhancements.
• Strongly focused and detailed oriented towards achieving the goal with minimal supervision.
• Participate in weekly management discussions with business users of key projects to resolve complex issues and for technical enhancements and improvements.

Environment: Oracle 11g, TOAD, Data Modeler, UNIX SSH Client Server, MS Visio, Tortoise SVN.

Confidential, Houston, TX

Sr. Oracle Developer

Responsibilities:

• Involved in Design, coding, testing, Implementation and production support on GSAP Project for SOPUS and MOTIVA customers by attending various trainings on the applications used by Confidential - Oil Trading, Scheduling, and Shipping etc.
• Involved in several phases of testing includes Unit testing, Integration testing, User Acceptance Testing support (UAT), Customer Acceptance Testing (CAT) support.
• Enhanced and provided production support in Inventory Optimizer (IO) application used by customers in various locations in Chennai, Manila, London, etc.
• Solely supported the SIMTO Scheduling Blending application used by Traders to blend and trade the Fuel oil in certain proportions.
• Automated various reports and generated Ad-hoc query and reports on Daily/Monthly basis to minimize the manual intervention and to avoid the risk of delay in delivering the report.
• Manage any of Database or application or report related change request in IBM Rational Clear Quest for future reference.
• Efficiently used Service Manager Application tool to manage any application or database related request in getting access or reporting failures/outages.
• Created UNIX shell scripts to run the batch process and to send Hourly/Daily/Monthly emails to individual or any distribution group.
• Proficient in creating Modules, Chains, Schedules, Connections, Variables in AppWorx while scheduling a Job.

Environment: Oracle 10g, TOAD, Data Modeler, UNIX, SQL Server 2008, IBM Rational Clear Quest, HP Service Manager, Application Manager(AppWorx), WinSCP, SIMTO Scheduling Blending Systems.

Confidential, Houston, TX

Sr. Oracle Consultant

Responsibilities:

• Handle a variety of development tasks including design, coding, developing and implementing detailed code to department standards and unit testing.
• Implemented Meter Data Management System for Pedernales Electric Cooperative (PEC) located in Austin.
• Used Data Modeler to create ER Diagrams for the newly designed normalized Tables with necessary constraints.
• Loaded million rows of data from SQL Server to Oracle database using SQL* Loader.
• Created UNIX shell scripts to run the batch process and to send Hourly/Daily/Monthly email statistics reports using ControlM.
• Automated and converted the Billing reports used to bill the customers from Excel to Oracle database.
• Monitor, Validate and Report the data anomalies or outage on daily basis based on the statistics report generated.
• Worked on tuning the complex queries using Explain Plan, Hints, Indexes, and Partitions etc. to improve the performance of the application.

Environment: Oracle 11g, TOAD, Data Modeler, UNIX SSH Client Server, MS Visio, SQL Server 2008

Confidential, Houston, TX

Sr. Oracle Consultant

Responsibilities:

• Involved in Analysis, Design, Development and Implementation in building the Robust Call Center Application.
• Worked on generating and maintaining a monthly report to send Default (Delinquency) reporting for FNMA (Fannie Mae), FHLMC (Freddie Mac), SFDMS (Single Family Default Monitoring System) and VA (Valerie).
• Provided borrowers with different government programs like Home Affordable Modification Program (HAMP), Home Affordable Unemployment Program (HAUP) by avoiding them going in foreclosures.
• Worked on providing the borrowers with Home Affordable Foreclosure Alternative (HAFA) program includes Short Sale, Deed in Lieu, and Settlement.
• Also providing different workout options and modification programs to help the borrowers.
• Worked on IVR (Interactive voice Response) systems to provide the borrowers an alert or route the call to the perfect department based on their loan status.
• Worked on Dialer Tranche to make automated calls to the certain borrowers in certain time zone.
• Worked on Data Migration from the MS Access database to Oracle database.
• Solely worked on collecting and maintain the sensitive and secured borrower financial Information.
• Worked on Data Conversion of the legacy application form PowerBuilder and MS Access to .Net and Oracle database.
• Worked on tuning the complex queries using Explain Plan to improve the performance of the application.
• Remotely supported when the schedule jobs run after hours and also for at the time of end of month processing.

Environment: Oracle 9i/10g, Windows XP, MS Visio, UNIX, TOAD, SQL Navigator, Data Modeler, VSS, Clear Quest, JCI (Job Control Interface), TIDAL.

Confidential, Omaha, NE

Oracle Consultant

Responsibilities:

• Responsible for new development and customization of the RETEK application includes Distribution of Goods, Allocation Application, Ordering and Transfers.
• Closely worked with the end users in finding their needs and improvements to provide a technical specification document.
• Developed a HIPAA (Health Insurance Profitability and Accountability Act) interface and relevant reports to securely maintain the patient Information from the pharmacy systems.
• Worked on the third party TOMAX Interface to access the point of sale (POS) data.
• Extensive experience in customizing Forms and Reports using Forms Builder and Reports Builder.
• Efficient in writing shell scripting to automate the daily activities such as loading files into database using and FTP the files to or from remote servers using the host address.

Environment: Oracle 9i, Forms Builder 6i/10g, Reports Builder 6i, RETEK Application, Windows 2000, Unix, Net Term, Hummingbird Exceed, TOAD, PVCS, Agent Ransack, AppWorx.

Confidential, Jacksonville, FL

Oracle Financial Technical Consultant

Responsibilities:

• Prepared Conceptual Design document based on business requirements document.
• Interfaced Invoices using Auto Invoice Concurrent Program.
• Programmatically created Credit Memos using Auto Invoice and PL/SQL.
• Importing Customers using SQL Loader.
• Used Autosys to run the interface at scheduled intervals.
• Generated Flat file using UTL FILE Package for interfacing to Oracle AP.
• Developed PL/SQL packages for loading FND executable, program and parameters using FND Program package.
• Involved in tuning of Customer Conversion Interface.
• Customized Billing and Receipt History Report.
• Loaded AR related data (direct dump) from legacy system to AR financial module.
• Registered executables and programs in AOL and created value sets.

Environment: Oracle 11i, Forms Builder 6i, Reports Builder 6i, UNIX, SQL Loader, TOAD, SQL Navigator.

Confidential, Charlottesville, VA

Oracle Consultant

Responsibilities:

• Involved in development and customization of a financial systems and payroll systems.
• Responsible for importing and exporting files from/to different third party vendors systems to/from our financial and payroll systems.
• Created lot of adhoc reports on weekly, monthly and yearly basis using Reports builder 6i based on the client requirement.
• Responsible for performing various database administration duties using advanced querying protocols and PL/SQL scripting techniques.
• Created Unix Shell Script for sending Internal Requisition Error Files to the respective employees. This report has an option of destination type as Screen, File and Email.
• Implemented automatic e-mailing functionality by creating XML-based templates for letters, which receive their customized data sets from the: Oracle 9i database.

Environment: Oracle 9i, Forms Builder 6i/9i, Reports Builder 6i, Windows 2000, Unix Shell Script, TOAD, XML, XSL, XSLT, SQL Navigator.

Confidential

Oracle Developer

Responsibilities:

• Designed, Developed and Implemented a robust application Interface for the International Export and Import.
• Provided business training and documentation to the end users to use the application in an effective manner.
• Directly interacted with the business users while UAT to get their suggestions, ideas to improve the application more robust and more user interactive.

Environment: Oracle 9i, Visual Basic 6.0, Crystal Report 9.0, Windows 2000