Data Analyst Consultant Resume

TECHNICAL SKILLS

SQL Server
SAS
SSAS
AWS
Oracle
Teradata
DB2
Postgres
SybaseIQ
Python
R
Spark
Scala
Java
C#
VBA
T - SQL
PL/SQL
Talend
Aginity
Netezza
HBase
Hive
Oozie
DataIku
Unix
Jira
Confluence

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst Consultant

Responsibilities:

Perform call center complex data migration and integration, conversion and data modeling
Restructuring data schema - redundancy checking, redefining business rules and resizing
Database system SQL Server query automation to support migration plan and strategy
DB & DW design, configuration, performance and support in QA and production environment

Confidential

Data Integration Analyst Consultant

Responsibilities:

Define & Rationalize banking business requirement and attribute - active customer, etc.
Consolidate customer marketing business requirement and constraint between US and Canada
Hadoop data table setup, map business entity onto schema, Hive & SQL query design, implement business logic for banking and wealth data flow, performance tuning and review data flow
Write SAS macro script, normalize, standardize data and data validation
Integrate different data sources and create ETL pipeline by PySpark, Hive HQL and SQL
Use and create project description, metadata and ticketing to share info by JIRA and Confluence

Confidential

Data Integration Analytic Manager

Responsibilities:

Propose data extraction, integration, data model implementation and validation design
Translate business problem into data model and procedure, and measurable plans
Conduct quality assurance strategy, ETL design, integration plan and development
Lead Hadoop data migration project and correct query insufficiency and performance issue
Identify inconsistency and availability issue in HBase NoSQL time series data
Create Oozie process workflow schedule automation to run program and update data mart
Lead credit card data integration project - plan, development, QA, schedule and maintenance
Perform data validation to assure data quality criteria - outlier treatment, missing record imputation, data normalization, standardization and apply business rules by Python
Prepare dimensional cube in monthly, finance, store, product category and vendor data
Write SQL and Unix script to manage flat file upload, cleansing and manipulating string
Integrate different data sources such as Oracle, Teradata and Mainframe
Build Python error trapping script incoming invalid data, auto issue notification and summarizes invalid data information during data generation process
Create OLAP cube for trend and yearly gap dashboard and quality control chart by SAS and SSAS
Support Loyalty Data Business Intelligence Project by SQL ETL and data standardization
Support Digital Marketing data enrichment to evaluate ecommerce shopping sites design and UX
Support Campaign Analytic Project to runs a Python ML model to target prospect customer

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship