Kevin Pham Email & Phone Number

- Data architect and design- SQL development- SSIS development

Toronto, Ontario, Canada

- Azure development- PostgreSQL to TSQL Azure- SP / Views development / migration into Azure Synapse

- Implementation/Development of Billing Engine- Power BI and SSRS development- Open Reports- SQL/SSMS development - DataLake development

Toronto

• During the first month of employment, 24,000+ records were discovered to be missing "NAICS" codes through data analysis.• Extracted the missing records, and through SQL logic, provided a "solution" to fix over 24,000 records that were missed from data migration.• Collect and analysis data on SQL server 2008 to develop reports for Collective Bargaining Information Services (CBIS). The reports includes but not limited to weekly wage and collective agreement reports, monthly highlights, quarterly work stoppages and ad-hoc requests from the minister's office.• Built new reporting capabilities such as drill-down of summarized data to perform DRS file auditing. This provides the capability to ensure DRS files are created properly by DRS staff.• Building automatic audit reports against DRS data and provide DRS users the tools required to monitor DRS files and it's "completeness" and status.• Working with complex data to provide data analysis and reporting for Mediation and Conciliation services.• Developed reporting processes using BusinessObjects 3.1/4.0/4.1 and provide user training to ensure DRS users are able to deliver reporting as needed.• Help configured reporting users and provide access to Business Objects reporting web portal (InfoView) for both ad-hoc and schedule reports.• Developed Business Views using BusinessObjects Business View Manager against BusinessObjects 3.1 in Unix platform. These Business Views contains Data Connections, Data Foundataions, Business Elements, and List of Values (LOVs) which enable dynamic parameters through SQL views, store procedures, and tables.• Developing DRS universe using both IDT (Information Design Tool) and UDT (Universe Design Tool) with Dimensions, Details and Measures against DRS database to enable business users to develop their own reports and/or change reports view "on-demand" using WebIntelligence (WEBI).

• Designed and Implement an enterprise solution for Reporting using Business Objects Enterprise XI R2 to support 5,000+ users for a the TD Bank Voyageur project; a join venture between IBM, Bell and TD.• Solution Architect for Rogers RFP. Scope, Designed, and Proposed a BusinessObjects XI R3, Cognos, or Cisco CUIS presentation layer with ETL scripts pulling data into a new Data Mart. The solution will port over 65 existing and 9 “Net New” dashboards into the new Reporting Solutions.• Solution Architect for Bedrock (Bell). Customer will be using Cisco CUIS as their reporting presentation layer. As well as gathered requirements, provided estimates, developed, and documents for 22 Call Centre Skill Groups, Call Types, and Agents reports.• Solution Architect for WCB (Workers’ Compensation Board – Alberta). Customer is moving from Cisco’s WebView reporting solution to Cisco CUIS as their reporting presentation layer. Gather requirements, provided estimates, developed and documents for 6 Call Centre Skill Groups, Call Types, and Agents reports.• Developed Custom Reports for Honda Project on Cisco Customer Response Solutions. Honda is using Cisco UCCX Historical Reports platform with Crystal Reports XI.• Reporting Architecture for short term Shoppers Drug Mart Project using Crystal Reports Application Server (Crystal Reports 2008 Embedded Edition).• Designed and Implement Disaster Recovery Plan and Load Balancing to meet customer’s requirement of 99% up-time. • Developer and support the development of Portal applications based on the BusinessObjects XI R2 SDK.• Analyze submitted COR’s and determine if report(s) meet strict design guidelines and provide detail feedback on recommendations of changes in order to pass the MAC process to promote reports between environments.• SQL Queries using DB2 Command Editor and Toad for SQL Server 3.2

- Developing Reports with Crystal Reports XI - Consulting and development work with BusinessObjects 6.5- Consulting and development work with BusinessObjects XI R2- Universe Design with BusinessObjects XI R 2- Custom Applications development- Heat Administrator

• Gather requirements from upper Management in order to develop and implement “Automated Crystal Reporting Services”• Work closely with the IT Department to implement and develop Crystal Reports, leveraging the scheduling, delivery, and ad-hoc features from Crystal Reports XI R2 Enterprise Server.• Reports Requirement Gathering, Development and Implementation of Crystal Reports XI R2.• Development of Dashboards and Reports using Crystal Reports XI R2 and Xcelcius Workgroup 4.5.• Data Validation using Toad for SQL Sever.• Provide technical solutions such as development of internal Intranet site in order to automate processes and reduce cost.• Develop financial reports on a daily basis in order to reduce internal resources set aside for reporting.• Managed all reports scheduling within Crystal Reports Server and auditing of scheduled task to ensure 100% deliver of confidential Management Information Reports.• Multiple Reports Design using complex Cross Tab, Sub-Reports, SQL Expressions, running totals and Crystal/Basic Formulas in a MS SQL environment using Query Analyzer for Data Validation.• Developed an XML application that parses call centre data and populates the database for reports development.