As a Senior Solutions Architect, my role is to provide technical expertise in the pre-sales stage to help deliver enterprise class open source solutions to customers in the public sector. I create possibilities, solve problems, and establish strategic relationships. My goal is to educate, assist, and enable my customers to leverage their existing IT infrastructure while building additional capabilities to deliver the best solution for their unique digital transformation needs.

• Led a team of five offshore developers to successfully deliver a data migration solution end to end in support of Time Warner’s merger with AT&T • Collaborated with business owners to produce reports for reconciliation of data between pre-merger and post-merger data warehouses, Managed UAT processes accordingly • Peer reviewed Informatica code and related scripts, developed/recoded when necessary • Architected data conversion to/from disparate XML, Netezza, SQL Server, Web Service data • Prepared test scripts and documents for unit, regression, cutover, and migration testing • Coordinated SDLC process through ServiceNow between offshore and onshore teams and reported progress to management

• Managed contractors for the delivery of data warehousing solutions using Informatica 9.6 and related Unix/stored procedure processes for a bi-temporal data management system with disparate source files and tables spread across internal departments and external vendors servicing 35,000 global users via Linux platforms using Sybase IQ and DB2 databases • Launched a new Informatica data warehouse domain, delivering associated training and enablement for developers and documentation, saving Goldman Sachs $2,000,000 for reduction of hours required to maintain prior state stored procedures and scripts • Spearheaded the automation of periodic and year-end event triggered processes, consequently streamlining processes, reducing hundreds of hours of manual labor and errors for repeatable processes • Administered production L1 and L3 level support to consumers of Human Capital Management data, delivered reports to management on quarterly performance of support service

Delivered data warehouse solutions including ETL development, administration, operations, maintenance and business intelligence reporting to various customers in commercial and government sectors.

Assisted with ADT/Tyco corporation split activity. Reverse engineered mappings from legacy environment into requirements and standards for new environment. Designed standardized mapping templates for migration to new environment based on analysis of requirements. Developed migration mappings using templates and retrofit custom templates the requirements into standardized templates. Generated test data and test cases based on business use cases. Executed tests and reported results, tested business object reports and compared to legacy reports. Performance tuned mappings and optimized run schedule

Developed ETL on aggressive 2 week Agile sprints. Performed business process analysis to derive requirements. Designed ingest processes from various internal and external departments and agencies in a top secret environment. Managed complete life cycle development from needs analysis, requirements documents, design, development, documentation, integration, testing, manual preparation, migration and training.

Utilized Melissa Data Software to geocode map data cleansed by IDQ. Assisted in integration and testing of ESRI/BING Map Geocoding Application. Architected data model and mappings for data marts and ETL development. Provided consulting on Web Service design and implementation on a large scale migration. Provided consulting on Threat Management system processes and reconciliation of data transfer. Automated FTP and SSH processes and workflow processes for HR and BSA data. Assisted in Oracle database upgrade and Triplet Cluster Migration. Upgraded Informatica Linux Server Platform from Version 8.6.1 to 9.1.1. Designed and managed operations, standards, and maintenance processes. Consulted on data governance and data cleansing throughout data lifecycle. Managed change management processes and procedures. Redesigned Threat Management System ETL process including consumption of Web Services, SSL Security, message/transport layer security, and provided consulting on best practices regarding Informatica Web Service utilities.

Designed ingest processes from various internal and external departments and agencies in a top secret environment. Managed complete life cycle development from needs analysis, requirements documents, design, development, documentation, integration, testing, manual preparation, migration and training. Designed, maintained, and modified Informatica PowerCenter mappings and workflows sourcing from SQL Sever and Oracle 10g in support of large Data Warehouse effort. Performed Informatica PowerCenter administration including security. Created and modified reports and universes and supporting projects within Business Objects. Developed production migration plans and procedures for Informatica ETL processes. Performed Informatica software upgrades, provide operations and maintenance. Administered Data Warehouse servers in relation to load recovery, performance tuning, configuration. Provided consulting on ETL best practices.

Consulting Site: Hong Kong Trade Dev Council:Reviewed RFP and assisted in technical solution design and documentation in competition with ORACLE and IBM. Consulted on MDM (Master Data Management) best practices and solutions. Presented solution to client on behalf of PEAK and ATOS in a sales meeting. Consulted on Data Governance in regards to its importance, processes, procedures, consequences.Consulting Site: Investment Tech Group:Installed and configured Informatica Version 9.1.1 on 6 Solaris servers. Designed and Implemented Informatica Server Grid functionality with High Availability.

Architected and developed an HR database that interfaced to a web-based GUI and populated the database using PowerCenter Designed, configured, and developed complex mappings/ETL logic using PowerCenter for various processes, data cleansing, and data integration. Designed and executed numerous reports, dashboards, and broadcasts using PowerAnalyzer. Developed scripts, routines, and queried various types of databases (SQL, DB2) for QA, debugging, and supplementing PowerCenter workflows. Deployed and baselined development modifications to AIX/UNIX environments using PVCS for testing, development, staging, QA, and production on nine servers. Performed PowerCenter software installations, upgrades, data migrations, and administration. Designed solutions for complex real time data integration needs throughout project lifecycle. Managed production support issues and monitored warehouse loading. Delivered a successful Go-Live within the aggressive deadline of 6 weeks. Led a group of consultants and developers for the timely system integration testing of large scale data conversion. Reported status, conducted peer reviews, provided mentoring, and performed project planning as Team Lead

Examined Patent Applications related to Computer Science, Computer/ Electrical Engineering, Computer Networking and Databases, Telecommunications. Searched EAST/WEST, IEEE, ACM databases for relevant Prior Art. Conducted a thorough technical study on subject matter of inventions under examination. Composed office actions discussing patentability of invention and comparison to relevant prior art. Consulted and negotiated claims of invention and application status with patent attorneys.

Composed complex Matlab software programs to perform debris mitigation modeling. Studied highly abstract pattern matching algorithms and presented to customer (BMDO, DoD). Researched radars, relevant search patterns, RCS, and documented research. Produced process flow diagrams and state charts to illustrate processes of benchmark software. Assisted in requirements definition and implementation of CMMI processes and procedures.

Performed sanity tests on hardware/software via a UNIX environment. Developed alternatives/workarounds for inefficiencies in testing/development process. Designed web page that posted results and updates regarding status and changes in software load/hardware.

Trained in Satellite Communications and passed certification exam. Performed frame relay tests on a Multi-Mode Mobile Messaging product. Collected and analyzed satellite signal data from the field. Documented all test results and conclusions in a deliverable report.