Power Bi Business Intelligence

Ramses O. Leoparte

B** L** Emmaus st., Town & Country phase1, Brgy Burol 1, Dasmarinas Cavite

LinkedIn +63-915-***-****; ***********@*****.***

SUMMARY OF QUALIFICATIONS

Can Support different Open Source Technology, collaborate closely cross-functional team, to understand their analytical needs.

Create dynamic and informative meaningful forecasting models using Power BI dashboard.

TECHNICAL SKILLS:

Software/Tools.

•Prometheus, Grafana, Opentelemetry, Kubernetes(K8s), Kustomization, YAML, Dockers, Minikube, Apache Kafka, Elasticsearch, Apache Nifi, Opensearch, SQL, BigQuery, Google Cloud, 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.

•Develop prototype dashboard for PoC from QlikView, Tableau, SSIS, SSRS, PowerBi integrate with PowerApps

•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

Production Support Tools:

•Visual Studio Code, Bash, 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:

•Python, PowerBi DAX, PL/SQL, J2EE, JSP, Java, JavaScript, Servlet.Net, C#, Eclipse(IDE), VB 5&6 using DAO/ADO thru ODBC, ActiveX, 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:

•Apache Druid, OData, Sharepoint, DB2, Teradata, Netezza, Oracle Database 9i/8i, SQL* Servers ver. 8, MS Access 95/98/2000, Informix

OS: Linux, Windows

EXPERIENCE(s):

Deep.BI (Poland company https://www.deep.bi/ ) July 2024 – present

Support Engineer (Freelance/Contractor)

•Handling Queries and Support for Apache Druid, Kafka, Elasticsearch, Apache Nifi, OpenSearch in real-time analytics database and Maintain/ Support all Power BI Dashboard

•1st level Support Engineer receive issues, communicate with client’s issue and analyze, gather initial information/files logs, initiate high level investigation on causes the issue, and recommend possible solution/fix, assess Incidents priorities.

•Research and documentation of Use Cases from different Open source technology(Kubernetes, Kustomization, YAML).

•Collaborating closely with cross-functional Data Engineers, DevOps Engineer, DBA and Developers from Clients.

Telstra Health (under TOA - The Outsourced Accountant Global) Nov 2023 – Apr 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-Designed Customer Ageing Invoices Dashboard from Power Query to DAX code, optimizing query performance for faster refresh and more precise results.

•Utilizing advanced techniques in Power Query to extract, transform, and load data efficiently from various sources ODATA, SQL Server, Sharepoint, Excel, ensuring data integrity and accuracy.

•Collaborating closely with cross-functional teams to understand their analytical needs, gather requirements and translating them into actionable insights through Power BI 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, Power BI Dashboard and 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, Power BI

Alorica Asia ROHQ, Ltd. Nov 2020 – Apr 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.

•Collaborate 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.

•Maintenance/Support (POWERBi Dashboard) EMC information are accurate and run on time for Executive meetings

UL Verification Services Philippines PLC. Subsidiary of UL (Underwriters Laboratories) Aug 2014 – Feb 2020

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 slow performance existing SQL, Oracle PL/SQL, Stored Procedure, enhance/modify Crystal reports in 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) Mar 2013 – Jul 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 SOX 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:

•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 May 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.

Contact this candidate