Data Analyst Senior

GIL MORAN

Jersey City, New Jersey

908-***-**** ********@*********.*** www.linkedin.com/in/gilmoran1 EDUCATION

Columbia University, New York, NY

M.S Management Science and Engineering Dec 2021

Coursework: Business Analytics, Sports Analytics, Operations Strategy, Optimization Models. Muhlenberg College, Allentown, PA

B.S in Physical Science May 2020

Minors in Business Administration & Mathematics. Dean's List: Cum Laude WORK EXPERIENCE

CheckedUp, New York, NY

Senior Data Analyst Apr. 2024 - Present

• Developed and optimized SQL queries in Snowflake to provide the sales sponsorship team with real-time data on available locations for TV and wallboard placements, improving decision-making speed.

• Designed and maintained Tableau dashboards for the leadership team, delivering data insights that support strategic planning and performance tracking.

• Owned SQL query development to match internal network data with global doctor networks, facilitating targeted outreach and enhanced network visibility.

• Collaborated with marketing to create data-driven presentations, enhancing the clarity and impact of network information for key stakeholders.

Blue Skies Consulting (Johnson & Johnson ERP Implementation Project), Raritan, NJ Principal Consultant (Data Project Management Analyst) Jan. 2022 -Apr. 2024

• Created and managed over 20 global JIRA/Power BI dashboards to track teamwide deliverables, metrics and KPI’s.

• Built over 40 JIRA structures using JQL queries and EXPR expressions to organize company data and tasks for team.

• Composed and executed data team training (JIRA Navigation, SharePoint navigation, Onboarding) for global team members.

• Managed E2E testing for BST (Business Simulation team) and UAT (User Acceptance Testing) for KSA (Saudi Arabia) and US team members.

Localposh (Startup Specialized in E-commerce for Local Businesses), New York, NY Growth and Revenue Engineer Jan. 2021 – Dec. 2021

• Conducted 15 competitive analyses to compare and optimize delivery rates to increase revenue.

• Implemented an Objectives and Key Results (OKR) board with different KPI's to ensure the company’s continued growth and begin expansion into 5 new cities in 2021.

• Negotiated with 4 different background check companies to guarantee the best possible rates. Johnson & Johnson (J&J) Consumer Health, Skillman, NJ Logistics and Procurement Intern May 2020 – Nov. 2020

• Analyzed Intermodal and Truckload cost differences on 46 transportation lanes and displayed $2.4M in cost avoidances and $300k in potential savings in Power BI Earning a Six Sigma Yellow-Belt Certification.

• Ensured data integrity of spot market and out of service shipments utilizing an Alteryx workflow. 365Scores (Cross Platform Sports App), Tel Aviv, Israel Marketing Intern Jun. 2017 – Aug. 2017

• Inputted a wide range of entity data into 365Scores application database.

• Led and developed NBA and NFL marketing strategies to improve visibility for American markets.

• Organized and distributed 20-30 news stories per day to application users in relevant markets. TECHNICAL SKILLS

• Software: Java, R-Studio, LaTeX, Maple, Microsoft Office Suite, Adobe Photoshop, Microsoft Power BI, Alteryx, Python, Tableau, SQL, JIRA, EXPR, JQL, Snowflake.

• Language: Fluent in English and Hebrew.

Contact this candidate