Data Analyst Client Onboarding

Vivek Aitipamula

***********@*****.*** +1-540-***-****

PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience delivering data-driven solutions for client projects across diverse business environments. Skilled in PL/SQL, Oracle Exadata, and Oracle 10g for developing and optimizing complex queries, as well as building and maintaining stored procedures to support critical reporting and analytics functions. Strong background in data processing and analytics using Python, Apache Spark, and advanced query tools, with an emphasis on efficiency and reliability. Adept at designing and executing test scenarios, performing thorough data validation checks, and ensuring smooth integration of new solutions within existing systems. Experienced working with Wholesale Credit products and client onboarding/KYC processes, providing detailed insights to support compliance and business operations. Proficient in Microsoft Excel, Word, and PowerPoint to create clear, actionable reports and presentations for technical and non-technical stakeholders. Well-versed in agile methodologies, story refinement, and work prioritization, consistently supporting team delivery and project estimation in fast-paced environments.

WORK EXPERIENCE

Hatch, Data Analyst Nov 2022 - Present

●Developed complex PL/SQL queries and stored procedures to support data analysis and reporting needs, ensuring reliable insights for project teams focused on efficient business solutions.

●Built and optimized data pipelines using Python and Spark for real-time and batch processing, enabling timely access to critical data supporting business decision-making.

●Managed large datasets and performed query tuning for better performance using Oracle Exadata, supporting diverse business initiatives and credit products.

●Created and maintained data models and schemas in Snowflake and BigQuery to facilitate smooth data integration and analytics across the organization.

●Developed clear documentation and process flows for data pipelines, ensuring system interfaces and dependencies are well-understood by all stakeholders.

●Utilized Microsoft Excel and the Office suite to visualize and present data findings, delivering actionable insights and effective communication to business and technical teams.

●Participated in Agile ceremonies, contributing to story refinement, work prioritization, and estimation for new data features and analysis tasks.

●Improved data quality by implementing validation checks and monitoring tools, reducing errors and enhancing the accuracy of business reporting.

●Collaborated with teams to define requirements and deliver data solutions that support innovation and positive change in wholesale credit and client onboarding/KYC processes.

●Tested and validated new data solutions through comprehensive test cases and scenarios, ensuring seamless integration with existing systems and minimizing deployment disruptions.

SquarePeg, Data Engineer Jul 2019 - Dec 2021

●Developed PL/SQL solutions to analyze and reconcile wholesale credit product data, ensuring accuracy and compliance with client onboarding and KYC requirements for large-scale financial systems.

●Designed and executed complex Oracle 10g queries to extract, transform, and validate customer onboarding data, supporting seamless integration with enterprise application workflows.

●Built and maintained robust data interfaces between legacy systems and Oracle Exadata environments, facilitating reliable information flow across wholesale credit and compliance domains.

●Created detailed business and technical documentation for test scenarios, interface requirements, and data mappings, enabling clear understanding for both technical and non-technical stakeholders.

●Conducted requirement analysis and story refinement sessions with business and IT teams, clarifying data needs and supporting accurate work estimation in Agile delivery cycles.

●Tested data integration components by developing sample datasets and test cases, reducing system risk and confirming that new solutions met established business and regulatory standards.

●Utilized Microsoft Excel, PowerPoint, and Word to summarize analytical findings, prepare executive summaries, and deliver presentations to teams and leadership.

●Supported Agile scrum teams by helping prioritize backlog items, estimating resource needs, and coordinating day-to-day progress to ensure timely completion of project milestones.

●Analyzed cross-application data flows and dependencies to provide an end-to-end perspective for system enhancements, identifying potential risks and mitigation strategies.

●Acted as a team player by sharing knowledge, answering questions, and proactively reaching out to resolve data or system integration issues with minimal supervision.

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, Snowflake, BigQuery, PL/SQL

Testing & Validation: Test Scenario Design, Test Case Development, Data Validation Checks

Agile & Delivery Tools: Agile Scrum, Story Refinement, Work Prioritization

Data Processing & Analytics: Python, Apache Spark, Query Tuning, Stored Procedures, Query Tools

Credit & Compliance Platforms: Wholesale Credit Products, Client Onboarding / KYC

Business Intelligence & Reporting: Microsoft Excel, Microsoft PowerPoint, Microsoft Word

EDUCATION

Master in Data Science

Lewis University, USA

Bachelor of Technology, Electrical and Electronics Engineering

Mahatma Gandhi University, IND

Contact this candidate