Adam Corwin Email & Phone Number

Austin, Tx, Us

Austin, Texas, United States

~

Austin, Texas, United States

Through Theorem, LLC as a Senior Data Analyst• Review and Update SQL mapping specs using Snowflake and Git / Github• Review and Update SQL filters based on project scope changes• Collaborate with internal and external data stewards to update data quality metrics• Create Tableau reports for Data Management Office (DMO) KPIs• Establish best practices for Tableau dashboards including implementation and design• Present Tableau Dashboards to DMO Leadership and peers on current KPIs• Work with DMO development team to implement KPI data requirements and SQL updates

Austin, Texas Area

Collaborate with IT directors, and supervisors to gather Power BI report requirements and iterate on initial Power BI reports.Collaborate with other HHSC IT teams, and data owners to ensure accuracy within data being used for reports.Turned Create and maintain Power BI reports for IT leadership and supervisors using Power BI Desktop covering topics such as: o Upcoming and delinquent training o Performance evaluation deadline tracking o Contractor hour tracking o Contractor burn-down rates o Filled and vacant IT positions o Employee comp and overtimeEliminated the need for 8+ Excel reports sent out weekly with the creation of Power BI reports. This allowed for daily updates of the data using Power BI.Work with SharePoint developers to create ETL processes for report automation and weekly report updates.Provide weekly, bi-weekly, and monthly reports for HHSC IT directors and supervisors.Present to and train IT directors and supervisors on Power BI report functionality. Create and maintain SOPs for reports and Power BI workflows. Train team members on Power BI and Excel functions.Use Python (Pandas & Numpy) to clean data before Power BI ingest.Use Git for version control on projects were applicable.Complete analysis for Quarterly and Monthly Business Plans.

Dallas/Fort Worth Area (Dickies Hq)

Technical Skills: SQL, Tableau / Tableau Desktop, Shiloh, Datalliance System, Microsoft Excel, Excel Macros, Powerpoint, MS Office ProficientAdded new VMI programs and assortments into Datalliance system.Wrote special orders for seasonal items and programs.Created and maintained SOPs for VMI processes.Trained other team members on Datalliance systems and VMI process.Executed Dickies vendor managed inventory (VMI) and replenishment for key national accounts utilizing Datalliance systemsResponsible for purchase order creation, forecasting/profiling SKUs, seasonal planning, minimizing out of stock, and impacting inventory turn through productive and effective inventory replenishment. Created and maintained VMI tracking information such as mod fill, in-stock rates, rate of sale, weeks of supply, inventory on order, and other KPIs.

Dallas/Fort Worth Area (Dickies Hq)

Technical Skills: SQL, Tableau / Tableau Desktop, Shiloh, Datalliance System, Microsoft Excel, Excel Macros, Powerpoint, MS Office ProficientKey Accounts Overseen: Target, Kohl's, Fiesta, Tilly'sProvided weekly, bi-weekly, and monthly reporting of account sales, inventory, and other metricsMaintained ladder plans to ensure accurate sales planning and forecasting.Created business Dashboards and ad-hoc analysis using Tableau.Developed ad-hoc analyses for salesmen, team leads, other business stakeholders, and customers.Conducted team meetings across North America with business partner stakeholders.Trained team members on Tableau and advanced excel functions.Analyzed account sales data to find action avenues for business improvement opportunities.Cleaned and worked with large datasets to identify outliers and actionable items to improve supply chain operations.Responsible for forecasting/profiling SKUs, seasonal planning, minimizing out of stock, and impacting inventory turn.

Dallas/Fort Worth Area (Dickies Hq)

Executed Dickies vendor managed inventory (VMI) and replenishment for key national accounts utilizing Datalliance systemsResponsible for purchase order creation, minimizing out of stock, and impacting inventory turn through productive and effective inventory replenishment.

Westlake, Texas

Created new file storage system for business unitReduced business units storage footprint on network drive by more than 50%Creation of Powershell script to analyze network storage file structureAnalyzed network structure and created excel reports to report findings to leadership.

Westlake, Texas

Conducted independent research utilizing ambiguous data to formulate practical business solutions for recommendations to senior leadership.Consolidated internal and external data and performed analysis for operational reports as requested by Senior Leadership.Analyzed data and performed fact-finding research to create single version of the truth.Compiled data and insights for process improvement implementations by customer business units. Performed raw data analysis and due diligence to ensure complete accuracy of source data for development and deployment of capacity plans.Responsible for delivering validated plans for forecasting and staffing capacity plans.Participated in live Business Continuity Plan (BCP) exercise to test viability of disaster recovery preparedness.

Flower Mound, Texas

Database construction in excel with data cleansingConduct analytics based on sales and inventory as requested

Flower Mound, Texas

Pull restock merchandise and deliver to the sales floor.Replenish backroom stock with inbound products.

Staples Warehouse, Coppell Texas

Former licensed Non Commissioned Security Officer, through the State of Texas.Catch Internal and External Loss. Respond to safety incidents in Staples Warehouse Internally and Externally.

Plano, Texas

Greet customers upon arrival and manage seating flow. Maintain the front end of the restaurant. Provide customer service as the first point of contact, especially during peak periods.

Flower Mound, Texas

Inbound shipment receiving, check-in and put away incoming stock. Distribute orders, pick required stock, and then pack for shipment. Process customer orders and confirm shipments.

Bachelor Of Business Administration (Bba), Decision Sciences

Activities and Societies: Undergraduate Research, UNT I.N.F.O.R.M.S. member

Associate'S Degree, Science

Education record

Activities and Societies: Yearbook Team