Stephen Dropkin, Cspo Email & Phone Number

Saint Paul, Mn, Us

Bloomington, Minnesota, United States

Consulting on the development of business intelligence and analytical reporting, specializing in business & technical requirements, semantic layer development, and visualization tools.> Leading onshore and offshore teams in the development of the clients semantic layer and reporting platform leveraging Snowflake, AtScale and Tableau.> Led the reporting development of real-time promotional Tableau dashboards with email updates pushed to subscribers every hour. >… Show more Consulting on the development of business intelligence and analytical reporting, specializing in business & technical requirements, semantic layer development, and visualization tools.> Leading onshore and offshore teams in the development of the clients semantic layer and reporting platform leveraging Snowflake, AtScale and Tableau.> Led the reporting development of real-time promotional Tableau dashboards with email updates pushed to subscribers every hour. > Managing client reporting requests within the agile framework.> Trained client Tableau users and leadership teams on Tableau dashboard interactivity and self-service ad-hoc report development. Show less

Minnesota, United States

Plymouth, Minnesota, United States

APi Group(Industry: Construction)Led the payroll data migration to Dayforce for 2 Canadian subsidiary companies of APi Group as the lead data analyst. Assisted in the data migration of 5+ US subsidiary companies. Collaborated with offshore teams on functional and technical requirements. Advised as a Power BI subject matter expert on reporting development, tool capabilities, and strategic implementation approaches.

Bloomington, Minnesota, United States

Thrivent Financial(Industry: Financial Services)Leading client project teams with down stream data implementations through requirements analysis, conceptual and logical modeling, view reporting design, source to target mapping, testing, and dashboard development. Consulting on data project lifecycle management. Coaching on IT business analysis and dashboard development (Power BI & Tableau). Collaborating with offshore development teams.

Bloomington, Minnesota, United States

Thrivent Financial(Industry: Financial Services)Business Analysis -• Solicited business requirements through client working sessions, including directors, managers, and subject matter experts• Drive initiative status meetings with leadership teams• Consult with team leads on best practices for business analysis, road mapping, and requirement gathering• Identify and escalate areas of risk within client data regarding durability of their architecture, integrity of… Show more Thrivent Financial(Industry: Financial Services)Business Analysis -• Solicited business requirements through client working sessions, including directors, managers, and subject matter experts• Drive initiative status meetings with leadership teams• Consult with team leads on best practices for business analysis, road mapping, and requirement gathering• Identify and escalate areas of risk within client data regarding durability of their architecture, integrity of their data, and reporting automation limitations• Led classes on Data Terminology & SQL Fundamentals Data Analysis - • Reverse engineer and translate existing ETL and individual SQL scripts into project requirements and rules Show less

Bloomington, Mn

Aramark Uniform ServicesJuly 2019 - April 2020 (10 Months)October 2018 - December 2018 (3 Months)(Industry: Retail)Augeo Affinity Marketing, Inc. January 2019 - June 2019 (6 Months)(Industry: Marketing)Business Analysis -• Facilitated client leadership and stakeholder meetings to solicit business requirements for KPI reporting• Assisted in the facilitation of Rapid Process Mapping sessions: diagnosed client issues and technology to identify their… Show more Aramark Uniform ServicesJuly 2019 - April 2020 (10 Months)October 2018 - December 2018 (3 Months)(Industry: Retail)Augeo Affinity Marketing, Inc. January 2019 - June 2019 (6 Months)(Industry: Marketing)Business Analysis -• Facilitated client leadership and stakeholder meetings to solicit business requirements for KPI reporting• Assisted in the facilitation of Rapid Process Mapping sessions: diagnosed client issues and technology to identify their primary pain points used to create resolution recommendations.• Prepared business cases and proposals for cost-effective design alternatives, including procedural modifications• Standardized recurring reporting processes for efficiency gains• Created project roadmaps and timelines aligned with leadership business objectives• Performed basic analysis and resolution activities to identified issues ensuring that Service Level Agreements were met or exceededData Analysis - • Built source to target data mapping documentation• Reverse engineered and translated existing ETL and individual SQL scripts into project requirements and rules• Created future state data view models with source data locations, SQL coding with required transformations and business rule logic, and metric calculations for data engineers to create ETL with ease• Performed ETL testing through SQL coding in SSMS, Oracle, Vertica, Databricks, AWS, and Cloudera environments• Became trusted subject matter expert for clients’ dataAgile Facilitation - • Managed JIRA project and sprint backlogs• Facilitated sprint planning and backlog refinement sessions• Identified and constructed user stories and used cases accurately depicting business objectives Show less

Bloomington, Mn

• Consulted with internal teams on time consuming and costly processes to identify and implement automations or streamlined efficiencies.• Automated leadership KPI and operational reports through Tableau dashboards linked directly to source databases for internal customers, including the Finance, Financial Reporting, Cash Management, Accounts Payable, Accounts Receivable, and Process Improvement departments.• Administered the branches Tableau Server provisioning user accesses for… Show more • Consulted with internal teams on time consuming and costly processes to identify and implement automations or streamlined efficiencies.• Automated leadership KPI and operational reports through Tableau dashboards linked directly to source databases for internal customers, including the Finance, Financial Reporting, Cash Management, Accounts Payable, Accounts Receivable, and Process Improvement departments.• Administered the branches Tableau Server provisioning user accesses for published Tableau dashboards based on data sensitivity.• Project managed system integrations for acquired satellite offices in Dallas, Chicago, and Louisville pertaining to accounting, check processing, and cash management.• Developed 30+ Visio process maps on recurring processes to ensure they do not remain tribal knowledge. • Created and taught internal classes on data visualization, business cases, project charters, and project plans. Show less

Greater Minneapolis-St. Paul Area

Massachusetts (Southborough, Hopkinton, Framingham) & Rome, Maine

General property maintenance including interior painting and cleaning, landscaping, and deck refinishing.

Wilmington, Ma

Internship for improving company awareness and brand development through integrated social media marketing and customer engagement.

Lawrence, Ma

Internship to promote organizational communication, collaboration, and awareness through website enhancements for intuitive information searches, event planning, and communication collateral development including brochures, newsletters, and magazine advertisements.

Natick, Ma

Customer service associate in the sporting apparel department.

Lawrence, Ma

• Performed excel spreadsheet data entry to record employee hours for select projects• Edited summary documentation in support of Standard Operating Procedures revisions• Purchased parts utilizing general purchase order requisitions• Assembled and packed products in preparation for distribution

Marlborough, Ma

Warehouse associate for shipping and receiving, inventory, and order fulfillment of computer products.

Bachelor Of Science (B.S.), Business Marketing

Activities and Societies: Fraternity: Tau Kappa Epsilon

Leadership Fundamentals Certificate