Professional Summary

Innovative accounting professional proficient in extracting financial data from various reporting systems and suggesting key operational changes.

Experience of 10 years SAS, Informix, Microsoft SQL and IBM Cognos for solid reporting financial activities.

Education

UVM Campus Tlalpan September 2010 to May 2014

Bachelor’s Degree in Informatics Systems Administration (Computer Science) Academic Grade. 90

Languages

Spanish (100% Native)

English (85% Business and Technical conversation)

German (70% Fluent conversation)

Courses and Certifications

SAP Business Objects: Simple and advanced reporting May 2009

SAS Programing 1 Essentials January 2010

SAS Programing 2 Data Manipulation Techniques January 2010

Querying Microsoft SQL Server 2008 R2 July 2013

Microsoft SQL Server 2008 R2 Data Base Management MC ID 10207716 July 2013

Skills

Software Platform Years of Expertise

SAS Data Manipulation 5 years

Informix Querying 6 years

Microsoft SQL Querying 6 years

Business Objects Advanced Reporting 5 years

IBM Cognos Advanced Reporting 2 years

Microsoft Excel Advanced Reporting 10 years

Microsoft Access Data Base Manipulation 10 years

Data Quality Assurance 6 years

Human Resources Management 6 years

Soft Skills

• Analisys Strategy and Decision Maker

• Adaptability, Empathy and Focus on customer needs

• Persuasive communicator

• Goal-oriented and high commitment

Experience

Scotiabank Inverlat - (Jan 2009 – Aug 2015)

(Bank of Nova Scotia Mexico, Distrito Federal)

BI Executive SR. June 2013 to August 2015

As a Business Intelligence (BI) Executive’s, my duties involved identify business intelligence, reporting, and data analysis needs. I had to work closely with clients (Bank’s Business Areas) and IT teams to turn data into critical information and knowledge that could be used to make sound business decisions.

Responsibilities:

Provide data that is accurate, congruent and reliable

Ensure the information is easily available to users for direct consumption or integration with other systems.

Educate and train clients to use the data as an analytical tool, displaying the information in new forms and content for the purpose of analysis and option exploration.

Generating reports of cash flows, customer behavior and products’ profitability.

Achievements:

The creation of a Debit Master File as main source for all debit reporting.

Participating in a documentation project regarding the migration of the Institutional Data Warehouse. Managed a group of three people to ensure the data was all copy books and business rules where documented achieving the goal on time.

Actively participating in the migration of the Credit Card institutional platform FDR to Tsys.

Creation of regional reports by Branch to mark the products’ trends and variation between spot balances and monthly averages to identify and minimize account attrition.

Automation of reports eliminating manual procedures and shortening the production times.

Data Quality Analyst Executive Jr. February 2011 to June 2013

As a Data Quality Analyst Executive my job was to ensure that data loaded into the data warehouse met the informational requirements of the organization. I needed to check the products’ data and the transactions stored in the Institutional Data Warehouse and match it with the accounting.

Responsibilities:

Review historical and referential integrity of data warehouse data and check its accuracy.

Match transactional data with the Accounting

Report any incidents to IT for further consideration and reprocess of data.

Achievements:

Working with ten years of data in order to re create accounting sheets to validate the taxes paid in personal loans, credit cards and mortgages as requested by the IRS authority.

Automation of reports that validate the product balances and averages with the institution accounting.

Help Desk Executive Jr. January 2009 to February 2013

As a Help Desk Executive my duties were to receive the information requirements from the bank’s business areas. I had to make sure that we had the data requested available and then assign the request to any of the BI executives responsible to create a solution.

Responsibilities:

Receiving and reviewing all the data requests and then assign it to a BI executive.

Continuous follow up to all requests to make sure they got completed in the consented time.

Responsible of basic product reports.

Achievements:

Personally giving solution to 75% of all the data requests received through our Requirements System.

Innovating all the monthly reports that were assigned to me using advanced reporting tools.

Creating the first institutional report Anti-Attrition

IBM – Trantor

(IT Services Mexico, Distrito Federal)

IT Support Manager April 2008 to December 2008

As an IT Support Manager I was responsible to receive the support tickets generated by the IBM call center for on site support. I would then assign the tickets to an IT Technician for further attention and solution to the issue reported. I had to kept track on all assigned tickets and IT technicians responsible of the solution to ensure it’s completed before the consented due date.

Responsibilities:

Proper management of resources to ensure a 100% of positive solutions for all tickets received by the call center.

Proper follow up with the customers to properly understand the issue described on the tickets and then assign it to the best technician available for the task.

Keeping track on the tickets logs.

Installation of special bank related software and personalized configurations.

Achievements:

Reducing the backlog from 80% to 0% after the first month of taking the position.

Created an Incidents Report to use it as a FAQ’s for the technicians for a fast and accurate solution.

Teletech

(Call Center AT&T Campaign Mexico, Distrito Federal)

AT&T Tier 1 Technical Support September 2006 to November 2007

As a Tier 1 Technical Support my duties were to receive incoming calls from AT&T internet customers that may have been experiencing service outages or connection problems like slow connectivity and the lack of it. I needed to follow the service guide and give any assistance within the scope of support. If any customer was experiencing issues outside of the support of a Tier 1 technician, then the call had to be escalated to the next tier level for further attention.

Responsibilities:

Attending incoming customers calls and assist them following the approved guidelines.

Documenting customer data and issue in regard for organized customer management

Close all incoming calls within the established due time regardless of the outcome.

Hospital Merlos

(Health Services Mexico, Distrito Federal)

IT Support January 2005 to August 2006

As an IT Support for the Hospital Merlos, my duties involved installing and configuring all computer equipment. Installing and troubleshooting the modules of the ERP software called SIHOWIN. Server and client management and also ensure the networks was always working.

Responsibilities:

Installation and maintenance of all computer equipment.

Management and troubleshooting of all ERP modules of SIHOWIN (Hospital Management Software)

Performing network stress test to ensure its proper performance.

Computer Sales and Mantenaince

(IT Services Mexico, Distrito Federal)

Entrepeneur June 2001 to December 2004

I looked for personal customers in order to sell them computer equipment and service programs. I also built small networks for internet places. I had a catalog with all type of computer parts so the customers could by the computer and adjust the price to any budget available.

Responsibilities:

Selling and offering computer solutions to small businesses.

Assembling and configuring computer equipment.

Installing and configuring small networks.

Contact this candidate