We provide IT Staff Augmentation Services!

Sr. Db Admin And It Lead Resume

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • 7+ years of solid IT experience in performing QA analysis, business analysis, business modeling, requirement gathering, design, testing and documentation.
  • More than 4 years of profound experience as a Quality Analyst with excellent project management skills in financial institutions and Insurance domains.
  • Have around 3+ years as a System Integrator - Functional Domain and around 1 year of experience in Performance testing of software Testing using the Performance Testing Tools HP Load Runner, IBM Rational Performance Tester.
  • Expertise in working with SDLC methodologies and processes including Agile and Waterfall model.
  • Extensive QA experience in different phases of lifecycle, including Test Planning, Test Execution, Defect Tracking, Management and Reporting.
  • Experience in Web Services testing using Soap UI.
  • Expertise in both manual and automation testing of Web services.
  • Experience in Defect Management with tools like Quality Center, Clear Quest, Test link.
  • Was responsible for QA activities for the entire Software Development Life Cycle (SDLC).
  • Performed business functional tests at various stages of STLC such as Functional Testing, User Acceptance Testing (UAT), Regression Testing, End-to-End testing.
  • Experience with HP Application Life Cycle Management (ALM) Software suite for requirements management, testing and defect resolution.
  • Solid experience in Java, JEE, UNIX, PL/SQL and ETL scripting and query optimization.
  • Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica PowerCenter9.X/8.x/ 7.x
  • Solid experience with databases including Oracle (10g/11g), MySQL (5.x), SQL Server 2008.
  • Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
  • Knowledge in Full Life Cycle development of Data Warehousing.
  • Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Expert in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
  • Excellent interpersonal communication skills, coordination skills, organization skills and strong analytical skills in assessing current and future market trends.
  • Excellent experience working on agile model using software tool like Rally Dev Software for user Story creation.
  • Experienced in Database management and testing by writing complex SQL queries in Toad, SQL Developer, Oracle.
  • Involved in all phases and types of Web testing scoped in Project i.e., Unit, Application, Integration, System, Regression, Automation, Load & Performance, Security, Stress and User Acceptance testing.
  • Wipro trained and qualified Oracle Data Base Administrator and Automation Expert for QTP (Quick Test Pro)
  • Motivated team player with ability to work under minimal supervision possessing excellent communication, interpersonal, analytical and problem solving skills.
  • Passionate about mastering new technologies with a keen awareness of new industry developments and the evolution of next generation business solutions.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, Java EE, C, C++, Java Script, UML, XML, XSL, Shell Scripting

Web Design: HTML, HTML 5, CSS, CSS 3, AJAX, jQuery

Operating Systems: Windows (XP, 7, 8, Vista), LINUX and UNIX

Databases & Tools: Oracle (10g, 11g), MySQL 5.x, SQL Server 2008

Build & Integration Tools: Maven, Ant, Hudson, Jenkins

ETL Tools: Informatica PowerCenter, Talend

Testing Tools: SoapUI, Selenium Suite, Apache JMeter, Cucumber

MS Office Applications: Office 2010 suite, MS Visio, MS Project, SharePoint

Agile Tool: Rally Dev Software

Application/Web servers: Apache Tomcat 5.x/6.x and Glassfish

IDE: Net Beans, Eclipse, SQL Developer, SQL Data Modeler

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DB Admin and IT Lead

Responsibilities:

  • Prepared Test Plan, Test Cases and Test Procedures using Business requirements documented in the Functional specifications document of the system.
  • Involved in both White box and black box testing of the application.
  • Involved in team to perform extensive Load/Stress testing using Load Runner for all phases.
  • Analyzed various graphs generated by LoadRunner.
  • Performed different types of tests like Integration, system, regression, database testing.
  • Created tests scripts for BAT (Build Acceptance Testing) and Regressions.
  • Analyzed manual test cases and functional specifications to determine best approach to develop automation libraries.
  • Used HP Application Lifecycle Management (ALM) software suite for testing and defect resolution.
  • Assisted Testing teams to build test plans and involved in Pro gression testing and Regression testing .
  • Involved in the SDLC and analyzed the software requirements.
  • Developed application features using Java/JEE, JSP’s, Servlets and frameworks.
  • Analyzed the existing code components and developed enhancements to the existing project modules.
  • Maintain their company website front end, with daily news update.
  • Loaded the data using the SQL loader, Imports & Export data between systems.
  • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
  • Worked on database modeling and created Oracle Tables, Views, Constrains, Synonyms and Sequences.
  • Wrote several DB Queries to fetch different business requirement data.
  • Developed Various MIS Queries and device a process for DB Backup.

Confidential

Responsibilities:

  • Acted as the primary Intermediary between the Subject Matter Experts, business user and technical SME’s to identify the business needs, Business Rules, Business Processes & Interface Specifications for the improvement of the claims processing systems and then documented them in Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) using Power Designer.
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize different iterations and phases of the Software Development Life Cycle (SDLC).
  • Performed GAP analysis and wrote application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
  • Designed Use Case modeling, authored Narrative Use Cases and created UML diagrams such as Use Case Diagrams, Sequence diagrams and Flow Diagrams (Business/System) using MS Visio.
  • Provided structured walkthrough to the developers to understand the Use Cases and worked with quality control teams to develop Test Plans, Test Cases and test scripts based on usability and functional performance criteria.
  • Proficient with Microsoft Word, Excel, Access and PowerPoint for requirements management and communication.
  • Did multitasking and excel in fast paced environment.
  • Led and conducted JAD sessions to identify the flows and processes involved in the content.
  • Organized and Performed UI/GUI Testing, Progression, Regression testing and provided support.
  • User Acceptance Testing (UAT) for multiple iterations involving the entire User environment setup.
  • Worked with development and testing teams to accomplish timely release objectives.
  • Participated in product release and deployment to end-users after successful development and testing of the product. Also participated in training the end-users and creating training documents.

Confidential

Assistant SI and Sr. Quality Lead

Responsibilities:

  • Performed FSCD Integration Testing in System Testing Phase.
  • Handled FSCD Integration and App Dev Module in UAT Testing Phase.
  • Managed responsibilities of System Integrator as a Support in UAT Testing Phase.
  • Experienced in offshore team handling of 8-10 people in testing
  • Stood as SPOC for UAT Testing Team for any issue resolution.
  • Experienced in handling all the Portal related Issues.
  • Prepared and Maintained Daily, Weekly Status Mails for tracking UAT progress.
  • Hosted Daily Status Meeting for FSCD Integration.
  • Had strong and effective communication with Customer during Requirement Analysis phase and UAT Phase.
  • SPOC for all the functionalities across Application.
  • Intimated Offshore team and Managers about the activities planned over ahead.
  • Being Proactive, Highlighted any issues to Customer to avoid re-run.
  • Proven expertise of Functional knowledge in Insurance Domain.
  • Conducted Knowledge Transfer Sessions for 30 new additions to the team.
  • Analyze system requirements and develop test conditions, test plans and test cases
  • Logged Issues/Concerns or Clarifications in RADAR (a Issue tracking tool)
  • Linked Test Cases to functional requirements to ensure that they are traceable throughout the testing process.
  • Prepared DSM(Dependency Structure Matrix) across 146 Functionalities which helped for Design as well as Execution Phase.
  • Assisted in documentation of Test Plan, Test Procedure and Test Strategy.
  • Experienced in Inspections/Reviews, Test Execution, Test Data Preparation, Test Environment set-up and Metrics Collection
  • Experienced in managing test cases in Test Director and Quality Center
  • Extensive experience in Manual Testing that includes through testing of Application based on Business Requirement Document, System Requirement Specifications, Functional Requirement Specifications and Technical Specification Document.
  • Experienced in usage of Orthogonal Array a tool used for Optimization of Test Cases.

Confidential

Functional Test Engineer.

Responsibilities:

  • Experienced in generating various reports for test execution and defect status using Mercury Test Director and Quality Center
  • Initiated Daily Status Meeting, One-to-One Meetings and Stand-Up meetings as part of excelling the QA activities.
  • As a manual tester involved in Test case design, Test case execution, Preparation of Test Reports and Metrics, CA/CR Tracking, Logging defects and coordinating with the development team for resolving the issues.
  • Experienced in Database testing by writing SQL queries in Toad, SQL Developer.
  • Experienced in Interface testing by usage of File Transfer and Web service Tools.
  • Proficient in the tasks of Bug tracking and Reporting using Quality Center/Test Director
  • Maintained Defect Rejection Ratio of less than 2 % individual and less than 5% of Team across all phases of Testing including User Acceptance Testing.
  • Experienced in Root Cause Analysis of Defects in Unit and Functional Level.
  • Experienced in preparing Pivot Tables in Excel for presenting testing status and defect status
  • Active Participant of Defect Triage Meetings which involved All Work Streams, Client and Testing Team. Represented Offshore Testing Team of 30 members.
  • Handled all the performance activities as part of POC for GMAC.
  • As a Performance Tester dealing with Client for requirement gathering.
  • Involved in creation of Business flows for Performance Testing.
  • Planning the project life cycle and ensuring that the project deadlines are met.
  • Identifying/Resolving Risks/Issues in the project.
  • Took the responsibility of creating the test data for the execution.
  • Co-ordination with the involved parties for moving the application into Production.
  • Creation of test cases as part of Report's and Performance testing.
  • Involved in the phase of Performance Tuning for reports and the bottlenecks.
  • Able to identify if there is any requirement missing during the beginning phase to avoid later surprises
  • Execution of test scenarios and scripts against Business requirements.
  • As a Quick Grasper gained expertise over Functionality with in initial 3 months of the Project.
  • Experienced in Database testing by writing SQL queries in Toad, SQL Developer.
  • Experienced in Interface testing by usage of File Transfer and Web service Tools.
  • Maintained Defect Rejection Ratio of less than 2 % individual and less than 5% of Team across all phases of Testing including User Acceptance Testing.
  • Proficient in the tasks of Bug tracking and Reporting using Quality Center/Test Director
  • To assure the Quality and reduce the effort by introducing innovative methods and minimizing the project slippage.
  • Maintain traceability matrix for requirements including Change Requests.
  • I was responsible for the AppDEV and Interfaces Modules.
  • I was able to assure the execution is done on time without missing any target and avoiding high Penalty Clause.

We'd love your feedback!