Data Warehousing Sql Server
Resume:
Japneet Singh
*******.******@*****.***
SUMMARY OF QUALIFICATIONS
Over 10 years of extensive experience in Software Testing in cloud computing, Data Warehousing, Client/Server applications and Web based applications.
Experience in Data Mining & Big data Analytics.
Proficient in both Manual and Automated testing using automation tools like UFT and Selenium webdriver to run scripts for Functional and Regression Testing.
Experienced in creating, enhancing and maintain test scripts for functional and regression testing suite using UFT.
Experience in testing REST Web services.
Hands-On expert in Test Rail, Jira, Rally, Quality Center & Test Director for writing Test Cases, Test Execution, Defect Management, Defect Tracking and Bug Reporting.
MDM and Experience in Data Warehousing/ETL Testing within the environment of Oracle, SQL Server.
Have solid experience on database query tools such as SQL Developer and TOAD SQL and SQL Server Management Studio.
Experience in testing of Data Integrations related to data Warehousing and then to Master Data Management (MDM).
Proficient in Back-End/Database Testing, specifically in developing and executing SQL queries to interact with databases.
Experience in health care domain (Medicare, Medicaid including EDI 837/835 transactions, claim processing, CPT codes, ICD-10 codes data).
Experienced on various marketing applications for providing better reporting purposes like Teradata, Marketo and Salesforce.
Hand on experience with working on Bigdata technologies like Amazon Redshift, HADOOP and HIVE.
Experience working on TSV files, loading these files into Tables and validating data.
Worked with Business Analysist and Functional Team members to translate Business requirements into ETL technical specifications.
Expert in Database testing including Regression, Integration, System, Performance, Functional and Unit Testing.
Experience with version control, configuration management and change control procedures.
Strong knowledge of Software development life Cycle and Software Testing Life Cycle and highly proficient in Waterfall Agile methodology.
Expertise in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual and automation testing.
Initiated in writing/running test cases in Stoplight and Postman to test API web services.
Well versed in writing detailed test cases by utilizing functional & non-functional requirements.
Helped team in transforming business process requirements into Functional Requirements, Functional Specifications, Business Process Mapping and Modeling for application development.
Experience in working in Azure dev ops/TFS.
Worked in generating and Tracking Service now tickets
Experienced with managing and resolving offshore QA/developer team roadblocks.
An effective communicator with strong analytical abilities, combined with skills to plan and implement projects and strong aptitude for learning new technologies.
Ability to work independently as well as within a team environment.
TECHNICAL SUMMARY
Project Methodologies
Agile, Waterfall.
Defect Tracking tools
Jira,Rally, Mercury Quality Center, Quick Test Pro, SharePoint,ADO.
Languages
SQL, HQL, MY SQL, Java, HTML.
Databases
Oracle 8i/9i/11 and SQL Server.
Data warehouse
Hadoop, Amazon Redshift, Hive, Teradata.
Marketing Analytics Tool
Salesforce, Marketo, Qualtrics.
Operating System
Windows 98/XP/ 2003/2008, Linux/Unix.
Technical Tools
SQL Developer for MySQL, MySQL Workbench TOAD, TERADATA SQL Assistant, Selenium, PUTTY,Swagger,Postman, UFT, Stoplight.
Tools and Applications
MS Visio, MS Office, MS Project, Excel, MS Word
Requirement Management Tools
Rational Clear Quest, ReqPro, MS Project, VISIO
PROFFESIONAL EXPERIENCE
Infosys /Caresource, Sacramento, CA
Lead QA/BSA April 2022 to Current.
Responsible for monitoring the data flow for various EDI transactions (EDI 837/835 transactions, claim processing, CPT codes, ICD-10 codes).
Leading offshore and onshore team.
Created process flows for cross-functional business process integration to adopt best practices and standards.
Created best practices to generate documentation for future references.
Work as lead to resolve gaps among different teams.
Validated data in tables by writing complex SQL queries in SQL workbench DB.
Worked on STATE OF OHIO Medicaid project (Validating/Creating data in Facets and different output xml files).
Created and documented test plans, test cases and registered the expected results in Jira.
Used Jira for bug tracking, bug reporting, storing and maintaining the test repository.
Participated in meetings to analyze team work and gave estimates for future work
Worked closely with Management to provide effective solutions and enhancements to the product development.
Review the data submitted by Plan Partners for completeness, accuracy, and timeliness.
Prepared reports for the management to obtain more accurate data from data partners for future submissions.
Worked as lead assigning and creating user stories in Jira.
Autodesk, San Rafael, CA
QA Engineer February 2018 - October 2021
At Autodesk, I was worked on Master data management team. The main objective of team is implements secure, reliable, on-demand software, enabling Autodesk to unlock data insights in the Customer domain.
I also worked on GDPR team. The main objective of the team is to comply with European Union general data protection regulation which governs the collection, processing, use and storage of personal data of Autodesk clients.
Responsibilities:
Tested track flow of API calls from different source to target through APIGEE.
Extensively written SQL to confirm the data transfer from source to target.
Validated data in Salesforce & Marketo and other marketing tools and UAT Testing
Validated data in Redshift tables by writing SQL queries among different databases.
Hand on experience on working on Amazon Web Service.
Experienced in Master Data Management (MDM) testing for source identification, data collection, data transformation, rule administration, data consolidation and data reconciliation.
Experienced in writing/running queries to Load data and validate data in Linux.
Testing data consistency and data flow from Redshift tables to Hive tables in SQL server and Linux environment.
Automated Rest APIs using Rest Assured framework to test Json response by using Json path and code check-in to Gitbucket.
Worked on MDM and Experienced in testing REST/SOAP web services through postman, swagger,stoplight and validate data flow.
Experience in working and writing test cases in stoplight.
Scheduling and automated jobs to be run in batch process and performed batch testing through AWS and Jenkins.
Extracted data from various tools like Oracle, CSV files from AWS and FTTP server.
Performing various type of Functional, Regression and Integration testing and SIT Testing
Participated and running in regular and QA status meetings involving giving demo to Stake holders.
Extensively integration with developers, business and various management teams to understand project requirements.
Using Jira to write Test cases and tracking defects to test data flow and Master Data Management (MDM)
Working closely working with external companies to validate data flow and storage.
Working on different internal applications how data is transformed.
Experienced with managing and resolving offshore QA/developer team roadblocks.
Worked with different teams across multiple countries.
Cornerstone on Demand, Santa Monica, CA
Software Quality Analyst January 2016 – January 2018
At Cornerstone on Demand, I was working in employee performance management team. The main objective of team was to improve product visibility and client satisfaction of the application. Enhancement of existing application by adding new features to the application and supporting clients by resolving any issues.
Responsibilities:
Tested web based application using internal robust automation framework by creating automated scenarios.
Work on testing CSS based web application across different browsers manually in different cultures.
Experience in Mobile APP testing on Android, iPad and iPhone, Emulator, Simulator to perform Mobile App testing, phone functionality and native app testing.
Experienced on creating data pages and spying the objects which are used in scenario through UFT.
Automated regression test suite and stories in UFT.
Conducted data driven testing using UFT to test the application with different set of datasets.
Worked on desktop testing covered functionality, such as performance, compatibility of software across various operating systems, screen resolutions and hardware configurations.
Experience working in graphical elements of a desktop application, along with how your users interact with it also to make sure that the application’s interface is functioning properly,
Worked on creating smoke test scripts which run daily to validate nightly builds.
Worked on frontend UI automation framework along with automating smoke, regression, integration and functional test suites using POM approach, TestNG and Maven and validate data integrity against database’s by creating SQL queries.
Wrote complex SQL queries to validate accuracy of data in backend SQL server.
Worked on uploading and deleting dummy data in SQL server to support a customer requirement.
Validated and parsing of data in locale translation (different culture in backend tables).
Created regression suites which run biweekly for stage and production deployments for the client bug fixes.
Actively monitored weekly automated regression scenarios to look for any failures and fix them by updating the automation scripts.
Continuously worked on testing and resolving client bugs.
Perform various kinds of testing such as Functional, Integration, End-to-End and system testing.
Created and document test plans, test cases and register the expected results in Test Rail.
Worked on defect tool Test Rail for bug tracking, bug reporting, storing and maintaining the test repository.
Worked closely with other teams to enhance current application for better client satisfaction and help them with automating test scenarios.
Efficient use of Agile Methodology of Software development with frequently changing requirements and managing several sprint releases. Participated in several sprint releases spread across multiple iterations.
Participated in daily SCRUM meetings and other Agile ceremonies with team members.
Autodesk, San Rafael, CA
Software Quality Analyst March 2015 – December 2015
At Autodesk, I was part of marketing analytical reporting team. The main objective of the team was to increase the efficient usage of data for business owners and to provide up-to-date and consistent data. This enabled business owners to use data effectively for reporting, marketing and sales purposes resulting in increased number of clients and growth for the company.
Responsibilities:
Worked on marketing and analytics reporting data from salesforce and Marketo in agile environment with rapid 2 week sprints.
Worked with Putty to validate daily Scoop jobs with incremental load to populate Hive tables.
Worked in Redshift to validate jobs running in Hadoop cluster for successful completion of load data from start to end.
Validated that consistent, up-to-date data from external TSV files is updated daily into Hive and Redshift for reporting purposes.
Worked with Filezila to export TSV file from marketo and load to hive staging tables.
Validated missing data called through Rest API calls from marketo.
Validated monitoring tables in MySQL Workbench on daily bases.
Validated Silkview Dashboard was being updated with the daily current data.
Experienced with cleansing data in staging tables as per business requirements.
Created test cases, test plans, test data from User stories and reported status ensuring accurate coverage of requirements and business processes.
Created various test dataset scenarios, uploaded data and validated data as per business request.
Analyzed business requirements and user stories for creating and executing test cases.
Performed various kinds of testing such as Functional, Integration, End-to-End and system testing.
Experienced in writing complex SQL queries to validate accuracy of data both in HIVE and Redshift.
Created and documented test plans, test cases and registered the expected results in RALLY.
Used RALLY for bug tracking, bug reporting, storing and maintaining the test repository.
Reviewed existing test cases with the different kind of source systems for different periods of data.
Documented some of the recurring defects, their resolutions and business comments.
Worked closely with offshore teams to validate data for enhancement of current application for better reporting purposes.
PGE, San Ramon, CA
Quality Analyst October 2014 – January 2015
Project: Zainet and Endur retirement
At PG&E, I worked on projects named Zainet and Endur retirement. These applications were being retired from old database in Oracle to new database in Teradata for efficient use of data for reporting and audit purposes. Worked on testing data from Oracle to Teradata, filing bugs and executing test cases in Quality center.
Responsibilities:
Used OLELOAD to load tables in staging environment.
Wrote complex SQL queries in Teradata to compare data in core environment.
Tested data both from TOAD to Teradata by writing SQL queries SQL server.
Validated 500 tables including 300 tables with data in Sql server.
Wrote complex and large Scripts in SQL to validate data.
Created and documented test plans, test cases and registered the expected results in HP Quality Center.
Used HP Quality Center for bug tracking, bug reporting, storing and maintaining the test repository.
Documented some of the recurring defects, their resolutions and business comments.
Bank of the West, San Ramon, CA
QA Analyst May 2014 – September 2014
Project: ENTERPRISE DATA WAREHOUSE (EDW).
I worked on a project named ENTERPRISE DATA WAREHOUSE (EDW). This is a data mart which receives data from several source systems including another larger warehouse called FDM and does the processing on the data to make it ready and usable for different applications, which includes reporting and financial applications. The ETL is performed on the data that is being sourced from. Wrote complex SQL queries to validate data in Teradata SQL assistant and Toad. Used HP quality center to file bugs.
Responsibilities:
Tested and reviewed ETL mapping document and transformation based on business requirements.
Performed batch testing which included daily, weekly and monthly load.
Used TERADATA SQL Assistant to validate data in Teradata.
Worked on TOAD and SQL Server to validate Data.
Used HP Quality Center to execute, manage test cases and report bugs.
Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
Validated transformed data in Data Warehouse and Data Marts.
Created weekly Data Warehouse Quality report for the QA manager.
UCLA Health Care, Los Angeles, CA
Quality Analyst February 2013 - March 2014
Project: ODS
Worked on manually testing the data during enhancement of old data warehouse to new Oracle based data warehouse, ODS. We used SQL server to execute SQL queries and worked with Bugzilla to file bugs.
Responsibilities:
Performed End to End testing starting from validating E&B, creating auths, submitting claims, validating payment and claim status and regression testing.
Tested 276 EDI transaction for both home and host members to validate various edits at Gateway and NPI scenarios for Prof/Inst 276 transactions.
Tested Provider and VRU portals and handled different projects (Health care Reform, Upgrade App Retirement etc.)
Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems.
Retested the existing test cases with different kinds of source systems for different periods of data also with different type of Data like flat files, Excel sheets.
Data- integrity testing and back-end testing was performed manually by creating and executing SQL statements.
Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations.
Performed data validation testing from source target to destination target by writing SQL queries.
Manually performed back-end testing on SQL database by writing SQL queries.
Worked on import /export of Data.
Developed Automated Test Scripts to perform Functional, Performance, Integration, Stress, System, User Acceptance, Regression and Volume testing.
Used Bugzilla for storing, maintaining the test repository, bug tracking and reporting.
Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
EDUCATION
Master of Business Administration – Punjab Technical University, India
Visa Status
US Citizen
Contact this candidate