PROFESSIONAL EXPERIENCE

• Enterprise Architect, Enterprise Data/Information/Content Architect for high - availability, scalability and high-performance systems.
• Data Governance policies and standards definition and enforcement to support business goals and productivity.
• Business continuity and disaster recovery strategies. Enterprise elastic cloud computing and Big Data architect. Database systems, virtualization (VMware), Business Intelligence/Analytics/Dashboards and Data Warehousing.
• Overall IT projects technical lead adhered to high-end methodologies and best practices.
• Certified Enterprise Architect wif over 20 years of enterprise level architecture strategy planning and consulting experience in leading efforts to managing, designing, architecting, building, tuning and implementing mission critical systems for different line of businesses (Healthcare, Tel-communication, Medical, Banking/Financial, Insurance, Education, Retail, Pharmaceutical, Manufacturing, Government, Consumer).
• Strong business and technical management skills focused on increasing organizational efficiency as well as bringing products to market on time and on budget. Provide enterprise level data architecture, Big Data, data modeling, governance, business intelligence, analytics, data mining, system analysis, cloud computing technology support and leadership on teh various systems.
• Architecting and implementing different projects for a range of platforms wif high scalability/elasticity, performance, high availability and reliability utilizing amazon cloud web services (EC2, SQS, SNS, RDS, S3,..).
• Analyze technical and functional impact and setup tactical and strategic plans/analytics associated to technology trends. Perform data governance assessments, gap analysis and provide recommendations to stakeholders.
• Excellent communicator wif colleagues, customers and upper management to identify risks, propose solutions and offer alternative of realistic design/deployment options.
• Ability to lead teh implementation of mature noledge of operational procedures appropriate to creating and running high-volume, high-performance, high-availability and complex application suites.
• Proactively managing and leading efforts to enhance customer service by defining necessary tools and methodologies to continuously re-evaluate and improve end-user experience.

PROFESSIONAL EXPERIENCE

Confidential, Massachusetts

Enterprise Data Architect/EA

Responsibilities:

• Architect high available, scalable and superior performance backend database systems on teh cloud wif replication, load balancing, failover, monitor/alert, low maintenance…etc. Utilizing Amazon AWS services for cloud computing and automations including EC2, SQS, MySQL, RDS, S3 and Amazon Linux.
• Designing scalable Data Models and schema to support transactional and non-transactional applications including BI and analytics. Design and implement strategies necessary to handle mass volume of data (~1 petabyte) together wif data lifecycle.
• Evaluate and recommend third party technologies and products (e.g. Scalebase, Vertica, Tableau…)
• Working wif all parties including stakeholder and management to gather requirements, plan product road map, enforce data governance policies/standards, adherence to regulations/compliancy and support patent activities.

Confidential, Massachusetts

Enterprise Data Architect/EA

Responsibilities:

• Define, plan and implement strategies for enterprise data governance including policies, standards, data identification/definition/classification, data consistency, data acquisition/extraction, cleansing/scrubbing, integration, data hosting/location, data manipulation/reporting/intelligence, data sharing/replication/federation and consolidation, data security and data aggregation /archiving cross all information management systems wifin teh enterprise.
• Build high level conceptual, logical and physical data models as well as detailed ones for various business needs. Perform extensive data analysis (data sensitivity, manipulation frequency for ACID, data authority, data regulation compliance..etc) including capacity planning (processor, storage, network) and governance.
• Perform GAP analysis between baseline and target data/information architecture and setup necessary migration plans.
• Design architectural database solutions for high scalability, high availability/(business continuity) and performance at teh enterprise level to meet teh current and future needs of teh accelerated business and customer base growth.
• Research, define, design and develop tools and technologies for adaptability wifin teh enterprise throughout data life cycle.
• Perform continuous analysis of stakeholders’ concerns/views from different viewpoints, identify business scenarios, resolve any/all conflicts at teh architectural level and halp transform architectural solutions into actual project plans.
• Closely work wif teh rest of teh project/product managers, business community, CxO, stakeholders and architecture team members to communicate ideas, share artifacts/deliverables, identify and mitigate risks, review status and contribute to teh overall enterprise architecture landscape.
• Design and build business intelligence platform, reporting and dashboards wif mass level wealth of heterogeneous legacy data (>15 TB) to be used by executives and marketing analysts for their day to day analysis and predictive considerations.
• Design and deploy efficient schema models and entities (> 500) wif massive and real-time data manipulation wif a instantaneous ETL processes.
• Utilize Amazon web services for testing/developing and proof of concept pilot projects (hadoop/map reduce/hive). Design teh architecture including data life cycle stream for all web activities/clicks to be analyzed on top of a scalable hadoop platform in order to provide intelligence back to teh front end application.
• Oracle Retail Merchandising System (RMS) Implementation and build enterprise data warehouse interface.

Tools and Technologies used: Dimensional Modeling, OLAP, Cubes, Data Marts, Start and snowflake schemas, MySQL, Columnar Databases (Vertica), Hadoop/HDFS/Hive/MapReduce, SQL analyzing/monitoring and tuning, Web Access analysis, Tableau, Jasper, Amazon Web Services/cloud, Oracle, SalesForce, SEO, Google Analytics, Toad, Erwin, Bash shell scripting, Stored Procedures, Top down methodologies, ADM, Agile...etc.

Confidential, Massachusetts

Senior Manager/Data Architect

Responsibilities:

• Acts as prime SME data architect for all schema products embedded, virtualized and standalone database systems.
• Design, manage, plan and implement enterprise information system architectural solutions, methodologies and standards for high performance, scalability and high availability/clustering solutions and information sharing (replication).
• Preparation and definition of business cases reviews and validate technical and functional requirements.
• Define teh ongoing backup/archiving policies, authentication/authorization, patching/upgrade and all maintenance strategies.
• Design data level architecture capacity planning, security/auditing and operations (including VMware products).
• Evaluate current standards and policies to those provided by industry and recognize potential adoption wifin teh enterprise to improve overall practices.
• Identify and communicate risks, provide early stage alternatives and proactively correspond to upper managements.
• Interactively and promptly communicate progress, risks/issues and is seen as a visionary, providing input to direction and strategy. Ensure clients satisfaction, exceed expectation and maintain trusted bond wif clients at all levels.
• Work on unusually complex problems and provides technical solutions, which are highly innovative. Visible to stakeholders as teh subject matter expert.

Tools and Technologies used: Oracle, Streams, Golden Gate, Scrum, Erwin, SQL Tuning, Toad, VMware, Stored Procedures, Top Down and root cause analysis.

Confidential, Massachusetts

Enterprise Data Architect Lead

Responsibilities:

• Responsible for teh overall Enterprise data architect and design of Digital Archive systems and databases (>20 TB).
• Design mass data ingestion, purging, authentication, replication, archiving strategies and regulatory compliance/standards.
• Establish and publish guidelines for data architecture standards, MDM and best practice enforcement at enterprise level.
• Work wif customers to efficiently advice and deploy/integrate product components on all environments (dev, test, production) and provide training and guidance on best practices. Mentor/manage group of developers/DBA/System Admin and architects.
• Design, produce and maintain ERD diagrams of over 1000 entities cross all business practices utilizing Erwin tools.
• Lead efforts to deploy teh optimal system layout, performance, scalability and 24/7 service availability clusters (business continuity and disaster recovery policies and guidelines). Define and execute benchmarking strategies for all environments).
• Setup teh roadmap for teh enterprise data architect including requirements for data manipulation, data security, risks analysis, data retention policies and data archiving.
• BI strategy definition, design and implementation for Event Tracking System and Billing. Provide design for next level data summarization and abstraction as Data Marts, Cubes, Multidimensional databases, etc.
• Performing conceptual, logical and physical data modeling work utilizing Erwin and Power Designer tools and database design in complex, large-scale data environments.
• Setup strategic and tactical plans for benchmarking teh architecture; define test cases, performance metrics and acceptance criteria against massive database systems. Review, validate results and communicate to team and stakeholders all artifacts and deliverables.
• Provide mentoring/coaching leadership, offer brownbag sessions and noledge transfer exercises.

Confidential, Massachusetts,

Senior Data Architect Consultant

Responsibilities:

• Lead projects to Re-architect teh OLTP and data warehouse dimensional star schema and data marts for new releases of MarketMax (Merchandise Planning) application for various RDBMS systems.
• Optimal database system design/configuration/customization for high performance and scalability for a variety of clients.
• Generate logical and physical data models associated wif data architecture requirements, build metadata for existing and newly acquired entities and classify each according to usage, ACID, Data type .etc.
• Define, gather, analyze and document all technical and functional requirements and deliverables. Plan for optimal deployment infrastructure requirements including (storage, network, servers, tools, etc).
• Evaluate and present teh existing/new technical architect, timeline and required resources to management and clients.
• Working on standardizing and integrating MarketMax wif teh rest of SAS products (data and application compliant).
• Guarantee on-time achievement of deliverables and play Quality Assurance role for technical team deliverables.
• Generate and maintain enterprise level data definitions (DDL) and customize/tune for various database technologies .
• Design and participate in teh governance activities, ensuring adherence to regulatory compliance and enterprise standards.

Confidential, Massachusetts

Technical Data Architect Manager

Responsibilities:

• Analyze all business requirements and functional specifications for customer tracking and retention OLTP and data warehouse project.
• Evaluate and recommend different technologies and platforms in response to business growth and technology evolvement.
• Capacity planning, defining, analyzing, designing/modeling and implementing customer product to support marketing intelligence.
• Coordinate and manage teh deployment strategy, identify and resolve all/any issues, apply noledge and experience considered necessary to profitably, manage client relation, exceed expectations and deliver a successful project.

Confidential, Massachusetts

Lead Data Architect

Responsibilities:

• Lead efforts in defining, analyzing, designing/modeling and implementing transaction databases, analytical data warehouse and data mining to halp scientists predict future experiments’ results and accelerate drug discovery process.
• Setup standard interfaces between laboratory station/robot controllers and transaction databases (development, test/QA and Production).
• Develop and implement strategies for data architect, data acquisitions, archive/recovery and reporting. Also design and implement custom ETL processes for data movement and data transformation cross all internal and external databases.
• Data modeling (logical and physical), implementation and tuning database engine, schemas and DML/Queries for OLTP and data warehouse/data mine structures.
• Develop an in-house corporate Chemical Inventory and Chemical Library DBMS systems wif interaction to MDLI products.
• Resolve issues and implement solutions for scalability, availability (failover), reliability, security and performance for teh whole enterprise.
• Mentor/manage group of developers/DBA/System Admin and architects.
• Setup project development methods, standards, templates. Research and resolve any/all design and development issues.

Confidential

Technical Manager

Responsibilities:

• Efficiently manage resources, budget and time to deliver various strategic projects.
• Set teh technical directions for teh organization as well as providing directions for teh improvement of operational processes.
• Evaluate technologies and software products (e.g. Content Management, ERP) and recommend use for developing web-based applications.
• Designed and implemented a three tired Internet architecture for teh corporate E-Business model and Pay Per View initiative.
• Architect and Implement an OLTP and Data Warehouse solution to achieve intelligent marketing and provide halp to executives in decision making.

Confidential, Massachusetts

Technical Architect Leader

Responsibilities:

• Practicing BI methodology and setup project plans.
• Designing and implementing architect for Insurance Data Warehouse (Premium and Claim subject areas)
• Technical systems architect for N-Tier Web applications. Manage projects, resources and time.
• Define necessary tools for testing, validating and diagnosing integrated packages and modules. Provide scientific approach for acceptance testing.
• Provide technical support to clients at critical situations. Monitor system load, growth and document outcomes.

Confidential, California, USA

Principal Consultant/ Team leader Data Architect

Responsibilities:

• Working at Oracle prospect and client sites to synthesize people, processes, software and hardware into optimal application systems in various operating system environments.
• Applying noledge of operational procedures appropriate to creating and running high-volume, high-performance, high-availability, complex application suites for various types of industry (e.g. Insurance, Communication, Retail, Financial…etc.).
• Designing and implementing logical and physical data models and data architect for several mission critical OLTP and Data Warehouses (> 1 TB) projects as well as integration wif other systems.
• Implementing, testing and automating data capture, cleansing, load/populate and reporting procedures.
• Planning for database backup/recovery, availability and establishing security policies.
• Improving overall system performance by building, monitoring and documenting successful new methods and tools.
• Identifying, scoping and selling billable consulting work.
• Technically and functionally leading team of consultants (4~8).
• Develop module, system, and acceptance test plans. Ensure timely completion of deliverables; keep development team on track (timeline and functionality). Fill Quality Assurance role for technical team deliverables. Communicate technical issues to customers at a business level.

Confidential

Senior Decision Support System Architect

Responsibilities:

• Data Architect and Data modeling adopting Star and Snowflake schemas for Nielsen’s retailer clients.
• Benchmarking database engines to achieve teh optimal configuration.
• Supporting and implementing an OLAP tool (Workstation Plus) on different platforms and different RDBMS engines.
• Performance tuning.
• Design and implement data capture, transform and load/populate methodologies and rules (build Metadata repository).
• Providing database and UNIX system standards for developers involved in various projects.

Confidential

Senior Consultant

Responsibilities:

• Implementing a three tiered Client/Server system deploying Informix On-Line engine, Tuxedo TP monitor and Visual Basic.
• Administrating multiple residency servers for development, testing and production environments.
• Database modeling and logical/physical database layout implementation.
• Benchmarking database background load, concurrent users and Backup/recovery using ESQL, C and UNIX shell scripts.
• Performance tuning (Applications, Platform, Server and Network).Bell Mobility Cellular
• Building, tuning and implementing Sybase database for message processing (Call Data Records CDRs).
• Prototyping and benchmarking Tuxedo middleware for database hits, load balancing, message queuing and guaranteed message delivery features.
• Designing and presenting teh technical architecture solutions to clients as a member of teh technical architecture group.
• Help client rolling to production by conducting various noledge transfer sessions and providing full documentation.