Andrew Bose Email & Phone Number

Seattle, Wa, Us

Hybrid role of approximately 60% data science / 20% consulting / 20% presentation, involving both internal and external stakeholders. Data Science work utilizes SQL and Python/R programming languages.Common Technical Tasks:- Project scoping, development of analysis methodologies, execution of analyses, management of project timelines, and interpretation of results for clients and partner teams.- Peer-reviewing analyses for code design, analysis methodology, experimental design, and result interpretation.- Training peers and partner teams in coding, statistics, and documentation best practices.- Onboarding and training junior analysts.Impact:- Produced 96 bespoke client analyses and 8 large-scale projects, supporting stakeholders across 12 countries, resulting in an additional client investment of +$84.5MM over 2 years.- Provided support to 11 major US CPG brands, including Kimberly Clark, SC Johnson, and Johnson & Johnson.- Scaled work to produce analytical results specific to each of 169k brands and 39.1k categories globally.Trainings & Moderation:- Conducted trainings for 240 peer analysts on technical best practices, covering proper coding (SQL, Python, and R), documentation, and statistical methods to enhance workflow efficiency.- Onboarded and trained 6 new hires and junior teammates. Recognized by leadership for being an effective educator and mentor.Additional Key Contributions:- Developed the team’s SQL and Python coding style guidelines and best practices.- Introduced sampling methods and innovative SQL query designs to reduce big data querying time from hours to minutes.- Introduced novel approaches to elaborate SQL query design, reducing the team’s SQL code development workload by 20-40%.- Developed an analysis methodology using Natural Language Processing (NLP) techniques to generate actionable insights from a brand’s customer reviews, considering sentiment, topic modeling, and trend identification by customer segment.

London, Gb

Natural Language Processing (NLP) focused role, performing text analysis on social media with custom-defined kpi's for clients' goals. Analysis types include cohort analysis, market segmentation, identifying behavioral trends on social media, quantifying the scale and sentiment/perceptions of global events, insights from survey data, and identifying lifestyles and preferences of a brand's target audience. ** See real example projects in links below **• Spearheaded new department dedicated to supporting operations of internal insights, community, relationships, & strategy teams.• Won "Rookie of the Year" award for contributions towards new business innovation and process improvement & automation.• Improved insights team performance through automated data cleaning & preparation within spreadsheets for internal & client-facing dashboards.• Developed predictive model across 5 features for estimating EMV of influencer partnerships, communicating results to leadership. Modified code for new analysis on influencer fees. • Developed proprietary metrics for brand social advocacy benchmarking against competitors over time. • Conducted extensive social listening audit centered on racial justice issues in the US & presented director-level decks, communicating risk-reward analysis with strategic recommendations for client’s partnership decisions. • Debugged & optimized code from ex-employee, reducing from 1500 to 650 lines of code, to measure impact of client’s campaign on users’ social media activity, and communicated actionable insights to enhance performance. • Showcased agency’s data-driven storytelling capabilities with an annotated timelapse map of Covid cases vs emotions expressed on Twitter with identified microtrends, by sampling 500k tweets daily using Netbase API and applied geospatial clustering to better identify insights. • Evaluated 4 Saas platforms and wrote internal training documentation for fellow analysts.

Boulder, Colorado, Us

Educated students through the NYC sponsored Tech Talent Pipeline - a scholarship-based 18-week program for low-income residents to develop data analytics skills for career advancement.Developed curriculum centered around SQL, python, Excel, statistics, and Tableau, and marketing analytics.• Gave specialty-topic lectures including a 2-week probability & statistics crash course.• Curate real-world data analytics projects and create daily assignments.• Scored and provided constructive feedback to 16 students on assignments & assessments.• Provided in-class assistance and one-on-one coaching for students needing extra assistance or looking to dig deeper into course material.• Wrote daily SQL sprints and walked through solutions in class.• Coordinated with program team and city representatives to review class progress and strategize opportunities for improvement.• Debugged and critiqued others’ SQL & python code.Galvanize is a 21st century school for engineers, entrepreneurs and data scientists. On eight campuses across the U.S., the energy, intellect and ambition of Galvanize students, members, and alumni are at the heart of a learning community that promotes belonging and celebrates courage and growth. Our faculty and flexible blended-learning platform, combining part-time online education and in-person training, provide the most relevant and in-demand technology skills to anyone with the drive and determination to re-skill, up-skill and define success on their terms. Our members include first-time entrepreneurs, growing startups, and Fortune 1000 companies all looking to level-up. https://www.galvanize.com/

Boulder, Colorado, Us

Data Science Immersive Course: ► Programming/development skills: Python, OOP, SQL/NOSQL, Unix commands, jupyter notebook► Analysis: Probability, Statistics, Regression, Pandas, Plotting► Supervised Learning: SVMs, Kernels, kNN, Decision Trees, Random Forests, and Boosting► Unsupervised Learning: KMeans and Hierarchical Clustering, Dimensionality Reduction► Special Topics: NLP, Web Scraping, Time Series, Neural Networks► Big Data: Map Reduce, Spark, SparkSQL, SparkML, Algorithm Complexity Analysis► Data Engineering: Recommender Systems, AWS, Parallelization, FlaskCapstone Project: Built a text-AI model (NLP) from scratch to identify the 10-15 most salient themes within a product's customer reviews, using a custom sentiment analysis model to prioritize themes that have the strongest impact on a customer's purchasing decisions. Created custom performance metrics to evaluable quality and benchmarked performance against real results on Amazon.com.Galvanize is a 21st Century school for entrepreneurs, engineers, and data scientists. On eight campuses across the U.S., the energy, intellect and ambition of Galvanize students, members and alumni are at the heart of a learning community that promotes belonging, and that celebrates courage and growth. Our faculty and flexible blended-learning platform, combining part-time online education and in-person training, provide the most relevant and in-demand technical skills to anyone with the drive and determination to re-skill, up-skill and define success on their terms. Galvanize members include first-time entrepreneurs, growing startups, and Fortune 1000 companies all looking to level-up. Become a member or enroll in an immersive course by visiting the Galvanize website. Follow us: Facebook, Instagram, Twitter and YouTube.

Helping both struggling and high-achieving student's overcome educational barriers and taking their math & science comprehension to the next level.• Tutor high-school through grad-students in Calculus, Statistics, Econ, & Physics.• Assess students' learning style and goals, developing action plans and weekly schedules, and focusing on meeting them where they are now to bring them to where they want to be.• Self-motivated & organized - responsible for client acquisition & retention, referrals, schedules, preparing educational materials, and billing.

• Utilize detailed-oriented skillset while performing field inspections on commercial projects for environmental compliance.• Serve as liaison for ESL, interfacing directly with customers with a friendly and professional demeanor.• Documenting all instances of compliance or violation for each check point.• Prepare findings and inspection forms the same day.

Developed & analyzed complete electrical & physical project design packages from conception to post-construction for multiple clients – Design summary documents, panel layouts, One-Line/Three-Line diagrams, AC & DC relay control schematics & wiring diagrams, arrangement plans & sections, equipment details, grounding plans, cable schedules, bills of material, and construction documentation (as-builts).• Reviewed technical specification documents for all electrical control projects, reviewed contractor design submittals, interpreted and applied various codes and standards for installations, and verified design changes, specifications, and drawing releases.• Utilized strong detail-oriented skillset by performing Quality Assurance reviews of other engineers’ work to ensure all design work meets project requirements and client & industry design standards.• Generated & maintained all necessary project support documentation – project schedule, client & vendor correspondence, vendor specification evaluations, meeting minutes, bid proposal requests and evaluations, cost estimations, engineering calculations, close out forms.• Interfaced with clients with strong communication skills to resolve design related issues, in planning meetings, and during site visits and design-review meetings.• Brought behind-schedule projects back onto/ahead of schedule on a regular basis through effectively managing workload, time, strong initiative, coordinating with fellow engineers and CAD operators, and bringing a willingness to go the extra mile.• Assisted in on the job training for new engineers and CAD operators.

Supervised the financial wing of a 190-member, multi-million-dollar, cooperatively-run social justice nonprofit.• Supervised finance staff; facilitated and organized board & committee meetings (prepared agenda/meeting minutes); and provided insight, research, and risk analysis of the organization’s current and future financial operations.• Spearheaded team-based expansion initiatives - Led a project team for reconstruction feasibility for a $1.3M property. Led a project team for coordinating the $1.2M sale of a residential property and planned purchase and construction of replacement property. Coordinated a team for a co-ownership agreement for converting a charity-owned property, expanding the organization’s service by 10%.• Executed standard accounting and auditing principles, A/P, A/R, payroll, general ledger postings, invoicing, and reconciling accounts; • Presented monthly, quarterly, and annual Profit and Loss statements and Balance Sheets to the board of directors.• Authored & Co-authored policy proposals to restructure & streamline the organization’s operations.

Developed and launched socially and environmentally sustainable programs with the University of Wisconsin.• Launched 2 new programs that collect 10+ tons of donations each year. • Coordinated the collection and distribution of organic food to 200 financially disadvantaged individuals in the downtown Madison area on a biweekly schedule.• Organized meetings/charity events, seminars, volunteer recruiting, business partnerships, website, social media.• Collaborated with Goodwill, the Society of St. Vincent de Paul, and Rethink WI, other non-profits, and apartment landlords to successfully execute programs.• Generated project proposals, schedules, budgets, marketing materials.• Entirely self-managed scheduling and tasks to meet deadlines on time.• Recruited and trained volunteers for special events and project implementation.

Authored business proposal and financial feasibility analysis of Ethiopian Social-Sustainability startup Echelon Medical Device Manufacturing, Ethiopia's 1st medical device manufacturer, which produces neonatal Bag Valve Mask (BVM) resuscitation devices that are cost-effective for 3rd world medical facilities. Analysis included resourcing of raw materials, cost and growth projections for multiple scenarios, Gannt chart style proposed timeline, business valuation estimates, risk assessment, and strategic recommendations for founders.Business proposal successfully won $120,000+ in grant funding. ** Additionally, co-authored business plan and financial analysis for a Madison, WI based health-food company’s Buy One, Feed One (B1F1) charity program to provide basic needs to malnourished children in Guatemala.

Chicago, Us

• Programmed and documented LabView application for remotely controlling HALT (Highly/Heat Accelerated Life Testing) chambers for medical device parts longevity testing. o Designed and executed software test plans /Prepared end-user documentation.• Built test rigs and conducted validation tests for anaesthesia machine drop-in replacement oxygen sensors from a new ROS-compliant vendor.• Worked independently to create, maintain and execute automation and manual test plans.• Regularly reported to engineering team on progress and projected completion dates.

• Developing valuable customer service and technical skills through assisting UW students and faculty with their computer and technical issues.• Enhancing clear speaking and troubleshooting abilities by handling customers’ computer and software problems over the phone.

Mountain View, California, Us

Direct marketing sales contractor-Generated over $10,000 in sales during 3-month summer job during college.-Responsible for all stages of sales: cold calling, acquiring leads, maintaining customer relations, demos, taking orders, placing orders with suppliers, deliveries/fulfillment, handling returns/failed payments, accounting, and bookkeeping.-Worked completely independently, setting my own schedule and weekly sales goals.

Bachelor Of Science, Computer & Electrical Engineering / Minor In Business Entrepreneurship

Data Science, Data Science

The Data Science Course 2019: Complete Data Science Bootcamp

Machine Learning For Marketing Analytics (Columbiax Edx Bamm 104)