Data Analyst Solutions

Ashish Roganagari

*********************@*****.*** +1-347-***-****

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience specializing in database management, data integration, and client onboarding processes. Skilled in PL/SQL development, Oracle Exadata and Oracle 10g environments, and advanced data analysis using Microsoft Excel and SQL scripting. Adept at designing and validating data solutions, building data transformation pipelines, and supporting KYC compliance and wholesale credit operations. Proficient with Agile Scrum methodologies, effort estimation, and business reporting tools, contributing to efficient project delivery and clear communication across technical and business stakeholders. Delivers actionable insights and supports seamless integration of data solutions within enterprise systems.

WORK EXPERIENCE

Chord, Data Analyst Jun 2024 - Present

●Developed and maintained complex PL/SQL queries to support data analysis and ensure reliable data retrieval from Oracle Exadata environments, focusing on unifying disconnected datasets for consistent business reporting.

●Created, tested, and refined data integration pipelines using Python and PL/SQL, making sure data from multiple sources was transformed and loaded accurately for analytics and downstream applications.

●Built stored procedures and optimized SQL scripts in Oracle 10g to address reporting bottlenecks and improve the consistency of business metrics used by technical stakeholders.

●Utilized Microsoft Excel and PowerPoint to prepare and present analytical findings, communicating technical data insights to both engineering teams and business leaders in a clear, actionable way.

●Documented data flow processes and interface requirements, helping to ensure that new data solutions could be smoothly integrated into existing systems without disruption.

●Participated in Agile sprint planning and story refinement, estimating work for new data initiatives and contributing to the prioritization of tasks within the analytics team.

●Analyzed and broke down complex business requirements into technical tasks, shaping effective data solutions and supporting accurate and timely client onboarding reporting.

●Developed and executed test scenarios for new data transformation logic, validating data quality and supporting reliable delivery of information to end-users and downstream AI models.

●Reviewed and updated SQL code and transformation logic to comply with best practices in data governance and security, reducing the risk of inconsistent metrics across reports.

●Supported multiple concurrent projects by managing shifting priorities, maintaining clear documentation, and asking relevant questions to clarify requirements or identify potential risks early.

Raft, Data Engineer Sep 2019 - May 2023

●Developed PL/SQL scripts to analyze large-scale transactional data for wholesale credit and KYC processes, ensuring accuracy in client onboarding and compliance reporting within Oracle Exadata environments.

●Created robust test scenarios and validated data interfaces to confirm seamless integration of new data solutions into enterprise banking systems, with a focus on secure and reliable client onboarding functionality.

●Designed solutions for end-to-end data flow across multiple applications, mapping business logic to technical tasks to support wholesale credit lifecycle and improve transparency for business and technical teams.

●Built complex stored procedures in Oracle 10g to automate reconciliation and exception handling for client onboarding workflows, reducing manual intervention and improving data consistency.

●Utilized Microsoft Excel and PowerPoint to summarize analytical findings, tailoring presentations for executive stakeholders and technical audiences to support business decisions and project updates.

●Participated in Agile ceremonies, contributing to story refinement and providing effort estimation for data analysis tasks, helping prioritize work and optimize resource allocation within the team.

●Guided team members through problem-solving sessions for data quality issues, using strong analytical thinking to identify root causes and recommend innovative solutions in a collaborative environment.

●Supported multiple ongoing projects by identifying priorities, managing deliverables, and adapting to shifting requirements, ensuring consistent progress with minimal supervision.

●Estimated resource requirements and financial effort for new data initiatives by analyzing project scope and historical data trends, supporting effective planning and budgeting.

●Reached out to subject matter experts and business users to clarify requirements, asking targeted questions to ensure complete understanding and accurate implementation of KYC and credit product enhancements.

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, PL/SQL, SQL (Structured Query Language), Stored Procedures

Agile & Project Tools: Agile Scrum Platforms, Effort Estimation Tools, Financial Estimation Tools, Test Scenario Development Tools

Data Integration & ETL: Data Integration Pipelines, Data Transformation Tools

Presentation & Reporting: Microsoft PowerPoint, Business Reporting Tools

Data Analytics & Query Tools: Microsoft Excel, Python, SQL Scripts, Query Tools for Data Analysis

Client Onboarding & KYC Technologies: KYC Compliance Tools, Wholesale Credit Product Platforms, Client Onboarding Systems

EDUCATION

Master of Science in Data Analytics & Visualization

Yeshiva University - Katz School of Science and Health, New York, NY

Contact this candidate