Post Job Free

Resume

Sign in

Agile Scrum Product Business Data Analyst Alteryx

Location:
Jersey City, NJ
Posted:
March 25, 2024

Contact this candidate

Resume:

Daniel Weierich

NY/NJ Metro

Remote or on-site

ad4kdr@r.postjobfree.com

SKILLS

Product:

SCRUM, Agile SDLC Framework, SAFe, Jira, MS Azure Devops, Kanban, Waterfall, Roadmap, Customer Journey, Swimlane, Burndown, Epics, User Stories, Sprint Planning, Product Backlog, BRD, SoP, DLP, ERP, Confluence, Atlassian, Visio, Lucidchart, flowchart, Sharepoint, B2B, B2C, Salesforce, Enterprise Data, Business Requirements, Customer Experience, Portfolio, Product & Project Management, Product Reporting Dashboards, Presentation Skills, KPI Design and Analysis, ServiceNow

Data Analysis:

ETL Development, Alteryx, Tableau, TOAD, MS SSMS, CMS, QA, Smartsheet, Citrix, Data Analytics, Data Modeling, Data Governance, UAT User Acceptance Testing, UX/UI, SEO, PHI, Big Data, Data Parsing, Membership Data, Financial Data

Management: Program & Portfolio Management, Release Train Engineer, Change Management, Resource Management & Demand Forecasting, Creative Strategy, Change Management, Corporate Development Goals & Target Management, Enterprise Project Tracking, Stakeholder Presentation, Access Management CERTIFICATIONS

Certified Full-Stack Developer: Rutgers University-New Brunswick, 6-month Coding Bootcamp Professional Scrum Master I: Issued by Scrum.org

Agile Development with Jira Software: Issued by Atlassian Jan ‘24 SAFe - Executing Scaled Agile Framework: Issued by Coursera.org Jan ‘24 Jira Agile Roadmaps: Issued by Coursera.org Feb ‘24 Alteryx Foundation: Issued by Alteryx Mar ‘24

Alteryx Designer – General Knowledge: Issued by Alteryx Mar ‘24 Alteryx Designer – Data Manipulation: Issued by Alteryx Mar ‘24

*I was overseas May-November ’23

WORK EXPERIENCE

Kaiser Permanente Denver, CO

Product Consultant IV Jul 22 – Apr 23

Product Release Owner & Scrum Master

Data Management Senior Nov 21 – Jul 22

Data Governance

Randstad Technologies Group May 21 – Nov 21

End Client: Kaiser Permanente

Business Analyst – Contractor

(2021-2023)

• SAFe Release Train Engineer for the Charitable Health Coverage Program:

- Product - Medicaid Eligibility Determination Engine software & web-based dashboards. Ad campaigns to healthcare members

- TechOps - Managing data integrity, data demographics, ETL cloud scheduling, PowerBI KPI dashboards design, Optical Character Recognition

- BusOps Compliance - Audit readiness each enrollment period based on state and federal requirements

- ERP – resource planning, licenses, equipment, onboarding/offboarding process

- CRM – Customer retention & outreach, SMS system, CX, UX o Design MS Azure DevOps & Jira Epics, User Stories and Tasks from the Product Backlog into understandable sprint planning to create data loads, version control and visualizations for interval releases o Exercise best practices in data governance for test & production environments o Design QA tests for ETLs and incremental software releases for membership financial payments o Launch scheduled ETLs to Alteryx cloud Gallery

o Conduct quarterly Discovery phase for the UI/UX of a desktop app used by the data entry team o Use of burndown and velocity methodologies to align with resource management and project timelines o Design UAT scripts for both desktop UI features and training modules, including regression testing to finalize effectiveness of sprint tickets and app functionality for the production environment o Identify obstacles, blockers, issues, if any, to avoid in the next release o Launch the new production environment and host a stakeholder meeting to review updates and accomplishments

• Primary founder for Other Health Coverage reconciliation program to assess dual coverage overlap in big data sets

o Pioneered a new customer experience for SFTP data accuracy from third-party clients o Launched the Agile Scrum process using Microsoft DevOps o Discovery phase to launch UI/UX requirements for stakeholders to view a new, high-value way to understand metrics to align with company KPIs

o Re-work of Excel file usage into scheduled cloud runs of Alteryx ETLs o Produced a $1.9M company net gain in the first year o Net gain from healthcare consolidation led to 4 new hires

• Launch of 2 new ideas for CX as healthcare members o Use of an SMS system to remind members of important dates for action items o Use of iPads at locally hosted sign-ups to have data directly load into the server to move away from the old process of pen & paper, data entry method

• Assess PHI & PII data regarding prescription, clinical and healthcare membership usage

• Strategize market pricing for key demographics based on zip code and eligibility

• Engage with stakeholders to clarify realistic capabilities of the technical team

• Large dataset server migrations into Medicaid data warehouse. Combining IBM iSeries, MS SQL Server, Oracle ACS Group, Inc. Santa Monica, CA

End client: Kite Pharma, a Gilead Sciences Co. Dec 19 – Nov 20 Business Analyst II - Contractor

Corporate Development, Program & Portfolio Management

• Resource & Demand forecast modeling, work alongside Product and Transformation Management Offices

• Proposed and integrated Program & Product goals into Jira Agile framework from Smartsheet & Excel tracking

• Integrated user stories for new ways to approach ERP for resource management in 10+ yr Product timelines

• Owner of corporate development goals dashboards, KPIs and targeted metrics over 5 year timelines, reports relayed to C suite

• Strategize with Tech Ops to incorporate resource management to align with corporate goals

• Analyze & design KPI metrics to find weaknesses in product cycles, alternate uses for resources over extended timelines

Kforce, Inc. San Diego, CA

End client: Kaiser Permanente Feb 18 – Mar 19

Database Developer - Contractor

Medicare Operations Reporting

• Design and maintain ETLs using Alteryx for data to be loaded into server-side database applications

• Alteryx development for reconciliation of membership financial payments

• Develop Alteryx error notification to prevent incorrect data passing to production environment

• Ensure integrity over big data sets of private healthcare information

• Agile framework for in-house software applications to prevent loss of entitlements BrightScope, Inc. San Diego, CA

Enterprise Analyst Jul 17 – Feb 18

Product Team, B2B

• Utilize SQL to aggregate financial data to model requests for client reports

• Use of JIRA to create user stories for data development tickets from third party clients

• Agile method, develop product pipelines with stakeholders

• Mapping of parent-child tickets to reduce repeated work

• Import datasets into Excel and use various approaches namely VLOOKUP, pivot tables and macros to create ad- hoc reports that illustrated insight into the financial 401(k) fund industry

• Utilize Beacon, an internal data visualization product, to display big data into visualizations for clients Rutgers University, New Brunswick Piscataway, NJ

Full-Stack Developer Jan 16 – Jul 16

Rutgers Coding Bootcamp

• 26 weekly projects completed, 4 monthly large applications developed

• Develop applications from scratch, coding client-side and server-side

• Utilize JavaScript library frameworks, develop MySQL databases from scratch, design tables to store data from the front-end

Construction Specialties, Inc. Lebanon, NJ

Estimator Aug 14 – Jan 16

Interior Fixed Products

• Estimate construction project takeoffs ranging from $20k-1M+

• Relay technical knowledge to outside sales reps

• Maintain communication between general contractors, sales, corporate and manufacturing EDUCATION

Rutgers University New Brunswick, NJ

B.Sc. Environmental and Business Economics Sep 09 - May 13 School of Environmental and Biological Sciences

Rutgers University New Brunswick, NJ

Certified Full-Stack Developer Jan 16 – Jul 16

Continuous Studies Program



Contact this candidate