Ramses O. Leoparte

Blk ** Lot ** Emmaus st., Town and Country ph 1,

Brgy. Burol 1, Dasmarinas, Cavite, Philippines 4114 Email: adzahz@r.postjobfree.com ; adzahz@r.postjobfree.com Mobile #: +63-915-***-**** https://www.linkedin.com/in/ramses -leoparte - bb120452/

OBJECTIVE To give my best effort in an organization by accepting new challenges and finding new ways to achieve the desired result in the worst situation. SUMMARY OF QUALIFICATIONS • Established the Analytics and Reporting group that develop, maintain and supports backend process on ETL on all business users for their financial reports. Developed, maintain and support Web technologies on Java platform TECHNICAL SKILLS:

Software

• Labware LIMS v6/7(Laboratory Information System), Aprimo (Marketing Management tool), LDAP

• PowerBi, Crystal Reports 8, 9 and XI, Crystal Enterprise/Crystal Management Console/ePortfolio, using LDAP and APOS for security.

• Microstrategy 9.2.1 (and version 8), Microstrategy Intelligence server, Narrowcast Server and Object Manager Oracle Business Intelligence Enterprise Edition (OBIEE) ver. 10

*Creates prototype reports for PoC from QlikView, Tableau, SSIS, SSRS, PowerBi Production Support Tools:

•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: •DB2, Teradata, Netezza, Oracle Database 9i/8i, SQL* Servers ver. 8, MS Access 95/98/2000, Informix EXPERIENCE(s):

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. Arturo. Tata Consultancy Services (TCS) May 2022 – Feb 2023 Production Support – for Philippine Depository and Trust Corporation (PDTC/PDS group)

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

• Manage the conversion of ESP jobs to Narrowcast Distribution services.

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

• Lead the development, maintenance and support of all company reports (Crystal, Essbase and Microstrategy reports, OBIEE 10g).

• Designate task and guidance to team members on the procedures from creation to deployment in production to be SarbanesOxley Compliant.

• Estimate work effort for minor web reporting changes. Handle the administration for Crystal Management Console version 9 of Crystal Enterprise server settings to be at top performance.

• Maintenance/Migration of Microstrategy reports using Intelligence and Narrowcast server and Object manager to administer the deployment of reports.

• Conducted classroom training within Safeway employees for VB 6, Crystal Reports, Microstrategy. Team Lead (Business Intelligence group)

• Analysis and estimation of work effort for Minor Work Request (MWR) for Datawarehouse, Reporting (essbase, microstrategy, crystal reports, Supply Chain and Datastage, OBIEE).

• Allocate and monitor team resources for Project assistance and ensure all incidents meet Service Level Agreement.

• Guide junior members on handling critical issues and Adhere to company policy in handling issues. Review individual and team performance upon manager request.

• 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)

• Developed Database Cleanup Process. (using Java), created PL/SQL to handle UPSERT by Removing bad data, invalid customer names, invalid numeric format, etc.

• Developed Notice of Disconnection, a web application for customers tracking. (using Java) St. Luke's Medical Center Oct 2001 - Mar 2002

Programmer Analyst

• Developed Human Resources Information System. (using VB6, SQL in Informix, Crystal Report 8 ) • Developed reports for the Billing and Human information application using (using VB6 and 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 Generated of ship out (Time Generated) and Assembly Manufacturing Execution Report Viewer. This system helped increased production by 10% in which it gives accurate information to analyze and decision making.

St. Luke's Medical Center Aug 2000 – Mar 2001

Programmer

• Develop Clinical Assessment Protocol System of Memory Center (VB6, Crystal Report 8, SQL Informix)

• Develop Patients tracking System of Vision Laser 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:

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