Sentences with phrase «sql queries»

Created complex T - SQL queries to develop and improve Stored Procedures, User - Defined Functions, Indexed Views and Triggers to maintain database operations, and facilitate ETL processes.

Utilized the Microsoft SQL Server 2000 client tools to create and populate database tables and to write SQL queries and stored procedures.

Retrieved healthcare member data based on ad hoc requirements, translated business rules to technical filters, ensured SQL queries work accurately and efficiently.

I am expert in Manual Testing in all phases of QA life cycle and back end database testing by writing and executing SQL Queries and extensive experience in testing of APIs using API tester a...

Experienced with: * Intermediate SQL queries and statements, * Excellent verbal and written communication skills Familiarity with developing automation scripts using scripting languages such as Java and (C# - Sharp) * Intermediate with Oracle * A good understanding of LINUX * Create and automate functional test cases using Selenium.

Have comprehensive skills of Designing (SSIS ETL Packages Complex T - SQL Queries, Partitioning and Indexing.

* Proficient in writing SQL queries in T - SQL and PL - SQL.

AREAS of EXPERTISE * * Project Management * PEGA Systems BRP * Best Practices Testing Manager * Waterfall and modified Agile methodologies * Software Development Life Cycle * SQL queries * Production Support * Requirements Gathering / Analysis * Development of Business & Functional Requirements * Development of Use Cases * Change Management * Quality Assurance Testing & Review.

PROFESSIONAL SUMMARY * Multi-faceted, efficient and dynamic professional with 3 + years of experience as Business Analyst and Quality Assurance Engineer using Manual, automation, functional / non-functional, Database Testing using custom SQL queries for internet based applications.

Created new EJBs, form beans, backing beans for the new tables being added for the HCPP3.0, also created DTOS, DAOs, and worked on complex SQL Queries.

Respond to all report requests utilizing SQL queries, SSRS, or Crystal Reports to provide accurate data to all departments within the agency.

Provided connections using JDBC to the database and developed SQL queries to manipulate the data and wrote Stored Procedures for interacting with the database

Assisted developers with writing and tuning SQL queries; performed on - call support and problem resolution 24/7.

Composed t - SQL queries and stored procedures to produce both ad - hoc and hard copy reports in Crystal Reports

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back - end testing and worked with data quality issues.

Developed SQL queries to extract data from table (s) to be used for analysis, testing and decision making.

Wrote SQL queries to verify modified data displayed in UI matched backend database

As a contractor for [company name], worked in the Risk Data Platform department testing financial risk databases using SQL queries in MS Access and Aqua Data Studio

Ensured that system input was accurately captures in DB2 database during testing of development and production by utilizing SQL queries.

Created a Unit Test Plan, developed the application using Web Dynpro Java, Entity Java Beans and SQL queries in SAP NetWeaver

Performed SQL queries for the purpose of gathering metrics as well as performance vs. cost data analysis

Designed, coded, tested, and aggregated results from SQL queries to provide information to clients

In scope of grey box testing verified application data stored within a database table using SQL queries

Updated test plans, created test cases and test scenarios for assigned functional areas (including Transact SQL queries for data validation).

Improved system response time by ~ 20 % by using SQL profiler to identify long running SQL queries and addressing them by either rewriting or adding indexes to the appropriate tables.

Used SQL profiler to analyze SQL queries.

Extensively dealt with SQL Queries, Stored procedures, Triggers to process large collection of data in Microsoft SQL Server environment.

Microsoft SQL server 2005 administration: writing SQL queries to extract information from order management database, updating, changing, inserted new data, modifying existing data in database, resolved data table inconsistencies in collaboration with the database administrator

Develop complex T - SQL queries for data - analysis and data extract utilizing knowledge of joins and understanding database landscape.

Responsible for creating oracle reports in the project and have dealt with complex SQL queries

Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic Sql, Merge statements.Built and monitored indexes to bring down processing times from minutes to seconds

Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales

Conducted extensive data analysis / verification by writing and executing complex SQL queries in Microsoft Access.

Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T - SQL stored procedures, user defined functions (UDFs) for data analysis

Developed inline view queries and complex SQL queries and improved the query performance for the same.

Experienced with SQL Queries, Stored Procedures and PL / SQL programs.

Designed and developed reports using SSRS and optimized SQL queries to improve run time performance of reports

Optimized speed of app by checking how many SQL queries each page of the app was making and finding ways to decrease

Optimized SQL queries with newer statements that utilize table indexes and adhere to SQL best practices.

Created SQL queries for table maintenance and database testing for detailed weekly or daily report generation.

Created complex SQL queries to troubleshoot, identify and correct issues with end - user data entry and external data imports

Power user of SQL queries with multi-table joins, group functions, subqueries, set operations and T - SQL.

Verified the integrity of data during testing utilizing query analyzer, executing SQL queries, Gray Box testing.

Involved with data mining activities in order to provide test data items for automation team by making SQL queries to extract account information using Oracle 10g.

Conducted Back End Testing and constructed SQL queries to extract and store data from various tables in Oracle database

Executed manual and automated test scripts (front - end and back - end - using SQL queries), conducted daily defect meetings with development, compiled test results and updated senior management on project status for weekly MIS reporting.

Requirements gathering and construction of SQL queries / Excel reports for ad hoc requests across multiple business units.

Should be well experienced in coding complex SQL Queries...

Created specialized SQL queries, view, functions, and procedures; utilized Crystal Reports to create custom reports - for reporting and advanced data analysis

Assigned the tasks of generating sql queries to execute DB2 platform in recovering test data and to test data integrity