Manager Sql Server

ANU KALYANI

SUMMARY:

• *+ Years of IT experience in Software Quality Assurance and Testing in Financial, Business Services,

• Insurance and Healthcare, SQL Server development, SSIS for developing, deploying packages, on Server from

heterogeneous databases along with Migration (MSMA).

• Experience performing Functionality Testing, Cross Functionality Testing Graphical User Interface (GUI)

• Testing, Integration, Negative testing, User Acceptance (UAT) Stress Testing, ETL Data Warehousing, database

testing and Regression testing on several applications as needed to find out and minimize defects.

• Hands on experience in preparing test data sets (Initial Loads, Incremental Loads, Constraining Tests and

analytical skills)

• Coordinate and Lead Roles in Creation and Execution of QA and Testing Processes, Test Strategies,

• Test Estimation, Test Plans, ETL Testing, Bug Documentation and Regression Testing.

• Well versed with complete Life Cycle Development process which includes Requirements Analysis,

• Documentation, Development, Testing, Implementation.

• Demonstrated Expertise in Leadership, Project Management and Estimation.

• Experience working in agile environment, Waterfall models and Snow flake schema.

• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.

Strong knowledge of RDBMS concepts. Developed SQL queries in databases to conduct

• DB testing.

• Very strong experience in development of test plan, test scripts using QC (Quality Center, MS Test

• Professionals, Service tester)

• Experience in QMF Database Query tool.

• Efficient in quickly understanding Data Mapping document and prepare test plan and test strategy.

• Participating in test plan meetings and discussions.

• Coordinating with business and technical development teams.

• Took part in creating technical specifications from Business requirement and Development team.

• Took part in Defect status meetings with Development and QA team.

• Took part in creating technical specifications from Business requirement.

• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in

debugging and strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

LANGUAGES: Visual Basic, Visual Studio 2010/2008/2005, .Net (VB, ADO), SQL, HTML, XML

TESTING TOOLS: Microsoft Test Manager, Huntington Service Tester (HST), Quality Center, QMF

DATASBASE/ RDBMS: MS SQL Server 2008/2008R2/2005, MS Access 2008, Teradata V2R6

BI/ETL/REPORTING TOOLS: SSIS (2008/2005), SSRS (2008/2005)

INTERNET TECHNOLOGIES: HTML, DHTML, XML, ASP

DEFECT TRACKING TOOLS: Huntington Service Tester (HST)

Version Control: SharePoint, Team Foundation Server

OPERATING SYSTEM: WINDOWS 2008/2007/XP, WINDOWS SERVER 2K3, LINUX, UNIX

EDUCATION:

• Masters - University of Bridgeport, US 2010

• Certification - PGDCA GND University2003

• BACHELORS - GND University 2002

EXPERIENCE:

Management Science Associates (Pittsburgh, PA)

QA Analyst (Database Testing, Web Service Testing, ETL Testing)

April 2012 - Till Date

Description: Management Science Associates, Inc. is a diversified information management company that for four

decades has given market leaders the competitive edge in data management, advanced analytics and technology. Our

research focus and innovative solutions not only transform industrial and institutional practices; they illuminate the range,

reach and potential of what we can do to infuse your organization with new energy. The project i worked on is a gamimg

project for casinos. It mainly concentrate on data analytics which involves, validity checks, retrieval and future predictions .

Casinos use this information for various purposes including inward and outward incomes and /or focusing necessaries

changes to their floor map areas.

Responsibilities:

• Gather requirement from the development manager, Business development manager and technical team lead.

• Go through the requirement of the projects and discuss scope, specifications and risk involved in testing.

• Working in Agile environment.

• Prepare Test Plan and explain the same to the authorities for approval.

• Create data mapping document.

• Discuss with the team for timelines.

• Discuss different technical involvements with the development team.

• Working on Silk Test and SOAP UI.

• Working with Test Manager for Front End, Performance, ETL, Stress, Regression and Backend Testing

• Involved in different technical and QA team meetings to review the step by step performance from QA Analysts.

• Work with testing for printing the web application pages.

• Report to the development manager for any show stopping scenarios regarding testing from the QA team.

• Prepare different queries for database testing manually using SQL Server Management Studio.

• Log defects and in Test Manager and check daily status of the same till it’s resolved, closed or deferred.

• Schedule defect meetings with technical, QA team and managers.

• Involved in UAT testing.

• Learn and suggest new testing strategies for better test approach.

• Explain the status and reasons for the defects and the risk involved before if it go to production

• Prepare QA summary of the achievements and difficulties faced in the same project.

Environment: T-SQL, SQL Server Management Studio(2008r2), Microsoft Visual studio (2010), Windows Vista/XP, MS-

Office suite 2010,.NET(VB,C#),Microsoft Test Manager, Source safe,Silk,ASP.net

HUNTINGTON BANK - Columbus, OH

QA Analyst

August 2011 – February 2012

Description: A regional bank committed to Midwest markets. They deliver easy access to competitive products,

innovative features, and tools to help you manage your money and your business-all backed by the best service in the

industry. It provide personal banking for individuals and families, small business banking, banking for middle market

businesses and nonprofit organizations, and specialty financial services through offices and more than 600 local

branches, more than 1,300 ATMs, and via online and mobile banking across six states: Ohio, Michigan, Indiana,

Pennsylvania, West Virginia, and Kentucky. There headquarter is in Columbus, Ohio, but each of our Huntington branches

and offices serves as headquarters for local customers' financial needs.

Responsibilities:

• Go through the requirement of the projects and discuss scope, specifications and risk involved in testing.

• Interacting with the end client and holding sessions with developers.

• Prepare Test Plan and explain the same to several technical and management authorities for approval.

• Go through the data mapping, discuss with the team for timelines.

• Discuss different technical involvements with the development team.

• Worked with WSEB and mainframe testing using Huntington own service testing tool.

• Worked with ETL testing using Quality Center.

• Involved in different technical and QA team meetings to review the step by step performance from

• QA Analysts.

• Prepare different queries for database testing manually in SQL as well as using QMF (database query tool).

• Log defects and in Quality Center and check daily status of the same till it is closed or deferred.

• Schedule defect meetings with technical, QA team and managers.

• Guiding QA team through the testing process

• Reviewing test scripts of team and audit if necessary

• Assign projects to the QA team while managing the multiple projects, according to priority

• Explain the status and reasons for the defects and the risk involved before if it go to production

• Prepare summary of the achievements and difficulties faced in the same project and explain to the lead to get it

approved.

Environment: Huntington Service Tester, Quality Center 10, MS Excel, Windows NT, Java script, Asp,

VB script and XML,SQL Server 2008/2005,T-SQL,SQL Server Management Studio(2008r2), Business Intelligence,

Microsoft Visual studio 2010, Windows Vista/XP, MS-Office suite 2010, NET(VB,C#).

SEARS - Hoffman Estates, IL

QA Analyst

February 2011 to July 2011

Description: Sears Holdings Corporation is a product line company having departmental stores in all over the US. It is

the nation's fourth largest broad line retailer with over 4,000 full-line and specialty retail stores in the United States and

Canada. Sears Holdings is the leading home appliance retailer as well as a leader in tools, lawn and garden, consumer

electronics and automotive repair and maintenance. Sears Holdings is the 2011 ENERGY STAR® Retail Partner of the

Year. Key proprietary brands include Kenmore, Craftsman and Die-hard, and a broad apparel offering, including such well-

known labels as Lands' End, Jaclyn Smith and Joe Boxer, as well as the Apostrophe and Covington brands. It also has

the Country Living collection, which is offered by Sears and Kmart. We are the nation's largest provider of home services,

with more than 11 million service calls made annually. Sears Holdings Corporation operates through its subsidiaries,

including Sears, Roebuck and Co. and Kmart Corporation.

Responsibilities:

• Gather report requirements and document technical specifications.

• Creating test plan and test strategies.

• Set various goals and target dates for the test cycle.

• Testing reports developed in SSRS.

• Testing database with SQL queries, stored procedures.

• Primary focus was in the testing reengineering of the ETL processes using the SQL Server Integration Services

(SSIS).

• Extracting data through T-SQL queries to create reports.

• Extensively worked on testing source data from Flat file source systems, SQL server source systems.

• Involved in testing, monitoring SSIS packages.

• Testing data transfer from various types of databases with conversion through SSIS.

• Evaluating and testing the validation rules, error handling and test strategy of the mapping.

• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e.

backward navigation from target to source.

• Performing Black Box, Regression, Functional, ETL and System Testing.

• Work closely with the technical and business team to update the requirements.

• Established and documented ETL QA standards, procedures and QA methodologies.

• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts.

• Experience working in Agile environment.

• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change

• Control in requirements leads to test case update.

• Conducted regression testing on the application under test.

• Involved in UAT testing.

• Create and execute load test plans.

• Developed regression test scripts for the application.

• Involved in metrics gathering, analysis and reporting to concerned team.

• Extensively tested several ETL Mappings.

• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.

• Conducted test case reviews to ensure scenarios accurately capture according to the business functionality.

• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test

scripts.

• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and

• Multi Reports.

• Reviewing the test cases of the QA team and managing multiple projects within team

• Create complex test cases and assign them to QA team for execution

• Extensively tested several Business Objects reports for data quality, fonts, headers & cosmetic.

• Prepare QA summary report.

Environment: Quality Center 10, MS Excel, Windows NT, Java script, Asp, VB script, XML, SQL Server 2008/2005,T-

SQL, SSIS(2008/2005), SSRS(2008/2005), SQL Server Management Studio(2008/2005), Business Intelligence, Microsoft

Visual studio (2008/2005), Windows Vista/XP, MSOffice, suite 2003/2007,Windows Server 2003,.NET(VB,C#).

INVISALIGN (San Jose, CA)

QA Analyst

Sep 2010 - Jan 2011

Description: Invisalign, with its business worldwide, is a tooth aligner company located in San Jose,

CA. This project mainly focus on the migration of the data from different database sources, in different environments,

through ETL(SSIS) process, testing, integrating and deploying into the existing server database followed by different types

of report retrieval of the data using SQL,SSRS, SSAS.

Responsibilities:

• Primary focuses on gathering the requirement from various resources and business clients.

• Held various meeting to review the functional and system requirements until its approved from the business and

Development team.

• Gather report requirements and document technical specifications needed from development team.

• Working on SRS document and implementing into functional level by creating Data mapping.

• Participated and finished a training on LMS related to the business systems.

• Create and maintain T-SQL queries and stored procedures.

• Testing dynamic configuration packages and deployed successfully.

• Developing, testing and deploying SSIS packages, dynamic configuration packages.

• Created backup and tested the packages with user level testing cases for SSIS packages.

• Retrieval of the data from T-SQL queries, stored procedure to create parameterized reports using SSRS.

• Develop test plans based on test strategy for Data Warehousing Application.

• Performing Black Box, Regression, Functional, smoke and System Testing.

• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

• Written complex SQL queries for querying data against different data bases for data verification process.

• Preparation of technical specifications and Source to Target mappings.

• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement

business rules and security.

• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the

business requirements.

• Design and execute the test cases on the application as per client standards.

• Preventing occurrences of multiple runs by flagging processed dates.

• Written Test Cases for ETL to compare Source and Target database systems.

• Interacting with senior peers or subject matter experts to learn more about the data.

• Identifying duplicate records in the staging area before data gets processed.

• Conducted data validation testing.

• Assisted in System Test and UAT testing scenarios as required.

• Actively involved in the requirements gathering sessions.

• Testing the source and target databases for conformance to specifications.

• Conditional testing of constraints based on the business rules.

• Developed automated test scripts from manual test cases for Regression testing based on the requirement

documents using Quick Test Professional.

• Test cases on different kinds of reports & retrieval of the data from T-SQL queries

• Co-ordinate and support the team on technical support and documentation

Environment: Quality Center 10, MS Excel, Windows NT, Java script, Asp, VB script and XML,SQL Server (2008/2005),

SSIS (2008/2005), SSRS (2008/2005) SSAS (2005), Server Management Studio (2008/2005), Business Intelligence,

Microsoft Visual studio (2010/2008/2005), Windows Vista, Windows XP, MS-Office 2007, JDE (Java Development

Environment), Oracle, BRM (Billing and Revenue Management), Adobe

Database QA/Jr. Database Developer

RELAINCE COMMUNICATIONS LIMITED - Mumbai, Maharashtra

Oct 2004 to Sep 2007

Description: Reliance Communications International Inc. is an affiliate company of Reliance Info communications Ltd,

Mumbai, India. Reliance Info communications Ltd. is India's largest private information and communication services

provider. It has international points of presence in New York, Los Angeles, London and Hong Kong seamlessly integrated

with domestic gateways located at Mumbai, Delhi, Chennai, Kolkata and Ernakulum. The Project goal was to gather

requirements from Business users and designed, developed and maintained the tool for making decisions depending on

different scenarios, Giving weekly reports and integration of data from different sources.

Responsibilities:

• Participated in the full software development life cycle (SDLC).

• Participation in weekly design reviews and walkthroughs with project manager and development team.

• Worked on database design with the team.

• Measured the performance of the shell scripts by getting the expected results.

• Involved in writing T-SQL code using the technical and functional specifications.

• Generated SQL install create and drop database objects including: tables, views, primary keys, indexes,

constraints, packages, sequences, grants and synonyms.

• Involved in writing T-SQL queries, Stored Procedures and Data Base Triggers.

• Documented business rules, functional and technical designs, test cases, and user guides.

• Involved in the debugging and error handling & extracting data from different resources.

• Monitored the database growth on daily basis and create test scenarios to test bad incoming data.

• Tested database for incoming and outgoing data.

• Participated in creating test plan.

• Involved in front end and regression testing.

Environment: Center 10, MS Excel, Windows NT, Java script, Asp, VB script and XML, MS SQL2000,

C, UNIX, T-SQL, DTS, Windows XP, Windows Server 2000, MS-Office 2003 Suite.

Contact this candidate