Pasang L. Email & Phone Number

• Develop and implement Informatica-based ETL logic to support the sourcing, transformation, and analysis of data for F&G Retail Markets, enhancing decision-making across the organization.• Lead the creation of data integrations for DTCC, middleware, and distributor needs, ensuring seamless delivery of critical platforms and applications.• Collaborate with business partners to design scalable, maintainable solutions that solve complex problems and improve operational efficiency.• Manage daily production cycles and troubleshoot issues, ensuring high-quality data support and clear communication with IT and business stakeholders.

St Louis, Missouri, United States

During my tenure, I performed data migration for a Fortune 500 company using Informatica Power Center Client 10.1. I collaborated with business stakeholders to understand functional requirements, performed data profiling, created mapping, and converted data for 5 legacy applications.KEY ACHIEVEMENTS:• Designed, optimized, and managed 30 ETL workflows, resulting in the transfer of 6.5 million data records into an Oracle database• Developed and executed data conversion plans, achieving production deployment within a 24-hour timeframe• Led the data conversion team through 5 Dry Runs on the test environment, ensuring data pipeline reliability during the Go-Live• Monitored and tuned ETL processes to enhance data processing speed and efficiency, addressing bottlenecks and optimizing performance• Conducted validation and testing of deliverables, adhering to client-approved processes to ensure accuracy• Produced detailed data reports for leadership, providing insights into data quality metrics and ETL process performance• Provided post-implementation support, investigating and resolving reported data anomalies, inconsistencies, and discrepancies through JIRA issue-tracking software• Trained new hires on the data conversion process using Maximo Integration Framework• Contributed to Maximo integration efforts, deploying packages in the Migration Manager application and executing scripts for Go-Live readiness• Implemented Maximo system enhancements, such as database changes, workflow changes, configuration changes, automation scripts, and BIRT reports

Virginia, United States

Trained in a software engineering apprenticeship program where I developed full-stack Java applications using MVC design patterns while following Agile practices.KEY ACHIEVEMENTS:• Created dynamic front-end applications using JavaScript and AngularJS• Employed Servlet technologies to leverage the Front Controller design pattern• Utilized Spring Data and JDBC to handle data transfer between the server-side application and the database• Constructed a relational database using Oracle and SQL query language• Implemented SQL triggers and sequences to handle auto-incrementing primary keys

New York, New York, United States

Supported the Performance Analysis & Assessment team on projects and initiatives, demonstrating my ability to contribute effectively to various procurement endeavors. KEY ACHIEVEMENTS:• Conducted in-depth analysis of monthly reports and performed data mining to evaluate the performance of projects• Researched and introduced new, cost-effective commodities to enhance the agency's inventory management• Crafted user stories in Visual Studio Team Foundation Server 2015 for multiple e-procurement projects• Managed and updated the agency's website utilizing the Umbraco content management system, ensuring information remained current and accessible

New York, New York, United States

Interned in the data team helping Harlem RBI collect, manage, and process the organization’s data.KEY ACHIEVEMENTS:• Managed medium-sized data and survey entry tasks while working with the Apricot database• Collaborated with the Data department, contributing to special projects by recording and analyzing survey results which provided critical insights for informed decision-making• Assisted in the processing of summer enrollment applications and report card entries, effectively preparing and storing essential organizational data for streamlined operations