­­­­­­­­­­­­­­­­­­­­­­­­­­

SUMMARY:

Twenty years of proven US experience and one year of International experience to include Federal Information Technology projects. Large US corporations experience as Information Technology Leader/Project Manager/Chief Systems Engineer/Data Architect, Enterprise Architect, Technical Advisor, Data warehouse Architect, and DBA.

TECHNICAL SKILLS:

Technology Areas: IT Project Management, Data Architecture, Database Systems Engineering/ Integration/Architecture/Strategy/Roadmap/Assessments/Concept of Operations, Enterprise Architecture (based on FEAF), Enterprise Relational/OLTP database and Dimensional data models/data warehouse design, ETL, Business Intelligence Reporting Analytics (Dashboards/Scorecards, Predictive Analytics, Reports), ERP - Oracle Federal Financials, Database Administration, Service Oriented Architecture (SOA), Business Process Management (BPM), Data Quality/Profiling, Data Governance/Stewardship, Metadata Management, Master Data Management (MDM), Artificial Intelligence/Expert Systems/Neural Networks, Data Mining, Machine Learning, Predictive Analytics, Big Data Analytics, Hadoop framework, NoSQL.

COTS Tools Experience/Knowledge: MS SQL Server, MySQL, Oracle 11g RDBMS, Oracle BPM, Oracle Federal Financials, Oracle OBIEE, Oracle PL/SQL, SQL Plus, Informatica (Power Center 9.x, Data Quality - IDQ, MDM, Identity Resolution-IIR, Metadata Manager - IMM), Business Objects, Cognos, Tableau, Toad, IBM Rational Team Concert for Agile, CA Rally for Agile, CA Erwin ERx/BPx, IBM InfoSphere Data Architect, ER Studio Data Architect, Cloudera Data Hub (for Big Data), Hadoop (Hive, Pig, Impala, Flume, Kafka, HDFS, MapReduce, Spark).

PROFESSIONAL WORK EXPERIENCE:

Confidential, Ashburn, VA

Chief Architect

Responsibilities:

• Defined data collection and trip management system (TMS) data architecture consisting of the OLTP database and data warehouse design to collect, ingest, and report NOAA data related to commercial and recreational fishing trips at Federal and state level.
• Defined TMS SOA architecture based on Oracle APEX and web services API based on RESTful services and JSON data format for data collection, validation, and ingestion into the OLTP database. The historical data is archived and summarized in a data warehouse that support data reporting capabilities and data quality reports generation.
• Working directly with the customer, briefing on architecture and technical status as well as designing data models in discussions with the NOAA SMEs.
• Technical environment: Oracle 12c, Oracle APEX 5.0 REST services with JASON data format, ER Studio for data modeling, Oracle PL/SQL for data transformation and load, SQL developer for PL/SQL development.

Confidential

Sr. Data Architect/Technical Advisor/SME

Responsibilities:

• Leading data architecture work involving defining history tracking solution, data flows definitions, and data modeling to capture history data and reporting models.
• Agile methodology approach to the design and development of solution, using Rally for Agile project management methodology and daily scrum.
• Supporting Enterprise Data Architecture Division, and collaborating with other organizations of the Confidential .
• Used data modeling tools Erwin Erx, ER Studio, Toad for Oracle, Toad for MySQL, MySQL, Oracle databases to define models, generate DDLs, for MySQL and Oracle databases.

Confidential

Responsibilities:

• Data architecture support to the Enterprise Data Architecture Division on Patent End to End (PE2E) Docket Application Viewer (DAV) Project.
• Attend daily scrum for development teams, determine data requirements based on DAV Sprint user stories, and discuss data needs with the development team to determine data model needs of the DAV project. Successfully deliver accurate data model updates to the development team even at short notice turn around.
• Define/update/manage three large data models in MySQL using IBM IDA data modeling tool complying with the Confidential set data architecture standards and naming convention and applying best industry practices for data modeling and fully constrained data model.
• Successfully migrated the PE2E DAV application data models for MySQL database platform from IBM IDA to ER Studio Data Architect tool accurately maintaining the data model diagram and table structures etc. consistent with the original data model.
• Participated in the DAV application workflow and Hierarchical Finite State Machine (HFSM) discussions, as well as Role based access control (RBAC) meetings with various stake holders including DAV Application Chief Architect.
• Performed DAV data profiling, model verification and testing MySQL DDL scripts in Toad for MySQL. Performed DAV source system (PALM) data profiling using Toad for Oracle.
• Worked with Perl scripts for making batch corrections to DDL scripts to conform to the Confidential data architecture standards.
• Weekly Status presentation/meeting with the customer.

Confidential, Herndon, VA

Chief Engineer & Data Architect

Responsibilities:

• Provided technical leadership, scrum master, and data architect for end to end development of a large and complex Enterprise Data Warehouse redesign and big data solution using Agile scrum based SDLC project for VBA covering several lines of business. Technically led development team to include subcontractors for design, ETL, business intelligence, test, deployment, operations and maintenance, and DBA.
• Led and facilitated discussions with SME/user/Line of business representatives for reporting and data Requirements/Scope determination, Gap analysis (between Baseline and Target Architecture), Conceptual, Logical and Physical Data Model design, and Source-Target/ETL Mappings of Enterprise Data Warehouse model.
• Provided specific guidance, clarification, problem resolution, answered questions and mentoring to include ETL and OBIEE developers as well as DBA team.
• Performed multidimensional data modeling, data profiling, metadata management and data governance on the project.
• Scrum Master on the project for design and implementation team of the data warehouse redesign.
• Created and presented architecture and data warehouse design and other technical presentations, technical/project discussions, and weekly status to the senior government customers.
• Well versed with IBM Rational Team Concert for managing the Product/Sprint backlog/defining epic, stories, tasks, story point and tracking progress etc.
• Advised customer/supported with SAS for simulation and modeling/forecasting and correlation/ data mining of data sets related to the claims processing.
• Provided Technical leadership and project management for development of a big data solution system to demonstrate use of Hadoop ecosystem (consisting of HDFS, Pig, Hive, and Impala to process large data sets on a multi-node cluster using Amazon Web Services. The prototype offered use of several large data files on veteran benefits directly loaded into Hadoop file system and processed using Pig and Hive in a batch mode and produce results that were transferred back to the Oracle relational database using Apache Sqoop. Large fact tables data from relational and unstructured/semi-structured and unstructured (text) files were loaded in Hadoop and interactive queries run in Impala for real time analytics results. The system was designed so the user could transfer analytical results back to the EDW using Sqoop and generate report. The Hadoop system was setup, configured to work with 4 node cluster (provided by AWS cloud) using Cloudera platform for Hadoop (Cloudera Manager and Enterprise Data Hub) running on Cloudera virtual machine.

Software Tools used: Oracle 11g, Oracle OBIEE, CA Erwin Erx/Power Designer, Informatica Power Center 9.x, Informatica Data Quality, Informatica Identity Resolution, Toad, IBM Rational Team Concert for Agile/CM, SAS (for Data Mining), IBM InfoSphere Data Architect, Hadoop ecosystem/Cloudera Data Hub (CDH) with Cloudera Manager, and Amazon Web Service (AWS)/Elastic Compute Cloud (EC2).

Confidential, McLean, VA

Lead Consultant

Responsibilities:

• Created a Data Quality Implementation strategy for a comprehensive data quality framework, starting with assessing and monitoring (including profiling) data quality of Electronic Immigration System (ELIS). The strategy included specific roadmap on phased approach for near, mid and long term planned implementation activities.
• Determined data quality dimensions, measures, attributes, and designed model to drive and store data quality assessment of ELIS data for display as a dashboard. The data quality monitoring solution envisions flexible design with custom code development for DQ assessment. The strategy leverages ELIS reporting environment, and Data Governance consisting of ELIS Data Steward and Data Change Request process to implement a low cost solution in the near term.

Confidential

Technical Advisor

Responsibilities:

• Provided acquisition support by determining business/technical requirements for the information system acquisition by CPI to implement the Sunshine Act and policies.
• Supported architecture for data virtualization and MDM for CMS enterprise.

Confidential

Data warehouse Integration Project, Chief Architect

Responsibilities:

• Defined Data warehouse Integration Implementation plan and provided very specific recommendations to integrate two large data warehouses EDW and CIRIS into a single integrated Enterprise Data Warehouse, followed by more data warehouses to be integrated into the target integrated data warehouse.
• Recommended schema, ETL and data level integration of the two data warehouses with several Star/Snowflake dimensional models, over 100 dimensions and 10 fact tables following Kimball’s bus architecture with conformed dimensions.
• Defined end to end integration plan with technical roles and responsibilities. Created Data warehouse Integration Implementation Plan document that documented the approach, analysis, and specific recommendations. Presented findings, approach, analysis, recommendations and status to the customer.

Confidential

Data Warehouse SME

Responsibilities:

• Contributed to defining key components of Army Medical Operations Data System (MODS) Data warehouse Concept of Operations document.
• Task lead on two tasks: VRM Master Data Management (MDM) Risk Assessment and Master Data Management (MDM) Implementation Requirements, using existing COTS (Informatica) tools for MDM Implementation of Veteran data.

Confidential

Data Architecture Project, Chief Data Architect

Responsibilities:

• Provided data/systems architecture on as-is and to-be architecture, including risk analysis mitigation, impact analysis by gathering information and creating AS-IS/PLANNED VBA enterprise architecture systems diagram showing information exchanges (internal/external) and subject area data in the context of various Lines of Business (LOBs).
• Captured VBA Systems environment details, meta-data and data exchanges information in couple of spreadsheets to analyze environment and information exchanges. Scheduled and Led information gathering sessions with several VBA SMEs, Senior Staff and Lines of Business on systems and data exchanges. This followed DoDAF v2.0
• Provided VBA SME expertise to create a VBA Benefit Segment Architecture (BSA), and Systems to Subject Area Data Mapping. This was based on DoDAF v2.0.

Confidential

Enterprise Data Architecture Project, Senior System Architect

Responsibilities:

• Provided Enterprise/Data Architecture Support to Confidential CIO Office, Office of Information Management, Office of Commissioner - Food Safety Initiative Office.
• Liaison to the Confidential Enterprise Architecture team.
• Architecture assessment included AS-IS Enterprise Architecture Capture, created Confidential Systems as-is/as-planned Data Flow Diagrams, and Business Process Flow. Created and presented business transformation approach/strategy to Confidential Senior Management.
• Organized and led meetings with Confidential SMEs for information gathering on Systems, Information exchanges, Confidential business processes and segment architecture.

Confidential

Senior Data Architect

Responsibilities:

• Business Process Modeling Guidance/Support, Data Governance Strategy & Framework, Project Management Support, Recommend Data Policy, Data Management Plan, Liaison with Confidential Enterprise Data Management Office (EDMO), Tools assessment/ recommendation for Enterprise Data Profiling and Quality Improvement.

Confidential

Technical Advisor and Liaison

Responsibilities:

• Led Confidential Science and Technology Engineering support. Liaison between Confidential Infrastructure Protection R&D Project Office and Confidential S&T Division.
• SME/Support on various Confidential Capstone IPT/Working groups.

Confidential

Oracle SME

Responsibilities:

• Led ADIS application (database design /technology/performance) assessment by interviewing several Subject Matter Experts (SMEs) on the application, analyzing architecture information, and provided findings and recommendations.

Confidential, Arlington, VA

Director, Enterprise Applications and Data warehouse

Responsibilities:

• Architected/Designed a Service Oriented Architecture (SOA) solution that allows remote users (in ships etc.) on low bandwidth network to schedule standard reports queries offline and submit for execution as well as view reports when online, to be run on Asset Visibility System developed. Led a three person team to develop the prototype system.

Tools: /environment: Oracle 10g, Oracle SOA suite, SAP Business Objects, Informatica Power Center.

Confidential

Technical Lead

Responsibilities:

• Working closely with the customer, technically led a 5 person team to develop a Portfolio/Program Management Application based on Earned Value Management (EVM) for use by OSD AT&L Senior Executive Staff as executive cockpit/scorecard on DoD weapons/IT systems acquisition programs based on EVM. The application also included SOA based BPM module for data quality check process. Developed the application using CORDA Centerview, Informatica Power Center & Analyzer, MS SQL Server, and BEA Aqualogic. Worked directly with OSD customer.
• Implemented SOA Client that obtained Program and Contract data from a Web service by making SOAP request call and then saved the data directly onto backend SQL Server data warehouse.
• Developed an Oracle version of the application for use by OSD PA&E government customer for portfolio management in a classified environment.

Tools: /environment: Oracle 10g, MS SQL Server, Oracle SOA suite, Informatica Power Center, CORDA Centerview.

Confidential

Chief Architect & Project Manager

Responsibilities:

• Won this project and led a team to develop and demonstrate a prototype Performance Based Logistics (PBL) Decision Support System based on the Kaplan-Norton’s Balanced Scorecard methodology to do program management on a multi-billion dollar key weapon system acquisition/maintenance program. Capabilities included Business Intelligence reporting, Data Mining, Prediction/Forecasting as well as pulling performance data from various DoD data sources.

Tools: /environment: Developed using leading COTS tools Business Objects, Informatica Power Center, and Oracle 10g, Windows.

Confidential

Ashore Operations Project, Oracle SME

Responsibilities:

• Key member of two Winning proposals development/presentation team to Confidential (SPAWAR) for Phase I and II that resulted in awards of both phases of the project. Directed the Confidential Data Center Oracle Technical Environment Upgrade/Migration as well as created detailed project plan for upgrade of Oracle ERP applications implementation, Database (Oracle 10g), Storage Area Network based on EMC Clarion 700 series, Backup and Recovery. Lead feasibility studies for new applications modules, and performed enterprise architecture and change request reviews.
• Designed and provided technical/project management in development of a prototype web-enabled DoD Logistics Balanced Scorecard Application (Kaplan-Norton’s) for Performance Based Contracting decision support .i.e. to monitor the performance of logistics contracts awarded by OSD AT&L. The architecture consisted of a data warehouse with KPI balanced scorecard dashboard including predictive analytics capabilities developed using Informatica Power Center, Business Objects, and Oracle 9i.