Etl Consultantt Resume
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, MDAutomation 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, SCQA 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.
ConfidentialQuality 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.