Design, develop database tables, views and insert scripts for a Veteran's Enrollment system utilizing Oracle PL/SQL. This is a complex suite of application was developed using JAVA as the front-end and Oracle as the back end. I was the sole database developer between the JAVA developers and the DBA• Worked on Enrollment database for the Veterans and creating tables and views• Created new insert scripts based on the requirement in an agile environment.• Participated in daily scrum meetings.• Verify the databases if the changes applied in all the environments. And Data analysis.• Maintain some of the ETL jobs loading hospital and patient data from SQL server to oracle tables and the reports run on daily basis.Tools: Oracle 11g, Visual Studio, MS SQL Server, SQL Developer, TOAD, Jira, Rational, JAZZ, EXCEL, Windows 10.

Software Developer responsible for all aspects of the VETSNET development/maintenance process. This complex suite of applications was developed using Visual Basic for the front-end and Oracle PL/SQL for the back-end.• Worked on Financial Application System (FAS) and Awards for Veterans.• Worked on the Caregiver payment system for the Veterans.• Implemented Design Change Requests (DCRs) and Defects in accordance with the Requirements and Functional Specifications.• Participated in design sessions associated with change requests. Developed technical documentation.• Developed application code following the processes and procedures as detailed in the VETSNET Software and Development Life Cycle (SDLC) document.• Recommended process and architectural improvements for the VETSNET system.• Worked with the other developers among all development tiers to produce efficient and quality code.• Conducted Unit testing to verify that code was implemented in accordance with the functional specifications.

Software Developer responsible for all aspects of the VETSNET development/maintenance process. This complex suite of applications was developed using Visual Basic for the front-end and Oracle PL/SQL for the back-end.• Implemented Design Change Requests (DCRs) and Defects in accordance with the Requirements and Functional Specifications.• Participated in design sessions associated with change requests. Developed technical documentation.• Developed application code following the processes and procedures as detailed in the VETSNET Software and Development Life Cycle (SDLC) document.• Recommended process and architectural improvements for the VETSNET system.• Worked with the other developers among all development tiers to produce efficient and quality code.• Conducted Unit testing to verify that code is implemented in accordance with the functional specifications.• Assisted with troubleshooting, analyzing and resolving production issues.• Developed Web services to support the St. Paul teams automated claims process and tested the WSDL using SOAP UI.

As one of the PL/SQL Developer involved in the development of procedures, functions, triggers, Packages for the client State Street bank at Boston.• Modified a procedure to move the data from the temporary tables to the main tables. Used merge and Object types to make the procedure more efficient.• Involved in the development of Canadian Ishares create order file project. This is an extensive package involving the validation of the approved orders created for the current date and the order file get created in the fixed length format in the UNIX directory• Involved in the Eiger PCF process for UK ishares from developing technical design to development of the Project. Did unit testing and delivered the project on time.

As one of the reporting and development team member. My responsibilities include developing complex reports, data analysis, coding, testing and research. Helping the users in day to day problems and providing them easy solutions. Designed and developed reports in oracle SQL and used excel as the reporting tool to deliver the reports. Learned the new Oracle Business Intelligent tool (BiTool) to deliver web based reports to the customers. Complicated stored procedures are written in oracle 11i. • Designed and developed dashboard reports.• Developed front end excel form to deliver the reports. Complex macros are written in VBA to parse the data into different tabs based on the program name.• Complex stored procedures are written in PL/SQL to create the tables and then insert the date into the tables. DBMS scheduler is used to schedule the jobs to run daily, weekly and monthly basis to insert the data into the tables and the data is extracted for building reports.• Used direct SQL functionality to create the Oracle Business Intelligent web based reports.• Used the SVN software for change control.

One of the technical team members of DDM(Distributed Database Management). Responsibilities include report development, helping and rectifying the problems the users in daily basis. 24/7 pager support. Designed and developed Main frame reports for the Client service department into Crystal reports 9.0. Complicated SQL queries are written in Sybase to accomplish these tasks. Involved in the Spherical Timesheet project. Creating reports using Microsoft reporting services.• Developed several reports based on the user requests using crystal reports.• Developed Lineup Data Entry form for the data collection group in MS Access. The users can enter their channel numbers, Channel names, dates, formats, etc instead of time consuming manual work.• Created ASP pages using real time data from the database for the department website.• Changed the JCL code in the TSO based on the user requests and ran the jobs in the CA7.• Created and maintained the Employee database application written in Ms Access and Visual basic.

• Developed the Complex Sales Journal report and financial reconciliation reports running daily and monthly basic.• Oracle analytical functions are used in developing the stored procedures.• Maintained the MS Access database for all the reports created in the finance department and documented. • Developed the Customer information screen where the user enters the customer information, their address, orders and other personal information.• Developed reports for the IT department-using oracle Reports6i.

At PSCU-Financial Services striving to meet the goal of Go-Live date and keeping the project in the budget has always been my utmost responsibility above and beyond quality deliverable work. Developed most complicated reports on a very demanding schedule.• Worked independently on a project to implement inbound interface into Oracle from BONDATA &BONHISTORY Parsing Application.• Developed the above process using Delphi 6.0 to parse a huge data file into multiple files based on dynamic conditions specified by various user parameters.• Created numerous Oracle stored objects, Packages, Procedures, Functions and Triggers to support the Oracle data conversion.• Designed and developed summary and detailed reports using Crystal Reports to according to user Specifications.• Did extensive analysis and development on the new Billing Application using Oracle 8i & Crystal Reports 8.0.• Interacted directly with the users in business requirement analysis, process design & enhancement, application Development, testing, and documenting the same.• Converted all the Delphi 2.0 Reports to Delphi 6.0 Quick Reports and Delphi 5.0 Application to Delphi 6.0 Application.• Designed & Customized the Credit Union web sites using Web Administration Tool and XML Style sheets.