SUMMARY

• Support and partner with all levels of management and business stakeholders across organizations and globally.
• Work closely and collaboratively with every group in and outside of the company, technical and non - technical and 3rd party vendors, both on-shore and off-shore resources.
• Years of management, technical project management, technical lead and development experiences. Waterfall, Agile and SDLC.
• Years of experiences on defining and designing conceptual, logical and physical dada architecture, data modeling, data strategy, solutions and roadmap.
• Have experiences working on many different platforms, infrastructure, technologies and references different design frameworks and methodologies.
• Over 8 years of hands on experience working as an enterprise data architect in various industries and platforms.
• Over 12 years of hands-on experience on Enterprise Data Warehouse, ETL and BI/Analytics architecture design, strategy and solutions, analysis, management and development in various industries and platforms.
• Over 8 years of hands-on experiences on designing and implementing data integration project from planning, roadmap, strategy, architecture, acquisition, integration/migration, conversion, mapping, DQ, harmonization, analysis to deployment/release and support, end-to-end.
• Good experience on analyzing business process and data flows for various applications and industries. For example, customer and product, ERP, eCommerce, CRM (marketing, sales, CSR, vendor & account), financial, accounting, inventory and logistics, health care, patient, claims, pricing and more.
• Good experience on designing data models, such as Star Schema, Dimensional and OLTP data models. Some experiences on Hives design.
• Experience on migrating and deploying cloud based healthcare billing application. SaaS.
• Worked with security group to identify, define and set up data security classification and process to enforce PCI, PII and SOX compliances.
• Good experiences on setting up naming, data modeling and coding standards and best practice.
• Experience on performing as-is and to-be analysis and made recommendation on architecture design and strategy, technology standardization, business and data process alignments, application integration and migration strategy, data quality, MDM integration, metadata collection and data governance.
• Experience in gathering business and technical requirements and then translate them into technical design.
• Good experiences on business, technical and operational metadata collection and maintenance.
• Some limited exposure to Big Data, Hadoop conceptual architecture framework design. Have used HivQL on Cloudera.
• Many years of hands on technical development experiences focus on DW, DI, ETL, DQ and BI /OLAP Dashboards/Analytics.
• Knowledgeable on marketing, sales and customer analytics, data cleansing, de-duping and standardization.
• Good understanding and exposure to data governance and MDM concepts.

TECHNICAL SKILLS

• Oracle/OBIEE, Cognos and have some training on Qlikview.
• Informatica Power Center, OWB, SQL, PL/SQL, HTML, XML and Shell Scripts.
• Erwin and ERStudio.
• Guidewire InfoCenter and DataHub, ERP, CRM.
• Self-training on Microservices design, Hive, MongoDB and Python right now.
• Not hands-on but understanding of LDAP, DNS, IP, HTTP/SSL, Proxy, SMTP, SOAP, REST, WebLogic
• Tomcat, MS Messaging, Java Scripts, Java and C/C++. Needs to provide solution based on these settings.
• Oracle RDBMS, MS RDBMS, DB2/UDB. Unix, Linux and Window 2005 to 2014.

PROFESSIONAL EXPERIENCE

Confidential

Technical Project Manager / BI Architect

Responsibilities:

• Manage few reporting projects to define and create KPIs and dashboards to recognize project revenue and ROI; enhance existing reporting platform with hybrid architecture to support various data structures and analytics requirements.
• Create project plans, tracks, manages, recruit, estimate, follow- up, reports status, resolves issues and risks.
• Manage change management control, perform code reviews and define standards for coding and designs.
• Lead project teams between 5 to12 technical staffs and analysts. Agile and scrum.
• Work as a liaison among business stakeholders, technical groups, architects and vendors on product selections, POC, architecture reviews and designs, and all other project or production support related deliveries.
• Manage and perform project related database designs, data model designs, development tasks and QA efforts.
• Support current ETL & BI processes, operations and new business initiatives.
• Worked with business and IT to drive and define BI strategies for short/long-term goals, timeline and roadmap.
• Worked with client’s architecture team to define DW/ETL/BI architecture standards and best practices.

ENVIRONMENT: Oracle 12c, MS Great Plains/Dymanics GP, Cognos, PL/SQL, MS Project, ERStudio

Confidential

Data Architect

Responsibilities:

• Member of Confidential data architectural team and responsible for supporting EDW and eCommerce engineering product teams throughout the entire project lifecycle. Scrum and agile.
• Performed complex data analysis to validate against logical/physical architecture designs,
• Worked with Security Group, DBAs, business SMEs and engineering groups to analyze, define, set up, configure and enforce PII/PCI/SOX security compliances.
• Worked as a lead data architect for TicketUtil integration project, and the tasks included: analyzed and documented API and data integrations and the gaps, defined business and technical transformation rules, designed data models, re-designed ticket listing process and architecture to support C2C business requirements.
• Created design and requirement documents; maintained and published metadata, WiKi web pages.
• Developed Javascript/Macros to maintain metadata in ERStudio.

ENVIRONMENT: Oracle 11g/12c, Informatica Power Center 9.x, ERStudio, SQL, Macro, PL/SQL, REST, SOAP, Slack, MS Server 2012, Oracle VM 10.0.6, JSON

Confidential, Foster City, CA

Enterprise Data Architect

Responsibilities:

• Member of Confidential enterprise data architecture team and responsible for driving and designing data architecture and recommending data strategy and solutions, enforcing data naming and design standards, evaluating technology adaptability, creating data/process/application integration and migration designs and solutions, business process alignments and improvements and defining metadata and maintenance.
• Designed eCommerce data and process models to support both RDBMS and Hadoop environments.
• Enforced data security and data privacy compliances, PII, PIC and SOX.
• Performed complex business data and process analysis to ensure data consistency, harmony and quality.
• Lead data architect for multiple Confidential OLTP and eCommerce projects to support Confidential ’s corporate card process and implementation efforts, SDLC.

ENVIRONMENT: SQL Server 2008 R2, DB2/UDB v9.7, Oracle 11g, Erwin v9.x, Cloudear HiveQL, Jira.