SUMMARY:

• Profile Successful career as a Data Architect and Data Analyst. Most recently became certified as a Data Scientist. Using R and MS Azure Machine Learning created predictive models for marketing and nutritional health. I have designed, implemented and created analytic environments for large, complex database systems. I have designed data architectures including using the semantic Web Ontology Language (OWL) an extension to RDF, with analytical capabilities using SPARQL when retrieving large, disparate databases. Solid experience in working with financial systems. Architecting the data requirements from OLTP systems for BI Analytics using PowerBI.
• The marketing community desired to improve its sponsor retention rates for our sponsored children. Collected data from a few sources, integrated the data, performed data cleansing, data mining, and ran predictive analytics to assist in identifying individuals for specific types of marketing campaigns.
• Collected medical data from several countries regarding participation in nutrition programs to determine the greatest factors leading to recovery of malnourished children. Utilized several data cleansing and preparation techniques to support identification of outliers and anomalies. Required SQL queries to import data to machine learning tool and R. Created a web service accessed through Excel to analyze new data based on the learned data using statistical analysis. Determined 3rd party sources of data to extend analysis capabilities.
• Defined the business and data requirements for a Data Warehouse providing descriptive ad hoc (PowerBI and Tableau) and predictive (Azure ML and R) data analytics for a couple of business users and management. Defined the ETL to be used for the data warehouse including rules and transformations. Extensive SQL scripts with query optimization.
• Creating visualizations and dashboards from multiple data sources including SQL and Excel to provide improved data analytics. Created PowerBI dashboard from Twitter feeds requiring the use of calculated columns including extensive usage of DAX.

PROFESSIONAL EXPERIENCE:

Technical Project Manager/Data Analyt

Confidential, WA

• Hired to manage a data warehousing project starting with a 30 - day discovery phase. The project was managed using VSTS/TFS. I managed the project and wrote the business requirements document. My future role would also include data modeling, data architecture and data analytics.
• The project is on hold awaiting customer approval, budgeting, and implementing the next steps.

Senior Information Architect II/Data Analyst

Confidential, WA

• This was a 90-day contract that turned into two years. Working with the central Confidential Enterprise Architecture team as a information architect helping to design a centralized Data Warehouse and implement a data analytics platform. Defined the ETL to be used for the data warehouse including rules and transformations. Specifically tasked to write the supporting governance documents for the Data Warehouse to be expanded throughout the WV Partnership. Wrote the RFP to bring in a contractor to design and implement the Data Warehouse now in process. Performing an in-depth proof of concept comparing BI Data Analytic tools with a focus on Tableau and PowerBI for ad hoc reporting. Created visualizations and dashboards from SQL, Excel, Twitter, et. al. Finalizing the design of the data warehouse from data modeling and design, document management support, BI and Data Analytics support, Data Quality support with a focus on profiling to support data mining. In order to get more out of our data, became certified as a Data Scientist and worked on a marketing application to identify repeat customers and targeted marketing to reach those in various demographics. Working on a predictive model regarding child nutrition and restoring malnourished children to good health.

Senior Data Architect

Confidential, VA

• Supporting the Army’s CTO in identifying, evaluation, and recommending software to help consolidate or bring up to current standards for all of their network applications. This ranges from patch management, vulnerability analysis, and enterprise architecture as a means to ensure the end results are integrated within the Army suite.

Confidential, VA

Senior Data Architect

• Provided financial analytic modeling and data analysis from Deltek, SQL Server, SQL, Excel, and Sharepoint. Tools and methods included BPMN, Entity Relationship (ER) diagrams (both AS-IS and TO-BE used across the accompany to not only provide required government and civilian reporting but also tools to analyze the business and allow senior management to make better decisions. Created a data model from all executive systems and the current and needed interfaces between them including the ETL definitions between source and target systems. Defined the dashboard and the tools for data analysis as well as the SQL to export to Excel for configurable charts and graphs as well as supporting “What IF” and ad hoc data mining capabilities.

Program Manager

• Program management oversight for the Acquisition Visibility SOA Technical team including: team oversight, sub-contractor coordination, scheduling, project planning and task assignments, timesheet and invoice approvals, and other PM tasks as required. This project provided the OSD with advance data analysis using SOA to replace their existing ETL. Updating Program Management Plan and other subsidiary management documents to a constantly set of changing contract requirements. Updating all documents and implementing practices that fully support our companies CMMI level 3 practices. It is also the Program Manager’s responsibility to work with the team and ensure DoD standards are maintained. In addition to these responsibilities, maintaining my role as the chief enterprise architect for our solution architecture and the BEA (DoDAF) as well as working with the data team to create a semantic ontology (RDF/OWL) and the design of a data warehouse based upon our logical data model that supports all the statutory reporting and analysis requirements for major acquisition programs using SPARQL to enhance the analytical capabilities.

Strategic Architect

• Providing subject matter expertise on the future of Major Acquisition visibility with the AT&L community for both Acquisition and Technology. Working very closely with the Business Enterprise Architecture (BEA) documenting in DoDAF format the processes and data architecture used to manage and monitor the Dod’s major acquisition programs as defined within the DoD 5000 series, both for weapon systems and Information Technology. Facilitating across teams changes within the architecture to support ontologies and BPMN primitives with various working groups to provide advice on such as common vocabulary within the DoD and other strategic decisions to improve the efficiency and direction of the acquisition processes and coordination with other DoD areas such as the Comptroller community. Supporting the change to the End-to-End framework.

Business Process Consultant/Data Architect

• Provide process review of several applications for the GSA Public Building Service related to inventory management, occupancy, and leases. Current task is designing an operational data store (ODS) to serve as the interface between several applications. Task includes authoring the policies and agreements for data governance and management. Also tasked with defining the interfaces and metrics to ensure data integrity and availability. This includes support for a PBS wide data warehouse and business intelligence solution from standard reports to management dashboards. Utilized SQL extensively for data analysis.
• Provide subject matter expertise and program management support for tactical level business process reengineering project for the USDA as part of a larger application consolidation project using service oriented architecture (SOA). Provide for the Enterprise Architecture team an analysis of the current data architecture to better design a common data model for 8 disparate applications.
• Designed the implementation strategy for their Business Intelligence solution using Cognos. Created development, testing, and staging environments and documented the installation. Wrote an implementation plan for the reporting life cycle. Produced sample reports from test data the emulated existing executive reports.
• Delivered an AS-IS set of deliverables with recommendations leading to TO-BE documentation and oversight of the agency’s implementation of the process changes.
• Designed a common data model (tactical DRM) supporting the existing model, business requirements as reengineered, and enhanced analysis.
• Utilized BPR and database architecture to design a SOA/SOI framework.
• Provided the USDA team a ready-to-go reporting environment.

Confidential, McLean, VA

Director of Engineering/Data Analyst

• Program manager and data architect/analyst using emerging ontology methodologies such as the Semantic Web (RDF/OWL) as well as JSON to analyze the relationships between several data sources within the Intelligence community (including the FBI), create a semantic Operational Data Store (ODS) in order to provide the customer with state of the art analytic and deep data mining capabilities. This included the ETL to move data into the ODS from the source systems. Provided a proof of concept using SPARQL to demonstrate the capabilities of semantic technologies. IT director overseeing 4 project managers in the data analysis IT domain.
• Delivered a research prototype showing the value of semantic technologies to increase data analysis capabilities. Worked with the customer to initiate a project to implement a live solution.
• Utilized agile management methodologies to oversee 4 projects and assist the project managers in the design and development of a secure Federated SOA environment with stakeholders from a variety of agencies and locations. Assisted in the design to add cross-domain functionality.

Confidential, Parker, CO

Lead Business Process Engineer

• Lead Business Process Engineer for a SOA implementation working as a sub-contractor to Booz Allen Hamilton on a contract to centralize all of the FBI Security Division’s applications into a single system.
• Extended the Agency’s Enterprise Architecture with Business Process Execution Plan (BPEP) to document the BPR approach and project plan for the FBI’s security division. Provided Enterprise Architecture and Business Process Engineering subject matter expertise for the SOA team and sub-project.

Confidential

Chief Software Architect

• Chief Software Architect for the Defense Advanced Research Projects Agency (DARPA) directly supporting the Director of IT by providing Enterprise Architecture support, specifically in the business process (BRM) and data analysis (DRM) to support re-engineering all new applications and changes to existing systems into a SOA infrastructure, making recommendations on software products, responsible for defining a common development environment utilizing current industry standards and serving as the liaison between the various organizations and the applications that they utilize. The Chief Software Architect serves as DARPA’s Enterprise Architect, SOA Architect, Business Process Engineer and Database Architect.
• Trained in ITIL and utilized this with SOA methodologies to author the software and SLA requirements for DARPA’s seat management re-compete. This was based upon using metrics and other artifacts from the Performance Reference Model (PRM), Key Performance indicators (KPIs and BSCs).
• Management oversight over all software projects. Interfaced with the financial system using Excel.

Confidential, Chantilly, VA

Chief Application Engineer

• Lead technical role in analyzing business processes and data requirements and re-engineering them to create a system having many components including portal technology, business intelligence tools, predictive analysis tools, security tools, GIS tools, incident management tools, data distribution and recovery tools, and others. This included the ETL design from source to target.
• Created the process and architecture to provide data from 54 states and territories for the National Guard’s daily briefing.

Confidential, Woodbridge, VA

Professor (evenings - part time)

• Taught Microsoft Certified System Engineering classes

Confidential, Herndon, VA

Business Technologist

• Subject Matter Expert for all of their Business Reference Model (BRM) tools, Data Reference Model (DRM) tools, and other Enterprise Architecture tools.
• Business technologist for CA’s largest software sale in the BI business area.

Confidential, Reston, VA

Senior Technical Associate

• Senior software consultant assigned to various accounts to provide consulting, analysis, project management, and architecture services.
• Enterprise Architect, Business Process Engineer and Data Architect for the Federal Bureau of Investigation (FBI).
• Project Manager over a development team for the Department of Commerce (DOC).
• Analyzed requirements and business processes for the Freedom of Information Act for the FBI and architected a solution for redaction and publication of documents being released to the public.

Confidential, Vienna, VA

Senior Database Analyst/Database Developer

• Worked as a database developer and system analyst to consolidate systems and maintain existing systems.