SUMMARY:

• 6 years of experience in Testing, Business Analysis and Project Management
• Well versed in creating Test Plan, Test Cases and Scripts to support testing.
• Experienced in Software Development Life Cycle (SDLC) - Waterfall & Agile Scrum methodologies from requirements definition to product release within determined deadlines.
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution and Defect Management.
• Facilitated scrum meetings and Defect triage to coordinate with team to ensure deliverables are completed by deadlines
• Coordinated with teams to deliver error free product through testing, creating detailed test strategies, automation strategies, responsible for test deliverables, facilitating UAT, status reporting to management and issue escalations.
• Strong on Datawarehouse Concepts.
• Strong knowledge in SQL and worked on various databases - MS SQL (T-SQL),PLSQL, Oracle and Sybase.
• Strong in Informatica Powercenter for troubleshooting/managing workflows and ETL process
• Worked extensively on UNIX platforms and Windows platforms
• Outstanding organizational skills including ability to multi-task, managing multiple projects, prioritizing and managing increasingly complex issues
• Used SharePoint and Confluence extensively for Document management
• Experience working on Automation tools such as QTP and Selenium.
• Reduced cost and time and increased test coverage by developed tools using VB Scripting to automate run DML and DDL statements on SQL database, Partition large files.
• Experience testing Webs services. Soap UI and Rest services extensively for testing requests and responses.
• Experience working on Python and Perl Scripts.
• Worked on SharePoint extensively.
• Participate in weekly meeting with business and project managers to prioritize the enhancements.
• Supervise and coordinate technical delivery with offshore and onshore team and meet deliverables on time with adherence to schedule and quality mandates.
• Excellent interpersonal, communication, presentation and documentation skills
• Design the automation approach for regression scenarios
• Defect management - Identify defects at an early stage and deliver details to stakeholders and developers on time so that the Production release is not impacted.

TECHNICAL SKILLS:

• Agile & Waterfall methodologies
• Test Plans & Design
• Project Documentation
• Functional & Regression Testing
• UI Testing
• Data Warehouse testing
• Testing Automation Strategy
• Defect/Bug Tracking
• Reporting and Metrics
• Test estimation
• Requirement analysis
• UNIX
• JIRA, HP QC
• SQL
• Informatica
• Microsoft APS
• CCNA certified

PROFESSIONAL EXPERIENCE:

Confidential

Test Analyst/Lead

Responsibilities:

• Worked on Elastic search feature implementation
• My responsibilities include Requirement analysis, Sprint Planning, Testing of Web Application, Onsite/Offshore coordination, Reporting the status on daily basis to offshore/onsite and Defect Triaging.
• Facilitating UAT and providing demos for sign off.
• Provide support for Test design.
• Create test cases for complex modules based on the defined test strategy for the assigned module.
• For the assigned module, implement guidance given on test data, perform set-up activities, prepare scripts (SQL, etc.) to create test data as required and populate test data in a timely manner.
• Execute test cases as planned for the assigned modules with special focus on key modules using knowledge of test execution process for both functional and non-functional type of testing.
• Perform specific activities for the given module as per the ""Go-live"" implementation plan with guidance from supervisor.
• Participate in and prepare content for KT sessions, capture understanding of assigned module, and take on shadow support.
• Participate in onsite-offshore interactions as required, prepare and submit daily status reports to supervisor and provide timely updates for project trackers on the module assigned.
• Document and share own learnings from the project, seek information and leverage knowledge from other modules.
• Provide inputs for the Requirements Traceability Matrix (RTM).

Data Warehouse/ETL Testing

RESPONSIBILITIES:

• Testing of Big Data on Microsoft APS platform - Validated the loading and transformation of large sets of structured, semi structured and unstructured data on Hadoop and SQL Parallel Data Warehouse
• Worked on Agile model - involving actively on Sprint meetings to estimate and define scope of activities for each Sprint and groom backlogs
• Attended business requirement meetings and scripted SQL queries on SQL PDW platform to validate the technical data quality and business data
• Tested snowflake/star schema and the SCD1/SCD2/Fact table load transformations to load data into the data mart
• Worked with Program Managers, Business Analysts, Developers, and Testers to resolve issues with requirements/mapping transformations
• Created, estimated, designed and executed test plans and test cases using HP Quality Center.
• Responsible for providing HP ALM and QA life cycle training to various user bases.
• Triaged defects in HP ALM & JIRA for QA and DEV env, working with DEV team to resolve the defects, retesting and closing the defects.
• Increased test coverage by developing tools to partition files, extract specific rows and columns, thus eliminating the sampling technique to validate large files
• Developed tool using VBA to automate the monitoring and emailing of failed SSIS packages run via Autosys
• Managed requirements and defects on JIRA, prepared status reports on a daily and weekly basis on Confluence
• Conducted product design reviews throughout the software development lifecycle to provide input on functional requirements, product designs and potential issues.
• Provided technical leadership and coordinated with application teams
• Responsible for resource planning and test effort estimation
• Designed automation approach for testing on Microsoft APS; designed strategies for implementing complex business requirements; documented automation approach using MS Visio.
• Participated in the architecture, design, development and testing effort of building Interfaces (Data Integration) for Test Data Management

Technical Environment: Big Data Platform-Microsoft APS, Hadoop, Parallel Data Warehouse(PDW), SQL server, Oracle, HP ALM, MS Visual Studio, VBA on MS Excel, Autosys, Rapid SQL, SQL Server Management Studio, JIRA, TOAD, Compare, Confluence

End to End Integration Testing

RESPONSIBILITIES:

• Analyzed the system requirement specification, related design documents and developed Test Plans
• Conducted Data Warehouse Testing (DWT)/ Functional/ Integration/ System/ Regression/ User acceptance testing for the software product under varying conditions and analyzing the behavior of the system
• Experience working on various Securities, BlackRock’s Aladdin and Eagle PACE
• Involved in System Integration Testing of Order Management System, Trade Processing Systems & Portfolio Accounting System in Capital Group
• Worked on Unix Batch jobs, retrieving the report output files and comparing in new and legacy environments using various comparison tools
• Used ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica
• Used Informatica Workflow Manager to execute Informatica Mappings and Workflow Monitor to monitor ETL execution and logs.
• Worked on Power Center Informatica components such as Sources, Targets, Mappings, Workflow Monitor, and Workflow Manager Etc.
• Provided detailed project level status reports end of each day.
• Saved 15% of cost and time by developing a tool on VBA to clean up database. This reduced the manual efforts from 50 minutes to 5 minutes.
• Developed and maintained comprehensive test cases covering all the requirements.
• Used MindMap extensively for graphical representations of requirements and showcasing to the client
• Involved in running various Autosys Jobs on Secure CRT to validate data flow between various interfaces
• Participated in peer reviews of functional specification, application previews, and test plans/test cases.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases
• Created and executed SQL queries in Oracle, MS SQL & Sybase database to validate ETL processes
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Used TOAD/Rapid SQL to develop and execute test scripts in SQL, to validate the test cases.
• Worked closely with team members to ensure status and schedules are communicated to Onshore Counterparts
• Interacted with Business Analysts and developers to resolve the technical issues so as to meet the client’s requirement for a better quality software product.
• Performed Integration Testing, Functional and Regression testing, Maintaining Requirement Traceability Matrix

Technical Environment: UNIX, Sybase, Oracle, HP ALM, Informatica, Autosys, Rapid SQL, SQL Server Management Studio, JIRA, TOAD, VBA, Compare, CompareIT, SnagIT, HTML5

Business Systems Analyst / Quality Analyst

Responsibilities:

• Worked on the project to manage data flow process of 911 data to the CAD system and its archival to the data warehouse
• Used Agile Scrum methodologies in the Software Development Life Cycle (SDLC)
• Managed project resources, goals and timelines
• Conducted GAP Analysis of existing and the expected business processes
• Prepared technical specifications and Source to Target mappings
• Performed Source system analysis to identify the source data that needs to be moved into the target tables
• Performed ETL to load data into the destination systems
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Interacted with the SMEs and technical teams to develop User Stories.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Served as a primary point of contact for the Product Owner to guide the sprint team for reaching project objectives and tackling critical issues.
• Conducted daily scrum meetings to coordinate with team to ensure deliverables are completed by deadlines
• Worked closely with the product owner and scrum master for providing weekly progress reports and ensuring smooth process toward Sprint Goal.
• Dealt with cross-organizational, cross functional groups and vendors for information exchange.
• Created and monitored Acceptance Criteria for the user stories
• Identified pain points in the application and suggested permanent fix.
• Developed estimates/quotations for business tasks
• Participated in the research and development of business opportunities and ideas within the scope of the project.
• Worked with MS Visio to create process flow diagrams
• Prepared technical reports by collecting, analyzing, and evaluating information and trends.
• Worked with ETL groups for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and MS SQL server.
• Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
• Coordinating with change management for implementation and maintenance activities
• Facilitated UAT and getting user signoff to ensure the release by creating Test Cases to perform functional and regression testing to ensure product stability.
• Managed issues and defect management ; Used HP Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

Confidential, Norwalk, CA

Lead Research

Responsibilities:

• Participated in the project to develop a new intranet
• Lead end to end research and analysis across multiple teams and worked closely with clients to ensure alignment on technical solution.
• Analyzed and prepared GAP analysis reports
• Created the conceptual diagrams and data flow diagrams based on the analysis of requirements
• Created mock-ups and wireframes to design the website as requested by the client
• Participated in Sprint planning meetings
• Documented functional requirements, quality assurance plans, and user stories.
• Coordinated and monitored end to end testing activities
• Created the “IT Disaster Recovery Plan” and “IT Master Plan” for the fiscal years 2012-2016
• Ensured timely and quality delivery of all requests
• Created Status and Test Summary Reports on Weekly basis.
• Executed the test case, and analyzed the actual results against the expected results to each GUI objects.
• Reduced calls to help desk by 26% by developing and documenting the product troubleshooting procedures and user-training.
• Contributed in the development of knowledge transfer documentation.