Analyze and troubleshoot production data issues to improve reporting accuracy and functionality. Overhaul the existing application data model to increase precision and efficiency in data handling. Engineer and execute ETL mappings in Informatica PowerCenter, tailoring configurations for new data integration. Lead unit and integration testing efforts to ensure the robustness and reliability of new data models and functionalities. Schedule batch jobs through AutoSys, optimizing system operations and workload management. Conduct in-depth analysis of datasets within MicroStrategy reports to derive actionable insights. Utilize SQL and stored procedures for data analysis and optimization. Implement configuration of inbuilt sourcing tools to integrate new data streams. Execute comprehensive unit and integration testing to ensure the accuracy of data solutions. Leverage Python scripting to implement unique use cases.Project is now concentrating to migrate existing ETL flows to informatica cloud idmc. Created and launched a revamped data model for the Dart (Data Incident Portal Data) application, significantly improving data integrity and user accessibility. Laid groundwork for designing and developing ETL mappings within PowerCenter to enhance Enterprise Data Management (EDM) capabilities. Overhauled a data control automation system that bypasses workflow execution in the event of data discrepancies, reducing downtime and improving system resilience.

Conducted comprehensive requirement analysis and architected mappings for enhanced data lake functionalities, ensuring precise and scalable solutions. Led the design, development, and deployment phases of Informatica jobs, maintaining high standards in unit testing and overall project delivery. Facilitated cross-functional collaboration to streamline the technological migration from Ab Initio to Informatica, identifying and implementing effective migration strategies. Pioneered the ETL development initiative for critical anti-money laundering and fraud detection applications within the banking sector, leveraging Informatica Power Center. Orchestrated data integration and management, advancing from traditional flat file systems to a Master Data Management (MDM) framework aligned with big data lake architectures. Engineered an innovative unit testing tool tailored for flat files, optimizing standard lake ingestion processes and improving testing efficiency and reliability.

Conducted comprehensive requirement analysis and crafted detailed design specifications leading to strategic code enhancements that boosted system performance in production environments. Developed and implemented automated Power BI reports, providing critical business insights and supporting strategic decision-making processes. Engineered and deployed new workflows in the centralized file transfer system, ensuring improved data integrity and system efficiency. Spearheaded the Middleware and RTB project, facilitating application support and seamless integration between Blackrock's Aladdin product and Asset Management applications, enhancing ETL processes within an Ab Initio continuous flow environment. Innovated and refined a tag validation script that streamlined code deployments, significantly reducing errors and deployment times. Revolutionized the centralized file transfer system through automation, achieving significant reductions in manual labor and enhancing operational efficiency. Advanced the performance of existing Ab Initio graphs, securing substantial gains in processing speed and accuracy, delivering considerable value to clients.

Facilitated application support initiatives for RISK, Mortgage, Finance, and Consumer applications within the Bank, focusing on critical incident resolution and performance enhancements. Collaborated with diverse teams to rectify data discrepancies and infrastructure issues, enhancing system integrity and data accuracy. Led the design and code reviews, ensuring seamless transitions of software artifacts to production environments while adhering to best practices for scalability and maintainability. Refined the LAKE Ingest framework and managed the seamless migration & integration of DIME code into the LAKE environment. Created a versatile tool for upgrading Co>Op versions in Ab Initio, streamlining updates and maintenance procedures. Engineered and implemented advanced automation strategies for batch processing optimization, boosting application efficiency and performance. Designed and introduced a suite of automation tools, including the Atlas file copy tool, Tag migration validation tool, and a comparative analysis tool for Prod vs QA CA7 environments. Initiated and executed a proof of concept in Talend for image processing, setting a precedent for future multimedia data handling capabilities.

Steered the foundational development of Customer 360 capabilities on the Oracle Big Data Appliance, integrating party and relationship data from 14 internal banking systems – centralizing customer and wholesale product information to enhance identification of parties and analysis of their relationships and product interactions. Coordinated the consolidation of diverse data sources to construct a unified view of customer relationships and product holdings, improving data accuracy and accessibility. Led a team in the execution of development tasks, including the efficient management of data loads to HDFS and the resolution of project-related issues, ensuring timely progress and adherence to project milestones. Championed the implementation of a scalable big data architecture, demonstrating the system's capacity for handling extensive datasets and supporting the Bank's strategic goals through advanced data analysis techniques. Innovated data integration processes by utilizing the cobol2j utility for seamless data injection into the cluster, enhancing data throughput and system reliability. Implemented automation of data workflows using the Oozie scheduler, which streamlined operations and reduced manual intervention, thereby increasing project efficiency and resource optimization.