SUMMARY:

• Over ten years of professional IT experience in developing and testing of Client/Server, Web based Applications, ETL Informatica applications and SQL Server applications like SSMS, SQL Server Integration Services (SSIS), Reporting and Analysis services (SSRS and SSAS).
• Worked on experience on Cloud services: Cloud servers and databases, Cloudberry explorer for Azure blob storage.
• Experience on Cloud computing using cloud based technology tools like SQL Azure DB and Cloudberry lab.
• ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing
• Extensive exposure to Business Intelligence projects with experience in building Enterprise Data Warehouse, Data Marts and Operational Data Stores
• Extensively tested BI reports and Cube infrastructure changes using Business Objects, SSRS and SSAS.
• Strong working experience in the Development, Implementation and Testing of Data Warehousing using Data migration, Data Extraction, Data Transformation and Data Loading (ETL) tools, Informatica, SSIS, Ab Initio and DataStage .
• Proficiency in writing SQL queries with complex joins and PL/SQL procedures
• Hands on experience on front end as well, on UI and Website.
• Extensive experience in Agile/Scrum Environment.
• Experience in Change Management Process for BI Change requests.
• Tested consolidated data from various departments into the data warehouse by identifying the Common data and solve the discrepancy on data values.
• Experience in working with Rest and Soap services testing using SOAP UI
• Experience with automation tools like SQL Query surge and QTP.
• Expertise in Ralph Kimball & Bill Inmon’s Methodologies
• Good business knowledge in Pharmaceuticals, Healthcare, Banking, Insurance & Finance and Retail business lines.
• Review system use cases and functional specifications with the appropriate Business Analyst and documented test strategy and test plan.
• Good experience in writing and executing regression test suites and participating in integration testing with different teams.
• Extensive exposure to testing during all phases of the Software Development Life Cycle (SDLC) and Defect Life Cycle (DLC)

TECHNICAL SKILLS:

ETL Tools: SSIS 2010, 2007, 2005 Microsoft visual Studio, Business intelligence Development studio (BIDS), Informatica 8.6.1, 7.1.1, 6.5, Data Stage, Ab Initio

Reporting Tools: SSRS, BIDS, Business Objects XI, 6.x, Cognos 7.0, Crystal Reports 4.6/6.0.

Databases: SQL Azure DB, SQL Server 2012,2010,2008,2005, Teradata, Oracle9i, Oracle 8i

Database Tools: SQL Azure, Microsoft SQL Server, Microsoft SQL Server 2008R2, Toad

Testing Tools: Quality Center 9.2, Test Director, JIRA, TFS

Languages: SQL, PL/SQL, C, C++

Operating Systems: Windows9x/NT/2000/XP/Vista, UNIX, LINUX

Defect Management Tool: JIRA, Microsoft Team Foundation Server (TFS), Mingle, Quality CenterBugZilla and scarab

Browsers: Internet Explorer9.0, 8.0, 7.0, 6.0, Fire Fox, Chrome, Netscape Navigator

Software Tools: Soap UI 3.0, Soap UI 4.0,MS - Project 2000, MS Visio, MS Office Suite, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior QA Engineer

Responsibilities:

• Completely responsible for QA Testing activities for several ETL / Web/SAP/PeopleSoft/SOA/Mobile projects.
• Analyze the Business Requirement Document (BRD), Functional Specification Documents to prepare test plans, test strategies and high level test scenarios.
• Monitored staff training initiatives and development to ensure quality support is maintained.
• Recommend and provide support to establish quality standards to be universally applied in program/project level throughout.
• Managed testing activities for Automation and Functional
• Formulated High level Automation and Functional test strategies
• Created effort estimation, monitor team and coordinate closely and lead testing team and guide in defect tracking.
• Assists management with internal problem/issue resolution insuring department efficiencies and service quality are consistently maintained.
• Reviews status of quality assurance initiatives and collaborates with other IT managers to ensure quality objectives are being attained.
• Responsible for end to end functionality of all the functional systems.
• Defined testing boundaries and provided specialized testing services.
• Standardized processes for optimizing accuracy in resource utilization
• Created Roadmap for Organizational design ROI and best testing practices
• Closely monitor the critical deliveries of the code from development team and delivery of QA team until successful implementation/deployment to product
• Chair scrum/defect review meetings with project team stakeholders to discuss issue found during testing and their current statuses.
• Formulated Functional / Automated Test strategies for various projects
• Implemented SOAP tool for testing web services
• Managed functional and NFT aspects testing
• Supported team executing test cases during tight testing schedules to meet project timelines like working overnight and weekend.

Environment: Teradata SQL Assistant, Oracle PL/SQL Developer, Ab initio, HP ALM 12.50, JIRA, Mainframes

Confidential, Chicago, IL

ETL Testing Team Lead

Responsibilities:

• Coordinated test schedules for several releases and responsible for all QA and UAT testing activities for ETL Data Validation, Report and Cube testing.
• Lead QA team, including mentoring, managing workload priorities, measuring staff performance and promoting professional development.
• Maintained the Test Developed, collected and analyzed quality metrics about products and projects. Ensured that teams followed processes through SDLC and provided reports to managers. Provided input for the process improvements and recommendations to proposed solutions.
• Conducted daily meetings with QA team to track QA task progress, mitigated risks, took corrective actions, resolved issues with parties involved and escalated as needed. Provided the project status report to management on regular basis.
• Extensively written PL/SQL stored procedures to capture the data difference between source and target during data centric testing.
• Involved in extensive DATA validation using SQL queries
• Worked on SQL Server Integration Services (SSIS) to test the integration and analyze data from multiple homogeneous and heterogeneous information sources(CSV, Excel, SQL 2005, SQL 2008)
• Performed regular backups and restores of databases to refresh seed test data in other environments.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing
• Extensively worked on SQL queries performance tuning for existing stored procedures in seed/full data loads.
• Monitors test metrics, trending & root cause analysis. Manage distribution & review/ analysis of Test Metrics
• Developed and implemented Test Plans adjusting test strategy to the requirements of the particular product release. Maintained Traceability matrix and manual tests in Test Director/QC. Interacted with BA for gathering requirements.
• Worked with systems engineering team to deploy test new Hadoop environments and expand existing Hadoop clusters
• Created Hive queries which helped analysts spot emerging trends by comparing fresh data with historical claim metrics.
• Involved in creating Hive tables, loading and analyzing data using Hive queries
• Load and transform large sets of structured, semi structured and unstructured data
• Created reports for BI team using Sqoop to export data into HDFS and Hive
• Worked on SSRS for various reports including, drilldown, drill through, graphical reports and metadata reports

Environment: SQL Server 2008R2, SSIS, SSRS, Windows 7, UNIX, Putty, WinSCP, Hadoop, Sqoop, Flume-ng, HiveQL, JIRA, HP ALM

Confidential, Chicago, IL

QA Team Lead

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and frame the High Level Test Scenarios.
• Closely monitor the critical deliveries of the code from development team and delivery of QA team until successful implementation/deployment to product
• Coordinates test schedules for several releases and manages all QA and UAT testing activities for KioskUI, KioskServices, ETL applications
• Managed distributed team of 10 resources
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Written complex SQL queries to test the logical function of Look up, Pivot, Merge Join, Union all, OLEDB Command, Derived Column, Conditional Split, and Aggregate transformations to get the manipulate data in SSIS package data flow.
• Created SQL jobs load in QA Environment using SQL Agent.
• Tested logic for SCD (Slowly Changing Dimension Type 1 and Type2) for required Dimensions and performance of SSIS package.
• Involved in Implementation of the QA process and documentation of ETL Test Plans, ETL Test Cases, Test Procedures and Test Scripts for manual and automated testing scope in the QA life cycle
• Attend Scrum/Agile meetings and provide QA processes for all sprints
• Strong management and leadership for direct reports with capacity to mentor and coach QA teams.
• Found the Defects when running the test cases and assign to BI Developers using Defect Tracking tool, ‘Mingle’.
• Provided updates to Project Manager and other team members on testing activities. Attended weekly status meetings.
• Provided status on Change Requests accordingly.

Environment: SSRS, Microsoft visual Studio, Business intelligence Development studio (BIDS),SQL 2012, PL/SQL, Report Manager, OLTP and OLAP data sources, Microsoft Excel.

Confidential, Chicago, IL

Test Lead/Architect

Responsibilities:

• Mentor the team on different modules and processes on different release for KioskUI, Data, Azure and Website. Analyzed business requirements and functional specifications and helped the team understand the overall scope of project.
• Developed Test strategy, Test Plan and approach for testing.
• Tested many applications developed during the run of the project like KioskUI, SQL Azure and Cloud applications
• Lead the team of 7 members on all applications involved
• Validated XML files and SOAP messages
• Validated back-end databases and front end-GUI screens as per requirements.
• Enhance QA assessment framework, and conduct reviews with various projects and teams for effectiveness of and adherence to quality processes.
• Peer Review of Technical Specifications, Program Specs, Unit Test Plans and other project related documents.
• Performed end to end testing

Environment: SQL Azure DB, Vault source control, Windows Azure, SSRS, SSIS, Microsoft visual Studio, Business intelligence Development studio (BIDS),SQL 2012,SQL 2010, PL/SQL, Report Manager.

Confidential, Chicago, IL

Senior ETL /QA Tester

Responsibilities:

• Reviewed mapping documents, technical and functional requirements for understanding the project
• Extensively worked on SQL Azure DB and cloud servers for writing sql queries and testing.
• Successively used Vault source control for deploying the DB scripts on cloud servers
• Ran the Sync jobs on windows azure to sync the data between Cloud and on premises servers and validated the data.
• Tested the SSAS cubes by writing SQL queries comparing the result with the cube values. Done slicing and dicing of the cube and tested the results.
• Tested the ETL process for both before data validation and after data validation process
• Used Excel and Tableau 7.0 for browse through SSAS cubes
• Used Cloud berry explorer for Azure blob storage to get connected to the front end apps and verify the logs for the services that the SSIS package is calling. This was required to correctly validate the data on the backend referring front end.
• Developed test plans and test cases for EPC based on business and technical requirement documents
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested stored procedures in MS SQL Server 2012
• Validated the complete source to target mapping along with transformation rules and verified if they are meeting requirements as well.
• Validated data through various stages of data movement from source(xml feed) to parsing of xml feed to flattening of data to unpivoting of data and calling web service and populating data in database
• Tested SSIS packages in BIDS and ran SQL jobs (scheduled and on demand).
• Tested Reports on ETL SSRS
• Reported bugs through email notifications to developers using Microsoft TFS tool.
• Attended sprint review, planning and Backlog grooming sessions and daily stand ups.

Environment: SQL Azure DB, Teradata, Vault source control system, Windows Azure, SSRS, SSIS Microsoft visual Studio, Business intelligence Development studio (BIDS),SQL 2012, PL/SQL, Report Manager.

Confidential, Chicago, IL

Senior ETL Analyst

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and frame the High Level Test Scenarios.
• Worked on SQL Server Integration Services (SSIS) to test the integration and analyze data from multiple homogeneous and heterogeneous information sources(CSV, Excel, SQL 2005, SQL 2008)
• Tested logics used in the transformations like For-Each Loop Container, Expressions, Execute SQL task, Variables by writing SQL queries.
• Written complex Sql queries to test the logical function of Look up, Pivot, Merge Join, Union all, OLEDB Command, Derived Column, Conditional Split, and Aggregate transformations to get the manipulate data in SSIS package data flow.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Created SQL jobs load in QA Environment using SQL Agent.
• Tested logic for SCD (Slowly Changing Dimension Type 1 and Type2) for required Dimensions and performance of SSIS package.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created Test cases based on the Test scenarios and Involved in the review of test cases.
• Performed sanity testing, functional testing, integration testing, regression testing, system testing and Data base testing through different iterations.
• Tested both Rest and SOAP services using SOAP UI
• Created projects, Test Suites and ran the test cases using SOAP UI
• Efficiently used Mingle as the defect tracking tool.
• Performed Manual Back End testing, validating the records in the data base by writing various SQL queries.
• Extensively worked in the Agile environment participating in the sprint planning meetings, scrums and retrospective meetings

Environment: SSIS, SQL Server 2008, Soap UI, Subversion, Mingle, MS office Tools

Confidential, Cincinnati, OH

Senior ETL QA Analyst

Responsibilities:

• Involved in Requirement Analysis and deriving the High Level Test Scenarios
• Created Test Plans, Test strategies and Test cases based on the Test scenarios
• Executed queries in Teradata for verification and validations of back end data
• Used Ab initio transform components to move the data between the servers and tested (ETL Testing) them
• Performed sanity testing, functional testing, integration testing, regression testing, system testing and Data base testing through different iterations
• Worked with ETL group for understating for data loading for both dimensions and facts
• Efficiently used Team Foundation Server (TFS) for the effective project management
• Efficiently used JIRA as the defect tracking tool
• Executed Test Cases as per test schedule, reporting test execution results and providing data for RTM( Requirement Traceability Matrix)
• Involved in creating the design and technical specifications for the ETL process of the project.
• Extensively worked in the Agile environment participating in the sprint planning meetings, scrums and retrospective meetings

Environment: ASP.NET, Win Forms, Visual Studio.NET 2005, JavaScript, Ajax Toolkit Controls, HTML, Teradata, Visual Source Safe, Ab initio, Agile Environment, IIS 6.0, Windows NT/XP, Team Foundation Server (TFS), Jira, MS office Tools

Confidential, New York City, NY

Software Developer

Responsibilities:

• Defined the Source databases and Target databases in Informatica..
• Involved in adding Sources and Target databases to Mapping Designer of Informatica.
• Created the Mappings in Informatica.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, lookup, update strategy, Sequence Generator Transformations, Stored Procedure Transformations, Aggregate transformations and Expression Transformations in Informatica.
• Involved in creating, editing, deleting and scheduling of the Sessions in Informatica.
• Involved in preparing the specification documents for individual mapping customization.
• Creating mappings to extract data from source files, transform the data using filters, expressions and stored procedures and then load to Oracle data warehouse.
• Involved in preparing the specification documents for individual mapping customization.
• Performed Unit testing and system testing and code review

Environment: Informatica 8.1.1, Oracle 9i, Toad

Confidential

Informatica Developer

Responsibilities:

• Involved in preparing the specification documents for individual mapping customization.
• Creating mappings to extract data from source files, transform the data using filters, expressions and stored procedures and then load to Oracle data warehouse.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, lookup, update strategy, Sequence Generator Transformations, Stored Procedure Transformations, Aggregate transformations and Expression Transformations in Informatica.
• Involved in creating, editing, deleting and scheduling of the Sessions in Informatica.
• Unit testing and system testing and code review.

Environment: Informatica 7.1.1, Oracle 9i, Toad.