SUMMARY

• Sr. ETL/Datawarehouse Tester/Data Analyst with 7 + years of experience and expertise necessary to take on dynamic and complex software systems. Strong background in both manual and automation testing. Desire to bring abilities to the new role with room for advancement.
• Good exp in Python Scripting.Proven skills in completing black, white and grey box tests. Background writing and implementing test cases, developing testing plans and identifying use cases. Fully versed in complete SDLC.
• Quality expert with success reviewing features and assessing functionality to identify common and complex software problems.
• Special experience in Alteryx and Tableau software illustrated over 3 years of experience.
• Collaborates with cross - functional team members to enhance software package quality.
• Senior Software Quality Assurance Analyst and outstanding performer in Data Analysis and Validation within the organization.
• Proven success in leadership, operational excellence and organizational development with keen understanding of elements of business.
• Recognized for inspiring team members to excel and encouraging creative work environments.

TECHNICAL SKILLS

ETL Tools : Informatica Power Center (Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor), DVO(Data Validation Option)

Software Tools: TOAD, CITRIX, HP-QC, CA Workload, Putty, Win-SCP, Alteryx, Tableau, Anaconda, Jupyter- Notebooks, Spyder

Operating Systems: Windows 7, Win NT 4.0, UNIX, LINUX, and MS-DOS

Software Methodologies: Waterfall, Agile

RDBMS: Oracle 11G/10G, IBM DB2, MS SQL Server, My SQL, Netezza, Oracle 12 C, MS Access

Programming Languages: SQL, PL/SQL, UNIX Vi, Python

Software Packages: JIRA, HP-QC, MS-Office, PowerPoint, Word, Excel, Outlook, Beyond Compare, Visual Studio, SharePoint, Confluence, ServiceNow

PROFESSIONAL EXPERIENCE

Senior ETL Tester/Data Analyst

Confidential - Herndon, VA

Responsibilities:

• Interacted with Business Analysts and Product Owners during requirement gathering.
• Led and drove Test planning meetings and ensured all Features were covered and corresponding User stories were created.
• Participated in In-sprint grooming sessions and Sprint Recon sessions at the end of each Sprint.
• Played key role in planning team providing suggestions and feedback to create new updates for client's proprietary tool DTF (Data Test Framework)
• Perform upstream/downstream impact assessments to application and work as POC for all co-ordination efforts.
• Led Regression Test Automation effort and successfully delivered complete suite of workflows which helped cut down regression time by 80%
• Participated in several Knowledge and brain storming sessions to understand and draw requirements to build a new tool to Automate Regression Test.
• Worked diligently and proactively to find areas where testing can be automated and successfully employed several procedures to cut down total Progression test execution time by at least 20% Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Creation of database objects like tables, Views, Stored Procedures, Packages using Oracle tools like Toad & SQL* plus.
• Used Autosys to create Jobs and attach sequences so that the data load into UAT environment is automated.
• Created and Maintained database backups in Delphix database for UAT Team.
• Provided support to Report testing and suggested fix defects in various stages of Testing i.e., SIT (System Integration Test), Integration Test and UAT (User Acceptance testing).
• Performed code review and made changes/improvements as required Responsible for providing migration documents to business team.
• Responsible for development of all Regression Test Suites using Alteryx Designer for Legacy applications.
• Handle team and guide with maintenance of legacy Alteryx workflows for Regression Test. Responsible to gather relevant impacted user stories and build automation workflows to assist business validation.
• Held multiple demo sessions to train peers in Alteryx Designer.
• Held multiple brown bag sessions per the request of different teams and suggested ideas to fit their requirement.
• Assisted in Tableau Dashboard Report Developments for Business Users.
• Working on building new Automation tool to ease regression test process between SLS (Sub Ledger System) and EDW components.
• Working on using python to build UI component of Automation tool (Gandalf).
• Proactively Monitored user interaction with system and make improvements to tune applications for shifting business and user needs
• Created Epics, Features and User stories in JIRA and worked with Scrum Master to make sure all User stories are properly assigned. Created Test cases and Executed them in JIRA.

ETL/Datawarehouse Tester/Data Analyst

Confidential

Responsibilities:

• Created Test Scripts by analyzing requirements and mapping specifications. Responsible for creating Test Strategy for New Data Warehouse.
• Performed Informatica and DVO (Data Validation Option) installation and created user-friendly manual for team members. This helped decrease turnaround time by aiding team members to efficiently download, install and request appropriate roles/accesses by at least 50%.
• Developed Test Scripts using Informatica DVO for use during SIT (System Integration Test) Created complex SQL queries for use in DVO SQL views
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE functions
• Created Test Cases and Requirement Traceability Matrix. Mapped Test Cases to Requirements in HP-Quality Center. Developed detailed Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional Testing and Regression Testing. Interacted with Stake holders and Development team to get requirements to facilitate UAT testing.
• Performed test case execution and defect lifecycle using HP QC
• Prepared status summary reports with details of Executed, Passed and Failed test cases from HP QC using excel and sent them out everyday to track/relay team's progress.
• Validate defects raised during testing cycle.
• Ensured that proper severity and priority has been assigned to defects and follow up for its resolution with development team
• Handled daily defect triage calls efficiently and followed company standards in creating and tracking defects.
• Prepared test plans for various custom applications resulting in delivery of more seamless and user-friendly application
• Worked with cross functional teams to align work, priorities, and practices and to determine if planned enhancements and changes are in line with company's standards.
• Provided valuable insights and always setup brainstorm sessions with all team members while building Test Strategy.
• Managed team of 2 onshore and 3 offshore resources. Efficiently handled and provided individuals goals to team.