Dan Gallo Email & Phone Number

Milwaukee, Wi, Us

Milwaukee, Wi, Us

• Effectively lead a team of three - varying from Junior to Senior skill levels• Responsible for team deliverables in both quantity and quality of work• Lead and drive report/dashboard development for multiple key company initiatives• Collaborate closely with Senior Leadership (Sr Director, VP and above) to ensure deliverables remain on target and on time• Present actionable insights to senior leadership and provide recommendations• Develop and maintain complex business logic for reporting needs• Participate in hiring and interviewing process when expanding the team• Act as point of contact for cross-departmental work• Continually improve prior development work to reduce tech-debt• Lead team migration from on-prem SQL Server to AWS Postgres environment• Create standards and best practices for team• Transitioned team to Git to facilitate version-controlled code• Run monthly Power BI workshop (open to entire enterprise and began by me in 2018) to provide continual development for Northwestern Mutual's Power BI Community of Practice

Milwaukee, Wi, Us

• responsible for ownership and continued maintenance for multiple Power BI Workspaces and the reports/dashboards contained within• build enterprise ETL solution to grab, land, and analyze Jira (and Jira related) data and then developed several Power BI reports surface key initiative and deliver insights• founding member of Power BI consortium to discuss and develop Power BI standards and best practices for the enterprise Power BI tenant• act as a subject matter expert for all things Power BI related• provide technical mentorship to team intern and junior team members• requisitioned server for the Reporting & Analytics team while developing team database standards• leverage Python as an ETL tool as our company continues to pivot over to APIs• build and maintain SSIS packages for ETL processes for internal data movement

Milwaukee, Wi, Us

• developed "Health of the Business" Power BI dashboard for C-Level executives• Power BI developer responsible for creation and maintenance of various Power BI reports and Dashboards• acted as sole data engineer to built out data lab from scratch to enable the Policy Benefits workstream to have workable, modeled data• lead effort to clean up database by removing deprecated tables, views, and stored procedures• key participant in multiple business practice events where we uncover gaps and process inefficiencies and develop more efficient workflows

New York, New York, Us

• Create, maintain, and regularly distribute reports/dashboards that track business KPIs • Key Finance contact for ongoing Data Warehouse project (began as proof of concept)• Constructed Lifetime Value Model, Subscription Forecast Model, Churn Model and Subscriber Analysis Tracker for subscription service• Construct SQL queries for ad-hoc requests to retrieve intricate metrics• Act as Data Steward and product owner of Reporting Portal• Collaborate with subject matter experts to understand business needs and requirements• Identify opportunities for improvement in reporting as well as operations and processes• Conduct on-going analysis of the business, operating practices, and data flows within and between various systems and applications

New York, New York, Us

• Aid in building multi-faceted models and forecasts• Support and develop management material for presentation to the Company’s Board of Directors • Key finance contact for operational departments, providing monthly updates of P&L activity and budgets vs. actuals • Closely analyze YouTube library of 80,000+ videos to ensure consistent and effective monetization

New York, New York, Us

• Led the implementation of automated software solution for Company-wide invoicing process • Accurately processed 1,000 invoices and payments per month in five different checkbooks• Worked closely with Controller and Assistant Controller to effectively manage cash flow• Provided accurate, detailed accruals at month end as part of month-end close process• Aided in setting up a Company-wide Corporate AmEx credit card program

New York, New York, Us

• Additionally provided support to two Senior Vice Presidents and Vice President• Assisted in prioritizing daily tasks to keep executives on schedule• Coordinated all travel arrangements – air travel, car service, and hotel• Assisted in logistics and planning of companywide events

New York, Ny, Us

• Provided full, daily support to two Vice Presidents and one Director• Managed multiple phones lines and calendars • Utilized creative problem solving and implemented new best practices