Scan to view my LinkedIn profile

I N F O

Phone

Address

Elma St. Don Fabian

E-mail

Tableau Public

aprilannramirez#!/

Projects

APRIL ANN RAMIREZ

D A T A S C I E N T I S T A S P I R A N T

S U M M A R Y

Experienced Lead Business Analyst with a demonstrated history of working in the supply chain and banking industry. Skilled in Data Analysis, Business Development, Business Process Improvement, Credit Analysis, and Supply Chain Risk Management. Strong business development professional with a Post Graduate Degree focused in Data Science from Purdue University.

E D U C A T I O N

Dec 2019 to

Dec 2020

2008 - 2012

POST GRADUATE DIPLOMA IN DATA SCIENCE

Purdue University

BSBA BANKING AND FINANCE

New Era University

W O R K E X P E R I E N C E

Aug 2020 -

present

Operations Analyst

JK Capital Finance Inc.

Industry: Financing

RESPONSIBILITIES

Assist Managing Director or higher management in expertise and guidance for innovation of Operations.

Conducted business process review and contributed to the business process improvement in the accounting and legal & collections department.

Created new reports and modify existing reports using the standards and best practices.

Perform ad-hoc data analysis and determine when repetitive ad-hoc requests should be included as standard reporting.

Created and maintained databases used by accounting and collections department to monitor day to day activities such as check payments, and case status. Utilized advanced Google Sheet formulas and Query function to automate updating, analyzing and reporting of data.

Collects and standardize data using advanced formulas in Google Sheets to conform with requirements of centralized credit Information organizations.

T E C H N I C A L

SK I L L S

MS Excel (Macro, Pivot, Vlookup, Solver)

Google Sheets (Query, Index Match)

MS Word / MS Powerpoint / MS Visio

Coordinates with the partner software developer and end users towards finalizing the company's ERP system. Communicates with various department to ensure workability of each functions and requirements of the platform.

Generates generic inquiry and dashboards through the ERP system as required by the top management

Serves as the administrator of the company's ERP system. Manages the access rights and security of each user,

Conducted Loan Reconciliation report on a monthly basis.

Perform ad-hoc data analysis and determine when repetitive ad-hoc requests should be included as standard reporting.

Schedule, coordinate and facilitate requirements with the business to identify and drive complete requirements and innovative solution design

Collaborate with relevant departments on performance and regulatory projects to define and document requirements for new functionality, test solutions, and support implementation.

Maintain close alignment with the higher management.

Promote continuous improvement through data mining and analytics. Data Warehousing / Data Mining

Phyton Programing

Machine Learning (K-Means Clustering,

Random Forest, Decision Trees)

Natural Language Processing

Tableau

R / SQL

Lean Six Sigma (Greenbelt)

Statistical Analysis)

Project Management

Risk Management

Credit Analysis

Due Diligence Checking

November

2017 - Jun

e2020

Business Analyst and Business Development Lead

PASIA Shared Services Corp. (A sister company of Procurement and Supply Institute of Asia)

Industry: BPO/Consulting for Supply Chain, Procurement and Logistics ACHIEVEMENTS

Led and pioneered a new revenue stream for the organization by developing an analytics service platform used to assess suppliers’ business performance based on legitimacy, financial stability, risk management, service performance, warehouse management, human resource compliance, sustainability, health & safety, as well as the on- site and virtual supplier visit services. The framework is designed in accordance to the objective of establishing the first B2B e-Marketplace in Asia that combines supplier assessment and supplier discovery services.

Conducted a research study that includes benchmark for business opportunities, market trend and comparative analysis, establishing the business unit standing in the marketplace.

Conducted a Profit & Loss analysis which includes sales targets, revenue forecast, and cost estimations for the overall business unit including the technology, required working space, storage, manpower resources, supplies and furniture etc.

Designed the overall process on end to end operation from sales to delivery of service using kaizen and lean six sigma tools and techniques

Determined the pricing strategy of all services under the business unit such as the standard, expanded and comprehensive supplier assessment as well as the on-site and virtual supplier visit service using activity-based costing technique

Created the manual with complete policies and procedures guidelines, job description of the team, qualifications and KPIs

Formulated standard and customized scorecards that identifies the supplier’s business performance and risk level based on client and industry requirements

Designed and developed supplier analytics report to be submitted to clients for final accreditation

Designed and developed periodical status reports of suppliers for client’s reference and decision making

Automated the reporting system using advanced excel techniques to optimize resources in the business unit process

Drove the growth of the business unit for more than two (2) years on terms of sales, while also leading the growth of the operations team from a one- man to having a total of ten (10) team members with data analyst position

Planned, organized and facilitated an event as one the strategic initiative of the business unit attended by 40 C-level executives from the top corporations in the Philippines

Closed seven (7) clients with a revenue value of P8M within 2 years of spearheading both sales and operations

A C H I E V E M E N T S

Civil Service Passer -

Professional level, May 2012

Planning and Development

Committee Chairman,

NEU Junior Finance Executive

Association, 2011 -2012

Dean’s Lister, 2010 - 2012

T R A I N I N G S

Asian Institute of Management

Business Analytics

Simplilearn co-developed by IBM in

collaboration with Purdue

University

Lean Six Sigma Greenbelt

Statistics Essential for Data

Science

R & Python Programming

Machine Learning

Tableau Desktop 10

IBM Watson for Chatbot

Artificial Intelligence Engineer

IDESS Interactive Technologies

The Philippine Data Privacy

Basics

Procurement and Supply Institute of

Asia

Essentials of Strategic Sourcing

Negotiating for Procurement

and Supply Chain Professionals

Strategic Negotiations

Contracts Performance

Management

Supply Chain Risk Management

Planters Development Bank

Anti-Money Laundering Act

Credit Fraud & Risk Management

Signature Verification Seminar

II. RESPONSIBILITIES

Business Analysis and Process Improvement (Operations)

Directly reports to the Vice President, CEO and Chairman of the organization.

Plan and present business proposal to the company executives. Deliver Sales and Operations reports on a weekly basis.

Develop and continuously update business unit framework; Demand and Supply analysis, S&OP (Sales and Operations Plan), Standard Operating Procedures, project materials such as checklist, scorecard, contract and proposals, databases, customer reports, supplier assessment reports, presentations for sales and events; content development for marketing collaterals such as flyers, brochures and AVPs.

Conducts Profit and Loss Analysis during the business planning period

Analyze client requirements, customize scorecards, reports, and questionnaires according to the agreed supplier performance metrics

Led and trained ten (10) data analysts and processors to perform various functions in GPAS including collecting and validating of data, conducting phone interviews, background checking, document review and fraud analysis, database management, and data and financial ratio analysis that assesses suppliers’ performance and risk-level in terms of business legitimacy, financial stability, service delivery performance, facilities and warehouse management, human resource compliance, and the supplier’s sustainability, health and safety compliance

Design the process for site inspections particularly to validate supplier’s compliance to occupational safety and health best practices, supplier code of conduct and warehouse management - providing uniformity in activity of the deployed personnel.

Create strategic plans to ensure delivery of commitment within the project timeline. Estimate resources required to meet agreed timeframe with clients.

Develop strategic initiatives for continuous process improvement.

Supervise the team for an effective implementation of policies and procedures.

Conducts final review of supplier analytics report prior to submission to the client.

Manage and monitor the centralized global database of suppliers endorsed by clients

Business Development (Sales)

Generates leads through participating in events and organizing different marketing initiatives.

Establish a strong pipeline by closely coordinating with prospect clients prior, during and after events and conferences

Develop contents for social media posting, sales letters, flyer, brochure and AVP

Conducts business presentation during public training and client calls

Negotiate and review contract agreements with prospect clients.

Update contract proposals to align with internal and external requirements

Conducts price and cost analysis for rate adjustments from client negotiations

Develop strategic plans to achieve sales targets during business planning period

Handles client database to monitor progress and requirements June 2016 –

September

2017

Professional Medical Representative

L. Meyerf Pharma Inc. Industry:

Pharmaceutical

I. ACHIEVEMENTS

Opened and established the business in the area of Tarlac, Pangasinan, La Union, and Baguio.

Placed and introduced the organization’s top product to all Mercury drug outlets under the assigned area

Won over one of the top pulmonologist in the Philippines to be the speaker to introduce the organization’s newly released product

Launched the new product to Baguio with 20 participating doctors including the top pulmonologists in the area

II. Responsibilities

Responsible for promotion, sales, collection and delivery of company's products to trade outlets and dispensing doctors.

January 2016

– April 2016

June 2015 to

Oct 2015

(1Semester)

May 2012 –

January

2016

Credit Officer, Junior Assistant Manager

Security Bank Corporation

Industry: Banking Responsibilities

Approves and declines personal loan applications in line with the bank’s parameters and risk tolerance.

Decides for different possible alternatives to support sales and increase the team’s productivity.

Identifies suspicious accounts and protects the bank from any fraudulent transactions.

Part-time Instructor

Golden Link College

Industry: Education

Responsibilities

Delivered finance and accounting subjects to business administration an information technology students

Credit Analyst

Chinabank Savings (formerly Planters Development Bank) Industry: Banking

Responsibilities

Created comprehensive proposal report summarizing information of loan borrowers including company and individual profile, credit scoring, financial capacity etc.

Implemented sound credit evaluation of auto loan and business loan applications in accordance to bank policies and procedures.

Conducted financial analysis and ensures business compliance of loan applicants

Examined correct data to ensure accurate credit scoring

Conducted field investigations discreetly and thoroughly on the background, character and financial credit standing, records and habits of loan applicants or clients of the Bank

Intern from October 2011 to January 2012 under Auto Loans Marketing Department

Contact this candidate