Jason Leclair Email & Phone Number

Omaha, Nebraska, United States

Currently working in AWS as Mutual of Omaha modernizes claims processing. Supporting claims initialization, claims processing and integrating claims data back into the Mutual of Omaha reporting environment.Initially, I processed data updates from data warehouse to Salesforce using Informatica in support of sales agents in the field.

Greater Omaha Area

• Create and maintain data transformation jobs in order to link various operational and accounting systems using Informatica PowerCenter ETL, Oracle PL/SQL, SQL Server T-SQL and customer Access and Excel applications.
• Designed and produced the automated process to transfer commodities contracts, tickets, A/R and A/P from legacy platforms to the core grain operational system.
• Actively supported the transfer of data from the legacy platform to the core grain operational system.
• Enhanced numerous Access and Excel applications in order to increase automation and security of impacted processes.

Completely re-structured and automated the processing of incoming benefits files into Payflex's primary system.In addition, automated/streamlined the process for generating Open Enrollment packets for COBRA participants and retirees.

Greater Omaha Area

• Maintained and enhanced Informatica PowerCenter ETL mappings and sessions to proactively improve quality and scalability. Created new Informatica PowerCenter ETL mappings and sessions. Provided after hours monitoring.
• Designed an automated process to load travel agent data received from various travel consortia, drastically reducing the number of man hours involved in maintaining this data on a monthly basis.
• Supported the revenue optimization project by converting a manually run SQL script into an ETL workflow reducing the processing time by approximately 5 hours each day.
• Developed the travel agent commission payment workflow to vendor specifications, including support for FedRooms (a federal travel program) and for the Pay for Performance model. The subsequent reporting impacted up to.
• Produced a custom process to track and support SalesForce.com reporting and data maintenance for the WorldWide Sales department.

Greater Omaha Area

• Provided first level support for the company’s automated online booking and dedicated interfaces which involved establishing data standards and acting as the primary point of contact for distribution partners..
• Managed the elimination of costly legacy processes used to manually handle failed booking transactions and the loading of hotel rates and availability into the four largest distribution networks. The elimination of.
• Primary point of contact for Expedia, Travelocity and the internal operational staff while implementing a dedicated shopping and booking interface with each partner.

Greater Omaha Area

• Managed a 4-person team of project managers responsible for all automated booking interface related assignments. Translated business requirements into technical specifications and established overarching operational.
• Automated and directed the testing of business applications to better manage staffing and turn-around time.
• Spearheaded a project to extract and compile log file data in creating a reporting database used by both Operations and Customer Service for troubleshooting purposes, significantly reducing the number of research.

Greater Omaha Area

Provided technical and analytical support for GDS and data processing departments.

Various

• Troubleshot aviation electronic failures to component level.
• Programmed custom tests to isolate specific circuits in test bench and/or electronic equipment.