Shanker Vadlamani
**** ********* ******* *****, *********
337-***-**** (cell) Email: *****************@*****.***
See my LinkedIn profile at https://www.linkedin.com/in/shankervadlamani
A QA professional with over 11 years of experience in manual and automation testing.
PROFILE:
Excellent analytical, communication and interpersonal skills.
Proactively assist in troubleshooting to identify and resolve issues early.
Extensive experience in following QA methodologies, analyzing business requirements, preparing test plans, performing functional,regression,SIT/CIT testing, writing test cases and executing them.
Experienced in ETL, Database and Business Intelligence testing.
Expertise in Manual Testing/mobile application testing, Symbian, Blackberry, Android Mobile applications.
Experience in Onsite/Offshore models.
Knowledge of relational, star schema, dimensional data models.
Experience working on Databases like Oracle, Teradata, SQL Server, IBM DB2.
Exposure to Salesforce CRM.
Experienced using ETL tools like Red gate.
Experience in Email Marketing Campaigns
Experienced in Testing BI applications using OBIEE, SSRS and Informatica.
Experienced in Change Management.
Experience in Automation tools like Selenium, Cucumber and QTP
Experience in setting up email marketing campaigns via exact target
Analyze bugs, troubleshooting with software development and other teams to fix errors.
Involved in maintaining test matrices and traceability matrix and performing GAP analysis.
Strong attention to detail, producing detailed, accurate and reliable documentation.
Experience in testing applications on mobile devices like iPhone, Android.
Experience with Web-based enterprise applications, SOA (Services Oriented Architecture), Web 2.0 and Web application servers. Experience in developing XML requests for web service testing and validate response XML.
Experienced in QC admin work.
Experienced in Financial and Retail domains.
Expertise in partnering with software development teams and managing testing for multiple work streams in big enterprise projects, including e-commerce client websites.
SKILLS AND PROFICIENCIES:
Testing tools: Win Runner, Load Runner, Quick Test Pro (QTP), and Rational, Red gate, SOAPUI Pro, JUNIT, Selenium, Poster (Firefox), Selenium, Renorex, Cucumber
Version Control Tools: Github, MTFS
Test Management/Reporting tools: Test Director, Quality Center,9,10,10.5,HP ALM 11.5,UFT,Jira,Test Rail
Reporting /ETL Tools : SSRS 2005/2008, OBIEE 11g, Microstratergy, OBIEE, Informatica
Languages: HTML, XML, JavaScript, .NET, Visual Basic, C, ASP
Databases: Oracle, SQL Server, MS Access 2000,Teradata,DB2
Operating systems: Windows 7x,10x/2000/ NT/XP, HP Unix, MAC OS,Linux
Mobile platforms: iOS: iPhone 6,6s,5,5S,5C,4s, 4, iPad 2, iPad 3, iPad Air, iPod; Android: Galaxy SIII, S4,S6
Droid Razr, HTC evo, Nexus T Tablet, Google Nexus, and Samsung Note; Windows phones; Blackberry.
Web servers: Apache, IIS
Project methodologies: Rational Unified Process (RUP), Waterfall SDLC, Agile Scrum, Adode A/B testing Suite, CA Agile
Project Management Tools: Confluence, Robohead, MS Project
Other software: Photoshop, Adobe CQ, Adobe Test & Target Suite, MS Visio, MS Office, Win Merge, Red Gate, Checkmate(OBIEE test automation tool),Microsoft Dynamics CRM 2012,2013,2015,2016, Salesforce
PROJECT DETAILS
Test Lead/Manager, American Tire Distributors, Huntersville, NC Feb 2014 till Date
Worked on various projects like “Walmart Canada”, “BI Stabilization” “BI Modernization (Migration from Microsoft BI to OBIEE)”, Microsoft Dynamics CRM, Oracle EBS, ATD Online and ATD Mobile App.
Preformed Functional, System, Integration, Regression and Database testing.
Perfumed extensive ETL testing using Red gate tool.
Involved in initial Requirement Analysis phase and understanding user stories defined in Jira
Preparing daily workloads for staff & coordinating the daily allocation of work including myself.
Preparing weekly and monthly status on time.
Mentoring and training up junior and new staff.
Initiated Triage meetings with client regularly to discuss about defects and prioritize them.
Handling client enquiries and acting as the face of the business.
Analyze data trends, draw conclusions and recommend direction as it applies to defect resolution.
Setup JIRA-Jam Plugin setup for the team for Defect mappings between the tools.
Worked as QC admin for some time.
Worked on Automation suite using selenium
Tested Applications like “Walmart-Canada” for Canadian customers and “BI Intelligence” an ETL oriented testing.
Participated in defect triage meetings.
Coordinated with Dev and BA teams and OPS teams for the projects to avoid communication gaps and resolve issues.
Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
Experience in hybrid apps and mobile apps on iOS, iPad and Android devices
Performed Validation using simulators and emulators and also with real time devices.
Experience working on BrowserStack for cross browser testing.
Extensively tested several OBIEE reports for data quality
Tested all OBIEE Dashboards according to the requirement
Worked on Microsoft Dynamics CRM project for Field Support.
Extensive experience on CRM Mobile App testing and web based cloud testing.
Experience in EBS Oracle testing.
Experience in Auto jobs and Autosys.
Sr.QA at Ally Financial, Charlotte, NC Dec 2013–Feb 2014
Involved in in-depth analysis on Agile iteration/Backlog Stories and identifying business gaps
Involved in the story point estimation for stories and Test Plan,Test Scripts, Test Conditions Preparation for various Functional and OS-Browser testing
Functional and OS-Browser Test Execution and reporting
Involved in Smoke Testing, Functional Testing, Integration Testing, Regression Testing.
Involved in compatibility, functional and user interface testing in different Mobile handsets
Involved in defect tracking and reporting using QC
Create and execute SoapUI requests to validate the API Calls and response
Participated in Defect triage meetings with Development, product and different test teams.
Preparation of defect report and test execution summary report on daily/Weekly basis
Involved in Onsite offshore co-ordination.
Supported the product team in User Acceptance testing
QA/UAT Lead at Lowe's (Lowes.com),Mooresville, NC May 2010–Dec 2013
Created, wrote, managed and implemented software quality assessments, software test plans, test design specifications, and test cases for mobile apps and mobile web. Improved existing smoke tests.
Created Test Plans and managed the team for testing various applications across multiple browsers in production as well as QA environments.
Develop, maintain and execute automated and manual test scripts for requirement validation, integration, regression, performance and usability testing.
Create and maintain reusable test data for automation scripts.
Liaise with Business Analyst, Project Manager, and Development team member(s) throughout for delivering better quality products.
Working experience in Adobe A/B testing.
Worked with Email marketing team and experience in setting up email marketing campaigns and digital marketing
Analyzed Business Requirements, Business rules and Technical Specifications.
Provided high level estimates on testing efforts based on the respective impact analysis.
Generated weekly reports on progress of current project(s)
Tested on GSM, LTE, and CDMA based devices.
Experience in performing automation testing using selenium and cucumber
Managed and Conducted Mobile testing over the cloud using Device Anywhere.
Determined repair priorities and updated status of test cases in Quality Center.
Tested daily promotions, banners, and homepage on Lowes.com on store, item and state level.
Worked closely with various teams during stand-ups and in retrospectives to improve.
Tested over all kinds of IOS devices which included: iPhone 5, 5S, 5C, 4s, 4, ipad 2, ipad 3, ipad Air.
Tested over all kinds of Android devices which included: S3, S4, S6, S7, Droid Razr, Droid 4, HTE evo, Nexus T Tablet, Google Nexus, and Samsung Note.
Tested on Blackberry as well as the windows phones.
Conducted and lead Defect triages for UAT/QA defects.
Created best practices and training materials for technical testing.
Lead and tested geo-targeted homepage versions using Adobe Test & Target Suite.
Provide UAT support (baseline, integration, regression) for daily site enhancement.
Updated test scripts using Quality Center and documented defects found during functional and regression testing in Quality Center. Followed up throughout the bug life cycle.
Performed in-store testing of the store app used by store associates.
Trained and mentored individuals both onsite and offshore in promotional banner and homepage testing methodologies.
Worked against tight deadlines during Black Friday.
Generated test summary reports, got sign off, and uploaded valid documents in SharePoint.
Researched root causes and worked with risk management.
Helped determine best use of development and testing resources onsite and offshore.
Tested web services using Advanced Rest Client (XML over HTTP) and Soap UI.
Performed black box and white box testing for checking functionality, security, and regression.
Mentored and Trained onsite and offshore resources on projects.
Experience in working in Onsite/Offshore model.
QA Engineer at Savvytech Solutions Oct 2008 to Apr 2010
Created Test Plans and managed the team for testing various applications across multiple browsers in production as well as QA environments.
Designed and executed test cases according to the business specification.
Develop, maintain and execute automated and manual test scripts for requirement validation, integration, regression, performance and usability testing
Participated in defect triage meetings.
Involved in Creating Low, Medium, High and Critical Issues in QC.
Coordinated with Dev and BA teams and OPS teams for the projects to avoid communication gaps and resolve issues.
ETL Consultant at Provident Bank, OH
Oct 2007-Oct 2008
Involved in the development of system requirements and design specifications.
Participated in the design and development of Star Schema.
Developed complex mappings in Informatica to load the data from various sources using different transformations like Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
Developed Mapplets to implement business rules using complex logic.
Created and scheduled Sessions and Batches through the Informatica Server Manager.
Administered the locks on the repository objects while they were being used in sessions and batches.
Created User groups, users and assigned corresponding repository privileges in the Informatica Repository Manager using the administer repository privileges.
Designed and documented the validation rules, error handling and test strategy of the mapping.
Tuned the sessions for better performance by eliminating various performance bottlenecks.
Wrote UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
Converted the SQL/Procedures and SQL*Loader scripts to Informatica mappings.
Software Teaching Assistant McNeese State University Feb 2007-Aug 2007
Trained and helped Undergraduate students with Database installation and Database security
Assisted Professors in grading and helped them with their presentations.
Database Systems Engineer at ER Systems Jan 2006 to July 2006
Installation, configuration and upgrading of Microsoft SQL Server/MY SQL Oracle server software and related products.
Establish and maintain sound backup and recovery policies and procedures.
Database tuning and performance monitoring.
Implement and maintain database security.
Designed and executed test cases according to the business specification.
Participated in defect triage meetings.
Coordinated with Dev and BA teams and OPS teams for the projects to avoid communication gaps and resolve issues.
EDUCATION
Master’s in Engineering, McNeese State University
Bachelor’s in Engineering, Osmania University