SQL developer /BI developer Resume Bellevue, WA - Hire IT People

SUMMARY:

Extensive experience of T - SQL query languages, creating databases, tables, functions, stored procedures, constraints and indexes.
Created and maintained SQL server database to keep records of legal counseling clients, such as labor migrants
Experience in working with the databases such as SQL Server and wrote SQL queries for Backend Testing
Managed schema objects like Triggers, cursors, indexes and procedures.
Fixing Missing Indexes and Excess indexes
Extensive knowledge of SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) methodologies.
Diverse experience in Software testing and experience in preparing Test plan, Test Case Willing to relocate: Anywhere

PROFESSIONAL EXPERIENCE:

SQL developer /BI developer

Confidential - Bellevue, WA

Implemented database optimization, including indexing and SQL query performance tuning.
Created and managed SSIS Packages to extract data from various sources.
Worked on a Data Warehouse development project.
Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
Performed disaster recovery planning and testing in off-site location.
Experience in implementing efficient Disaster Recovery Strategies and high availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and database Mirroring.
Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
Management of database backup, recovery processes and procedures.

Database Developer

Confidential

Created SQL Server Agent jobs and job schedules.
Created simple and complex SQL queries, views, functions and stored procedures
Wrote SQL queries against migration and trafficking databases, manipulated data for project monitoring and reporting purposes.
Worked with a team that was assisting partner Government offices in developing an effective database management system (database design, data entry and analysis).
Created numerous simple to complex queries involving joins, correlated sub queries, views, stored procedures and functions for diverse business requirements.
Supported defect review meetings with documents and weekly management meetings with presentations

QA Engineer

Confidential

Actively involved in creation of detailed test plans, test cases and traceability matrix for different application modules according to functional requirements and business specifications.
Created test strategic document.
Designed and developed test plan and test cases for UAT (User Acceptance Test) Testing.
Designed and executed Build Verification Test and Functional Test cases.
Performed GUI Test, Regression testing, System Integration testing.
Execute tests, track and report bugs using Microsoft Test Manager.
Performed database testing by developing and executing SQL queries.
Responsible for conduction smoke, functional, UI, integration, regression, and ad-hoc testing.