Ananya Tripathi

PROJECT NAME: BANK OF BARODA

DOMAIN: BANKING

• Optimized SQL queries across Oracle and Hive to improve data retrieval speed and execution efficiency for large-scale banking datasets.
• Improved query performance by 40%, reducing runtime and supporting faster decision-making for the banking client. Used stored procedures, joins, subqueries, and aggregation functions for efficient data extraction.
• Developed and executed complex SQL and Spark queries to load, transform, and validate structured data into enterprise-level data tables.
• Worked with Hive and Spark for distributed data processing, enabling faster and scalable ETL workflows in a big data environment.
• Collaborated with cross-functional teams to troubleshoot and resolve performance bottlenecks in Oracle, Hive, and Spark-based pipelines.
• Ensured data accuracy and consistency by implementing automated data validation checks during load processes across Spark, Hive, and Oracle platforms.
• Designed and developed Informatica mappings to extract, transform, and load data from various sources into target data warehouses, supporting critical banking operations.
• Optimized ETL workflows in Informatica by implementing reusable transformations and efficient data flow logic, improving performance and maintainability.
• Created basic Linux shell scripts to automate routine data loading, file management, and job scheduling tasks, enhancing workflow efficiency in the ETL process.
• Worked on Stonebranch to automate end-to-end data loading processes, reducing manual intervention and ensuring timely data availability.
• Designed and implemented workflows in Stonebranch to orchestrate ETL tasks, integrating tools like Informatica, shell scripts, and database jobs seamlessly.
• Worked closely with clients in the banking domain to gather requirements, provide updates, and ensure data solutions aligned with business needs, demonstrating strong communication and collaboration skills.

• Designed and developed a dynamic Event Management System using HTML, CSS, PHP, and MySQL to efficiently manage and organize college events, reducing manual coordination by 40% and ensuring smoother event execution.
  
• Built key functionalities such as event creation, participant registration, user authentication, admin control panels, and automated email notifications, significantly improving event tracking and user experience for both students and faculty.
  
• Collaborated with college event teams to gather functional requirements, tested the system for performance and usability, and deployed it successfully on a local server, receiving positive feedback for enhancing transparency and communication in event workflows.

• Assisted in planning and executing digital marketing campaigns across social media and web platforms, helping increase brand visibility and audience interaction through consistent, targeted content strategies.
  
• Developed a strong understanding of “reach” as a core marketing concept, recognizing that effective marketing involves influencing customer perception and guiding their thought process toward the value of a product or service.
  
• Learned to approach marketing as a strategic and creative process, shifting from the idea of simple promotion to viewing it as a thoughtful engagement with the audience—using messaging, timing, and content to build interest and trust.