We provide IT Staff Augmentation Services!

Etl Consultantt Resume

3.00/5 (Submit Your Rating)

Mclean, VA

SUMMARY:

  • Extensively experienced in writing Test plans, Test cases and Test execution.
  • Strong Knowledge in Test case authoring, execution and reporting.
  • Experienced in front - end, back-end and compatibility testing in multi-tier client/server.
  • Experienced in Software Engineering, SDLC & Testing Methodologies to ensure industry standards.
  • Proficient in Black box and Grey box functional and data driven testing using testing techniques.
  • Experienced in Manual Testing, Functional Testing, Database Testing, Compatibility Testing, Workflow Integration Testing, User Acceptance Testing, Automated Testing and Regression Testing.
  • Experienced in the Triage team meetings for Defect management with the project team and peers using the tool HP Quality Center/ALM.
  • Experienced in developing a Traceability matrix mapping requirements to test cases using HP ALM/Quality Center.
  • Experienced in writing and understanding SQL queries to perform data verification and set up test data.
  • Experienced with automated testing tools like QTP/UFT.
  • Experienced in generating and running automation test scripts using QTP/UFT.
  • Proficient to automate all the Data Grid Validations in the application using QTP/UFT.
  • Proficient in feasibility analysis for automation, test script review and execution using QTP/UFT.
  • Extensively experienced in Hybrid automation frameworks by using QTP/UFT.
  • Multitasking, Self-starter, Motivated, Detail focused and Quick learner.
  • Excellent analytical and problem solving skills in designing, developing, and implementing.
  • Committed team player and rapid problem solver with commitment and a strong work ethic and ability to quickly adapt to new environments.

TECHNICAL SKILLS:

Testing Tools: ALM, UFT, JIRA, HP Quality Center, HP Quick Test Pro, SOAP UI, Jemeter, Rapid SQL, Autosys, VersionOne, PUTTY, WINSCP

Programming Language: C/C++, C#, Java, VB Script, JavaScript, HTML, XML, SQL, PL/SQL

Data Base: Oracle, SQL Server, MYSQL, DB2

Operating System: Windows, Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

ETL Consultant 

Responsibilities:

  • Develops and executes detailed ETL related functional, performance, integration and regression test cases, and documentation.
  • Ensures Data warehousing related test process, methodologies, and tools are applied appropriately and that test phase entry/exit criteria are defined as agreed to by stakeholders and applied by the test team.
  • Develops and Designs ETL test cases, scenarios, and scripts to ensure quality Data warehouse / BI applications.
  • Works independently and responsible for getting all clarifications from various stake holders (Business, Architects, Project Managers & Leads) to produce the deliverables.
  • Autosys experience from job execution and data testing standpoint.
  • Hands on experience using ETL tool Informatica 9.6.1 Hotfix 3 and DB2.
  • Experience in focusing on AGILE methodologies using VersionOne.
  • Reports the status of test planning, defects and execution activities, including regular status updates to the project team using quality metrics.
  • General knowledge of UNIX/Linux with hands-on experience in developing and maintaining Shell scripts.
  • Strong knowledge of Data Warehousing and ETL concepts, standards and best practices.

Environment: HP ALM, UFT, Rapid SQL, VB Script, XML, Informatica, ETL, Autosys, SOAP UI, UNIX.

Confidential, Silver Spring, MD

Automation Engineer

Responsibilities:

  • Worked closely with development Team and marketing to review the designs of systems, implement Test Plans, and Test the quality of software products.
  • Created clear, accurate and unambiguous technical documentation including detailed Test plans, Test cases, Testing procedures and Test results in accordance with company defined standards and methodologies.
  • Participated in the application development life cycle and drive quality in the development process.
  • Developed and managed quality assurance metrics for performance improvement of all teams.
  • Involved in thorough Compatibility Testing of the site on different environments.
  • Performed GUI, Functional, Regression, System, Back-end, Negative, Positive, and User Acceptance Testing.
  • Responsible for defect management includes, defect logging, defect tracking, defect triaging and defect closure using HP ALM.
  • Used HP ALM to manage the requirements, test scripts and also defects.
  • Involved in writing SQL and queries to perform Backend Testing.
  • Used Parameterization for using various data to test the web application and other desktop applications, mainframe applications using UFT.
  • Automated the QA regression test suite with UFT.
  • Created and executed of UFT Automation scripts using VBScript.
  • Created library files and library header files with VBScript having utility and reusable functions in UFT.
  • Built detailed and reusable Hybrid Automation Framework using UFT.
  • Designed, developed and implemented test strategy in an agile environment.
  • Involved in creating UAT environment and Performed UAT Testing.
  • Involved in troubleshooting, problem solving, and analytical skills.
  • Assisted Development Support experts in troubleshooting customer-reported issues.
  • Coordinated with multiple different teams including remote and off-shore groups.

Environment: ALM, UFT, Java, Java Script, VB Script, XML, SQL Server, MS Office, Windows, SOAP UI, UNIX.

Confidential, Columbia, SC

QA Engineer

Responsibilities:

  • Designed, wrote, reviewed, and executed test plans, procedures, reports, user guides, software version description documents, and other technical documentation.
  • Wrote, tracked, reviewed and verified resolution of defects.
  • Designed and prepared Test Strategies & Approach, testing metrics and other testing artifacts.
  • Prioritized and executed functional tests and regression tests.
  • Worked effectively with users and software engineers to understand requirements and test system functionality.
  • Worked in an agile, rapid development and prototyping environment where effective communication was paramount.
  • Ensured traceability of test cases back to project requirement.
  • Used Quality Center to track and report system defects and bug fixes.
  • Wrote Reusable Test Cases, GUI Related Reusable Test Cases, and Validation Test Cases using Quality Center.
  • Tested application’s backend by creating and executing using SQL queries.
  • Involved in using Object Repository in UFT.
  • Developed automated scripts in UFT for front-end smoke and regression testing.
  • Involved in handle the exceptions using UFT recovery scenario manager.
  • Worked on User Acceptance Testing (UAT) with users along with providing training to end-users.
  • Tested applications based on business requirements and industry best practices.
  • Performed other job-related duties as assigned.
  • Identified opportunities to adopt innovative technologies.

Environment: Quality Center, QTP, VBScript, Java, Java Script, MS SQL Server, Web Services, Windows, UNIX.

Confidential

Quality Assurance Data Analysis

Responsibilities:

  • Developed and implemented Quality Assurance Data Analysis and Supply Inventory programs that resulted in more efficient laboratory training and reduced man-hours spent in ordering supplies for the clinic.
  • Responsible for defect management includes, defect logging, defect tracking, defect triaging and defect closure using HP ALM.
  • Used HP ALM to manage the requirements, test scripts and also defects.
  • Involved in writing SQL queries to perform Backend Testing.
  • Used Parameterization for using various data to test the web application and other desktop applications, mainframe applications using UFT.
  • Performed both black box and white box testing.
  • Responsible for up to 20 technicians, dentists, and assistants providing dental care for up to 48,000 beneficiaries that included both active duty and veterans.
  • Responsible for the enrollment and claims oversight of the TRICARE Prime program for active duty.
  • Transformed the team-based production style to better utilize personnel resources. Resulted in more than 60% reduction in turnover times for cases.
  • Trained all staff on the electronic health records system and maintained the troubleshooting Help Desk requests with the EHR Company.
  • Spearheaded an advancement program, which made a positive impact on 300 plus sailors and improved their opportunities to advance to next pay grade. Conducted classroom and on-site training with delegation to the advancement program committee.
  • Served as HIPAA Officer and received 100% compliance grade during JACHO, OSHA inspections.
  • Maintained up-to-date files of all licenses and certifications as training officer for 28 staff.
  • Dramatically reduced outsourcing to civilian dental clinics from 100% to 5%, saving the Navy over 42K annually. Directly supported an increase in Operational Readiness to an unprecedented 96.5%.
  • Streamlined the procurement of 800 line items purchased during an increase in patient care, thereby decreasing the ordering time by two days.
  • Played a major part in testing and timely delivery of the product.
  • Participated in enhancement meetings focused on making the product more effective in real time scenario.
  • Maintained and communicated meaningful status reporting for on-going testing activities.

Environment: Quality Center, QTP, Java, Java Script, TOAD, Oracle, SQL Server, Windows, HTML, Agile, MS Office, UNIX.

We'd love your feedback!