Experience

Precima, a NielsenIQ Company

• Canada
• Retail
• 1 - 100 Employee

• Data Engineer

  • Dec 2017 - Present

  Toronto, Canada Area - Senior Software Engineer at Nielsen IQ - Main resource for standard product development for different clients - Integration Lead in on-boarding new client's data - Account manager for multiple clients, overseeing data pipelines, data integration, change in existing data flows - Automated data load processes by implementing S3 bucket and Lambda in AWS - Performed data profiling, validation, acquisition and streamlining to efficiently provide information to downstream… Show more - Senior Software Engineer at Nielsen IQ - Main resource for standard product development for different clients - Integration Lead in on-boarding new client's data - Account manager for multiple clients, overseeing data pipelines, data integration, change in existing data flows - Automated data load processes by implementing S3 bucket and Lambda in AWS - Performed data profiling, validation, acquisition and streamlining to efficiently provide information to downstream applications and products in cloud-based AWS/Redshift/Snowflake environment - Lead / main resources in agile and traditional projects optimizing JIRA, Confluence, Smartsheet - Re-engineered multiple-week process from end to end, consisting of applications for data science and advanced analytics, by optimizing performance, standardizing and automating workflows. Reduced the 3 week SLA to 1 week SLA. - Assessed POC use-cases on other cloud (Azure), data warehousing / data processing platforms Technology: AWS, Snowflake, Python, IBM Netezza, UNIX, JIRA, Confluence, Control-M, BitBucket, SourceTree/GitHub, Azure

• Senior Business Analyst

  • Sep 2016 - Dec 2017

  Toronto, Ontario, Canada - Documented, designed and reviewed the process of onboarding a new retail data for customer analytics - Committee member of Data Design Review and reviewed data models, optimized DDL and designed solutions for standardized process for implementing additional data - Built a solution to transform the core base data into retail information required by other teams and implement them to the central transaction log table - Designed the workflows and created runbooks for incident responses… Show more - Documented, designed and reviewed the process of onboarding a new retail data for customer analytics - Committee member of Data Design Review and reviewed data models, optimized DDL and designed solutions for standardized process for implementing additional data - Built a solution to transform the core base data into retail information required by other teams and implement them to the central transaction log table - Designed the workflows and created runbooks for incident responses and user managements in AWS environment operations - Created user guides for loading data in Redshift - Exercised data modeling to build standardized data model Technology: IBM Netezza, UNIX, Smartsheet, Confluence, MS Office, AWS, Redshift



Scotiabank

• Canada
• Banking
• 700 & Above Employee

• Senior Programmer Analyst

  • Jan 2016 - Aug 2016

  Toronto, Canada Area - Technical lead in the team for multiple application systems, providing technical consulting and user support - Centre of Excellence for standardizing common classification domains for different projects - Responsible for resource planning and work effort estimation for project deliverables - Design, implement, and support infrastructure of the department - Technical resource to take and lead the Hadoop and Enterprise Data Lake initiative for AML data in collaboration with EIM -… Show more - Technical lead in the team for multiple application systems, providing technical consulting and user support - Centre of Excellence for standardizing common classification domains for different projects - Responsible for resource planning and work effort estimation for project deliverables - Design, implement, and support infrastructure of the department - Technical resource to take and lead the Hadoop and Enterprise Data Lake initiative for AML data in collaboration with EIM - Lead developer who effectively assigns deliverables to other resources and support them by making critical decisions and mitigating issues - Documented, reviewed, and assessed design documents and functional requirement documents as a lead technical resource - Lead developer to deliver solutions for client relationship management, compliance, and acquisition of new units - Mentoring other staffs and developers by guiding analysis, presenting the system flows - Developed and updated ETL processes and the system flows to optimize the efficiency of the daily operations - Thorough analysis on all domestic transactions for AML through Agile Project - Successfully completed the Scrum Master role by achieving all sprint goals and providing the report dashboards to senior management as well as the scrum team Technology: IBM DataStage, IBM QualityStage, IBM DB2, AIX, JIRA, MS Office

• Programmer Analyst

  • Mar 2011 - Dec 2015

  Toronto, Canada Area - Technical lead for multiple application systems, providing technical consulting and user support - Responsible for resource planning and work effort estimation for project deliverables - Lead developer who effectively assigns deliverables to other resources and support them by making critical decisions and mitigating issues - Documented, reviewed, and assessed design documents and functional requirement documents as a lead technical resource - Lead developer to deliver solutions… Show more - Technical lead for multiple application systems, providing technical consulting and user support - Responsible for resource planning and work effort estimation for project deliverables - Lead developer who effectively assigns deliverables to other resources and support them by making critical decisions and mitigating issues - Documented, reviewed, and assessed design documents and functional requirement documents as a lead technical resource - Lead developer to deliver solutions for client relationship management, compliance, and acquisition of new units - Mentoring other staffs and developers by guiding analysis, presenting the system flows - Developed and updated ETL processes and the system flows to optimize the efficiency of the daily operations - Awarded as Best of The Best Top Individual for 2015 by the company Technology: IBM DataStage, IBM QualityStage, IBM DB2, AIX, JIRA, MS Office



Royal Bank of Canada

• Australia
• Banking

• Technical Systems Analyst

  • Sep 2007 - Mar 2011

  Toronto, Canada Area - Performed analysis and developed Data Stage modules for efficient process to load and verify data in data warehouse - Provided technical consulting and maintenance support for 5 application systems and the system flows, focusing on problem management in advance and system fixes and maintenance releases. - Detailed investigation of Database environment for new projects’ initiations - Participated in the analysis and gathered requirements for new projects - Mentored team members in… Show more - Performed analysis and developed Data Stage modules for efficient process to load and verify data in data warehouse - Provided technical consulting and maintenance support for 5 application systems and the system flows, focusing on problem management in advance and system fixes and maintenance releases. - Detailed investigation of Database environment for new projects’ initiations - Participated in the analysis and gathered requirements for new projects - Mentored team members in junior position by guiding and demonstrating the analysis and action processes Technology: JCL, Z/OS, Teradata, IBM DataStage, MS Office Show less