----------- ----------- N. -----------
351 Purok 2 ,Brgy. Banlic Calamba
City, Laguna
Cell No. : -----------0Email : -----------
LinkedIn : -----------.-----------/in/------------------------------------6736ab3b
Current
Position : Business Analyst ( SAP B1 )
SPECIAL SKILLS:
Data Analysis Tools
* Power BI
* MS SQL Server Management
* MS Azure Services ( Data Factory, Synapse , Storage, SQL )
SAP B1
* Basic skills in SAP B1 Modules (Accounting/Purchasing/Sales/Logistics /Implementation).
* Create customized reports thru Crystal Reports for SAP B1.
* Managed and maintained SAP B1 for more than 5 Years.
Software & Hardware
* Manages various networking equipment such as switches, routers, modems and WIFI appliances.
* Networking (LAN/WLAN ) installation for cables, layouts and designing for better
connectivity and security.
* Assemble and repair computers and other IT equipment from upgrade to newly installed equipment.
* Software tools expertise with Windows 2012, 7,8,10,11 and Microsoft Products(Office) , Adobe Photoshop, Adobe After Effects ,Corel Draw, Sony Vegas and other Internet or Network tools.
* Knowledgeable with programming tools (PHP , Crystal Reports, Oracle Forms , Oracle Developer, PL / SQL and Database
Management software.)
PERSONAL WORK EXPERIENCES
OMEGA GTI Asia : Business Analyst ( SAP B1 )
July 2023 - April 26, 2024
GECO ASIA Pte, Ltd. : MS Azure Data Analytics Developer
Dec. 2021 – July 2023
Scope of Work :
* Create Visualization using Power BI with DAX operations.
* Power Query to harmonize the data and Power Automate to prepare workflow
* Preparation of ETL from different datasets.
* Creation of Containers and blobs thru Azure Storage.
* Preparation of MS Azure Data Factory – Data flow, Pipelines , and data sets .
* Create a Data Hub Center where all the tables needed by the Power
BI Construction group would get their resources, by which is to create
connection from different sources and extracting the tables via Azure Data
Factory pipelines. Create and design pipelines to extract the tables from the
sources ( Sharepoint List , Workday, Oracle SQL , MS SQL , API’s , Salesforce )
and save them in the Azure Containers.
* Provide documentation for the frameworks created.
* Create Data Mappings activity from the resource.
* Create Power BI dashboard reports connecting to excel file stored in Sharepoint drive which is a compilation of all information with regards to the data migration project , in which are update simultaneously by end-users. Produce and maintain visuals and metrics on the current status of the Migration project like reports showing the number of tables , resources and migrated table counts from different platforms. Displaying timelines and burndown charts to monitor the progress status.
* Created ADF pipelines that ingests data from different sources (
Oracle , PSQL , FileBase, Sharepoint , Rest API’s).
* Created Stored Procedures and Views in Synapse that would read
configuration data from tables that would be used for ADF pipeline ingestion.
* Maintain and troubleshoot of existing ADF Pipelines from different
markets, like data type format issues that causes ingestion to fail and needs to go thru some data type formatting.
And provide root cause analysis on the issues encountered.
* Deployment of different frameworks ( API / Full Ingestion / Logging / Curation ) and artifacts in the azure services (Synapse / Databrick / Data Factory ).
* Provide documentation on the confluence page and conduct KT’s to
the Production Team after the acceptance of the fixes for the pipeline issues
that were solved. And this can serve as reference for further issues that might have similar problems.
MIYOSHI TECHNOLOGIES PHILS.: Sr.
IT Officer
Oct. 18, 2002 – Dec. 4, 2021
Work Details:
* Administer and facilitate the IT system and infrastructure.
* Provide support in implementing and maintaining of SAP B1.
*Create Ad-hoc reports and SQL Queries for end users in SAP B1.
* Customize or revise reports for SAP B1.
* Troubleshoot or trace system error and end-user concerns in SAP B1
* Provide guidelines for system flow of the SAP B1 system teaching
new users on how to use the modules assigned to them. Providing
information on the purposes of each field that the end-users need to use.
* Troubleshooting of the system for user errors or creating work arounds inside the system.
* Installation of network from cabling to configuration and monitoring the flow of connection from all workstations.
* Provide necessary reports or documents to help in assuring that all IT projects which includes planning, budgeting and sourcing out of suppliers are on time and all
implementation run smoothly to ensure to meet the given deadlines and fully
utilize the resources. Providing training if needed for end-users. Closely monitor all transactions with regards to the implementation of the project.
* Maintain the Payroll and Timekeeping system by providing necessary reports, troubleshooting and software maintenance.
* Tracking of email and internet security from server point and filter any unnecessary programs or files being acquired from other senders. Keeping all security and anti-virus up-to-date to ensure the security. Controls the internet accesses of end-users.
OLD MRP System
* Maintain and customize the acquired ERP system (PLATINUM for WINDOWS ) . Providing needed reports or forms requested by end-users by customizing or revising reports to provide a more accurate and needed information using CRYSTAL REPORTS and MS ACCESS . Troubleshooting the database using Pervasive
SQL to correct or track errors or wrong information that could cause problem in
the system and provide a solution to prevent it from occurring.
Key Projects & Achievements :
* Provided support in implementing an MRP system running on UNIX and Informix (-----------) which was developed in Singapore .
* Provided support in implementing an ERP system running on Platinum for windows SAGE PFW (2005 – 2006)
* Provided support for the full implementation of SAP B1 system from 2014 up to present.
* Created and implemented Work-in-process monitoring system in one of the divisions.
* Created the company profile from PP Slides to a Video Presentation with Japanese
translations.
* Created a Web based monitoring system for production that captures operator
productivity and machine utilization thru PHP language.
* Implemented a cost saving scheme especially with Ink consumptions, Electricity Savings, and Software maintenance.
* Implemented Timekeeping and Payroll System
KOMPUTER RUN Computer Services :
Proprietor August 1999 – 2002
The
company is engaged in computer rentals , printing and providing IT solutions
which involves repair of computers , networks and installation of
software. The company also provides
services to companies that requires IT services from configuration and
installation of networks to installation or repair of workstations.
NIDEC SHIMPOO : QC
Inspector October 1998 – March 1999
Inspect
and assure quality of products before delivery.
ACI PHILIPPINES : IT Programmer July 1997 – June 1998
Responsibilities :
* Recruited to do report and forms customization from current system ORACLE GEMMS and ORACLE FINANCIALS using Oracle Forms / Reports together with PL/SLQ plus. Gathering of information and formulating a reports
as requested by departments .
* Customization of document forms such as invoices and delivery receipts to make transactions and information accurate and also update the database from any changes made. Provide troubleshooting by using SQL scripts to eliminate wrong encodings or information.
* Train users on how to run the reports or modules added in the system by providing them procedures and actual supervision while in the process of using the added
modules.
EDUCATION AND CREDENTIALS
Bachelor of Science in Computer Science
Laguna College of Business & Arts
Yr. 1993 – 1997
SEMINARS AND TRAININGS ATTENDED :
DATE SEMINARS & TRAININGS PROVIDER
May 26 – 28, ‘14 SAP B1 ( TB1000 Logistics ) MustardSeed
May 29-30,’14 SAP B1 ( TB1100 Accounting ) MustardSeed
June 30–July 4,’14 SAP B1 ( TB1200 Implementation ) MustardSeed
Dec 14-18 ‘09 2799– Implementing Microsoft SQL Server 2005 DB Wizards
Nov. 4 – 6 ‘09 5061– Implementing MS Sharepoint Server 2007 DB Wizards
Oct 12 – 16 ‘09 2780– Maintaining a Microsoft SQL Server 2005 DB Wizards
August ’09 CCNA BootCamp Mapua Institute of Tech.
DEC. 3-7 ‘07 2272C Implementing and Supporting Microsoft
Windows XP Professional New Horizons Centers
Nov. 23-24 ‘07 2276C Implementing a Microsoft Windows
Server 2003 Network Infrastructure – New Horizons Centers,
Nov.12-16 ‘07 2273B Managing and Maintaining a Microsoft
Windows Server 2003 Server New Horizons Centers,
Aug. 4 ‘07 Supervisory & Managerial Effectiveness Training RMP Consultancy
Feb.19, ‘07 Introduction to Six Sigma Miyoshi Technologies Phils.
Aug. 26, ‘07 Executive Management Team Retreat FIAT Training & Consultancy Corp.
Mar.15, ‘03 Basic Fire and Safety Seminar Bureau of Fire Protection
Calamba City
PERSONAL BACKGROUND :
I am 46 years of age , born on January 13, 1977. I am a Filipino with 2 children and married. I am a Christian. I like to involve myself to sports like, Bowling, Basketball and Badminton.
