Andrew James Email & Phone Number

Oceanside, Ca, Us

Health insurance migration from Netezza to Snowflake Azure Data Vault. Erwin Data Modeler 12.5, dimensional modeling, Facets, Epic, Claims, plan membership, eligibility, HL7 ADT, EPP & HPCS. Data Warehouse, Data Lake, Digital Health Record. Data modeling, technical reviews of development deliverables to ensure best practices, enterprise standards. Clinical & non-clinical member data, HIPAA.

Leading health care provider requested an audit of their analytics Redshift based architecture, database model, poor performance issues and replacement of their AWS data pipelines. Investigated their Redshift design, recommended server & software configuration upgrades. AWS Glue POC with Spark, Studio, Kafka, Kubernetes, workflow & Aurora. Educated team on advanced features to streamline ETL. Presented CEO with modern enterprise event based architecture based to meet requirements. Prepared Redshift to Snowflake Azure detailed migration roadmap, strategy, cost benefit analysis and code needed to migrate with zero downtime. Presented findings to IT leadership & executives.

Responsible for the leading retailer data platform migration from On-premise Hadoop to Snowflake/AWS, S3 data lake, Snowflake EDW data warehouse using Data Vault 2.0, Talend, Tableau & Microstrategy. Integration to SAP ERP, SAP BW, MDM Stibo, Customer Data Platforms like Segment & Lytics. Enterprise AI: Vendor management of Supply Chain Control Tower for Warehouse management, inventory optimization & demand forecasting dashboards. Identifying Snowflake ingestion patterns for the enterprise following best practices. Design of Snowflake HA/DR & Secure Data Sharing. Data Standards, Data Modeling, Canonical Models, information governance standards in agile environment. TOGAF, ABB & SBB.

Senior Snowflake architect –Leading health care company migrating its analytics to Snowflake. SaaS from PostgreSQL & new development, AWS, data warehouse, Data Vault 2.0, Talend, Tableau, IDERA data modeling tool, Architecture. Designed and implemented Snowflake data model, account setup/configuration, PII data masking strategies, RBAC security model Cost efficient & optimal scalable architecture. Daily administration, problem solving & performance monitoring.

Brand new implementation of AWS Redshift EDW & Data Lake. Working closely with the visionary CTO & Infrastructure Director to move the leading insurance company to the cloud and build first class enterprise cloud data lake in S3 & Redshift data warehouse platform for cost-efficient optimal scalable analytics solution to drive the business analytics to the next level.Hands-on data cloud architect provided architectural artifacts for:* Cloud vendor & technology stack selection* Roadmap & Strategy to move the enterprise to Modern Enterprise Architecture coming from legacy mainframe and Outdated SQL Server. The solution to deliver Enterprise view of the customer & property for the first time as we are joining 2 ERP systems then migrate to Guidewire. Results include significant cost savings & faster time to market.* High Level Design for data lake & data warehouse* developed Data Model for Redshift for business friendly reporting and migrate databases to Redshift* developed ETL CDC Data Pipelines to meet SLA* Working with analysts to select tables to migrate to AWS* Provided options (Snowflake) beside Redshift for POC with extensive Technology Matrix Comparison* Project was a success on time and on budget Data sources: mainframe & SQL Server. Architecture and implementation of databases, ETL to S3 & Redshift.

Support and enhancement of Center of Medicare and Medicaid (CMS) systems, Medicaid Management Information System (MMIS), State Medicaid Agencies (SMA), EHR, EMR, Federal Financial Participation (FFP), Data & Analytics Services (DAS), Center for Clinical Standards and Quality (CCSQ). Hadoop EMR Hive, Airflow, SAS Viva, Mainframe. Data Warehouse, Data Governance, Claims, Assessments, AWS, CMS MDM, Providers and Beneficiaries.

SaaS provider elected to migrate their EDW, Data Lake & Data Science Analytics platform from AWS Redshift to Snowflake. Audit, optimize and enhance their future Snowflake infrastructure, data model, design, Matillion ETL & S3 architecture. Recommend & implement optimal, scale-able & cost-efficient architecture. Design Data Sharing Strategy. Snowflake powerful SQL, Snowflake Functions to develop optimized scalable data pipelines and ETL.

Interface with chief of information security CIS, SVP & CTO to perform extensive audits of the enterprise data compliance. The leading enterprise migrating its whole infrastructure to AWS Cloud. In addition, they sold their largest bus unit. Audit to ensure that they are in compliance with strict regulations. I audited AWS Aurora, SQL Server EC2 & HortonWorks EC2 data. Performed complex analysis in summarized business terms and effectively communicated with technical teams & executives, running extensive queries. Submitted signed professional artifacts to meet future auditing needs to CTO & legal dept.Audited and documented current data warehouse ETL Process Flow down to SQL Queries and made recommendations as they are migrating their analytics/data lake to AWS S3, Glue, Athena, Python & Spark.

Global leader in manufacturing of renewable energy (wind & solar) equipments & sensors. Telemetry data collected at scale. Working with management, architects, data scientists & engineers to craft roadmap & strategy to guide in their due diligence to migrate to the cloud. Extensive evaluation of cloud vendors, products and technologies, documentation, demos to serve the company in key areas including data advanced analytics & data science scalability issues. Created powerful powerpoints to gain key stakeholders buy-in to highlight benefits, roadmaps and milestones. Understanding of Scada data, wind & solar advanced analytics use cases and competitive global market landscape. Presented architectures to meet requirements and staff skills.Technology comparison matrix, Azure Blob Storage, Data Lake, Data Warehouse & advanced analytics (ML) Data pipeline architecture in Azure Data Functions, Data Catalog & Azure Databricks. AWS Data Lake, Snowflake, Spark, Redshift, DW, Lambda, S3 & GCP storage. Project completed using half budget and timelines.

=AWS Professional Services - Healthcare HIPAA: -Brand new implementation of AWS Analytics & Data Lake. Design/implementation of AWS Data Lake & ETL pipelines for CDC from SQL Server to S3, Glue, Python SDK, Spark, Lambda, DMS & PII challenges. = Brand new implementation of AWS Redshift/Snowflake EDW & Data Lake. E-commerce: Cloud data warehouse, data lake, analytics landscape and tools/vendor evaluation. AWS Redshift & Snowflake with Tableau. Snowflake powerful SQL, Snowflake Functions to develop optimized scalable data pipelines and ETL. - DW Data modeling. - DW & Data Lake best practices-Data Governance Committee Charter,Policy & Program Charter-Business Intelligence Steering Committee Charter & Center of Excellence-Presentation to the executives on business case for Data Warehouse Initiative & Data Strategy--Identifying skills needed and interviewing candidates- Recommendations on Tableau Optimization=Streaming analytics: POC Real time Fraud detection using Spark Streaming, Spark ML, Kafka, Cassandra & Airflow=Health Care: Postgres DBA consultation on performance and migration to AWS HIPPA.Consulting e-commerce leader on Data Warehouse - Data Governance initiative and Center of Excellence, Evaluation of current state & recommendations on Future architecture of Business Intelligence & Predictive analytics (Machine Learning)

Irvine, Ca, Us

Taught graduate advanced analytics program classes in AWS technologies, Spark, advanced analytics, Big Data (EMR), MongoDB, Postgres, Python, R, Databricks, Jupyter, Zeppelin, Altrex & Databases. Technology coordinator for Data Science & Machine Learning graduate programs. Support real life projects using machine learning models in areas: fraud detection, predictive maintenance, customer retention & demand forecast..Created & managed the AWS account for the graduate program to provide Cost-efficient optimal account structure that delivered SIGNIFICANT COST SAVINGS to the university. Taught classes in AWS, Big Data & advanced analytics. Consulting professors, Data Scientists & Machine Learning graduate students to prepare/clean their big data for machine learning real life projects with leading companies in areas such as customer churn, fraud detection, demand forecasting and healthcare analytics. Python, R, RStudio, Zeppelin, Jupyter, Spark, ML.. Managed AWS program account security for in-house and external companies. Technical resource for the university on challenging AWS projects. Created and managed AWS account for cost efficiency.

=Brand new implementation of AWS Redshift EDW & Data Lake. Building telematics events data warehouse in AWS Redshift, GLUE, Python, PySpark, Spectrum, Paquet, Nested JSON, Kafka, ZooKeeper, S3 Data Lake.=Brand new implementation of AWS Redshift EDW & Data Lake. SPARK, PySpark for data scientists, dataframes, RDD, databricks, Python, R, RStudio, Jupyter, Anaconda, EMR, Zeppelin, SPARK performance and best practices. =Brand new implementation of AWS Redshift EDW & Data Lake. Technical Lead/Architect building next gen AWS data warehouse for community colleges. Managing AWS Data Lake. Redshift, S3, Data pipeline. Student Information System & Student Learning System.=Brand new implementation of AWS Redshift EDW & Data Lake. Telematics EDW & Analytics migration from Oracle, Informatica to AWS Hadoop, HortonWorks HDP, HIVE, Sqoop, Spark,Hybrid (cloud & On-premise) model for efficiency, Cost savings and meeting batch window.Led POCs for Informatica cloud. Recommended Tungsten for cost savings, performance & faster results.=Brand new implementation of AWS Redshift EDW & Data Lake. Consult Retailer building SaaS Multi-Tenant Point of Sale Cloud Analytics Application on cloud vendors selection, technology stack selection, database (SQL/NoSQL), data warehouse/analytics platform, BI/reporting tools & SaaS architecture options with documented cost benefit analysis and capacity plan, vendor negotiations. Initial architect for multiple vendors.Google Cloud SQL For Postgres, Cloud Shell, BigQuery.=Consult software vendor to audit current Oracle database configuration to perform and scale. Document database configuration audit, tuning recommendations and best practices.

- Over 3 dozens of successful Cloud EDW & Data Lake implementations using AWS Redshift, Snowflake, S3, RDS, GLUE, Spark, Python.- Business Intelligence Architect for JP Morgan chase to evaluate current state, evaluate BI tools and develop recommendations, roadmap & strategies. Appointed as a member in Architecture Review Board.- Lead Business Intelligence Architect for Sun Oracle BI Center of Excellence building Data Warehouse Reference Platforms for high profile clients from Infrastructure to DW implementations end-to-end managing Large data center & teams.- Selected to teach in University of California to Advanced Analytics Graduate Program (focus on AWS, Machine Learning & AI). Initiated & managed AWS account and architect/implement solutions for professors and Students.- Microsoft kimball: Started in data warehousing in the mid 90's with Big 4 company. Shortly after I joined Dr. Ralph Kimball 4 people team in InfoDynamics to build large data warehouse for Microsoft. - Technical Lead & Data Warehouse Architect for organizations like Health & Welfare Dept, Community Colleges Tech Center & a School District to design Infrastructure for DW implementations end-to-end in AWS Cloud TRYING to make a difference for students/colleges, benefits recipients and communities. Appointed to be a member in Architecture Review Committee.- Since 2014, Obtaining several AWS Architect Certification and selected to be authorized trainer for certified Amazon classes to architects & Big Data professionals.- Few Snowflake certifications as Technology Partner or Snowflake Pro. - HP: evaluated large number of leading BI tools and the eval was published in HP knowledge base as a technical resource for the enterprise in the late 1990's.-Sun: Performance Engineer: delivering best performance for Oracle ERP on Sun platforms

Principal Certified AWS Cloud Architect & Technology Partner. Azure, SoftLayer, Private & Hybrid cloud architecture & brokeringBig Data Architect - Hadoop (Cloudera & HortonWorks) , NoSQL (MongoDB)20+ years Business Intelligence/Data Warehousing Architect, DBA, performance engineerHelp companies move to modern enterprise architecture by incorporating Hadoop, cloud technology & NoSQL.Hands-on Leader of over 50 cloud, Hadoop, NoSQL, BI/DW & database evaluations and pilots that delivered high ROI.Cloud projects:Porting HIPPA SaaS Health Care application w PHI from AWS to AzureFast & cost efficient initial assessment. Requirements collection.Cloud vendors evaluationHybrid data warehouse & reporting using DynamoDB, Redshift & TableauOn-premise Oracle migration & Disaster Recovery/HA on AWSMySQL, MongoDB migration to MySQL RDS, AWS DynamoDBPostgres migration to AWS MongoDBAWS infrastructure & Media Streaming for social gaming company, CDN, recommendation enginePre-sales support, projects qualification & sizingAWS Machine Learning, predictive models & PythonBig Data Projects:Telematics IOT Trucking application - Storm, Kafka, Spark, HDPEDW Modernization, Claudera, TalendFast & cost efficient initial assessmentHadoop vendors evaluation & selectionInstallation, configuration, administration & optimization of Cloudera & HortonWorksData Discovery Sandbox, Customer 360, Data Lake pilotDatabase Projects:Installation, configuration, administration, security architecture, optimization and bench marking and stress testing of several SQL/NoSQL databases.NoSQL databases evaluation & selectionMigration from SQL to NoSQL platform like MongoDBNoSQL MongoDB modeling & optimizationSenior Oracle DBA for 10+ yrs.Data Warehouse, Business Intelligence:Data Warehouse modernization with Hadoop, performance tuning.Dimensional modeling for star schemaDatabase, storage and application performance optimizationSalesForce & Pivotal CRM integration

Newport Beach, Ca, Us

http://www.linkedin.com/company/cloud-migration-architectLeading Hands-on several cloud migration, cost optimization, technology stack selection, vendor evaluation, pilots & implementations for large enterprises or startups.Successful database migrations & optimization from SQL to AWS RDS SQL with near zero downtime. Drastic cost reduction, increase performance, reduce administration workload & eliminate need for patches & upgrades projects.Successful database migrations, modeling & optimization from SQL to AWS NoSQL with near zero. downtime. Improved performance, availability, scaling, simplified replication & reduce cost. Migrate Oracle DR to AWS Oracle RDS.Developing cloud migration roadmap & strategies for HIPAA Health Care SaaS application on AWS & Azure. Audit of AWS architecture & security model.

Kapolei, Hi, Us

Principal AWS Cloud Architect & Certified Technology PartnerBig Data Architect - Hadoop (Cloudera & HortonWorks) , NoSQL (MongoDB)20+ years Business Intelligence/Data Warehousing Architect, DBA, performance engineerHelp companies move to modern enterprise architecture by incorporating Hadoop, cloud technology & NoSQL into their architecture.Hands-on Leader of over 50 cloud, Hadoop, NoSQL, BI/DW & database evaluations and pilots that delivered high ROI.Cloud projects:Fast & cost efficient initial assessment. Requirements collection.Cloud vendors evaluation & selectionData Warehouse & analytics using Redshift, Tableau, PentahoHybrid data warehouse & reporting system using DynamoDB & RedshiftOn-premise Oracle migration to AWSOracle Disaster Recovery/HA on AWSMySQL migration to MySQL RDSMongoDB migration to AWS DynamoDBPostgres migration to AWS MongoDBMedia Streaming for gaming companyPre-sales support, projects qualification & sizingBig Data Projects:Fast & cost efficient initial assessmentHadoop vendors evaluation & selectionInstallation, configuration, administration & opimization of Hadoop for Cloudera & HortonWorks.EDW ModernizationTelematics Trucking use caseData Discovery Sandbox, Customer 360, Data Lake pilotDatabase Projects:Installation, configuration, administration, security architecture, optimization and bench marking and stress testing of several SQL/NoSQL databases.NoSQL databases evaluation & selectionMigration from SQL to NoSQL platefrom like MongoDBNoSQL MongoDB modeling & optimizationSenior Oracle DBA for 10+ yrs.Data Warehouse, Business Intelligence:Built over 50 large scale projects implementing data warehouse or data marts from end to end at different capacity from architect and/or DBA.Evaluation of databases, ETL tools & OLAP tools that was published by top tiers technology companies.Metadata creation & management.Dimensional modeling for star schemasDatabase, storage and application performance optimization