SUMMARY:

• Data Analyst with 6+ years of experience in data Analysis and Business Intelligence with a solid knowledge and extensive expertise in various software testing methodologies (Waterfall, Agile/Scrum) approaches.
• Worked in all phases of Software Development Life Cycle, Software Test Life Cycle, Defect Life Cycle using industry accepted methodologies Agile Test Practice and Waterfall.
• Expertise in writing SQL and PL/SQL statements for data validation.
• Expertise in data validation for ETL projects using data analytics tools like R, SAS and Tableu.
• Strong working experience in ETL tools like SSIS and Informatica Power Center.
• Good experience in Microstrategy, Tableau, SSRS & Business Objects reports. 
• Expertise on in writing SQL and PL/SQL statements.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling 
• Strong knowledge in SAS to perform Data Analysis (Proc Compare, Transpose)
• Good knowledge with Writing R programs for Data validation and Analysis.
• Vary good knowledge in Python language for data validation and analysis.
• Strong Knowledge in Data Modeling using tools like Erwin and SAP power Designer.
• Expertise in Data profiling using SQL scripts,SAS and Tableu.
• Very good hands-on experience with Testing documentation like writing Test Plans, Detailed Test Cases, Test analysis, Collection of the required Test Data and preparation of publication of Test Results.
• Extensive Experience in Black Box testing, Regression testing, Database testing, and system testing, Sanity, functional, regression, smoke, user acceptance testing, GUI/Front-End testing and end-to-end testing.
• Proficient in writing/executing Test Plans/Cases, Bug Reporting and Tracking Defects.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. 
• Technical strengths and automated test tool expertise includes Webdriver, Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite 
• Experience in conducting the daily standup meeting as part of the scrum activities, reported the status to Stake holders.
• Experienced in working with Business Users, Business Analysts, IT leads and Developers in identifying and gathering Business requirements to further translate requirements into functional and technical design specifications. 
• Strong Team player and contribute towards the team goals. Ability to work productively and effectively in a team as well as individually.

SKILLS PROFILE:

Test Management Tool:  HP ALM, QC, Rally, Jira, MTM

Databases:  Oracle, MySQL,SQL Server, Teradata, DB2, SQL server

ETL Tools:  SSIS, Informatica  Power Center 8.x/9.x/10.x 

OLAP Tools:  Microstrategy, Business Objects, Tableau, SSRS

GUI Tools:  Visual Basic 5.0/ 6.0, Crystal Reports 4.6/6.0 

Languages:  SQL, UNIX, SAS, R, Python, Java

Web Technologies:  XML, HTML

Operating Systems: Test Tools  ALM, Quality Center, JIRA, Remedy, Bugzilla, LDAP Browsers, TOAD, Terminal Emulators, MS Project

Languages/Apps Tested:  .NET, SQL, Java, JavaScript, HTML, XML, SOAP, UNIX, Flash, Video Streaming, Internet Explorer, Firefox, Safari, WebLogic, WebSphere, VMware, e-commerce, Billing and Provisioning, Member Services, Mobile SMS, Cloud Computing (SaaS)

DB’s Tested:  ORACLE,MS SQL

OS’s Tested:  Windows, MAC, UNIX, Symbian

Web/App Servers Tested:  MS IIS, BEA WebLogic, WebSphere, J2EE 

Hardware Tested:  PCs, Laptops, HP Servers, Mainframes, AS/400, Video Servers

Tools:  Soap UI, Microsoft Office - Word, Excel, Access, Visio, PowerPoint, Toad, Putty

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business and Data Architect

Responsibilities:

• Understanding the current data flow and draft it in a Data flow diagram and create System understanding document
• Come up with multiple approach to provide the most enhanced solution to the end users.
• Do that estimation in terms of effort and process for the multiple Plans.
• Come up with optimized solution plan and get sign off from end users.
• Data migration approach from STG-ODS-Data mart and then to downstream reports.
• Decide on the history retention process (could be SCD 1 or SCD 2)
• Understand the report requirement and structure data marts that way.
• Create ETL packages in SSIS and reports in SSRS.
• Transfer the knowledge to offshore team on a daily meeting.
• Drive the delivery from Offshore.
• Define the scope, Create sprint plan and conduct scrum meeting.
• Create SQL queries to validate the SSIS data load Package.

Confidential, CA

Data Analyst/ETL Tester

Responsibilities:

• Extensively working on optimizing the existing test scripts using Toad.  
• Creating and executing the test scripts on SAS as part of certification Team.
• Automated the entire testing process Using SAS and R language.
• Performing data validation of Production data and doing Business analysis for the issues.
• Create automated test suit for data validation for various data loads using SAS and R.
• Involved in validation of complex logic like Customer matching and merging to derive Enterprise House hold and address matching and merging to get preferred address.
• Create Trending reports in Tableau to find the data consistency.
• Generate tableau Dashboard for Business need.
• Working closely on the trending reports using Tableau.
• Writing SQL queries as per the Business view by using Business Objects.
• Complete understanding of the Sources and target systems, flow of data to the downstream data marts.
• Extensively working on analyzing the Business User queries to include the logics as part of Regression testing.
• Involved in the error checking and testing of the Data warehouse ETL  procedures and programs Informatica session log. 
• Conducted Business Demos with the Clients to go over the Product developed and Tested.
• Developed the complete Test documents involving Test Plan, Test Cases and Test Scripts by analyzing Business requirement documents and Use cases.
• Performed Back End Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Review data loaded into the data warehouse and data marts for accuracy, completeness, consistency and validity
• Created and maintained procedures and documentation
• Better co-ordination with the Steady state team, Release team and SIT team for the ongoing projects.
• Generate reports and trends for the Business users to take strategic decision.
• Create R program to do an end to end testing from source to Target and create test results automatically.

Environment: Toad, DB2, Tableau, Business Objects, HP ALM, SAS, R, Informatica 9.5, Mainframes

Confidential, San Jose

SSIS Developer

Responsibilities:

• Written Test Cases for Data warehouse ETL to compare Source and Target database systems 
• Extensively worked on test case reviews with the Business and the managers to ensure QA has covered all the Business Aspects.
• Created packages for the data load process from source files to Stage Tables.
• Created unit test cases for the SSIS packages.
• Created View for to be used for Microstrategy Dashboards.
• Designed smoke, sanity, acceptance, functional and regression test cases.
• Written Test cases where data is coming from multiple sources using complex join conditions.
• Extensively worked on debugging by tracing the logs.
• Used HP ALM to prepare Test cases, procedures and Requirements Traceability Matrix
• Verified that all modules were tested properly based on requirements.
• Tested Microstrategy Dashboards for UI.

Environment: SSIS 2012 , SQL Server , Agile, Microstrategy ,HP ALM, SQL, Flat Files , 

Confidential, Chicago IL

Sr ETL tester

Responsibilities:

• Worked on documenting the Test Plan and collecting the Business requirements from Client to make sure all the Aspects of the Business is covered and tested.
• Prepared Test Plan and gave a detail test plan strategy for the management.
• Wrote Test Cases for Data warehouse ETL  to compare Source and Target database systems 
• Extensively worked on test case reviews with the Business and the managers to ensure QA has covered all the Business Aspects.
• Extensively worked on Agile Methodology.
• Used the test scripts for Regression, Sanity, Smoke Tests.
• Extensively used ETL  methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide ETL   solution using Informatica.
• Extraction of test data from tables and loading of data into SQL tables. 
• Tested the ETL mappings and other ETL  Processes (Data Warehouse Testing) 
• Involved in the error checking and testing of the Data warehouse ETL  procedures and programs Informatica session log. 
• Written several complex SQL queries for validating Cognos Reports. 
• Complete Knowledge on Planning Systems - Order Planner, Merchandise Planner, Event Management, Pattern
• Run the rules to ensure the data conforms to the validation rules. Created and executed all tests through Power center. Loads results into the DVO results database and displays them in the DVO ensured that every aspect of the Business is understood by the Team.
• Good understanding with all the business rules as a part of Business Planning Systems .
• Tested End to End test flow scenarios starting from Front end to the Order fulfillment systems and Oracle Financials successful.
• Conducted Business Demos with the Clients to go over the Product developed and Tested.
• Extensively worked on debugging by tracing the logs.
• Used Rational / Jira, HP ALM to prepare Test cases, procedures and Requirements Traceability Matrix

Environment: Informatica 9.5, MS SQL Server 2008, Agile, UNIX, Cognos, MS Excel, Oracle 10g, TFS, SQL, TOAD, Flat Files, JIRA, HP Quality Center/TestDirector, ALM, Oracle .

Confidential

Sr. ETL Tester

Responsibilities:

• Responsible for analysis, reports and defect tracking. 
• Actively attend meetings with fellow testers and other groups to evaluate the progress and Performance of the application. 
• Responsible for writing shell scripts (wrapper) to schedule the jobs in development environment.
• Involved in extensive DATA validation using SQL queries and back-end testing 
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards 
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Created stored procedures, triggers using PL/SQL. 
• Involved in Functionality, Stress, regression, performance, load, and User Acceptance Testing. 
• Tested the application in cross browsers such as Internet Explorer, Mozilla Firefox, Safari and Google Chrome for browser compatibility testing.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team. 
•   Worked in Agile methodology during application development and participated in daily scrum meetings.
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures  .
• Developed automated test scripts using QTP to perform Functional and Regression testing. 
• Created Test input requirements and prepared the test data for Data Driven testing. 
• Designed smoke, sanity, acceptance, functional and regression test cases.
• Performed various testing activities like GUI testing, functional testing, browser compatibility testing, regression testing.
• Tested several Informatica Mappings to validate the business conditions 
• Formally Document Test Plans, Test Suite Design and Test cases. 
• Defect Management (including documentation and verifying resolutions). 
• Participate in Testing Documentation reviews and Walk - through, including: Test Plans. 
• Participate in Project and Test Team Requirements reviews. 
• Determine Test Data needs. 

Environment : Informatica 9.1, Cognos, Java, SQL, PL/SQL, Oracle 9i, HTML, TOAD, XML, UNIX, Quick Test Pro, Quality Center, MS Excel, SOAP UI