Nikhila Vankayalapati
Kansas City,USA
Summary
Results-driven Data Analyst with 3+ years of experience collaborating with clients and cross-functional teams to deliver data-driven solutions. Skilled in mentoring, influencing through technical insights, and optimizing business outcomes through data modeling and process improvement. Adept at project management, adapting to evolving requirements, and driving impactful presentations for decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
ETL Data Analyst
Kelsey Seybold Clinic
06.2024 - Current
- Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
- Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
- Created Tableau views with complex calculations and hierarchies making it possible to analyze and obtain insights into large data sets
- Worked with data architect team to make appropriate changes to the data models
- Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
- Generates ETL scripts to transform, flatten, and enrich the data from source to target using AWS Glue and created event driven ETL pipelines with AWS Glue
- Utilized Tableau server to publish and share the reports with the business users
- Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups
Data Analyst
Accenture
07.2022 - 01.2023
- Worked with healthcare claims data and wrote SQL queries to organize the data and sorted, summarized, and reported salient changes within the datasets
- Evaluated and established the validity of incoming claims data and data element combinations to ensure accuracy and completeness of all reporting results
- Used analytic tools such as Tableau and SAS for healthcare data analysis and visualization
- Collibra Workflow development and configuration based on MS Data Governance Approach & Requirements
- Involved working in the area data management including Metadata, Data Analysis, Data Integrity and Data Mapping
- Utilized spark SQL to load data from AWS S3 to Snowflake tables using data bricks
- Created reports in various style format (RTF, PDF, Excel, and HTML) using ODS statements
Data Analyst
Perficient India Pvt Ltd
10.2020 - 07.2022
- Worked as Data Analyst at Perficient, Designed and developed logical and physical data models to support Data Marts and the Data Warehouse
- Analyzed and managed data in crucial healthcare modules, including Network, Plans, Eligibilityand Claims, to support business needs and decision-making
- Designed and maintained MySQL databases and created Data pipelines using user-defined functions and stored procedures for daily reporting tasks
- Developed and implemented databases, data collection systems and strategies that optimize statistical efficiency and quality
- Created data stories and visualizations using Power BI
- Performed Data analysis, statistical analysis, generated reports, listings, and graph using SAS tools SAS/Base, SAS/Macros and SAS/Graph, SAS/Access
- Developed highly interactive Data Visualization reports using multiple data sources and custom SQL queries
- Performed Data Cleaning, features scaling, features engineering using pandas and NumPy packages in python
Education
Master of Science - Computer Science
University of Missouri-Kansas City
Kansas City, MO05.2024
Bachelor of Technology - Computer Science and Engineering
Bharath University
Chennai, India05.2022
Skills
- Java
- Python
- SQL
- Oracle
- MySQL
- PostgreSQL
- MongoDB
- Snowflake
- AWS Services (EC2, S3, IAM)
- Linux / Windows
- Tableau
- Power BI
- C
- Git
- Agile methodologies
- Data Governance
SKILLS
· Database Management and Data Mapping
· Team Player and Leadership qualities.
· Quick learner and Strong problem-solving skills.
LINKEDIN URL
https://www.linkedin.com/in/nikhilareddyaccenture/
Certification
- AWS Certified Cloud Practitioner, 2024
- AWS Certified Solutions Architect – Associate, 2024
- Microsoft Power BI Data Analyst Associate
Timeline
ETL Data Analyst
Kelsey Seybold Clinic
06.2024 - Current
Data Analyst
Accenture
07.2022 - 01.2023
Data Analyst
Perficient India Pvt Ltd
10.2020 - 07.2022
Bachelor of Technology - Computer Science and Engineering
Bharath University
- AWS Certified Cloud Practitioner, 2024
- AWS Certified Solutions Architect – Associate, 2024
- Microsoft Power BI Data Analyst Associate
Master of Science - Computer Science
University of Missouri-Kansas City
Similar Profiles
Estefany RomeroEstefany Romero
Medical Assistant at Kelsey Seybold Clinic OB/GYNMedical Assistant at Kelsey Seybold Clinic OB/GYN
Nakia LafluerNakia Lafluer
Department Support Specialist II – OB/GYN Department at Kelsey-Seybold ClinicDepartment Support Specialist II – OB/GYN Department at Kelsey-Seybold Clinic
Lilia FloydLilia Floyd
Certified Medical Assistant at Kelsey-Seybold ClinicCertified Medical Assistant at Kelsey-Seybold Clinic