Peter J. Email & Phone Number

Mississauga, On, Ca

Toronto, Ontario, Canada

- Discover and understand clients' needs.- Design solutions across development, configuration, integration, and security.- Create proposals, presentations, estimates, and documentation.- Lead successful implementation of automated solutions.- Engage with business users and decision makers at all levels.- Deep knowledge in Power BI, Fabric, Power Platform, Power Automate, and Power Apps.- Mentor, coach, and lead team members.- Articulate ideas, develop, lead, and support team members.- Change management.- Adapt quickly, be flexible and practical to meet deadline and commitments.- Embrace change and take ownership, while creating a fun environment.

Toronto, Ontario, Canada

- Work in a scrum-based team that is passionate about data. - Enable a data culture throughout the organization.- Support the development of scalable and robust data pipelines.- Complete and maintain source to target mappings templates and associated metadata.- Support the advancement of Analytical models.- Collaborate with Data Modelers and BI Analyst.- Anticipate and translate business needs into actionable data solutions.- Create Data Visualization prototypes to support the elicitation of Business needs.- Maintain Jira content relevant.- Ensure the reports of the team progress reflect the team velocity and capacity.- Break down strategic problems, analyze data and information.- Provide subject matter insights and recommendations.- Document and maintain operational procedures and processes relating to analytics and reporting.- Assist in the ongoing changes resulting from the roll out of Clickatell’s Data Strategy.- Change management.

Mississauga

- Act as a data steward providing ETL, intelligence gathering, and analysis.- Extract and consolidate data from SQL, Azure, Salesforce, Oracle, Excel, JIRA, CRM., and SharePoint.- Streamline data flows, tasks, and processes using Microsoft Power Automate.- Assemble an easily accessible relational database based on multiple data sources.- Control data quality and data drift.- Develop a live NPS dashboard in Power BI to increase call center efficiency.- Create a Utilization Dashboard in Power BI to increase resource productivity.- Create a Revenue Report in Power BI to improve financial visibility.- Initiate a Backlog analysis to strengthen portfolio of projects.- Design a Quotation online tool in Power BI to increase sales.- Create a Compliance dashboard in Power BI to track time sheets.- Standardize On Plan tracking in Power BI to increase reservation accuracy.- Communicate recommendations based on provided analysis.

Scarborough

- Combine data from CRM systems using Excel, VBA, SQL, and Power BI.- Enhance data integrity in Microsoft Dynamics to break departmental silos.- Assess risk sensitivity via quantitative analysis.- Analyze variances and deviations to improve forecasting.- Implement an equipment density analysis to generate marketing insights.- Create a premature replacements analysis to improve the bottom line.- Create and present innovative data analyses to support strategic decisions.- Create a streamlined performance-based commission structure.- Generate leads for sales by creating a lead source analysis.- Collaborate with call center agents to improve productivity via behavior analysis.

Mississauga, Ontario, Canada

- Act as a data steward for insurance data.- Consolidate data from multiple internal and external CRM systems and databases.- Support and test implementation of a new insurance CRM system.- Create an insurance portfolio analysis to help increase bargaining power.- Create financial models of underwriting scenarios to minimize risk.- Reconcile accounts and analyzed variances to improve financial forecasting.- Investigate trends in insurance claims, reserves, and costs to generate insights.- Analyze vendor payments to eliminate revenue leakage.- Analyze claims data, identify, and address risk factors to reduce costs.- Research marketing offers to forecast financial impact of changes.- Analyze sales data and created bundles to increase penetration and revenue.- Perform pricing analysis to adjust premiums.

Oakville, Ontario

- Consolidate data from IBM Cognos, Access, SAP, Salesforce, and Excel reports- Perform extraction, clean up, and formatting of large data sets using VBA and SQL.- Provide data to increase accuracy of financial forecasting.- Resolve data quality issues in implementation of SAP.- Create a profitability analysis to increase margins.- Create valuation models for mergers and acquisitions.- Contribute to creation of the pricing model.- Create a revenue leakage analysis to drive $4M in revenue.- Identify trends in financial, sales, and operational data.- Create automated sales reporting dashboards to increase productivity.- Restructure books of business to drive 105% growth in sales.- Create an analysis to increase customer retention to 95%.- Run sales contests and recognition programs.

Ba With Honors, Economics, 3.6

Activities and Societies: Investor's club Advanced statistical analysis Advanced micro and macro economics Accounting Corporate finance.

Bachelor Of Science - Bs, Computer Science, 3

Java C Advanced logic Algorithms Multi-variable calculus