Uploaded File
add photo
Candra
fransiscuscandra@yahoo.com
770-576-0698
720 Soneley Ct
Alpharetta, GA 30004
Sr. Data Warehouse Developer
24 years experience W2
03/16/2022
0
Recommendations
Average rating
49
Profile views
Summary

To seek challenging and professional career opportunities where my professional experiences and educational skills.

Experience
Sr. Data Warehouse Developer
Information Technology
Mar 2018 - Apr 2020

* Designing & building Data Warehouse using Snowflake schema design for monitoring Registration
process, Payment process, Exam process & Cycle maintenance process in Microsoft Azure SQL Server
2016 (on-premise and cloud). Processing data from multiple sources & process data using SSIS tool.
* Creating multi client data mart and keep improving better Database model by using Kimball’s data
modeling. Use Data warehouse Entity Relationship Diagram for business process.
* Created several Jupiter/Databrick notebooks written in Python, Py-Spark, SparkSql, Scala to process
data from/to Data Warehouse and supply Machine Learning model and perform some statistical
analytics report and graph. Created Machine Learning model in SageMaker & created API.
* Creating automated process for SSIS packages to run sequentially one after another with 24 hours
schedule time. The process also send automatic email when process completed or failed.
* Building 30+ calculated columns metrics to measure key metric business processes.
* Tuning several complex to gain faster processing time and processing smaller subset of data.
* Built SSIS packages to sync production DB to development DB in Azure cloud and on-prem intances
using powershell scripts.
* Created R scripts for data science programmer to pull data from data mart using ODBC connections.
Create security setting for users to access authorized tables, views, stored procedures.
* Working with data sciences analyst to queries to pull data from IBM SPSS
Technical Environment: MS Azure, SQL Server 2012/2016, SSIS, SSAS, Visual Studio 2016, IBM SPSS, R scripts in R-Studio, Jupiter Notebook, and Python .

Data Warehousing MS Azure SQL SQL Server Snowflake Hadoop Spark Data Marts Data Modeling Machine Learning PowerShell Python SAS Visual Analytics SSAS SSIS Visual Studio IBM SPSS Scala
Remove Skill
Senior Data Warehouse Developer
Information Technology
Jul 2015 - Feb 2018
  • Working in agile environment using scrum methodology to create/maintain datawarehouse solutions based on sprint method groomed by product owner using VersionOne and Jira.
  • Optimized complex queries and long stored procedures by gaining 60% improvement.
  • Developing dashboard and detail reports using Tableau, SSRS, SSAS and Tabular.
  • Migrating several Datawarehouse from on premise SQL Servers to cloud AWS Hadoop, AWS EMR, S3, Athena and Redshift.
  • Using Kimball dimensional model method, built Snow flakes and Star schema Datamarts with its SSIS, SSAS cubes, Tabular, SSRS/Tableau reports using Hadoop/AWS ecosystem to support product owner's products. Monitor, validate and informed critical processes.
  • Tuning queries to gain faster processing time and smaller processing data in SQL Server, Hadoop and AWS. Keep improving better Data Achitectural model.
  • Developing Tableau/SSRS report connecting to many data sources to AWS DataLake Presto, Redshift, Hadoop and SQL Server.
  • Developing validation processes for detail and aggregate data ensuring data credibility. Technical Environment: (Hadoop, AWS (EMR, Redshift, S3), PostgreSQL, Hive, Spark, SparkSQL PySpark, SQL Server 2008, Visual Studio 2014, Zappysys, SSIS, SSAS, Tabular, SSRS, Tableau, VersionOne, JIRA).
Agile Methodology AWS AWS S3 Data Warehousing Hadoop Hive Scrum Spark SQL SQL Server SSAS SSAS CUbe SSIS SSRS Stored Procedure Tableau Visual Studio
Remove Skill
Data Engineer
Information Technology
Aug 2011 - Jul 2015
Atlanta, GA

PSS Reporting and Metric Specialist Product Supply System Performance Management Scope of activities:

  • Created web-based Finance, Merchandising scorecard, Full-Service scorecard, Distribution scorecard, Supplier On time-In full scorecard, Breakage damaged & loss scorecard, Field-ops scorecard and Bottler scorecard using .NET C# 2008 with Tableau & ETL (extract, transform & load) processes from several systems (SAP, Matrix/Teradata/ASR, Basis, Kronos, GPS, Easytrax)
  • Using Cost Element accounting, we were able to build financial dashboard to track between Financial Accounting and Financial Control for Profitability Analysis in Profit Centers, Region and Entity.
  • Built financial hierarchy for orders, cost centers, cost element, G/L account, profit center
  • Implemented Master Hierarchy multi regions, areas and locations hierarchies, master data relationship with multiple scorecards. Technical Environment: (.NET C#, Visual Studio 2008/2010, SQL Server 2005/2008, MS VB, Access, Excel, SSIS, SSAS, SSRS, .NET Framework 4.5 Jscript, Dynamic SQL).
Data Engineering ETL Microsoft Excel SQL SQL Server SSIS SSRS Tableau Teradata Visual Studio
Remove Skill
PPIC Manager, Food Industry
Dec 2009 - Mar 2011
  • Managed Operation Warehouse with 5 areas (Receiving, Picking, Shipping, Production and Kitchen) with Standard Operating Procedure.
  • Managed finished and semi-finished good production including stock for Dry/Frozen/Fresh Goods including kitchen's spare-parts and mechanical supplies to 20 stores in Jakarta area.
  • Managed Quality Control and Assurance for Production and Warehouse for all goods.
  • Managed Daily and Weekly Purchasing for in-House production & Imported goods.
  • Developed, implemented/supervised transportation and delivery schedule for 14 trucks.
No skills were added
Remove Skill
PPIC Manager, Pharmaceutical-Customer-Medical Industry (Agt 2006 - Dec 2009)
Medical Devices
Dec 2005 - Dec 2009
  • Successfully implemented ERP with WMS and MRP/DRP and Transporta tion system in PPIC dept.
  • Managed planning & purchasing for 44 principles (import & local produced items).
  • Managed 23 Branch's Inventory Control with Direct & In-Direct System.
  • Managed Weekly & Monthly Purchasing & 3 Month Forward Purchasing.
  • Managed recall & returned damaged and expired items from all branches.
ERP
Remove Skill
Logistic Manager Nat DC, Pharmaceutical-Customer-Medical Industry
Medical Devices
Dec 2005 - Dec 2005
  • Agt 2006)
  • Successfully implemented SAP R3 ERP with W MS and MRP/DRP and transportation system (all packages) in national distribution center.
  • Managed consumer & pharmaceutical warehouses with total of 100 employees.
  • Managed weekly stock replenishment order using SAP.
  • Planning production for picking, packing & transportation for 32 branches including daily receiving.
  • Communicate with all branches for shipping & operational issues.
ERP
Remove Skill
Business Analyst, Information Technology
Construction/Engineering
Sep 2001 - Feb 2002
Logistics Group Asia Pte Ltd Business Analyst, Information Technology
  • Performed daily support in information system department from generating order up to piping data confirmation using EDI to National Singapore Semiconductor.
  • Supported customer tracking program for all packaging sent by UPS using internet & telephone.
Business Analysis
Remove Skill
Project Manager
May 2000 - Sep 2001
Project Management
Remove Skill
Customer Satisfaction
Banking/Financial
Jun 1999 - May 2000
  • Implemented pick-to-conveyor sys including slotted 20,000 skus into forward system TruckPro whs.
  • Implemented static shelf slotting system for tote picking by minimizing travel distance for high volume goods and proved to be efficient.
  • Created operation financial worksheet for distribution managers in managing their DC.
  • Defined central control desk processes & contingency plans in handling eight DCs for Y2K.
No skills were added
Remove Skill
Process Engineer
Information Technology
Jun 1999 - Jun 1999
No skills were added
Remove Skill
Implemented WMS
Nov 1998 - Jun 1999
in several distribution centers including Inbound & outbound process, zoning and slot naming system.
No skills were added
Remove Skill
Programmer
Information Technology
Aug 1998 - Nov 1998
Columbus, OH
No skills were added
Remove Skill
Engineer
Information Technology
Mar 1998 - Jun 1998
Cincinnati, OH
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Applied Mathematics
Ohio University
Certifications
Kimball Method Dimensional Modeling Certified with Snowflake and Star schema design
with Decision Works
Scrum Master Certified by Scrum Alliance
IBM Data Science Certification (Machine Learning with Python, Data Visualization with Python
Data Analysis with Python, Databases and SQL for Data Science, Data Science Methodology, Open
Source Tools for Data Science, and Python for Applied Data Science )
BigData Hadoop Certified by Dezyre
Tableau Software Developer Certified by Mikan Associate
AWS Certified by Qwiklabs for: Advance BigData on AWS, Advance Operations using Redshift
Compute and Networking on AWS, Websites and Web Apps
Skills
SQL
2020
8
SQL Server
2020
8
SSIS
2020
8
Visual Studio
2020
8
SSRS
2018
6
Tableau
2018
6
Data Warehousing
2020
4
ERP
2009
4
Hadoop
2020
4
Spark
2020
4
SSAS
2020
4
Data Engineering
2015
3
ETL
2015
3
Microsoft Excel
2015
3
Teradata
2015
3
Agile Methodology
2018
2
AWS
2018
2
AWS S3
2018
2
Data Marts
2020
2
Data Modeling
2020
2
Hive
2018
2
IBM SPSS
2020
2
Machine Learning
2020
2
MS Azure
2020
2
PowerShell
2020
2
Python
2020
2
SAS Visual Analytics
2020
2
Scala
2020
2
Scrum
2018
2
Snowflake
2020
2
SSAS CUbe
2018
2
Stored Procedure
2018
2
Project Management
2001
1
Business Analysis
2002
1