Data Analyst Python

Miguel Almanzar

• addo12@r.postjobfree.com • https://www.linkedin.com/in/miguel-almanzar-programmer/ •

Professional Profile

Experienced Reporting and Data Analyst. Skilled in developing and maintaining analytical reporting, managing and testing ETL process between Data Warehouses, Data Wrangling of unstructured data using technologies such as Python, SQL, SSRS, Amazon Redshift and MongoDB. Knowledge and understanding of numerous software packages, operating systems and Cloud based solutions. Excellent verbal, written, communication, and problem-solving skills..

Skills

• SQL, SQL Server Reporting Services (SSRS), MongoDB, MySQL, Tableau

• Agile, Selenium, Postman, JIRA, Zephyr, Confluence, Amazon Web Services, ETL processes

• Business Intelligence (BI), Data Management, Data Mining, Data Modeling

• Data mapping, ETL Processes, Data Wrangling using Python

• Software/Application Development and Testing (Python), Linux and Command Line Tools

Professional Experience

Reporting QA Analyst – Xenial, Charlotte, NC (Aug 2018 – Oct 2019)

Automated testing of POS Reporting application, Portal, Web API, using Selenium & Postman

Manual testing of POS applications and Web based Portal

Utilizing Amazon Web Services, New Relic S3 buckets

ETL testing with Python, Matillion, MongoDB, and Amazon Redshift

Collaborated and Communicated with Off Shore teams on testing web based reporting services across development stacks

Data Management of PII data across multiple Data Warehouses

Documented testing and processes utilizing Confluence, JIRA, Zephyr

Data Analyst & IT Support - Wikoff Color Corp Ft. Mill, SC (June 2016 – July 2018)

Data analysis and report building with SQL Server Reporting Services (SSRS)

Ad Hoc Report building of Sales, Inventory, Regulatory Reports using MS SQL & SSRS

Identify customer requirements and generated user story for report building

Identify KPI’s company wide for Report building

Data Management and Data Valiation of unstructured data for report building

One-on-One mentoring for end-users in the use of company products and services

Data & Reporting Analyst - Wikoff Color Charlotte, NC (June 2012 – May 2016)

Compiled Sales Analysis Reports utilizing Excel Spreadsheets and ERP Software (Chempax)

Inventory Analyst utilizing ERP Software (Chempax) and Spreadsheets

Data Modeling of unstructured data for data intergration with ERP software

Composed Environmental VOC Reports through Excel Spreadsheets and Access database extracts

Bilingual Customer Service for International Customers (English/Spanish)

Organized PowerPoint slides for Presentations and Meetings

Data Analyst & Lab Assistant - Wikoff Color Charlotte, NC (June 2009– May 2012)

Composed Color IQC report graphs and plots for data analysis

Data Entry of Formulas/Recipes utilizing ERP Software and Excel Spreadsheets

Composed Formulation Excel spreadsheets for customer color requests

Composed Excel Spreadsheets for Environmental VOC data analysis

Data Wrangling of Legacy Software to identify trends in Color Consistency

Inventory Control Analyst - Wikoff Color Charlotte, NC (June 2006– May 2008)

Inventory Control Management through ERP Software and Access Database

Generated Inventory Reports for Kanban and MRP using Excel Spreadsheets

Aggregated unstructured Inventory data for Data Integration

Identified trends, and KPI’s in Logistics and Inventory Control

Customer/Vendor relations specialist

Bilingual Customer service (English/Spanish)

Education

University of Phoenix - (2007-2008)

• Computer and Information Science and Support Services

Coursework and Certificates

Course work and Certificates can be found on my LinkedIn page

Python, SQL, SSRS, Tableau, MongoDB, Big Data, Agile, MS SQL Server, Linux

https://www.linkedin.com/in/miguel-almanzar-programmer/

Contact this candidate