We provide IT Staff Augmentation Services!

Sme / Chief Data Architect Resume Profile

Annapolis, MarylanD


Accomplished Subject Matter Expert SME with more than 20years of hands-on experience in Big data systems, data governance, master data management, integrated enterprise data warehouses, relational-database management systems and spatial database systems for the public and private sector organizations.Skilled professional with proven ability to super-charge IT departments and programs. Hands-on experience and up-to-date knowledge in big data technologies and products. Experienced and successful in business development. Strong background in consulting and management within US Federal agencies and commercial corporations. Proficient at making presentations and communicating with peers, vendors, corporate and government senior executives and officers.


Big data: Hadoop MapReduce, Unstructured Data Processing, Apache Hive, HBase, Pig, Mahout, Flume, Sqoop, Ambari, Zookeeper, Oozie, NoSQL, EDW, Data Analytics

Tools: Oracle 11g, Oracle Spatial, Teradata, MySQL, Oracle Data Integrator ODI , Oracle EDQ, Oracle Datanomics, OBIEE, ETL/ELT, Informatica PowerCenter, Talend, ERWin, R, SPSS, Business Objects

Languages: SQL, PL/SQL, Perl, Python, JavaScript, Java/JEE, Oracle APEX, Oracle ADF, XML, XSLT, WSDL, SOAP

Operating Systems: Microsoft Windows, Linux, Solaris, Fedora

Statistics: Machine Learning R ,Multivariate Statistics and Analysis,Probability Distribution, Decision Trees, Monte Carlo Simulation, Bayesian Networks, Systems Theory



SME / Chief Data Architect

  • Implemented long-term strategic goals and short-term tactical plans for managing and maintaining systems and software. Designed, developed, and guided implementation of end-to-end integrated systems
  • Authored and reviewed proposals in response to Federal RFIs and RFPs. Forged alliance with large and small business for partnering on Federal contracts. Generated leads and networked with decision-makers
  • Performed big dataprocessing using Hadoop, MapReduce and NoSQL databases including MongoDB
  • Architected data analytics systems and initiated the Data Sciences practice
  • Authored white papers onbig data, cybersecurity and geospatial informatics
  • Modeled business and system processes based on findings through use case scenarios and data models
  • Applied best practices and standards including TOGAF, DAMA and OMG to create data architecture artifacts
  • Providedtechnical expertiseto business analysts, data analysts, DBAs, and developers
  • Developed Level 0, 1, and 2 Data Flow Diagrams and System Context Diagrams
  • Developed conceptual and logical data models for assessment systems in alignment with IT Roadmap and vision
  • Architected the Master Data Management model and metadata repository implementation
  • Mapped key data objects to business processes
  • Created data security view, data component sourcing, application / data matrix, data entity to business process matrix, data dissemination diagrams and data topology mapping
  • Conducted risk assessment and gap analysis of systems and data architecture artifacts
  • Facilitated information management practice, architectural guidelines, framework and policies
  • Hands-on experience with business intelligence, data integration and data quality tools including Oracle Business Intelligence Foundation Suite
  • Authored system specifications document and technical design documents low- and high-level
  • Created an options analysis framework to assist with comparison of alternative solutions
  • Developed an Activity Based Costing ABC cost model for enterprise data services

Environment: Oracle 11g, ODI, EDQ, Oracle SOA Suite, JEE, Oracle BI, Informatica Power Center Erwin, OBIEE, WebLogic, Hadoop Map Reduce, MongoDB, CouchDB, InfoSphere, JEE, ADF, APEX, R, SPSS, Erwin, Visio, Logizian, Enterprise Architect


Solutions Architect Consultant

  • Modernized Orange Book OB legacy system for FDA. Created OB use cases, OB logical andphysical data models and the OB interface model for interoperability with other FDA systems
  • Architected the OB systeminfrastructure
  • Created the OB prototype using open source web technologies
  • Documented clients' existing As-Is and To-Be architectures and technology portfolios and made recommendations for improvements and/or alternatives
  • Created EPLC documents and interfaced with senior leadership in Senior Management Team SMT meetings
  • Participated in Gate Reviews with Agency personnel including Information Security and Enterprise Architecture
  • Created test cases and test plans
  • Wrote a white paper on a comparative study of Oracle APEX and ADF
  • Designed the evaluation instrument to evaluate COTS products for assessing risk, making recommendations and proposing alternatives in the context of OB system functionality
  • Created corporatewebsite content

Environment: Oracle 11g, Erwin, Enterprise Architect, WebLogic, JEE, ADF, APEX


Solutions Architect Consultant

  • Formulated technical architecture of financial systems including web services, interfaces and service components
  • Created logical and physical data models
  • Managed a team of 14 PL-SQL, Java and .NET developers, Oracle DBAs, and business analysts
  • Mentored software developers and database analysts. Provided hands-on assistance with technical solutions
  • Interfaced with business analysts and testers for validation of requirements and analysis of regression testing
  • Interacted and coordinated with the client, responded to client queries with regards to the technology, tools and processes used in the development of the system
  • Prepared and made presentations on technology solutions to the client
  • Peer-reviewed Java and PL-SQL source code
  • Analyzed SQL queries for performance optimization
  • Authored the Technical Design Document of the Benefit Calculation and Valuation Solution BCVS . Participated in divisional meetings with the client including EA, security, technical review board and others
  • Coordinated with the PBGC Enterprise Architecture EA to implement VMWare Virtualization Technology
  • Documented clients' existing As-Is and To-Be architectures and technology portfolios and made recommendations for improvements
  • Participated in PBGC Gate Reviews after completion of each milestone

Environment: Oracle 11g, Erwin, WebLogic, JEE, APEX, .NET


Chief Software Architect

  • Architected data warehouses consisting of relational and spatial entities
  • Created logical and physical data models and developed algorithms to create data marts of spatial geometries
  • Used ETL tools for extraction, transformation, loading and integration of data from disparate sources
  • Resolved data consistency issues by constructing and executing complex SQL queries
  • Developed applications to retrieve and analyze data using J2EE, custom-developed MAFTIGER APIs
  • Resolved anomalies and geometric distortions zingers, zig-zags , and supported high volume transactions
  • Collected and analyzed performance metrics by concurrently monitoring the database and application servers
  • Implemented coupling, cohesion, concurrency, caching and data structures in application design
  • Designed and developed the Population Count Review System website using ESRI and ASP.NET technologies
  • Developed test plans and acceptance criteria based on technical and specifications for public domain apps
  • Maximized productivity and cut costs by automating business processes
  • Created algorithms for randomly generating data for the Master Address File data warehouse in a private cloud
  • Provided expertise with design and development of GIS applications to the client
  • Earned Employee Service Award and recognition from senior management

Environment:ESRI, Oracle 11g RDBMS and Spatial , ODI, WebLogic, Hadoop Map Reduce, JEE, ADF, Perl, PL/SQL


Operations Manager

  • Provided application service management to the FDIC client
  • As a leader of the Operations and Maintenance O M team, provided application, configuration, release management, capacity planning and resource management to the client
  • Provided business development services including proposal writing, proposal management, gate reviews and strategic planning to the program manager and the account manager
  • Interacted and communicated with vendors regarding service offerings and teaming agreements
  • Contributed to revenue growth through a SOA contract award of 3 Million from FDIC
  • Improved contract performance by streamlining ad-hoc processes

Environment: Oracle 11g, Websphere ESB, SOA, InfoSphere, Rational Architect, JEE, Cognos, SharePoint


Program Manager

  • Architected solutions in EDW data modeling, ETL, data quality, and performance optimization
  • Prepared SOWs, coordinated with subcontractors, and supervised staff of several data analysts, and Oracle DBAs
  • Created and maintained the Project Management Plan, Performance Management Plan, Risk Management Plan, Quality Assurance Plan, Knowledge Transfer Plan and Transition Management Plan for the IRS EDW Branch
  • Used Earned Value Management System for project performance management
  • Enforced measures to improve staff performance, quality of service and products provided to the customer
  • Provided weekly status reporting to the client, the project team and corporate management
  • Earned Internal Revenue Service Modernized eFile MeF Award
  • Chaired weekly technical sessions and project meetings
  • Served as the Lockheed Martin Information Technology Subject-Matter-Expert SME on the Operations and Maintenance Transition Team at the Department of Labor

Environment: Oracle 11g, WebLogic, JEE, Informatica PowerCenter, XML, ERwin, Oracle Designer


Program Manager

  • Supervised a staff of 34 employees and contractors across multiple geographical locations and projects
  • Managed software development life cycle SDLC , while ensuring compliance with CMMI, IRS ELC methodologies
  • Acquired additional 0.5 million business from the IRS client by delivering focused technology presentations
  • Generated 2M in additional revenues in first 3 months through technology enhancements
  • Created an integrated project management plan and integrated project schedule
  • Trained and mandated the staff to comply with the various levels of security in compliance with FISMA and NIST
  • Acted as the primary customer interface regarding all contractual communications
  • Delivered products on-time and within budget by managing scope control and change impact on tasks
  • Conducted risk assessment to minimize application life cycle costs and managed issues on a daily-basis
  • Participated in strategy sessions with senior management.Recognized for maintaining 100 staff retention

Environment: Oracle 10g, J2EE, PL/SQL, Informatica PowerCenter, XML, .NET, C


Task Manager/Program Manager

  • Supervised 35 analysts, programmers, DBAs, testers, and subcontractors
  • Architected, designed, developed and managed the National Address Data Warehouse
  • Designed and developed data marts for three- and five-digit zipcodes, counties and locatable addresses
  • Architected Geographic Information System GIS Interfaces and spatial topology
  • Standardized commercial and non-commercial addresses and created a matching algorithm
  • Improved project performance by implementing CMMI L3 processes. Collected, managed and analyzed KPIs
  • Created project management plan, work breakdown structure and project schedule
  • Managed project risks and issues by maintaining a problem log. Conducted monthly reviews with the COTR
  • Prepared and managed budget and projections for the corporate executives

Environment: Oracle 10g/11g, J2EE, PL/SQL, HTML, JavaScript, Perl, SPSS, Informatica PowerCenter, Oracle Designer

Hire Now