SKILLS:Informatica (Powercenter), Pentaho Data Integrator (Kettle), Embarcadero (E/R-Studio/Architect), Oracle 11g (SQL, PL/SQL, Toad), XML, Linux, Rally, Jenkins, GIT, AWS (cloud computing), MS ExcelDUTIES:- Brought onboard to build a data warehouse from the ground floor up- Delivered into production the 1st phase data warehouse by 15July deadline- Worked as a close-knit team in an agile environment, where we conduct daily scrums, are guided by user-stories, engage in 3-week sprints, complete defect tracking/resolution cycles, and manage sprint/product backlogs- Designed and automated a comprehensive process to reconcile all CSS daily transactional activity on the XML-based/information-bus platform, against confirmation reports from the Federal Reserve Bank of New York (FRBNY); this occurs twice daily in production to ensure both holdings and clearings of CSS securities match to the FED's recordations- Produced a conformed dimensional model with facts and measures to reflect key CSS business activity, and developed 10 major Informatica/ETL mappings and workflows to fully populate the resulting 15 star-schema tables- Provided the data feeds into Tableau-based, highly-graphical dashboards for executive managers to digest in a high-performance environment- Devised 3 programmatic, meta-data-based application frameworks to drive job control, error handling, and failure recovery- Tuned both the ETL code and database (via indexing, partitioning, pipeline/parallel processing) to provide efficient access paths to underlying data, mainly to support end-use queries and reports - Compiled a body of standards, best practices and design patterns - covering such elements as MD5-based delta-detection, dynamic table-lookups, and duplicate-checking - to ensure the highest quality of deliverable code that's very maintainable, flexible, and scalable

SKILLS:Informatica (Powercenter, Developer, IDQ/Analyst), Embarcadero (E/R-Studio/Architect), Oracle 11g (SQL, PL/SQL, Toad), Sharepoint, Remedy, IBM Doors, ClearQuest, MS Project, ExcelDUTIES:In-House Data Strategy (IHDS): May 2014 - Aug 2015- Led this project to gather property-management invoice data and deliver it to the business community for querying and analysis before the 2nd quarter 2015- Championed the internet-based (SFTP) method in which up to 1 gigabyte of data is transmitted daily from the external vendor to Fannie Mae- Accomplished the logical and physical database modeling activities to build the repository, comprising 42 relational tables, for storing and accessing the data- Established the human bridge among business analysts, ETL developers, system/acceptance testers, and business end-users- Devised an intricate, meta-data driven data-quality scheme to identify, record, report and analyze data errors and corrections Credit Data Repository (CDR): Nov 2013 - Apr 2014- Designed the slowly-changing-dimension (SCD) strategy to maintain a full history of credit-related data for as-of/aggregate/OLAP reporting- Coordinated with Enterprise Data Quality (EDQ) personnel to formulate and implement 12 core business rules for integrating DQ requirements into CDR- Produced 5 Informatica/ETL mappings to feed metrics into the BI tool where analysts can quantify defect rates and plan corrective measuresNational Underwriting Center Data Mart (NUCDM): Apr 2012 - Oct 2013- Designed and constructed NUCDM as a lifecycle-based, dimensional star-schema to track the - complete history of credit losses involving distressed loans- Pioneered an Ab Initio, RAD-based prototype to demonstrate NUCDM's capabilities, thus garnering broad user-acceptance at the outset of the project- Organized the detailed analysis, extracting, transforming, and loading of the 10 major sources of data, required to capture and/or derive over 2500 attributes

SKILLS:Kalido (DW Manager), Ab Initio (GDE/EME), Oracle 10g (SQL, PL/SQL, Toad), XML Path, Essbase, Unix, Autosys, Mercury QualityCenter, IBM ClearCase, MS Access, ExcelDUTIES:Financial Data Warehouse (FDW): Jan 2007 - Mar 2012- Developed the FDW to enable debt, loan, and securities portfolios to be effectively managed, and to drive financial reporting and risk analyses- Programmed the ETL components, made up of 9 main Ab Initio graphs, to populate a comprehensive portfolio-management system, derived from the base FDW repository- Constructed a 14-table dedicated data mart to furnish liability-related financial information to consumers for managing FM's extensive bond and derivative trading business- Integrated a 10-table dimensional model for corporate planning/accounting personnel to capture and measure budget vs. actual administrative expenses

SKILLS:Kalido (DW Manager), Essbase, Business Objects, Data Integrator, Oracle 9i (SQL, PL/SQL, SQR, SQL*Windows/Centura), Excel (VB Macros), Unix (Korn shell scripting) DUTIES:Data Warehouse Phase 2: 2001 - 2007- Received in 2005 Intelsat's annual CEO award for excellent achievements in leading the Business Intelligence initiative for customer service/support- Converted the existing DW from a custom-ETL and Essbase platform to a Kalido and Business Objects architecture to better fulfill fast-growing needs- Integrated critical elements of merger Panamsat's business data into an extended DW to measure sales, orders, revenues, and satellite bandwidthData Warehouse Phase 1: 1996 - 2001- Became a founding member of Intelsat's emergent DW, BI, and IA practices, for developing solutions in three main subject areas: 1) Sales & Marketing, 2) Financial Management, and 3) Satellite Traffic- Led the development and testing teams to construct Intelsat's 1st DW environment in an Oracle RDBMS, coupled with the new Essbase multi-dimensional cube technology for delivering data to consumers