Learn Data Skills
Beta
Anthony Morales

Anthony Morales

Senior Data Engineer

Dext Capital, LLC | Portland, OR, USA

Technologies

My Portfolio Highlights

My New Track

Python Fundamentals

My New Course

Introduction to Python

Algorithm aficionado, dancing with equations in the realm of possibilities.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Intermediate Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Querying Microsoft SQL Server 2012/2014

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Dext Capital | Sep 2019 - Present

Senior Data Engineer

- Design and build an enterprise Power BI data model, configuring workspaces and deploying the initial set of reports for the business. - Architect and deploy a complete data solution, building and connecting our Azure resources to 3rd Party services in the cloud and behind firewalls. - Develop Azure Data Factory Datasets, Data Flows and complete Pipelines to import and transform data. - Developed a single Operational Data Store in Azure SQL Server comprised of over 1,000 source objects from multiple systems. - Built and Schedule Azure Services to automate all data exports with custom error handling including retry. - Customize and administer Salesforce, implementing sharing rules, validation rules, custom columns, reports, dashboards. - Develop Apex Triggers and Classes to extend and enhance Salesforce. - Perform a one time migration from our legacy front end system to Salesforce using Power Query M to transform the data and DataLoader to import it.
Show More

KinderCare Education | Jun 2018 - Sep 2019

Principal Business Intelligence Data Analyst

N/A

TEKsystems | Feb 2018 - Jun 2018

Senior BI Developer

N/A

Genesis Financial Solutions | Jul 2014 - Feb 2018

SQL Engineer

* Teach monthly classes on SQL Fundamentals and Optimization to the company analysts. * Designed and built our production phone number database which handles all compliance related logic including cellphone identification, 3rd party phone number identification and state my state restrictions. * Design and build the data warehouses used to generate most of the company's reports and drive our analysis. * Monitor SQL Server performance, optimizing queries and ensure critical process run on efficiently and without issues. * Write ETL processes to import and export data utilizing BCP, SSIS, SSRS and C# Data Tools SDK.

Genesis Financial Solutions | Feb 2013 - Jun 2014

Operations Reporting Analyst

* Designed Departmental KPI Reports (and underlying SQL) which summarizes the successes and status of our monthly and daily activities to the Executive Team. * Developed our Promise Reports which saved us the equivalent of one full time supervisor while also improving the overall accuracy of our incentive payouts. * Developed and Documented our Employee Database Structure which all of our employee based reports now rely on and designed a web based tool to manage Employee. * Developed a Staffing Modeling to effectively ensured that our outbound teams were adequately staffed to meet goals.

Freelance | Mar 2012 - May 2013

Developer

* Designed websites using the latest web standards (HTML5 and WAI- ARIA) and tested them using the most common Mobile, Tablet, and Desktop browsers. * Worked with clients on SAS Web Applications utilizing Ruby on Rails, No- SQL and AJAX while specifically contributing to their Analytical Data Parsing Algorithm. * Wrote Technical Guidelines and presentations to advise companies on Web and Software Solutions to assist with large decisions. * Created Social Media Strategies and Improved SEO to improve leads.

Stream Global Services | Feb 2010 - Mar 2012

Developer - Analyst

* Designed and built analytic Web Applications which tracked and prioritized its content based on the the users input ultimately improving efficiency and reducing handle times. * Performed regular usability analysis and focus groups to determine user needs and ensure accessibility. * Prepare management reports, defining and evaluating problems through mathematical and simulation models, in order to provide recommendations and action plans. * Confer with management and operation teams to prioritize lists, resolve conflicts, develop content criteria, or choose solutions. * Perform validation and testing of models to ensure adequacy and reformulate models as necessary.

Make it Personalized | Aug 2009 - Apr 2010

Assistant Manager

* Assist with the store management by monitoring customer preferences and determining where to focus sale efforts. * Review operational records and reports to determine profitability and approve budget expenditures. * Direct and coordinate activities involving sales of products and services. * Review layouts with clients and discuss design concepts, suggesting improvements as needed.

Gap Inc./Banana Republic | Jun 2006 - Jul 2009

Customer Experience Lead - Visual Specialist

* Consult with General Manager to plan advertising services and secure information regarding customer specifications. * Plan and direct staffing training, and performance evaluations to develop and control sales and service programs. * Oversee the management and budgeting for the back of store inventory. * Consult with advertising or sales staff to determine type of merchandise to be featured to improve sell through.

College of Mount Saint Vincent | Nov 2002 - May 2006

PC Technician

Provided technical assistance for computer users in person, via telephone, and through remote connections. Diagnosed, troubleshot and resolved hardware, software, or other network and system problems, replacing defective components when necessary. Maintained records of daily data communications, problems, remedial actions, and installation activities. Performed systems analysis and programmed tasks to maintain and control the use of computer systems.

Tekmark Global Solutions | Apr 2002 - Jul 2002

Consultant

Designed, built and maintained web sites, using scripting languages, content creation tools, management tools and digital media. Evaluated code to ensuring it met industry standards, validated, was proper constructed, and rendered on different browsers, devices or operating systems. Designed graphics and layouts for product illustrations, brochures, company logos, and multimedia presentations based on knowledge of layout principles and aesthetic design concepts.

My Education

Take a look at my formal education

Bachelor of Science in Computer ScienceCollege of Mount Saint Vincent | 2006

About Me

Anthony Morales

I've worked doing data analysis and data engineering using SQL Server, SSAS and Power BI for the past 10 years. As a Data Aficionado, I'm here to learn some more skills and keep my existing skills sharp.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free