Bhavya Vidiyala

**F Garden Ter, North Arlington, NJ 07031

adhzmo@r.postjobfree.com ;+1-551-***-**** (M); LinkedIn

PROFESSIONAL SUMMARY:

Experienced Data Analyst/ Test Engineer, with master’s degree in Information Systems Technology, having profound knowledge on Enterprise Data Warehousing and Bigdata. Extensive experience in Analysis, Development and Testing multiple Data warehousing applications. Hands on experience in working with the Databases as well as reporting and visualization tools like Tableau and Power BI.

Currently working in Data Management team as a Data/ Test Engineer for Perishing- BNY Mellon. Responsible for Documenting Test Plans, ETL Flows, Data Analysis, Data Modeling, and maintenance of Business Glossary & Data Dictionary for reference data and critical data elements related to Asset Movement, Accounts, Positions and Balances, Order Management, and Securities approved by the Data Governance. Hands on experience in creating conceptual, logical, and physical data models in Erwin.

Test Engineer Experience:

Experience in Software Testing of Client/Server, Web based Applications, Manual, SQL and ETL testing

Good understanding of all the stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)

Having working experience on various Testing Stages/Levels/Phases, Testing types, Testing Techniques and Requirements management tools viz., Quality Center

Experienced in Functional and Non-Functional (Availability, Usability, Reliability, and compatibility Testing Types

Conducted system testing for comprehensive data using Manual Testing.

Performed Manual Testing to determine eligibility and financial results for different programs.

Executed test cases for support functions and interfaces to run the reports.

Worked on SIT, Regression testing as well as testing the production defects.

Actively worked in the UAT transition, retested UAT defects and updated comments in JIRA based on the business feedbacks

Hands on experience in preparing Test plans, Test cases and its execution

Good expertise in peer reviews (Test Design and Defect Reporting)

Expertise in analyzing the results and reporting Suggestions and defects

Good Exposure on Bug Life Cycle

Performed planning and execution of QA/UAT testing.

Experience in SQL querying to view successful transactions of data and for validating data

Good expertise on Exploratory Testing using Domain Knowledge

Well-versed in analyzing the Business, Technical Requirements and converting them to Functional Testing scenarios

Skillful in mapping the test cases with the requirements using traceability matrix for Identifying test Coverage

Accomplished in Participating and Coordinating in Smoke Testing, System Integration Testing, Functional Testing, Regression testing and User Acceptance Testing (UAT).

Expert in testing web applications

CORE SKILLSET:

BI Reporting Tools

Tableau, MS Power BI

MSBI Tools

SSIS, SSAS, SSRS

Databases

MS SQL Server 2008 R2/2008/2012, Oracle 9i/10g, DB2, Hive

Data Analytics Tools

Tableau, Pandas, Matplotlib

Data Modeling Tools

Visio, SQL Server Data Tools

Relational Data Modeling

Erwin (Conceptual, Logical & Physical Data Modeling)

Languages

SQL, PL/SQL, Unix Shell Scripting, Python

ETL Tools

Informatica, SSIS

Web Technologies

HTML, Java Script, XML, CSS

Business Tools

VSTS, JIIRA, Confluence, Wireframes, MS-Excel, Visio, MS Access, MS Power Point, SharePoint, PPM, HP ALM and Quality Center

Business Skills

Data Analysis, Disaster Recover Planning, Analysis Modeling and Designing, SDLC, Agile & Waterfall Methodologies.

PROFESSIONAL EXPERIENCE:

Data/ Test Engineer at Pershing- BNY Mellon, NJ February 2019- Present

Conducted Business meetings to identify the critical data requirements impacting the compliance rule

Performed Data Analysis on the critical data related to Asset Movement, Accounts, Positions and Balances, Order Management, and Securities to check the data accuracy.

Created logical and physical Data models in Erwin to label the new segment.

Performed in-depth analysis on the existing data patterns from the DB2 to check the nature of the existing information

Worked on SSIS to get the related data from their old system to the AMPS system and data warehouse.

Prepared test plan and test strategy documents for validating the source files and make sure the data is populated into the target tables accurately based on the data mappings and applied transformation rules.

Document the release plans, Test strategy using Visio, Jira and Confluence.

Wrote complex SQL scripts using joins, and stored procedures to retrieve the data from different data sources like SQL, DB2, PostgreSQL.

Using Tableau designed multiple scorecards and dashboards to display the data trends to the business.

Environment: SQL Server 2012, DB2, Informatica, PostgreSQL, Advanced Excel, Visio, Tableau, ERWIN Data Modeler, Jira, Confluence.

Data/ Test Engineer at Wilmington University, Delaware January 2017-December 2018

Developed IT strategic vision and drove key objectives of the project.

Gathered Requirements, performed Feasibility Analysis and participated in technical implementation.

Designed and developed SSIS Packages to transfer data from MS Excel, SQL Server 2012 R2 and Flat files.

Responsible for optimizing SQL queries, stored procedures to improve the performance time.

Create Test Strategies and Test Cases using ETL testing tools to check the functioning of the web services-based integrations.

Ensured data accuracy through the creation and implementation of data integrity queries

Designed and developed reports and dashboards using Tableau to measure the performance of the University monthly basis.

Build customized interactive dashboards using Tableau desktop for presenting the outcomes of the analysis to the management.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Restricted data for Specific users using Row level security and User filters.

Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: SQL Server 2012, SSDT, Tableau, Advanced Excel, Talend

Data/ Test Engineer at MICROSOFT, India January 2013 – January 2015

Worked with the clients to gather software requirements/business rules, and ensure alignment with development teams

Analyzed the requirements and developed the Test strategy, Requirements Traceability Matrix and the Test plan

Involved in identifying functional and Non-Functional requirements and created the Functional System Design document (FSD)

Responsible for design and implementation of integrated Data warehousing and BI capabilities using INFORMATICA and SSIS

Responsible for creating and modifying the Database for Lotus tax system based on the Business requirements

Responsible for modifying the reports by updating the logic with the change in the line of business

Involved in maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs

Actively participated in writing SQL Queries for pulling large volume of records from enterprise database using stored procedures

Worked on designing, development of SSIS Packages using different control flow tasks and dataflow tasks for performing ETL operations

Created various analytical reports using power BI and SSRS to perform tax calculations on the reports

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc.

Created reports Yearly, Quarterly, Monthly, and Daily based of the business requirements and criticality of the data.

Environment: SSIS, SSRS, Power BI, Informatica, Visio, VSTF

Contact this candidate