- Engaged in all project phases using Agile methodology, from requirements gathering to testing and implementation, with daily scrums and bi-weekly sprint planning.- Built reports from user stories and created interactive Tableau dashboards to provide key business insights.- Developed data quality rules and exception handling using Informatica Data Quality and performed data validation.- Designed and implemented data extraction, transformation, and loading (ETL) processes using Informatica PowerCenter and PowerExchange.- Utilized AWS Data Pipeline and Python to streamline data migration, enhance reporting processes, and support decision-making.- Developed RESTful APIs using Python, Flask, and Django, integrating various data sources (Java, JDBC, RDBMS, shell scripts, and flat files) for seamless data processing.- Wrote technical documentation for ETL processes, ensuring consistency and adherence to naming standards.

- Designed and developed interactive dashboards in Power BI to provide real-time business insights and support data-driven decision-making.- Extracted data from various sources, including JSON files and mainframe flat files, and transformed it into usable formats for reporting and analysis.- Developed and maintained reports using Teradata SQL and MS Excel, including Weekly, Monthly, and Quarterly Business Monitoring reports.- Worked with multiple data sources (including Teradata, Oracle, SAS, and SQL Server) to deliver business-critical reports and facilitate cross-team collaboration.

- Led migration and gap analysis between legacy systems and new platforms, identifying and resolving issues to ensure smooth data integration.- Built and optimized ETL pipelines for AWS S3 and Redshift, using Python, UNIX scripting, and SQL to automate data loading and business logic execution.- Performed data profiling and source-to-target mapping for conversion processes, ensuring data accuracy and integrity.- Wrote and optimized SQL/PLSQL scripts for data validation and transformation, ensuring alignment with business requirements and maintaining data quality.- Coordinated with offshore teams to track progress, provide updates, and resolve project issues, ensuring on-time delivery.

- Wrote SQL statements to extract data from SQL Server databases.- Managed the research and data analytics team.- Developed yearly reports and presented them to the Board of Directors.- Gathered, analyzed, and interpreted research data, and built reports.- Created questionnaires and collected responses via SurveyMonkey and from the community.- Developed data collection and analysis plans, and conducted analysis of datasets using various statistical techniques in SPSS and Excel.- Wrote scientific manuscripts and grant applications.