Apr 2017 – Nov 2017 · 7 mos · Toronto, Ontario, Canada

Oct 2015 – Apr 2017 · 1 yr 6 mos · Toronto, Canada Area

• Design and implement Hadoop platform to support enterprise wide batch, real time, and ad-hoc data analytic and consumption
• Setup real time data ingestion using Apache Kafka and Flume
• Transfer data between Hive and relational DB using Sqoop and Fluidquery
• Develop ETL process using Spark, MapReduce, Storm

Sep 2014 – Sep 2015 · 1 yr · Toronto, Canada Area

• Developed ETL loading script for IBM Netezza database using UNIX shell scripting and SQL
• Developed Microsoft SSIS package for production data loading into Netezza using C# and .Net
• Designed and created Data model for financial trade and position data using Power Designer
• Developed visualization using Spotfire for ETL data quality report
• Developed an SQL Generator using Python Jinja2 template engine

Jun 2013 – Aug 2014 · 1 yr 2 mos · Toronto, Canada Area

• Analyzed existing client application data structure and evaluated different approaches for data model conversion from Business Object to MicroStrategy
• Lead reporting solutions development with member across different time zones
• Provided training to colleagues and business clients on MicroStrategy
• Overseen overall MicroStrategy reporting solution development across all projects
• Developed and coordinated implementation of custom MicroStrategy SDK scheduling solution

Mar 2013 – Apr 2013 · 1 mo · Toronto, Canada Area

• Reviewed and provided feedback on existing MicroStrategy data model, as well as creating data loading strategies.
• Developed MicroStrategy dashboard with unique visualizations using custom jQuery and SDK.
• Created data load monitoring services to for daily data loading services.

Nov 2012 – Feb 2013 · 3 mos · Toronto, Canada Area

• Resolved incoming MicroStrategy enhancement requests and bug fixes
• Automated MicroStrategy user entitlement information feed to auditing systems using distribution services and UNIX shell script.
• Performed MicroStrategy upgrade from 9.0.0 to 9.3.0 with stress testing and usability testing.
• Developed web customization using MicroStrategy SDK to accommodate the upgrade

Jul 2012 – Oct 2012 · 3 mos

• Developed data input application using MicroStrategy Transaction Services
• Created reporting dashboards with compelling visualization on data gathered
• Integrated MicroStrategy dashboards into existing company SharePoint site for maximum impact
• Recorded and published training video for intuitive user training

Jun 2012 – Jul 2012 · 1 mo

• Modeled and mapped data from source format to data warehouse for every reporting needs
• Developed ETL scripts that extracts data from source and loads them into the warehouse
• Developed MicroStrategy logical model that supports KPI reporting.
• Developed dashboard visualizations for KPI reporting

Feb 2012 – Apr 2012 · 2 mos · Vancouver, Canada Area

• Developed and maintained QPMS MicroStrategy dashboard
• Upgraded MicroStrategy from version 9.0.2 to 9.2.1 for all three environments with minimum downtime.
• Performed rigorous stress testing, user concurrency testing, and regression testing for each MicroStrateyg and database environment

Nov 2011 – May 2013 · 1 yr 6 mos

• Business analysis and requirements gathering
• Logical and physical data models including metadata
• Source system data analysis
• Source to target data mapping analysis and design
• ETL development and Quality Assurance
• Information delivery development and Quality Assurance
• Represent Adastra and Liaise with other client groups within the framework of a larger project team to deliver a unified solution

Nov 2011 – Feb 2012 · 3 mos

• Developed a MicroStrategy Mobile Dashboard Marketing demo together with Teradata
• Analysed and created data models for financial campaign management business cases
• Populated data model with semi-realistic campaign demographic data

Jan 2009 – May 2009 · 4 mos · Richmond Hill, ON

• Co-op Placement, where the main task is to develop company's internal content management system. The system is written Java based framework WebObjects.