SUMMARY

• Significant expertise in data management/architecture/strategy (big data, data lakes, data warehousing, MDM), data modeling, analytics, BI, and OLAP
• Managed and delivered various consulting and software development engagements for global companies; broad experience in complete systems development cycle, from analysis and design to implementation and post - implementation maintenance.
• Subject matter expert in the area of insurance, health care, energy (Upstream Operations, Subsurface, Well Exploration and Production), trading (physical and financial that include derivatives and securities), consumer packaged goods and retail (assortment/pricing optimization, distribution, demand planning, and activity-based costing), transportation and logistics.

TECHNICAL SKILLS

• Data Modeling (Process, Conceptual, Logical, Physical, 3NF, dimensional, and canonical)
• Data Management/Data Architecture Strategy and Implementation
• AWS Redshift, BigQuery, Snowflake, Netezza, Oracle, SQL Server, PostgreSQL, SSIS, Informatica, Informix, Red Brick, DataFlux
• ErWin, PowerDesigner, ER/Studio
• Cognos, Composite, Business Objects, MS Analytical Services, Crystal Reports, Xcelcius, Spotfire, Dundas, QlikView, Tableau
• PL/SQL, Perl, C, C++, VB 6.0, C#, ASP.NET, JavaScript, HTML, XML, ActiveX, OOD, OOP, 4GL, MFC, OpenGL, Python
• TOGAF 9 Certified, AGILE practice

PROFESSIONAL EXPERIENCE

Confidential

Cloud Data Architect

Responsibilities:

• Responsible for re-engineering AWS/Redshift data warehouse on Google Cloud Platform (Airflow, Spark, DataFlow, BigQuery)
• Responsible for GCP data design and architecture; data modeling, system architecture from data ingestion and integration (30+ data sources) to data lake/persistent/query/visualization layers
• Collaborated with other architects and business stakeholders across organization on cloud architecture strategy and implementation aimed at maximizing value of data across the organization

Confidential

Data Architect/Data Solution Architect

Responsibilities:

• Architected solution for collecting data from IoT devices; supervised design and development
• Responsible for improving and expanding data models and data architecture for Global Commercial Analytics Datawarehouse Platform (Oracle, DataStage, Cognos, Tableau, Python)
• Responsible for defining and implementing strategy of integrating multiple data sources into the commercial platform, consisting of both internal and external data (ex. Connected devices data, IMS, Salesforce, JDE)
• Working closely with business stakeholders, business analysts, and technical architects to drive on-going analytics initiatives and data solution architecture from requirements gathering and gap analysis right through the stabilization of delivered products
• Working with business stakeholders and technical personnel in order to identify future state data architecture requirements related to moving data platform into cloud; responsible for architecting a successful POC involving AWS and Snowflake.

Confidential

Data Architect/Data Modeler

Responsibilities:

• Data Modeling and Data Architecture work on systems modernization project, moving from Legacy to micro services architecture (DB2, Java, ErWin)
• Participated in JAD sessions with Java developers, DBA’s, BA’s and QA team
• Worked with business stakeholders in order to identify future state data requirements
• Analyzed existing systems in order to produce future state data models (conceptual, logical, and physical)
• Created source to target mappings between legacy systems and future state
• Assisted with database and systems planning targeting future state
• Served as mentor to client’s data architecture team

Confidential

Data Architect/Data Modeler

Responsibilities:

• Designed data mart reporting solution off TrackWise workflow system, covering quality management (CAPA, Complaints, CCM)
• Created dimensional data model to accommodate business requirements (PowerDesigner, Oracle)
• Developed integration plan between source system and data mart
• Created source to target mappings between TrackWise and data mart’s dimensional model
• Supervised ETL development (DataStage)
• Supervised development of reports off the data mart (Cognos)

Confidential

Data Architect/Data Modeler

Responsibilities:

• Led a team responsible for design and implementation of ODS for transportation and logistics management system
• Created logical and physical 3NF relational ODS models based on XML data extracts from transportation logistics application (ER/Studio)
• Managed implementation of .NET application to extract and load data into SQL Server 2014 database
• Led a team in design and implementation of SSIS packages to control execution of .NET application
• Designed a dimensional data model for reporting
• Software built out was done on AWS

Confidential

Solution Architect

Responsibilities:

• Responsible for overall design and implementation of data mart for consumer analytics
• Responsible for system architecture, data integration (consumer, census, and geospatial data), logical and physical database design and implementation (Informatica, Oracle, SQL Server and QlikView)
• Designed ETL processes and transformations, maintained source to target mappings
• Implemented complex transformation logic to align granularity of the data with target architecture
• Interacted with project stakeholders on business reporting requirements (C-level executives)