Data Analytics Sql Server

ENGEL J. ORDAZ

Dallas, TX 954-***-**** ********@*****.*** linkedin/engel-ordaz

SUMMARY

Analytically minded professional with hands-on experience in data analytics and fulfillment operations. Skilled in interpreting complex datasets, creating visualizations, and leveraging tools like SQL, Python, Tableau, and Looker Studio to support data driven decision making. Proficient in writing SQL queries, handling null values, and utilizing aggregate functions to manage and analyze large datasets. Experienced in quantifying business problems, performing trade-off analysis, and optimizing workflows to improve efficiency and accuracy. Strong ability to analyze, clean, and present data to uncover actionable insights. Bilingual in Spanish and English, with excellent communication and teamwork skills. Seeking to leverage my technical expertise and analytical mindset to drive business success.

SKILLS

Data Analytics: Data Interpretation, Data Sourcing, Data Profiling, Data Wrangling, Data Curation, Predictive Modeling.

Technical Skills: Microsoft SQL Server, SQL Server Management Studio, Tableau, Power BI, Looker Studio, Microsoft Office (Excel, Access Word, PowerPoint), Google Cloud Platform, Google Suite (Sheets, Docs, Slide), Slack, Windows.

Programming Languages: Python, SQL, C#, JavaScript.

Fulfillment Operations: Picking operations, packing, receiving, induct processes, problem-solving for picking discrepancies, inventory management, RF scanner operation, quality control.

SOFT SKILLS

Attention to detail, time management, teamwork, adaptability, communication, problem-solving, ability to work under pressure.

LANGUAGE

Spanish (Native), English (Proficient).

RELEVANT EXPERIENCE

Correlation One Remote

Data Analytics Training Program Jun 2023 - October 2023

• Participated in a 24-week data analytics program facilitated through real data analytics business cases to solve business and technical issues.

• Reduced data duplication by 30% using Excel's conditional formatting and formulas, improving data accuracy and efficiency.

• Conducted linear regression analysis in Excel to uncover strong correlations between advertising spending and customer acquisition, optimizing ad budgets and achieving a 20% increase in customer acquisition rate.

• Cleaned and standardized customer databases by removing null values using Excel’s data cleaning functions and SQL queries, ensuring reliable reporting and analysis for critical decision-making processes.

• Organized and streamlined data processing workflows using Pandas and NumPy in Python, reducing data preparation time by 40% and enabling faster insights generation.

ADDITIONAL EXPERIENCE

Amazon Dallas-Forth Worth, TX

Outbound Operations Ago 2021 – Oct 2024

• Consistently exceeded daily productivity targets by 15% in outbound operations, ensuring timely and accurate order fulfillment, which contributed to a 10% reduction in shipping errors.

• Identified and resolved order discrepancies, improving outbound process accuracy by 20% and supporting a 95% on-time shipment rate, directly impacting customer satisfaction and positive feedback.

EDUCATION

Universidad Gran Mariscal de Ayacucho (UGMA) Venezuela

Juris Doctor 1999 - 2004

Instituto Universitario de Tecnología Isaac Newton Venezuela

Associate Degree in IT (Credits 79/113) 1996 - 1999

Contact this candidate