OBJECTIVE

Experienced Business Intelligence and Systems Analyst is looking for new projects with immediate availability.

CORE SKILLS

•Broad in-depth knowledge of Business Intelligence and Systems analysis principles, techniques, and best practices.

•Strong experience in gathering and documenting business requirements from high-level (BRD) to technical specifications.

•Extensive experience working in Manufacturing, Logistics, Financial Services, P&C and Life Insurance sectors.

•Able to learn and deliver new skills quickly and accurately.

•Great interpersonal and people communication skills.

•Work well as a team member and project lead.

•Strong analytical and problem-solving skills.

•Always working on deliverable and end-to-end sound solutions.

CAREER ACHIEVEMENTS

Business Intelligence and Systems Analytics Consultant Panvela Corporation 2005 – Present

•Contracts specializing in BI and Systems Analytics projects.

Systems Consultant Toronto Hydro 2011 – 2013

•Designed and developed complete back-to-front-end solutions involving complete cycle development process:

•Oracle/Excel (data source) -> SAP BO Data Services (ETL tool) -> Netezza 4/5(data target) -> Business Rules (stored procedures using NZPL/SQL, ETL Transforms) -> Reporting Data Mart -> BO Universe (meta-data layer) -> Reports (Web Intelligence) and/or Crystal Reports -> Business Requirements and Design Specification Documentation

•Defined DS Datastore Configurations and Aliases to provide universal integration in DEV, TEST and PROD environments

•Created Data Services Central and Local repositories and used them for development, unit testing and Label Based promotion

•Designed data conversion process using SAP BusinessObjects Data Services (ETL jobs, data/work flows design, ETL transforms) with integration mechanisms to allow for reliable process of data loads and e-mail status notifications

•Created ETL Data Services to extract data from Oracle 11g database, store it on a staging Unix server, then use custom file transfer program SFTP to send 48 reports in .txt and .csv formats to a remote network directory using Korn shell script commands

•Provided production release and post-production support of 44 Web Intelligence reports for Finance Department including IFRS and CGAAP financial statements (i.e., Balance Sheets, Income Statements/Retained Earnings, Summary Pages and Notes). Implemented service requests for reports layouts and core logic troubleshooting and change requests comparing source reports data hosted on SAP ERP 6.0 SR 3.

•Provided technical support with change and incident management tasks using ITIL-compatible BMC Remedy 7.5 tool

•Migrated existing Crystal Reports and Web intelligence documents from SAP Business Objects Enterprise platform 3.2 to 4.1, including testing of SAP BO Data Services 14.1

•Created ETL Data Services to extract data from Oracle 11g database (PL/SQL), store it on a staging Unix server, then use custom file transfer program SFTP to send 48 reports in .txt and .csv formats to a remote network directory using Korn shell script commands

Business Intelligence Analyst III ERCO Worldwide 2013 – 2022

•Advanced reports and dashboards development with Microsoft Excel and Power BI

•Extensive experience using SAP BusinessObjects BI platform and tools (SAP Web Intelligence and Crystal Reports)

•ETL design and development with Azure Data Factory, Data Flows and SAP Data Services

•Near-real-time data ETL implementing CDC (Change Data Capture) on MS SQL Server

•SAP BI Platform ETL migration from in-premises to Azure Cloud SaaS (PaaS and IaaS) infrastructure

•SAP Business Objects BI Platform and Data Services (ETL) administration

•Maintained existing and developed new ETL processes using SAP BO Data Services and Microsoft SQL Server jobs to provide near-real-time data availability for BI reporting solutions used by Finance & Sales, Transportation departments

•Developed T-SQL queries, functions, views, and stored procedures with SQL Server to support SAP BO Data Services and universes

•Provided timely issue resolutions and production support for worldwide enterprise BI reports users

Used: Azure Cloud Infrastructure, Microsoft Power BI, Azure SQL Database, Azure Data Factory, Azure Data Sets and Data Flows, Microsoft SQL Server Enterprise Edition, SAP BusinessObjects Enterprise, Web Intelligence, Crystal Reports 2016, SAP Data Services, Oracle J.D. Edwards Enterprise One (ERP), Microsoft SharePoint, Salesforce.

EDUCATION: Technology University College Diploma

Contact this candidate