We provide IT Staff Augmentation Services!

Etl Tester Resume

Plano, TX

SUMMARY

  • 13+ years’ hands - on experience as Lead / Data / Test Analysis on Data warehouse, ETL, Web-Services, Security, SAAS / Cloud, Mobile, Web / eCommerce. (SCM) applications. Solid understanding & experience in writing test strategies, plans, prepare schedule, deliverables, defect documentation and test cases / scripts of manual / automation (Worksoft, Selenium and QTP 9.5).
  • The test execution of Functional / Integration / Regression / UAT / Parallel, Black / White / Grey Box for new implementations, system enhancements, product support along with Data Conversion from Legacy.
  • Leading projects and helping in selection of resources, training, planning, assigning & directing ongoing work, conducting performance reviews, resolving issues.
  • Perform testing / analyzing system upgrades, enhancements, break-fixes, and production support. Good exposure in Bulk Data Mgmt.
  • Validation for business process while writing multi-complex SQLs for various database / tables, retrieval of data, display to other applications.
  • Strong interpersonal, Organization, communication, coaching, facilitating, presentation skills.

TECHNICAL SKILLS

Worksoft: Tosca, Selenium, SOAP UI 5.0.0, Web Services (SOAP, RESTFul / REST, Jason), HP QC / ALM, TFS, Microsoft Test Mgr, Jira, Rational Test Concert (RTC), ClearQuest

BI Tools: SAP Hana Studio, Informatica, Business Objects (Webi / Design Studio), Bex Query, Tableau, Cognos, Crystal, Brio Reports, SQL Server, Oracle 11g, Teradata, Sybase, Essbase, mShare, DB Artisan, TOAD, PL/SQL, SQL Analyzer, MQSeries, VB / Java Script, HTML, UNIX / Putty, UC4, Beyond Compare, FIX / FIXML, EDI (820 834 835 837)

SAP: R/3 to 4.6b to ECC 6.0 FICO, FICA, FSCD, SD, MM, CS/CRM, SRM, HCM/HR/SuccessFactor, BO / HANA, WM / BW / Hybris, SAP PCard, PinPoint, eBridge (EDI - generate shipment doc), SAP TDMS, SAP Data Services / Integrator, SAP BPCA, SAP ChaRM, Ariba (Accounts, Contacts, Reports, Dashboard, Forecast, Settings, Reward), Solution Manager

Salesforce: CRM, ARCOs, Ventyx Service Suite 9.3.1 (Dispatch, Mobile, Administration, Workforce Availability), Remedy, Excaliber

MS Projects: Visio, PowerPoint, Excel, Word, PowerPoint, SharePoint, eRoom, RoboHelp

Other Technologies: C#, Java, J2EE, .NET, Perl / Shell / Java / Java / VBA Script, SAS, Unix, Mainframe, JSO / TSO, CA7 scheduler, MTI Operationals

Methodologies: Agile, Waterfall, Accelerated SAP (ASAP), Rapid App Development (RAD)

Test Management Tools: QC / ALM, Selenium, Worksoft, Jira, Tosca

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

ETL tester

Responsibilities:

  • Well versed in Database management tool - Toad
  • Optimize SQL statements and database code without relying on a DBA. Advanced optimization enabling DBAs to tune SQL effectively in production.
  • Ensuring database code and SQL scaling properly before it gets released into production.
  • Creating and maintain scripts and database code with debugging and integration with source control using Toad
  • Welversed in MDH tool
  • Perfect in SQL queries
  • Excellent knowledge in SQL scripts and test cases.

Confidential, Greensboro, NC

ETL tester

Responsibilities:

  • Lead & Manage A2W (Austim to Work) & non- A2W spectrum Resources for Conversion, Integration & UAT Testing
  • Prepare & Train A2W resources on ALM, SAP, SQL Scripts, Automation (Worksoft)
  • Lead the Digitization of Master Requirement Specifications (MRS), Master Configuration Design (MCD) Analysis, Standardization and Harmonization
  • Lead the AutoID (Testing Data by Test Script), Configuration Analysis and Test Script Analysis including S/4 Impacted Objects
  • Lead & support Worksoft Automation activities
  • Work with all teams to clarify & resolve all issues and suggest solutions
  • Performed Lead ETL testing Activities.
  • Wrote SQL queries and tested stored procedures as part of ETL testing.
  • Experience in DB activities.
  • Validate MRS (Master Requirements Specifications), Rewrite based on the industry standards, and work with DCM (Digital Capability Managers) to get an approval and help on uploading into ALM
  • Validate MCD (Master Configuration Design), Rewrite based on the industry standards, find the GAP, Reconcile with MRS vs MCD and work with DCM (Digital Capability Managers) to get an approval and help on uploading into ALM
  • Work with all teams to Setup Environments, Test Data & ALM
  • Create Management Reports, refresh & its updates
  • Support ALM Activities including Admin / Customization
  • Identifying trends, analyzing issues, suggest solutions and taking proper action
  • Performs Resource & Project assessments and audits on processes & procedures to ensure compliance to specifications, procedures
  • Penetration / Segregation of duties, rules testing
  • Test Tools Management including installation, configuring, provisioning for Worksoft etc.

Environment: HP ALM, SQL, Java Script, HTML/CSS, Tableu, SAP Ariba Procurement, SAP ECC, S4/HANA, SAP SuccessFactor, Hybris

Confidential

Consultant - Test Lead / Coordinator

Responsibilities:

  • Lead & Manage Integration & UAT Testing
  • Lead Interface / PAIRR (Partner Application) Testing and support
  • Lead & support TOSCA Automation activities including installations and configuring various testing management tools
  • Manage Test Management Meetings and take appropriate actions
  • Coordinate with business teams to develop Business Scenarios & Sequencing
  • Work with Business / Technical / Functional teams to identify business requirements, process flow and tech designs
  • Setup Environments, Test Data, Process Flows & ALM
  • Create Management Reports, refresh & its updates
  • Support ALM Activities including Admin / Customization
  • Identifying trends, analyzing issues, suggest solutions and insure proper action taken
  • Analyze Defects, prioritize and enforce in fixing
  • Audit SMBB T-Code with ALM & Environment (Integration & UAT)
  • Penetration / Segregation of duties, rules testing
  • Performs assessments and audits on processes & procedures to ensure compliance to specifications, engineering drawings, procedures

Environment:S4/HANA, Hybris, SAP Project Systems-PS,SAP Ariba Procurement, SAP SuccessFactor, ALM, SQL Server, TOSCA, Java Script, HTML/CSS, Tableu, Unix, SVN, REST, Excel

Confidential, Springdale, AR

Consultant - Test Lead (EHP7 for SAP ERP 6.0)

Responsibilities:

  • For functional / data warehouse / ETL / security test planning, development, and management of all aspects of Supplier Relationship Management (SRM), SuccessFactor& conversion to S4/HANA Program(s) on ETL / Mobile / Cloud / Web based apps

Environment: Supply Chain Mgmt. (SCM), SAP Procure-to-Pay; Ariba (Catalogue Contents, Shopping Cart, Dashboard / Network), SAP CRM, SD Orders -OTC, Pricing, Dispute, Transport, Treasury Risk Management, Credit, Billing / AR-Revenue with Multiple Deliverables, EWS / WMS, MM / EIM (Enterprise Inventory); GIS, MDM -Materials / Vendor, Materials Req. Planning & Invoice verification); Customer Orders Delivery / tracking; CS (Service Processing- Equip Master record, Service Order / Billing; Service Contracts - Periodic Billing); GTS Customs -Export & Import declarations; Alerts / Email / Workflow triggers for unexpected tasks & events); Data Migration, HR/HCM/SuccessFactor (Payroll, PerAdmin -personal data, new hire, retirement, travel exp and TimeMgmt - absence, attendance and time evaluation; Workforce Planning, Compen. and Learning Mgmt System -Recommend / Create and Track Course progress, ETL / BI / HANA, Bex Query, Design Studio, Salesforce CRM (Sales / Service cloud, Custom App), Worksoft, Selenium, SOAP UI, AWS, Oracle, .NET, Java, Remedy

Confidential, Richardson, TX

Consultant - Test Lead

Responsibilities:

  • Government Programs- MMAI (Medicare Medicaid Alignment Initiative) for functional / security / ETL testing for a number of states including Texas, Illinois, Minnesota (18+ projects) - test validations for the open enrollment includes various EDIs (834 Benefit Enrollment, 820 Premium Payments, 837 Claim Form, 835 Claim Payment/Advice)

Environment: EDI transaction (820 834 837), Data Migration, Rational Test Concert (RTC), Testing environment management / QC /IBM CURAM/ ALM, Excel, Word, PowerPoint, Visio, SQL

Confidential, Keller, TX

Consultant - Lead / Test Analyst

Responsibilities:

  • Validate Fund Product / Accounting, Asset Management & Operational support

Environment: WebServices -SoapUI / AWS, Quality Center, Excel, Word, Squirrel SQL, SQL Server Mgmt Studio (SQL), UNIX/Putty, UC4, Beyond Compare, QC

Confidential, Dallas, TX

Consultant - Lead / Test Analyst

Responsibilities:

  • Planning, Analysis, Coordination, Reporting, functional / security Testing (ALM Manual Scripts/ Worksoft) of SAP Financials / Procurement / Sales / BW / HCM / CRM System & Interfaces, and Corporate Workflow Tools (CWT) Web Portal.

Confidential, Maple Grove, MN

SAP Consultant - Lead / Test Analyst

Responsibilities:

  • Requirement Analysis, Blue-Print and its implementation Testing of SAP System for Functional Specifications for Interfaces, Conversions (ETL) while supporting Compliance Code of 21CFR-11 (Electronic Records - Controls for open / closed systems; Electronic Signature / password) - Security Testing

Hire Now