SUMMARY:

• 8+ years of experience as a Senior QA Analyst - ETL Testing with diverse experience in Functional, Regression, Integration, System Testing.
• Experience in understanding software project life cycle, updating/modifying requirement analysis, Functional/Design Specifications & Test plans designing.
• Responsible for testing of the ETL solutions developed using Sql Server Integration Services (SSIS), SSRS, and Sql/T-Sql.
• Works with the other IT and technology teams to refine technical specifications for test analysis and quality assurance. Worked with MS SQL Server 2008/2012/14. Able to work collaboratively with testers, developers and business in testing complex and large projects and maintain detail QA documentation.
• Expertise in Testing complex Business rules by creating mapping document and various transformations.
• Strong knowledge in Data Warehouse and Business Intelligence solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, and FACT & Dimensions tables, Physical & Logical Data Modeling.
• Created SQL Server Reports using SSRS 2008 and designed and implemented stylish report layouts
• Expertise in Defect management , Bug tracking , Bug Reports MS Visual Studio & TFS (Team Foundation Server).
• Experience testing SSAS cubes.
• Strong working experience in the Data Analysis , Data Verification and Validation of an ETL Application s using Backend/Database Testing.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Solid Back End Testing experience by writing and executing SQL Queries SQL Server and TSQL.
• Experienced in development of complex stored procedures, joins, views like database objects.
• Strong knowledge of office productivity tools like MS Word/PowerPoint/Excel/Outlook etc.
• Experience in testing of ETL solutionson AWS environment.
• Worked on Amazon Web Services (EC2, EMR, S3, RDS)
• A good team player with excellent technical, communication and interpersonal skills and capable of taking up responsibilities independently. Motivated and determined to deliver productive high quality, complete deliverables within deadlines with minimal supervision.

TECHNICAL SKILLS:

Languages: C#, VB.NET, SQL

Defect Tracking: Mingle, Team Foundation Server, JIRA

Methodologies: Waterfall, Agile, Scrum

IDE: Visual Studio.NET 2005/2008/2013

Operating System: Windows 2008/2012 Server, Windows XP/7,8

RDBMS: MS SQL Server 2008/2012/2014 Enterprise Edition, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, BIDS.

ETL/Tools: SSIS,Putty,WinSCP,Filezilla

Big Data: Amazon S3,Redshift, Cassandra, AWS EMR, Athena

PROFESSIONAL EXPERIENCE:

Confidential - Naperville, IL

ETL/DWH/Big Data Quality Analyst

• Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Used TFS (Team Foundation Server)& JIRA as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Defect Management.
• Review all requirements and specifications documentation for clarity, completeness and testability
• Involved in the sprint planning sessions, estimate testing tasks and attend daily scrum meetings as part of agile methodologies.
• Interpret complex business/data requirements and translate these into a comprehensive test plan.
• Validated Fact and TYPE 1 and TYPE 2 Slowly changing dimensions.
• Responsible for testing of the ETL solutions developed using Sql Server Integration Services (SSIS), SSRS, and SQL/T-SQL.
• Works with the other IT and technology teams to refine technical specifications for test analysis and quality assurance.
• Developed quality assurance plans, test scenarios, cases and methods; performed user interface, usability, stress, load, system and integration testing for high traffic streaming media content delivery.
• Validated data and Cube design for SSAS cubes.
• Performed System, Integration, Functional and regression testing to ensure that the new change in the system is working as expected.
• Implemented Test Data Strategy Plan for Data Acquisition process to create Historical, Current and Point in Time data to meet the Testing Requirements.
• Created Test Data Strategy Plan, Test scenarios and Test Cases for Business objects, SQL Data Extracts with critical, high and low priority.
• Test data extraction from SQL server to cloud Amazon S3 storage.
• Tested end-to-end Big Data applications on Amazon Web Services (AWS) from source systems using ETL.
• Validated data in AWS Athena using ORC files from Amazon S3 buckets.
• Written and executed complex SQL queries to validate data of the reports.
• Validation testing to validate usability, Functionality, Data correctness and security of various BO reports, SSRS Reports and Data Extracts.
• Created Aged data, Point-In-Time, Future data to validate Aging Reports, Data extracts.
• Validating the data transformations between source and target systems using SQL Server Integration Services (SSIS).
• Performed Data reconciliation to validate the data flow from source to Data Mart Facts and Dimensions.
• Documented work activities defects and issues, test cases, test plans, test results in JIRA management tool.

Environment: SQL Server 2008/2012/2014/2016 , AWS,Redshift, Aginity, AWS Athena, AmazonS3, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Business Intelligence, T-SQL, BIDS on Windows 2008/2012 Servers, Windows 7, Agile, Windows 8,.NET, Team Foundation Server, JIRA, XML, Visual Studio 2013,

Confidential, Wixom, MI

Programmer Analyst/Developer

• Review all requirements and specifications documentation for clarity, completeness and testability
• Involved in the sprint planning sessions, estimate testing tasks and attend daily scrum meetings as part of agile methodologies.
• Interpret complex business/data requirements and translate these into a comprehensive test plan.
• Responsible for testing of the ETL solutions developed using Sql Server Integration Services (SSIS) 2005/2008, SSRS, and Sql/T-Sql.
• Develop and maintain the manual and automated test scripts, functions/Sql code.
• Works with the other IT and technology teams to refine technical specifications for test analysis and quality assurance.
• Developed quality assurance plans, test scenarios, cases and methods; performed user interface, usability, stress, load, system and integration testing for high traffic streaming media content delivery
• Validating the data transformations between source and target systems using SQL Server Integration Services (SSIS)
• Developed and managed functional, integration, and unit testing schedule, work breakdown, and estimates (based on requirements) that support the overall project schedule
• Validated Business Reports subscriptions (SSRS) which are subscribed monthly and weekly.
• Provided QA Support (Baseline, Regression and Integration Testing) in Infrastructure Upgrades and Project Deployments.
• Involved in Data migration testing.
• Complete ownership and responsibility for the maintenance and improvement of existing product test suites and Monitoring day to day functions of the project.
• Quality assurance, issue identification, problem resolution, and to work under tight deadlines and pressure situations.
• Providing testing support for any change request that requires immediate deployment in production.

Environment: SQL Server 2008, SQL Server 2012, Agile, SSIS, SSRS, Windows 7, XML, .NET, Mingle, Tableau

Confidential, BatonRouge, LA

Programmer/ QA Analyst

• Responsible for creating various stored procedures involved in application development.
• Data migration from Microsoft Excel and Microsoft Access into SQL database
• Identifying and adding the report parameters
• Formatting reports using the Global variables and expressions
• Integrated various reports into the application, the reports were created using Microsoft SQL Server Reporting Services (SSRS) and generated in PDF Format and Excel Format
• Developed .NET components in C# and implemented the Data Access layer using ADO.NET to communicate with SQL Server 2005/2008
• Involved in Analysis, Design and Development of the application
• Developed the user interface in ASP.NET using C# as code behind language
• Used ADO.NET for data querying, storage, manipulation and to communicate with SQL Server 2005/2008
• Validated Business Reports subscriptions (SSRS) which are subscribed monthly and weekly
• Provided QA Support (Baseline, Regression and Integration Testing) in Infrastructure Upgrades and Project Deployments
• Involved in Data migration testing
• Used Custom Validations, Validation Controls and performed validations both on client side and server side
• Used Datasets for temporary storing and manipulation of data
• Implemented Security features for Web based tool using windows authentication
• Documentation of developed Components and module. Enhancements to the existing system to add additional functionality to meet user’s requirements
• Involved in system study, requirement gathering through extensive interaction with clients understand their needs
• Designed and developed components using C# & .NET Framework
• Used Web Forms and Server controls in ASP.NET for end-user UI
• Designed cascading style sheets to set style on ASP.NET pages

Environment: .NET frameworks 3.5, C#, ASP.Net, ADO.NET, C# Web Forms, SQL server 2005/2008 including replication, SQL Server Reporting Services, Visual Studio 2008, JavaScript, Excel, Access.

Confidential, Irving, TX

Programmer/QA Analyst

• Involved in Analysis, Design and Development of the application
• Developed the user interface in ASP.NET using C# as code behind language
• Used ADO.NET for data querying, storage, manipulation and to communicate with SQLServer 2005/2008
• Used Custom Validations, Validation Controls and performed validations both on client side and server side
• Used Datasets for temporary storing and manipulation of data
• Implemented Security features for Web based tool using windows authentication
• Responsible for the integration of software modules (version control and packaging releases).
• Documentation of developed Components and module. Enhancements to the existing system to add additional functionality to meet users’ requirements
• Involved in system study, requirement gathering through extensive interaction with clients understand their needs.
• Designed and developed components using C# & .NET Framework
• Used Web Forms and Server controls in ASP.NET for end-user UI
• Used AJAX controls for user friendly web-page application.
• Designed cascading style sheets to set style on ASP.NET pages
• Developed .NET components in C# and implemented the Data Access layer using ADO.NET to communicate with SQL Server 2005/2008
• Designed User-friendly Login Pages using Ajax controls
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Designed basic, drill through, drill down, parameterized reports
• Plan and create databases, database objects, Indexes
• Migrating databases onto different environment using backup/restore process
• Create users, allocating appropriate permissions and roles on the database objects

Environment: .NET frameworks 3.5, C#, ASP.Net, ADO.NET, C# Web Forms, SQL server 2005/2008 including replication, SQL Server Reporting Services, Visual Studio 2008, Ajax, IIS, JavaScript

Southern University and A&M College, Baton Rouge, LA

Web Developer

• Developed a Web Portal using C#.NET, ASP.NET Web Forms
• Developed ASP.NET pages using web form, server, validation, user controls
• Developed customized Web forms that extensively use data grids, data lists and all other .NET framework controls. Worked on validation controls for validating user input
• Developed data access components using C#.NET
• Developed Web Services using C#.NET modeled data objects
• Developed Implementation classes using C#.NET
• Used Crystal Reports and SSRS for generation of various reports

Environment: Visual Studio.NET 2008, ASP.NET, C#, Web Forms, JavaScript, SQL Server 2008, Crystal Reports, SSRS and Windows XP Server