Enterprise Data Architect Resume

SUMMARY

Highly accomplished, deeply data driven, Data/BI architect with over 14 years track record of success in Data warehouse/business intelligence architecture, design, development, data modeling, data analysis, visualization, performance optimization and user interaction.
Proven expertise in tackling challenges from all phases of project, meeting deadlines and handling multiple assignments simultaneously in fast paced environment.
Coordinated deliverable with key stakeholders in cross - functional groups.
Demonstrated proficiency in leading and mentoring individuals.

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

Responsible for data warehousing, data modeling, governance, architecture standards, methodologies and guidelines
Partner with various business, gather requirements, converted them into scalable technical solutions and system designs
Designed rule engine to handle complicated data conversion requirements
Architected Data lake, Master data, Security, data hub and data marts layers.
Developed logical and physical models for various complicated requirements
Tuned DB processes to improve performance
Reverse engineered Cognos reports (Command Performance), identified business rules for the Dashboards/reports and created Command Performance data mart for Power BI.

Environment: Oracle data modeler 4.1, MS SQL Server 2016, Visual Studio 2016, MS Azure, SSIS, Power BI

Confidential

ETL Architect

Responsibilities:

Worked with Financial Analysts, SMEs, PWC consultants and KPMG consultants to gather the requirements for Input and Output VAT flows
Architect China VAT, GECap solutions, deigned/developed flow diagrams, Data models, ETL interfaces, DB/Unix scripts and Autosys jills.
Collaborated with UI team, developed user interfaces with dual approval features and operational dashboards for reconciliation.
Identified bottlenecks in production fixed them

Environment: Informatica 9.6.1, Oracle 11g, UNIX, Autosys

Confidential

ETL Architect

Responsibilities:

Executed many POCs successfully, initiated projects and converted requirements into technical specs
Architect and developed Oozie jobs, hive actions, Sqoop jobs and ETL file transfer jobs
Produced ETL architecture, data flow/process flow diagrams
Built guidelines for data conversion, retention, archival, quality and reconciliation
Designed and developed ETL job orchestration, CDC and Data Quality frameworks
Collaborated with the BI team and QA teams in delivering business critical reports

Environment: Informatica 9.1, Oracle 11g, UNIX, Postgress 9.1, jira, Hadoop, Sqoop, Github, Agile, Hive, Oozie, Hue

Confidential

DW Architect

Responsibilities:

Environment: Informatica 9.1, Oracle 11g, UNIX

Confidential

DW Architect

Responsibilities:

Conducted JAD (Joint Application Design) sessions and workshops to gather requirements
Performed data profiling of different source systems (Workday, Hyperion, Taleo), assessed data quality and developed cleansing strategies
Provided Solution Architecture, prepared DW Bus Matrix, Logical and Physical Data Model
Analyzed critical legacy applications (in PL/SQL), re-engineered with Informatica, reconciled data
Designed proactive notification system using combination of SQLs and Informatica
Assessed Oracle APEX tool for User Contributed Data requirements, developed UCD solution to replace existing MS Access 'Forecast Tool'

Environment: Informatica 9.1, Oracle 11g, UNIX, APEX 4.0, Workday, Oracle data modeler