Sql Developer Resume Profile
RELEVANT EXPERIENCE
Twenty five years of experience in Testing, Analysis and Requirement Engineering, Software Engineering, System Integration, Configuration Management, Production Support, Network Engineering, Software Project Management and software development. Experienced in ITIL, Software Development Life Cycle SDLC , Six Sigma, CMM, Agile, SOX and MISMO standards.
Experience Highlights:
Mastered Analysis, Testing, Test Automation and Software Project Management for 12 Years.
Demonstrated success in Code quality improvement by Source code review using source code review tools IBM Logiscope, McCabe IQ, CAST and Software Analyzer from Rational . Reviewed source codes for WEB and client server applications written in C, C , VB6.0, VB.net, Java and CSharp. Mentored development leads to ensure industry best practices are implemented with reduced code complexity and increased reliability by reviewing the complex areas of the code and improving them. Measured metrics for improvement and updated management periodically. Conducted presentation sessions at Raytheon SDI program for all program participants.
Mastered front-end, back-end, batch testing and 508 testing. Estimated Test effort required reviewing application changes. Ensured best practices and industry standards are implemented in all applications.
- Achieved customer satisfaction FBI, United States Patent and Trademark Office USPTO by Functional and Regression manual Testing and test automation using Rational Functional Tester and HP Quick Test Pro.
- Managed budget and time effectively across projects in the test team for seamless Test execution.
- Completed Test Coverage Analysis using breakpoints in source codes and tracking unexecuted branches. Prepared Test Data to test these branches for 100 Test coverage.
- Developed new Test Tools, Designed, Coded in Java J2EE, Tested and implemented complex calculations in various testing projects. Compared numbers generated by the above Test Tools with the application data with automated test scripts and achieved 100 data verification.
- Performance testing of Web applications using Load Runner.
- Completed performance tuning of self written the Test Tools in JAVA J2EE that process 20Million loans from 20 minutes to 5 minutes.
- Identify the bottleneck by introducing System time calls and write results in an output file. Checkpoints reached vs. System time.
- Analyze the time taken between different checkpoints in the code.
- Analyze disk I/O, Processing and memory based transactions and find the time taken for these activities
- Determine bottleneck and the area needs attention.
- Perform research on different methods for same class and how does Java implement them.
- Determine best method and implement them in the code
- Perform functional Testing that the Test Tools work as per specification.
- Analyze new times taken with the new method in the Test Tool.
- Remove System times introduced and finalize Optimized Test Tool.
- Conducted Requirements Analysis and composed the Requirement Specifications document.
- Decided, documented and published projects tasks and determined the critical path and resource planning. Published Project Schedule.
- Allocated work and monitored progress of Team Members. Managed team of 4 Analysts/Testers.
- Conducted effective meetings with Development team, Test Team and Business team and determined project scope and timeline. Discussed and published roles and responsibilities matrix.
- Created and completed System Testing with Test Plan, Test Schedule, Test Scripts, Test Cases, Requirement Traceability Matrix, performed Testing and composed the Test Results Documents.
- Negotiated and Prioritized Software releases contents as per the Business guidelines.
- Analyzed issues and determined the root cause and resolved them within given budget.
- Determined the Project Scope and milestones and measured progress for management reporting.
- Demonstrated results in the given timeframe.
- Demonstrated analytical and problem solving skills.
- Arranged releases analyzing business impacts and process critical dependencies.
- Analyzed Designed, Developed, Tested, Resolved issues and implemented various cross platform, mission critical integrated systems.
- Leading System Testing for 9 years.
- Led Software Development team for 7 years
- Led Network Design and Implementation team for 5 years
- Managed Clear Quest Tickets to closure.
- Prioritized and multitasked multiple mission critical projects in a fast paced environment.
- Mastered Business knowledge and subject matter expertise in Mortgage industry, Loan processing and all related calculations.
- Completed Performance testing of self developed Test Tools, by code optimization and increased Test Coverage by enforcing manipulated data to execute conditional code paths.
- Interviewed new Analysts.
- Mentored junior candidates in the team.
Confidential
- I am working as a Technical Test Lead for functional, regression and acceptance Testing of N-DEx a WEB based Search engine for our customer. The System consists of importing new data into the system, Role based access of various users to the data they are authorized to view display search results via Simple, Advanced, Targeted search, Audit trail to log user's activity, various filters for date based, location based, geographical area based reporting and interfacing with similar national systems NCIC and III.
- My role was to lead the test efforts in Geographical search and role based data sharing to identify records in a small geographic area and identify details of crime on a MAP of US are displayed effectively as per the requirements. Testing Geocoder to make sure all valid addresses are Geocoded correctly with reference to similar Geocoding applications on the WEB. Preparing Test Plan, Test Scripts Detailed to the level of every mouse click and keystrokes , Creating Requirement Traceability Matrix, Creating Test Data, Testing, Defect tracking and reporting.
- I have Developed the Requirement Specifications of Bulk Search capability of N-DEx. Reviewed requirements with the customer, Incorporated changes, built Test Scenarios, Test Plan and Test Cases for Testing. I have prepared Requirements to Test Case Mapping RTM to ensure all requirements are tested.
- Developed multiple Test Tools for Test automation, Test Data generation and Management in Java and worked with co workers to ensure they are using these tools for improved productivity.
- I made multiple Business Trips to Customer site for demonstrating System functionalities in Systems Acceptance Testing, organized meetings, identifying issues, Prioritizing issues opening and tracking defects and related reporting. Achieved complete customer satisfaction.
Confidential
- Prepare Test Strategy,
- Prepare Test Plan,
- Prepare Test Cases and scripts,
- Get all the documents reviewed by the tech writing team also by all stakeholders
- Test effort estimation
- Conduct testing of various real life problems and logging results,
- Defect tracking and management till closure
- Conduct end user training.
- Contributing positively in all Development meetings including outstation customers, going over issues, concerns
- Management reporting.
- Identifying interface software development/conversion requirements across various software modules
- End to End testing,
Confidential
Testing and Test Management
- Managed 28 Patent and Trademark applications at USPTO
- Review Release and decide Test Scope within given budget and timeframe
- Meet all the Task Order Managers TOM and review upcoming Test Projects and Prepare Team Schedule
- Estimate effort required reviewing Requirements and analyzing changes in applications
- Allocate work within Test Team
- Prepare Team Schedule
- Prepare Test Plan, Scripts and Cases
- Tested complex. Mission critical applications
- Completed Front end, back end and testing Batch programs in applications
- Prepared Test Documentations and signoff
- Track Defects
- Test Automation and automating regression Test Cases using Rational Functional Tester
- Preparing monthly reports for management reporting
- Conduct Testing Automatic and manual on various releases.
- Completed 508 Disability testing on multiple applications.
Confidential
- Managing Analysis of all 28 Applications for source code review
- Review source codes of applications using IBM Logiscope and McCabe IQ Tools
- Review CAST results performed by our customer USPTO
- Track results
- Assist development teams to focus on complex areas and improve the code
- Re-run and capture results of improvements
- Management reporting and conducting in house sessions of knowledge sharing
- Monitoring all development teams to ensure they are using Software Analyzer and FxCop regularly during the development life cycle instead of running them towards the end of the development life cycle.
Confidential
- Performance Testing of WEB applications using Load Runner.
- Completed Requirements gathering, Analysis and System requirement specification documents as per Business guidelines
- Carried out Systems and Integration Testing of Complex applications.
- Developed Use cases based on requirements
- Defined use cases from Business requirements and performing testing
- Mastered in Java, C and familiarity with Ab-initio, and similar environments.
- Determined Internal/External Stakeholders
- Led discussions by bringing everyone in table and resolving issues, identifying hurdles and action plans and implementing them in a crash time schedule
- Achieved collaborative success and delivered results
- Tested Critical Applications in given cost and time
- Analyzed of current process and suggesting areas to improve by Test Automation
- Developed GUI Based User Test Tools for increased 100 Test Coverage and reliability
- Conducted Causal Analysis of issues found and suggested process improvements
- Experienced in bulk data handling 20Million records, data scrubbing, parsing, field wise comparison, matching and merging of comma delimited flat files.
- Created and Documented Test Plan, Test Schedule, RTM, Test Script, Test Results, Problem and project management.
- Led a team of four individuals, work assignment, progress monitoring, providing assistance as needed, managing people, reporting, providing guidance to resolve issues timely.
- Tested IBM Mainframe Loan Processing system and various UNIX and WEB based systems, GUI as well as backend testing. Database consistency testing, field level data validations.
- Completed Data modifications to suit the Test Scenario. Planning multiple business scenarios not occur normally.
- Conducted Multi user concurrent Testing, File and database locking, unlocking, database commit or rollback feature testing.
- Carried out SQL queries and backend testing using TOAD.
- Implemented and monitored best industry practices in the team. Managed team data in SharePoint.
- Mentored junior co-workers.
Confidential
- Wrote Test Plan and Schedule, Test Cases and Scripts, Test Results
- Performed Front End and Backend Testing
- Published Data consistency scripts to verify the software updates at the end of the day is successful
- Wrote database stored procedures
- Suggested and implemented multiple process improvement solutions in Development and Test Processes
- Prepared large volume of Test Data to test business scenarios.
- Mentored junior staff members.
Confidential
- Completed Software installation
- Mastered LAN Management
- Managed Software upgrade
- Trained and mentoring junior members in the team
- Conducted learning sessions for junior members in the team
Confidential
- Led Data Communications Team with 4 members and achieved the following:
- Designed, Installed and implemented 64KBPS overseas link with GAN Insurance UK and TCS Calcutta.
- Designed, Documented, Installed and implemented 64 KBPS Internet server and workstations in a LAN
- Designed and implemented Inter office Ethernet LAN with Switch, Multiplexer, Router, Modem and Hubs.
- Led group to provide Networking solutions to multiple customers to share Voice, Data, Image and application files.
- Managed various Networking software upgrades in DEC system. Implemented TCP/IP Ethernet LAN to communicate over dedicated link between inter offices in a city.
- Conducted various Training courses Classroom and Hands on on Networking and Data communications.
- Conducted Hardware sizing and configuration management for various leading customers and published necessary documentations.
- Designed and developed PC LAN cards and related software development and testing at IBM Boca Raton Florida
- Designed and implemented Data communication solutions for Auto Zone Memphis USA
- Designed and implemented Data communication and Networking solution for AT T Istel UK.
- Designed, developed and implemented WAN session and data link layer software in assembly language for Philips Telesoft Brussels Belgium.
- Designed, developed and implemented Customized application software solutions for Tata Iron and Steel Company, Steel authority of India, Continental Insurance USA and many other leading customers.
- Completed System conversion from Data basic to COBOL for Continental Insurance on IBM System 36 and AS400.