Mark Anthony Claramo Email & Phone Number

Toronto, Ontario, Canada

• Automated the production of three key monthly reports submitted to the Ministry of Health and Ontario Health, reducing processing time from a full day to just 15 minutes per report and eliminating manual data extraction errors.• Proactively oversee, identify, and implement initiatives aimed at enhancing processes and creating efficiencies in the execution of government programs and strategic partnerships. • Responsible for consolidating, validating, and analyzing business data sourced internally and externally. Deliver accurate and timely insights crucial for strategic and operational decision-making, with a direct impact on Government Contracts and opportunities across Eastern Canada.• Partner with subject matter experts to extract, clean, and analyze intricate data from diverse databases. Develop reports and predictive models to assess the operational and performance metrics of government contract programs.

Toronto, Ontario, Canada

• Served as the data architect that reviewed and analyzed more than 10 data infrastructure, managed databases, and developed solutions that improved data processes and data reliability by 200%.• Migrated all manual Excel reports to the Power BI environment and improved the ETL (Extract, Transform, Load) processes, resulting in a significant reduction of approximately 500 hours per year in manual data extraction and report generation that improved data efficiency by 300%. • Led the end-to-end creation and documentation of six comprehensive data models, catering to four vendors and Rogers' internal teams in both connected home and wireless domains.• Collaborated closely with stakeholders to understand report requirements, delivering detailed insights into campaign and vendor performance for sales and marketing. Presented comprehensive analyses.• Led and managed a project focused on analyzing end-of-day campaign performance for four Vendors. This initiative enabled the team to swiftly ascertain the profitability of campaigns, extracting valuable insights, identifying trends, patterns, and areas for improvement. The findings facilitated the seamless fine-tuning of campaigns for enhanced effectiveness.• Deployed a data universe in Power BI that aligned all reports and equipped the channel to easily pull data for sales, marketing, operation, and finance needs. And developed all ETL processes in SQL server and SSIS packages for Telesales results.• Provided in-depth analysis and visual for business reviews and prepared comprehensive reports summarizing findings, recommendations and supporting evidence.• Collaborated with other internal departments such as finance, sales, marketing, and vendors to assess the ongoing profitable health of programs and IT and data governance team for data sources accuracy.• Conducted training sessions on data modeling and dashboard creation, empowering approximately 30 individuals, including analytics teams and stakeholders.

Toronto, Canada Area

• Won the Ted Rogers Award in Business Excellence for the Fall 2019 Quarter, recognizing the innovative Business Marketing Unified Dashboard. This initiative resulted in substantial cost savings for the marketing, including approximately $350K in API creation, $500K in data extraction, and an additional $500K in consultant fees. The dashboard efficiently consolidates information from over 20 data sources into a single, effective reporting platform. Sources include SEO, SEM, Chat, Invoca, and Rogers internal oracle and azure tables.• Created a customer segmentation project, utilizing historical data to discern the next best action. This initiative enhanced our understanding of customer needs and informed the development of targeted campaigns for optimal effectiveness.• Provided meaningful dashboards that enabled marketing, sales, and care team to easily track their campaigns and strategy performance and helped them came up with informative decisions.• Conducted frequent meetings with stakeholders to collect report requirements and identify opportunities for dashboard enhancements.

• Led, developed, and documented ETL processes and reports development from data gathering to maintenance and helped to ensure the integrity and reliability of data provided across business units.• Proactively introduced inventive concepts like anomalous sales, geographical revenue performance, unsolicited telecommunication rule violations and completion/fallout sales reports by harnessing internal and corporate data, offering executives a more comprehensive perspective to facilitate informed decision-making and drive business advancement.• Provided stakeholders weekly to yearly executive summary reports and scorecards for all call center performance and effectiveness in handling multiple campaigns, along with justifications for fallout sales in both inbound and outbound calls and for voice of the client surveys that used on their business reviews.• Managed four international call center vendors big data, delivering comprehensive analysis and valuable insights to executives regarding their performance and effectiveness in managing diverse inbound and outbound campaigns.• Resolved data inconsistency on both internal and external databases of all reports and dashboards by developing multiple checkpoints for each ETL stage and regularly met with IT prime across business units to clarify ambiguity of data to correct data sources and maintain data accuracy and reliability.• Led training for approximately 10 people for oracle (SQL and PL/SQL) and dashboard creation (Tableau and DOMO) and walk through on new data transformation for new projects among reporting team that increased the team’s effectiveness drastically.

Ncr - National Capital Region, Philippines

• Pioneered a Data Quality and Control Team responsible for developing and deploying all processes for the Oracle and Unix environment.• Created all reports with in-depth analysis of the company’s performance based on various campaigns.• Created all technical documentation and training materials that helped new hires with their training, effectively reducing a year of on-the-job training experience to only 3 months.• Liaised across business intelligence group, internal clients, and vendors to understand the data of new promos and campaigns which helped build/update all reports in Power BI and maintained data integrity.• Developed all tools and scripts for automation such as data check across multiple relational databases, scheduled refresh of reports using power BI and Tableau for data trend and Excel Macros for ad hoc requests.

Ncr - National Capital Region, Philippines

• Eliminated production issues by doing regression testing and provided excellent customer support by delivering their request on time or deploying urgent requests that require system update within the day with 7 days turn around to maintain good relationship with manufacturing clients.• Identified issues as well as organizing and enhancing global work instructions and procedures based on errors encountered during regression testing that prevents unusual cost due to incorrect specifications loaded in the system.