Resume
Data Quality And Validation Lead Seattle, WA
SUMMARY:
- Senior Consultant with over 17 years of experience in Project delivery, Software Quality Assurance Engineering and including Regulatory Compliance and Validation of IT systems.
- Have successfully managed requirements analysis, planning, testing & delivery of both validated and non - validated systems and delivered their respective project deliverables under challenging project time lines.
- I am seeking a role of Architect / Lead for IT projects or Organizations for Testing and Business Analysis
- Over 10 years of testing experience as a Test Architect, Test Lead and Hands on tester.
- Can provide a complete soup to nuts solution for your Software testing needs.
- Based on factoring Time, Resource, Compliance, I can provide a path/roadmap on needs analysis for Testing.
- Can Plan, Build and Test solution (manual & automated) including validation deliverables.
- Can assist in building a auditable, manageable, searchable stricture in HP ALM, including various types of reporting needs.
- Can prepare data for testing
- Can provide assistance in Data harmonization / Data Governance
- Creating test coverage and quantifying testing scope, time and resources
- Managing Test Phases for creation of Data, Test Scripts
- Managing issues and defects
- How to show integrity in the system to owners
- Test Coverages should follow both Requirement and Data convergence path.
- Follow a risk based approach: For Validated system, drive entire project based on CFR part 11 and Business criticality.
- Minimize both Granular and Narrative formats of capturing Business requirements and traceability ; Move to Flow charts and Map it to Data, summarizing, Process, security, owner ship at Data level in the System/ data requirement specifications. .
- Keep the traceability Modular ( example: MS excel) and use Pivot Tables and Macros for metrics and aggregates for reporting
- Hands on understanding of the Business process and integration of business modules within SAP & Oracle e-business suite (OTC, CRM, FI/CO, SC (procurement), QM, MM, BW).
- Understanding of Master (Customer, Vendor & Material) and Transactional data creation process in ERP systems.
- Trained and working knowledge on SAP HANA BODS and BO rich reporting.
- Hands on understanding of Requirements gathering, Process Mapping & blueprinting of systems.
- Have driven requirements gathering process as per the project and validation standards, New, Upgrades and changes.
- Have lead successful Testing of SAP implementations from building a Test Plan, defining the Test Scope, Build Test Scripts, and Scheduling Test Execution across Cutovers, Issue resolution and status reporting.
- Tenacity to work long hours and deliver as per schedule under any conditions.
- Have strong understanding of User Acceptance Testing / Integration testing, regression, set expectations, Readiness of system (Data & access), Training, Validation of results and issue resolution.
- Have successfully lead and managed Large and small-scale project experience directing cross-functional and multi-national teams in development, integration and implementation.
- Experience in leading manual and automated testing (Mercury Tools (HP- QC ALM, SAP TAO / Emprix), Error mediation, preparing bug reports and metrics.
- Maintain a balance between captaining and hand holding to guide the project as per the schedule.
- Understand macro issues such as identifying tasks in project time lines, cross-functional impact and resource planning.
- Understand the project from Holistic perspective from discovery, requirements building, and testing phases, go live and post go-live.
- Well versed with documentation protocols and have worked on global templates, reports required for Testing & Sign Offs.
- Hands on knowledge on Business Warehouse, Data Model, Dimension, Cubes and Facts.
- Can guide through Business Warehouse analytics SAP HANA BODS with reporting in Business objects.
- Have lead Onshore and offshore teams.
- Have Planned Programs for Solutions/ Projects consisting of 20 team members.
- Have mentored and initiated processes for good practices for team members to adhere and follow in a project.
- Have championed solutions for clients by building return on investments for solutions.
- Have Managed Expectations of testing to the stakeholders, by providing informed knowledge regarding the Expected versus the actual testing results and a roadmap to mitigate.
- 7 years of Pharmaceutical Validation and IS/IT compliance experience with a focus on ERP and Data warehouse applications.
- Well versed with documentation protocols required for Validation: for ex: SOP’s, Global templates, Validation Plan, Change Management, Risk assessment, Corporate Compliance, Metrics,
- Have authored IQ, OQ, PQ deliverables (Requirements, Risk assessment, Traceability) and Sign offs.
- Up to Date Knowledge relating to CFR part 11 & GXP (Gamp 5) required for IT Systems Validation.
TECHNICAL SKILLS:
Languages: C & C++, SQL, Visual Basic, Java, JSP, JAVA Scripts, EJB, HTML, DHTML, XML, PERL
Databases: SQL Server 7.0/2000, DB2, Oracle 8i/7, MS Access; SAP HANA BODS
ERP: SAP R/3 4.6 S/D, MM, PP, SAP CRM 4.0, ECC 6.01, BW 7.3, SAP HANA BODS, BO 4.1
OS: Windows, UNIX
Software: MS Office, Visio, MS Project, Excel, MS Front Page, Dreamweaver, Business Objects 4.1
Case Tools: UML, MS Visio
Other Tools: Documentum
QA Tools: Quality Center, Load Runner, Test Director- Admin & User, Quick Test Pro, Empirix- E-tester, E-Loader
PROFESSIONAL EXPERIENCE:
Confidential, Seattle, WA
Data Quality and Validation lead
Responsibilities:
- ERP Project Implementation Planning
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
Platform: Magento, Oracle, AWS
Prog / query: Java, PHP, XML, SQL server, SQL
API: Social Media, Excel, CSV, Databases
Confidential, NY
Test Creator / Tester
Responsibilities:
- Author
- Data Migration specialist
Platform: SAP AFS (OTC), SAP HANA, HP ALM. RLM
Confidential, NJ
Tester SAP
Responsibilities:
- ( Changes) Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
SAP: FI, PTP, BW
Confidential, NJ
Test Creator / TesterResponsibilities:
- ERP Project Implementation Planning
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Author
- Data Migration specialist
- Development
Platform: JDE, HP ALM
Prog: SQL for reports
Confidential, Princeton, NJ
Test Creator / TesterResponsibilities:
- Validation and Testing of SAP to ECC 6.0 upgrade from 3.
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Author
- SAP Implementation
Confidential, Piscataway, NJ
Test Creator / TesterResponsibilities:
- Validation of HPQC and QTP for Automating test scripts for SAP
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
Confidential, Irvine, CA
Test Creator / TesterResponsibilities:
- Track and Trace Data warehouse project
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
Platform: Qlik View, Oracle.
Query: SQL
RDBMS: JDE, SAP
Confidential, NJ
SAP QA lead
Responsibilities:
- SAP TAO implementation / Enhancement Pack 5 Upgrade
- ERP Project Implementation Planning
- (changes) Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
SAP: OTC and HR
Confidential, King of prussiin, PA
SAP Test Lead
Responsibilities:
- ERP Project Implementation Planning
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
SAP: OTC
Confidential, Bridgewater, NJ
Senior Business and Validation analyst
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
Oracle: OTC / MDM
Query / Tool: informatica / SQL
Confidential, NJ
SAP Data Analyst
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Creator / Tester
- Data Migration specialist
- Development
Platform: Oracle ERP, HP QC, SQL
Confidential, Bridgewater, NJ
SAP Business and Validation (Gxp) / Test Coordinator
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
SAP: OTC / FI
Confidential, Boston
Testing Lead
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
Platform: Cognos, Informatica, Oracle, AWS
Prog / query: Java, PHP, XML, SQL server, SQL
API: Social Media, Excel, CSV, Databases
Confidential, NY
Senior Test Lead
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Author
- Data Migration specialist
- Development
SAP: OTC
Confidential
Senior Validation Analyst
Responsibilities:
- Test Creator / Tester
- Author
SAP: OTC / FI
Confidential, MN
Business analyst ( OTC ) and UAT tester
Responsibilities:
- ( changes) Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
Confidential, Lawrenceville, NJ
Lead QA Analyst
Responsibilities:
- Business requirements gathering for FRS and SRS
- Test Architect and Planning
- Test Creator / Tester
- Documentum
- Oracle / SAP: OTC ; QM standard API's to social media, data bases
- SAP HANA, SAP BW, BODS, Informatica.
- SQL, SQL Server, ORACLE, QLIkView
- Java, PHP, Python, C,C++, VBA, HTML
Confidential, Seattle, WA
Data Quality and Validation lead
Responsibilities:
- Assisting to develop Mobile platform and DW solutions for Business Analytics solutions in Ecommerce and Life Sciences.
- Solutions require the below universe and I am validat9ing the feed, validation dimensions. Based on deduping and ETL logic to create the unique user.
- Other areas I am working with are
- Identifying financial and category data aggregation.
- Visualization of fast moving products and defining a logic for readjusting the inventory based on weekly, monthly and quarterly replenishments and safety stock. .
Platform: Oracle, SQL Server, Tableau visualization on mobile devices, Excel, Mobile Platform integration, Data base API and DBMS integration with SAP HANA and BO
SAP AFS / TEST STRATEGY
Confidential, NY
Responsibilities:
- Recommended approaches for testing new SAP ERP implementation
- Proposed structure in HP ALM testing tools for organizing test artifacts.
- Proposed Process of identifying test scripts and building them in HP ALM, vis-à-vis the development deliverables.
- Recommended process to data preparation and test preparation
- Based on the structure, ability to generate value add report
Confidential, CHERRY HILL, NJ
SAP AFS / TEST STRATEGYResponsibilities:
- Worked with the various business areas to map their business processes
- Work with Functional leads and Business Owners to build and Qualify Requirements.
- Build Master Test Plan for the project.
- Build a robust risk matrix based on GAMP5 standards to prioritize the requirements.
- Set - up HP ALM ( test management tool ) for the Test Project
- Uploaded, Managed and got the approvals in HP ALM ( Test Management tool)
- Worked with the team to freeze requirements and build test scripts.
- Got the test Scripts reviewed and approved from business Users.
- Dry run the test scripts
- Set up Schedule and environment for testing.
- Escalate issues relating to deliverables and testing
- Manage the Defect Management process in HP ALM
- Provided status and reports to PMO and Steering committee.
Confidential, Princeton, NJ
SAP AFS / TEST STRATEGYResponsibilities:
- Activities include Drafting Test and Validation Documents and having them approved.
- Impart Training to Team
- Challenge / Improve Project related processes
- Introspect Confidential business process and ensure Validation deliverables like FDS, SDS, FRS, TRA are ready for validation approval.
- Plan Testing schedules and team
- Plan Test Scripts and have them approved from Val and Technical review
- Conduct Testing and Report Progress and status to PMO
- Escalate issues to PMO in a timely manner.
- Work with Project manager to align with key deliverables.
Confidential, Piscataway, NJ
Validation of HPQC and QTP for Automating test scripts for SAP
Responsibilities:
- Validation of Automation testing process using HP QC and QTP.
- Defined, Drafted and Most of the validation deliverables.
- Test Script Development and other development activities were defined and managed.
- Reported to PMO and SAP-COE leads about the progress, issues and risks.
- Defined Plan included managing the following criteria: Scope, Time Frame, Roles and responsibilities, exit conditions, issues escalation, progress report & status. ‘
- Defined the Automation testing process.
- Performed System Testing and UAT using automated test scripts:
- Test Script Development and other development activities were defined and managed.
- Reported to PMO and SAP-COE leads about the progress, issues and risks.
- Worked with SAP BASIS, MDM & Interface team (system integrator) for Environment readiness.
- Defined Plan included managing the following criteria: Scope, Time Frame, Roles and responsibilities, exit conditions, issues escalation, progress report & status.
- Defined the Automation testing process.
Confidential, Irvine, CA
Business Analyst
Responsibilities:
- Was the Business Analyst Validation Manager (GXP) / Lead with 3 offshore testers; Client needed Validation done on a new tool used for Data Warehouse for the Track and Trace Business Intelligence data warehouse. The Vendor application was QlikView.
- Understood the key data and inbound and outbound loads, The associative model of qlikview applications versus a traditional DW of relational
- In Span of 7 Weeks, I was able to guide the client successfully through the Business requirements and Validation of the Application.
- Highlight: I have excellent reference from the project, IT Director and Validation Manager
Confidential, Parsippany, NJ
SAP QA lead
Responsibilities:
- Lead/ managed a successful Implementation of SAP TAO 2.04 for the client to perform its SAP testing across SCM, P2P, and OTC & HR on ECC 6.0.
- Lead a team of 5 offshore SAP TAO testers and onshore (US) team to install SAP TAO, integrate with Solution Manager and HP Quality center and Quick Test Pro, Identify Test Scenarios, Automate and successfully execute them.
- Team of 7 testers ( Onshore & offshore )
- Worked with the SAP - COE to build a plan for the successful implementation of SAP TAO for the clients testing needs.
- Reported to PMO and SAP-COE leads about the progress, issues and risks.
- Defined Plan included managing the following criteria: Scope, Time Frame, Roles and responsibilities, exit conditions, issues escalation, progress report & status.
- Defined the Automation testing process for DSI.
- Build Components in HP QC for standard process and mostly used TCODES.
- Successfully build a test bed of 100 Test Scenarios for regression testing
- Held meetings and actively participated in Identifying test scenarios with functional leads
- Conducted Demos, Training and Regression Testing session with new Users and SAP COE
- Published FAQ’s and Process Documents relating to the project.
- Lead the QA testing & Computer Systems Validation for Enhancement Pack 5.
- Team Consisted of UAT and Development team (SCM, FI & HR), in the numbers of 30 - 40.
- Part of the team which finalized the scope of project, Vendor selection from delivery of the project to SOW.
- Worked with various team to identify scope, Pre-reqs, Data and dependencies for testing.
- Prepared the formal Master Test Plan with SAP COE, functional team, system integrator to identify key miles stones of testing.
- Worked with team leads and business from different modules to prepare the test scripts, Data and training.
- Build the project in HP Quality Center to track the testing with the required test scripts.
- Executed Reports from HP quality center for QA status reporting.
- Scheduling of testing and Issues resolutions with the Vendor.
- Responsible for signoffs for CSV and QA.
- Reported to steering committee the progress and reports.
Confidential
SAP Test Lead - OTC & Validation Reviewer
Responsibilities:
- Understood the Scope of testing, based on Daily meeting with the BA and system integrator.
- Worked with the system integrator to understand the Environment & data readiness.
- Reported the progress of test cases development, Quality review and scope creep to PM.
- Assisted the testers in Building test cases and getting them approved from Quality in HP Quality Center.
- Based on the Volume of test case planned the test schedule, No of resources that were needed and Dependencies of the test cases.
- Provided training to Testers on testing process, from Test Execution, Recording results, pass and Fail and Storing the excited labs
- Understood the dependencies on unit and cross function al level. And escalated the needs as per need to the PMO or technical team.
- Managed a team of 18 testers hand holding and captaining them to get all the test cases executed in timely manner
- Planned the Prep data, Seed Data for End to End.
- Planned daily activities during the testing phase from Retesting, Executing test cases and also clean of the executed test labs for quality review
- Creation of test plans / labs and mapping requirements in HP quality center
- Generation of Test Status reports from QC
- Use SAP (TAO) consolidator in the creation of Seed Data and multiple Orders.
Confidential, Bridgewater, NJ
Senior Business and Validation analyst
Responsibilities:
- Actively participated with Validation Team and Business in developing the Compliance Methodology. We held weekly meeting with other team members for continuous improvement and analyzing Risk.
- Provided training & hand holding on the Methodology to Business. (Templates, Change management, Traceability)
- Actively participated in gathering Business reqs and testing through an iterative process.
- Handholding on guidance for CFR PART 11, GMP and SOX assessment.
- Gave direction to Business and IT on preparing the documentation deliverables relating to Business requirements, and RICE
- Worked with the data migration team to understand the Confidential needs for Data.
- Developed and Delivered Data Migration testing plan.
- Successfully communicated and resolved issues arising between Business and IT.
- Prepared Validation Reports and Metrics.
- Advice on the matters relating to Trace ability of RICE elements and Configurations and Business Requirements.
- Guided the MDM cell successfully through end-to-end testing, used Quality Center to log in defects.