Data Analyst

Ranjith Goud Palusa

Richmond, VA *************@*****.*** +1-972-***-****

Summary

Business and Data Analyst with 3+ years of experience delivering data-driven solutions for financial services and enterprise applications. Strong expertise in writing complex PL/SQL queries, stored procedures, and optimizing data workflows on Oracle Exadata (10g and above). Skilled in Wholesale Credit products, Client Onboarding, and KYC processes. Proficient in bridging the gap between business and technical teams, gathering requirements, and delivering scalable solutions in Agile environments. Adept at analyzing datasets, improving process efficiency, and presenting actionable insights to both technical and non-technical stakeholders. Technical Skills

Databases: Oracle Exadata (10g and above), MySQL, PostgreSQL, MS SQL Server

Languages & Tools: PL/SQL, Python, Shell Scripting

Data Analysis Tools: Microsoft Excel (Advanced), Tableau, Power BI

Business Domains: Wholesale Credit, Client Onboarding, KYC

Agile Practices: Scrum, Story Refinement, Sprint Planning

Other Tools: Microsoft Office Suite, Jira, Confluence

Cloud Platforms: AWS, Azure

Methodologies: Agile, CI/CD, Data Warehousing

Experience

Business / Data Analyst Capital One

Richmond, VA Jun 2023 – Present

Designed and executed complex PL/SQL queries and stored procedures to analyze Wholesale Credit product data and identify key risk and compliance trends.

Collaborated with client onboarding and KYC teams to streamline data collection processes, improving data quality and reducing onboarding time by 15%.

Partnered with business stakeholders to refine stories and requirements, ensuring alignment with organizational goals and technical feasibility.

Supported Agile sprint planning by providing accurate estimations of effort and dependencies across multiple workstreams.

Performed root cause analysis on data discrepancies by tracing data flow across multiple systems and applica- tions.

Built interactive dashboards in Excel and Tableau for senior management, improving visibility into credit risk and customer onboarding metrics.

Developed proof-of-concepts (POCs) for new data integration workflows to mitigate risk and improve processing speed.

Worked closely with QA teams to define and execute test scenarios, ensuring smooth integration of new features into production.

Enhanced Oracle Exadata performance by optimizing queries and indexing strategies, reducing query run time by 30%.

Acted as liaison between technical and business teams, translating technical issues into clear business terms for executive reporting.

Monitored and tracked Agile metrics, ensuring continuous improvement in team performance and delivery time- lines.

Documented processes, data models, and workflows to support knowledge sharing and onboarding of new team members.

Data Analyst Trix Technologies

Hyderabad, India Feb 2021 – Aug 2022

Wrote and optimized complex PL/SQL scripts to manage and analyze high-volume financial datasets.

Supported KYC compliance by ensuring accurate data migration and validation during system upgrades.

Worked with cross-functional teams to gather and document data requirements for reporting and analytics initiatives.

Conducted exploratory data analysis to identify trends and present actionable insights to stakeholders.

Built detailed Excel reports and automated recurring reporting tasks to reduce manual effort by 25%.

Assisted in the transition to Agile project management by refining stories and backlog grooming.

Identified process bottlenecks in client onboarding workflows and recommended automation solutions.

Partnered with QA teams to create test plans and validate data accuracy for new system implementations.

Provided end-to-end data mapping documentation to support compliance and audit initiatives.

Delivered training sessions on data analysis best practices and reporting tools to junior analysts. Education

Master of Science in Advanced Data Analytics

University of North Texas, Denton, TX Aug 2022 – Dec 2023 Bachelor of Technology in Computer Science

MLR Institute of Technology (JNTUH), Hyderabad, India Jul 2018 – May 2022 Certifications

Azure Administrator (AZ-104), Kubernetes Administrator (CKA)

Contact this candidate