Vani N. Reddy

SUMMARY OF EXPERIENCE

Broad-based background in Oracle and database management with hands-on skills in successful implementation of core enterprise software applications. Comprehensively understands and analyzes complex software requirements. Identifies software deficiencies and potential opportunities for process improvement. Designs and develops innovative solutions for increasing reliability and improving productivity. Highly productive team player recognized for positive attitude, flexibility and working well under pressure. Continuously focuses on best practices for coding techniques, testing habits, performance tuning and problem resolution that contribute to achieving targeted benchmarks.

EDUCATION

Academic Institution: University of Houston

Diploma: MS, Computer Science Coursework

Diploma: PG Diploma. Computer Science, India

SKILLS

Software: Oracle 11.x, SQL*Plus, Toad, SQL Developer, Forms 6i, Reports 6i and Graphics 2.5, Oracle Fusion Middleware 11g

Operating Systems: Linux/Unix & Windows 2000/XP

Programming Languages: SQL and PL / SQL, Microsoft SQL

PROFESSIONAL EXPERIENCE

2015 to date

Department of Veteran Affairs

DB Developer

Responsibilities:

Involved as Database Subject Matter Expert(DB SME) for Product Development in providing software development for VA Loan Guaranty Program software maintenance applications. Maintaining and supporting application interfaces between web-based applications and internal and external(non-VA) systems. Providing LGY application release support to the Software Development Center, data Warehouse/Program analysis and integrity(PA&I) schema and reports design. Monitoring and supporting batch processing.

.

Added new procedures and modified existing procedures to handle Financial transactions.

Created database procedures and scripts to upload data for data migration for BAC and NADL.

Writing complex queries to generate various Full File Loan Review reports.

Developed and implemented a plan to redact by identifying the data fields which contain PII data. Created a process with 24 scripts to be executed and validate the redaction process to see if the masked and sanitized data required for LGY development and test environments is in sync. Created documentation and process scripts to maintain and perform the repeatable process to mask/sanitize data in those environments whenever the database is refreshed from production.

Handling production issues by analyzing, developing and testing and releasing.

Doing code reviews for all sql scripts, procedures/packages for database releases and to check log files at the time of release to make sure everything is good.

Help other developers with code and script issues.

2014 to 2015

SYSCO

Oracle Forms Developer

Responsibilities:

Involved in design, development of Virginia Dry warehouse Pilot Project automation to integrate with Symbotic system within a Sysco warehouse operation.

Developed and modified existing PL/SQL packages and functions.

Modified the existing forms and menu forms in 11g to check if the Location, Zone and Aisle are maintainable as per the requirement.

1998 to 2014

Baker Hughes Inc.

Systems Analyst/Programmer III

Responsibilities:

Involved in design, development, training and support of several releases of PowerVision, core enterprise software for BJ Services and predecessor Baker Hughes.

Completed several successful major projects by utilizing expertise in Oracle forms, reports and PL / SQL stored procedures development.

Developed Microsoft SQL scripts that exported data from 2 different applications enabling scripts to be imported it into newer application, re-written using Click software. Data helps in testing pilot project in new software.

Trained and provided knowledge transfer support to 2 onshore / offshore personnel for supporting PowerVision application that enabled trainees to function without supervision.

Added new multi-tab form that enhanced PowerPro margin analysis tools by 1) showing all jobs for proposal; 2) exhibiting default finance and manual override modifiers for selected proposal; 3) providing product cost, SAP expense and override information; and 4) giving option of modifying override cost.

Added new functionality to existing forms that validated and performed various checks to allow items to be substituted for components of a blend.

Created PL / SQL procedures that helped DBA administer and sync mobile and production databases for PowerVision, such as filtering and retrieving active jobs accrual reports from laptop / production databases used by accounts department to track revenue.

Utilized order fulfill interface (OFI) to integrate the PowerVision application with BHI US Pressure Pumping SAP implementation for order fulfillment.

Created core forms, reports and PL / SQL procedures and used Web methods that kept data in PowerVision and SAP synchronized. This enabled finance part of PowerVision to reside in SAP without impact to users.

Developed PL / SQL procedures that updated sales orders created in SAP to PowerVision through periodic batch processing enabling users to view generated sales order numbers in systematic way for jobs that did not use form.

Created ability to process invoices and perform credit / customer checks before sending jobs to be invoiced in SAP. Enhancement allowed user to verify information prior to invoicing.

Designed and developed sophisticated scheduling program that generated user-preferred weekly or monthly dates with choice to include or exclude certain weekends and holidays for periodic truck treatment.

Created daily job route generation PL/SQL program that informed driver about wells to be treated, frequency of treatments, products to be used and generated future treatment dates.

Increased efficiency by creating job location reports for hardcopy that were given to drivers.

Led design, development and implementation of TestDirector / Winrunner testing package for PowerVision that programmers used to test and debug PowerVision application forms and PL / SQL code.

Created major forms, reports and database procedures for chemical services, completion fluids and coiled tubing services that users utilized to educate and convince customers for desired information /or data requirements.

Produced functional and technical specifications to develop utility application in PowerVision that allowed exporting select group of file parameters to be imported into DIMS. Provided template for customer to view usage of products.

Created graphing forms to help that assisted accounts department in showing overall revenue in presentations.

SPECIALIZED TRAINING

Data Base Tuning DBA

Oracle7 and Developer2000, ICSA

Contact this candidate