Data Analyst
CurrentUtilized Python scripting and advanced SQL queries to automate data validation and cleaning processes, enhancing data quality and streamlining data preparation for analysis, which improved overall data integrity and analysis efficiency. Developed Extract, Transform, Load (ETL) processes leveraging Informatica and Python scripts and significantly reduced processing time and ensured seamless data extraction, transformation, and loading into target databases. Designed and developed over 25 interactive dashboards and detailed reports in MS Excel, visualizing complex data sets to provide actionable insights to stakeholders Applied ETL software Informatica, APIs, and middleware for seamless data flow and integration between different applications and systems, enhancing data accessibility and usability. Implemented rigorous data quality standards and governance processes to ensure data integrity, cleanliness, and security throughout the data integration lifecycle, reducing errors and ensuring compliance with regulatory requirements. Conducted data mining, data cleansing, and statistical analysis to identify trends, patterns, and relationships within data sets, extracting valuable insights that informed business strategies and decision-making. Developed and maintained SQL databases using MySQL, optimizing over 50+ queries for efficient data retrieval and storage in a customer relationship management (CRM) system upgrade project. Implemented a Python script that automated the financial reconciliation process, reducing manual effort by 20 hours per month. Maintained version control using GitHub, ensuring documentation and tracking of code changes across 5+ projects throughout the project lifecycle, enabling seamless collaboration with development teams.Utilized AWS services such as RDS and RedShift to design and automate data pipelines, integrating CloudWatch to monitor and optimize data workflows and reduce manual processes.
