Sql Server Project Manager
Resume:
ANU – ******@****.***
PGDCA CERTIFICATION
PROFILE SUMMARY:
• 3+ years of IT experience in Software Quality Assurance and Testing in Financial, Business ,Retail Services and Healthcare, SQL Server, Development. use of SSIS for developing, deploying packages, on server, from heterogeneous databases along with Migration (MSMA). Extensive experience in development and deployment of different types of customized reports using SSRS.
• Experience performing 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 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, Bug Documentation and Regression Testing.
• Well versed with complete Life Cycle Development process which includes Requirements Analysis, Documentation, Development, Testing, Implementation and Finance.
• Developed and executed manual tests at all test phases to verify application for production implementation.
• Worked with the project team to ensure quality throughout the product lifecycle, including reviewing specifications, developing schedules, and resolving issues.
• Demonstrated Expertise in Leadership, Project Management and Estimation.
• Experience working in Agile environment.
• 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 Oracle databases to conduct DB testing.
• Experience working with SOAP UI for web applications.
• Installation of SQL Server 2005, 2008 with Server Reporting Services (SSRS) & Integration Services (SSIS) .
• Expert in developing and deploying cascading parameterized, Drilldown with linking sub reports in various file formats with respect to client requirement.
• Very strong experience in development of test plan, test scripts using QC (Quality Center)
• Experience in QMF Database Query tool.
• Efficient in quickly understanding Data Mapping document and prepare test plan.
• Participating in test plan meetings and discussions.
• 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 able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies
•
TECHNICAL SKILLS
OPERATING SYSTEMS: Windows 7/Vista/XP/NT/2000, Windows Server 2003/2000
Testing Tools: Huntington Service Tester, Quality Center,QMF
RDBMS: MS SQL Server 2008, MS Access 2008, Teradata V2R6
BI &ETL TOOLS: SSIS (2008/2005), SSRS (2008/2005)
DATBASE: MS SQL Server 2008/2005/2000, MS Access 2003/2000
PROGRAMMING: C, C++, DS, Visual Studio 2010/2008/2005, .Net (VB, ADO), SQL*Plus, HTML, XML
Defect Tracking Tools:Huntington Service Tester, Quality Center.
OTHER TOOLS: Erwin 7.0, OLAP, OLTP, SQL Profiler, MSMA, SSAS (2005), (Microsoft Migration Assistant), JDE (Java Development Environment), BRM (Business Resource Management), Business Intelligence, Crystal Reports, MS-Office 2003/2007 Suite, MS-DOS, Adobe
-DOS, Adobe
EDUCATION& CERTIFICATIONS
• BACHELORS from GND University, India, 2002
• POST GRADUATE DIPLOMA IN COMPUTER APPLICATION, India, 2003
• Masters in Information Technology PT University, India ,2005
• Masters Of Computer Science(MS),US 2010
PROFESSIONAL EXPERIENCE
Huntington Bank(Columbus, Ohio)
QA Analyst ( Functional Testing,Database Testing, Service Testing, ETL Testing, SOA Testing,Negative Testing)
August2011- Till Date
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.
• 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 as well as using QMF (database query tool)..
• Log defects and in Quality Center and check daily status of the same till its closed or deferred.
• Schedule defect meetings with technical, QA team and managers.
• 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, SSIS(2008/2005), SSRS(2008/2005), SQL Server Management Studio(2008/2005), Business Intelligence, Microsoft Visual studio (2008/2005), Windows Vista/XP, MS-Office suite 2003/2007,Windows Server 2003,.NET(VB,C#).
SEARS (Hoffman Estates,IL)
QA/Developer (QC,T-SQL, SSIS, SSRS)
Feb2011 – July2011
Description: Sears Holdings Corporation is a product line company having departmental stores in all over the US. It is the nation's fourth largest broadline 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 DieHard, 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.
• Working on SRS document and implementing into functional level by making Data Models, both logical and physical using ERWIN.
• Developed SQL queries, functions, triggers, cursors, views and stored procedures.
• Primary focus was in the reengineering of the ETL processes using the SQL Server Integration Services (SSIS).
• Extracting data through T-SQL queries to create reports.
• Extensively worked on source data from Flat file source systems, SQL server source systems.
• Created table definitions and look-up reference data from Revenue Management
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Doing data transfer from various types of databases with conversion through SSIS.
• Documented 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, smoke and System Testing.
• 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.
• 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 business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports.
• Create and maintain SQL queries and stored procedures.
• Extensively tested several Business Objects reports for data quality, fonts, headers & cosmetic.
Environment: Quality Center 10, MS Excel, Windows NT, Java script, Asp, VB script and 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, MS-Office suite 2003/2007,Windows Server 2003,.NET(VB,C#).
INVISALIGN (San Jose, CA)
QA/Developer (QC,T-SQL, SSIS, SSRS)
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 were in the reengineering and extracting data from two different data sources using ETL process SQL Server Integration Services SSIS(2008).
• Gather report requirements and document technical specifications.
• Working on SRS document and implementing into functional level by making Data Models
• Participated and finished a training on LMS related to the business systems
• Create and maintain T-SQL queries and stored procedures, functions, triggers.
• Tuning package components like Script Task, Data Flow task, Data Conversion, Slowly Changing Dimension, Look Up, Derived Column, Multicast, Sort, and Conditional split, Script Component, Configuration file.
• Created 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 company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• 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
RELAINCE COMMUNICATIONS LIMITED (Mumbai, India)
Junior DATABASE DEVELOPER/Database QA
October 2006 – September 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 life cycle.
• 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 Packages, Functions, 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.
• Monitored the database growth on daily basis. Established backup and recovery strategies. Worked on Database tuning and performance monitoring.
• Extracting databases from different resources.
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