OBJECTIVE To give my best effort in an organization by accepting new challenges and finding new ways to achieve the desired result in any worst situation.
SUMMARY OF QUALIFICATIONS • Create dynamic and informative meaningful forecasting models using PowerBI dashboard, can collaborate with cross-functional teams to understand their analytical needs. TECHNICAL SKILLS:
Software
• PowerBi (and integrate to MS PowerApps), DAX, Power Query/M, Crystal Reports 8, 9 and XI, Crystal Enterprise/Crystal Management Console/ePortfolio, using LDAP and APOS for security.
• Labware LIMS v6/7(Laboratory Information System), Aprimo (Marketing Management tool), LDAP
• Microstrategy 9.2.1 (and version 8), Microstrategy Intelligence server, Narrowcast Server and Object Manager Oracle Business Intelligence Enterprise Edition (OBIEE) ver. 10
* Develop prototype dashboard for PoC from QlikView, Tableau, SSIS, SSRS, PowerBi integrate with PowerApps Production Support Tools:
• SourceTree, Stash, GitHub, ServiceNow, TFS (Visual Studio Team Foundation Server 2013), Remedy System; Teradata SQL Assistant, Changeman DS/ALM, DW Job processes/ETL, Unix/Solaris, Oracle SQL Developer, Control/M Languages:
•PL/SQL, MS SQL, VB 5&6 using DAO/ADO thru ODBC, ActiveX, J2EE, JSP, Java, JavaScript, Servlet.Net, C#, Eclipse(IDE), HTML using Dreamweaver MX, Oracle Forms 6i, Oracle Reports R6i, JDeveloper 9i,Unix Scripting, XML, Vignette Portal ver 7.2.1
Application Server: • Websphere, Bea Weblogic
Database/DataSource: •OData, Sharepoint, DB2, Teradata, Netezza, Oracle Database 9i/8i, SQL* Servers ver. 8, MS Access 95/98/2000, Informix
EXPERIENCE(s):
Telstra Health (under TOA - The Outsourced Accountant Global) Nov 2023 – April 2024 Power BI Specialist
• Developed and designed meaningful forecasting data models for Asset Register Management, enabling efficient tracking and management of assets using meaning full and simple visualization across the organization.
• Re-Design Customer Ageing Invoices Dashboard from Power Query to DAX code, optimizing query performance for faster refresh and more precise results.
• Creating dynamic and informative dashboards for Finance and Accounting departments, providing key stakeholders with real-time insights into financial performance metrics, trends, and forecasts.
• Utilizing advanced techniques in Power Query to extract, transform, and load data efficiently from various sources ODATA, SQLServer, Sharepoint, Excel, ensuring data integrity and accuracy.
• Collaborating closely with cross-functional teams to understand their analytical needs and requirements, and translating them into actionable insights through PowerBI solutions.
Macquarie Group Services (Philippines), Inc. Feb 2023 – July 2023 DevOps Engineer
• Support In-house Sales and Research, Publishing, Editorial Finance research application handles investigation, debug and bug fix create permanent fix.
• Tools handled SQL Developer, SQL scripting, SourceTree, Stash, GitHub, SSRS, Excel, Power Bi (integrate to PowerApps), Arturo.
Tata Consultancy Services/TCS (client: Philippine Depository and Trust Corporation (PDTC May 2022 – Feb 2023 Production Support
• Provide Support on TCS Bancs system, handles investigation and debug the system from bug issues, create workaround and propose solution for permanent fix.
• Coordinate with Developer, DBA, network team and business users for minor/major changes needed.
• Tools handled SQL Developer, Unix Scripting, Putty, WinScp Alorica Asia ROHQ, Ltd. Nov 2020 – April 2022
Reporting Analyst
• Gather Report requirements document what Database, Tables, Fields/Columns, report samples, report formatting, how users wanted to use/send reports via email, from website, automate run time, etc… and create Technical Documents for Developers.
• Analyze required fields and map fields from existing to the new platform.
• Coordinate with Developers and Project Managers making sure deliverables on time.
• PROJECT: Develop/Support - Enhance/Modify (PowerBI) EMC (Enterprise Manpower Capacity) dashboard upon request by Executive (VPs)
• Process all gathered Rawdata from different Location/clients to be used in EMC.
• Create/develop VBA/Macro for faster processing of EMC RawData.
• Making sure (POWERBi Dashboard) EMC information are accurate and run on time for Executive meetings UL Verification Services Philippines PLC. Aug 2014 – Feb 2020 Subsidiary of UL (Underwriters Laboratories)
Programmer Analyst
As Production Support Level 2 & 3 handling maintenance on bug fix and enhancement on LIMS 6 for Business/End users. Coordination with other IT groups (Vendor, DBA, Network) on identifying/fixing major/complex issue.
• Support the Labware LIMS 6 (Laboratory Information Management System) develop/code using Subroutines, Analysis, Access Routine, Query Tags, Report Templates, Test List, User Dialog, Protocols, Rules and Events Manager, Change Manager and Visual Workflow.
• Write/rewrite SQL, Oracle PL/SQL, Stored Proc in LIMS v6 for Crystal Reports, create/deploy package, coordinate with DBA on proposed changes.
• Create SQL queries for Metrics reports (Daily, Weekly, Monthly and Yearly) using PowerBi for top managements for POC (Proof of Concept).
• Investigate on slow performance existing SQL, Oracle PL/SQL, Stored Procedure, enhance/modify Crystal reports with coordination with DBA.
Trainings Attended:
• Labware LIMS 7 Administration 1 (19th -23rd Oct 2015), LIMS Basic v6 (26th-28th Oct 2015) at Labware Australia Pty Ltd.
• LabWare 2015 NA Customer Education Conference Atlanta, GA (26 April - 01 May 2015) Attendee ID: LW0009361 AIG (American Insurance Group) March 2013 – July 2014 Application Programmer
Project OGIS Bulletin 85
• Taking Lead on enhancement portion of Strategic Reinsurance Web base application which handles the reinsurance of each transaction, tools: J2EE, JSP, Eclipse (IDE), DBSolo & Sybase DB
• Created/Altered SQLs to handle the new functionality on the DB side. Production Support (L2)
• Maintenance Legacy app reinsurance application (VB6) and Crystal reports enhancements. Safeway Manila Inc. (subsidiary of Safeway Inc., USA) July 2003 – Feb 2013 Team/Technical Lead (Programmer Analyst/Production Support) Technical Lead (Analytics and Reporting team)
• Lead the Project Migration of Crystal reports to Microstrategy 9.21 (5 members in manila).
• Migration of Crystal reports (approximate 1000+ Crystal Report) to microstrategy.
• Projects scope involves ChangemanDS to process the development stage, promote codes going to production.
• Redesign the Web application (StoreReports Application) to link the microstrategy reports upon availability to corporate, Divisions, Districts to Store level
• Develop the SQL for metric and sales reports, created Analysis and dashboard using OBIEE 10g.
• Designate/Estimate task and guidance to team members on the procedures from creation to deployment in production to be SarbanesOxley Compliant. .
• Analysis and estimation of work effort for Minor Work Request (MWR) for Datawarehouse, Reporting (essbase, microstrategy, crystal reports, Supply Chain and Datastage, OBIEE).
• Handles the Team Shifting Schedule to provide 24/7 support. Previous Team/Work Tasks: Application Support (Former Team member of SDG–Web group)
• Provides 2nd level Support to In-house/Vendor Web Based applications (.NET & Java) and Crystal Reports. • Responsible for the minor work development, maintenance and supporting different web based applications (.NET & Java platform).
• Coordinates issues with other teams (3rd level, vendor and business users) and Ensures all incidents resolved within Service Level Agreement Projects handled:
• Developed Towerperrins website for Safeway employees and a link embed on Safeway intranet to view employees healthcare and benefits. Using J2EE, websphere technologies.
• Competitor Tracking application – did enhancement on monitoring competitor stores price items on its reporting. (J2EE, Javascipt, Servlet, Crystal Reports)
• Developed Crystal reports (with SQL) for Aprimo (Marketing Management Tool). Maynilad Water Services, Inc. Apr 2002 – Jun 2003
Application Developer
• Developed Collection and Monitoring of Bills System on all branches (using Java), Database Cleanup Process. (using Java), created PL/SQL to handle UPSERT by Removing bad data,
St. Luke's Medical Center Oct 2001 - Mar 2002
Programmer Analyst
• Developed Human Resources Information System. (using VB6, SQL in Informix, Crystal Report 8 ) • Intel Technology Phils, Inc. Apr 2001 – Sept 2001
Programmer Analyst (Using VB6 and Crystal Reports 8)
• Developed processes thru PL/SQL in Demand Prioritization and Demand Splitter. • Developed Assembly Maximization Solution Process • Developed Supplies Batch Processing thru PL/SQL, Crystal Report. St. Luke's Medical Center Aug 2000 – Mar 2001
Programmer
Develop Clinical Assessment Protocol System of Memory Center (VB6, Crystal Report 8, SQL Informix) EDUCATION:
AMA Computer University (1996-1999)
BS Computer Science degree
INTEREST: Love going places like beach, mountain climbing, and love spending time with my family/kids. Enjoy hanging out with friends, playing basketball, volleyball, badminton and I like to cook. REFERENCES:
Dale M Dela Cruz Team Lead - Alorica M: 090******** Joven Velasquez Team Lead – UL Verification Services M: 63 0917.7235457 Herberto Somera Manager – UL Verification Services M 091*-******* Marq Hernandez AIG F&A Project Manager +63 2 878 1000 ext. 1612 Ivan Lim Safeway SDG CC Support Manager 1-877-***-**** ext. 9-762 +63- 7576762; M:0905.377.3112
Bernadette Galvez-Khan
Safeway SDG DQ Development
Manager
1-877-***-**** ext 9-266 +63-
7576266; M: 0917.520.7846