Rahul Chowdary Byrapuneni

Business system analyst working on two different projects related to axiom lineage and FDIC Data quality rules with hands-on experience in developing Python scripts to parse the XML data for the axiom lineage and connecting it to the POWER BI. Similarly, wrote complex SQL to extract FDIC Data and wrote the Data quality rules. Build a prototype application to download and extract the FDIC data using Power BI.

• .Pioneered the development of Python scripts for parsing XML data, significantly enhancing the data lineage process for Axiom systems.
• Expertly crafted complex SQL queries for the extraction and analysis of FDIC data, playing a pivotal role in upholding data integrity and compliance.
• Conceived and executed a prototype application for streamlined downloading and extraction of FDIC data, integrating seamlessly with Power BI.
• Innovated Power BI dashboards, enabling advanced drill-through capabilities for insightful data analysis.
• Developed and maintained comprehensive Entity Relationship Diagrams (ERDs) using data modeler tools, providing a clear visualization of data models and enhancing team understanding.
• Demonstrated expertise in Python, creating robust scripts on LINUX servers for data parsing and Oracle database integration.
• Authored SQL scripts for data extraction, optimizing them into efficient database views.
• Conducted meetings with the finance teams to review the automation process of dashboards.
• Documented data quality rules with precision, effectively communicating technical details to business stakeholders.
• Created detailed technical and business requirement documentation, facilitating clear communication with business teams and end-users.
• Designed and implemented HTML scripts for monthly finance team communications, enhancing the presentation of data check updates.
• Actively involved in data quality checks, employing meticulous testing procedures to maintain high standards.
• Managed and refined MS Access database systems, correcting data irregularities and maintaining data accuracy.

Environment: Linux, Windows, Microsoft tools (Word, Access, Visio, Excel, Outlook, Teams, Power BI), Jupyter, Notepad ++, Axiom, Oracle SQL developer, Toad, Toad Data modeler, VS Code, PUTTY, Python, SQL Server.

• Improved overall class participation by implementing group activities and project-based learning.
• Gained knowledge of Tableau, Power BI, Rapid Miner, and MS tools while grading assignments.
• Demonstrated classes on data analysis/system analysis using SQL and Python.

• Organized and analyzed a longitudinal dataset that contains information on the cardiovascular, nervous system, and physical activities.
• Determined the kind of analysis that would be appropriate to fulfill the project's purpose, identified and sorted important variables, and examined the pattern of the data.
• Analysis of the dataset using SPSS and STATA was performed to get the desired outcomes.
• · Created tables, figures, and patterns with visualization software like R Studio.
• · All the results were noted and presented to the institutional members.

• Enhanced system performance by optimizing configurations and settings.
• Reduced troubleshooting time with thorough documentation of processes and solutions.
• Collaborated closely with software developers to identify and resolve issues promptly.
• worked with finance teams and IT teams for developing a new trade application tailored for the bank's institutional clients, offering advanced trading capabilities in equities, derivatives, and fixed-income products.
• Increased reliability of critical systems through proactive monitoring and maintenance.