SUMMARY:

Experienced in Data Analysis, profiling ETL testing, Software Quality Assurance (SQA), middleware and Web - based applications in domains viz; Telecom, Healthcare, Government, Financial and Retail industries applications on Windows/Unix based Platforms.

• Implementation skills in complete Software Development Life Cycle (SDLC) using Agile methodology.
• Experienced in manual testing with the focus on Functional Testing, Regression Testing, Smoke Testing, Load Testing and System Testing.
• Experience in working with Business analysts, developers, and testers for complex projects during the full Software Development Life Cycle (SDLC).
• Expertise in finding analogies/anomalies from the data using SQL’s for Analysis.
• Work with ETL Developers to build or enhance data loads & extracts.
• Assist with documenting requirements for improved automation as needed.
• Communicate data enhancement needs with management, ETL developers and report developers.
• Expertise in creating Test Plans and executing Test Cases/Test Scripts.
• Experience in performing back-end testing using T-SQL, PL/SQL and SQL Queries.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Languages: Java, C++, C, PL /SQL, VB.net, C#, VB Script, javascript, Unix Shell scripting

Database: Oracle 10g, SQL server 2005/2008 R2.

Internet Tools: HTML, XML.

Automated Test Tools: Selenium, Quick Test Pro 9.2

Test management Tool: Test Director, IBM Rational Confidential, HP-ALM, Confidential, JIRA, MS Sharepoint.

BI Tools: SSIS 2010, SSRS, Informatica 9.6.2, Omniture

PROFESSIONAL EXPERIENCE:

Confidential, St.Louis Park, MN

Sr. ETL QA Analyst

Responsibilities:

• Working with the ETL teams on various projects testing for MoneyGram data related to Customers Profile, online money transfer, Bill payment services and pre-paid services data and Money orders.
• Working with Oracle EBS team to validate on Oracle cash mgt. project viz; loading data using Informatica workflow and validate using SQL validation.
• Dimension and Fact tables Initial and incremental validations using Common Table expression and analytical function SQL’s.
• Working with cross functional team to test end to end scenario Point of entry applications viz AgentConnect till data loaded to EDW.
• Working on Customer loyalty reward program with Brierley to analyze customer behavior and pattern.
• Working on validating various datamarts via Informatica Intelligent Master data management(MDM). Main objective is to create a large Quality Datawarehouse.
• Cognos Report validation for various business solutions.
• Working on project to ensure POS (Point of Sale) is Dodd-Frank Act compliance.
• Preparation of Project estimates, test strategy document, leading team of ETL testers in onshore / offshore model.

Environment: Informatica 9.6.2, Oracle 11g / 12c upgrade, SQL Server 2012, MS Visio, HP-ALM 11.52, JIRA, Oracle E-business solutions, Cognos, Waterfall/Agile Methodology

Confidential, Minneapolis, MN

Sr. ETL QA Analyst

Responsibilities:

• Working with the BI and ETL teams closely to progress the testing toward realistic achievable milestones for each sprint.
• Mentoring/leading a team of 4 ETL QA resources for technical issues, project bucket or hours related problems, meetings with Project Managers, Supervisors to discuss and resolve task or deadline related issues.
• Prepare required matrices to help understand project managers task vs defects raised and impact analysis on upcoming tasks.
• As part of project artifact deliverable prepare Test strategy document.
• Working on multiple tasks to validate data in Common landing zone and integrated data mart from various subsystems to build a Healthcare integration DataMart.
• Working on various Domains to build the Healthcare DataMart viz; Provider, Subscribers, Claims, and PHI (Protected Health Information).
• Working on complex data upstream/ downstream to provide monthly data to government as per regulations.
• Interpret complex business/data requirements and translate into a comprehensive scenario or “test data” (using SQL, PL/SQL and/or data generation tools).
• Functional testing on HealthEdge system (Frontend) validate Enrollment, Membership, claims, PHI(Protected healthcare information) data.
• Working on various legacy systems data related to incremental and historical data fixes of Providers, subscribers and claims data.
• Working on Enterprise Data warehouse for validating the Fact and Dimension tables (Slowly changing dimension type 1 and 2) for data related issues.
• Experience in profiling large data sets to understand and determine to create metadata accurately.
• In absence of required data, creating test data set to meet the requirement.
• Analyzing and finding the data anomalies for data quality and creating appropriate defects in required tool.
• Worked on Government compliance project like ICD 9 and ICD 10.
• Worked on validating OBIEE reports project.
• Worked on HEDIS file project, Pharmacy Benefit manager (PBM) Claims project.
• Analyzing and working on to resolving Production issue tickets with Business Analyst, Data Architect and development team.
• Working with database architect, business analyst and developers for Development grooming session and Test Script grooming session for each of the stories.
• ETL Validation using automation tool QuerySurge similar principles of Informatica DVO.
• Setting up Parameter file, execution and monitoring of Informatica workflows based on deployment instructions, analyze the WF and session log.

Environment: Informatica 9.6.2, Oracle 11g, SQL Server 2008, Toad 12.1, QuerySurge, MS Visio, VersionOne, UNIX, Automic job scheduler, OBIEE reporting, Agile Methodology

Confidential, Libertyville, IL

Lead ETL QA /Data Analyst

Responsibilities:

• Determine, Prepare and Maintain the Test strategy, test design, test cases, and traceability for the BI and ETL solutions under test.
• Work with the BI and ETL teams closely to progress the testing toward realistic achievable milestones.
• Interpret complex business/data requirements and translate into a comprehensive scenario or “test data” (using SQL, PL/SQL and/or data generation tools).
• Working on various legacy Frontend systems related to finance like remarketing, Billing and collections and Asset to be incremental and historical data fixes of lease, Retail and Balloon accounts.
• Major part of this project are Customer Data Integration / Master Data Management implementations across multiple sources. Main objective is to bring quality focus to MDM implementation so that a quality architecture and quality infrastructure is delivered which can feed to reporting needs.
• Worked on daily data feed validation from Oracle financials and Salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Leads, Campaigns, Forecasts to be ingested into EDW.
• Working on Enterprise Data warehouse for validating the Fact and Dimension tables (SCD type 2) for data related issues.
• Experience in profiling large data sets to understand and determine to create metadata accurately.
• In absence of required data, creating test data set to meet the requirement.
• Analyzing and finding the data anomalies for data quality.
• Worked on White box and gray box testing for complex code transformation to interpret the code and find issues if any.
• Analyzing and working on to resolving Production issue tickets with Business Analyst, Data Architect and development team.
• Execute test plan tasks, review results and utilize a defect tracking system to record and track resolution of defects in TFS and JIRA.
• Provide work Bucket hour estimation and budgeting for each story(agile process) and communicate status to PM.
• Conduct daily standup meeting, Coach and mentor 4 resources in ETL QA team.
• Working with database architect, business analyst and developers for Development grooming session and Test Script grooming session for each of the stories.
• Working on large set of data to be transferred from staging to ODS.
• Working with five Application developer group to handle their data needs and work in sync towards String testing.
• Working knowledge of UNIX, brief exposure on AWK utility and bash scripting for ETL output flat file validation before sending it to SFTP server.

Environment: Informatica 9.5.1, Oracle 10g, Oracle Financials, SQL Server 2012, Sybase, Salesforce.com, Rapid SQL, Team Foundation server, Microsoft Test Manager (MTM), JIRA, TOAD, MS Visio, HP Quality Center 10.0, Confluence (JAMA), Business objects, UNIX, FileZilla, Sysadmiral job Scheduler, Agile Kanban methodology.

Confidential, Oak brook Terrace, IL

BI Data/Lead QA Analyst

Responsibilities:

• Daily testing of the various data feed related to customer profile, Physical Billing, Product catalog and content provider data.
• Attending meetings with business stakeholders to design and discuss Analytical record(AR) to be used in SAS campaigns.
• Responsible for testing of the ETL solutions developed using SQL Server Integration Services (SSIS) 2005 / 2008 and SQL / T-SQL, SSRS and Tableau.
• Data aggregation matching against staging table and EDW(Enterprise Data warehouse).
• Worked on complex information model, logical relationships, and the data structures that support different area of business.
• SCM Billing data validation in backend for new customers, win back customers, referral data, service termination customer data.
• Finding and analyzing analogies/anomalies for the subscribers buying pattern (w/without promotion Scheme). Analyzing Kids movies/PG 13 movies streaming patterns etc.
• Worked with frontend team for customer reward program for new signup for various promotion plans and free credits associated with each plan, Ref Code validation received in email on special promotion, Rental promotion for various DVD/ Blu ray etc.
• Analyze Site Catalyst data / Omniture data captured in SQL server using Fiddler/ Google chrome developer tool and Omniture reports.
• Develop complex SQL queries using querying tools and SQL/T-SQL and relational database manipulation.
• Responsible for the full life-cycle of the test phase of a project from its kick off until delivery and readiness to be deployed to Production.
• Validate reports designed in Tableau for business stakeholders via referencing backend tables/views and SSRS reports.
• Contribution towards the validation of data related to the creation of new Tableau Dashboards.
• Escalate information as deemed necessary and provide regular status reports on the same.
• Work directly with the frontend team of testing specialists on assigned projects and give certification from backend perspective.
• Analyze data by using T-SQL’s, using pivot and adhoc functional tests in ODS.
• Analyze the streaming data (Session shifting data) in backend for various clients, finding analogies/patterns with or without use of various clients, buying patterns, etc.
• Aggregating and Trending of Content provider report for various Studios.
• Weekly meeting with Business, Stakeholders and Analyst.
• Preparation of artifacts/deliverables for business and stakeholders.
• Data validation and verification will be carried out in Backend using Toad and SQL server management studio.
• Lead and mentor team of 2 ETL QA resources and bucket estimations.

Environment: SQL server 2012, SSIS, SSRS, .Net, SoapUI Pro, TOAD, Excel, Tableau, Omniture, Splunk, JIRA, Confluence, Quality Center ALM 11.5.2, Selenium 2.4, Google Dev tool/Fiddler

Confidential, Fort Lauderdale, FL

Sr.Backend QA Analyst

Responsibilities:

• Reviewing and analyzing business requirements and functional documentations for test scenario development.
• Designing the test plan and scenarios and test cases that to be exported into HP-ALM.
• Analysis of heterogeneous data from various systems like SAP, Siebel, Salesforce.com and validating it in ODS(operational Data store).
• Analyze data by using T-SQL’s, using pivot and adhoc functional tests in SAP Sales Ordering system and reporting to compare the data in EDW.
• Aggregating, Trending and creating graph of Backlog Order information in Excel.
• Performing data validation using PL/SQL and T-SQL queries.

Environment: SQL server 2008 R2, SSIS, SSRS, Oracle 10g, SAP,  VB.Net, Odata Explorer, TOAD, Excel, Agile Methodology, HP-ALM 11.0, MS Sharepoint, XML, Rational performance Tester.

Confidential       

Data Analyst

Responsibilities:

• Reviewing and analyzing business requirements and functional documentations for test scenario development.
• Working with Conversion team of data from State legacy system(getting datafeeds from mainframe) so as to carry out testing in more efficient way.
• Worked on Enterprise Data warehouse with high volumes of data related to Auto Licensing and Tax collection.
• Extensive Functional and Regression testing of frontend and middleware via SOAP, WSDL and Business process management through Java Messaging Services inside the web service client.
• Worked closely with developments team for STM(Source to Target mapping) document Modifications and raise a Change request(CR) incase required.
• Mapping testcases with RTM (Requirement traceability Matrix) and impact matrix.
• Designing of Extensive Test Plan, Scenarios and managing walkthrough and daily defect & Weekly status calls.
• Experience in ETL deliverables, sourcing from multiple source systems.
• Testing of Data quality tickets for History and incremental fixes in EDW(Enterprise Data warehouse).
• Worked on implementation and post implementation support.
• Act as the technical contact for any query/database performance issues, work with developers and business users in query requests and enhancements.
• Working with developers to fix/tweak the .net code using the Visual Studio debugger.
• Live Meetings with SME’s (Subject matter experts) for writing scenarios for testing the various State Tax viz IT, Sales Tax, Lottery and other financial application.
• Validating the data using T-SQL on very large databases (VLDB).
• Worked as UAT Defect manager, managing defects for User Acceptance Team, designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes, deliverables.
• Verification and Testing reports on reporting server(Copy of Staging data) with the reports from legacy system.

Environment: SQL server 2005/2008 R2, SSIS, SSRS, Oracle 10g,  VB.Net, VS 2008, TOAD, Agile Methodology, Mainframe,  Confidential, MS Sharepoint, Tivoli Storage Manager, SAN,XML, SOAPUI, XmlSpy,  LiteSpeed 6.5, Spotlight, VMWare.

Confidential, Richardson, TX

Sr.QA Analyst

Responsibilities:

• Analyzed the Business Requirements Document and System Specifications and identified the test requirements.
• Writing and executing test cases based on FSD (Functional Specification Document).
• Testing specific session based data usage for prepaid accounts.
• Evaluating speed test, volume test by burning the data from specific network towers and geographical locations.
• Responsible for per-production device testing (Smartphone, Data only device and Netbooks).
• Managing and Coordinating test in MSG (Mobile Shared Data), EIT (Enterprise Integration Testing) and in QP (Quite Production).
• Testing of SIM card on Various brands of Smartphones, Tablets etc. for speed and data usage analysis.
• User interface testing on various smartphones and tablets.
• Data verification and validation for billing of wireless and data usage related equipments.
• Worked on Billing adjustments, credits applied, early termination, fee waiver etc.
• Escalating & Filing Defects, tracking the defects using HP Quality center.
• Involved in Integrated Systems Testing team for testing of various applications like Phoenix, POS, and OPUS for the external clients like RadioShack, Wal-Mart, Best buy etc.

Environment: Oracle 10g, Java, selenium, SQL, UNIX, HP Quality Center 10.0, Agile Environment,

Confidential, MS

Lead BI Sr. QA Analyst

Responsibilities:

• Analyzed functional requirements and SRS documented the user specifications and business rules.
• Mapping testcases with RTM (Requirement traceability Matrix) and impact matrix.
• Designing Test Plan, Scenarios and managing walkthrough and daily defect & Weekly status calls.
• Working on multiple projects like Large group renewal and small group renewal system and Blue Direct Reporting (BDR).
• Testing data from mainframe input file, Staging and EDW.
• Data aggregation matching against staging table and ODS(Operational Data store).
• Ensured ETL Regression testing and integration testing to ensure proper functioning.
• Worked closely with developments team for STM(Source to Target mapping) document Modifications and raise a Change request(CR) incase required.
• Worked on Dental, Vision, claims processing and protected healthcare information(PHI).
• Validating on data using SQL queries in TOAD based on logic/conditions and filters specified in source to target mapping document(STM).
• Scheduling and monitoring the Tivoli job scheduler for sequence of jobs execution with dependencies and scheduling, Holding and re-startability of a job in case of failure.
• Extensively tested each table based on STM(Source to mapping) using SQL’s, rules and filters.
• Blue direct Report testing using COGNOS report studio.
• Leading to scheduling meetings with Development team and various cross testing team.
• Involved as managing defects for User Acceptance Team, Designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes.
• Provide task estimation and budgeting for each user story and communicate status to Project Manager.
• Provide various metrics to project manager viz, Root Cause analysis, Test execution productivity trend, Average defect turnaround time.
• Mentoring a team of 5 QA resources.
• Managing issues with on-shore and off-shore development team.

Environment: Informatica 8.6.1, SQL Server 2005, Oracle 10g, DB2, Mainframe 3270, UNIX, COGNOS, TOAD 10.5, Tivoli Job Scheduler,MS Project, Visio, SOAP, PVCS, XML, IBM suite, IBM Confidential .

Confidential, Richardson, TX

Sr.QA Analyst

Responsibilities:

• Creation and execution of QA and testing processes such as test scenario planning, test case writing, test case execution, Defect documentation and issues investigation and resolving.
• Experienced in manual/backend testing with the focus on smoke testing, Functional Testing, Regression Testing, Black box, Gray box Testing and System Testing.
• Extensive Functional and Regression testing of frontend and middleware via SOAP, WSDL and Business process management through Java Messaging Services inside the web service client.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database using toad.
• Worked on Customer Service Management (CSM) Module of the Amdocs Ensemble (Telegence) system. The process encompassed performing online activities on Telegence, running End of Day, Usage and Billing process followed by validating the online and paper bills in 26 markets.
• Validate the Billing history for Change of Bill Cycle BANs to check for Errors once the Invoicing was done and Send the BANs for IR Processing and Invoicing.
• Worked on Combined billing project of AT&T Uverse, Wireless and Wireline and user opted bill date selection verifying in AMDOCS CSM Billing module.
• Worked as UAT Defect manager, managing defects for User Acceptance Team, designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes, deliverables.
• Deployed and customized collaborative and publishing site collections, sites, web parts, document libraries, lists, and views.
• Organizing meetings with Team lead, Developers, and QA team members for Defect tracking, resolving to meet the deadline.
• Escalating & Filing Defects, tracking the defects using HP Quality center.
• Worked for planning and support meetings with onshore and offshore for various issues and solutions.

Environment: Oracle 10g, SQL server 2005, Asp.Net,VB.net Java, XML, LoadRunner, IBM Rational Confidential, HP Quality Center 10.0, QTP 9.2, SOA, MS Sharepoint, Change Request Tool, TOAD, VI editor, Putty, Amdocs, Ensemble, Telegence, CARE, XMLSpy.