Business Intelligence Developer

• Nov 2022 - Present

Consultant

• Mar 2016 - Oct 2022

Day to day task involved with: -MircoStrategy Report/Dashboard Development -Design and develop reports on Mobile devices for Apple and Andriod -Developing Visual insights with Tableau including Mapping visualizations -Refine business requirements with business users and analyst -Create and design innovative solutions to resolve various software/data driven issues -Design, develop and scheduling ETL package through Informatica/SSIS -Create MicroStrategy Report utilizing FreeformSQL to query database bypassing the MicroStrategy architecture -Using calculations and data manipulation to create dataset which supports advanced visualizations -Generate data extract and preform data cleansing / transformation for data scientist team -Create and Design Tables / Views / Stored Procedures to support ETL and Reporting solutions -Create transactional report to allow user interaction with backend Database -Design MicroStrategy Schema Objects with best practice to allow precise reporting and utilizing MSTR's Object reporting environment to all user based ad-hoc reporting -Design and modify security model for Reporting environment and BI suite -Working with business user to understand then gather and document business requirement -Working with QA analyst to validate deliverables. Preform unit testing after development -Working in an Agile Development Environment as a team member. Good understanding on agile methodology -Provide feedback to team to improve teamwork and team coherence -Mentoring junior Consultants Environment worked with : MicroStrategy, Informatica, Tableau, Amazon S3, AWS Firehose, AWS Kineses , Amazon Red Shift, MS SQL Server, Teradata, Oracle Show less

BI Consultant

• Oct 2016 - Mar 2022

- Work with business user to gather and refine requirements. - Work with Migration data to AWS cloud stack utilizing AWS S3, AWS Redshift, AWS Lambda, AWS GLUE, AWS IAM and other AWS services. - Create solution for day-to-day reporting purpose and Advanced analytic purpose - Design and develop Informatica ETL for data transformation and manipulation - Provide training and support to Reporting users - Generate Data and provide extract for Data Analytics - Create Dashboards and Alerts for monitoring daily ETL process failure and issue - Manage user and access - Provide feedback and Agile implementation of continuous improvement - Create map Visualization with Tableau and MicroStrategy for Customer behaviour studies Show less

BI Consultant

• May 2016 - Oct 2016

Bell Media - Create BI reports on Hadoop impala to generate business insight on Bell TV - Work with Big Data developers to verify and re-design backend table in impala to support reporting requirement. - Work with QA analyst on making changes to improve existing reporting requirement PCCS - Customer Survey Dashboard - Create MicroStrategy logical view to generate high performance Reporting Cubes - Create transactional service with Tables and Stored Procedures to create interactive Survey app - Create real-time visualization and alert to highlight any actionable negative feedbacks to business user PULSE - MSTR mobile dashboards - Create multi-dimensional interactive Dashboard for all level of business user in the organization. - Designed Mobile and tablets dashboards for all users. - Create interactive dashboard which has talkback function to backend allows user to provide feedback and updates to other business users. - Implement security model to allow different level of business user access same Dashboard with different Level of Content Show less

Data Warehouse Consultant

• May 2013 - Mar 2016

Adastra Corporation is a world-class provider of Business Intelligence, Data Integration, Data Warehousing and Master Data Management solutions to leading organizations around the globe. Adastra bridges the gap between management and technology consulting to translate pressing business needs into workable and cost-efficient solutions. Adastra Corporation is a world-class provider of Business Intelligence, Data Integration, Data Warehousing and Master Data Management solutions to leading organizations around the globe. Adastra bridges the gap between management and technology consulting to translate pressing business needs into workable and cost-efficient solutions.

BI Consultant

• Nov 2015 - Feb 2016

Creating Microstrategy Reports and Documents Creating Microstrategy Reports and Documents

Business Intelligence Consultant

• Jun 2015 - Sep 2015

OMNI Channel Project -Creating operation and analytical reports for new Holt Renfrew E-commerce platform -Manage MicroStrategy Enterprise Objects and Object promotions -Modify current Reports to accommodate e-commerce data. -Verify reporting requirements OMNI Channel Project -Creating operation and analytical reports for new Holt Renfrew E-commerce platform -Manage MicroStrategy Enterprise Objects and Object promotions -Modify current Reports to accommodate e-commerce data. -Verify reporting requirements

Data Warehouse Consultant

• Mar 2014 - May 2015

BI Application Support -MicroStrategy platform maintenance and support -Modify current reports and Dashboards due to change request from business -Create store procedures for updating back end table -Fix dashboard issues Quality Assurance -Create test cases and run tests for end to end EDW project. -Create test cases and run tests for migrating Acute Patient Reports/Dashboards from Access to MicroStrategy -Create test cases and run tests for New Visual Insight Data discovery project in MicroStrategy -Verify business requirement and reporting requirement for New Emergency Department -Facilitate meeting to solve issues Business analyst -Translate business logic to reporting logic -Verify Business and Reporting requirement Show less

BI Consultant

• Oct 2013 - Dec 2013

Small and Medium Businesses Reports and Dashboards -Create MicroStrategy reports for Business Operation. -Create new objects to support reporting in MicroStrategy Enviroment -Preform project promotion for new dashboards Small and Medium Businesses Reports and Dashboards -Create MicroStrategy reports for Business Operation. -Create new objects to support reporting in MicroStrategy Enviroment -Preform project promotion for new dashboards

Business Intelligence Consultant

• Jul 2013 - Aug 2013

-Business Intelligence Consultant -Create new ad-hoc reports in MicroStrategy -Gather requirement on an outdated SQL Server for migration to new DB -Business Intelligence Consultant -Create new ad-hoc reports in MicroStrategy -Gather requirement on an outdated SQL Server for migration to new DB

Automation analyst (Co-op position)

• Jan 2011 - Sep 2011