Data Analyst Client Onboarding

Nikhita Mandava

***********@*****.*** +1-903-***-****

PROFESSIONAL SUMMARY

Data Analyst with 6 years of experience supporting enterprise clients in technology and telecommunications domains. Skilled in PL/SQL development, Oracle Exadata, and Oracle 10g, with a proven ability to design and optimize complex queries and stored procedures for large-scale data environments. Adept at data modeling, building ETL pipelines, and executing data validation scripts to ensure data integrity and support critical business processes. Strong background in client onboarding and KYC automation, including integration of onboarding data and reconciliation workflows. Proficient in Microsoft Office suite with advanced capabilities in Excel and PowerPoint for reporting automation and dashboard creation. Experienced in Agile environments, driving test scenario design, integration testing, and resource planning for timely and accurate project delivery. Known for analytical thinking, attention to detail, and clear communication with both technical and non-technical stakeholders to deliver actionable insights and drive project success.

WORK EXPERIENCE

Cogitate, Data Analyst Aug 2024 - Present

●Developed complex PL/SQL queries and stored procedures on Oracle Exadata environments to extract, transform, and validate insurance data for underwriting, policy, and claims applications.

●Created and maintained scalable ETL pipelines to process large datasets from multiple internal and external sources, ensuring data accuracy for core insurance operations.

●Designed test scenarios and data validation scripts using SQL and Microsoft Excel to support the integration of new data-driven features across digital insurance platforms.

●Improved business decision-making by analyzing insurance policy and claim data, identifying trends, and presenting actionable insights to both technical and business teams using Microsoft PowerPoint and Excel.

●Built and optimized data models with PL/SQL to support predictive analytics and reporting for cloud-native insurance products, enabling efficient access to operational metrics.

●Participated in Agile sprint planning and daily standups, prioritizing requirements and coordinating tasks with data engineers and product managers to deliver enhancements for the DigitalEdge Insurance Platform.

●Documented requirements and technical specifications for new data interfaces, ensuring robust and well-tested integrations with existing insurance applications and third-party data providers.

●Used advanced SQL techniques to perform deep-dive analysis on policyholder and claims data, supporting KYC initiatives and improving client onboarding processes.

●Wrote and maintained clear technical documentation for data processes and analytics workflows, facilitating knowledge sharing among cross-functional teams.

●Supported effort estimation and project delivery by breaking down business requirements, identifying priorities, and managing multiple data analysis tasks in parallel to meet project deadlines.

British telecomm, Data Analyst Aug 2021 - Jul 2023

●Developed PL/SQL procedures and optimized complex queries on Oracle 10g to support large-scale telecommunications billing data analysis and enhance reporting accuracy for wholesale credit operations.

●Created automated reconciliation workflows in Microsoft Excel and Access to validate client onboarding data and ensure compliance with KYC requirements across telecom wholesale credit products.

●Designed and executed rigorous test scenarios for new data integration features, ensuring robust and well-tested interfaces between CRM, billing, and wholesale credit management systems.

●Supported Agile sprint activities by contributing business requirements for wholesale product enhancements, estimating delivery effort, and coordinating with cross-functional teams to prioritize telecom credit data projects.

●Built dashboards using Microsoft PowerPoint and Excel to present trends in client onboarding and credit risk to both technical and non-technical stakeholders, enabling data-driven telecom business decisions.

●Analyzed end-to-end data flows across order management, credit assessment, and onboarding applications to identify gaps, improve data consistency, and support process optimization for wholesale telecom clients.

●Guided team members in interpreting complex PL/SQL query results, resolving data discrepancies, and promoting shared understanding of telecom credit product data structures and business rules.

●Worked independently to manage multiple concurrent analysis projects, regularly identifying priorities and addressing critical telecom credit data issues under minimal supervision.

●Facilitated financial estimation and resource planning sessions for new telecom data initiatives, documenting key assumptions and collaborating with project managers to track budget utilization.

●Initiated proactive discussions with technical architects and business analysts to clarify requirements, ask questions on ambiguous data elements, and ensure successful delivery of KYC and onboarding solutions.

British telecomm, System Analyst Jun 2017 - Jul 2021

●Gathered and analyzed requirements, prepared test plans, created test cases and monitored fixes in Agile environment using Jira, enhancing traceability and test coverage

●Automated approx. 2000+ end to end test scenarios using Selenium scripting using Java resulting in approximately reduction in manual regression testing efforts

●Collaborated with cross-functional teams, to understand use cases and develop comprehensive test scenarios leading to increase in bug-fix efficiency

●Managed repository version systems for code in Git hub, ensuring smooth code integration and deployment

●Developed visualizations and reports on tableau, enabling deep analyses into usability clicks, customer behavior, and navigational efficiency across client’s web portal

TECHNICAL SKILLS

Databases: Oracle Exadata, Oracle 10g, PL/SQL, Microsoft Access

Data Analysis & ETL: SQL (Complex Queries), ETL Pipelines, Data Validation Scripts, Data Modeling, Microsoft Excel

Agile & Project Tools: Agile Scrum Tools, Effort Estimation Tools, Resource Planning Tools

Client Onboarding & KYC: KYC Automation Tools, Reconciliation Workflows, Onboarding Data Integration

Testing & Quality Assurance: Test Scenario Design, Integration Testing

Business Intelligence & Reporting: Microsoft PowerPoint, Dashboard Creation (Excel/PowerPoint), Reporting Automation

EDUCATION

Master of Science, Business Analytics and Artificial Intelligence

The University of Texas at Dallas

Bachelor of Engineering, Computer Science Engineering

Anna University

PROJECTS

ICU Mortality Prediction Python

Built predictive models for ICU mortality using 91,713 patient records and 84 clinical variables, applying advanced imbalanced data techniques (SMOTE, Tomek Links, ADASYN) and feature selection to achieve a 0.91 concordance index and a 20% improvement in identifying minority cases over traditional APACHE methods.

Hand Injury Analysis Python Tableau

Performed EDA using Python and Tableau to analyze non-hospitalized amputation cases and identified top 5 high-risk machinery categories, enabling actionable health safety policies. Applied NLP techniques to extract top 10 recurring phrases and injury causes, driving recommendations for the manufacturing sector.

Consumer Behavior Analysis Market Research Market Research Python Excel Tableau

Conducted competitor research within FMCG sector and recommended marketing strategies to improve revenue and enhance product positioning. Implemented data-driven analysis through statistical modelling and data visualization.

CERTIFICATIONS

Certified Scrum Product Owner

Snowflake Platform Associate

Databricks Fundamentals

Contact this candidate