SUMMARY:

• 16 years of experience in enterprise architecture including data, application, technology and service oriented architecture.
• Extensive experience in Information Governance policy and strategy including standards, quality, security, metadata and master data management.
• Many years of experience in designing and building data frameworks for structured and unstructured data conducive for business insights, reporting and analytics.
• Experience in integrating complex corporate - wide business processes, customer-driven applications and data-driven framework.
• Experience in working with big data technologies (like Hadoop, Hive, Pig, Sqoop, Hbase, Cassandra, MongoDB, Drill, Flume, Impala, ElasticSearch, Spark, Spark Streaming and Kafka).
• Experience in dynamic web application design/development including Restful Web Services with J2EE, Ajax, Spring Framework/Spring Security and Oracle/MongoDB databases.
• Extensive experience in developing DW/BI applications with various versions of ETL/ELT and BI Tools such as Informatica, Ab Initio, ODI, Cognos, Tablue, Business Objects, OBIEE, etc.
• Strong Oracle and DB2 DBA/development experience and SQL, PL/SQL skills
• Fluent in multiple programming and scripting languages (Scala/Java/Python/Java Script/JSP).
• Knowledge of industry standard Enterprise Architecture Frameworks, (e.g. Zachman, TOGAF).
• Possess ability to adapt to new technologies very quickly.

PROFESSIONAL EXPERIENCE:

Sr. Enterprise/ Information/ Big Data Architect

Confidential, VA

Responsibilities:

• Provide Enterprise technology/application architecture and data hub architecture including Big Data, relational/NoSQL database, data warehouse, data analytics (business intelligence and predicative analytics) with TOGAF enterprise framework.
• Provide Information Governance policy and strategy including standards, quality, security, metadata and master data management.
• Provide optimal solutions and design patterns for building frameworks for data ingestion, loading, transformation on big data platform.
• Design and Build robust and scalable data engineering solutions for structured and unstructured data conducive for business insights, reporting and analytics.
• Provide and identify the cost effective data solutions for the clients with Big Data technology including Hadoop, MapReduce, Yarn, Pig, Sqoop, Hive, Impala, Kafka, Oozie, HBase, Cassandra, MongoDB, Elasticsearch, Hue, Flume, NoSQL Databases, APIs, Spark and Spark Streaming according to their business scenarios.
• Involved in designing and developing dynamic web applications and Restful web services with J2EE and MongoDB database.
• Import and export data between HDFS and traditional data warehouse with Sqoop, Hive on Big Data Platform.
• Offload traditional data warehouse to Hive and Hbase on big data platform with Spark.
• Provide new data modeling solutions for the new data integration environment on HDFS such as flattened out data model.
• Developed Big Data Analytics application with Hive, Drill, Impala, Spark and Tableau.
• Developed data event/streaming application with kafka, spark streaming and Hbase.

Principal Enterprise Solution Architect

Confidential

Responsibilities:

• Provided Enterprise Architecture including application, enterprise data hub, service oriented strategy, roadmap and architecture with TOGAF Architecture Development Method.
• Set formal IT standards, policies, processes and governance models.
• Worked effectively with all levels of the technical and non-technical organizational while proactively strengthening relationships.
• Responsible for building and driving alignment to an Enterprise Reference Architecture and roadmap.
• Developed the overall vision that underlies the projected solution and transforms that vision through a collaborative execution into the solution.
• Create design patterns and best practices for integration of systems and processes through the enterprise.
• Imported and exported data between HDFS and traditional data warehouse with Sqoop on top of CDH (Cloudera Distribution Hadoop).
• Designed and developed Big Data Analytics application with Hive, Drill, Impala, Spark and Tableau.
• Provided POC for the clients with Big Data technology including Hadoop, MapReduce, Yarn, Pig, Sqoop, Hive, Impala, Kafka, Oozie, HBase, Cassandra, MongoDB, ElasticSearch, Hue, Flume, NoSQL Databases, APIs, Spark and Spark Streaming according to their business scenarios.
• Developed data event/streaming application to collect customers’ comments related to specific business areas on social media and provide tailored recommendations for precision marketing with kafka, spark streaming, machine learning algorithms and Hbase.
• Designed and developed dynamic web application and Restful web services with J2EE and Oracle/NoSQL databases.
• Provided training and demo classes of using ETL/E-LT and BI tools for the developers from different clients, the training subjects include Big Data, OWB, ODI, Informatica, OBIEE and Business Objects.

Enterprise Architect

Confidential, Washington DC

Responsibilities:

• Provided vision, strategy, roadmaps, plans and solutions for the domains of Enterprise Application Integration, Enterprise Data Services Layer and Service Oriented Business Intelligence.
• Worked with multiple stakeholders to gather and prioritize their concerns as inputs into architectural design. Provided an architectural roadmaps for system, application and database development.
• Provided professional leadership in design, development, implementation and maintenance of large-scale multi-terabyte Data Warehouse and Business Intelligence and J2EE applications.
• Advised executive directors and customers on “best practices” concerning application architecture, system architecture, data warehousing, BI architecture, data architecture, and database management/development.
• Worked with IT Governance to align development and operational activities with departmental SDLC and support framework.
• Ensured that appropriate governance structure and processes are in place for information management and enterprise data warehousing strategy, operations and activities.
• As a member of the Organization’s Architecture Review Board, reviewed and provided the guidance for all the proposals and architecture documents submitted by the domain teams.

Sr. Data Warehouse/ BI Architect

Confidential, Washington DC

Responsibilities:

• Planned, directed, and managed the Enterprise Data Warehouse (EDW) and Business Intelligence (BI) Architecture for Confidential BI Analytical System following SEI Level III practices.
• Managed data warehouse and BI projects to successful implementation while acting as the sr. data warehousing task manager/Sr. data warehouse/BI architect on the project.
• Responsible for design and implementation of the enterprise data warehouse, data marts, ODS, logical & physical data modeling, multi-dimensional modeling, cube design and slowly changing dimensions using the Kimball data warehousing methodologies and the principles of Kimball's design.
• Provided expert consultation in Confidential BI system implementation including Linux installation, network configuration, Oracle 10g installation, Oracle Warehouse Builder 10g R2 installation/configuration and Business Objects XI R2 installation/configuration.
• Performed benchmarking, evaluation, and selection of ETL, DW and BI tools. Define the Decision Analysis and Resolution (DAR) Documents for Central Data Warehouse, ETL Tool and BI Tool Selection for Confidential after consulting with the different vendors following CMMI level III Practice-Process Defined Level.

Sr. Consultant/ Sr. Data Warehouse Architect

Confidential, Falls Church VA

Responsibilities:

• Conducted strategic assessments of clients business models, operations strategy, IT strategy, and DW/BI infrastructure; made recommendations to maximize ROI from investments in DW/BI; and helped clients implement those recommendations.
• Defined DW/BI architecture, data architecture and associated management for Federal Highway Administration Financial System.
• Participated in requirement meetings with the client end-users to clarify BI reports and web content needs. Assisted in documenting requirements, resolving ambiguities and conflicts, and gather consensus.
• Provided skilled data analysis, defined and maintained data standards, performed data mapping and data modeling, defined data transformation rules, facilitated database and multi-dimensional cube design using Oracle 11i database model, implemented a metadata repository.
• Developed ad-hoc query, dashboard and forecast reports using Oracle Discoverer Plus, Business Objects, OLAP, Oracle Portal for Federal Highways Administration Financial System. Created web portal page for OLAP Application.

Senior Data Architect/ Technical Manager/ Application Developer

Confidential, Vienna VA

Responsibilities:

• Responsible for system/transactional data architecture, data warehouse architecture, database design, logical and physical modeling, database and application optimization, scalability and tuning queries and stored procedure. Maintained database repository and wrote design and metadata documents.
• Installed Oracle 10g/9i/8i on Sun Solaris/Linux and Window Servers. Responsible for performance and optimization for database and business intelligence applications.
• Used Export, Import and SQL*Loader utilities for Database backup and Security.
• Developed dynamic web applications with J2EE.
• Developed and maintain Shell and SQL scripts to automate backups and monitor performance.
• Supported Data Warehouse Databases: performed capacity planning, installed new databases on Sun Solaris, involved in Star & Snowflake schema design, logical design, performed physical implementation, created scripts to populate database, created summary tables and materialized views.
• Installed and configured Oracle web application server IAS, OAS on Sun and window servers.

Computer Systems Engineer

Confidential, Washington, DC

Responsibilities:

• Analyzed the specifications and functionality and defined the logical and physical data model for the Federal Aviation Administration ( Confidential ) LDR (Labor Distribution Reporting) Financial System with Oracle.
• In charge of developing and implementing a subsystem of the National Air Space Supporting System for Confidential and Confidential (DOT) with Oracle Forms 4.5/6.0 and Oracle Reports 2.5/3.0.