Big Data Engineer Resume
2.00/5 (Submit Your Rating)
Emeryville, CA
TECHNICAL SKILLS:
Business Intelligence: Spark SQL, Vertica SQL, ETL, HDFS, YARN, JDBC, SSRS, SPSS, STATA, Tableau, UML, Data Migration, Data Warehouse, Data Visualization, Report and Dashboard Format and Configuration
Software Experience: Dbeaver, IntelliJ, Hadoop, PowerShell, Oracle SQL Developer 3.1, Oracle Zeal R12 ERP, SAP Logon 7 30, Center Stone B2B, MS Visual Studio, NetBeans, FileZilla, Visio, TortoiseSVN, JIRA
Programming Languages: SQL, Python, Java, C#, Scala, Stata ado, Html 5, Xml, Macro
PROFESSIONAL EXPERIENCE:
Confidential, EMERYVILLE, CA
Big Data Engineer
- Utilized Hadoop Distributed File System (HDFS) for data storage and Client Builder for data validation, parallelly loading data from Hadoop to Vertica database through multiple data nodes
- Wrote and optimized Spark/Vertica SQL scripts for ETL process for a provider group with 2 billion+ claims
- Configured Dimensions and Metrics in Pentaho Mondrian OLAP, build the reports in the cloud - based platform
- Migrated and managed the user/user favorites/roles between different Org Units
- Designed, implemented and deployed the SSRS reports (Monthly, HMO, UA) to the platform
- Implemented surgical and emergency dashboards for one of the country s largest payer and provider
- Handled and supervised the monthly data and content release for HCSC ER project (Kaiser and Blue Shield)
Confidential, CA
Data Implementation Analyst
- Facilitated the Center Stone B2B platform to configure and monitor the accounts, custom terms and sale orders
- Focused on data integration around SAP, SKU List and Line List to build the datasets for B2B platform
- Lead and created data catalogs, worked on the product data loading in the AMP platform for new season
Confidential
ERP Operation Specialist
- Maintained and updated the GE Support Central portal from GE library backend
- Facilitated the GE Zeal ERP community, designed and implemented the business workflows
- Supported the IDM (Identify Management) system and managed the IDM reconciliation
- Migrated large data from GE library to GE Box with Java 7 plug - in and assigned corresponding responsibilities
- Wrote the complex SQL code in the SQL Developer 3.1 and developed the ERP KPI reports by using Tableau
- Scheduled and hosted the monthly ERP module training for 2,000 ERP users from 9 global countries
Confidential, FL
Business Intelligence Analyst
- Used Trello to arrange projects in a timeline and connected to main server by TeamViewer and MS RDC
- Collected dataset from Amazon Seller Central, wrote the complex SQL query to drive business decisions
- Made revenue statistic forecasting by using SPSS t - test and did revenue regression analysis, chi-square test