Shyamala SQL

Shyamala SAP
Contact information:
Email ID: kranthi@hireitpeople.net
cell: 202-350-4277
Summary:
• 15 years of work Experience in the Information Technology field in the area of Quality Assurance, Development,
maintenance and testing of software Applications
• Hands on experience and expertise of industry standard methodologies of SDLC and STLC
(Agile, Kanban, Waterfall)
• Expertise in ETL Testing, Database Testing, Functional Testing, Regression Testing, Automation Testing
Product based Testing, API Testing, Telecom Testing using Telecom Software(Kenan 11.7), Unit testing,
Integration Testing, System Testing, Smoke testing, Regression Testing, Black-Box/White Box
• Hands on experience with using Informatica power center 9.6 for development and testing.
• Hands on using Power center, Talend Studio, AWS Redshift, Informatica Cloud, Query Surge(ETL
Automation)
for Testing EDW and ODS.
• Experience with Jenkins as a CI/CD tool to kick of automated jobs.
• Hands on with UNIX to test files in an ETL set up -checking head, tail, format, position of characters and
comparing it with incoming files.
• Experience
testing web applications/API with knowledge of cross browsers and user interface testing
technique using Selenium(Web driver) with JAVA(Core Java), Postman, REST Client, .NET and AJAX
• Experience with salesforce testing -creation of contracts, plans and checking the data flow.
• Experience leading and managing teams offshore and onsite
• Expertise in designing Test Scenarios, Test Plan & Test Reports.
• Proficient in Test case writing & execution, Defect tracking and Reporting.
• Experience with Bug Reporting and
testing Tools-, JIRA, Test rail, Rally, AR Remedy, HP ALM, TFS
• Extensive experience working with SQL complex Queries using inner, outer joins, CTE, Subqueries and
PL/SQL for database testing and DWH testing validating source and target.
• Exposure to ETL
MDM for match and merge functionality
• Good knowledge on BI Reporting tools-Tableau, Micro strategy and SAP BO.
• Proficient
with Data warehousing concepts and applications and databases-SQL Server, ORACLE.
• Good Knowledge of VB Scripting, Python scripting, and UNIX Shell Scripting, RESTful, HTML, PHP, RPGLE,
SOAP, XML/JSON, JavaScript
• Experience working with Telecom OSS/BSS Systems and Kenan Billing software(Kenan fx 11.7) for telecom
product configuration.
• Adaptability to challenging environments and smart working along with strong work ethics and ability to learn new
concepts.
• Excellent Communication and client interaction skills.
Summary of Skills:
Operating Systems Windows 2000/NT, XP/4.0/95/98
Languages PL/SQL, Core Java, VB Script
RDBMS SQL Server and Oracle, base
Web Technologies HTML, XML, SOAP, Web Services and JavaScript
Tools
AWS Redshift, Informatica cloud, Query Surge, Talend,
Rally, Salesforce, Quality Center, , ETL Informatica, AR
Remedy, Selenium, QTP Eclipse, Firebug, Auto It, TOAD,
PL/SQL Developer, SQL, Kenan 11.7, QTP, Java, Putty,
FileZilla, SQL Server
Certifications:
ISTQB
ITIL
Education
MCA from Osmania University
B.Com Honors from Osmania University