Senior Consultant
Hartford, Connecticut Area
• Develop custom client software applications with different platforms such as Java, Microsoft, TIBCO, and Informatica.• Developed TIBCO BusinessWorks and TIBCO Substation processes for customer loyalty project which communicate with WebSphere web applications, JMS and several databases. Used XSD to define message interfaces between affected systems. • Designed part of a travel and entertainment expense tracking data mart. Developed mappings for extracting data from source systems and loading into the data mart utilizing Informatica PowerMart. Documented the Design Architecture, Mapping Specifications, Session Flow, Session Restartability, and Target/Source Matrix. Modified data model and ETL processes for the addition of European Travel and Entertainment expenses. Documented the business process, ETL flows, job dependencies, and source/target definitions.• Designed error-handling strategy for data mart loads. Reviewed technical requirements documentation and assigned tasks to four ETL developers. Reviewed Informatica mappings to verify correct logic and improve mapping efficiency and reusability. Reviewed database with DBA to improve SQL query performance.• Developed Business Objects reports for Asset Allocation reporting. Optimized SQL query performance for quicker report presentation. Updated Oracle PL/SQL code for dimension loads. Coordinated and resolved issues with the release of Business Objects Universe and reports with client staff.• Converted, tested and migrated legacy Gemstone applications to WebSphere. Integrated outsourced code development for front end into the Storefronts J2EE application. Coordinated set up of WebSphere and Vignette production environments for deployment Storefronts application. Coordinated Quality Assurance testing for production releases. • Added new functionality in Java to customer profile survey application. Modified survey database schema to meet new requirements (SQL Server2000).