Data Analyst Business

Lance J. Dorsey Jr.

E-mail: **************@*****.*** Mobile: 414-***-****

OBJECTIVE:

Seeking an employment opportunity where I can leverage my strong analytical and technical abilities to develop effective data models, visualize data, and uncover insights that drive organizational success.

EDUCATION: University of Wisconsin – Whitewater

Bachelor of Business Administration; Information Technology – Business Analysis

EXPERIENCE:

National Guardian Life – System Analyst Madison, Wisconsin April 2024 – August 2024

●Aided in developing, executing and maintaining test plans, test scenarios, test cases and test scripts.

●Documented and evaluated test results and defects to ensure that quality issues and defects were appropriately identified, prioritized, documented, tracked and resolved.

●Worked with a team to identify and develop acceptance criteria

●Applied understanding of acceptance criteria to test and evaluate new or modified software features and functionality with an emphasis on delivering high quality software.

●Led Daily Stand-Up, Release Planning, Review and Retrospective meetings on a rotational basis.

Northwestern Mutual – Business Analyst Milwaukee, Wisconsin July 2020 – September 2023

●Responsible for fact-based requirement gathering, including all system, technical and intake requests as well as presenting said requests to engineers and team at daily standups.

●Acted as a liaison between the business and DevOps, regularly meeting with stakeholders of various departments to discuss requirements, timelines and expectations to ensure that work was getting done in a timely manner.

●Aided engineers in performance of user acceptance testing for new software applications, documented and evaluated findings

●Created, documented, and implemented improvements to data reporting and visualization systems such as Power BI and through partnerships with IT and other stakeholders.

●Participated in daily standups, creating epics, features, and user stories in Jira under an agile framework, and used this data to create visualizations to track departmental progress down to the sprint level.

●Created process flow diagrams of various business processes in Viso.

Brady Corporation – Data Analyst Milwaukee, Wisconsin August 2019 – June 2020

●Creating, identifying, testing, documenting, and implementing improvements to data reporting systems and processes through partnerships with Sales, Marketing and other key stakeholders in applications such as Excel, PowerBI, Google Analytics and SalesForce.

●Had ongoing meetings with stakeholders in Sales, Marketing, and other departments to discuss progress, update technical documentation, and present findings of weekly, monthly, and ad hoc reports.

●Performed analysis on large datasets to identify opportunities and risks in support of business case development for Finance, Operations, Sales and Marketing Teams.

●Aggregate and analyze data from multiple sources (financial, CRM, ad hoc) in languages such as Python to build visualizations and unearth meaningful insights to support business initiatives in a fast-paced environment.

●Assist in developing material to communicate modelling results to technical and non-technical audiences.

Abbott Laboratories – Business Relationship Management Waukegan, Illinois May 2018 – August 2018

●Communicated with business and documented user authentication processes in a corporate web-based intranet tool called ESAM.

● Researched and presented multiple different software applications to aid in the acquisition, standardization, and organization of the business to further enhance business processes.

●Assisted with and conducted solution assessment and validations to ensure functional and technical specifications met identified business needs.

Abbott Laboratories – Forecasting Automation Waukegan, Illinois May 2017 – August 2017

●Defined business requirements to create and test use cases on current and new systems for forecast automation.

●Analyzed and prepared data for statistical forecasting in APO and IBP.

●Explored the use of new automation forecasting tools to replace the current companywide supply chain system.

SC Johnson – Data Scientist Racine, Wisconsin May 2016 – August 2016

●Programmed in Python language to designed and implement a data import mechanism with machine learning capabilities to store and categorize chemical formulas that code for various smells based on various criterion.

●Built visualization reports in Tableau to discuss findings with non-technical stakeholders.

●Led demonstrations to executives to justify machine learning projects and their benefits to the organization including improved inventory management, improved product quality and design, and reduction of production cost.

SKILLS/PROFICIENCIES:

●Python, R, SAP, Visual Basic, SQL, Excel, Power BI, Confluence, Tableau Scrum, Agile Methodology, Jira, User Acceptance Testing, CRM (MS Dynamics), Google Analytics, ServiceNow, Visio

Certifications: Tableau Certified Data Analyst, Data Analyst in SQL Certification, PL-300: Microsoft Power BI Data Analyst

Contact this candidate