Sql Developer Business Intelligence

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

Contact this candidate