Bachelor's of Science in Information Technology

BUSINESS INTELLIGENCE CONSULTANT

• Deliver assigned reports observing the report requirements and UX enhancements from the existing data sources on or before the due date.
• Assist the team in making sure the team will accomplish the deliverable with Quality, Functionality and UI/UX Reports that is expected within the deadline by doing Peer Reviews.
• Make documentations and presentations required with each report.
• Investigate and resolve escalated incidents and service requests that L1/L2 support cannot resolve.
• Diagnose issues in Data Engineering, Real-Time Analytics, Data Factory, Synapse Data Warehouse, or Power BI workloads in Microsoft Fabric.
• Work closely with Microsoft product support teams to report and fix bugs.
• Provide guidance on complex setup/configuration issues (e.g., Fabric capacities, security models, Gateway configurations and authentications, Power BI tenant settings).
• Capacity Monitoring via Power BI Premium Capacity Metrics app.
• Technologies used: MSSQL 2019, MS Planner, MS Power BI, Microsoft Fabric, Service Now

SQL DEVELOPER

• Develop and maintain complex SQL queries and functions in SQL Server.
• Create customized reports in the CargoWise tool by linking the SQL functions/queries with the appropriate Excel template.
• Collaborate with business stakeholders to gather reporting requirements and translate them into technical solutions.
• Develop and maintain technical documentation for reports and data sources.
• Troubleshoot data-related issues and provide solutions to improve data accuracy and reporting efficiency.
• Participate in team meetings to discuss project requirements, timelines, and deliverables.
• Technologies used: MSSQL 2019, CargoWise, VB for Applications (Excel), Azure DevOps, Teamhood, MS Power BI

REVENUE & COST ASSURANCE DEVELOPER

• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements
• Suggest and develop new queries
• Provide timely scheduled management reporting for the analyst
• Develop procedures and scripts for data migration
• Investigate exceptions and data inaccuracy
• Creation of ad-hoc reports
• Power BI Report creation, enhancements, development and bug fixes
• Connecting data sources, importing data, and transforming data for Business Intelligence
• Collaborated with end-users to establish knowledge base and equip them on using dashboards and SQL
• Perform DAX queries and functions in Power BI
• Maintenance and updating of the team confluence pages
• Enhancements and bug fixes of existing SharePoint forms
• Technologies used: MSSQL 2014, 2016, 2019, MS Power BI, VB for Applications (Excel), MS PowerApps, Confluence, JIRA

SME – SQL DEVELOPER

• Develop, implement and optimize stored procedures and functions using T-SQL
• Analyze existing SQL queries for performance improvement
• Develop procedures and scripts for data migration
• Provide timely scheduled management reporting for the analyst
• Assigned tasks and peer reviewed analyst work
• Manages databases
• Developed a time tracker application
• Make enhancements requested by users, perform testing and do bug fixes
• Technologies used: MSSQL 2012, 2014, Microsoft Access 2013, VB for Applications (Excel)

APPLICATION SUPPORT SPECIALIST

• Provide assistance as an L2 Support to frontline tasks when the need arises
• Incident validation and evaluation to confirm severity
• Rotational support for issues reported by client, business and/or implementation teams
• Receive tickets for analysis, further evaluation, resolution and/or escalation
• Created reports and interface laboratory instruments as per user’s request
• Evaluate problem resolutions and delivery of application changes to anticipate impact to business and users in order to keep the user community well informed.
• Technologies used: Crystal Reports XXI 2013, SSRS, MSSQL 2005, 2008 R2, 2012, VB.NET, VB6.0

JR. DEVELOPER

• System support and maintenance for existing application
• Development of change request and enhancements requested by clients
• Aided in deploying and implementing the existing application for the clients
• Diagnosing and rectifying performance issues
• Maintaining continuity throughout all websites both technically and creatively
• Mentoring team members in development and technical progression
• Develop a data management application using VB for Applications (Microsoft Access)
• Technologies used: PHP (CodeIgniter), JavaScript, jQuery, MySQL, TortoiseSVN, MSSQL 2008 R2, MS Access 2010, C#.NET