Post Job Free

Resume

Sign in

Sql Server Qa Analyst

Location:
Herndon, VA
Salary:
90000
Posted:
August 30, 2023

Contact this candidate

Resume:

SRINADH R. MARAM

PROFESSIONAL SUMMARY

•Senior QA Consultant with 12 years’ experience in testing.

•Knowledge of major cloud service providers, like AWS, etc.

•Understanding of CRM like Siebel, sales force etc. working know of ERP like Oracle apps, SAP and Peoplesoft. Worked with legacy systems like Mainframe etc. Experience using Selenium WebDriver.Experienced at TDD and BDD Concepts in testing. Working Knowledge of phython. Working knowledge of Bigdata. Good at Interaction with end users and colleagues

PROFESSIONAL EXPERIENCE

Senior QA Tester September 22- August 24, 2023

NextGen-DC

Client: Child and Family Services Agency (CFSA)

Scope: R1&Pilot (Intake): CFSA is enhancing existing FACES application to meet state and Federal requirements

Environment: SQL MS365 CRM,.Net, ADO

Contribution:

Provided testing for UI-UX based application built using CRM365

Tested dashboards and view or applets etc

Tested E2E flow of the functionality of the application

Tested apis used for interfaces between client and other ` applications

Followed agile process, epics, user stories, BPF’s for preparation of testing artifacts.

Written testcases, scenarios, testplan etc

Followed devops through Azure process using Microsoft tools

Senior QA Consultant

Delmock Technologies - Laurel, MD (Remote)

09/19 – 09/22

Client: WSSC, Washington Suburban Sanitary Commission.

Scope: PPC- Project Cornerstone is the upgrade of several old, yet mission critical, IT systems that encompass support customer service, billing, work assignment & asset management.

Environment: SQL, Oracle, CC&B, C2M, MWM, MDM, ODM, SOA, EBS, CSIS, GIS, SharePoint, ALM, UC4(UNIX)

Contribution:

Provided testing support for functional interfaces in C2M

Worked with iPad, MDT and Non-MDT for MWM and with following Meter upload/Download, Fiserv ebill interface A/P Refunds & GL extract

Tested C2M-MWM, Meter Reads billing, Accounting, Auditing, Security, IVRS system. Participated in integration testing of C2M-MWM, GIS-C2M.

Have an explicit understanding of CC&B / MDM and ODM application functionality

Provided ongoing data requests from the CC&B function departments

Used Atomic UC4 for submitting the Batch Job Flows.

Utilized Oracle C2M VERS 2.6, MWM, ORACLE VERS 12c, Oracle SQL Developer, HP ALM 11.5.

QA Tester

FDA ORA/Salient CRGT – Rockville, MD

02/18 – 08/19

Scope: RBIS includes different systems used by ORA of FDA for information management of regulatory affairs. RBIS includes ORADSS, FIDA OSAR.

ORADSS is used by all departments within ORA (FDA Regulatory Affairs Organization) to get scheduled and ad-hoc reports and dashboards to support the decision making.

Environment: SQL, oracle 11g, Windows, Excel, J2EE, Business Objects Reports, Web Intelligence, Informatica, SharePoint, ALM (Quality Center), HP-Unix.

Contribution:

Created testing artifacts for testing like test cases, testing reports. Tested and validated ETL process, the data from source (FACTS) system to data warehouse (target) for systems like Labs. Validated the Jira CRs (Change requests), Enhancements, Modification of ETL, Business objects reports, WebI related objects, universe, SQL validation etc. Used to interact with users regarding CR’s for UAT testing purpose.

QA Tester

Conduent – German Town, MD

Smart tag website -Indotronix 02/17 – 12/17

Scope: Disaster Recovery: the approach to accommodating the personnel, equipment, systems, network, applications and data components required to ensure the resumption and continuity of critical FL CCSS processes.

SWINT/SWINT Test Execution of interfaces of Siebel and web for FL CCSS.

Environment: oracle, SQL Server,SSIS, PowerBI,Powerhouse,Windows, Excel, Java, informatica, Siebel, Sun Solaris.

Contribution:

Tested the application in Disaster Box. Participated in Failover of the application. Participated in execution of test cases both front end, backend, Siebel functional. Tested ETL and replicated database applications

Tester

Smart grid solutions – Apex Covantage, Herndon, VA Ampcus-04/16 – 02/17

Environment: SQL Server, Windows, Excel, Dot Net, Selenium web driver, java

Scope: APEX Covantage/Smart grid solutions Provides software for utility based company like Gas, Network, Electric, etc

Profield automates the most important workflows that connect dispersed team members to their supervisors, to program headquarters and to third parties.

Contribution:

Tested the ETL Data for test scenario for integration testing of Interfaces using SSIS sql server Package. Tested the Exports files of the different interfaces of the Utility application. Tested the workflows of the utility application. Automated few scenarios of web application using selenium web driver.

Senior QA Analyst

hCentive – Herndon, VA 03/15 – 03/16(kforce)

Scope: The hCentive WebInsure Private Exchange solution allows health plans to offer defined contribution plan marketplace to small business customers.

The multi-carrier, multi-product hCentive WebInsure Benefits Platform allows large brokers to efficiently design, purchase and administer employee benefits and helps employees and individuals compare options and choose the most beneficial plans for their needs.

Environment: SQL, oracle 11g, Windows, Excel, J2EE, SOAP UI, SharePoint.

Contribution:

Created Test Scenarios and executing to test Business Rules for employer, employee, public exchange, LSC. Created test plan templates which were to be used as best practices format for business units. Designed Test Documents and recorded test results to use during regression testing after each build.

Senior QA Analyst

Dept. of Education Smithsonian – Washington D.C. 08/14 – 02/15

Scope: G5 is the Department of Education's new grants management system.

Environment: SQL, oracle 11g, Windows, Excel, J2EE, Informatica, Jaws, SOAPUI Pro, Java, etc.

Contribution:

Created testing artifacts for system testing like test cases, testing reports. Tested the different functionalities of G5 system. Involved in testing the SQL, IMRs as the project is in maintenance phase. Tested the regular imrs and task orders. Tested the application using 508 compliance and participated in accessibility testing. Tested Jasper Reports. Participated in Cross Browser Testing of web applications using IE, Chrome, Firefox, etc. Perform testing of web application using mobile apps on smart phones, androids, iPad, etc. Performed manual and automated test procedures for functional testing of Web services using SoapUI

Senior QA Analyst

Fannie Mae – Herndon, VA 03/14 – 6/14

Scope: NextGen is a Web-based application through which lenders submit loans to Fannie Mae for Whole loan sale and MBS Pools. Lender can import loan and pool data, perform edits to facilitate error-free delivery, transfer loans between commitments (or pools)

Environment: SQL, oracle 11g, Windows, Excel, J2EE, UNIX shell scripts, Autosys Scripts, Restful services Abinitio, Doors, Rally, Web Services, Gems, Selenium, Cucumber SOAPUI, JSON, WSDL, AIX.

Contribution:

Tested the ULDD requirements and be delivered in the MISMO XML ULDD file format. The full Property Address as shown in the Property Section of the Whole Loan Detail. Tested various versions of MISMO Data points of ULDD using golden files. Loaded ULDD format files for verifying the data in Early Check systems etc. Created Testing Artifacts for system testing related reviews Test results summary, test plan, RTM etc. Tested Restful services for LDNextgenapplications. Tested restful services, backend, frontend, business rules of the applications. Worked with JSON browser testing.

Senior QA Analyst/Test Lead

K – Herndon, VA

03/13 – 12/13

Scope: K provides any child access to exceptional curriculum and tools that enable him or her to maximize his or her success in life, regardless of geographic, financial, or demographic circumstance. Kindergarten through 12th grade students in most states are enrolled in online public schools or "virtual schools" that partner with K . Ecommerce: External site for customers who are interested in ordering K Courses or specialty items. EPR: parents can enroll students through online. OMS: Order Management System which is used internally by Sales/Operations team to provide order entry and administration.

Integration: Pushing /transferring the data from one system to other system

Environment: SQL, oracle, Windows, Excel, J2EE, UNIX shell scripts, JIRA, XML, QTP, SharePoint 2010, Test Manager, Test Complete, TFS

Contribution:

Created Testing Artifacts for system testing related reviews Test results summary, test plan, RTM etc. Tested Websites and Involved in testing the flow of functionality according to business rules. . Developed Data driven test scripts using QTP. Participated in risk management and defect management of the application Provided mentorship on SharePoint and ClearQuest/RQM for Uruguay testers

Senior QA Analyst

Fannie Mae – Herndon, VA

02/12 – 03/13

Scope: NextGen is a Web-based application through which lenders submit loans to Fannie Mae for Whole loan sale and MBS Pools. Lender can import loan and pool data, perform edits to facilitate error-free delivery, transfer loans between commitments (or pools)

Environment: SQL, oracle 11g, Windows, Excel, J2EE, UNIX shell scripts, Autosys Scripts, Restful services Abinitio, Doors

Contribution:

Equator Phase II ODS Reporting: Capturing Data from Equator ODS and load the extracted data to Fannie Mae ODS to support reporting.

History Events: For existing reports, there is a need to create specific history events. As part of the daily load of the ODS, logic will be applied to the data to determine if history events need to be created in TRAX database. Snapshot: On Monthly basis a snapshot of ODS will be created and available for reporting. Check2.0/CBRS: The enhancement of existing data warehouse of Early Check(EC 2.0) Release Loading process is for ODS and CFR will capture all the Early Check data from upstream internal data model. The new data will be stored in new tables and existing tables and make available to users for reporting, analytical and production support.

Senior QA Analyst

Freddie Mac – Reston, VA

06/11 - 01/12

Scope: SAI program, Freddie Mac will require Servicers to deliver new EDR codes to identify loans in the standard modification trial period and internally report and generate Servicer incentives for these loans.

Environment: SQL, oracle, Windows, Excel, J2EE, UNIX shell scripts, DataStage, C++, Web methods, Doors

SQL, oracle, Windows, Excel, J2EE, UNIX shell scripts, Autosys Scripts

Contribution:

Executed SQL queries using Rapid SQL to connect and Sybase, DB2 databases. Used clear quest for logging and tracking test defects. Tested the Servicer reports developed with J2EE technologies. Used shell generate the output of edits and servicer data. Runned AutoSys box jobs for generating tracking, under reported, over reported reports. Performed file transfer mechanism using FTP.

Senior QA Analyst, PMT, Performance Management Tool

Time Warner Cable – Herndon, VA

01/11 - 06/11

Scope: Time Warner Inc., PMT: Our team is involved in supporting the Agents who are taking calls from customers. The application PMT, Performance Management Tool, primarily focus on generating the scorecards for agents, supervisors and Managers in various groups of the Time Warner. I have involved in Design, Development and Testing of Data Feed to this PMT application from various sources. New and Improved data processing plan from grabbing data to processing the files in PMT scorecard system and enabling automated notification service.

Contribution:

Documentation and testing of Microsoft sql server, IIS, Business Intelligence OLAP application. Tested the scorecard website built using ColdFusion and Java applications. Data Analysis for Data warehouse applications of ODS, DW, OLAP cubes. Participated in Microsoft Sql server programming and data mining for Reporting.

Environment: SQL Server, SSIS (SQL Server Integration Server), SSRS (SQL Server Reporting Services), Windows, Excel, Quality Center, Java, Dotnet, XML, Web Services, Autosys, cold fusion, C#, SharePoint.

Senior QA Analyst/Data Warehouse Tester

Network Solutions - Herndon, VA

05/09- 12/10

Scope: Offers services that include domain registration, email and web hosting.

Environment: Quality Center, DataStage Teradata, Oracle SQL, MySQL, IE Explorer, Firefox v7.0, Oracle, SQL Server, J2EE, WebLogic, Struts, JSP, Siebel, SharePoint 2010

Contribution:

Tested Websites and Involved in testing the flow of functionality according to business rules. Executed test cases for websites using proxies by cross browser testing. Wrote SQL to test the ETL Data. Participated in testing for rebranding initiative related Test Scenarios, Test Cases and Test Data for UAT Testing purpose

Tested the front end of the application and logged the defects in quality center

EDUCATION

•Master in Science in Physics from Osmania University Hyderabad, India in 1997.

•Bachelor in science in Math, Physics, Chemistry from Osmania University Hyderabad, India in 1995.



Contact this candidate