Penchala Manjushree A

Translated complex datasets into actionable insights and designed the requirement to the engineering teams
Conducted deep dive analysis on operations and financial data to uncover the patterns in data and supported strategic decisions
Developed scalable data models as a Json format file and transformations were implemented in a third party tool to improve data quality and accuracy
Collaborated with data engineering teams to enhance the pipelines and guide them through the data flow to achieve business oriented results
Improved data quality by implementing validation checks and cleansing process at various level in the process flow
Partnered with cross functional teams to understand the business requirements and deliver tailored insights
Provided data driven recommendations that optimized the operational workflow
Presented analytical findings or observations to the stakeholders by simplifying the complex data into clear business recommendations
Led cross department BI workshops to improve data literacy and strengthen data-driven culture
Managed stakeholder expectations by setting clear timelines, project scopes and project plans

Designed and developed analytical datasets and transformed complex data into business-focused insights.Conducted operational and financial data analysis to identify trends and support key decision-making.Built scalable JSON-based data models and contributed to enhancing engineering data pipelines.Implemented validation and data-quality checks across the processing workflow.Collaborated with cross-functional teams to gather requirements and deliver targeted BI outputs.Presented insights to stakeholders with simplified recommendations.Organized BI/data literacy workshops to strengthen analytical culture.Managed project timelines, scope, and stakeholder expectations.

Analyzed business requirements, system requirements, data mapping requirement specifications and responsible for designing the proposed solution as per the analysis, documenting functional requirements and supplementary requirement documents
Extensively worked on data modeling for star schema and customized insurance industry model to meet the business requirements
Responsible for developing end to end solution architecture design document including technical design document, architecture artifacts, data flow diagrams, data mapping from source to target source systems and best practice documents
Technical assistance provided for Development, Testing and Dashboard teams to ensure a proper data flow as per the requirements/specifications
Data analysis performed by Verification, Validation, and Transformations on the Input data which is further loaded into data warehouse
Initial loading of records on data warehouse and incremental loading of records at a later date to verify new inserted/updated data
Led meetings with clients and key stakeholders to gather requirements, analyze, finalize and have formal sign-offs from approvers
Ability to translate broader business needs into clear team objectives and concrete individual goals and coordinating with external for efficient output
Draws conclusions and effectively communicates findings with both technical and non technical teams
Reviewed test scripts (SQL) and assisted the team on test script tuning

Leading the team from offshore
Worked in dynamic agile environment and participated in scrum with clients and sprint meetings
Co-ordinate with onsite and the clients for better understanding on the Business scenario testing
Working with the development team closely to get the defects fixed and triaged defects with the other teams
Preparing test cases as per the requirement and setting an expectation on what to be tested
Test scripts are prepared to cover all the possible scenarios
Business scenario validation – Understanding the exact business requirement from the client and testing the same
Maintaining all scripts and logs in Agile Central so that it could be reused
Attending Daily Status and having peer reviews to get the sign off from clients
Validating the data in each attribute for every record between Hadoop and SAS output
End to End testing - Validating that all Hadoop jobs are completed with no failures
Ensuring the policies in Hadoop ar same as in SAS for the available divisions
Python tool – Worked as a part of automation team of 4 for building comparator tool using Python, which was helpful in comparison of DDL and data between different types of DBs
This tool was completed apart from the deliverables of my project
Won the hackathon competition held by the clients by presenting the Python tool
Received Client appreciation

Working closely with Dev team and understanding the business requirements end to end scenarios and involved in Test Design and Execution activities
Having hands on experience on Hive queries, base queries, Hadoop commands, Unix commands, Titan - Graphical database and written gremlin code as per the requirements
Attending meetings and coordinating with Test Manager on daily basis
Providing Knowledge Transfer to the new team members
Triaging defects and getting it to closure by discussing with development team
Scripts Generator – Prepared automation tool using Macros for having the Scripts generated in one click which has 1 to 1and half hours of efforts reduced on writing scripts for each feed
Preparing test cases & test scripts
Validating based on Business requirements by understanding the information available in Bridge documents
Data validations have been performed to check the utmost correctness of the data loaded into the target tables
Execution of Shell script/HQL/SQL queries to verify the data completeness and ability to analyze shell script and find out the reason for failure in case of any script failure
Testing was performed for different types of HDFS files such as : Fixed width file , Variable length file and JASON files
Maintaining all scripts and logs in QC so that it could be reused
Attending Daily Status Review with clients
Attending Design walkthrough, raising ambiguities and tracking them to closure

Involved in Preparing the Test cases as per the requirements given in the User Story
Designing the scripts as per the expectations to test against the target
Review meetings with clients to get better understanding that all the expectations are met by the test scripts designed
Discussions with development team to understand their process of loading data
Similarly the QA instances tables are loaded to check against the deployed table
Results are captured in the Test evidence documents which eventually goes through Peer review with clients
Involved in sprint planning meetings and in preparing Business Scenario Testing
Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables
Preparing the Test cases using the Mapping document
Performed System test on Micro strategy Reports Data warehouse system which involved analyzing functional specifications and writing test analysis, executing reports with test data for test scenarios and writing complex Test SQLs for the reports and logging defects in Clear Quest
Validating the Business scenarios for each report as per its functionality
Upload and execute the test cases in ALM