Oracle developer Resume
Chicago, IL
SUMMARY
- More than 15 Years of experience in developing business related applications in Client/Server using PowerBuilder and Oracle.
- Extensive experience in Information Systems Analysis, Design, Development, Coding, Testing, Migration, Enhancements (program maintenance) and solid understanding of the Systems Life Cycle (SDLC).
- Experience in Incident management, Change management, Release management and using tools like JIRA, Service - Now, PVCS, TFS etc…
- Strong expertise in user interface, specification development and troubleshooting.
- Solid knowledge of programming and Design methodologies related to RDBMS Applications.
- Experience in working with large databases and in designing robust, complex databases, expertise in Client / Server architecture.
- Resolved a lot of Performance Issues inOracle procedures, functions and Packages.
- Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communications to maintain effective work relationships with all levels of personnel in a team environment or independently.
- Strong experience creating User Guide and Design, testing and release Documentations.
TECHNICAL SKILLS
PowerBuilder: PowerBuilder 12.6, 9.0, 8.0, 7.0, 6.5 and 6.0
Databases: Oracle 7.3, 8i, 9i & 10g, 11g, SQL Server 6.5/7//2000, Sybase SQL Server 10
Visual Basic: Visual Basic 6.0
Programming Languages: C, C++
Version Control tools: PVCS 7.5, TFS, CM Synergy 6.4. and VSS PL SQL Developer, TOAD PL SQL Developer 5.1 and 8.0.4 TOAD 11.6
Crystal Report: Crystal Report 6.0 (Report generating tool)
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Oracle DeveloperResponsibilities:
- Coordination with Business clients to understand the new requirements and specifications and provide them a solution design and estimates.
- Take the ownership of the change and complete it by going through the entire SDLC life cycle starting from the requirement gathering to implementation and maintenance and documentation.
- Maintain the versions of both PowerBuilder and Oracle Objects in version control tool (PVCS).
- Performance Tuning of Oracle procedures and functions.
- Production support of the application with respect to issues and bug-fixes.
- Mentoring and peer reviewing of the work done by other team members including offshore team members.
Confidential, Highland Hills, OH
Responsibilities:
- Responsible for the development and maintenance of the application in PowerBuilder7, 12.6 and Oracle 10g.
- Migrated the application from PB7.0 to PB12.6.
- Knowledge on Denodo platform( Leading Data Virtualization Platform)
- Take ownership of the change and create design documents and test cases.
- Present the design to the core technical team and get it approved.
- Make the code changes and complete the documentation.
- Follow up with testing team and the implementation team and help them with any issues related to the change and application.
- Analyze the user trend in using the application and suggest modifications if needed. Also interact with users to understand the application usage.
- Direct interaction with business partners to understand the issues they are facing as well as for the new modules.
- Have proficiently used version control tool (PVCS).
Confidential, Highland Hills, OH
Responsibilities:
- Responsible for the development and maintenance of the application in PowerBuilder7, 12.6 and Oracle 10g.
- Migrated the application from PB7.0 to PB12.6.
- Based on the errors reported by client, I had to analyze them, get an estimate done thereby reflecting the effort involved for the problem to be solved.
- Create design documents and test cases.
- Present the design to the core technical team and get it approved.
- Make the code changes and complete the documentation.
- Follow up with testing team and the implementation team and help them with any issues related to the change and application.
- Analyze the user trend in using the application and suggest modifications if needed. Also interact with users to understand the application usage.
- Direct interaction with business partners to understand the issues they are facing as well as for the new modules.
- Have proficiently used version control tool (PVCS).
Confidential
Responsibilities:
- Quasi Technical Lead / Support Analyst and application owner.
- Allocate work to team members and review their work
- Interact with users by mails / phone to fix the problem they are facing in our application
- Interact with business to discuss the current issues with the application
- Propose new ideas to improve the performance of the application
- Working on New enhancements which include changes in Powerbuilder, Oracle and Visual basic components.
Confidential
Responsibilities:
- Understanding the existing Product functionality
- Based on the errors reported by client (in Sunrise tool), I had to analyse them, get an estimate done thereby reflecting the effort involved for the problem to be solved.
- Interact with client to get a go-ahead for fixing of the problem
- I was also responsible to update the Sunrise tool with all the above mentioned information.
- Have proficiently used Version control tool
- 6 months onsite with Client in UK
- Direct Interaction with client for raised issues, closed issues etc.
- For enhancement - I was responsible to do the impact analysis and let client know the details, based on which development would be carried forward.
- Each and every enhancement and changes to the existing product was documented and updated.
- This document was also circulated to the client to get a sign-off and confirmation on the same.
Confidential
Responsibilities:
- Had to undergo a detailed system study of the module to be worked on.
- I had to study the complete Database Structure, so as to get the output (reports) with correct data and minimise the effort and increase the performance.
- I was given the responsibility to make relevant changes at the database level (table) and procedural level changes to get an effective output.
- Deployment of the system in the client machines.
Confidential
Responsibilities:
- Was involved in the entire life cycle of this product
- Creation of Data Base Design and Objects.
- Coding and Testing to ensure that the functionality is in place.
- Delivering the same to client and getting a sign-off
- Deployment in the client machines.
- Post install verification and support.
- Catering to the changes and customizing to the client’s satisfaction.
Confidential
Responsibilities:
- Creation of Data Base Design and Objects
- Creation of Front End screens and Reports using PowerBuilder and PFC.
- Coding and Testing to ensure that the functionality is in place.
- Delivering the same to client and getting a sign-off
- Getting Client satisfaction
Confidential
Responsibilities:
- Was involved for the entire life cycle of this product
- Creation of Data Base Design
- Creation of Front End screens and Reports using PowerBuilder and PFC.
- Coding and Testing to ensure that the functionality is in place.
- Delivering the same to client and getting a sign-off
- Getting Client satisfaction
Confidential
Responsibilities:
- Involved extensively in System Study
- Based on the enhancements, I was involved in the Design and coding using PowerBuilder and Oracle.
- Testing to ensure the functionality is in place.
- Installing the changes in the production environment.
- Give client post installation support.
Confidential
Responsibilities:
- Involved extensively in System Study
- Based on the enhancements, I was involved in the Design and coding using PowerBuilder and Oracle.
- Testing to ensure the functionality is in place.
- Installing the changes in the production environment.
- Give client post installation support.