Data Analyst Client Onboarding

Srilekha Jajala

**********@*****.***

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience supporting data-driven solutions for enterprise clients. Core expertise includes developing and optimizing complex PL/SQL queries and stored procedures on Oracle 10g and Exadata platforms, designing data models, and automating client onboarding and compliance processes. Skilled in building and monitoring data pipelines, conducting detailed log analysis, and ensuring data integrity through comprehensive test scenario design. Proficient with Microsoft Excel and PowerPoint for analytics and reporting, as well as workflow management in Agile environments. Delivers accurate, actionable insights by connecting business requirements with technical implementation, enabling improved decision-making and operational efficiency across projects.

EDUCATION

Masters in information systems

Northwest Missouri State University

Bachelors in business administration Field

Global institute of business school

TECHNICAL SKILLS

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

Data Engineering: dbt, SQL (Complex Queries), Stored Procedures, Data Modeling

Analytics & Reporting: Microsoft Excel, Microsoft PowerPoint, Dashboard Development

Data Integration & Testing: Test Scenario Design, Data Pipeline Monitoring, Log Analysis

Project & Workflow Management: Agile (Scrum), Story Refinement Tools, Work Estimation Tools

Client Onboarding & Compliance: KYC Process Validation, Client Onboarding Automation, Regulatory Data Validation

WORK EXPERIENCE

Kikoff, Data Analyst Jan 2024 - Present

●Developed complex PL/SQL queries and stored procedures on Oracle 10g to extract and validate credit-building transactional data, supporting analytics and compliance requirements for financial product teams.

●Built and maintained robust data pipelines using Snowflake and dbt, optimizing data ingestion and transformation for accurate downstream reporting and analysis in a fast-paced software development environment.

●Created data models from behavioral and transactional sources, enabling insightful dashboards and credit flow analytics for product and finance stakeholders using SQL and Microsoft Excel.

●Tested data integration solutions to ensure seamless and reliable movement of customer and onboarding data across internal systems, focusing on strong interface validation and clear documentation.

●Designed and reviewed test scenarios for key credit onboarding features, identifying data anomalies and supporting quick resolution of issues in collaboration with technology and business teams.

●Utilized Microsoft Office tools, especially Excel and PowerPoint, to prepare and present analytical findings to both technical developers and non-technical executives, supporting informed decision-making.

●Developed monitoring scripts and log analysis routines to detect failures in data pipelines early, reducing time to resolution and minimizing impact on customer onboarding and reporting flows.

●Participated in Agile ceremonies, helping the team define requirements, estimate stories, and prioritize data analytics tasks that aligned with evolving product and compliance needs.

●Guided junior analysts in best practices for SQL development, data validation, and documentation, contributing to knowledge sharing within the analytics group.

●Communicated technical data concepts in accessible language across product, operations, and management groups, ensuring clarity and fostering collaboration for credit product improvements.

Coalesce, Data Engineer Jul 2021 - Jun 2023

●Developed PL/SQL scripts on Oracle Exadata to support wholesale credit data analysis and client onboarding workflows, ensuring robust and well-tested interfaces for financial product integration.

●Designed and executed comprehensive test scenarios for KYC processes, validating data accuracy and compliance with regulatory requirements within large-scale enterprise information systems.

●Created detailed technical documentation and user guides for query tools and data flows, making complex analytics accessible to both technical teams and business stakeholders using Microsoft Office suite.

●Conducted story refinement sessions with Agile teams, breaking down complex business requirements into actionable data tasks, and contributing to accurate work estimation across multi-system projects.

●Built custom stored procedures to streamline onboarding and client verification processes, reducing manual intervention and supporting secure data movement across enterprise platforms.

●Analyzed data anomalies in wholesale credit product pipelines, applying troubleshooting skills to identify root causes and implement effective solutions in close coordination with IT and compliance teams.

●Presented analytical findings and project updates to executive leadership using clear business language, while providing technical deep-dives for development teams to promote organization-wide understanding.

●Prioritized multiple concurrent projects by assessing data complexity, risk, and business value, ensuring timely delivery of analytics solutions in a dynamic technology consulting environment.

●Participated in proof-of-concept initiatives to evaluate new Oracle database features or query optimization approaches, mitigating delivery risks and supporting technology evolution for government and enterprise clients.

●Mentored team members on best practices for PL/SQL query development, data validation, and Agile task management, fostering a collaborative environment and continuous skills improvement within the analytics group.

Contact this candidate