Oscar Ricardo Toro Roldan IT Consultant

P

Senior Lead Business Analyst

Prologistics

Dec 2021 - Jun 2023 (1 year 7 months)

• Used DRAW.io to design a High-Level Data Architecture Diagram to show how the data flow between the integration of Yardi and PeopleSoft.
• Worked in the automation testing project using qTest tool for the General Ledger module of PeopleSoft as part of the integration with Yardi.
• Analysed PeopleSoft integration with different modules including Accounts Payable, Purcharge Orders, Cash Management, Expenses, Billing, Asset Management, eProcument, nVision, among others for the real estate industry.
• Used Jira and Confluence to track and create user stories, epics, spikes, and user acceptance criteria.
• Reviewed SQL queries to obt

Program Manager/Business Analyst/Python

Cisco

Apr 2021 - Dec 2021 (9 months)

• Worked with Oracle Client Server and Tableau to deliver ad hoc reports to stakeholders within the Global
Translation Services (GTS)Team.
• Joined different tables using Oracle Databases to deliver reports through Tableau.
• Reviewed and approved Python.exe files created by Junior Business Analysts related to process automation for the Finance Team including Purchase Requisition forms automatically filled out in excel.
• Developed python scripts to automate manual process after inserting excel files into a folder and creating a new excel file with specifics columns using lists, hash tables, dictionaries, and stacks.
• Worked with Oracle Client Server and Tableau to deliver ad hoc reports to stakeholders within

AWS-GitHub Developer/Senior Business Analyst

TCS

Oct 2020 - Apr 2021 (7 months)

• Validated and managed data by mapping legacy systems information against Athena data uploaded by the ingestion team using S3 cloud storage in AWS.
• Analysed and modified decision table and business terms excel files to run macros, so queries can be created and be run in Athena in addition to the use of Teamforge, GithHub and emr repositories.
• Used SQL queries for Workbench and Athena to create tables and insert data.
• Participated in Agile ceremonies including "daily stand-ups, retrospective and sprint plan meetings".
• Used Lambda from AWS to push and run process for data flow.

T

Bench (Scrum) Master/Business Consultant

Terra Firma Games

Jun 2019 - Dec 2019 (7 months)

• Delivered a new CMS Request for Proposal to VicHealth to facilitate the use of the website for non technical people and to reduce yearly subscription costs including a recommendation to move from IaaS to SaaS.
• Created user stories, customer journeys, and EPICs to gather requirements for the new system implementation project within the Department of Justice (DoJ), while ensuring full understanding of DoJ issues and project goals.
• Analysed a list of requirements to create a Request for Quotations (RFQ) document for the DoJ outlining potential issues and creative solutions, ensuring project implementation as per project standards.
• Participated and helped in organising a workshop to deliver an efficient change manageme

M

Business Analyst-Business Testing

METAPM

Feb 2019 - Jun 2019 (5 months)

• Worked as a contractor in the Satellite and Telecommunications industry providing business analysis/mapping and readiness consultancy to Speedcast, while certifying quality assurance of the documents delivered.
• Developed ground network design documents to cover alarm plans delivered to NBN, while gathering feedback from the various network engineers to ensure product quality results.
• Worked on a data dictionary for the ESWP portal with the Senior Business Analyst and the website service provider, ensuring appropriate progress of the data dictionary completion.
• Created troubleshooting guide documents to support engineers/developers and business users to correct modem malfunctioning, ensuring approval of project mana

Business Analyst-Technology/Change

Deakin University

Jul 2018 - Jan 2019 (7 months)

• Worked with the Change Management team to identify key influencers among the stakeholders involved and impacted by the new system implementation including a further analysis of the six emotional stages
of organisational change.
• Proactively supported the Project Manager, and other senior managers, to analyse and document current business processes, identify system/business requirements, and facilitate the design of To-Be processes.
• Documented, mapped, developed, and analysed processes to identify inefficiencies, areas for improvement, and other opportunities related to the recruitment and management of casual staff developed by the Think Differently Program, while meeting with different stakeholders from various high

Business Analyst/Data Specialist (Contract-Temp Work)

The University of Melbourne

Oct 2017 - May 2018 (8 months)

• Performed data analysis and reporting on inbound studentsfor the global mobility program using Chronus and Q Flow as a software, while working with SMEs specialised in using Chronus and similar systems.
• Elicited process improvements in the internships and careers department, proposing new excel files auto populating certain values for easier data management, while ensuring co-workers' satisfaction about the final improved product.
• Created a process flow documentation using Visio as a software and systems training for on boarding of administrators, ensuring understanding and agreement from the various stakeholders involved in the process.

Project Manager/Business Analyst-Data Specialist, Imaging Printing Services

Hewlett Packard

Jun 2014 - Feb 2016 (1 year 9 months)

• Extracted and manipulated data into useable reports showing statistics, performance management metrics, anddashboards, while meeting with collaborators in Singapore and China to provide input and feedback.
• Developed and maintained triggers, validation rules and customed workflows to manage and deliver process improvement in relation to the project of the labelling printer boxes procedure consisting of changing labels when errors were committed, or updates were needed.
• Worked on finding duplicated processes and data to perform database de-duping and clean-up procedures to deliver improvement and efficiency standards.
• Refined existing reports, dashboards, and processes to continuously monitor data quality and integri

Account Manager- (EDI Feeding), US Financial Claims

Hewlett Packard

Mar 2012 - Jun 2014 (2 years 4 months)

• Analysed and reconciled excel files obtained from EDI feeding by using SQL queries to process rebates if missing.
• Managed several customer accounts and dispute files in relation to rebate requests and including the delivery of high-quality customer service to Partners such as Ingram, Synnex, and PC Mall.
• Worked with Lean Six Sigma methodology to improve internal processes within the Department, while gathering with Team Leads, Managers and stakeholders for brainstorming and obtain creative ideas.

Consultants Development Executive

Seguros Monterrey New York Life

Nov 2011 - Mar 2012 (5 months)

• Led a team of sales consultants to achieve targets and meet expectations, while accompanying them
with clients to show know-how in real cases and for learning purposes.
• Trained and managed sales consultants, through company product training sessions using financial and customer service plans, while delivering product information and client approach strategies.
• Provided consulting service on Capital Markets to clients for long-term investments using equity-backed securities as products offered by the Insurance Company for portfolio investment.

Credit Analyst / Account Executive

Banco DelSur

Mar 2009 - May 2010 (1 year 3 months)

• Analysed Financial Statements from different companies and customers, including account ledgers (debits and credits) to see loan viability.
• Provided consulting service on Capital Markets to clients for long-term investments using equity-backed securities as products offered by the Bank for portfolio investment.
• Promoted loans from the bank together with Real Estate agents to different customers including building and housing loans.

Account Executive

HSBC

Jun 2008 - Oct 2008 (5 months)

• Provided consulting services on Capital Markets to clients for long-term investments using equity backed securities as products offered by the Bank for portfolio investment.
• Promoted loans from the bank together with Real Estate agents to different customers including building and housing loans.

Oscar Ricardo Toro Roldan

About

Detail

Timeline

Résumé

Oscar Ricardo Toro Roldan

About

Detail

Behavioral traits