← В ленту
Middle
Регистрация: 22.05.2024

Kanaka Naga Akhil Potturi

Специализация: System / Business Analyst / Data Engineer
— System and Business Analyst with 7+ years of combined experience supporting financial services, healthcare, government, and enterprise data platforms. — Experienced in translating business needs into integration requirements, functional and technical specifications, API and file-interface mappings, validation rules, exception handling, non-functional requirements, UML process flows, and test scenarios. — Banking background includes payment gateway and processor integrations, card-transaction workflows, legacy-system analysis, reconciliation, and reporting for a Wells Fargo project. — Strong hands-on skills in Oracle SQL/PL/SQL, data mapping, REST/SOAP interfaces, JSON/XML payloads, JDBC connectivity, UAT support, defect analysis, and cross-functional delivery.
— System and Business Analyst with 7+ years of combined experience supporting financial services, healthcare, government, and enterprise data platforms. — Experienced in translating business needs into integration requirements, functional and technical specifications, API and file-interface mappings, validation rules, exception handling, non-functional requirements, UML process flows, and test scenarios. — Banking background includes payment gateway and processor integrations, card-transaction workflows, legacy-system analysis, reconciliation, and reporting for a Wells Fargo project. — Strong hands-on skills in Oracle SQL/PL/SQL, data mapping, REST/SOAP interfaces, JSON/XML payloads, JDBC connectivity, UAT support, defect analysis, and cross-functional delivery.

Скиллы

Python
Scala
Spark
Hadoop
AWS
SQL
RDBMS
DevOps Knowledge
GIT
HBase
HDFS
Hive
MapReduce
Pig
Yarn
Kafka
Zookeeper
Impala
Apache Sqoop
Apache Airflow
Hue
NiFi
Elasticsearch
Talend
SSIS
SSRS
Spark SQL
Data Frames
Data Sets
Kubernetes
Docker
Scikit-learn
Pandas
Matplotlib
MySQL
HTML/CSS
XML
JavaScript
JSON
UML Using MS Visio
Project Plan MS Project Plan
Power Builder
Tableau
Power BI
Amazon Web Services (AWS)
Azure
GCP
Data bricks
Visual Studio
Eclipse
Jenkins
GitHub
Snowflake

Опыт работы

Senior System Analyst
с 11.2025 - По настоящий момент |Mid-West Global Solutions – Enterprise Data Integration and Reporting Project
SQL, Oracle, SQL Server, Python, Power BI, REST APIs, JSON, XML, JDBC, ETL, Data Mapping, UML, Visio, Jira, Confluence, ServiceNow, UAT
● Gather and analyze reporting, data-exchange, operational, and system requirements from business users, program managers, and technical teams. ● Translate requirements into functional specifications, business rules, source-to-target mappings, acceptance criteria, validation rules, and process documentation. ● Document current-state and future-state system workflows, data movement, dependencies, exception paths, and integration requirements. ● Create UML sequence diagrams, use-case diagrams, process flows, and information-flow documentation. ● Analyze failed data loads, rejected records, duplicate values, missing keys, invalid relationships, and reporting discrepancies. ● Coordinate with application, database, ETL, QA, and business teams to resolve integration issues. ● Define and validate non-functional requirements related to performance, security, logging, availability, auditability, data retention, and recovery. ● Support SIT, UAT, defect tracking, release validation, and production issue resolution.
Data Reporting Analyst
03.2025 - 10.2025 |State of Tennessee – Department of Education
SQL, Excel, Power BI, SharePoint, Oracle, Data Mapping, Data Validation, Process Documentation, UAT, ServiceNow
● Gathered reporting and system requirements from program managers, business users, and technical teams. ● Analyzed data flows across state applications, databases, reports, Excel files, and SharePoint trackers. ● Created data mappings, business rules, validation procedures, process documentation, and test scenarios. ● Used SQL and Excel to verify data completeness, accuracy, consistency, duplicate records, and missing values. ● Investigated reporting, application, access, and data-quality issues and documented root causes, corrective actions, and retesting results. ● Supported UAT and release validation and communicated project updates to technical and non-technical stakeholders.
Business Systems Analyst
01.2023 - 02.2025 |Blue Cross Blue Shield – Healthcare Data Integration Project
Oracle, SQL Server, Snowflake, SQL, PL/SQL, Python, ETL, REST APIs, JSON, XML, SSIS, PySpark, Jira, ServiceNow, SIT, UAT
● Analyzed business and technical requirements for claims, eligibility, member, provider, and compliance-data integrations. ● Prepared source-to-target mappings, data dictionaries, transformation rules, validation requirements, and interface documentation. ● Developed and supported SQL and PL/SQL processes for data extraction, transformation, validation, reconciliation, and exception reporting. ● Investigated failed loads, rejected records, duplicate values, invalid codes, missing information, and reconciliation differences. ● Coordinated with business users, developers, database teams, ETL teams, and QA analysts to resolve integration issues. ● Supported SIT, UAT, regression testing, defect tracking, and production-release validation.
Business Analyst – Banking Integrations
12.2019 - 05.2020 |Wells Fargo – Banking and Payment Integration Project
REST APIs, SOAP, JSON, XML, JDBC, Oracle SQL, PL/SQL, UML, Sequence Diagrams, Use Case Diagrams, Visio, Jira, Confluence, Payment Gateways, Payment Processors, SIT, UAT
● Analyzed banking applications, payment-processing workflows, card transaction flows, and payment gateway and processor integrations. ● Gathered business and system requirements and translated them into functional and technical integration specifications. ● Documented request and response structures, field mappings, validation rules, error handling, transaction statuses, and reconciliation requirements. ● Created UML sequence diagrams, use-case diagrams, process flows, and system interaction documentation. ● Supported card transaction workflows involving authorization, routing, processor responses, clearing, settlement, reversals, refunds, and exception handling. ● Used Oracle SQL and PL/SQL for transaction-data validation, reconciliation, troubleshooting, and reporting. ● Prepared SIT and UAT test scenarios and worked with development and QA teams to resolve integration defects.

Образование

Information Technology Management
с 2026 - По настоящий момент
Belhaven University
Computer Science (Магистр)
2021 - 2022
University of Missouri Kansas City
Computer Science (Бакалавр)
2012 - 2016
Vellore Institute of Technology

Языки

АнглийскийСвободно владеюХиндиРодной