SUMMARY:

• Oracle certified professional with 6+ years IT experience in Quality Assurance, Analysis, Design, Development, Testing and Implementation of various complex business application systems. Professional experience in diversified IT fields such as Data - warehousing, Data Mart & Client/Server applications under Mainframe, Unix & Windows in Agile and Waterfall Environments. And proficient in Siebel CRM Ver.8.1 & Web based application.
• 6+ years of experience with System, Regression, Functionality, Integration, performance and U.A.T. with expertise in data mapping, backend testing. Used ETL tool Ab Initio: GDE (1.8.19/1.10.11/1.13 ), Co>Op 2.8.18/2.10.11/2.13 , Informatica & SSIS using Control-M. Also worked with operational sources like DB2, Oracle, Sql Server, Teradata and Flat files
• Leading Projects as a Test Project Manager, Test Integration Lead, QA Lead and QA Tester on Project contexts.
• Preparing/reviewing Test Strategy and Test Plans basing on requirements and User stories. Providing leadership to testing resources. Leading UAT testing as a onsite coordinator. Conducting Defect triage meetings as Integration lead for large complex Projects.
• Experience in Onsite/offshore modal.
• Experience in analyzing data using HiveQL
• 3+ Years development and testing experience with Oracle. Exclusively used various reporting tools like SQR, Oracle forms and reports. Also proficient with SQL, PL/SQL and SQL Loader.
• 1+ year Proof of concepts experience with new Technologies with Bigdata/Hadoop and other Ecosystems like Sqoop (data Exchange), Hive, Oozie Workflow, HBase, Mongo DB, Casandra & Flume Log Collector.
• Developed several Ab Initio applications extracting, transformation, loading, cleaning and populating various Data marts. Hands on experience with Ab-Initio in a very large Database Systems (VLDB) environment with massive parallelism.
• Hands on experience with Quality Center & Clear Quest with various levels of experience as TPM (Test Project Manager), Quality Lead &Tester.
• Hands on experience as Quality Center (ver.11) Administrator & Parasoft SOA test for services testing.
• Proficient with XML source data and conversion to flat data files.
• Knowledge in EME - Identifying the Environmental variables for the project, creation of sand boxes, Check-in and Check-outs.
• Possess Excellent Communication (both verbal and written) & Interpersonal skills. Technically sound, Result-Oriented with strong Problem-Solving skill.

TECHNICAL SKILLS:

Big Data: Hadoop and other Ecosystems Sqoop (data Exchange), HBase, Hive, Mongo DB, Spark, PySpark, Scala-Spark.

ETL Tool: AbInitio GDE, Co>Operating System, Informatica & SSIS.

Databases: Oracle 7.x~11g, Teradata, IBM DB2, MS SQL Server 6.5/7/2000, Natezza.

Testing Tools: Quality Center, qTest, QC ALM, JIRA, Clear Quest, Control-M, ESP.

Other Utilities: Toad, SQL Server Studio, IBM DB Visualizer 9.x/Visual Explain for DB2, XML SPY, WebSphere MQ Explorer 7.x, IBM Control Center for DB2 Ver.8, Rapid SQL, Parasoft SOA Test, XML Spy, SoapUI, DB Artician, Rational Clear Case & MS Office products, WinSCP

Operating Systems: UNIX AIX/Solaris, Mainframe TSO/MVS and Windows NT/2000/XP/7.

ERP Tools: Siebel CRM Upgrade from Ver.7.x to Ver.8.x

Programming Languages: COBOL, C, Java (1.2), SQL and PL/SQL, Java Script, VB Script

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, IA

Sr. QA Lead

Responsibilities:

• Leading a team of Hadoop testers and responsible for all the QA deliverables.
• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts. Tested functionality across applications
• Extensively involved in comparing the results of traditional system to Hadoop environment to identify any differences and fix them by finding the route cause.
• Validated daily and weekly load jobs to dump data from HDFS data lake to RDMS Oracle database for processing and re-importing to HDFS after process.
• Extensively involved in validating Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Involved in testing designing and development of Big data &ETL Data warehouse environment.
• Expertise in writing HQL statements for HIVE & SQL Statements in database to make sure the data is populating in Data Mart/Data warehouse According to Business Rules.
• Tested the Inbound / Outbound Interfaces to Finance RDBMS databases.
• Dealt Hive queries with many joins and conditions for finding matching and non-matching data, to generate new columns, estimate shipping quantities and similar requirements.
• Involved in creating Hive tables, loading the data using it and in writing Hive queries to analyze the data.
• Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, Flat files, ASCII, EBCDIC, Avro files, Json Files, XML files) before loading into target database.
• Involved in developing UNIX Shell wrappers to run various SQL Scripts.
• Automated the process to copy files in Hadoop system for testing purpose at regular intervals.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Expertise in validating migrated data from Oracle data warehouse to Hadoop HDFS using sqoop.
• Expertise in validating HIVE managed external tables for the migrated data from Oracle to HDFS.
• Expertise in validating core publish layer views created on Hive STG tables using complex transformations rules.
• Manage the Test data, Test environment and resolving QA environment issues.
• Coordinating with other application leads and product owners for test support and data support activities.

Environment: Hadoop, Hive/HQL, Impala, Sqoop, Spark, HDFS, Linux, Cloudera CDH 5.0, Spark - Scala, PySpark, Java, HUE, Map Reduce, DWH ETL Bigdata, JIRA, SQL, PL/SQL, Oracle 11g, TOAD, Sql Developer, qTest, WinSCP, UNIX, Control-M

Confidential, Winston-Salem, NC

QA Manager/ QA Lead

Responsibilities:

• Worked as a single point of contact for all QA resources and deliverables (Test configuration, management, Test Data Management, Environment Managements etc) for both strategic and non-strategic Projects.
• Managed and mentoring all QA Leads with deep understanding of Testing Methodologies.
• Participated in requirement analysis and design sessions & ensure that appropriate test plans and test cases
• Lead test teams; assist development and test teams with quality processes.
• Review/write test cases, SQL queries, automated scripts and/or manual procedures.
• Review with Business Users and development teams to ensure appropriate test coverage.
• Support user acceptance testing (UAT) teams with test case preparation, and coordinate the test execution cycle to ensure each project is progressing on schedule and in adherence to all policies and procedures.
• Develop test strategies and processes, working at the highest technical level of all phases of application testing activities.
• Worked with Program stakeholders and external focal points to identify and remove barriers- escalating as necessary to meet Project SLA's.
• Coordinated and monitored all project teams during project lifecycle phases, particularly in design and development Individual project responsibilities included: project estimation, budget management, developing project planning strategies, establishing milestones and schedules, maintaining and reporting project status, issue tracking, risk management, change control, and monitoring activities of all team members.
• Monitor, analyze and publish weekly report on multiple projects to ensure accordance with defined project standards.
• Identify and document data/report faults and work with developers in fault resolution. worked on Hadoop ecosystem, including tools like HDFS, Sqoop, Hive, impala and HBase.
• Lead & participate in integration/End-2-End testing efforts.
• Experience with data warehousing, dimensional modeling and ETL development.
• Communicate and escalate risks identified during testing activities, as appropriate, to key project stakeholders.
• Provide guidance and training to less experience testers on a regular basis at distributed team environments like onsite/offshore.

Environment: Informatica, Unix, Oracle, Hadoop, HDFS, Sqoop, Hive, DB2, Natezza, IBM Visual Explain for DB2 Ver.8, IBM Control Center for DB2 Ver.8.

Confidential, Durham, NC

Sr. QA Lead

Responsibilities:

• Worked on requirement analysis and understanding of DWBI technical specification documents and Participate in requirement gathering sessions with BCBSNC business user.
• Worked as a single point of contact for all QA resources and deliverables (Test, Configuration Management, Test Data Management, Environment Management, etc.) and mentoring QA Engineers.
• Validated all data transformations and perform End-to-End data validation for ETL systems. strong in SQL and write complex SQL queries for validating business rules using Oracle/Teradata/SQL Server/DB2 scripts.
• Worked with Developers and Systems Analysts to define test scenarios. Developed test data sets, SQL scripts to test backend technical/integration functionality
• Reviewed design specifications and provide guidance to development and business sponsors regarding potential issues.
• Interpreted the business rules and technical documentation to create and implement test plans, test scripts, and test cases to certify accuracy of data content in new database development and revisions to existing databases.
• Created SQL scripts to collect and analyze data.
• Managed risks and issues during the entire project implementation. Escalated QA related project concerns to senior management in a timely manner.
• Identify and document data/report faults and work with developers in fault resolution. worked on Hadoop ecosystem, including tools like HDFS, Sqoop, Hive, impala and HBase.
• Lead & participate in integration/End-2-End testing efforts.
• Worked with Developers and Systems Analysts to define test scenarios. Involved in the identification of test data requirements and established test data repositories. Worked with Configuration and Environment management resources
• Actively participated in analyzing system documentation, ex. Requirements, Interface Specifications, etc.
• Managed Defect Reporting process and collaborate with Developers as needed to isolate root cause of defects.
• Prepared test status, and disseminated statuses in project meetings that spread over multiple departments in Capital One.
• Proven ability to quickly adapt to and become effective in complex projects and matrixed environment

Environment: Ab Initio, Unix, Oracle, Hadoop, HDFS, Sqoop, Hive, DB2, Sql Server, Control-M, IBM Visual Explain for DB2 Ver.8, IBM Control Center for DB2 Ver.8.

Confidential , Boston, MA

Lead QA Engineer

Responsibilities:

• Coordinated and monitored all project teams during project lifecycle phases, particularly in design and development Individual project responsibilities included: project estimation, budget management, developing project planning strategies, establishing milestones and schedules, maintaining and reporting project status, issue tracking, risk management, change control, and monitoring activities of all team members.
• Worked as a single point of contact for all QA resources and deliverables (Test, Configuration Management, Test Data Management, Environment Management, etc.)
• Worked with the GC, PM, release manager, business analysts and TD leads to develop and manage the project schedule.
• Managed RIAD document risks, issues, assumptions &dependencies during the entire project implementation.
• Worked with Developers and Systems Analysts to define test scenarios. Developed test data sets, SQL scripts to test backend technical/integration functionality
• Reviewed design specifications and provide guidance to development and business sponsors regarding potential issues.
• Developed test strategies, test plans and test cases to test system enhancements and improvements.
• Developed maintained Traceability Matrix to cover all functional requirements across the platform and making sure the end user needs/Business requirements.
• Developed test project plans using MS Project. Execute test plans according to published project plan.
• Provided status reports and Summary Signoff Reports.
• Interpreted the business rules and technical documentation to create and implement test plans, test scripts, and test cases to certify accuracy of data content in new database development and revisions to existing databases.
• Created SQL queries to collect and analyze data.
• Created analytical results reports - both written and graphical.
• Served as a data expert on underlying business and data rules to negotiate possible resolutions that support and enforce data quality standards, validate data transformation logic, and to certify data resolutions.

Environment: Informatica, SSIS, Unix, Oracle 9i/11g,, Quality Center, Control - M, Toad, iCEDQ, AQT (Advance Query Tool), FileZilla, Hadoop, Hive, DB2, IBM Visual Explain for DB2 Ver.8, IBM Control Center for DB2 Ver.8, Golden Gate, Quality Explorer Clear QuestHumming Bird, WinSCP 4.1.9,& MS-Visio.

Confidential, Charlotte, NC

QA Engineer

Responsibilities:

• Coordinated and monitored all project teams during project lifecycle phases, particularly in design and development Individual project responsibilities included: project estimation, budget management, developing project planning strategies, establishing milestones and schedules, maintaining and reporting project status, issue tracking, risk management, change control, and monitoring activities of all team members.
• Worked as a single point of contact for all QA resources and deliverables (Test, Configuration Management, Test Data Management, Environment Management, etc.)
• Managed RIAD document risks, issues, assumptions &dependencies during the entire project implementation.
• Worked with Developers and Systems Analysts to define test scenarios. Developed test data sets, SQL scripts to test backend technical/integration functionality
• Reviewed design specifications and provide guidance to development and business sponsors regarding potential issues.
• Interpreted the business rules and technical documentation to create and implement test plans, test scripts, and test cases to certify accuracy of data content in new database development and revisions to existing databases.
• Created SQL scripts to collect and analyze data.
• Created analytical results reports - both written and graphical.
• Managed risks and issues during the entire project implementation. Escalated QA related project concerns to senior management in a timely manner.
• Actively participated in analyzing system documentation, ex. Requirements, Interface Specifications, etc.
• Worked with Developers and Systems Analysts to define test scenarios. Involved in the identification of test data requirements and established test data repositories. Worked with Configuration and Environment management resources
• Managed Defect Reporting process and collaborate with Developers as needed to isolate root cause of defects.
• Prepared test status, and disseminated statuses in project meetings that spread over multiple departments in Capital One.
• Proven ability to quickly adapt to and become effective in complex projects and matrixed environment