Work Preference
Summary
Overview
Work History
Education
Skills
Certification
Software
Work Availability
Accomplishments
Timeline
Generic
JAMES DIKKO PASCUA COMPARES
Open To Work

JAMES DIKKO PASCUA COMPARES

SQL Developer, Integration Engineer, Power BI Developer
Vallejo,CA

Work Preference

Job Search Status

Open to work
Desired start date: 2 weeks notice

Desired Job Title

SQL DeveloperApplication Support Senior AnalystApplication Development Associate ManagerPower BI DeveloperIntegration Engineer

Work Type

Full TimePart Time

Location Preference

RemoteHybrid
Location: Vallejo, CASan Francisco, CA
Open to relocation: Yes

Salary Range

$70000/yr - $200000/yr

Important To Me

Work-life balanceCompany CultureFlexible work hoursWork from home optionCareer advancement

Summary

Results-driven IT Specialist with over 10 years of experience designing and optimizing data solutions in the Microsoft ecosystem, including MSSQL, Power BI, and PowerShell. Developed scalable data integrations and reporting platforms that empower organizations to make informed decisions. Enhanced data processes to improve efficiency and accuracy in reporting.

Overview

11
11
years of professional experience
3
3
Certification

Work History

SQL Developer | Integration Engineer (Remote)

BC Solutions Pty Ltd
Taguig, Philippines
07.2023 - 11.2025
  • Designed and optimized SQL queries, stored procedures, and ad hoc reports to support daily operations.
  • Developed and maintained SSIS packages to automate ETL processes and enhance system integrations.
  • Integrated data from other sources into the core servicing platform and data warehouse.
  • Automated routine tasks and data operations using PowerShell scripting and API calls to streamline workflows.
  • Supported and enhanced the core servicing platform through fixes, automations, and building new processes.
  • Created SSRS reports and Power BI dashboards to provide actionable business insights for decision-making.
  • Collaborated with stakeholders to analyze requirements and deliver reliable data solutions.
  • Provided support for Microsoft Fabric to maintain system functionality.

Application Development Associate Manager (Remote)

Accenture Inc.
Mandaluyong City, Philippines
02.2021 - 06.2023
  • Designed, built, and supported data migration system for integrating customer records from diverse source systems into Salesforce.
  • Analyzing batch feed processes, data flows and Salesforce automations to further optimize the data migration process.
  • Reconciled processed records to ensure high data quality throughout migration process.
  • Collaborated with cross-functional teams to identify and address dependencies among system components.
  • Collaborated with client to design data migration strategies.

SQL Developer

ColCap Servicing Pty LTD
Taguig City, Philippines
07.2018 - 02.2021
  • Designed and developed tools and functionalities to meet new business rules and requirements.
  • Enhancement and maintenance of the data warehouse for dynamic reporting and data integrations.
  • Created and enhanced reports to support business decision-making and performance monitoring.
  • Type of reports includes simple to complex that help executives visualize the status of the business.
  • Automated critical processes in main system, reducing risks of errors from manual interventions.
  • Resolved data issues through ad hoc queries to ensure data integrity.

Application Development Senior Analyst

Accenture Inc.
Mandaluyong City, Philippines
05.2017 - 05.2018
  • Led Scrum team in agile development processes.
  • Facilitated scrum activities, including sprint planning, daily scrums, and sprint retrospectives, to ensure team alignment and progress.
  • Designed and implemented enhancements for internal reporting system using Microsoft technology (SSRS and SQL server) to improve data accessibility.
  • Analysis of requirements (such as update of the systems logical behaviour, change in metric calculation, adding capability on the system, etc.), providing estimates and delivering into production.
  • Investigated and resolved issues promptly to minimize system downtime.
  • Dev lead backup tasked to monitor and organize development team's work.

Application Support Senior Analyst

Accenture Inc.
Mandaluyong City, Philippines
04.2014 - 04.2017
  • Leading a team of 9 to provide support to clients on the various software developed by the factory.
  • Maintained reporting functionality of various software and created customized reports for management and clients to enhance data visibility.
  • Investigated root causes of reported discrepancies and proposed fixes to improve system reliability.
  • Provides workaround to minimize the effect of the known bug/limitation of the system and deliver services based on the client requirement particularly on reporting data from the database.
  • Managing the team's workload and monitoring for daily deliverables.
  • Automated manual processes executed by the team to streamline operations and reduce resource expenditure.

Education

BS - Electronics & Communications Engineering

University of Saint Louis Tuguegarao
Tuguegarao City, Cagayan, Philippines
04-2013

Skills

  • MS SQL Server
  • ETL
  • Data Integration
  • Data Migration
  • SSIS
  • SSRS
  • Power BI
  • DAX
  • Power Query
  • VBA
  • Microsoft Fabric
  • Power Automate
  • Query Optimization
  • Data warehousing
  • Attention to detail
  • Collaborative teamwork

Certification

70#461, Microsoft

Software

Visual Studio Data Tools

Power BI

Microsoft Fabric

Microsoft Excel

Microsoft SQL Server

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Accomplishments

  • Database integration - Executed SQL Server database migration and consolidation, merging systems into a single instance to reduce costs and streamline ETL and reporting.
  • Portfolio Parameters dashboard -Developed an end-to-end SQL Server–driven Power BI dashboard for Treasury, enabling management of investor rules and covenants, monitoring loan exposure and capacity ($ and %), and proactively identifying potential breaches.
  • Bullet loans product - Automated the special product's processing by developing SQL Server stored procedures and PowerShell scripts to execute API calls, calculate loan balances, and post monthly anniversary transactions.
  • Microsoft Fabric SME - Assumed ownership of Power BI and Microsoft Fabric administration, supporting 15 multi-page dashboards and 20+ semantic models, integrating data from SQL Server, data warehouse, SharePoint, and D365.

Timeline

SQL Developer | Integration Engineer (Remote)

BC Solutions Pty Ltd
07.2023 - 11.2025

Application Development Associate Manager (Remote)

Accenture Inc.
02.2021 - 06.2023

SQL Developer

ColCap Servicing Pty LTD
07.2018 - 02.2021

Application Development Senior Analyst

Accenture Inc.
05.2017 - 05.2018

Application Support Senior Analyst

Accenture Inc.
04.2014 - 04.2017

BS - Electronics & Communications Engineering

University of Saint Louis Tuguegarao
JAMES DIKKO PASCUA COMPARESSQL Developer, Integration Engineer, Power BI Developer