| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name DiazStreet Address S Michigan AveChicago IL, Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLEEXECUTIVE SUMMARYSQL Analyst looking to support business automation & help gain insights into the business opportunities through various reporting techniques. Excellent experience using R language. Hands on experience in creating reports using SQL queries, SSRS, Crystal Reports, Power BI and Python and exposure to Azure and Databricks.TECHNICAL SKILLSMicrosoft TSQL, SSIS, SSRS, SSMS, Visual StudioMicrosoft Power BIR StudioPython-PandasOracle Cloud Fusion / OTBI and SQLMicrosoft Access (Forms, Queries, Macros, Reports)Microsoft Excel VBAMicrosoft Word TemplatesMicrosoft SharePointPROFESSIONAL EXPERIENCEWalgreens, Deerfield IL (remote)Business AnalystFeb 2023 August 2023Working primarily with Power BI, Azure Databricks, TSQL and some R Studio to report on transactional data for the Micro Fulfillment initiative with respect to tote usage averages, cycle counts, and arrival patterns. Both ETL and Power BI design concepts have been the focus.1.Power BI reporting using DAX measures and data modeling relationships.2.TSQL was utilized as CTEs including stored procedures.Busey Bank, Champaign IL (remote)Senior Compliance AnalystJan 2022 Oct 2022 (restructuring)Responsibilities involved:Working with R Studio to build quarterly sales exception reports: retail product exceptions, mortgage rate and pricing exceptions, indirect auto loan rate exceptions, internal complaints tracking.1.Tidyverse, Tidycensus, Rmarkup, Janitor, Internal R Studio packages and libraryCognos Reporting (late migration from R)1.Queries, Reports, VisualizationsProcedural documentationSpatial plotting with R TMAP packageSAC Wireless, Chicago IL (remote)Business Systems/Reporting AnalystMay 2020 to October 2021Responsibilities involved:Working with Oracle to create custom SQL scripts for HR timekeeping.Wrote & Designed SQL queries, stored procedures, SharePoint Power Automate for Excel quoting system.Working with Python, Excel, SharePoint, Azure to research API automation.Created new SQL queries, views and stored procedures for reporting purposes.Created & involved in Oracle database reporting and analytics.Excel Visual Basic macrosAPI connections to Azure portal and Base64 unpacking using R scriptsEdsal Manufacturing, Chicago, ILReporting AnalystNov 2018 to Dec 2019 (Contract)Developed a Balance Sheet and Income Statement in combination with text string parameters as a SSRS drilldown report for use as a company consolidated, general ledger code only, or location level statement including customizable month and year date ranges.Data included legacy Excel files and live SQL databases utilizing a SSIS month end import procedure.1.SSMS, SSIS, SSRS, Visual Studio, Power QueryExcel KPI with Power Pivot and SQL scripting: Labor hours, headcount, finished goods, productivity, on time deliveries, shipping fines as a percentage of sales, point of sale inventory on hand (Power BI Graphs).1.SSIS, SQL views, Power BI, DAXLight Efficient Design, Cary, IL (hybrid)Business/Reporting AnalystMay 2016 to Sep 2018 (Permanent)Commission Reporting with SQL scripting in combination with Excel and text files with year to date aggregated by product and customer.1.SQL scripting, Power Pivot, DAX.SSRS Profit and Loss reporting, Balance sheet ETL table (SQL scripts provided).1.Journal entries foreign currency translations incorporated into an SSIS procedure.Commission journal entries via text file for import into ERP (Syspro) including a hyperlink to a pdf report of detailed customer transactions with MS Access switchboard.1.MS Access, Power Pivot.Customer and sales representative reports with sales segmentation/marketing campaigns.1.SSIS, Excel, Power BI.2.SharePoint Flow and Business Apps.3.Introduction to R-language scripting.4.Demand versus Pricing.Contract Roles: 2007 -2016Constellation Brands, Chicago, ILData AnalystSep 2015 to Jan 2016 (Contract)Cognos Data Mart to Excel and MS SQL Express for data analysis.Supported end users with data related issues related to business change of addresses, marketing tags, inventory usage.Documented internal data governance process: MS Word, PowerPoint.Lincoln Park Zoo, Chicago, IL Data Analyst Jun 2015 to July 2015 (Contract)Family Health Network, Chicago, IL Data Analyst Nov 2014 to Jan 2015 (Contract)Signode Corporation, Glenview, IL Data Analyst Mar 2014 to Oct 2014 (Contract)Paper-Source, Chicago, IL Reporting Specialist Nov 2013 to Dec 2013 (Contract)Maximus Chicago, IL Reporting Specialist May 2013 to Aug 2013 (Contract)Ace Corporation Oakbrook, IL Data Analyst Jun 2012 to Mar 2013 (Contract)Zebra Technologies, Vernon Hills, IL Staff Accountant Nov 2011 to Apr 2012 (Contract)Leica Microsystems, Buffalo Grove, IL Data Analyst Jun 2010 to Apr 2011 (Contract)Electro-Motive Diesel McCook, IL Cost Accountant Apr 2009 to May 2009 (Contract)Thermal Care, Niles, IL Staff Accountant Oct 2008 to Jan 2009 (Contract)FHP, Northlake, IL Cost Accountant Feb 2008 to May 2008 (Contract)Mercury Products, Schaumburg, IL Cost Accountant Oct 2007 to Dec 2007 (Contract)Johnson & Quin Niles, ILFinancial Systems Administrator/ Cost AccountantOct 2004 Apr 2007 (Permanent)Developed departmental charging rates (OH and Direct Labor);Data governance using MS Access and reported direct labor hour variancesJournalized department costs (ERP, Crystal Reports, Microsoft Access, Great Plains);Job Costing: journalized WIP, COGS and FGs to Great Plains (Microsoft Excel, Microsoft Access); reported gross margin (Microsoft Access); reported monthly overtime (Monarch modeling, Microsoft Excel: pivot tables and vlookups); Ad-hoc reported (i.e. old margins recalculated with new charging rates); maintained fixed asset database: new asset entries; journal entries, reporting; implemented ERP inventory: hardware, software, and employee training (PrintStream, Microsoft Access, Visio, Excel, Word); performed inventory cycle countsSaratoga Specialties Elmhurst, ILCost AccountantJan 2002 Sep 2004 (Permanent)Reviewed customer orders for revisions, delivery dates, and pricing; entered bills of material, labor routings, and outside processing standards into ERP system;Data governance: variances of production costs: labor, material usage, substitution, overhead; investigated standard cost variances of purchase and inventory transactions: standard cost changes, purchase price variances, miscellaneous issues and receipts, miscellaneous inventory adjustments, and warehouse transfers; reviewed routings;implemented an estimating system to improve customer response time, reduce administrative costs, and reduce inactive data in ERP (Microsoft Access); troubleshot, trained or scheduled training for ERP software (Adage); upgraded hardware and networking; exposure to AP and AR (AS400)Various short term roles Jan 2001 to Dec 2001Accounts Payable Aug 1996 to June 1997Access Reporting (Payroll)AuditingTriton industries, INC Chicago, ILCost AccountantJuly 1997 Nov 2000 (Permanent)Reviewed all cost estimates for material, labor, and external processing; reviewed all customer orders for revision levels, delivery dates, and engineering changes; entered bills of material, labor routings, and outside processing standards into ERP system; Job Costing: direct material and labor variances versus estimate or standard; updated standards in collaboration with engineers, supervisors, or estimators; modeled new pricing in Excel; reported gross margin (Monarch modeling and Microsoft Access); automated labor variance reporting per shift, per job, per supervisor (ERP Consultant); established an FTP site for CAD/CAM drawings (ERP Consultant); automated ERP faxing of purchase orders and customer order confirmations (ERP Consultant); set up new employees with hardware, software, and networking; investigated ERP and Workstation system errors; administered Year 2000 ERP software conversion (ERP Consultants)Achievor Tire Chicago, ILAdministrative AssistantJuly 1995 June 1996 (Contract)Accounting and Sales Support; vendor management -purchasing and freight (reduced costs); perpetual inventory tracking (Excel)Education:Bachelor of Science, Finance 1995 University of Illinois at Chicago.Other:Bilingual: English/Spanish |
