Data Analyst Client Onboarding

NADIMPALLI GANESH SURYA SAI VARMA

********************@*****.*** +1-402-***-**** United States

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience delivering data-driven solutions in technology and analytics environments. Skilled in PL/SQL and SQL for building complex queries and data pipelines, with expertise in Oracle Exadata and Oracle 10g platforms. Background includes work with ETL tools such as Coalesce and Jinja, as well as process automation using Apache Airflow. Adept at designing automated validation scripts, mapping end-to-end processes, and supporting compliance in client onboarding and KYC workflows for wholesale credit products. Experienced in Agile Scrum environments, requirements documentation, and backlog prioritization, with a collaborative approach to team delivery. Proficient in Microsoft Office Suite for documentation, reporting, and analysis. Strong analytical thinking and attention to detail support successful integration of data solutions across diverse projects.

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, Snowflake

Query Languages: PL/SQL, SQL

ETL & Data Pipeline Tools: Coalesce (ELT Platform), Jinja (Templating for Data Transformation), Apache Airflow

Analytics & Data Validation: Automated Validation Scripts, Test Scenario Design, End-to-End Process Mapping, Observability Dashboards

Productivity & Collaboration: Microsoft Word, Microsoft Excel, Microsoft Office Suite, Agile Scrum Tools, User Story Mapping, Requirements Documentation, Backlog Prioritization

Financial Services & Regulatory: Wholesale Credit Product Integration, Client Onboarding Systems, KYC Compliance Workflows

WORK EXPERIENCE

Coalesce, Data Analyst Apr 2024 - Present

●Developed complex PL/SQL queries and procedures to transform and validate large data sets within Oracle Exadata environments, ensuring reliability and accuracy throughout the data pipeline delivery process.

●Built reusable data transformation templates using Jinja and integrated them with Snowflake, helping data teams quickly process analytics workloads and maintain consistency across projects.

●Created and maintained comprehensive documentation for data pipelines and transformation logic, making it easier for team members and stakeholders to understand data flows and support audit requirements.

●Worked with Microsoft Office tools to produce clear requirements documentation, test cases, and data dictionaries, supporting both technical and business audiences during project lifecycles.

●Designed and executed test scenarios to validate data models and transformations, helping to identify issues early and deliver well-tested solutions that integrated smoothly with existing systems.

●Implemented automated ELT processes within Coalesce’s hybrid low-code platform, enabling fast prototyping and deployment of ETL pipelines on Snowflake for enterprise data projects.

●Utilized the Coalesce API to trigger and monitor data transformation pipelines through orchestration tools like Airflow, providing visibility into execution states and handling exceptions as needed.

●Supported Agile team activities by contributing to user story refinement, requirement gathering, and workload estimation, ensuring tasks were prioritized and resources allocated efficiently.

●Created observability dashboards that tracked pipeline run times and success rates, giving teams actionable insights to troubleshoot issues and improve data quality.

●Participated in cross-team meetings to communicate technical solutions and business impacts, adapting explanations for both technical team members and business stakeholders as needed.

Gradient AI, Data Engineer Aug 2021 - Oct 2023

●Developed PL/SQL queries and stored procedures in Oracle 10g to analyze client onboarding data and support compliance with KYC requirements for financial services applications.

●Designed and executed comprehensive test cases ensuring robust integration of data feeds with internal systems, focusing on seamless flow for wholesale credit product onboarding.

●Created detailed business requirement documents and user stories using Microsoft Word and Excel, enabling clear communication of data mapping and transformation needs to technical teams.

●Built automated validation scripts to check data integrity across multiple applications, supporting end-to-end analysis of onboarding workflows for enterprise clients.

●Worked with Agile scrum teams to estimate story points, prioritize backlog items, and assign resources for iterative delivery of analytics solutions in enterprise credit domains.

●Used analytical thinking to identify data quality issues in client onboarding records, proposing innovative solutions to enhance accuracy and consistency for regulatory reporting.

●Delivered presentations and written summaries translating complex technical findings into clear business recommendations for both technical staff and executive stakeholders.

●Connected data across multiple platforms to build end-to-end process maps, providing a holistic view of client lifecycle from onboarding through ongoing credit management.

●Managed multiple data analysis projects simultaneously, effectively prioritizing tasks and adjusting timelines to meet shifting business needs with minimal supervision.

●Estimated effort and tracked financials for analytics initiatives, ensuring transparency on resource utilization and progress for both internal teams and external clients.

EDUCATION

Master of Science, Management Information Systems

Union Commonwealth University GPA: 3.8/4.0

PROJECTS

Real-Time Client Project – Loyalty & Customer Data Analysis

Built and managed data pipelines using Azure Data Factory to automatically collect and move data from different sources, reducing manual work and improving data accuracy for airline operations.

Transformed large sets of raw data into clean, usable formats using PySpark in Azure Databricks, helping business teams generate reports for flight trends, customer insights, and financial analysis.

Improved data processing speed and reliability by optimizing notebook code and handling version control with Azure Repos, ensuring smooth collaboration and faster delivery in Agile sprints.

Vehicle Service Management System – Django Web App

Built a web app using Django with two types of users (customers and admins) to book and manage vehicle services easily from a browser.

Used four separate databases to store service details, customer info, vehicle data, and feedback, helping the system run smoothly and keep everything organized.

Linked key pages like booking, service history, feedback, and login; added email alerts for updates; and deployed the project live using PythonAnywhere for real-time use.

Credit Risk Management – Loan Default Prediction + AI Chatbot

Created a system to predict the chances of a loan not being paid back, helping finance teams take better decisions and reduce risk in lending.

Built a simple chatbot that allows team members to ask questions about loan risk and get quick answers, without needing technical skills.

Used Python, Pandas, and an AI model with smart data retrieval (RAG) to analyse loan data and show results instantly on a cloud-based platform.

Contact this candidate