PROFESSIONAL SUMMARY

Senior IT professional with over 20 years of experience and 15 years providing consulting services to the federal, public and private sector. Technical expertise includes Systems and Software Engineering, Enterprise Architecture with focus on data architecture and analysis, data conversion and migration, data warehouse design and construction of Operational Data Store ODS through Extraction, Transformation and load ETL techniques. Demonstrated expertise in creating and implementing Data Warehouse star schemas, Data Marts, Metadata Management for Business Intelligence and Analytical Reporting. Has practical knowledge of the major relevant architectural framework such as: Zachman Enterprise Architecture Framework, Federal Enterprise Architecture Framework FEAF , Joint Architecture Reference Model JARM , Department of Defense Architecture Framework DoDAF and the Ralph Kimball Dimensional modeling approach. Mr. Ky possesses an exceptional combination of communication skill, technical and business skills. He is an experienced technical Lead and Technical Project Manager.

SKILLS HIGHLIGHT

• Management/Leadership Skills: Technical Project Manager, Technical Lead, Scrum Agile Methodology
• Life Cycle Expertise: Information Technology Infrastructure Library ITIL V3 , Federal Enterprise Architect Framework FEAF , Department of Defense Architecture Framework DoDAF , NIST Enterprise Architecture Model, Service Oriented Architecture SOA Framework, Unified Modeling Language diagrams UML
• RDBMS/ERP: Oracle /8i/9i/10g, PLSQL, Oracle Fusion Middleware, Microsoft SQL Server 7, 00, 05, Big Data Hadoop/MapReduce
• Business Intelligence OLAP Reporting: Business Objects: WebI, Cognos: Impromptu, Oracle Discovery
• ETL Tools: Oracle Warehouse builder OWB , Data Transformation Service DTS , Informatica PowerCenter,
• Open Sources ETL: Talend, Pentaho
• Data Modeling: ERwin, System Architect, Oracle Developer, Oracle Designer, Quest-TOAD, Embarcadero, Microsoft Visio
• Use Cases: RATIONAL ROSE: ClearCase, Microsoft Visio, Popkins, System Architect, Metis Troux Architect modeling tool
• Operating Systems: Windows, Unix Sun Solaris, Redhat Linux, MS-DOS, Apple Mac OS

Development Environment: Java 2 Platform Enterprise Edition J2EE , Microsoft .NET

PROJECT EXPERIENCE

BAE Systems, Data Migration Lead

• ISR Common lead at DCGS/EFT provided expertise in all architectural related tasks, assisted with SvcV-4/SvcV-5/OV-5 and related DoDAF service refinement tasks with Functional Teams GEOINT, SIGINT, HUMINT, and MASINT and PoRs family of services. Lead Data Calls mapping effort for NSG Expeditionary Architecture NEA and the Intelligence Community IC for service discovery. Worked with latest Cloud and SOA technologies in the Defense Intelligence Information Enterprise DI2E environment.
• Data Migration Lead at RTM created tool selection criteria matrix to choose adequate ETL application for project. Participated in vendors proof of concept demonstration. Provided technical expertise and guidance for the installation of Oracle Warehouse Builder OWB . Assessed customer legacy schemas and analyzed target schemas for data mapping. Worked with proposal team for scope definition of RTM 3.0 Enterprise Capabilities, and Technical Baseline Architecture for the Request For Information RFI Response.

Systems/Enterprise Architect

• Leading the system architecture effort for the FBI and the IC Enterprise Resource Planning ERP . Developed, analyzed and provided recommendations on alternative strategies to determine optimal path for architectural solutions.
• Performed assessment of the FBI Program Management Office PMO . Facilitated working sessions with FBI SMEs and Stakeholders to capture technical baseline requirements
• Leveraged the Federal Enterprise Architect Framework FEAF to capture Business, Data, Technical Service and Security Reference Models requirements artifacts BRM, DRM, SRM, and TRM . Created initial draft of the FBI Human Resource Information System HRIS target architecture Conceptual Logical . Created HW/SW virtualization architecture as well as Data Migration and Business Intelligence HW/SW Architecture. Developed Software Requirements Specification SRS document.

Oracle Fusion Middleware Architect

• Led and participated in database architecture design and implementation for Oracle WebLogic Server infrastructure for an Operations Maintenance environment at the Bureau of Alcohol, Tobacco, Firearms and Explosives ATF .
• Provided configuration and troubleshooting assistance for the deployment and installation of various distributed Oracle applications, Oracle Platform Security Services, Oracle Access Manager and Oracle Identity Manager on Oracle WebLogic Server Platform. Assisted with the creation of related domains and related schemas and tablespace mappings by using the Oracle Repository Creation Utility RCU . Led and participated in Data modeling and Data Mart architecture initiatives object conceptual, logical and physical , data analysis and management of metadata models/data dictionary. Analyzed, resolved or recommended solutions to highly complex technical problems such, as performance issues, reliability issues, and data quality issues. Participated in database upgrade process from Oracle 11g to future releases . Influence and educate project teams on the importance of good data management/governance practices.

Systems/Enterprise Data Architect

Systems Engineer supporting the FBI Program Management Office PMO of the FBI Administrative Program Unit responsibilities include: Leading the data integration effort for the Enterprise Project Portfolio Management tool implementation at the FBI Office of IT Program Management Branch ITB . Facilitated JAD sessions for high level requirements gathering. Leveraged the FBI Life Cycle Management LCM and the Federal Enterprise Architect Framework FEAF reference models to uncover and map relevant data entities to the FBI Information and Technology Branch ITB Business Processes and functional areas. Assessed baseline system to create transitional and target architecture. Created tool selection template and criteria for evaluating and selecting the appropriate application for the Enterprise PMO implementation. Established a Data Governance and Stewardships presence across the PMO.

Sr. Data Warehouse Architect

Technical Lead for the Data Warehouse implementation for the Submarine Maintenance Automation and Communications System SMACS . Organized Joint Application Development with data sources subject matter experts to ensure the proper capture of legacy data. Coordinated the design of the consolidated data model, identifying integration points with the data sources. Created conceptual, logical and physical Star Schema data models to create the data warehouse. Designed, developed and implemented the enterprise system architecture for all ETL strategies source, staging and target data movement to be integrated with the NAVY Federated Data Warehouse Enterprise Architecture. Reviewed ETL requirements, defined and participated in ETL governance for standards and architecture for the project. Performed hands-on of ETL performance tuning with Oracle Warehouse Builder application tool.

Senior Data Warehouse Architect

Responsible for the Design and Implementation phase of an Enterprise Data Warehouse EDW for the Bureau of Information Resource Management IRM at the Department of State, bringing together information from three historical data sources into an integrated enterprise data warehouse. Lead a team of developers to design develop and document the contextual, conceptual and logical data models and data dictionary for the Enterprise Data Warehouse. Provided technical expertise for the creation of the ICD Interface Control Document , the Memorandum of Understanding MOU between EDW and the Department of State and for the definition of the System Design Documentation SDD .

Technical Project Manager and Senior Data Architect Lead

Leading a mandate from the Chief Technology Officer CTO of the Defense Security System DSS for providing systems architecture and integration technical expertise to facilitate the migration from legacy systems to an enterprise solution of the following three legacy systems: The Joint Personnel Adjudication System JPAS the Industrial security facilities database ISFD- and the Defense Counterintelligence Information DCII . Responsible for defining/refining the overall systems architecture concept, determining the enterprise and system standards, providing integration guidance to developers, championing and enforcing the service-oriented architectural approach, overseeing systems and components refinements, and providing assessments of architectural changes at the enterprise and system level. Exposed to Metis Troux and System Architect modeling tool.

Data Warehouse Architect,

• Assessed the feasibility study of the FBI Enterprise data Warehouse at the Engineering and Research Facility ERF . Performed a S.W.O.T Strength, Weakness, Opportunities, and Threats analysis of the EDMS Electronic Data Management System for the purpose of uncovering functional areas to model the data warehouse subject areas and display SOA components. Presented the deliverable of work break down structures WBS of the data warehouse implementation tasks and a white paper to upper management
• Responsible for creating, designing and implementing a large-scale data warehouse to support the CIFA Intelligence Community.
• Created requirement documentation analysis and conducted interviews with technical leads and business users' community in order to identify warehouse subject areas. Lead the development of logical data model and physical database design model with associated documentation. Lead the development of source-to-target data mapping, all related ETL efforts to populate the target data warehouse.

Science Application International Corporation, Senior Database Engineer,

Led the software/systems architecture and design efforts to share C4I/C2 logistics data in the context of information assurance among Coalition/US partners. Responsible for creating, designing, implementing the administration of large-scale computerized databases using state of the art technologies to determine Intrusion Detection System IDS data connections and data sharing in support of national security objectives. Experienced user of the Rational RequisitePro and Rational Rose application tools: mediate Joint Application Development JAD sessions with developers and SMEs to capture metadata and business rules definition.

Senior Technical Consultant

Contracted with Government Agencies, Educational Institutions and Health Care Institutions for development, design, and implementation of Client/Server applications for ERP systems.