SUMMARY

• Solutions - focused QA Tester / ETL Test lead with 10 plus years of experience; high-level proficiency with ALM, advanced SQL, Unix script, SSIS, SAS, Informatica, Informatica DVO, DataStage, QTP/UFT with knowledge in Java.
• A track record of successful project delivery of high quality software across financial, and healthcare sectors
• Extensive experience in software testing, testing strategy, software process improvement, test automation, software development, and both traditional and agile testing methodologies
• Project Experience includes testing complex ETL and BI solutions, Data warehouse testing, Report testing, writing advanced SQL scripts for data validation, data profiling, Restful Web services testing (SOA) using SOAP UI, Java application and .net application testing etc.

TECHNICAL SKILLS

Testing Tools: HP ALM, MS Test Manager, Quality Center 9.2, Rational Robot, Rational Clear Quest, Rational Requisite Pro, QTP, Team Foundation Server, SOAPUI, QuerySurge, SAS

Testing Methodologies: Agile, Waterfall, ISO Quality Standards, CMMI

Modeling Tools: ERWin, Visio, EAsparx

ETL Tools: Informatica 9.6.1, Informatica DVO, DataStage

Programming Languages: VB Script, SQL, PL/SQL, HTML and XML.

Industry Experience: Healthcare, Finance

BI Tools: Business Objects XI R2. SQL Reporting Services, Cognos

Databases: DB2, Oracle, MS Access, SQL Server 2012, Netezza and Teradata.

PROFESSIONAL EXPERIENCE

Confidential

Technologies: Netezza, SAP Business Objects, Informatica 9.6.1, SAS, Oracle 12.6, XML, DOORS, HP ALM, SOAPUI, UNIX, AutoSys, ALM, XMLSpy, Rational Clear Quest, QTP.

Responsibilities:

• Sr. QA Tester / ETL Test Lead
• Validated Business Objects Reports with the data extracted by writing SQL queries on Netezza against the report generated by BOBJ.
• Leading a team of 4 testers.
• Tested total of 10 reports and identified 15 defects.
• Written SQL queries to verify the counts using group by function.
• Used advanced SQL analytics such as Dense Rank, Rank, Row Num to extract the data and perform the desired test scenario.
• Created Adhoc reports on BOBJ using Dimension class and Measure class on the Universe.
• Created the test data for a particular test scenario validation and defined test strategy for validating BOBJ reports.
• Executed Informatica ETL jobs using Autosys JIL through command line interface to populate the test data into Datamart from Del ODS database and Acquisition ODS database. Complete system testing has been done from Source DEL ODS database to Datamart.
• Validated Loan Delivery data attributes (ULDD- Uniform Loan Delivery Data) that are imported through LDNG (Loan Delivery Next Generation application) through XML into Delivery ODS database.
• Worked with development team and contributed towards data analysis and minimized retesting and redeployment of the reports.

Confidential

Senior Data Warehouse Tester

Technologies: Informatica 9.6.1, Teradata, Mainframe, MS Test Manager, SSIS, SAS, SQL Server 2012, Visual Studio 2012, XML, .NET, Oracle, Web services, UFT, Java, DB2, Cognos, EA Sparx, DOORS, HP ALM, SOAPUI 4.6, UNIX, Control-M, Tidal scheduler.

Responsibilities:

• Have set up automation framework and used UFT to automate the web application medicode blue by creating data driven tests.
• Completed testing of Data Migration, Application Interfaces and Data Extracts which consisted of 50 ETL extracts for External Vendors and Internal Users.
• Provided work estimate efforts and weekly status reports are sent to higher management.
• Provided mentorship, guidance and instructions to the team.
• UsedInformaticaDataValidationOptiontotestnumerousETLextracts whichhelpedinreducingthedatatestingandvalidationtimeandresourcesby50to90percent.
• Tracked data changes using Change Data capture.
• Involved in setting up test environment, test data preparation.
• Ensured the key results like complete system testing, integration testing, UAT and Vendor testing are achieved.
• Informatica workflows are run in Test environment by adjusting the parameter files as needed to populate one day or one month of the data.
• Used mapping documents to validate the data routing from source files (XML, flat files, Mainframe files etc.) to Staging to Target tables in EDW or Target flat files and in validating the transformation logic.
• Used SQL select statements that include joins, union all, subqueries, having, group by, Recursive CTE, Aggregate functions to extract the data for data validation.
• Created views and stored procedures as needed.
• Used insert and update statements to create and mock the test data for a particular test scenario validation.
• Created Test Strategy, Test Plan, Test Cases and Test Scenarios to achieve end to end testing, system testing, integrated testing and UAT for various projects as CRM application, Membership Enrollment Tracking Application, Individual Dental Enrollment Product, and Actuarial Product.
• Arranged daily Quick touch point meetings for Priority defects or show stoppers finding with the offshore Confidential Development team.
• Involved in creating user stories and use cases. Attended requirement gathering meetings with business users and created functional requirement document for Medicode Blue application.
• Involved in validating reports.
• Data Analyst
• Played the role of Data Analyst proposing data recommendations, data transformation logic in mapping document. The additional role as Data Analyst on ICD-10 conversion project has been economical for the company and we were able to complete all the Data Analysis required for the project within 5-6 months which otherwise would have taken 9-12 months.
• The data migration of Groups and Members to a new system at BCBS of North Dakota is a business transformation and has an estimated savings of 5-6 million an year. Both Confidential and BCBS of ND use one flexible platform for processing claims and reimbursements.

Confidential, Chicago, IL

Quality Assurance Tester

Responsibilities:

• The Commercial Card division of Confidential developed and operated New PaymentNet3, a transactional credit card processing system serving corporate institutions.
• Investment and Wealth Management division offered investment management across all major asset classes including equities, fixed income, multi-asset and money market funds.

Technologies: Quality Center 9.2, QTP 9.0, UNIX, Rational Requisite Pro, Rational Clear Quest, .NET, VB, XML, XSL, C#, SQLServer2000, DB2, Web services, Mainframe, Lotus Notes 7.1.2 and DataStage

Confidential, Tempe, AZ

Graduate Research Assistant

Responsibilities:

• Involved in writing SQL queries and created reports. Accessed data from Oracle using MS Access in creating reports and forms.
• Validated if the report created is meeting the Social Services department requirements.
• Involved in designing web pages using Front Page2000 for ASU West campus Social Services department. Updated the web page with daily events and news happenings.
• Created thumbnails and improved site performance.

Technologies: Oracle, MS Access, Front Page2000, HTML