Post Job Free

Resume

Sign in

Data Python

Location:
Chicago, IL
Posted:
January 19, 2021

Contact this candidate

Resume:

JAVIER VAÇIO-TAMEZ

Chicago, Illinois, U.S.A. • 312-***-**** • adjjrk@r.postjobfree.com

www.linkedin.com/in/javier-vaçío-tamez

Professional Synopsis

A mathematically precocious IT Developer/Programmer with an extensive aptitude for learning very quickly and adapting effortlessly. Adept and agile at providing innovative solutions as a high-level problem solver and critical thinker.

Education

Northeastern Illinois University Date of Graduation: May 12, 2014 Bachelor of Science: Applied Mathematics

Minor in Computer Science

University of California at Berkeley September 2009 – June 2010

Phillips Academy Andover Class of 2009

Experience

Northern Trust: SR IT Business Consultant (Contract) May 2019 – December 2020

Technologies Utilized: Excel, VBA, PowerBI, Fundmaster(AS400), SQL Server, Power BI, Python, Powershell

Utilize my strong knowledge of VBA, SQL, and Power BI to support Investment Operations Cash Processing and Foreign Exchange service teams.

Investment Operations SME Team:

•Serve as SME for IT development and reporting.

•Provide on-site, expert-level advice, support, and troubleshooting to all investment client service teams.

•Act as liaison between business users and off-site macro development team for issues related to

using, testing, and developing macros.

•Identify improvement opportunities and create or review business requirements to address

business needs.

•Solve complex macro problems and create solutions for various business processes using Excel

VBA and FUNDMASTER or other ETL process automation solutions.

Create stored procedures and complex queries for financial database operations in SQL and ETL processes.

•Provide macro development as needed during periods of peak demand

•Establish and maintain Best Practices relative to the lifecycle of macros

•Maintain governance over our inventory of macros, including access rights, business continuity

protocol, decommissioning of obsolete or redundant macros, etc.

•Provide advice and training to staff in both one-on-one and group/class situations.

•Manage and own reporting metrics relative to investment operations utilizing Power BI

•Participate in meetings and calls with all organizational levels internally.

•Be a key stakeholder in Process Optimization programs to enhance existing process and design

an optimal future state

BERKOT’S SUPER FOODS: SR IT Business Consultant (Contract) February 2019 – May 2019

Technologies Utilized: Excel, VBA, PowerBI, SSIS, SQL Server, Shell Scripting, HMTL, SQL Azure

Leads and control complex analysis for IT Cloud migration (SQL Azure) and integration projects.

Implement solutions that improve the quality of services delivered leading efforts to integrate, test and implementation of solutions to achieve desired results.

Utilizes problem solving, decision making and analytical skills to meet changing business needs.

Leads efforts with department(s) to define and document current business processes and areas for improvement.

Oak Point Partners: Sr. IT Business Consultant (contract) October 2018 – January 2019

Technologies Utilized: Excel, VBA, SSRS, SSIS, SQL Server, Shell Scripting, Python

Work on internal projects, developing, & maintaining applications centered on the particular needs of individual business units.

Build VBA applications (user interfaces) for various excel based data sheets.

Design and code various types of automated reports (operational, financial) via SSRS.

Gathering and defining user requirements.

Database / Data Modelling Design & Development in MSQL.

Leverage available tools, appropriate languages and technologies on the way to successful completion.

Data migration between SQL server and Azure.

McDonalds: Sr. IT Business Consultant (contract) March 2018 – October 2018

Technologies Utilized: Excel, VBA, SSRS, SSIS, SQL Server, Oracle, OBIEE, Shell Scripting, Linux, Sharepoint, SQL Azure

Work on a multitude of diverse business problems and translate that knowledge into a technical solution. Create new financial applications while enhancing and supporting existing applications in their full life-cycle application development, including requirements gathering, design, coding, testing, QA and documentation and production support.

Work on moderately complex systems development projects including:

Gathering and defining user requirements

Database / Data Modelling Design in Oracle & MSQL & DB2

Complex ETL work with OBIEE

Complex Advanced Programming in VBA (5000+ line scripts)

Financial applications dealing with all of finance viz. accounting, reporting, sales, taxes, compliance, etc.

Developing and supporting financial applications with very advanced complex business logic on front and back end.

Testing, implementation, & follow up.

Utilized Agile mythology.

BMO Financial Group: IT Business Analyst September 2016 – February 2018

Technologies Utilized: Excel, MS Access, VBA, SSRS, SSIS, SQL Server, Shell Scripting, DB2, SAS, Spotfire, Datameer, PowerBI, Python, Sharepoint, Linux

Present Build and maintain a “World Class” Center of Excellence in Customer Analytics by:

Building data and analytics capabilities

Driving actionable insights

Leveraging data to deliver actionable insights that will drive increased revenues and improve the overall BMO customer experience

Work closely with the broader U.S. Customer Analytics teams as well as the Campaign Management team to support them in their business as usual data challenges and opportunities.

Responsible for standardizing data naming, establishing consistent data definitions, monitoring/auditing the data quality, and executing cleansing and policy agreements.

Work closely with technology and operations partners and various Lines of Business to perform investigation and remediation of Customer Data Quality issues.

Work closely with the broader U.S. Personal and Commercial Customer Analytics team (modeling, campaign management, reporting) to support them in their business as usual processes including, but not limited to:

Support existing as well as design and develop new data enrichment processes requiring secure exchange with third party vendors and loading to U.S. Customer Analytics data mart

Support requirements gathering, design and development of common data structures for consumption by the broader U.S. Customer Analytics team

Coordinate directly with technology partners to operationalize data management processes

Support design and development of key performance indicators and data quality metrics

Support answering data related questions and solving data related challenges

Support Master Data Management (MDM) efforts within the U.S. Personal & Commercial as well as the US Private Client Group including, but not limited to:

Review data quality reports with Data Owners and Data Stakeholders to: Understand root cause of quality deficiencies, support the formulation of appropriate remediation plans with Data Owners and Technology

Support Customer data quality investigation, remediation, and verification

Support the development of key performance indicators and data quality metrics

Provide ongoing analysis for refining existing cleansing rules or the development of new data cleansing rules

Perform analysis to determine requirements for refining existing or new matching rules for MDM

Collaborates with stakeholders to define business objectives, process, and requirements

Design complex VBA scripts with embedded SQL for complex ETL work in MSQL, Oracle, & DB2

Utilized PowerBI to maintain and update reports.

Utilized Python’s Pandas module for data analysis.

Utilized Agile Methodology in development.

Univar: SQL Developer (Contract) August 2016 – September 2016

Technologies Utilized: Excel, SQL Server, Python, Sharepoint, SQL Azure, AWS

Translated business and functional requirements to technical specifications in the context of the data warehouse and implemented efficient and repeatable technical solutions using highly optimized and standards-compliant SQL queries.

Designed and developed complex queries and data models for a high performance projects and deliverables.

Designed, developed, and maintained tables, stored procedures, views, schemas, and functions in SQL Server while ensuring their stability, reliability, scalability, and performance.

Maintained and managed revisions of code in production, testing and development environments.

Worked with Business Intelligence Team to gather and refine business and data requirements to produce well-designed and developed solutions.

Migrated legacy data into SQL Server 2016 and AWS (Amazon Web Services) cloud RDS (relational database services).

Utilized Agile Methodology in development.

Basware: Data Integration Consultant November 2015 – July 2016

Technologies Utilized: Excel, SSIS, Oracle, SQL Server, XML, Python, IIS, XPath, Sharepoint, Linux, HTML

Working with internal and external Project Managers, Solution Architects, and other key business users to scope integration solutions and conduct technical gap analysis of environments.

Development, validation, and deployment of ETL activities with different datasets (e.g. DB, XML, CSV) for various software systems (e.g. ERP, Document Archiving, Purchasing).

Delivery of the relevant documentation during project milestones (e.g. integration mappings, process flowcharts, testing results, migration scripts).

Contributing and supporting the company integration strategies, templates, development practices, and quality assurance plans.

Deploy data models and business processes with numerous ERP systems.

Automated the accounting processes for large fortune 500 companies.

Working in international projects and global deployments in a multicultural atmosphere.

Development work in SQL Server and Oracle. Writing SQL procedures and complex queries. Writing complex PL/SQL statements and queries in Oracle.

Used Python to write data integration scripts

BERKOT’S SUPER FOODS: IT Business Analyst February 2015 – November 2015

Technologies Utilized: Excel, VBA, MS Access, PowerBI, SSIS, SQL Server, Shell Scripting, Python, HTML

Designed scripts, tests and debugged, documented, and implemented changes to new or existing databases and applications; acting as a Database Administrator.

Developed IT solutions within their POS system SMS LOC and performed multiple data analysis.

Met with end users and vendors to assess information flow and processes in order to develop custom scripts, ad hoc financial reports, and applications for efficient management.

Heavy programming and development in SQL Server and VBA. Importing Data into Excel from external Databases.

Created Complex ETL VBA scripts with embedded SQL.

Designed complex VBA macros in VBA.

Creating and optimizing SSIS packages for complex workflows and ETL between SMS LOC System and SQL Server.

Acted as DBA for company’s large SQL server Database.

Wrote Python shell scripts for automation of tasks.

Used PowerBI to develop reports.

Utilized Python’s Pandas module for data analysis.

Skills

Programming

Highly proficient in T-SQL 2012, DB2, Netezza, DataMeer, Google Apps Script, SAS, Python 3.0, VB.net, SharePoint.

Intermediate proficiency in Matlab, R (Knowledge of Statistical Modeling), C#, and HTML.

Proficient w/ Shell Scripting and comfortable with working from Linux Command Line.

Experienced in working in Linux Environment: Debian Ubuntu 16.04 and Red Hat Fedora 22.

Proficient in working with XML, XPath, and XSLT.

Software

Proficient in Microsoft Office Suite 2013

Fluent in Excel viz. Advanced Functions (Conditionals, Math, text, etc.), Pivot Tables, V/H Lookups.

MetaTrader 5 (Highly adaptable to other basic GUI financial platforms).

Proficient with SQL Server Data Tools (Business Intelligence) vis à vis SSIS (ETL), SSRS, & SSAS.

Languages

Fluent (Reading, Writing, and Speaking) in Spanish. Advanced coursework in reading, writing, and speaking French.



Contact this candidate