Sql Server Database Developer

MACHA SWATHY

Phone: 409-***-****

*********@*****.***

Linkedin – www.linkedin.com/in/swathy-macha

Doesn’t require sponsorship and can work for any employer

PROFESSIONAL SUMMARY

• 5 years of experience in IT industry including 1 year of field experience on QA and testing of web based and client-server applications.

• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2012/2008R2/2008.

• Experience in Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.

• Experience in Extraction and Migration of Data from data sources like Excel, MS Access to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.

• Knowledge in scheduling Backups and Restore, Log Shipping and Maintenance plans using SSMS Tool.

• Knowledge on different recovery models and when to choose.

• Knowledge in writing stored Procedures, Triggers, Cursors, and Views.

• Proficient in using Test Management Tool Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Reporting.

• Good understanding of RDBMS and Normalization /De-normalization.

• Good experience in SQL Server Business Intelligence Tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

• Good knowledge on control flow and data flow tasks in SSIS.

• Experience in installation of SSRS. Hands on experience in generating different types of Reports using SQL Server Reporting Services (SSRS). Proven ability in generating Drill Down and Drill Through reports with drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.

• Developed and exported test cases to Quality Center and mapped all test cases to the business requirements.

• Good interpersonal and communication skills.

• Ability to self-manage and lead projects to completion with minimal supervision.

EDUCATION

• Master of Science(MS) in Electrical Engineering, Lamar University, Beaumont, TX

• Bachelor of Science (BS) in Electrical Engineering, JNTU, Hyderabad, India

TECHNICAL EXPERIENCE

RDBMS: SQL Server 2012/2008R2/2008, Microsoft Excel 2000/2007

Database Tools: SQL Management Studio, SQL Server Business Intelligence Development Studio, SQL Query Analyzer

ETL Tools: SQL Server Integration Services, Import Export Data, DTS, BCP

Data Modeling: Star Schema Modeling, Dimensions Tables and Logical Data Modeling

Languages: SQL, T-SQL, PL/SQL

Operating Systems: Windows, Linux

Testing Tools: Quality Centre/Test Director, Win Runner, Load Runner, Quick Test Pro

PROFESSIONAL EXPERIENCE

Client: NEC Corporation of America (Jan 2015-Dec 2015)

Role: Software Quality Assurance Analyst Rancho Cordova, CA

NEC is a leading provider of innovative IT, biometrics, network, and communications products and solutions for service carriers and Fortune 1000 and SMB businesses across multiple vertical industries. Also includes healthcare, which delivers one of the industry's broadest portfolios of technology solutions and professional services, including unified communications, wireless, voice and data, managed services, server and storage infrastructure and optical network systems.

Responsibilities:

• Involved in Business and Functional Requirement Document (BRD) review meetings conducted by BA team to better understand the application functionality and to gather functional requirement Document (FRD) to create the Test Plan and Test Scenarios.

• Involved in the Test Case walkthroughs to BA and assessment meetings.

• Documented Technical Specs and developed test plans and test scripts for manual testing.

• Proficient in working with testing tools and carrying out Functionality testing, GUI Testing, System Testing, Integration Testing and Regression Testing, Negative Testing, End to End Testing, Adhoc testing and UAT testing.

• Developed various test cases for Unit testing the Data before releasing to Testing environment.

• Coordinate with QA team in reviewing their test cases and end-to-end testing.

• Involved in defect reporting and assigning the defects to development team through Quality Center.

• Involved in backend database testing using SQL.

• Coordinated the team by having weekly QA status meetings and by addressing the outstanding issues immediately.

• Successfully completed the projects by attending the required project meetings, release meetings, and by meeting the dates on time.

• Discussed with Project Team, Subject Matter Experts and Business Analysts and resolved the issues as per the mutual consensus and to the satisfaction of the end users.

Client: Experian Inc. (Dec 2012-Aug 2014)

Role: Database Engineer Denver, CO

Experian is the leading global information services company, providing data and analytical tools to clients in more than 65 countries. The company helps businesses to manage credit risk, prevent fraud, target marketing offers and automate decision-making. Experian also helps individuals to check their credit report and credit score and protect against identity theft.

Responsibilities:

• Migrate SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

• Perform Data Analysis, T-SQL Development and data validation per requirement specifications using SQL Server Management Studio.

• Investigate and resolved issues in database code.

• Experience in Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

• Supporting Customer Service department requests by writing queries to document current issues and resolve outstanding tickets.

• Coordinated with end user to Obtain signoff and approvals on results before deploying the code to production.

• Work on Subject Matter Experts (SME’s) in understanding, documenting their requirements.

• Conduct Post Deployment analysis for the new code changes.

• Design, develop and perform quality review of data as per the project requirements.

Client: Sudler & Hennessey - Avenue-E (Mar 2012-Sep 2012)

Role: Microsoft SQL Server Developer New York, NY

Sudler & Hennessey is one of the leading Healthcare Communication firms developing strategic promotional and educational programmes for a broad array of healthcare brands. Sudler & Hennessey works with clients, strategically and programmatically, to accelerate, expand and extend the product life cycles of ethical drugs.

Responsibilities:

• Involved in enhancing the performance of database servers by Query optimization using SQL Profiler and performance monitors.

• Hands on Experience in Database Backup, Recovery and Disaster Recovery procedures.

• Create Replication models like Snapshot and Transactional.

• Created and scheduled various SQL Jobs using SQL Server Agent to perform various Administrative skills.

• Installed and maintained MS SQL Server 2008.

• Migrated databases from SQL Server 2005 to SQL Server 2008.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

• Developed SQL queries to fetch complex data from different tables in remote databases using joins and formatted the results into reports.

• Generated complex stored procedures and functions for better performance and flexibility.

• Created indexes for the quick retrieval of the data from the database.

Client: Microsoft Licensing (MSLI) (Mar 2011-Nov 2011)

Role: Entry level database developer Reno, NV

Microsoft Licensing, GP (MSLI), headquartered in Reno, Nev. since 1997, enables organizations, large and small, to acquire, distribute and utilize Microsoft’s vast array of products, including software,

Hardware and services. MSLI employs approximately 500 professionals across 22 states and supports Microsoft’s operations for OEM, Volume Licensing, XBOX and Dynamics throughout North & South America.

Responsibilities:

• Created new tables, views, indexes and user defined functions.

• Optimized queries to improve performance by creating indexes.

• Wrote T-SQL statements to retrieve data.

• Used SQL Analyzer and Profiler for analyzing the SQL statements and procedures.

• Performed daily database backup & restoration and monitored the performance of Database Server.

• Created joins and sub-queries for complex queries involving multiple tables.

• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

HONOURS AND AWARDS

• Received Graduate Student Scholarship from Lamar University, Beaumont, Texas

• Executive Board member, International Advisory Council at Lamar University

• Received DISC (Directive Innovative Serving & Calculating) training for effective teamwork and decision-making

• Student Government Representative, Voice International Organization, Lamar University.

• Volunteer: ROTARACT, St. Mathew’s Episcopal Student Center, Beaumont, Texas.

• Volunteer: Developed and organized fund raising projects for Voice International Organization.

Contact this candidate