Harshitha Nayana

Sr Data Analyst @First Citizens Bank

Raleigh, NC, US

Migrated legacy Argos reports to modern SSRS and Power BI platforms, improving reporting accuracy and reducing report generation time by 30%.• Improved ETL efficiency by 25% through optimized SSIS workflows and enhanced SQL performance.• Used Informatica PowerCenter for data integration between on-premise systems and cloud-based storage solutions.• Developed Python scripts for automating data extraction, transformation, and validation, improving ETL pipeline efficiency.• Implemented Pandas and NumPy for data cleansing, aggregation, and preprocessing to enhance reporting accuracy.• Integrated Python-based APIs with AWS services like S3, Lambda, and Glue for seamless data processing and automation.• Designed and developed Informatica workflows and mappings to perform robust ETL processes, handling large volumes of structured and unstructured data.• Implemented complex data transformations and cleansing rules within Informatica, ensure high data quality & consistency.• Automated ETL workflows using Informatica Scheduler, improving job orchestration and reducing manual intervention.• Implemented AWS Glue for scalable ETL workflows, automating data extraction, transformation, and loading from on-premise systems to the cloud.• Utilized Amazon S3 for secure data storage and archival, enabling efficient data access for reporting and analytics.• Configured AWS Lambda functions to automate ETL triggers and Power BI dataset refreshes, ensuring real-time data availability.• Tuned Informatica sessions and optimized performance using partitioning, pushdown optimization, and parameterization.• Integrated Informatica with AWS services (S3, Redshift) for hybrid cloud data movement and transformation.• Automated data reconciliation and cube processing, reducing manual intervention and ensuring real-time insights.• Collaborated with business analysts to gather, analyze, and interpret business requirements, ensuring alignment with technical solutions.

University of New Haven

Master's degree, Business Analytics